L2J Server

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

I used this script some time ago to keep my db clean. The queries you are looking for are essentially there.

2Lecter: Thank you for another thing. I must overlooked that MySQL already know subselects (I ran for a long time on 3.23 not on 4.xx).

that was exactly what i was looking for, did a fantastic job. thank you!