From 6eece20e45c99de3c889de227fc1391282e0bf78 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Sun, 18 Jun 2017 15:49:08 +0200 Subject: rename files --- sql/updates/world/3.3.5/2017_06_18_00_world .sql | 11 ------ sql/updates/world/3.3.5/2017_06_18_00_world.sql | 11 ++++++ sql/updates/world/3.3.5/2017_06_18_01_world .sql | 44 ------------------------ sql/updates/world/3.3.5/2017_06_18_02_world.sql | 44 ++++++++++++++++++++++++ 4 files changed, 55 insertions(+), 55 deletions(-) delete mode 100644 sql/updates/world/3.3.5/2017_06_18_00_world .sql create mode 100644 sql/updates/world/3.3.5/2017_06_18_00_world.sql delete mode 100644 sql/updates/world/3.3.5/2017_06_18_01_world .sql create mode 100644 sql/updates/world/3.3.5/2017_06_18_02_world.sql (limited to 'sql') diff --git a/sql/updates/world/3.3.5/2017_06_18_00_world .sql b/sql/updates/world/3.3.5/2017_06_18_00_world .sql deleted file mode 100644 index b691583f3b3..00000000000 --- a/sql/updates/world/3.3.5/2017_06_18_00_world .sql +++ /dev/null @@ -1,11 +0,0 @@ --- -DELETE FROM `creature` WHERE `guid` IN (80410,80411,80413,80414,80416,80417,80420,80421,114575,114578,114584); -INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES -(80410, 29124, 571, 0, 0, 1, 1, 0, 0, 5566.938, 4112.677, 40.348, 2.269064, 300, 5, 0, 0, 0, 1, 0, 0, 0, -1), -(80411, 29124, 571, 0, 0, 1, 1, 0, 0, 5594.8916, 3885.3424, -97.15444, 3.00348, 300, 5, 0, 0, 0, 1, 0, 0, 0, -1), -(80413, 28101, 571, 0, 0, 1, 1, 0, 0, 5606.3583, 3898.4746, -95.45957, 3.00348, 300, 5, 0, 0, 0, 1, 0, 0, 0, -1), -(80414, 29124, 571, 0, 0, 1, 1, 0, 0, 5537.5039, 3966.5637, -40.84126, 0.04116, 300, 5, 0, 0, 0, 1, 0, 0, 0, -1), -(80416, 29124, 571, 0, 0, 1, 1, 0, 0, 5594.546, 3808.950, -14.236, 1.580546, 300, 5, 0, 0, 0, 1, 0, 0, 0, -1), -(80417, 29124, 571, 0, 0, 1, 1, 0, 0, 5623.9321, 3776.0725, -5.8515, 0.5161, 300, 5, 0, 0, 0, 1, 0, 0, 0, -1), -(80420, 28108, 571, 0, 0, 1, 1, 0, 0, 5594.884, 3784.661, -106.930, 2.118348, 300, 0, 0, 0, 0, 0, 0, 0, 0, -1), -(80421, 28113, 571, 0, 0, 1, 1, 0, 0, 5622.8334, 3875.159, -98.7706, 2.295847, 300, 0, 0, 0, 0, 0, 0, 0, 0, -1); diff --git a/sql/updates/world/3.3.5/2017_06_18_00_world.sql b/sql/updates/world/3.3.5/2017_06_18_00_world.sql new file mode 100644 index 00000000000..b691583f3b3 --- /dev/null +++ b/sql/updates/world/3.3.5/2017_06_18_00_world.sql @@ -0,0 +1,11 @@ +-- +DELETE FROM `creature` WHERE `guid` IN (80410,80411,80413,80414,80416,80417,80420,80421,114575,114578,114584); +INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +(80410, 29124, 571, 0, 0, 1, 1, 0, 0, 5566.938, 4112.677, 40.348, 2.269064, 300, 5, 0, 0, 0, 1, 0, 0, 0, -1), +(80411, 29124, 571, 0, 0, 1, 1, 0, 0, 5594.8916, 3885.3424, -97.15444, 3.00348, 300, 5, 0, 0, 0, 1, 0, 0, 0, -1), +(80413, 28101, 571, 0, 0, 1, 1, 0, 0, 5606.3583, 3898.4746, -95.45957, 3.00348, 300, 5, 0, 0, 0, 1, 0, 0, 0, -1), +(80414, 29124, 571, 0, 0, 1, 1, 0, 0, 5537.5039, 3966.5637, -40.84126, 0.04116, 300, 5, 0, 0, 0, 1, 0, 0, 0, -1), +(80416, 29124, 571, 0, 0, 1, 1, 0, 0, 5594.546, 3808.950, -14.236, 1.580546, 300, 5, 0, 0, 0, 1, 0, 0, 0, -1), +(80417, 29124, 571, 0, 0, 1, 1, 0, 0, 5623.9321, 3776.0725, -5.8515, 0.5161, 300, 5, 0, 0, 0, 1, 0, 0, 0, -1), +(80420, 28108, 571, 0, 0, 1, 1, 0, 0, 5594.884, 3784.661, -106.930, 2.118348, 300, 0, 0, 0, 0, 0, 0, 0, 0, -1), +(80421, 28113, 571, 0, 0, 1, 1, 0, 0, 5622.8334, 3875.159, -98.7706, 2.295847, 300, 0, 0, 0, 0, 0, 0, 0, 0, -1); diff --git a/sql/updates/world/3.3.5/2017_06_18_01_world .sql b/sql/updates/world/3.3.5/2017_06_18_01_world .sql deleted file mode 100644 index 03fa6c81574..00000000000 --- a/sql/updates/world/3.3.5/2017_06_18_01_world .sql +++ /dev/null @@ -1,44 +0,0 @@ -DELETE FROM `creature_text` WHERE `CreatureID`=20071; -INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES -(20071, 1, 0, 'You didn\'t really think I\'d do business with you again, did you? Sometimes, the best way to return to profitability is to know when to cut your losses.', 12, 0, 100, 1, 0, 0, 17618, 0, 'Wind Trader Marid to Player'), -(20071, 0, 0, 'Let us hold our discussion in a more... private place. Follow me, $n.', 12, 0, 100, 1, 0, 0, 17615, 0, 'Wind Trader Marid to Player'); - -DELETE FROM `gossip_menu_option` WHERE `MenuID`=8071; -INSERT INTO `gossip_menu_option` (`MenuID`, `OptionID`, `OptionIcon`, `OptionText`, `OptionBroadcastTextID`, `OptionType`, `OptionNpcFlag`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `VerifiedBuild`) VALUES -(8071, 0, 0, 'Wind Trader Marid, I\'ve returned with more information on the nether drakes. I\'m prepared to be your business partner, and for an extra sum, I\'ll take care of that troublesome elf and her human friend.', 17754, 1, 1, 0, 0, 0, 0, '', 0, 0); - -UPDATE `creature_template` SET `AIName`='SmartAI', `flags_extra`=0 WHERE `entry`=20071; - -DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=20071; -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 -(20071, 0, 0, 1, 62, 0, 100, 0, 8071, 0, 0, 0, 64, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Wind Trader Marid - On Gossip Select - Set Store Targetlist'), -(20071, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Wind Trader Marid - On Gossip Select - Close Gossip'), -(20071, 0, 2, 3, 61, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Wind Trader Marid - On Gossip Select - Say Line 0'), -(20071, 0, 3, 4, 61, 0, 100, 0, 0, 0, 0, 0, 81, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Wind Trader Marid - On Gossip Select - Set NPC Flags'), -(20071, 0, 4, 0, 61, 0, 100, 0, 0, 0, 0, 0, 53, 0, 20071, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Wind Trader Marid - On Gossip Select - Start WP'), -(20071, 0, 5, 6, 40, 0, 100, 0, 10, 20071, 0, 0, 66, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0.4537856, 'Wind Trader Marid - On Reached WP 10 - Set Orientation'), -(20071, 0, 6, 7, 61, 0, 100, 0, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Wind Trader Marid - On Reached WP 10 - Set Home Position'), -(20071, 0, 7, 8, 61, 0, 100, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Wind Trader Marid - On Reached WP 10 - Say Line 1'), -(20071, 0, 8, 9, 61, 0, 100, 0, 0, 0, 0, 0, 2, 14, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Wind Trader Marid - On Reached WP 10 - Set Faction'), -(20071, 0, 9, 10, 61, 0, 100, 0, 0, 0, 0, 0, 19, 256, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Wind Trader Marid - On Reached WP 10 - Set Unit Flags'), -(20071, 0, 10, 0, 61, 0, 100, 0, 0, 0, 0, 0, 8, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Wind Trader Marid - On Reached WP 10 - Set Defensive'), -(20071, 0, 11, 0, 7, 0, 100, 0, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Wind Trader Marid - On Evade - Despawn'), -(20071, 0, 12, 13, 4, 0, 100, 0, 0, 0, 0, 0, 12, 20101, 1, 60000, 1, 0, 0, 8, 0, 0, 0, 4322.216, 2148.113, 124.918, 4.014257, 'Wind Trader Marid - On Aggro - Summon Netherstalkwe'), -(20071, 0, 13, 0, 61, 0, 100, 0, 0, 0, 0, 0, 12, 20101, 1, 60000, 1, 0, 0, 8, 0, 0, 0, 4327.583, 2133.33, 126.4966, 3.508112, 'Wind Trader Marid - On Aggro - Summon Netherstalkwe'); - -DELETE FROM `waypoints` WHERE `entry`=20071; -INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES -(20071, 1, 4296.338, 2216.264, 122.231, 'Wind Trader Marid'), -(20071, 2, 4302.872, 2204.899, 120.7829, 'Wind Trader Marid'), -(20071, 3, 4306.264, 2197.094, 119.4814, 'Wind Trader Marid'), -(20071, 4, 4307.128, 2187.726, 115.1026, 'Wind Trader Marid'), -(20071, 5, 4310.083, 2182.954, 117.2381, 'Wind Trader Marid'), -(20071, 6, 4310.326, 2175.833, 118.5926, 'Wind Trader Marid'), -(20071, 7, 4311.009, 2166.498, 117.6943, 'Wind Trader Marid'), -(20071, 8, 4310.087, 2155.008, 125.7436, 'Wind Trader Marid'), -(20071, 9, 4307.198, 2145.444, 128.3736, 'Wind Trader Marid'), -(20071, 10, 4305.531, 2141.197, 129.5266, 'Wind Trader Marid'); - -DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=8071; -INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES -(15, 8071, 0, 0, 0, 9, 0, 10273, 0, 0, 0, 0, 0, '', 'Show gossip option 8071 if player has quest 10273'); diff --git a/sql/updates/world/3.3.5/2017_06_18_02_world.sql b/sql/updates/world/3.3.5/2017_06_18_02_world.sql new file mode 100644 index 00000000000..03fa6c81574 --- /dev/null +++ b/sql/updates/world/3.3.5/2017_06_18_02_world.sql @@ -0,0 +1,44 @@ +DELETE FROM `creature_text` WHERE `CreatureID`=20071; +INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES +(20071, 1, 0, 'You didn\'t really think I\'d do business with you again, did you? Sometimes, the best way to return to profitability is to know when to cut your losses.', 12, 0, 100, 1, 0, 0, 17618, 0, 'Wind Trader Marid to Player'), +(20071, 0, 0, 'Let us hold our discussion in a more... private place. Follow me, $n.', 12, 0, 100, 1, 0, 0, 17615, 0, 'Wind Trader Marid to Player'); + +DELETE FROM `gossip_menu_option` WHERE `MenuID`=8071; +INSERT INTO `gossip_menu_option` (`MenuID`, `OptionID`, `OptionIcon`, `OptionText`, `OptionBroadcastTextID`, `OptionType`, `OptionNpcFlag`, `ActionMenuID`, `ActionPoiID`, `BoxCoded`, `BoxMoney`, `BoxText`, `BoxBroadcastTextID`, `VerifiedBuild`) VALUES +(8071, 0, 0, 'Wind Trader Marid, I\'ve returned with more information on the nether drakes. I\'m prepared to be your business partner, and for an extra sum, I\'ll take care of that troublesome elf and her human friend.', 17754, 1, 1, 0, 0, 0, 0, '', 0, 0); + +UPDATE `creature_template` SET `AIName`='SmartAI', `flags_extra`=0 WHERE `entry`=20071; + +DELETE FROM `smart_scripts` WHERE `source_type`=0 AND `entryorguid`=20071; +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 +(20071, 0, 0, 1, 62, 0, 100, 0, 8071, 0, 0, 0, 64, 1, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Wind Trader Marid - On Gossip Select - Set Store Targetlist'), +(20071, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Wind Trader Marid - On Gossip Select - Close Gossip'), +(20071, 0, 2, 3, 61, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Wind Trader Marid - On Gossip Select - Say Line 0'), +(20071, 0, 3, 4, 61, 0, 100, 0, 0, 0, 0, 0, 81, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Wind Trader Marid - On Gossip Select - Set NPC Flags'), +(20071, 0, 4, 0, 61, 0, 100, 0, 0, 0, 0, 0, 53, 0, 20071, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Wind Trader Marid - On Gossip Select - Start WP'), +(20071, 0, 5, 6, 40, 0, 100, 0, 10, 20071, 0, 0, 66, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0.4537856, 'Wind Trader Marid - On Reached WP 10 - Set Orientation'), +(20071, 0, 6, 7, 61, 0, 100, 0, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Wind Trader Marid - On Reached WP 10 - Set Home Position'), +(20071, 0, 7, 8, 61, 0, 100, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Wind Trader Marid - On Reached WP 10 - Say Line 1'), +(20071, 0, 8, 9, 61, 0, 100, 0, 0, 0, 0, 0, 2, 14, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Wind Trader Marid - On Reached WP 10 - Set Faction'), +(20071, 0, 9, 10, 61, 0, 100, 0, 0, 0, 0, 0, 19, 256, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Wind Trader Marid - On Reached WP 10 - Set Unit Flags'), +(20071, 0, 10, 0, 61, 0, 100, 0, 0, 0, 0, 0, 8, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Wind Trader Marid - On Reached WP 10 - Set Defensive'), +(20071, 0, 11, 0, 7, 0, 100, 0, 0, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Wind Trader Marid - On Evade - Despawn'), +(20071, 0, 12, 13, 4, 0, 100, 0, 0, 0, 0, 0, 12, 20101, 1, 60000, 1, 0, 0, 8, 0, 0, 0, 4322.216, 2148.113, 124.918, 4.014257, 'Wind Trader Marid - On Aggro - Summon Netherstalkwe'), +(20071, 0, 13, 0, 61, 0, 100, 0, 0, 0, 0, 0, 12, 20101, 1, 60000, 1, 0, 0, 8, 0, 0, 0, 4327.583, 2133.33, 126.4966, 3.508112, 'Wind Trader Marid - On Aggro - Summon Netherstalkwe'); + +DELETE FROM `waypoints` WHERE `entry`=20071; +INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES +(20071, 1, 4296.338, 2216.264, 122.231, 'Wind Trader Marid'), +(20071, 2, 4302.872, 2204.899, 120.7829, 'Wind Trader Marid'), +(20071, 3, 4306.264, 2197.094, 119.4814, 'Wind Trader Marid'), +(20071, 4, 4307.128, 2187.726, 115.1026, 'Wind Trader Marid'), +(20071, 5, 4310.083, 2182.954, 117.2381, 'Wind Trader Marid'), +(20071, 6, 4310.326, 2175.833, 118.5926, 'Wind Trader Marid'), +(20071, 7, 4311.009, 2166.498, 117.6943, 'Wind Trader Marid'), +(20071, 8, 4310.087, 2155.008, 125.7436, 'Wind Trader Marid'), +(20071, 9, 4307.198, 2145.444, 128.3736, 'Wind Trader Marid'), +(20071, 10, 4305.531, 2141.197, 129.5266, 'Wind Trader Marid'); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=8071; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(15, 8071, 0, 0, 0, 9, 0, 10273, 0, 0, 0, 0, 0, '', 'Show gossip option 8071 if player has quest 10273'); -- cgit v1.2.3