We moved our repositories to BitBucket!

If you can't login or you can't register to the forums do not rise an issue, instead please write to support (at) l2jserver.com

Check our wiki!

Report server issues here

Forum has been updated to phpBB 3.2, let's see if this fixes some minor bugs we had.

Thank you for visiting http://www.l2jserver.com/

[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: 6861
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 Photon 4.8 - OpenJDK11 - MySQL 8.0.12 - L2J Server :+1:
Live support

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: 67
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