📄 syscode_guest.asp
字号:
<%@language=vbscript codepage=936 %>
<%
option explicit
response.buffer=true
'强制浏览器重新访问服务器下载页面，而不是从缓存读取页面
Response.Buffer = True
Response.Expires = -1
Response.ExpiresAbsolute = Now() - 1
Response.Expires = 0
Response.CacheControl = "no-cache"
%>
<!--#include file="conn.asp"-->
<!--#include file="Conn_User.asp"-->
<!--#include file="config.asp"-->
<!--#include file="ubbcode.asp"-->
<!--#include file="function.asp"-->
<!--#include file="admin_code_guest.asp"-->
<!--#include file="md5.asp"-->
<%
dim strChannel,sqlChannel,rsChannel,ChannelUrl,ChannelName
dim strFileName,MaxPerPage,totalPut,CurrentPage,TotalPages
dim BeginTime,EndTime,founderr, errmsg,i
dim rs,sql,rsGuest,sqlGuest
dim PageTitle,strPath,strPageTitle
dim SkinID,ClassID,AnnounceCount
dim UserGuestName,UserType,UserSex,UserEmail,UserHomepage,UserOicq,UserIcq,UserMsn
dim WriteName,WriteType,WriteSex,WriteEmail,WriteOicq,WriteIcq,WriteMsn,WriteHomepage
dim WriteFace,WriteImages,WriteTitle,WriteContent,SaveEdit,SaveEditId
dim GuestType,LoginName,AdminReplyContent
dim Action,SubmitType,GuestPath,TitleName,keyword
Set rsGuest= Server.CreateObject("ADODB.Recordset")
'***********************************************************************************************
strPath= " <a href='" & SiteUrl & "'>" & SiteName & "</a>"
strPageTitle= SiteTitle
if ShowSiteChannel="Yes" then
strChannel= "<font color='#FFFFFF'>|</font> "
sqlChannel="select * from Channel order by OrderID"
set rsChannel=server.CreateObject("adodb.recordset")
rsChannel.open sqlChannel,conn,1,1
do while not rsChannel.eof
if rsChannel("ChannelID")=ChannelID then
ChannelUrl=rsChannel("LinkUrl")
ChannelName=rsChannel("ChannelName")
strChannel=strChannel & "<a href='" & ChannelUrl & "' style='text-decoration:none;'><font color='#FFFFFF'>" & ChannelName & "</font></a> <font color='#FFFFFF'>|</font> "
else
strChannel=strChannel & "<a href='" & rsChannel("LinkUrl") & "' style='text-decoration:none;'><font color='#FFFFFF'>" & rsChannel("ChannelName") & "</font></a> <font color='#FFFFFF'>|</font> "
end if
rsChannel.movenext
loop
rsChannel.close
set rsChannel=nothing
strPath=strPath & " >> <a href='" & ChannelUrl & "'>" & ChannelName & "</a>"
strPageTitle=strPageTitle & " >> " & ChannelName
end if
BeginTime=Timer
ClassID=0
'*********************************************************************************************
strFileName="GuestBook.asp"
GuestPath="images/guestbook/"
MaxPerPage=10
SaveEdit=0
if request("page")<>"" then
currentPage=cint(request("page"))
else
currentPage=1
end if
TitleName=ChannelName
Action=request("Action")
select case Action
case "write"
PageTitle="签写留言"
case "savewrite"
PageTitle="保存留言"
case "reply"
PageTitle="回复留言"
case "edit"
PageTitle="编辑留言"
case "del"
PageTitle="删除留言"
case else
PageTitle="网站留言"
end select
GuestType=0
if CheckUserLogined()=true then
GuestType=1
LoginName=Trim(Request.Cookies("asp163")("UserName"))
end if
keyword=trim(request("keyword"))
if keyword<>"" then
keyword=ReplaceBadChar(keyword)
keyword=Replace(keyword,"[","")
keyword=Replace(keyword,"]","")
end if
if keyword<>"" then TitleName="搜索含有 <font color=red>"&keyword&"</font> 的留言"
'=================================================
'过程名：GuestBook_Left()
'作 用：显示左侧留言功能
'参 数：无
'=================================================
sub GuestBook_Left()
set rsGuest=conn.execute("select count(*) from Guest where GuestIsPassed=0")
if GuestType=1 then
response.write " 留言模式：<font color=green>用户模式</font>" & vbcrlf
else
response.write " 留言模式：<font color=green>游客模式</font>" & vbcrlf
end if
if EnableGuestCheck="Yes" then
response.write " 发表模式：<font color=green>审核发表</font>" & vbcrlf
response.write " 待审留言：<font color=red>"&rsGuest(0)&"</font> 条" & vbcrlf
else
response.write " 发表模式：<font color=green>直接发表</font>" & vbcrlf
end if
if GuestType=1 then
response.write "<div align='center'><a href='" & strFileName & "?action=user' >【我的留言】</a></div>"
end if
response.write "<div align='center'><a href='" & strFileName & "' >【查看留言】</a></div>" & vbcrlf
response.write "<div align='center'><a href='" & strFileName & "?action=write' >【签写留言】</a></div><br>" & vbcrlf
end sub
'=================================================
'过程名：GuestBook_Search()
'作 用：显示留言搜索
'参 数：无
'=================================================
sub GuestBook_Search()
response.write "<table border='0' cellpadding='0' cellspacing='0'>"
response.write "<form method=""post"" name='SearchForm' action='" & strFileName & "'>"
response.write "<tr><td height='40' >"
response.write " <input type='text' name='keyword' size='15' value='关键字' maxlength='50' onFocus='this.select();'> "
response.write "<input type='submit' name='Submit' value='搜索'>"
response.write "</td></tr></form></table>"
end sub
%>
<%
'=================================================
'过程名：GuestBook()
'作 用：留言本功能调用
'参 数：无
'=================================================
sub GuestBook()
select case Action
case "write"
call WriteGuest()
case "savewrite"
call SaveWriteGuest()
case "reply"
call ReplyGuest()
case "edit"
call EditGuest()
case "del"
call DelGuest()
case "user"
call ShowAllGuest(3)
case else
call GuestMain()
end select
end sub
'=================================================
'过程名：GuestMain()
'作 用：留言主函数
'参 数：无
'=================================================
sub GuestMain()
if GuestType=1 then
ShowAllGuest(1)
else
ShowAllGuest(2)
end if
end sub
'=================================================
'过程名：ShowAllGuest()
'作 用：分页显示所有留言
'参 数：ShowType----- 0为显示所有
' 1为显示已通过审核及用户自己发表的留言
' 2为显示已通过审核的留言（用于游客显示）
' 3为显示用户自己发表的留言
'=================================================
sub ShowAllGuest(ShowType)
if ShowType=1 then
sqlGuest="select * from Guest where (GuestIsPassed=1 or GuestName='"&LoginName&"')"
elseif ShowType=2 then
sqlGuest="select * from Guest where GuestIsPassed=1"
elseif ShowType=3 then
sqlGuest="select * from Guest where GuestName='"&LoginName&"'"
elseif ShowType=4 then
sqlGuest="select * from Guest where GuestIsPassed=0"
else
if keyword<>"" then
sqlGuest="select * from Guest where 1"
else
sqlGuest="select * from Guest"
end if
end if
if keyword<>"" then
sqlGuest=sqlGuest & " and (GuestTitle like '%" & keyword & "%' or GuestContent like '%" & keyword & "%' or GuestName like '%" & keyword & "%' or GuestReply like '%" & keyword & "%') "
end if
sqlGuest=sqlGuest&" order by GuestMaxId desc"
set rsGuest=server.createobject("adodb.recordset")
rsGuest.open sqlGuest,conn,1,1
if rsGuest.bof and rsGuest.eof then
totalput=0
response.write "<br><li>没有任何留言</li>"
else
totalput=rsGuest.recordcount
if currentPage=1 then
call ShowGuestList()
else
if (currentPage-1)*MaxPerPage<totalPut then
rsGuest.move (currentPage-1)*MaxPerPage
dim bookmark
bookmark=rsGuest.bookmark
call ShowGuestList()
else
currentPage=1
call ShowGuestList()
end if
end if
end if
rsGuest.close
set rsGuest=nothing
end sub
'=================================================
'过程名：ShowGuestList()
'作 用：显示留言
'参 数：无
'=================================================
sub ShowGuestList()
dim i,GuestTip,TipName,TipSex,TipEmail,TipOicq,TipHomepage,isdelUser
i=0
do while not rsGuest.eof
isdelUser=0
if rsGuest("GuestType")=1 then
sql="select * from " & db_User_Table & " where " & db_User_Name & "='" & rsGuest("GuestName")&"'"
set rs=server.createobject("adodb.recordset")
rs.open sql,Conn_User,1,1
if not rs.bof and not rs.eof then
UserGuestName=rs(db_User_Name)
UserSex=rs(db_User_Sex)
UserEmail=rs(db_User_Email)
UserOicq=rs(db_User_QQ)
UserIcq=rs(db_User_Icq)
UserMsn=rs(db_User_Msn)
UserHomepage=rs(db_User_Homepage)
else
isdelUser=1
end if
end if
if rsGuest("GuestType")<>1 or isdelUser=1 then
UserGuestName=rsGuest("GuestName")
UserSex=rsGuest("GuestSex")
UserEmail=rsGuest("GuestEmail")
UserOicq=rsGuest("GuestOicq")
UserIcq=rsGuest("GuestIcq")
UserMsn=rsGuest("GuestMsn")
UserHomepage=rsGuest("GuestHomepage")
end if
TipName=UserGuestName
if isdelUser=1 then TipName=TipName&"（已删除）"
if UserEmail="" or isnull(UserEmail) then
TipEmail="未填"
else
TipEmail=UserEmail
end if
if UserOicq="" or isnull(UserOicq) then
TipOicq="未填"
else
TipOicq=UserOicq
end if
if UserHomepage="" or isnull(UserHomepage) then
TipHomepage="未填"
else
TipHomepage=UserHomepage
end if
if UserIcq="" or isnull(UserIcq) then UserIcq="未填"
if UserMsn="" or isnull(UserMsn) then UserMsn="未填"
if UserSex=1 then
TipSex="（酷哥）"
elseif UserSex=0 then
TipSex="(靓妹)"
else
TipSex=""
end if
GuestTip=" 姓名："&TipName&" "&TipSex&"<br> 主页："&TipHomepage&"<br> OICQ："&TipOicq&"<br> 信箱："&TipEmail&"<br> 地址："&rsGuest("GuestIP")&"<br> 时间："&rsGuest("GuestDatetime")
%>
<SCRIPT language=javascript>
function CheckAll(form)
{
for (var i=0;i<form.elements.length;i++)
{
var e = form.elements[i];
if (e.Name != "chkAll"&&e.disabled!=true)
e.checked = form.chkAll.checked;
}
}
</script>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -