[HELP] Mod banned a member

[killerford]

A new guy on our forums as a mod on our forums and all of this guys threads he's soft deleted them and now the member is showing as Guest. The mod on our forums don't know what he pressed and now one of our main guy on our forums is showing as a guest and all his threads and posts and on soft delete.. How can i get it all back? Redo everything

[Lynne]

If a user is showing as Guest, then that means the user was deleted. The only way to get him back is by using a database backup from before this was done.

[killerford]

I've registered him back onto the forum. Is there a way of getting his stuff back from my backup files without doing anything? and just adding them to my server files?

[Lynne]

I do not have a query handy to do that, but I know I have seen it posted before (at least for the post and thread table). If I recall, the userid for the post/threadstarter will be 0, but the username will still have the users username there. So, your query needs to set the userid in the post and thread table (possibly attachment/filedata table also, which could get messy) to be the new userid WHERE username=username. So, try a search to find it.

[peugeot405]

If the posts are still existing you might be able to use one of following mods to change them to that user again.

Change Author And Creation Date Of Posts And Articles (www.vbulletin.org/forum/showthread.php?t=241481)

Change Threads/Posts Owner/Date for vB4 (https://vborg.vbsupport.ru/showthread.php?t=245183)

[killerford]

Thanks for the links, Will try that out.

[kerrghann]

A few suggestions I can give are these:

1. Backup your database fairly frequently.
2. Make sure the mods you put in power know what they're doing and have good judgement.
3. Make a simple guide to help your mods find their way around the modcp so things like this don't happen as often.

[Lynne]

Also, check the permissions you have given your mods in Admincp > Forums & Moderators > Show All Moderators > Edit Permissions

[killerford]

Thanks for the replies guys, helps a lot. Will take a look at these.

[M.C.]

My way of doing that:

Go to your phpMyAdmin
Open your DB and go to "post" table
Find any post your user did (you can do it by "postid" or any other creteria)
There are "Username" and "userid" columns - you need to remember them.
Then go to "user" table, find your new created user (usualy at the very end of table)
Click "Edit" and change his new "Username" and "userid" with old one from "post" table
Save

Now you can go in your Admincp and find all soft deleted posts by username and recover them ;)

No need to roll back your database.