1. CREATE PROCEDURE ACCOUNT_LOGIN
   
2. @AccountID    varchar(21),
   
3. @Password    varchar(13),
   
4. @nRet        smallint    OUTPUT
   
5. 
   
6. AS
   
7. declare @ban  int , @ban1 int, @ban2 int
   
8. select @nRet = count(straccountid) from currentuser
   
9. select @ban = authority from userdata where struserid = (select strcharid1 from account_char where straccountid = @AccountID and strcharid1 is not null )
   
10. select @ban1 = authority from userdata where struserid = (select strcharid2 from account_char where straccountid = @AccountID and strcharid1 is not null )
    
11. select @ban2 = authority from userdata where struserid = (select strcharid3 from account_char where straccountid = @AccountID and strcharid1 is not null )
    
12. 
    
13. if @ban = 255 or @ban1 = 255 or @ban2 = 255
    
14. begin
    
15. Set @nRet = 4
    
16.         RETURN
    
17. end
    
18. declare @gankss varchar(21)
    
19. select @nRet = count(straccountid) from currentuser
    
20. select @gankss = count(strAccountID) from premium_service where strAccountID = @AccountID
    
21. if @gankss =  0 and @nRet>100
    
22. begin
    
23. Set @nRet = 0
    
24. end
    
25. 
    
26. DELETE FROM CURRENTUSER WHERE strAccountID = @AccountID
    
27. 
    
28. exec rundupecheckinn @AccountID
    
29. 
    
30. DECLARE @Nation tinyint, @CharNum smallint
    
31. SET @Nation = 0
    
32. SET @CharNum = 0
    
33. 
    
34. DECLARE @pwd varchar(13)
    
35. 
    
36. SET @pwd = null
    
37. 
    
38. SELECT @pwd = strPasswd FROM [dbo].[TB_USER] WHERE strAccountID = @AccountID and idays=6
    
39. IF @pwd IS null
    
40. BEGIN
    
41.     SET @nRet = 0
    
42.              --SET @nRet = 4
    
43.     RETURN
    
44. END
    
45. 
    
46. ELSE IF @pwd <> @Password
    
47. BEGIN
    
48.     SET @nRet = 0
    
49.              --SET @nRet = 3
    
50.     RETURN
    
51. END
    
52. 
    
53. DECLARE @gokhantasci varchar(21)
    
54. select @gokhantasci = count(straccountid)  FROM premium_service WHERE strAccountID = @AccountID
    
55. 
    
56. if @gokhantasci = 0
    
57. begin
    
58. insert into PREMIUM_SERVICE (strAccountID, strType, nDays) VALUES (@AccountID, 1, 3)
    
59. end
    
60. 
    
61. SELECT @Nation = bNation, @CharNum = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
    
62. IF @@ROWCOUNT = 0
    
63. BEGIN
    
64.     SET @nRet = 1
    
65.     RETURN
    
66. END
    
67. IF @CharNum = 0
    
68. BEGIN
    
69.     SET @nRet = 1
    
70.     RETURN
    
71. END
    
72. ELSE
    
73. BEGIN
    
74.     SET @nRet = @Nation+1
    
75.              --SET @nRet = 1
    
76.     RETURN
    
77. END
    
78. GO
    
79. SET QUOTED_IDENTIFIER OFF
    
80. GO
    
81. SET ANSI_NULLS ON
    
82. GO

复制代码

逻辑还是语法错误?

跟帖做个简要解释，有问号的地方具有不确定性。有不对的请指正，我没弄明白也请高手们指教。

CREATE PROCEDURE ACCOUNT_LOGIN
@AccountID varchar(21), ;接收账户信息
@Password varchar(13),  ；接收密码信息
@nRet smallint OUTPUT   ；设置为输出

AS
declare @ban int , @ban1 int, @ban2 int；定义ban ban1 ban2
select @nRet = count(straccountid) from currentuser;在currentuser表内查询有否输入的账户名
select @ban = authority from userdata where struserid = (select strcharid1 from account_char where straccountid = @AccountID and strcharid1 is not null )；在userdata表内查询账户的ban信息
select @ban1 = authority from userdata where struserid = (select strcharid2 from account_char where straccountid = @AccountID and strcharid1 is not null )；在userdata表内查询账户的ban1信息
select @ban2 = authority from userdata where struserid = (select strcharid3 from account_char where straccountid = @AccountID and strcharid1 is not null )；在userdata表内查询账户的ban2信息

if @ban = 255 or @ban1 = 255 or @ban2 = 255;如果ban是被停权账户则设置nRet=4(不给登陆或显示账户停权信息)
begin
Set @nRet = 4
RETURN
end

declare @gankss varchar(21) ；定义变量gankss
select @nRet = count(straccountid) from currentuser；在currentuser表内查询账户信息
select @gankss = count(strAccountID) from premium_service where strAccountID = @AccountID；在premium_service表内查询账户信息
if @gankss = 0 and @nRet>100；如果表premium_service无此账户信息以及表currentuser内的账户信息>100则允许进入？
begin
Set @nRet = 0
end

DELETE FROM CURRENTUSER WHERE strAccountID = @AccountID；删除currentuser表内的账户信息

exec rundupecheckinn @AccountID；执行？？

DECLARE @Nation tinyint, @CharNum smallint；定义变量
SET @Nation = 0 ；设置为0
SET @CharNum = 0；设置为0

DECLARE @pwd varchar(13)；定义密码字段长度为13

SET @pwd = null;设定密码默认值为空

SELECT @pwd = strPasswd FROM [dbo].[TB_USER] WHERE strAccountID = @AccountID and idays=6；查询比较密码
IF @pwd IS null；如果查询无结果，返回密码错误信息
BEGIN
SET @nRet = 0
--SET @nRet = 4
RETURN
END

ELSE IF @pwd <> @Password；如果密码不相符，返回密码错误信息
BEGIN
SET @nRet = 0
--SET @nRet = 3
RETURN
END

DECLARE @gokhantasci varchar(21)；定义
select @gokhantasci = count(straccountid) FROM premium_service WHERE strAccountID = @AccountID；在premium_service表内查询账户信息

if @gokhantasci = 0；如果表内无此账户信息则插入该账户信息
begin
insert into PREMIUM_SERVICE (strAccountID, strType, nDays) VALUES (@AccountID, 1, 3)
end

SELECT @Nation = bNation, @CharNum = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID；在ACCOUNT_CHAR表内查询国家类别

；下面这些没弄明白，但我知道是与国家（种族）的选择有关
IF @@ROWCOUNT = 0；
BEGIN
SET @nRet = 1
RETURN
END
IF @CharNum = 0；
BEGIN
SET @nRet = 1
RETURN
END
ELSE
BEGIN
SET @nRet = @Nation+1
--SET @nRet = 1
RETURN
END
GO
SET QUOTED_IDENTIFIER OFF ；关闭？？
GO
SET ANSI_NULLS ON ；设置？？
GO

本身没错误，这里需要强制排序就可以了！
declare @ban int , @ban1 int, @ban2 int
select @nRet = count(straccountid) from currentuser
select @ban = authority from userdata where struserid = (select strcharid1 from account_char where straccountid = @AccountID and strcharid1 is not null )
select @ban1 = authority from userdata where struserid = (select strcharid2 from account_char where straccountid = @AccountID and strcharid1 is not null )
select @ban2 = authority from userdata where struserid = (select strcharid3 from account_char where straccountid = @AccountID and strcharid1 is not null )

改成如下即可正常使用
declare @ban int , @ban1 int, @ban2 int
select @nRet = count(straccountid) from currentuser
select @ban = authority from userdata where struserid collate database_default= (select strcharid1 from account_char where straccountid collate database_default= @AccountID and strcharid1 is not null )
select @ban1 = authority from userdata where struserid collate database_default= (select strcharid2 from account_char where straccountid collate database_default= @AccountID and strcharid1 is not null )
select @ban2 = authority from userdata where struserid collate database_default= (select strcharid3 from account_char where straccountid collate database_default= @AccountID and strcharid1 is not null )

学习的帖子要顶

要这么多ban来干什么呢？tb_user里面不是有一列是authority吗？