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 [DATE]1361219532[/DATE] at [TIME]1361219532[/TIME] ---------------

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]

Originally Posted by Lynne

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

Registered Users would be two.

[borbole]

Originally Posted by Amaury25

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).