New spawn data

[jam^]

Here's a quick SQL file i created to prep the existing database before importing Drawde's data..

# kill the tables that we have new definitions for
drop table if exists loottable;
drop table if exists loottable_entries;
drop table if exists lootdrop;
drop table if exists lootdrop_entries;

#clean out the existing data in the other tables
delete from spawnentry;
delete from spawngroup;
delete from spawn2;
delete from npc_types;


after that, it's just a matter of importing the files with
mysql -f eq <datafile.txt

I notice i have to use the -f (ignore errors) option with mysql for this since there seems to be many duplicates in a couple of the files.


BTW, kudos to all of you for a great job on the emulator and the database info