Quote:
Originally Posted by evesve
Is there a code so I can get the visitor in order:
Administrators(6), Moderators(7), Special members(9) and than the others?
|
I?ll try again....
I change the code in the plugin to:
Code:
FROM " . TABLE_PREFIX . "user as user
LEFT JOIN " . TABLE_PREFIX . "usergroup as groupa ON(user.usergroupid = groupa.usergroupid)
LEFT JOIN " . TABLE_PREFIX . "usergroup as groupb ON(user.displaygroupid = groupb.usergroupid)
WHERE lastactivity > " .$cutoff. " ORDER BY usergroupid, username
");
now I see the users order by usergroups.
There must be an easy way to set the usergroups in order
6,7,9,2,1
??????????????