Missing NPCID: 4254 Geofram Bouldertoe (Mining Trainer) Ironforge

[mastermind]

Fix for missing mining trainer in Ironforge.

-- --------------------------------------------------------
-- Repack version:               7.0.2
-- Missing NPC (Mining trainer in Ironforge)
-- NPCID: 4254 Geofram Bouldertoe 
-- --------------------------------------------------------

DELETE FROM `creature` where `id` = 4254;
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
(4254, 0, 1537, 5342, 1, 1, 0, 4254, -4709.3, -1107.14, 504.447, 5.75103, 300, 0, 0, 1342, 0, 0, 0, 0, 0, 0);

 

[Methusalem]

I do not know how to apply/make fixes for database. It is why I don't offer to help on repacks. Anything I do to a repack is set-of-the-pants gueswork. "like a shadetree mechanic" lol But I do know that anything posted by members gets used in future repacks. So thank you for helping.

 

[mastermind]

You're Welcome.

Anything to advance the project. If there is not a tutorial on how to add these type patches/fixes already floating around I may create one. I remember seeing a patcher (java based) in one post but I can not seem to locate it at the moment.

It can be a little intimidating at first but, as with most things in life, once you know the steps involved it is not to difficult.

 

[Methusalem]

You're Welcome.

Anything to advance the project. If there is not a tutorial on how to add these type patches/fixes already floating around I may create one. I remember seeing a patcher (java based) in one post but I can not seem to locate it at the moment.

It can be a little intimidating at first but, as with most things in life, once you know the steps involved it is not to difficult.

I have been there with Navicat. The first "several times" I broke the server, or glitched things, but now Ican modify a lil safely with it. lol

 

[ExO]

I do not know how to apply/make fixes for database. It is why I don't offer to help on repacks. Anything I do to a repack is set-of-the-pants gueswork. "like a shadetree mechanic" lol But I do know that anything posted by members gets used in future repacks. So thank you for helping.

I made a small (very short gyazo gif), on how to do it with HeidiSQL (a database program):
https://gyazo.com/c2254eda3496ab09cc29771b1b540b99

Hope it helps