Importing drawde's data to the db

[Nada]

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.

[Shawn319]

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

[Zeitgeist]

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

[Trumpcard]

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

[Nada]

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

[humphrey]

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

=)

[Trumpcard]

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.

[Drawde]

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

[Timeout]

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 :Using database 'eq' at localhost
Loading items & NPCs...done.
Spells loaded from 'spdat.eff'.
Loading guild ranks...done.
Connected to worldserver: 127.0.0.1:9000
Entering sleep mode
Map: Maps\freportw.map not found.
-----------
Zone server 'freportw' listening on port:9004
-----------
Message:Zone bootup: West Freeport
New client from ip: 127.0.0.1 port:1445
Login packet 1
New random SACK.dwARQ
Login packet 2
Zone Weather for: freportw 0
Login packet 3
Login packet 4
Resending packets
Login packet 5
Unkown opcode: 0xff21 size:60
Got a player save request (OP_Save)
Unkown opcode: 0x4721 size:92
Unkown opcode: 0x4721 size:92
Unkown opcode: 0x4721 size:92
Unkown opcode: 0x4721 size:92
Unkown opcode: 0x1f20 size:4
Channel:8 #castspell 1776
Channel:8 #zone ecommons
Zone request for:Taludan to:ecommons
Player at x:127 y:83 z:-23.6
Zoning to safe coords: ecommons, x=-794, y=1570, z=5
Zone target:ecommons x:-794 y:1570 z:5
Got a player profile
Player attempting to delete spawn...
Client disconnected (!pm.CA): Taludan
Client disconnected (cs=d): Taludan
Dropping client: Process=false, ip=127.0.0.1, port=1445
Automatic shutdown
Message:----SERVER SHUTDOWN----
Zone shutdown: going to sleep

What can I do to fix this?

[Bean]

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?

[Trumpcard]

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

The new field was added in ver 0.2.3