<!--#include file="../conn.asp"-->
<!--#include file="ydzq.asp"-->
<%call head
call saycardd("上传勋章")%>
<%if saytk=1 then response.Write"不支持简版上传请切换到彩板上传"
Response.Expires = -1
Response.AddHeader "Pragma", "no-cache"
Response.AddHeader "Cache-Control", "no-cache, must-revalidate"
%>
<%
if request("tpp")=1 then
response.Write"确定删除重新建立数据库表"
response.Write"<a href=""xxxfile.asp?sid="&sid&"&amp;saytk="&saytk&"&amp;tpp=2"">是|<a href=""xxxfile.asp?sid="&sid&"&amp;saytk="&saytk&""">否</a>"
elseif request("tpp")=2 then
 conn.execute("DROP TABLE xunzhang")
sql="CREATE TABLE [xunzhang] (ID int IDENTITY (1,1) not null PRIMARY key)"
conn.Execute(sql)
sql="ALTER TABLE [xunzhang] ADD [name] nvarchar(50)"
conn.Execute(sql) 
sql="ALTER TABLE [xunzhang] ADD [tou] ntext"
conn.Execute(sql)
sql="ALTER TABLE [xunzhang] ADD [cent] int"
conn.Execute(sql)
response.Write"操作成功"
end if
response.Write"<br/>温馨提示如果您上传提示成功但这里不显示请点击这里<a href=""xxxfile.asp?sid="&sid&"&amp;saytk="&saytk&"&amp;tpp=1"">删除表新建表</a><br/>点击后将删除现在当前勋章所有数据请慎用"
response.write"<br/>上传用户勋章<br/>"
response.write("<form action='WAP2_Upfilexxx.asp?saytk="&saytk&"&amp;sid="&sid&"' enctype='multipart/form-data' method='post'>")%>
勋章名称：<input type="text" name="xuanname"><br/> 
选择勋章：<input type="file" name="filefield1"><br/>  
勋章价格：<input type="text" name="cent"><br/>  
<input type="submit" name="Submit2" value="确定上传">
<br/><br/>1.建议所上传文件名和目录组合是字母与数字.
<br/>2.上传的图片格式支持jpg,jpeg,gif,bmp,png.
<br/><a href="adminxunzhang.asp?saytk=<%=saytk%>&amp;sid=<%=sid%>">[用户勋章管理]</a>
<!--#include file="fanhui.asp"-->
<%call head1%>