List Moderators

[Triality]

Hello,

If you go to http://www.crystalisforums.com and switch to the red theme you will notice on the right side I have a spot to put all the team. I want to list the moderators and super mods there (with links to there profile), but I dont want to have to hardcode them all in. Does anyone know how I can do this without coding it all?

Thanks

[Andreas]

Moderators
[SQL]SELECT moderator.userid, user.username FROM moderator LEFT JOIN user ON (moderator.userid=user.userid) GROUP BY moderator.userid[/SQL]

Super-Moderators
[SQL]SELECT user.username, user.userid
FROM user, usergroup
WHERE (user.usergroupid = usergroup.usergroupid OR usergroup.usergroupid
IN (user.membergroupids)) AND (usergroup.adminpermissions & 1) AND !(usergroup.adminpermissions & 2)[/SQL]

Admins
[SQL]SELECT user.username, user.userid
FROM user, usergroup
WHERE (user.usergroupid = usergroup.usergroupid OR usergroup.usergroupid
IN (user.membergroupids)) AND (usergroup.adminpermissions & 2)[/SQL]

[Triality]

ok, and once this is done how do i get them to show up on the site?

[Andreas]

Process the results of the queries

But there might be better ways to do this anyway (-> $imodcache)

[Triality]

hmm i dont really understand. any easier way to do this?

[Triality]

ok so if i did run those queries on the database could someone explain how to use them to show up on my page