Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE lin2world
- GO
- CREATE TABLE BannedHardwareId
- (
- [hardware_id] nvarchar(50) NOT NULL DEFAULT N'00000000000000000000000000000000',
- [account] nvarchar(25) NOT NULL DEFAULT N'',
- [gm] nvarchar(25) NOT NULL DEFAULT N'',
- [timeout] INT NOT NULL DEFAULT 0
- )
- GO
- CREATE PROCEDURE lin_BanHardwareId
- (
- @hwid NVARCHAR(50),
- @account AS nvarchar(25),
- @gm AS nvarchar(25),
- @timeout INT
- )
- AS
- SET NOCOUNT ON;
- BEGIN
- IF EXISTS(SELECT * FROM [dbo].[BannedHardwareId] WHERE [hardware_id] = @hwid)
- BEGIN
- UPDATE [BannedHardwareId] SET [account]=@account, [gm] = @gm, [timeout] = @timeout WHERE [hardware_id] = @hwid
- END
- ELSE
- BEGIN
- INSERT INTO [BannedHardwareId] ([hardware_id], [account], [gm], [timeout]) VALUES (@hwid, @account, @gm, @timeout)
- END
- END
- GO
- CREATE PROCEDURE lin_UnBanHardwareId
- (
- @hwid NVARCHAR(50)
- )
- AS
- SET NOCOUNT ON;
- DELETE FROM [BannedHardwareId] WHERE [hardware_id] = @hwid
- GO
- CREATE PROCEDURE lin_LoadBannedHardwareId
- AS
- SET NOCOUNT ON;
- SELECT [hardware_id], [account], [gm], [timeout] FROM [BannedHardwareId]
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement