Page 1 of 4
Deleting 10000 lv. 20 or lower chars
Posted: Sat Dec 26, 2009 2:19 am
by momo61
Hello guys,
I'm wondering if it would damage the server if I deleted 10.000 characters from the caracters table. Then after that I'd start the server and shut it down again, and then update to gracia epilogue.
would it damage the server or is that an acceptable way of doing it ?
Re: Deleting 10000 lv. 20 or lower chars
Posted: Sat Dec 26, 2009 2:49 am
by MELERIX
what about accounts ?
Re: Deleting 10000 lv. 20 or lower chars
Posted: Sat Dec 26, 2009 2:51 am
by momo61
No, only characters ... I would then use an SQL query to delete all empty accounts.
but what about only characters lv. 20 or below ?
Re: Deleting 10000 lv. 20 or lower chars
Posted: Sat Dec 26, 2009 3:41 am
by Tan
i dont remember properly but sometimes ago i did delete all characters above lvl 20 and nothing bad heppend
i dont remember correctly
Re: Deleting 10000 lv. 20 or lower chars
Posted: Sat Dec 26, 2009 9:32 am
by Aikimaniac
ppl will love to have their fresh academy toons erased
Re: Deleting 10000 lv. 20 or lower chars
Posted: Sat Dec 26, 2009 10:13 am
by JIV
what exactly you expect to happen? on server start is made dp cleanup.
Re: Deleting 10000 lv. 20 or lower chars
Posted: Sat Dec 26, 2009 4:38 pm
by momo61
I just thought there would be conflicts with clans, skills, quests, items etc.
but if a database cleanup is initiated, it's good.
Re: Deleting 10000 lv. 20 or lower chars
Posted: Sat Dec 26, 2009 4:54 pm
by Copyleft
always backup before, and you'll be fine
Re: Deleting 10000 lv. 20 or lower chars
Posted: Sat Dec 26, 2009 9:39 pm
by Bloodshed
i always used alt lowbies to store items and stuff, people willl cry if they lose their pack mules
Re: Deleting 10000 lv. 20 or lower chars
Posted: Sun Dec 27, 2009 12:05 am
by ThePhoenixBird
Made this many times before, and at the server start orphan stuff gets deleted, so there would not be any damage, but remember to ALWAYS bakcup.
Re: Deleting 10000 lv. 20 or lower chars
Posted: Sun Dec 27, 2009 12:22 am
by momo61
Of course I will announce that in 2 weeks, all chars below a certain level will get deleted. And of course I'll do a backup
thanks guys =)
Re: Deleting 10000 lv. 20 or lower chars
Posted: Sun Dec 27, 2009 4:36 am
by denser
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.
Re: Deleting 10000 lv. 20 or lower chars
Posted: Sun Dec 27, 2009 5:50 am
by momo61
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.
uh ... what ?
Re: Deleting 10000 lv. 20 or lower chars
Posted: Sun Dec 27, 2009 7:02 am
by denser
Code: Select all
UPDATE characters SET deletion_time=1 WHERE level<=20,UPDATE characters SET accaunt=momo61 WHERE deletion_time=1;
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.
Re: Deleting 10000 lv. 20 or lower chars
Posted: Sun Dec 27, 2009 1:46 pm
by momo61
denser wrote:Code: Select all
UPDATE characters SET deletion_time=1 WHERE level<=20,UPDATE characters SET accaunt=momo61 WHERE deletion_time=1;
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.
Isnt there an easier way ?
Like, CHECK if account has characters, if not then DELETE account ?