菜鸟也好，新手也好，多搜搜论坛，都能找你到的东西。。

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

复制代码

收到~
但我已经自动二转了。嘎嘎

请问下这个怎么设置啊‘？  高手指教 QQ569030476

放在存储的那个表里？

謝謝  可以自動 2 轉了
自動 2 轉太好用了

3 跟 4 樓的
更改 LOAD_USER_DATA  這個檔案  照樓主的寫法就可以自動 2 轉了
轉人物 或 下線上來就直接 2 轉太好用了

语法错误啊`~~是哪里没有搞对?

樓上 會不會你復制錯誤  我試過了 語法沒錯哦~ 你在試試看

实验下，谢谢！

我已经更新了谢谢啊