Newbie Spellweaver
- Joined
- Apr 14, 2023
- Messages
- 38
- Reaction score
- 5
Guys, you can somehow block a person’s computer so that he cannot enter the game ?
And how to do it correctly.
And how to do it correctly.
Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!
Join Today!A ban on an IP is not valid, since the IP can be changed.Ban ip
Theres no optionA ban on an IP is not valid, since the IP can be changed.
Guys, you can somehow block a person’s computer so that he cannot enter the game ?
And how to do it correctly.
Once the stored procedure has been created Go toUSE [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;
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