%
Select Case Request("t")
Case "1"
ViewVoters_Main()
Case "2"
Dim Rootid,Action,TopicInfo,BBsInfo,BBsReplyInfo,PostTable,ReplyID
ViewTopicInfo_Main()
Case Else
Dim dv_ubb,abgcolor
ViewPaper_Main()
End Select
Sub ViewPaper_Main()
Dvbbs.LoadTemplates("paper_even_toplist")
Dvbbs.stats=template.Strings(3)
Dvbbs.Head()
Dim paperid
Dim username
If Request("id")="" Then
Dvbbs.AddErrCode(35)
ElseIf Not IsNumeric(Request("id")) Then
Dvbbs.AddErrCode(35)
Else
paperID=clng(Request("id"))
End If
Dvbbs.ShowErr()
Set dv_ubb=new Dvbbs_UbbCode
dv_ubb.PostType=2
Dim Rs,Sql
Set Rs=Server.Createobject("Adodb.Recordset")
Sql="Select * From Dv_SmallPaper Where s_id="&paperid
Set Rs=Dvbbs.Execute(Sql)
If Rs.Eof And Rs.Bof Then
Dvbbs.AddErrCode(32)
Rs.Close
Set Rs=Nothing
Dvbbs.ShowErr()
Else
Dvbbs.Execute("Update Dv_SmallPaper Set s_hits=s_hits+1 Where s_id="&paperid)
Dim TempStr
TempStr = template.html(4)
TempStr = Replace(TempStr,"{$title}",Dvbbs.Htmlencode(rs("s_title")))
TempStr = Replace(TempStr,"{$username}",Dvbbs.Htmlencode(rs("s_username")))
TempStr = Replace(TempStr,"{$hits}",rs("s_hits"))
ubblists=ubblist(Rs("s_content"))&"39,"
TempStr = Replace(TempStr,"{$content}",dv_ubb.Dv_UbbCode(Rs("s_content"),4,2,1))
TempStr = Replace(TempStr,"{$addtime}",Dvbbs.Htmlencode(rs("s_addtime")))
Response.Write TempStr
Rs.Close
Set Rs=Nothing
End If
Dvbbs.ActiveOnline()
Dvbbs.Footer()
End Sub
Sub ViewVoters_Main()
Dim voteid
Dim title,votevalue,votevaluestr,voteoption
Dim TempArray,TempStr,TempStr1,TempStr2,TempStr3
Dvbbs.Loadtemplates("dispbbs")
Dvbbs.Stats=template.Strings(12)
Dvbbs.head
If Request("id")="" then
Dvbbs.AddErrCode(30)
ElseIf Not IsNumeric(Request("id")) then
Dvbbs.AddErrCode(30)
Else
VoteID=Request("id")
End If
Dvbbs.ShowErr
TempArray = Split(template.html(12),"||")
TempStr = TempArray(0)
Dim Rs,i
Set Rs=Dvbbs.Execute("select vote from dv_vote where voteid="&voteid)
If Not (rs.eof And rs.bof) Then
votevalue=split(rs(0),"|")
Else
Dvbbs.AddErrCode(30)
Dvbbs.ShowErr
End If
Set Rs=Dvbbs.Execute("select title from dv_topic where pollid="&voteid)
If Not (Rs.EOF And rs.bof) Then
title=Dvbbs.HtmlEncode(rs(0))
End If
TempStr = Replace(TempStr,"{$title}",title)
Set Rs=Dvbbs.Execute("select v.*,u.username from dv_voteuser v inner join [dv_user] u on v.userid=u.userid where voteid="&voteid)
If Rs.Eof And Rs.Bof Then
TempStr = Replace(TempStr,"{$voteinfo}",TempArray(1))
Else
TempStr1 = TempArray(2)
Do While Not Rs.Eof
TempStr2 = TempStr1
TempStr2 = Replace(TempStr2,"{$userid}",Rs("UserID"))
TempStr2 = Replace(TempStr2,"{$username}",Rs("UserName"))
voteoption = Split(rs("voteoption"),",")
For i = 0 To Ubound(voteoption)
If IsNumeric(voteoption(i)) Then
If i<>0 Then votevaluestr = votevaluestr & "
"
votevaluestr = votevaluestr & votevalue(voteoption(i))
End If
Next
TempStr2 = Replace(TempStr2,"{$uservote}",votevaluestr)
votevaluestr = ""
TempStr3 = TempStr3 & TempStr2
Rs.MoveNext
Loop
TempStr = Replace(TempStr,"{$voteinfo}",TempStr3)
End If
Rs.Close
Set Rs =Nothing
Response.Write TempStr
End Sub
Sub ViewTopicInfo_Main()
Dvbbs.LoadTemplates("dispbbs")
Dvbbs.ErrType = 1 '设置错误提示信息显示模式
Dvbbs.mainsetting(0)="98%"
Action = Request("action")
Rootid = Request("ID")
PostTable = Request("PostTable")
'PostTable = Checktable(PostTable)
ReplyID = Request("ReplyID")
If Rootid="" Or Not IsNumeric(Rootid) Then Dvbbs.AddErrCode(35)
If Dvbbs.GroupSetting(2)<>1 Then Dvbbs.AddErrCode(31)
Dvbbs.ShowErr()
Rootid = Clng(Rootid)
Select Case Action
Case "View" : Dvbbs.stats="查看贴子的信息"
Case Else
Dvbbs.stats="购买帖子"
End Select
'Dvbbs.Nav
'Dvbbs.Head_var 1,Dvbbs.Board_Data(4,0),"",""
Dvbbs.Head()
view_Topic()
If IsNumeric(ReplyID) and ReplyID<>"" Then
ReplyID = cCur(ReplyID)
If cCur(BBsInfo(5,0)) <> ReplyID Then view_Dispbbs
End If
FootInfo()
Dvbbs.ShowErr()
Dvbbs.Activeonline()
Dvbbs.Footer
End Sub
Sub view_Dispbbs()
GetBBsReplyInfo
Dvbbs.ShowErr()
%>
| 该回复帖信息 |
| 回复作者: | <%=UserInfoUrl(BBsReplyInfo(0,0))%> |
| 回复时间: | <%=BBsReplyInfo(2,0)%> |
<%If DVbbs.Forum_Setting(90)="1" Then %>
| 使用道具: | <%=GetTopicToolsInfo(BBsReplyInfo(6,0))%> |
<%End If%>
<%
End Sub
Sub view_Topic()
GetTopicInfo()
GetBBsInfo()
Dvbbs.ShowErr()
If TopicInfo(12,0)<>1 Then TopicInfo(0,0) = Dvbbs.iHtmlencode(TopicInfo(0,0))
%>
| 《<%=TopicInfo(0,0)%>》 主题信息 |
| 主题作者: | <%=UserInfoUrl(TopicInfo(1,0))%> |
| 发表时间: | <%=TopicInfo(3,0)%> |
| 回复帖数: | <%=TopicInfo(4,0)%> |
浏览次数: | <%=TopicInfo(5,0)%> |
<% If TopicInfo(11,0)>0 Then %>
| 帖子信息: | <%=GetTopicMoneyInfo(TopicInfo(9,0),TopicInfo(11,0))%> |
| 详细信息: |
<%ShowBuyUser%>
|
<% End If %>
<%If TopicInfo(10,0)<>"" and DVbbs.Forum_Setting(90)="1" Then %>
| 道具信息: | <%=GetTopicToolsInfo(TopicInfo(10,0))%> |
<% End If %>
<%
End Sub
Sub FootInfo()
Response.Write ""
End Sub
Sub ShowBuyUser()
Dim TempStr,i,BuyUser,n,m
If BBsInfo(1,0)="" Or Instr(BBsInfo(1,0),"|||")=0 Then Exit Sub
TempStr = Split(BBsInfo(1,0),"|||")
n = Ubound(TempStr)
Select Case TopicInfo(11,0)
Case 1,5
Response.Write "目前总共赠送的金币数为:"&TempStr(0)
Response.Write ",赠送次数为:"&n-1&"。
"
For i=2 to n
BuyUser = Split(TempStr(i),",")
Response.Write UserInfoUrl(BuyUser(0))
Response.Write " 获得金币:"&BuyUser(1)
Response.Write " "
If i mod 2 = 1 then Response.Write "
"
Next
Case 2
Response.Write "目前作者共获得金币数为:"&TempStr(0)
Response.Write ",赠送人数为:"&n-1&"。
"
For i=2 to n
BuyUser = Split(TempStr(i),",")
Response.Write UserInfoUrl(BuyUser(0))
Response.Write " 赠送金币:"&BuyUser(1)
Response.Write " "
If i mod 2 = 1 then Response.Write "
"
Next
Case 3
Dim BuyMoneyInfo,GetMoney,BuyInfo
BuyMoneyInfo = Split(TempStr(0),"@@@")
If Ubound(BuyMoneyInfo)>0 Then
GetMoney = BuyMoneyInfo(0)
BuyInfo = "该帖购买限制数为:"
If BuyMoneyInfo(1)<>"-1" Then
BuyInfo = BuyInfo & BuyMoneyInfo(1)&"。"
Else
BuyInfo = BuyInfo & "无限。"
End If
If BuyMoneyInfo(2)<>"0" Then
BuyInfo = BuyInfo & "VIP用户需要支付购买。
"
Else
BuyInfo = BuyInfo & "VIP用户不需要支付购买。
"
End If
If BuyMoneyInfo(3)<>"" Then
BuyInfo = BuyInfo & ("只允许以下用户购买:
" & BuyMoneyInfo(3))
End If
BuyInfo = BuyInfo&"
"
Else
GetMoney = TempStr(0)
End If
Response.Write BuyInfo
'Response.Write "
"
Response.Write "目前作者共获得金币数为:"&GetMoney
Response.Write ",购买人数为:"&n-2&"。
"
For i=2 to n
Response.Write UserInfoUrl(TempStr(i))
Response.Write " "
If i mod 2 = 1 then Response.Write "
"
Next
End Select
End Sub
Function UserInfoUrl(Name)
UserInfoUrl = ""&Name&""
End Function
'读取道具名单列表
Function GetTopicToolsInfo(ToolsID)
Dim Sql,Rs
GetTopicToolsInfo = "没有使用道具!"
If IsNull(ToolsID) Then Exit Function
If Not IsNumeric(Replace(ToolsID,",","")) Then Exit Function
If ToolsID="-1111" Then Exit Function
Sql = "Select ToolsName From [Dv_Plus_Tools_Info] where ID in ("&Dvbbs.Checkstr(ToolsID)&")"
Set Rs = Dvbbs.Plus_Execute(Sql)
If Rs.Eof Then
Exit Function
Else
Sql = Rs.GetString(,-1, "§§§", " ", " , ")
'Sql = Split(Sql,"§§§")
End If
GetTopicToolsInfo = Sql
End Function
Function GetTopicMoneyInfo(M,MoneyType)
'帖子信息类型
Dim TempStr
Select Case MoneyType
Case 1
TempStr = Replace(Template.Strings(17),"{$SendMoney}",M)
TempStr = Replace(TempStr,"{$Stats}","")
Case 2
TempStr = Replace(Template.Strings(18),"{$GetMoney}",M)
Case 3
TempStr = Replace(Template.Strings(19),"{$PayMoney}",M)
Case 5
TempStr = Replace(Template.Strings(17),"{$SendMoney}",M)
TempStr = Replace(TempStr,"{$Stats}",Template.Strings(21))
Case Else
TempStr = ""
End Select
TempStr = Replace(TempStr,"{$ViewUrl}","#")
TempStr = Replace(TempStr,"{$alertcolor}",Dvbbs.Mainsetting(1))
GetTopicMoneyInfo = TempStr
End Function
'获取主题信息 TopicInfo:
'Title=0,PostUsername=1,PostUserid=2,DateAndTime=3,Child=4,Hits=5,LastPost=6,
'LastPostTime=7,PostTable=8,GetMoney=9,UseTools=10,GetMoneyType=11,TopicMode=12
Sub GetTopicInfo()
Dim Sql,Rs
Sql = "Select Title,PostUsername,PostUserid,DateAndTime,Child,Hits,LastPost,LastPostTime,PostTable,GetMoney,UseTools,GetMoneyType,TopicMode "
Sql = Sql & "From Dv_Topic Where TopicID="&Rootid&" and boardid="&Dvbbs.boardid
Set Rs = Dvbbs.Execute(Sql)
If Rs.eof and Rs.bof Then
Dvbbs.AddErrCode(32)
Exit Sub
Else
Sql = Rs.GetRows(1)
End If
Set Rs=Nothing
TopicInfo = Sql
End Sub
'获取分表信息 BBsInfo
Sub GetBBsInfo()
Dim Sql,Rs
Sql = "Select isagree,PostBuyUser,GetMoney,UseTools,GetMoneyType,Announceid "
Sql = Sql & "From "&TopicInfo(8,0)&" Where RootID="&Rootid&" and ParentID=0 and boardid="&Dvbbs.boardid
Set Rs = Dvbbs.Execute(Sql)
If Rs.eof and Rs.bof Then
Dvbbs.AddErrCode(32)
Exit Sub
Else
Sql = Rs.GetRows(1)
End If
Set Rs=Nothing
BBsInfo = Sql
End Sub
'获取分表信息 BBsInfo
Sub GetBBsReplyInfo()
Dim Sql,Rs
Sql = "Select UserName,PostUserID,DateAndTime,isagree,PostBuyUser,GetMoney,UseTools,GetMoneyType "
Sql = Sql & "From "&TopicInfo(8,0)&" Where Announceid="&ReplyID
Set Rs = Dvbbs.Execute(Sql)
If Rs.eof and Rs.bof Then
Dvbbs.AddErrCode(32)
Exit Sub
Else
Sql = Rs.GetRows(1)
End If
Set Rs=Nothing
BBsReplyInfo = Sql
End Sub
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(35)
checktable = "Dv_bbs" & Table
End Function
%>