tools_updatedb2.asp

来自「zheng fu wang zhan gong neng qi quan」· ASP 代码 · 共 35 行

<!--#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 "& db_News_Table &" alter COLUMN titleface text(255)") 
         response.write "<DIV align=center>修改字段[E_News]表[titleface]字段长度为255完毕！</DIV><BR>"
                                       

        '更新表数据	

		conn.execute("update "& db_User_Table &" Set jingyong=1 where (jingyong is null) ")	
		response.write "<DIV align=center>用户管理中会员状态显示错误修正成功！</DIV><BR>"

		response.write "<DIV align=center>全部更新完成！</DIV><BR>"
		response.end
		conn.close
		set conn=nothing
	'else 
	'	response.write "<DIV align=center><font color=red>请选择一个参数！</font></DIV>"
	'	response.end
	'end if
end if%>