<% '################################################################################# '## Snitz Forums 2000 v3.4.06 '################################################################################# '## Copyright (C) 2000-06 Michael Anderson, Pierre Gorissen, '## Huw Reddick and Richard Kinser '## '## This program is free software; you can redistribute it and/or '## modify it under the terms of the GNU General Public License '## as published by the Free Software Foundation; either version 2 '## of the License, or (at your option) any later version. '## '## All copyright notices regarding Snitz Forums 2000 '## must remain intact in the scripts and in the outputted HTML '## The "powered by" text/logo with a link back to '## http://forum.snitz.com in the footer of the pages MUST '## remain visible when the pages are viewed on the internet or intranet. '## '## This program is distributed in the hope that it will be useful, '## but WITHOUT ANY WARRANTY; without even the implied warranty of '## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the '## GNU General Public License for more details. '## '## You should have received a copy of the GNU General Public License '## along with this program; if not, write to the Free Software '## Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. '## '## Support can be obtained from our support forums at: '## http://forum.snitz.com '## '## Correspondence and Marketing Questions can be sent to: '## manderson@snitz.com '## '################################################################################# %> <% '-------------------------------------------------------------------- ' Microsoft ADO ' ' Copyright (c) 1996-1998 Microsoft Corporation. ' ' ADO constants include file for VBScript ' (This is a trimmed down version with only the required constants) '-------------------------------------------------------------------- on error resume next '---- CursorTypeEnum Values ---- Const adOpenForwardOnly = 0 Const adOpenKeyset = 1 Const adOpenDynamic = 2 Const adOpenStatic = 3 '---- LockTypeEnum Values ---- Const adLockReadOnly = 1 Const adLockPessimistic = 2 Const adLockOptimistic = 3 Const adLockBatchOptimistic = 4 '---- ExecuteOptionEnum Values ---- Const adAsyncExecute = &H00000010 Const adAsyncFetch = &H00000020 Const adAsyncFetchNonBlocking = &H00000040 Const adExecuteNoRecords = &H00000080 Const adExecuteStream = &H00000400 '---- CursorLocationEnum Values ---- Const adUseServer = 2 Const adUseClient = 3 '---- GetRowsOptionEnum Values ---- Const adGetRowsRest = -1 '---- CommandTypeEnum Values ---- Const adCmdUnknown = &H0008 Const adCmdText = &H0001 Const adCmdTable = &H0002 Const adCmdStoredProc = &H0004 Const adCmdFile = &H0100 Const adCmdTableDirect = &H0200 err.clear on error goto 0 %> <% '################################################################################# '## Snitz Forums 2000 v3.4.06 '################################################################################# '## Copyright (C) 2000-06 Michael Anderson, Pierre Gorissen, '## Huw Reddick and Richard Kinser '## '## This program is free software; you can redistribute it and/or '## modify it under the terms of the GNU General Public License '## as published by the Free Software Foundation; either version 2 '## of the License, or (at your option) any later version. '## '## All copyright notices regarding Snitz Forums 2000 '## must remain intact in the scripts and in the outputted HTML '## The "powered by" text/logo with a link back to '## http://forum.snitz.com in the footer of the pages MUST '## remain visible when the pages are viewed on the internet or intranet. '## '## This program is distributed in the hope that it will be useful, '## but WITHOUT ANY WARRANTY; without even the implied warranty of '## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the '## GNU General Public License for more details. '## '## You should have received a copy of the GNU General Public License '## along with this program; if not, write to the Free Software '## Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. '## '## Support can be obtained from our support forums at: '## http://forum.snitz.com '## '## Correspondence and Marketing Questions can be sent to: '## manderson@snitz.com '## '################################################################################# Session.LCID = 1033 '## Do Not Edit Response.Buffer = true Dim strDBType, strConnString, strTablePrefix, strMemberTablePrefix, strFilterTablePrefix '## Do Not Edit Dim counter, ConnErrorNumber, ConnErrorDesc, blnSetup '## Do Not Edit '################################################################################# '## SELECT YOUR DATABASE TYPE AND CONNECTION TYPE (access, sqlserver or mysql) '################################################################################# 'strDBType = "sqlserver" strDBType = "access" 'strDBType = "mysql" '## Make sure to uncomment one of the strConnString lines and edit it so that it points to where your database is! strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("snitz_forums_2000.mdb") '## MS Access 2000 using virtual path 'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/USERNAME/db/snitz_forums_2000.mdb") '## MS Access 2000 on Brinkster 'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\db\snitz_forums_2000.mdb" '## MS Access 2000 'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("snitz_forums_2000.mdb") '## MS Access 97 using virtual path 'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/USERNAME/db/snitz_forums_2000.mdb") '## MS Access 97 on Brinkster 'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 97 'strConnString = "Provider=SQLOLEDB;Data Source=SERVER_NAME;database=DB_NAME;uid=UID;pwd=PWD;" '## MS SQL Server 6.x/7.x/2000 (OLEDB connection) 'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=UID;pwd=PWD;database=DB_NAME" '## MS SQL Server 6.x/7.x/2000 (ODBC connection) 'strConnString = "driver=MySQL;server=SERVER_IP;uid=UID;pwd=PWD;database=DB_NAME" '## MySQL w/ MyODBC v2.50 'strConnString = "driver={MySQL ODBC 3.51 Driver};option=16387;server=SERVER_IP;user=UID;password=PWD;DATABASE=DB_NAME;" '##MySQL w/ MyODBC v3.51 'strConnString = "DSN_NAME" '## DSN strTablePrefix = "FORUM_" strMemberTablePrefix = "FORUM_" strFilterTablePrefix = "FORUM_" 'used for BADWORDS and NAMEFILTER tables '################################################################################# '## If you have deleted the default Admin account, you may need to change the '## value below. Otherwise, it should be left unchanged. (such as with a new '## installation) '################################################################################# Const intAdminMemberID = 1 '################################################################################# '## intCookieDuration is the amount of days before the forum cookie expires '## You can set it to a higher value '## For example for one year you can set it to 365 '## (default is 30 days) '################################################################################# Const intCookieDuration = 30 %> <% '################################################################################# '## Snitz Forums 2000 v3.4.06 '################################################################################# '## Copyright (C) 2000-06 Michael Anderson, Pierre Gorissen, '## Huw Reddick and Richard Kinser '## '## This program is free software; you can redistribute it and/or '## modify it under the terms of the GNU General Public License '## as published by the Free Software Foundation; either version 2 '## of the License, or (at your option) any later version. '## '## All copyright notices regarding Snitz Forums 2000 '## must remain intact in the scripts and in the outputted HTML '## The "powered by" text/logo with a link back to '## http://forum.snitz.com in the footer of the pages MUST '## remain visible when the pages are viewed on the internet or intranet. '## '## This program is distributed in the hope that it will be useful, '## but WITHOUT ANY WARRANTY; without even the implied warranty of '## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the '## GNU General Public License for more details. '## '## You should have received a copy of the GNU General Public License '## along with this program; if not, write to the Free Software '## Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. '## '## Support can be obtained from our support forums at: '## http://forum.snitz.com '## '## Correspondence and Marketing Questions can be sent to: '## manderson@snitz.com '## '################################################################################# '## Const variable_name = "icon_filename|width|height" Const strIconAIM = "icon_aim.gif|15|15" Const strIconBar = "icon_bar.gif|15|15" Const strIconBlank = "icon_blank.gif|15|15" Const strIconClosedTopic = "icon_closed_topic.gif|15|15" Const strIconDeleteReply = "icon_delete_reply.gif|15|15" Const strIconEditTopic = "icon_edit_topic.gif|15|15" Const strIconEditorBold = "icon_editor_bold.gif|23|22" Const strIconEditorCenter = "icon_editor_center.gif|23|22" Const strIconEditorCode = "icon_editor_code.gif|23|22" Const strIconEditorEmail = "icon_editor_email.gif|23|22" Const strIconEditorHR = "icon_editor_hr.gif|23|22" Const strIconEditorLeft = "icon_editor_left.gif|23|22" Const strIconEditorImage = "icon_editor_image.gif|23|22" Const strIconEditorItalicize = "icon_editor_italicize.gif|23|22" Const strIconEditorList = "icon_editor_list.gif|23|22" Const strIconEditorQuote = "icon_editor_quote.gif|23|22" Const strIconEditorRight = "icon_editor_right.gif|23|22" Const strIconEditorSmilie = "icon_editor_smilie.gif|23|22" Const strIconEditorStrike = "icon_editor_strike.gif|23|22" Const strIconEditorUnderline = "icon_editor_underline.gif|23|22" Const strIconEditorUrl = "icon_editor_url.gif|23|22" Const strIconEmail = "icon_email.gif|15|15" Const strIconFolder = "icon_folder.gif|15|15" Const strIconFolderArchive = "icon_folder_archive.gif|16|16" Const strIconFolderArchived = "icon_folder_archived.gif|15|15" Const strIconFolderClosed = "icon_folder_closed.gif|15|15" Const strIconFolderClosedTopic = "icon_folder_closed_topic.gif|15|15" Const strIconFolderDelete = "icon_folder_delete.gif|15|15" Const strIconFolderHold = "icon_folder_hold.gif|15|15" Const strIconFolderHot = "icon_folder_hot.gif|15|17" Const strIconFolderLocked = "icon_folder_locked.gif|15|15" Const strIconFolderModerate = "icon_folder_moderate.gif|15|15" Const strIconFolderNew = "icon_folder_new.gif|15|15" Const strIconFolderNewHot = "icon_folder_new_hot.gif|15|17" Const strIconFolderNewLocked = "icon_folder_new_locked.gif|15|15" Const strIconFolderNewSticky = "icon_folder_new_sticky.gif|15|15" Const strIconFolderNewStickyLocked = "icon_folder_new_sticky_locked.gif|15|15" Const strIconFolderNewTopic = "icon_folder_new_topic.gif|15|15" Const strIconFolderOpen = "icon_folder_open.gif|15|15" Const strIconFolderOpenTopic = "icon_folder_open_topic.gif|15|15" Const strIconFolderPencil = "icon_folder_pencil.gif|15|15" Const strIconFolderSticky = "icon_folder_sticky.gif|15|15" Const strIconFolderStickyLocked = "icon_folder_sticky_locked.gif|15|15" Const strIconFolderUnlocked = "icon_folder_unlocked.gif|15|15" Const strIconFolderUnmoderated = "icon_folder_unmoderated.gif|15|15" Const strIconGoDown = "icon_go_down.gif|15|15" Const strIconGoLeft = "icon_go_left.gif|15|15" Const strIconGoRight = "icon_go_right.gif|15|15" Const strIconGoUp = "icon_go_up.gif|15|15" Const strIconGroup = "icon_group.gif|15|15" Const strIconGroupCategories = "icon_group_categories.gif|21|22" Const strIconHomepage = "icon_homepage.gif|15|15" Const strIconICQ = "icon_icq.gif|15|15" Const strIconIP = "icon_ip.gif|15|15" Const strIconLastpost = "icon_lastpost.gif|12|10" Const strIconLock = "icon_lock.gif|12|12" Const strIconMinus = "icon_minus.gif|10|10" Const strIconMSNM = "icon_msnm.gif|15|15" Const strIconPencil = "icon_pencil.gif|12|12" Const strIconPhotoNone = "icon_photo_none.gif|150|150" Const strIconPlus = "icon_plus.gif|10|10" Const strIconPosticon = "icon_posticon.gif|15|15" Const strIconPosticonHold = "icon_posticon_hold.gif|15|15" Const strIconPosticonUnmoderated = "icon_posticon_unmoderated.gif|15|15" Const strIconPrint = "icon_print.gif|16|17" Const strIconPrivateAdd = "icon_private_add.gif|23|22" Const strIconPrivateAddAll = "icon_private_addall.gif|23|22" Const strIconPrivateRemAll = "icon_private_remall.gif|23|22" Const strIconPrivateRemove = "icon_private_remove.gif|23|22" Const strIconProfile = "icon_profile.gif|15|15" Const strIconProfileLocked = "icon_profile_locked.gif|15|15" Const strIconReplyTopic = "icon_reply_topic.gif|15|15" Const strIconSendTopic = "icon_send_topic.gif|15|15" Const strIconSmile = "icon_smile.gif|15|15" Const strIconSmile8ball = "icon_smile_8ball.gif|15|15" Const strIconSmileAngry = "icon_smile_angry.gif|15|15" Const strIconSmileApprove = "icon_smile_approve.gif|15|15" Const strIconSmileBig = "icon_smile_big.gif|15|15" Const strIconSmileBlackeye = "icon_smile_blackeye.gif|15|15" Const strIconSmileBlush = "icon_smile_blush.gif|15|15" Const strIconSmileClown = "icon_smile_clown.gif|15|15" Const strIconSmileCool = "icon_smile_cool.gif|15|15" Const strIconSmileDead = "icon_smile_dead.gif|15|15" Const strIconSmileDisapprove = "icon_smile_disapprove.gif|15|15" Const strIconSmileEvil = "icon_smile_evil.gif|15|15" Const strIconSmileKisses = "icon_smile_kisses.gif|15|15" Const strIconSmileQuestion = "icon_smile_question.gif|15|15" Const strIconSmileSad = "icon_smile_sad.gif|15|15" Const strIconSmileShock = "icon_smile_shock.gif|15|15" Const strIconSmileShy = "icon_smile_shy.gif|15|15" Const strIconSmileSleepy = "icon_smile_sleepy.gif|15|15" Const strIconSmileTongue = "icon_smile_tongue.gif|15|15" Const strIconSmileWink = "icon_smile_wink.gif|15|15" Const strIconSort = "icon_sort.gif|15|15" Const strIconStarBlue = "icon_star_blue.gif|13|12" Const strIconStarBronze = "icon_star_bronze.gif|13|12" Const strIconStarCyan = "icon_star_cyan.gif|13|12" Const strIconStarGold = "icon_star_gold.gif|13|12" Const strIconStarGreen = "icon_star_green.gif|13|12" Const strIconStarOrange = "icon_star_orange.gif|13|12" Const strIconStarPurple = "icon_star_purple.gif|13|12" Const strIconStarRed = "icon_star_red.gif|13|12" Const strIconStarSilver = "icon_star_silver.gif|13|12" Const strIconSubscribe = "icon_subscribe.gif|15|15" Const strIconTopicAllRead = "icon_topic_all_read.gif|15|15" Const strIconTrashcan = "icon_trashcan.gif|12|12" Const strIconUnlock = "icon_unlock.gif|12|12" Const strIconUnsubscribe = "icon_unsubscribe.gif|15|15" Const strIconUrl = "icon_url.gif|16|16" Const strIconYahoo = "icon_yahoo.gif|16|15" function getCurrentIcon(fIconName,fAltText,fOtherTags) if fIconName = "" then exit function if fOtherTags <> "" then fOtherTags = " " & fOtherTags if Instr(fIconName,"http://") > 0 then strTempImageUrl = "" else strTempImageUrl = strImageUrl tmpicons = split(fIconName,"|") if tmpicons(1) <> "" then fWidth = " width=""" & tmpicons(1) & """" if tmpicons(2) <> "" then fHeight = " height=""" & tmpicons(2) & """" getCurrentIcon = "" end function %> <% '################################################################################# '## Do Not Edit Below This Line - It could destroy your forums and lose data '################################################################################# Dim mLev, strLoginStatus, MemberID, strArchiveTablePrefix Dim strVersion, strForumTitle, strCopyright, strTitleImage, strHomeURL Dim strForumURL, strAuthType, strSetCookieToForum, strEmail, strUniqueEmail Dim strMailMode, strMailServer, strSender, strDateType, strTimeAdjust Dim strTimeType, strMoveTopicMode, strMoveNotify, strIPLogging, strPrivateForums Dim strShowModerators, strAllowForumCode, strIMGInPosts, strAllowHTML, strNoCookies Dim strHotTopic, intHotTopicNum, strSecureAdmin Dim strAIM, strICQ, strMSN, strYAHOO Dim strFullName, strPicture, strSex, strCity, strState Dim strAge, strAgeDOB, strMinAge, strCountry, strOccupation, strBio Dim strHobbies, strLNews, strQuote, strMarStatus, strFavLinks Dim strRecentTopics, strAllowHideEmail, strHomepage, strUseExtendedProfile, strIcons Dim strGfxButtons, strEditedByDate, strBadWordFilter, strBadWords, strDefaultFontFace Dim strDefaultFontSize, strHeaderFontSize, strFooterFontSize, strPageBGColor, strDefaultFontColor Dim strLinkColor, strLinkTextDecoration, strVisitedLinkColor, strVisitedTextDecoration Dim strActiveLinkColor, strActiveTextDecoration, strHoverFontColor, strHoverTextDecoration Dim strHeadCellColor, strHeadFontColor, strCategoryCellColor, strCategoryFontColor Dim strForumFirstCellColor, strForumCellColor, strAltForumCellColor, strForumFontColor Dim strForumLinkColor, strForumLinkTextDecoration, strForumVisitedLinkColor, strForumVisitedTextDecoration Dim strForumActiveLinkColor, strForumActiveTextDecoration, strForumHoverFontColor, strForumHoverTextDecoration Dim strTableBorderColor, strPopUpTableColor, strPopUpBorderColor, strNewFontColor, strHiLiteFontColor, strSearchHiLiteColor Dim strTopicWidthLeft, strTopicNoWrapLeft, strTopicWidthRight, strTopicNoWrapRight, strShowRank Dim strRankAdmin, strRankMod, strRankColorAdmin, strRankColorMod Dim strRankLevel0, strRankLevel1, strRankLevel2, strRankLevel3, strRankLevel4, strRankLevel5 Dim strRankColor0, strRankColor1, strRankColor2, strRankColor3, strRankColor4, strRankColor5 Dim intRankLevel0, intRankLevel1, intRankLevel2, intRankLevel3, intRankLevel4, intRankLevel5 Dim strSignatures, strDSignatures, strShowStatistics, strShowImagePoweredBy, strLogonForMail Dim strShowPaging, strShowTopicNav, strPageSize, strPageNumberSize, strForumTimeAdjust Dim strNTGroups, strAutoLogon, strModeration, strSubscription, strArchiveState, strUserNameFilter Dim strFloodCheck, strFloodCheckTime, strTimeLimit, strEmailVal, strProhibitNewMembers, strRequireReg, strRestrictReg Dim strGroupCategories, strPageBGImageUrl, strImageUrl, strJumpLastPost, strStickyTopic, strShowSendToFriend Dim strShowPrinterFriendly, strShowTimer, strTimerPhrase, strShowFormatButtons, strShowSmiliesTable, strShowQuickReply Dim SubCount, MySubCount strCookieURL = Left(Request.ServerVariables("Path_Info"), InstrRev(Request.ServerVariables("Path_Info"), "/")) strUniqueID = "Snitz00" If Application(strCookieURL & "ConfigLoaded")= "" Or IsNull(Application(strCookieURL & "ConfigLoaded")) Or blnSetup="Y" Then on error resume next blnLoadConfig = TRUE set my_Conn = Server.CreateObject("ADODB.Connection") my_Conn.Errors.Clear Err.Clear my_Conn.Open strConnString for counter = 0 to my_conn.Errors.Count -1 ConnErrorNumber = Err.Number ConnErrorDesc = my_Conn.Errors(counter).Description If ConnErrorNumber <> 0 Then If blnSetup <> "Y" Then my_Conn.Errors.Clear Err.Clear Response.Redirect "setup.asp?RC=1&CC=1&strDBType=" & strDBType & "&EC=" & ConnErrorNumber & "&ED=" & Server.URLEncode(ConnErrorDesc) else blnLoadConfig = FALSE end if end if next my_Conn.Errors.Clear Err.Clear '## if the configvariables aren't loaded into the Application object '## or after the admin has changed the configuration '## the variables get (re)loaded '## Forum_SQL strSql = "SELECT * FROM " & strTablePrefix & "CONFIG_NEW " set rsConfig = my_Conn.Execute (strSql) for counter = 0 to my_conn.Errors.Count -1 ConnErrorNumber = Err.Number If ConnErrorNumber <> 0 Then If blnSetup <> "Y" Then my_Conn.Errors.Clear Err.Clear strSql = "SELECT C_STRVERSION, C_STRSENDER " strSql = strSql & " FROM " & strTablePrefix & "CONFIG " set rsInfo = my_Conn.Execute (StrSql) strVersion = rsInfo("C_STRVERSION") strSender = rsInfo("C_STRSENDER") rsInfo.Close set rsInfo = nothing if strVersion = "" then strSql = "SELECT C_VALUE " strSql = strSql & " FROM " & strTablePrefix & "CONFIG_NEW " strSql = strSql & " WHERE C_VARIABLE = 'strVersion' " set rsInfo = my_Conn.Execute (StrSql) strVersion = rsInfo("C_VALUE") rsInfo.Close set rsInfo = nothing strSql = "SELECT C_VALUE " strSql = strSql & " FROM " & strTablePrefix & "CONFIG_NEW " strSql = strSql & " WHERE C_VARIABLE = 'strSender' " set rsInfo = my_Conn.Execute (StrSql) strSender = rsInfo("C_VALUE") rsInfo.Close set rsInfo = nothing end if my_Conn.Close set my_Conn = nothing Response.Redirect "setup.asp?RC=2&MAIL=" & Server.UrlEncode(strSender) & "&VER=" & Server.URLEncode(strVersion) & "&strDBType="& strDBType & "&EC=" & ConnErrorNumber else my_Conn.Errors.Clear blnLoadConfig = FALSE end if end if next my_Conn.Errors.Clear if blnLoadConfig then Application.Lock do while not rsConfig.EOF Application(strCookieURL & Trim(UCase(rsConfig("C_VARIABLE")))) = Trim(rsConfig("C_VALUE")) rsConfig.MoveNext loop Application.UnLock rsConfig.close end if my_Conn.Close set my_Conn = nothing on error goto 0 Application.Lock Application(strCookieURL & "ConfigLoaded")= "YES" Application.UnLock End If ' ## Read the config-info from the application variables... strVersion = Application(strCookieURL & "STRVERSION") strForumTitle = Application(strCookieURL & "STRFORUMTITLE") strCopyright = Application(strCookieURL & "STRCOPYRIGHT") strTitleImage = Application(strCookieURL & "STRTITLEIMAGE") strHomeURL = Application(strCookieURL & "STRHOMEURL") strForumURL = Application(strCookieURL & "STRFORUMURL") strAuthType = Application(strCookieURL & "STRAUTHTYPE") strSetCookieToForum = Application(strCookieURL & "STRSETCOOKIETOFORUM") strEmail = Application(strCookieURL & "STREMAIL") strUniqueEmail = Application(strCookieURL & "STRUNIQUEEMAIL") strMailMode = Application(strCookieURL & "STRMAILMODE") strMailServer = Application(strCookieURL & "STRMAILSERVER") strSender = Application(strCookieURL & "STRSENDER") strDateType = Application(strCookieURL & "STRDATETYPE") strTimeAdjust = Application(strCookieURL & "STRTIMEADJUST") strTimeType = Application(strCookieURL & "STRTIMETYPE") strMoveTopicMode = Application(strCookieURL & "STRMOVETOPICMODE") strMoveNotify = Application(strCookieURL & "STRMOVENOTIFY") strIPLogging = Application(strCookieURL & "STRIPLOGGING") strPrivateForums = Application(strCookieURL & "STRPRIVATEFORUMS") strShowModerators = Application(strCookieURL & "STRSHOWMODERATORS") strAllowForumCode = Application(strCookieURL & "STRALLOWFORUMCODE") strIMGInPosts = Application(strCookieURL & "STRIMGINPOSTS") strAllowHTML = Application(strCookieURL & "STRALLOWHTML") strNoCookies = Application(strCookieURL & "STRNOCOOKIES") strSecureAdmin = Application(strCookieURL & "STRSECUREADMIN") strHotTopic = Application(strCookieURL & "STRHOTTOPIC") intHotTopicNum = cLng(Application(strCookieURL & "INTHOTTOPICNUM")) strAIM = Application(strCookieURL & "STRAIM") strICQ = Application(strCookieURL & "STRICQ") strMSN = Application(strCookieURL & "STRMSN") strYAHOO = Application(strCookieURL & "STRYAHOO") strFullName = Application(strCookieURL & "STRFULLNAME") strPicture = Application(strCookieURL & "STRPICTURE") strSex = Application(strCookieURL & "STRSEX") strCity = Application(strCookieURL & "STRCITY") strState = Application(strCookieURL & "STRSTATE") strAge = Application(strCookieURL & "STRAGE") strAgeDOB = Application(strCookieURL & "STRAGEDOB") strMinAge = cInt(Application(strCookieURL & "STRMINAGE")) strCountry = Application(strCookieURL & "STRCOUNTRY") strOccupation = Application(strCookieURL & "STROCCUPATION") strBio = Application(strCookieURL & "STRBIO") strHobbies = Application(strCookieURL & "STRHOBBIES") strLNews = Application(strCookieURL & "STRLNEWS") strQuote = Application(strCookieURL & "STRQUOTE") strMarStatus = Application(strCookieURL & "STRMARSTATUS") strFavLinks = Application(strCookieURL & "STRFAVLINKS") strRecentTopics = Application(strCookieURL & "STRRECENTTOPICS") strAllowHideEmail = "1" '##not yet used ! strHomepage = Application(strCookieURL & "STRHOMEPAGE") strSignatures = Application(strCookieURL & "STRSIGNATURES") strDSignatures = Application(strCookieURL & "STRDSIGNATURES") strUseExtendedProfile = (cLng(strSignatures) + cLng(strBio) + cLng(strHobbies) + cLng(strLNews) + cLng(strRecentTopics) + cLng(strPicture) + cLng(strQuote)) > 0 strUseExtendedProfile = strUseExtendedProfile or ((cLng(strAIM) + cLng(strICQ) + cLng(strMSN) + cLng(strYAHOO) + (cLng(strFullName)*2) + cLng(strSex) + cLng(strCity) + cLng(strState) + cLng(strAge) + cLng(strCountry) + cLng(strOccupation) + (cLng(strFavLinks)*2)) > 5) strIcons = Application(strCookieURL & "STRICONS") strGfxButtons = Application(strCookieURL & "STRGFXBUTTONS") strEditedByDate = Application(strCookieURL & "STREDITEDBYDATE") strBadWordFilter = Application(strCookieURL & "STRBADWORDFILTER") strBadWords = Application(strCookieURL & "STRBADWORDS") strUserNameFilter = Application(strCookieURL & "STRUSERNAMEFILTER") strDefaultFontFace = Application(strCookieURL & "STRDEFAULTFONTFACE") strDefaultFontSize = Application(strCookieURL & "STRDEFAULTFONTSIZE") strHeaderFontSize = Application(strCookieURL & "STRHEADERFONTSIZE") strFooterFontSize = Application(strCookieURL & "STRFOOTERFONTSIZE") strPageBGColor = Application(strCookieURL & "STRPAGEBGCOLOR") strDefaultFontColor = Application(strCookieURL & "STRDEFAULTFONTCOLOR") strLinkColor = Application(strCookieURL & "STRLINKCOLOR") strLinkTextDecoration = Application(strCookieURL & "STRLINKTEXTDECORATION") strVisitedLinkColor = Application(strCookieURL & "STRVISITEDLINKCOLOR") strVisitedTextDecoration = Application(strCookieURL & "STRVISITEDTEXTDECORATION") strActiveLinkColor = Application(strCookieURL & "STRACTIVELINKCOLOR") strActiveTextDecoration = Application(strCookieURL & "STRACTIVETEXTDECORATION") strHoverFontColor = Application(strCookieURL & "STRHOVERFONTCOLOR") strHoverTextDecoration = Application(strCookieURL & "STRHOVERTEXTDECORATION") strHeadCellColor = Application(strCookieURL & "STRHEADCELLCOLOR") strHeadFontColor = Application(strCookieURL & "STRHEADFONTCOLOR") strCategoryCellColor = Application(strCookieURL & "STRCATEGORYCELLCOLOR") strCategoryFontColor = Application(strCookieURL & "STRCATEGORYFONTCOLOR") strForumFirstCellColor = Application(strCookieURL & "STRFORUMFIRSTCELLCOLOR") strForumCellColor = Application(strCookieURL & "STRFORUMCELLCOLOR") strAltForumCellColor = Application(strCookieURL & "STRALTFORUMCELLCOLOR") strForumFontColor = Application(strCookieURL & "STRFORUMFONTCOLOR") strForumLinkColor = Application(strCookieURL & "STRFORUMLINKCOLOR") strForumLinkTextDecoration = Application(strCookieURL & "STRFORUMLINKTEXTDECORATION") strForumVisitedLinkColor = Application(strCookieURL & "STRFORUMVISITEDLINKCOLOR") strForumVisitedTextDecoration = Application(strCookieURL & "STRFORUMVISITEDTEXTDECORATION") strForumActiveLinkColor = Application(strCookieURL & "STRFORUMACTIVELINKCOLOR") strForumActiveTextDecoration = Application(strCookieURL & "STRFORUMACTIVETEXTDECORATION") strForumHoverFontColor = Application(strCookieURL & "STRFORUMHOVERFONTCOLOR") strForumHoverTextDecoration = Application(strCookieURL & "STRFORUMHOVERTEXTDECORATION") strTableBorderColor = Application(strCookieURL & "STRTABLEBORDERCOLOR") strPopUpTableColor = Application(strCookieURL & "STRPOPUPTABLECOLOR") strPopUpBorderColor = Application(strCookieURL & "STRPOPUPBORDERCOLOR") strNewFontColor = Application(strCookieURL & "STRNEWFONTCOLOR") strHiLiteFontColor = Application(strCookieURL & "STRHILITEFONTCOLOR") strSearchHiLiteColor = Application(strCookieURL & "STRSEARCHHILITECOLOR") strTopicWidthLeft = Application(strCookieURL & "STRTOPICWIDTHLEFT") strTopicNoWrapLeft = Application(strCookieURL & "STRTOPICNOWRAPLEFT") strTopicWidthRight = Application(strCookieURL & "STRTOPICWIDTHRIGHT") strTopicNoWrapRight = Application(strCookieURL & "STRTOPICNOWRAPRIGHT") strShowRank = Application(strCookieURL & "STRSHOWRANK") strRankAdmin = Application(strCookieURL & "STRRANKADMIN") strRankMod = Application(strCookieURL & "STRRANKMOD") strRankLevel0 = Application(strCookieURL & "STRRANKLEVEL0") strRankLevel1 = Application(strCookieURL & "STRRANKLEVEL1") strRankLevel2 = Application(strCookieURL & "STRRANKLEVEL2") strRankLevel3 = Application(strCookieURL & "STRRANKLEVEL3") strRankLevel4 = Application(strCookieURL & "STRRANKLEVEL4") strRankLevel5 = Application(strCookieURL & "STRRANKLEVEL5") strRankColorAdmin = Application(strCookieURL & "STRRANKCOLORADMIN") strRankColorMod = Application(strCookieURL & "STRRANKCOLORMOD") strRankColor0 = Application(strCookieURL & "STRRANKCOLOR0") strRankColor1 = Application(strCookieURL & "STRRANKCOLOR1") strRankColor2 = Application(strCookieURL & "STRRANKCOLOR2") strRankColor3 = Application(strCookieURL & "STRRANKCOLOR3") strRankColor4 = Application(strCookieURL & "STRRANKCOLOR4") strRankColor5 = Application(strCookieURL & "STRRANKCOLOR5") intRankLevel0 = Application(strCookieURL & "INTRANKLEVEL0") intRankLevel1 = Application(strCookieURL & "INTRANKLEVEL1") intRankLevel2 = Application(strCookieURL & "INTRANKLEVEL2") intRankLevel3 = Application(strCookieURL & "INTRANKLEVEL3") intRankLevel4 = Application(strCookieURL & "INTRANKLEVEL4") intRankLevel5 = Application(strCookieURL & "INTRANKLEVEL5") strShowStatistics = Application(strCookieURL & "STRSHOWSTATISTICS") strShowImagePoweredBy = Application(strCookieURL & "STRSHOWIMAGEPOWEREDBY") strLogonForMail = Application(strCookieURL & "STRLOGONFORMAIL") strShowPaging = Application(strCookieURL & "STRSHOWPAGING") strShowTopicNav = Application(strCookieURL & "STRSHOWTOPICNAV") strPageSize = Application(strCookieURL & "STRPAGESIZE") strPageNumberSize = Application(strCookieURL & "STRPAGENUMBERSIZE") strForumTimeAdjust = DateAdd("h", strTimeAdjust , Now()) strNTGroups = Application(strCookieURL & "STRNTGROUPS") strAutoLogon = Application(strCookieURL & "STRAUTOLOGON") strModeration = Application(strCookieURL & "STRMODERATION") strSubscription = Application(strCookieURL & "STRSUBSCRIPTION") strArchiveState = Application(strCookieURL & "STRARCHIVESTATE") strFloodCheck = Application(strCookieURL & "STRFLOODCHECK") strFloodCheckTime = Application(strCookieURL & "STRFLOODCHECKTIME") strEmailVal = Application(strCookieURL & "STREMAILVAL") strPageBGImageUrl = Application(strCookieURL & "STRPAGEBGIMAGEURL") strImageUrl = Application(strCookieURL & "STRIMAGEURL") strJumpLastPost = Application(strCookieURL & "STRJUMPLASTPOST") strStickyTopic = Application(strCookieURL & "STRSTICKYTOPIC") strShowSendToFriend = Application(strCookieURL & "STRSHOWSENDTOFRIEND") strShowPrinterFriendly = Application(strCookieURL & "STRSHOWPRINTERFRIENDLY") strProhibitNewMembers = Application(strCookieURL & "STRPROHIBITNEWMEMBERS") strRequireReg = Application(strCookieURL & "STRREQUIREREG") strRestrictReg = Application(strCookieURL & "STRRESTRICTREG") strGroupCategories = Application(strCookieURL & "STRGROUPCATEGORIES") strShowTimer = Application(strCookieURL & "STRSHOWTIMER") strTimerPhrase = Application(strCookieURL & "STRTIMERPHRASE") strShowFormatButtons = Application(strCookieURL & "STRSHOWFORMATBUTTONS") strShowSmiliesTable = Application(strCookieURL & "STRSHOWSMILIESTABLE") strShowQuickReply = Application(strCookieURL & "STRSHOWQUICKREPLY") if strSecureAdmin = "0" then Session(strCookieURL & "Approval") = "15916941253" end if if strAuthType = "db" then strDBNTSQLName = "M_NAME" strAutoLogon = "0" strNTGroups = "0" else strDBNTSQLName = "M_USERNAME" end if %> <% '################################################################################# '## Variable declaration '################################################################################# dim strSelectSize dim intCols, intRows '################################################################################# '## Initialise variables '################################################################################# if Request.QueryString("method") <> "" then strRqMethod = chkString(Request.QueryString("method"), "SQLString") elseif Request.Form("Method_Type") = "logout" then 'Do Nothing else Response.Redirect("default.asp") end if if Request.QueryString("TOPIC_ID") <> "" then if IsNumeric(Request.QueryString("TOPIC_ID")) = True then strRqTopicID = cLng(Request.QueryString("TOPIC_ID")) else Response.Redirect("default.asp") end if end if if Request.QueryString("FORUM_ID") <> "" then if IsNumeric(Request.QueryString("FORUM_ID")) = True then strRqForumID = cLng(Request.QueryString("FORUM_ID")) else Response.Redirect("default.asp") end if end if if Request.QueryString("CAT_ID") <> "" then if IsNumeric(Request.QueryString("CAT_ID")) = True then strRqCatID = cLng(Request.QueryString("CAT_ID")) else Response.Redirect("default.asp") end if end if if Request.QueryString("REPLY_ID") <> "" then if IsNumeric(Request.QueryString("REPLY_ID")) = True then strRqReplyID = cLng(Request.QueryString("REPLY_ID")) else Response.Redirect("default.asp") end if end if strCkPassWord = Request.Cookies(strUniqueID & "User")("Pword") if strSelectSize = "" or IsNull(strSelectSize) then strSelectSize = Request.Cookies(strUniqueID & "strSelectSize") end if if not(IsNull(strSelectSize)) and strSelectSize <> "" then if strSetCookieToForum = 1 then Response.Cookies(strUniqueID & "strSelectSize").Path = strCookieURL else Response.Cookies(strUniqueID & "strSelectSize").Path = "/" end if Response.Cookies(strUniqueID & "strSelectSize") = strSelectSize Response.Cookies(strUniqueID & "strSelectSize").expires = dateAdd("yyyy", 1, strForumTimeAdjust) end if %> <% ' See the VB6 project that accompanies this sample for full code comments on how ' it works. ' ' ASP VBScript code for generating a SHA256 'digest' or 'signature' of a string. The ' MD5 algorithm is one of the industry standard methods for generating digital ' signatures. It is generically known as a digest, digital signature, one-way ' encryption, hash or checksum algorithm. A common use for SHA256 is for password ' encryption as it is one-way in nature, that does not mean that your passwords ' are not free from a dictionary attack. ' ' If you are using the routine for passwords, you can make it a little more secure ' by concatenating some known random characters to the password before you generate ' the signature and on subsequent tests, so even if a hacker knows you are using ' SHA-256 for your passwords, the random characters will make it harder to dictionary ' attack. ' ' NOTE: Due to the way in which the string is processed the routine assumes a ' single byte character set. VB passes unicode (2-byte) character strings, the ' ConvertToWordArray function uses on the first byte for each character. This ' has been done this way for ease of use, to make the routine truely portable ' you could accept a byte array instead, it would then be up to the calling ' routine to make sure that the byte array is generated from their string in ' a manner consistent with the string type. ' ' This is 'free' software with the following restrictions: ' ' You may not redistribute this code as a 'sample' or 'demo'. However, you are free ' to use the source code in your own code, but you may not claim that you created ' the sample code. It is expressly forbidden to sell or profit from this source code ' other than by the knowledge gained or the enhanced value added by your own code. ' ' Use of this software is also done so at your own risk. The code is supplied as ' is without warranty or guarantee of any kind. ' ' Should you wish to commission some derivative work based on this code provided ' here, or any consultancy work, please do not hesitate to contact us. ' ' Web Site: http://www.frez.co.uk ' E-mail: sales@frez.co.uk Private m_lOnBits(30) Private m_l2Power(30) Private K(63) Private Const BITS_TO_A_BYTE = 8 Private Const BYTES_TO_A_WORD = 4 Private Const BITS_TO_A_WORD = 32 m_lOnBits(0) = CLng(1) m_lOnBits(1) = CLng(3) m_lOnBits(2) = CLng(7) m_lOnBits(3) = CLng(15) m_lOnBits(4) = CLng(31) m_lOnBits(5) = CLng(63) m_lOnBits(6) = CLng(127) m_lOnBits(7) = CLng(255) m_lOnBits(8) = CLng(511) m_lOnBits(9) = CLng(1023) m_lOnBits(10) = CLng(2047) m_lOnBits(11) = CLng(4095) m_lOnBits(12) = CLng(8191) m_lOnBits(13) = CLng(16383) m_lOnBits(14) = CLng(32767) m_lOnBits(15) = CLng(65535) m_lOnBits(16) = CLng(131071) m_lOnBits(17) = CLng(262143) m_lOnBits(18) = CLng(524287) m_lOnBits(19) = CLng(1048575) m_lOnBits(20) = CLng(2097151) m_lOnBits(21) = CLng(4194303) m_lOnBits(22) = CLng(8388607) m_lOnBits(23) = CLng(16777215) m_lOnBits(24) = CLng(33554431) m_lOnBits(25) = CLng(67108863) m_lOnBits(26) = CLng(134217727) m_lOnBits(27) = CLng(268435455) m_lOnBits(28) = CLng(536870911) m_lOnBits(29) = CLng(1073741823) m_lOnBits(30) = CLng(2147483647) m_l2Power(0) = CLng(1) m_l2Power(1) = CLng(2) m_l2Power(2) = CLng(4) m_l2Power(3) = CLng(8) m_l2Power(4) = CLng(16) m_l2Power(5) = CLng(32) m_l2Power(6) = CLng(64) m_l2Power(7) = CLng(128) m_l2Power(8) = CLng(256) m_l2Power(9) = CLng(512) m_l2Power(10) = CLng(1024) m_l2Power(11) = CLng(2048) m_l2Power(12) = CLng(4096) m_l2Power(13) = CLng(8192) m_l2Power(14) = CLng(16384) m_l2Power(15) = CLng(32768) m_l2Power(16) = CLng(65536) m_l2Power(17) = CLng(131072) m_l2Power(18) = CLng(262144) m_l2Power(19) = CLng(524288) m_l2Power(20) = CLng(1048576) m_l2Power(21) = CLng(2097152) m_l2Power(22) = CLng(4194304) m_l2Power(23) = CLng(8388608) m_l2Power(24) = CLng(16777216) m_l2Power(25) = CLng(33554432) m_l2Power(26) = CLng(67108864) m_l2Power(27) = CLng(134217728) m_l2Power(28) = CLng(268435456) m_l2Power(29) = CLng(536870912) m_l2Power(30) = CLng(1073741824) K(0) = &H428A2F98 K(1) = &H71374491 K(2) = &HB5C0FBCF K(3) = &HE9B5DBA5 K(4) = &H3956C25B K(5) = &H59F111F1 K(6) = &H923F82A4 K(7) = &HAB1C5ED5 K(8) = &HD807AA98 K(9) = &H12835B01 K(10) = &H243185BE K(11) = &H550C7DC3 K(12) = &H72BE5D74 K(13) = &H80DEB1FE K(14) = &H9BDC06A7 K(15) = &HC19BF174 K(16) = &HE49B69C1 K(17) = &HEFBE4786 K(18) = &HFC19DC6 K(19) = &H240CA1CC K(20) = &H2DE92C6F K(21) = &H4A7484AA K(22) = &H5CB0A9DC K(23) = &H76F988DA K(24) = &H983E5152 K(25) = &HA831C66D K(26) = &HB00327C8 K(27) = &HBF597FC7 K(28) = &HC6E00BF3 K(29) = &HD5A79147 K(30) = &H6CA6351 K(31) = &H14292967 K(32) = &H27B70A85 K(33) = &H2E1B2138 K(34) = &H4D2C6DFC K(35) = &H53380D13 K(36) = &H650A7354 K(37) = &H766A0ABB K(38) = &H81C2C92E K(39) = &H92722C85 K(40) = &HA2BFE8A1 K(41) = &HA81A664B K(42) = &HC24B8B70 K(43) = &HC76C51A3 K(44) = &HD192E819 K(45) = &HD6990624 K(46) = &HF40E3585 K(47) = &H106AA070 K(48) = &H19A4C116 K(49) = &H1E376C08 K(50) = &H2748774C K(51) = &H34B0BCB5 K(52) = &H391C0CB3 K(53) = &H4ED8AA4A K(54) = &H5B9CCA4F K(55) = &H682E6FF3 K(56) = &H748F82EE K(57) = &H78A5636F K(58) = &H84C87814 K(59) = &H8CC70208 K(60) = &H90BEFFFA K(61) = &HA4506CEB K(62) = &HBEF9A3F7 K(63) = &HC67178F2 Private Function LShift(lValue, iShiftBits) If iShiftBits = 0 Then LShift = lValue Exit Function ElseIf iShiftBits = 31 Then If lValue And 1 Then LShift = &H80000000 Else LShift = 0 End If Exit Function ElseIf iShiftBits < 0 Or iShiftBits > 31 Then Err.Raise 6 End If If (lValue And m_l2Power(31 - iShiftBits)) Then LShift = ((lValue And m_lOnBits(31 - (iShiftBits + 1))) * m_l2Power(iShiftBits)) Or &H80000000 Else LShift = ((lValue And m_lOnBits(31 - iShiftBits)) * m_l2Power(iShiftBits)) End If End Function Private Function RShift(lValue, iShiftBits) If iShiftBits = 0 Then RShift = lValue Exit Function ElseIf iShiftBits = 31 Then If lValue And &H80000000 Then RShift = 1 Else RShift = 0 End If Exit Function ElseIf iShiftBits < 0 Or iShiftBits > 31 Then Err.Raise 6 End If RShift = (lValue And &H7FFFFFFE) \ m_l2Power(iShiftBits) If (lValue And &H80000000) Then RShift = (RShift Or (&H40000000 \ m_l2Power(iShiftBits - 1))) End If End Function Private Function AddUnsigned(lX, lY) Dim lX4 Dim lY4 Dim lX8 Dim lY8 Dim lResult lX8 = lX And &H80000000 lY8 = lY And &H80000000 lX4 = lX And &H40000000 lY4 = lY And &H40000000 lResult = (lX And &H3FFFFFFF) + (lY And &H3FFFFFFF) If lX4 And lY4 Then lResult = lResult Xor &H80000000 Xor lX8 Xor lY8 ElseIf lX4 Or lY4 Then If lResult And &H40000000 Then lResult = lResult Xor &HC0000000 Xor lX8 Xor lY8 Else lResult = lResult Xor &H40000000 Xor lX8 Xor lY8 End If Else lResult = lResult Xor lX8 Xor lY8 End If AddUnsigned = lResult End Function Private Function Ch(x, y, z) Ch = ((x And y) Xor ((Not x) And z)) End Function Private Function Maj(x, y, z) Maj = ((x And y) Xor (x And z) Xor (y And z)) End Function Private Function S(x, n) S = (RShift(x, (n And m_lOnBits(4))) Or LShift(x, (32 - (n And m_lOnBits(4))))) End Function Private Function R(x, n) R = RShift(x, cLng(n And m_lOnBits(4))) End Function Private Function Sigma0(x) Sigma0 = (S(x, 2) Xor S(x, 13) Xor S(x, 22)) End Function Private Function Sigma1(x) Sigma1 = (S(x, 6) Xor S(x, 11) Xor S(x, 25)) End Function Private Function Gamma0(x) Gamma0 = (S(x, 7) Xor S(x, 18) Xor R(x, 3)) End Function Private Function Gamma1(x) Gamma1 = (S(x, 17) Xor S(x, 19) Xor R(x, 10)) End Function Private Function ConvertToWordArray(sMessage) Dim lMessageLength Dim lNumberOfWords Dim lWordArray() Dim lBytePosition Dim lByteCount Dim lWordCount Dim lByte Const MODULUS_BITS = 512 Const CONGRUENT_BITS = 448 lMessageLength = Len(sMessage) lNumberOfWords = (((lMessageLength + ((MODULUS_BITS - CONGRUENT_BITS) \ BITS_TO_A_BYTE)) \ (MODULUS_BITS \ BITS_TO_A_BYTE)) + 1) * (MODULUS_BITS \ BITS_TO_A_WORD) ReDim lWordArray(lNumberOfWords - 1) lBytePosition = 0 lByteCount = 0 Do Until lByteCount >= lMessageLength lWordCount = lByteCount \ BYTES_TO_A_WORD lBytePosition = (3 - (lByteCount Mod BYTES_TO_A_WORD)) * BITS_TO_A_BYTE lByte = AscB(Mid(sMessage, lByteCount + 1, 1)) lWordArray(lWordCount) = lWordArray(lWordCount) Or LShift(lByte, lBytePosition) lByteCount = lByteCount + 1 Loop lWordCount = lByteCount \ BYTES_TO_A_WORD lBytePosition = (3 - (lByteCount Mod BYTES_TO_A_WORD)) * BITS_TO_A_BYTE lWordArray(lWordCount) = lWordArray(lWordCount) Or LShift(&H80, lBytePosition) lWordArray(lNumberOfWords - 1) = LShift(lMessageLength, 3) lWordArray(lNumberOfWords - 2) = RShift(lMessageLength, 29) ConvertToWordArray = lWordArray End Function Public Function SHA256(sMessage) Dim HASH(7) Dim M Dim W(63) Dim a Dim b Dim c Dim d Dim e Dim f Dim g Dim h Dim i Dim j Dim T1 Dim T2 HASH(0) = &H6A09E667 HASH(1) = &HBB67AE85 HASH(2) = &H3C6EF372 HASH(3) = &HA54FF53A HASH(4) = &H510E527F HASH(5) = &H9B05688C HASH(6) = &H1F83D9AB HASH(7) = &H5BE0CD19 M = ConvertToWordArray(sMessage) For i = 0 To UBound(M) Step 16 a = HASH(0) b = HASH(1) c = HASH(2) d = HASH(3) e = HASH(4) f = HASH(5) g = HASH(6) h = HASH(7) For j = 0 To 63 If j < 16 Then W(j) = M(j + i) Else W(j) = AddUnsigned(AddUnsigned(AddUnsigned(Gamma1(W(j - 2)), W(j - 7)), Gamma0(W(j - 15))), W(j - 16)) End If T1 = AddUnsigned(AddUnsigned(AddUnsigned(AddUnsigned(h, Sigma1(e)), Ch(e, f, g)), K(j)), W(j)) T2 = AddUnsigned(Sigma0(a), Maj(a, b, c)) h = g g = f f = e e = AddUnsigned(d, T1) d = c c = b b = a a = AddUnsigned(T1, T2) Next HASH(0) = AddUnsigned(a, HASH(0)) HASH(1) = AddUnsigned(b, HASH(1)) HASH(2) = AddUnsigned(c, HASH(2)) HASH(3) = AddUnsigned(d, HASH(3)) HASH(4) = AddUnsigned(e, HASH(4)) HASH(5) = AddUnsigned(f, HASH(5)) HASH(6) = AddUnsigned(g, HASH(6)) HASH(7) = AddUnsigned(h, HASH(7)) Next SHA256 = LCase(Right("00000000" & Hex(HASH(0)), 8) & Right("00000000" & Hex(HASH(1)), 8) & Right("00000000" & Hex(HASH(2)), 8) & Right("00000000" & Hex(HASH(3)), 8) & Right("00000000" & Hex(HASH(4)), 8) & Right("00000000" & Hex(HASH(5)), 8) & Right("00000000" & Hex(HASH(6)), 8) & Right("00000000" & Hex(HASH(7)), 8)) End Function %> <% '################################################################################# '## Snitz Forums 2000 v3.4.06 '################################################################################# '## Copyright (C) 2000-06 Michael Anderson, Pierre Gorissen, '## Huw Reddick and Richard Kinser '## '## This program is free software; you can redistribute it and/or '## modify it under the terms of the GNU General Public License '## as published by the Free Software Foundation; either version 2 '## of the License, or (at your option) any later version. '## '## All copyright notices regarding Snitz Forums 2000 '## must remain intact in the scripts and in the outputted HTML '## The "powered by" text/logo with a link back to '## http://forum.snitz.com in the footer of the pages MUST '## remain visible when the pages are viewed on the internet or intranet. '## '## This program is distributed in the hope that it will be useful, '## but WITHOUT ANY WARRANTY; without even the implied warranty of '## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the '## GNU General Public License for more details. '## '## You should have received a copy of the GNU General Public License '## along with this program; if not, write to the Free Software '## Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. '## '## Support can be obtained from our support forums at: '## http://forum.snitz.com '## '## Correspondence and Marketing Questions can be sent to: '## manderson@snitz.com '## '################################################################################# %> <% '################################################################################# '## Snitz Forums 2000 v3.4.06 '################################################################################# '## Copyright (C) 2000-06 Michael Anderson, Pierre Gorissen, '## Huw Reddick and Richard Kinser '## '## This program is free software; you can redistribute it and/or '## modify it under the terms of the GNU General Public License '## as published by the Free Software Foundation; either version 2 '## of the License, or (at your option) any later version. '## '## All copyright notices regarding Snitz Forums 2000 '## must remain intact in the scripts and in the outputted HTML '## The "powered by" text/logo with a link back to '## http://forum.snitz.com in the footer of the pages MUST '## remain visible when the pages are viewed on the internet or intranet. '## '## This program is distributed in the hope that it will be useful, '## but WITHOUT ANY WARRANTY; without even the implied warranty of '## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the '## GNU General Public License for more details. '## '## You should have received a copy of the GNU General Public License '## along with this program; if not, write to the Free Software '## Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. '## '## Support can be obtained from our support forums at: '## http://forum.snitz.com '## '## Correspondence and Marketing Questions can be sent to: '## manderson@snitz.com '## '################################################################################# %> <% '############################################## '## Post Formatting ## '############################################## function chkQuoteOk(fString) chkQuoteOk = not(InStr(1, fString, "'", 0) > 0) end function function ChkURLs(ByVal strToFormat, ByVal sPrefix, ByVal iType) Dim strArray Dim Counter ChkURLs = strToFormat if InStr(1, strToFormat, sPrefix) > 0 Then strArray = Split(strToFormat, sPrefix, -1) ChkURLs = strArray(0) for Counter = 1 To UBound(strArray) if ((strArray(Counter-1) = "" Or Len(strArray(Counter-1)) < 5) And strArray(Counter)<> "") then ChkURLs = ChkURLs & edit_hrefs(sPrefix & strArray(Counter), iType) elseif ((UCase(Right(strArray(Counter-1), 6)) <> "HREF=""") and _ (UCase(Right(strArray(Counter-1), 5)) <> "[IMG]") and _ (UCase(Right(strArray(Counter-1), 5)) <> "[URL]") and _ (UCase(Right(strArray(Counter-1), 6)) <> "[URL=""") and _ (UCase(Right(strArray(Counter-1), 6)) <> "FTP://") and _ (UCase(Right(strArray(Counter-1), 8)) <> "FILE:///") and _ (UCase(Right(strArray(Counter-1), 7)) <> "HTTP://") and _ (UCase(Right(strArray(Counter-1), 8)) <> "HTTPS://") and _ (UCase(Right(strArray(Counter-1), 5)) <> "SRC=""") and _ (UCase(Right(strArray(Counter-1), 1)) <> "-") and _ (UCase(Right(strArray(Counter-1), 1)) <> "=") and _ (strArray(Counter) <> "")) then ChkURLs = ChkURLs & edit_hrefs(sPrefix & strArray(Counter), iType) else ChkURLs = ChkURLs & sPrefix & strArray(Counter) end if next end if end function function ChkMail(ByVal strToFormat) Dim strArray Dim Counter if InStr(1, strToFormat, " ") > 0 Then strArray = Split(Replace(strToFormat, "
", "
", 1, -1, vbTextCompare), " ", -1) 'ChkMail = strArray(0) for Counter = 0 to UBound(strArray) If (InStr(strArray(Counter), "@") > 0) and _ not(InStr(UCase(strArray(Counter)), "MAILTO:") > 0) and _ not(InStr(UCase(strArray(Counter)), "FTP:") > 0) and _ not(InStr(UCase(strArray(Counter)), "[URL") > 0) then ChkMail = ChkMail & " " & edit_hrefs(strArray(counter), 4) else ChkMail = ChkMail & " " & strArray(counter) end if next ChkMail = Replace(ChkMail, "
", "
", 1, -1, vbTextCompare) else if (InStr(strToFormat, "@") > 0) and _ not(InStr(UCase(strToFormat), "MAILTO:") > 0) and _ not(InStr(UCase(strToFormat), "FTP:") > 0) and _ not(InStr(UCase(strToFormat), "[URL") > 0) then ChkMail = ChkMail & " " & edit_hrefs(strToFormat, 4) else ChkMail = strToFormat end if end if end function function FormatStr(fString) on Error resume next fString = Replace(fString, CHR(13), "") 'fString = Replace(fString, CHR(10) & CHR(10), "

") fString = Replace(fString, CHR(10), "
") if strBadWordFilter = 1 or strBadWordFilter = "1" then fString = ChkBadWords(fString) end if if strAllowForumCode = "1" then fString = ReplaceURLs(fString) fString = ReplaceCodeTags(fString) if strIMGInPosts = "1" then fString = ReplaceImageTags(fString) end if end if fString = ChkURLs(fString, "http://", 1) fString = ChkURLs(fString, "https://", 2) fString = ChkURLs(fString, "www.", 3) fString = ChkMail(fString) fString = ChkURLs(fString, "ftp://", 5) fString = ChkURLs(fString, "file:///", 6) if strIcons = "1" then fString = smile(fString) end if if strAllowForumCode = "1" then fString = extratags(fString) end if FormatStr = fString on Error goto 0 end function function doCode(fString, fOTag, fCTag, fROTag, fRCTag) fOTagPos = Instr(1, fString, fOTag, 1) fCTagPos = Instr(1, fString, fCTag, 1) while (fCTagPos > 0 and fOTagPos > 0) fString = replace(fString, fOTag, fROTag, 1, 1, 1) fString = replace(fString, fCTag, fRCTag, 1, 1, 1) fOTagPos = Instr(1, fString, fOTag, 1) fCTagPos = Instr(1, fString, fCTag, 1) wend doCode = fString end function function Smile(fString) fString = replace(fString, "[:(!]", getCurrentIcon(strIconSmileAngry,"","align=""middle""")) fString = replace(fString, "[B)]", getCurrentIcon(strIconSmileBlackeye,"","align=""middle""")) fString = replace(fString, "[xx(]", getCurrentIcon(strIconSmileDead,"","align=""middle""")) fString = replace(fString, "[XX(]", getCurrentIcon(strIconSmileDead,"","align=""middle""")) fString = replace(fString, "[:I]", getCurrentIcon(strIconSmileBlush,"","align=""middle""")) fString = replace(fString, "[:(]", getCurrentIcon(strIconSmileSad,"","align=""middle""")) fString = replace(fString, "[:o]", getCurrentIcon(strIconSmileShock,"","align=""middle""")) fString = replace(fString, "[:O]", getCurrentIcon(strIconSmileShock,"","align=""middle""")) fString = replace(fString, "[:0]", getCurrentIcon(strIconSmileShock,"","align=""middle""")) fString = replace(fString, "[|)]", getCurrentIcon(strIconSmileSleepy,"","align=""middle""")) fString = replace(fString, "[:)]", getCurrentIcon(strIconSmile,"","align=""middle""")) fString = replace(fString, "[:D]", getCurrentIcon(strIconSmileBig,"","align=""middle""")) fString = replace(fString, "[}:)]", getCurrentIcon(strIconSmileEvil,"","align=""middle""")) fString = replace(fString, "[:o)]", getCurrentIcon(strIconSmileClown,"","align=""middle""")) fString = replace(fString, "[:O)]", getCurrentIcon(strIconSmileClown,"","align=""middle""")) fString = replace(fString, "[:0)]", getCurrentIcon(strIconSmileClown,"","align=""middle""")) fString = replace(fString, "[8)]", getCurrentIcon(strIconSmileShy,"","align=""middle""")) fString = replace(fString, "[8D]", getCurrentIcon(strIconSmileCool,"","align=""middle""")) fString = replace(fString, "[:P]", getCurrentIcon(strIconSmileTongue,"","align=""middle""")) fString = replace(fString, "[:p]", getCurrentIcon(strIconSmileTongue,"","align=""middle""")) fString = replace(fString, "[;)]", getCurrentIcon(strIconSmileWink,"","align=""middle""")) fString = replace(fString, "[8]", getCurrentIcon(strIconSmile8ball,"","align=""middle""")) fString = replace(fString, "[?]", getCurrentIcon(strIconSmileQuestion,"","align=""middle""")) fString = replace(fString, "[^]", getCurrentIcon(strIconSmileApprove,"","align=""middle""")) fString = replace(fString, "[V]", getCurrentIcon(strIconSmileDisapprove,"","align=""middle""")) fString = replace(fString, "[v]", getCurrentIcon(strIconSmileDisapprove,"","align=""middle""")) fString = replace(fString, "[:X]", getCurrentIcon(strIconSmileKisses,"","align=""middle""")) fString = replace(fString, "[:x]", getCurrentIcon(strIconSmileKisses,"","align=""middle""")) Smile = fString end function function extratags(fString) fString = doCode(fString, "[spoiler]", "[/spoiler]", "", "") extratags = fString end function function chkBadWords(fString) if trim(Application(strCookieURL & "STRBADWORDWORDS")) = "" or trim(Application(strCookieURL & "STRBADWORDREPLACE")) = "" then txtBadWordWords = "" txtBadWordReplace = "" '## Forum_SQL - Get Badwords from DB strSqlb = "SELECT B_BADWORD, B_REPLACE " strSqlb = strSqlb & " FROM " & strFilterTablePrefix & "BADWORDS " if strDBType = "mysql" then strSqlb = strSqlb & "ORDER BY LENGTH(B_BADWORD) DESC " else strSqlb = strSqlb & "ORDER BY LEN(B_BADWORD) DESC " end if set rsBadWord = Server.CreateObject("ADODB.Recordset") rsBadWord.open strSqlb, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText if rsBadWord.EOF then recBadWordCount = "" else allBadWordData = rsBadWord.GetRows(adGetRowsRest) recBadWordCount = UBound(allBadWordData,2) end if rsBadWord.close set rsBadWord = nothing if recBadWordCount <> "" then bBADWORD = 0 bREPLACE = 1 for iBadword = 0 to recBadWordCount BadWordWord = allBadWordData(bBADWORD,iBadWord) BadWordReplace = allBadWordData(bREPLACE,iBadWord) if txtBadWordWords = "" then txtBadWordWords = BadWordWord txtBadWordReplace = BadWordReplace else txtBadWordWords = txtBadWordWords & "," & BadWordWord txtBadWordReplace = txtBadWordReplace & "," & BadWordReplace end if next end if Application.Lock Application(strCookieURL & "STRBADWORDWORDS") = txtBadWordWords Application(strCookieURL & "STRBADWORDREPLACE") = txtBadWordReplace Application.UnLock end if txtBadWordWords = Application(strCookieURL & "STRBADWORDWORDS") txtBadWordReplace = Application(strCookieURL & "STRBADWORDREPLACE") if fString = "" or IsNull(fString) then fString = " " bwords = split(txtBadWordWords, ",") breplace = split(txtBadWordReplace, ",") for i = 0 to ubound(bwords) fString = Replace(fString, bwords(i), breplace(i), 1, -1, 1) next chkBadWords = fString end function function HTMLEncode(pString) fString = trim(pString) if fString = "" or IsNull(fString) then fString = " " else fString = replace(fString, ">", ">") fString = replace(fString, "<", "<") end if HTMLEncode = fString end function function HTMLDecode(pString) fString = trim(pString) if fString = "" then fString = " " else fString = replace(fString, ">", ">") fString = replace(fString, "<", "<") end if HTMLDecode = fString end function function chkString(pString,fField_Type) '## Types - name, password, title, message, url, urlpath, email, number, list fString = trim(pString) if fString = "" or isNull(fString) then fString = " " else ' chkBadWords(fString) end if Select Case lcase(fField_Type) Case "refer" fString = Replace(fString, "&#", "#") fString = Replace(fString, """", """) fString = HTMLEncode(fString) ChkString = fString exit function Case "archive" fString = Replace(fString, "'", "''") if strDBType = "mysql" then fString = Replace(fString, "\", "\\") end if chkString = fString exit function Case "displayimage" fString = Replace(fString, " ", "") fString = Replace(fString, """", "") fString = Replace(fString, "<", "") fString = Replace(fString, ">", "") chkString = fString exit function Case "pagetitle" if strBadWordFilter = "1" then fString = chkBadWords(fString) end if fString = Replace(fString,"\","\\") fString = Replace(fString,"'","\'") fString = HTMLDecode(fString) chkString = fString exit function Case "title" if strAllowHTML <> "1" then fString = HTMLEncode(fString) end if if strBadWordFilter = "1" then fString = chkBadWords(fString) end if chkString = fString exit function Case "password" fString = trim(fString) chkString = fString Case "decode" fString = HTMLDecode(fString) chkString = fString exit function Case "urlpath" fString = Server.URLEncode(fString) chkString = fString exit function Case "sqlstring" fString = Replace(fString, "'", "''") if strDBType = "mysql" then fString = Replace(fString, "\", "\\") end if fString = HTMLEncode(fString) chkString = fString exit function Case "jsurlpath" fString = Replace(fString, "'", "\'") fString = Server.URLEncode(fString) chkString = fString exit function Case "edit" if strAllowHTML <> "1" then fString = HTMLEncode(fString) end if fString = Replace(fString, """", """) ChkString = fString exit function Case "admindisplay" if strAllowHTML <> "1" then fString = HTMLEncode(fString) end if chkString = fString exit function Case "display" if strAllowHTML <> "1" then fString = HTMLEncode(fString) end if if strBadWordFilter = "1" then fString = ChkBadWords(fString) end if fString = replace(fString,"+","+") fString = replace(fString, """", """) chkString = fString exit function Case "search" if strAllowHTML <> "1" then fString = HTMLEncode(fString) end if if strBadWordFilter = "1" then fString = ChkBadWords(fString) end if fString = Replace(fString, """", """) chkString = fString exit function Case "message" if strBadWordFilter = "1" then fString = ChkBadWords(fString) end if fString = Replace(fString,"&#","#") if strDBType = "mysql" then fString = Replace(fString, "\", "\\") end if if strAllowHTML <> "1" then fString = HTMLEncode(fString) end if Case "preview" if strBadWordFilter = "1" then fString = ChkBadWords(fString) end if if strAllowHTML <> "1" then fString = HTMLEncode(fString) end if Case "hidden" fString = HTMLEncode(fString) End Select if fField_Type <> "signature" and fField_Type <> "title" then fString = doCode(fString, "[quote]", "[/quote]", "
quote:
", "
") end if if strAllowForumCode = "1" and fField_Type <> "signature" then fString = doCode(fString, "[b]", "[/b]", "", "") fString = doCode(fString, "[s]", "[/s]", "", "") fString = doCode(fString, "[strike]", "[/strike]", "", "") fString = doCode(fString, "[u]", "[/u]", "", "") fString = doCode(fString, "[i]", "[/i]", "", "") if fField_Type <> "title" then fString = doCode(fString, "[font=Andale Mono]", "[/font=Andale Mono]", "", "") fString = doCode(fString, "[font=Arial]", "[/font=Arial]", "", "") fString = doCode(fString, "[font=Arial Black]", "[/font=Arial Black]", "", "") fString = doCode(fString, "[font=Book Antiqua]", "[/font=Book Antiqua]", "", "") fString = doCode(fString, "[font=Century Gothic]", "[/font=Century Gothic]", "", "") fString = doCode(fString, "[font=Courier New]", "[/font=Courier New]", "", "") fString = doCode(fString, "[font=Comic Sans MS]", "[/font=Comic Sans MS]", "", "") fString = doCode(fString, "[font=Georgia]", "[/font=Georgia]", "", "") fString = doCode(fString, "[font=Impact]", "[/font=Impact]", "", "") fString = doCode(fString, "[font=Tahoma]", "[/font=Tahoma]", "", "") fString = doCode(fString, "[font=Times New Roman]", "[/font=Times New Roman]", "", "") fString = doCode(fString, "[font=Trebuchet MS]", "[/font=Trebuchet MS]", "", "") fString = doCode(fString, "[font=Script MT Bold]", "[/font=Script MT Bold]", "", "") fString = doCode(fString, "[font=Stencil]", "[/font=Stencil]", "", "") fString = doCode(fString, "[font=Verdana]", "[/font=Verdana]", "", "") fString = doCode(fString, "[font=Lucida Console]", "[/font=Lucida Console]", "", "") fString = doCode(fString, "[red]", "[/red]", "", "") fString = doCode(fString, "[green]", "[/green]", "", "") fString = doCode(fString, "[blue]", "[/blue]", "", "") fString = doCode(fString, "[white]", "[/white]", "", "") fString = doCode(fString, "[purple]", "[/purple]", "", "") fString = doCode(fString, "[yellow]", "[/yellow]", "", "") fString = doCode(fString, "[violet]", "[/violet]", "", "") fString = doCode(fString, "[brown]", "[/brown]", "", "") fString = doCode(fString, "[black]", "[/black]", "", "") fString = doCode(fString, "[pink]", "[/pink]", "", "") fString = doCode(fString, "[orange]", "[/orange]", "", "") fString = doCode(fString, "[gold]", "[/gold]", "", "") fString = doCode(fString, "[beige]", "[/beige]", "", "") fString = doCode(fString, "[teal]", "[/teal]", "", "") fString = doCode(fString, "[navy]", "[/navy]", "", "") fString = doCode(fString, "[maroon]", "[/maroon]", "", "") fString = doCode(fString, "[limegreen]", "[/limegreen]", "", "") fString = doCode(fString, "[h1]", "[/h1]", "

", "

") fString = doCode(fString, "[h2]", "[/h2]", "

", "

") fString = doCode(fString, "[h3]", "[/h3]", "

", "

") fString = doCode(fString, "[h4]", "[/h4]", "

", "

") fString = doCode(fString, "[h5]", "[/h5]", "
", "
") fString = doCode(fString, "[h6]", "[/h6]", "
", "
") fString = doCode(fString, "[size=1]", "[/size=1]", "", "") fString = doCode(fString, "[size=2]", "[/size=2]", "", "") fString = doCode(fString, "[size=3]", "[/size=3]", "", "") fString = doCode(fString, "[size=4]", "[/size=4]", "", "") fString = doCode(fString, "[size=5]", "[/size=5]", "", "") fString = doCode(fString, "[size=6]", "[/size=6]", "", "") fString = doCode(fString, "[list]", "[/list]", "") fString = doCode(fString, "[list=1]", "[/list=1]", "
    ", "
") fString = doCode(fString, "[list=a]", "[/list=a]", "
    ", "
") fString = doCode(fString, "[*]", "[/*]", "
  • ", "
  • ") fString = doCode(fString, "[left]", "[/left]", "
    ", "
    ") fString = doCode(fString, "[center]", "[/center]", "
    ", "
    ") fString = doCode(fString, "[centre]", "[/centre]", "
    ", "
    ") fString = doCode(fString, "[right]", "[/right]", "
    ", "
    ") 'fString = doCode(fString, "[code]", "[/code]", "
    ", "
    ") fString = replace(fString, "[br]", "
    ", 1, -1, 1) fString = replace(fString, "[hr]", "
    ", 1, -1, 1) end if end if if fField_Type <> "hidden" and _ fField_Type <> "preview" then fString = Replace(fString, "'", "''") end if if fField_Type = "message" and strDBType = "mysql" then fString = Replace(fString, """", "\""") end if chkString = fString end function '############################################## '## Date Formatting ## '############################################## function doublenum(fNum) if fNum > 9 then doublenum = fNum else doublenum = "0" & fNum end if end function function chkDateFormat(strDateTime) chkDateFormat = isdate("" & Mid(strDateTime, 5,2) & "/" & Mid(strDateTime, 7,2) & "/" & Mid(strDateTime, 1,4) & " " & Mid(strDateTime, 9,2) & ":" & Mid(strDateTime, 11,2) & ":" & Mid(strDateTime, 13,2) & "") end function function StrToDate(strDateTime) if ChkDateFormat(strDateTime) then 'Testing for server format if strComp(Month("04/05/2002"),"4") = 0 then StrToDate = cdate("" & Mid(strDateTime, 5,2) & "/" & Mid(strDateTime, 7,2) & "/" & Mid(strDateTime, 1,4) & " " & Mid(strDateTime, 9,2) & ":" & Mid(strDateTime, 11,2) & ":" & Mid(strDateTime, 13,2) & "") else StrToDate = cdate("" & Mid(strDateTime, 7,2) & "/" & Mid(strDateTime, 5,2) & "/" & Mid(strDateTime, 1,4) & " " & Mid(strDateTime, 9,2) & ":" & Mid(strDateTime, 11,2) & ":" & Mid(strDateTime, 13,2) & "") end if else if strComp(Month("04/05/2002"),"4") = 0 then tmpDate = DatePart("m",strForumTimeAdjust) & "/" & DatePart("d",strForumTimeAdjust) & "/" & DatePart("yyyy",strForumTimeAdjust) & " " & DatePart("h",strForumTimeAdjust) & ":" & DatePart("n",strForumTimeAdjust) & ":" & DatePart("s",strForumTimeAdjust) else tmpDate = DatePart("d",strForumTimeAdjust) & "/" & DatePart("m",strForumTimeAdjust) & "/" & DatePart("yyyy",strForumTimeAdjust) & " " & DatePart("h",strForumTimeAdjust) & ":" & DatePart("n",strForumTimeAdjust) & ":" & DatePart("s",strForumTimeAdjust) end if StrToDate = tmpDate end if end function function oldStrToDate(strDateTime) if ChkDateFormat(strDateTime) then StrToDate = cdate("" & Mid(strDateTime, 5,2) & "/" & Mid(strDateTime, 7,2) & "/" & Mid(strDateTime, 1,4) & " " & Mid(strDateTime, 9,2) & ":" & Mid(strDateTime, 11,2) & ":" & Mid(strDateTime, 13,2) & "") else tmpDate = DatePart("m",strForumTimeAdjust) & "/" & DatePart("d",strForumTimeAdjust) & "/" & DatePart("yyyy",strForumTimeAdjust) & " " & DatePart("h",strForumTimeAdjust) & ":" & DatePart("n",strForumTimeAdjust) & ":" & DatePart("s",strForumTimeAdjust) StrToDate = "" & tmpDate end if end function function DateToStr(dtDateTime) if not isDate(dtDateTime) then dtDateTime = strToDate(dtDateTime) end if DateToStr = year(dtDateTime) & doublenum(Month(dtdateTime)) & doublenum(Day(dtdateTime)) & doublenum(Hour(dtdateTime)) & doublenum(Minute(dtdateTime)) & doublenum(Second(dtdateTime)) & "" end function function ReadLastHereDate(UserName) dim rs_date dim strSql if trim(UserName) = "" then ReadLastHereDate = DateToStr(DateAdd("d", -10, strForumTimeAdjust)) exit function end if '## Forum_SQL strSql = "SELECT M_LASTHEREDATE " strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS " strSql = strSql & " WHERE " & strDBNTSQLName & " = '" & ChkString(UserName, "SQLString") & "' " Set rs_date = Server.CreateObject("ADODB.Recordset") rs_date.open strSql, my_Conn if (rs_date.BOF and rs_date.EOF) then ReadLastHereDate = DateToStr(DateAdd("d",-10,strForumTimeAdjust)) else if rs_date("M_LASTHEREDATE") = "" or IsNull(rs_date("M_LASTHEREDATE")) then ReadLastHereDate = DateToStr(DateAdd("d",-10,strForumTimeAdjust)) else ReadLastHereDate = rs_date("M_LASTHEREDATE") end if end if rs_date.close set rs_date = nothing UpdateLastHereDate DateToStr(strForumTimeAdjust),UserName end function function UpdateLastHereDate(fTime,UserName) UserIPAddress = Request.ServerVariables("HTTP_X_FORWARDED_FOR") If UserIPAddress = "" Then UserIPAddress = Request.ServerVariables("REMOTE_ADDR") End If '## Forum_SQL - Do DB Update strSql = "UPDATE " & strMemberTablePrefix & "MEMBERS " strSql = strSql & " SET M_LASTHEREDATE = '" & fTime & "'" strSql = strSql & ", M_LAST_IP = '" & UserIPAddress & "'" strSql = strSql & " WHERE " & strDBNTSQLName & " = '" & ChkString(UserName, "SQLString") & "' " my_conn.Execute (strSql),,adCmdText + adExecuteNoRecords end function function chkDate(fDate,separator,fTime) if fDate = "" or isNull(fDate) then if fTime then chkTime(fDate) end if exit function end if select case strDateType case "dmy" chkDate = Mid(fDate,7,2) & "/" & _ Mid(fDate,5,2) & "/" & _ Mid(fDate,1,4) case "mdy" chkDate = Mid(fDate,5,2) & "/" & _ Mid(fDate,7,2) & "/" & _ Mid(fDate,1,4) case "ymd" chkDate = Mid(fDate,1,4) & "/" & _ Mid(fDate,5,2) & "/" & _ Mid(fDate,7,2) case "ydm" chkDate =Mid(fDate,1,4) & "/" & _ Mid(fDate,7,2) & "/" & _ Mid(fDate,5,2) case "dmmy" chkDate = Mid(fDate,7,2) & " " & _ Monthname(Mid(fDate,5,2),1) & " " & _ Mid(fDate,1,4) case "mmdy" chkDate = Monthname(Mid(fDate,5,2),1) & " " & _ Mid(fDate,7,2) & " " & _ Mid(fDate,1,4) case "ymmd" chkDate = Mid(fDate,1,4) & " " & _ Monthname(Mid(fDate,5,2),1) & " " & _ Mid(fDate,7,2) case "ydmm" chkDate = Mid(fDate,1,4) & " " & _ Mid(fDate,7,2) & " " & _ Monthname(Mid(fDate,5,2),1) case "dmmmy" chkDate = Mid(fDate,7,2) & " " & _ Monthname(Mid(fDate,5,2),0) & " " & _ Mid(fDate,1,4) case "mmmdy" chkDate = Monthname(Mid(fDate,5,2),0) & " " & _ Mid(fDate,7,2) & " " & _ Mid(fDate,1,4) case "ymmmd" chkDate = Mid(fDate,1,4) & " " & _ Monthname(Mid(fDate,5,2),0) & " " & _ Mid(fDate,7,2) case "ydmmm" chkDate = Mid(fDate,1,4) & " " & _ Mid(fDate,7,2) & " " & _ Monthname(Mid(fDate,5,2),0) case else chkDate = Mid(fDate,5,2) & "/" & _ Mid(fDate,7,2) & "/" & _ Mid(fDate,1,4) end select if fTime then chkDate = chkDate & separator & chkTime(fDate) end if end function function chkTime(fTime) if fTime = "" or isNull(fTime) then exit function end if if strTimeType = 12 then if cLng(Mid(fTime, 9,2)) > 12 then chkTime = ChkTime & " " & _ (cLng(Mid(fTime, 9,2)) -12) & ":" & _ Mid(fTime, 11,2) & ":" & _ Mid(fTime, 13,2) & " " & "PM" elseif cLng(Mid(fTime, 9,2)) = 12 then chkTime = ChkTime & " " & _ cLng(Mid(fTime, 9,2)) & ":" & _ Mid(fTime, 11,2) & ":" & _ Mid(fTime, 13,2) & " " & "PM" elseif cLng(Mid(fTime, 9,2)) = 0 then chkTime = ChkTime & " " & _ (cLng(Mid(fTime, 9,2)) +12) & ":" & _ Mid(fTime, 11,2) & ":" & _ Mid(fTime, 13,2) & " " & "AM" else chkTime = ChkTime & " " & _ Mid(fTime, 9,2) & ":" & _ Mid(fTime, 11,2) & ":" & _ Mid(fTime, 13,2) & " " & "AM" end if else ChkTime = ChkTime & " " & _ Mid(fTime, 9,2) & ":" & _ Mid(fTime, 11,2) & ":" & _ Mid(fTime, 13,2) end if end function function widenum(fNum) if fNum > 9 then widenum = "" else widenum = " " end if end function '############################################## '## Multi-Moderators ## '############################################## function chkForumModerator(fForum_ID, fMember_Name) '## Forum_SQL strSql = "SELECT mo.FORUM_ID " strSql = strSql & " FROM " & strTablePrefix & "MODERATOR mo, " & strMemberTablePrefix & "MEMBERS me " strSql = strSql & " WHERE mo.FORUM_ID = " & fForum_ID & " " strSql = strSql & " AND mo.MEMBER_ID = me.MEMBER_ID " strSql = strSql & " AND me." & strDBNTSQLName & " = '" & chkString(fMember_Name,"SQLString") & "'" set rsChk = Server.CreateObject("ADODB.Recordset") rsChk.open strSql, my_Conn if rsChk.bof or rsChk.eof then chkForumModerator = "0" else chkForumModerator = "1" end if rsChk.close set rsChk = nothing end function '############################################## '## NT Authentication ## '############################################## sub NTUser() dim strSql dim rs_chk if Session(strCookieURL & "username")="" then '## Forum_SQL strSql ="SELECT MEMBER_ID, M_LEVEL, M_PASSWORD, M_USERNAME, M_NAME " strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS " strSql = strSql & " WHERE M_USERNAME = '" & ChkString(Session(strCookieURL & "userid"), "SQLString") & "'" strSql = strSql & " AND M_STATUS = " & 1 Set rs_chk = Server.CreateObject("ADODB.Recordset") rs_chk.open strSql, my_Conn if rs_chk.BOF or rs_chk.EOF then strLoginStatus = 0 else Session(strCookieURL & "username") = rs_chk("M_NAME") if strSetCookieToForum = 1 then Response.Cookies(strUniqueID & "User").Path = strCookieURL end if Response.Cookies(strUniqueID & "User")("Name") = rs_chk("M_NAME") Response.Cookies(strUniqueID & "User")("Pword") = rs_chk("M_PASSWORD") 'Response.Cookies(strUniqueID & "User")("Cookies") = "" Response.Cookies(strUniqueID & "User").Expires = dateAdd("d", intCookieDuration, strForumTimeAdjust) Session(strCookieURL & "last_here_date") = ReadLastHereDate(Request.Form("Name")) if strAuthType = "nt" then Session(strCookieURL & "last_here_date") = ReadLastHereDate(Session(strCookieURL & "userID")) end if strLoginStatus = 1 mLev = cLng(chkUser(Session(strCookieURL & "userID"), Request.Cookies(strUniqueID & "User")("Pword"),-1)) if mLev = 4 then Session(strCookieURL & "Approval") = "15916941253" end if end if rs_chk.close set rs_chk = nothing end if end sub function chkAccountReg() dim strSql dim rs_chk '## Forum_SQL strSql ="SELECT M_LEVEL, M_USERNAME " strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS " strSql = strSql & " WHERE M_USERNAME = '" & ChkString(Session(strCookieURL & "userid"), "SQLString") & "'" strSql = strSql & " AND M_STATUS = " & 1 Set rs_chk = Server.CreateObject("ADODB.Recordset") rs_chk.open strSql, my_Conn if rs_chk.BOF or rs_chk.EOF then chkAccountReg = "0" else chkAccountReg = "1" end if rs_chk.close set rs_chk = nothing end function sub NTAuthenticate() dim strUser, strNTUser, checkNT strNTUser = Request.ServerVariables("AUTH_USER") strNTUser = replace(strNTUser, "\", "/") if Session(strCookieURL & "userid") = "" then strUser = Mid(strNTUser,(instr(1,strNTUser,"/")+1),len(strNTUser)) Session(strCookieURL & "userid") = strUser end if if strNTGroups="1" then strNTGroupsSTR = Session(strCookieURL & "strNTGroupsSTR") if Session(strCookieURL & "strNTGroupsSTR") = "" then Set strNTUserInfo = GetObject("WinNT://"+strNTUser) For Each strNTUserInfoGroup in strNTUserInfo.Groups strNTGroupsSTR=strNTGroupsSTR+", "+strNTUserInfoGroup.name NEXT Session(strCookieURL & "strNTGroupsSTR") = strNTGroupsSTR end if end if if strAutoLogon="1" then strNTUserFullName = Session(strCookieURL & "strNTUserFullName") if Session(strCookieURL & "strNTUserFullName") = "" then Set strNTUserInfo = GetObject("WinNT://"+strNTUser) strNTUserFullName=strNTUserInfo.FullName Session(strCookieURL & "strNTUserFullName") = strNTUserFullName end if end if end sub '############################################## '## Cookie functions and Subs ## '############################################## sub doCookies(fSavePassWord) if strSetCookieToForum = 1 then Response.Cookies(strUniqueID & "User").Path = strCookieURL else Response.Cookies(strUniqueID & "User").Path = "/" end if Response.Cookies(strUniqueID & "User")("Name") = strDBNTUserName Response.Cookies(strUniqueID & "User")("Pword") = strEncodedPassword 'Response.Cookies(strUniqueID & "User")("Cookies") = Request.Form("Cookies") if fSavePassWord = "true" then Response.Cookies(strUniqueID & "User").Expires = dateAdd("d", intCookieDuration, strForumTimeAdjust) end if Session(strCookieURL & "last_here_date") = ReadLastHereDate(strDBNTFUserName) end sub sub ClearCookies() if strSetCookieToForum = 1 then Response.Cookies(strUniqueID & "User").Path = strCookieURL else Response.Cookies(strUniqueID & "User").Path = "/" end if Response.Cookies(strUniqueID & "User") = "" Session(strCookieURL & "Approval") = "" Session.Abandon 'Response.Cookies(strUniqueID & "User").Expires = dateadd("d", -2, strForumTimeAdjust) end sub '############################################## '## Private Forums ## '############################################## function chkUser(fName, fPassword, fAuthor) dim rsCheck dim strSql '## Forum_SQL strSql = "SELECT MEMBER_ID, M_LEVEL, M_NAME, M_PASSWORD " strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS " strSql = strSql & " WHERE " & strDBNTSQLName & " = '" & ChkString(fName, "SQLString") & "' " if strAuthType="db" then strSql = strSql & " AND M_PASSWORD = '" & ChkString(fPassword, "SQLString") &"'" End If strSql = strSql & " AND M_STATUS = " & 1 Set rsCheck = my_Conn.Execute(strSql) if rsCheck.BOF or rsCheck.EOF or not(ChkQuoteOk(fName)) or not(ChkQuoteOk(fPassword)) then MemberID = -1 chkUser = 0 '## Invalid Password if strDBNTUserName <> "" and chkCookie = 1 then Call ClearCookies() strDBNTUserName = "" end if else MemberID = rsCheck("MEMBER_ID") strDBNTUserName = rsCheck("M_NAME") if (rsCheck("MEMBER_ID") & "" = fAuthor & "") and (cLng(rsCheck("M_LEVEL")) <> 3) then chkUser = 1 '## Author else select case cLng(rsCheck("M_LEVEL")) case 1 chkUser = 2 '## Normal User case 2 chkUser = 3 '## Moderator case 3 chkUser = 4 '## Admin case else chkUser = cLng(rsCheck("M_LEVEL")) end select end if end if rsCheck.close set rsCheck = nothing end function Function ReplaceURLs(ByVal strToFormat) Dim oTag, c1Tag, oTag2, c2Tag Dim roTag, rc1Tag, rc2Tag Dim oTagPos, c1TagPos, oTagPos2, c1TagPos2 Dim Counter Dim strArray, strArray2 Dim strFirstPart, strSecondPart oTag = "[url=""" c1Tag = """]" oTag2 = "[url]" c2Tag = "[/url]" roTag = "" rc2Tag = "" oTagPos = InStr(1, strToFormat, oTag, 1) 'Position of opening tag c1TagPos = InStr(1, strToFormat, c1Tag, 1) 'Position of closing tag 'if opening tag and closing tag is found... If (oTagpos > 0) And (c1TagPos > 0) Then 'Split string at the opening tag strArray = Split(strToFormat, oTag, -1, 1) 'Loop through array For Counter = 0 To UBound(strArray) 'if the closing tag is found in the string then... If (InStr(1, strArray(Counter), c1Tag, 1) > 0) Then 'split string at the closing tag... strArray2 = Split(strArray(Counter), c1Tag, -1, 1) strArray2(0) = replace(strArray2(0), """", " ") ' ## filter out " 'strArray2(0) = replace(strArray2(0), "&", " ", 1, -1, 1) ' ## filter out & 'strArray2(0) = replace(strArray2(0), "#", " ", 1, -1, 1) ' ## filter out # strArray2(0) = replace(strArray2(0), ";", " ", 1, -1, 1) ' ## filter out ; strArray2(0) = replace(strArray2(0), "+", " ", 1, -1, 1) ' ## filter out + strArray2(0) = replace(strArray2(0), "(", " ", 1, -1, 1) ' ## filter out ( strArray2(0) = replace(strArray2(0), ")", " ", 1, -1, 1) ' ## filter out ) 'strArray2(0) = replace(strArray2(0), "[", " ", 1, -1, 1) ' ## filter out [ 'strArray2(0) = replace(strArray2(0), "]", " ", 1, -1, 1) ' ## filter out ] 'strArray2(0) = replace(strArray2(0), "=", " ", 1, -1, 1) ' ## filter out = strArray2(0) = replace(strArray2(0), "*", " ", 1, -1, 1) ' ## filter out * strArray2(0) = replace(strArray2(0), "'", " ", 1, -1, 1) ' ## filter out ' strArray2(0) = replace(strArray2(0), ">", " ", 1, -1, 1) ' ## filter out > strArray2(0) = replace(strArray2(0), "<", " ", 1, -1, 1) ' ## filter out < strArray2(0) = replace(strArray2(0), vbTab, " ", 1, -1, 1) ' ## filter out Tabs strArray2(0) = replace(strArray2(0), "view-source", " ", 1, -1, 1) ' ## filter out view-source strArray2(0) = replace(strArray2(0), "javascript", " ", 1, -1, 1) ' ## filter out javascript strArray2(0) = replace(strArray2(0), "jscript", " ", 1, -1, 1) ' ## filter out jscript strArray2(0) = replace(strArray2(0), "vbscript", " ", 1, -1, 1) ' ## filter out vbscript 'if the closing url tag is found in the string and '[URL] is not found in the string then... If InStr(1, strArray2(1), c2Tag, 1) And _ Not InStr(1, UCase(strArray2(1)), "[URL]", 1) Then strFirstPart = Left(strArray2(1), InStr(1, strArray2(1), c2Tag, 1)-1) strSecondPart = Right(strArray2(1), (Len(strArray2(1)) - Instr(1, strArray2(1), c2Tag,1) - len(c2Tag)+1)) If strFirstPart <> "" Then If UCase(Left(strFirstPart, 5)) = "[IMG]" Then ReplaceURLs = ReplaceURLs & "" & strFirstPart & "" & strSecondPart ElseIf UCase(Left(strArray2(0), 7)) = "HTTP://" Then 'ReplaceURLs = ReplaceURLs & edit_hrefs(strArray2(0), 1) & strSecondPart ReplaceURLs = ReplaceURLs & roTag & strArray2(0) & rc1Tag & strFirstPart & rc2Tag & strSecondPart ElseIf UCase(Left(strArray2(0), 8)) = "HTTPS://" Then 'ReplaceURLs = ReplaceURLs & edit_hrefs(strArray2(0), 2) & strSecondPart ReplaceURLs = ReplaceURLs & roTag & strArray2(0) & rc1Tag & strFirstPart & rc2Tag & strSecondPart ElseIf UCase(Left(strArray2(0), 4)) = "WWW." Then 'ReplaceURLs = ReplaceURLs & edit_hrefs(strArray2(0), 3) & strSecondPart ReplaceURLs = ReplaceURLs & roTag & "http://" & strArray2(0) & rc1Tag & strFirstPart & rc2Tag & strSecondPart ElseIf UCase(Left(strArray2(0), 7)) = "MAILTO:" Then 'ReplaceURLs = ReplaceURLs & edit_hrefs(strArray2(0), 4) & strSecondPart ReplaceURLs = ReplaceURLs & roTag & strArray2(0) & rc1Tag & strFirstPart & rc2Tag & strSecondPart ElseIf UCase(Left(strArray2(0), 6)) = "FTP://" Then 'ReplaceURLs = ReplaceURLs & edit_hrefs(strArray2(0), 5) & strSecondPart ReplaceURLs = ReplaceURLs & roTag & strArray2(0) & rc1Tag & strFirstPart & rc2Tag & strSecondPart ElseIf InStr(strArray2(0), "@") > 0 Then 'ReplaceURLs = ReplaceURLs & edit_hrefs(strArray2(0), 4) & strSecondPart ReplaceURLs = ReplaceURLs & roTag & "mailto:" & strArray2(0) & rc1Tag & strFirstPart & rc2Tag & strSecondPart ElseIf UCase(Left(strArray2(0), 6)) = "FILE:///" Then ReplaceURLs = ReplaceURLs & roTag & strArray2(0) & rc1Tag & strFirstPart & rc2Tag & strSecondPart Else ReplaceURLs = ReplaceURLs & roTag & strArray2(0) & rc1Tag & strFirstPart & rc2Tag & strSecondPart End If Else If UCase(Left(strArray2(0), 7)) = "HTTP://" Then ReplaceURLs = ReplaceURLs & edit_hrefs(strArray2(0), 1) & strSecondPart 'ReplaceURLs = ReplaceURLs & roTag & strArray2(0) & rc1Tag & strFirstPart & rc2Tag & strSecondPart ElseIf UCase(Left(strArray2(0), 8)) = "HTTPS://" Then ReplaceURLs = ReplaceURLs & edit_hrefs(strArray2(0), 2) & strSecondPart 'ReplaceURLs = ReplaceURLs & roTag & strArray2(0) & rc1Tag & strFirstPart & rc2Tag & strSecondPart ElseIf UCase(Left(strArray2(0), 4)) = "WWW." Then ReplaceURLs = ReplaceURLs & edit_hrefs(strArray2(0), 3) & strSecondPart 'ReplaceURLs = ReplaceURLs & roTag & "http://" & strArray2(0) & rc1Tag & strFirstPart & rc2Tag & strSecondPart ElseIf UCase(Left(strArray2(0), 7)) = "MAILTO:" Then ReplaceURLs = ReplaceURLs & edit_hrefs(strArray2(0), 4) & strSecondPart 'ReplaceURLs = ReplaceURLs & roTag & strArray2(0) & rc1Tag & strFirstPart & rc2Tag & strSecondPart ElseIf UCase(Left(strArray2(0), 6)) = "FTP://" Then ReplaceURLs = ReplaceURLs & edit_hrefs(strArray2(0), 5) & strSecondPart 'ReplaceURLs = ReplaceURLs & roTag & strArray2(0) & rc1Tag & strFirstPart & rc2Tag & strSecondPart ElseIf InStr(strArray2(0), "@") > 0 Then ReplaceURLs = ReplaceURLs & edit_hrefs(strArray2(0), 4) & strSecondPart 'ReplaceURLs = ReplaceURLs & roTag & "mailto:" & strArray2(0) & rc1Tag & strFirstPart & rc2Tag & strSecondPart ElseIf UCase(Left(strArray2(0), 6)) = "FILE:///" Then ReplaceURLs = ReplaceURLs & roTag & strArray2(0) & rc1Tag & strArray2(0) & rc2Tag & strSecondPart Else ReplaceURLs = ReplaceURLs & roTag & strArray2(0) & rc1Tag & strArray2(0) & rc2Tag & strSecondPart End If End If Else ReplaceURLs = ReplaceURLs & roTag & strArray2(0) & rc1Tag & strArray2(0) & rc2Tag & strArray2(1) End If Else ReplaceURLs = ReplaceURLs & strArray(Counter) End If Next Else ReplaceURLs = strToFormat End If oTagPos2 = InStr(1, ReplaceURLs, oTag2, 1) c1TagPos2 = InStr(1, ReplaceURLs, c2Tag, 1) 'if opening tag and closing tag is found then... If (oTagpos2 > 0) And (c1TagPos2 > 0) Then 'split string at opening tag strArray = Split(ReplaceURLs, oTag2, -1, 1) ReplaceURLs = "" For Counter = 0 To Ubound(strArray) 'if closing url tag is found in string then... If InStr(1, strArray(Counter), c2Tag, 1) > 0 Then 'split string at closing url tag strArray2 = Split(strArray(Counter), c2Tag, -1, 1) strArray2(0) = replace(strArray2(0), """", " ") ' ## filter out " 'strArray2(0) = replace(strArray2(0), "&", " ", 1, -1, 1) ' ## filter out & 'strArray2(0) = replace(strArray2(0), "#", " ", 1, -1, 1) ' ## filter out # strArray2(0) = replace(strArray2(0), ";", " ", 1, -1, 1) ' ## filter out ; strArray2(0) = replace(strArray2(0), "+", " ", 1, -1, 1) ' ## filter out + strArray2(0) = replace(strArray2(0), "(", " ", 1, -1, 1) ' ## filter out ( strArray2(0) = replace(strArray2(0), ")", " ", 1, -1, 1) ' ## filter out ) 'strArray2(0) = replace(strArray2(0), "[", " ", 1, -1, 1) ' ## filter out [ 'strArray2(0) = replace(strArray2(0), "]", " ", 1, -1, 1) ' ## filter out ] 'strArray2(0) = replace(strArray2(0), "=", " ", 1, -1, 1) ' ## filter out = strArray2(0) = replace(strArray2(0), "*", " ", 1, -1, 1) ' ## filter out * strArray2(0) = replace(strArray2(0), "'", " ", 1, -1, 1) ' ## filter out ' strArray2(0) = replace(strArray2(0), ">", " ", 1, -1, 1) ' ## filter out > strArray2(0) = replace(strArray2(0), "<", " ", 1, -1, 1) ' ## filter out < strArray2(0) = replace(strArray2(0), vbTab, " ", 1, -1, 1) ' ## filter out Tabs strArray2(0) = replace(strArray2(0), "view-source", " ", 1, -1, 1) ' ## filter out view-source strArray2(0) = replace(strArray2(0), "javascript", " ", 1, -1, 1) ' ## filter out javascript strArray2(0) = replace(strArray2(0), "jscript", " ", 1, -1, 1) ' ## filter out jscript strArray2(0) = replace(strArray2(0), "vbscript", " ", 1, -1, 1) ' ## filter out vbscript If UCase(Left(strArray2(0), 7)) = "HTTP://" Then ReplaceURLs = ReplaceURLs & edit_hrefs(strArray2(0), 1) & strArray2(1) ElseIf UCase(Left(strArray2(0), 8)) = "HTTPS://" Then ReplaceURLs = ReplaceURLs & edit_hrefs(strArray2(0), 2) & strArray2(1) ElseIf UCase(Left(strArray2(0), 4)) = "WWW." Then ReplaceURLs = ReplaceURLs & edit_hrefs(strArray2(0), 3) & strArray2(1) ElseIf UCase(Left(strArray2(0), 7)) = "MAILTO:" Then 'ReplaceURLs = ReplaceURLs & edit_hrefs(strArray2(0), 4) & strArray2(1) ReplaceURLs = ReplaceURLs & roTag & strArray2(0) & rc1Tag & strArray2(0) & rc2Tag & strArray2(1) ElseIf UCase(Left(strArray2(0), 6)) = "FTP://" Then ReplaceURLs = ReplaceURLs & edit_hrefs(strArray2(0), 5) & strArray2(1) ElseIf InStr(strArray2(0), "@") > 0 Then ReplaceURLs = ReplaceURLs & edit_hrefs(strArray2(0), 4) & strArray2(1) ElseIf UCase(Left(strArray2(0), 6)) = "FILE:///" Then ReplaceURLs = ReplaceURLs & edit_hrefs(strArray2(0), 7) & strArray2(1) Else ReplaceURLs = ReplaceURLs & roTag & strArray2(0) & rc1Tag & strArray2(0) & rc2Tag & strArray2(1) End If Else ReplaceURLs = ReplaceURLs & strArray(Counter) End If Next End If End Function function isAllowedMember(fForum_ID,fMemberID) if fMemberID <> MemberID then isAllowedMember = OldisAllowedMember(fForum_ID,fMemberID) exit function end if if Session(strCookieURL & "AllowedForums" & MemberID) = "" or IsNull(Session(strCookieURL & "AllowedForums" & MemberID)) then strSql = "SELECT FORUM_ID FROM " & strTablePrefix & "ALLOWED_MEMBERS " strSql = strSql & " WHERE MEMBER_ID = " & cLng(fMemberID) Set rsAllowedMember = Server.CreateObject("ADODB.Recordset") rsAllowedMember.open strSql, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText if (rsAllowedMember.EOF or rsAllowedMember.BOF) then isAllowedMember2 = "-1" Session(strCookieURL & "AllowedForums" & MemberID) = isAllowedMember2 Session(strCookieURL & "AllowedForums" & MemberID) = isAllowedMember2 else arrAllowedForums = rsAllowedMember.GetRows(adGetRowsRest) For AllowCount = 0 to ubound(arrAllowedForums,2) ' Total Numer of Rows if AllowCount = 0 then isAllowedMember2 = arrAllowedForums(0,AllowCount) else isAllowedMember2 = isAllowedMember2 & "," & arrAllowedForums(0,AllowCount) end if next Session(strCookieURL & "AllowedForums" & MemberID) = isAllowedMember2 Session(strCookieURL & "AllowedForums" & MemberID) = isAllowedMember2 end if rsAllowedMember.close set rsAllowedMember = nothing end if if Session(strCookieURL & "AllowedForums" & MemberID) = "-1" then isAllowedMember = 0 elseif InStr("," & Session(strCookieURL & "AllowedForums" & MemberID) & ",","," & fForum_ID & ",") then isAllowedMember = 1 else isAllowedMember = 0 end if end function function OldisAllowedMember(fForum_ID,fMemberID) OldisAllowedMember = 0 strSql = "SELECT MEMBER_ID, FORUM_ID FROM " & strTablePrefix & "ALLOWED_MEMBERS " strSql = strSql & " WHERE FORUM_ID = " & cLng(fForum_ID) strSql = strSql & " AND MEMBER_ID = " & cLng(fMemberID) Set rsAllowedMember = Server.CreateObject("ADODB.Recordset") rsAllowedMember.open strSql, my_Conn if (rsAllowedMember.EOF or rsAllowedMember.BOF) then OldisAllowedMember = 0 rsAllowedMember.close set rsAllowedMember = nothing exit function else OldisAllowedMember = 1 rsAllowedMember.close set rsAllowedMember = nothing end if end function Function ReplaceImageTags(fString) Dim oTag, cTag Dim roTag, rcTag Dim oTagPos, cTagPos Dim nTagPos Dim counter1, counter2, counter3 Dim strUrlText Dim Tagcount Dim strTempString, strResultString TagCount = 6 Dim ImgTags(6,2,2) Dim strArray, strArray2 ImgTags(1,1,1) = "[img]" ImgTags(1,2,1) = "[/img]" ImgTags(1,1,2) = "" ImgTags(2,1,1) = "[image]" ImgTags(2,2,1) = "[/image]" ImgTags(2,1,2) = ImgTags(1,1,2) ImgTags(2,2,2) = ImgTags(1,2,2) ImgTags(3,1,1) = "[img=right]" ImgTags(3,2,1) = "[/img=right]" ImgTags(3,1,2) = "" ImgTags(4,1,1) = "[image=right]" ImgTags(4,2,1) = "[/image=right]" ImgTags(4,1,2) = ImgTags(3,1,2) ImgTags(4,2,2) = ImgTags(3,2,2) ImgTags(5,1,1) = "[img=left]" ImgTags(5,2,1) = "[/img=left]" ImgTags(5,1,2) = "" ImgTags(6,1,1) = "[image=left]" ImgTags(6,2,1) = "[/image=left]" ImgTags(6,1,2) = ImgTags(5,1,2) ImgTags(6,2,2) = ImgTags(5,2,2) strResultString = "" strTempString = fString for counter1 = 1 to TagCount oTag = ImgTags(counter1,1,1) roTag = ImgTags(counter1,1,2) cTag = ImgTags(counter1,2,1) rcTag = ImgTags(counter1,2,2) oTagPos = InStr(1, strTempString, oTag, 1) cTagPos = InStr(1, strTempString, cTag, 1) if (oTagPos > 0) and (cTagPos > oTagPos) then strArray = Split(strTempString, oTag, -1, 1) for counter2 = 0 to Ubound(strArray) if (Instr(1, strArray(counter2), cTag, 1) > 0) then strArray2 = split(strArray(counter2), cTag, -1, 1) strUrlText = trim(strArray2(0)) strUrlText = replace(strUrlText, """", " ") ' ## filter out " '## Added to exclude Javascript and other potentially hazardous characters strUrlText = replace(strUrlText, "&", " ", 1, -1, 1) ' ## filter out & strUrlText = replace(strUrlText, "#", " ", 1, -1, 1) ' ## filter out # strUrlText = replace(strUrlText, ";", " ", 1, -1, 1) ' ## filter out ; strUrlText = replace(strUrlText, "+", " ", 1, -1, 1) ' ## filter out + strUrlText = replace(strUrlText, "(", " ", 1, -1, 1) ' ## filter out ( strUrlText = replace(strUrlText, ")", " ", 1, -1, 1) ' ## filter out ) strUrlText = replace(strUrlText, "[", " ", 1, -1, 1) ' ## filter out [ strUrlText = replace(strUrlText, "]", " ", 1, -1, 1) ' ## filter out ] strUrlText = replace(strUrlText, "=", " ", 1, -1, 1) ' ## filter out = strUrlText = replace(strUrlText, "*", " ", 1, -1, 1) ' ## filter out * strUrlText = replace(strUrlText, "'", " ", 1, -1, 1) ' ## filter out ' strUrlText = replace(strUrlText, vbTab, " ", 1, -1, 1) ' ## filter out Tabs strUrlText = replace(strUrlText, "view-source", " ", 1, -1, 1) ' ## filter out view-source strUrlText = replace(strUrlText, "javascript", " ", 1, -1, 1) ' ## filter out javascript strUrlText = replace(strUrlText, "jscript", " ", 1, -1, 1) ' ## filter out jscript strUrlText = replace(strUrlText, "vbscript", " ", 1, -1, 1) ' ## filter out vbscript strUrlText = replace(strUrlText, "mailto", " ", 1, -1, 1) ' ## filter out mailto '## End Added strUrlText = replace(strUrlText, "<", " ") ' ## filter out < strUrlText = replace(strUrlText, ">", " ") ' ## filter out > strResultString = strResultString & roTag & strUrlText & rcTag & strArray2(1) for counter3 = 2 to UBound(strArray2) strResultString = strResultString & strArray2(counter3) next else strResultString = strResultString & strArray(counter2) end if next strTempString = strResultString strResultString = "" end if next ReplaceImageTags = strTempString end function Function ReplaceCodeTags(fString) Dim oTag, cTag Dim roTag, rcTag Dim oTagPos, cTagPos Dim nTagPos Dim counter1, counter2 Dim strCodeText Dim Tagcount Dim strTempString, strResultString TagCount = 1 Dim CodeTags(1,2,2) Dim strArray, strArray2 CodeTags(1,1,1) = "[code]" CodeTags(1,2,1) = "[/code]" CodeTags(1,1,2) = "
    "
     	CodeTags(1,2,2) = "
    " strResultString = "" strTempString = fString for counter1 = 1 to TagCount oTag = CodeTags(counter1,1,1) roTag = CodeTags(counter1,1,2) cTag = CodeTags(counter1,2,1) rcTag = CodeTags(counter1,2,2) oTagPos = InStr(1, strTempString, oTag, 1) cTagPos = InStr(1, strTempString, cTag, 1) if (oTagpos > 0) and (cTagPos > 0) then strArray = Split(strTempString, oTag, -1, 1) for counter2 = 0 to Ubound(strArray) if (Instr(1, strArray(counter2), cTag) > 0) then strArray2 = split(strArray(counter2), cTag, -1, 1) strCodeText = trim(strArray2(0)) strCodeText = replace(strCodeText, "
    ", vbNewLine) strResultString = strResultString & roTag & strCodeText & rcTag & strArray2(1) else strResultString = strResultString & strArray(counter2) end if next strTempString = strResultString strResultString = "" end if next ReplaceCodeTags = strTempString end function '############################################## '## Page Title ## '############################################## Function GetNewTitle(strTempScriptName) Dim StrTempScript Dim strNewTitle arrTempScript = Split(strTempScriptName, "/") strTempScript = arrTempScript(Ubound(arrTempScript)) strTempScript = lcase(strTempScript) Select Case strTempScript Case "topic.asp" strTempTopic = cLng(request.querystring("TOPIC_ID")) if strTempTopic <> 0 then strsql = "SELECT FORUM_ID, T_SUBJECT FROM " & strActivePrefix & "TOPICS WHERE TOPIC_ID=" & strTempTopic set ttopics = my_conn.execute(strsql) if ttopics.bof or ttopics.eof then GetNewTitle = strForumTitle set ttopics = nothing else if mLev = 4 then ForumChkSkipAllowed = 1 elseif mLev = 3 then if chkForumModerator(ttopics("FORUM_ID"), ChkString(strDBNTUserName, "decode")) = "1" then ForumChkSkipAllowed = 1 else ForumChkSkipAllowed = 0 end if else ForumChkSkipAllowed = 0 end if intShowTopicTitle = 1 if strPrivateForums = "1" and ForumChkSkipAllowed = 0 then if not(chkForumAccess(ttopics("FORUM_ID"),MemberID,false)) then intShowTopicTitle = 0 end if end if if intShowTopicTitle = 1 then strTempTopicTitle = " - " & chkString(ttopics("T_SUBJECT"),"display") set ttopics = nothing strNewTitle = strForumTitle & strTempTopicTitle end if else GetNewTitle = strForumTitle end if Case "forum.asp" strTempForum = cLng(request.querystring("FORUM_ID")) if strTempForum <> 0 then strsql = "SELECT F_SUBJECT FROM " & strTablePrefix & "FORUM WHERE FORUM_ID=" & strTempForum set tforums = my_conn.execute(strsql) if tforums.bof or tforums.eof then strNewTitle = strForumTitle set tforums = nothing else strTempForumTitle = chkString(tforums("F_SUBJECT"),"display") set tforums = nothing strNewTitle = strForumTitle & " - " & strTempForumTitle end if else strNewTitle = strForumTitle end if Case "members.asp" strNewTitle = strForumTitle & " - Members" Case "active.asp" strNewTitle = strForumTitle & " - Active Topics" Case "faq.asp" strNewTitle = strForumTitle & " - Frequently Asked Questions" Case "search.asp" strNewTitle = strForumTitle & " - Search" Case "pop_profile.asp" if request.querystring("mode") = "display" then strNewTitle = strForumTitle & " - View Profile" elseif request.querystring("mode") = "edit" then strNewTitle = strForumTitle & " - Edit Profile" else strNewTitle = strForumTitle & " - Profile" end if Case "register.asp" strNewTitle = strForumTitle & " - User Agreement and Registration" Case "down.asp" strNewTitle = strForumTitle & " is currently closed." Case "default.asp" strNewTitle = strForumTitle Case else strNewTitle = strForumTitle End Select GetNewTitle = strNewTitle End Function '## Function to limit the amount of records to retrieve from the database Function TopSQL(strSQL, lngRecords) if ucase(left(strSQL,7)) = "SELECT " then select case strDBType case "sqlserver" TopSQL = "SET ROWCOUNT " & lngRecords & vbNewLine & strSQL & vbNewLine & "SET ROWCOUNT 0" case "access" TopSQL = "SELECT TOP " & lngRecords & mid(strSQL,7) case "mysql" if instr(strSQL,";") > 0 then strSQL1 = Mid(strSQL, 1, Instr(strSQL, ";")-1) strSQL2 = Mid(strSQL, InstrRev(strSQL, ";")) TopSQL = strSQL1 & " LIMIT " & lngRecords & strSQL2 else TopSQL = strSQL & " LIMIT " & lngRecords end if end select else TopSQL = strSQL end if End Function Function sGetColspan(lIN, lOUT) if (strShowModerators = "1") then lOut = lOut + 1 if (mlev = "4" or mlev = "3") and (strShowModerators = "1") then lOut = lOut + 1 if (mlev = "4" or mlev = "3") and (strShowModerators <> "1") then lOut = lOut + 2 if lOut > lIn then sGetColspan = lIN else sGetColspan = lOUT end if End Function function dWStatus(strMsg) dWStatus = " onMouseOver=""(window.status='" & Replace(strMsg, "'", "\'") & "'); return true"" onMouseOut=""(window.status=''); return true""" end function function profileLink(fName, fID) if instr(fName,"img src=") > 0 then strExtraStuff = "" else strExtraStuff = " title=""View " & fName & "'s Profile""" & dWStatus("View " & fName & "'s Profile") end if if strUseExtendedProfile then strReturn = "" else strReturn = "" end if profileLink = strReturn & fName & "" end function function chkSelect(actualValue, thisValue) if isNumeric(actualValue) then actualValue = cLng(actualValue) if actualValue = thisValue then chkSelect = " selected" else chkSelect = "" end if end function function chkExist(actualValue) if trim(actualValue) <> "" then chkExist = actualValue else chkExist = "" end if end function function chkExistElse(actualValue, elseValue) if trim(actualValue) <> "" then chkExistElse = actualValue else chkExistElse = elseValue end if end function function chkRadio(actualValue, thisValue, boltf) if isNumeric(actualValue) then actualValue = cLng(actualValue) if actualValue = thisValue EQV boltf then chkRadio = " checked" else chkRadio = "" end if end function function chkCheckbox(actualValue, thisValue, boltf) if isNumeric(actualValue) then actualValue = cLng(actualValue) if actualValue = thisValue EQV boltf then chkCheckbox = " checked" else chkCheckbox = "" end if end function function InArray(strArray,strValue) if strArray <> "" and strArray <> "0" then if (instr("," & strArray & "," ,"," & strValue & ",") > 0) then InArray = True exit function end if end if InArray = False end function function oldInArray(strArray,strValue) if IsArray(strArray) then Dim Ix for Ix = 0 To UBound(strArray) if cLng(strArray(Ix)) = cLng(strValue) then oldInArray = True exit function end if next end if oldInArray = False end function Sub WriteFooter() %> <% '################################################################################# '## Snitz Forums 2000 v3.4.06 '################################################################################# '## Copyright (C) 2000-06 Michael Anderson, Pierre Gorissen, '## Huw Reddick and Richard Kinser '## '## This program is free software; you can redistribute it and/or '## modify it under the terms of the GNU General Public License '## as published by the Free Software Foundation; either version 2 '## of the License, or (at your option) any later version. '## '## All copyright notices regarding Snitz Forums 2000 '## must remain intact in the scripts and in the outputted HTML '## The "powered by" text/logo with a link back to '## http://forum.snitz.com in the footer of the pages MUST '## remain visible when the pages are viewed on the internet or intranet. '## '## This program is distributed in the hope that it will be useful, '## but WITHOUT ANY WARRANTY; without even the implied warranty of '## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the '## GNU General Public License for more details. '## '## You should have received a copy of the GNU General Public License '## along with this program; if not, write to the Free Software '## Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. '## '## Support can be obtained from our support forums at: '## http://forum.snitz.com '## '## Correspondence and Marketing Questions can be sent to: '## manderson@snitz.com '## '################################################################################# Response.Write " " & vbNewLine & _ " " & vbNewLine & _ "" & vbNewLine & _ "" & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "
    " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "
    " & strForumTitle & "© " & strCopyright & "" & getCurrentIcon(strIconGoUp,"Go To Top Of Page","align=""right""") & "
    " & vbNewLine & _ "
    " & vbNewLine & _ "" & vbNewLine & _ " " & vbNewLine if strShowTimer = "1" then Response.Write " " & vbNewLine end if Response.Write " " & vbNewline '## END - REMOVAL, MODIFICATION OR CIRCUMVENTING THIS CODE WILL VIOLATE THE SNITZ FORUMS 2000 LICENSE AGREEMENT Response.Write " " & vbNewLine & _ "
    " & chkString(replace(strTimerPhrase, "[TIMER]", abs(round(StopTimer(1), 2)), 1, -1, 1),"display") & "" '## START - REMOVAL, MODIFICATION OR CIRCUMVENTING THIS CODE WILL VIOLATE THE SNITZ FORUMS 2000 LICENSE AGREEMENT Response.Write "" if strShowImagePoweredBy = "1" then Response.Write getCurrentIcon("logo_powered_by.gif||","Powered By: " & strVersion,"") else Response.Write "Snitz Forums 2000" end if Response.Write "
    " & vbNewLine & _ "" & vbNewLine & _ "" & vbNewLine my_Conn.Close set my_Conn = nothing %> <% end sub Sub WriteFooterShort() %> <% '################################################################################# '## Snitz Forums 2000 v3.4.06 '################################################################################# '## Copyright (C) 2000-06 Michael Anderson, Pierre Gorissen, '## Huw Reddick and Richard Kinser '## '## This program is free software; you can redistribute it and/or '## modify it under the terms of the GNU General Public License '## as published by the Free Software Foundation; either version 2 '## of the License, or (at your option) any later version. '## '## All copyright notices regarding Snitz Forums 2000 '## must remain intact in the scripts and in the outputted HTML '## The "powered by" text/logo with a link back to '## http://forum.snitz.com in the footer of the pages MUST '## remain visible when the pages are viewed on the internet or intranet. '## '## This program is distributed in the hope that it will be useful, '## but WITHOUT ANY WARRANTY; without even the implied warranty of '## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the '## GNU General Public License for more details. '## '## You should have received a copy of the GNU General Public License '## along with this program; if not, write to the Free Software '## Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. '## '## Support can be obtained from our support forums at: '## http://forum.snitz.com '## '## Correspondence and Marketing Questions can be sent to: '## manderson@snitz.com '## '################################################################################# Response.Write "

    Close Window

    " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "" & vbNewLine & _ "" & vbNewLine & _ "" & vbNewLine my_Conn.Close set my_Conn = nothing %> <% end sub %> <% if strShowTimer = "1" then '### start of timer code Dim StopWatch(19) sub StartTimer(x) StopWatch(x) = timer end sub function StopTimer(x) EndTime = Timer 'Watch for the midnight wraparound... if EndTime < StopWatch(x) then EndTime = EndTime + (86400) end if StopTimer = EndTime - StopWatch(x) end function StartTimer 1 '### end of timer code end if strArchiveTablePrefix = strTablePrefix & "A_" strScriptName = request.servervariables("script_name") strReferer = chkString(request.servervariables("HTTP_REFERER"),"refer") if Application(strCookieURL & "down") then if not Instr(strScriptName,"admin_") > 0 then Response.redirect("down.asp") end if end if if strPageBGImageURL = "" then strTmpPageBGImageURL = "" elseif Instr(strPageBGImageURL,"/") > 0 or Instr(strPageBGImageURL,"\") > 0 then strTmpPageBGImageURL = " background=""" & strPageBGImageURL & """" else strTmpPageBGImageURL = " background=""" & strImageUrl & strPageBGImageURL & """" end if If strDBType = "" then Response.Write "" & vbNewLine & _ "" & vbNewline & _ "" & strForumTitle & "" & vbNewline '## START - REMOVAL, MODIFICATION OR CIRCUMVENTING THIS CODE WILL VIOLATE THE SNITZ FORUMS 2000 LICENSE AGREEMENT Response.Write "" & vbNewline '## END - REMOVAL, MODIFICATION OR CIRCUMVENTING THIS CODE WILL VIOLATE THE SNITZ FORUMS 2000 LICENSE AGREEMENT Response.Write "" & vbNewLine & _ "" & vbNewLine & _ "" & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "

    " & _ "There has been a problem...

    " & _ "Your strDBType is not set, please edit your config.asp
    to reflect your database type." & _ "

    " & _ "Click here to retry.
    " & vbNewLine & _ "" & vbNewLine & _ "" & vbNewLine Response.End end if set my_Conn = Server.CreateObject("ADODB.Connection") my_Conn.Open strConnString if (strAuthType = "nt") then call NTauthenticate() if (ChkAccountReg() = "1") then call NTUser() end if end if if strGroupCategories = "1" then if Request.QueryString("Group") = "" then if Request.Cookies(strCookieURL & "GROUP") = "" Then Group = 2 else Group = cLng(Request.Cookies(strCookieURL & "GROUP")) end if else Group = cLng(Request.QueryString("Group")) end if 'set default Session(strCookieURL & "GROUP_ICON") = "icon_group_categories.gif" Session(strCookieURL & "GROUP_IMAGE") = strTitleImage 'Forum_SQL - Group exists ? strSql = "SELECT GROUP_ID, GROUP_NAME, GROUP_ICON, GROUP_IMAGE " strSql = strSql & " FROM " & strTablePrefix & "GROUP_NAMES " strSql = strSql & " WHERE GROUP_ID = " & Group set rs2 = my_Conn.Execute (strSql) if rs2.EOF or rs2.BOF then Group = 2 strSql = "SELECT GROUP_ID, GROUP_NAME, GROUP_ICON, GROUP_IMAGE " strSql = strSql & " FROM " & strTablePrefix & "GROUP_NAMES " strSql = strSql & " WHERE GROUP_ID = " & Group set rs2 = my_Conn.Execute (strSql) end if Session(strCookieURL & "GROUP_NAME") = rs2("GROUP_NAME") if instr(rs2("GROUP_ICON"), ".") then Session(strCookieURL & "GROUP_ICON") = rs2("GROUP_ICON") end if if instr(rs2("GROUP_IMAGE"), ".") then Session(strCookieURL & "GROUP_IMAGE") = rs2("GROUP_IMAGE") end if rs2.Close set rs2 = nothing Response.Cookies(strCookieURL & "GROUP") = Group Response.Cookies(strCookieURL & "GROUP").Expires = dateAdd("d", intCookieDuration, strForumTimeAdjust) if Session(strCookieURL & "GROUP_IMAGE") <> "" then strTitleImage = Session(strCookieURL & "GROUP_IMAGE") end if end if strDBNTUserName = Request.Cookies(strUniqueID & "User")("Name") strDBNTFUserName = trim(chkString(Request.Form("Name"),"SQLString")) if strDBNTFUserName = "" then strDBNTFUserName = trim(chkString(Request.Form("User"),"SQLString")) if strAuthType = "nt" then strDBNTUserName = Session(strCookieURL & "userID") strDBNTFUserName = Session(strCookieURL & "userID") end if if strRequireReg = "1" and strDBNTUserName = "" then if not Instr(strScriptName,"register.asp") > 0 and _ not Instr(strScriptName,"password.asp") > 0 and _ not Instr(strScriptName,"faq.asp") > 0 and _ not Instr(strScriptName,"login.asp") > 0 then scriptname = split(request.servervariables("SCRIPT_NAME"),"/") if Request.QueryString <> "" then Response.Redirect("login.asp?target=" & lcase(scriptname(ubound(scriptname))) & "?" & Request.QueryString) else Response.Redirect("login.asp?target=" & lcase(scriptname(ubound(scriptname)))) end if end if end if select case Request.Form("Method_Type") case "login" strEncodedPassword = sha256("" & Request.Form("Password")) select case chkUser(strDBNTFUserName, strEncodedPassword,-1) case 1, 2, 3, 4 Call DoCookies(Request.Form("SavePassword")) strLoginStatus = 1 case else strLoginStatus = 0 end select case "logout" Call ClearCookies() end select if trim(strDBNTUserName) <> "" and trim(Request.Cookies(strUniqueID & "User")("Pword")) <> "" then chkCookie = 1 mLev = cLng(chkUser(strDBNTUserName, Request.Cookies(strUniqueID & "User")("Pword"),-1)) chkCookie = 0 else MemberID = -1 mLev = 0 end if if mLev = 4 and strEmailVal = "1" and strRestrictReg = "1" and strEmail = "1" then '## Forum_SQL - Get membercount from DB strSql = "SELECT COUNT(MEMBER_ID) AS U_COUNT FROM " & strMemberTablePrefix & "MEMBERS_PENDING WHERE M_APPROVE = " & 0 set rs = Server.CreateObject("ADODB.Recordset") rs.open strSql, my_Conn if not rs.EOF then User_Count = cLng(rs("U_COUNT")) else User_Count = 0 end if rs.close set rs = nothing end if Response.Write "" & vbNewline & vbNewline & _ "" & vbNewline & _ "" & GetNewTitle(strScriptName) & "" & vbNewline '## START - REMOVAL, MODIFICATION OR CIRCUMVENTING THIS CODE WILL VIOLATE THE SNITZ FORUMS 2000 LICENSE AGREEMENT Response.Write "" & vbNewline '## END - REMOVAL, MODIFICATION OR CIRCUMVENTING THIS CODE WILL VIOLATE THE SNITZ FORUMS 2000 LICENSE AGREEMENT Response.Write "" & vbNewLine & _ "" & vbNewLine & _ "" & vbNewLine & _ vbNewLine & _ "" & vbNewLine & _ "" & vbNewLine & _ vbNewLine & _ "" & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "
    " & getCurrentIcon(strTitleImage & "||",strForumTitle,"") & "" & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine select case Request.Form("Method_Type") case "login" Response.Write "
    " & strForumTitle & "
    " & vbNewLine call sForumNavigation() Response.Write "
    " & vbNewLine & _ "
    " & vbNewLine if strLoginStatus = 0 then Response.Write "

    Your username and/or password were incorrect.

    " & vbNewLine & _ "

    Please either try again or register for an account.

    " & vbNewLine else Response.Write "

    You logged on successfully!

    " & vbNewLine & _ "

    Thank you for your participation.

    " & vbNewLine end if Response.Write "" & vbNewLine & _ "

    Back To Forum

    " & vbNewLine & _ "" & vbNewLine & _ " " & vbNewLine & _ "
    " & vbNewLine WriteFooter Response.End case "logout" Response.Write "
    " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "" & vbNewLine & _ "

    You logged out successfully!

    " & vbNewLine & _ "

    Thank you for your participation.

    " & vbNewLine & _ "" & vbNewLine & _ "

    Back To Forum

    " & vbNewLine & _ "" & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if else Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine if (mlev = 4) or (lcase(strNoCookies) = "1") then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if Response.Write " " & vbNewLine end if Response.Write "
    " & vbNewLine WriteFooter Response.End end select if (mlev = 0) then if not(Instr(Request.ServerVariables("Path_Info"), "register.asp") > 0) and _ not(Instr(Request.ServerVariables("Path_Info"), "pop_profile.asp") > 0) and _ not(Instr(Request.ServerVariables("Path_Info"), "search.asp") > 0) and _ not(Instr(Request.ServerVariables("Path_Info"), "login.asp") > 0) and _ not(Instr(Request.ServerVariables("Path_Info"), "password.asp") > 0) and _ not(Instr(Request.ServerVariables("Path_Info"), "faq.asp") > 0) and _ not(Instr(Request.ServerVariables("Path_Info"), "post.asp") > 0) then Response.Write "
    " & vbNewLine & _ " " & vbNewLine & _ "
    " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine if (strAuthType = "db") then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine else if (strAuthType = "nt") then Response.Write " " & vbNewLine end if end if Response.Write " " & vbNewLine if (lcase(strEmail) = "1") then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if Response.Write "
    Username:
    " & vbNewLine & _ "
    Password:
    " & vbNewLine & _ "
    " & vbNewLine if strGfxButtons = "1" then Response.Write " " & vbNewLine else Response.Write " " & vbNewLine end if Response.Write "
    " & vbNewLine & _ " Save PasswordPlease register to post in these Forums
    " & vbNewLine & _ " Forgot your " if strAuthType = "nt" then Response.Write("Admin ") Response.Write "Password?" & vbNewLine if (lcase(strNoCookies) = "1") then Response.Write " |" & vbNewLine & _ " Admin Options" & vbNewLine end if Response.Write "

    " & vbNewLine & _ "
    " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "
    You are logged on as
    " if strAuthType="nt" then Response.Write "" & Session(strCookieURL & "username") & " (" & Session(strCookieURL & "userid") & ")
     " else if strAuthType = "db" then Response.Write "" & profileLink(ChkString(strDBNTUserName, "display"),MemberID) & "" if strGfxButtons = "1" then Response.Write "" else Response.Write "" end if end if end if Response.Write "
    " & vbNewLine & _ "
    Admin Options" if mLev = 4 and (strEmailVal = "1" and strRestrictReg = "1" and strEmail = "1" and User_Count > 0) then Response.Write(" | (" & User_Count & ") Member(s) awaiting approval") Response.Write "

    " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "" & vbNewLine & _ "" & vbNewLine '########### GROUP Categories ########### %> <% '################################################################################# '## Snitz Forums 2000 v3.4.06 '################################################################################# '## Copyright (C) 2000-06 Michael Anderson, Pierre Gorissen, '## Huw Reddick and Richard Kinser '## '## This program is free software; you can redistribute it and/or '## modify it under the terms of the GNU General Public License '## as published by the Free Software Foundation; either version 2 '## of the License, or (at your option) any later version. '## '## All copyright notices regarding Snitz Forums 2000 '## must remain intact in the scripts and in the outputted HTML '## The "powered by" text/logo with a link back to '## http://forum.snitz.com in the footer of the pages MUST '## remain visible when the pages are viewed on the internet or intranet. '## '## This program is distributed in the hope that it will be useful, '## but WITHOUT ANY WARRANTY; without even the implied warranty of '## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the '## GNU General Public License for more details. '## '## You should have received a copy of the GNU General Public License '## along with this program; if not, write to the Free Software '## Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. '## '## Support can be obtained from our support forums at: '## http://forum.snitz.com '## '## Correspondence and Marketing Questions can be sent to: '## manderson@snitz.com '## '################################################################################# if strGroupCategories = "1" then strOK = "" Response.Write " " & vbNewLine ' where we are? strPathInfo = Request.ServerVariables("Path_Info") if lcase(Right(strPathInfo, 10)) = "active.asp" Then strOK = "OK" strLinkTo = "active.asp" elseif lcase(Right(strPathInfo, 11)) = "default.asp" then strOK = "OK" strLinkTo = "default.asp" else strOK = "" end if if StrOK="OK" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if end if %> <% '######## GROUP Categories ############## Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "
    " & vbNewLine & _ " Change Category Group
    " & vbNewLine & _ " " & vbNewLine & _ " Group Category Menu

    " & vbNewLine sub sForumNavigation() ' DEM --> Added code to show the subscription line if strSubscription > 0 and strEmail = "1" then if mlev > 0 then strSql = "SELECT COUNT(*) AS MySubCount FROM " & strTablePrefix & "SUBSCRIPTIONS" strSql = strSql & " WHERE MEMBER_ID = " & MemberID set rsCount = my_Conn.Execute (strSql) if rsCount.BOF or rsCount.EOF then ' No Subscriptions found, do nothing MySubCount = 0 rsCount.Close set rsCount = nothing else MySubCount = rsCount("MySubCount") rsCount.Close set rsCount = nothing end if if mLev = 4 then strSql = "SELECT COUNT(*) AS SubCount FROM " & strTablePrefix & "SUBSCRIPTIONS" set rsCount = my_Conn.Execute (strSql) if rsCount.BOF or rsCount.EOF then ' No Subscriptions found, do nothing SubCount = 0 rsCount.Close set rsCount = nothing else SubCount = rsCount("SubCount") rsCount.Close set rsCount = nothing end if end if else SubCount = 0 MySubCount = 0 end if else SubCount = 0 MySubCount = 0 end if Response.Write " Home" & vbNewline & _ " |" & vbNewline if strUseExtendedProfile then Response.Write " Profile" & vbNewline else Response.Write " Profile" & vbNewline end if if strAutoLogon <> "1" then if strProhibitNewMembers <> "1" then Response.Write " |" & vbNewline & _ " Register" & vbNewline end if end if Response.Write " |" & vbNewline & _ " Active Topics" & vbNewline ' DEM --> Start of code added to show subscriptions if they exist if (strSubscription > 0) then if mlev = 4 and SubCount > 0 then Response.Write " |" & vbNewline & _ " All Subscriptions" & vbNewline end if if MySubCount > 0 then Response.Write " |" & vbNewline & _ " My Subscriptions" & vbNewline end if end if ' DEM --> End of Code added to show subscriptions if they exist Response.Write " |" & vbNewline & _ " Members" & vbNewline & _ " |" & vbNewline & _ " "" then Response.Write("?FORUM_ID=" & cLng(Request.QueryString("FORUM_ID"))) Response.Write """" & dWStatus("Perform a search by keyword, date, and/or name...") & " tabindex=""-1"">Search" & vbNewline & _ " |" & vbNewline & _ " FAQ" end sub if strGroupCategories = "1" then if Session(strCookieURL & "GROUP_NAME") = "" then GROUPNAME = " Default Groups " else GROUPNAME = Session(strCookieURL & "GROUP_NAME") end if 'Forum_SQL - Get Groups strSql = "SELECT GROUP_ID, GROUP_CATID " strSql = strSql & " FROM " & strTablePrefix & "GROUPS " strSql = strSql & " WHERE GROUP_ID = " & Group set rsgroups = Server.CreateObject("ADODB.Recordset") rsgroups.Open strSql, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText if rsgroups.EOF then recGroupCatCount = "" else allGroupCatData = rsgroups.GetRows(adGetRowsRest) recGroupCatCount = UBound(allGroupCatData, 2) end if rsgroups.Close set rsgroups = nothing end if %> <% '################################################################################# '## Snitz Forums 2000 v3.4.06 '################################################################################# '## Copyright (C) 2000-06 Michael Anderson, Pierre Gorissen, '## Huw Reddick and Richard Kinser '## '## This program is free software; you can redistribute it and/or '## modify it under the terms of the GNU General Public License '## as published by the Free Software Foundation; either version 2 '## of the License, or (at your option) any later version. '## '## All copyright notices regarding Snitz Forums 2000 '## must remain intact in the scripts and in the outputted HTML '## The "powered by" text/logo with a link back to '## http://forum.snitz.com in the footer of the pages MUST '## remain visible when the pages are viewed on the internet or intranet. '## '## This program is distributed in the hope that it will be useful, '## but WITHOUT ANY WARRANTY; without even the implied warranty of '## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the '## GNU General Public License for more details. '## '## You should have received a copy of the GNU General Public License '## along with this program; if not, write to the Free Software '## Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. '## '## Support can be obtained from our support forums at: '## http://forum.snitz.com '## '## Correspondence and Marketing Questions can be sent to: '## manderson@snitz.com '## '################################################################################# sub ProcessSubscriptions (pMemberId, CatID, ForumId, TopicId, Moderation) ' DEM --> Added line to ignore the moderator/admin since they would be approving the post if ' ThisMemberId & MemberID are different.... ThisMemberID = MemberID ' -- If subscription is not allowed or e-mail is not turned on, exit if strSubscription = 0 or strEmail = 0 then exit sub end if StrSql = "SELECT C.CAT_SUBSCRIPTION, C.CAT_NAME, F.F_SUBJECT, F.F_SUBSCRIPTION, " & _ " T.T_SUBJECT, M.M_NAME " & _ " FROM " & strTablePrefix & "CATEGORY C, " & _ " " & strTablePrefix & "FORUM F, " & _ " " & strTablePrefix & "TOPICS T, " & _ " " & strMemberTablePrefix & "MEMBERS M " & _ " WHERE C.CAT_ID = " & CatID & " AND F.FORUM_ID = " & ForumID & _ " AND T.TOPIC_ID = " & TopicID & " AND M.MEMBER_ID = " & pMemberID Set rsSub = Server.CreateObject("ADODB.Recordset") rsSub.open strSql, my_Conn ' -- If No record is found, exit sub if RsSub.Eof or RsSub.BOF then rsSub.close set rsSub = nothing exit sub else ' Pull the data from the recordset allSubsData = rsSub.GetRows(adGetRowsRest) SubCnt = UBound(allSubsData,2) end if rsSub.close set rsSub = nothing CatSubscription = allSubsData(0, 0) CatName = allSubsData(1, 0) ForumName = allSubsData(2, 0) ForumSubscription = allSubsData(3, 0) TopicName = allSubsData(4, 0) MemberName = allSubsData(5, 0) ' -- If no subscriptions are allowed for the category or forum, exit sub if CatSubscription = 0 or ForumSubscription = 0 then exit sub end if ' -- Set highest subscription level to check for... ' strSubscription 1 = whole board, 2 = by category, 3 = by forum, 4 = by topic ' CatSubscription 1 = whole category, 2 = by forum, 3 = by topic ' ForumSubscription 1 = whole forum, 2 = by topic If strSubscription = 4 or CatSubscription = 3 or ForumSubscription = 2 then SubLevel = "TOPIC" Elseif strSubscription = 3 then SubLevel = "FORUM" ElseIf CatSubscription > 1 then SubLevel = "FORUM" Elseif StrSubscription > 1 then SubLevel = "CATEGORY" Else SubLevel = "ALL" End if '## Emails all users who wish to receive a mail if a topic or reply has been made. This sub will '## check for subscriptions based on the topic, forum, category and across the board. It will '## ignore the posting member. if Moderation <> "No" then strSql = "SELECT MOD_ID from " & strTablePrefix & "MODERATOR" Set modCheck = Server.CreateObject("ADODB.Recordset") modCheck.open strSql, my_Conn if modCheck.EOF or modCheck.BOF then strUniqueModID = "none" else strUniqueModID = modCheck("Mod_ID") end if modCheck.Close set modCheck = nothing else strUniqueModID = "none" end if strSql = "SELECT S.MEMBER_ID, S.CAT_ID, S.FORUM_ID, S.TOPIC_ID, M.M_NAME, M.M_EMAIL " & _ " FROM " & strTablePrefix & "SUBSCRIPTIONS S, " & strMemberTablePrefix & "MEMBERS M" if Moderation <> "No" and strUniqueModID <> "none" then strSql = strSql & ", " & strTablePrefix & "MODERATOR Mo" end if ' -- The author nor the Moderator need to get notification on this topic.... strSql = strSql & " WHERE S.MEMBER_ID <> " & pMemberID & _ " AND S.MEMBER_ID <> " & ThisMemberID & _ " AND M.MEMBER_ID = S.MEMBER_ID" & _ " AND M.M_STATUS <> 0" & _ " AND (S.TOPIC_ID = " & TopicId ' Topic specific subscriptions... ' -- Check for Subscriptions against the Forum if SubLevel <> "TOPIC" then StrSql = StrSql & " OR (S.CAT_ID = " & CatID & " AND S.FORUM_ID = " & ForumID & " AND S.TOPIC_ID = 0)" end if ' -- Check for Subscriptions against the Category if SubLevel = "CATEGORY" or SubLevel = "ALL" then StrSql = StrSql & " OR (S.CAT_ID = " & CatID & " AND S.FORUM_ID = 0 AND S.TOPIC_ID = 0)" end if ' -- Check for Subscriptions against the Board if SubLevel = "ALL" then StrSql = StrSql & " OR (S.CAT_ID = 0 AND S.FORUM_ID = 0 AND S.TOPIC_ID = 0)" end if strSql = strSql & ")" if Moderation <> "No" then StrSql = StrSql & " AND ((M.M_LEVEL = 3" if strUniqueModID = "none" then StrSql = StrSql & "))" else StrSql = StrSql & " AND Mo.MOD_ID = " & strUniqueModID & ") OR (M.M_LEVEL = 2 AND S.MEMBER_ID = Mo.MEMBER_ID AND Mo.FORUM_ID = " & ForumId & "))" end if end if set rsLoop = Server.CreateObject("ADODB.Recordset") : rsLoop.open strSql, my_Conn if rsLoop.EOF or rsLoop.BOF then rsLoop.close : set rsLoop = nothing : Exit Sub ' No subscriptions, exit.... else ' Pull the data from the recordset allLoopData = rsLoop.GetRows(adGetRowsRest) : LoopCount = UBound(allLoopData,2) rsLoop.close : set rsLoop = nothing for iSub = 0 to LoopCount LoopMemberID = allLoopData(0, iSub) LoopCatID = allLoopData(1, iSub) LoopForumID = allLoopData(2, iSub) LoopTopicID = allLoopData(3, iSub) LoopMemberName = allLoopData(4, iSub) LoopMemberEmail = allLoopData(5, iSub) if chkForumAccess(ForumID, LoopMemberID, false) <> FALSE then strRecipientsName = LoopMemberName strRecipients = LoopMemberEmail strMessage = "Hello " & LoopMemberName & vbNewline & vbNewline ' ## Send the appropriate message depending on the subscription. if LoopCatID > 0 then if LoopForumID > 0 then if LoopTopicID > 0 then strSubject = strForumTitle & " - Reply to a posting" strMessage = strMessage & MemberName & " has replied to a topic on " & strForumTitle & " that you requested notification to. " else strSubject = strForumTitle & " - New posting" strMessage = strMessage & MemberName & " has posted to the forum '" & ForumName & "' at " & strForumTitle & " that you requested notification on. " end if else strSubject = strForumTitle & " - New posting" strMessage = strMessage & MemberName & " has posted to the category '" & CatName & "' at " & StrForumTitle & " that you requested notification on. " end if else strSubject = strForumTitle & " - New posting" strMessage = strMessage & MemberName & " has posted to the " & strForumTitle & " board that you requested notification on. " end if strMessage = strMessage & "Regarding the subject - " & TopicName & "." & vbNewline & vbNewline strMessage = strMessage & "You can view the posting at " & strForumURL & "topic.asp?whichpage=-1&TOPIC_ID=" & TopicId & vbNewline %> <% '################################################################################# '## Snitz Forums 2000 v3.4.06 '################################################################################# '## Copyright (C) 2000-06 Michael Anderson, Pierre Gorissen, '## Huw Reddick and Richard Kinser '## '## This program is free software; you can redistribute it and/or '## modify it under the terms of the GNU General Public License '## as published by the Free Software Foundation; either version 2 '## of the License, or (at your option) any later version. '## '## All copyright notices regarding Snitz Forums 2000 '## must remain intact in the scripts and in the outputted HTML '## The "powered by" text/logo with a link back to '## http://forum.snitz.com in the footer of the pages MUST '## remain visible when the pages are viewed on the internet or intranet. '## '## This program is distributed in the hope that it will be useful, '## but WITHOUT ANY WARRANTY; without even the implied warranty of '## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the '## GNU General Public License for more details. '## '## You should have received a copy of the GNU General Public License '## along with this program; if not, write to the Free Software '## Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. '## '## Support can be obtained from our support forums at: '## http://forum.snitz.com '## '## Correspondence and Marketing Questions can be sent to: '## manderson@snitz.com '## '################################################################################# if trim(strFromName) = "" then strFromName = strForumTitle end if select case lcase(strMailMode) case "abmailer" Set objNewMail = Server.CreateObject("ABMailer.Mailman") objNewMail.ServerAddr = strMailServer objNewMail.FromName = strFromName objNewMail.FromAddress = strSender objNewMail.SendTo = strRecipients objNewMail.MailSubject = strSubject objNewMail.MailMessage = strMessage on error resume next '## Ignore Errors objNewMail.SendMail If Err <> 0 Then Err_Msg = Err_Msg & "
  • Your request was not sent due to the following error: " & Err.Description & "
  • " End if case "aspemail" Set objNewMail = Server.CreateObject("Persits.MailSender") objNewMail.FromName = strFromName objNewMail.From = strSender objNewMail.AddReplyTo strSender objNewMail.Host = strMailServer objNewMail.AddAddress strRecipients, strRecipientsName objNewMail.Subject = strSubject objNewMail.Body = strMessage on error resume next '## Ignore Errors objNewMail.Send If Err <> 0 Then Err_Msg = Err_Msg & "
  • Your request was not sent due to the following error: " & Err.Description & "
  • " End if case "aspmail" Set objNewMail = Server.CreateObject("SMTPsvg.Mailer") objNewMail.FromName = strFromName objNewMail.FromAddress = strSender 'objNewMail.AddReplyTo = strSender objNewMail.RemoteHost = strMailServer objNewMail.AddRecipient strRecipientsName, strRecipients objNewMail.Subject = strSubject objNewMail.BodyText = strMessage on error resume next '## Ignore Errors SendOk = objNewMail.SendMail If not(SendOk) <> 0 Then Err_Msg = Err_Msg & "
  • Your request was not sent due to the following error: " & objNewMail.Response & "
  • " End if case "aspqmail" Set objNewMail = Server.CreateObject("SMTPsvg.Mailer") objNewMail.QMessage = 1 objNewMail.FromName = strFromName objNewMail.FromAddress = strSender objNewMail.RemoteHost = strMailServer objNewMail.AddRecipient strRecipientsName, strRecipients objNewMail.Subject = strSubject objNewMail.BodyText = strMessage on error resume next '## Ignore Errors objNewMail.SendMail If Err <> 0 Then Err_Msg = Err_Msg & "
  • Your request was not sent due to the following error: " & Err.Description & "
  • " End if case "cdonts" Set objNewMail = Server.CreateObject ("CDONTS.NewMail") objNewMail.BodyFormat = 1 objNewMail.MailFormat = 0 on error resume next '## Ignore Errors objNewMail.Send strSender, strRecipients, strSubject, strMessage If Err <> 0 Then Err_Msg = Err_Msg & "
  • Your request was not sent due to the following error: " & Err.Description & "
  • " End if on error resume next '## Ignore Errors case "chilicdonts" Set objNewMail = Server.CreateObject ("CDONTS.NewMail") on error resume next '## Ignore Errors objNewMail.Host = strMailServer objNewMail.To = strRecipients objNewMail.From = strSender objNewMail.Subject = strSubject objNewMail.Body = strMessage objNewMail.Send If Err <> 0 Then Err_Msg = Err_Msg & "
  • Your request was not sent due to the following error: " & Err.Description & "
  • " End if on error resume next '## Ignore Errors case "cdosys" Set iConf = Server.CreateObject ("CDO.Configuration") Set Flds = iConf.Fields 'Set and update fields properties Flds("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2 'cdoSendUsingPort Flds("http://schemas.microsoft.com/cdo/configuration/smtpserver") = strMailServer 'Flds("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = cdoBasic 'Flds("http://schemas.microsoft.com/cdo/configuration/sendusername") = "username" 'Flds("http://schemas.microsoft.com/cdo/configuration/sendpassword") = "password" Flds.Update Set objNewMail = Server.CreateObject("CDO.Message") Set objNewMail.Configuration = iConf 'Format and send message Err.Clear objNewMail.To = strRecipients objNewMail.From = strSender objNewMail.Subject = strSubject objNewMail.TextBody = strMessage On Error Resume Next objNewMail.Send If Err <> 0 Then Err_Msg = Err_Msg & "
  • Your request was not sent due to the following error: " & Err.Description & "
  • " End if case "dkqmail" Set objNewMail = Server.CreateObject("dkQmail.Qmail") objNewMail.FromEmail = strSender objNewMail.ToEmail = strRecipients objNewMail.Subject = strSubject objNewMail.Body = strMessage objNewMail.CC = "" objNewMail.MessageType = "TEXT" on error resume next '## Ignore Errors objNewMail.SendMail() If Err <> 0 Then Err_Msg = Err_Msg & "
  • Your request was not sent due to the following error: " & Err.Description & "
  • " End if case "dundasmailq" set objNewMail = Server.CreateObject("Dundas.Mailer") objNewMail.QuickSend strSender, strRecipients, strSubject, strMessage on error resume next '##Ignore Errors If Err <> 0 Then Err_Msg = Err_Msg & "
  • Your request was not sent due to the following error: " & Err.Description & "
  • " End if case "dundasmails" set objNewMail = Server.CreateObject("Dundas.Mailer") objNewMail.TOs.Add strRecipients objNewMail.FromAddress = strSender objNewMail.Subject = strSubject objNewMail.Body = strMessage on error resume next '##Ignore Errors objNewMail.SendMail If Err <> 0 Then Err_Msg = Err_Msg & "
  • Your request was not sent due to the following error: " & Err.Description & "
  • " End if case "freemailsender" set objNewMail = Server.CreateObject("Innoveda.MailSender") NoLoginMethod=0 CramMD5Method=1 AuthLoginMethod=2 LoginPlainMethod=3 objNewMail.Username = "username" objNewMail.Password = "password" objNewMail.LoginMethod = NoLoginMethod objNewMail.FromName = strFromName objNewMail.From = strSender 'objNewMail.AddReplyTo strSender objNewMail.Host = strMailServer objNewMail.To = strRecipients 'objNewMail.CC = strSender objNewMail.Subject = strSubject objNewMail.Body = strMessage on error resume next '## Ignore Errors objNewMail.Send If Err <> 0 Then Err_Msg = Err_Msg & "
  • Your request was not sent due to the following error: " & Err.Description & "
  • " End if case "geocel" set objNewMail = Server.CreateObject("Geocel.Mailer") objNewMail.AddServer strMailServer, 25 objNewMail.AddRecipient strRecipients, strRecipientsName objNewMail.FromName = strFromName objNewMail.FromAddress = strFrom objNewMail.Subject = strSubject objNewMail.Body = strMessage on error resume next '## Ignore Errors objNewMail.Send() if Err <> 0 then Response.Write "Your request was not sent due to the following error: " & Err.Description else Response.Write "Your mail has been sent..." end if case "iismail" Set objNewMail = Server.CreateObject("iismail.iismail.1") MailServer = strMailServer objNewMail.Server = strMailServer objNewMail.addRecipient(strRecipients) objNewMail.From = strSender objNewMail.Subject = strSubject objNewMail.body = strMessage on error resume next '## Ignore Errors objNewMail.Send If Err <> 0 Then Err_Msg = Err_Msg & "
  • Your request was not sent due to the following error: " & Err.Description & "
  • " End if case "jmail" Set objNewMail = Server.CreateObject("Jmail.smtpmail") objNewMail.ServerAddress = strMailServer objNewMail.AddRecipient strRecipients objNewMail.Sender = strSender objNewMail.Subject = strSubject objNewMail.body = strMessage objNewMail.priority = 3 on error resume next '## Ignore Errors objNewMail.execute If Err <> 0 Then Err_Msg = Err_Msg & "
  • Your request was not sent due to the following error: " & Err.Description & "
  • " End if case "jmail4" Set objNewMail = Server.CreateObject("Jmail.Message") 'objNewMail.MailServerUserName = "myUserName" 'objNewMail.MailServerPassword = "MyPassword" objNewMail.From = strSender objNewMail.FromName = strFromName objNewMail.AddRecipient strRecipients, strRecipientsName objNewMail.Subject = strSubject objNewMail.Body = strMessage on error resume next '## Ignore Errors objNewMail.Send(strMailServer) If Err <> 0 Then Err_Msg = Err_Msg & "
  • Your request was not sent due to the following error: " & Err.Description & "
  • " End if case "mdaemon" Set gMDUser = Server.CreateObject("MDUserCom.MDUser") mbDllLoaded = gMDUser.LoadUserDll if mbDllLoaded = False then response.write "Could not load MDUSER.DLL! Program will exit." & "
    " else Set gMDMessageInfo = Server.CreateObject("MDUserCom.MDMessageInfo") gMDUser.InitMessageInfo gMDMessageInfo gMDMessageInfo.To = strRecipients gMDMessageInfo.From = strSender gMDMessageInfo.Subject = strSubject gMDMessageInfo.MessageBody = strMessage gMDMessageInfo.Priority = 0 gMDUser.SpoolMessage gMDMessageInfo mbDllLoaded = gMDUser.FreeUserDll end if if Err <> 0 Then Err_Msg = Err_Msg & "
  • Your request was not sent due to the following error: " & Err.Description & "
  • " end if case "ocxmail" Set objNewMail = Server.CreateObject("ASPMail.ASPMailCtrl.1") recipient = strRecipients sender = strSender subject = strSubject message = strMessage mailserver = strMailServer on error resume next '## Ignore Errors result = objNewMail.SendMail(mailserver, recipient, sender, subject, message) If Err <> 0 Then Err_Msg = Err_Msg & "
  • Your request was not sent due to the following error: " & Err.Description & "
  • " End if case "ocxqmail" Set objNewMail = Server.CreateObject("ocxQmail.ocxQmailCtrl.1") mailServer = strMailServer FromName = strFromName FromAddress = strSender priority = "" returnReceipt = "" toAddressList = strRecipients ccAddressList = "" bccAddressList = "" attachmentList = "" messageSubject = strSubject messageText = strMessage on error resume next '## Ignore Errors objNewMail.Q mailServer, _ fromName, _ fromAddress, _ priority, _ returnReceipt, _ toAddressList, _ ccAddressList, _ bccAddressList, _ attachmentList, _ messageSubject, _ messageText If Err <> 0 Then Err_Msg = Err_Msg & "
  • Your request was not sent due to the following error: " & Err.Description & "
  • " End if case "sasmtpmail" Set objNewMail = Server.CreateObject("SoftArtisans.SMTPMail") objNewMail.FromName = strFromName objNewMail.FromAddress = strSender objNewMail.AddRecipient strRecipientsName, strRecipients 'objNewMail.AddReplyTo strSender objNewMail.BodyText = strMessage objNewMail.organization = strForumTitle objNewMail.Subject = strSubject objNewMail.RemoteHost = strMailServer on error resume next SendOk = objNewMail.SendMail If not(SendOk) <> 0 Then Err_Msg = Err_Msg & "
  • Your request was not sent due to the following error: " & objNewMail.Response & "
  • " End if case "smtp" Set objNewMail = Server.CreateObject("SmtpMail.SmtpMail.1") objNewMail.MailServer = strMailServer objNewMail.Recipients = strRecipients objNewMail.Sender = strSender objNewMail.Subject = strSubject objNewMail.Message = strMessage on error resume next '## Ignore Errors objNewMail.SendMail2 If Err <> 0 Then Err_Msg = Err_Msg & "
  • Your request was not sent due to the following error: " & Err.Description & "
  • " End if case "vsemail" Set objNewMail = CreateObject("VSEmail.SMTPSendMail") objNewMail.Host = strMailServer objNewMail.From = strSender objNewMail.SendTo = strRecipients objNewMail.Subject = strSubject objNewMail.Body = strMessage on error resume next '## Ignore Errors objNewMail.Connect objNewMail.Send objNewMail.Disconnect If Err <> 0 Then Err_Msg = Err_Msg & "
  • Your request was not sent due to the following error: " & Err.Description & "
  • " End if end select Set objNewMail = Nothing on error goto 0 %> <% end if next end if end sub ' PullSubscriptions - will return a list of the subcriptions that exist for a member Function PullSubscriptions(sCatID, sForumID, sTopicID) ' -- if subscriptions or e-mail are not turned on, or the person is not logged in, exit... If strSubscription = "0" or lcase(strEmail) <> "1" or mlev = 0 then PullSubscriptions = "" : Exit Function End if ' -- declare the variables used in this function Dim BoardSubs, CatSubs, ForumSubs, TopicSubs, rsSub, SubCnt, allSubData, iSub Dim SubCatID, SubForumID, SubTopicID ' -- build the appropriate sql statement... subStrSQL = "SELECT CAT_ID, FORUM_ID, TOPIC_ID " & _ " FROM " & strTablePrefix & "SUBSCRIPTIONS" & _ " WHERE MEMBER_ID = " & MemberID ' GetCheck will return the correct SQL statement for the optional parameters.... subStrSQL = subStrSQL & GetCheck("CAT_ID", Clng(sCatID)) subStrSQL = subStrSQL & GetCheck("FORUM_ID", Clng(sForumID)) subStrSQL = subStrSQL & GetCheck("TOPIC_ID", Clng(sTopicID)) ' -- execute the sql statement... 'Response.Write substrSql 'Response.End Set rsSub = Server.CreateObject("ADODB.Recordset") rsSub.open subStrSQL, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText if rsSub.EOF or rsSub.BOF then ' If none found, exit SubCnt = "" PullSubscriptions = "" else ' Pull the data from the recordset allSubData = rsSub.GetRows(adGetRowsRest) SubCnt = UBound(allSubData,2) end if rsSub.Close set rsSub = Nothing if SubCnt = "" then ' If none found, exit PullSubscriptions = "" else BoardSubs = "N" CatSubs = 0 ForumSubs = 0 TopicSubs = 0 for iSub = 0 to SubCnt SubCatID = allSubData(0, iSub) SubForumID = allSubData(1, iSub) SubTopicID = allSubData(2, iSub) If SubCatID = 0 then BoardSubs = "Y" Elseif SubForumID = 0 then If CatSubs > "" then CatSubs = CatSubs & "," CatSubs = CatSubs & SubCatID Elseif SubTopicID = 0 then If ForumSubs > "" then ForumSubs = ForumSubs & "," ForumSubs = ForumSubs & SubForumID Else If TopicSubs > "" then TopicSubs = TopicSubs & "," TopicSubs = TopicSubs & SubTopicID End If next PullSubscriptions = BoardSubs & ";" & CatSubs & ";" & ForumSubs & ";" & TopicSubs end if End Function ' GetCheck standardizes the handling of optional parameters in PullSubscriptions Function GetCheck(ObjectName, ObjectID) If ObjectID > 0 then GetCheck = " AND " & ObjectName & " = " & ObjectID Elseif ObjectID = -99 then GetCheck = " AND " & ObjectName & " = 0" Else GetCheck = "" End If End Function ' Displays the appropriate link, icon and message(if appropriate) for subscriptions... Function ShowSubLink (SubOption, CatID, ForumID, TopicID, ShowText) Dim DefaultFont DefaultFont = "" ' -- Declare variables... Dim StandardLinkInfo, LinkText, LinkIcon, LinkLevel, LinkParam if Instr(Request.ServerVariables("SCRIPT_NAME"),"post.asp") then ' -- Only show the checkboxes on the post page... if SubOption = "S" then ShowSubLink = "Check here to subscribe to this topic." else ShowSubLink = "Check here to unsubscribe from this topic." end if else ' -- Standard Link StandardLinkInfo = "" & getCurrentIcon(LinkIcon, LinkText,"align=""absmiddle""" & dwStatus(LinkText)) & "" if ShowText <> "N" then ShowSubLink = ShowSubLink & " " & StandardLinkInfo & LinkLevel & LinkParam & "')""" & dwStatus(LinkText) & ">" & DefaultFont & LinkText & "" end if end if end function Response.Write " " & vbNewLine %> <% '################################################################################# '## Snitz Forums 2000 v3.4.06 '################################################################################# '## Copyright (C) 2000-06 Michael Anderson, Pierre Gorissen, '## Huw Reddick and Richard Kinser '## '## This program is free software; you can redistribute it and/or '## modify it under the terms of the GNU General Public License '## as published by the Free Software Foundation; either version 2 '## of the License, or (at your option) any later version. '## '## All copyright notices regarding Snitz Forums 2000 '## must remain intact in the scripts and in the outputted HTML '## The "powered by" text/logo with a link back to '## http://forum.snitz.com in the footer of the pages MUST '## remain visible when the pages are viewed on the internet or intranet. '## '## This program is distributed in the hope that it will be useful, '## but WITHOUT ANY WARRANTY; without even the implied warranty of '## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the '## GNU General Public License for more details. '## '## You should have received a copy of the GNU General Public License '## along with this program; if not, write to the Free Software '## Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. '## '## Support can be obtained from our support forums at: '## http://forum.snitz.com '## '## Correspondence and Marketing Questions can be sent to: '## manderson@snitz.com '## '################################################################################# function getMemberName(fUser_Number) dim strSql dim rsGetmemberName '## Forum_SQL if isNull(fUser_Number) then exit function strSql = "SELECT M_NAME " strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS " strSql = strSql & " WHERE MEMBER_ID = " & cLng(fUser_Number) set rsGetMemberName = Server.CreateObject("ADODB.Recordset") rsGetMemberName.open strSql, my_Conn if rsGetMemberName.EOF or rsGetMemberName.BOF then getMemberName = "" else getMemberName = chkString(rsGetMemberName("M_NAME"),"display") end if rsGetMemberName.close set rsGetMemberName = nothing end function function getMemberID(fUser_Name) dim strSql dim rsGetMemberID '## Forum_SQL strSql = "SELECT MEMBER_ID " strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS " strSql = strSql & " WHERE " & strDBNTSQLName & " = '" & ChkString(fUser_Name, "SQLString") & "'" set rsGetMemberID = Server.CreateObject("ADODB.Recordset") rsGetMemberID.open strSql, my_Conn if rsGetMemberID.EOF then getMemberID = 0 else getMemberID = cLng(rsGetMemberID("MEMBER_ID")) end if rsGetMemberID.close set rsGetMemberID = nothing end function function chkDisplayForum(fPrivateForums,fFPasswordNew,fForum_ID,UserNum) dim strSql dim rsAccess chkDisplayForum = false if (mLev = 4) or (mLev = 3 and ModerateAllowed = "Y") then chkDisplayForum = true exit function end if select case cLng(fPrivateForums) case 0, 1, 2, 3, 4, 7, 9 chkDisplayForum = true exit function case 5 if UserNum = -1 then chkDisplayForum = false exit function else chkDisplayForum = true exit function end if case 6 if UserNum = -1 then chkDisplayForum = false exit function end if if isAllowedMember(fForum_ID,UserNum) = 1 then chkDisplayForum = true else chkDisplayForum = false end if case 8 chkDisplayForum = false if strAuthType ="nt" THEN NTGroupSTR = Split(Session(strCookieURL & "strNTGroupsSTR"), ", ") for j = 0 to ubound(NTGroupSTR) NTGroupDBSTR = Split(fFPasswordNew, ", ") for i = 0 to ubound(NTGroupDBSTR) if NTGroupDBSTR(i) = NTGroupSTR(j) then chkDisplayForum = true exit function end if next next end if case else chkDisplayForum = true end select end function function chkForumAccess(fForum, UserNum, Display) if MemberID = UserNum then if mLev < 1 then chkForumAccess = false elseif mLev = 3 then chkForumAccess = true elseif mLev = 4 then chkForumAccess = true exit function end if end if '## Forum_SQL strSql = "SELECT F_PRIVATEFORUMS, F_SUBJECT, F_PASSWORD_NEW " strSql = strSql & " FROM " & strTablePrefix & "FORUM " strSql = strSql & " WHERE FORUM_ID = " & cLng(fForum) Set rsStatus = Server.CreateObject("ADODB.Recordset") rsStatus.open strSql, my_Conn if rsStatus.EOF or rsStatus.BOF then rsStatus.close set rsStatus = nothing Response.Redirect("default.asp") else dim Users dim MatchFound If rsStatus("F_PRIVATEFORUMS") <> 0 then Select case rsStatus("F_PRIVATEFORUMS") case 0 chkForumAccess = true case 1, 6 '## Allowed Users if isAllowedMember(fForum,UserNum) = 1 then chkForumAccess = true else if Display then doNotAllowed Response.end else chkForumAccess = false end if end if case 2 '## password select case Request.Cookies(strUniqueID & "Forum")("PRIVATE_" & rsStatus("F_SUBJECT")) case rsStatus("F_PASSWORD_NEW") chkForumAccess = true case else if Request("pass") = "" then if Display then doPasswordForm Response.End else chkForumAccess = false end if else if Request("pass") <> rsStatus("F_PASSWORD_NEW") then if Display then Response.Write "

    Invalid password!

    " & vbNewLine & _ "

    Go Back to Enter Data


    " & vbNewLine WriteFooter Response.End else chkForumAccess = false end if else if strSetCookieToForum = 1 then Response.Cookies(strUniqueID & "Forum").Path = strCookieURL end if Response.Cookies(strUniqueID & "Forum")("PRIVATE_" & rsStatus("F_SUBJECT")) = Request("pass") chkForumAccess = true end if end if end select case 3 '## Either Password or Allowed if isAllowedMember(fForum,UserNum) = 1 then chkForumAccess = true else chkForumAccess = false end if if not(chkForumAccess) then select case Request.Cookies(strUniqueID & "Forum")("PRIVATE_" & rsStatus("F_SUBJECT")) case rsStatus("F_PASSWORD_NEW") chkForumAccess = true case else if Request("pass") = "" then if Display then doPasswordForm Response.End else chkForumAccess = false end if else if Request("pass") <> rsStatus("F_PASSWORD_NEW") then if Display then Response.Write "

    Invalid password!

    " & vbNewLine & _ "

    Go Back to Enter Data


    " & vbNewLine WriteFooter Response.End else chkForumAccess = false end if else if strSetCookieToForum = 1 then Response.Cookies(strUniqueID & "Forum").Path = strCookieURL end if Response.Cookies(strUniqueID & "Forum")("PRIVATE_" & rsStatus("F_SUBJECT")) = Request("pass") chkForumAccess = true end if end if end select end if '## code added 07/13/2000 case 7 '## members or password if strDBNTUserName = "" then select case Request.Cookies(strUniqueID & "Forum")("PRIVATE_" & rsStatus("F_SUBJECT")) case rsStatus("F_PASSWORD_NEW") chkForumAccess = true case else if Request("pass") = "" then if Display then doLoginForm response.end else chkForumAccess = false end if else if Request("pass") <> rsStatus("F_PASSWORD_NEW") then if Display then Response.Write "

    Invalid password!

    " & vbNewLine & _ "

    Go Back to Enter Data


    " & vbNewLine WriteFooter Response.End else chkForumAccess = false end if else if strSetCookieToForum = 1 then Response.Cookies(strUniqueID & "Forum").Path = strCookieURL end if Response.Cookies(strUniqueID & "Forum")("PRIVATE_" & rsStatus("F_SUBJECT")) = Request("pass") chkForumAccess = true end if end if end select else chkForumAccess = true end if '## end code added 07/13/2000 case 4, 5 '## members only if Usernum = -1 or Usernum = "" then if Display then doNotLoggedInForm else chkForumAccess = false end if else '## V3.1 SR4 chkForumAccess = true end if case 8, 9 test="test db" chkForumAccess = FALSE if strAuthType="db" then chkForumAccess = true rsStatus.close set rsStatus = nothing exit function end if NTGroupSTR = Split(Session(strCookieURL & "strNTGroupsSTR"), ", ") for j = 0 to ubound(NTGroupSTR) NTGroupDBSTR = Split(rsStatus("F_PASSWORD_NEW"), ", ") for i = 0 to ubound(NTGroupDBSTR) if NTGroupDBSTR(i) = NTGroupSTR(j) then chkForumAccess = True rsStatus.close set rsStatus = nothing exit function end if next next if Display then doNotAllowed end if case else chkForumAccess = true end select else chkForumAccess = true end if end if rsStatus.close set rsStatus = nothing end function function chkForumAccessNew(fPrivateForums,fFPasswordNew,fForum_Subject,fForum_ID,UserNum) if MemberID = UserNum then if mLev < 1 then chkForumAccessNew = false elseif mLev = 3 then chkForumAccessNew = true elseif mLev = 4 then chkForumAccessNew = true exit function end if end if dim Users dim MatchFound Select case fPrivateForums case 0 chkForumAccessNew = true case 1, 6 '## Allowed Members List if isAllowedMember(fForum_ID,UserNum) = 1 then chkForumAccessNew = true else chkForumAccessNew = false end if case 2 '## password select case Request.Cookies(strUniqueID & "Forum")("PRIVATE_" & fForum_Subject) case fFPasswordNew chkForumAccessNew = true case else chkForumAccessNew = false end select case 3 '## Either Password or Allowed Members List if isAllowedMember(fForum_ID,UserNum) = 1 then chkForumAccessNew = true else chkForumAccessNew = false end if if not(chkForumAccessNew) then select case Request.Cookies(strUniqueID & "Forum")("PRIVATE_" & fForum_Subject) case fFPasswordNew chkForumAccessNew = true case else chkForumAccessNew = false end select end if case 7 '## Members or Password if Usernum = -1 or Usernum = "" then select case Request.Cookies(strUniqueID & "Forum")("PRIVATE_" & fForum_Subject) case fFPasswordNew chkForumAccessNew = true case else chkForumAccessNew = false end select else chkForumAccessNew = true end if case 4, 5 '## Members only if Usernum = -1 or Usernum = "" then chkForumAccessNew = false else chkForumAccessNew = true end if case 8, 9 '## NT Global Groups test="test db" chkForumAccessNew = false if strAuthType="db" then chkForumAccessNew = true end if NTGroupSTR = Split(Session(strCookieURL & "strNTGroupsSTR"), ", ") for j = 0 to ubound(NTGroupSTR) NTGroupDBSTR = Split(fFPasswordNew, ", ") for i = 0 to ubound(NTGroupDBSTR) if NTGroupDBSTR(i) = NTGroupSTR(j) then chkForumAccessNew = True exit function end if next next case else chkForumAccessNew = true end select end function sub doLoginForm() Response.Write "

    There Was A Problem

    " & vbNewLine & _ "

    You do not have access to this forum.

    " & vbNewLine & _ "

    If you have been given special permission by the administrator to view and/or post in this forum, enter the password here:" & vbNewLine & _ "

    " for each q in Request.QueryString Response.Write " " & vbNewLine next Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "
    " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "
    " & vbNewLine & _ "

    " & vbNewLine & _ "

    Go Back To Enter Data

    " & vbNewLine & _ "

    Return to the forum


    " & vbNewLine WriteFooter Response.End end sub sub doNotAllowed() Response.Write "

    There Was A Problem

    " & vbNewLine & _ "

    You do not have access to this forum.

    " & vbNewLine & _ "

    Go Back

    " & vbNewLine & _ "

    Return to the forum


    " & vbNewLine WriteFooter Response.End end sub sub doPasswordForm() if Request.QueryString <> "" then strRqQryString = "?" & Request.QueryString else strRqQryString = "" Response.Write "

    There Was A Problem

    " & vbNewLine & _ "

    You must enter the password for this forum." & vbNewLine & _ "

    " & vbNewLine for each q in Request.QueryString Response.Write " " & vbNewLine next Response.Write " " & vbNewLine & _ " " & vbNewLine & _ "

    " & vbNewLine & _ "

    Go Back

    " & vbNewLine & _ "

    Return to the forum


    " & vbNewLine WriteFooter Response.End end sub sub doNotLoggedInForm() Response.Write "

    There Was A Problem

    " & vbNewLine & _ "

    You must be logged in to enter this forum

    " & vbNewLine & _ "

    Go Back

    " & vbNewLine & _ "

    Return to the forum


    " & vbNewLine WriteFooter Response.End end sub %> <% '################################################################################# '## Snitz Forums 2000 v3.4.06 '################################################################################# '## Copyright (C) 2000-06 Michael Anderson, Pierre Gorissen, '## Huw Reddick and Richard Kinser '## '## This program is free software; you can redistribute it and/or '## modify it under the terms of the GNU General Public License '## as published by the Free Software Foundation; either version 2 '## of the License, or (at your option) any later version. '## '## All copyright notices regarding Snitz Forums 2000 '## must remain intact in the scripts and in the outputted HTML '## The "powered by" text/logo with a link back to '## http://forum.snitz.com in the footer of the pages MUST '## remain visible when the pages are viewed on the internet or intranet. '## '## This program is distributed in the hope that it will be useful, '## but WITHOUT ANY WARRANTY; without even the implied warranty of '## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the '## GNU General Public License for more details. '## '## You should have received a copy of the GNU General Public License '## along with this program; if not, write to the Free Software '## Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. '## '## Support can be obtained from our support forums at: '## http://forum.snitz.com '## '## Correspondence and Marketing Questions can be sent to: '## manderson@snitz.com '## '################################################################################# function EmailField(fTestString) TheAt = Instr(2, fTestString, "@") if TheAt = 0 then EmailField = 0 else TheDot = Instr(cLng(TheAt) + 2, fTestString, ".") if TheDot = 0 then EmailField = 0 else if cLng(TheDot) + 1 > Len(fTestString) then EmailField = 0 else EmailField = -1 end if end if end if end function '############################################## '## Ranks and Stars ## '############################################## function getMember_Level(fM_TITLE, fM_LEVEL, fM_POSTS) dim Member_Level Member_Level = "" if Trim(fM_TITLE) <> "" then Member_Level = fM_TITLE else select case fM_LEVEL case "1" if (fM_POSTS < cLng(intRankLevel1)) then Member_Level = Member_Level & strRankLevel0 if (fM_POSTS >= cLng(intRankLevel1)) and (fM_POSTS < cLng(intRankLevel2)) then Member_Level = Member_Level & strRankLevel1 if (fM_POSTS >= cLng(intRankLevel2)) and (fM_POSTS < cLng(intRankLevel3)) then Member_Level = Member_Level & strRankLevel2 if (fM_POSTS >= cLng(intRankLevel3)) and (fM_POSTS < cLng(intRankLevel4)) then Member_Level = Member_Level & strRankLevel3 if (fM_POSTS >= cLng(intRankLevel4)) and (fM_POSTS < cLng(intRankLevel5)) then Member_Level = Member_Level & strRankLevel4 if (fM_POSTS >= cLng(intRankLevel5)) then Member_Level = Member_Level & strRankLevel5 case "2" Member_Level = Member_Level & strRankMod case "3" Member_Level = Member_Level & strRankAdmin case else Member_Level = Member_Level & "Error" end select end if getMember_Level = Member_Level end function function getStar_Level(fM_LEVEL, fM_POSTS) dim Star_Level select case fM_LEVEL case "1" if (fM_POSTS < cLng(intRankLevel1)) then Star_Level = "" if (fM_POSTS >= cLng(intRankLevel1)) and (fM_POSTS < cLng(intRankLevel2)) then Star_Level = getCurrentIcon(getStarColor(strRankColor1),"","") if (fM_POSTS >= cLng(intRankLevel2)) and (fM_POSTS < cLng(intRankLevel3)) then Star_Level = getCurrentIcon(getStarColor(strRankColor2),"","") & getCurrentIcon(getStarColor(strRankColor2),"","") if (fM_POSTS >= cLng(intRankLevel3)) and (fM_POSTS < cLng(intRankLevel4)) then Star_Level = getCurrentIcon(getStarColor(strRankColor3),"","") & getCurrentIcon(getStarColor(strRankColor3),"","") & getCurrentIcon(getStarColor(strRankColor3),"","") if (fM_POSTS >= cLng(intRankLevel4)) and (fM_POSTS < cLng(intRankLevel5)) then Star_Level = getCurrentIcon(getStarColor(strRankColor4),"","") & getCurrentIcon(getStarColor(strRankColor4),"","") & getCurrentIcon(getStarColor(strRankColor4),"","") & getCurrentIcon(getStarColor(strRankColor4),"","") if (fM_POSTS >= cLng(intRankLevel5)) then Star_Level = getCurrentIcon(getStarColor(strRankColor5),"","") & getCurrentIcon(getStarColor(strRankColor5),"","") & getCurrentIcon(getStarColor(strRankColor5),"","") & getCurrentIcon(getStarColor(strRankColor5),"","") & getCurrentIcon(getStarColor(strRankColor5),"","") case "2" if fM_POSTS < cLng(intRankLevel1) then Star_Level = "" if (fM_POSTS >= cLng(intRankLevel1)) and (fM_POSTS < cLng(intRankLevel2)) then Star_Level = getCurrentIcon(getStarColor(strRankColorMod),"","") if (fM_POSTS >= cLng(intRankLevel2)) and (fM_POSTS < cLng(intRankLevel3)) then Star_Level = getCurrentIcon(getStarColor(strRankColorMod),"","") & getCurrentIcon(getStarColor(strRankColorMod),"","") if (fM_POSTS >= cLng(intRankLevel3)) and (fM_POSTS < cLng(intRankLevel4)) then Star_Level = getCurrentIcon(getStarColor(strRankColorMod),"","") & getCurrentIcon(getStarColor(strRankColorMod),"","") & getCurrentIcon(getStarColor(strRankColorMod),"","") if (fM_POSTS >= cLng(intRankLevel4)) and (fM_POSTS < cLng(intRankLevel5)) then Star_Level = getCurrentIcon(getStarColor(strRankColorMod),"","") & getCurrentIcon(getStarColor(strRankColorMod),"","") & getCurrentIcon(getStarColor(strRankColorMod),"","") & getCurrentIcon(getStarColor(strRankColorMod),"","") if (fM_POSTS >= cLng(intRankLevel5)) then Star_Level = getCurrentIcon(getStarColor(strRankColorMod),"","") & getCurrentIcon(getStarColor(strRankColorMod),"","") & getCurrentIcon(getStarColor(strRankColorMod),"","") & getCurrentIcon(getStarColor(strRankColorMod),"","") & getCurrentIcon(getStarColor(strRankColorMod),"","") case "3" if (fM_POSTS < cLng(intRankLevel1)) then Star_Level = "" if (fM_POSTS >= cLng(intRankLevel1)) and (fM_POSTS < cLng(intRankLevel2)) then Star_Level = getCurrentIcon(getStarColor(strRankColorAdmin),"","") if (fM_POSTS >= cLng(intRankLevel2)) and (fM_POSTS < cLng(intRankLevel3)) then Star_Level = getCurrentIcon(getStarColor(strRankColorAdmin),"","") & getCurrentIcon(getStarColor(strRankColorAdmin),"","") if (fM_POSTS >= cLng(intRankLevel3)) and (fM_POSTS < cLng(intRankLevel4)) then Star_Level = getCurrentIcon(getStarColor(strRankColorAdmin),"","") & getCurrentIcon(getStarColor(strRankColorAdmin),"","") & getCurrentIcon(getStarColor(strRankColorAdmin),"","") if (fM_POSTS >= cLng(intRankLevel4)) and (fM_POSTS < cLng(intRankLevel5)) then Star_Level = getCurrentIcon(getStarColor(strRankColorAdmin),"","") & getCurrentIcon(getStarColor(strRankColorAdmin),"","") & getCurrentIcon(getStarColor(strRankColorAdmin),"","") & getCurrentIcon(getStarColor(strRankColorAdmin),"","") if (fM_POSTS >= cLng(intRankLevel5)) then Star_Level = getCurrentIcon(getStarColor(strRankColorAdmin),"","") & getCurrentIcon(getStarColor(strRankColorAdmin),"","") & getCurrentIcon(getStarColor(strRankColorAdmin),"","") & getCurrentIcon(getStarColor(strRankColorAdmin),"","") & getCurrentIcon(getStarColor(strRankColorAdmin),"","") case else Star_Level = "Error" end select getStar_Level = Star_Level end function function getStarColor(strStarColor) select case strStarColor case "gold" : getStarColor = strIconStarGold case "silver" : getStarColor = strIconStarSilver case "bronze" : getStarColor = strIconStarBronze case "orange" : getStarColor = strIconStarOrange case "red" : getStarColor = strIconStarRed case "purple" : getStarColor = strIconStarPurple case "blue" : getStarColor = strIconStarBlue case "cyan" : getStarColor = strIconStarCyan case "green" : getStarColor = strIconStarGreen end select end function function getSig(fUser_Name) '## Forum_SQL strSql = "SELECT M_SIG " strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS " strSql = strSql & " WHERE " & strDBNTSQLName & " = '" & ChkString(fUser_Name, "SQLString") & "'" set rsSig = my_Conn.Execute (strSql) if rsSig.EOF or rsSig.BOF then '## Do nothing else getSig = rsSig("M_SIG") end if rsSig.close set rsSig = nothing end function function ViewSig(fUserID) if fUserID = -1 then ViewSig = 1 exit function end if '## Forum_SQL strSqlv = "SELECT M_VIEW_SIG " strSqlv = strSqlv & " FROM " & strMemberTablePrefix & "MEMBERS " strSqlv = strSqlv & " WHERE MEMBER_ID = " & cLng(fUserID) set rsVSig = my_Conn.Execute (strSqlv) if rsVSig.EOF or rsVSig.BOF then ViewSig = 1 else ViewSig = rsVSig("M_VIEW_SIG") end if rsVSig.close set rsVSig = nothing end function function getSigDefault(fUserID) if fUserID = -1 then getSigDefault = 1 exit function end if if Session(strCookieURL & "intSigDefault" & MemberID) = "" or IsNull(Session(strCookieURL & "intSigDefault" & MemberID)) then 'on error resume next strSqld = "SELECT M_SIG_DEFAULT " strSqld = strSqld & " FROM " & strMemberTablePrefix & "MEMBERS " strSqld = strSqld & " WHERE MEMBER_ID = " & cLng(fUserID) set rsSigDefault = my_Conn.Execute (strSqld) if rsSigDefault.EOF or rsSigDefault.BOF then getSigDefault = 1 set rsSigDefault = nothing exit function else tmpSigDefault = rsSigDefault("M_SIG_DEFAULT") Session(strCookieURL & "intSigDefault" & MemberID) = tmpSigDefault Session(strCookieURL & "intSigDefault" & MemberID) = tmpSigDefault end if set rsSigDefault = nothing end if if Session(strCookieURL & "intSigDefault" & MemberID) <> "" then getSigDefault = Session(strCookieURL & "intSigDefault" & MemberID) else getSigDefault = 1 end if end function Function DisplayUsersAge(fDOB) dtDOB = fDOB dtToday = FormatDateTime(strForumTimeAdjust,2) DisplayUsersAge = DateDiff("yyyy", dtDOB, dtToday) dtTmp = DateAdd("yyyy", DisplayUsersAge, dtDOB) if (DateDiff("d", dtToday, dtTmp) > 0) then DisplayUsersAge = DisplayUsersAge - 1 End Function function DOBToDate(fDOB) 'Testing for server format if strComp(Month("04/05/2002"),"4") = 0 then DOBToDate = cdate("" & Mid(fDOB, 5,2) & "/" & Mid(fDOB, 7,2) & "/" & Mid(fDOB, 1,4) & "") else DOBToDate = cdate("" & Mid(fDOB, 7,2) & "/" & Mid(fDOB, 5,2) & "/" & Mid(fDOB, 1,4) & "") end if end function %> <% '################################################################################# '## Snitz Forums 2000 v3.4.06 '################################################################################# '## Copyright (C) 2000-06 Michael Anderson, Pierre Gorissen, '## Huw Reddick and Richard Kinser '## '## This program is free software; you can redistribute it and/or '## modify it under the terms of the GNU General Public License '## as published by the Free Software Foundation; either version 2 '## of the License, or (at your option) any later version. '## '## All copyright notices regarding Snitz Forums 2000 '## must remain intact in the scripts and in the outputted HTML '## The "powered by" text/logo with a link back to '## http://forum.snitz.com in the footer of the pages MUST '## remain visible when the pages are viewed on the internet or intranet. '## '## This program is distributed in the hope that it will be useful, '## but WITHOUT ANY WARRANTY; without even the implied warranty of '## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the '## GNU General Public License for more details. '## '## You should have received a copy of the GNU General Public License '## along with this program; if not, write to the Free Software '## Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. '## '## Support can be obtained from our support forums at: '## http://forum.snitz.com '## '## Correspondence and Marketing Questions can be sent to: '## manderson@snitz.com '## '################################################################################# function GetKey(action) '// Create an array of characters to choose from for the key. '// If you would like to add uppercase letters or high ASCII characters, '// simply add them to the array, just remember to modify intNumChars '// variable to match number of characters in the array. intNumChars = 52 keyArray = Array("a","b","c","d","e","f","g","h","i","j","k","l","m","n","o","p","q","r","s","t","u","v","w","x","y","z","0","1","2","3","4","5","6","7","8","9","0","1","2","3","4","5","6","7","8","9","0","1","2","3","4","5") '// This picks 32 random numbers and pulls corresponding letters from the '// array. If you want a larger, or smaller key, simply adjust the '// number of characters you grab. dim key(32) Randomize for i = 0 to 31 key(i) = (Int(((intNumChars - 1) * Rnd) + 1)) next '// Make the key! strKey = "" for j = 0 to 31 strKey = strKey & keyArray(key(j)) next GetKey = strKey if action = "sendemail" then '## E-mails verification link to the new e-mail address. strRecipientsName = Request.Form("Name") strRecipients = Request.Form("Email") strFrom = strSender strFromName = strForumTitle strsubject = strForumTitle & "- Your E-mail Address Has Been Changed " strMessage = "Hello " & Request.Form("name") & vbNewLine & vbNewLine if Request.QueryString("mode") <> "EditIt" then strMessage = strMessage & "You received this message from " & strForumTitle & " because someone has changed your e-mail address on the forums at " & strForumURL & vbNewLine & vbNewLine else strMessage = strMessage & "You received this message from " & strForumTitle & " because you have changed your e-mail address on the forums at " & strForumURL & vbNewLine & vbNewLine end if strMessage = strMessage & "To complete your e-mail change, please click on the link below:" & vbNewLine & vbNewLine strMessage = strMessage & strForumURL & "pop_profile.asp?verkey=" & strKey & vbNewLine & vbNewLine strMessage = strMessage & "Thank You!" & vbNewLine & vbNewLine strMessage = strMessage & "Forum Admin" %> <% '################################################################################# '## Snitz Forums 2000 v3.4.06 '################################################################################# '## Copyright (C) 2000-06 Michael Anderson, Pierre Gorissen, '## Huw Reddick and Richard Kinser '## '## This program is free software; you can redistribute it and/or '## modify it under the terms of the GNU General Public License '## as published by the Free Software Foundation; either version 2 '## of the License, or (at your option) any later version. '## '## All copyright notices regarding Snitz Forums 2000 '## must remain intact in the scripts and in the outputted HTML '## The "powered by" text/logo with a link back to '## http://forum.snitz.com in the footer of the pages MUST '## remain visible when the pages are viewed on the internet or intranet. '## '## This program is distributed in the hope that it will be useful, '## but WITHOUT ANY WARRANTY; without even the implied warranty of '## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the '## GNU General Public License for more details. '## '## You should have received a copy of the GNU General Public License '## along with this program; if not, write to the Free Software '## Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. '## '## Support can be obtained from our support forums at: '## http://forum.snitz.com '## '## Correspondence and Marketing Questions can be sent to: '## manderson@snitz.com '## '################################################################################# if trim(strFromName) = "" then strFromName = strForumTitle end if select case lcase(strMailMode) case "abmailer" Set objNewMail = Server.CreateObject("ABMailer.Mailman") objNewMail.ServerAddr = strMailServer objNewMail.FromName = strFromName objNewMail.FromAddress = strSender objNewMail.SendTo = strRecipients objNewMail.MailSubject = strSubject objNewMail.MailMessage = strMessage on error resume next '## Ignore Errors objNewMail.SendMail If Err <> 0 Then Err_Msg = Err_Msg & "
  • Your request was not sent due to the following error: " & Err.Description & "
  • " End if case "aspemail" Set objNewMail = Server.CreateObject("Persits.MailSender") objNewMail.FromName = strFromName objNewMail.From = strSender objNewMail.AddReplyTo strSender objNewMail.Host = strMailServer objNewMail.AddAddress strRecipients, strRecipientsName objNewMail.Subject = strSubject objNewMail.Body = strMessage on error resume next '## Ignore Errors objNewMail.Send If Err <> 0 Then Err_Msg = Err_Msg & "
  • Your request was not sent due to the following error: " & Err.Description & "
  • " End if case "aspmail" Set objNewMail = Server.CreateObject("SMTPsvg.Mailer") objNewMail.FromName = strFromName objNewMail.FromAddress = strSender 'objNewMail.AddReplyTo = strSender objNewMail.RemoteHost = strMailServer objNewMail.AddRecipient strRecipientsName, strRecipients objNewMail.Subject = strSubject objNewMail.BodyText = strMessage on error resume next '## Ignore Errors SendOk = objNewMail.SendMail If not(SendOk) <> 0 Then Err_Msg = Err_Msg & "
  • Your request was not sent due to the following error: " & objNewMail.Response & "
  • " End if case "aspqmail" Set objNewMail = Server.CreateObject("SMTPsvg.Mailer") objNewMail.QMessage = 1 objNewMail.FromName = strFromName objNewMail.FromAddress = strSender objNewMail.RemoteHost = strMailServer objNewMail.AddRecipient strRecipientsName, strRecipients objNewMail.Subject = strSubject objNewMail.BodyText = strMessage on error resume next '## Ignore Errors objNewMail.SendMail If Err <> 0 Then Err_Msg = Err_Msg & "
  • Your request was not sent due to the following error: " & Err.Description & "
  • " End if case "cdonts" Set objNewMail = Server.CreateObject ("CDONTS.NewMail") objNewMail.BodyFormat = 1 objNewMail.MailFormat = 0 on error resume next '## Ignore Errors objNewMail.Send strSender, strRecipients, strSubject, strMessage If Err <> 0 Then Err_Msg = Err_Msg & "
  • Your request was not sent due to the following error: " & Err.Description & "
  • " End if on error resume next '## Ignore Errors case "chilicdonts" Set objNewMail = Server.CreateObject ("CDONTS.NewMail") on error resume next '## Ignore Errors objNewMail.Host = strMailServer objNewMail.To = strRecipients objNewMail.From = strSender objNewMail.Subject = strSubject objNewMail.Body = strMessage objNewMail.Send If Err <> 0 Then Err_Msg = Err_Msg & "
  • Your request was not sent due to the following error: " & Err.Description & "
  • " End if on error resume next '## Ignore Errors case "cdosys" Set iConf = Server.CreateObject ("CDO.Configuration") Set Flds = iConf.Fields 'Set and update fields properties Flds("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2 'cdoSendUsingPort Flds("http://schemas.microsoft.com/cdo/configuration/smtpserver") = strMailServer 'Flds("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = cdoBasic 'Flds("http://schemas.microsoft.com/cdo/configuration/sendusername") = "username" 'Flds("http://schemas.microsoft.com/cdo/configuration/sendpassword") = "password" Flds.Update Set objNewMail = Server.CreateObject("CDO.Message") Set objNewMail.Configuration = iConf 'Format and send message Err.Clear objNewMail.To = strRecipients objNewMail.From = strSender objNewMail.Subject = strSubject objNewMail.TextBody = strMessage On Error Resume Next objNewMail.Send If Err <> 0 Then Err_Msg = Err_Msg & "
  • Your request was not sent due to the following error: " & Err.Description & "
  • " End if case "dkqmail" Set objNewMail = Server.CreateObject("dkQmail.Qmail") objNewMail.FromEmail = strSender objNewMail.ToEmail = strRecipients objNewMail.Subject = strSubject objNewMail.Body = strMessage objNewMail.CC = "" objNewMail.MessageType = "TEXT" on error resume next '## Ignore Errors objNewMail.SendMail() If Err <> 0 Then Err_Msg = Err_Msg & "
  • Your request was not sent due to the following error: " & Err.Description & "
  • " End if case "dundasmailq" set objNewMail = Server.CreateObject("Dundas.Mailer") objNewMail.QuickSend strSender, strRecipients, strSubject, strMessage on error resume next '##Ignore Errors If Err <> 0 Then Err_Msg = Err_Msg & "
  • Your request was not sent due to the following error: " & Err.Description & "
  • " End if case "dundasmails" set objNewMail = Server.CreateObject("Dundas.Mailer") objNewMail.TOs.Add strRecipients objNewMail.FromAddress = strSender objNewMail.Subject = strSubject objNewMail.Body = strMessage on error resume next '##Ignore Errors objNewMail.SendMail If Err <> 0 Then Err_Msg = Err_Msg & "
  • Your request was not sent due to the following error: " & Err.Description & "
  • " End if case "freemailsender" set objNewMail = Server.CreateObject("Innoveda.MailSender") NoLoginMethod=0 CramMD5Method=1 AuthLoginMethod=2 LoginPlainMethod=3 objNewMail.Username = "username" objNewMail.Password = "password" objNewMail.LoginMethod = NoLoginMethod objNewMail.FromName = strFromName objNewMail.From = strSender 'objNewMail.AddReplyTo strSender objNewMail.Host = strMailServer objNewMail.To = strRecipients 'objNewMail.CC = strSender objNewMail.Subject = strSubject objNewMail.Body = strMessage on error resume next '## Ignore Errors objNewMail.Send If Err <> 0 Then Err_Msg = Err_Msg & "
  • Your request was not sent due to the following error: " & Err.Description & "
  • " End if case "geocel" set objNewMail = Server.CreateObject("Geocel.Mailer") objNewMail.AddServer strMailServer, 25 objNewMail.AddRecipient strRecipients, strRecipientsName objNewMail.FromName = strFromName objNewMail.FromAddress = strFrom objNewMail.Subject = strSubject objNewMail.Body = strMessage on error resume next '## Ignore Errors objNewMail.Send() if Err <> 0 then Response.Write "Your request was not sent due to the following error: " & Err.Description else Response.Write "Your mail has been sent..." end if case "iismail" Set objNewMail = Server.CreateObject("iismail.iismail.1") MailServer = strMailServer objNewMail.Server = strMailServer objNewMail.addRecipient(strRecipients) objNewMail.From = strSender objNewMail.Subject = strSubject objNewMail.body = strMessage on error resume next '## Ignore Errors objNewMail.Send If Err <> 0 Then Err_Msg = Err_Msg & "
  • Your request was not sent due to the following error: " & Err.Description & "
  • " End if case "jmail" Set objNewMail = Server.CreateObject("Jmail.smtpmail") objNewMail.ServerAddress = strMailServer objNewMail.AddRecipient strRecipients objNewMail.Sender = strSender objNewMail.Subject = strSubject objNewMail.body = strMessage objNewMail.priority = 3 on error resume next '## Ignore Errors objNewMail.execute If Err <> 0 Then Err_Msg = Err_Msg & "
  • Your request was not sent due to the following error: " & Err.Description & "
  • " End if case "jmail4" Set objNewMail = Server.CreateObject("Jmail.Message") 'objNewMail.MailServerUserName = "myUserName" 'objNewMail.MailServerPassword = "MyPassword" objNewMail.From = strSender objNewMail.FromName = strFromName objNewMail.AddRecipient strRecipients, strRecipientsName objNewMail.Subject = strSubject objNewMail.Body = strMessage on error resume next '## Ignore Errors objNewMail.Send(strMailServer) If Err <> 0 Then Err_Msg = Err_Msg & "
  • Your request was not sent due to the following error: " & Err.Description & "
  • " End if case "mdaemon" Set gMDUser = Server.CreateObject("MDUserCom.MDUser") mbDllLoaded = gMDUser.LoadUserDll if mbDllLoaded = False then response.write "Could not load MDUSER.DLL! Program will exit." & "
    " else Set gMDMessageInfo = Server.CreateObject("MDUserCom.MDMessageInfo") gMDUser.InitMessageInfo gMDMessageInfo gMDMessageInfo.To = strRecipients gMDMessageInfo.From = strSender gMDMessageInfo.Subject = strSubject gMDMessageInfo.MessageBody = strMessage gMDMessageInfo.Priority = 0 gMDUser.SpoolMessage gMDMessageInfo mbDllLoaded = gMDUser.FreeUserDll end if if Err <> 0 Then Err_Msg = Err_Msg & "
  • Your request was not sent due to the following error: " & Err.Description & "
  • " end if case "ocxmail" Set objNewMail = Server.CreateObject("ASPMail.ASPMailCtrl.1") recipient = strRecipients sender = strSender subject = strSubject message = strMessage mailserver = strMailServer on error resume next '## Ignore Errors result = objNewMail.SendMail(mailserver, recipient, sender, subject, message) If Err <> 0 Then Err_Msg = Err_Msg & "
  • Your request was not sent due to the following error: " & Err.Description & "
  • " End if case "ocxqmail" Set objNewMail = Server.CreateObject("ocxQmail.ocxQmailCtrl.1") mailServer = strMailServer FromName = strFromName FromAddress = strSender priority = "" returnReceipt = "" toAddressList = strRecipients ccAddressList = "" bccAddressList = "" attachmentList = "" messageSubject = strSubject messageText = strMessage on error resume next '## Ignore Errors objNewMail.Q mailServer, _ fromName, _ fromAddress, _ priority, _ returnReceipt, _ toAddressList, _ ccAddressList, _ bccAddressList, _ attachmentList, _ messageSubject, _ messageText If Err <> 0 Then Err_Msg = Err_Msg & "
  • Your request was not sent due to the following error: " & Err.Description & "
  • " End if case "sasmtpmail" Set objNewMail = Server.CreateObject("SoftArtisans.SMTPMail") objNewMail.FromName = strFromName objNewMail.FromAddress = strSender objNewMail.AddRecipient strRecipientsName, strRecipients 'objNewMail.AddReplyTo strSender objNewMail.BodyText = strMessage objNewMail.organization = strForumTitle objNewMail.Subject = strSubject objNewMail.RemoteHost = strMailServer on error resume next SendOk = objNewMail.SendMail If not(SendOk) <> 0 Then Err_Msg = Err_Msg & "
  • Your request was not sent due to the following error: " & objNewMail.Response & "
  • " End if case "smtp" Set objNewMail = Server.CreateObject("SmtpMail.SmtpMail.1") objNewMail.MailServer = strMailServer objNewMail.Recipients = strRecipients objNewMail.Sender = strSender objNewMail.Subject = strSubject objNewMail.Message = strMessage on error resume next '## Ignore Errors objNewMail.SendMail2 If Err <> 0 Then Err_Msg = Err_Msg & "
  • Your request was not sent due to the following error: " & Err.Description & "
  • " End if case "vsemail" Set objNewMail = CreateObject("VSEmail.SMTPSendMail") objNewMail.Host = strMailServer objNewMail.From = strSender objNewMail.SendTo = strRecipients objNewMail.Subject = strSubject objNewMail.Body = strMessage on error resume next '## Ignore Errors objNewMail.Connect objNewMail.Send objNewMail.Disconnect If Err <> 0 Then Err_Msg = Err_Msg & "
  • Your request was not sent due to the following error: " & Err.Description & "
  • " End if end select Set objNewMail = Nothing on error goto 0 %> <% end if end function function CleanCode(fString) if fString = "" or IsNull(fstring) then fString = " " else '## left for compatibility with older versions of the forum fString = replace(fString, "
    quote:
    ","[quote]", 1, -1, 1) fString = replace(fString, "
    ","[/quote]", 1, -1, 1) '## fString = replace(fString, "
    quote:
    ","[quote]", 1, -1, 1) fString = replace(fString, "
    ","[/quote]", 1, -1, 1) '## left for compatibility with older versions of the forum fString = replace(fString, "
    ","[/quote]", 1, -1, 1) '## if strAllowForumCode = "1" then fString = replace(fString, "","[b]", 1, -1, 1) fString = replace(fString, "","[/b]", 1, -1, 1) fString = replace(fString, "", "[s]", 1, -1, 1) fString = replace(fString, "", "[/s]", 1, -1, 1) fString = replace(fString, "","[u]", 1, -1, 1) fString = replace(fString, "","[/u]", 1, -1, 1) fString = replace(fString, "","[i]", 1, -1, 1) fString = replace(fString, "","[/i]", 1, -1, 1) '## left for compatibility with older versions of the forum fString = replace(fString, "", "[font=Andale Mono]", 1, -1, 1) fString = replace(fString, "", "[/font=Andale Mono]", 1, -1, 1) fString = replace(fString, "", "[font=Arial]", 1, -1, 1) fString = replace(fString, "", "[/font=Arial]", 1, -1, 1) fString = replace(fString, "", "[font=Arial Black]", 1, -1, 1) fString = replace(fString, "", "[/font=Arial Black]", 1, -1, 1) fString = replace(fString, "", "[font=Book Antiqua]", 1, -1, 1) fString = replace(fString, "", "[/font=Book Antiqua]", 1, -1, 1) fString = replace(fString, "", "[font=Century Gothic]", 1, -1, 1) fString = replace(fString, "", "[/font=Century Gothic]", 1, -1, 1) fString = replace(fString, "", "[font=Comic Sans MS]", 1, -1, 1) fString = replace(fString, "", "[/font=Comic Sans MS]", 1, -1, 1) fString = replace(fString, "", "[font=Courier New]", 1, -1, 1) fString = replace(fString, "", "[/font=Courier New]", 1, -1, 1) fString = replace(fString, "", "[font=Georgia]", 1, -1, 1) fString = replace(fString, "", "[/font=Georgia]", 1, -1, 1) fString = replace(fString, "", "[font=Impact]", 1, -1, 1) fString = replace(fString, "", "[/font=Impact]", 1, -1, 1) fString = replace(fString, "", "[font=Tahoma]", 1, -1, 1) fString = replace(fString, "", "[/font=Tahoma]", 1, -1, 1) fString = replace(fString, "", "[font=Times New Roman]", 1, -1, 1) fString = replace(fString, "", "[/font=Times New Roman]", 1, -1, 1) fString = replace(fString, "", "[font=Trebuchet MS]", 1, -1, 1) fString = replace(fString, "", "[/font=Trebuchet MS]", 1, -1, 1) fString = replace(fString, "", "[font=Script MT Bold]", 1, -1, 1) fString = replace(fString, "", "[/font=Script MT Bold]", 1, -1, 1) fString = replace(fString, "", "[font=Stencil]", 1, -1, 1) fString = replace(fString, "", "[/font=Stencil]", 1, -1, 1) fString = replace(fString, "", "[font=Verdana]", 1, -1, 1) fString = replace(fString, "", "[/font=Verdana]", 1, -1, 1) fString = replace(fString, "", "[font=Lucida Console]", 1, -1, 1) fString = replace(fString, "", "[/font=Lucida Console]", 1, -1, 1) '## fString = replace(fString, "", "[font=Andale Mono]", 1, -1, 1) fString = replace(fString, "", "[/font=Andale Mono]", 1, -1, 1) fString = replace(fString, "", "[font=Arial]", 1, -1, 1) fString = replace(fString, "", "[/font=Arial]", 1, -1, 1) fString = replace(fString, "", "[font=Arial Black]", 1, -1, 1) fString = replace(fString, "", "[/font=Arial Black]", 1, -1, 1) fString = replace(fString, "", "[font=Book Antiqua]", 1, -1, 1) fString = replace(fString, "", "[/font=Book Antiqua]", 1, -1, 1) fString = replace(fString, "", "[font=Century Gothic]", 1, -1, 1) fString = replace(fString, "", "[/font=Century Gothic]", 1, -1, 1) fString = replace(fString, "", "[font=Comic Sans MS]", 1, -1, 1) fString = replace(fString, "", "[/font=Comic Sans MS]", 1, -1, 1) fString = replace(fString, "", "[font=Courier New]", 1, -1, 1) fString = replace(fString, "", "[/font=Courier New]", 1, -1, 1) fString = replace(fString, "", "[font=Georgia]", 1, -1, 1) fString = replace(fString, "", "[/font=Georgia]", 1, -1, 1) fString = replace(fString, "", "[font=Impact]", 1, -1, 1) fString = replace(fString, "", "[/font=Impact]", 1, -1, 1) fString = replace(fString, "", "[font=Tahoma]", 1, -1, 1) fString = replace(fString, "", "[/font=Tahoma]", 1, -1, 1) fString = replace(fString, "", "[font=Times New Roman]", 1, -1, 1) fString = replace(fString, "", "[/font=Times New Roman]", 1, -1, 1) fString = replace(fString, "", "[font=Trebuchet MS]", 1, -1, 1) fString = replace(fString, "", "[/font=Trebuchet MS]", 1, -1, 1) fString = replace(fString, "", "[font=Script MT Bold]", 1, -1, 1) fString = replace(fString, "", "[/font=Script MT Bold]", 1, -1, 1) fString = replace(fString, "", "[font=Stencil]", 1, -1, 1) fString = replace(fString, "", "[/font=Stencil]", 1, -1, 1) fString = replace(fString, "", "[font=Verdana]", 1, -1, 1) fString = replace(fString, "", "[/font=Verdana]", 1, -1, 1) fString = replace(fString, "", "[font=Lucida Console]", 1, -1, 1) fString = replace(fString, "", "[/font=Lucida Console]", 1, -1, 1) '## left for compatibility with older versions of the forum fString = replace(fString, "", "[red]", 1, -1, 1) fString = replace(fString, "", "[/red]", 1, -1, 1) fString = replace(fString, "", "[green]", 1, -1, 1) fString = replace(fString, "", "[/green]", 1, -1, 1) fString = replace(fString, "", "[blue]", 1, -1, 1) fString = replace(fString, "", "[/blue]", 1, -1, 1) fString = replace(fString, "", "[white]", 1, -1, 1) fString = replace(fString, "", "[/white]", 1, -1, 1) fString = replace(fString, "", "[purple]", 1, -1, 1) fString = replace(fString, "", "[/purple]", 1, -1, 1) fString = replace(fString, "", "[yellow]", 1, -1, 1) fString = replace(fString, "", "[/yellow]", 1, -1, 1) fString = replace(fString, "", "[violet]", 1, -1, 1) fString = replace(fString, "", "[/violet]", 1, -1, 1) fString = replace(fString, "", "[brown]", 1, -1, 1) fString = replace(fString, "", "[/brown]", 1, -1, 1) fString = replace(fString, "", "[black]", 1, -1, 1) fString = replace(fString, "", "[/black]", 1, -1, 1) fString = replace(fString, "", "[pink]", 1, -1, 1) fString = replace(fString, "", "[/pink]", 1, -1, 1) fString = replace(fString, "", "[orange]", 1, -1, 1) fString = replace(fString, "", "[/orange]", 1, -1, 1) fString = replace(fString, "", "[gold]", 1, -1, 1) fString = replace(fString, "", "[/gold]", 1, -1, 1) fString = replace(fString, "", "[beige]", 1, -1, 1) fString = replace(fString, "", "[/beige]", 1, -1, 1) fString = replace(fString, "", "[teal]", 1, -1, 1) fString = replace(fString, "", "[/teal]", 1, -1, 1) fString = replace(fString, "", "[navy]", 1, -1, 1) fString = replace(fString, "", "[/navy]", 1, -1, 1) fString = replace(fString, "", "[maroon]", 1, -1, 1) fString = replace(fString, "", "[/maroon]", 1, -1, 1) fString = replace(fString, "", "[limegreen]", 1, -1, 1) fString = replace(fString, "", "[/limegreen]", 1, -1, 1) '## fString = replace(fString, "", "[red]", 1, -1, 1) fString = replace(fString, "", "[/red]", 1, -1, 1) fString = replace(fString, "", "[green]", 1, -1, 1) fString = replace(fString, "", "[/green]", 1, -1, 1) fString = replace(fString, "", "[blue]", 1, -1, 1) fString = replace(fString, "", "[/blue]", 1, -1, 1) fString = replace(fString, "", "[white]", 1, -1, 1) fString = replace(fString, "", "[/white]", 1, -1, 1) fString = replace(fString, "", "[purple]", 1, -1, 1) fString = replace(fString, "", "[/purple]", 1, -1, 1) fString = replace(fString, "", "[yellow]", 1, -1, 1) fString = replace(fString, "", "[/yellow]", 1, -1, 1) fString = replace(fString, "", "[violet]", 1, -1, 1) fString = replace(fString, "", "[/violet]", 1, -1, 1) fString = replace(fString, "", "[brown]", 1, -1, 1) fString = replace(fString, "", "[/brown]", 1, -1, 1) fString = replace(fString, "", "[black]", 1, -1, 1) fString = replace(fString, "", "[/black]", 1, -1, 1) fString = replace(fString, "", "[pink]", 1, -1, 1) fString = replace(fString, "", "[/pink]", 1, -1, 1) fString = replace(fString, "", "[orange]", 1, -1, 1) fString = replace(fString, "", "[/orange]", 1, -1, 1) fString = replace(fString, "", "[gold]", 1, -1, 1) fString = replace(fString, "", "[/gold]", 1, -1, 1) fString = replace(fString, "", "[beige]", 1, -1, 1) fString = replace(fString, "", "[/beige]", 1, -1, 1) fString = replace(fString, "", "[teal]", 1, -1, 1) fString = replace(fString, "", "[/teal]", 1, -1, 1) fString = replace(fString, "", "[navy]", 1, -1, 1) fString = replace(fString, "", "[/navy]", 1, -1, 1) fString = replace(fString, "", "[maroon]", 1, -1, 1) fString = replace(fString, "", "[/maroon]", 1, -1, 1) fString = replace(fString, "", "[limegreen]", 1, -1, 1) fString = replace(fString, "", "[/limegreen]", 1, -1, 1) fString = replace(fString, "

    ", "[h1]", 1, -1, 1) fString = replace(fString, "

    ", "[/h1]", 1, -1, 1) fString = replace(fString, "

    ", "[h2]", 1, -1, 1) fString = replace(fString, "

    ", "[/h2]", 1, -1, 1) fString = replace(fString, "

    ", "[h3]", 1, -1, 1) fString = replace(fString, "

    ", "[/h3]", 1, -1, 1) fString = replace(fString, "

    ", "[h4]", 1, -1, 1) fString = replace(fString, "

    ", "[/h4]", 1, -1, 1) fString = replace(fString, "
    ", "[h5]", 1, -1, 1) fString = replace(fString, "
    ", "[/h5]", 1, -1, 1) fString = replace(fString, "
    ", "[h6]", 1, -1, 1) fString = replace(fString, "
    ", "[/h6]", 1, -1, 1) '## left for compatibility with older versions of the forum fString = replace(fString, "", "[size=1]", 1, -1, 1) fString = replace(fString, "", "[/size=1]", 1, -1, 1) fString = replace(fString, "", "[size=2]", 1, -1, 1) fString = replace(fString, "", "[/size=2]", 1, -1, 1) fString = replace(fString, "", "[size=3]", 1, -1, 1) fString = replace(fString, "", "[/size=3]", 1, -1, 1) fString = replace(fString, "", "[size=4]", 1, -1, 1) fString = replace(fString, "", "[/size=4]", 1, -1, 1) fString = replace(fString, "", "[size=5]", 1, -1, 1) fString = replace(fString, "", "[/size=5]", 1, -1, 1) fString = replace(fString, "", "[size=6]", 1, -1, 1) fString = replace(fString, "", "[/size=6]", 1, -1, 1) '## fString = replace(fString, "", "[size=1]", 1, -1, 1) fString = replace(fString, "", "[/size=1]", 1, -1, 1) fString = replace(fString, "", "[size=2]", 1, -1, 1) fString = replace(fString, "", "[/size=2]", 1, -1, 1) fString = replace(fString, "", "[size=3]", 1, -1, 1) fString = replace(fString, "", "[/size=3]", 1, -1, 1) fString = replace(fString, "", "[size=4]", 1, -1, 1) fString = replace(fString, "", "[/size=4]", 1, -1, 1) fString = replace(fString, "", "[size=5]", 1, -1, 1) fString = replace(fString, "", "[/size=5]", 1, -1, 1) fString = replace(fString, "", "[size=6]", 1, -1, 1) fString = replace(fString, "", "[/size=6]", 1, -1, 1) fString = replace(fString, "
    ","[br]", 1, -1, 1) fString = replace(fString, "
    ","[hr]", 1, -1, 1) '## left for compatibility with older versions of the forum fString = replace(fString, "
    ", "[left]", 1, -1, 1) fString = replace(fString, "
    ", "[/left]", 1, -1, 1) '## fString = replace(fString, "
    ", "[left]", 1, -1, 1) fString = replace(fString, "
    ", "[/left]", 1, -1, 1) fString = replace(fString, "
    ","[center]", 1, -1, 1) fString = replace(fString, "
    ","[/center]", 1, -1, 1) '## left for compatibility with older versions of the forum fString = replace(fString, "
    ", "[right]", 1, -1, 1) fString = replace(fString, "
    ", "[/right]", 1, -1, 1) '## fString = replace(fString, "
    ", "[right]", 1, -1, 1) fString = replace(fString, "
    ", "[/right]", 1, -1, 1) fString = replace(fString, "
      ","[list]", 1, -1, 1) fString = replace(fString, "
    ","[/list]", 1, -1, 1) '## left for compatibility with older versions of the forum fString = replace(fString, "
      ","[list=1]", 1, -1, 1) fString = replace(fString, "
    ","[/list=1]", 1, -1, 1) fString = replace(fString, "
      ","[list=a]", 1, -1, 1) fString = replace(fString, "
    ","[/list=a]", 1, -1, 1) '## fString = replace(fString, "
      ","[list=1]", 1, -1, 1) fString = replace(fString, "
    ","[/list=1]", 1, -1, 1) fString = replace(fString, "
      ","[list=a]", 1, -1, 1) fString = replace(fString, "
    ","[/list=a]", 1, -1, 1) fString = replace(fString, "
  • ","[*]", 1, -1, 1) fString = replace(fString, "
  • ","[/*]", 1, -1, 1) '## left for compatibility with older versions of the forum fString = replace(fString, "
    ","[code]", 1, -1, 1)
    			fString = replace(fString, "
    ","[/code]", 1, -1, 1) '## fString = replace(fString, "
    ","[code]", 1, -1, 1)
    			fString = replace(fString, "
    ","[/code]", 1, -1, 1) end if if strIcons = "1" then '## left for compatibility with older versions of the forum fString = replace(fString, "", "[:(!]", 1, -1, 1) fString = replace(fString, "", "[B)]", 1, -1, 1) fString = replace(fString, "", "[xx(]", 1, -1, 1) fString = replace(fString, "", "[XX(]", 1, -1, 1) fString = replace(fString, "", "[:O]", 1, -1, 1) fString = replace(fString, "", "[:o]", 1, -1, 1) fString = replace(fString, "", "[:0]", 1, -1, 1) fString = replace(fString, "", "[:I]", 1, -1, 1) fString = replace(fString, "", "[:(]", 1, -1, 1) fString = replace(fString, "", "[8)]", 1, -1, 1) fString = replace(fString, "", "[:)]", 1, -1, 1) fString = replace(fString, "", "[}:)]", 1, -1, 1) fString = replace(fString, "", "[:D]", 1, -1, 1) fString = replace(fString, "", "[8D]", 1, -1, 1) fString = replace(fString, "", "[|)]", 1, -1, 1) fString = replace(fString, "", "[:o)]", 1, -1, 1) fString = replace(fString, "", "[:O)]", 1, -1, 1) fString = replace(fString, "", "[:0)]", 1, -1, 1) fString = replace(fString, "", "[:P]", 1, -1, 1) fString = replace(fString, "", "[:p]", 1, -1, 1) fString = replace(fString, "", "[;)]", 1, -1, 1) fString = replace(fString, "", "[8]", 1, -1, 1) fString = replace(fString, "", "[?]", 1, -1, 1) fString = replace(fString, "", "[^]", 1, -1, 1) fString = replace(fString, "", "[V]", 1, -1, 1) fString = replace(fString, "", "[v]", 1, -1, 1) fString = replace(fString, "", "[V]", 1, -1, 1) fString = replace(fString, "", "[v]", 1, -1, 1) fString = replace(fString, "", "[:X]", 1, -1, 1) fString = replace(fString, "", "[:x]", 1, -1, 1) '## end if if strAllowForumCode = "1" then if strIMGInPosts = "1" then fString = replace(fString, "","[/img]", 1, -1, 1) fString = replace(fString, """ id=right border=0>","[/img=right]", 1, -1, 1) fString = replace(fString, """ id=left border=0>","[/img=left]", 1, -1, 1) '## fString = replace(fString, "","[/img]", 1, -1, 1) fString = replace(fString, """ id=""right"" border=""0"">","[/img=right]", 1, -1, 1) fString = replace(fString, """ id=""left"" border=""0"">","[/img=left]", 1, -1, 1) end if end if end if fString = Replace(fString, "'", "'") CleanCode = fString end function %> <% '################################################################################# '## Page-code start '################################################################################# if request("ARCHIVE") = "true" then strActivePrefix = strTablePrefix & "A_" ArchiveView = "true" else strActivePrefix = strTablePrefix ArchiveView = "" end if if strRqMethod = "Edit" or _ strRqMethod = "EditTopic" or _ strRqMethod = "Reply" or _ strRqMethod = "ReplyQuote" or _ strRqMethod = "TopicQuote" then '## check if topic exists in TOPICS table set rsTCheck = my_Conn.Execute ("SELECT TOPIC_ID FROM " & strActivePrefix & "TOPICS WHERE TOPIC_ID = " & strRqTopicID) if rsTCheck.EOF or rsTCheck.BOF then rsTCheck.Close set rsTCheck = nothing Go_Result "Sorry, that Topic no longer exists in the Database" end if set rsTCheck = nothing end if if ArchiveView <> "" then if MethodType = "Reply" or _ MethodType = "ReplyQuote" or _ MethodType = "TopicQuote" then Go_Result "This is not allowed in the Archives." end if end if if strRqMethod = "Edit" or _ strRqMethod = "EditTopic" or _ strRqMethod = "Reply" or _ strRqMethod = "ReplyQuote" or _ strRqMethod = "Topic" or _ strRqMethod = "TopicQuote" then if strRqMethod <> "Topic" then '## Forum_SQL - Find out if the Category, Forum or Topic is Locked or Un-Locked and if it Exists strSql = "SELECT C.CAT_ID, C.CAT_NAME, C.CAT_STATUS, C.CAT_SUBSCRIPTION, " &_ "F.FORUM_ID, F.F_STATUS, F.F_TYPE, F.F_SUBJECT, F.F_SUBSCRIPTION, "&_ "T.T_STATUS, T.T_SUBJECT " &_ " FROM " & strTablePrefix & "CATEGORY C, " &_ strTablePrefix & "FORUM F, " &_ strActivePrefix & "TOPICS T" &_ " WHERE C.CAT_ID = T.CAT_ID " &_ " AND F.FORUM_ID = T.FORUM_ID " &_ " AND T.TOPIC_ID = " & strRqTopicID & "" else '## Forum_SQL - Find out if the Category or Forum is Locked or Un-Locked and if it Exists strSql = "SELECT C.CAT_ID, C.CAT_NAME, C.CAT_STATUS, C.CAT_SUBSCRIPTION, " &_ "F.FORUM_ID, F.F_STATUS, F.F_TYPE, F.F_SUBJECT, F.F_SUBSCRIPTION "&_ " FROM " & strTablePrefix & "CATEGORY C, " &_ strTablePrefix & "FORUM F" &_ " WHERE C.CAT_ID = F.CAT_ID " &_ " AND F.FORUM_ID = " & strRqForumID & "" end if set rsStatus = my_Conn.Execute(strSql) if rsStatus.EOF or rsStatus.BOF then rsStatus.close set rsStatus = nothing Go_Result "Please don't attempt to edit the URL
    to gain access to locked Forums/Categories." else '## Subscribe checkbox start ## PostCat_subscription = rsStatus("CAT_SUBSCRIPTION") PostForum_subscription = rsStatus("F_SUBSCRIPTION") '## Subscribe checkbox end ## blnCStatus = rsStatus("CAT_STATUS") blnFStatus = rsStatus("F_STATUS") strRqForumID = rsStatus("FORUM_ID") strRqCatID = rsStatus("CAT_ID") Cat_Name = rsStatus("CAT_NAME") Forum_Type = rsStatus("F_TYPE") Forum_Subject = rsStatus("F_SUBJECT") if strRqMethod <> "Topic" then blnTStatus = rsStatus("T_STATUS") Topic_Title = rsStatus("T_SUBJECT") else blnTStatus = 1 end if rsStatus.close set rsStatus = nothing end if if mLev = 4 then AdminAllowed = 1 ForumChkSkipAllowed = 1 elseif mLev = 3 then if chkForumModerator(strRqForumID, ChkString(strDBNTUserName, "decode")) = "1" then AdminAllowed = 1 ForumChkSkipAllowed = 1 else if lcase(strNoCookies) = "1" then AdminAllowed = 1 ForumChkSkipAllowed = 0 else AdminAllowed = 0 ForumChkSkipAllowed = 0 end if end if elseif lcase(strNoCookies) = "1" then AdminAllowed = 1 ForumChkSkipAllowed = 0 else AdminAllowed = 0 ForumChkSkipAllowed = 0 end if select case strRqMethod case "Topic" if (Forum_Type = 1) then Go_Result "You have attempted to post a New Topic to a Forum designated as a Web Link" end if if (blnCStatus = 0) and (AdminAllowed = 0) then Go_Result "You have attempted to post a New Topic to a Locked Category" end if if (blnFStatus = 0) and (AdminAllowed = 0) then Go_Result "You have attempted to post a New Topic to a Locked Forum" end if case "EditTopic" if ((blnCStatus = 0) or (blnFStatus = 0) or (blnTStatus = 0)) and (AdminAllowed = 0) then Go_Result "You have attempted to edit a Locked Topic" end if case "Reply", "ReplyQuote", "TopicQuote" if ((blnCStatus = 0) or (blnFStatus = 0) or (blnTStatus = 0)) and (AdminAllowed = 0) then Go_Result "You have attempted to Reply to a Locked Topic" end if case "Edit" if ((blnCStatus = 0) or (blnFStatus = 0) or (blnTStatus = 0)) and (AdminAllowed = 0) then Go_Result "You have attempted to Edit a Reply to a Locked Topic" end if end select if strPrivateForums = "1" and ForumChkSkipAllowed = 0 then if not(chkForumAccess(strRqForumID,MemberID,false)) then Go_Result "You do not have access to this forum" end if end if end if select case strSelectSize case "1" intCols = 45 intRows = 11 case "2" intCols = 70 intRows = 12 case "3" intCols = 90 intRows = 12 case "4" intCols = 130 intRows = 15 case else intCols = 70 intRows = 12 end select Response.Write " " & vbNewLine & _ " " & vbNewLine if strRqMethod = "EditForum" then if (mLev = 4) or (chkForumModerator(strRqForumId, strDBNTUserName) = "1") then '## Do Nothing else Go_Result "Only moderators and administrators can edit forums" end if end if Msg = "" select case strRqMethod case "Reply", "ReplyQuote", "TopicQuote" if (strNoCookies = 1) or (strDBNTUserName = "") then Msg = Msg & "Note: You must be registered in order to post a reply.
    " if strProhibitNewMembers <> "1" then Msg = Msg & "To register, click here. Registration is FREE!
    " end if end if case "Topic" if (strNoCookies = 1) or (strDBNTUserName = "") then Msg = Msg & "Note: You must be registered in order to post a Topic.
    " if strProhibitNewMembers <> "1" then Msg = Msg & "To register, click here. Registration is FREE!
    " end if end if case "Category" Msg = Msg & "Note: You must be an Administrator to create a new Category.
    " case "Forum" Msg = Msg & "Note: You must be an Administrator to create a new Forum.
    " case "URL" Msg = Msg & "Note: You must be an Administrator to create a new Web Link.
    " case "Edit", "EditTopic" Msg = Msg & "Note: Only the poster of this message, and the Moderator can edit the message." case "EditForum" Msg = Msg & "Note: Only the Moderator or an Administrator can edit a Forum." case "EditURL" Msg = Msg & "Note: Only the Moderator or an Administrator can edit a Web Link." case "EditCategory" Msg = Msg & "Note: Only an Administrator can edit a Category." case else Response.Redirect "default.asp" end select if strRqMethod = "Edit" or _ strRqMethod = "ReplyQuote" then '## Forum_SQL strSql = "SELECT M.M_NAME, R.R_AUTHOR, R.R_SIG, R.R_MESSAGE " strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS M, " & strActivePrefix & "REPLY R " strSql = strSql & " WHERE M.MEMBER_ID = R.R_AUTHOR AND R.REPLY_ID = " & strRqReplyID set rs = my_Conn.Execute (strSql) strAuthor = rs("R_AUTHOR") strReplySig = rs("R_SIG") if strRqMethod = "Edit" then TxtMsg = rs("R_MESSAGE") else if strRqMethod = "ReplyQuote" then TxtMsg = "[quote][i]Originally posted by " & chkString(rs("M_NAME"),"display") & "[/i]" & vbNewline TxtMsg = TxtMsg & "[br]" & rs("R_MESSAGE") & vbNewline TxtMsg = TxtMsg & "[/quote]" end if end if set rs = nothing end if if strRqMethod = "EditTopic" or strRqMethod = "TopicQuote" then '## Forum_SQL strSql = "SELECT M.M_NAME, T.T_SUBJECT, T.T_AUTHOR, T.T_STICKY, T.T_SIG, T.T_MESSAGE " strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS M, " & strActivePrefix & "TOPICS T " strSql = strSql & " WHERE M.MEMBER_ID = T.T_AUTHOR AND T.TOPIC_ID = " & strRqTopicID set rs = my_Conn.Execute (strSql) TxtSub = rs("T_SUBJECT") strAuthor = rs("T_AUTHOR") strTopicSig = rs("T_SIG") if strStickyTopic = "1" then strTopicSticky = rs("T_STICKY") end if if strRqMethod = "EditTopic" then TxtMsg = rs("T_MESSAGE") else if strRqMethod = "TopicQuote" then TxtMsg = "[quote][i]Originally posted by " & chkString(rs("M_NAME"),"display") & "[/i]" & vbNewline TxtMsg = TxtMsg & "[br]" & rs("T_MESSAGE") & vbNewline TxtMsg = TxtMsg & "[/quote]" end if end if set rs = nothing end if if strRqMethod = "EditForum" or _ strRqMethod = "EditURL" then '## Forum_SQL ' DEM --> Added F_SUBSCRIPTION, F_MODERATION to the end of this select strSql = "SELECT F_SUBJECT, F_URL, F_PRIVATEFORUMS, F_PASSWORD_NEW, " & _ "F_DEFAULTDAYS, F_COUNT_M_POSTS, F_SUBSCRIPTION, F_MODERATION, F_DESCRIPTION " & _ " FROM " & strTablePrefix & "FORUM " & _ " WHERE FORUM_ID = " & strRqForumId set rs = my_Conn.Execute (strSql) if strRqMethod = "EditURL" then TxtUrl = rs("F_URL") end if if strRqMethod = "EditForum" then fDefaultDays = rs("F_DEFAULTDAYS") fForumCntMPosts = rs("F_COUNT_M_POSTS") fPrivateForums = rs("F_PRIVATEFORUMS") fPasswordNew = rs("F_PASSWORD_NEW") end if if strRqMethod = "EditForum" or _ strRqMethod = "EditURL" then TxtSub = rs("F_SUBJECT") ' DEM --> Added fields to get them into local variables which is a faster run ForumSubscription = rs("F_SUBSCRIPTION") ForumModeration = rs("F_MODERATION") TxtMsg = rs("F_DESCRIPTION") end if set rs = nothing end if ' DEM --> Added editforum and forum to get the cat_subscription and cat_moderation for later use. if strRqMethod = "EditCategory" or strRqMethod = "EditForum" or strRqMethod = "EditURL" or strRqMethod = "Forum" then '## Forum_SQL ' DEM --> Added CAT_SUBSCRIPTION for subscription services ' DEM --> Added CAT_MODERATION for moderation processing strSql = "SELECT CAT_NAME, CAT_SUBSCRIPTION, CAT_MODERATION " strSql = strSql & " FROM " & strTablePrefix & "CATEGORY " strSql = strSql & " WHERE CAT_ID = " & strRqCatID ' DEM --> Added if statement to use a different connection and to move the database fields to local variables if strRqMethod = "EditForum" or strRqMethod = "EditURL" or strRqMethod = "Forum" then set rs1 = my_Conn.Execute (strSql) CatSubscription = rs1("CAT_SUBSCRIPTION") CatModeration = rs1("CAT_MODERATION") strCatName = rs1("CAT_NAME") set rs1 = nothing else set rs = my_Conn.Execute (strSql) CatSubscription = rs("CAT_SUBSCRIPTION") CatModeration = rs("CAT_MODERATION") TxtSub = rs("CAT_NAME") set rs = nothing end if 'if strRqMethod = "EditCategory" then ' TxtSub = rs("CAT_NAME") 'end if end if select case strRqMethod case "Category" btn = "Post New Category" case "Edit", "EditCategory", "EditForum", "EditTopic", "EditURL" btn = "Post Changes" case "Forum" btn = "Post New Forum" case "Reply", "ReplyQuote", "TopicQuote" btn = "Post New Reply" case "Topic" btn = "Post New Topic" case "URL" btn = "Post New URL" case else btn = "Post" end select Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "
    " & vbNewLine & _ " " & getCurrentIcon(strIconFolderOpen,"","align=""absmiddle""") & " All Forums
    " & vbNewLine if strRqMethod = "EditCategory" then Response.Write " " & getCurrentIcon(strIconBar,"","align=""absmiddle""") & getCurrentIcon(strIconFolderOpen,"","align=""absmiddle""") & " " & ChkString(TxtSub,"display") & "
    " & vbNewLine elseif strRqMethod = "EditForum" or strRqMethod = "EditURL" then Response.Write " " & getCurrentIcon(strIconBar,"","align=""absmiddle""") & getCurrentIcon(strIconFolderOpen,"","align=""absmiddle""") & " " & ChkString(strCatName,"display") & "
    " & vbNewLine Response.Write " " & getCurrentIcon(strIconBlank,"","align=""absmiddle""") & getCurrentIcon(strIconBar,"","align=""absmiddle""") & getCurrentIcon(strIconFolderOpen,"","align=""absmiddle""") & " " & ChkString(TxtSub,"display") & "
    " & vbNewLine else if strRqMethod = "Edit" or strRqMethod = "EditTopic" or _ strRqMethod = "Reply" or strRqMethod = "ReplyQuote" or _ strRqMethod = "Topic" or strRqMethod = "TopicQuote" then Response.Write " " & getCurrentIcon(strIconBar,"","align=""absmiddle""") if blnCStatus <> 0 then Response.Write getCurrentIcon(strIconFolderOpen,"","align=""absmiddle""") else Response.Write getCurrentIcon(strIconFolderClosed,"","align=""absmiddle""") end if Response.Write " " & ChkString(Cat_Name,"display") & "
    " & vbNewLine Response.Write " " & getCurrentIcon(strIconBlank,"","align=""absmiddle""") & getCurrentIcon(strIconBar,"","align=""absmiddle""") if blnFStatus <> 0 and blnCStatus <> 0 then Response.Write getCurrentIcon(strIconFolderOpen,"","align=""absmiddle""") else if strRqMethod <> "Topic" then Response.Write getCurrentIcon(strIconFolderClosed,"","align=""absmiddle""") else Response.Write getCurrentIcon(strIconFolderClosedTopic,"","align=""absmiddle""") end if end if Response.Write " " & ChkString(Forum_Subject,"display") & "
    " & vbNewLine end if end if if strRqMethod = "Edit" or strRqMethod = "EditTopic" or _ strRqMethod = "Reply" or strRqMethod = "ReplyQuote" or _ strRqMethod = "TopicQuote" then Response.Write " " & getCurrentIcon(strIconBlank,"","align=""absmiddle""") & getCurrentIcon(strIconBlank,"","align=""absmiddle""") & getCurrentIcon(strIconBar,"","align=""absmiddle""") if blnTStatus <> 0 and blnFStatus <> 0 and blnCStatus <> 0 then Response.Write getCurrentIcon(strIconFolderOpenTopic,"","align=""absmiddle""") else Response.Write getCurrentIcon(strIconFolderClosedTopic,"","align=""absmiddle""") end if Response.Write " " & ChkString(Topic_Title,"title") & "" & vbNewLine end if Response.Write "
    " & vbNewLine & _ "

    " & Msg & "

    " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewline & _ " " & vbNewline & _ "
    " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine if strRqMethod = "Edit" or strRqMethod = "EditTopic" then Response.Write(" " & vbNewLine) Response.Write " " & vbNewLine & _ " " & vbNewLine if strRqMethod = "Edit" or strRqMethod = "EditTopic" or strRqMethod = "Forum" or strRqMethod = "EditForum" or _ strRqMethod = "Reply" or strRqMethod = "ReplyQuote" or _ strRqMethod = "Topic" or strRqMethod = "TopicQuote" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if if mlev = 4 or _ mlev = 3 or _ mlev = 2 or _ mlev = 1 then Response.Write " " & vbNewLine & _ " " & vbNewLine else if (lcase(strNoCookies) = "1") or _ (strDBNTUserName = "" or _ strCkPassWord = "") then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if end if if strAllowForumCode = "1" and strShowFormatButtons = "1" then if strRqMethod = "Edit" or strRqMethod = "EditTopic" or _ strRqMethod = "Reply" or strRqMethod = "ReplyQuote" or _ strRqMethod = "Topic" or strRqMethod = "TopicQuote" then %> <% '################################################################################# '## Snitz Forums 2000 v3.4.06 '################################################################################# '## Copyright (C) 2000-06 Michael Anderson, Pierre Gorissen, '## Huw Reddick and Richard Kinser '## '## This program is free software; you can redistribute it and/or '## modify it under the terms of the GNU General Public License '## as published by the Free Software Foundation; either version 2 '## of the License, or (at your option) any later version. '## '## All copyright notices regarding Snitz Forums 2000 '## must remain intact in the scripts and in the outputted HTML '## The "powered by" text/logo with a link back to '## http://forum.snitz.com in the footer of the pages MUST '## remain visible when the pages are viewed on the internet or intranet. '## '## This program is distributed in the hope that it will be useful, '## but WITHOUT ANY WARRANTY; without even the implied warranty of '## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the '## GNU General Public License for more details. '## '## You should have received a copy of the GNU General Public License '## along with this program; if not, write to the Free Software '## Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. '## '## Support can be obtained from our support forums at: '## http://forum.snitz.com '## '## Correspondence and Marketing Questions can be sent to: '## manderson@snitz.com '## '################################################################################# Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine %> <% end if end if if strRqMethod = "Forum" or _ strRqMethod = "URL" or _ strRqMethod = "EditURL" or _ strRqMethod = "EditForum" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if if (strRqMethod = "EditTopic") then Dim MoveTopicAllowed if (mLev = 4) or (mLev = 3 and strMoveTopicMode = "0") or ((mLev = 3) and (strMoveTopicMode = "1") and (strAuthor = MemberID)) then MoveTopicAllowed = "1" else MoveTopicAllowed = "0" end if Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewline & _ " " & vbNewLine end if if strRqMethod = "Forum" or _ strRqMethod = "EditForum" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if if strRqMethod = "Forum" or _ strRqMethod = "EditForum" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if if strRqMethod = "Category" or _ strRqMethod = "EditCategory" or _ strRqMethod = "URL" or _ strRqMethod = "EditURL" or _ strRqMethod = "Forum" or _ strRqMethod = "EditForum" or _ strRqMethod = "EditTopic" or _ strRqMethod = "Topic" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if if strRqMethod = "URL" or _ strRqMethod = "EditURL" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if if strRqMethod = "Edit" or strRqMethod = "URL" or strRqMethod = "EditURL" or _ strRqMethod = "Forum" or strRqMethod = "EditForum" or _ strRqMethod = "Reply" or strRqMethod = "ReplyQuote" or _ strRqMethod = "EditTopic" or strRqMethod = "Topic" or strRqMethod = "TopicQuote" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if select case strRqMethod case "Reply", "ReplyQuote", "TopicQuote" Response.Write " " & vbNewLine end select '################################################################################# '## Forum Moderators - listbox Code '################################################################################# if (strRqMethod = "Forum" or _ strRqMethod = "URL" or _ strRqMethod = "EditURL" or _ strRqMethod = "EditForum") and (mLev > 3 or lcase(strNoCookies) = "1") then Response.Write " " & vbNewLine & _ " " & vbNewLine strSql = "SELECT MEMBER_ID, M_NAME " strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS " strSql = strSql & " WHERE M_LEVEL > 1 " strSql = strSql & " AND M_STATUS = " & 1 strSql = strSql & " ORDER BY M_NAME ASC " set rsModerators = Server.CreateObject("ADODB.Recordset") rsModerators.open strSql, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText if rsModerators.EOF then recModeratorsCount = "" else allModeratorsData = rsModerators.GetRows(adGetRowsRest) recModeratorsCount = UBound(allModeratorsData,2) meMEMBER_ID = 0 meM_NAME = 1 end if rsModerators.close set rsModerators = nothing tmpStrUserList = "" if strRqMethod = "EditForum" or strRqMethod = "EditURL" then strSql = "SELECT MO.MEMBER_ID, M.M_NAME " strSql = strSql & " FROM " & strTablePrefix & "MODERATOR MO, " & strMemberTablePrefix & "MEMBERS M" strSql = strSql & " WHERE MO.FORUM_ID = " & strRqForumID & " AND M.MEMBER_ID = MO.MEMBER_ID" set rsForumModerator = Server.CreateObject("ADODB.Recordset") rsForumModerator.open strSql, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText if rsForumModerator.EOF then recForumModeratorCount = "" else allForumModeratorData = rsForumModerator.GetRows(adGetRowsRest) recForumModeratorCount = UBound(allForumModeratorData,2) moMEMBER_ID = 0 moM_NAME = 1 end if rsForumModerator.close set rsForumModerator = nothing if recForumModeratorCount <> "" then for iForumModerator = 0 to recForumModeratorCount ForumModeratorMemberID = allForumModeratorData(moMEMBER_ID, iForumModerator) if tmpStrUserList = "" then tmpStrUserList = ForumModeratorMemberID else tmpStrUserList = tmpStrUserList & "," & ForumModeratorMemberID end if next end if end if SelectSize = 6 Response.Write " " & vbNewLine & _ " " & vbNewLine end if '################################################################################# '## Forum Moderators - End of listbox code '################################################################################# ' DEM --> Start of Code added for full moderation and subscription services if strRqMethod = "Forum" or strRqMethod = "EditForum" or _ strRqMethod = "Category" or strRqMethod = "EditCategory" then if strSubscription > 0 and strEmail = "1" and _ ((strRqMethod = "Category" or strRqMethod = "EditCategory") or _ ((strRqMethod = "Forum" or strRqMethod = "EditForum") and (CatSubscription > 0))) then ' Subscription service first..... Response.Write " " & vbNewline Response.Write " " & vbNewLine Response.Write " " & vbNewline Response.Write " " & vbNewLine end if ' Topic Moderation Code - Check if Moderation is allowed over the entire board, then ' check if Moderation is allowed for the next level up. if strModeration > 0 and _ ((strRqMethod = "Category" or strRqMethod = "EditCategory") or _ ((strRqMethod = "Forum" or strRqMethod = "EditForum") and CatModeration > 0)) then Response.Write " " & vbNewline Response.Write " " & vbNewLine Response.Write " " & vbNewline Response.Write " " & vbNewline end if end if ' DEM --> End of Code Added for Moderation and Subscription if strRqMethod = "Edit" or _ strRqMethod = "URL" or strRqMethod = "EditURL" or _ strRqMethod = "Reply" or strRqMethod = "ReplyQuote" or _ strRqMethod = "EditTopic" or strRqMethod = "Topic" or strRqMethod = "TopicQuote" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewline Response.Write " " & vbNewline end if if strPrivateForums <> "0" then if strRqMethod = "Forum" or _ strRqMethod = "URL" or _ strRqMethod = "EditURL" or _ strRqMethod = "EditForum" then if strRqMethod = "EditForum" or _ strRqMethod = "EditURL" then ForumAuthType = fPrivateForums else ForumAuthType = 0 end if Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine '################################################################################# '## Allowed User - listbox Code '################################################################################# strSql = "SELECT MEMBER_ID, M_NAME " strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS " strSql = strSql & " WHERE M_STATUS = " & 1 strSql = strSql & " ORDER BY M_NAME ASC " set rsMember = Server.CreateObject("ADODB.Recordset") rsMember.open strSql, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText if rsMember.EOF then recMemberCount = "" else allMemberData = rsMember.GetRows(adGetRowsRest) recMemberCount = UBound(allMemberData,2) meMEMBER_ID = 0 meM_NAME = 1 end if rsMember.close set rsMember = nothing tmpStrUserList = "" if strRqMethod = "EditForum" or strRqMethod = "EditURL" then strSql = "SELECT AM.MEMBER_ID, M.M_NAME" strSql = strSql & " FROM " & strTablePrefix & "ALLOWED_MEMBERS AM, " & strMemberTablePrefix & "MEMBERS M" strSql = strSql & " WHERE AM.FORUM_ID = " & strRqForumID & " AND M.MEMBER_ID = AM.MEMBER_ID" set rsAllowedMember = Server.CreateObject("ADODB.Recordset") rsAllowedMember.open strSql, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText if rsAllowedMember.EOF then recAllowedMemberCount = "" else allAllowedMemberData = rsAllowedMember.GetRows(adGetRowsRest) recAllowedMemberCount = UBound(allAllowedMemberData,2) amMEMBER_ID = 0 amM_NAME = 1 end if rsAllowedMember.close set rsAllowedMember = nothing if recAllowedMemberCount <> "" then for iAllowedMember = 0 to recAllowedMemberCount AllowedMembersMemberID = allAllowedMemberData(amMEMBER_ID, iAllowedMember) if tmpStrUserList = "" then tmpStrUserList = AllowedMembersMemberID else tmpStrUserList = tmpStrUserList & "," & AllowedMembersMemberID end if next end if end if SelectSize = 6 Response.Write " " & vbNewLine & _ " " & vbNewLine '################################################################################# '## Allowed User - End of listbox code '################################################################################# end if end if Response.Write " " & vbNewline & _ " " & vbNewline & _ " " & vbNewline & _ Response.Write "" & vbNewline & _ " " & vbNewline & _ " " & vbNewLine & _ "
    Screensize:" & vbNewLine & _ " " & vbNewLine & _ "
    UserName:
    Password:
    " & vbNewLine & _ " Format Mode:" & vbNewLine & _ " " & vbNewLine & _ " " & getCurrentIcon(strIconSmileQuestion,"","") & "
    " & vbNewLine & _ " Format:" & vbNewLine & _ " " & getCurrentIcon(strIconEditorBold,"Bold","align=""top""") & "" & _ "" & getCurrentIcon(strIconEditorItalicize,"Italicized","align=""top""") & "" & _ "" & getCurrentIcon(strIconEditorUnderline,"Underline","align=""top""") & "" & _ "" & getCurrentIcon(strIconEditorStrike,"Strikethrough","align=""top""") & "" & vbNewLine & _ " " & getCurrentIcon(strIconEditorLeft,"Align Left","align=""top""") & "" & _ "" & getCurrentIcon(strIconEditorCenter,"Centered","align=""top""") & "" & _ "" & getCurrentIcon(strIconEditorRight,"Align Right","align=""top""") & "" & vbNewLine & _ " " & getCurrentIcon(strIconEditorHR,"Horizontal Rule","align=""top""") & "" & _ " " & getCurrentIcon(strIconEditorUrl,"Insert Hyperlink","align=""top""") & "" & _ "" & getCurrentIcon(strIconEditorEmail,"Insert Email","align=""top""") & "" if strIMGInPosts = "1" then Response.Write "" & getCurrentIcon(strIconEditorImage,"Insert Image","align=""top""") & "" & vbNewLine end if Response.Write " " & getCurrentIcon(strIconEditorCode,"Insert Code","align=""top""") & "" & _ "" & getCurrentIcon(strIconEditorQuote,"Insert Quote","align=""top""") & "" & _ "" & getCurrentIcon(strIconEditorList,"Insert List","align=""top""") & "" & vbNewLine if lcase(strIcons) = "1" and strShowSmiliesTable = "0" then Response.Write " " & getCurrentIcon(strIconEditorSmilie,"Insert Smilie","align=""top""") & "" & vbNewLine end if Response.Write "
    " & vbNewLine & _ " " & vbNewLine & _ "  " & vbNewLine & _ "  " & vbNewLine & _ "
    Category:" & vbNewLine & _ " " & vbNewLine & _ " " & getCurrentIcon(strIconSmileQuestion,"Click here to get more help on this option","") & "
    Forum:" & vbNewLine if mlev = 3 or mlev = 4 then Response.Write " " & vbNewLine end if 'set rsForum = nothing if mlev = 3 or mlev = 4 then Response.Write " " & vbNewline end if Response.Write "
    Default Days:" & vbNewLine & _ " " & getCurrentIcon(strIconSmileQuestion,"Click here to get more help on this option","") & "
    Increase Post Count:" & vbNewLine & _ " " & getCurrentIcon(strIconSmileQuestion,"Click here to get more help on this option","") & "
    Subject:
    Address: "") then Response.Write(TxtURL) else Response.Write("http://") Response.Write """ size=""40"">" & getCurrentIcon(strIconSmileQuestion,"Click here to get more help on this option","") & "
    Message:
    " & vbNewLine & _ "
    " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "
    " & vbNewLine if strAllowHTML = "1" then Response.Write " * HTML is ON
    " & vbNewLine else Response.Write " * HTML is OFF
    " & vbNewLine end if if strAllowForumCode = "1" then Response.Write " * Forum Code is ON
    " & vbNewLine else Response.Write " * Forum Code is OFF
    " & vbNewLine end if if strIcons = "1" and strShowSmiliesTable = "1" then if strRqMethod = "Edit" or strRqMethod = "EditTopic" or _ strRqMethod = "Reply" or strRqMethod = "ReplyQuote" or _ strRqMethod = "Topic" or strRqMethod = "TopicQuote" then %> <% '################################################################################# '## Snitz Forums 2000 v3.4.06 '################################################################################# '## Copyright (C) 2000-06 Michael Anderson, Pierre Gorissen, '## Huw Reddick and Richard Kinser '## '## This program is free software; you can redistribute it and/or '## modify it under the terms of the GNU General Public License '## as published by the Free Software Foundation; either version 2 '## of the License, or (at your option) any later version. '## '## All copyright notices regarding Snitz Forums 2000 '## must remain intact in the scripts and in the outputted HTML '## The "powered by" text/logo with a link back to '## http://forum.snitz.com in the footer of the pages MUST '## remain visible when the pages are viewed on the internet or intranet. '## '## This program is distributed in the hope that it will be useful, '## but WITHOUT ANY WARRANTY; without even the implied warranty of '## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the '## GNU General Public License for more details. '## '## You should have received a copy of the GNU General Public License '## along with this program; if not, write to the Free Software '## Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. '## '## Support can be obtained from our support forums at: '## http://forum.snitz.com '## '## Correspondence and Marketing Questions can be sent to: '## manderson@snitz.com '## '################################################################################# Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "
    Smilies
    " & getCurrentIcon(strIconSmile,"Smile [:)]","") & "" & getCurrentIcon(strIconSmileBig,"Big Smile [:D]","") & "" & getCurrentIcon(strIconSmileCool,"Cool [8D]","") & "" & getCurrentIcon(strIconSmileBlush,"Blush [:I]","") & "
    " & getCurrentIcon(strIconSmileTongue,"Tongue [:P]","") & "" & getCurrentIcon(strIconSmileEvil,"Evil [):]","") & "" & getCurrentIcon(strIconSmileWink,"Wink [;)]","") & "" & getCurrentIcon(strIconSmileClown,"Clown [:o)]","") & "
    " & getCurrentIcon(strIconSmileBlackeye,"Black Eye [B)]","") & "" & getCurrentIcon(strIconSmile8ball,"Eight Ball [8]","") & "" & getCurrentIcon(strIconSmileSad,"Frown [:(]","") & "" & getCurrentIcon(strIconSmileShy,"Shy [8)]","") & "
    " & getCurrentIcon(strIconSmileShock,"Shocked [:0]","") & "" & getCurrentIcon(strIconSmileAngry,"Angry [:(!]","") & "" & getCurrentIcon(strIconSmileDead,"Dead [xx(]","") & "" & getCurrentIcon(strIconSmileSleepy,"Sleepy [|)]","") & "
    " & getCurrentIcon(strIconSmileKisses,"Kisses [:X]","") & "" & getCurrentIcon(strIconSmileApprove,"Approve [^]","") & "" & getCurrentIcon(strIconSmileDisapprove,"Disapprove [V]","") & "" & getCurrentIcon(strIconSmileQuestion,"Question [?]","") & "
    " & vbNewLine %> <% end if end if Response.Write "
    " & vbNewLine & _ "

    Moderators:" & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "
    Available
    " & vbNewLine & _ " " & vbNewLine & _ "

    " & vbNewLine & _ " " & getCurrentIcon(strIconPrivateRemAll,"","") & "" & vbNewLine & _ " " & getCurrentIcon(strIconPrivateRemove,"","") & "" & vbNewLine & _ " " & getCurrentIcon(strIconPrivateAdd,"","") & "" & vbNewLine & _ " " & getCurrentIcon(strIconPrivateAddAll,"","") & "" & vbNewLine & _ "
    Selected
    " & vbNewLine & _ " " & vbNewLine & _ "
     " & getCurrentIcon(strIconSmileQuestion,"Click here to get more help on this option","") & "
    " & vbNewLine & _ "
    Subscription:" & vbNewLine Response.Write " " & vbNewline Response.Write " " & getCurrentIcon(strIconSmileQuestion,"Click here to get more help on this option","") & "
    Moderation:" & vbNewLine Response.Write " " & vbNewline Response.Write " " & getCurrentIcon(strIconSmileQuestion,"Click here to get more help on this option","") & " 
     " & vbNewLine if strRqMethod = "Edit" or strRqMethod = "Reply" or strRqMethod = "ReplyQuote" or _ strRqMethod = "Topic" or strRqMethod = "EditTopic" or strRqMethod = "TopicQuote" then if (strRqMethod = "Reply" or strRqMethod = "ReplyQuote" or _ strRqMethod = "Topic" or strRqMethod = "TopicQuote") and strSignatures = "1" and strDSignatures <> "1" then Response.Write " " & vbNewLine intSigDefault = getSigDefault(MemberID) Response.Write "
    " & vbNewLine end if if strSignatures = "1" and strDSignatures = "1" then Response.Write " " if strRqMethod = "Edit" then Response.Write "
    " & vbNewLine elseif strRqMethod = "EditTopic" then Response.Write "
    " & vbNewLine else intSigDefault = getSigDefault(MemberID) Response.Write "
    " & vbNewLine end if end if '## Subscribe checkbox start ## if strSubscription > 0 and postCat_Subscription > 0 and postForum_Subscription > 0 and strEmail = 1 then ' -- Check for a topic subscription held by the user Dim strSubString, strSubArray, strBoardSubs, strCatSubs, strForumSubs, strTopicSubs if MySubCount > 0 then strSubString = PullSubscriptions(0, 0, 0) strSubArray = Split(strSubString,";") if uBound(strSubArray) < 0 then strBoardSubs = "" strCatSubs = "" strForumSubs = "" strTopicSubs = "" else strBoardSubs = strSubArray(0) strCatSubs = strSubArray(1) strForumSubs = strSubArray(2) strTopicSubs = strSubArray(3) end If end if SubLinkFontStart = " " SubLinkFontEnd = "
    " & vbNewLine if InArray(strTopicSubs, strRqTopicID) and strRqMethod <> "Topic" then Response.Write SubLinkFontStart & ShowSubLink ("U", strRqCatID, strRqForumID, strRqTopicID, "Y") & SubLinkFontEnd elseif strBoardSubs <> "Y" and not(InArray(strForumSubs,strRqForumID) or InArray(strCatSubs,strRqCatID)) then Response.Write SubLinkFontStart & ShowSubLink ("S", strRqCatID, strRqForumID, strRqTopicID, "Y") & SubLinkFontEnd end if end if '# Subscribe checkbox end ## if ((mLev = 4) or (chkForumModerator(strRqForumId, strDBNTUserName) = "1")) _ and (strRqMethod = "Topic" or strRqMethod = "EditTopic" or strRqMethod = "Reply" or _ strRqMethod = "ReplyQuote" or strRqMethod = "TopicQuote") then if strStickyTopic = "1" then if strRqMethod = "Topic" then Response.Write "
    " & vbNewLine elseif strRqMethod = "EditTopic" then Response.Write "
    " & vbNewLine end if end if if blnTStatus = 1 then if strRqMethod <> "EditTopic" then Response.Write "
    " & vbNewLine end if end if end if if (strDBNTUserName = "" and strSignatures <> "1") or (strRqMethod = "EditTopic" and strDSignatures <> "1") then Response.Write "  " & vbNewLine end if end if Response.Write "
    Auth Type:" & vbNewLine & _ "  " & getCurrentIcon(strIconSmileQuestion,"Click here to get more help on this option","") & "" & vbNewLine if strRqMethod = "Forum" or _ strRqMethod = "EditForum" then if strRqMethod = "EditForum" then If fPasswordNew <> " " Then strPassword = fPasswordNew else strPassword = " " end if else strPassword = " " end if Response.Write "
    Password" if strNTGroups = "1" then Response.Write(" or Global Groups") Response.Write ":
    " & vbNewLine & _ " " end if Response.Write "
    Allowed Member List:" & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "
    Available
    " & vbNewLine & _ " " & vbNewLine & _ "

    " & vbNewLine & _ " " & getCurrentIcon(strIconPrivateRemAll,"","") & "" & vbNewLine & _ " " & getCurrentIcon(strIconPrivateRemove,"","") & "" & vbNewLine & _ " " & getCurrentIcon(strIconPrivateAdd,"","") & "" & vbNewLine & _ " " & getCurrentIcon(strIconPrivateAddAll,"","") & "" & vbNewLine & _ "
    Selected
    " & vbNewLine & _ " " & vbNewLine & _ "
     " & getCurrentIcon(strIconSmileQuestion,"Click here to get more help on this option","") & "
    " & vbNewLine & _ "
      "0" then if mLev = 3 then Response.Write " onclick=""selectAllOptions(document.PostTopic.AuthUsers);""" else Response.Write " onclick=""selectAllOptions(document.PostTopic.AuthUsers);selectAllOptions(document.PostTopic.ForumMod);""" end if else if mLev > 3 then Response.Write " onclick=""selectAllOptions(document.PostTopic.ForumMod);""" end if end if Response.Write ">" if strAllowForumCode = "1" or strAllowHTML = "1" then if strRqMethod = "Reply" or _ strRqMethod = "ReplyQuote" or _ strRqMethod = "Edit" or _ strRqMethod = "EditTopic" or _ strRqMethod = "Topic" or _ strRqMethod = "TopicQuote" then Response.Write " " end if end if 'Response.Write " 
    " & vbNewline & _ "
    " & vbNewline & _ "
    " & vbNewline if strRqMethod = "Reply" or _ strRqMethod = "TopicQuote" or _ strRqMethod = "ReplyQuote" then Response.Write "
    " & vbNewLine & _ "" & vbNewLine & _ " " & vbNewLine & _ "
    " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewline & _ " " & vbNewline & _ "
    " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine if (mLev = 4) or (chkForumModerator(strRqForumId, strDBNTUserName) = "1") then Moderation = "N" else ' DEM --> Added Select of Moderation Fields strSQL = "SELECT C.CAT_MODERATION, F.F_MODERATION " strSQL = strSQL & "FROM " & strTablePrefix & "CATEGORY C, " & strTablePrefix & "FORUM F " strSQL = strSQL & " WHERE C.CAT_ID = " & strRqCatID strSQL = strSQL & " AND F.FORUM_ID = " & strRqForumID set rsa = my_Conn.Execute (strSql) ' ## Moderators and Admins can see unmoderated posts. if strModeration = 1 and rsa("CAT_MODERATION") = 1 and (rsa("F_MODERATION") = 1 or rsa("F_MODERATION") = 3) then Moderation = "Y" else Moderation = "N" end if set rsa = nothing end if ' DEM --> End of Moderation Code '## Forum_SQL strSql = "SELECT M.M_NAME, T.T_DATE, T.T_MESSAGE " strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS M, " & strActivePrefix & "TOPICS T " strSql = strSql & " WHERE M.MEMBER_ID = T.T_AUTHOR AND T.TOPIC_ID = " & strRqTopicID set rs = my_Conn.Execute (strSql) Response.Write " " & vbNewline Response.Write " " & vbNewline Response.Write " " & vbNewline Response.Write " " & vbNewline rs.close set rs = nothing '## Forum_SQL - Get all replies to Topic from the DB strSql ="SELECT M.M_NAME, R.R_DATE, R.R_MESSAGE " strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS M, " & strActivePrefix & "REPLY R " strSql = strSql & " WHERE M.MEMBER_ID = R.R_AUTHOR AND R.TOPIC_ID = " & strRqTopicID ' DEM --> Added check for moderation so that only admins and moderators can see the unapproved posts. if Moderation = "Y" then strSql = strSql & " AND R.R_STATUS < 2 " ' Ignore unapproved and rejected posts... else strSql = strSql & " AND R.R_STATUS < 3 " ' Ignore all rejected posts.... end if strSql = strSql & " ORDER BY R.R_DATE DESC;" set rs = Server.CreateObject("ADODB.Recordset") rs.open TopSQL(strSql,strPageSize), my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText if rs.EOF then recReplyCount = "" else allReplyData = rs.GetRows(adGetRowsRest) recReplyCount = UBound(allReplyData,2) end if rs.close set rs = nothing strI = 0 if recReplyCount = "" then Response.Write "" else Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine mM_NAME = 0 rR_DATE = 1 rR_MESSAGE = 2 for iReply = 0 to recReplyCount ReplyMemberName = allReplyData(mM_NAME, iReply) ReplyDate = allReplyData(rR_DATE, iReply) ReplyMessage = allReplyData(rR_MESSAGE, iReply) if strI = 0 then CColor = strAltForumCellColor else CColor = strForumCellColor end if Response.Write " " & vbNewline & _ " " & vbNewline & _ " " & vbNewline & _ " " & vbNewline strI = strI + 1 if strI = 2 then strI = 0 end if next end if Response.Write "
    T O P I C    R E V I E W
    " & ChkString(rs("M_NAME"),"display") & "Posted - " & ChkDate(rs("T_DATE"), " :" ,true) & "
    " & formatStr(rs("T_MESSAGE")) & "
    " & recReplyCount+1 & "   L A T E S T    R E P L I E S    (Newest First)
    " & ChkString(ReplyMemberName,"display") & "Posted - " & ChkDate(ReplyDate, " :" ,true) & "
    " & formatStr(ReplyMessage) & "
    " & vbNewline & _ "
    " & vbNewline & _ "
    " & vbNewline end if WriteFooter function Go_Result(message) Response.write "
    " & message & "
    " &_ "
    " &_ " " WriteFooter Response.end end function %>