jamalfree Active member Jan 30, 2017 #1 hi i want remove all users except userid =1 but before that opretion i need 1. to reset all likes and trophies for all members by sql 2. move all post and threads to userid=1 this for new strating
hi i want remove all users except userid =1 but before that opretion i need 1. to reset all likes and trophies for all members by sql 2. move all post and threads to userid=1 this for new strating
jamalfree Active member Jan 30, 2017 #2 for q 2 PHP: update `xf_thread` set `username` = 'jack' AND `user_id` = 1 AND last_post_user_id = 1 AND last_post_username ='jack' AND `first_post_likes` = 0; update `xf_post` set user_id = 1 AND username = 'jack' AND likes = 0; its true or false Upvote 0 Downvote
for q 2 PHP: update `xf_thread` set `username` = 'jack' AND `user_id` = 1 AND last_post_user_id = 1 AND last_post_username ='jack' AND `first_post_likes` = 0; update `xf_post` set user_id = 1 AND username = 'jack' AND likes = 0; its true or false
TPerry Well-known member Jan 30, 2017 #3 Got a sneaking suspicion you may be playing wth fire when you attempt to do this as there are MANY other tables that would have to be updated. Upvote 0 Downvote
Got a sneaking suspicion you may be playing wth fire when you attempt to do this as there are MANY other tables that would have to be updated.
