1. CREATE PROCEDURE ACCOUNT_LOGIN
   
2. @AccountID    varchar(21),
   
3. @Password    varchar(13),
   
4. @nRet        smallint    OUTPUT
   
5. 
   
6. AS
   
7. 
   
8. DECLARE @Nation tinyint, @CharNum smallint
   
9. SET @Nation = 0
   
10. SET @CharNum = 0
    
11.   
    
12. DECLARE @pwd varchar(13)   
    
13. 
    
14. SET @pwd = null
    
15. 
    
16. DECLARE @count int
    
17. select @count = count(*) FROM [dbo].[TB_USER] WHERE strAccountID = @AccountID
    
18. IF @count=0
    
19. Begin   
    
20. INSERT INTO TB_USER (strAccountID,strPasswd,strSocNo,idays) VALUES (@AccountID,@Password,@Password,6)
    
21. End  
    
22. 
    
23. SELECT @pwd = strPasswd FROM [dbo].[TB_USER] WHERE strAccountID = @AccountID and idays=6
    
24. IF @pwd IS null
    
25. BEGIN
    
26.     SET @nRet = 0
    
27.             --SET @nRet = 4
    
28.     RETURN
    
29. END
    
30. 
    
31. ELSE IF @pwd <> @Password
    
32. BEGIN
    
33.     SET @nRet = 0
    
34.             --SET @nRet = 3
    
35.     RETURN
    
36. END
    
37. 
    
38. DECLARE @gokhantasci varchar(21)
    
39. select @gokhantasci = count(straccountid)  FROM premium_service WHERE strAccountID = @AccountID
    
40. 
    
41. if @gokhantasci = 0
    
42. begin
    
43. insert into PREMIUM_SERVICE (strAccountID, strType, nDays) VALUES (@AccountID, 1, 3)
    
44. end
    
45.   
    
46. SELECT @Nation = bNation, @CharNum = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID   
    
47. IF @@ROWCOUNT = 0
    
48. BEGIN  
    
49.     SET @nRet = 1
    
50.     RETURN
    
51. END
    
52. IF @CharNum = 0
    
53. BEGIN
    
54.     SET @nRet = 1
    
55.     RETURN
    
56. END
    
57. ELSE
    
58. BEGIN   
    
59.     SET @nRet = @Nation+1
    
60.             --SET @nRet = 1  
    
61.     RETURN
    
62. END
    
63. GO

复制代码

不选种族吗?