Web Wiz - Solar Powered Eco Web Hosting

  New Posts New Posts RSS Feed - "Show Moderators"
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

"Show Moderators"

 Post Reply Post Reply
Author
tandai View Drop Down
Newbie
Newbie


Joined: 25 June 2006
Status: Offline
Points: 8
Post Options Post Options   Thanks (0) Thanks(0)   Quote tandai Quote  Post ReplyReply Direct Link To This Post Topic: "Show Moderators"
    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?
Back to Top
Mikey View Drop Down
Senior Member
Senior Member

1979

Joined: 06 October 2003
Location: United Kingdom
Status: Offline
Points: 839
Post Options Post Options   Thanks (0) Thanks(0)   Quote Mikey Quote  Post ReplyReply Direct Link To This Post Posted: 30 October 2006 at 10:47am
EDIT: Moved out of Mod Index
Handyman man?
Back to Top
tandai View Drop Down
Newbie
Newbie


Joined: 25 June 2006
Status: Offline
Points: 8
Post Options Post Options   Thanks (0) Thanks(0)   Quote tandai Quote  Post ReplyReply Direct Link To This Post Posted: 30 October 2006 at 11:06am
@Mikey

What's to edit? Where is Mod Index to move out? Thanks for clarification.
Back to Top
jsaren View Drop Down
Groupie
Groupie
Avatar

Joined: 15 April 2006
Location: China
Status: Offline
Points: 95
Post Options Post Options   Thanks (0) Thanks(0)   Quote jsaren Quote  Post ReplyReply Direct Link To This Post 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

Back to Top
justme View Drop Down
Groupie
Groupie


Joined: 06 January 2006
Status: Offline
Points: 53
Post Options Post Options   Thanks (0) Thanks(0)   Quote justme Quote  Post ReplyReply Direct Link To This Post Posted: 11 November 2006 at 6:15am
I imagin this would  be added in the default file but where exactly?

Edited by justme - 11 November 2006 at 6:15am
Back to Top
justme View Drop Down
Groupie
Groupie


Joined: 06 January 2006
Status: Offline
Points: 53
Post Options Post Options   Thanks (0) Thanks(0)   Quote justme Quote  Post ReplyReply Direct Link To This Post 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.


Edited by justme - 11 November 2006 at 8:43pm
Back to Top
webfort View Drop Down
Newbie
Newbie


Joined: 02 November 2002
Location: United Kingdom
Status: Offline
Points: 20
Post Options Post Options   Thanks (0) Thanks(0)   Quote webfort Quote  Post ReplyReply Direct Link To This Post Posted: 27 November 2006 at 11:49am
how com the link has been removed, I think this would be a great feature to have :-(
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.07
Copyright ©2001-2024 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Policy

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2024 Web Wiz Ltd. All rights reserved.