Need Help Ban

[xxxnazarxxx90]

Guys, you can somehow block a person’s computer so that he cannot enter the game ?
And how to do it correctly.

 

[Izami01]

Ban ip

 

[xxxnazarxxx90]

Ban ip

A ban on an IP is not valid, since the IP can be changed.

 

[Izami01]

A ban on an IP is not valid, since the IP can be changed.

Theres no option

 

[mangel_]

Guys, you can somehow block a person’s computer so that he cannot enter the game ?
And how to do it correctly.

You can create a stored procedure to ban that user's HWID from their already registered accounts.

USE [MuOnline];
GO

CREATE PROCEDURE sp_BanHWIDofExistingUser
AS
BEGIN
SET NOCOUNT ON;
INSERT INTO BanMacInfo (HardwareId, Account)
SELECT
m.HWID,
m.memb___id
FROM
MEMB_STAT m
WHERE
m.HWID = 'Here you must put the HWID of that user'
AND NOT EXISTS (
SELECT 1
FROM BanMacInfo b
WHERE b.HardwareId = m.HWID AND b.Account = m.memb___id
);
END;

Once the stored procedure has been created Go to
MuOnline>Programmability>Stored Procedures, search sp_BanHWIDofExistingUser, right click and click on Execute Stored Procedure

And create a trigger so that every time that HWID tries to register an account this account will be automatically banned.

USE [MuOnline];
GO
CREATE TRIGGER trg_BanHWIDofNewUserRegisters
ON MEMB_STAT
AFTER INSERT
AS
BEGIN
SET NOCOUNT ON;
INSERT INTO BanMacInfo (HardwareId, Account)
SELECT
i.HWID,
i.memb___id
FROM
inserted i
WHERE
i.HWID = 'Here you must put the HWID of that user';
END;
GO

Now all the user's accounts should have been added to the BanMacInfo table and every time that user creates an account it will be automatically added to BanMacInfo.

This is an example based on the MuDevs database, these query may vary depending on how the names are defined in your tables and columns.