-- ----------------------------
-- Procedure structure for [ADMIN_BanUser]
-- ----------------------------
ALTER PROCEDURE [dbo].[ADMIN_BanUser]
@in_CustomerID int,
@in_Reason VARCHAR(512)
AS
BEGIN
update UsersData set AccountStatus=202 WHERE CustomerID=@in_CustomerID
update UsersData set BanReason=@in_Reason WHERE CustomerID=@in_CustomerID
-- clear his login session
update LoginSessions set SessionID=0 where CustomerID=@in_CustomerID
-- Insert to BanLog
insert into dbo.DBG_BanLog values (@in_CustomerID, GETDATE(), 300, @in_Reason)
declare @IP varchar(100)
declare @mac varchar(100)
declare @miniACRC varchar(50)
SELECT @IP=ip, @mac=mac @miniACRC=MiniACRC FROM LoginLog WHERE CustomerID = @in_CustomerID
INSERT INTO dbo.HWID_Log (CustomerID, ip, HardwareID, Team)
VALUES
(@in_CustomerID, @IP, [COLOR="#FF0000" @mac[/COLOR], GETDATE())
INSERT INTO dbo.HWID_Ban (HardwareID, Reason)
VALUES
([COLOR="#FF0000" @mac[/COLOR], @in_Reason)
select 0 as ResultCode
END
-- resault
HardwareID = 0x1fae8fb7eXXX
reason = Reason XXX
- - - Updated - - -
MiniACRC has "0" alway


Reply With Quote![[help] how to fix auto ban (hwid_ban by new dnc)](http://ragezone.com/hyper728.png)


