Author |
Topic Search Topic Options
|
tandai
Newbie
Joined: 25 June 2006
Status: Offline
Points: 8
|
Post Options
Thanks(0)
Quote Reply
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?
|
|
Mikey
Senior Member
1979
Joined: 06 October 2003
Location: United Kingdom
Status: Offline
Points: 839
|
Post Options
Thanks(0)
Quote Reply
Posted: 30 October 2006 at 10:47am |
EDIT: Moved out of Mod Index
|
Handyman man?
|
|
tandai
Newbie
Joined: 25 June 2006
Status: Offline
Points: 8
|
Post Options
Thanks(0)
Quote Reply
Posted: 30 October 2006 at 11:06am |
@Mikey
What's to edit? Where is Mod Index to move out? Thanks for clarification.
|
|
jsaren
Groupie
Joined: 15 April 2006
Location: China
Status: Offline
Points: 95
|
Post Options
Thanks(0)
Quote Reply
Posted: 31 October 2006 at 2:28pm |
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:
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
|
|
|
justme
Groupie
Joined: 06 January 2006
Status: Offline
Points: 53
|
Post Options
Thanks(0)
Quote Reply
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
|
|
justme
Groupie
Joined: 06 January 2006
Status: Offline
Points: 53
|
Post Options
Thanks(0)
Quote Reply
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
|
|
webfort
Newbie
Joined: 02 November 2002
Location: United Kingdom
Status: Offline
Points: 20
|
Post Options
Thanks(0)
Quote Reply
Posted: 27 November 2006 at 11:49am |
how com the link has been removed, I think this would be a great feature to have :-(
|
|