Mob HP and Loot past GoD expansion

[colin111]

Okay i am having a problem with Mob HP and Loot past GoD expansion. Mob HP is way too low for the levels but i know how to modify HP on a mass scale.

Loot on the other hand is non existent for all mobs in zones post GoD. Did i do something wrong when setting up my server? Is there an easy fix? I have peqdb_Rev1751.sql and Rev1741 binaires. Any help is welcome. Thanks in advance!

[Karayrem]

it hasn't been worked on yet. PEQ is currently on GoD and won't work on OoW or up until GoD is completed. I think they will released a new database when GoD is complete. Although anything pass GoD exist on the database, it just has not been update for faction, hp, loot and etc.

[colin111]

Ahh okay thanks. Thats what i figured but just wanted to verify on here. Thanks again for your reply.

[ChaosSlayerZ]

you can modify hps like this:

update npc_types set hp=X where id>A and id<B;

X will be whatever formula you want use - like 1000*level
A and B are npc ids range that you want to modify

backup your DB before running any code ;)

[colin111]

Thanks for both of your replies.

So is there no way at all that i can add loot to the mobs in the zones after GoD?

Sorry, i am a new to this.

[blackdragonsdg]

You can add and remove loot from any npc in your database. If you are new then the simplest way would be to use the npc_loot editor. It can be found here:
http://www.georgestools.eqemulator.net/GeorgeS_EqEmu_Files.zip

If you want to learn how it actually works then you can create everything manually. The following example uses custom id's so using it on your database WILL NOT work.

loottable & lootdrop example:
delete from lootdrop where id = 750022;
INSERT INTO `lootdrop` (`id`, `name`) VALUES (750022, 'Ashengate_Normal');
delete from loottable where id = 750022;
INSERT INTO `loottable` (`id`, `name`, `mincash`, `maxcash`, `avgcoin`) VALUES (750022, 'Ashengate_Normal', 100000, 300000, 0);
delete from loottable_entries where loottable_id = 750022;
INSERT INTO `loottable_entries` (`loottable_id`, `lootdrop_id`, `multiplier`, `probability`) VALUES (750022, 750022, 1, 7);
INSERT INTO `loottable_entries` (`loottable_id`, `lootdrop_id`, `multiplier`, `probability`) VALUES (750022, 750023, 1, 5);
delete from lootdrop_entries where lootdrop_id = 750022;delete from lootdrop_entries where lootdrop_id = 750023;
INSERT INTO `lootdrop_entries` (`lootdrop_id`, `item_id`, `item_charges`, `equip_item`, `chance`) VALUES (750022, 219834, 1, 0, 50);
INSERT INTO `lootdrop_entries` (`lootdrop_id`, `item_id`, `item_charges`, `equip_item`, `chance`) VALUES (750022, 219835, 1, 0, 50);
INSERT INTO `lootdrop_entries` (`lootdrop_id`, `item_id`, `item_charges`, `equip_item`, `chance`) VALUES (750023, 219616, 1, 0, 5);


After creating the above you will need to assign the loottable_id to the npc you want the loot to drop from. In this case inserting loottable_id 750022 into an npc's loottable_id field would cause that npc to drop the specified items.

[colin111]

You guys are awesome. Thanks!