<% @ Language=VBScript %> <% Option Explicit %> <% '**************************************************************************************** '** Copyright Notice '** '** Web Wiz Guide - Web Wiz Forums '** '** Copyright 2001-2004 Bruce Corkhill All Rights Reserved. '** '** This program is free software; you can modify (at your own risk) any part of it '** under the terms of the License that accompanies this software and use it both '** privately and commercially. '** '** All copyright notices must remain in tacked in the scripts and the '** outputted HTML. '** '** You may use parts of this program in your own private work, but you may NOT '** redistribute, repackage, or sell the whole or any part of this program even '** if it is modified or reverse engineered in whole or in part without express '** permission from the author. '** '** You may not pass the whole or any part of this application off as your own work. '** '** All links to Web Wiz Guide and powered by logo's must remain unchanged and in place '** and must remain visible when the pages are viewed unless permission is first granted '** by the copyright holder. '** '** This program is distributed in the hope that it will be useful, '** but WITHOUT ANY WARRANTY; without even the implied warranty of '** MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE OR ANY OTHER '** WARRANTIES WHETHER EXPRESSED OR IMPLIED. '** '** You should have received a copy of the License along with this program; '** if not, write to:- Web Wiz Guide, PO Box 4982, Bournemouth, BH8 8XP, United Kingdom. '** '** '** No official support is available for this program but you may post support questions at: - '** http://www.webwizguide.info/forum '** '** Support questions are NOT answered by e-mail ever! '** '** For correspondence or non support questions contact: - '** info@webwizguide.info '** '** or at: - '** '** Web Wiz Guide, PO Box 4982, Bournemouth, BH8 8XP, United Kingdom '** '**************************************************************************************** 'Set the response buffer to true Response.Buffer = True 'Dimension variables Dim intUserGroupID 'Holds the group ID Dim strGroupName 'Holds the name of the group Dim lngMinimumPosts 'Holds the minimum amount of posts to be in that group Dim blnSpecialGroup 'Set to true if a special group Dim intStars 'Holds the number of stars for the group Dim strCustomStars 'Holds the custom stars image if there is one fo0r this group Dim blnStartingGroup 'Set to true if it is the starting group 'If this is a postback update the strating group If Request.Form("postBack") Then 'Read in the group ID to make the starting group intUserGroupID = CInt(Request.Form("start")) 'Clear the old strating group 'Initalise the SQL string with an SQL update command to update the starting group If strDatabaseType = "SQLServer" Then strSQL = "UPDATE " & strDbTable & "Group SET " strSQL = strSQL & "" & strDbTable & "Group.Starting_group = 0 " strSQL = strSQL & " WHERE " & strDbTable & "Group.Starting_group = 1;" Else strSQL = "UPDATE " & strDbTable & "Group SET " strSQL = strSQL & "" & strDbTable & "Group.Starting_group = False " strSQL = strSQL & " WHERE " & strDbTable & "Group.Starting_group = True;" End If 'Write the updated number of posts to the database adoCon.Execute(strSQL) 'Read the various groups from the database 'Initalise the strSQL variable with an SQL statement to query the database strSQL = "SELECT " & strDbTable & "Group.* FROM " & strDbTable & "Group WHERE " & strDbTable & "Group.Group_ID = " & intUserGroupID & ";" 'Set the Lock Type for the records so that the record set is only locked when it is updated rsCommon.LockType = 3 'Query the database rsCommon.Open strSQL, adoCon 'If a record is returned update it If not rsCommon.EOF Then rsCommon.Fields("Starting_group") = True rsCommon.Update 'Requery to let access catch up rsCommon.Requery End If 'Close the recordset rsCommon.Close End If %> Administer User Groups
Administer User Groups
Return to the the Administration Menu

From here you can create, delete, change the details, etc. of forum user groups.

Click on User Group Name to change the details and settings for that user Group.

To change the Starting Group, select which group you want as the starting group and click the 'Update Starting Group' button.
<% 'Read the various groups from the database 'Initalise the strSQL variable with an SQL statement to query the database strSQL = "SELECT " & strDbTable & "Group.* FROM " & strDbTable & "Group ORDER BY " & strDbTable & "Group.Group_ID ASC;" 'Query the database rsCommon.Open strSQL, adoCon 'Check there are user groups to display If rsCommon.EOF Then 'If there are no user groups display then display the appropriate error message Response.Write vbCrLf & "" 'Else there the are user groups so write the HTML to display them Else 'Loop round to read in all the groups in the database Do While NOT rsCommon.EOF 'Get the category name from the database intUserGroupID = CInt(rsCommon("Group_ID")) strGroupName = rsCommon("Name") lngMinimumPosts = CLng(rsCommon("Minimum_posts")) blnSpecialGroup = CBool(rsCommon("Special_rank")) intStars = CInt(rsCommon("Stars")) strCustomStars = rsCommon("Custom_stars") blnStartingGroup = CBool(rsCommon("Starting_group")) 'Display the groups %> <% 'Move to the next database record rsCommon.MoveNext Loop End If 'Reset Server Objects rsCommon.Close Set rsCommon = Nothing adoCon.Close Set adoCon = Nothing %>
User Group Stars Minimum Num of Posts
(for Ladder Groups only)		 Starting
Group		 Delete
There are User Groups to display.
<% = strGroupName %> " alt="<% = intStars %> stars"> <% 'If this is a special group then disply a message that it is not a rank group If blnSpecialGroup Then Response.Write("Non Ladder Group") 'If this is a rank group disply the minimum number of posts to be in this group Else Response.Write(lngMinimumPosts) End If %> <% 'If this is the admin group or guest group then don't let em change the starting group If intUserGroupID <> 1 AND intUserGroupID <> 2 Then %> > <% End If %> <% 'If this is not the admin group, guest group, or starting group let them delete the group If intUserGroupID <> 1 AND intUserGroupID <> 2 AND blnStartingGroup = False Then %> Delete <% End If %>

Please Read the Following
Admin Group
The Admin Group, (the first group in the list), cannot be deleted. Any member placed in this user group has admin powers over the whole board and can also use this admin area, so be careful of the users you place in this group!
Guest Group
The Guest Group, (the second group in the list), cannot be deleted. Any member placed in this user group has the same powers on the board as visitors that have not registered.
Starting Group
The Starting Group is a special group that new members automatically become part of when they first register. You can only have one starting group, if you want to delete the starting group you must first select another group to be the starting group. You change the starting group by editing the details of a group and selecting it to become the starting group.