Page 2 of 4
Re: Deleting 10000 lv. 20 or lower chars
Posted: Sun Dec 27, 2009 7:23 pm
by denser
you said that you wont to get tails and clean delete....i contrib you a method with 100% clean deletion.
Re: Deleting 10000 lv. 20 or lower chars
Posted: Sun Dec 27, 2009 8:20 pm
by momo61
denser wrote: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
Re: Deleting 10000 lv. 20 or lower chars
Posted: Sun Dec 27, 2009 8:26 pm
by 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..
Re: Deleting 10000 lv. 20 or lower chars
Posted: Mon Dec 28, 2009 5:02 am
by 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
Re: Deleting 10000 lv. 20 or lower chars
Posted: Mon Jan 11, 2010 11:44 am
by momo61
deleted 27.000 characters ^^
that was so much fun
Re: Deleting 10000 lv. 20 or lower chars
Posted: Mon Jan 11, 2010 12:21 pm
by denser
hope you like it if it needs again)
Re: Deleting 10000 lv. 20 or lower chars
Posted: Mon Jan 11, 2010 12:24 pm
by momo61
denser wrote:hope you like it if it needs again)
I didnt use your scripts X_x I deleted the characters manually in Navicat
Re: Deleting 10000 lv. 20 or lower chars
Posted: Fri Jul 09, 2010 12:33 pm
by 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...
Re: Deleting 10000 lv. 20 or lower chars
Posted: Fri Jul 09, 2010 2:36 pm
by 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
Re: Deleting 10000 lv. 20 or lower chars
Posted: Sat Jul 10, 2010 12:52 am
by LaraCroft
Ok...
Works so fine...
Thx a lot guys
Re: Deleting 10000 lv. 20 or lower chars
Posted: Sat Jul 10, 2010 8:44 am
by blacksea
for all accounts/chars etc older than 6 months?:-s
Re: Deleting 10000 lv. 20 or lower chars
Posted: Sat Jul 10, 2010 8:48 am
by janiii
blacksea wrote: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
Re: Deleting 10000 lv. 20 or lower chars
Posted: Sat Jul 10, 2010 8:57 am
by blacksea
and level<=85 i supose.. i used option from idfactory but it takes too long.. after 6 hours still not finished
Re: Deleting 10000 lv. 20 or lower chars
Posted: Sat Jul 10, 2010 1:30 pm
by LaraCroft
janiii wrote: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???
Re: Deleting 10000 lv. 20 or lower chars
Posted: Sat Jul 10, 2010 1:48 pm
by 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...
