Need some help with mysql clean up
Forum rules
READ NOW: L2j Forums Rules of Conduct
READ NOW: L2j Forums Rules of Conduct
-
- Posts: 205
- Joined: Thu Sep 01, 2005 2:32 am
Need some help with mysql clean up
Well Ive deleted some accounts and some characters with the account php pages but i dont think it deleted the charater skills, quest info and items. Im not all that great with mysql and am in need of a command or 2 to check items, quest info and skills against the characters db and if the character no longer exists then delete those entries. Would be most helpful to keep it clean and streamlined to provide fast clean game play. Thanks
- DrLecter
- L2j Inner Circle
- Posts: 705
- Joined: Sat Jul 23, 2005 8:32 pm
- Contact:
I used this script some time ago to keep my db clean. The queries you are looking for are essentially there.