MWnpcdb_050_default0_3
 

A couple quick fixes , added LDoN zones (thx jdank) , Sharvahl char creation somewhat working , only fall to death once now :)
A couple price fixes and npc spell fixes.

Grab it here=

http://tcstoys.sytes.net/MWnpcdb_050_default0_3.zip

NOTE: source ONLY the .sql file from the download, NO other files needed , this is a complete DB.
Just source and run for online(public) server , just add acct info for LAN server.

More soon :)

ENJOY!!

great work, will give it a try :D

!
 

Great work, keep it up!

Looking forward to future releases.

I tried to import this file into my database, and everytime I log into a character it resets back to server select screen. I've reset my database to an empty set, and tried to import it several times with the same luck.

Basically, I used

MySql-> source databasefile.sql

LOTS of duplicate errors

So I tried to delete my old tables, and start fresh with your info.

Both gave me same results, unable to log into the game.

Am I doing something wrong? Perhaps, a simple guide to explain the steps needed?

Start with a clean DB , then source ONLY the .sql file in the D/L , it's a complete DB , nothing else needed.

Thanks, gonna give it a try right now !


Edit: Having the same problem :-/

I dropped the EQ database, re-created it, granted the permissions to my user, and sourced your sql file.

Load up to character select screen, enter world, loads a sec, then it dumps me to server selection. :?:

Make sure your .ini files are correct and that you have the correct ip addresses in the boot5zones.bat

DO NOT COMPILE WORLD as WORLDDEBUG!!
There is extra code in the world source that was added as a rough conversion tool for the DB info , if you compile and run world as debug , it will try to convert the DB and then try to run the items from the new items_ table.

COMPILE as Win32 and it should run just fine.

I compiled it as World.exe, win32.

My problem isn't getting into the world. Without importing the database (at least, the one above) I can get into the game fine. The game also runs fine if I import the supplemental databases (db.sql, pets.sql, and doors_objects.sql I think they're called) that came with the code. But when I import the database you've posted, it kicks me to server select. If I remove the database, and start from a fresh empty one- or the 3 supplemental ones- The game works fine.


P.S. I noticed the zonepoints_raw INSERTS have some funky characters in them. Is this normal?

[quote]
INSERT INTO zonepoints_raw VALUES (1,'nexus','\0\0\0\0GH\0

Yes..

Ok.....quick question.

I know your working on pathing, etc. But is there any way to

1) get the npc to STOP casting on themselves every two seconds?

and

2) allow for zoning? I have walls where the zoneline normally would occur.

Cheers

Everthing is being worked on and really alot of this stuff you can fix your self just search on the problem

Is this for the 5.0 db?

all I have to do is type in

create database eq;
use eq;
source (your DB)

and poof it will say 5.0-DR4 next to my server? or will it still say 4.4?

Please PM me with the answer I cant keep track of all my posts...

Well, I did alot of parsing on this file. I broke it into individual files, each one with the SQL creating/populating a single table. I initially started from a fresh database, and sourced the db.sql that came with the emu so I could get a workable EMU going.

I then ran the EMU to be sure it worked, it did.

I then started dropping tables, and sourcing them from this database. One table at a time, and running the EMU after each drop/source to check if it worked.

It was very tedious but I managed to get every single table populated EXCEPT the <spawngroup> table. Each time I populate this table from the file, my EMU stops working after character select and either goes "Not Responding" or kicks me to character select screen.

I know I've asked for more help than I prolly deserve, but I'm curious if there's anything I'm doing wrong- Or if anyone has any suggestions on why this table stops my EMU from operating.

Thanks again.

EDIT: The error I am getting when this table is loaded is:

Why would it ONLY crash when this table is populated? The EMU runs perfectly otherwise.

I was having this prob also so I ran these sql statements.

select
spawnentry.*
from
spawnentry
left join
npc_types
on
spawnentry.npcID=npc_types.id
where
npc_types.id is null;

and

select
spawnentry.*
from
spawnentry
left join
spawngroup
on
spawnentry.spawngroupID=spawngroup.id
where
spawngroup.id is null;

The first statement returned two rows. I removed these entries from the database and was able to get pass the charater screen and into the zone. I'm not sure if this did it because I did alot of other data normalization and came up with a completly different database than the one I initially started with. But it works.