EQEmulator Forums - Grobb fixes

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

- Development::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=596)

- - Grobb fixes (https://www.eqemulator.org/forums/showthread.php?t=23918)

Added all these fixes to ax_classic with no problems

Also merged into PEQ, with no issue.

Eh, spoke too soon.

In PEQ, 50311 is a_bandit and 50300 is Sir_Edwin_Motte who now looks like a new mechanical spider ;) I'll get these fixed up and post the SQL here.

I hadn't checked all the way through, but I did see a dupe error. was going to look this weekend. maybe need to delete/ old spawns and npcs before putting in new.
In all, it's still a great imrovement

Code:

--change the shapeshifter Motte back to human form

update npc_types set race = 1 where id = 50300;

--a_domesticated_bleeder

INSERT INTO `npc_types` VALUES (52103,'a_domesticated_bleeder','',1,134,1,22,11,2,0,0,2,2,0,0,0,0,0,1,2,'',50,0,0,0,0,0,0,0,0,0,0.75,1,1,1,1,1,0,1,0,5,0,0,0,0,68,68,63,68,76,63,58,0,0,1,0,1);

--a_domesticated_bleeder spawn

update spawnentry set npcid = 52103 where npcid = 50311 and spawngroupid = 52096;

--a jungle hatching

INSERT INTO `npc_types` VALUES (52104,'a_jungle_hatchling','',1,440,1,22,11,2,2,0,2,2,0,0,0,0,0,1,2,'',50,0,0,0,0,1,0,0,0,0,1,1,1,1,1,1,0,1,0,21,0,0,0,0,79,79,79,79,79,79,79,0,0,1,0,1);

--a jungle hatching spawn

update spawnentry set npcid = 52104 where npcid = 50300 and spawngroupid = 52095;

I think what happened was you are using the pre-Rathe Mountains overhaul of PEQ to grab the other NPCs from, so that's why the IDs got messed up.

Woops. Didn't realize those changes had been made. Sorry for the screw up. I will D/L a newer version before I make anymore changes. Cave, do you have a changelog somewhere and I just missed it ?

Sadly, I am horrible about keeping a changelog. I do it for a few days, then forget about keeping it up to date. One day I will work out a system that documents what I do without me having to do much ;)