Restricting info to groups

i take it you are talking about wwg forums V7

to add this feature... around line 230 of members.asp

theres this code

 'If this is to show a group the query the database for the members of the group
 If intGetGroupID <> 0 Then
  'Initalise the strSQL variable with an SQL statement to query the database
  strSQL = "SELECT " & strDbTable & "Author.Author_ID, " & strDbTable & "Author.Username, " & strDbTable & "Author.Group_ID, " & strDbTable & "Author.Homepage, " & strDbTable & "Author.No_of_posts, " & strDbTable & "Author.Join_date, " & strDbTable & "Author.Active, " & strDbTable & "Group.Name, " & strDbTable & "Group.Stars "
  strSQL = strSQL & "FROM " & strDbTable & "Author, " & strDbTable & "Group "
  strSQL = strSQL & "WHERE " & strDbTable & "Author.Group_ID = " & strDbTable & "Group.Group_ID AND " & strDbTable & "Author.Group_ID=" & intGetGroupID & " "
  strSQL = strSQL & "ORDER BY " & strSortBy & ";"

 'Else get all the members from the database
 Else
  'Initalise the strSQL variable with an SQL statement to query the database
  strSQL = "SELECT " & strDbTable & "Author.Author_ID, " & strDbTable & "Author.Username, " & strDbTable & "Author.Group_ID, " & strDbTable & "Author.Homepage, " & strDbTable & "Author.No_of_posts, " & strDbTable & "Author.Join_date, " & strDbTable & "Author.Active, " & strDbTable & "Group.Name, " & strDbTable & "Group.Stars "
  strSQL = strSQL & "FROM " & strDbTable & "Author, " & strDbTable & "Group "
  strSQL = strSQL & "WHERE " & strDbTable & "Author.Group_ID = " & strDbTable & "Group.Group_ID AND " & strDbTable & "Author.Username Like '" & strSearchCriteria & "%'  "
If (blnAdmin = False OR blnModerator = False) Then strSQL = strSQl & " AND tblAuthor.Group_ID =" & intGroupID & ""
  strSQL = strSQL & "ORDER BY " & strSortBy & ";"
 End If

the section in red is what would make it so that the results found would be in the same group ... that is when you are searching ( not looking at a group id ie moderatos for a forum ... this code only applys to all members except admin and moderators if you dont want it that way delete the appropriate blnadmin or blnmoderator ..

i haven't tested it but it should work if it doesn't let me know .....

for got to add the tabkle name

just add the code in red to the SQL where it says where make sure to add it on a new line below the where but above the order by or sort by

that will make it have the same rescriction as the members page....

after a little thought this seems to work....

 If (blnAdmin = False OR blnModerator = False) Then strSQL = strSQl & " AND tblPermissions.Forum_ID = tblForum.Forum_id AND tblPermissions.Group_ID =" & intGroupID & ""

now on to the search area for the same problem....