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
|