Hi - first off, fantastic product - thank you so much for this!
I'm trying to programmatically pull comments out of the WordPress SQL database.
This works well when I relate wp_posts table and wp_comments tables.
However, I'm struggling to link inline comments to content within the wp_comments table.
There doesn't seem to be a way to identify which comments relate to which inline unique_id within the wp_wc_feedback_forms table.
I assume I should be looking somewhere else? Any help would be appreciated!
Many thanks,
R
Hi,
The wpdiscuz_feedback_form_id meta key in the wp_commentmeta table can be used to retrieve the IDs of the inline comment feedback forms.
SELECT * FROM `wp_comments` c JOIN `wp_commentmeta` m ON c.`comment_ID` = m.`comment_id` AND m.`meta_key` = 'wpdiscuz_feedback_form_id' JOIN `wp_wc_feedback_forms` ff ON ff.`id` = m.`meta_value` WHERE c.`comment_post_ID` = 1 AND ff.`unique_id` = '0sdbxr5cfy'
The SQL above gets the inline comments with unique_id = 0sdbxr5cfy for the post ID = 1.
The wp_ is just a prefix, in your case, it may differ.
