[Share] Inactive Remove

Have you created a useful tool? or Do you want to get help building one? This is the right place!
Forum rules
READ NOW: L2j Forums Rules of Conduct
Post Reply
mangdar
Posts: 68
Joined: Tue May 11, 2010 7:22 am

[Share] Inactive Remove

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. :lol:
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:

Re: [Share] Inactive Remove

Post by labman » Fri May 13, 2011 4:50 am

Good program! Thanks for You!

User avatar
goncafa
Posts: 385
Joined: Thu Aug 05, 2010 2:10 pm
Location: Santiago, Chile

Re: [Share] Inactive Remove

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.
Image

lion
L2j Veteran
L2j Veteran
Posts: 967
Joined: Sun Mar 11, 2007 7:49 pm
Location: Ukraine

Re: [Share] Inactive Remove

Post by lion » Fri May 13, 2011 4:15 pm

IdFactory

User avatar
Zoey76
L2j Inner Circle
L2j Inner Circle
Posts: 7002
Joined: Tue Aug 11, 2009 3:36 am

Re: [Share] Inactive Remove

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.
Using Eclipse 4.21 - OpenJDK17 - MariaDB 10.6.3 - L2J Server 2.6.3.0

JOIN OUR DISCORD

User avatar
goncafa
Posts: 385
Joined: Thu Aug 05, 2010 2:10 pm
Location: Santiago, Chile

Re: [Share] Inactive Remove

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.
Image

shippou
Posts: 71
Joined: Thu Jun 25, 2009 9:27 pm

Re: [Share] Inactive Remove

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
L2j Senior Developer
Posts: 795
Joined: Sun Aug 14, 2005 11:27 am

Re: [Share] Inactive Remove

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.

Post Reply