Creating AutoList of SuperMods

Ahh thanks for the tip, I completely forgot about that....

Great AddOn!!! Thx a lot.

I am working on this to fit it my needs and got some ideas, but want to ask anyway, howto list the forums the moderators a moderators of? Any help for this one?

Thanks

I tried this, just to bring the forumids up, but it adds the forumids from the frist to the second mod, and so on....didn't work....anyhelp??

This is what I put into the while () {}

PHP Code:

$moderators = $DB_site->query("
    SELECT * FROM moderator WHERE userid=$user[userid]");    
    while ($moderator = $DB_site->fetch_array($moderators))
        {
        eval("\$supermodsforums .= \"".gettemplate("supermodsforums")."\";");
        } 


The template only contains:

PHP Code:

$moderator[forumid]<br> 


The problem with this is "Super Moderators" are not normally assigned to a forum but have free-reign over the entire forum setting.

As I said, I change a lot to fit it my needs. I got this for the getsmods.php and some more templates: It show Admingroup and Moderatorgroup. Now I want to check if the userid is in the moderator table and get the forumids from it to show the forum name.

PHP Code:

<?php

$super_moderators_group_id = 35;
$admin_group_id = 6;

$templatesused="supermods,supermodsbits,$supermodspm,supermodsicq,supermodsaim,supermodsemail,supermodshp,postbit_offline,postbit_online";
require('./global.php4');

$users = $DB_site->query("
        SELECT DISTINCT
        session.userid AS sessionuserid,
        user.*, userfield.* FROM user
        LEFT JOIN userfield ON (userfield.userid = user.userid)
        LEFT JOIN session   ON (session.userid = user.userid
                                            AND session.userid <> 0
                                            AND user.invisible = 0
                                            AND session.lastactivity>0)
        WHERE  ( user.usergroupid=$super_moderators_group_id ) or ( user.usergroupid=$admin_group_id )
        ORDER BY user.usergroupid,user.username");

    
while ($user = $DB_site->fetch_array($users))
    {
    if (($count++ % 2) == 0) $backcolor = "{secondaltcolor}";
    else $backcolor = "{firstaltcolor}";
        
    if ($user[field2] == "") $user[location] = "&nbsp;";
    else $user[location] = $user[field2];
    
        if ($showonline) {
               unset($onlinestatus);
               if ($user[sessionuserid]>0) {
                  eval("\$onlinestatus = \"".gettemplate("postbit_online")."\";");
               } else {
                  eval("\$onlinestatus = \"".gettemplate("postbit_offline")."\";");
               }
            }
        
    if ($user[receivepm] == 0) $sendpmlink = "&nbsp;";
    else eval("\$sendpmlink = \"".gettemplate("supermodspm")."\";");

    if ($user[icq] == "") $sendicqlink = "&nbsp;";
    else eval("\$sendicqlink = \"".gettemplate("supermodsicq")."\";");
    
    if ($user[aim] == "") $sendaimlink = "&nbsp;";
    else eval("\$sendaimlink = \"".gettemplate("supermodsaim")."\";");
    
    if ($user[homepage] == "") $sendhplink = "&nbsp;";
    else eval("\$sendhplink = \"".gettemplate("supermodshp")."\";");
    
    eval("\$supermodsbits .= \"".gettemplate("supermodsbits")."\";");
    
    
    
    
        
    }

makeforumjump();
    
eval("dooutput(\"".gettemplate("supermods")."\");");

?>

Anyone who can help or working on it? I need it.....hm.....going to sleep and see whats going to be in a few hours (sometimes I wish I live in a US time zone......)

How can I change this to just list moderators?
Instead of supermods?

Originally posted by Sarge
How can I change this to just list moderators?
Instead of supermods?

I don't know -- this goes by usergroup ids and all of my moderators are super moderators.

Theres a groupid part, you just change the number.

what is the group id for mods?