From f731116766268a38a58572e57cc8abbac400c5ca Mon Sep 17 00:00:00 2001 From: joschiwald Date: Thu, 23 Jan 2014 18:21:17 +0100 Subject: Scripts/AhnKahet: fix some issues on prince taldaram script --- sql/updates/world/2014_01_17_00_trinity_string.sql | 8 -------- sql/updates/world/2014_01_17_00_world_trinity_string.sql | 8 ++++++++ sql/updates/world/2014_01_23_01_conditions.sql | 5 ----- sql/updates/world/2014_01_23_01_world_conditions.sql | 5 +++++ sql/updates/world/2014_01_23_02_sai.sql | 2 -- sql/updates/world/2014_01_23_02_world_sai.sql | 2 ++ sql/updates/world/2014_01_23_03_conditions.sql | 3 --- sql/updates/world/2014_01_23_03_world_conditions.sql | 3 +++ sql/updates/world/2014_01_23_04_game_event_creature.sql | 6 ------ .../world/2014_01_23_04_world_game_event_creature.sql | 6 ++++++ sql/updates/world/2014_01_23_05_creature_template.sql | 2 -- sql/updates/world/2014_01_23_05_world_creature_template.sql | 2 ++ sql/updates/world/2014_01_23_06_creature.sql | 4 ---- sql/updates/world/2014_01_23_06_world_creature.sql | 4 ++++ sql/updates/world/2014_01_23_07_spell_bonus_data.sql | 3 --- sql/updates/world/2014_01_23_07_world_spell_bonus_data.sql | 3 +++ sql/updates/world/2014_01_23_08_graveyard.sql | 4 ---- sql/updates/world/2014_01_23_08_world_graveyard.sql | 4 ++++ sql/updates/world/2014_01_23_09_npc_trainer.sql | 4 ---- sql/updates/world/2014_01_23_09_world_npc_trainer.sql | 4 ++++ sql/updates/world/2014_01_23_10_creature_loot_template.sql | 2 -- .../world/2014_01_23_10_world_creature_loot_template.sql | 2 ++ sql/updates/world/2014_01_23_11_creature_template.sql | 2 -- sql/updates/world/2014_01_23_11_world_creature_template.sql | 2 ++ sql/updates/world/2014_01_23_12_sai.sql | 8 -------- sql/updates/world/2014_01_23_12_world_sai.sql | 8 ++++++++ sql/updates/world/2014_01_23_13_world_misc.sql | 13 +++++++++++++ 27 files changed, 66 insertions(+), 53 deletions(-) delete mode 100644 sql/updates/world/2014_01_17_00_trinity_string.sql create mode 100644 sql/updates/world/2014_01_17_00_world_trinity_string.sql delete mode 100644 sql/updates/world/2014_01_23_01_conditions.sql create mode 100644 sql/updates/world/2014_01_23_01_world_conditions.sql delete mode 100644 sql/updates/world/2014_01_23_02_sai.sql create mode 100644 sql/updates/world/2014_01_23_02_world_sai.sql delete mode 100644 sql/updates/world/2014_01_23_03_conditions.sql create mode 100644 sql/updates/world/2014_01_23_03_world_conditions.sql delete mode 100644 sql/updates/world/2014_01_23_04_game_event_creature.sql create mode 100644 sql/updates/world/2014_01_23_04_world_game_event_creature.sql delete mode 100644 sql/updates/world/2014_01_23_05_creature_template.sql create mode 100644 sql/updates/world/2014_01_23_05_world_creature_template.sql delete mode 100644 sql/updates/world/2014_01_23_06_creature.sql create mode 100644 sql/updates/world/2014_01_23_06_world_creature.sql delete mode 100644 sql/updates/world/2014_01_23_07_spell_bonus_data.sql create mode 100644 sql/updates/world/2014_01_23_07_world_spell_bonus_data.sql delete mode 100644 sql/updates/world/2014_01_23_08_graveyard.sql create mode 100644 sql/updates/world/2014_01_23_08_world_graveyard.sql delete mode 100644 sql/updates/world/2014_01_23_09_npc_trainer.sql create mode 100644 sql/updates/world/2014_01_23_09_world_npc_trainer.sql delete mode 100644 sql/updates/world/2014_01_23_10_creature_loot_template.sql create mode 100644 sql/updates/world/2014_01_23_10_world_creature_loot_template.sql delete mode 100644 sql/updates/world/2014_01_23_11_creature_template.sql create mode 100644 sql/updates/world/2014_01_23_11_world_creature_template.sql delete mode 100644 sql/updates/world/2014_01_23_12_sai.sql create mode 100644 sql/updates/world/2014_01_23_12_world_sai.sql create mode 100644 sql/updates/world/2014_01_23_13_world_misc.sql (limited to 'sql') diff --git a/sql/updates/world/2014_01_17_00_trinity_string.sql b/sql/updates/world/2014_01_17_00_trinity_string.sql deleted file mode 100644 index 698af0f56cb..00000000000 --- a/sql/updates/world/2014_01_17_00_trinity_string.sql +++ /dev/null @@ -1,8 +0,0 @@ -DELETE FROM trinity_string where entry in (11002, 11003, 11004, 11005, 11006, 11007); -INSERT INTO `trinity_string` VALUES -('11002', 'Server: %s has kicked %s, reason: %s', '', '', '', '', '', '', '', ''), -('11003', 'Server: %s has muted %s for %u minutes, reason: %s', '', '', '', '', '', '', '', ''), -('11004', 'Server: %s has banned character %s for %s, reason: %s', '', '', '', '', '', '', '', ''), -('11005', 'Server: %s has banned character %s permanetly, reason: %s', '', '', '', '', '', '', '', ''), -('11006', 'Server: %s has banned %s for %s, reason: %s', '', '', '', '', '', '', '', ''), -('11007', 'Server: %s has banned %s permanetly, reason: %s', '', '', '', '', '', '', '', ''); diff --git a/sql/updates/world/2014_01_17_00_world_trinity_string.sql b/sql/updates/world/2014_01_17_00_world_trinity_string.sql new file mode 100644 index 00000000000..698af0f56cb --- /dev/null +++ b/sql/updates/world/2014_01_17_00_world_trinity_string.sql @@ -0,0 +1,8 @@ +DELETE FROM trinity_string where entry in (11002, 11003, 11004, 11005, 11006, 11007); +INSERT INTO `trinity_string` VALUES +('11002', 'Server: %s has kicked %s, reason: %s', '', '', '', '', '', '', '', ''), +('11003', 'Server: %s has muted %s for %u minutes, reason: %s', '', '', '', '', '', '', '', ''), +('11004', 'Server: %s has banned character %s for %s, reason: %s', '', '', '', '', '', '', '', ''), +('11005', 'Server: %s has banned character %s permanetly, reason: %s', '', '', '', '', '', '', '', ''), +('11006', 'Server: %s has banned %s for %s, reason: %s', '', '', '', '', '', '', '', ''), +('11007', 'Server: %s has banned %s permanetly, reason: %s', '', '', '', '', '', '', '', ''); diff --git a/sql/updates/world/2014_01_23_01_conditions.sql b/sql/updates/world/2014_01_23_01_conditions.sql deleted file mode 100644 index 4afa30ee13d..00000000000 --- a/sql/updates/world/2014_01_23_01_conditions.sql +++ /dev/null @@ -1,5 +0,0 @@ --- -DELETE FROM `conditions` WHERE `SourceEntry` = 40817; -INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `Comment`) VALUES -(17,0,40817,0,0,23,0,3785,0,0,0,0,0,'Banishing Crystal requires Forge Camp: Wrath'), -(17,0,40817,0,1,23,0,3784,0,0,0,0,0,'Banishing Crystal requires Forge Camp: Terror'); diff --git a/sql/updates/world/2014_01_23_01_world_conditions.sql b/sql/updates/world/2014_01_23_01_world_conditions.sql new file mode 100644 index 00000000000..4afa30ee13d --- /dev/null +++ b/sql/updates/world/2014_01_23_01_world_conditions.sql @@ -0,0 +1,5 @@ +-- +DELETE FROM `conditions` WHERE `SourceEntry` = 40817; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `Comment`) VALUES +(17,0,40817,0,0,23,0,3785,0,0,0,0,0,'Banishing Crystal requires Forge Camp: Wrath'), +(17,0,40817,0,1,23,0,3784,0,0,0,0,0,'Banishing Crystal requires Forge Camp: Terror'); diff --git a/sql/updates/world/2014_01_23_02_sai.sql b/sql/updates/world/2014_01_23_02_sai.sql deleted file mode 100644 index f55db997a4c..00000000000 --- a/sql/updates/world/2014_01_23_02_sai.sql +++ /dev/null @@ -1,2 +0,0 @@ --- -UPDATE `smart_scripts` SET `event_phase_mask`=1 WHERE `entryorguid`=2103 AND `event_phase_mask`=2; diff --git a/sql/updates/world/2014_01_23_02_world_sai.sql b/sql/updates/world/2014_01_23_02_world_sai.sql new file mode 100644 index 00000000000..f55db997a4c --- /dev/null +++ b/sql/updates/world/2014_01_23_02_world_sai.sql @@ -0,0 +1,2 @@ +-- +UPDATE `smart_scripts` SET `event_phase_mask`=1 WHERE `entryorguid`=2103 AND `event_phase_mask`=2; diff --git a/sql/updates/world/2014_01_23_03_conditions.sql b/sql/updates/world/2014_01_23_03_conditions.sql deleted file mode 100644 index df83d50fd51..00000000000 --- a/sql/updates/world/2014_01_23_03_conditions.sql +++ /dev/null @@ -1,3 +0,0 @@ --- -UPDATE `conditions` SET `ElseGroup`=1 WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=3186 AND `SourceEntry`=0 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=5 AND `ConditionTarget`=0 AND `ConditionValue1`=54 AND `ConditionValue2`=128 AND `ConditionValue3`=0; -UPDATE `conditions` SET `ConditionValue1`=64 WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=3186 AND `SourceEntry`=0 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=16 AND `ConditionTarget`=0 AND `ConditionValue1`=8 AND `ConditionValue2`=0 AND `ConditionValue3`=0; diff --git a/sql/updates/world/2014_01_23_03_world_conditions.sql b/sql/updates/world/2014_01_23_03_world_conditions.sql new file mode 100644 index 00000000000..df83d50fd51 --- /dev/null +++ b/sql/updates/world/2014_01_23_03_world_conditions.sql @@ -0,0 +1,3 @@ +-- +UPDATE `conditions` SET `ElseGroup`=1 WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=3186 AND `SourceEntry`=0 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=5 AND `ConditionTarget`=0 AND `ConditionValue1`=54 AND `ConditionValue2`=128 AND `ConditionValue3`=0; +UPDATE `conditions` SET `ConditionValue1`=64 WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=3186 AND `SourceEntry`=0 AND `SourceId`=0 AND `ElseGroup`=0 AND `ConditionTypeOrReference`=16 AND `ConditionTarget`=0 AND `ConditionValue1`=8 AND `ConditionValue2`=0 AND `ConditionValue3`=0; diff --git a/sql/updates/world/2014_01_23_04_game_event_creature.sql b/sql/updates/world/2014_01_23_04_game_event_creature.sql deleted file mode 100644 index 5d350803f82..00000000000 --- a/sql/updates/world/2014_01_23_04_game_event_creature.sql +++ /dev/null @@ -1,6 +0,0 @@ --- Boxi (brewfest) -SET @GUID := '200002'; - --- game event creature boxi -DELETE FROM `game_event_creature` WHERE `guid`=@GUID; -INSERT INTO `game_event_creature`(`eventEntry`,`guid`) values (24,@GUID); diff --git a/sql/updates/world/2014_01_23_04_world_game_event_creature.sql b/sql/updates/world/2014_01_23_04_world_game_event_creature.sql new file mode 100644 index 00000000000..5d350803f82 --- /dev/null +++ b/sql/updates/world/2014_01_23_04_world_game_event_creature.sql @@ -0,0 +1,6 @@ +-- Boxi (brewfest) +SET @GUID := '200002'; + +-- game event creature boxi +DELETE FROM `game_event_creature` WHERE `guid`=@GUID; +INSERT INTO `game_event_creature`(`eventEntry`,`guid`) values (24,@GUID); diff --git a/sql/updates/world/2014_01_23_05_creature_template.sql b/sql/updates/world/2014_01_23_05_creature_template.sql deleted file mode 100644 index a35a6191ea4..00000000000 --- a/sql/updates/world/2014_01_23_05_creature_template.sql +++ /dev/null @@ -1,2 +0,0 @@ --- -UPDATE `creature_template` SET `flags_extra`=`flags_extra`|128|2 WHERE `entry` IN (31138,31550); diff --git a/sql/updates/world/2014_01_23_05_world_creature_template.sql b/sql/updates/world/2014_01_23_05_world_creature_template.sql new file mode 100644 index 00000000000..a35a6191ea4 --- /dev/null +++ b/sql/updates/world/2014_01_23_05_world_creature_template.sql @@ -0,0 +1,2 @@ +-- +UPDATE `creature_template` SET `flags_extra`=`flags_extra`|128|2 WHERE `entry` IN (31138,31550); diff --git a/sql/updates/world/2014_01_23_06_creature.sql b/sql/updates/world/2014_01_23_06_creature.sql deleted file mode 100644 index 356db4fceb4..00000000000 --- a/sql/updates/world/2014_01_23_06_creature.sql +++ /dev/null @@ -1,4 +0,0 @@ --- Update creature (Voidspawner L) force to use modelid 18684 -UPDATE `creature` SET `modelid`=18684 WHERE `guid` IN (70169, 70170, 70171, 70172, 70173, 70174); --- Update creature (Voidspawner XL) force to use modelid 18685 -UPDATE `creature` SET `modelid`=18685 WHERE `guid` IN (68919, 68918, 68917, 68920, 68921); diff --git a/sql/updates/world/2014_01_23_06_world_creature.sql b/sql/updates/world/2014_01_23_06_world_creature.sql new file mode 100644 index 00000000000..356db4fceb4 --- /dev/null +++ b/sql/updates/world/2014_01_23_06_world_creature.sql @@ -0,0 +1,4 @@ +-- Update creature (Voidspawner L) force to use modelid 18684 +UPDATE `creature` SET `modelid`=18684 WHERE `guid` IN (70169, 70170, 70171, 70172, 70173, 70174); +-- Update creature (Voidspawner XL) force to use modelid 18685 +UPDATE `creature` SET `modelid`=18685 WHERE `guid` IN (68919, 68918, 68917, 68920, 68921); diff --git a/sql/updates/world/2014_01_23_07_spell_bonus_data.sql b/sql/updates/world/2014_01_23_07_spell_bonus_data.sql deleted file mode 100644 index 1dfd35eac5a..00000000000 --- a/sql/updates/world/2014_01_23_07_spell_bonus_data.sql +++ /dev/null @@ -1,3 +0,0 @@ --- Living Ruby Pendant (item 24110) shouldn't get SP bonuses -DELETE FROM `spell_bonus_data` WHERE `entry`=31024; -INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `ap_dot_bonus`, `comments`) VALUES (31024,0,0,0,0,'Living ruby pendant should not get bonuses'); diff --git a/sql/updates/world/2014_01_23_07_world_spell_bonus_data.sql b/sql/updates/world/2014_01_23_07_world_spell_bonus_data.sql new file mode 100644 index 00000000000..1dfd35eac5a --- /dev/null +++ b/sql/updates/world/2014_01_23_07_world_spell_bonus_data.sql @@ -0,0 +1,3 @@ +-- Living Ruby Pendant (item 24110) shouldn't get SP bonuses +DELETE FROM `spell_bonus_data` WHERE `entry`=31024; +INSERT INTO `spell_bonus_data` (`entry`, `direct_bonus`, `dot_bonus`, `ap_bonus`, `ap_dot_bonus`, `comments`) VALUES (31024,0,0,0,0,'Living ruby pendant should not get bonuses'); diff --git a/sql/updates/world/2014_01_23_08_graveyard.sql b/sql/updates/world/2014_01_23_08_graveyard.sql deleted file mode 100644 index 27cfc39647d..00000000000 --- a/sql/updates/world/2014_01_23_08_graveyard.sql +++ /dev/null @@ -1,4 +0,0 @@ --- -DELETE FROM `game_graveyard_zone` WHERE `id`=589; -INSERT INTO `game_graveyard_zone` (`id`, `ghost_zone`, `faction`) VALUES -(589, 876, 0); diff --git a/sql/updates/world/2014_01_23_08_world_graveyard.sql b/sql/updates/world/2014_01_23_08_world_graveyard.sql new file mode 100644 index 00000000000..27cfc39647d --- /dev/null +++ b/sql/updates/world/2014_01_23_08_world_graveyard.sql @@ -0,0 +1,4 @@ +-- +DELETE FROM `game_graveyard_zone` WHERE `id`=589; +INSERT INTO `game_graveyard_zone` (`id`, `ghost_zone`, `faction`) VALUES +(589, 876, 0); diff --git a/sql/updates/world/2014_01_23_09_npc_trainer.sql b/sql/updates/world/2014_01_23_09_npc_trainer.sql deleted file mode 100644 index 3b44463b3da..00000000000 --- a/sql/updates/world/2014_01_23_09_npc_trainer.sql +++ /dev/null @@ -1,4 +0,0 @@ --- -DELETE FROM `npc_trainer` WHERE `entry`=201009 AND `spell`=63746; -INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES -(201009, 63746, 5000, 333, 225, 0); diff --git a/sql/updates/world/2014_01_23_09_world_npc_trainer.sql b/sql/updates/world/2014_01_23_09_world_npc_trainer.sql new file mode 100644 index 00000000000..3b44463b3da --- /dev/null +++ b/sql/updates/world/2014_01_23_09_world_npc_trainer.sql @@ -0,0 +1,4 @@ +-- +DELETE FROM `npc_trainer` WHERE `entry`=201009 AND `spell`=63746; +INSERT INTO `npc_trainer` (`entry`, `spell`, `spellcost`, `reqskill`, `reqskillvalue`, `reqlevel`) VALUES +(201009, 63746, 5000, 333, 225, 0); diff --git a/sql/updates/world/2014_01_23_10_creature_loot_template.sql b/sql/updates/world/2014_01_23_10_creature_loot_template.sql deleted file mode 100644 index f15bf25e5a8..00000000000 --- a/sql/updates/world/2014_01_23_10_creature_loot_template.sql +++ /dev/null @@ -1,2 +0,0 @@ --- Delete mote of earth from loot of Icetouched Earthrager -DELETE FROM `creature_loot_template` WHERE `entry`=29436 AND `item`=22573; diff --git a/sql/updates/world/2014_01_23_10_world_creature_loot_template.sql b/sql/updates/world/2014_01_23_10_world_creature_loot_template.sql new file mode 100644 index 00000000000..f15bf25e5a8 --- /dev/null +++ b/sql/updates/world/2014_01_23_10_world_creature_loot_template.sql @@ -0,0 +1,2 @@ +-- Delete mote of earth from loot of Icetouched Earthrager +DELETE FROM `creature_loot_template` WHERE `entry`=29436 AND `item`=22573; diff --git a/sql/updates/world/2014_01_23_11_creature_template.sql b/sql/updates/world/2014_01_23_11_creature_template.sql deleted file mode 100644 index efb5c7871af..00000000000 --- a/sql/updates/world/2014_01_23_11_creature_template.sql +++ /dev/null @@ -1,2 +0,0 @@ --- Rubble Stalker Kologarn -UPDATE `creature_template` SET `flags_extra`=`flags_extra`|128 WHERE `entry`=33809; diff --git a/sql/updates/world/2014_01_23_11_world_creature_template.sql b/sql/updates/world/2014_01_23_11_world_creature_template.sql new file mode 100644 index 00000000000..efb5c7871af --- /dev/null +++ b/sql/updates/world/2014_01_23_11_world_creature_template.sql @@ -0,0 +1,2 @@ +-- Rubble Stalker Kologarn +UPDATE `creature_template` SET `flags_extra`=`flags_extra`|128 WHERE `entry`=33809; diff --git a/sql/updates/world/2014_01_23_12_sai.sql b/sql/updates/world/2014_01_23_12_sai.sql deleted file mode 100644 index a9935fd0c97..00000000000 --- a/sql/updates/world/2014_01_23_12_sai.sql +++ /dev/null @@ -1,8 +0,0 @@ --- The Torch of Retribution (3454) -SET @KALARAN := 8479; -- Kalaran Windblade -SET @QUEST := 3454; -- Quest: The Torch of Retribution - -DELETE FROM `smart_scripts` WHERE `entryorguid`=@KALARAN AND `id` IN (5,6); -INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES -(@KALARAN,0,5,6,19,0,100,0,@QUEST,0,0,0,70,0,0,0,0,0,0,14,24166,149410,0,0,0,0,0,"Kalaran Windblade - On Quest Accept (4354) - Respawn Light of Retribution"), -(@KALARAN,0,6,0,61,0,100,0,0,0,0,0,70,0,0,0,0,0,0,14,16762,149047,0,0,0,0,0,"Kalaran Windblade - Linked with Previous Event - Respawn Torch of Retribution"); diff --git a/sql/updates/world/2014_01_23_12_world_sai.sql b/sql/updates/world/2014_01_23_12_world_sai.sql new file mode 100644 index 00000000000..a9935fd0c97 --- /dev/null +++ b/sql/updates/world/2014_01_23_12_world_sai.sql @@ -0,0 +1,8 @@ +-- The Torch of Retribution (3454) +SET @KALARAN := 8479; -- Kalaran Windblade +SET @QUEST := 3454; -- Quest: The Torch of Retribution + +DELETE FROM `smart_scripts` WHERE `entryorguid`=@KALARAN AND `id` IN (5,6); +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(@KALARAN,0,5,6,19,0,100,0,@QUEST,0,0,0,70,0,0,0,0,0,0,14,24166,149410,0,0,0,0,0,"Kalaran Windblade - On Quest Accept (4354) - Respawn Light of Retribution"), +(@KALARAN,0,6,0,61,0,100,0,0,0,0,0,70,0,0,0,0,0,0,14,16762,149047,0,0,0,0,0,"Kalaran Windblade - Linked with Previous Event - Respawn Torch of Retribution"); diff --git a/sql/updates/world/2014_01_23_13_world_misc.sql b/sql/updates/world/2014_01_23_13_world_misc.sql new file mode 100644 index 00000000000..627aa99d56b --- /dev/null +++ b/sql/updates/world/2014_01_23_13_world_misc.sql @@ -0,0 +1,13 @@ +UPDATE `creature_template` SET `ScriptName`='boss_prince_taldaram' WHERE `entry`=29308; + +UPDATE `creature_template` SET `scale`=1, `speed_walk`=2, `InhabitType`=4, `flags_extra`=128 WHERE `entry` IN (30106,31458,31686,31687); +UPDATE `creature_template` SET `ScriptName`='npc_prince_taldaram_flame_sphere' WHERE `entry` IN (30106,31686,31687); + +UPDATE `gameobject_template` SET `flags`=32, `ScriptName`='go_prince_taldaram_sphere' WHERE `entry` IN (193093,193094); + +DELETE FROM `spell_script_names` WHERE `spell_id` IN (55931, 55895, 59511, 59512); +INSERT INTO `spell_script_names` (`spell_id` ,`ScriptName`) VALUES +(55931, 'spell_prince_taldaram_conjure_flame_sphere'), +(55895, 'spell_prince_taldaram_flame_sphere_summon'), +(59511, 'spell_prince_taldaram_flame_sphere_summon'), +(59512, 'spell_prince_taldaram_flame_sphere_summon'); -- cgit v1.2.3