PDA

View Full Version : Beta 4 of my DB addon, plus updated EQNPC parser


Drawde
02-23-2003, 09:15 PM
http://edwardpinniger.bctalk.net/eq/worlddata1.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.

linnx
02-25-2003, 04:41 AM
Is this compatible with eqemu 0.4.2???

DeletedUser
02-26-2003, 07:32 AM
since it was just posted. I'm pretty sure he'd post a working version. :D

Drawde
02-26-2003, 08:54 AM
Yes, it's fully compatible with 4.2 (it has the new resist values in npc_types etc.)

hiddenfear
02-26-2003, 09:08 AM
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 :)

izagod
02-26-2003, 07:38 PM
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

izagod
02-26-2003, 09:24 PM
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? :(

Trumpcard
02-27-2003, 02:34 AM
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...

Drawde
02-27-2003, 07:59 AM
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.

hiddenfear
02-27-2003, 08:26 AM
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

izagod
02-27-2003, 09:35 AM
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.

izagod
02-27-2003, 09:43 AM
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.

Trumpcard
02-27-2003, 09:48 AM
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.

izagod
02-27-2003, 08:02 PM
: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

Monrezz
03-16-2003, 08:48 AM
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....

Drawde
03-16-2003, 08:58 AM
I'm working on a 0.4.3-compatible version and should hopefully have it finished within 2 or 3 days. It should have quite a few fixes and additions in addition to being fully 4.3-compatible.

cybermax
03-17-2003, 12:39 AM
And one more thing.. Does the "hostile" npc's attack you? Ie. are you KOS to mobs?

Drawde
03-17-2003, 03:12 AM
Yes, I've got factions working OK now, and KOS creatures will aggro.
I'm working on improving the faction list, so all the different "guilds" in a city have their own faction as in EQLive, but haven't finished it yet. Also eventually I'll add faction bonuses for killing things like orcs.

brainleacher
03-17-2003, 04:59 AM
I'm hosting your db on my local LAN, since my connection is too slow to hook up to EQemu's minilogin (144k IDSL)... The game's very very much playable. Koodos to you and the EQemu developers.

A quick request if you don't mind. I know that wandering mobs is now supported on the server side engine, does your source db have the grid points data? Is this info collected in the zone collector that you're using? (the one from hackersquest right?) If so, it would be great if you could put it in a release some time, cuz it adds ALOT to the game. Thanks..

Shatan
03-17-2003, 06:57 AM
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

I am getting this error also how did you fix it

thanks

Shatan
03-17-2003, 07:01 AM
I dont have any spells, equipment. The game runs I dont know how to get that stuff. I have down loaded all that I have found. Can someone tell me what I am doing wrong. If I do an item search I get nothing. My char didnt start with spells. I have no npc's in game. Someone please help

Mauritius
03-19-2003, 12:40 AM
you have to wait until a 4.3 compatible database is out, thats all

Mauritius
03-19-2003, 12:40 AM
you have to wait until a 4.3 compatible database is out, thats all

:arrow: we are all sitting in the same boat