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
Deleting 10000 lv. 20 or lower chars
Forum rules
READ NOW: L2j Forums Rules of Conduct
READ NOW: L2j Forums Rules of Conduct
- AntV
- Posts: 177
- Joined: Mon May 10, 2010 10:46 pm
Re: Deleting 10000 lv. 20 or lower chars
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.
- Zoey76
- L2j Inner Circle
- Posts: 7005
- Joined: Tue Aug 11, 2009 3:36 am
Re: Deleting 10000 lv. 20 or lower chars
LOL, Interesting way of doing it.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.
Powered by Eclipse 4.30 | Eclipse Temurin 21 | MariaDB 11.3.2 | L2J Server 2.6.3.0 - High Five
Join our Discord!
Join our Discord!
- AntV
- Posts: 177
- Joined: Mon May 10, 2010 10:46 pm
Re: Deleting 10000 lv. 20 or lower chars
Nobody reads the first page of posts anymore, huhdenser wrote: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.Code: Select all
UPDATE characters SET deletion_time=1 WHERE level<=20,UPDATE characters SET accaunt=momo61 WHERE deletion_time=1;
- UnAfraid
- L2j Veteran
- Posts: 4199
- Joined: Mon Jul 23, 2007 4:25 pm
- Location: Bulgaria
- Contact:
Re: Deleting 10000 lv. 20 or lower chars
I'd delete them right away and let server cleanup the rest
Code: Select all
DELETE FROM characters WHERE level < 20;