Advertisement
Guest User

Update - new antibot.

a guest
Aug 21st, 2013
606
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.08 KB | None | 0 0
  1. USE lin2world
  2. GO
  3.  
  4.  
  5. CREATE TABLE BannedHardwareId
  6.     (
  7.     [hardware_id] nvarchar(50) NOT NULL DEFAULT N'00000000000000000000000000000000',
  8.     [account] nvarchar(25) NOT NULL DEFAULT N'',
  9.     [gm] nvarchar(25) NOT NULL DEFAULT N'',
  10.     [timeout] INT NOT NULL DEFAULT 0
  11.     )  
  12. GO
  13.  
  14. CREATE PROCEDURE lin_BanHardwareId
  15. (
  16.  @hwid NVARCHAR(50),
  17.  @account AS nvarchar(25),
  18.  @gm AS nvarchar(25),
  19.  @timeout INT
  20. )
  21. AS
  22.  
  23. SET NOCOUNT ON;
  24. BEGIN
  25.     IF EXISTS(SELECT * FROM [dbo].[BannedHardwareId] WHERE [hardware_id] = @hwid)
  26.     BEGIN
  27.         UPDATE [BannedHardwareId] SET [account]=@account, [gm] = @gm, [timeout] = @timeout WHERE [hardware_id] = @hwid
  28.     END
  29.     ELSE
  30.     BEGIN
  31.         INSERT INTO [BannedHardwareId] ([hardware_id], [account], [gm], [timeout]) VALUES (@hwid, @account, @gm, @timeout)
  32.     END
  33. END
  34. GO
  35.  
  36. CREATE PROCEDURE lin_UnBanHardwareId
  37. (
  38.  @hwid NVARCHAR(50)
  39. )
  40. AS
  41.  
  42. SET NOCOUNT ON;
  43.  
  44. DELETE FROM [BannedHardwareId] WHERE [hardware_id] = @hwid
  45.  
  46. GO
  47.  
  48.  
  49. CREATE PROCEDURE lin_LoadBannedHardwareId
  50. AS
  51.  
  52. SET NOCOUNT ON;
  53.  
  54. SELECT [hardware_id], [account], [gm], [timeout] FROM [BannedHardwareId]
  55.  
  56. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement