Deleting 10000 lv. 20 or lower chars

Support for the latest build of L2J Server, get help here with installations, upgrades, problems.
Do not post bugs reports here, use viewforum.php?f=77 instead.
There is no support for other server builds than the official provided by l2jserver.com
Forum rules
READ NOW: L2j Forums Rules of Conduct
User avatar
momo61
Posts: 1648
Joined: Fri Jun 06, 2008 2:05 pm
Location: Europe

Deleting 10000 lv. 20 or lower chars

Post 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 ?
User avatar
MELERIX
L2j Veteran
L2j Veteran
Posts: 6667
Joined: Sat Sep 23, 2006 11:31 pm
Location: Chile
Contact:

Re: Deleting 10000 lv. 20 or lower chars

Post by MELERIX »

what about accounts ? :P
User avatar
momo61
Posts: 1648
Joined: Fri Jun 06, 2008 2:05 pm
Location: Europe

Re: Deleting 10000 lv. 20 or lower chars

Post 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 ?
User avatar
Tan
L2j Veteran
L2j Veteran
Posts: 873
Joined: Wed Jun 10, 2009 10:31 pm
Location: Poland

Re: Deleting 10000 lv. 20 or lower chars

Post by Tan »

i dont remember properly but sometimes ago i did delete all characters above lvl 20 and nothing bad heppend :P 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
User avatar
Aikimaniac
L2j Inner Circle
L2j Inner Circle
Posts: 3048
Joined: Sun Aug 07, 2005 11:42 pm
Location: Slovakia

Re: Deleting 10000 lv. 20 or lower chars

Post by Aikimaniac »

ppl will love to have their fresh academy toons erased :D
Image
User avatar
JIV
L2j Veteran
L2j Veteran
Posts: 1882
Joined: Sun Jan 06, 2008 8:17 pm
Location: Slovakia
Contact:

Re: Deleting 10000 lv. 20 or lower chars

Post by JIV »

what exactly you expect to happen? on server start is made dp cleanup.
User avatar
momo61
Posts: 1648
Joined: Fri Jun 06, 2008 2:05 pm
Location: Europe

Re: Deleting 10000 lv. 20 or lower chars

Post 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.
User avatar
Copyleft
Posts: 253
Joined: Fri Feb 01, 2008 9:39 pm

Re: Deleting 10000 lv. 20 or lower chars

Post by Copyleft »

always backup before, and you'll be fine
User avatar
Bloodshed
L2j Veteran
L2j Veteran
Posts: 816
Joined: Mon Jun 23, 2008 9:54 am
Location: Dorf Town

Re: Deleting 10000 lv. 20 or lower chars

Post by Bloodshed »

i always used alt lowbies to store items and stuff, people willl cry if they lose their pack mules
taking a break;
User avatar
ThePhoenixBird
L2j Inner Circle
L2j Inner Circle
Posts: 1857
Joined: Fri May 27, 2005 5:11 pm

Re: Deleting 10000 lv. 20 or lower chars

Post 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.
User avatar
momo61
Posts: 1648
Joined: Fri Jun 06, 2008 2:05 pm
Location: Europe

Re: Deleting 10000 lv. 20 or lower chars

Post 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 :P

thanks guys =)
User avatar
denser
Posts: 1392
Joined: Wed May 30, 2007 9:13 pm
Location: Russia
Contact:

Re: Deleting 10000 lv. 20 or lower chars

Post 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.
Tiger, once tasted human flesh, will want to taste it again
L2J - the place where glad to see you any time!
User avatar
momo61
Posts: 1648
Joined: Fri Jun 06, 2008 2:05 pm
Location: Europe

Re: Deleting 10000 lv. 20 or lower chars

Post 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 ?
User avatar
denser
Posts: 1392
Joined: Wed May 30, 2007 9:13 pm
Location: Russia
Contact:

Re: Deleting 10000 lv. 20 or lower chars

Post 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.
Tiger, once tasted human flesh, will want to taste it again
L2J - the place where glad to see you any time!
User avatar
momo61
Posts: 1648
Joined: Fri Jun 06, 2008 2:05 pm
Location: Europe

Re: Deleting 10000 lv. 20 or lower chars

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