Have you created a useful tool? or Do you want to get help building one? This is the right place!
mangdar
Posts: 68 Joined: Tue May 11, 2010 7:22 am
Post
by mangdar » Fri May 13, 2011 2:14 am
Hi
I made a very simple php script for delete Ban Character / Inactive charactor / Over Enc Item.
May be someone need it.
You can also make cronjob automatic run my script and do it by your hand.
You do not have the required permissions to view the files attached to this post.
labman
Posts: 67 Joined: Sun Sep 13, 2009 2:09 pm
Location: Taiwan
Contact:
Post
by labman » Fri May 13, 2011 4:50 am
Good program! Thanks for You!
goncafa
Posts: 385 Joined: Thu Aug 05, 2010 2:10 pm
Location: Santiago, Chile
Post
by goncafa » Fri May 13, 2011 4:11 pm
But you need not only delete character from table characters, you also need to delete all data of character like quest, items, etc....
Best Regards
PS: im sorry my bad english.
lion
L2j Veteran
Posts: 967 Joined: Sun Mar 11, 2007 7:49 pm
Location: Ukraine
Post
by lion » Fri May 13, 2011 4:15 pm
IdFactory
Zoey76
L2j Inner Circle
Posts: 7008 Joined: Tue Aug 11, 2009 3:36 am
Post
by Zoey76 » Fri May 13, 2011 4:17 pm
lion wrote: IdFactory
In addition to lion's comment IdFactory does a clean up upon server load, removing orphan items, subclasses, clan, etc, when the charId doesn't exist.
goncafa
Posts: 385 Joined: Thu Aug 05, 2010 2:10 pm
Location: Santiago, Chile
Post
by goncafa » Fri May 13, 2011 4:23 pm
Zoey76 wrote: lion wrote: IdFactory
In addition to lion's comment IdFactory does a clean up upon server load, removing orphan items, subclasses, clan, etc, when the charId doesn't exist.
:O
Great!, then this script is 100% functionally
Thanks!
Best Regards
PS: im sorry my bad english.
shippou
Posts: 75 Joined: Thu Jun 25, 2009 9:27 pm
Post
by shippou » Mon May 09, 2016 11:14 am
Only one problem, its only deleting the char, but its not clean up the db.
I mean Char items clan data, seven signs, dyes etc.
HorridoJoho
L2j Senior Developer
Posts: 795 Joined: Sun Aug 14, 2005 11:27 am
Post
by HorridoJoho » Tue May 10, 2016 9:11 am
shippou wrote: Only one problem, its only deleting the char, but its not clean up the db.
I mean Char items clan data, seven signs, dyes etc.
You should read Zoey76 post again. On server startup data from non existing characters are deleted.