Drawde
02-07-2002, 03:58 AM
Sorry I couldn't reply to your post earlier (your post on the
forum seems to have been deleted now?)
I'm afraid I'm not sure exactly what caused the problem you have since
I've never encountered a crash/bug exactly like that myself. It does seem like
it might be a problem with the database though. The emulator often crashes
when it encounters incorrect/missing DB data.
You might have somehow made an error when importing my data into the DB. This
is the method I use:
Delete the existing EQ database using WinMySQLAdmin.
Create a new (blank) EQ database.
Open (in a text editor, not a word processor) the db.sql that comes with the emulator (without any spawn
or loot data in it), and delete all the loot-related table structs (between the items and name_filter data).
Copy and paste loot.txt into the place where the old loot data was.
Then copy and paste npc_types.txt, spawn2.txt, spawnentry.txt, spawngroup.txt and zonepoints.txt into the appropriate
areas of the database.
You'll also need to set the default user status to "200" not "0" if you want to use GM commands.
Save the database to your mysql/bin directory.
Open MySQL , type "use eq" and "source db.sql". You should get a few error "beeps" but not many (not sure what errors
are causing this, but they're not major).
When it's finished importing, you should be able to run the emulator and EQ, and see the spawned NPCs and monsters.
Hope this helps.
forum seems to have been deleted now?)
I'm afraid I'm not sure exactly what caused the problem you have since
I've never encountered a crash/bug exactly like that myself. It does seem like
it might be a problem with the database though. The emulator often crashes
when it encounters incorrect/missing DB data.
You might have somehow made an error when importing my data into the DB. This
is the method I use:
Delete the existing EQ database using WinMySQLAdmin.
Create a new (blank) EQ database.
Open (in a text editor, not a word processor) the db.sql that comes with the emulator (without any spawn
or loot data in it), and delete all the loot-related table structs (between the items and name_filter data).
Copy and paste loot.txt into the place where the old loot data was.
Then copy and paste npc_types.txt, spawn2.txt, spawnentry.txt, spawngroup.txt and zonepoints.txt into the appropriate
areas of the database.
You'll also need to set the default user status to "200" not "0" if you want to use GM commands.
Save the database to your mysql/bin directory.
Open MySQL , type "use eq" and "source db.sql". You should get a few error "beeps" but not many (not sure what errors
are causing this, but they're not major).
When it's finished importing, you should be able to run the emulator and EQ, and see the spawned NPCs and monsters.
Hope this helps.