Creating AutoList of SuperMods

[Me2Be]

Can someone help me with this? I'd really like to be able to have a link where someone would click and it would list all of those in the supermoderator admin group with the following info in a table:

Username Location PM (link to send pm)

How can this be done?

Give me a little while to finish the documentation for the new version of my vBcode buttons and I'll write this for you in a jiffy

Originally posted by Kier
Give me a little while to finish the documentation for the new version of my vBcode buttons and I'll write this for you in a jiffy

Thanks

I hope this is what you wanted...



If you link to the attached PHP file, the page will display a list of all your super-moderators, together with a link to their profile and PM, and a display of their location.

I included the forum-jump just because...

To install, just copy the getsmods.php file to your forums directory, and create three custom templates using the .htm files in the attached zip.

Thank you! Works perfectly

Kier strikes again

Another great hack! Thanks

I also added the user's online status to this as well... for those interested:

edit file getsmods.php

Change the main query to read:

$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 )
        ORDER BY user.username");

Find:

        if ($user[field2] == "") $user[location] = " ";
        else $user[location] = $user[field2];

And add AFTER:

        if ($showonline) {
               unset($onlinestatus);
               if ($user[sessionuserid]>0) {
                  eval("\$onlinestatus = \"".gettemplate("postbit_online")."\";");
               } else {
                  eval("\$onlinestatus = \"".gettemplate("postbit_offline")."\";");
               }
            }

Template Change supermodsbit
Add

$onlinestatus

Thanks Kier & Chris - this is just perfect!!!

Yep.. Works great.

don't forget to add postbit_offline and postbit_online to the list of $templatesused, or the page will use an extra two queries...