<% '################################################################################# '## 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=mysql245.secureserver.net;uid=dbdhamma;pwd=success;database=dbdhamma" '## MySQL w/ MyODBC v2.50 strConnString = "driver={MySQL ODBC 3.51 Driver};option=16387;server=dhammadb.db.8972160.hostedresource.com;user=dhammadb;password=Nak28Oz!;DATABASE=dbdhamma;" '##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 %> <% ' 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 & _ " 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 '## '################################################################################# 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 %> <% '################################################################################# '## 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 DisplayProfileForm on error resume next strMode = Request.QueryString("mode") Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "

    All Fields marked with * are required" if lcase(strEmail) = "1" and strEmailVal = "1" then if strMode = "Register" then Response.Write("
    To complete your registration, you need to have a valid e-mail address.") else if strMode <> "goModify" then Response.Write("
    If you change your e-mail address, a confirmation e-mail will be sent to your new address.
    Please make sure it is a valid address.
    ") else Response.Write("
    If you change the e-mail address, a confirmation e-mail will be sent to the new address.
    Please make sure it is a valid address.
    ") end if end if end if Response.Write "

    " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine if strUseExtendedProfile then Response.Write " " & vbNewLine end if 'extended profile Response.Write " " & vbNewLine & _ " " & vbNewLine & _ "
    " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine if strMode = "Register" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if Response.Write " " & vbNewLine & _ " " & vbNewLine if strMode = "Register" then Response.Write " " & vbNewLine else Response.Write " " & vbNewLine end if Response.Write " " & vbNewLine if strMode = "goModify" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if if strAIM = "1" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if if strICQ = "1" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if if strMSN = "1" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if if strYAHOO = "1" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if if (strHomepage + strFavLinks) > 0 and (strUseExtendedProfile) then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine if strHomepage = "1" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if if strFavLinks = "1" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if end if if strPicture = "1" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if ' strPicture if (strBio + strHobbies + strLNews + strQuote) > 0 then if strMode <> "Register" then strMyHobbies = rs("M_HOBBIES") strMyLNews = rs("M_LNEWS") strMyQuote = rs("M_QUOTE") strMyBio = rs("M_BIO") end if Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine if strHobbies = "1" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if if strLNews = "1" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if if strQuote = "1" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if if strBio = "1" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if end if Response.Write "
     Contact Info 
    * E-mail Address:  "Register" then Response.Write(rs("M_EMAIL")) Response.Write """>" & vbNewLine & _ " "Register" then Response.Write(rs("M_EMAIL")) Response.Write """>
    * E-mail Address Again: 
    Allow Forum Members
    to Send you E-Mail?: 
    " & vbNewLine & _ " " & vbNewLine & _ "
    Initial IP: " & ChkString(rs("M_IP"), "display") & "
    Last IP: " & ChkString(rs("M_LAST_IP"), "display") & "
    AIM:  "Register" then Response.Write(ChkString(rs("M_AIM"), "display")) Response.Write """>
    ICQ:  "Register" then Response.Write(ChkString(rs("M_ICQ"), "display")) Response.Write """>
    MSN:  "Register" then Response.Write(ChkString(rs("M_MSN"), "display")) Response.Write """>
    YAHOO IM:  "Register" then Response.Write(ChkString(rs("M_YAHOO"), "display")) Response.Write """>
    " & vbNewLine & _ " Links 
    Homepage:  "Register" then if ChkString(rs("M_HOMEPAGE"), "display") <> " " and lcase(rs("M_HOMEPAGE")) <> "http://" then Response.Write(rs("M_HOMEPAGE")) else Response.Write("http://") else Response.Write("http://") end if Response.Write """>
    Cool Links:  "Register" then if rs("M_LINK1") <> " " and lcase(rs("M_LINK1")) <> "http://" then Response.Write(ChkString(rs("M_LINK1"), "display")) else Response.Write("http://") else Response.Write("http://") end if Response.Write """>
      "Register" then if rs("M_LINK2") <> " " and lcase(rs("M_LINK2")) <> "http://" then Response.Write(ChkString(rs("M_LINK2"), "display")) else Response.Write("http://") else Response.Write("http://") end if Response.Write """>
    " & vbNewLine & _ " Picture 
    Picture URL:  "Register" then if rs("M_PHOTO_URL") <> " " and lcase(rs("M_PHOTO_URL")) <> "http://" then Response.Write(ChkString(rs("M_PHOTO_URL"), "displayimage")) else Response.Write("http://") else Response.Write("http://") end if Response.Write """>
    More About Me
    Hobbies: 
    Latest News: 
    Favorite Quote: 
    Bio: 
    " & vbNewLine & _ "
    " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine if strMode = "goModify" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if if strAuthType = "nt" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine else if strMode = "Register" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine else Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine if strMode = "goEdit" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if end if end if if strFullName = "1" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if if strCity = "1" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if if strState = "1" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if if strCountry = "1" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if if strAge = "1" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if ' if strAgeDOB = "1" then ' Response.Write " " & vbNewLine ' Response.Write " " & vbNewLine & _ ' " " & vbNewLine & _ ' " " & vbNewLine & _ ' " " & vbNewLine ' end if if strAgeDOB = "1" then strDOByear = "" strDOBmonth = "" strDOBday = "" if strMode <> "Register" then strMDOB = trim(ChkString(rs("M_DOB"), "display")) if len(strMDOB) > 0 then strDOByear = cInt(left(strMDOB, 4)) strDOBmonth = cInt(mid(strMDOB, 5, 2)) strDOBday = cInt(right(strMDOB, 2)) end if end if Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " "& vbNewLine & _ " " & vbNewLine end if if strSex = "1" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if if strMarStatus = "1" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if if strOccupation = "1" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if if strMode = "goModify" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if if strSignatures = "1" then if strMode <> "Register" then strTxtSig = rs("M_SIG") end if Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine if strMode <> "goModify" then if strDSignatures = "1" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if end if if Request.Form("Method_Type") = "Modify" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if if not(strUseExtendedProfile) then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine if strMode = "Register" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if Response.Write " " & vbNewLine & _ " " & vbNewLine if strMode = "Register" then Response.Write " " & vbNewLine else Response.Write " " & vbNewLine end if Response.Write " " & vbNewLine if strAIM = "1" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if if strICQ = "1" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if if strMSN = "1" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if if strYAHOO = "1" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if end if if (strHomepage + strFavLinks) > 0 and not(strUseExtendedProfile) then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine if strHomepage = "1" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if if strFavLinks = "1" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine end if end if Response.Write "
    Basics
    * User Name: " & vbNewLine if (strMode = "goEdit") or (strMode = "goModify" and cLng(Request.Form("MEMBER_ID")) = cLng(intAdminMemberID)) then Response.Write " " & ChkString(rs("M_NAME"), "display") & "" & vbNewLine & _ " " & vbNewLine else Response.Write " "Register" then Response.Write(ChkString(rs("M_NAME"), "display")) Response.Write """>" & vbNewLine end if Response.Write "
    Title: 
    * Your Account: " & vbNewLine if Request.Form("Method_Type") = "Modify" then Response.Write " " & vbNewLine else Response.Write " " & Session(strCookieURL & "userid") & "" & vbNewLine end if Response.Write "
    * Password: 
    * Password Again: 
     New Password: " & vbNewLine & _ "
     New Password Again: 
    Firstname:  "Register" then Response.Write(rs("M_FIRSTNAME")) Response.Write """>
    Surname:  "Register" then Response.Write(rs("M_LASTNAME")) Response.Write """>
    City:  "Register" then Response.Write(rs("M_CITY")) Response.Write """>
    State:  "Register" then Response.Write(rs("M_STATE")) Response.Write """>
    Country: " & vbNewLine & _ "
    Age:  "Register" then Response.Write(ChkString(rs("M_AGE"), "display")) Response.Write """>
    Birth Date:  "Register" then Response.Write(trim(ChkString(rs("M_DOB"), "display"))) ' Response.Write """>" & getCurrentIcon(strIconCalendar,"Choose Date","align=""absmiddle""") & "
    Birth Date: " & vbNewLine & _ " "& vbNewLine & _ " "& vbNewLine & _ " "& vbNewLine & _ "
    Gender: " & vbNewLine & _ "
    Marital Status:  "Register" then Response.Write(ChkString(rs("M_MARSTATUS"), "display")) Response.Write """>
    Occupation:  "Register" then Response.Write(ChkString(rs("M_OCCUPATION"), "display")) Response.Write """>
    # of Posts: 
    Signature: 
    " & 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 Response.Write "
    " & vbNewLine & _ "
    " & vbNewLine & _ "  
    View Signatures
    in Posts?: 
    " & vbNewLine & _ "
    Signature checkbox
    checked by default?: 
    " & vbNewLine & _ "
    Member Level: " & vbNewLine if rs("MEMBER_ID") = intAdminMemberID then Response.Write " Administrator" & vbNewLine & _ " " & vbNewLine else Response.Write " " & vbNewLine end if Response.Write "
     Contact Info 
    * E-mail Address:  "Register" then Response.Write(ChkString(rs("M_EMAIL"), "display")) Response.Write """>" & vbNewLine & _ " "Register" then Response.Write(rs("M_EMAIL")) Response.Write """>
    * E-mail Address Again: 
    Allow Forum Members
    to Send you E-Mail?: 
    " & vbNewLine & _ " " & vbNewLine & _ "
    AIM:  "Register" then Response.Write(ChkString(rs("M_AIM"), "display")) Response.Write """>
    ICQ:  "Register" then Response.Write(ChkString(rs("M_ICQ"), "display")) Response.Write """>
    MSN:  "Register" then Response.Write(ChkString(rs("M_MSN"), "display")) Response.Write """>
    YAHOO IM:  "Register" then Response.Write(ChkString(rs("M_YAHOO"), "display")) Response.Write """>
    Links 
    Homepage:  "Register" then if rs("M_HOMEPAGE") <> " " and lcase(rs("M_HOMEPAGE")) <> "http://" then Response.Write(ChkString(rs("M_HOMEPAGE"), "display")) else Response.Write("http://") else Response.Write("http://") end if Response.Write """>
    Cool Links:  "Register" then if rs("M_LINK1") <> " " and lcase(rs("M_LINK1")) <> "http://" then Response.Write(ChkString(rs("M_LINK1"), "display")) else Response.Write("http://") else Response.Write("http://") end if Response.Write """>
      "Register" then if rs("M_LINK2") <> " " and lcase(rs("M_LINK2")) <> "http://" then Response.Write(ChkString(rs("M_LINK2"), "display")) else Response.Write("http://") else Response.Write("http://") end if Response.Write """>
    " & vbNewLine & _ "
    " & vbNewLine & _ "
    " & vbNewLine if strUseExtendedProfile then Response.Write "

    Back To Forum

    " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "
    " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "
    " & vbNewLine else Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "
    " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "
    " & vbNewLine end if on error goto 0 end Sub %> <% Dim strURLError if Request.Form("policy_accept") = "true" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "
    " & getCurrentIcon(strIconFolderOpen,"","") & " All Forums
    " & vbNewLine & _ " " & getCurrentIcon(strIconBar,"","") & getCurrentIcon(strIconFolderOpenTopic,"","") & " Registration Rules and Policies Agreement
    " & vbNewLine & _ " " & getCurrentIcon(strIconBlank,"","") & getCurrentIcon(strIconBar,"","") & getCurrentIcon(strIconFolderOpenTopic,"","") & " Registration Form for " & strForumTitle & "
    " & vbNewLine end if if strProhibitNewMembers <> "1" then if Request.QueryString("mode") <> "DoIt" and Request.QueryString("actkey") = "" then if Request.Form("policy_accept") <> "true" 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 & _ " " & getCurrentIcon(strIconFolderOpen,"","") & " All Forums
    " & vbNewLine & _ " " & getCurrentIcon(strIconBar,"","") & getCurrentIcon(strIconFolderOpenTopic,"","") & " Registration Rules and Policies Agreement
    " & vbNewLine if strProhibitNewMembers <> "1" then Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "
    " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "
    Privacy Statement for " & strForumTitle & "
    " & vbNewLine & _ "

    If you agree to the terms and conditions stated below, " & _ "press the "Agree" button. Otherwise, press "Cancel".

    " & vbNewLine & _ "

    In order to use these forums, users are required to " & _ "provide a username, password and e-mail address. Neither the Administrators of " & _ "these forums, or the Moderators participating, are responsible for the privacy " & _ "practices of any user. Remember that all information that is disclosed in these " & _ "areas becomes public information and you should exercise caution when deciding " & _ "to share any of your personal information. Any user who finds material posted by " & _ "another user objectionable is encouraged to contact us via e-mail. We are " & _ "authorized by you to remove or modify any data submitted by you to these forums " & _ "for any reason we feel constitutes a violation of our policies, whether stated, " & _ "implied or not.

    " & vbNewLine & _ "

    This site may contain links to other web sites and " & _ "files. We have no control over the content and can not ensure it will not be offensive " & _ "or objectionable. We will, however, remove links to material that we feel is inappropriate as we become aware of them.

    " & vbNewLine & _ "

    Cookies must be turned on in your browser to participate " & _ "as a user in these forums. Cookies are used here to hold your username and " & _ "password and viewing options, allowing you to login.

    " & vbNewLine & _ "

    By pressing the "Agree" button, you agree that you, the " & _ "user, are " if strMinAge > 0 then Response.Write strMinAge else Response.Write "13" end if Response.Write " years of age or over. You are fully responsible for any information " & _ "or file supplied by this user. You also agree that you will not post any " & _ "copyrighted material that is not owned by yourself or the owners of these " & _ "forums. In your use of these forums, you agree that you will not post any " & _ "information which is vulgar, harassing, hateful, threatening, invading of others " & _ "privacy, sexually oriented, or violates any laws.

    " & vbNewLine & _ "

    If you do agree with the rules and policies stated in " & _ "this agreement, and meet the criteria stated herein, proceed to press the " & _ ""Agree" button below, otherwise press "Cancel".

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

    If you have any questions about this privacy statement " & _ "or the use of these forums, you can contact the forum administrator at: " & _ "" & strSender & "

    " & vbNewLine & _ "
    " & vbNewLine & _ "
    " & vbNewLine & _ "
    " & vbNewLine else Response.Write "

    Sorry, we are not accepting any new Members at this time.

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

    Back To Forum


    " & vbNewLine end if WriteFooter Response.End %> <% end if if strAuthType = "nt" and ChkAccountReg = "1" then Response.Write "

    Registration for this account is not necessary.

    " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "
    • This NT User account has already been registered.
    " & vbNewLine WriteFooter Response.End end if if strUseExtendedProfile then strColspan = " colspan=""2""" else strColspan = "" end if call ShowForm '################################ E-mail Validation Mod ################################# elseif Request.QueryString("actkey") <> "" and lcase(strEmail) = "1" and strEmailVal = "1" then key = chkString(Request.QueryString("actkey"),"SQLString") '###Forum_SQL strSql = "SELECT M_NAME, M_USERNAME, M_PASSWORD, M_KEY, M_LEVEL, M_EMAIL, M_DATE, M_COUNTRY, M_AIM, M_ICQ, M_MSN, M_YAHOO" & _ ", M_POSTS, M_HOMEPAGE, M_LASTHEREDATE, M_STATUS, M_RECEIVE_EMAIL, M_LAST_IP, M_IP, M_SIG, M_VIEW_SIG, M_SIG_DEFAULT" & _ ", M_FIRSTNAME, M_LASTNAME, M_CITY, M_STATE, M_PHOTO_URL, M_LINK1, M_LINK2, M_AGE, M_DOB, M_MARSTATUS, M_SEX, M_OCCUPATION" & _ ", M_BIO, M_HOBBIES, M_LNEWS, M_QUOTE, M_SHA256" & _ " FROM " & strMemberTablePrefix & "MEMBERS_PENDING" & _ " WHERE M_KEY = '" & key & "'" set rsKey = my_Conn.Execute (strSql) if rsKey.EOF or rsKey.BOF then '## activation key not found 'Error message to user Response.Write "

    Activation Key Not Found!

    " & vbNewLine & _ "

    Your activation key was not found in our database.
    Please try registering again by clicking the Register link at the top right hand corner.
    If this problem persists, please contact the Administrator of the forums.

    " & vbNewLine & _ "

    Back To Forum

    " & vbNewLine elseif strComp(key,rsKey("M_KEY")) <> 0 then 'Error message to user Response.Write "

    Activation Key Did Not Match!

    " & vbNewLine & _ "

    Your activation key did not match the one that we have in our database.
    Please try registering again by clicking the Register link at the top right hand corner.
    If this problem persists, please contact the Administrator of the forums.

    " & vbNewLine & _ "

    Back To Forum

    " & vbNewLine else '## Forum_SQL strSql = "INSERT INTO " & strMemberTablePrefix & "MEMBERS " strSql = strSql & "(M_NAME" strSql = strSql & ", M_USERNAME" strSql = strSql & ", M_PASSWORD" strSql = strSql & ", M_LEVEL" strSql = strSql & ", M_EMAIL" strSql = strSql & ", M_DATE" strSql = strSql & ", M_COUNTRY" strSql = strSql & ", M_AIM" strSql = strSql & ", M_ICQ" strSql = strSql & ", M_MSN" strSql = strSql & ", M_YAHOO" strSql = strSql & ", M_POSTS" strSql = strSql & ", M_HOMEPAGE" strSql = strSql & ", M_LASTHEREDATE" strSql = strSql & ", M_STATUS" strSql = strSql & ", M_RECEIVE_EMAIL" strSql = strSql & ", M_LAST_IP" strSql = strSql & ", M_IP" strSql = strSql & ", M_SIG" strSql = strSql & ", M_VIEW_SIG" strSql = strSql & ", M_SIG_DEFAULT" strSql = strSql & ", M_FIRSTNAME" strSql = strSql & ", M_LASTNAME" strSql = strSql & ", M_CITY" strSql = strSql & ", M_STATE" strSql = strSql & ", M_PHOTO_URL" strSql = strSql & ", M_LINK1" strSql = strSql & ", M_LINK2" strSql = strsql & ", M_AGE" strSql = strsql & ", M_DOB" strSql = strSql & ", M_MARSTATUS" strSql = strsql & ", M_SEX" strSql = strSql & ", M_OCCUPATION" strSql = strSql & ", M_BIO" strSql = strSql & ", M_HOBBIES" strsql = strsql & ", M_LNEWS" strSql = strSql & ", M_QUOTE" strSql = strSql & ", M_SHA256" strSql = strSql & ") " strSql = strSql & " VALUES (" strSql = strSql & "'" & chkString(rsKey("M_NAME"),"SQLString") & "'" strSql = strSql & ", '" & chkString(rsKey("M_USERNAME"),"SQLString") & "'" strSql = strSql & ", '" & chkString(rsKey("M_PASSWORD"),"SQLString") & "'" strSql = strSql & ", " & "1" strSql = strSql & ", '" & chkString(rsKey("M_EMAIL"),"SQLString") & "'" strSql = strSql & ", '" & DateToStr(strForumTimeAdjust) & "'" strSql = strSql & ", '" & chkString(rsKey("M_COUNTRY"),"SQLString") & "'" strSql = strSql & ", '" & chkString(rsKey("M_AIM"),"SQLString") & "'" strSql = strSql & ", '" & chkString(rsKey("M_ICQ"),"SQLString") & "'" strSql = strSql & ", '" & chkString(rsKey("M_MSN"),"SQLString") & "'" strSql = strSql & ", '" & chkString(rsKey("M_YAHOO"),"SQLString") & "'" strSql = strSql & ", 0" strSql = strSql & ", '" & chkString(rsKey("M_HOMEPAGE"),"SQLString") & "'" strSql = strSql & ", '" & DateToStr(strForumTimeAdjust) & "'" strSql = strSql & ", 1" strSql = strSql & ", " & cLng(rsKey("M_RECEIVE_EMAIL")) & " " strSql = strSql & ", '" & chkString(rsKey("M_LAST_IP"),"SQLString") & "'" strSql = strSql & ", '" & chkString(rsKey("M_IP"),"SQLString") & "'" strSql = strSql & ", '" & chkString(rsKey("M_SIG"),"message") & "'" strSql = strSql & ", '" & chkString(rsKey("M_VIEW_SIG"),"SQLString") & "'" strSql = strSql & ", '" & chkString(rsKey("M_SIG_DEFAULT"),"SQLString") & "'" strSql = strSql & ", '" & chkString(rsKey("M_FIRSTNAME"),"SQLString") & "'" strSql = strSql & ", '" & chkString(rsKey("M_LASTNAME"),"SQLString") & "'" strSql = strSql & ", '" & chkString(rsKey("M_CITY"),"SQLString") & "'" strSql = strSql & ", '" & chkString(rsKey("M_STATE"),"SQLString") & "'" strSql = strSql & ", '" & chkString(rsKey("M_PHOTO_URL"),"SQLString") & "'" strSql = strSql & ", '" & chkString(rsKey("M_LINK1"),"SQLString") & "'" strSql = strSql & ", '" & chkString(rsKey("M_LINK2"),"SQLString") & "'" strSql = strsql & ", '" & chkString(rsKey("M_AGE"),"SQLString") & "'" strSql = strsql & ", '" & chkString(rsKey("M_DOB"),"SQLString") & "'" strSql = strSql & ", '" & chkString(rsKey("M_MARSTATUS"),"SQLString") & "'" strSql = strSql & ", '" & chkString(rsKey("M_SEX"),"SQLString") & "'" strSql = strSql & ", '" & chkString(rsKey("M_OCCUPATION"),"SQLString") & "'" strSql = strSql & ", '" & chkString(rsKey("M_BIO"),"message") & "'" strSql = strSql & ", '" & chkString(rsKey("M_HOBBIES"),"message") & "'" strSql = strSql & ", '" & chkString(rsKey("M_LNEWS"),"message") & "'" strSql = strSql & ", '" & chkString(rsKey("M_QUOTE"),"message") & "'" strSql = strSql & ", 1" strSql = strSql & ")" my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords Call DoCount '## Forum_SQL - Delete the Member strSql = "DELETE FROM " & strMemberTablePrefix & "MEMBERS_PENDING " strSql = strSql & " WHERE M_KEY = '" & key & "'" my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords Response.Write "

    Your Registration Has Been Completed!

    " & vbNewLine & _ "

    You may now begin posting" if strAuthType="db" then Response.Write(" using your new UserName and Password") Response.Write ".

    " & vbNewLine & _ "

    Back To Forum

    " & vbNewLine end if rsKey.close set rsKey = nothing '##################################################################################### else strEncodedPassword = sha256("" & trim(Request.Form("Password"))) Err_Msg = "" if strAutoLogon <> 1 then if trim(Request.Form("Name")) = "" then Err_Msg = Err_Msg & "
  • You must choose a UserName
  • " end if if Len(trim(Request.Form("Name"))) < 3 then Err_Msg = Err_Msg & "
  • Your UserName must be at least 3 characters long
  • " end if end if '## Forum_SQL strSql = "SELECT M_NAME FROM " & strMemberTablePrefix & "MEMBERS " strSql = strSql & " WHERE M_NAME = '" & ChkString(Trim(Request.Form("Name")), "SQLString") &"'" set rs = my_Conn.Execute (strSql) if rs.BOF and rs.EOF then '## Do Nothing else Err_Msg = Err_Msg & "
  • UserName already in Use, Please Choose Another
  • " end if rs.close set rs = nothing if strEmail = "1" and strEmailVal = "1" then '## Forum_SQL strSql = "SELECT M_NAME FROM " & strMemberTablePrefix & "MEMBERS_PENDING " strSql = strSql & " WHERE M_NAME = '" & ChkString(Trim(Request.Form("Name")), "SQLString") &"'" set rs = my_Conn.Execute (strSql) if rs.BOF and rs.EOF then '## Do Nothing else Err_Msg = Err_Msg & "
  • UserName already in Use, Please Choose Another
  • " end if rs.close set rs = nothing end if if strUserNameFilter = "1" then chkNameFilter(trim(Request.Form("Name"))) end if if strBadWordFilter = "1" then chkNameBadWords(trim(Request.Form("Name"))) end if if not IsValidString(trim(Request.Form("Name"))) then Err_Msg = Err_Msg & "
  • You may not use any of these chars in your username !#$%^&*()=+{}[]|\;:/?>,<'
  • " end if '## NT authentication no additional password needed if strAuthType = "db" then if not IsValidString(trim(Request.Form("Password"))) then Err_Msg = Err_Msg & "
  • You may not use any of these chars in your password !#$%^&*()=+{}[]|\;:/?>,<'
  • " end if if trim(Request.Form("Password")) = "" then Err_Msg = Err_Msg & "
  • You must choose a Password
  • " end if if Len(Request.Form("Password")) > 25 then Err_Msg = Err_Msg & "
  • Your Password can not be greater than 25 characters
  • " end if if Request.Form("Password") <> Request.Form("Password2") then Err_Msg = Err_Msg & "
  • Your Passwords didn't match.
  • " end if end if If strAutoLogon <> 1 then if Request.Form("Email") = "" then Err_Msg = Err_Msg & "
  • You Must give an e-mail address
  • " end if if Request.Form("Email") <> Request.Form("Email3") then Err_Msg = Err_Msg & "
  • Your E-mail Addresses didn't match.
  • " end if if EmailField(Request.Form("Email")) = 0 then Err_Msg = Err_Msg & "
  • You Must enter a valid e-mail address
  • " end if end if if strMSN = "1" and trim(Request.Form("MSN")) <> "" then if EmailField(Request.Form("MSN")) = 0 then Err_Msg = Err_Msg & "
  • You Must enter a valid MSN Messenger Username
  • " end if end if if strAuthType = "nt" and ChkAccountReg = "true" then Err_Msg = Err_Msg & "
  • NT User Account already registered.
  • " end if if strUniqueEmail = "1" then '## Forum_SQL strSql = "SELECT M_EMAIL FROM " & strMemberTablePrefix & "MEMBERS " strSql = strSql & " WHERE M_EMAIL = '" & Trim(chkString(Request.Form("Email"),"SQLString")) &"'" set rs = my_Conn.Execute(TopSQL(strSql,1)) if rs.BOF and rs.EOF then '## Do Nothing else Err_Msg = Err_Msg & "
  • E-mail Address already in use, Please Choose Another
  • " end if set rs = nothing if strEmail = "1" and strEmailVal = "1" then '## Forum_SQL strSql = "SELECT M_EMAIL FROM " & strMemberTablePrefix & "MEMBERS_PENDING " strSql = strSql & " WHERE M_EMAIL = '" & Trim(chkString(Request.Form("Email"),"SQLString")) &"'" set rs = my_Conn.Execute(TopSQL(strSql,1)) if rs.BOF and rs.EOF then '## Do Nothing else Err_Msg = Err_Msg & "
  • E-mail Address already in use, Please Choose Another
  • " end if set rs = nothing '## Forum_SQL strSql = "SELECT M_NEWEMAIL FROM " & strMemberTablePrefix & "MEMBERS " strSql = strSql & " WHERE M_NEWEMAIL = '" & Trim(ChkString(Request.Form("Email"),"SQLString")) &"'" set rs = my_Conn.Execute(TopSQL(strSql,1)) if rs.BOF and rs.EOF then '## Do Nothing else Err_Msg = Err_Msg & "
  • E-mail Address already in use, Please Choose Another
  • " end if set rs = nothing end if end if if not IsValidURL(trim(Request.Form("Homepage"))) then Err_Msg = Err_Msg & "
  • Homepage URL: Invalid URL" & strURLError & "
  • " end if if not IsValidURL(trim(Request.Form("LINK1"))) then Err_Msg = Err_Msg & "
  • Cool Links URL: Invalid URL" & strURLError & "
  • " end if if not IsValidURL(trim(Request.Form("LINK2"))) then Err_Msg = Err_Msg & "
  • Cool Links URL: Invalid URL" & strURLError & "
  • " end if if not IsValidURL(trim(Request.Form("Photo_URL"))) then Err_Msg = Err_Msg & "
  • Photo URL: Invalid URL" & strURLError & "
  • " end if strMAge = "" if strAge = "1" then strMAge = ChkString(trim(Request.Form("Age")), "SQLString") end if if strAgeDOB = "1" then strMDOB = ChkString(Request.Form("year"), "SQLString") & ChkString(Request.Form("month"), "SQLString") & ChkString(Request.Form("day"), "SQLString") if len(strMDOB) <> 8 then strMDOB = "" else strMDOByear = cInt(left(strMDOB, 4)) strMDOBmonth = cInt(mid(strMDOB, 5, 2)) strMDOBday = cInt(right(strMDOB, 2)) arrDays = array(31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31) intDays = arrDays(strMDOBMonth - 1) if strMDOBmonth = 2 and strMDOByear mod 4 = 0 and not (strMDOByear mod 100 = 0 and not strMDOBYear mod 400 = 0) then intDays = intDays + 1 end if if strMDOBday > intDays or strMDOB > left(DateToStr(strForumTimeAdjust), 8) then Err_Msg = Err_Msg & "
  • Date of Birth: Invalid Date
  • " else strMAge = DisplayUsersAge(DOBToDate(strMDOB)) end if end if end if if len(strMAge) > 0 then if not isNumeric(strMAge) then Err_Msg = Err_Msg & "
  • You must enter a numerical value for your age.
  • " elseif strMinAge > 0 and strMAge < strMinAge then Err_Msg = Err_Msg & "
  • You must be at least " & strMinAge & " years old to join this forum.
  • " end if end if if Err_Msg = "" then if Trim(Request.Form("Homepage")) <> "" and lcase(trim(Request.Form("Homepage"))) <> "http://" and Trim(lcase(Request.Form("Homepage"))) <> "https://" and lcase(Request.Form("Homepage")) <> "file:///" then regHomepage = ChkString(Request.Form("Homepage"),"SQLString") else regHomepage = " " end if if Trim(Request.Form("LINK1")) <> "" and lcase(trim(Request.Form("LINK1"))) <> "http://" and Trim(lcase(Request.Form("LINK1"))) <> "https://" then regLink1 = ChkString(Request.Form("LINK1"),"SQLString") else regLink1 = " " end if if Trim(Request.Form("LINK2")) <> "" and lcase(trim(Request.Form("LINK2"))) <> "http://" and Trim(lcase(Request.Form("LINK2"))) <> "https://" then regLink2 = ChkString(Request.Form("LINK2"),"SQLString") else regLink2 = " " end if if Trim(Request.Form("PHOTO_URL")) <> "" and lcase(trim(Request.Form("PHOTO_URL"))) <> "http://" and Trim(lcase(Request.Form("PHOTO_URL"))) <> "https://" then regPhoto_URL = ChkString(Request.Form("Photo_URL"),"SQLString") else regPhoto_URL = " " end if UserIPAddress = Request.ServerVariables("HTTP_X_FORWARDED_FOR") if UserIPAddress = "" then UserIPAddress = Request.ServerVariables("REMOTE_ADDR") end if '###### E-mail Validation Mod ###### actkey = GetKey("none") '################################## '## Forum_SQL strSql = "INSERT INTO " & strMemberTablePrefix if strEmail = "1" and strEmailVal = "1" then strSql = strSql & "MEMBERS_PENDING " else strSql = strSql & "MEMBERS " end if strSql = strSql & "(M_NAME" if strAuthType = "nt" then strSql = strSql & ", M_USERNAME" end if strSql = strSql & ", M_PASSWORD" '######### E-mail Validation Mod ########## if strEmail = "1" and strEmailVal = "1" then strSql = strSql & ", M_KEY" strSql = strSql & ", M_LEVEL" strSql = strSql & ", M_APPROVE" end if '######################################### strSql = strSql & ", M_EMAIL" strSql = strSql & ", M_DATE" strSql = strSql & ", M_COUNTRY" strSql = strSql & ", M_AIM" strSql = strSql & ", M_ICQ" strSql = strSql & ", M_MSN" strSql = strSql & ", M_YAHOO" strSql = strSql & ", M_POSTS" strSql = strSql & ", M_HOMEPAGE" strSql = strSql & ", M_LASTHEREDATE" strSql = strSql & ", M_STATUS" strSql = strSql & ", M_RECEIVE_EMAIL" strSql = strSql & ", M_LAST_IP" strSql = strSql & ", M_IP" strSql = strSql & ", M_SIG" strSql = strSql & ", M_VIEW_SIG" strSql = strSql & ", M_SIG_DEFAULT" strSql = strSql & ", M_FIRSTNAME" strSql = strSql & ", M_LASTNAME" strsql = strsql & ", M_CITY" strsql = strsql & ", M_STATE" strsql = strsql & ", M_PHOTO_URL" strsql = strsql & ", M_LINK1" strSql = strSql & ", M_LINK2" strSql = strsql & ", M_AGE" strSql = strsql & ", M_DOB" strSql = strSql & ", M_MARSTATUS" strSql = strsql & ", M_SEX" strSql = strSql & ", M_OCCUPATION" strSql = strSql & ", M_BIO" strSql = strSql & ", M_HOBBIES" strsql = strsql & ", M_LNEWS" strSql = strSql & ", M_QUOTE" strSql = strSql & ", M_SHA256" strSql = strSql & ") " strSql = strSql & " VALUES (" if strAutoLogon = "1" then strSql = strSql & "'" & chkString(Session(strCookieURL & "strNTUserFullName"),"SQLString") & "'" else strSql = strSql & "'" & chkString(trim(Request.Form("Name")),"SQLString") & "'" end if if strAuthType = "nt" then strSql = strSql & ", " & "'" & chkString(strDBNTUserName,"SQLString") & "'" end if strSql = strSql & ", " & "'" & chkString(strEncodedPassword,"password") & "'" '################## E-mail Validation Mod ######################## if strEmail = "1" and strEmailVal = "1" then strSql = strSql & ", " & "'" & chkString(actkey,"") & "'" strSql = strSql & ", " & "-1" if strRestrictReg = "1" then strSql = strSql & ", " & "0" else strSql = strSql & ", " & "1" end if end if '################################################################ strSql = strSql & ", " & "'" & chkString(Request.Form("Email"),"SQLString") & "'" strSql = strSql & ", " & "'" & DateToStr(strForumTimeAdjust) & "'" strSql = strSql & ", " & "'" & chkString(Request.Form("Country"),"SQLString") & "'" strSql = strSql & ", " & "'" & chkString(Request.Form("AIM"),"SQLString") & "'" strSql = strSql & ", " & "'" & chkString(Request.Form("ICQ"),"SQLString") & "'" strSql = strSql & ", " & "'" & chkString(Request.Form("MSN"),"SQLString") & "'" strSql = strSql & ", " & "'" & chkString(Request.Form("YAHOO"),"SQLString") & "'" strSql = strSql & ", " & "0" strSql = strSql & ", " & "'" & chkString(Trim(regHomepage),"SQLString") & "'" strSql = strSql & ", " & "'" & DateToStr(strForumTimeAdjust) & "'" '################## E-mail Validation Mod ######################## if strEmail = "1" and strEmailVal = "1" then strSql = strSql & ", " & "0" else strSql = strSql & ", " & "1" end if 'strSql = strSql & ", " & "1" '################################################################ strSql = strSql & ", " & cLng(Request.Form("ReceiveEMail")) & " " strSql = strSql & ", '" & UserIPAddress & "'" strSql = strSql & ", '" & UserIPAddress & "'" if strSignatures = "1" then strSql = strSql & ", " & "'" & chkString(Request.Form("Sig"),"message") & "'" else strsql = strsql & ", ''" end if if strSignatures = "1" and strDSignatures = "1" then strSql = strSql & ", " & cLng(Request.Form("ViewSig")) else strsql = strsql & ", " & 1 end if if strSignatures = "1" then strSql = strSql & ", " & cLng(Request.Form("fSigDefault")) else strsql = strsql & ", " & 1 end if if strFullName = "1" then strSql = strSql & ", '" & ChkString(Request.Form("FirstName"),"SQLString") & "'" strSql = strSql & ", '" & ChkString(Request.Form("LastName"),"SQLString") & "'" else strSql = strSql & ", ''" strSql = strSql & ", ''" end if if strCity = "1" then strsql = strsql & ", '" & ChkString(Request.Form("City"),"SQLString") & "'" else strsql = strsql & ", ''" end if if strState = "1" then strsql = strsql & ", '" & ChkString(Request.Form("State"),"SQLString") & "'" else strsql = strsql & ", ''" end if if strPicture = "1" then strsql = strsql & ", '" & ChkString(Trim(regPhoto_URL),"SQLString") & "'" else strsql = strsql & ", ''" end if if strFavLinks = "1" then strsql = strsql & ", '" & ChkString(Trim(regLink1),"SQLString") & "'" strSql = strSql & ", '" & ChkString(Trim(regLink2),"SQLString") & "'" else strsql = strsql & ", ''" strSql = strSql & ", ''" end if if strAge = "1" then strSql = strsql & ", '" & strMAge & "'" else strSql = strsql & ", ''" end if if strAgeDOB = "1" then strSql = strsql & ", '" & strMDOB & "'" else strSql = strsql & ", ''" end if if strMarStatus = "1" then strSql = strSql & ", '" & ChkString(Request.Form("MarStatus"),"SQLString") & "'" else strSql = strSql & ", ''" end if if strSex = "1" then strSql = strsql & ", '" & ChkString(Request.Form("Sex"),"SQLString") & "'" else strSql = strSql & ", ''" end if if strOccupation = "1" then strSql = strSql & ", '" & ChkString(Request.Form("Occupation"),"SQLString") & "'" else strSql = strSql & ", ''" end if if strBio = "1" then strSql = strSql & ", '" & ChkString(Request.Form("Bio"),"message") & "'" else strSql = strSql & ", ''" end if if strHobbies = "1" then strSql = strSql & ", '" & ChkString(Request.Form("Hobbies"),"message") & "'" else strSql = strSql & ", ''" end if if strLNews = "1" then strsql = strsql & ", '" & ChkString(Request.Form("LNews"),"message") & "'" else strSql = strSql & ", ''" end if if strQuote = "1" then strSql = strSql & ", '" & ChkString(Request.Form("Quote"),"message") & "'" else strSql = strSql & ", ''" end if strSql = strSql & ", 1" strSql = strSql & ")" my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords if strEmail = "1" and strEmailVal = "1" then 'Do Nothing else Call DoCount end if regHomepage = "" if strEmail = "1" and strRestrictReg = "0" then '## E-mails Message to the Author of this Reply. strRecipientsName = Request.Form("Name") strRecipients = Request.Form("Email") strFrom = strSender strFromName = strForumTitle strsubject = strForumTitle & " Registration " strMessage = "Hello " & Request.Form("name") & vbNewline & vbNewline strMessage = strMessage & "You received this message from " & strForumTitle & " because you have registered for a new account which allows you to post new messages and reply to existing ones on the forums at " & strForumURL & vbNewline & vbNewline if strAuthType="db" then '################################### E-mail Validation Mod ################################# if strEmailVal = "1" then strMessage = strMessage & "Please click on the link below to complete your registration." & vbNewline & vbNewLine strMessage = strMessage & "If the link is split or broken, you will need to copy and paste the entire link into your web browser." & vbNewline & vbNewLine strMessage = strMessage & strForumURL & "register.asp?actkey=" & actkey & vbNewline & vbNewline else '###################################################################################### strMessage = strMessage & "Password: " & Request.Form("Password") & vbNewline & vbNewline end if '<---- E-mail Validation Mod - 1 line ############# end if strMessage = strMessage & "You can change your information at our website by selecting the ""Profile"" link." & vbNewline & vbNewline strMessage = strMessage & "Happy Posting!" %> <% '################################################################################# '## 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 else Response.Write "

    There Was A Problem With Your Details

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

    Go Back To Enter Data

    " & vbNewLine WriteFooter Response.End end if ' ##################### E-mail Validation Mod ######################### if lcase(strEmail) = "0" then Response.Write "

    Your Registration Has Been Completed!

    " & vbNewLine & _ "

    You may now begin posting" if strAuthType = "db" then Response.Write(" using your new UserName and Password") Response.Write ".

    " & vbNewLine else if strEmailVal = "1" then Response.Write "

    Your Registration Is Almost Complete!

    " & vbNewLine '####################################### if strRestrictReg = "1" then Response.Write "

    The Administrator has restricted registration on this forum. You will receive an e-mail as soon as the Administrator approves your request.

    " & vbNewLine else Response.Write "

    Please follow the instructions in the e-mail that has been sent to " & ChkString(Request.Form("Email"),"email") & " to complete your registration.

    " & vbNewLine end if '####################################### else Response.Write "

    Your Registration Has Been Completed!

    " & vbNewLine & _ "

    You may now begin posting" if strAuthType = "db" then Response.Write(" using your new UserName and Password") Response.Write ".

    " & vbNewLine end if end if ' ####################################################################### if strAuthType = "db" then select case chkUser(Request.Form("Name"), Request.Form("Password"),-1) case 1, 2, 3, 4 Call DoCookies("false") strLoginStatus = 1 case else strLoginStatus = 0 end select end if if strAutoLogon = 1 then Response.Redirect "default.asp" else Response.Write " " & vbNewLine end if Response.Write "

    Back To Forum

    " & vbNewLine end if else Response.Write "

    Sorry, we are not accepting any new Members at this time.

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

    Back To Forum


    " & vbNewLine end if WriteFooter Response.End sub DoCount '## Forum_SQL - Updates the Totals table by adding 1 to U_COUNT strSql = "UPDATE " & strTablePrefix & "TOTALS " strSql = strSql & " SET " & strTablePrefix & "TOTALS.U_COUNT = " & strTablePrefix & "TOTALS.U_COUNT + 1" my_Conn.Execute (strSql),,adCmdText + adExecuteNoRecords end sub sub ShowForm() Response.Write "
    " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "
    " & vbNewLine Call DisplayProfileForm Response.Write "
    " & vbNewLine & _ "
    " & vbNewLine end sub Function IsValidURL(sValidate) Dim sInvalidChars Dim bTemp Dim i if trim(sValidate) = "" then IsValidURL = true : exit function sInvalidChars = """;+()*'<>" for i = 1 To Len(sInvalidChars) if InStr(sValidate, Mid(sInvalidChars, i, 1)) > 0 then bTemp = True if bTemp then strURLError = "
    • cannot contain any of the following characters: "" ; + ( ) * ' < > " if bTemp then Exit For next if not bTemp then for i = 1 to Len(sValidate) if Asc(Mid(sValidate, i, 1)) = 160 then bTemp = True if bTemp then strURLError = "
    • cannot contain any spaces " if bTemp then Exit For next end if ' extra checks ' check to make sure URL begins with http:// or https:// if not bTemp then bTemp = (lcase(left(sValidate, 7)) <> "http://") and (lcase(left(sValidate, 8)) <> "https://") if bTemp then strURLError = "
    • must begin with either http:// or https:// " end if ' check to make sure URL is 255 characters or less if not bTemp then bTemp = len(sValidate) > 255 if bTemp then strURLError = "
    • cannot be more than 255 characters " end if ' no two consecutive dots if not bTemp then bTemp = InStr(sValidate, "..") > 0 if bTemp then strURLError = "
    • cannot contain consecutive periods " end if 'no spaces if not bTemp then bTemp = InStr(sValidate, " ") > 0 if bTemp then strURLError = "
    • cannot contain any spaces " end if if not bTemp then bTemp = (len(sValidate) <> len(Trim(sValidate))) if bTemp then strURLError = "
    • cannot contain any spaces " end if 'Addition for leading and trailing spaces ' if any of the above are true, invalid string IsValidURL = Not bTemp End Function Function IsValidString(sValidate) Dim sInvalidChars Dim bTemp Dim i ' Disallowed characters sInvalidChars = "!#$%^&*()=+{}[]|\;:/?>,<'" for i = 1 To Len(sInvalidChars) if InStr(sValidate, Mid(sInvalidChars, i, 1)) > 0 then bTemp = True if bTemp then Exit For next for i = 1 to Len(sValidate) if Asc(Mid(sValidate, i, 1)) = 160 then bTemp = True if bTemp then Exit For next ' extra checks ' no two consecutive dots or spaces if not bTemp then bTemp = InStr(sValidate, "..") > 0 end if if not bTemp then bTemp = InStr(sValidate, " ") > 0 end if if not bTemp then bTemp = (len(sValidate) <> len(Trim(sValidate))) end if 'Addition for leading and trailing spaces ' if any of the above are true, invalid string IsValidString = Not bTemp End Function function chkNameFilter(pString) if trim(Application(strCookieURL & "STRFILTERUSERNAMES")) = "" then txtUserNames = "" '## Forum_SQL - Get UserNames from DB strSqln = "SELECT N_NAME " strSqln = strSqln & " FROM " & strFilterTablePrefix & "NAMEFILTER " set rsUName = Server.CreateObject("ADODB.Recordset") rsUName.open strSqln, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText if rsUName.EOF then recUserNameCount = "" else allUserNameData = rsUName.GetRows(adGetRowsRest) recUserNameCount = UBound(allUserNameData,2) end if rsUName.close set rsUName = nothing if recUserNameCount <> "" then nNAME = 0 for iUserName = 0 to recUserNameCount UserNameName = allUserNameData(nNAME,iUserName) if txtUserNames = "" then txtUserNames = UserNameName else txtUserNames = txtUserNames & "," & UserNameName end if next end if Application.Lock Application(strCookieURL & "STRFILTERUSERNAMES") = txtUserNames Application.UnLock end if txtUserNames = Application(strCookieURL & "STRFILTERUSERNAMES") fString = trim(pString) unames = split(txtUserNames, ",") for i = 0 to ubound(unames) if instr(1,lcase(fString), lcase(unames(i)),1) <> 0 then Err_Msg = Err_Msg & "
  • Username may not contain the word " & unames(i) & "
  • " exit function end if next end function function chkNameBadWords(pString) 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") fString = trim(pString) bwords = split(txtBadWordWords, ",") for i = 0 to ubound(bwords) if instr(1,lcase(fString), lcase(bwords(i)),1) <> 0 then Err_Msg = Err_Msg & "
  • Username may not contain the word " & bwords(i) & "
  • " exit function end if next end function %>