If you want to make a Pay 2 Play server, add this account login Procedure or Update your own:

1. USE [KN_ONLINE]
   
2. set ANSI_NULLSON
   
3. set QUOTED_IDENTIFIERON
   
4. ---------- //Created by Zenocide// ---------
   
5. GO
   
6. 
   
7. CREATE PROCEDURE [dbo].[ACCOUNT_LOGIN]
   
8. 
   
9. @AccountID varchar(21),
   
10. @Password varchar(13),
    
11. @nRet smallintOUTPUT
    
12. 
    
13. AS
    
14. 
    
15. DECLARE @Nation tinyint, @CharNum smallint, @PremyName varchar(21)
    
16. 
    
17. -----------------------------------Process Login----------------------------------------
    
18. SET @Nation = 0
    
19. SET @CharNum = 0
    
20. DECLARE @pwd varchar(13)
    
21. SET @pwd =null
    
22. SELECT @pwd = strPasswd FROM TB_USER WHERE strAccountID = @AccountID and idays>0
    
23. IF @pwd ISnull
    
24. BEGIN
    
25. 
    
26. --SET @nRet = 0
    
27. SET @nRet = 4
    
28. RETURN
    
29. END
    
30. ELSEIF @pwd <> @Password
    
31. BEGIN
    
32. --SET @nRet = 0
    
33. SET @nRet = 3
    
34. RETURN
    
35. END
    
36. ----------------------------Premium Check-----------------------------------------------
    
37. select @PremyName = strAccountID from PremiumCheck where strAccountID = @AccountID
    
38. IF @PremyName = @AccountID -- Define Premium Account Name Check
    
39. BEGIN
    
40. SET @nRet = 12 -- Give notice, edit in texts.tbl
    
41. RETURN
    
42. END
    
43. 
    
44. ------------------------------Successfull Transaction-----------------------------------
    
45. SELECT @Nation = bNation, @CharNum = bCharNum FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
    
46. IF@@ROWCOUNT= 0
    
47. BEGIN
    
48. SET @nRet = 1
    
49. RETURN
    
50. END
    
51. IF @CharNum = 0
    
52. BEGIN
    
53. SET @nRet = 1
    
54. RETURN
    
55. END
    
56. ELSE
    
57. BEGIN
    
58. SET @nRet = 1
    
59. RETURN
    
60. END
    

复制代码

Next you will need to add a new Table, add the Following.

1. USE [KN_online]
   
2. GO
   
3. /****** Object:  Table [dbo].[PremiumCheck]    Script Date: 09/26/2008 11:07:28 ******/
   
4. SET ANSI_NULLS ON
   
5. GO
   
6. SET QUOTED_IDENTIFIER ON
   
7. GO
   
8. SET ANSI_PADDING ON
   
9. GO
   
10. CREATE TABLE [dbo].[PremiumCheck](
    
11. [strAccountID] [varchar](21) COLLATE Latin1_General_CI_AI NOT NULL
    
12. ) ON [PRIMARY]
    
13. GO
    
14. SET ANSI_PADDING OFF

复制代码

You now have a Pay 2 Play server, depending on the structure of your premium scripts/procedures you can add other checks e.g to auto insert a users id who buys premium and to Auto remove the user when they have no more premium days.

I will let you figure this one out, its quiet easy.

To block a user manually just simpily enter there accountid into the PremimCheck table.