MWnpcdb_050_default0_3

[tcsmyworld]

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

[Elea]

great work, will give it a try

[haxx777]

Great work, keep it up!

Looking forward to future releases.

[Bori]

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?

[tcsmyworld]

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

[Bori]

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

[tcsmyworld]

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

[tcsmyworld]

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.

[Bori]

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

[Trumpcard]

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

Yes..

[wguidry]

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

[Memener]

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

[Bori]

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:

TCPConnection::RecvData(): Error: 10054

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

[Raumuth]

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.