• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.5 i want remove all users but before ..

jamalfree

Active member
#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
 

jamalfree

Active member
#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
 

Tracy Perry

Well-known member
#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.