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.
[Share] Inactive Remove
Forum rules
READ NOW: L2j Forums Rules of Conduct
READ NOW: L2j Forums Rules of Conduct
-
- Posts: 68
- Joined: Tue May 11, 2010 7:22 am
[Share] Inactive Remove
You do not have the required permissions to view the files attached to this post.
-
- Posts: 67
- Joined: Sun Sep 13, 2009 2:09 pm
- Location: Taiwan
- Contact:
- goncafa
- Posts: 385
- Joined: Thu Aug 05, 2010 2:10 pm
- Location: Santiago, Chile
Re: [Share] Inactive Remove
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.
PS: im sorry my bad english.
-
- L2j Veteran
- Posts: 967
- Joined: Sun Mar 11, 2007 7:49 pm
- Location: Ukraine
Re: [Share] Inactive Remove
IdFactory
- Zoey76
- L2j Inner Circle
- Posts: 7005
- Joined: Tue Aug 11, 2009 3:36 am
Re: [Share] Inactive Remove
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.lion wrote:IdFactory
Powered by Eclipse 4.30 | Eclipse Temurin 21 | MariaDB 11.3.2 | L2J Server 2.6.3.0 - High Five
Join our Discord!
Join our Discord!
- goncafa
- Posts: 385
- Joined: Thu Aug 05, 2010 2:10 pm
- Location: Santiago, Chile
Re: [Share] Inactive Remove
:OZoey76 wrote: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.lion wrote:IdFactory
Great!, then this script is 100% functionally
Thanks!
Best Regards
PS: im sorry my bad english.
PS: im sorry my bad english.
-
- Posts: 74
- Joined: Thu Jun 25, 2009 9:27 pm
Re: [Share] Inactive Remove
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.
I mean Char items clan data, seven signs, dyes etc.
-
- L2j Senior Developer
- Posts: 795
- Joined: Sun Aug 14, 2005 11:27 am
Re: [Share] Inactive Remove
You should read Zoey76 post again. On server startup data from non existing characters are deleted.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.
Away cause of a bulding side in my place.
H5 GeoData from Nos & FBIagent
GoD Ch3 Lindvior GeoData from Nos & FBIagent
Yet another Buffer (Freya & HighFive)
Party Teleporter (Freya & HighFive)
FBIagent
H5 GeoData from Nos & FBIagent
GoD Ch3 Lindvior GeoData from Nos & FBIagent
Yet another Buffer (Freya & HighFive)
Party Teleporter (Freya & HighFive)
FBIagent