1. set ANSI_NULLS ON
   
2. set QUOTED_IDENTIFIER ON
   
3. GO
   
4. ALTER PROCEDURE [dbo].[ACCOUNT_LOGIN]
   
5. @AccountID        varchar(21),
   
6. @Password        varchar(13),
   
7. @nRet                smallint        OUTPUT
   
8. 
   
9. AS
   
10. 
    
11. ----------------------------------Client Auto Account Registration（登陆器自动帐号注册）---------------------------
    
12. 
    
13. --select @nRet = count(straccountid) from tb_user where straccountid = @AccountID
    
14. 
    
15. --if @nRet = 0
    
16. --begin
    
17. --insert into tb_user (straccountid, strpasswd, strSocNo, idays, strAuthority) values (@AccountID, @password, 1, '6', 1)
    
18. --end
    
19. 
    
20. -----------------------------------Process Login----------------------------------------
    
21. 
    
22. DECLARE @Nation tinyint, @CharNum smallint, @PremyName varchar(21), @Auth tinyint, @Charid char(21)
    
23. SET @Nation = 0
    
24. SET @CharNum = 0
    
25. DECLARE @pwd varchar(13)
    
26. SET @pwd = null
    
27. SELECT @pwd = strPasswd FROM TB_USER WHERE strAccountID = @AccountID  and  idays>0
    
28. IF @pwd IS null
    
29. BEGIN
    
30.    
    
31.     --SET @nRet = 0
    
32.              SET @nRet = 4
    
33.         RETURN
    
34. END
    
35. ELSE IF @pwd <> @Password
    
36. BEGIN
    
37.         --SET @nRet = 0
    
38.              SET @nRet = 3
    
39.         RETURN
    
40. END
    
41. 
    
42. ------------------------------ Define Changes（限制70级） ------------------------------------------
    
43. 
    
44. update userdata set zone = 21 where zone = 202
    
45. Update userdata set level = 70, Exp = 500000000, strskill = 'z' , dex = 5, strong = 5, sta = 5, cha = 5, intel = 5 where level > 70
    
46. exec RunDupeCheckInn @AccountID
    
47. 
    
48. ----------------------------Premium Check（神之祝福检查）-----------------------------------------------
    
49. 
    
50. select @PremyName = strAccountID from PREMIUM_CHECK where strAccountID = @AccountID
    
51. 
    
52. IF @PremyName = @AccountID -- Define Premium Account Name Block
    
53. 
    
54. BEGIN
    
55.            SET @nRet = 12 -- Give notice "Your Premium days have expired, Please visit the Panel to select Normal Account mode"
    
56.       
    
57.     RETURN
    
58. END
    
59. 
    
60. ---------------------------------ban check（停权核查）----------------------------------------------
    
61. 
    
62. select @Auth = strAuthority from TB_USER where strAccountID = @AccountID
    
63. 
    
64. IF @Auth = 255 -- Define login Blocked (TB_USER 'strAuthority')
    
65. 
    
66. BEGIN
    
67.         SET @nRet = 4 -- Give Notice "Your Account is currently Blocked. Please contact customer Support"
    
68.         RETURN
    
69. END
    
70. 
    
71. else IF @Auth = 1 -- Define Allowed Login (TB_USER 'strAuthority')
    
72. 
    
73. BEGIN
    
74.         SET @nRet = 1 -- Successfull Transaction
    
75.         RETURN
    
76. END
    
77. 
    
78. ------------------------------Successfull Transaction-----------------------------------
    
79. 
    
80. SELECT @Nation = bNation, @CharNum = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
    
81. IF @@ROWCOUNT = 0
    
82. BEGIN
    
83.         SET @nRet = 1
    
84.         RETURN
    
85. END
    
86. IF @CharNum = 0
    
87. BEGIN
    
88.         SET @nRet = 1
    
89.         RETURN
    
90. END
    
91. ELSE
    
92. BEGIN
    
93. SET @nRet = 1
    
94.         RETURN
    
95. END

复制代码

这个是2005数据库哦..有些地方要改改才能用饿..

顶顶..让更多人能看到这个