Beta 4 of my DB addon, plus updated EQNPC parser
 

http://edwardpinniger.bctalk.net/eq/...ta1.1beta4.zip
http://edwardpinniger.bctalk.net/eq/eqnpc.zip

I've also (finally) uploaded a new version of EQNPC, the parser/converter utility
I use to generate the spawn data - this version supports resists and the city_defense table
as well as having a new min/max damage formula and an up-to-date source NPC list. This might help out other people who want to add NPCs.

New things in this version:
Added NPC spawns to Shar Vahl, the Nexus and the Bazaar (Next version of my quest addon will include Nexus Scion scripts).
Fixed + itemised Lower and Upper Guk
Updated Greater Faydark with new creature types (arboreans, sylvan bats etc)
Added City Defence data
Added resistances data to npc_types (base resists are determined by race, e.g undead are resistant to poison/disease, and increased according to the NPC's level)
More tradeskill recipes (baking and brewing, plus some "newbie" quest armour - scripts to obtain the moulds + assembly kits for the latter will be in my next quest addon)
More loot tables (still unfinished)
Modified + added to merchant lists, using the new 80-item cap (again, still unfinished). Also, you can buy horse bridles from the Bazaar merchants.
Adjusted NPC min/max damage formula (it's higher now, to compensate for the new AC damage reduction code which was resulting in NPCs not hitting hard enough)
Fixed some creatures that had far too many HPs for their level (lizardmen in Feerrott, skeletons in Qeynos Hills)
Fixed some NPCs being on the wrong faction (notably Sir Edwin Motte being on the Bloodsabres faction and killing any non-evil players that went near him..)

Next version (1.1 final) should include -
Fixed Kunark outdoor zones
Fixed spawns/Z locs for Sebilis, Najena, Chardok and maybe some other dungeons
Loot tables for all old world and Kunark monster types (hopefully)
Merchant lists assigned properly in Erudin and Cabilis
More tradeskill recipes (jewelcraft, fletching, smithed armour)
Might be a while till I finish this version though since I haven't had much time to work on EQEmu lately.

Is this compatible with eqemu 0.4.2???

since it was just posted. I'm pretty sure he'd post a working version. :D

Yes, it's fully compatible with 4.2 (it has the new resist values in npc_types etc.)

I installed your worlddata, I went to test in game and there where no NPCs anywhere. Do I need the EQNPC installed too? If so, how do I install it? I`m a noob to all this :)

Error 1054
 

i put this db addon in and ran the mysql commands and its repeatedly giving error 1054 its been 10min and its still going
it says ERROR 1054 UKNOWN COLUMN 'MR' IN 'FIELD LIST'
did i break it? ahh its all over now! the rain of fire from hell has desnded upon my computer that runs the Endless Time Server! :(

hope you can help me out with this hehe

ok my bad it takes a few min, so scratch that error, it seems i was in a hurry, :roll: but now i dont have any npcs what happend? :(

Are you sure youve upgraded your db.sql file for 4.2 ?

go into mysql and type

use eq;
describe npc_types;

and paste the output...

That error is definitely caused by your DB being out of date - the resist values (MR, FR etc) were added in the 4.2 db.

I figured out how to install your addons. The first couple times no NPCs would show, but I figured it out. but, one question. Does this addon just have a few spawns and such or what? I seem to not be able to use PoP AA Points, a few SoL AA Class points, and there are no quests. Where those or some of those included, need to be activated somehow? Or do I have to do that my self? Sorry I`m a noob trying to learn this stuff :)

-Ellusion

heres what i get when i do what you sayd trump
 

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13 to server version: 3.23.55-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.


mysql> use eq;
Database changed
mysql> describe npc_types;
+-------------------+----------------------+------+-----+---------+-------------
---+
| Field | Type | Null | Key | Default | Extra
|
+-------------------+----------------------+------+-----+---------+-------------
---+
| id | int(11) | | PRI | NULL | auto_increme
nt |
| name | text | | | |
|
| level | tinyint(2) unsigned | | | 0 |
|
| race | smallint(5) unsigned | | | 0 |
|
| class | tinyint(2) unsigned | | | 0 |
|
| bodytype | int(11) | YES | | NULL |
|
| hp | int(11) | | | 0 |
|
| gender | tinyint(2) unsigned | | | 0 |
|
| texture | tinyint(2) unsigned | | | 0 |
|
| helmtexture | tinyint(2) unsigned | | | 0 |
|
| size | float | | | 0 |
|
| hp_regen_rate | int(11) unsigned | | | 0 |
|
| mana_regen_rate | int(11) unsigned | | | 0 |
|
| loottable_id | int(11) unsigned | | | 0 |
|
| merchant_id | int(11) unsigned | | | 0 |
|
| mindmg | int(10) unsigned | | | 0 |
|
| maxdmg | int(10) unsigned | | | 0 |
|
| usedspells | varchar(70) | | | |
|
| npcspecialattks | varchar(5) | | | |
|
| banish | int(10) unsigned | | | 0 |
|
| aggroradius | int(10) unsigned | | | 0 |
|
| social | int(10) unsigned | | | 0 |
|
| face | int(10) unsigned | | | 1 |
|
| luclin_hairstyle | int(10) unsigned | | | 1 |
|
| luclin_haircolor | int(10) unsigned | | | 1 |
|
| luclin_eyecolor | int(10) unsigned | | | 1 |
|
| luclin_beardcolor | int(10) unsigned | | | 1 |
|
| fixedz | tinyint(2) unsigned | | | 0 |
|
| d_meele_texture1 | int(10) unsigned | | | 0 |
|
| d_meele_texture2 | int(10) unsigned | | | 0 |
|
| walkspeed | float | | | 0 |
|
| runspeed | float | | | 0 |
|
+-------------------+----------------------+------+-----+---------+-------------
---+
32 rows in set (0.07 sec)

mysql>

im not the best at this so i dont rely have the best idea on what this means but i dont think its right.

I have the db.sql for 4.2
 

I have the db.sql for 4.2, its -- EQEmu 0.3.9 Database
i have gone to msql.exe and typed use eq then source db.sql, after installing the wolrd data, trying to get the spawns to come back, but it runs and gives me a ton of duplicate entry errors then when its done i still have spawns.

The table above that was in your database was wrong, none of the new fields existed , so that makes me think your database never got upgraded properly.

This is what you do.

drop database eq;
create database eq;
source db.sql;
describe npc_types;

This time, make sure the resistance fields are in it. MR,FR,CR, etc.
If they are not, you have the wrong db.sql file from somewhere.

Then source in Drawdes database again. This should fix your problem.

:D :D :D Thanks For all the help Every thing works now i also realy like the work in the beta4 of this data! Great job :o

Valudus - Endless Time Server

Will this add spawns to the Emu v4.3 zones?

Currently, I don't have any monsters In game (at all).

No bankers, No shopkeepers, No monsters....