members.asp

In version 11 I think the following code needs to be added to the members.asp file otherwise blnModerator can never be 'True' and therefore the changes to the code which remove banned members from the list can only be seen by an administrator and not a moderator

At line approx 195

'First see if the user is a in a moderator group for any forum
'Initalise the strSQL variable with an SQL statement to query the database
strSQL = "SELECT " & strDbTable & "Permissions.Moderate " & _
"FROM " & strDbTable & "Permissions " & _
"WHERE (" & strDbTable & "Permissions.Group_ID = " & intGroupID & " OR " & strDbTable & "Permissions.Author_ID = " & lngLoggedInUserID & ") AND  " & strDbTable & "Permissions.Moderate=" & strDBTrue & ";"

'Set error trapping
On Error Resume Next
   
'Query the database
rsCommon.Open strSQL, adoCon

'If an error has occurred write an error to the page
If Err.Number <> 0 Then    Call errorMsg("An error has occurred while executing SQL query on database.", "permissions ", "members.asp")
                       
'Disable error trapping
On Error goto 0
           
'If a record is returned then the user is a moderator in one of the forums
If NOT rsCommon.EOF Then blnModerator = True

'Clean up
rsCommon.Close