Register for your free account! | Forgot your password?

You last visited: Today at 12:26

  • Please register to post and access all features, it's quick, easy and FREE!


Clean character

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Oct 2008
Posts: 1,221
Received Thanks: 561
Clean character

hello

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



conquer93 is offline  
Old 04/21/2009, 04:41   #2
 
elite*gold: 0
Join Date: Mar 2008
Posts: 41
Received Thanks: 19
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


bhencetotozo is offline  
Old 04/21/2009, 18:09   #3
 
elite*gold: 0
Join Date: May 2008
Posts: 238
Received Thanks: 8
Quote:
Originally Posted by bhencetotozo View Post
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 ??
lelothebest is offline  
Reply



« [HELP] Add Aloken weap infos & Skills | eeeeh, .. - hi! look my lil prob and solve it »

Similar Threads
wtt 93 bower hercules clean for sw2 60+ nuker or clean account ;)
Title say all but if its a clean account i want 1b gold to! else we will not trade xD add me on msn :[email protected]
1 Replies - Silkroad Online Trading
clean error when creating character
when i create a character on my own server i get this error http://img823.imageshack.us/img823/42/unbenanntune.jpg
0 Replies - Dekaron Private Server



All times are GMT +2. The time now is 12:26.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2018 elitepvpers All Rights Reserved.