Missing NPCID: 42501 Wounded Infantry v7.0.2

mastermind · Jul 4, 2017

Missing in Gnome starting area. Needed for priests to complete quest (The Arts of a Priest).

Code:

-- --------------------------------------------------------
-- Repack version:               7.0.2
-- Missing NPC need to quest
-- NPCID: 42501 Wounded Infantry 
-- QUESTID: 26200 The Arts of a Priest
-- --------------------------------------------------------

DELETE FROM `creature` where `id` = 42501;
INSERT INTO `creature` (`id`, `map`, `zone`, `area`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `walkmode`) VALUES
(42501, 0, 1, 133, 1, 1, 0, 0, -5073.36, 480.697, 401.773, 5.09961, 300, 0, 0, 1910, 0, 0, 0, 0, 0, 0),
(42501, 0, 1, 133, 1, 1, 0, 0, -5070.24, 482.313, 401.752, 5.17422, 300, 0, 0, 1910, 0, 0, 0, 0, 0, 0),
(42501, 0, 1, 133, 1, 1, 0, 0, -5066.86, 484.792, 401.611, 5.34701, 300, 0, 0, 1910, 0, 0, 0, 0, 0, 0),
(42501, 0, 1, 133, 1, 1, 0, 0, -5064.19, 486.29, 401.639, 5.03286, 300, 0, 0, 1910, 0, 0, 0, 0, 0, 0);

Methusalem · Jul 4, 2017

I have learned a lot considering I knew nothing when Istarted. I can assemble, configure online, and set drop rates, etc in a repacks, but adding to a DB is over my head. lol

ExO · Jul 5, 2017

Confucious said:
I have learned a lot considering I knew nothing when Istarted. I can assemble, configure online, and set drop rates, etc in a repacks, but adding to a DB is over my head. lol

It's a bit same logic as:
https://www.youtube.com/watch?v=CLlhAibDN6k

Just executing directly into the database without opening a .sql file first

Missing NPCID: 42501 Wounded Infantry v7.0.2

mastermind

Methusalem

ExO