Limited Support
Our team is currently on holiday, so support will be limited during this period. Response times may be slower than usual, and some inquiries may be delayed.
We appreciate your patience and understanding, and we’ll resume our usual support by the end of August.
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.
