%
Function xieTag(who)
Dim s
s=who
rs.Open "mgtag",Conn
do while not rs.eof
s=replace(s,rs("tagname"),""+rs("tagname")+"")
rs.movenext
loop
rs.close
xieTag=s
End Function
top
if Request.Cookies("username")=empty then error("
您还未登录社区")
DetectPost
id=int(Request("id"))
sql="Select * From forum where ID="&ID&""
rs.Open sql,Conn,1
if rs("locktopic")=1 then error("此主题已经关闭,不接受新的回复")
forumid=rs("forumid")
ReList=rs("ReList")
rs.close
username=Request.Cookies("username")
topic=HTMLEncode(Request("topic"))
content=ContentEncode(Request.Form("content"))
content=xieTag(content)
if badwords<>empty then
filtrate=split(badwords,"|")
for i = 0 to ubound(filtrate)
topic=ReplaceText(topic,""&filtrate(i)&"",string(len(filtrate(i)),"*"))
next
end if
If not conn.Execute("Select username from prison where username='"&username&"'" ).eof Then error("您被关进监狱")
sql="select * from bbsconfig where id="&forumid&""
Set Rs=Conn.Execute(sql)
bbsname=rs("bbsname")
logo=rs("logo")
followid=rs("followid")
rs.close
if membercode>1 or instr("|"&moderated&"|","|"&Request.Cookies("username")&"|")>0 then UserPopedomPass=1
if Request.ServerVariables("request_method") = "POST" and Request("preview")="" then
if Len(content)<2 then message=message&"文章内容不能小于 2 字符"
if Application(CacheName&"LastPostName")=username then
if DateDiff("s",Application(CacheName&"LastPostTime"),Now()) < int(PostTime) then message=message&"为防止有人用程序灌水,论坛限制一个人两次发帖间隔必须大于"&PostTime&"秒!"
end if
if message<>"" then error(""&message&"")
sql="select * from user where username='"&HTMLEncode(username)&"'"
rs.Open sql,Conn,1,3
if rs("userlife")<3 then
message=message&"您的体力值 < 3 不能发表文章每有效停留时间 10 分钟:体力值:+10"
end if
StopPostTime=int(DateDiff("s",rs("regtime"),Now())/60)
if StopPostTime < int(Reg10) then message=message&"新注册用户必须 "&Reg10&" 分钟后才能发帖,您必须再等待 "&Reg10-StopPostTime&" 分钟!"
if message<>"" then error(""&message&"")
if UserPopedomPass<>1 then rs("userlife")=rs("userlife")-1
rs("postrevert")=rs("postrevert")+1
rs("money")=rs("money")+1
rs("experience")=rs("experience")+1
rs("landtime")=now()
rs.update
rs.close
sql="insert into reforum"&ReList&" (topicid,username,content,postip,posttime) values ('"&id&"','"&Request.Cookies("username")&"','"&content&"','"&Request.ServerVariables("HTTP_X_FORWARDED_FOR")&"',now())"
conn.Execute(SQL)
conn.execute("update forum set lastname='"&username&"',replies=replies+1,lasttime='"&now()&"' where ID="&ID&"")
conn.execute("update bbsconfig set lasttopic='"&left(topic,15)&"',lastname='"&username&"',lasttime='"&now()&"',today=today+1,tolrestore=tolrestore+1 where id="&forumid&"")
conn.execute("update clubconfig set today=today+1")
'send email to all joinner's
sql="select a.username,a.usermail from user a inner join reforum"& ReList &" b on a.username = b.username where b.topicid="& id &" and a.bbsemail=1 group by a.username"
rs.open sql,conn,1
mailaddress=""
Do While Not rs.eof
If rs("username")<>username Then mailaddress=mailaddress+"," +rs("usermail")
rs.movenext
loop
rs.close
sql="select a.username,a.usermail from user a inner join forum b on a.username = b.username where b.id="& id &" and a.bbsemail=1"
rs.open sql,conn,1
Do While Not rs.eof
If InStr(mailaddress,rs("username"))=0 And rs("username")<>username Then mailaddress=mailaddress+"," +rs("usermail")
rs.movenext
loop
rs.close
mailtopic="您在重症肌无力病友之家参与的讨论有新的回复"
body=""&vbCrlf&"亲, 您好!"&vbCrlf&""&vbCrlf&" 您收到此信件,是因为您在重症肌无力病友之家(www.9b01.net)参与讨论的帖子有新的回复。请点击链接((http://www.9b01.net/zzjwl/ShowPost.asp?id=" & id & ")查看。"& vbCrlf & vbCrlf & "论坛服务由 "&homename&":"&homeurl&" 提供 程序制作:Yuzi工作室"&vbCrlf&""&vbCrlf&""&vbCrlf&""
%>
<%
Application.Lock
Application(CacheName&"CountReforum") = Application(CacheName&"CountReforum")+1
Application(CacheName&"LastPostName")=username
Application(CacheName&"LastPostTime")=now()
Application.UnLock
message=message&"回复主题成功返回主题返回论坛返回论坛首页"
succeed(""&message&"")
end if
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
if Request("quote")=1 and Request("preview")="" then
if isnumeric(""&Request("retopicid")&"") then
sql="select * from reforum"&ReList&" where id="&Request("retopicid")&""
else
sql="select * from forum where ID="&id&""
end if
Set Rs=Conn.Execute(sql)
content =rs("content")
quote="引用:
原文由 "&rs("username")&" 发表于 "&rs("posttime")&" :
"&content&""&vbCrlf&"
"
rs.close
end if
if Request("quote")=2 and Request("preview")="" then
if isnumeric(""&Request("retopicid")&"") then
sql="select * from reforum"&ReList&" where id="&Request("retopicid")&""
else
sql="select * from forum where ID="&id&""
end if
Set Rs=Conn.Execute(sql)
content =rs("content")
dzhqy=Request("dzhqy")
if instr(content,dzhqy)>0 then
dzhqy="......
"+dzhqy+"
......"
quote="引用:
原文由 "&rs("username")&" 发表于 "&rs("posttime")&" :
"&dzhqy&""&vbCrlf&"
"
end if
rs.close
end if
%>
border=0 class=a2 align="center">
<%
htmlend
%>