% @ Language=VBScript %> <% Option Explicit %> <% 'Set the response buffer to true Response.Buffer = True 'Dimension variables Dim strWebSiteName 'Holds the web site name Dim strForumPath 'Holds the forum path Dim strMode 'holds the mode of the page, set to true if changes are to be made to the database Dim strBgColour 'Holds the background colour of the forum Dim strTextColour 'Holds the text colours of the forum Dim strTextType 'Holds the font type of the forum Dim intTextSize 'Holds the font size of the forum Dim strTableColour 'Holds the table colour of the forum Dim strTableBorderColour 'Holds the border colour of the forum Dim strTableTitleColour 'Holds the table title and status ba rof the forum Dim strLinkColour 'Holds the Hperlink colour Dim strVLinkColour 'Holds the visited link colour Dim strALinkColour 'Holds the active link colour Dim blnTextLinks 'Set to true if you want text links instead of the powered by logo Dim blnLCode 'Holds the LCode value Dim blnRTEEditor 'Set to true if the HTML editor for IE 5+ is turned on Dim intTopicPerPage 'Holds the number of topics to show on each page Dim strTitleImage 'Holds the path and name for the title image for the forum Dim blnEmoticons 'Set to true if emoticons are turned on Dim strThreadOrder 'Holds the order the threads are in Dim blnAvatarImages 'Set to true if avatar images are on Dim intRepliesPerPage 'Holds the number of replies per page Dim intHotTopicViews 'Holds the number of views before a topic becomes hot Dim intHotTopicReplies 'Holds the number of replies before a topic becomes hot Dim blnPrivateMessenger 'Set to true if the private messenger is on Dim intPrivateMessages 'Holds the number of private msg's a user can have in there inbox Dim strForumName 'Holds the forum name Dim blnActiveUsers 'Set to true if the active users list is enabled Dim blnProcessTime 'Set to true if the user wants the page genration time displayed Dim blnAuthorEdited 'Set to true if the user wants the name of a post editor displayed Dim blnFlashFiles 'Set to true if Flash support is enabled Dim intPollChoice 'Holds the numebr of Poll Choices Dim strWebsiteURL 'Holds the URL to the sites homepage Dim blnShowMod 'Set to true if mod groups are shown on the main forum page 'Read in the users details for the forum strForumName = Request.Form("forumName") strWebSiteName = Request.Form("siteName") strWebsiteURL = Request.Form("siteURL") strForumPath = Request.Form("forumPath") strTitleImage = Request.Form("titleImage") blnTextLinks = Request.Form("textLinks") blnRTEEditor = CBool(Request.Form("IEEditor")) blnLCode = CBool(Request.Form("LCode")) intTopicPerPage = CInt(Request.Form("topic")) blnEmoticons = CBool(Request.Form("emoticons")) strThreadOrder = Request.Form("threadOrder") intPollChoice = CInt(Request.Form("pollChoice")) blnAvatarImages = CBool(Request.Form("avatar")) intRepliesPerPage = CInt(Request.Form("threads")) intHotTopicViews = CInt(Request.Form("hotViews")) intHotTopicReplies = CInt(Request.Form("hotReplies")) blnPrivateMessenger = CBool(Request.Form("privateMsg")) intPrivateMessages = CInt(Request.Form("pmNo")) blnActiveUsers = CBool(Request.Form("activeUsers")) blnProcessTime = CBool(Request.Form("processTime")) blnAuthorEdited = CBool(Request.Form("edited")) blnFlashFiles = CBool(Request.Form("flash")) blnShowMod = CBool(Request.Form("showMod")) strMode = Request.Form("mode") 'Initialise the SQL variable with an SQL statement to get the configuration details from the database If strDatabaseType = "SQLServer" Then strSQL = "EXECUTE " & strDbProc & "SelectConfiguration" Else strSQL = "SELECT TOP 1 " & strDbTable & "Configuration.* From " & strDbTable & "Configuration;" End If 'Set the cursor type property of the record set to Dynamic so we can navigate through the record set rsCommon.CursorType = 2 '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 the user is changing tthe colours then update the database If Request.Form("postBack") Then 'Update the recordset With rsCommon .Fields("forum_name") = strForumName .Fields("website_path") = strWebsiteURL .Fields("Text_link") = blnTextLinks .Fields("IE_editor") = blnRTEEditor .Fields("L_code") = blnLCode .Fields("Topics_per_page") = intTopicPerPage .Fields("Title_image") = strTitleImage .Fields("website_name") = strWebSiteName .Fields("forum_path") = strForumPath .Fields("Emoticons") = blnEmoticons .Fields("Avatar") = blnAvatarImages .Fields("Threads_per_page") = intRepliesPerPage .Fields("Hot_views") = intHotTopicViews .Fields("Hot_replies") = intHotTopicReplies .Fields("Private_msg") = blnPrivateMessenger .Fields("No_of_priavte_msg") = intPrivateMessages .Fields("Active_users") = blnActiveUsers .Fields("Process_time") = blnProcessTime .Fields("Show_edit") = blnAuthorEdited .Fields("Flash") = blnFlashFiles .Fields("Vote_choices") = intPollChoice .Fields("Show_mod") = blnShowMod 'Update the database with the new user's colours .Update 'Re-run the query to read in the updated recordset from the database .Requery End With 'Update variables Application("strMainForumName") = strForumName Application("strWebsiteURL") = strWebsiteURL Application("blnTextLinks") = blnTextLinks Application("blnRTEEditor") = blnRTEEditor Application("blnLCode") = blnLCode Application("intTopicPerPage") = intTopicPerPage Application("strTitleImage") = strTitleImage Application("strWebsiteName") = strWebSiteName Application("strForumPath") = strForumPath Application("blnEmoticons") = blnEmoticons Application("blnAvatar") = blnAvatarImages Application("intThreadsPerPage") = intRepliesPerPage Application("intNumHotViews") = intHotTopicViews Application("intNumHotReplies") = intRepliesPerPage Application("blnPrivateMessages") = blnPrivateMessenger Application("intNumPrivateMessages") = intPrivateMessages Application("blnActiveUsers") = blnActiveUsers Application("blnShowProcessTime") = blnProcessTime Application("blnShowEditUser") = blnAuthorEdited Application("blnFlashFiles") = blnFlashFiles Application("intMaxPollChoices") = intPollChoice Application("blnShowMod") = blnShowMod 'Empty the application level variable so that the changes made are seen in the main forum Application("blnConfigurationSet") = false End If 'Read in the forum colours from the database If NOT rsCommon.EOF Then 'Read in the colour info from the database strForumName = rsCommon.Fields("forum_name") strWebsiteURL = rsCommon.Fields("website_path") blnTextLinks = rsCommon.Fields("Text_link") blnLCode = CBool(rsCommon.Fields("L_code")) blnRTEEditor = rsCommon.Fields("IE_editor") intTopicPerPage = CInt(rsCommon.Fields("Topics_per_page")) strTitleImage = rsCommon.Fields("Title_image") strWebSiteName = rsCommon("website_name") strForumPath = rsCommon("forum_path") blnEmoticons = rsCommon.Fields("Emoticons") blnAvatarImages = rsCommon.Fields("Avatar") intRepliesPerPage = rsCommon.Fields("Threads_per_page") intHotTopicViews = rsCommon.Fields("Hot_views") intHotTopicReplies = rsCommon.Fields("Hot_replies") blnPrivateMessenger = rsCommon.Fields("Private_msg") intPrivateMessages = rsCommon.Fields("No_of_priavte_msg") blnActiveUsers = rsCommon.Fields("Active_users") blnProcessTime = rsCommon.Fields("Process_time") blnAuthorEdited = rsCommon.Fields("Show_edit") blnFlashFiles = rsCommon.Fields("Flash") intPollChoice = CInt(rsCommon.Fields("Vote_choices")) blnShowMod = CBool(rsCommon.Fields("Show_mod")) End If 'Reset Server Objects rsCommon.Close Set rsCommon = Nothing adoCon.Close Set adoCon = Nothing %>