[شــرح] كيفية استعادة المنشورات/المواضيع/الرسائل من مستخدم محذوف في XenForo

UPDATE xf_post SET username = 'NewUsername', user_id = NEW_USER_ID WHERE username = 'OldUsername'; UPDATE xf_thread SET username = 'NewUsername', user_id = NEW_USER_ID WHERE username = 'OldUsername'; UPDATE xf_profile_post SET username = 'NewUsername', user_id = NEW_USER_ID WHERE username = 'OldUsername'; UPDATE xf_profile_post_comment SET username = 'NewUsername', user_id = NEW_USER_ID WHERE username = 'OldUsername';

UPDATE xf_conversation_message SET username = 'NewUsername', user_id = NEW_USER_ID WHERE username = 'OldUsername'; UPDATE xf_conversation_master SET username = 'NewUsername', user_id = NEW_USER_ID WHERE username = 'OldUsername'; UPDATE xf_conversation_recipient SET user_id = NEW_USER_ID WHERE user_id = (SELECT user_id FROM xf_user WHERE username = 'OldUsername');