I set up a new group promotion to promote anyone with 10 posts or more to a new group to help combat spam. I forced it to run 3X and it has yet to move any forum users, even though most people on the forum that are in that group have more than 10 posts. it ran 2 more times on its own, as the promotion task is set up to run every 20 minutes, and it's only moved 2 users. why is it running like that when it should be moving a lot more, especially if I force it to run?
I hope it doesn't need to wait for each user to log in before it moves them because I'm trying to really lock down the registered user group and disable the user cp so spammers can't do much. if it does, is there a query I can run where it moves everyone with, or more than 10 posts, to the new group?
try below SQL query ; X is the required new group
UPDATE mybb_users SET usergroup = 'X' WHERE postnum > '10';
(2012-01-11, 06:22 AM)ranjani Wrote: [ -> ]try below SQL query ; X is the required new group
UPDATE `mybb_users` SET `usergroup` = 'X' WHERE `postnum` > '10';
that moved all users..crap.
I only wanted to move users from the registered group to the new group if they had 10 or more posts. is it possible to revert back the last change?
(2012-01-11, 06:34 AM)Shemo Wrote: [ -> ]is it possible to revert back the last change?
No, you should have taken a db backup before running queries you're not sure about.
If you want to try again, try this query after restoring if possible:
UPDATE `mybb_users` SET `usergroup` = 'X' WHERE `usergroup` = 'Y' AND `postnum` > '10'
So for above query, X would be the new usergroup, Y would be the usergroup of the users you wish to move.
(2012-01-11, 06:41 AM)crazy4cs Wrote: [ -> ] (2012-01-11, 06:34 AM)Shemo Wrote: [ -> ]is it possible to revert back the last change?
No, you should have taken a db backup before running queries you're not sure about.
If you want to try again, try this query after restoring if possible:
UPDATE `mybb_users` SET `usergroup` = 'X' WHERE `usergroup` = 'Y' AND `postnum` > '10'
So for above query, X would be the new usergroup, Y would be the usergroup of the users you wish to move.
thanks. it looks like it moved everyone with more than 10 posts on the first go around. I had to manually move some users back to their super mod and admin groups (stupid me should of ran a backup!) and move a few with exactly 10 posts from the one group to the new group.
:oops: it was really a crap
AND an expert recently warned about such bad suggestions !!
(2012-01-11, 07:20 AM)ranjani Wrote: [ -> ]:oops: it was really a crap AND an expert recently warned about such bad suggestions !!
no big deal..it was my fault for not running a backup first. I appreciate all the help you give to me anyhow!
