All pastes #587211 Raw Edit

272_quest_template.sql

public sql v1 · immutable
#587211 ·published 2007-06-24 11:06 UTC
rendered paste body
-- Taming Beast, Troll side... Part Where you kill:Adult Plainstrider. UPDATE `quest_template` SET `reqspellcast1`=19688 WHERE entry = 6061;-- Goblin Sponsorship Part 5, Item was Dropped on Normal Drop Should be Source Item.UPDATE `quest_template` SET `ReqSourceId1`=5851,`ReqSourceCount1`=1 WHERE `entry`=1182;-- Below: Patch Provide By NoFantasy ;) thx you./*Quest : 9370*Quest Name : The Cleansing Must Be Stopped*Location : Hellfire Peninsula*Faction : Horde*Quest Guiver : Ryathen the Somber*Quest Level / Min Level Req : 62 / 60*Reason for not working : Missing Source Item*/UPDATE quest_template SET srcItemId = 23358, srcItemCount = 1 WHERE entry = 9370;/*Quest : 9391*Quest Name : Marking the Path*Location : Hellfire Peninsula*Faction : Horde*Quest Guiver : Ranger Captain Venn'ren*Quest Level / Min Level Req : 62 / 60*Reason for not working : Missing Source Item, And GameObject not reacting to SpellCast by Source Item (29384)*/UPDATE quest_template SET srcItemId = 23480, srcItemCount = 1 WHERE entry = 9391;UPDATE quest_template SET ReqSpellCast1 = 29384, ReqSpellCast2 = 29384, ReqSpellCast3 = 29384 WHERE entry = 9391;UPDATE quest_template SET ReqCreatureOrGOId3 = -181581 WHERE entry = 9391;/*Quest : 10161 *Quest Name : In Case of Emergency... *Location : Hellfire Peninsula *Faction : Both *Quest Guiver : "Screaming" Screed Luckheed *Quest Level / Min Level Req : 61 / 58 *Reason for not working : All GameObject Not having Loot ID */UPDATE `gameobject` SET `Loot` = 183394 WHERE `id`=183395;UPDATE `gameobject` SET `Loot` = 183394 WHERE `id`=183396;UPDATE `gameobject` SET `Loot` = 183394 WHERE `id`=183397;/*BAD FLAGS ON MOB* Mob Attacking Character, While Character cannot Attack or Target* Tunneler ( 16968 )*/UPDATE creature_template SET `flags` = 0 WHERE `entry` = 16968;/* Uncontrolled VoidWalker ( 16975 )*/UPDATE creature_template SET `flags` = 0 WHERE `entry` = 16975;/* Crust Burster ( 16844 )*/UPDATE creature_template SET `flags` = 0 WHERE `entry` = 16844;