[Release] [HunZSRC] Ban trough HWID procedure

[DarkAngelBR]

Ok, so i made this after germany won the game making 7x1 in brazil #GODeutshcland
It's a semi-auto procedure to ban the hwid of the player using HunZ src (yeap, nothing special), you just need to enter the CID, reason, and banned by things. OFC you can make a php script for it if you want to make it more practice that already is
So, here it's

Spoiler:

-- ----------------------------
-- Procedure structure for [ADMIN_BanUserHWID BY Dark from apocalypticworldmmo.com LOLOLOL]
-- ----------------------------


CREATE PROCEDURE [dbo].[ADMIN_BanUserHWID]
@in_CustomerID int,
@in_reason varchar(MAX),
-- @in_end_date datetime
@in_banned_by nvarchar(256)
AS
BEGIN
SET NOCOUNT ON;
declare @email varchar(128)
select @email=email from dbo.Accounts where CustomerID=@in_CustomerID


declare @Hashedmac varchar(MAX)
declare @ProcessorID varchar(MAX)
declare @MotherBoardID varchar(MAX)
declare @GPUID varchar(MAX)
declare @HardDiskID varchar(MAX)
declare @OsiD varchar(MAX)
declare @Reason varchar(MAX)
select
@Hashedmac=MAChash,
@ProcessorID=ProcessorID,
@MotherBoardID=MotherboardID,
@GPUID=GPUID,
@HardDiskID=HardDiskID,
@OsiD=OSID
from dbo.Accounts where CustomerID=@in_CustomerID


-- clear his login session
update dbo.LoginSessions set SessionID=0 where CustomerID=@in_CustomerID

-- set his all alive chars to respawned mode
update dbo.UsersChars set Alive=2 where CustomerID=@in_CustomerID and Alive=1


if @Reason is null) set @Reason = @Reason
else set @Reason = @Reason + ', ' + @Reason
-- ban
begin
insert into dbo.HardwareBan values @email, @Hashedmac, @in_banned_by, 2999, @in_reason, @ProcessorID, @MotherBoardID, @GPUID, @HardDiskID, @OsiD)
select 0 as ResultCode, 'Permanent BAN' as ResultMsg, @email as 'email'
return
end
END

- - - Updated - - -

I think that something is wrong with that thread, can't edit it lol.
Here's the script with bantime (for example 2015-07-08 [Today])

Spoiler:

-- ----------------------------
-- Procedure structure for [ADMIN_BanUserHWID BY Dark from apocalypticworldmmo.com added bantime]
-- ----------------------------


ALTER PROCEDURE [dbo].[ADMIN_BanUserHWID]
	@in_CustomerID int,
	@in_reason varchar(MAX),
	@in_end_date datetime
	@in_banned_by nvarchar(256)
AS
BEGIN
	SET NOCOUNT ON;
	declare @email varchar(128)
	select @email=email from dbo.Accounts where CustomerID=@in_CustomerID


	declare @Hashedmac varchar(MAX)
	declare @ProcessorID varchar(MAX)
	declare @MotherBoardID varchar(MAX)
	declare @GPUID varchar(MAX)
	declare @HardDiskID varchar(MAX)
	declare @OsiD varchar(MAX)
	declare @Reason varchar(MAX)
	select 
	 @Hashedmac=MAChash, 
	 @ProcessorID=ProcessorID,
	 @MotherBoardID=MotherboardID, 
		@GPUID=GPUID, 
	 @HardDiskID=HardDiskID, 
	 @OsiD=OSID
	from dbo.Accounts where CustomerID=@in_CustomerID


	-- clear his login session
	update dbo.LoginSessions set SessionID=0 where CustomerID=@in_CustomerID
	
	-- set his all alive chars to respawned mode
	update dbo.UsersChars set Alive=2 where CustomerID=@in_CustomerID and Alive=1


	if @Reason is null) set @Reason = @Reason
	else                   set @Reason = @Reason + ', ' + @Reason
	-- ban
	begin
		insert into dbo.HardwareBan values  @email, @Hashedmac, @in_banned_by, @in_end_date, @in_reason, @ProcessorID, @MotherBoardID, @GPUID, @HardDiskID, @OsiD)
		select 0 as ResultCode, 'Permanent BAN' as ResultMsg, @email as 'email'
		return
	end
END

[MentaL]

[JohnzBallad]

Could you release [AGAIN[ the HunZ src?