PDA

View Full Version : Reset forum users & posts

Psyd0x
12-26-2014, 06:42 AM
How can i reset the forum users and all the posts without losing the other things
i want to reset only this

thanks for help
ForceHSS
12-26-2014, 07:01 AM
Reset? Do you mean delete all posts
Psyd0x
12-26-2014, 07:52 AM
yes delete all posts and delete all users
ForceHSS
12-26-2014, 09:04 AM
Do you have a lot of users and posts? Either way, best way you can do it is for users admincp/Users/Prune/Move Users for posts use the moderation tools for each section
HM666
12-26-2014, 09:40 AM
Yeah that was gonna be my suggestion too, its the fastest way.
helenblog
12-27-2014, 09:29 AM
How can i reset the forum users and all the posts without losing the other things
i want to reset only this

thanks for help

I think you should keep the users, just delete posts by go to the forums and tick all and delete.
It's more benefit if you keep your members.
ozzy47
12-27-2014, 09:43 AM
Well that would be fine, but it sounds like the OP wants a fresh start, no users or posts, but wants to keep everything else in place.
Psyd0x
12-27-2014, 03:14 PM
i want just to wipe everything the forum was before 2years and now i just resotre it so i dont need the posts and users anymore i want to start from 0
Lynne
12-27-2014, 03:43 PM
You could go to admincp > Threads & Posts > Prune and you can also go to admincp > Users > Prune.

Please be aware that if you are on shared hosting, you probably cannot prune more that 1000 items at a time.
Psyd0x
12-27-2014, 03:45 PM
i did it but now when a new user register he start from number 240 and not from 2
i want to wipe the user number count too
HM666
12-27-2014, 05:19 PM
Why didn't you just install a new forum and take the old one down?
Lynne
12-28-2014, 01:02 AM
i did it but now when a new user register he start from number 240 and not from 2
i want to wipe the user number count too
That requires editing the database directory via a tool like phpMyAdmin and setting the AUTO_INCREMENT for the user table.

ALWAYS DO A BACKUP PRIOR TO DOING ANYTHING TO YOUR DATABASE!!!
ForceHSS
12-28-2014, 06:46 AM
ALTER TABLE `user`AUTO_INCREMENT=2;
Run this query in your admincp
Lynne
12-28-2014, 03:29 PM
He doesn't want to set it to 1 if he is keeping the admin, userid 1, account. He would want to set it to 2.