Greetings,
I want to move the users who have been registered for 7 days to a new group.
Can anyone please guide me the right SQL command for that?
Promotions system is built into Mybb 1.4x series. Look in admincp under users for "Group Promotions".
Yes bro I enabled that but so far it has moved only a few users. I think I have to move them using SQL command.
I found this code from promotions.php
if(in_array('timeregistered', $requirements) && intval($promotion['registered']) > 0 && !empty($promotion['registeredtype']))
{
switch($promotion['registeredtype'])
{
case "hours":
$regdate = $promotion['registered']*60*60;
break;
case "days":
$regdate = $promotion['registered']*60*60*24;
break;
case "weeks":
$regdate = $promotion['registered']*60*60*24*7;
case "months":
$regdate = $promotion['registered']*60*60*24*30;
break;
case "years":
$regdate = $promotion['registered']*60*60*24*365;
break;
default:
$regdate = $promotion['registered']*60*60*24;
}
$sql_where .= "{$and}regdate <= '".(TIME_NOW-$regdate)."'";
$and = " AND ";
}
Please guide me, what to put in place of
postnum
UPDATE `mybb_users` SET `usergroup` = 'new_usergroup_id' WHERE `postnum` > '5' AND `usergroup` = 'old_sergroup_id'
TY.
Edit: Matt bro the other thread was a different question. Its was about moving all users from one group to another. This one about moving users who have been registered for at least 7 days.
Anyways problem got solved
