diff options
| -rw-r--r-- | sql/updates/world/2011_03_24_2_world_sai.sql | 13 | ||||
| -rw-r--r-- | sql/updates/world/2011_03_25_1_world_gameobjects.sql | 7 |
2 files changed, 7 insertions, 13 deletions
diff --git a/sql/updates/world/2011_03_24_2_world_sai.sql b/sql/updates/world/2011_03_24_2_world_sai.sql index 8bde91979e6..b4ee24b0a31 100644 --- a/sql/updates/world/2011_03_24_2_world_sai.sql +++ b/sql/updates/world/2011_03_24_2_world_sai.sql @@ -34,19 +34,6 @@ INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type UPDATE `gossip_menu_option` SET `action_script_id`=0 WHERE `menu_id`=@GOSSIP; DELETE FROM `gossip_scripts` WHERE `id` IN (1021500,1021501); --- Keeper Remulos SAI -SET @ENTRY := 11832; -SET @GOSSIP := 10215; -UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`=@ENTRY; -DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY; -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 -(@ENTRY,0,0,0,62,0,100,0,@GOSSIP,0,0,0,11,57413,1,0,0,0,0,7,0,0,0,0,0,0,0, 'Keeper Remulos - On gossip option select - cast spell'), -(@ENTRY,0,1,2,62,0,100,0,@GOSSIP,1,0,0,11,57670,1,0,0,0,0,7,0,0,0,0,0,0,0, 'Keeper Remulos - On gossip option select - cast spell'), -(@ENTRY,0,2,0,61,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Keeper Remulos - On gossip option select - close gossip'); --- Cleanup gossip -UPDATE `gossip_menu_option` SET `action_script_id`=0 WHERE `menu_id`=@GOSSIP; -DELETE FROM `gossip_scripts` WHERE `id` IN (1021500,1021501); - -- Fizzcrank Recon Pilot SAI SET @ENTRY := 25841; SET @GOSSIP := 21248; diff --git a/sql/updates/world/2011_03_25_1_world_gameobjects.sql b/sql/updates/world/2011_03_25_1_world_gameobjects.sql new file mode 100644 index 00000000000..d2d9c0da5a2 --- /dev/null +++ b/sql/updates/world/2011_03_25_1_world_gameobjects.sql @@ -0,0 +1,7 @@ +-- Spawn Tribunal Chest in heroic HoS mode and correct wrong spawnmasks +SET @GUID = 151790; -- Set by TDB team (need 1) +UPDATE `gameobject` SET `spawnMask`=1 WHERE `guid`=65564; -- Tribunal Chest non heroic +DELETE FROM `gameobject` WHERE `id`=193996; +INSERT INTO `gameobject` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`)VALUES +(@GUID,193996,599,2,1,880.406,345.164,203.706,0,0,0,0,1,180,0,1); -- Tribunal Chest heroic +UPDATE `gameobject_template` SET `faction`=94, `flags`=4 /* should be 4 and nothing else (temp) */ WHERE `entry` IN (193996,190586); |