Register for your free account! | Forgot your password?

You last visited: Today at 12:44

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


Clean character

Discussion on Clean character within the Dekaron Private Server forum part of the Dekaron category.

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 ;)
08/27/2010 - Silkroad Online Trading - 1 Replies
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]
clean error when creating character
06/29/2010 - Dekaron Private Server - 0 Replies
when i create a character on my own server i get this error http://img823.imageshack.us/img823/42/unbenanntune.jpg



All times are GMT +1. The time now is 12:44.


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

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