AI Search

Classic Search

Search Phrase:

Search Type:

Advanced search options

Search in Forums:

Search in date period:

Sort Search Results by:

Filter by custom fields

Topic prefix

AI Assistant

Notifications

Clear all

(SQL) Relating wp_wc_feedback_forms items to wp_comments

✦ Summarize Topic

Inline Commenting

Last Post by Asti 1 year ago

3 Posts

2 Users

0 Reactions

1,079 Views

RSS

rocky

(@rocky)

Posts: 1

New Member

Topic starter

Translate ▼

[#9328]

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,

Posted : 24/11/2024 3:39 am

Topic Tags

Asti

(@asti)

Posts: 8257

Illustrious Member Support

Translate ▼

Hi,

I'll ask the developers and get back to you soon.

In case you want to say thank you! 🙂
We'd really appreciate if you leave a good review on the plugin page.
This is the best way to say thank you to this project and the support team.

Posted : 25/11/2024 12:38 pm

Asti

(@asti)

Posts: 8257

Illustrious Member Support

Translate ▼

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.

In case you want to say thank you! 🙂
We'd really appreciate if you leave a good review on the plugin page.
This is the best way to say thank you to this project and the support team.

Posted : 25/11/2024 1:24 pm