Clean character

hello

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

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

Quote:

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 ??