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

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

下面不知道对不对！
==========
        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

1. 
   
2. CREATE procedure [HumanNT]
   
3. @Account char(30)
   
4. 
   
5. 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)
   
6. begin tran
   
7. declare @char1 varchar(21)
   
8. set @char1 = (select strcharid1 from account_char where straccountid = @account)
   
9. declare @char2 varchar(21)
   
10. set @char2 = (select strcharid2 from account_char where straccountid = @account)
    
11. declare @char3 varchar(21)
    
12. set @char3 = (select strcharid3 from account_char where straccountid = @account)
    
13. declare @clannumber1 smallint
    
14. set @clannumber1 = (select idnum from knights where chief = @char1)
    
15. declare @clannumber2 smallint
    
16. set @clannumber2 = (select idnum from knights where chief = @char2)
    
17. declare @clannumber3 smallint
    
18. set @clannumber3 = (select idnum from knights where chief = @char3)
    
19. update account_char set bnation = '2' where bnation = '1' and straccountid = @Account
    
20. update userdata set nation = '2' where nation = '1' and struserid = @char1
    
21. update userdata set race = '11' where race = '1' and class in ('101','105','106') and struserid = @char1
    
22. Update userdata set race = '12' where race = '2' and class in ('107','111','102','104','112','108') and struserid = @char1
    
23. update userdata set race = '13' where race = '3' and class in ('103','109','110') and struserid = @char1
    
24. update userdata set race = '13' where race = '4' and class in ('104','111','112') and struserid = @char1
    
25. update userdata set class = '205' where class = '105' and struserid = @char1
    
26. update userdata set class = '207' where class = '107' and struserid = @char1
    
27. update userdata set class = '209' where class = '109' and struserid = @char1
    
28. update userdata set class = '211' where class = '111' and struserid = @char1
    
29. update userdata set class = '201' where class = '101' and struserid = @char1
    
30. update userdata set class = '202' where class = '102' and struserid = @char1
    
31. update userdata set class = '203' where class = '103' and struserid = @char1
    
32. update userdata set class = '204' where class = '104' and struserid = @char1
    
33. update userdata set class = '212' where class = '112' and struserid = @char1
    
34. update userdata set class = '206' where class = '106' and struserid = @char1
    
35. update userdata set class = '208' where class = '108' and struserid = @char1
    
36. update userdata set class = '210' where class = '110' and struserid = @char1
    
37. update userdata set zone = '21',bind = '-1',px = '31900',pz = '40100',py = '0' where struserid = @char1
    
38. delete from knights where chief = @char1
    
39. delete from knights_user where sidnum = @clannumber1
    
40. delete from knights_rating where shindex = @clannumber1
    
41. update userdata set knights = 0, fame = 0 where knights = @clannumber1
    
42. update userdata set nation = '2' where nation = '1' and struserid = @char2
    
43. update userdata set race = '11' where race = '1' and class in ('101','105','106') and struserid = @char2
    
44. Update userdata set race = '12' where race = '2' and class in ('107','111','102','104','112','108') and struserid = @char2
    
45. update userdata set race = '13' where race = '3' and class in ('103','109','110') and struserid = @char2
    
46. update userdata set race = '13' where race = '4' and class in ('104','111','112') and struserid = @char2
    
47. update userdata set class = '205' where class = '105' and struserid = @char2
    
48. update userdata set class = '207' where class = '107' and struserid = @char2
    
49. update userdata set class = '209' where class = '109' and struserid = @char2
    
50. update userdata set class = '211' where class = '111' and struserid = @char2
    
51. update userdata set class = '201' where class = '101' and struserid = @char2
    
52. update userdata set class = '202' where class = '102' and struserid = @char2
    
53. update userdata set class = '203' where class = '103' and struserid = @char2
    
54. update userdata set class = '204' where class = '104' and struserid = @char2
    
55. update userdata set class = '212' where class = '112' and struserid = @char2
    
56. update userdata set class = '206' where class = '106' and struserid = @char2
    
57. update userdata set class = '208' where class = '108' and struserid = @char2
    
58. update userdata set class = '210' where class = '110' and struserid = @char2
    
59. update userdata set zone = '21',bind = '-1',px = '31900',pz = '40100',py = '0' where struserid = @char2
    
60. delete from knights where chief = @char2
    
61. delete from knights_user where sidnum = @clannumber2
    
62. delete from knights_rating where shindex = @clannumber2
    
63. update userdata set knights = 0, fame = 0 where knights = @clannumber2
    
64. update userdata set nation = '2' where nation = '1' and struserid = @char3
    
65. update userdata set race = '11' where race = '1' and class in ('101','105','106') and struserid = @char3
    
66. Update userdata set race = '12' where race = '2' and class in ('107','111','102','104','112','108') and struserid = @char3
    
67. update userdata set race = '13' where race = '3' and class in ('103','109','110') and struserid = @char3
    
68. update userdata set race = '13' where race = '4' and class in ('104','111','112') and struserid = @char3
    
69. update userdata set class = '205' where class = '105' and struserid = @char3
    
70. update userdata set class = '207' where class = '107' and struserid = @char3
    
71. update userdata set class = '209' where class = '109' and struserid = @char3
    
72. update userdata set class = '211' where class = '111' and struserid = @char3
    
73. update userdata set class = '201' where class = '101' and struserid = @char3
    
74. update userdata set class = '202' where class = '102' and struserid = @char3
    
75. update userdata set class = '203' where class = '103' and struserid = @char3
    
76. update userdata set class = '204' where class = '104' and struserid = @char3
    
77. update userdata set class = '212' where class = '112' and struserid = @char3
    
78. update userdata set class = '206' where class = '106' and struserid = @char3
    
79. update userdata set class = '208' where class = '108' and struserid = @char3
    
80. update userdata set class = '210' where class = '110' and struserid = @char3
    
81. update userdata set zone = '21',bind = '-1',px = '31900',pz = '40100',py = '0' where struserid = @char3
    
82. delete from knights where chief = @char3
    
83. delete from knights_user where sidnum = @clannumber3
    
84. delete from knights_rating where shindex = @clannumber3
    
85. update userdata set knights = 0, fame = 0 where knights = @clannumber3
    
86. update userdata set knights = 0, fame = 0 where struserid = @char1
    
87. update userdata set knights = 0, fame = 0 where struserid = @char2
    
88. update userdata set knights = 0, fame = 0 where struserid = @char3
    
89. Update knights set vicechief_1 = '' where vicechief_1 = @char1
    
90. Update knights set vicechief_2 = '' where vicechief_2 = @char1
    
91. Update knights set vicechief_3 = '' where vicechief_3 = @char1
    
92. Update knights set vicechief_1 = '' where vicechief_1 = @char2
    
93. Update knights set vicechief_2 = '' where vicechief_2 = @char2
    
94. Update knights set vicechief_3 = '' where vicechief_3 = @char2
    
95. Update knights set vicechief_1 = '' where vicechief_1 = @char3
    
96. Update knights set vicechief_2 = '' where vicechief_2 = @char3
    
97. Update knights set vicechief_3 = '' where vicechief_3 = @char3
    
98. delete from knights_user where struserid = @char1
    
99. delete from knights_user where struserid = @char2
    
100. delete from knights_user where struserid = @char3
     
101. commit tran
     
102. 
     
103. GO
     

复制代码

1. CREATE procedure [KarusNT]
   
2. @Account char(30)
   
3. 
   
4. 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)
   
5. 
   
6. begin tran
   
7. 
   
8. declare @char1 varchar(21)
   
9. set @char1 = (select strcharid1 from account_char where straccountid = @account)
   
10. declare @char2 varchar(21)
    
11. set @char2 = (select strcharid2 from account_char where straccountid = @account)
    
12. declare @char3 varchar(21)
    
13. set @char3 = (select strcharid3 from account_char where straccountid = @account)
    
14. declare @clannumber1 smallint
    
15. set @clannumber1 = (select idnum from knights where chief = @char1)
    
16. declare @clannumber2 smallint
    
17. set @clannumber2 = (select idnum from knights where chief = @char2)
    
18. declare @clannumber3 smallint
    
19. set @clannumber3 = (select idnum from knights where chief = @char3)
    
20. 
    
21. update account_char set bnation = '1' where bnation = '2' and straccountid = @Account
    
22. 
    
23. update userdata set nation = '1' where nation = '2' and struserid = @char1
    
24. Update userdata set race = '1' where race = '11' and class in ('201','205','206') and struserid = @char1
    
25. Update userdata set race = '1' where race = '12' and class in ('201','205','206') and struserid = @char1
    
26. Update userdata set race = '1' where race = '13' and class in ('201','205','206') and struserid = @char1
    
27. Update userdata set race = '2' where race = '12' and class in ('207','211','202','204','212','208') and struserid = @char1
    
28. update userdata set race = '2' where race = '13' and class in ('202','207','208') and struserid = @char1
    
29. update userdata set race = '3' where race = '12' and class in ('203','209','210') and struserid = @char1
    
30. update userdata set race = '3' where race = '13' and class in ('203','209','210') and struserid = @char1
    
31. update userdata set race = '4' where race = '13' and class in ('204','211','212') and struserid = @char1
    
32. update userdata set class = '105' where class = '205' and struserid = @char1
    
33. update userdata set class = '107' where class = '207' and struserid = @char1
    
34. update userdata set class = '109' where class = '209' and struserid = @char1
    
35. update userdata set class = '111' where class = '211' and struserid = @char1
    
36. update userdata set class = '101' where class = '201' and struserid = @char1
    
37. update userdata set class = '102' where class = '202' and struserid = @char1
    
38. update userdata set class = '103' where class = '203' and struserid = @char1
    
39. update userdata set class = '104' where class = '204' and struserid = @char1
    
40. update userdata set class = '112' where class = '212' and struserid = @char1
    
41. update userdata set class = '106' where class = '206' and struserid = @char1
    
42. update userdata set class = '108' where class = '208' and struserid = @char1
    
43. update userdata set class = '110' where class = '210' and struserid = @char1
    
44. update userdata set zone = '21',bind = '-1',px = '31900',pz = '40100',py = '0' where struserid = @char1
    
45. delete from knights where chief = @char1
    
46. delete from knights_user where sidnum = @clannumber1
    
47. delete from knights_rating where shindex = @clannumber1
    
48. update userdata set knights = 0, fame = 0 where knights = @clannumber1
    
49. 
    
50. update userdata set nation = '1' where nation = '2' and struserid = @char2
    
51. Update userdata set race = '1' where race = '11' and class in ('201','205','206') and struserid = @char2
    
52. Update userdata set race = '1' where race = '12' and class in ('201','205','206') and struserid = @char2
    
53. Update userdata set race = '1' where race = '13' and class in ('201','205','206') and struserid = @char2
    
54. Update userdata set race = '2' where race = '12' and class in ('207','211','202','204','212','208') and struserid = @char2
    
55. update userdata set race = '2' where race = '13' and class in ('202','207','208') and struserid = @char2
    
56. update userdata set race = '3' where race = '12' and class in ('203','209','210') and struserid = @char2
    
57. update userdata set race = '3' where race = '13' and class in ('203','209','210') and struserid = @char2
    
58. update userdata set race = '4' where race = '13' and class in ('204','211','212') and struserid = @char2
    
59. update userdata set class = '105' where class = '205' and struserid = @char2
    
60. update userdata set class = '107' where class = '207' and struserid = @char2
    
61. update userdata set class = '109' where class = '209' and struserid = @char2
    
62. update userdata set class = '111' where class = '211' and struserid = @char2
    
63. update userdata set class = '101' where class = '201' and struserid = @char2
    
64. update userdata set class = '102' where class = '202' and struserid = @char2
    
65. update userdata set class = '103' where class = '203' and struserid = @char2
    
66. update userdata set class = '104' where class = '204' and struserid = @char2
    
67. update userdata set class = '112' where class = '212' and struserid = @char2
    
68. update userdata set class = '106' where class = '206' and struserid = @char2
    
69. update userdata set class = '108' where class = '208' and struserid = @char2
    
70. update userdata set class = '110' where class = '210' and struserid = @char2
    
71. update userdata set zone = '21',bind = '-1',px = '31900',pz = '40100',py = '0' where struserid = @char2
    
72. delete from knights where chief = @char2
    
73. delete from knights_user where sidnum = @clannumber2
    
74. delete from knights_rating where shindex = @clannumber2
    
75. update userdata set knights = 0, fame = 0 where knights = @clannumber2
    
76. 
    
77. update userdata set nation = '1' where nation = '2' and struserid = @char3
    
78. Update userdata set race = '1' where race = '11' and class in ('201','205','206') and struserid = @char3
    
79. Update userdata set race = '1' where race = '12' and class in ('201','205','206') and struserid = @char3
    
80. Update userdata set race = '1' where race = '13' and class in ('201','205','206') and struserid = @char3
    
81. Update userdata set race = '2' where race = '12' and class in ('207','211','202','204','212','208') and struserid = @char3
    
82. update userdata set race = '2' where race = '13' and class in ('202','207','208') and struserid = @char3
    
83. update userdata set race = '3' where race = '12' and class in ('203','209','210') and struserid = @char3
    
84. update userdata set race = '3' where race = '13' and class in ('203','209','210') and struserid = @char3
    
85. update userdata set race = '4' where race = '13' and class in ('204','211','212') and struserid = @char3
    
86. update userdata set class = '105' where class = '205' and struserid = @char3
    
87. update userdata set class = '107' where class = '207' and struserid = @char3
    
88. update userdata set class = '109' where class = '209' and struserid = @char3
    
89. update userdata set class = '111' where class = '211' and struserid = @char3
    
90. update userdata set class = '101' where class = '201' and struserid = @char3
    
91. update userdata set class = '102' where class = '202' and struserid = @char3
    
92. update userdata set class = '103' where class = '203' and struserid = @char3
    
93. update userdata set class = '104' where class = '204' and struserid = @char3
    
94. update userdata set class = '112' where class = '212' and struserid = @char3
    
95. update userdata set class = '106' where class = '206' and struserid = @char3
    
96. update userdata set class = '108' where class = '208' and struserid = @char3
    
97. update userdata set class = '110' where class = '210' and struserid = @char3
    
98. update userdata set zone = '21',bind = '-1',px = '31900',pz = '40100',py = '0' where struserid = @char3
    
99. delete from knights where chief = @char3
    
100. delete from knights_user where sidnum = @clannumber3
     
101. delete from knights_rating where shindex = @clannumber3
     
102. update userdata set knights = 0, fame = 0 where knights = @clannumber3
     
103. update userdata set knights = 0, fame = 0 where struserid = @char1
     
104. update userdata set knights = 0, fame = 0 where struserid = @char2
     
105. update userdata set knights = 0, fame = 0 where struserid = @char3
     
106. Update knights set vicechief_1 = '' where vicechief_1 = @char1
     
107. Update knights set vicechief_2 = '' where vicechief_2 = @char1
     
108. Update knights set vicechief_3 = '' where vicechief_3 = @char1
     
109. Update knights set vicechief_1 = '' where vicechief_1 = @char2
     
110. Update knights set vicechief_2 = '' where vicechief_2 = @char2
     
111. Update knights set vicechief_3 = '' where vicechief_3 = @char2
     
112. Update knights set vicechief_1 = '' where vicechief_1 = @char3
     
113. Update knights set vicechief_2 = '' where vicechief_2 = @char3
     
114. Update knights set vicechief_3 = '' where vicechief_3 = @char3
     
115. delete from knights_user where struserid = @char1
     
116. delete from knights_user where struserid = @char2
     
117. delete from knights_user where struserid = @char3
     
118. 
     
119. commit tran
     
120. 
     
121. GO

复制代码

看不懂~~~先推再說

ssssssssssssssssssssssssssssss