你用哪個庫老外新庫嗎?

對~~用了登入還是資料會消失 = =!

就是有3.0武器的庫? 我改了可以保存物品技能 正常 中文顯示= =

那種族重複選擇呢??
你是下載哪一個資料庫的押?

目前已經解決物品保存的問題！

種族重複尚未解決><"有高手解決哩嗎~~

目前用置頂的三個數據都會重複選擇種族....
老外的缺地圖檔.............
至頂的兩個數據也是一樣><"

[ 本帖最后由 jiji0513 于 2008-11-12 11:14 编辑 ]

1. 修改存储过程
   
2. CREATE PROCEDURE ACCOUNT_LOGIN
   
3. @AccountID varchar(21),
   
4. @Password varchar(13),
   
5. @nRet smallint OUTPUT
   
6. 
   
7. AS
   
8. 
   
9. 
   
10. DECLARE @Nation tinyint, @CharNum smallint
    
11. SET @Nation = 0
    
12. SET @CharNum = 0
    
13. 
    
14. DECLARE @pwd varchar(13)
    
15. 
    
16. SET @pwd = null
    
17. 
    
18. SELECT @pwd = strPasswd FROM [dbo].[TB_USER] WHERE strAccountID = @AccountID and idays=6
    
19. IF @pwd IS null
    
20. BEGIN
    
21. SET @nRet = 0
    
22. --SET @nRet = 4
    
23. RETURN
    
24. END
    
25. 
    
26. ELSE IF @pwd <> @Password
    
27. BEGIN
    
28. SET @nRet = 0
    
29. --SET @nRet = 3
    
30. RETURN
    
31. END
    
32. 
    
33. DECLARE @gokhantasci varchar(21)
    
34. select @gokhantasci = count(straccountid) FROM premium_service WHERE strAccountID = @AccountID
    
35. 
    
36. if @gokhantasci = 0
    
37. begin
    
38. insert into PREMIUM_SERVICE (strAccountID, strType, nDays) VALUES (@AccountID, 1, 3)
    
39. end
    
40. 
    
41. SELECT @Nation = bNation, @CharNum = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
    
42. IF @@ROWCOUNT = 0
    
43. BEGIN
    
44. SET @nRet = 1
    
45. RETURN
    
46. END
    
47. IF @CharNum = 0
    
48. BEGIN
    
49. SET @nRet = 1
    
50. RETURN
    
51. END
    
52. ELSE
    
53. BEGIN
    
54. SET @nRet = @Nation+1
    
55. --SET @nRet = 1
    
56. RETURN
    
57. END
    
58. GO
    
59. 
    
60. 
    
61. ==========================
    
62. 
    
63. CREATE PROCEDURE MYST_LOGIN
    
64. @AccountID varchar(21),
    
65. @Password varchar(13),
    
66. @nRet smallint OUTPUT
    
67. 
    
68. AS
    
69. 
    
70. 
    
71. DECLARE @Nation tinyint, @CharNum smallint
    
72. SET @Nation = 0
    
73. SET @CharNum = 0
    
74. 
    
75. DECLARE @pwd varchar(13)
    
76. 
    
77. SET @pwd = null
    
78. 
    
79. SELECT @pwd = strPasswd FROM [dbo].[TB_USER] WHERE strAccountID = @AccountID
    
80. IF @pwd IS null
    
81. BEGIN
    
82. SET @nRet = 0
    
83. RETURN
    
84. END
    
85. 
    
86. ELSE IF @pwd <> @Password
    
87. BEGIN
    
88. SET @nRet = 0
    
89. RETURN
    
90. END
    
91. 
    
92. SELECT @Nation = bNation, @CharNum = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
    
93. IF @@ROWCOUNT = 0
    
94. BEGIN
    
95. SET @nRet = 1
    
96. RETURN
    
97. END
    
98. IF @CharNum >= 0
    
99. BEGIN
    
100. SET @nRet = 1
     
101. RETURN
     
102. END
     
103. ELSE
     
104. BEGIN
     
105. SET @nRet = @Nation+1
     
106. RETURN
     
107. END
     
108. GO

复制代码

我是使用完整端-带中文补丁-登陆器-地图-基本不用修改的服務端和數據....
改完登入遊戲出現密碼不符~~由於我沒有此儲存過程MYST_LOGIN我把他用新增的....
然後修改ACCOUNT_LOGIN....AU則使用置頂的myAujard

[ 本帖最后由 jiji0513 于 2008-11-12 20:10 编辑 ]

不懂`~你说的那个我跟本无法用``

排序规则不知道在哪去修改，能指点下么