Deleting 10000 lv. 20 or lower chars
Forum rules
READ NOW: L2j Forums Rules of Conduct
READ NOW: L2j Forums Rules of Conduct
- LaraCroft
- Posts: 360
- Joined: Sat Aug 08, 2009 1:37 am
Re: Deleting 10000 lv. 20 or lower chars
I tested on my live test server...
All characters below lvl 20 are set to delet....
Even if the character was created today...
All characters below lvl 20 are set to delet....
Even if the character was created today...
!!!knowledge and intelligence must be shared!!!
- Raikkon35
- Posts: 178
- Joined: Sat Mar 08, 2008 2:54 pm
Re: Deleting 10000 lv. 20 or lower chars
argh, problems with my connection... rewriting
Last edited by Raikkon35 on Sat Jul 10, 2010 1:57 pm, edited 1 time in total.
- LaraCroft
- Posts: 360
- Joined: Sat Aug 08, 2009 1:37 am
Re: Deleting 10000 lv. 20 or lower chars
Thx janiii
I'll test... and post results here...
Other question:
The acc are deleted atomatic by server or only when the player try to log in???
I'll test... and post results here...
Other question:
The acc are deleted atomatic by server or only when the player try to log in???
!!!knowledge and intelligence must be shared!!!
- denser
- Posts: 1392
- Joined: Wed May 30, 2007 9:13 pm
- Location: Russia
- Contact:
Re: Deleting 10000 lv. 20 or lower chars
LaraCroft wrote: One Question:
The acc are deleted atomatic by server or only when the player try to log in???
denser wrote:made SQl query when set up delete time to 1 where lvl <= 20, and change owner account to yours - so when you logged in - get a little freeze - then all of account will delete by server w/o conflicts.
Tiger, once tasted human flesh, will want to taste it again
L2J - the place where glad to see you any time!
L2J - the place where glad to see you any time!
- janiii
- L2j Veteran
- Posts: 4269
- Joined: Wed May 28, 2008 3:15 pm
- Location: Slovakia
Re: Deleting 10000 lv. 20 or lower chars
the problem is in the NOW() function. it returns the date, not the unix timestamp and deletion_time column doesnt exist, it is deletetime.
Code: Select all
UPDATE characters SET deletetime=1 WHERE level<=20 AND (UNIX_TIMESTAMP()*1000-lastAccess) >= 10368000000;
DO NOT EVEN TRY TO MESS WITH ME!
forum flOOder dancing dEVILoper ♀
I don't give private support - PM will be ignored!
forum flOOder dancing dEVILoper ♀
I don't give private support - PM will be ignored!
- LaraCroft
- Posts: 360
- Joined: Sat Aug 08, 2009 1:37 am
Re: Deleting 10000 lv. 20 or lower chars
Yes denser...
But...
But...
Only for my acc... or for all acc that have been marked for delete??so when you logged in
!!!knowledge and intelligence must be shared!!!
- janiii
- L2j Veteran
- Posts: 4269
- Joined: Wed May 28, 2008 3:15 pm
- Location: Slovakia
Re: Deleting 10000 lv. 20 or lower chars
LaraCroft wrote:Yes denser...
But...
Only for my acc... or for all acc that have been marked for delete??so when you logged in
it is not about accounts but about deleting characters. then on server start when idfactory cleans the database, characters with lower deletion time are deleted and after that all data from that deleted characters is cleaned. it has nothing to do with account.
DO NOT EVEN TRY TO MESS WITH ME!
forum flOOder dancing dEVILoper ♀
I don't give private support - PM will be ignored!
forum flOOder dancing dEVILoper ♀
I don't give private support - PM will be ignored!
- denser
- Posts: 1392
- Joined: Wed May 30, 2007 9:13 pm
- Location: Russia
- Contact:
Re: Deleting 10000 lv. 20 or lower chars
did you see query where you just move chars with 1 in delettime to your acc?LaraCroft wrote:Yes denser...
But...
Only for my acc... or for all acc that have been marked for delete??so when you logged in
so after this query - it become yours chars and then when you login - they all gone
it urgent but works i deleted 500+ chars that way long ago
Tiger, once tasted human flesh, will want to taste it again
L2J - the place where glad to see you any time!
L2J - the place where glad to see you any time!
- LaraCroft
- Posts: 360
- Joined: Sat Aug 08, 2009 1:37 am
Re: Deleting 10000 lv. 20 or lower chars
Now I understand...
work right now janiii...
Thx a lot guys...
work right now janiii...
Thx a lot guys...
!!!knowledge and intelligence must be shared!!!
- denser
- Posts: 1392
- Joined: Wed May 30, 2007 9:13 pm
- Location: Russia
- Contact:
Re: Deleting 10000 lv. 20 or lower chars
lets get clear what we need to concentrate all of stuff
[sql]UPDATE characters SET deletetime=1 WHERE level < min_level_to_survive AND (UNIX_TIMESTAMP()*1000-lastAccess) >= time_diff_in_milliseconds;UPDATE characters SET account = your_account WHERE deletetime=1;[/sql]
nice result add another conditions on your own taste
[sql]UPDATE characters SET deletetime=1 WHERE level < min_level_to_survive AND (UNIX_TIMESTAMP()*1000-lastAccess) >= time_diff_in_milliseconds;UPDATE characters SET account = your_account WHERE deletetime=1;[/sql]
nice result add another conditions on your own taste
Tiger, once tasted human flesh, will want to taste it again
L2J - the place where glad to see you any time!
L2J - the place where glad to see you any time!
- Raikkon35
- Posts: 178
- Joined: Sat Mar 08, 2008 2:54 pm
Re: Deleting 10000 lv. 20 or lower chars
Friends, open "L2_GameServer\java\com\l2jserver\gameserver\idfactory\IdFactory.java".
From line 173 to 195 there are so many thinks that can help you.
I think this is a clean delete, because after that, all the char stuff are deleted by querys send by IdFactory.
From line 173 to 195 there are so many thinks that can help you.
I think this is a clean delete, because after that, all the char stuff are deleted by querys send by IdFactory.
- denser
- Posts: 1392
- Joined: Wed May 30, 2007 9:13 pm
- Location: Russia
- Contact:
Re: Deleting 10000 lv. 20 or lower chars
my method is simple ant ask idfactory too. read thread before reply.Raikkon35 wrote:Friends, open "L2_GameServer\java\com\l2jserver\gameserver\idfactory\IdFactory.java".
From line 173 to 195 there are so many thinks that can help you.
I think this is a clean delete, because after that, all the char stuff are deleted by querys send by IdFactory.
Tiger, once tasted human flesh, will want to taste it again
L2J - the place where glad to see you any time!
L2J - the place where glad to see you any time!
- Raikkon35
- Posts: 178
- Joined: Sat Mar 08, 2008 2:54 pm
Re: Deleting 10000 lv. 20 or lower chars
I have been reading the topic since it starts, and only want to help.denser wrote:my method is simple ant ask idfactory too. read thread before reply.Raikkon35 wrote:Friends, open "L2_GameServer\java\com\l2jserver\gameserver\idfactory\IdFactory.java".
From line 173 to 195 there are so many thinks that can help you.
I think this is a clean delete, because after that, all the char stuff are deleted by querys send by IdFactory.
Its more simple and automatic use the commented adds that there are in IdFactory first lines, instead of use a query, having a "delete by days" in the file.
- denser
- Posts: 1392
- Joined: Wed May 30, 2007 9:13 pm
- Location: Russia
- Contact:
Re: Deleting 10000 lv. 20 or lower chars
simple aim and simple solution:) why do patch for such routine?
feel free to use that what you prefer..
peace
feel free to use that what you prefer..
peace
Tiger, once tasted human flesh, will want to taste it again
L2J - the place where glad to see you any time!
L2J - the place where glad to see you any time!
-
- Posts: 575
- Joined: Wed Dec 02, 2009 7:59 pm
Re: Deleting 10000 lv. 20 or lower chars
seams for some reason, dp clean up is not happening, i deleted characters from characters.sql but after i started gameserver, the characters items, in items.sql were there, as in owner_id column corresponded to the allready deleted character.JIV wrote:what exactly you expect to happen? on server start is made dp cleanup.
any ideea why? my gs is not modded at all...