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)

$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:
$moderators=$DB_site->query("SELECT DISTINCT user.userid FROM usergoup,user WHERE user.usergroupid=usergroup.usergroupid AND (usergroup.ismoderator=1 OR usergroup.cancontrolpanel=1)");