Spawn/world data 0.6
 

Sorry it's been so long since the last version, but you can now get version
0.6 from http://www.innersystems.com/~drawde/worlddata0.6.zip
It should be compatible with both 0.2.3 and 0.2.4 (however you will be unable
to buy or sell from the merchants in the current 0.2.4 beta, though you can
see what things they sell)

New things in this version -
More or less complete merchant item lists
Basic faction data (one faction per race at the minute; I'll add individual factions and monster clans later)
Lots of Z coordinate fixes (still a lot to do though, especially in dungeons)
Armour/robe textures for NPCs (based on class and level)
More zone points (though they don't work at the minute)
Many other small changes, bugfixes and additions to NPC and loot table data.

Most city zones are working properly now, however Neriak and Paineel are still very buggy especially with Z coordinates.

Merchant lists include "generic" ones for various types of weapons, armour, supplies, jewellery etc.,
tradeskill item merchants (though tradeskills don't work in the emulator ATM), food and drink (different for
each race) as well as unique weapon, armour and artifact merchants for each race selling high-value magic items.

Any feedback on bugs (especially crashes and "bogus item" errors with merchants) would be very helpful!
There are (in 2.3 at least) some problems with gold and platinum not being subtracted when you buy things, and stackable/chargable
items (e.g food or potions) being deleted when bought due to having zero charges. However this is a bug in the EQEmu code
and has nothing to do with the merchant list data.

Url Not found =P

The requested URL /~drawde/worlddata0.6.zip. was not found on this server

nevermind....it was just me.....

take the period of the end of the url....:p

A good item to add would be Bladestorm, Katana of Steel Sleet. That sword was badass ;)

That weapon isn't in the item DB unfortunately..
Also, many high-value/quest items have a value of either 0 or 1cp, so can't really be sold by merchants. Some of those that do have realistic money values I've added to the "artifact" merchant lists (usually one for each city and race)

Ah, it's not a question item by the way. It was dropped from Dracoliche in Fearplane. Verant saw it as too powerful, and took it out. They replaced it with monsoon(shudder). Bladestorm was awesome :D

If you need stats of it, you can find it at www.everlore.com

using 0.2.4 pre5 emu

i am getting this error on npc_types.txt

ERROR 1136: Column count doesn't match value count at row 1

had to add merchant_id to the database
with type int(11) unsigned

not sure why it wasnt there before but works now

Easier
 

I was wondering if you had a link to a db.sql file that already had all the changes made to it. I could go through and copy and paste all of the files but I am worried I will break it by pasting it in the wrong place or without deleting the # that are in place of the --. Any way I can get a db.sql file that already has these things in place?

You don't need a completely integrated foo.sql file -- eventhough that would be nice.

I haven't had any problems taking the .txt files from Drawde's distribution and renaming them to .sql files. I then just add them into my "eq" database via mysql as follows:

You will get a few beeps due to duplicated db entries, but it works.

i didnt even bother to rename em and it works.

For an easy install batch file, see this post

Oh and if you turn echo on, it nicely outputs the import errors to the dos window. Mostly duplicate Key values, but it works just fine anyhow.

With the next version I'll release a complete db file as well as the seperate .txt files, to make it easier to install. I'll still distribute the .txt files so people can merge the data with their own DB changes.

ETA on Next Version?
 

ETA on Next Version?