[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

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 [USER=213273]email[/USER] varchar(128)
	select [USER=213273]email[/USER]=email from dbo.Accounts where CustomerID=@in_CustomerID


	declare [USER=1333348643]Hashed[/USER]mac varchar(MAX)
	declare [USER=1333401759]Process[/USER]orID varchar(MAX)
	declare [USER=439582]MotherBoard[/USER]ID varchar(MAX)
	declare @GPUID varchar(MAX)
	declare [USER=1333449671]HardDisk[/USER]ID varchar(MAX)
	declare [USER=1333442691]Osi[/USER]D varchar(MAX)
	declare [USER=769759]Reason[/USER] varchar(MAX)
	select 
	 [USER=1333348643]Hashed[/USER]mac=MAChash, 
	 [USER=1333401759]Process[/USER]orID=ProcessorID,
	 [USER=439582]MotherBoard[/USER]ID=MotherboardID, 
		@GPUID=GPUID, 
	 [USER=1333449671]HardDisk[/USER]ID=HardDiskID, 
	 [USER=1333442691]Osi[/USER]D=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 [USER=769759]Reason[/USER] is null) set [USER=769759]Reason[/USER] = [USER=769759]Reason[/USER]
	else                   set [USER=769759]Reason[/USER] = [USER=769759]Reason[/USER] + ', ' + [USER=769759]Reason[/USER]
	-- ban
	begin
		insert into dbo.HardwareBan values  [USER=213273]email[/USER], [USER=1333348643]Hashed[/USER]mac, @in_banned_by, @in_end_date, @in_reason, [USER=1333401759]Process[/USER]orID, [USER=439582]MotherBoard[/USER]ID, @GPUID, [USER=1333449671]HardDisk[/USER]ID, [USER=1333442691]Osi[/USER]D)
		select 0 as ResultCode, 'Permanent BAN' as ResultMsg, [USER=213273]email[/USER] as 'email'
		return
	end
END

 

[JohnzBallad]

Could you release [AGAIN[ the HunZ src?