XenForo Forumdaki Tüm Beğenileri sıfırlama SQL Sorgusu

DELETE FROM xf_liked_content;

UPDATE xf_user AS u
SET like_count = (
   SELECT COUNT(*)
   FROM xf_liked_content AS lc
   WHERE lc.content_user_id = u.user_id
   GROUP BY lc.content_user_id
);

UPDATE xf_post SET likes = 0, like_users = 0x613a303a7b7d;