Quick query needed, apprecated

[NarutoFTW]

Can anyone write a query that unbans every member that was banned by a particular moderator?

so like the moderator's user id and unban everyone banned by that person.

Thank you

--------------- Added 1361219532 at 1361219532 ---------------

bump? help please

[NarutoFTW]

bump

[Lynne]

You would need to provide more details like what usergroup have the users been banned to? What usergroup do you wish them to be put in when unbanned?

[NarutoFTW]

Registered user. regular user

[Lynne]

There is no "regular user" group. We need some usergroupids for this.

[Amaury]

There is no "regular user" group. We need some usergroupids for this.

Registered Users would be two. :)

[borbole]

Registered Users would be two. :)

What about if the user has changed it and uses a custom group for Registered Users?

[kh99]

Try this:
UPDATE userban SET liftdate = 1 WHERE adminid = X


where X is the userid of the mod you mentioned (it's called adminid but it's also for mods). Then run the "Restore Temporarily Banned Users" schedule task (or wait for it to run).