Deleting 10000 lv. 20 or lower chars
Forum rules
READ NOW: L2j Forums Rules of Conduct
READ NOW: L2j Forums Rules of Conduct
- momo61
- Posts: 1648
- Joined: Fri Jun 06, 2008 2:05 pm
- Location: Europe
Deleting 10000 lv. 20 or lower chars
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 ?
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 ?
- MELERIX
- L2j Veteran
- Posts: 6667
- Joined: Sat Sep 23, 2006 11:31 pm
- Location: Chile
- Contact:
- momo61
- Posts: 1648
- Joined: Fri Jun 06, 2008 2:05 pm
- Location: Europe
Re: Deleting 10000 lv. 20 or lower chars
No, only characters ... I would then use an SQL query to delete all empty accounts.
but what about only characters lv. 20 or below ?
but what about only characters lv. 20 or below ?
- Tan
- L2j Veteran
- Posts: 873
- Joined: Wed Jun 10, 2009 10:31 pm
- Location: Poland
Re: Deleting 10000 lv. 20 or lower chars
i dont remember properly but sometimes ago i did delete all characters above lvl 20 and nothing bad heppend i dont remember correctly
Some people believe in God... i believe in Music... some people pray..... I turn on Winamp
http://www.last.fm/user/L2jTan
http://www.last.fm/user/L2jTan
- Aikimaniac
- L2j Inner Circle
- Posts: 3048
- Joined: Sun Aug 07, 2005 11:42 pm
- Location: Slovakia
- JIV
- L2j Veteran
- Posts: 1882
- Joined: Sun Jan 06, 2008 8:17 pm
- Location: Slovakia
- Contact:
Re: Deleting 10000 lv. 20 or lower chars
what exactly you expect to happen? on server start is made dp cleanup.
- momo61
- Posts: 1648
- Joined: Fri Jun 06, 2008 2:05 pm
- Location: Europe
Re: Deleting 10000 lv. 20 or lower chars
I just thought there would be conflicts with clans, skills, quests, items etc.
but if a database cleanup is initiated, it's good.
but if a database cleanup is initiated, it's good.
- Copyleft
- Posts: 253
- Joined: Fri Feb 01, 2008 9:39 pm
Re: Deleting 10000 lv. 20 or lower chars
always backup before, and you'll be fine
- Bloodshed
- L2j Veteran
- Posts: 816
- Joined: Mon Jun 23, 2008 9:54 am
- Location: Dorf Town
Re: Deleting 10000 lv. 20 or lower chars
i always used alt lowbies to store items and stuff, people willl cry if they lose their pack mules
taking a break;
- ThePhoenixBird
- L2j Inner Circle
- Posts: 1857
- Joined: Fri May 27, 2005 5:11 pm
Re: Deleting 10000 lv. 20 or lower chars
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.
- momo61
- Posts: 1648
- Joined: Fri Jun 06, 2008 2:05 pm
- Location: Europe
Re: Deleting 10000 lv. 20 or lower chars
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 =)
thanks guys =)
- denser
- Posts: 1392
- Joined: Wed May 30, 2007 9:13 pm
- Location: Russia
- Contact:
Re: Deleting 10000 lv. 20 or lower chars
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!
- momo61
- Posts: 1648
- Joined: Fri Jun 06, 2008 2:05 pm
- Location: Europe
Re: Deleting 10000 lv. 20 or lower chars
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 ?
- denser
- Posts: 1392
- Joined: Wed May 30, 2007 9:13 pm
- Location: Russia
- Contact:
Re: Deleting 10000 lv. 20 or lower chars
Code: Select all
UPDATE characters SET deletion_time=1 WHERE level<=20,UPDATE characters SET accaunt=momo61 WHERE deletion_time=1;
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!
- momo61
- Posts: 1648
- Joined: Fri Jun 06, 2008 2:05 pm
- Location: Europe
Re: Deleting 10000 lv. 20 or lower chars
denser wrote: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.Code: Select all
UPDATE characters SET deletion_time=1 WHERE level<=20,UPDATE characters SET accaunt=momo61 WHERE deletion_time=1;
Isnt there an easier way ?
Like, CHECK if account has characters, if not then DELETE account ?