postdata.asp

公司企业网站管理系统全站源码,用于企业内部对网站的管理

<!--#include file=../conn.asp-->
<!--#include file="inc/const.asp"-->
<%
Head()
Server.ScriptTimeOut=9999999
Dim admin_flag
admin_flag=Split("26,27",",")
CheckAdmin(","&admin_flag(0)&",")
CheckAdmin(","&admin_flag(1)&",")
Select Case LCase(Request("action"))
	Case "nowused" : Call NowUsed()
	Case "update" : Call Update()
	Case "del" : Call Del()
	Case "creattable" : Call CreatTable()
	Case "search" : Call Search()
	Case "update2" : Call Update2()
	Case "update3" : Call Update3()
	Case Else
		Call main()
End Select
Footer()

Sub main()
%>
<table width="100%" border="0" cellspacing="1" cellpadding="3" align="center">
	<tr> 
		<td height="23" colspan="2" class=td1><B>说明</B>：<BR>您可以选择下列其中之一种模式进行帖子数据在不同表之间的转换。</td>
	</tr>
	<tr> 
		<th colspan="2">模式一：搜索要转移的帖子</th>
	</tr>
	<FORM METHOD=POST ACTION="?action=search">
	<tr> 
		<td height="23" width="20%" class=td1><B>搜索条件</B></td>
		<td height="23" width="80%" class=td1>
			<input type="text" name="keyword">&nbsp;
			<select name="tablename">
			<%=TableSelectForm%>
			</select>&nbsp;<!--shinzeal edit username and topic to searchWhat in 2004/7/4 这种单选的标单用radio比较合理-->
			<input type="radio" class="radio" name="searchWhat" value="username" checked>用户&nbsp;
			<input type="radio" class="radio" name="searchWhat" value="topic">主题&nbsp;
			<input type="submit" class="button" name="submit" value="搜索">
		</td>
	</tr>
	</FORM>
	<tr> 
		<td height="23" colspan="2" class=td1><B>注意</B>：这里仅搜索所在表的主题和发表用户数据，搜索后对搜索结果进行操作</td>
	</tr>
	<tr> 
		<th colspan="2">模式二：在不同表转移数据</th>
	</tr>
	<FORM METHOD=POST ACTION="?action=update2">
	<tr> 
		<td height="23" width="100%" class=td1 colspan="2">&nbsp;
		<select name="OutTablename">
		<%=TableSelectForm%>
		</select><!--shinzeal edit top1000 and end1000 to TopOrEnd in 2004/7/4 这种单选的标单用radio比较合理-->
		 <input type="radio" class="radio" name="TopOrEnd" value="Top" checked>前 <input type="radio" class="radio" name="TopOrEnd" value="End">后 <input type=text name="selnum" value="100" size=3>条 记录转移到
		<select name="InTablename">
		<%=TableSelectForm%>
		</select>
		&nbsp;<input type="submit" class="button" name="submit" value="提交">
		</td>
	</tr>
	</FORM>
	<tr> 
		<td height="23" colspan="2" class=td1><B>注意</B>：最前N条记录指数据库中最早发表的帖子（如果平均每个帖子有5个回复，那么100个主题在这里的更新量将是500条记录），这通常要花很长的时间，更新的速度取决于您的服务器性能以及更新数据的多少。执行本步骤将消耗大量的服务器资源，建议您在访问人数较少的时候或者本地进行更新操作。</td>
	</tr>
</table>
<%
end sub

sub nowused()
%>
<form method="POST" action="?action=update">
<table width="100%" border="0" cellspacing="1" cellpadding="3" align="center">
<tr> 
<td height="23" colspan="5" class=td1><B>说明</B>：<BR>下列数据表中选中的为当前论坛所使用来保存帖子数据的表，一般情况下每个表中的数据越少论坛帖子显示速度越快，当您下列单个帖子数据表中的数据有超过几万的帖子时不妨新添一个数据表来保存帖子数据（SQL版本用户建议每个表数据达到20万以后进行添加表操作），您会发现论坛速度快很多很多。<BR>您也可以将当前所使用的数据表在下列数据表中切换，当前所使用的帖子数据表即当前论坛用户发贴时默认的保存帖子数据表</td>
</tr>
<tr> 
<th colspan="5">当前数据表设定</th>
</tr>
<tr> 
<td width="20%"><b>表名<B></td>
<td width="20%"><B>说明</B></td>
<td width="20%"><B>当前帖数</B></td>
<td width="20%"><B>当前默认</B></td>
<td width="20%"><B>删除</B></td>
</tr>
<%
Dim i,rs
for i=0 to ubound(AllPostTable)
	On Error Resume Next
	Set Rs=Dvbbs.Execute("select count(*) from "&AllPostTable(i)&"")
	If Err Then
		Err.Clear
%>
	<tr> 
		<td width="20%" class=td1><%=AllPostTable(i)%></td>
		<td width="20%" class=td1>该记录对应的帖子数据表不存在或已经被删除</td>
		<td width="20%" class=td1>-1</td>
		<td width="20%" class=td1><input value="<%=AllPostTable(i)%>" name="TableName" type="radio" class="radio" disabled="true"></td>
		<td width="20%" class=td1><a href="?action=del&tablename=<%=AllPostTable(i)%>">删除</a></td>
	</tr>
<%	Else%>
	<tr> 
		<td width="20%" class=td1><%=AllPostTable(i)%></td>
		<td width="20%" class=td1><%=AllPostTableName(i)%></td>
		<td width="20%" class=td1><%=Rs(0)%></td>
		<td width="20%" class=td1><input value="<%=AllPostTable(i)%>" name="TableName" type="radio" class="radio" <%if Trim(Lcase(Dvbbs.NowUseBBS))=Lcase(AllPostTable(i)) then%>checked<%end if%>></td>
		<td width="20%" class=td1><a href="?action=del&tablename=<%=AllPostTable(i)%>"  onclick="{if(confirm('删除将包括该数据表所有帖子，本操作所删除的内容将不可恢复，确定删除吗?')){return true;}return false;}">删除</a></td>
	</tr>
<%
	End IF
next
%>
<tr> 
<td width="100%" colspan=5 class=td1> 
<input type="submit" class="button" name="Submit" value="提 交">
</td>
</tr>
</form>
<FORM METHOD=POST ACTION="?action=CreatTable">
<tr> 
<th colspan="5">添加数据表</th>
</tr>
<tr> 
<td width="20%" class=td1>添加的表名</td>
<td width="80%" class=td1 colspan=4><input type=text name="tablename" value="Dv_bbs<%=ubound(AllPostTable)+2%>">&nbsp;只能用Dv_bbs+数字表示，如Dv_bbs5，最后的数字最多不能超过9</td>
</tr>
<tr> 
<td width="20%" class=td1>添加表的说明</td>
<td width="80%" class=td1 colspan=4><input type=text name="tablereadme">&nbsp;简单描述该表的用途，在搜索帖子和其他相关操作部分显示</td>
</tr>
<tr> 
<td width="100%" colspan=5 class=td1> 
<input type="submit" class="button" name="Submit" value="提 交">
</td>
</tr>
</FORM>
</table>
<%
end sub

sub update()
	Dvbbs.Execute("update Dv_setup set Forum_NowUseBBS='"&request.form("TableName")&"'")
	Dvbbs.loadSetup()
	Dv_suc("更新成功！")
end sub

sub del()
	dim nAllPostTable,nAllPostTableName,ii
	if Trim(request("tablename"))=Trim(Dvbbs.NowUseBBS) then
		Errmsg=ErrMsg + "<BR><li>当前正在使用的表不能删除。"
		dvbbs_error()
		exit sub
	end if
	Dvbbs.Execute("delete from dv_Tablelist where TableName='"&Trim(request("TableName"))&"'")
	Dvbbs.Execute("delete from dv_BestTopic where RootID in (select TopicID from dv_topic where PostTable='"&request("tablename")&"')")
	Dvbbs.Execute("delete from dv_Topic where PostTable='"&request("tablename")&"'")
	On Error Resume Next
	Dvbbs.Execute("drop table "&request("tablename")&"")
	If Err Then Err.Clear
	Dv_suc("删除成功！")
end sub

sub CreatTable()
if request.form("tablename")="" then
	Errmsg=ErrMsg + "<BR><li>请输入表名。"
	dvbbs_error()
	exit sub
elseif len(request.form("tablename"))<>7 then
	Errmsg=ErrMsg + "<BR><li>输入的表名不合法。"
	dvbbs_error()
	exit sub
elseif not isnumeric(right(request.form("tablename"),1)) then
	Errmsg=ErrMsg + "<BR><li>输入的表名不合法。"
	dvbbs_error()
	exit sub
elseif cint(right(request.form("tablename"),1))>9 or cint(right(request.form("tablename"),1))<0 then
	Errmsg=ErrMsg + "<BR><li>输入的表名不合法。"
	dvbbs_error()
	exit sub
end if
if request.form("tablereadme")="" then
	Errmsg=ErrMsg + "<BR><li>请输入表的说明。"
	dvbbs_error()
	exit sub
end If
Dim i,sql
for i=0 to ubound(AllPostTable)
	if AllPostTable(i)=request.form("tablename") then
		Errmsg=ErrMsg + "<BR><li>您输入的表名已经存在，请重新输入。"
		dvbbs_error()
		exit sub
	end if
next

Dim NewAllPostTable,NewAllPostTableName
'更新数据表列表

Dvbbs.Execute("insert into dv_TableList(TableName,TableType)Values('"&request.form("tablename")&"','"&request.form("tablereadme")&"') ")
'NewAllPostTable=rs(0) & "|" & request.form("tablename")
'NewAllPostTableName=rs(1) & "|" & request.form("tablereadme")

'Set conn = Server.CreateObject("ADODB.connection")
'connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("dvbbs5.mdb")
'conn.open connstr
'建立新表
If IsSqlDataBase=1 Then
sql="CREATE TABLE ["&request.form("tablename")&"] (AnnounceID int IDENTITY (1, 1) NOT NULL CONSTRAINT PK_"&request.form("tablename")&" PRIMARY KEY,"&_
		"ParentID int default 0,"&_
		"BoardID int default 0,"&_
		"UserName varchar(50),"&_
		"PostUserID int default 0,"&_
		"Topic varchar(250),"&_
		"Body text,"&_
		"DateAndTime smalldatetime default "&SqlNowString&","&_
		"length int Default 0,"&_
		"RootID int Default 0,"&_
		"layer int Default 0,"&_
		"orders int Default 0,"&_
		"isbest tinyint Default 0,"&_
		"ip varchar(40) NULL,"&_
		"Expression varchar(100) NULL,"&_
		"locktopic int Default 0,"&_
		"signflag tinyint Default 0,"&_
		"emailflag tinyint Default 0,"&_
		"isagree varchar(50) NULL,"&_
		"isupload tinyint default 0,"&_
		"isaudit tinyint default 0,"&_
		"PostBuyUser text,"&_
		"UbbList varchar(255),"&_
		"GetMoney int not null Default 0,"&_
		"UseTools varchar(255),"&_
		"GetMoneyType tinyint not null Default 0"&_
		")"
Else
sql="CREATE TABLE "&request.form("tablename")&" (AnnounceID int IDENTITY (1, 1) NOT NULL CONSTRAINT PrimaryKey PRIMARY KEY,"&_
		"ParentID int default 0,"&_
		"BoardID int default 0,"&_
		"UserName varchar(50),"&_
		"PostUserID int default 0,"&_
		"Topic varchar(250),"&_
		"Body text,"&_
		"DateAndTime smalldatetime default Now(),"&_
		"length int Default 0,"&_
		"RootID int Default 0,"&_
		"layer int Default 0,"&_
		"orders int Default 0,"&_
		"isbest tinyint Default 0,"&_
		"ip varchar(40) NULL,"&_
		"Expression varchar(100) NULL,"&_
		"locktopic int Default 0,"&_
		"signflag tinyint Default 0,"&_
		"emailflag tinyint Default 0,"&_
		"isagree varchar(50) NULL,"&_
		"isupload tinyint default 0,"&_
		"isaudit tinyint default 0,"&_
		"PostBuyUser text,"&_
		"UbbList varchar(255),"&_
		"GetMoney int not null Default 0,"&_
		"UseTools varchar(255),"&_
		"GetMoneyType tinyint not null Default 0"&_
		")"
End If 
Dvbbs.Execute(sql)

'添加索引
Dvbbs.Execute("create index dispbbs on "&request.form("tablename")&" (boardid,rootid)")
Dvbbs.Execute("create index save_1 on "&request.form("tablename")&" (rootid,orders)")
Dvbbs.Execute("create index disp on "&request.form("tablename")&" (boardid)")
Dvbbs.Execute("create index PostUserID on "&request.form("tablename")&" (PostUserID)")
'Dvbbs.Execute("update config set AllPostTable='"&NewAllPostTable&"',AllPostTableName='"&NewAllPostTableName&"'")
Dv_suc("添加表成功，请返回。")
end sub

'模式2更新
sub update2()
dim trs
dim ForNum,TopNum
Dim orderby,PostUserID
if request.form("outtablename")=request.form("intablename") then
	Errmsg=ErrMsg + "<BR><li>不能在相同数据表内转移数据。"
	dvbbs_error()
	exit sub
end if
if (not isnumeric(request.form("selnum"))) or request.form("selnum")="" then
	Errmsg=ErrMsg + "<BR><li>请填写正确的更新数量。"
	dvbbs_error()
	exit sub
end if
if request.form("TopOrEnd")="Top" then	'shinzeal edit this to TopOrEnd in 2004/7/4
orderby=""
else
orderby=" desc"
end if
TopNum=Clng(request.form("selnum"))
if TopNum>100 then
	ForNum=int(TopNum/100)+1
	TopNum=100
else
	ForNum=1
end if

Dim C1
C1=TopNum
%>
&nbsp;<BR>
<table cellpadding="0" cellspacing="0" border="0" width="100%" align="center">
<tr><td colspan=2 class=td1>
下面开始转移论坛帖子资料，预计本次共有<%=C1%>个帖子需要更新
<table width="400" border="0" cellspacing="1" cellpadding="1">
<tr> 
<td bgcolor=#000000>
<table width="400" border="0" cellspacing="0" cellpadding="1">
<tr> 
<td bgcolor=#ffffff height=9><img src="../skins/default/bar/bar3.gif" width=0 height=16 id=img2 name=img2 align=absmiddle></td></tr></table>
</td></tr></table> <span id=txt2 name=txt2 style="font-size:9pt">0</span><span style="font-size:9pt">%</span></td></tr>
</table>
<%
Response.Flush