Importing drawde's data to the db
 

I recently downloaded drawde's spawn data and manually copy'd and pasted them into my db. When i finish that i type use eq, source db.sql and it does the normal stuff but then its updating all the items, spawn, etc making a annoying sound and taking forever. Anyone have this problem? Anyway to fix it because its making my parents go crazy but, i need to import the data into the database.

dont copy it into one file. the most recent zip has several txt files such as spawn.txt

put all those files in the mysql/bin dir and run mysql.exe.

then type use eq

then type source spawn.txt or whatever it is for all the txt files. that worked for me :)

or mysql -f eqdbname <blah.sql to shut up the errors i think

Heres the easy way.. The problem is that only the loot txt file contains the tables def's first. Heres how I do it, very simple..

Attatching a zip file with the 4 table defs i source in.



use eq;
drop table npc_types;
drop table lootdrop;
drop table lootdrop_entries;
drop table loottable;
drop table loottable_entries;
drop table spawn2;
drop table spawngroup;
drop table spawnentry;
source createspawn2.txt;
source createspawngroup.txt;
source createspawnentry.txt;
source createnpc_types.txt;
source loot.txt;
source npcs.txt;
source spawn2.txt;
source spawnentry.txt;
source spawngroup.txt;

If you paste this into word pad, put the resulting file in the same directory as drawde's txt files, and the 4 im putting out, you should just be able just C:\mysql\bin\mysql eq < filename.sql
and do it in one fell swoop..

Thanks guys for all your help i just got it working. :D

help please :)
 

for some reason the npc types isnt working. i cant find it anywhere in the db.sql and im not sure what to do. it gives errors if i try to use it that no table was created. then says eq.npc.types doesn't exsist.

anyone know what to do ? thanks

=)

download the file i att. above, open it, drop it in the same directory as drawde's txt files.. then
type

c:\mysql\bin\mysql eq < createnpc_types.txt

that will create the npc_types table..

then c:\mysql\bin\mysql eq < npctypes.txt
to import in drawde's NPC table.

It's npcs.txt not npc_types.txt, that's why that file isn't working.
However npc_types.txt is a better name I think (more obvious where to put it in the DB), so I'll change the output name in the parser

I followed the instructions in the thread and got the DB updated, but now whenever I go to a zone that has spawns, I crash.

In the zoneserver window it says :What can I do to fix this?

I think I may have discovered a little hiccup in Trumpcard's scripts. It seems that the npc_types table created has 13 fields, whereas the data supplied in the npc_types.txt file has 14 values for each entry. Is there perhaps a missing field in there somewhere?

The new version of drawde's data has the extra field.

The new field was added in ver 0.2.3