Need some help with mysql clean up

Elektra · Post by **Elektra** » Mon Oct 17, 2005 7:25 pm

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

Post by **DrLecter** » Mon Oct 17, 2005 8:43 pm

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

kmarty · Post by **kmarty** » Wed Oct 19, 2005 9:07 pm

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

Elektra · Post by **Elektra** » Wed Oct 19, 2005 9:15 pm

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