From 0a014e1431647cc008cc4af760eb6d7a0e35d046 Mon Sep 17 00:00:00 2001 From: joschiwald Date: Thu, 17 Apr 2014 00:09:43 +0200 Subject: Scripts/UtgardeKeep: fixed some issues on Ingvar the Plunderer Closes #10859 --- sql/updates/world/2014_04_17_00_world_misc.sql | 29 ++++++++++++++++++++++++++ 1 file changed, 29 insertions(+) create mode 100644 sql/updates/world/2014_04_17_00_world_misc.sql (limited to 'sql') diff --git a/sql/updates/world/2014_04_17_00_world_misc.sql b/sql/updates/world/2014_04_17_00_world_misc.sql new file mode 100644 index 00000000000..9deeb5ddef0 --- /dev/null +++ b/sql/updates/world/2014_04_17_00_world_misc.sql @@ -0,0 +1,29 @@ +DELETE FROM `spelldifficulty_dbc` WHERE `id`=42739; +INSERT INTO `spelldifficulty_dbc` (`id`, `spellid0`, `spellid1`) VALUES +(42739,42739,59736); + +DELETE FROM `spell_script_names` WHERE `spell_id` IN (42730,59735,42912); +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(42730,'spell_ingvar_woe_strike'), +(59735,'spell_ingvar_woe_strike'), +(42912,'spell_ingvar_summon_banshee'); + +UPDATE `creature_text` SET `entry`=23980, `groupid`=`groupid`-3 WHERE `entry`=23954 AND `groupid` IN (3,4,5); + +UPDATE `creature_template` SET `flags_extra`=0 WHERE `entry` IN (23997,31835); + +UPDATE `creature_template` SET `mingold`=0, `maxgold`=0, `lootid`=0 WHERE `entry` IN (23954,31673); +UPDATE `creature_template` SET `mingold`=4056, `maxgold`=6760, `lootid`=23980 WHERE `entry`=23980; +UPDATE `creature_template` SET `mingold`=8112, `maxgold`=13520, `lootid`=31674 WHERE `entry`=31674; + +UPDATE `creature_loot_template` SET `entry`=23980 WHERE `entry`=23954; +UPDATE `creature_loot_template` SET `entry`=31674 WHERE `entry`=31673; + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=1 AND `SourceGroup` IN (23980,31674,23954,31673); +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(1,23980,43228,0,0,1,0,57940,0,0,0,0,0,'','Can loot Stone Keeper''s Shard only with aura Essence of Wintergrasp'), +(1,31674,43228,0,0,1,0,57940,0,0,0,0,0,'','Can loot Stone Keeper''s Shard only with aura Essence of Wintergrasp'); + +UPDATE `instance_encounters` SET `creditEntry`=23980 WHERE `entry` IN (575,576); + +UPDATE `creature_template` SET `InhabitType`=4 WHERE `entry` IN (24068,31655); -- cgit v1.2.3