Thanks Jake. Is there any way to delete likes between certain posters. Eg delete only the likes poster A gave to poster X but not to poster Y or poster Z
Thanks Jake. Is there any way to delete likes between certain posters. Eg delete only the likes poster A gave to poster X but not to poster Y or poster Z
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 30' at line 5
Yes I am and removing the semi-colon worked, thanks. But it doesn't show me the posts which were liked. All I get is a content id. How do I convert this into the liked post. I want to see what was liked.
SELECT liked.*, post.*, thread.*
FROM xf_liked_content AS liked
INNER JOIN xf_post AS post ON
(liked.content_id = post.post_id)
INNER JOIN xf_thread AS thread ON
(post.thread_id = thread.thread_id)
WHERE content_type = 'post'
AND like_user_id = 2
AND content_user_id = 3
That will show you the entire details of the like, the entire details of the post that was liked and the entire details of the thread that post was in.
SELECT post.post_id, post.thread_id, post.message, thread.title
FROM xf_post AS post
INNER JOIN xf_thread AS thread ON
(thread.thread_id = post.thread_id)
WHERE post.message LIKE '%resource%'
Will display any post where the post content contains the word "resource". Will display the post_id, thread_id, message and the thread title.