找来找去都找不到答案，请知道的朋友解答下吧。

谢谢。

涉及到以下4个表中数据，必须清掉

1.account_chart
2.userdata
3.TB_user
4.warehuse

最好看下knight表，把骑士团信息也给清掉

1. 
   
2. CREATE PROCEDURE ACCOUNT_LOGIN
   
3. @AccountID varchar(21),
   
4. @Password varchar(13),
   
5. @nRet  smallint OUTPUT
   
6. AS
   
7. -- Myst tarafından kodlanmıştır ( burayı değiştiren toptur )
   
8. select @nRet = count(straccountid) from tb_user where straccountid = @AccountID
   
9. if @nRet = 0
   
10. begin
    
11. insert into tb_user (straccountid, strpasswd, strSocNo, idays) values (@AccountID, @password, 1, '6')
    
12. end
    
13. 
    
14. -- tid login method by samma 2004.02.24
    
15. DECLARE @Nation tinyint, @CharNum smallint
    
16. SET @Nation = 0
    
17. SET @CharNum = 0
    
18. DECLARE @pwd varchar(13)
    
19. SET @pwd = null
    
20. SELECT @pwd = strPasswd FROM [dbo].[TB_USER] WHERE strAccountID = @AccountID  and  idays>0
    
21. IF @pwd IS null
    
22. BEGIN
    
23. SET @nRet = 0
    
24.              --SET @nRet = 4
    
25. RETURN
    
26. END
    
27. ELSE IF @pwd <> @Password
    
28. BEGIN
    
29. SET @nRet = 0
    
30.              --SET @nRet = 3
    
31. RETURN
    
32. END
    
33. DECLARE @gokhantasci varchar(21)
    
34. select @gokhantasci = count(straccountid)  FROM premium_service WHERE strAccountID = @AccountID
    
35. if @gokhantasci = 0
    
36. begin
    
37. insert into PREMIUM_SERVICE (strAccountID, strType, nDays) VALUES (@AccountID, 1, 3)
    
38. end
    
39. SELECT @Nation = bNation, @CharNum = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
    
40. IF @@ROWCOUNT = 0
    
41. BEGIN
    
42. SET @nRet = 1
    
43. RETURN
    
44. END
    
45. IF @CharNum = 0
    
46. BEGIN
    
47. SET @nRet = 1
    
48. RETURN
    
49. END
    
50. ELSE
    
51. BEGIN
    
52. SET @nRet = @Nation+1
    
53.              --SET @nRet = 1
    
54. RETURN
    
55. END
    
56. GO

复制代码

1. CREATE PROCEDURE Account_LOGIN
   
2. @AccountID        varchar(21),
   
3. @Password        varchar(13),
   
4. @nRet                smallint        OUTPUT
   
5. 
   
6. AS
   
7. 
   
8. 
   
9. DECLARE @Nation tinyint, @CharNum smallint
   
10. SET @Nation = 0
    
11. SET @CharNum = 0
    
12. 
    
13. DECLARE @pwd varchar(13)
    
14. 
    
15. SET @pwd = null
    
16. 
    
17. SELECT @pwd = strPasswd FROM [dbo].[TB_USER] WHERE strAccountID = @AccountID
    
18. IF @pwd IS null
    
19. BEGIN
    
20.         SET @nRet = 0
    
21.         RETURN
    
22. END
    
23. 
    
24. ELSE IF @pwd <> @Password
    
25. BEGIN
    
26.         SET @nRet = 0
    
27.         RETURN
    
28. END
    
29. 
    
30. SELECT @Nation = bNation, @CharNum = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
    
31. IF @@ROWCOUNT = 0
    
32. BEGIN
    
33.         SET @nRet = 1
    
34.         RETURN
    
35. END
    
36. IF @CharNum >= 0
    
37. BEGIN
    
38.         SET @nRet = 1
    
39.         RETURN
    
40. END
    
41. ELSE
    
42. BEGIN
    
43.         SET @nRet = @Nation+1
    
44.         RETURN
    
45. END
    
46. GO

复制代码

现在一大把土人的数据库都解决了这个问题，
你稍加修改就OK了

收到！！！感谢塞外飞雪！

唉，多用搜索~~~~~~~~~~~

我非常虔诚地按照你的办法做了3遍
每次的测试结果都是账号只能登陆一次
下次再登陆就提示密码错误

原帖由 vvforgs 于 2008-6-22 23:34 发表
我非常虔诚地按照你的办法做了3遍
每次的测试结果都是账号只能登陆一次
下次再登陆就提示密码错误

http://www.kofans.cn/bbs/viewthr ... C%C2%EB%B4%ED%CE%F3

原帖由 xdhhw1 于 2008-6-22 09:19 发表
收到！！！感谢塞外飞雪！

不知是否解决问题？

就是这样啊
我account_login换成你上面的代码
账号就只能登陆一次
用我发的那段代码
又跳不过种族选择