<%
'#################################################################################
'## Copyright (C) 2000 Michael Anderson and Pierre Gorissen
'##
'## 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 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 support forums at:
'## http://forum.snitz.com
'##
'## Correspondence and Marketing Questions can be sent to:
'## reinhold@bigfoot.com
'##
'## or
'##
'## Snitz Communications
'## C/O: Michael Anderson
'## PO Box 200
'## Harpswell, ME 04079
'#################################################################################
%>
<% If Session(strCookieURL & "Approval") = "15916941253" Then %>
<%
if Request.Form("Method_Type") = "Write_Configuration" then
Err_Msg = ""
if Err_Msg = "" then
'## Delete private messages
strMessageDays = datetostr(dateAdd("d",-Request.Form("strMessageDays"),strForumTimeAdjust))
strSql = "DELETE FROM " & strTablePrefix & "PM "
strSql = strSql & "WHERE M_SENT < '" & strMessageDays & "'"
if Request.Form("UnRead") = "yes" then
strSql = strSql & " AND M_READ = 0"
else
strSql = strSql & " AND M_READ = 1"
end if
my_Conn.Execute (strSql)
%>
Messages Deleted!
Congratulations!
Back To Admin Home
<% else %>
There Was A Problem With Your Details
>Go Back To Enter Data
<% end if %>
<% else %>
<%
strMessage15Days = datetostr(dateAdd("d",-15,strForumTimeAdjust))
strMessage30Days = datetostr(dateAdd("d",-30,strForumTimeAdjust))
strMessage45Days = datetostr(dateAdd("d",-45,strForumTimeAdjust))
strMessage60Days = datetostr(dateAdd("d",-60,strForumTimeAdjust))
if strDBType = "access" then
strSqL = "SELECT count(M_TO) as [pmcount] "
else
strSQL = "SELECT count(M_TO) as pmcount "
end if
strSql = strSql & " FROM " & strTablePrefix & "PM "
strSql = strSql & " WHERE M_READ = 1"
Set rsPM = my_Conn.Execute(strSql)
pmcountr = rsPM("pmcount")
rsPM.close
set rsPM = nothing
if strDBType = "access" then
strSqL = "SELECT count(M_TO) as [pmcount] "
else
strSQL = "SELECT count(M_TO) as pmcount "
end if
strSql = strSql & " FROM " & strTablePrefix & "PM "
strSql = strSql & " WHERE M_READ = 0"
Set rsPM = my_Conn.Execute(strSql)
pmcountu = rsPM("pmcount")
rsPM.close
set rsPM = nothing
if strDBType = "access" then
strSqL = "SELECT count(M_TO) as [pmcount] "
else
strSQL = "SELECT count(M_TO) as pmcount "
end if
strSql = strSql & " FROM " & strTablePrefix & "PM "
strSql = strSql & " WHERE M_SENT < '" & strMessage15Days & "' AND M_READ = 1"
Set rsPM = my_Conn.Execute(strSql)
pmcount15r = rsPM("pmcount")
rsPM.close
set rsPM = nothing
if strDBType = "access" then
strSqL = "SELECT count(M_TO) as [pmcount] "
else
strSQL = "SELECT count(M_TO) as pmcount "
end if
strSql = strSql & " FROM " & strTablePrefix & "PM "
strSql = strSql & " WHERE M_SENT < '" & strMessage15Days & "' AND M_READ = 0"
Set rsPM = my_Conn.Execute(strSql)
pmcount15u = rsPM("pmcount")
rsPM.close
set rsPM = nothing
if strDBType = "access" then
strSqL = "SELECT count(M_TO) as [pmcount] "
else
strSQL = "SELECT count(M_TO) as pmcount "
end if
strSql = strSql & " FROM " & strTablePrefix & "PM "
strSql = strSql & " WHERE M_SENT < '" & strMessage30Days & "' AND M_READ = 1"
Set rsPM = my_Conn.Execute(strSql)
pmcount30r = rsPM("pmcount")
rsPM.close
set rsPM = nothing
if strDBType = "access" then
strSqL = "SELECT count(M_TO) as [pmcount] "
else
strSQL = "SELECT count(M_TO) as pmcount "
end if
strSql = strSql & " FROM " & strTablePrefix & "PM "
strSql = strSql & " WHERE M_SENT < '" & strMessage30Days & "' AND M_READ = 0"
Set rsPM = my_Conn.Execute(strSql)
pmcount30u = rsPM("pmcount")
rsPM.close
set rsPM = nothing
if strDBType = "access" then
strSqL = "SELECT count(M_TO) as [pmcount] "
else
strSQL = "SELECT count(M_TO) as pmcount "
end if
strSql = strSql & " FROM " & strTablePrefix & "PM "
strSql = strSql & " WHERE M_SENT < '" & strMessage45Days & "' AND M_READ = 1"
Set rsPM = my_Conn.Execute(strSql)
pmcount45r = rsPM("pmcount")
rsPM.close
set rsPM = nothing
if strDBType = "access" then
strSqL = "SELECT count(M_TO) as [pmcount] "
else
strSQL = "SELECT count(M_TO) as pmcount "
end if
strSql = strSql & " FROM " & strTablePrefix & "PM "
strSql = strSql & " WHERE M_SENT < '" & strMessage45Days & "' AND M_READ = 0"
Set rsPM = my_Conn.Execute(strSql)
pmcount45u = rsPM("pmcount")
rsPM.close
set rsPM = nothing
if strDBType = "access" then
strSqL = "SELECT count(M_TO) as [pmcount] "
else
strSQL = "SELECT count(M_TO) as pmcount "
end if
strSql = strSql & " FROM " & strTablePrefix & "PM "
strSql = strSql & " WHERE M_SENT < '" & strMessage60Days & "' AND M_READ = 1"
Set rsPM = my_Conn.Execute(strSql)
pmcount60r = rsPM("pmcount")
rsPM.close
set rsPM = nothing
if strDBType = "access" then
strSqL = "SELECT count(M_TO) as [pmcount] "
else
strSQL = "SELECT count(M_TO) as pmcount "
end if
strSql = strSql & " FROM " & strTablePrefix & "PM "
strSql = strSql & " WHERE M_SENT < '" & strMessage60Days & "' AND M_READ = 0"
Set rsPM = my_Conn.Execute(strSql)
pmcount60u = rsPM("pmcount")
rsPM.close
set rsPM = nothing
%>
| Current Private Message Counts |
| Time Period |
Read |
Unread |
| All |
<% =pmcountr %> |
<% =pmcountu %> |
| Older than 15 days |
<% =pmcount15r %> |
<% =pmcount15u %> |
| Older than 30 days |
<% =pmcount30r %> |
<% =pmcount30u %> |
| Older than 45 days |
<% =pmcount45r %> |
<% =pmcount45u %> |
| Older than 60 days |
<% =pmcount60r %> |
<% =pmcount60u %> |
|
<% end if
WriteFooter
Else
scriptname = split(request.servervariables("SCRIPT_NAME"),"/")
Response.Redirect "admin_login.asp?target=" & scriptname(ubound(scriptname))
End IF
%>
All Forums
Private Messages Maintenance