Showgroups - Quite Simple

[Automated]

Hi Guys,

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

On my forums my 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:

PHP Code:

// 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

PHP Code:

// 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

Matthew

[Xenon]

you're welcome