Showgroups - Quite Simple

[Automated]

Hi Guys,

I have a question and it has been buggin me for weeks :(

On my forums my Showgroups.php (http://www.freelanceforums.com/forums/showgroups.php) page shows the admins, super mods and mods but in the Mods section it shows the admins and super mods (i call them advisors;))

Is there a way to JUST show the Moderators in usergroup 7 in that space?

Thanks
Matthew

[Xenon]

it is, because showgroups.php reads out from the moderator-table and also admins can be entered in.

to change that, open showgroups and find:
// get moderators ************************************************** ********
$users = $DB_site->query("
SELECT
$locationfieldselect forum.forumid, forum.title AS forumtitle,
user.username, user.userid, user.invisible, user.receivepm, user.lastactivity, user.lastvisit
FROM moderator
LEFT JOIN user ON (user.userid = moderator.userid)
LEFT JOIN forum ON (forum.forumid = moderator.forumid)
LEFT JOIN userfield ON (userfield.userid = user.userid)
WHERE forum.active = 1
ORDER BY user.username ASC, forum.displayorder ASC
");

and change it to// get moderators ************************************************** ********
$users = $DB_site->query("
SELECT
$locationfieldselect forum.forumid, forum.title AS forumtitle,
user.username, user.userid, user.invisible, user.receivepm, user.lastactivity, user.lastvisit
FROM moderator
LEFT JOIN user ON (user.userid = moderator.userid)
LEFT JOIN forum ON (forum.forumid = moderator.forumid)
LEFT JOIN userfield ON (userfield.userid = user.userid)
WHERE forum.active = 1 AND user.usergroupid = 7
ORDER BY user.username ASC, forum.displayorder ASC
");

[Automated]

Thanks a lot man, it works great :p

Matthew

[Xenon]

you're welcome :)