How to make moderators appear in alphabetical order on the moderator list?

[james shadle]

This is the message I received:

                 SELECT moderator.*, user.username,
                                  IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid
                                  FROM moderator AS moderator
                                  INNER JOIN user AS user USING(userid)
                                    WHERE moderator.userid = 444ORDER BY moderator.userid;
   
  MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BY moderator.userid' at line 5

includes/functions_forumlist.php

This was the original code:

IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid
        FROM " . TABLE_PREFIX . "moderator AS moderator
        INNER JOIN " . TABLE_PREFIX . "user AS user USING(userid)
        " . ($userid != null ? "WHERE moderator.userid = " . intval($userid) : "") . "
    ");
    while ($moderator = $vbulletin->db->fetch_array($forummoderators))
    {
        fetch_musername($moderator);
        $imodcache["$moderator[forumid]"]["$moderator[userid]"] = $moderator;
        $mod["$moderator[userid]"] = 1;
    }

I cut and pasted your code:

IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid
        FROM " . TABLE_PREFIX . "moderator AS moderator
        INNER JOIN " . TABLE_PREFIX . "user AS user USING(userid)
              " . ($userid != null ? "WHERE moderator.userid = " . intval($userid) : "") . "ORDER BY user.username ASC
    "); 
    while ($moderator = $vbulletin->db->fetch_array($forummoderators))
    {
        fetch_musername($moderator);
        $imodcache["$moderator[forumid]"]["$moderator[userid]"] = $moderator;
        $mod["$moderator[userid]"] = 1;
    }

Thanks