Deleting 10000 lv. 20 or lower chars

[denser]

you said that you wont to get tails and clean delete....i contrib you a method with 100% clean deletion.

[momo61]

you said that you wont to get tails and clean delete....i contrib you a method with 100% clean deletion.

>_< i dont understand you m8

[Aikimaniac]

what is not understandible on what denser explained...you will fully clear erase from DB for those toons so he made queries with HOW TO for you..not sure if there is way to explain it more easier..

[denser]

Code: Select all

UPDATE characters SET deletetime=1 WHERE level<=20;UPDATE characters SET account_name=momo61 WHERE deletetime=1;

edited for real names in SQL, earlier wrote by memory) now look at sql table.
hope you will find more easy way...but i do not see it.

regards

[momo61]

deleted 27.000 characters ^^

that was so much fun

[denser]

hope you like it if it needs again)

[momo61]

hope you like it if it needs again)

I didnt use your scripts X_x I deleted the characters manually in Navicat

[LaraCroft]

Hi guys....
Sorry... I see that is a old topic...
But...
How do I delete the characters that do not log in the server for more than 120 days?
Using denser's method...

Thx a lot...

[denser]

[sql]UPDATE characters SET deletetime=1 WHERE level<=20 AND (UNIX_TIMESTAMP()*1000-lastAccess) >= 10368000000;UPDATE characters SET account=momo61 WHERE deletion_time=1;[/sql]
may be that helps you

[LaraCroft]

Ok...
Works so fine...
Thx a lot guys

[blacksea]

for all accounts/chars etc older than 6 months?:-s

[janiii]

for all accounts/chars etc older than 6 months?:-s

what about using a little bit of math? the time difference is in milliseconds..

Code: Select all

UPDATE characters SET deletetime=1 WHERE level<=20 AND (UNIX_TIMESTAMP()*1000-lastAccess) >= [b]10368000000[/b];

120 days -> 120*24*60*60*1000 milliseconds -> 10368000000 number in the query
6 months is about 180 days -> 180*24*60*60*1000 milliseconds -> your number

[blacksea]

and level<=85 i supose.. i used option from idfactory but it takes too long.. after 6 hours still not finished

[LaraCroft]

UPDATE characters SET deletion_time=1 WHERE level<=20 AND (NOW()-`characters`.lastAccess) >= 10368000000;

Don't work so fine...
All characters below lvl 20 are set to delete...

Ps: Im using the sql on Navicat

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

[denser]

i dont check it, but sintaxis is right... may be something wrong with lastaccess column?

strange...
[sql]SELECT * FROM characters WHERE (NOW()-lastAccess) < 100000;[/sql]
give me zero result. but i just now logged in adn then logout...