[Ryloth]

i read threw a few pages, anyone realize this shows past moderators who are no longer mods due to joinng for the users on the moderator table.


the poor man's way to do this is to change this:

        SELECT user.*
        FROM " . TABLE_PREFIX . "user AS user
        LEFT JOIN ".TABLE_PREFIX."moderator AS moderator USING (userid)
        WHERE moderator.userid = user.userid $additional_usergroups
        ORDER BY user.username

to

        SELECT user.*
        FROM " . TABLE_PREFIX . "user AS user
        LEFT JOIN ".TABLE_PREFIX."moderator AS moderator USING (userid)
        WHERE moderator.userid = '' $additional_usergroups
        ORDER BY user.username

Then change around a few lines of text for the options so that you now MUST SPECIFY which groups you want to show.




I realize this is a poor way to do it, however, it is a very simple way that 99% of people can understand. the right way would be to re-write the query not joining on the moderator table. i think the intentions were right w/ joining, however, right join by the way your query is setup would be the join you were after and even then the query is not right. i am out of time for looking at this.