Add stats to NPC

[Ueguvil]

I'm on 6.0, and my database (PEQ) doesn't appear to have any NPC stats (i.e. Dex, Str, Agi, etc) in npc_types. I was wondering what the commands what be to add them in MySQL. Thanks. :)

[sesmar]

save this to a file and source it into your Database to add the stats to your Database.


ALTER TABLE npc_types ADD STR MEDIUMINT UNSIGNED NOT NULL DEFAULT '75';
ALTER TABLE npc_types ADD STA MEDIUMINT UNSIGNED NOT NULL DEFAULT '75';
ALTER TABLE npc_types ADD DEX MEDIUMINT UNSIGNED NOT NULL DEFAULT '75';
ALTER TABLE npc_types ADD AGI MEDIUMINT UNSIGNED NOT NULL DEFAULT '75';
ALTER TABLE npc_types ADD _INT MEDIUMINT UNSIGNED NOT NULL DEFAULT '80';
ALTER TABLE npc_types ADD WIS MEDIUMINT UNSIGNED NOT NULL DEFAULT '75';
ALTER TABLE npc_types ADD CHA MEDIUMINT UNSIGNED NOT NULL DEFAULT '75';
UPDATE npc_types SET _INT=80 WHERE _INT=75;
UPDATE npc_types SET _INT=60 WHERE _INT=80 AND ( bodytype=3 OR bodytype=8);


Orginally added by FNW in the ChangeLog

[Ueguvil]

Thanks, I put it in and set the Str, Agi, and Dex of some dragons to 250. Before, I pretty much never missed them, and they missed me a lot, and even with the change to 250, I see no difference. Do you know what may be causing this?

[sesmar]

You also might want to look into this thread for setting NPC stats.

http://eqemulator.net/forums/showthread.php?p=116234#post116234

[Ueguvil]

Ok so, doesn't matter what I set NPCs stats to in MYSQL front, it always comes up as 75 in #showstats ingame. This sucks, because I hardly ever miss on high level mobs, and they hardly ever hit me. Anyone know how to fix this, it would be really appreciated.

[mystic414]

6.0 servers don't support npc stats. It was fixed in later versions (check the changelog). So your options are, upgrade to a newer server version, or merge the newer code into your server, which will probably be difficult to do, and may or may not function as expected, since many things have been rewritten in the newer server versions.

[Ueguvil]

Thanks, that clears things up. I might just give the tougher mobs stat buffs, as that seems to work.