<% If Dvbbs.BoardID < 1 Then Response.Write "参数错误" Response.End End If Dim MyPost Dim postbuyuser,bgcolor,abgcolor Dvbbs.Loadtemplates("post") Set MyPost = New Dvbbs_Post Dvbbs.Stats = MyPost.ActionName Dvbbs.Nav() Dvbbs.Head_var 1,Dvbbs.BoardNode.attributes.getNamedItem("depth").text,"","" MyPost.Save_CheckData Set MyPost = Nothing Dvbbs.ActiveOnline Dvbbs.Footer Class Dvbbs_Post Public Action,ActionName,Star,Page,IsAudit,TotalUseTable,ToAction,TopicMode,Reuser Private AnnounceID,ReplyID,ParentID,RootID,Topic,Content,char_changed,signflag,mailflag,iLayer,iOrders Private TopTopic,IsTop,LastPost,LastPost_1,UpLoadPic_n,ihaveupfile,smsuserlist,upfileinfo Private UserName,UserPassWord,UserPost,GroupID,UserClass,DateAndTime,DateTimeStr,Expression,MyLastPostTime,LastPostTimes Private LockTopic,MyLockTopic,MyIsTop,MyIsTopAll,MyTopicMode,Child Private CanLockTopic,CanTopTopic,CanTopTopic_a,CanEditPost,Rs,SQL,i,IsAuditcheck Private vote,votetype,votenum,votetimeout,voteid,isvote,ErrCodes Private GetPostType,ToMoney,UseTools,ToolsBuyUser,GetMoneyType,Tools_UseTools,Tools_LastPostTime,ToolsInfo,ToolsSetting Private tMagicFace,iMagicFace,tMagicMoney,tMagicTicket,FoundUseMagic Private Sub Class_Initialize() ErrCodes = "" '管理员及该版版主允许在锁定论坛发帖 If Dvbbs.Board_Setting(0)="1" And Not (Dvbbs.Master or Dvbbs.Boardmaster) Then Response.redirect "showerr.asp?action=lock&boardid="&dvbbs.boardID&"" End If If Dvbbs.IsReadonly() And Not Dvbbs.Master Then Response.redirect "showerr.asp?action=readonly&boardid="&dvbbs.boardID&"" Action = Request("Action") TotalUseTable = Dvbbs.NowUseBBS Select Case Action Case "snew" Action = 5 ActionName = template.Strings(1) If Dvbbs.GroupSetting(3)="0" Then Dvbbs.AddErrCode(70) Case "sre" Action = 6 ActionName = template.Strings(3) If Dvbbs.GroupSetting(5)="0" then Dvbbs.AddErrCode(71) Case "svote" Action = 7 ActionName = template.Strings(5) If Dvbbs.GroupSetting(8)="0" then Dvbbs.AddErrCode(56) Case "sedit" Action = 8 ActionName = template.Strings(7) Case Else Action = 1 ActionName = template.Strings(0) End Select Star = Request("star") If Star = "" Or Not IsNumeric(Star) Then Star = 1 Star = Clng(Star) Page = Request("page") If Page = "" Or Not IsNumeric(Page) Then Page = 1 Page = Clng(Page) IsAudit = Cint(Dvbbs.Board_Setting(3)) Reuser = False'此变量标识是否更名发贴 FoundUseMagic = False End Sub '通用判断 Public Function Chk_Post() If Dvbbs.Board_Setting(43)="1" Then Dvbbs.AddErrCode(72) If Dvbbs.Board_Setting(1)="1" and Dvbbs.GroupSetting(37)="0" Then Dvbbs.AddErrCode(26) If Dvbbs.UserID>0 Then If Clng(Dvbbs.GroupSetting(52))>0 And DateDiff("s",Dvbbs.MyUserInfo(14),Now)"&Replace(template.Strings(21),"{$timelimited}",Dvbbs.GroupSetting(52))&"&action=OtherErr" If Dvbbs.GroupSetting(62)<>"0" And Not Action = 8 Then If Clng(Dvbbs.GroupSetting(62))<=Clng(Dvbbs.UserToday(0)) Then Response.redirect "showerr.asp?ErrCodes=
  • "&Replace(template.Strings(27),"{$topiclimited}",Dvbbs.GroupSetting(62))&"&action=OtherErr" End If End If If Dvbbs.GroupSetting(3)="0" And (Action = 5 Or Action = 7) Then Response.redirect "showerr.asp?ErrCodes=
  • "&template.Strings(28)&"&action=OtherErr" If Dvbbs.GroupSetting(5)="0" And (Action = 6) Then Response.redirect "showerr.asp?ErrCodes=
  • "&template.Strings(29)&"&action=OtherErr" End Function '返回判断和参数 Public Function Get_M_Request() AnnounceID = Request("ID") If AnnounceID = "" Or Not IsNumeric(AnnounceID) Then Dvbbs.AddErrCode(30) Dvbbs.ShowErr() AnnounceID = cCur(AnnounceID) End Function '判断发表类型及权限 GetPostType 0=赠送金币贴(求回复答案),1=获赠金币贴,2=金币购买贴 Private Sub Chk_PostType() Dim ToolsID ToolsID = Trim(Request.Form("ToolsID")) GetPostType = Trim(Request.Form("GetPostType")) ToMoney = Trim(Request.Form("ToMoney")) If ToMoney="" or Not Isnumeric(ToMoney) Then ToMoney = 0 If ToolsID="" or Not Isnumeric(ToolsID) Then ToolsID = "" Else ToolsID = Cint(ToolsID) End If Dvbbs.MyUserInfo(37) = cCur(Dvbbs.MyUserInfo(37)) '用户金币数量 ToMoney = cCur(ToMoney) UseTools = "" ToolsBuyUser = "" GetMoneyType = 0 If Dvbbs.GroupSetting(59)<>1 Then Exit Sub If GetPostType<>"" and (Action = 5 or Action = 7) Then Select Case GetPostType Case "0" If ToMoney = 0 or ToMoney > Dvbbs.MyUserInfo(37) Or ToMoney < 0 Then Response.redirect "showerr.asp?ErrCodes=
  • 您设置的金币值为空或者多于您拥有的金币数量。&action=OtherErr" Dvbbs.MyUserInfo(37) = Dvbbs.MyUserInfo(37)-ToMoney 'UseTools = "-1111" ToolsBuyUser = "0|||$SendMoney" GetMoneyType = 1 Case "1" ToolsBuyUser = "0|||$GetMoney" GetMoneyType = 2 'UseTools = ToolsInfo(4) Case "2" If ToMoney = 0 Or ToMoney < 0 Then Response.redirect "showerr.asp?ErrCodes=
  • 请正确填写购买帖的金币数量。&action=OtherErr" Dim Buy_Orders,Buy_VIPType,Buy_UserList Buy_Orders = Request.FORM("Buy_Orders") Buy_VIPType = Request.FORM("Buy_VIPType") Buy_UserList = Request.FORM("Buy_UserList") If Buy_Orders<>"" and IsNumeric(Buy_Orders) Then Buy_Orders = cCur(Buy_Orders) Else Buy_Orders = -1 End If If Not IsNumeric(Buy_VIPType) Then Buy_VIPType = 0 If Buy_UserList<>"" Then Buy_UserList = Replace(Replace(Replace(Buy_UserList,"|||",""),"@@@",""),"$PayMoney","") ToolsBuyUser = "0@@@"&Buy_Orders&"@@@"&Buy_VIPType&"@@@"&Buy_UserList&"|||$PayMoney|||" GetMoneyType = 3 'UseTools = ToolsInfo(4) End Select End If '回复获赠金币帖判断 If Action = 6 and GetPostType = "1" Then If ToMoney = 0 or ToMoney > Dvbbs.MyUserInfo(37) Or ToMoney < 0 Then Response.redirect "showerr.asp?ErrCodes=
  • 您设置的金币值为空或者多于您拥有的金币数量。&action=OtherErr" End If End Sub '更新用户及系统道具数量(用户ID，道具ID，减少数量) Private Sub UpdateUserTools(U_UserID,U_ToolsID,n) Dim Sql,Rs If Clng(n)<0 Then n = "+" & n Else n = "-" & n End If Set Rs = Dvbbs.Plus_Execute("Select ID From [Dv_Plus_Tools_Buss] Where UserID="& U_UserID &" and ToolsID="& U_ToolsID) If Rs.Eof And Rs.Bof Then Dim Trs Set Trs = Dvbbs.Plus_Execute("Select ToolsName From Dv_Plus_Tools_Info Where ID=" & U_ToolsID) If Not (Trs.Eof And Trs.Bof) Then Sql = "Insert Into [Dv_Plus_Tools_Buss] (UserID,UserName,ToolsID,ToolsName,ToolsCount) Values ("&U_UserID&",'"&Dv_Tools.ToUserInfo(1)&"',"&U_ToolsID&",'"&Trs(0)&"',"&Clng(Replace(Replace(n,"+",""),"-",""))&")" Dvbbs.Plus_Execute(Sql) End If Trs.Close Set Trs=Nothing Else Sql = "Update [Dv_Plus_Tools_Buss] Set ToolsCount = ToolsCount"&n&" Where UserID="& U_UserID &" and ToolsID="& U_ToolsID Dvbbs.Plus_Execute(Sql) End If Rs.Close Set Rs=Nothing Sql = "Update [Dv_Plus_Tools_Info] Set UserStock = UserStock"&n&" Where ID="& U_ToolsID Dvbbs.Plus_Execute(Sql) End Sub '回复获赠金币帖时更新 Public Sub GetMoney_SaveRe() Dim ToUserID,ToUserName,UpPostBuyUser,UpGetMoney,Tempstr SQL="Select PostUserID,GetMoney,PostBuyUser,Username From "&TotalUseTable&" Where RootID="&RootID&" and ParentID=0 and GetMoneyType=2" Set Rs = Server.CreateObject("ADODB.Recordset") Rs.Open SQL,conn,1,3 If Not Rs.Eof Then ToUserID = Clng(Rs(0)) UpGetMoney = Rs(1) + ToMoney UpPostBuyUser = Rs(2) ToUserName = Rs(3) Tempstr = Split(UpPostBuyUser,"|||",2) Tempstr(0) = UpGetMoney Tempstr(1) = Tempstr(1) & "|||" & UserName &","& ToMoney UpPostBuyUser = Tempstr(0) & "|||" & Tempstr(1) UpPostBuyUser = Trim(UpPostBuyUser) Rs(1) = UpGetMoney Rs(2) = UpPostBuyUser Rs.update End If Rs.Close : Set Rs=Nothing '更新主题MONEY值 Sql = "Update [Dv_Topic] Set GetMoney="&UpGetMoney&" where TopicID="&RootID Dvbbs.Execute(sql) '主题作者获取金币 Sql = "Update [Dv_User] Set UserMoney=UserMoney + "&ToMoney&" where UserID="&ToUserID Dvbbs.Execute(sql) '插入道具日志 'Dim LogMsg 'LogMsg = "回复主题：《"&topic&"》 赠道给作者:"&ToUserName&""&ToMoney&"个金币成功，并插入道具日志记录。" 'Call Dvbbs.ToolsLog(0,0,ToMoney,0,0,LogMsg,Dvbbs.MyUserInfo(37)&"|"&Dvbbs.MyUserInfo(38)) End Sub Rem ------------------------ Rem 保存部分函数开始 Rem ------------------------ '检查数据,提取数据，获得贴子数据表名等。 Public Sub Save_CheckData() Chk_Post() CheckfromScript() 'Dim mysessiondata '把提交的数据保存到session Content = Dvbbs.Checkstr(Request.Form("body")) Dvbbs.MyUserInfo(Dvbbs.UserInfoCount-1) = Content Session(Dvbbs.CacheName & "UserID") = Dvbbs.MyUserInfo If Dvbbs.Board_Setting(4) = "1" Then If Not Dvbbs.CodeIsTrue() Then Response.redirect "showerr.asp?ErrCodes=
  • 验证码校验失败，2秒后自动返回上一页面。&action=OtherErr&autoreload=1" End If End If Chk_PostType() '魔法表情检查部分 tMagicFace = Request("tMagicFace") If tMagicFace = "" Or Not IsNumeric(tMagicFace) Then tMagicFace = 0 tMagicFace = Cint(tMagicFace) iMagicFace = Request("iMagicFace") If iMagicFace = "" Or Not IsNumeric(iMagicFace) Then iMagicFace = 0 iMagicFace = Clng(iMagicFace) Expression = Dvbbs.Checkstr(Request.Form("Expression")) If Expression = "" Then Expression = "face1.gif" Else Expression = Replace(Expression,"|","") End If If tMagicFace = 1 And iMagicFace > 0 And Dvbbs.Forum_Setting(98)="1" Then Set Rs = Dvbbs.Plus_Execute("Select tMoney,tTicket,MagicSetting From Dv_Plus_Tools_MagicFace Where MagicFace_s = " & iMagicFace) If Rs.Eof And Rs.Bof Then Expression = "0|" & Expression tMagicMoney = 0 tMagicTicket = 0 Else If cCur(Dvbbs.MyUserInfo(38)) < Rs(1) And cCur(Dvbbs.MyUserInfo(37)) < Rs(0) Then Response.redirect "showerr.asp?ErrCodes=
  • 您没有足够的金币或点券使用魔法表情，2秒后自动返回上一页面。&action=OtherErr&autoreload=1" Dim iMagicSetting iMagicSetting = Split(Rs(2),"|") If cCur(iMagicSetting(0)) > cCur(Dvbbs.MyUserInfo(8)) Then Response.redirect "showerr.asp?ErrCodes=
  • 您的帖子数没有达到使用魔法表情的标准，2秒后自动返回上一页面。&action=OtherErr&autoreload=1" If cCur(iMagicSetting(1)) > cCur(Dvbbs.MyUserInfo(21)) Then Response.redirect "showerr.asp?ErrCodes=
  • 您的金钱数没有达到使用魔法表情的标准，2秒后自动返回上一页面。&action=OtherErr&autoreload=1" If cCur(iMagicSetting(2)) > cCur(Dvbbs.MyUserInfo(22)) Then Response.redirect "showerr.asp?ErrCodes=
  • 您的经验数没有达到使用魔法表情的标准，2秒后自动返回上一页面。&action=OtherErr&autoreload=1" If cCur(iMagicSetting(3)) > cCur(Dvbbs.MyUserInfo(23)) Then Response.redirect "showerr.asp?ErrCodes=
  • 您的魅力数没有达到使用魔法表情的标准，2秒后自动返回上一页面。&action=OtherErr&autoreload=1" If cCur(iMagicSetting(4)) > cCur(Dvbbs.MyUserInfo(24)) Then Response.redirect "showerr.asp?ErrCodes=
  • 您的威望数没有达到使用魔法表情的标准，2秒后自动返回上一页面。&action=OtherErr&autoreload=1" Expression = iMagicFace & "|" & Expression tMagicMoney = Rs(0) tMagicTicket = Rs(1) FoundUseMagic = True End If Rs.Close Set Rs=Nothing Else Expression = "0|" & Expression End If Expression = Split(Expression,"|") Topic = Dvbbs.Checkstr(Request.Form("topic")) 'Content=Dvbbs.Checkstr(Request.Form("Content")) signflag = Dvbbs.Checkstr(Trim(Request.Form("signflag"))) mailflag = Dvbbs.Checkstr(Trim(Request.Form("emailflag"))) MyTopicMode = Dvbbs.Checkstr(Trim(Request.Form("topicximoo"))) MyLockTopic = Dvbbs.Checkstr(Trim(Request.Form("locktopic"))) Myistop = Dvbbs.Checkstr(Trim(Request.Form("istop"))) Myistopall = Dvbbs.Checkstr(Trim(Request.Form("istopall"))) TopicMode = Request.Form("topicmode") If Dvbbs.strLength(topic)> CLng(Dvbbs.Board_Setting(45)) Then Response.redirect "showerr.asp?ErrCodes=
  • "&Replace(template.Strings(23),"{$topiclimited}",Dvbbs.Board_Setting(45))&"
    2秒后自动返回上一页面。&action=OtherErr&autoreload=1" If Dvbbs.strLength(Content) > CLng(Dvbbs.Board_Setting(16)) Then Response.redirect "showerr.asp?ErrCodes=
  • "&Replace(template.Strings(24),"{$bodylimited}",Dvbbs.Board_Setting(16))&"
    2秒后自动返回上一页面。&action=OtherErr&autoreload=1" REM 2004-4-23添加限制帖子内容最小字节数,下次在模板中添加。Dvbbs.YangZheng If Dvbbs.strLength(Content) < CLng(Dvbbs.Board_Setting(52)) And Not CLng(Dvbbs.Board_Setting(52)) = 0 Then Response.redirect "showerr.asp?ErrCodes=
  • "&Replace(template.Strings(24),"大于{$bodylimited}","小于"&Dvbbs.Board_Setting(52))&"
    2秒后自动返回上一页面。&action=OtherErr&autoreload=1" Dim testContent testContent=Content testContent=Html2Ubb(testContent) testContent=Replace(testContent,vbNewLine,"") testContent=Replace(testContent," ","") testContent=Replace(testContent," ","") If testContent="" Then Response.redirect "showerr.asp?ErrCodes=
  • 您没有填写内容,或因当前不支持HTML模式,内容被自动过滤
    2秒后自动返回上一页面。&action=OtherErr&autoreload=1" If Not IsNumeric(mailflag) Or mailflag="" Then mailflag=0 If TopicMode<>"" and IsNumeric(TopicMode) Then TopicMode=Cint(TopicMode) Else TopicMode=0 mailflag=CInt(mailflag) If signflag="yes" Then signflag=1 Else signflag=0 End If If Request.form("upfilerename")<>"" Then ihaveupfile=1 upfileinfo=Replace(Request.form("upfilerename"),"'","") upfileinfo=Replace(upfileinfo,";","") upfileinfo=Replace(upfileinfo,"--","") upfileinfo=Replace(upfileinfo,")","") Dim fixid,upfilelen fixid=Replace(upfileinfo," ","") fixid=Replace(fixid,",","") If Not IsNumeric(fixid) Then ihaveupfile=0 upfilelen=len(upfileinfo) upfileinfo=left(upfileinfo,upfilelen-1) Else ihaveupfile=0 End If voteid=0 isvote=0 If Action = 7 Then votetype=Dvbbs.Checkstr(request.Form("votetype")) If IsNumeric(votetype)=0 or votetype="" Then votetype=0 vote=Dvbbs.Checkstr(trim(Replace(request.Form("vote"),"|",""))) Dim j,k,vote_1,votelen,votenumlen If vote="" Then Dvbbs.AddErrCode(81) Else vote=split(vote,chr(13)&chr(10)) j=0 For i = 0 To ubound(vote) If Not (vote(i)="" Or vote(i)=" ") Then vote_1=""&vote_1&""&vote(i)&"|" j=j+1 End If If i>cint(Dvbbs.Board_Setting(32))-2 Then Exit For Next For k = 1 to j votenum=""&votenum&"0|" Next votelen=len(vote_1) votenumlen=len(votenum) votenum=left(votenum,votenumlen-1) vote=left(vote_1,votelen-1) End If If Not IsNumeric(request("votetimeout")) Then Dvbbs.AddErrCode(82) Else If request("votetimeout")="0" Then votetimeout=dateadd("d",9999,Now()) Else votetimeout=dateadd("d",request("votetimeout"),Now()) End If votetimeout=Replace(Replace(CSTR(votetimeout+Dvbbs.Forum_Setting(0)/24),"上午",""),"下午","") End If End If If Action = 5 Or Action = 7 Then CanLockTopic=False CanTopTopic=False CanTopTopic_a=False If Topic="" Then Response.redirect "showerr.asp?ErrCodes=
  • 您忘记填写标题
    2秒后自动返回上一页面。&action=OtherErr&autoreload=1" '减少判断，如果不为固顶，锁定等等的操作的话，不检查权限。 If MyLockTopic="yes" Or Myistopall="yes" Or Myistop="yes" Then '判断用户是否有固顶/解除固顶帖子权限 If (dvbbs.master or dvbbs.superboardmaster or dvbbs.boardmaster) Then If Dvbbs.GroupSetting(21)="1" Then CanTopTopic=True If Dvbbs.GroupSetting(20)="1" Then CanLockTopic=True End If If Dvbbs.GroupSetting(21)="1" and Cint(Dvbbs.UserGroupID)>3 Then CanTopTopic=True If Dvbbs.FoundUserPer and Dvbbs.GroupSetting(21)="1" Then CanTopTopic=True ElseIf Dvbbs.FoundUserPer and Dvbbs.GroupSetting(21)="0" Then CanTopTopic=False End If '判断用户是否有总固顶帖子权限 If (dvbbs.master or dvbbs.superboardmaster or dvbbs.boardmaster) and Dvbbs.GroupSetting(38)="1" Then CanTopTopic_a=True If Dvbbs.GroupSetting(38)="1" and Cint(Dvbbs.UserGroupID)>3 Then CanTopTopic_a=True If Dvbbs.FoundUserPer and Dvbbs.GroupSetting(38)="1" Then CanTopTopic_a=True ElseIf Dvbbs.FoundUserPer and Dvbbs.GroupSetting(38)="0" Then CanTopTopic_a=False End If End If If MyLockTopic="yes" Then MyLockTopic=1 Else MyLockTopic=0 End If If Myistopall="yes" Then Myistopall=1 Else Myistopall=0 End If If Not CanTopTopic_a Then Myistopall=0 If Myistop="yes" and Myistopall=0 Then Myistop=1 If Not CanTopTopic Then Myistop=0 ElseIf Myistopall=1 Then Myistop=3 Else Myistop=0 End If If Not IsNumeric(MyTopicMode) or Dvbbs.GroupSetting(51)="0" Then MyTopicMode=0 If Not CanLockTopic Then MyLockTopic=0 TotalUseTable=Dvbbs.NowUseBbs ElseIf Action = 6 Then AnnounceID = Request("followup") RootID = Request("RootID") If AnnounceID = "" Or Not IsNumeric(AnnounceID) Then Dvbbs.AddErrCode(30) If RootID = "" Or Not IsNumeric(RootID) Then Dvbbs.AddErrCode(30) TotalUseTable=Request.Form("TotalUseTable") TotalUseTable=checktable(TotalUseTable) Dvbbs.ShowErr() AnnounceID = cCur(AnnounceID) ParentID = AnnounceID RootID = cCur(RootID) MyLockTopic=0 ElseIf Action = 8 Then If Not IsNumeric(MyTopicMode) or Dvbbs.GroupSetting(51)="0" Then MyTopicMode=0 AnnounceID = Request("replyID") RootID = Request("ID") If AnnounceID = "" Or Not IsNumeric(AnnounceID) Then Dvbbs.AddErrCode(30) If RootID = "" Or Not IsNumeric(RootID) Then Dvbbs.AddErrCode(30) TotalUseTable = Checktable(Request.Form("TotalUseTable")) Dvbbs.ShowErr() AnnounceID = cCur(AnnounceID) RootID = cCur(RootID) MyLockTopic=0 Set Rs=Dvbbs.Execute("select AnnounceID from "&TotalUseTable&" where ParentID=0 and rootid="&RootID) If Not Rs.eof Then If AnnounceID=Rs(0) Then If Topic="" Then Dvbbs.AddErrCode(79) End If Else Dvbbs.AddErrCode(30) End If End If Dvbbs.Showerr() SaveData() '清空表单内容 Dvbbs.MyUserInfo(Dvbbs.UserInfoCount-1) = "" Session(Dvbbs.CacheName & "UserID") = Dvbbs.MyUserInfo End Sub '保存数据 Private Sub SaveData() If Not (Dvbbs.Master or Action = 8) Then CheckpostTime() Dim Forumupload If Dvbbs.GroupSetting(64)="1" Then IsAudit=0 Else If Dvbbs.Board_Setting(57)="1" Then IsAudit=NeedIsAudit() IsAuditcheck=IsAudit End If End If locktopic=0 If MyLockTopic=1 Then locktopic=1 If IsAudit=1 And Action <> 8 Then LockTopic=Dvbbs.BoardID Dvbbs.BoardID=777 Response.Cookies("Dvbbs")=LockTopic Else Response.Cookies("Dvbbs")=Dvbbs.Boardid End If Forumupload=split(Dvbbs.Board_Setting(19),"|") For i=0 to ubound(Forumupload) If Instr(Content,"[upload="&Forumupload(i)&"]") or Instr(Content,"."&Forumupload(i)&"") or Instr(Content,"["&Forumupload(i)&"]") then uploadpic_n=Forumupload(i) Exit For End If Next If InStr(Content,"viewfile.asp?ID=") Then uploadpic_n="down" If Not Action = 8 Then savepost() updatepostuser() Else Update_Edit_Announce() End If If Dvbbs.GroupSetting(59)=1 Then If (Action = 5 Or Action = 7) and (GetPostType="1" or GetPostType="2") Then 'Dim LogMsg 'LogMsg = "主题：《"&topic&"》 使用"&ToolsInfo(5)&"道具成功，并插入道具日志记录。" 'Call Dvbbs.ToolsLog(ToolsInfo(4),1,0,0,1,LogMsg,Dvbbs.MyUserInfo(37)&"|"&Dvbbs.MyUserInfo(38)) 'Call UpdateUserTools(Dvbbs.UserID,ToolsInfo(4),1) ElseIf Action = 6 and GetPostType="1" and GetMoneyType=4 Then Call GetMoney_SaveRe End If End If succeed() End Sub '保存发贴，投票和回贴 Public Sub Savepost() If Action = 5 Or Action = 7 Then ilayer=1:iOrders=0:ParentID=0 If Myistop=3 Then MyLastPostTime=DateADD("d",300,Replace(Replace(CSTR(NOW()+Dvbbs.Forum_Setting(0)/24),"上午",""),"下午","")) ElseIf Myistop=1 Then MyLastPostTime=DateADD("d",100,Replace(Replace(CSTR(NOW()+Dvbbs.Forum_Setting(0)/24),"上午",""),"下午","")) Else MyLastPostTime=Replace(Replace(CSTR(NOW()+Dvbbs.Forum_Setting(0)/24),"上午",""),"下午","") End If DateTimeStr=Replace(Replace(CSTR(NOW()+Dvbbs.Forum_Setting(0)/24),"上午",""),"下午","") If Action = 7 Then Insert_To_Vote() Insert_To_Topic() '更新总固顶和固顶的数据以及缓存数据 If MyIsTop=3 Then '将总固顶ID插入总设置表 Dim iForum_AllTopNum Set Rs=Dvbbs.Execute("Select Forum_AllTopNum From Dv_Setup") If Trim(Rs(0))="" Or IsNull(Rs(0)) Then iForum_AllTopNum = RootID Else iForum_AllTopNum = Rs(0) & "," & RootID End If Dvbbs.Execute("Update Dv_Setup Set Forum_AllTopNum='"&iForum_AllTopNum&"'") Dvbbs.ReloadSetupCache iForum_AllTopNum,28 Set Rs=Nothing ElseIf MyIsTop=1 Then Dim BoardTopStr Set Rs=Dvbbs.Execute("Select BoardID,BoardTopStr From Dv_Board Where BoardID="&Clng(Dvbbs.BoardID)) If Not (Rs.Eof And Rs.Bof) Then If Rs(1)="" Or IsNull(Rs(1)) Then BoardTopStr = RootID Else If InStr(","&Rs(1)&",","," & RootID & ",")>0 Then BoardTopStr = Rs(1) Else BoardTopStr = Rs(1) & "," & RootID End If End If Dvbbs.Execute("Update Dv_Board Set BoardTopStr='"&BoardTopStr&"' Where BoardID="&Rs(0)) If Dvbbs.BoardNode.attributes.getNamedItem("toptopiccount").text="" Then Dvbbs.ReloadBoardCache Dvbbs.BoardID,1,"toptopiccount" Else Dvbbs.ReloadBoardCache Dvbbs.BoardID,1+CLng(Dvbbs.BoardNode.attributes.getNamedItem("toptopiccount").text),"toptopiccount" End If Dvbbs.ReloadBoardCache Dvbbs.BoardID,BoardTopStr,"boardtopstr" End If Set Rs=Nothing End If ElseIf Action = 6 Then Get_SaveRe_TopicInfo() Get_ForumTreeCode() DateTimeStr=Replace(Replace(CSTR(NOW()+Dvbbs.Forum_Setting(0)/24),"上午",""),"下午","") End If Insert_To_Announce() If Action = 6 Then topic=Replace(Replace(cutStr(topic,14),chr(10),""),"'","") If topic="" Then topic=Content topic=Replace(cutStr(topic,14),chr(10),"") Else topic=Replace(cutStr(topic,14),chr(10),"") End If If ihaveupfile=1 Then Dvbbs.Execute("update dv_upfile set F_AnnounceID='"&RootID&"|"&AnnounceID&"',F_Readme='"&Replace(toptopic,"'","")&"',F_flag=0 where F_ID in ("&upfileinfo&")") Else If ihaveupfile=1 Then Dvbbs.Execute("update dv_upfile set F_AnnounceID='"&RootID&"|"&AnnounceID&"',F_Readme='"&Topic&"',F_flag=0 where F_ID in ("&upfileinfo&")") End If LastPost=Replace(username,"$","") & "$" & AnnounceID & "$" & DateTimeStr & "$" & Replace(cutStr(topic,20),"$","$") & "$" & uploadpic_n & "$" & Dvbbs.UserID & "$" & RootID & "$" & Dvbbs.BoardID LastPost=reubbcode(Replace(LastPost,"'","")) LastPost=Dvbbs.ChkBadWords(LastPost) If IsAudit<>1 Then Dim IsUpDateLastPostTime IsUpDateLastPostTime = False If istop>0 Or InStr("," & Tools_UseTools & ",",",13,")>0 Or InStr("," & Tools_UseTools & ",",",14,")>0 Then IsUpDateLastPostTime = True If Action = 6 Then If istop=3 And IsUpDateLastPostTime Then If IsSqlDataBase=1 Then SQL="update Dv_topic set child=child+1,LastPostTime=dateadd(day,300,"&SqlNowString&"),LastPost='"&LastPost&"' where TopicID="&RootID Else SQL="update Dv_topic set child=child+1,LastPostTime=dateadd('d',300,"&SqlNowString&"),LastPost='"&LastPost&"' where TopicID="&RootID End If ElseIf istop=2 And IsUpDateLastPostTime Then If IsSqlDataBase=1 Then SQL="update Dv_topic set child=child+1,LastPostTime=dateadd(day,200,"&SqlNowString&"),LastPost='"&LastPost&"' where TopicID="&RootID Else SQL="update Dv_topic set child=child+1,LastPostTime=dateadd('d',200,"&SqlNowString&"),LastPost='"&LastPost&"' where TopicID="&RootID End If ElseIf istop=1 And IsUpDateLastPostTime Then If IsSqlDataBase=1 Then SQL="update Dv_topic set child=child+1,LastPostTime=dateadd(day,100,"&SqlNowString&"),LastPost='"&LastPost&"' where TopicID="&RootID Else SQL="update Dv_topic set child=child+1,LastPostTime=dateadd('d',100,"&SqlNowString&"),LastPost='"&LastPost&"' where TopicID="&RootID End If ElseIf IsUpDateLastPostTime Then If DateDiff("h",Now(),Tools_LastPostTime)<=0 Then SQL="update Dv_topic set child=child+1,LastPostTime="&SqlNowString&",LastPost='"&LastPost&"' where TopicID="&RootID Else SQL="update Dv_topic set child=child+1,LastPost='"&LastPost&"' where TopicID="&RootID End If Else SQL="update Dv_topic set child=child+1,LastPostTime="&SqlNowString&",LastPost='"&LastPost&"' where TopicID="&RootID End If Dvbbs.Execute(SQL) Child=Child+2 If Child mod Dvbbs.Board_Setting(27)=0 Then star=Child\Dvbbs.Board_Setting(27) Else star=(Child\Dvbbs.Board_Setting(27))+1 End If Else Dvbbs.Execute("update Dv_topic set LastPost='"&LastPost&"' where topicid="&RootID) End If Else Dvbbs.Execute("update Dv_topic set LastPost='"&LastPost&"' where topicid="&RootID) End If If Action = 5 Or Action = 7 Then toptopic=Replace(cutStr(topic,20),"$","$") Else toptopic=Replace(cutStr(toptopic,20),"$","$") End If 'toptopic =主标题,Content=内容 '判断是否是加密的论坛，如果是，则不显示最后发贴内容。 If Dvbbs.Board_Setting(2)="1" Then LastPost_1="保密$" & AnnounceID & "$" & DateTimeStr & "$请认证用户进入查看$" & uploadpic_n & "$" & Dvbbs.UserID & "$" & RootID & "$" & Dvbbs.BoardID Else LastPost_1=Replace(username,"$","") & "$" & AnnounceID & "$" & DateTimeStr & "$" & toptopic & "$" & uploadpic_n & "$" & Dvbbs.UserID & "$" & RootID & "$" & Dvbbs.BoardID End If LastPost_1=reubbcode(Replace(LastPost_1,"'","")) LastPost_1=Dvbbs.ChkBadWords(LastPost_1) If IsAudit=0 Then UpDate_BoardInfoAndCache() UpDate_ForumInfoAndCache() End If Response.Cookies("Dvbbs")=Dvbbs.BoardID End Sub '判断用户是否有编辑权限且提取相关信息 Public Function Get_Edit_PermissionInfo() Dim old_user If Action = 4 Then Set Rs=Dvbbs.Execute("select b.username,b.topic,b.body,b.dateandtime,u.UserGroupID,b.signflag,b.emailflag from "&TotalUseTable&" b,[dv_user] u where b.postuserid=u.userid and b.RootID="&AnnounceID&" and b.AnnounceID="&replyID) Else Set Rs=Dvbbs.Execute("select b.username,b.topic,b.body,b.dateandtime,u.UserGroupID,b.signflag,b.emailflag from "&TotalUseTable&" b,[dv_user] u where b.postuserid=u.userid and b.RootID="&RootID&" and b.AnnounceID="&AnnounceID) End If If Rs.Eof And Rs.Bof Then Dvbbs.AddErrCode(48) Else If Action = 4 Then signflag=Rs("signflag") mailflag=Rs("emailflag") Topic=rs("topic") If Topic<>"" Then Topic = Server.HtmlEncode(Topic) Content=rs("body") old_user=rs("username") Else If Clng(Dvbbs.forum_setting(50))>0 then If Datediff("s",rs("dateandtime"),Now())>Clng(Dvbbs.forum_setting(50))*60 then Content = Content+chr(13)+chr(10)+char_changed+chr(13) End If Else Content = Content+chr(13)+chr(10)+char_changed+chr(13) End If End If If Clng(Dvbbs.forum_setting(51))>0 and not (Dvbbs.master or Dvbbs.boardmaster or Dvbbs.superboardmaster) Then If DateDiff("s",rs("dateandtime"),Now())>Clng(Dvbbs.forum_setting(51))*60 then Response.redirect "showerr.asp?ErrCodes=
  • "&Replace(Replace(template.Strings(22),"{$posttime}",Datediff("s",rs("dateandtime"),Now())/60),"{$etlimited}",Dvbbs.forum_setting(51))&"&action=OtherErr" End If If Rs("username")=Dvbbs.membername Then If Dvbbs.GroupSetting(10)="0" then Dvbbs.AddErrCode(74) CanEditPost=False Else CanEditPost=True End If Else If (Dvbbs.master or Dvbbs.superboardmaster or Dvbbs.boardmaster) and Dvbbs.GroupSetting(23)="1" then CanEditPost=True Else CanEditPost=False End If If Cint(Dvbbs.UserGroupID) > 3 And Dvbbs.GroupSetting(23)="1" Then CanEditPost=true If Dvbbs.GroupSetting(23)="1" and Dvbbs.founduserPer Then CanEditPost=True ElseIf Dvbbs.GroupSetting(23)="0" And Dvbbs.founduserPer Then CanEditPost=False End If If Cint(Dvbbs.UserGroupID) < 4 And Cint(Dvbbs.UserGroupID) = rs("UserGroupID") Then Dvbbs.AddErrCode(75) ElseIf Cint(Dvbbs.UserGroupID) < 4 and Cint(Dvbbs.UserGroupID) > rs("UserGroupID") Then Dvbbs.AddErrCode(76) End If If Not CanEditPost Then Dvbbs.AddErrCode(77) End If End If Set Rs=Nothing Dvbbs.ShowErr() If Action = 4 Then Dvbbs.MemberName=old_user End Function Public Sub Get_SaveRe_TopicInfo() SQL="select locktopic,LastPost,title,smsuserlist,IsSmsTopic,istop,Child,UseTools,LastPostTime,GetMoneyType,PostUserID, DateAndTime from Dv_topic where BoardID="&Dvbbs.BoardID&" And topicid="&cstr(RootID) Set Rs=dvbbs.Execute(sql) If Not (Rs.EOF And Rs.BOF) Then toptopic = Rs(2) istop = Rs(5) Child = Rs(6) Tools_UseTools = "," & Rs(7) & "," Tools_LastPostTime = Rs(8) If Rs("IsSmsTopic")=1 Then smsuserlist=Rs("smsuserlist") If Rs("LockTopic")=1 And Not (Dvbbs.Master Or Dvbbs.BoardMaster Or Dvbbs.SuperBoardMaster) Then Dvbbs.AddErrCode(78) '锁定多少天前的帖子判断 2004-9-16 Dv.Yz If Ubound(Dvbbs.Board_Setting) > 70 And Not (Dvbbs.Master Or Dvbbs.BoardMaster Or Dvbbs.SuperBoardMaster) Then If Not Clng(Dvbbs.Board_Setting(71)) = 0 And Datediff("d", Rs(11), Now()) > Clng(Dvbbs.Board_Setting(71)) Then Dvbbs.AddErrCode(78) End If If Not IsNull(Rs(1)) Then LastPost=split(Rs(1),"$") If ubound(LastPost)=7 Then UpLoadPic_n=LastPost(4) Else UpLoadPic_n="" End If End If If Cint(Rs(9)) = 5 Then Response.redirect "showerr.asp?ErrCodes=
    "+"
  • "&template.Strings(32)&"&action=OtherErr" Exit Sub End If If Clng(Rs(10)) <> Dvbbs.UserID and Cint(Rs(9)) = 2 and GetPostType = "1" Then GetMoneyType = 4 Dvbbs.MyUserInfo(37) = Dvbbs.MyUserInfo(37)-ToMoney Else GetMoneyType = 0 ToMoney=0 End If End If Set Rs = Nothing Dvbbs.showErr() End Sub Public Sub Insert_To_Vote() '插入投票记录 GroupSetting(68)投票项目中是否可以使用HTML Dim UArticle,UWealth,UEP,UCP,UPower UArticle = Request("UArticle") UWealth = Request("UWealth") UEP = Request("UEP") UCP = Request("UCP") UPower = Request("UPower") If Not IsNumeric(UArticle) Then UArticle = 0 If Not IsNumeric(UWealth) Then UWealth = 0 If Not IsNumeric(UEP) Then UEP = 0 If Not IsNumeric(UCP) Then UArticle = 0 If Not IsNumeric(UPower) Then UPower = 0 If Dvbbs.GroupSetting(68)<>"1" Then vote = server.htmlencode(vote) Dvbbs.execute("insert into dv_vote (vote,votenum,votetype,timeout,UArticle,UWealth,UEP,UCP,UPower) values ('"&vote&"','"&votenum&"',"&votetype&",'"&votetimeout&"',"&UArticle&","&UWealth&","&UEP&","&UCP&","&UPower&")") set rs=dvbbs.execute("select Max(voteid) from dv_vote") voteid=Rs(0) isvote=1 Set Rs=Nothing End Sub Public Sub Insert_To_Topic() '插入主题表 SQL="insert into Dv_topic (Title,Boardid,PostUsername,PostUserid,DateAndTime,Expression,LastPost,LastPostTime,PostTable,locktopic,istop,TopicMode,isvote,PollID,Mode,GetMoney,UseTools,GetMoneyType) values ('"&topic&"',"&Dvbbs.boardid&",'"&username&"',"&Dvbbs.userid&",'"&DateTimeStr&"','"&Expression(0)&"|"&Expression(1)&"','$$"&DateTimeStr&"$$$$','"&MyLastPostTime&"','"&TotalUseTable&"',"&locktopic&","&Myistop&","&MyTopicMode&","&isvote&","&voteid&","&TopicMode&","&ToMoney&",'"&UseTools&"',"&GetMoneyType&")" Dvbbs.Execute(sql) Set Rs=Dvbbs.Execute("select Max(topicid) From Dv_topic Where PostUserid="&Dvbbs.UserID) RootID=Rs(0) End Sub Public Sub Insert_To_Announce() '插入回复表 DIM UbblistBody UbblistBody = Content Content = Html2Ubb(Content) UbblistBody = Ubblist(Content) SQL="insert into "&TotalUseTable&"(Boardid,ParentID,username,topic,body,DateAndTime,length,RootID,layer,orders,ip,Expression,locktopic,signflag,emailflag,isbest,PostUserID,isupload,IsAudit,Ubblist,GetMoney,UseTools,PostBuyUser,GetMoneyType) values ("&Dvbbs.boardid&","&ParentID&",'"&username&"','"&topic&"','"&Content&"','"&DateTimeStr&"','"&Dvbbs.strlength(Content)&"',"&RootID&","&ilayer&","&iorders&",'"&Dvbbs.UserTrueIP&"','"&Expression(1)&"',"&locktopic&","&signflag&","&mailflag&",0,"&Dvbbs.userid&","&ihaveupfile&","&IsAudit&",'"&UbblistBody&"',"&ToMoney&",'"&UseTools&"','"&ToolsBuyUser&"',"&GetMoneyType&")" Dvbbs.Execute(sql) Set Rs=Dvbbs.Execute("select Max(AnnounceID) From "&TotalUseTable&" Where PostUserID="&Dvbbs.UserID) AnnounceID=Rs(0) End Sub '检查贴中是否含过滤字 Public Function NeedIsAudit() NeedIsAudit=0 Dim i,ChecKData If Dvbbs.Board_Setting(58)<>"0" Then ChecKData=split(Dvbbs.Board_Setting(58),"|") For i=0 to UBound(ChecKData) If Trim(ChecKData(i))<>"" Then If InStr(Content,ChecKData(i))>0 Or InStr(Topic,ChecKData(i))>0 Then NeedIsAudit=1 Exit Function End If End If Next End If End Function Public Sub Get_ForumTreeCode() Dim mailbody Set Rs=Dvbbs.Execute("select b.layer,b.orders,b.EmailFlag,b.username,u.userEmail from "&TotalUseTable&" b inner join [Dv_user] u on b.postuserid=u.userid where b.AnnounceID="&ParentID) If Not(rs.EOF And rs.BOF) Then If IsNull(Rs(0)) Then iLayer=1 Else iLayer=Rs(0) End If If IsNull(Rs(1)) Then iOrders=0 Else iOrders=Rs(1) End If If Rs(3)=Dvbbs.membername Then If Cint(Dvbbs.GroupSetting(4))=0 Then Dvbbs.AddErrCode(73) Else If Rs(2)>0 Then Dim sUrl,Email,TempArray,etopic TempArray = Split(template.html(10),"||") sUrl=Dvbbs.Get_ScriptNameUrl If Rs(2)=1 Or Rs(2)=3 Then etopic=Replace(template.Strings(25),"{$forumname}",Dvbbs.Forum_info(0)) email=Rs(4) mailbody = TempArray(0) mailbody = Replace(mailbody,"{$boardid}",Dvbbs.BoardID) mailbody = Replace(mailbody,"{$forumname}",Dvbbs.Forum_info(0)) mailbody = Replace(mailbody,"{$topicid}",RootID) mailbody = Replace(mailbody,"{$star}",Star) mailbody = Replace(mailbody,"{$surl}",sUrl) mailbody = Replace(mailbody,"{$parentid}",ParentID) Dim DvEmail Set DvEmail = New Dv_SendMail DvEmail.SendObject = Cint(Dvbbs.Forum_Setting(2)) '设置选取组件 1=Jmail,2=Cdonts,3=Aspemail DvEmail.ServerLoginName = Dvbbs.Forum_info(12) '您的邮件服务器登录名 DvEmail.ServerLoginPass = Dvbbs.Forum_info(13) '登录密码 DvEmail.SendSMTP = Dvbbs.Forum_info(4) 'SMTP地址 DvEmail.SendFromEmail = Dvbbs.Forum_info(5) '发送来源地址 DvEmail.SendFromName = Dvbbs.Forum_info(0) '发送人信息 If DvEmail.ErrCode = 0 Then DvEmail.SendMail email,etopic,mailbody '执行发送邮件 End If Set DvEmail = Nothing End If If Rs(2)=2 Or Rs(2)=3 Then mailbody = TempArray(1) mailbody = Replace(mailbody,"{$boardid}",Dvbbs.BoardID) mailbody = Replace(mailbody,"{$topicid}",RootID) mailbody = Replace(mailbody,"{$star}",Star) mailbody = Replace(mailbody,"{$surl}",sUrl) mailbody = Replace(mailbody,"{$parentid}",ParentID) Dvbbs.Execute("insert into dv_message(incept,sender,title,content,sendtime,flag,issend) values('"&Rs(3)&"','"&Dvbbs.Forum_info(0)&"','"&template.Strings(26)&"','"&mailbody&"',"&SqlNowString&",0,1)") update_user_msg(Rs(3)) End If End If End If Else iLayer=1 iOrders=0 End If Set Rs=Nothing If RootID<>0 Then iLayer=ilayer+1 Dvbbs.Execute "update "&TotalUseTable&" set orders=orders+1 where RootID="&cstr(RootID)&" and orders>"&cstr(iOrders) iOrders=iOrders+1 End If End Sub Public Sub Update_Edit_Announce() Dim re,LastBoard,LastTopic Set re=new RegExp re.IgnoreCase =True re.Global=True re.Pattern="
    " Content = re.Replace(Content,"[br]") re.Pattern="\[align=right\]\[color=#000066\](.*)\[\/color\]\[\/align\]" Content = re.Replace(Content,"") re.Pattern="
    (.*)<\/font><\/div>" Content = re.Replace(Content,"") re.Pattern="\[br\]" Content = re.Replace(Content,"
    ") Set re=Nothing If Dvbbs.membername<>UserName Then If Dvbbs.forum_setting(49)="1" Then char_changed = "[align=right][color=#000066][此贴子已经被"&Dvbbs.membername&"于"&Now()&"编辑过][/color][/align]" Else If Dvbbs.forum_setting(48)="1" Then char_changed = "[align=right][color=#000066][此贴子已经被作者于"&Now()&"编辑过][/color][/align]" End If Get_Edit_PermissionInfo Dim Contentdata Contentdata=Content Dvbbs.ShowErr '取出当前版面最后回复id,如果本帖为最后回复则更新相应数据 Set Rs = Dvbbs.Execute("select LastPost from dv_board where boardid="&Dvbbs.BoardID) If not (Rs.EOF And Rs.BOF) Then If Not IsNull(rs(0)) And rs(0)<>"" then LastBoard=split(rs(0),"$") If ubound(LastBoard)=7 Then If cCur(LastBoard(6))=cCur(AnnounceID) Then LastPost=LastBoard(0) & "$" & LastBoard(1) & "$" & Now() & "$" & Replace(cutStr(reubbcode(topic),20),"$","$") & "$" & LastBoard(4) & "$" & LastBoard(5) & "$" & LastBoard(6) & "$" & Dvbbs.BoardID dvbbs.execute("update dv_board set LastPost='"&Replace(LastPost,"'","")&"' where boardid="&Dvbbs.BoardID) End If End If End If End If '取得当前主题最后回复id,如果本帖为最后回复则更新相应数据 Dim iFoundUseMagic,MyMagicFace Set Rs=Dvbbs.Execute("select LastPost,istop,Expression from dv_topic where topicid="&rootid) If Not (Rs.Eof And Rs.Bof) Then istop=rs(1) MyMagicFace = Split(Rs(2),"|") If Ubound(MyMagicFace) = 1 Then iFoundUseMagic = MyMagicFace(0) If Not Isnull(Rs(0)) And Rs(0)<>"" Then LastTopic=split(rs(0),"$") If Ubound(LastTopic)=7 Then If cCur(LastTopic(1))=cCur(Announceid) Then LastPost=LastTopic(0) & "$" & LastTopic(1) & "$" & Now() & "$" & Replace(cutStr(reubbcode(Contentdata),20),"$","$") & "$" & LastTopic(4) & "$" & LastTopic(5) & "$" & LastTopic(6) & "$" & Dvbbs.BoardID dvbbs.execute("update dv_topic set LastPost='"&Replace(LastPost,"'","")&"' where topicid="&rootid) End If End If End If End If Set Rs = Server.CreateObject("ADODB.Recordset") SQL="SELECT * FROM "&TotalUseTable&" where AnnounceID="&Announceid&" And username='"&username&"'" rs.Open SQL,conn,1,3 If Rs.EOF And Rs.BOF Then If Not CanEditPost Then Dvbbs.AddErrCode(77) ElseIf Not Dvbbs.master And rs("locktopic")=1 then Dvbbs.AddErrCode(78) Else If Rs("parentid")=0 then Dim iExpression iExpression = ",Expression='"&Expression(0)&"|"&Expression(1)&"'" If istop=1 Then If IsSqlDataBase=1 Then Dvbbs.Execute("update dv_topic set title='"&topic&"',LastPostTime=dateadd(day,100,"&SqlNowString&"),TopicMode="&MyTopicMode&" "&iExpression&" where topicid="&rootid) Else Dvbbs.Execute("update dv_topic set title='"&topic&"',LastPostTime=dateadd('d',100,"&SqlNowString&"),TopicMode="&MyTopicMode&" "&iExpression&" where topicid="&rootid) End If ElseIf istop=3 Then If IsSqlDataBase=1 Then Dvbbs.Execute("update dv_topic set title='"&topic&"',LastPostTime=dateadd(day,300,"&SqlNowString&"),TopicMode="&MyTopicMode&" "&iExpression&" where topicid="&rootid) Else Dvbbs.Execute("update dv_topic set title='"&topic&"',LastPostTime=dateadd('d',300,"&SqlNowString&"),TopicMode="&MyTopicMode&" "&iExpression&" where topicid="&rootid) End If Else Dvbbs.Execute("update dv_topic set title='"&topic&"',TopicMode="&MyTopicMode&" "&iExpression&" where topicid="&rootid) End If End If Content = Html2Ubb(Content) Rs("Topic") =Replace(Topic,"''","'") rs("Body") =Replace(Content,"''","'") rs("length")=Dvbbs.strlength(Content) rs("ip")=Dvbbs.UserTrueIP rs("Expression")=Expression(1) rs("signflag")=signflag rs("emailflag")=mailflag If Rs("isupload")=0 And ihaveupfile=1 Then Rs("isupload")=1 Dim UbblistBody UbblistBody = Ubblist(Content) Rs("Ubblist")=UbblistBody rs.Update If ihaveupfile=1 Then dvbbs.execute("update dv_upfile set F_AnnounceID='"&rootid&"|"&AnnounceID&"',F_Readme='"&Replace(Rs("Topic"),"'","''")&"',F_flag=0 where F_ID in ("&upfileinfo&")") If FoundUseMagic Then If iMagicFace <> Clng(iFoundUseMagic) Then If cCur(Dvbbs.MyUserInfo(37)) > tMagicMoney Then Dvbbs.Execute("Update Dv_User Set UserMoney=UserMoney-"&tMagicMoney&" Where UserID="&Dvbbs.UserID) Dvbbs.MyUserInfo(37)=Dvbbs.MyUserInfo(37)-tMagicMoney Dvbbs.ToolsLog -88,1,tMagicMoney,0,1,"使用金币购买魔法表情",Dvbbs.MyUserInfo(37) & "|" & Dvbbs.MyUserInfo(38) Else Dvbbs.Execute("Update Dv_User Set UserTicket=UserTicket-"&tMagicTicket&" Where UserID="&Dvbbs.UserID) Dvbbs.MyUserInfo(38)=Dvbbs.MyUserInfo(38)-tMagicTicket Dvbbs.ToolsLog -88,1,0,tMagicTicket,1,"使用点券购买魔法表情",Dvbbs.MyUserInfo(37) & "|" & Dvbbs.MyUserInfo(38) End If End If End If End If Rs.Close Set Rs=Nothing Dvbbs.ShowErr() End Sub '更新版面数据和缓存 Public Sub UpDate_BoardInfoAndCache() Dim UpdateBoardID If Dvbbs.BoardNode.attributes.getNamedItem("parentstr").text<> "0" Then UpdateBoardID=Dvbbs.BoardNode.attributes.getNamedItem("parentstr").text & "," & Dvbbs.BoardID Else UpdateBoardID=Dvbbs.BoardID End If Dim updateboard,i If Action = 6 Then SQL="update Dv_board set PostNum=PostNum+1,todaynum=todaynum+1,LastPost='"&SimEncodeJS(LastPost_1)&"' where boardid in ("&UpdateBoardID&")" ElseIf Action = 5 Or Action = 7 Then SQL="update Dv_board set PostNum=PostNum+1,TopicNum=TopicNum+1,todaynum=todaynum+1,LastPost='"&SimEncodeJS(LastPost_1)&"' where boardid in ("&UpdateBoardID&")" End If Dvbbs.Execute(sql) Dvbbs.ReloadBoardInfo UpdateBoardID End Sub Public Sub UpDate_ForumInfoAndCache() Dim updateinfo,LastPostTime Dim Forum_LastPost,Forum_TodayNum,Forum_MaxPostNum Forum_LastPost=Dvbbs.CacheData(15,0) Forum_TodayNum=Dvbbs.CacheData(9,0) Forum_MaxPostNum=Dvbbs.CacheData(12,0) LastPostTimes=split(Forum_LastPost,"$") LastPostTime=LastPostTimes(2) If Not IsDate(LastPostTime) Then LastPostTime=Now() If datediff("d",LastPostTime,Now())=0 Then If CLng(Forum_TodayNum)+1 > CLng(Forum_MaxPostNum) Then updateinfo=",Forum_MaxPostNum=Forum_TodayNum+1,Forum_MaxPostDate="&SqlNowString&"" Dvbbs.ReloadSetupCache Now(),13 Dvbbs.ReloadSetupCache CLng(Forum_TodayNum)+1,12 End If Dvbbs.ReloadSetupCache CLng(Forum_TodayNum)+1,9 If Action = 6 Then SQL="update Dv_setup set Forum_PostNum=Forum_PostNum+1,Forum_TodayNum=Forum_TodayNum+1,Forum_LastPost='"&LastPost&"' "&updateinfo&" " Else SQL="update Dv_setup set Forum_TopicNum=Forum_TopicNum+1,Forum_PostNum=Forum_PostNum+1,Forum_TodayNum=Forum_TodayNum+1,Forum_LastPost='"&LastPost&"' "&updateinfo&" " End If Else If Action = 6 Then SQL="update Dv_setup set Forum_PostNum=Forum_PostNum+1,forum_YesTerdayNum="&CLng(Forum_TodayNum)&",Forum_TodayNum=1,Forum_LastPost='"&LastPost&"' " Else SQL="update Dv_setup set Forum_TopicNum=Forum_TopicNum+1,Forum_PostNum=Forum_PostNum+1,forum_YesTerdayNum="&CLng(Forum_TodayNum)&",Forum_TodayNum=1,Forum_LastPost='"&LastPost&"' " End If Dvbbs.ReloadSetupCache 1,9 End If '更新总固顶部分数据和缓存 If Not Action = 6 Then If Myistop=2 Then Dim tmpstr If Dvbbs.CacheData(28,0)="" Then tmpstr=", Forum_alltopnum='"&RootID&"'" Dvbbs.ReloadSetupCache RootID,28 Else tmpstr=", Forum_alltopnum='"&Dvbbs.CacheData(28,0)&","&RootID&"'" Dvbbs.ReloadSetupCache Dvbbs.CacheData(28,0)&","&RootID,28 End If SQL=SQl&tmpstr End If Dvbbs.ReloadSetupCache CLng(Dvbbs.CacheData(7,0))+1,7'主题数 End If Dvbbs.ReloadSetupCache CLng(Dvbbs.CacheData(8,0))+1,8'文章数 Dvbbs.ReloadSetupCache LastPost,15 Dvbbs.Execute(SQL) End Sub Public Sub succeed() Dim TempStr,PostRetrunName,tourl,returnurl If IsAudit=1 And Action <> 8 Then Dvbbs.BoardID=LockTopic Dvbbs.Stats = Dvbbs.Stats & template.Strings(20) TempStr = template.html(8) Select case Dvbbs.Board_Setting(17) case "1" tourl = "index.asp" PostRetrunName=template.Strings(13) case "2" tourl="index.asp?boardid="&Dvbbs.boardid PostRetrunName=template.Strings(14) case "3" If IsAudit=1 And Action <> 8 Then tourl="index.asp?boardid="&Dvbbs.boardid If IsAuditcheck=1 Then PostRetrunName="由于您发表的贴子含敏感内容，您的贴子需要管理员审核过才可以见到。" Else PostRetrunName=template.Strings(19) End If Else Select Case Action Case 5 tourl="dispbbs.asp?boardid="&Dvbbs.boardid&"&id="&RootID PostRetrunName=template.Strings(15) Case 6 tourl="dispbbs.asp?boardid="&Dvbbs.boardid&"&id="&RootID&"&star="&Star&"#"&Announceid PostRetrunName=template.Strings(16) Case 7 tourl="dispbbs.asp?boardid="&Dvbbs.boardid&"&id="&RootID PostRetrunName=template.Strings(17) Case 8 tourl="dispbbs.asp?boardid="&Dvbbs.boardid&"&id="&RootID&"&star="&Star&"#"&RootID PostRetrunName=template.Strings(18) End Select End If End Select returnurl="dispbbs.asp?boardid="&Dvbbs.boardid&"&id="&RootID TempStr = Replace(TempStr,"{$tourl}",tourl) TempStr = Replace(TempStr,"{$returnurl}",returnurl) TempStr = Replace(TempStr,"{$stats}",Dvbbs.Stats) TempStr = Replace(TempStr,"{$boardname}",Dvbbs.BoardType) TempStr = Replace(TempStr,"{$boardid}",Dvbbs.BoardID) TempStr = Replace(TempStr,"{$page}",page) TempStr = Replace(TempStr,"{$PostRetrunName}",PostRetrunName) Response.Write TempStr End Sub Private Function checktable(Table) Table=Right(Trim(Table),2) If Not IsNumeric(table) Then Table=Right(Trim(Table),1) If Not IsNumeric(table) Then Dvbbs.AddErrCode(30) checktable="Dv_bbs"&table End Function '检查提交来源 Public Sub CheckfromScript() If Not Dvbbs.ChkPost() Then Dvbbs.AddErrCode(16):Dvbbs.Showerr() If Not(IsArray(Session(Dvbbs.CacheName & "UserID"))) or Dvbbs.UserID = 0 Then Dvbbs.AddErrCode(42):Dvbbs.Showerr() If CStr(Request.Cookies("Dvbbs"))=CStr(Dvbbs.Boardid) Then Dvbbs.AddErrCode(30):Dvbbs.Showerr() If (Not ChkUserLogin) And (Action = 5 Or Action = 6 Or Action = 7) Then Dvbbs.AddErrCode(12):Dvbbs.Showerr() End Sub '判断发贴时间间隔 Private Sub CheckpostTime() If Dvbbs.Board_Setting(30)="1" Then Dim mypostinfo mypostinfo=Session(Dvbbs.CacheName & "UserID") If DateDiff("s",mypostinfo(2),Now())"+"
  • "&template.Strings(33)&"&action=OtherErr" End If End If End Sub '检查用户身份 Public Function ChkUserLogin() ChkUserLogin=False '取得发贴用户名和密码 UserName=Dvbbs.Checkstr(Request.Form("username")) '校验用户名和密码是否合法 'If UserName="" Or Dvbbs.strLength(userName)>Cint(Dvbbs.Forum_setting(41)) Or Dvbbs.strLength(userName) < Cint(Dvbbs.Forum_setting(40)) Then Dvbbs.AddErrCode(17) If UserName="" Then Dvbbs.AddErrCode(17) If Not IstrueName(UserName) Then Dvbbs.AddErrCode(18) Dvbbs.ShowErr() If Action = 8 Then '编辑贴子，检查用户身份 UserPassWord=Dvbbs.checkStr(Trim(Request.Cookies(Dvbbs.Forum_sn)("password"))) SQL = "Select JoinDate,UserID,UserPost,UserGroupID,userclass,lockuser,TruePassWord From [Dv_User] Where UserID="&Dvbbs.UserID Else '检查用户是否当前用户 If UserName<>Dvbbs.MemberName Then Reuser=True UserPassWord=Dvbbs.Checkstr(Trim(Request.Form("passwd"))) UserPassWord=md5(UserPassWord,16) SQL = "Select JoinDate,UserID,UserPost,UserGroupID,userclass,lockuser,userpassword From [Dv_User] Where UserName='"&UserName&"' " Else UserPassWord=Dvbbs.checkStr(Trim(Request.Cookies(Dvbbs.Forum_sn)("password"))) SQL = "Select JoinDate,UserID,UserPost,UserGroupID,userclass,lockuser,TruePassWord From [Dv_User] Where UserID="&Dvbbs.UserID End If End If If Len(UserPassWord)<>16 AND Len(UserPassWord)<>32 Then Dvbbs.AddErrCode(18) Set Rs=Dvbbs.Execute(SQL) If Not Rs.EOF Then If Not (UserPassWord<>rs(6) Or rs(5)=1 or rs(3)=5) Then '不允许使用马甲 If Dvbbs.UserID<>Rs(1) Then ChkUserLogin = False Else Dvbbs.UserID=Rs(1) UserPost=Rs(2) GroupID=Rs(3) userclass=Rs(4) ChkUserLogin=True End If Response.cookies("upNum")=0 Else Dvbbs.EmptyCookies Dvbbs.LetGuestSession() End If End If Set Rs = Nothing End Function '更新用户积分，所需外部变量,UserPost,userid,（外加发贴回贴的积分设置数据） Public Sub updatepostuser() '投票，发贴，更新积分 'Dvbbs.MyUserInfo = Session(Dvbbs.CacheName & "UserID") '更新最后发贴时间 Dvbbs.MyUserInfo(2) = Now Dim MagicSql If Action = 5 Or Action = 7 Then If FoundUseMagic Then If cCur(Dvbbs.MyUserInfo(37)) > tMagicMoney Then Dvbbs.MyUserInfo(37)=Dvbbs.MyUserInfo(37)-tMagicMoney Dvbbs.ToolsLog -88,1,tMagicMoney,0,1,"使用金币购买魔法表情",Dvbbs.MyUserInfo(37) & "|" & Dvbbs.MyUserInfo(38) Else MagicSql = ",UserTicket=UserTicket-"&tMagicTicket&"" Dvbbs.MyUserInfo(38)=Dvbbs.MyUserInfo(38)-tMagicTicket Dvbbs.ToolsLog -88,1,0,tMagicTicket,1,"使用点券购买魔法表情",Dvbbs.MyUserInfo(37) & "|" & Dvbbs.MyUserInfo(38) End If End If Dvbbs.Execute("update [Dv_user] set UserLastIP='"&Dvbbs.usertrueip&"',UserPost=UserPost+1,UserTopic=UserTopic+1,userWealth=userWealth+"&Clng(Dvbbs.Forum_user(1))&",userEP=userEP+"&Clng(Dvbbs.Forum_user(6))&",userCP=userCP+"&Clng(Dvbbs.Forum_user(11))&",UserToday='"&Clng(Dvbbs.UserToday(0))+1&"|"&Clng(Dvbbs.UserToday(1))&"|"&Clng(Dvbbs.UserToday(2))&"|"&Clng(Dvbbs.UserToday(3))&"|"&Clng(Dvbbs.UserToday(4))&"',UserMoney="&Dvbbs.MyUserInfo(37)&" "&MagicSql&" Where UserID="&Dvbbs.userID) If Not Reuser Then UserPost=UserPost+1 Dvbbs.MyUserInfo(21)=Dvbbs.MyUserInfo(21)+Clng(Dvbbs.Forum_user(1)) Dvbbs.MyUserInfo(22)=Dvbbs.MyUserInfo(22)+Clng(Dvbbs.Forum_user(6)) Dvbbs.MyUserInfo(23)=Dvbbs.MyUserInfo(23)+Clng(Dvbbs.Forum_user(11)) End If ElseIf Action = 6 Then '回贴更新积分。 If Not Reuser Then Dvbbs.Execute("update [Dv_user] set UserLastIP='"&Dvbbs.usertrueip&"',UserPost=UserPost+1,userWealth=userWealth+"&Clng(Dvbbs.Forum_user(2))&",userEP=userEP+"&Clng(Dvbbs.Forum_user(7))&",userCP=userCP+"&Clng(Dvbbs.Forum_user(12))&",UserToday='"&Clng(Dvbbs.UserToday(0))+1&"|"&Clng(Dvbbs.UserToday(1))&"|"&Clng(Dvbbs.UserToday(2))&"|"&Clng(Dvbbs.UserToday(3))&"|"&Clng(Dvbbs.UserToday(4))&"',UserMoney="&Dvbbs.MyUserInfo(37)&" Where UserID="&Dvbbs.userID) UserPost=UserPost+1 Dvbbs.MyUserInfo(21)=Dvbbs.MyUserInfo(21)+Clng(Dvbbs.Forum_user(2)) Dvbbs.MyUserInfo(22)=Dvbbs.MyUserInfo(22)+Clng(Dvbbs.Forum_user(7)) Dvbbs.MyUserInfo(23)=Dvbbs.MyUserInfo(23)+Clng(Dvbbs.Forum_user(12)) Else Dvbbs.Execute("update [Dv_user] set UserLastIP='"&Dvbbs.usertrueip&"',UserPost=UserPost+1,userWealth=userWealth+"&Clng(Dvbbs.Forum_user(2))&",userEP=userEP+"&Clng(Dvbbs.Forum_user(7))&",userCP=userCP+"&Clng(Dvbbs.Forum_user(12))&",UserMoney="&Dvbbs.MyUserInfo(37)&" Where UserID="&Dvbbs.userID) End If End If If Not Reuser Then Dvbbs.MyUserInfo(8)=UserPost+1 Dvbbs.MyUserInfo(36)=Clng(Dvbbs.UserToday(0))+1 & "|" & Clng(Dvbbs.UserToday(1)) & "|" & Clng(Dvbbs.UserToday(2))&"|"&Clng(Dvbbs.UserToday(3))&"|"&Clng(Dvbbs.UserToday(4)) End If '发贴数字能整除十则更新用户等级。(Updategrade()) If UserPost mod 10 < 1 Then Updategrade() 'Session(Dvbbs.CacheName & "UserID") = Dvbbs.MyUserInfo End Sub '更新用户等级，所需外部变量,UserPost,GroupID,userid Public Sub Updategrade() Dim FoundGrade,TitlePic REM 判断用户组(等级)资料，当用户级别为跟随文章数增长则自动更新用户组(等级) REM 自动更新用户数据 REM 如果属于系统或特殊或多属性组 Set Rs=Dvbbs.Execute("Select MinArticle,IsSetting,ParentGID,UserTitle,GroupPic From Dv_UserGroups Where UserGroupID="&GroupID) If Not (Rs.Eof And Rs.Bof) Then If Rs(2)<>3 Then '用户等级不按照文章升级，用户为系统或特殊或多属性组 UserClass=Rs(3) TitlePic=Rs(4) FoundGrade=True End If End If If Not FoundGrade Then '如果不属于系统或特殊或多属性组,则将该用户属于注册用户组且按照其文章数自动更新其用户组(等级) Set Rs=Dvbbs.Execute("Select Top 1 usertitle,GroupPic,UserGroupID From Dv_UserGroups Where ParentGID=3 And Minarticle<="&UserPost&" Order By MinArticle Desc,UserGroupID") If Not (Rs.Eof And Rs.Bof) Then UserClass=Rs(0) TitlePic=Rs(1) GroupID=Rs(2) FoundGrade=True End If End If Set Rs=Nothing If Not FoundGrade Then Response.Redirect "showerr.asp?ErrCodes=
  • 系统没有找到您的注册用户组资料，请联系管理员进行修正。&action=OtherErr" Dvbbs.Execute("Update [Dv_User] Set UserClass='"&UserClass&"',TitlePic='"&TitlePic&"',UserGroupID="&GroupID&" Where UserID="&Dvbbs.UserID) 'If Not Reuser Then Dvbbs.MyUserInfo(18) = UserClass Dvbbs.MyUserInfo(19) = GroupID 'Session(Dvbbs.CacheName & "UserID") = Dvbbs.MyUserInfo 'End If End Sub End Class '截取指定字符 Function cutStr(str,strlen) '去掉所有HTML标记 Dim re Set re=new RegExp re.IgnoreCase =True re.Global=True re.Pattern="<(.[^>]*)>" str=re.Replace(str,"") set re=Nothing Dim l,t,c,i l=Len(str) t=0 For i=1 to l c=Abs(Asc(Mid(str,i,1))) If c>255 Then t=t+2 Else t=t+1 End If If t>=strlen Then cutStr=left(str,i)&"..." Exit For Else cutStr=str End If Next cutStr=Replace(cutStr,chr(10),"") cutStr=Replace(cutStr,chr(13),"") End Function '过滤不必要UBB Function reUBBCode(strContent) Dim re Set re=new RegExp re.IgnoreCase =True re.Global=True strContent=Replace(strContent," "," ") re.Pattern="(\[QUOTE\])(.|\n)*(\[\/QUOTE\])" strContent=re.Replace(strContent,"") re.Pattern="(\[point=*([0-9]*)\])(.|\n)*(\[\/point\])" strContent=re.Replace(strContent," ") re.Pattern="(\[post=*([0-9]*)\])(.|\n)*(\[\/post\])" strContent=re.Replace(strContent," ") re.Pattern="(\[power=*([0-9]*)\])(.|\n)*(\[\/power\])" strContent=re.Replace(strContent," ") re.Pattern="(\[usercp=*([0-9]*)\])(.|\n)*(\[\/usercp\])" strContent=re.Replace(strContent," ") re.Pattern="(\[money=*([0-9]*)\])(.|\n)*(\[\/money\])" strContent=re.Replace(strContent," ") re.Pattern="(\[replyview\])(.|\n)*(\[\/replyview\])" strContent=re.Replace(strContent," ") re.Pattern="(\[usemoney=*([0-9]*)\])(.|\n)*(\[\/usemoney\])" strContent=re.Replace(strContent," ") strContent=Replace(strContent,"","") set re=Nothing strContent=Replace(strContent,Chr(10),"") strContent=Replace(strContent,Chr(13),"") strContent=replace(strContent, ">", ">") strContent=replace(strContent, "<", "<") strContent=Replace(strContent, CHR(32), " ") strContent=Replace(strContent, CHR(9), " ") strContent=Replace(strContent, CHR(34), """) reUBBCode=strContent End Function '通用函数 Function IstrueName(uName) IstrueName=False If InStr(uName,"=")>0 Then Exit Function If InStr(uName,"%")>0 Then Exit Function If InStr(uName,Chr(32))>0 Then Exit Function If InStr(uName,"?")>0 Then Exit Function If InStr(uName,"&")>0 Then Exit Function If InStr(uName,";")>0 Then Exit Function If InStr(uName,",")>0 Then Exit Function If InStr(uName,"'")>0 Then Exit Function If InStr(uName,Chr(34))>0 Then Exit Function If InStr(uName,chr(9))>0 Then Exit Function If InStr(uName,"")>0 Then Exit Function If InStr(uName,"$")>0 Then Exit Function IstrueName=True End Function Function SimEncodeJS(str) If Not IsNull(str) Then str = Replace(str, "\", "\\") str = Replace(str, chr(34), "\""") str = Replace(str, chr(39), "\'") str = Replace(str, chr(10), "\n") str = Replace(str, chr(13), "\r") SimEncodeJS=str End If End Function '发贴时用，为了减少入库量 Function Html2Ubb(str) If Str<>"" And Not IsNull(Str) Then Dim re,tmpstr Set re=new RegExp re.IgnoreCase =True re.Global=True 're.Pattern = "(
    )" 'Str = re.Replace(Str,"[br]") 'If Dvbbs.Board_Setting(5)="0" Then '先去掉标记中的换行 're.Pattern="(<(i|b|p|br|font)>)" 'Str=re.Replace(Str,"[$2]") 're.Pattern="(<(\/i|\/b|\/p|\/font)>)" 'Str=re.Replace(Str,"[$2]") 're.Pattern="(>)("&vbNewLine&")(<)" 'Str=re.Replace(Str,"$1$3") 're.Pattern="(>)("&vbNewLine&vbNewLine&")(<)" 'Str=re.Replace(Str,"$1$3") 're.Pattern="(
    )((.|\n)*)(<\/div>)" 'Str=re.Replace(Str,"[quote]$2[/quote]") 're.Pattern="<(.[^>]*)>" 'Str=re.Replace(Str,"") 're.Pattern="(\[(i|b|p|br|font)\])" 'Str=re.Replace(Str,"<$2>") 're.Pattern="(\[(\/i|\/b|\/p|\/font)\])" 'Str=re.Replace(Str,"<$2>") 'End If 're.Pattern = "(\[br\])" 'Str = re.Replace(Str,"
    ") 're.Pattern = "( )" 'Str = re.Replace(Str,Chr(9)) 're.Pattern = "()" 'Str = re.Replace(Str,"") 're.Pattern = "(<\/STRONG>)" 'Str = re.Replace(Str,"") 're.Pattern ="()" 'Str = re.Replace(Str,"") 're.Pattern ="(<\/TBODY>)" 'Str = re.Replace(Str,"") 'Set Re=Nothing Html2Ubb = Str Else Html2Ubb = "" End If End Function '更新用户短信通知信息（新短信条数||新短讯ID||发信人名） Sub UPDATE_User_Msg(username) Dim msginfo,i,UP_UserInfo,newmsg newmsg=newincept(username) If newmsg>0 Then msginfo=newincept(username) & "||" & inceptid(1,username) & "||" & inceptid(2,username) Else msginfo="0||0||null" End If Dvbbs.execute("UPDATE [Dv_User] Set UserMsg='"&Dvbbs.CheckStr(msginfo)&"' WHERE username='"&Dvbbs.CheckStr(username)&"'") If username=Dvbbs.MemberName Then UP_UserInfo=Session(Dvbbs.CacheName & "UserID") UP_UserInfo(30)=msginfo Session(Dvbbs.CacheName & "UserID")=UP_UserInfo Else Call Dvbbs.NeedUpdateList(username,1) End If End Sub '统计留言 Function newincept(iusername) Dim Rs Rs=Dvbbs.execute("SELECT Count(id) FROM Dv_Message WHERE flag=0 And issend=1 And DelR=0 And incept='"& iusername &"'") newincept=Rs(0) Set Rs=nothing If isnull(newincept) Then newincept=0 End Function Function inceptid(stype,iusername) Dim Rs Set Rs=Dvbbs.execute("SELECT top 1 id,sender FROM Dv_Message WHERE flag=0 And issend=1 And DelR=0 And incept='"& iusername &"'") If not rs.eof Then If stype=1 Then inceptid=Rs(0) Else inceptid=Rs(1) End If Else If stype=1 Then inceptid=0 Else inceptid="null" End If End If Set Rs=nothing End Function %>