Set rsz= Server.CreateObject("ADODB.Recordset")
SQL="Select * from TBL_Char where FLD_NAME ='"&jx&"'"
rsz.open SQL,conn2,2,3
if rsz("FLD_MONEY") > 10000000 then
rsz("FLD_MONEY") = rsz("FLD_MONEY") - 10000000
rsz.update
rsz.close
set rsz=nothing
SQL1= "update tbl_char set fld_item = 0x02940200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 where FLD_NAME ='"&jx&"'"
conn2.execute(sql1)
response.write "<script language=javascript>alert('帐号背包清理成功!扣除手续费!');location.href('manage.asp');</script>"
response.end
else
response.write "<script language=javascript>alert('对不起,您身上没有携带足够的钱来清理背包!请携带1000万热血币来删除');history.go(-1);</script>"
Response.End
end if
rsz.close
set rsz=nothing
end if
if request("action")="shanchu" then
jx=request("jx")
zh=request("zh")
if Session("name")<> zh then
Response.write "<SCRIPT language=JavaScript>alert('想黑人家的号啊你!');history.go(-1);</SCRIPT>"
Response.End
end if
SQL1= "delete tbl_char where FLD_NAME ='"&jx&"'"
SQL2= "delete tbl_warehouse where FLD_NAME ='"&jx&"'"
conn2.execute(sql1)
conn2.execute(sql2)
response.write "<script language=javascript>alert('您的帐号删除成功!!!');location.href('manage.asp');</script>"
end if
if request("action")="yao" then
jx=request("jx")
name=trim(session("name"))
Set rsk= Server.CreateObject("ADODB.Recordset")
SQL="Select * from TBL_account where FLD_ID ='"&name&"'"
rsk.open SQL,conn,1,1
if rsk("FLD_YAO") = 1 then
rsk.close
set rsk=nothing
response.write "<script language=javascript>alert('您已经领取过了物品,请不要重复领取!');location.href('manage.asp');</script>"
Response.End
else
Set rsl= Server.CreateObject("ADODB.Recordset")
SQL="Select * from TBL_Char where FLD_NAME ='"&jx&"'"
rsl.open SQL,conn2,1,1
if rsl("FLD_LEVEL") >=10 then
rsl.close
set rsl=nothing
Set rsm= Server.CreateObject("ADODB.Recordset")
SQL="Select * from TBL_ACCOUNT where FLD_ID ='"&name&"'"
rsm.open SQL,conn,2,3
rsm("FLD_YAO") = 1
rsm.update
rsm.close
set rsm=nothing
SQL2= "UPDATE TBL_Char set fld_money = 50000,FLD_ITEM=0x02940200000000002CDC143C01000000000000004052D777C8F7CB3C000000000000000000F9D00100000000002CDC143C01000000000000004052D777C8F7CB3C000000000000000000F8D00100000000002CDC143C01000000000000004052D777C8F7CB3C000000000000000000F7D00100000000002CDC143C01000000000000004052D777C8F7CB3C000000000000000000F6D00100000000002DDC143C01000000000000004052D777C8F7CB3C000000000000000000F5D00100000000002DDC143C01000000000000004052D777C8F7CB3C000000000000000000F4D00100000000002DDC143C01000000000000004052D777C8F7CB3C000000000000000000F3D00100000000002DDC143C01000000000000004052D777C8F7CB3C000000000000000000F2D001000000000037DC143C01000000000000000000000000000000000000000000000000F1D001000000000037DC143C01000000000000000000000000000000000000000000000000EAD00100000000001ECA9A3B01000000000000000000000000000000000000000000000000EBD00100000000001ECA9A3B01000000000000000000000000000000000000000000000000ECD00100000000001ECA9A3B0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 where FLD_NAME ='"&jx&"'"
conn2.execute(sql2)
response.write "<script language=javascript>alert('已经成功的领取了药品!');location.href('manage.asp');</script>"
response.end
else
rsl.close
set rsl=nothing
response.write "<script language=javascript>alert('请您到10级以后再来吧!');location.href('manage.asp');</script>"
Response.End
end if
end if
end if
if request("action")="gift" then
dim a
dim jq
dim jx
jx=request("jx")
jq=request("qn")
name=trim(session("name"))
a = jq + 100000000
Set rsk= Server.CreateObject("ADODB.Recordset")
SQL="Select * from TBL_account where FLD_ID ='"&name&"'"
rsk.open SQL,conn,1,1
if rsk("FLD_GIFT") = 1 then
rsk.close
set rsk=nothing
response.write "<script language=javascript>alert('您已经领取过了奖励,请不要重复领取!');location.href('manage.asp');</script>"
Response.End
else
Set rsl= Server.CreateObject("ADODB.Recordset")
SQL="Select * from TBL_Char where FLD_NAME ='"&jx&"'"
rsl.open SQL,conn2,1,1
if rsl("FLD_LEVEL") >59 then
rsl.close
set rsl=nothing
Set rsm= Server.CreateObject("ADODB.Recordset")
SQL="Select * from TBL_ACCOUNT where FLD_ID ='"&name&"'"
rsm.open SQL,conn,2,3
rsm("FLD_GIFT") = 1
rsm.update
rsm.close
set rsm=nothing
Set rst= Server.CreateObject("ADODB.Recordset")
SQL="Select * from TBL_Char where FLD_NAME ='"&jx&"'"
rst.open SQL,conn2,2,3
rst("FLD_MONEY")= a
rst.update
rst.close
set rst=nothing
response.write "<script language=javascript>alert('已经成功的领取了奖励!');location.href('manage.asp');</script>"
else
rsl.close
set rsl=nothing
response.write "<script language=javascript>alert('帐号还没有到60级!');location.href('manage.asp');</script>"
Response.End
end if
end if
end if
if request("action")="manage" then
jx=request("jx")
Set rs3= Server.CreateObject("ADODB.Recordset")
SQL="Select * from TBL_Char where FLD_NAME ='"&jx&"'"
rs3.open SQL,conn2,1,1
if rs3("FLD_MENOW") =0 then
rs3.close
set rs3=nothing
set rsk=server.createobject("adodb.recordset")
sql="select * from tbl_char where FLD_MENOW='0' and FLD_NAME ='"&jx&"'"
rsk.open sql,conn2,3,2
rsk("FLD_MENOW")=101
rsk("FLD_X")=613.6401
rsk("FLD_Y")=365.9651
rsk.update
rsk.close
set rsk=nothing
response.write "<script language=javascript>alert('自救成功,下次请小心,不要再卡号了!');location.href('manage.asp');</script>"
else
rs3.close
set rs3=nothing
response.write "<script language=javascript>alert('不需要使用本功能,没事别乱点!');location.href('manage.asp');</script>"
Response.End
end if
end if
if request("action")="zs" then
jx=request("jx")
jq=request("qn")
zy=request("zy")
Set rsz= Server.CreateObject("ADODB.Recordset")
SQL="Select * from TBL_Char where FLD_NAME ='"&jx&"'"
rsz.open SQL,conn2,1,1
if rsz("FLD_LEVEL") >=110 then
rsz.close
set rsz=nothing
IF zy= 1 then
SQL3= "update tbl_char set FLD_wearitem = 0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 where FLD_NAME ='"&jx&"'"
SQL4= "Update TBL_Char set FLD_ITEM=0x02940200000000000208AF2F0100000008C9100000000000000000000000000000000000001C431300000000000208AF2F010000004A0D03000000000000000000000000000000000000E7880200000000000108AF2F0100000074AE0A000000000000000000000000000000000000E8880200000000004AEEF805010000002179333C8F9698008F9698008F9698008F969800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 where FLD_NAME ='"&jx&"'"
SQL5= "update tbl_char set fld_quest = 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000C04020000000000D83C0C0001000000072D310100000000000000000000000000000000000000000000000000000000000000000000 where FLD_NAME ='"&jx&"'"
SQL6= "update tbl_char set fld_job_level = 0,fld_level = 1,fld_exp = 0,fld_fight_exp = 100000,fld_MONEY = 200000000,fld_ZX = 0 where FLD_NAME ='"&jx&"'"
SQL7= "update tbl_char set fld_kongfu = 0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 where FLD_NAME ='"&jx&"'"
conn2.execute(sql3)
conn2.execute(sql4)
conn2.execute(sql5)
conn2.execute(sql6)
conn2.execute(sql7)
name=trim(session("name"))
Set rsa= Server.CreateObject("ADODB.Recordset")
SQL="Select * from TBL_ACCOUNT where FLD_ID ='"&name&"'"
rsa.open SQL,conn,2,3
rsa("FLD_ZS") = rsa("FLD_ZS") + 1
rsa.update
rsa.close
set rsa=nothing
response.write "<script language=javascript>alert('恭喜恭喜,您的刀客已经成功转生!!');location.href('manage.asp');</script>"
response.write.end
end if
if zy=2 then
SQL3= "update tbl_char set FLD_wearitem = 0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 where FLD_NAME ='"&jx&"'"
SQL4= "Update [TBL_Char] set [TBL_Char].FLD_ITEM=0x02940200000000000208AF2F0100000008C9100000000000000000000000000000000000001C431300000000000208AF2F010000004A0D03000000000000000000000000000000000000E7880200000000000108AF2F0100000074AE0A000000000000000000000000000000000000E8880200000000004ACFEE0B010000002179333C8F9698008F9698008F9698008F969800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 where FLD_NAME ='"&jx&"'"
SQL5= "update tbl_char set fld_quest = 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000C04020000000000D83C0C0001000000072D310100000000000000000000000000000000000000000000000000000000000000000000 where FLD_NAME ='"&jx&"'"
SQL6= "update tbl_char set fld_job_level = 0,fld_level = 1,fld_exp = 0,fld_fight_exp = 100000,fld_MONEY = 200000000,fld_ZX = 0 where FLD_NAME ='"&jx&"'"
SQL7= "update tbl_char set fld_kongfu = 0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 where FLD_NAME ='"&jx&"'"
conn2.execute(sql3)
conn2.execute(sql4)
conn2.execute(sql5)
conn2.execute(sql6)
conn2.execute(sql7)
name=trim(session("name"))
Set rsa= Server.CreateObject("ADODB.Recordset")
SQL="Select * from TBL_ACCOUNT where FLD_ID ='"&name&"'"
rsa.open SQL,conn,2,3
rsa("FLD_ZS") = rsa("FLD_ZS") + 1
rsa.update
rsa.close
set rsa=nothing
response.write "<script language=javascript>alert('恭喜恭喜,您的剑客已经成功转生!!');location.href('manage.asp');</script>"
response.write.end
end if
if zy=3 then
SQL3= "update tbl_char set FLD_wearitem = 0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 where FLD_NAME ='"&jx&"'"
SQL4= "Update [TBL_Char] set [TBL_Char].FLD_ITEM=0x02940200000000000208AF2F0100000008C9100000000000000000000000000000000000001C431300000000000208AF2F010000004A0D03000000000000000000000000000000000000E7880200000000000108AF2F0100000074AE0A000000000000000000000000000000000000E8880200000000004AB0E411010000002179333C8F9698008F9698008F9698008F969800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 where FLD_NAME ='"&jx&"'"
SQL5= "update tbl_char set fld_quest = 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000C04020000000000D83C0C0001000000072D310100000000000000000000000000000000000000000000000000000000000000000000 where FLD_NAME ='"&jx&"'"
SQL6= "update tbl_char set fld_job_level = 0,fld_level = 1,fld_exp = 0,fld_fight_exp = 100000,fld_MONEY = 200000000,fld_ZX = 0 where FLD_NAME ='"&jx&"'"
SQL7= "update tbl_char set fld_kongfu = 0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 where FLD_NAME ='"&jx&"'"
conn2.execute(sql3)
conn2.execute(sql4)
conn2.execute(sql5)
conn2.execute(sql6)
conn2.execute(sql7)
name=trim(session("name"))
Set rsa= Server.CreateObject("ADODB.Recordset")
SQL="Select * from TBL_ACCOUNT where FLD_ID ='"&name&"'"
rsa.open SQL,conn,2,3
rsa("FLD_ZS") = rsa("FLD_ZS") + 1
rsa.update
rsa.close
set rsa=nothing
response.write "<script language=javascript>alert('恭喜恭喜,您的枪客已经成功转生!!');location.href('manage.asp');</script>"
response.write.end
end if
if zy=4 then
SQL3= "update tbl_char set FLD_wearitem = 0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 where FLD_NAME ='"&jx&"'"
SQL4= "Update [TBL_Char] set [TBL_Char].FLD_ITEM=0x02940200000000000208AF2F0100000008C9100000000000000000000000000000000000001C431300000000000208AF2F010000004A0D03000000000000000000000000000000000000E7880200000000000108AF2F0100000074AE0A000000000000000000000000000000000000E8880200000000004991DA17010000002179333C8F9698008F9698008F9698008F969800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 where FLD_NAME ='"&jx&"'"
SQL5= "update tbl_char set fld_quest = 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000C04020000000000D83C0C0001000000072D310100000000000000000000000000000000000000000000000000000000000000000000 where FLD_NAME ='"&jx&"'"
SQL6= "update tbl_char set fld_job_level = 0,fld_level = 1,fld_exp = 0,fld_fight_exp = 100000,fld_MONEY = 200000000,fld_ZX = 0 where FLD_NAME ='"&jx&"'"
SQL7= "update tbl_char set fld_kongfu = 0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 where FLD_NAME ='"&jx&"'"
conn2.execute(sql3)
conn2.execute(sql4)
conn2.execute(sql5)
conn2.execute(sql6)
conn2.execute(sql7)
name=trim(session("name"))
Set rsa= Server.CreateObject("ADODB.Recordset")
SQL="Select * from TBL_ACCOUNT where FLD_ID ='"&name&"'"
rsa.open SQL,conn,2,3
rsa("FLD_ZS") = rsa("FLD_ZS") + 1
rsa.update
rsa.close
set rsa=nothing
response.write "<script language=javascript>alert('恭喜恭喜,您的弓手已经成功转生!!');location.href('manage.asp');</script>"
response.write.end
end if
if zy=5 then
SQL3= "update tbl_char set FLD_wearitem = 0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 where FLD_NAME ='"&jx&"'"
SQL4= "Update [TBL_Char] set [TBL_Char].FLD_ITEM=0x02940200000000000208AF2F0100000008C9100000000000000000000000000000000000001C431300000000000208AF2F010000004A0D03000000000000000000000000000000000000E7880200000000000108AF2F0100000074AE0A000000000000000000000000000000000000E8880200000000004A72D01D010000002179333C94969800949698009496980094969800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 where FLD_NAME ='"&jx&"'"
SQL5= "update tbl_char set fld_quest = 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000C04020000000000D83C0C0001000000072D310100000000000000000000000000000000000000000000000000000000000000000000 where FLD_NAME ='"&jx&"'"
SQL6= "update tbl_char set fld_job_level = 0,fld_level = 1,fld_exp = 0,fld_fight_exp = 100000,fld_MONEY = 200000000,fld_ZX = 0 where FLD_NAME ='"&jx&"'"
SQL7= "update tbl_char set fld_kongfu = 0x0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 where FLD_NAME ='"&jx&"'"
conn2.execute(sql3)
conn2.execute(sql4)
conn2.execute(sql5)
conn2.execute(sql6)
conn2.execute(sql7)
name=trim(session("name"))
Set rsa= Server.CreateObject("ADODB.Recordset")
SQL="Select * from TBL_ACCOUNT where FLD_ID ='"&name&"'"
rsa.open SQL,conn,2,3
rsa("FLD_ZS") = rsa("FLD_ZS") + 1
rsa.update
rsa.close
set rsa=nothing
response.write "<script language=javascript>alert('恭喜恭喜,您的医生已经成功转生!!');location.href('manage.asp');</script>"
response.write.end
end if
else
response.write "<script language=javascript>alert('对不起,您的角色没有在110级以上,无法使用转生功能!');location.href('manage.asp');</script>"
Response.End
end if
end if