L2J Server

Hy!

Looking for a script wich can clear all char related data from db.
Not just the char it self.
Clan, Char items, etc where one data is stored.

I have a this script

" $query = ("DELETE FROM characters WHERE characters.accesslevel = 0 AND DATEDIFF(CURRENT_DATE( ) , FROM_UNIXTIME(`lastAccess`/1000)) > 180");
$result = mysql_query($query) or die(mysql_error());
break;
"

But the GS did not clean up the db is the char it self deleted.
So if chance the charId is readded by a char creation the new char have the deleted ones items to.
The new char is even rejoin the clan if the deleted char was in clan so it mess up things.

thx Fowardly

The best workaround is instead of deleting those chars, moving them to your admin account and setting delete time to 1, then logging in to your account and letting the server do all the magic.

AntV wrote:The best workaround is instead of deleting those chars, moving them to your admin account and setting delete time to 1, then logging in to your account and letting the server do all the magic.

LOL, Interesting way of doing it.

denser wrote:

Code: Select all

UPDATE characters SET deletion_time=1 WHERE level<=20,UPDATE characters SET accaunt=momo61 WHERE deletion_time=1;

and where you log in game by momo61 acc - game will freeze a little - depend on number of characters. server will delete all of them correctly.

Nobody reads the first page of posts anymore, huh

I'd delete them right away and let server cleanup the rest