Print Page | Close Window

"Show Moderators"

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums Modifications
Forum Description: Mod's and Add-on's for Web Wiz Forums.
URL: https://forums.webwiz.net/forum_posts.asp?TID=21784
Printed Date: 28 March 2026 at 9:37am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: "Show Moderators"
Posted By: tandai
Subject: "Show Moderators"
Date Posted: 30 October 2006 at 3:31am
I don't known why I can't see in the Administration Board the option "Show Moderators' names in the Main Page of the Forum"? after upgrade from 7.97 to 8.04 (using Upgrade Tool presented by WWF).
 
Can you help me, please?



Replies:
Posted By: Mikey
Date Posted: 30 October 2006 at 10:47am
EDIT: Moved out of Mod Index

-------------
Handyman man?


Posted By: tandai
Date Posted: 30 October 2006 at 11:06am
@Mikey

What's to edit? Where is Mod Index to move out? Thanks for clarification.


Posted By: jsaren
Date Posted: 31 October 2006 at 2:28pm
Originally posted by tandai tandai wrote:

@Mikey
What's to edit? Where is Mod Index to move out? Thanks for clarification.
Mikey is right.this is a question or a request, not a mod.
 
wwf 8.x remove this funtion ,i guess it for speed.
 
if you hope show Moderators,you should add some codes in your scripts.
for example:
Quote      strModerators = ""
      'fisrt groups
      strSQL = "SELECT " & strDbTable & "Permissions.Group_ID, " & strDbTable & "Permissions.Author_ID, " & strDbTable & "Group.Name " & _
      "FROM " & strDbTable & "Permissions" & strDBNoLock & ", " & strDbTable & "Group" & strDBNoLock & " " & _
      "WHERE " & strDbTable & "Permissions.Moderate = " & strDbTrue & " " & _
      "AND " & strDbTable & "Permissions.Forum_ID = " & intForumID & " " & _
      "AND " & strDbTable & "Permissions.Group_ID = " & strDbTable & "Group.Group_ID " & _
      "ORDER BY " & strDbTable & "Group.Name ASC;"
      On Error Resume Next
      rsCommon.Open strSQL, adoCon
      If Err.Number <> 0 Then Call errorMsg("An error has occured while executing SQL query on database.", "member_count", "default.asp")
      On Error goto 0
       Do until rsCommon.EOF
        If strModerators <> "" Then strModerators = strModerators & ", "
        strModerators = strModerators & "<a href=""members.asp?GID=" & rsCommon("Group_ID") & strQsSID2 & """ class=""smLink"">" & rsCommon("Name") & "</a>"
        rsCommon.MoveNext
       Loop
      rsCommon.close
      'then users
      strSQL = "SELECT " & strDbTable & "Permissions.Group_ID, " & strDbTable & "Permissions.Author_ID, " & strDbTable & "Author.Username " & _
      "FROM " & strDbTable & "Permissions" & strDBNoLock & ", " & strDbTable & "Author" & strDBNoLock & " " & _
      "WHERE " & strDbTable & "Permissions.Moderate = " & strDbTrue & " " & _
      "AND " & strDbTable & "Permissions.Forum_ID = " & intForumID & " " & _
      "AND " & strDbTable & "Permissions.Author_ID = " & strDbTable & "Author.Author_ID " & _
      "ORDER BY " & strDbTable & "Author.Username ASC;"
      On Error Resume Next
      rsCommon.Open strSQL, adoCon
      If Err.Number <> 0 Then Call errorMsg("An error has occured while executing SQL query on database.", "member_count", "default.asp")
      On Error goto 0
       Do until rsCommon.EOF
         If strModerators <> "" Then strModerators = strModerators & " "

        strModerators = strModerators & "<a href=""member_profile.asp?PF=" & rsCommon("Author_ID") & strQsSID2 & """ class=""smLink"" oncontextmenu=""ShowUserMenu('" & rsCommon("Author_ID") & "', '" & rsCommon("Username") & "'); return false;"">" & rsCommon("Username") & "</a>"

        rsCommon.MoveNext

       Loop
      rsCommon.close
 
      'If there are moderators
      If strModerators <> "" Then strModerators = "" & strModerators



Posted By: justme
Date Posted: 11 November 2006 at 6:15am
I imagin this would  be added in the default file but where exactly?


Posted By: justme
Date Posted: 11 November 2006 at 7:08pm
Thanks it works but extermly slow perfromance, thats a big bummer,any way we can optimize the code?
 
 I will add it to the Mod Index.


Posted By: webfort
Date Posted: 27 November 2006 at 11:49am
how com the link has been removed, I think this would be a great feature to have :-(



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net