Clean character

[conquer93]

hello

Any says i need a clean database çharacter for anti gm hack
can any sent it me?

[bhencetotozo]

You don't need a clean database for GM antihack, Just apply a trigger . This is an example. This one should work for you.

drop trigger trig_GMNAMECHECK_2;
create TRIGGER trig_GMNAMECHECK_2
ON user_character
FOR UPDATE
AS
IF not UPDATE(character_name)
BEGIN
RETURN
END

IF (UPDATE(character_name))
BEGIN
DECLARE @INSERTEDNAME varchar(50)
DECLARE @GMTABLECHECK varchar(50)
SELECT @INSERTEDNAME = (SELECT character_name FROM Inserted)
IF (@INSERTEDNAME IS NOT NULL AND SUBSTRING(@INSERTEDNAME, 1, 4) = '[GM]')
SELECT @GMTABLECHECK = (SELECT character_name FROM cod3_gmnames where character_name = @INSERTEDNAME)
if (@GMTABLECHECK IS NULL OR @GMTABLECHECK = '')
ROLLBACK
END

[lelothebest]

Originally Posted by bhencetotozo

You don't need a clean database for GM antihack, Just apply a trigger . This is an example. This one should work for you.

drop trigger trig_GMNAMECHECK_2;
create TRIGGER trig_GMNAMECHECK_2
ON user_character
FOR UPDATE
AS
IF not UPDATE(character_name)
BEGIN
RETURN
END

IF (UPDATE(character_name))
BEGIN
DECLARE @INSERTEDNAME varchar(50)
DECLARE @GMTABLECHECK varchar(50)
SELECT @INSERTEDNAME = (SELECT character_name FROM Inserted)
IF (@INSERTEDNAME IS NOT NULL AND SUBSTRING(@INSERTEDNAME, 1, 4) = '[GM]')
SELECT @GMTABLECHECK = (SELECT character_name FROM cod3_gmnames where character_name = @INSERTEDNAME)
if (@GMTABLECHECK IS NULL OR @GMTABLECHECK = '')
ROLLBACK
END

how to "apply a trigger" ?? can u show me ??