Just off the top of my head - If you use NaviCat, you should be able to import the spells_us.txt file using the ^ character as a delimiter.
I think the original spells_us.txt file has 7,872 spells (max id of 8446)
The DB has 7,837 spells (max id 8402)
What's the easiest way to have them the same? Yea you could go through and delete 7800+ lines by hand.... if you know any programming you could create a script/app that'll do that for you - or compare what's in the db vs whats in the file and add it automatically...
|