MyBB Community Forums

I recently made some big changes in our forums.. and now I'd like to unban most of the people.. but I have like 600+ bans

I'd like to unban everyone who has more then 5 posts.. since people who get a ban before they get 5 posts, shouldn't get another chance anyway..


so could you help me figure out a sql query for that?

unban everyone who has more then 5 posts..

and add them to default, registred group.

"DELETE FROM mybb_banned ..."

thx:p

(2013-05-18, 01:11 PM)Nebulos Wrote: [ -> ]I recently made some big changes in our forums.. and now I'd like to unban most of the people.. but I have like 600+ bans

I'd like to unban everyone who has more then 5 posts.. since people who get a ban before they get 5 posts, shouldn't get another chance anyway..


so could you help me figure out a sql query for that?

unban everyone who has more then 5 posts..

and add them to default, registred group.

"DELETE FROM mybb_banned ..."

thx:p

UPDATE `mybb_users` SET `usergroup` = '2' WHERE `usergroup` = '7' AND `postnum` > '5'

I'm afraid that this didn't unban them..

it works for now.. kinda..

but as you know, if you remove someone from banned group like that.. by changing groups, it won't lift the ban.

you must remove the ban using the "lift ban" command..

i hope mybb will make a better ban system soon.