<% '******************************************************************************* '* XUD Copyright 1995-2003 XCENT - www.xcent.com * '* XUD is a trademark of XCENT * '* This notice may not be removed from this source code file * '******************************************************************************* Dim lUpCount Redim sFileName(0) Redim sFileTitle(0) Redim sFileType(0) Redim lFileSize(0) Redim vFileCreated(0) bMBmainDebug = False Set objErr = CreateObject("Scripting.Dictionary") If gbEnabled Then sCmd = UCase(Trim(RequestValue("Cmd"))) iPageCurrent = FVal(RequestValue("Page")) lID = FVal(RequestValue("ID")) lTo = Fval(RequestValue("TO")) sToName = RequestValue("ToName") sFromName = RequestValue("FromName") sFromEmail = RequestValue("FromEmail") sSystem = RequestValue("System") lSystemID = FVal(RequestValue("SystemID")) sSubject = RequestValue("Subject") sBody = RequestValue("Body") sReturnTo = RequestValue("ReturnTo") sOriginalBody = RequestValue("OriginalBody") lUpCount = FVal(RequestValue("UpCount")) For lItem = 1 to lUpCount Redim Preserve sFileName(lItem) Redim Preserve sFileTitle(lItem) Redim Preserve sFileType(lItem) Redim Preserve lFileSize(lItem) Redim Preserve vFileCreated(lItem) sFileName(lItem) = RequestValue("UpFileName" & lItem) sFileTitle(lItem) = RequestValue("UpFiletitle" & lItem) sFileType(lItem) = RequestValue("UpFileType" & lItem) lFileSize(lItem) = Fval(RequestValue("UpFileSize" & lItem)) vFileCreated(lItem) = RequestValue("UpFileCreated" & lItem) Next lPageCount = 0 sURLString = "CMD=" & sCmd & "&ID=" & lID OpenDBConn LoadUserSettings sView = "" DoPageHeader 'TableHead Select Case sCmd Case "DELETE" If IsUserLoggedIn Then sView = "IN" DeleteMessages ViewInbox Else RedirectLogin End If Case "PREVIEW" If gbMBAllowNonReg OR IsUserLoggedIn Then sView = "COMPOSE" If ValidateMessage Then PreviewMessage Else ComposeMessage End If Else RedirectLogin End If Case "SEND" If gbMBAllowNonReg OR IsUserLoggedIn Then If ValidateMessage Then sView = "OUT" SendMessage Else sView = "COMPOSE" ComposeMessage End If Else RedirectLogin End If Case "COMPOSE" If gbMBAllowNonReg OR IsUserLoggedIn Then sView = "COMPOSE" ComposeMessage Else RedirectLogin End If Case "VIEW" If IsUserLoggedIn Then ViewMessage Else RedirectLogin End If Case "SENTBOX" If IsUserLoggedIn Then sView = "OUT" ViewSentbox Else RedirectLogin End If Case "INBOX" If IsUserLoggedIn Then sView = "IN" ViewInbox Else RedirectLogin End If Case Else If IsUserLoggedIn Then sView = "IN" ViewInbox ElseIf gbMBAllowNonReg Then sView = "COMPOSE" ComposeMessage Else RedirectLogin End If End Select TableFoot DoPageFooter CloseDBConn Else Response.Redirect "XUDDisabled.asp" End If Set objErr = Nothing Sub RedirectLogin CloseDBConn Response.Redirect "XUDLogin.asp?ReturnTo=" & Server.URLEncode("XUDMessageBase.asp?" & Request.QueryString) End Sub Sub AllFields Dim lItem Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "" For lItem = 1 to UBound(sFileName) Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "" Next End Sub Sub DeleteMessages For Each i in Request("Delete") sSQL = "UPDATE tblXUDUserMessageBase SET umbReceiverDelete=" & SQLStr("Y") & _ " WHERE umbID=" & SQLVal(i) gobjConnect.Execute(sSQL) Next End Sub Function ValidateMessage objErr.RemoveAll lOrigTo = lTo If abs(lTo) < 1 Then If Len(sToName) > 0 Then sUser = "SELECT regID from tblXUDUserRegistration WHERE regUserName=" & SQLStr(sToName) set rsUser = gobjConnect.Execute(sUser) If NOT rsUser.EOF Then lTo = rsUser("regID") If lTo = glUserID Then objErr.Add "TOERROR", GLS_MBCantSendSelf End If Else objErr.Add "TOERROR",GLS_MBUnknownUser End If rsUser.Close Set rsUser = Nothing Else objErr.Add "TOERROR", GLS_MBNoUsername End If Else If lTo = glUserID Then objErr.Add "TOERROR", GLS_MBCantSendSelf Else sUser = "SELECT regID from tblXUDUserRegistration WHERE regID=" & SQLVal(lTo) set rsUser = gobjConnect.Execute(sUser) If rsUser.EOF Then objErr.Add "TOERROR",GLS_MBUnknownUser End If rsUser.Close Set rsUser = Nothing End If End If If Len(sSubject) = 0 Then objErr.Add "SUBJECT", GLS_MBNoSubject ElseIf IsDirtyWords(sSubject) Then objErr.Add "SUBJECT", GLS_MBBadSubject ElseIf Len(sSubject) > 80 Then objErr.Add "SUBJECT", GLS_MBLongSubject End If If Len(sBody) = 0 Then objErr.Add "MESSAGE", GLS_MBNoMessage ElseIf IsDirtyWords(sBody) Then objErr.Add "MESSAGE", GLS_MBBadMessage End If If NOT IsUserLoggedIn Then If len(sFromName) = 0 Then objErr.Add "FROMERROR", GLS_MBNoFromName End If If len(sFromEmail) = 0 Then objErr.Add "FROMEMAIL", GLS_MBNoFromEmail End If End If If objErr.Count > 0 Then lTo = lOrigTo ValidateMessage = False Else ValidateMessage = True End If End Function Sub SendMessage vNow = Now If IsUserLoggedIn Then sFromName = gsUserName End If If gbMBSendAsEmail Or gbMBSendAdvMessage Then sToEmail = GetUserEmail(lTo) sToName = GetUserName(lTo) sNotify = ReadFile(Server.MapPath("XUDEmailTemplates/XUDMBSendAsEmail.txt")) & _ chr(13) & chr(10) & chr(13) & chr(10) & ReadFile(Server.MapPath("XUDEmailTemplates/XUDEmailFooter.txt")) sNotify = Replace(sNotify, "%XUD%", gsXUDURL) sNotify = Replace(sNotify, "%TO%", sToName) sNotify = Replace(sNotify, "%FROMNAME%", sFromName) sNotify = Replace(sNotify, "%FROMEMAIL%", OutMatch(len(sFromEmail), 0, GLS_TextNA,sFromEmail)) If len(sFromEmail) > 0 Then sNotify = Replace(sNotify, "%EMAILREPLYLINK%", GLS_MBEmailReplyLink & sFromEmail) Else sNotify = Replace(sNotify, "%EMAILREPLYLINK%", "") End If If IsUserLoggedIn Then sNotify = Replace(sNotify, "%ONLINEREPLYLINK%", GLS_MBOnlineReplyLink & gsXUDURL & "XUDMessageBase.asp?CMD=COMPOSE&TONAME=" & Server.URLEncode(sFromName)) Else sNotify = Replace(sNotify, "%ONLINEREPLYLINK%", "") End If sNotify = Replace(sNotify, "%BODY%", sBody) sNotify = Replace(sNotify, "%SUBJECT%", sSubject) sNotify = Replace(sNotify, "%DATETIME%", DispShortDateTime(NOW)) sMailSubject = GetFirstLine(sNotify) If gbMBUseSenderAddress And len(sFromEmail) > 0 Then sSendFromEmail = sFromEmail Else sSendFromEmail = gsAdminEmail End If 'response.write "to: " & sToEmail & " from: " & sSendFromEmail & " Body:" & sNotify SendEmailMessage sToEmail, sSendFromEmail, sMailSubject, sNotify End If If Not gbMBSendAsEmail Or gbMBSendAdvMessage Then If lID > 0 Then sSQL = "UPDATE tblXUDUserMessageBase " & _ "SET umbReplied=" & SQLStr("Y") & _ " WHERE umbID=" & SQLVal(lID) If bMBmainDebug Then Response.Write "SQL:
" & sSQL & "

" gobjConnect.Execute sSQL End If If Len(Trim(sOriginalBody)) > 0 Then sBody = sBody & GLS_MBOriginalMessageSep & sOriginalBody End If lUmbID = 0 Select Case giDBType Case 0: 'Jet Set rs = Server.CreateObject("ADODB.RecordSet") rs.Open "tblXUDUserMessageBase", gobjConnect, 1, 3, &H0002 'adOpenKeyset, adLockOptimistic, adCmdTable rs.AddNew rs("umbRegID") = lTo rs("umbFromRegID") = glUserID rs("umbFromName") = sFromName rs("umbFromEmail") = sFromEmail rs("umbDate") = vNow rs("umbSubject") = sSubject If Len(Trim(sSystem)) > 0 Then rs("umbSystem") = sSystem rs("umbSystemID") = lSystemID End If If lUpCount > 0 Then rs("umbHasAttachments") = "Y" End If rs("umbBody") = sBody rs.Update If bMBmainDebug Then Response.Write "SQL:n/a - JET AddNew/Update

" lUmbID = rs("umbID") rs.Close Set rs = Nothing Case 1: 'SQLServer sSQL = "INSERT into tblXUDUserMessageBase(umbRegID, umbFromRegID, umbFromName, umbFromEmail, " &_ "umbDate, umbSubject, umbSystem, umbSystemID, umbReceiverDelete, umbHasAttachments, umbBody) " &_ "VALUES (" & _ SQLVal(lTo) & ", " & _ SQLVal(glUserID) & ", " &_ SQLStr(sFromName) & ", " & _ SQLStr(sFromEmail) & ", " & _ SQLDate(vNow) & ", " & _ SQLStr(sSubject) & ", " & _ SQLStr(sSystem) & ", " & _ SQLVal(lSystemID) & ", " & _ SQLBool(False) & ", " & _ SQLStr(OutMatch(lUpCount, 0, "N", "Y")) & ", " & _ SQLStr(sBody) & ")" If bMBmainDebug Then Response.Write "SQL:
" & sSQL & "

" gobjConnect.Execute sSQL sSQL = "SELECT @@identity" Set rs = gobjConnect.Execute(sSQL) If Not rs.Eof Then lUmbID = Fval(rs(0)) End If rs.Close Set rs = Nothing Case Else lUmbID = 0 End Select If bMBmainDebug Then Response.Write "lUmbID:" & lUmbID & "

" If bMBmainDebug Then Response.Write "lUpCount:" & lUpCount & "

" If (lUpCount > 0) And (lUmbID > 0) Then For lFile = 1 to lUpCount sSQL = "INSERT INTO tblXUDUserMessageMedia " & _ "(umbmUmbID, umbmCreated, umbmSize, umbmType, umbmTitle, umbmLocalFilename, umbmValue) " & _ "VALUES (" & _ SQLVal(lUmbID) & ", " & _ SQLDate(vFileCreated(lFile)) & ", " & _ SQLVal(lFileSize(lFile)) & ", " & _ SQLStr(sFileType(lFile)) & ", " & _ SQLStr(sFileTitle(lFile)) & ", " & _ SQLStr(sFileName(lFile)) & ", " & _ SQLStr(sFileName(lFile)) & " " & _ ") " If bMBmainDebug Then Response.Write "SQL:
" & sSQL & "

" gobjConnect.Execute sSQL Next Else If lUmbID = 0 Then Response.Write "

INSERT ERROR

" End If End If UserNotification End If If len(gsMonitorEmail) > 0 Then sNotify = ReadFile(Server.MapPath("XUDEmailTemplates/XUDAdmMessageBaseCopy.txt")) & _ chr(13) & chr(10) & chr(13) & chr(10) & ReadFile(Server.MapPath("XUDEmailTemplates/XUDEmailFooter.txt")) sNotify = Replace(sNotify, "%XUD%", gsXUDURL) sNotify = Replace(sNotify, "%TO%", GetUserName(lTo)) sNotify = Replace(sNotify, "%FROM%", sFromName) sNotify = Replace(sNotify, "%BODY%", sBody) sNotify = Replace(sNotify, "%SUBJECT%", sSubject) sMailSubject = GetFirstLine(sNotify) SendEmailMessage gsMonitorEmail, gsAdminEmail, sMailSubject, sNotify ElseIf gbMBCopyAdmin Then sNotify = ReadFile(Server.MapPath("XUDEmailTemplates/XUDAdmMessageBaseCopy.txt")) & _ chr(13) & chr(10) & chr(13) & chr(10) & ReadFile(Server.MapPath("XUDEmailTemplates/XUDEmailFooter.txt")) sNotify = Replace(sNotify, "%XUD%", gsXUDURL) sNotify = Replace(sNotify, "%TO%", GetUserName(lTo)) sNotify = Replace(sNotify, "%FROM%", sFromName) sNotify = Replace(sNotify, "%BODY%", sBody) sNotify = Replace(sNotify, "%SUBJECT%", sSubject) sMailSubject = GetFirstLine(sNotify) SendEmailMessage gsAdminEmail, gsAdminEmail, sMailSubject, sNotify End If If UCase(Trim(sSystem)) = "CAD" And lSystemID > 0 Then sSQL = "UPDATE tblCPClassifieds SET cadReplyCount = cadReplyCount + 1 " & _ "WHERE cadID = " & SQLVal(lSystemID) gobjConnect.Execute(sSQL) End If If Len(sReturnTo) = 0 Then If IsUserLoggedIn AND (NOT gbMBSendASEmail Or gbMBSendAdvMessage) Then Response.Redirect "XUDMessageBase.asp?CMD=SENTBOX" Else sNav = "" & GLS_MBNavCompose & "" TableHead sNav Response.Write gsPlainTextOpen & GLS_MBMessageSent & gsPlainTextClose Response.Write "
" End If Else Response.Redirect sReturnTo End If End Sub Sub UserNotification Dim sSubject sSQL= "SELECT regHasUserMail, regEmail FROM tblXUDUserRegistration WHERE regID=" & lTo set rsHasMail = gobjConnect.Execute(sSQL) If NOT rsHasMail.EOF Then sHasMail = EvalBool(rsHasMail("regHasUserMail")) sUserEmail = "" & rsHasMail("regEmail") If NOT sHasMail Then sUpdate = "UPDATE tblXUDUserRegistration SET regHasUserMail=" & SQLStr("Y") &_ " WHERE regID=" & lTo gobjConnect.Execute sUpdate sNotify = ReadFile(Server.MapPath("XUDEmailTemplates/XUDNewMessageReceived.txt")) & _ chr(13) & chr(10) & ReadFile(Server.MapPath("XUDEmailTemplates/XUDEmailFooter.txt")) sNotify = Replace(sNotify,"%XUD%",gsXUDURL) sMailSubject = GetFirstLine(sNotify) SendEmailMessage sUserEmail, gsAdminEmail, sMailSubject, sNotify End If End If rsHasMail.Close set rsHasMail = Nothing End Sub Sub ComposeMessage AddDisableSubmitJS sNav = "" If lID > 0 and Len(sSubject)= 0 Then 'reply LoadValues sNav = "" & GLS_MBNavSentbox & "" sNav = sNav & " : " & sSubject & "" sNav = sNav & " : " & GLS_MBNavReply & "" If NOT Instr(sSubject, GLS_MBMsgReplySubject)=1 Then sSubject = GLS_MBMsgReplySubject & sSubject If (Len(sSubject) > 80) Then sSubject = Left(sSubject, 77) & "..." Else sNav ="" & GLS_MBNavCompose & "" End If TableHead sNav Response.Write gsSectionTitleOpen & GLS_TextComposeMessage & gsSectionTitleClose Response.Write "" Response.Write "
" Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "" 'fields for unregistered users to use message base If NOT IsUserLoggedIn Then Response.Write "" Response.Write "" Else Response.Write "" Response.Write "" End If If gbMBSendAsEmail Or gbMBSendAdvMessage OR NOT IsUserLoggedIn Then Response.Write "" Response.Write "" End If Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "
" & gsPlainTextOpen & GLS_RequiredText & gsPlainTextClose & "
" & gsFormTextOpen & OutMatch(True, objErr.Exists("TOERROR"), objErr.Item("TOERROR"), GLS_TextToUsername & GLS_PromptSeparator ) & gsFormTextClose & "" If lTo > 0 Then Response.Write gsPlainTextOpen & GetUserName(lTo) & " " & gsPlainTextClose Else Response.Write "" End If Response.Write GLS_Required & "
" & gsFormTextOpen & OutMatch(True, objErr.Exists("FROMERROR"), objErr.Item("FROMERROR"), GLS_MBFromName & GLS_PromptSeparator ) & gsFormTextClose & "" & GLS_Required & "
" & gsPlainTextOpen & Replace(GLS_MBLoginLink, "%LOGINREDIRECT%", "XUDLogin.asp?ReturnTo=" & Server.URLEncode("XUDMessageBase.asp?" & Request.QueryString)) & gsPlainTextClose &"
" & gsFormTextOpen & OutMatch(True, objErr.Exists("FROMERROR"), objErr.Item("FROMERROR"), GLS_MBFromName & GLS_PromptSeparator ) & gsFormTextClose & ""& gsPlainTextOpen & gsUserName & GLS_Required & "
" & GLS_MBLogoutLink & gsPlainTextClose & "
" & gsFormTextOpen & OutMatch(True, objErr.Exists("FROMEMAIL"), objErr.Item("FROMEMAIL"), GLS_MBFromEmail & GLS_PromptSeparator) & gsFormTextClose & "" & OutMatch(IsUserLoggedIn,False,GLS_Required, "") If (gbMBSendAsEmail Or gbMBSendAdvMessage) AND IsUserLoggedIn Then Response.Write "
" & gsPlainTextOpen & GLS_MBSendAsEmailEmailTip & gsPlainTextClose End If Response.Write "
" & gsFormTextOpen & OutMatch(True, objErr.Exists("SUBJECT"), objErr.Item("SUBJECT"), GLS_TextSubject & GLS_PromptSeparator) & gsFormTextClose & "" & GLS_Required & "
" & gsFormTextOpen & OutMatch(True, objErr.Exists("MESSAGE"), objErr.Item("MESSAGE"), GLS_TextMessage & GLS_PromptSeparator & GLS_Required) & gsFormTextClose & "
 
" Response.Write "
" If lID > 0 Then Response.Write "
" Response.Write "
" Response.Write "" Response.Write "" Response.Write "" sTemp = Server.HTMLEncode(sOriginalBody) sTemp = Replace(sTemp, vbCrLf, "
") Response.Write "" Response.Write "
" & gsFormTextOpen & GLS_MBOriginalMsg & gsFormTextClose & "" & gsPlainTextOpen & sTemp & gsPlainTextClose & "
" Response.Write "
" End If End Sub Sub PreviewMessage AddDisableSubmitJS sNav = "" If lID > 0 and Len(sSubject) = 0 Then 'reply sNav = "" & GLS_MBNavSentbox & "" sNav = sNav & " : " & sSubject & "" sNav = sNav & " : " & GLS_MBNavReply & "" If NOT Instr(sSubject, GLS_MBMsgReplySubject)=1 Then sSubject = GLS_MBMsgReplySubject & sSubject If (Len(sSubject) > 80) Then sSubject = Left(sSubject, 77) & "..." Else sNav ="" & GLS_MBNavCompose & "" End If TableHead sNav Response.Write gsSectionTitleOpen & GLS_TextPreviewMessage & gsSectionTitleClose Response.Write "" Response.Write "
" Response.Write "" Response.Write "" Response.Write "" AllFields Response.Write "" Response.Write "" If NOT IsUserLoggedIn Then Response.Write "" Response.Write "" End If If len(sFromEmail) > 0 Then Response.Write "" Response.Write "" End If Response.Write "" Response.Write "" Response.Write "" sDisplayBody = Server.HTMLEncode(sBody) sDisplayBody = Replace(sDisplayBody, vbCrLf, "
") Response.Write "" Response.Write "" Response.Write "" Response.Write "" If giUploadHandler > 0 AND gbMBAllowAttach AND NOT gbMBSendAsEmail Then If giMBMaxFiles > lUpCount Then Response.Write "" AllFields Response.Write "" Response.Write "" Else Response.Write "" Response.Write "" End If End If Response.Write "
" & gsFormTextOpen & OutMatch(True, objErr.Exists("TOERROR"), objErr.Item("TOERROR"), GLS_TextToUsername & GLS_PromptSeparator) & gsFormTextClose & "" If lTo > 0 Then Response.Write gsPlainTextOpen & GetUserName(lTo) & gsPlainTextClose Else Response.Write "" End If Response.Write "
" & gsFormTextOpen & GLS_MBFromName & GLS_PromptSeparator & gsFormTextClose & "" & gsPlainTextOpen & Server.HtmlEncode(sFromName) & gsPlainTextClose & "
" & gsFormTextOpen & GLS_MBFromEmail & GLS_PromptSeparator & gsFormTextClose & "" & gsPlainTextOpen & Server.HtmlEncode(sFromEmail) & gsPlainTextClose & "
" & gsFormTextOpen & GLS_TextSubject & GLS_PromptSeparator & gsFormTextClose & "" & gsPlainTextOpen & Server.HTMLEncode(sSubject) & gsPlainTextClose & "
" & gsFormTextOpen & GLS_TextMessage & GLS_PromptSeparator & gsFormTextClose & "" & gsPlainTextOpen & sDisplayBody & gsPlainTextClose & "
 
 
 " & gsPlainTextOpen & GLS_MBMaxFilesPerMsg & gsPlainTextClose & "
" Response.Write "
" If UBound(sFileName) > 0 Then Response.Write "
" Response.Write "
" Response.Write "" Response.Write "" bLineTag = True For lItem = 1 to Ubound(sFileName) sLineColor = AlternateTag(bLineTag, gsAltColorOne, gsAltColorTwo) Response.Write "" Next Response.Write "
" & gsColumnHeadOpen & GLS_TextFilesAttached & GLS_PromptSeparator & gsColumnHeadClose & " 
" & gsPlainTextOpen & sFileName(lItem) & gsPlainTextClose & "" & gsPlainTextOpen & sFileTitle(lItem) & gsPlainTextClose & "
" Response.Write "
" End If If lID > 0 Then Response.Write "
" Response.Write "
" Response.Write "" Response.Write "" Response.Write "" sTemp = Server.HTMLEncode(sOriginalBody) sTemp = Replace(sTemp, vbCrLf, "
") Response.Write "" Response.Write "
" & gsFormTextOpen & GLS_MBOriginalMsg & gsFormTextClose & "" & gsPlainTextOpen & sTemp & gsPlainTextClose & "
" Response.Write "
" End If End Sub Sub LoadValues sValues = "SELECT umbSubject, umbSystem, umbSystemID, umbFromRegID, " & _ "umbBody " & _ " FROM tblXUDUserMessageBase WHERE umbID=" & SQLVal(lID) Set rsValues = gobjConnect.Execute(sValues) If not rsValues.EOF Then sSubject = rsValues("umbSubject") sSystem = rsValues("umbSystem") lSystemID = rsValues("umbSystemID") lTo = rsValues("umbFromRegID") sOriginalBody = rsValues("umbBody") End If rsValues.Close set rsValues = Nothing End Sub Sub OutputFileViewJS Response.Write vbCrLf & vbCrLf & "" & vbCrLf End Sub Sub ViewMessage vNow = Now OutputFileViewJS sSQL = "SELECT umbSystem, umbSystemID, umbSubject, umbRegID, umbFromRegID, umbFromName, " & _ " umbFromEmail, umbDate, umbHasAttachments, umbBody " & _ " FROM tblXUDUserMessageBase WHERE" & _ " ((( umbReceiverDelete IS NULL OR umbReceiverDelete=" & SQLStr("N") & ") AND umbRegID=" & SQLVal(glUserID) & ")" & _ " OR umbFromRegID=" & SQLVal(glUserID) & ")" & _ " AND umbID=" & SQLVal(lID) SET rsMessage= gobjConnect.Execute(sSQL) If NOT rsMessage.EOF Then bHasAttachments = EvalBool(rsMessage("umbHasAttachments")) If rsMessage("umbRegID") = glUserID Then 'to reader sView = "IN" sNav = "" & GLS_MBNavInbox & " : " Else sView = "OUT" sNav = "" & GLS_MBNavSentbox & " : " End If sNav = sNav & "" & rsMessage("umbSubject") & "" TableHead sNav Response.Write "" Response.Write "
" Response.Write "" bUpdate= False Response.Write "" Response.Write "" 'Response.Write "" If rsMessage("umbFromRegID") = 0 Then Response.Write "" End If Else TableHead "" Response.Write "
" Response.Write gsColumnHeadOpen & GLS_TextSubject & GLS_PromptSeparator & gsColumnHeadClose Response.Write gsColumnHeadOpen & rsMessage("umbSubject") & gsColumnHeadClose Select Case UCase("" & rsMessage("umbSystem")) Case "AUC": If FVal(rsMessage("umbSystemID")) > 0 Then sLink = "" & SystemTypeIcon("AUC") & "" Else sLink = "" & SystemTypeIcon("AUC") & "" End If Case "CAD": If FVal(rsMessage("umbSystemID")) > 0 Then sLink = "" & SystemTypeIcon("CAD") & "" Else sLink = "" & SystemTypeIcon("CAD") & "" End If Case "MSG": If FVal(rsMessage("umbSystemID")) > 0 Then sLink = "" & SystemTypeIcon("MSG") & "" Else sLink = "" & SystemTypeIcon("MSG") & "" End If Case Else sLink = GLS_SymbNone End Select Response.Write "  " & gsColumnHeadOpen & sLink & gsColumnHeadClose & "
" Response.Write gsColumnHeadOpen & GLS_TextDate & GLS_PromptSeparator & gsColumnHeadClose Response.Write gsColumnHeadOpen & DispShortDateTime(rsMessage("umbDate")) & gsColumnHeadClose & "
" If rsMessage("umbRegID") = glUserID Then 'to reader bUpdate = True Response.Write gsColumnHeadOpen & GLS_TextFrom & GLS_PromptSeparator & gsColumnHeadClose sFromDisplay = rsMessage("umbFromName") If rsMessage("umbFromRegID") = 0 Then sFromDisplay = sFromDisplay & GLS_MBNonRegSymbol Response.Write gsColumnHeadOpen & sFromDisplay & gsColumnHeadClose If len("" & rsMessage("umbFromEmail")) > 0 Then Response.Write "
" & gsColumnHeadOpen & GLS_TextEmail & GLS_PromptSeparator & gsColumnHeadClose Response.Write gsColumnHeadOpen & "" & rsMessage("umbFromEmail") & "" End If Else Response.Write gsColumnHeadOpen & GLS_TextToUsername & GLS_PromptSeparator & gsColumnHeadClose sToDisplay = GetUserName(rsMessage("umbRegID")) Response.Write gsColumnHeadOpen & sToDisplay & gsColumnHeadClose End If Response.Write "
" sDisplayBody = Server.HTMLEncode(rsMessage("umbBody")) sDisplayBody = Replace(sDisplayBody, vbCrLf, "
") Response.Write gsPlainTextOpen & sDisplayBody & gsPlainTextClose Response.Write "
" '***Buttons**** Response.Write "
" Response.Write "" If FVal(rsMessage("umbRegID")) = glUserID Then If rsMessage("umbFromRegID") > 0 Then Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "" 'Response.Write "" End If Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "" End If Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "
" Response.Write "" Response.Write "
" Response.Write "" Response.Write "
" Response.Write "" Response.Write "
" Response.Write "
" & gsPlainTextOpen & GLS_MBReplyUnregistered & gsPlainTextClose & "
" Response.Write "
" Response.Write "" Response.Write "" End If rsMessage.Close set rsMessage = Nothing Response.Write "
" & gsPlainTextOpen & GLS_MBInvalidMessage & gsPlainTextClose & "
" Response.Write "
" If bHasAttachments Then sSQL = "SELECT * FROM tblXUDUserMessageMedia WHERE umbmUmbID = " & SQLVal(lID) Set rsAttach = gobjConnect.Execute(sSQL) Response.Write "" Response.Write "" Response.Write "
" Response.Write "" Response.Write "" If Not rsAttach.Eof Then Do While Not rsAttach.Eof sType = UCase(Trim("" & rsAttach("umbmType"))) sValue = "" & rsAttach("umbmValue") Response.Write "" 'Select Case sType ' Case "IMG": Response.Write "" ' Case Else ' Response.Write "" 'End Select Response.Write "" Response.Write "" Response.Write "" rsAttach.Movenext Loop Else Response.Write "" End If rsAttach.Close Set rsAttach = Nothing Response.Write "
" & gsColumnHeadOpen & GLS_TextAttachments & gsColumnHeadClose & "
" & gsPlainTextOpen & "" & sValue & " " & gsPlainTextClose & "" & gsPlainTextOpen & rsAttach("umbmValue") & " " & gsPlainTextClose & "" & gsPlainTextOpen & rsAttach("umbmSize") & " " & gsPlainTextClose & "" & gsPlainTextOpen & DispShortDateTime(rsAttach("umbmCreated")) & gsPlainTextClose & "
" & gsPlainTextOpen & GLS_MBErrListFiles & gsPlainTextClose & "
" End If If bUpdate Then sUpdate= "UPDATE tblXUDUserMessageBase SET" & _ " umbRead=" & SQLStr("Y") & "," & _ " umbReadOn=" & SQLDate(vNow) & _ " WHERE umbID=" & SQLVal(lID) gobjConnect.Execute(sUpdate) End If End Sub Sub ViewInbox If NOT gbMBSendAsEmail Or gbMBSendAdvMessage Then UpdateMailFlag sNav = "" & GLS_MBNavInbox & "" TableHead sNav sSQL = "SELECT umbID, umbSystem, umbSystemID, umbSubject, umbRegID, umbFromRegID, umbFromName, " & _ " umbFromEmail, umbDate, umbHasAttachments, umbRead, umbReplied " & _ " FROM tblXUDUserMessageBase" & _ " WHERE umbRegID=" & SQLVal(glUserID) & _ " AND (umbReceiverDelete=" & SQLStr("N") & " OR umbReceiverDelete Is NULL) " & _ " ORDER BY umbDate DESC" Response.Write gsSectionTitleOpen & GLS_MBMessagesReceived & gsSectionTitleClose & "
" Response.Write "" Response.Write "
" Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "" Set rsMail = Server.CreateObject("ADODB.Recordset") rsMail.PageSize = giItemsPerPage rsMail.CursorLocation = 3 'adUseClient rsMail.Open sSQL, gobjConnect, 3, 1, &H0001 'adOpenStatic, adLockReadOnly, adCmdText If Not rsMail.EOF Then Response.Write "" Response.Write "" Response.Write "" lPageCount = rsMail.PageCount If iPageCurrent < 1 Then iPageCurrent = 1 If iPageCurrent > lPageCount Then iPageCurrent = lPageCount rsMail.AbsolutePage = iPageCurrent iLineFlag = True sLineTag = AlternateTag(iLineFlag, gsAltColorOne, gsAltColorTwo) Do While (Not rsMail.EOF) AND (rsMail.AbsolutePage = iPageCurrent) sLineTag = AlternateTag(iLineFlag, gsAltColorOne, gsAltColorTwo) Response.Write "" If EvalBool(rsMail("umbRead")) Then If EvalBool(rsMail("umbReplied")) Then sImage = "" Else sImage = "" End If Else sImage = "" End If If EvalBool(rsMail("umbHasAttachments")) Then sImage = sImage & "" End If Response.Write "" sFromDisplay = rsMail("umbFromName") If rsMail("umbFromRegID") = 0 Then sFromDisplay = sFromDisplay & GLS_MBNonRegSymbol ElseIf IsUserVerified(rsMail("umbFromRegID")) Then sFromDisplay = sFromDisplay & GLS_Verified End If Response.Write "" Response.Write "" Select Case UCase("" & rsMail("umbSystem")) Case "AUC": If FVal(rsMail("umbSystemID")) > 0 Then sLink = "" & SystemTypeIcon("AUC") & "" Else sLink = "" & SystemTypeIcon("AUC") & "" End If Case "CAD": If FVal(rsMail("umbSystemID")) > 0 Then sLink = "" & SystemTypeIcon("CAD") & "" Else sLink = "" & SystemTypeIcon("CAD") & "" End If Case "MSG": If FVal(rsMail("umbSystemID")) > 0 Then sLink = "" & SystemTypeIcon("MSG") & "" Else sLink = "" & SystemTypeIcon("MSG") & "" End If CASE "NP" If FVal(rsMail("umbSystemID")) > 0 Then sLink = "" & SystemTypeIcon("NP") & "" Else sLink = "" & SystemTypeIcon("NP") & "" End If Case Else sLink = GLS_SymbNone End Select Response.Write "" Response.Write "" Response.Write "" rsMail.MoveNext Loop If gbMBAllowNonReg Then Response.Write "" End If Response.Write "" Response.Write "" If lPageCount > 1 Then sLineTag = AlternateTag(iLineFlag, gsAltColorOne, gsAltColorTwo) Response.Write "" End If Else Response.Write "" End If rsMail.Close set rsMail = Nothing Response.Write "
 " & gsColumnHeadOpen & GLS_TextFrom & gsColumnHeadClose & "" & gsColumnHeadOpen & GLS_TextReceived & gsColumnHeadClose & "" & gsColumnHeadOpen & GLS_TextSystem & gsColumnHeadClose & "" & gsColumnHeadOpen & GLS_TextSubject & gsColumnHeadClose & "
" Response.Write "" Response.Write " " & sImage & "" Response.Write "" & gsPlainTextOpen & sFromDisplay & gsPlainTextClose & "" & gsPlainTextOpen & DispShortDate(rsMail("umbDate")) & gsPlainTextClose & "" & gsPlainTextOpen & sLink & gsPlainTextClose & "" & gsPlainTextOpen & rsMail("umbSubject") & gsPlainTextClose & "
" Response.Write gsPlainTextOpen & GLS_MBNonRegSymbol & GLS_MBNonRegText & gsPlainTextClose Response.Write "
" Response.Write "" Response.Write "
" ShowPaging Response.Write "
" Response.Write gsPlainTextOpen & GLS_TextNoMessages & gsPlainTextClose Response.Write "
" Response.Write "
" Else ComposeMessage End If End Sub Sub ViewSentbox If NOT gbMBSendAsEmail Or gbMBSendAdvMessage Then sSQL = "SELECT umbID, umbSystem, umbSystemID, umbSubject, umbRegID, umbFromRegID, umbFromName, " & _ " umbFromEmail, umbDate, umbHasAttachments, umbRead, umbReadOn " & _ " FROM tblXUDUserMessageBase" & _ " WHERE umbFromRegID=" & SQLVal(glUserID) & _ " ORDER BY umbDate DESC" sNav = "" & GLS_MBNavSentbox & "" TableHead sNav Response.Write gsSectionTitleOpen & GLS_MBMessagesSent & gsSectionTitleClose & "
" Response.Write "" Response.Write "
" Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "" Response.Write "" Set rsMail = Server.CreateObject("ADODB.Recordset") rsMail.PageSize = giItemsPerPage rsMail.CursorLocation = 3 'adUseClient rsMail.Open sSQL, gobjConnect, 3, 1, &H0001 'adOpenStatic, adLockReadOnly, adCmdText If Not rsMail.EOF Then lPageCount = rsMail.PageCount If iPageCurrent < 1 Then iPageCurrent = 1 If iPageCurrent > lPageCount Then iPageCurrent = lPageCount rsMail.AbsolutePage = iPageCurrent iLineFlag = True sLineTag = AlternateTag(iLineFlag, gsAltColorOne, gsAltColorTwo) Do While (Not rsMail.EOF) AND (rsMail.AbsolutePage = iPageCurrent) sLineTag = AlternateTag(iLineFlag, gsAltColorOne, gsAltColorTwo) Response.Write "" If evalBool(rsMail("umbRead")) Then sImage = "" Else sImage = "" End If If EvalBool(rsMail("umbHasAttachments")) Then sImage = sImage & "" End If Response.Write "" sToDisplay = GetUserName(rsMail("umbRegID")) If IsUserVerified (rsMail("umbRegID")) Then sToDisplay = sToDisplay & GLS_Verified End If Response.Write "" Response.Write "" Response.Write "" Select Case UCase("" & rsMail("umbSystem")) Case "AUC": If FVal(rsMail("umbSystemID")) > 0 Then sLink = "" & SystemTypeIcon("AUC") & "" Else sLink = "" & SystemTypeIcon("AUC") & "" End If Case "CAD": If FVal(rsMail("umbSystemID")) > 0 Then sLink = "" & SystemTypeIcon("CAD") & "" Else sLink = "" & SystemTypeIcon("CAD") & "" End If Case "MSG": If FVal(rsMail("umbSystemID")) > 0 Then sLink = "" & SystemTypeIcon("MSG") & "" Else sLink = "" & SystemTypeIcon("MSG") & "" End If Case Else sLink = GLS_SymbNone End Select Response.Write "" Response.Write "" Response.Write "" rsMail.MoveNext Loop If lPageCount > 1 Then sLineTag = AlternateTag(iLineFlag, gsAltColorOne, gsAltColorTwo) Response.Write "" End If Else Response.Write "" End If rsMail.Close set rsMail = Nothing Response.Write "
 " & gsColumnHeadOpen & GLS_TextTo & gsColumnHeadClose & "" & gsColumnHeadOpen & GLS_TextSent & gsColumnHeadClose & "" & gsColumnHeadOpen & GLS_TextRead & gsColumnHeadClose & "" & gsColumnHeadOpen & GLS_TextSystem & gsColumnHeadClose & "" & gsColumnHeadOpen & GLS_TextSubject & gsColumnHeadClose & "
" & sImage & "" & gsPlainTextOpen & sToDisplay & gsPlainTextClose & "" & gsPlainTextOpen & DispShortDate(rsMail("umbDate")) & gsPlainTextClose & "" & gsPlainTextOpen If Len(Trim("" & rsMail("umbReadOn"))) > 0 Then Response.Write DispShortDate(rsMail("umbReadOn")) Else Response.Write GLS_SymbNone End If Response.Write gsPlainTextClose & "" & gsPlainTextOpen & sLink & gsPlainTextClose & "" & gsPlainTextOpen & rsMail("umbSubject") & gsPlainTextClose & "
" ShowPaging Response.Write "
" Response.Write gsPlainTextOpen & GLS_TextNoMessages & gsPlainTextClose Response.Write "
" Response.Write "
" Else ComposeMessage End If End Sub Sub TableHead (psEndText) Response.Write "" Response.Write "" Response.Write "" Response.Write "
" If NOT gbMBSendAsEmail Or gbMBSendAdvMessage Then Response.Write "" sTempColor = gsBackTabColor sTabTagOpen = gsUnselectedTabTextOpen sTabTagClose = gsUnselectedTabTextClose If sView = "IN" Then sTempColor = gsMainTabColor sTabTagOpen = gsSelectedTabTextOpen sTabTagClose = gsSelectedTabTextClose End If Response.Write "" Response.Write "" Response.Write "" sTempColor = gsBackTabColor sTabTagOpen = gsUnselectedTabTextOpen sTabTagClose = gsUnselectedTabTextClose If sView = "OUT" Then sTempColor = gsMainTabColor sTabTagOpen = gsSelectedTabTextOpen sTabTagClose = gsSelectedTabTextClose End If Response.Write "" Response.Write "" sTempColor = gsBackTabColor sTabTagOpen = gsUnselectedTabTextOpen sTabTagClose = gsUnselectedTabTextClose If sView = "COMPOSE" Then sTempColor = gsMainTabColor sTabTagOpen = gsSelectedTabTextOpen sTabTagClose = gsSelectedTabTextClose End If Response.Write "" Response.Write "" sTempColor = gsBackTabColor sTabTagOpen = gsUnselectedTabTextOpen sTabTagClose = gsUnselectedTabTextClose Response.Write "" Response.Write "" Response.Write "" Response.Write "
" & sTabTagOpen Response.Write "" & GLS_MBNavInbox & "" Response.Write sTabTagClose & "
 
" & sTabTagOpen Response.Write "" & GLS_MBNavSentbox & "" Response.Write sTabTagClose & "
 
" & sTabTagOpen Response.Write "" & GLS_MBNavCompose & "" Response.Write sTabTextClose & "
  
" End If Response.Write "
" End Sub Sub TableFoot Response.Write "
" ShowNavBar End Sub Function GetUserName(plID) dim lUserID lUserID = FVal(plID) sSQL = "SELECT regUserName from tblXUDUserRegistration WHERE regID=" & SQLVal(lUserID) set rsUser= gObjConnect.Execute(sSQL) If NOT rsUser.EOF Then GetUserName = rsUser("regUserName") Else GetUserName = "" End If rsUser.Close set rsUser = Nothing End Function Function GetUserEmail(plID) dim lUserID lUserID = FVal(plID) sSQL = "SELECT regEmail from tblXUDUserRegistration WHERE regID=" & SQLVal(lUserID) set rsUser= gObjConnect.Execute(sSQL) If NOT rsUser.EOF Then GetUserEmail = rsUser("regEmail") Else GetUserEmail = "" End If rsUser.Close set rsUser = Nothing End Function Sub UpdateMailFlag sUpdate = "UPDATE tblXUDUserRegistration SET regHasUserMail=" & SQLStr("N") & _ " WHERE regID=" & SQLVal(glUserID) gobjConnect.Execute(sUpdate) End Sub Sub ShowPaging iLowRange = RoundDownToNearest(iPageCurrent, 10) If iLowRange < 1 Then iLowRange = 1 End If iHighRange = iLowRange + 9 Response.Write "" Response.Write "
" & gsPlainTextOpen If iPageCurrent > 1 Then Response.Write "   " Else Response.Write "   " End If If iLowRange >= 10 Then Response.Write "-" Else Response.Write "" End If sTemp = " " iPage = iLowRange Do While (iPage < iHighRange + 1) And (iPage <= lPageCount) If iPage <> iPageCurrent Then sTemp = sTemp & "" & iPage & "  " Else sTemp = sTemp & "" & iPage & "  " End If iPage = iPage + 1 Loop sTemp = sTemp & "" Response.Write sTemp If lPageCount > iHighRange Then Response.Write "+ " End If If iPageCurrent < lPageCount Then Response.Write "    " Else Response.Write "    " End If Response.Write gsPlainTextClose & "
" End Sub %>