Deleting 10000 lv. 20 or lower chars

[LaraCroft]

I tested on my live test server...
All characters below lvl 20 are set to delet....
Even if the character was created today...

[Raikkon35]

argh, problems with my connection... rewriting

[LaraCroft]

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???

[denser]

One Question:
The acc are deleted atomatic by server or only when the player try to log in???

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.

[janiii]

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;

[LaraCroft]

Yes denser...
But...

so when you logged in

Only for my acc... or for all acc that have been marked for delete??

[janiii]

Yes denser...
But...

so when you logged in

Only for my acc... or for all acc that have been marked for delete??

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.

[denser]

Yes denser...
But...

so when you logged in

Only for my acc... or for all acc that have been marked for delete??

did you see query where you just move chars with 1 in delettime to your acc?
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

[LaraCroft]

Now I understand...
work right now janiii...

Thx a lot guys...

[denser]

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

[Raikkon35]

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.

[denser]

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.

my method is simple ant ask idfactory too. read thread before reply.

[Raikkon35]

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.

my method is simple ant ask idfactory too. read thread before reply.

I have been reading the topic since it starts, and only want to help.

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]

simple aim and simple solution:) why do patch for such routine?
feel free to use that what you prefer..
peace

[babyjason]

what exactly you expect to happen? on server start is made dp cleanup.

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.

any ideea why? my gs is not modded at all...