Selective Moderator Hiding

[coRtALoS]

Looking for a hack that allows me to selectively hide moderators on the forum index. I realize you can hide users from the Forum Leaders page, however I can't find a hack that allows you to hide certain usergroups from showing up on the forum index or subforum pages.

I apologize if this is a redundant question, however I tried searching for such a beast repeatedly through the forums to no avail.

I'm currently running v2.3.4

---Edit---

I apologize for not posting in the right section. I've reported this to a moderator.

[Xenon]

*moved*

[coRtALoS]

I apologize for bumping, however this is still a problem I need resolved on my forums.

If there is already an answer to this problem somewhere else on the forums, please PM me a link to the thread.

[Xenon]

hmm, i can help you on the index part, which should be quite equivalent to the forumdisplay part:

open index.php and find:
$forummoderators=$DB_site->query('SELECT user.userid,user.username,moderator.forumid
FROM moderator
LEFT JOIN user
ON (moderator.userid=user.userid)
ORDER BY user.username');

and change it into:
$forummoderators=$DB_site->query('SELECT user.userid,user.username,moderator.forumid
FROM moderator
LEFT JOIN user
ON (moderator.userid=user.userid)
WHERE user.usergroupid NOT IN (xx, yy, zz)
ORDER BY user.username');

and then just replace xx, yy, zz with the usergroupid's of the groups you don't want to show up in the listing :)

[Boofo]

Wouldn't it be better to use userid as the modertaors are probably all from the same usergroup?

Will this give an error with no SELECT for user.usergroupid?

[Xenon]

well, i just answered the question, he asked for usergroups which shouldn appear ;)

and nope, the condition field does not have to be in the result as well.

[coRtALoS]

My last problem is that user still shows up on the Forum Leaders page. Should I use the same bit of code for that page as well?

And thank you very much for that help Xenon.

It worked on the homepage, and I just had to edit the forumdisplay.php to get it to work when you're viewing the groups of general sections.

Then a quick editing of $moderatedby in the template got rid of the listed moderator when in the threadview section.

Thanks again... someone should make you... admin... :p

[Xenon]

*gg*

yeah, tell that Logician guy of vb.org that i should be an admin ^^

actually you should be able to to that on forumsleader page as well, as it's just an added condition