Query needed to select global mods/admins

[Darth Cow]

I'm modifying report.php so I can report PMs as well . How would I change this to select all super moderators/admins instead? (usergroups 5 and 6)

PHP Code:

  $moderators=$DB_site->query("SELECT DISTINCT user.userid FROM moderator,user WHERE user.userid=moderator.userid AND moderator.forumid IN ($foruminfo[parentlist])"); 


Thanks! My SQL skills are kinda lacking...

[Xenon]

hmm, not sure, but try this:

PHP Code:

$moderators=$DB_site->query("SELECT DISTINCT user.userid FROM usergoup,user WHERE user.usergroupid=usergroup.usergroupid AND (usergroup.ismoderator=1 OR usergroup.cancontrolpanel=1)");