2014-06-09, 02:30 AM
Well I want to execute a query via phpmyadmin that takes users in a certain usergroup which havent been online in __ amount of days and moves them to another usergroup/default usergroup.
can someone help?
can someone help?
2014-06-09, 02:30 AM
2014-06-09, 03:43 AM
UPDATE mybb_users SET usergroup='newgroup' WHERE usergroup = 'oldgroup' AND lastvisit < unixTimestampOfTheCutoffSo for example
UPDATE mybb_users SET usergroup='9' WHERE usergroup = '8' AND lastvisit < 1392285284Will move all people in usergroup 8 who haven't visited since Thu, 13 Feb 2014 09:54:44 GMT to usergroup 9.
Find the timestamp you want here: http://www.epochconverter.com/