saben

Karazhan NPC ModelID Updates It is currently a giant sausage fest in Karazhan. This query will attach the remaining correct modelIDs that will add women into the mix. This should include all the missing ModelIDs for Karazhan. ModelIDs pulled from TDB 3.3.5. [Code]-- Spectral Servant UPDATE `creature_template` SET `modelid2`=16465, `modelid3`=16466, `modelid4`=16467 WHERE `entry`=16409; -- Phantom Guest UPDATE `creature_template` SET `modelid2`=16486, `modelid3`=16487, `modelid4`=16488 WHERE `entry`=16407; -- Ghostly Steward UPDATE `creature_template` SET `modelid2`=16536, `modelid3`=16537, `modelid4`=16538 WHERE `entry`=16414; -- Spectral Chef UPDATE `creature_template` SET `modelid2`=16525, `modelid3`=16526, `modelid4`=16527 WHERE `entry`=16411; -- Ghostly Baker UPDATE `creature_template` SET `modelid2`=16530, `modelid3`=16531, `modelid4`=16532 WHERE `entry`=16412; -- Phantom Valet UPDATE `creature_template` SET `modelid2`=16495, `modelid3`=16496, `modelid4`=16497 WHERE `entry`=16408; -- Spectral Sentry UPDATE `creature_template` SET `modelid2`=16459, `modelid3`=16460, `modelid4`=16461 WHERE `entry`=16424; -- Wanton Hostess UPDATE `creature_template` SET `modelid2`=16544, `modelid3`=16545, `modelid4`=16546 WHERE `entry`=16459; -- Concubine UPDATE `creature_template` SET `modelid2`=16552, `modelid3`=16553, `modelid4`=16554 WHERE `entry`=16461; -- Night Mistress UPDATE `creature_template` SET `modelid2`=16548, `modelid3`=16549, `modelid4`=16550 WHERE `entry`=16460; -- Spectral Patron UPDATE `creature_template` SET `modelid2`=16556, `modelid3`=16557, `modelid4`=16558 WHERE `entry`=16468; -- Spectral Performer UPDATE `creature_template` SET `modelid2`=16568, `modelid3`=16569, `modelid4`=18979 WHERE `entry`=16473; -- Phantom Stagehand UPDATE `creature_template` SET `modelid2`=16564, `modelid3`=16565, `modelid4`=16566 WHERE `entry`=16472; -- Ghostly Philanthropist UPDATE `creature_template` SET `modelid2`=16560, `modelid3`=16561, `modelid4`=16562 WHERE `entry`=16470; -- Shadow Pillager UPDATE `creature_template` SET `modelid2`=16905, `modelid3`=16906, `modelid4`=16907 WHERE `entry`=16540; -- Phantom Attendant UPDATE `creature_template` SET `modelid2`=16515, `modelid3`=16516, `modelid4`=16517 WHERE `entry`=16406; -- Spectral Retainer UPDATE `creature_template` SET `modelid2`=16510, `modelid3`=16511, `modelid4`=16512 WHERE `entry`=16410; -- Spectral Stable Hand UPDATE `creature_template` SET `modelid2`=16398, `modelid3`=16399, `modelid4`=16400 WHERE `entry`=15551; -- Spectral Apprentice UPDATE `creature_template` SET `modelid2`=16437, `modelid3`=16440, `modelid4`=16441 WHERE `entry`=16389;

Archmage Leryda NPC_Text Fix Removes unpopulated `NPC_Text` data from Archmage Leryda that prevents players from talking to her (and thus starting the quest chain for the Kara rings.) She has another `Npc_Text` entry that contains her correct gossip that is properly attached to her gossip_menu. -- Remove incorrect text from Leryda DELETE FROM `npc_text` WHERE `id`=10884;

Missing gossip from 8 HFP NPCs (Suggested Fix) Adds sniffed gossip for Forward Commander Maimfist, Apothercary Zelana, Overlord Hun Mainfist, Captain Darkhowl, Grelag, Zezzak, Amilya Airheart and Stone Guard Ambelan. -- Adds gossip to Forward Commander Maimfist SET @GOSSIP := 7955; SET @ENTRY := 19273; SET @NPCTEXT := 9771; UPDATE `creature_template` SET `GossipMenuID`=@GOSSIP WHERE `entry`=@ENTRY; DELETE FROM `gossip_menu` WHERE `entry`=@GOSSIP; INSERT INTO `gossip_menu` (`entry`, `text_id`, `script_id`, `condition_id`) VALUES (@GOSSIP, @NPCTEXT, 0, 0); -- Adds gossip to Apothecary Zelana SET @GOSSIP := 8269; SET @ENTRY := 21257; SET @NPCTEXT := 10293; UPDATE `creature_template` SET `GossipMenuID`=@GOSSIP WHERE `entry`=@ENTRY; DELETE FROM `gossip_menu` WHERE `entry`=@GOSSIP; INSERT INTO `gossip_menu` (`entry`, `text_id`, `script_id`, `condition_id`) VALUES (@GOSSIP, @NPCTEXT, 0, 0); -- Adds gossip to Overlord Hun Maimfist SET @GOSSIP := 7335; SET @ENTRY := 16576; SET @NPCTEXT := 8719; UPDATE `creature_template` SET `GossipMenuID`=@GOSSIP WHERE `entry`=@ENTRY; DELETE FROM `gossip_menu` WHERE `entry`=@GOSSIP; INSERT INTO `gossip_menu` (`entry`, `text_id`, `script_id`, `condition_id`) VALUES (@GOSSIP, @NPCTEXT, 0, 0); -- Adds gossip to Captain Darkhowl SET @GOSSIP := 8495; SET @ENTRY := 22107; SET @NPCTEXT := 10610; UPDATE `creature_template` SET `GossipMenuID`=@GOSSIP WHERE `entry`=@ENTRY; DELETE FROM `gossip_menu` WHERE `entry`=@GOSSIP; INSERT INTO `gossip_menu` (`entry`, `text_id`, `script_id`, `condition_id`) VALUES (@GOSSIP, @NPCTEXT, 0, 0); -- Adds gossip to Grelag SET @GOSSIP := 7348; SET @ENTRY := 16858; SET @NPCTEXT := 8767; UPDATE `creature_template` SET `GossipMenuID`=@GOSSIP WHERE `entry`=@ENTRY; DELETE FROM `gossip_menu` WHERE `entry`=@GOSSIP; INSERT INTO `gossip_menu` (`entry`, `text_id`, `script_id`, `condition_id`) VALUES (@GOSSIP, @NPCTEXT, 0, 0); -- Adds gossip to Zezzak SET @GOSSIP := 8505; SET @ENTRY := 22231; SET @NPCTEXT := 10636; UPDATE `creature_template` SET `GossipMenuID`=@GOSSIP WHERE `entry`=@ENTRY; DELETE FROM `gossip_menu` WHERE `entry`=@GOSSIP; INSERT INTO `gossip_menu` (`entry`, `text_id`, `script_id`, `condition_id`) VALUES (@GOSSIP, @NPCTEXT, 0, 0); -- Adds gossip to Amilya Airheart SET @GOSSIP := 6944; SET @ENTRY := 19558; SET @NPCTEXT := 7778; UPDATE `creature_template` SET `GossipMenuID`=@GOSSIP WHERE `entry`=@ENTRY; DELETE FROM `gossip_menu` WHERE `entry`=@GOSSIP; INSERT INTO `gossip_menu` (`entry`, `text_id`, `script_id`, `condition_id`) VALUES (@GOSSIP, @NPCTEXT, 0, 0); -- Adds gossip to Stone Guard Ambelan SET @GOSSIP := 7958; SET @ENTRY := 19332; SET @NPCTEXT := 9777; UPDATE `creature_template` SET `GossipMenuID`=@GOSSIP WHERE `entry`=@ENTRY; DELETE FROM `gossip_menu` WHERE `entry`=@GOSSIP; INSERT INTO `gossip_menu` (`entry`, `text_id`, `script_id`, `condition_id`) VALUES (@GOSSIP, @NPCTEXT, 0, 0);

Dreadcallers Missing WPs. (Suggested Fix) Currently, the dreadcallers do not patrol in HFP. WPs pulled from TC and converted to fit Mangos DB structure. -- Dreadcaller 1 Pathing SET @NPC := 69499; UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-558.5822,`position_y`=2003.227,`position_z`=98.30606 WHERE `guid`=@NPC; DELETE FROM `creature_movement` WHERE `id`=@NPC; INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `orientation`, `model1`, `model2`) VALUES (@NPC,1,-558.5822,2003.227,98.30606,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,2,-557.4218,2005.291,99.07405,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,3,-559.7542,2056.054,96.38632,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,4,-540.9093,2062.701,104.2178,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,5,-538.0739,2083.637,102.7935,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,6,-531.9629,2100.469,104.145,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,7,-540.8042,2121.509,97.44407,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,8,-542.6715,2139.263,94.42299,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,9,-542.0955,2125.005,96.38588,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,10,-531.0101,2105.611,103.8495,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,11,-533.4691,2097.096,103.5421,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,12,-539.8324,2066.038,103.8721,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,13,-559.5454,2057.871,96.58672,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,14,-557.4636,2005.37,98.92694,0,0,0,0,0,0,0,0,0,0,0,0); -- Dreadcaller 2 Pathing SET @NPC := 69500; UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=233.3709,`position_y`=2074.927,`position_z`=39.10539 WHERE `guid`=@NPC; DELETE FROM `creature_movement` WHERE `id`=@NPC; INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `orientation`, `model1`, `model2`) VALUES (@NPC,1,233.3709,2074.927,39.10539,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,2,228.1582,2076.218,39.70464,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,3,226.8357,2086.181,39.48833,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,4,227.4231,2100.461,39.53439,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,5,231.5971,2104.666,38.92635,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,6,237.6874,2098.439,39.00676,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,7,241.6207,2088.015,38.11906,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,8,238.947,2078.802,38.06547,0,0,0,0,0,0,0,0,0,0,0,0); -- .go 233.3709 2074.927 39.10539 -- Dreadcaller 3 Pathing SET @NPC := 69501; UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=190.7178,`position_y`=2286.323,`position_z`=49.66181 WHERE `guid`=@NPC; DELETE FROM `creature_movement` WHERE `id`=@NPC; INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `orientation`, `model1`, `model2`) VALUES (@NPC,1,190.7178,2286.323,49.66181,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,2,210.6431,2285.845,53.60326,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,3,222.5459,2286.666,56.13475,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,4,231.5569,2296.63,60.31371,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,5,220.7462,2308.746,60.02021,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,6,208.7211,2311.991,57.36103,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,7,195.7977,2312.93,53.85427,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,8,181.254,2297.919,50.28107,0,0,0,0,0,0,0,0,0,0,0,0); -- .go 190.7178 2286.323 49.66181 -- Dreadcaller 4 Pathing SET @NPC := 69502; UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=177.5729,`position_y`=2268.238,`position_z`=48.5948 WHERE `guid`=@NPC; DELETE FROM `creature_movement` WHERE `id`=@NPC; INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `orientation`, `model1`, `model2`) VALUES (@NPC,1,177.5729,2268.238,48.5948,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,2,206.0571,2228.519,54.04856,0,0,0,0,0,0,0,0,0,0,0,0); -- .go 177.5729 2268.238 48.5948 -- Dreadcaller 5 Pathing SET @NPC := 69503; UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-523.7537,`position_y`=2008.213,`position_z`=82.43176 WHERE `guid`=@NPC; DELETE FROM `creature_movement` WHERE `id`=@NPC; INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `orientation`, `model1`, `model2`) VALUE (@NPC,1,-523.7537,2008.213,82.43176,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,2,-513.3772,2034.226,82.13103,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,3,-501.1374,2063.957,81.46646,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,4,-490.7202,2097.977,79.50304,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,5,-495.6437,2124.143,75.1469,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,6,-500.0753,2152.032,70.07507,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,7,-497.6553,2131.211,73.99121,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,8,-488.903,2108.3,78.71799,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,9,-496.6252,2076.111,81.08714,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,10,-505.7927,2051.876,81.88617,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,11,-519.2833,2018.794,82.35017,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,12,-523.7976,2008.294,82.49103,0,0,0,0,0,0,0,0,0,0,0,0); -- .go -523.7537 2008.213 82.43176 -- Dreadcaller 6 Pathing SET @NPC := 69504; UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-506.4011,`position_y`=1982.52,`position_z`=85.11931 WHERE `guid`=@NPC; DELETE FROM `creature_movement` WHERE `id`=@NPC; INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `script_id`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `orientation`, `model1`, `model2`) VALUE (@NPC,1,-506.4011,1982.52,85.11931,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,2,-491.8763,2002.533,90.20009,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,3,-475.5587,2034.282,93.52704,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,4,-459.14,2057.011,93.19531,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,5,-488.9269,2006.812,90.64146,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,6,-506.4684,1982.384,85.10349,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,7,-459.1624,2056.984,93.22046,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,8,-453.0856,2078.318,92.4622,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,9,-458.4782,2105.915,91.30417,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,10,-453.1829,2091.579,91.92897,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,11,-454.6579,2067.877,92.86068,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,12,-471.7339,2040.147,93.86339,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,13,-488.8954,2006.772,90.6447,0,0,0,0,0,0,0,0,0,0,0,0), (@NPC,14,-506.3882,1982.291,85.0636,0,0,0,0,0,0,0,0,0,0,0,0); -- .go -506.4011 1982.52 85.11931

Stormwind Infantry attacks horde at the dark portal First, based on data from TC, I suggest the following changes should be made the creature_template. UPDATE `creature_template` SET `ModelId2`=16419, `FactionAlliance`=1666, `FactionHorde`=1666 WHERE `entry`=16864; As for him attacking horde players, TC allows unit_flags to be overwritten from `creature_template` by adding the value to the `creature` table. Currently there is no unit_flags column in `creature`, so the fix is a little less clear. His unit flags should be 768; however, they should not be applied to the `creature_template` as there are numerous spawned across the zone and the others should be hostile towards horde.