EQEmulator Forums - Add stats to NPC

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::General Support (https://www.eqemulator.org/forums/forumdisplay.php?f=598)

- - Add stats to NPC (https://www.eqemulator.org/forums/showthread.php?t=19962)

Ueguvil

01-13-2006 11:23 AM

Add stats to NPC

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

01-13-2006 11:32 AM

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

Code:

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

01-13-2006 11:51 AM

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

01-13-2006 12:51 PM

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

http://eqemulator.net/forums/showthr...234#post116234

Ueguvil

01-19-2006 06:07 PM

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

01-20-2006 03:34 AM

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

01-20-2006 02:04 PM

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

All times are GMT -4. The time now is 09:26 PM.