Mass remove all moderators from forums

[AnhTuanCool]

Hi all,

My forum is having a personnel problem right now, I don't want to talk in deep about it, just want to ask HOW can I remove all the current moderators off their current moderated forums without changing their usergroup permissions? I've thought about a query that can do it so anyone please guide me then if there is. Thanks in advanced

PS: plz note that my forum has around 200 forums with 333 moderators so I don't think I can do it manually :ninja:.

[Xenon]

[SQL]DELETE FROM moderator[/sql] should do it.

that' won't affect usergroups, so your supermods will still stay supermods

[AnhTuanCool]

It worked, all moderators're detached from all the forums, thank you Xenon.

[Xenon]

you're welcome