tools_updatedb-2005-09-16.asp

zheng fu wang zhan gong neng qi quan

<!--#include file=conn.asp -->
<!--#include file="ConnUser.asp"-->
<!--#include file="config.asp"-->
<!--#include file="char.inc"-->
<!--#include file="chkuser.asp" -->
<!--#include file="md5.asp"-->
<!--#include file="ChkURL.asp"-->
<!--#include file="ChkManage.asp"-->
<%
if not(request.cookies(eChuang)("ManageKEY")="super" or request.cookies(eChuang)("ManageKEY")="typemaster" or request.cookies(eChuang)("ManageKEY")="bigmaster") then
	Show_Err("对不起，您的后台管理权限不够操作！")
	response.end
else
	action=request("action")
	'更新表结构
	conn.execute("alter table E_news add backtype1 int NULL default 0")
        response.write "<DIV align=center>添加[E_News]内部文章字段[backtype1]完毕！</DIV><BR>"

	conn.execute("alter table E_dep add depnumber int NULL default 0")
        response.write "<DIV align=center>添加[E_dep]内部字段[depnumber]完毕！</DIV><BR>"

        '更新表数据
	conn.execute("update "& db_News_Table &" Set backtype1=0")
	response.write "<DIV align=center>内部文章标记更新完毕！</DIV><BR>"

	conn.execute("update "& db_dep_Table &" Set depnumber=0")
	response.write "<DIV align=center>内部[E_dep]内部字段[depnumber]标记全部为值0！</DIV><BR>"

	response.write "<DIV align=center>全部更新完成！</DIV><BR>"
	response.end
	conn.close
	set conn=nothing
end if%>