talkweb 发表于 2009-10-12 13:29:47

哪位强人发个1310的人兽互转的SQL啊!!!

哪位强人发个1310的人兽互转的SQL啊!!!

talkweb 发表于 2009-10-14 14:47:16

1299的我有.1310不通用的吧.

langziming 发表于 2009-10-16 19:48:37

下面不知道对不对！
==========
        Sql="Select * from Account_char where strAccountID='"& strid &"' and (strcharID1='"& username &"' or strcharID2='"& username &"' or strcharID3='"& username &"')"
        set ors=conn.execute(Sql)
        if ors.eof then
                Response.write("<script>alert('输入的信息不正确！');window.history.back();</script>")
                Response.End()
        end if
        Sql="Select * from TB_USER where strAccountid='"& strid &"' and strpasswd='"& psw &"'"
        set ors=conn.execute(Sql)
        if ors.eof then
                Response.write("<script>alert('输入的密码不正确！');window.history.back();</script>")
                Response.End()
        end if
       
        '===============
        Sql="Select * from USERDATA where struserID='" & username & "'"
        set ors=conn.Execute(Sql)
        if ors.eof then
                Response.write("<script>alert('输入的角色名有误！');window.history.back();</script>")
                Response.End()
        end if
        if ors("knights")<>0 then
                Response.write("<script>alert('该角色未退出骑士团！');window.history.back();</script>")
                Response.End()

        end if
        ors.close
        set ors=nothing

        Sql="Select * from CURRENTUSER where strCharID='"& username &"'"
        set ors=conn.Execute(Sql)
        if not ors.eof then
                Response.write("<script>alert('角色还在线上请下线修改！');window.history.back();</script>")
                Response.End()
        end if
        ors.close
        set ors=nothing
       
        Sql="exec KarusNT '"& strid &"'"
        conn.execute(Sql)
        Response.write("<script>alert('您的种族转换申请成功！');</script>")
end if

ctgwglzc 发表于 2009-10-17 16:20:35


CREATE procedure
@Account char(30)

AS DECLARE @clannumber smallint, @length int,@row int,@i int,@dwid int,@pos int,@dur int,@dur1 int,@ext int,@StackSize1 int,@strName varchar(30),@strExtName varchar(30),@Cdwid varbinary(4),@cdur varchar(2),@cstack varchar(2)
begin tran
declare @char1 varchar(21)
set @char1 = (select strcharid1 from account_char where straccountid = @account)
declare @char2 varchar(21)
set @char2 = (select strcharid2 from account_char where straccountid = @account)
declare @char3 varchar(21)
set @char3 = (select strcharid3 from account_char where straccountid = @account)
declare @clannumber1 smallint
set @clannumber1 = (select idnum from knights where chief = @char1)
declare @clannumber2 smallint
set @clannumber2 = (select idnum from knights where chief = @char2)
declare @clannumber3 smallint
set @clannumber3 = (select idnum from knights where chief = @char3)
update account_char set bnation = '2' where bnation = '1' and straccountid = @Account
update userdata set nation = '2' where nation = '1' and struserid = @char1
update userdata set race = '11' where race = '1' and class in ('101','105','106') and struserid = @char1
Update userdata set race = '12' where race = '2' and class in ('107','111','102','104','112','108') and struserid = @char1
update userdata set race = '13' where race = '3' and class in ('103','109','110') and struserid = @char1
update userdata set race = '13' where race = '4' and class in ('104','111','112') and struserid = @char1
update userdata set class = '205' where class = '105' and struserid = @char1
update userdata set class = '207' where class = '107' and struserid = @char1
update userdata set class = '209' where class = '109' and struserid = @char1
update userdata set class = '211' where class = '111' and struserid = @char1
update userdata set class = '201' where class = '101' and struserid = @char1
update userdata set class = '202' where class = '102' and struserid = @char1
update userdata set class = '203' where class = '103' and struserid = @char1
update userdata set class = '204' where class = '104' and struserid = @char1
update userdata set class = '212' where class = '112' and struserid = @char1
update userdata set class = '206' where class = '106' and struserid = @char1
update userdata set class = '208' where class = '108' and struserid = @char1
update userdata set class = '210' where class = '110' and struserid = @char1
update userdata set zone = '21',bind = '-1',px = '31900',pz = '40100',py = '0' where struserid = @char1
delete from knights where chief = @char1
delete from knights_user where sidnum = @clannumber1
delete from knights_rating where shindex = @clannumber1
update userdata set knights = 0, fame = 0 where knights = @clannumber1
update userdata set nation = '2' where nation = '1' and struserid = @char2
update userdata set race = '11' where race = '1' and class in ('101','105','106') and struserid = @char2
Update userdata set race = '12' where race = '2' and class in ('107','111','102','104','112','108') and struserid = @char2
update userdata set race = '13' where race = '3' and class in ('103','109','110') and struserid = @char2
update userdata set race = '13' where race = '4' and class in ('104','111','112') and struserid = @char2
update userdata set class = '205' where class = '105' and struserid = @char2
update userdata set class = '207' where class = '107' and struserid = @char2
update userdata set class = '209' where class = '109' and struserid = @char2
update userdata set class = '211' where class = '111' and struserid = @char2
update userdata set class = '201' where class = '101' and struserid = @char2
update userdata set class = '202' where class = '102' and struserid = @char2
update userdata set class = '203' where class = '103' and struserid = @char2
update userdata set class = '204' where class = '104' and struserid = @char2
update userdata set class = '212' where class = '112' and struserid = @char2
update userdata set class = '206' where class = '106' and struserid = @char2
update userdata set class = '208' where class = '108' and struserid = @char2
update userdata set class = '210' where class = '110' and struserid = @char2
update userdata set zone = '21',bind = '-1',px = '31900',pz = '40100',py = '0' where struserid = @char2
delete from knights where chief = @char2
delete from knights_user where sidnum = @clannumber2
delete from knights_rating where shindex = @clannumber2
update userdata set knights = 0, fame = 0 where knights = @clannumber2
update userdata set nation = '2' where nation = '1' and struserid = @char3
update userdata set race = '11' where race = '1' and class in ('101','105','106') and struserid = @char3
Update userdata set race = '12' where race = '2' and class in ('107','111','102','104','112','108') and struserid = @char3
update userdata set race = '13' where race = '3' and class in ('103','109','110') and struserid = @char3
update userdata set race = '13' where race = '4' and class in ('104','111','112') and struserid = @char3
update userdata set class = '205' where class = '105' and struserid = @char3
update userdata set class = '207' where class = '107' and struserid = @char3
update userdata set class = '209' where class = '109' and struserid = @char3
update userdata set class = '211' where class = '111' and struserid = @char3
update userdata set class = '201' where class = '101' and struserid = @char3
update userdata set class = '202' where class = '102' and struserid = @char3
update userdata set class = '203' where class = '103' and struserid = @char3
update userdata set class = '204' where class = '104' and struserid = @char3
update userdata set class = '212' where class = '112' and struserid = @char3
update userdata set class = '206' where class = '106' and struserid = @char3
update userdata set class = '208' where class = '108' and struserid = @char3
update userdata set class = '210' where class = '110' and struserid = @char3
update userdata set zone = '21',bind = '-1',px = '31900',pz = '40100',py = '0' where struserid = @char3
delete from knights where chief = @char3
delete from knights_user where sidnum = @clannumber3
delete from knights_rating where shindex = @clannumber3
update userdata set knights = 0, fame = 0 where knights = @clannumber3
update userdata set knights = 0, fame = 0 where struserid = @char1
update userdata set knights = 0, fame = 0 where struserid = @char2
update userdata set knights = 0, fame = 0 where struserid = @char3
Update knights set vicechief_1 = '' where vicechief_1 = @char1
Update knights set vicechief_2 = '' where vicechief_2 = @char1
Update knights set vicechief_3 = '' where vicechief_3 = @char1
Update knights set vicechief_1 = '' where vicechief_1 = @char2
Update knights set vicechief_2 = '' where vicechief_2 = @char2
Update knights set vicechief_3 = '' where vicechief_3 = @char2
Update knights set vicechief_1 = '' where vicechief_1 = @char3
Update knights set vicechief_2 = '' where vicechief_2 = @char3
Update knights set vicechief_3 = '' where vicechief_3 = @char3
delete from knights_user where struserid = @char1
delete from knights_user where struserid = @char2
delete from knights_user where struserid = @char3
commit tran

GO
CREATE procedure
@Account char(30)

AS DECLARE @clannumber smallint, @length int,@row int,@i int,@dwid int,@pos int,@dur int,@dur1 int,@ext int,@StackSize1 int,@strName varchar(30),@strExtName varchar(30),@Cdwid varbinary(4),@cdur varchar(2),@cstack varchar(2)

begin tran

declare @char1 varchar(21)
set @char1 = (select strcharid1 from account_char where straccountid = @account)
declare @char2 varchar(21)
set @char2 = (select strcharid2 from account_char where straccountid = @account)
declare @char3 varchar(21)
set @char3 = (select strcharid3 from account_char where straccountid = @account)
declare @clannumber1 smallint
set @clannumber1 = (select idnum from knights where chief = @char1)
declare @clannumber2 smallint
set @clannumber2 = (select idnum from knights where chief = @char2)
declare @clannumber3 smallint
set @clannumber3 = (select idnum from knights where chief = @char3)

update account_char set bnation = '1' where bnation = '2' and straccountid = @Account

update userdata set nation = '1' where nation = '2' and struserid = @char1
Update userdata set race = '1' where race = '11' and class in ('201','205','206') and struserid = @char1
Update userdata set race = '1' where race = '12' and class in ('201','205','206') and struserid = @char1
Update userdata set race = '1' where race = '13' and class in ('201','205','206') and struserid = @char1
Update userdata set race = '2' where race = '12' and class in ('207','211','202','204','212','208') and struserid = @char1
update userdata set race = '2' where race = '13' and class in ('202','207','208') and struserid = @char1
update userdata set race = '3' where race = '12' and class in ('203','209','210') and struserid = @char1
update userdata set race = '3' where race = '13' and class in ('203','209','210') and struserid = @char1
update userdata set race = '4' where race = '13' and class in ('204','211','212') and struserid = @char1
update userdata set class = '105' where class = '205' and struserid = @char1
update userdata set class = '107' where class = '207' and struserid = @char1
update userdata set class = '109' where class = '209' and struserid = @char1
update userdata set class = '111' where class = '211' and struserid = @char1
update userdata set class = '101' where class = '201' and struserid = @char1
update userdata set class = '102' where class = '202' and struserid = @char1
update userdata set class = '103' where class = '203' and struserid = @char1
update userdata set class = '104' where class = '204' and struserid = @char1
update userdata set class = '112' where class = '212' and struserid = @char1
update userdata set class = '106' where class = '206' and struserid = @char1
update userdata set class = '108' where class = '208' and struserid = @char1
update userdata set class = '110' where class = '210' and struserid = @char1
update userdata set zone = '21',bind = '-1',px = '31900',pz = '40100',py = '0' where struserid = @char1
delete from knights where chief = @char1
delete from knights_user where sidnum = @clannumber1
delete from knights_rating where shindex = @clannumber1
update userdata set knights = 0, fame = 0 where knights = @clannumber1

update userdata set nation = '1' where nation = '2' and struserid = @char2
Update userdata set race = '1' where race = '11' and class in ('201','205','206') and struserid = @char2
Update userdata set race = '1' where race = '12' and class in ('201','205','206') and struserid = @char2
Update userdata set race = '1' where race = '13' and class in ('201','205','206') and struserid = @char2
Update userdata set race = '2' where race = '12' and class in ('207','211','202','204','212','208') and struserid = @char2
update userdata set race = '2' where race = '13' and class in ('202','207','208') and struserid = @char2
update userdata set race = '3' where race = '12' and class in ('203','209','210') and struserid = @char2
update userdata set race = '3' where race = '13' and class in ('203','209','210') and struserid = @char2
update userdata set race = '4' where race = '13' and class in ('204','211','212') and struserid = @char2
update userdata set class = '105' where class = '205' and struserid = @char2
update userdata set class = '107' where class = '207' and struserid = @char2
update userdata set class = '109' where class = '209' and struserid = @char2
update userdata set class = '111' where class = '211' and struserid = @char2
update userdata set class = '101' where class = '201' and struserid = @char2
update userdata set class = '102' where class = '202' and struserid = @char2
update userdata set class = '103' where class = '203' and struserid = @char2
update userdata set class = '104' where class = '204' and struserid = @char2
update userdata set class = '112' where class = '212' and struserid = @char2
update userdata set class = '106' where class = '206' and struserid = @char2
update userdata set class = '108' where class = '208' and struserid = @char2
update userdata set class = '110' where class = '210' and struserid = @char2
update userdata set zone = '21',bind = '-1',px = '31900',pz = '40100',py = '0' where struserid = @char2
delete from knights where chief = @char2
delete from knights_user where sidnum = @clannumber2
delete from knights_rating where shindex = @clannumber2
update userdata set knights = 0, fame = 0 where knights = @clannumber2

update userdata set nation = '1' where nation = '2' and struserid = @char3
Update userdata set race = '1' where race = '11' and class in ('201','205','206') and struserid = @char3
Update userdata set race = '1' where race = '12' and class in ('201','205','206') and struserid = @char3
Update userdata set race = '1' where race = '13' and class in ('201','205','206') and struserid = @char3
Update userdata set race = '2' where race = '12' and class in ('207','211','202','204','212','208') and struserid = @char3
update userdata set race = '2' where race = '13' and class in ('202','207','208') and struserid = @char3
update userdata set race = '3' where race = '12' and class in ('203','209','210') and struserid = @char3
update userdata set race = '3' where race = '13' and class in ('203','209','210') and struserid = @char3
update userdata set race = '4' where race = '13' and class in ('204','211','212') and struserid = @char3
update userdata set class = '105' where class = '205' and struserid = @char3
update userdata set class = '107' where class = '207' and struserid = @char3
update userdata set class = '109' where class = '209' and struserid = @char3
update userdata set class = '111' where class = '211' and struserid = @char3
update userdata set class = '101' where class = '201' and struserid = @char3
update userdata set class = '102' where class = '202' and struserid = @char3
update userdata set class = '103' where class = '203' and struserid = @char3
update userdata set class = '104' where class = '204' and struserid = @char3
update userdata set class = '112' where class = '212' and struserid = @char3
update userdata set class = '106' where class = '206' and struserid = @char3
update userdata set class = '108' where class = '208' and struserid = @char3
update userdata set class = '110' where class = '210' and struserid = @char3
update userdata set zone = '21',bind = '-1',px = '31900',pz = '40100',py = '0' where struserid = @char3
delete from knights where chief = @char3
delete from knights_user where sidnum = @clannumber3
delete from knights_rating where shindex = @clannumber3
update userdata set knights = 0, fame = 0 where knights = @clannumber3
update userdata set knights = 0, fame = 0 where struserid = @char1
update userdata set knights = 0, fame = 0 where struserid = @char2
update userdata set knights = 0, fame = 0 where struserid = @char3
Update knights set vicechief_1 = '' where vicechief_1 = @char1
Update knights set vicechief_2 = '' where vicechief_2 = @char1
Update knights set vicechief_3 = '' where vicechief_3 = @char1
Update knights set vicechief_1 = '' where vicechief_1 = @char2
Update knights set vicechief_2 = '' where vicechief_2 = @char2
Update knights set vicechief_3 = '' where vicechief_3 = @char2
Update knights set vicechief_1 = '' where vicechief_1 = @char3
Update knights set vicechief_2 = '' where vicechief_2 = @char3
Update knights set vicechief_3 = '' where vicechief_3 = @char3
delete from knights_user where struserid = @char1
delete from knights_user where struserid = @char2
delete from knights_user where struserid = @char3

commit tran

GO

leonjaykai 发表于 2009-10-25 22:33:48

看不懂~~~先推再說

shinryoken 发表于 2009-10-30 16:59:45

ssssssssssssssssssssssssssssss
页: [1]
查看完整版本: 哪位强人发个1310的人兽互转的SQL啊!!!