Quick question - SQL Query to return banned usergroups

[Otaconda]

Hi guys.

I'm struggling to find out how I evaluate, presumably 'genericoptions' in the usergroup table, to determine if a usergroup is banned or not. Dont suppose any of you guys could point me in the right direction?

Thanks.

[Otaconda]

Bumpski

[ericgtr]

Can I ask why you want to use a query for this? This can easily be done with a simple template conditional.

[Otaconda]

I want to move users to a particular user group based on inactivity. Easy enough to do with a query, but obviously this shouldnt apply to banned users. If I can determine in a query which usergroups are banned, then I can get a result set which doesn't contain members of these groups.

[Adrian Schneider]

To get banned groups, use this (remove NOT but leave in brackets for opposite result)...

PHP Code:

$bit = $vbulletin->bf_ugp['genericoptions']['isnotbannedgroup'];
$db->query_read("
    ...
    WHERE NOT($bit & usergroup.genericoptions)
");