dvbbs.asp

人民医院眼科全站

<!--#include file=conn.asp-->
<%
dim exec,rs

exec="create table ly ([ID] int  IDENTITY(1,1) PRIMARY KEY CLUSTERED,"&_
	"title varchar(100) null ,"&_
	"nei text null ,"&_
	"rt int null default 0 ,"&_
	"name varchar(20) null ,"&_
	"url varchar(100) null ,"&_
	"email varchar(100) null ,"&_
	"qq varchar(50) null,"&_
	"pic varchar(100) null,"&_
	"t datetime null default now(), "&_
	"yd int null default 0, "&_
	"hf int null default 0, "&_
	"jh int null default 0, "&_
	"bl int null default 0, "&_
	"reID int null default 0, "&_
	"reTime datetime null default Now(), "&_
	"isTop int null default 0, "&_
	"ip varchar(20) null,"&_
	"male varchar(10) null,"&_
	"face varchar(50) null,"&_
	"isPrivate bit null default 0, "&_
	"comefrom varchar(100) null, "&_
	"isLock bit null default 0, "&_
	"icq varchar(20) null, "&_
	"msn varchar(20) null )"
conn.execute(exec)

exec="create table GBconst (topicNum int null default 0, "&_
	"bestNum int null default 0, "&_
	"usernum int null default 0, "&_
	"pageLinkNum int null default 0, "&_
	"mustReg bit null,"&_
	"masterRe bit null, "&_
	"imgUbb bit null,"&_
	"rcPerPage1 int null, "&_
	"rcPerPage2 int null, "&_
	"defaultSkin int null, "&_
	"defaultStyle int null, "&_
	"esCode text null, "&_
	"homepage varchar(100) null, "&_
	"title varchar(100) null, "&_
	"masterEmail varchar(100) null, "&_
	"timeDiff int null, "&_
	"privatenum int null, "&_
	"killword varchar(255) null, "&_
	"maxLength int null,"&_
	"showFace bit null, "&_
	"postLimit int null)"
conn.execute(exec)

exec="alter table [user] add GBface varchar(100) null, GBpostNum int null default 0, GBprivateNum int null default 0"
conn.execute(exec)

exec="insert into GBconst (pagelinknum, imgubb,rcPerpage1,rcPerpage2,defaultskin,defaultstyle,timediff,homepage,title,killword,maxlength,showFace,postLimit,esCode) "&_
	"values(5,1,10,15,1,1,0,'http://www.9seek.com/','9seek.com','妈妈的,我靠,fuck,bitch,他妈的,性爱',500,1,20,'if%20style%3D1%20then%0A%0D%20rcPerPage%3DrcPerPage1%0A%0D%20else%0A%0D%20rcPerPage%3DrcPerPage2%0A%0D%20end%20if%0A%0Dresponse.write%20%22%3C%21--%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%22%26lf%26lf%26%229seek%u7559%u8A00%u672C%u514D%u8D39%u7248%22%26lf%26lf%26%22%u672A%u7ECF%u6388%u6743%u4E0D%u5F97%u7528%u4E8E%u5546%u4E1A%u7528%u9014%uFF01%uFF01%22%26lf%26lf%26%22http%3A//www.9seek.com/%22%26lf%26lf%26%22%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23--%3E%22%26lf%26%22%3Cscript%20for%3Dwindow%20event%3Donload%3Evar%20clink%3Ddocument.links%5Bdocument.links.length-1%5D%3Bclink.innerText%3D%279seek%u7559%u8A00%u672C%20%u7248%u672C%uFF1AVer5.1%27%3Bclink.href%3D%27http%3A//www.9seek.com/%27%3Bclink.title%3D%279seek%20%u7559%u8A00%u672C%u514D%u8D39%u7248%27%3B%3C/script%3E%3Cscript%20src%3D%27client.js%27%3E%3C/script%3E%22%20')"
conn.execute(exec)

exec="update [user] set GBpostNum=0,GBprivateNum=0,GBface='face/m01.gif'"
conn.execute(exec)

exec="create index rt on ly (rt asc)"
conn.execute(exec)
exec="create index name on ly (name asc)"
conn.execute(exec)

conn.close
set conn=nothing

response.write "数据库转换成功！"

%>