如题~~~~~~~~~~~~~~
因为本人技术有限！
不能自己弄自动二转。
要是有好心人帮忙。那最好不过了
现在急用先找代码解决问题！！！！！！！！！！
知道的希望帮帮小弟我！
万分感谢

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

复制代码

谢谢CT！！
但是小弟不会弄。呵呵
找高人帮忙去

学习中。。。。受教了