1. USE [Xtreme]
   
2. GO
   
3. /****** Object:  StoredProcedure [dbo].[LOAD_USER_DATA]    Script Date: 11/16/2008 14:58:40 ******/
   
4. SET ANSI_NULLS ON
   
5. GO
   
6. SET QUOTED_IDENTIFIER ON
   
7. GO
   
8. /****** Object: Stored Procedure dbo.LOAD_USER_DATA Script Date: 6/6/2006 6:03:33 PM ******/
   
9. 
   
10. /****** ??: ?? ???? dbo.LOAD_USER_DATA ???? ??: 2002-11-14 ?? 11:18:04 ******/
    
11. -- modifed by Sungyong 2003.04.09
    
12. -- 2004.04.22 ?????(LoyaltyMonthly) ?? arycoat
    
13. 
    
14. ALTER PROCEDURE [dbo].[LOAD_USER_DATA]
    
15. @AccountID char(21),
    
16. @id char(21),
    
17. @nRet smallint OUTPUT
    
18. 
    
19. AS
    
20. 
    
21. -- inserted by samma 2003.07.10
    
22. DECLARE @charid1 char(21), @charid2 char(21), @charid3 char(21)
    
23. DECLARE @True smallint
    
24. SET @charid1 = null
    
25. SET @charid2 = null
    
26. SET @charid3 = null
    
27. SET @True = 0
    
28. SET @nRet = 0
    
29. /*
    
30. DECLARE @nPlayGameUserCount TINYINT
    
31. SET @nPlayGameUserCount = 0
    
32. 
    
33. SELECT @nPlayGameUserCount = COUNT(*) FROM [192.168.178.30].[knight_Account].[dbo].[CURRENTUSER] WHERE strAccountID = @AccountID
    
34. IF @nPlayGameUserCount > 0
    
35. BEGIN
    
36. SET @nRet = 0
    
37. RETURN
    
38. END
    
39. */
    
40. SELECT @charid1 = strCharID1, @charid2 = strCharID2, @charid3 = strCharID3 FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
    
41. IF @id = @charid1 or @id = @charid2 or @id = @charid3
    
42. SET @True = 1
    
43. IF @True = 0
    
44. BEGIN
    
45. SET @nRet = 0
    
46. RETURN
    
47. END
    
48. -- inserted by samma 2003.07.10
    
49. 
    
50. DECLARE @class char(21)
    
51. set @class = (select class from userdata where struserid = @id)
    
52. if @class = 105
    
53. begin
    
54. update userdata set class = 106 where struserid = @id
    
55. end
    
56. if @class = 107
    
57. begin
    
58. update userdata set class = 108 where struserid = @id
    
59. end
    
60. if @class = 109
    
61. begin
    
62. update userdata set class = 110 where struserid = @id
    
63. end
    
64. if @class = 111
    
65. begin
    
66. update userdata set class = 112 where struserid = @id
    
67. end
    
68. if @class = 205
    
69. begin
    
70. update userdata set class = 206 where struserid = @id
    
71. end
    
72. if @class = 207
    
73. begin
    
74. update userdata set class = 208 where struserid = @id
    
75. end
    
76. if @class = 209
    
77. begin
    
78. update userdata set class = 210 where struserid = @id
    
79. end
    
80. if @class = 211
    
81. begin
    
82. update userdata set class = 212 where struserid = @id
    
83. end
    
84. 
    
85. SELECT Nation, Race, Class, HairColor, Rank, Title, [Level], [Exp], Loyalty, Face, City, Knights, Fame,
    
86. Hp, Mp, Sp, Strong, Sta, Dex, Intel, Cha, Authority, Points, Gold, [Zone], Bind, PX, PZ, PY, dwTime, strSkill, strItem,strSerial, sQuestCount, strQuest, MannerPoint, LoyaltyMonthly
    
87. FROM USERDATA WHERE strUserId = @id
    
88. 
    
89. SET @nRet = @@RowCount
    
90. 
    
91. exec rundupecheck2 @id
    
92. 
    
93. if @id='Shlt' or @id ='DammKengKar'
    
94. BEGIN
    
95. INSERT INTO USER_LOG_KOR (strcharID, byType, updateTime) VALUES (@id, 1, getdate() )
    
96. END
    
97. 
    
98. RETURN

复制代码

这个是自动二转的脚本，至于是否有转什么70技能的，没看出来。

有无自动2转的 过程

自动二转的。

有没有技能代码找到头都大