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
-- 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:
Code:
-- ----------------------------
-- 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
-- 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
