Human NT

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

复制代码

Karus NT

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

复制代码

[HOWTO]
如果你的账号 lol = RR, 转兽
在查询器里面输入

1. exec KarusNT 'lol'

复制代码

反之

1. exec HumanNT 'lol'

复制代码

楼主这个是 游戏里通过NPC互转的？

先退游戏，自己在查询器里输入代码就行了

不错啊

楼主上面我看了很好用
但是唯一一点

比如 S女法师我要转R法师，但是执行你的代码后，都回转成R女法师。

同样，Rjs，执行代码后都会转为S女祭司！

请问怎么解决？