FYI about EQEmu v0.2.7 Release

[Lyenu X`Arie]

The thing is the admin program will be broken.. I'm installing delphi as we speak and I'll work on updating the admin tool to the new DB format so we can release it with 0.2.7.. but I give you no promises on it.

[DeletedUser]

Already got summon working and I can tell you, its not very pretty when Nagafen fights lvl 52's now. I might get banish in there too (with a lvl they banish) if they were to aggro. Just incase if someone wants to go that far into realism.

[Zio]

Keep up the good work!

Soon enough with enough contribution this emu will be done in no time!

[ibleet]

Yes, but with the new tables...EqAdmin will need to updated as well. Any thoughts on updating the program Windcatcher? You gotta do it, your Admin ROCKS! Thanks

[Zeitgeist]

bleet you musta missed Lyenu's post. She is the top of this page (yes, SHE!).

[ibleet]

If Lyenu is NOT Windcatcher, then I have no idea what you are rambling about. Either way, it's no big deal. Heh

[DeletedUser]

For converting the database from the old one, it is possible, but it would be missing a lot of data then. Where would you get values for the damage columns, what spells they cast, what abilities they have, etc? Just put 0 for everything and it only stands there?


Also, the spells will be a number list of what they can cast. An Example

982 1919 17

That would let it death touch, cast guide journey and loh (If my numbers are right).

[Drawde]

I hope this isn't too much trouble, but could you post a list of the variables that are going to be added to the DB (especially the npc_types table) and roughly what they do? If I've got this information then I can add it to my EQNPC parser program now and therefore get a 2.7-compatible DB addon released ASAP when 2.7 comes out.

[Hmm]

you forgot reuse delay. suppose guy was HTing very rapidly? ( ie: one right after another ) it'd be undefeatable.

[DeletedUser]

If people wish to start working on their db:
npc_types columns:
min_dmg int(10)
max_dmg int(10)
those are obvious
banish char(1)

Char ----- Effect
-----------------
A Summon
B Enrage
C Rampage
D Flury
E Summon, Enrage, Rampage, Flury
F Summon, Enrage
G Summon, Rampage
H Summon, Flury
I Enrage, Rampage
J Enrage, Flury
K Summon, Enrage, Rampage
L Summon, Enrage, Flury
M Summon, Rampage, Flury
N Enrage, Rampage, Flury

you would put the char next to the effect to use those features.

This is just a heads up.

[DeletedUser]

This is the current table structure in our Private CVS

#
# Table structure for table `npc_types`
#

CREATE TABLE npc_types (
id int(11) NOT NULL auto_increment,
name text NOT NULL,
level tinyint(2) unsigned NOT NULL default '0',
race tinyint(2) unsigned NOT NULL default '0',
class tinyint(2) unsigned NOT NULL default '0',
hp int(11) NOT NULL default '0',
gender tinyint(2) unsigned NOT NULL default '0',
texture tinyint(2) unsigned NOT NULL default '0',
helmtexture tinyint(2) unsigned NOT NULL default '0',
size float NOT NULL default '0',
hp_regen_rate int(11) unsigned NOT NULL default '0',
mana_regen_rate int(11) unsigned NOT NULL default '0',
loottable_id int(11) unsigned NOT NULL default '0',
merchant_id int(11) unsigned NOT NULL default '0',
mindmg int(10) unsigned NOT NULL default '0',
maxdmg int(10) unsigned NOT NULL default '0',
usedspells char(22) NOT NULL default '',
npcspecialattks char(1) NOT NULL default '',
banish int(10) unsigned NOT NULL default '0',
aggroradius int(10) unsigned NOT NULL default '0',
social int(10) unsigned NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;

image: Changed usedspells to char(22), no way I can make them use spells with 1 letter/number.

[Drawde]

Thanks very much, I'll try and get that in ASAP. Configurable NPC damage will be very useful.
Two questions -
-Is the usedspells value a string containing the spell numbers, e.g "982 13 17" ?
-What is the hard-coded aggro radius currently used by EQEmu? For now I'll just give all NPCs in my DB this aggro radius.