From c17d148992b9c5d5d8afab73e26fa2404f727392 Mon Sep 17 00:00:00 2001 From: Dr-J Date: Tue, 7 Oct 2014 00:52:58 +0100 Subject: DB/Misc: Cursed Cauldron / Cursed Scarabs Thanks to @VincentMichael for the data on the missing trap objects Removing the cauldron bubbles and smoke gos as these are meant to be summoned by spell used by one of the trap objects Closes #11372 --- sql/updates/world/2014_10_06_06_world.sql | 30 ++++++++++++++++++++++++++++++ 1 file changed, 30 insertions(+) create mode 100644 sql/updates/world/2014_10_06_06_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2014_10_06_06_world.sql b/sql/updates/world/2014_10_06_06_world.sql new file mode 100644 index 00000000000..fde8bd4550a --- /dev/null +++ b/sql/updates/world/2014_10_06_06_world.sql @@ -0,0 +1,30 @@ +DELETE FROM `gameobject_template` WHERE `entry` IN (184718,184722); +INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `data0`, `data1`, `data2`, `data3`, `size`, `VerifiedBuild`) VALUES +(184718, 6, 327, 'Cauldron Summoner', 0, 0, 0, 36549, 1, -18019), +(184722, 6, 327, 'Cauldron Bug Summoner', 0, 0, 0, 36552, 1, -18019); + +DELETE FROM `gameobject` WHERE `guid` IN(25566,25567) AND `id` IN(184721,184717,184722,184718); + +INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(25566, 184718, 530, 1, 1, -970.813, 2172, 15.5428, -2.33874, 0, 0, 0.920505, -0.390731, 0, 100, 1, 0), +(25567, 184722, 530, 1, 1, -970.813, 2172, 15.5428, -2.33874, 0, 0, 0.920505, -0.390731, 0, 100, 1, 0); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=36546; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(13, 1, 36546, 0, 0, 31, 0, 5, 184715, 0, 0, 0, 0, '', 'Boil Bleeding Hollow Blood - Cursed Cauldron'), +(13, 2, 36546, 0, 0, 31, 0, 5, 184722, 0, 0, 0, 0, '', 'Boil Bleeding Hollow Blood - Cauldron Bug Summoner'); + +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN(21308,21306); +DELETE FROM `smart_scripts` WHERE `entryorguid` IN(21308,21306) AND `source_type`=0; + +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 +(21308, 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 11, 36555, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Cursed Scarab Summoner - On Spawn - Cast Summon Cursed Scarabs'), +(21306, 0, 0, 1, 11, 0, 100, 0, 0, 0, 0, 0, 89, 20, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Cursed Scarab - On Spawn - Set Random Movement'), +(21306, 0, 1, 2, 61, 0, 100, 0, 0, 0, 0, 0, 59, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Cursed Scarab - On Spawn - Set Run On'), +(21306, 0, 2, 3, 61, 0, 100, 0, 0, 0, 0, 0, 11, 36556, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Cursed Scarab - On Spawn - Cast Cursed Scarab Periodic'), +(21306, 0, 3, 4, 61, 0, 100, 0, 0, 0, 0, 0, 11, 36559, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Cursed Scarab - On Spawn - Cast Cursed Scarab Despawn Timer'), +(21306, 0, 4, 0, 61, 0, 100, 0, 0, 0, 0, 0, 11, 31309, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Cursed Scarab - On Spawn - Cast Spirit Particles (red, big)'), +(21306, 0, 5, 0, 8, 0, 100, 0, 36560, 0, 0, 0, 41, 40000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Cursed Scarab - On Spellhit (Cursed Scarab Despawn Periodic Trigger) - Despawn'), +(21306, 0, 6, 7, 1, 0, 100, 1, 5000, 90000, 0, 0, 2, 14, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Cursed Scarab - OOC - Set faction'), +(21306, 0, 7, 8, 61, 0, 100, 1, 0, 0, 0, 0, 8, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Cursed Scarab - OOC - Set Hostile'), +(21306, 0, 8, 0, 61, 0, 100, 1, 0, 0, 0, 0, 49, 0, 0, 0, 0, 0, 0, 21, 100, 0, 0, 0, 0, 0, 0, 'Cursed Scarab - OOC - Attack Sumoner'); -- cgit v1.2.3 From 083ae4e18318fb392af55c6a4727b5d131f78e09 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Tue, 7 Oct 2014 02:24:54 +0200 Subject: DB/Creature: BroadcastTextID for npc_text By 41782992, closes #13286 --- sql/updates/world/2014_10_07_00_world.sql | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) create mode 100644 sql/updates/world/2014_10_07_00_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2014_10_07_00_world.sql b/sql/updates/world/2014_10_07_00_world.sql new file mode 100644 index 00000000000..85962032e03 --- /dev/null +++ b/sql/updates/world/2014_10_07_00_world.sql @@ -0,0 +1,21 @@ +-- npc_text +UPDATE `npc_text` SET `BroadcastTextID0`=5195 WHERE `ID`=2838; +UPDATE `npc_text` SET `BroadcastTextID0`=11738 WHERE `ID`=8296; +UPDATE `npc_text` SET `BroadcastTextID0`=11790 WHERE `ID`=8282; +UPDATE `npc_text` SET `BroadcastTextID0`=11797 WHERE `ID`=8298; +UPDATE `npc_text` SET `BroadcastTextID0`=20625 WHERE `ID`=10787; +UPDATE `npc_text` SET `BroadcastTextID0`=37804 WHERE `ID`=15240; +UPDATE `npc_text` SET `BroadcastTextID0`=11736 WHERE `ID`=8244; +UPDATE `npc_text` SET `BroadcastTextID0`=11799 WHERE `ID`=8291; +UPDATE `npc_text` SET `BroadcastTextID0`=12770 WHERE `ID`=8663; +UPDATE `npc_text` SET `BroadcastTextID0`=14410 WHERE `ID`=9072; +UPDATE `npc_text` SET `BroadcastTextID0`=14546 WHERE `ID`=9110; +UPDATE `npc_text` SET `BroadcastTextID0`=17748 WHERE `ID`=9984; +UPDATE `npc_text` SET `BroadcastTextID0`=21971 WHERE `ID`=11093; +UPDATE `npc_text` SET `BroadcastTextID0`=27167 WHERE `ID`=12978; +UPDATE `npc_text` SET `BroadcastTextID0`=32577 WHERE `ID`=14089; +UPDATE `npc_text` SET `BroadcastTextID0`=37148 WHERE `ID`=15155; +UPDATE `npc_text` SET `BroadcastTextID0`=38655 WHERE `ID`=15412; +UPDATE `npc_text` SET `BroadcastTextID0`=40449 WHERE `ID`=15866; +UPDATE `npc_text` SET `BroadcastTextID0`=40471 WHERE `ID`=15873; +UPDATE `npc_text` SET `BroadcastTextID0`=40482 WHERE `ID`=15877; -- cgit v1.2.3 From ba2ae251e314213e5957e67bc7bf1ed75235694f Mon Sep 17 00:00:00 2001 From: Dr-J Date: Tue, 7 Oct 2014 19:19:22 +0100 Subject: DB/Quest: News from the East By @Pitcrawler Closes #13288 --- sql/updates/world/2014_10_07_01_world.sql | 61 +++++++++++++++++++++++++++++++ 1 file changed, 61 insertions(+) create mode 100644 sql/updates/world/2014_10_07_01_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2014_10_07_01_world.sql b/sql/updates/world/2014_10_07_01_world.sql new file mode 100644 index 00000000000..6d9940f7666 --- /dev/null +++ b/sql/updates/world/2014_10_07_01_world.sql @@ -0,0 +1,61 @@ +-- Fix Quest 11501 "News From the East" + +SET @WALT := 24807; +SET @CONSTRUCT := 24852; + +UPDATE `creature_template` SET `npcflag`=`npcflag`|1 WHERE `entry`=@WALT; +UPDATE `creature_template` SET `speed_run`=4.285714, `VehicleId`=87, `InhabitType`=4 WHERE `entry`=@CONSTRUCT; + +UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN (@WALT,@CONSTRUCT); +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (@WALT,@CONSTRUCT) AND `source_type`=0; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@CONSTRUCT*100 AND `source_type`=9; +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 +(@WALT,0,0,1,62,0,100,0,9022,0,0,0,11,49975,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Walt - On gossip option select - Spellcast Iron Rune Construct Taxi'), +(@WALT,0,1,0,61,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Walt - On gossip option select - Close gossip'), +(@CONSTRUCT,0,0,0,54,0,100,0,0,0,0,0,80,@CONSTRUCT*100,2,0,0,0,0,1,0,0,0,0,0,0,0, 'Iron Rune Construct - Just summoned - Run script'), +(@CONSTRUCT,0,1,2,40,0,100,1,18,@CONSTRUCT,0,0,1,1,2000,0,0,0,0,1,0,0,0,0,0,0,0, 'Iron Rune Construct - On WP 18 reached - Say line'), +(@CONSTRUCT,0,2,0,61,0,100,0,0,0,0,0,28,44687,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Iron Rune Construct - On WP 18 reached - Remove aura Rocket Jump'), +(@CONSTRUCT,0,3,0,52,0,100,0,1,@CONSTRUCT,0,0,11,44688,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Iron Rune Construct - On text over - Spellcast System Failure'), + +(@CONSTRUCT*100,9,0,0,0,0,100,0,4000,4000,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Iron Rune Construct script - Say line'), +(@CONSTRUCT*100,9,1,0,0,0,100,0,0,0,0,0,11,44687,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Iron Rune Construct script - Spellcast Rocket Jump'), +(@CONSTRUCT*100,9,2,0,0,0,100,0,2000,2000,0,0,53,1,@CONSTRUCT,0,0,0,0,1,0,0,0,0,0,0,0, 'Iron Rune Construct script - Start WP movement'); + +DELETE FROM `gossip_menu_option` WHERE `menu_id`=9022 AND `id`=0; +INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_icon`,`option_text`,`OptionBroadcastTextID`,`option_id`,`npc_option_npcflag`,`action_menu_id`,`action_poi_id`,`box_coded`,`box_money`,`box_text`) VALUES +(9022,0,0,'I''m ready to go, Walt.',23929,1,1,0,0,0,0,''); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=9022; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(15,9022,0,0,28,11501,0,0,0,'','Walt - Show gossip option only if player has completed but not rewarded quest News From the East'); + +DELETE FROM `creature_text` WHERE `entry`=@CONSTRUCT; +INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`,`BroadcastTextID`) VALUES +(@CONSTRUCT,0,0,'Launching.',12,0,100,0,0,0,'Iron Rune Construct',23860), +(@CONSTRUCT,1,0,'System failure in 3... 2...',12,0,100,0,0,0,'Iron Rune Construct',23930); + +DELETE FROM `waypoints` WHERE `entry`=@CONSTRUCT; +INSERT INTO `waypoints` (`entry`,`pointid`,`position_x`,`position_y`,`position_z`,`point_comment`) VALUES +(@CONSTRUCT,1,479.0616,-5941.539,316.96,'Iron Rune Construct'), +(@CONSTRUCT,2,479.2529,-5941.489,365.9878,'Iron Rune Construct'), +(@CONSTRUCT,3,517.0134,-5825.359,365.9878,'Iron Rune Construct'), +(@CONSTRUCT,4,527.9034,-5659.926,365.9878,'Iron Rune Construct'), +(@CONSTRUCT,5,715.0627,-5351.074,365.9878,'Iron Rune Construct'), +(@CONSTRUCT,6,768.4551,-5018.862,365.9878,'Iron Rune Construct'), +(@CONSTRUCT,7,840.6277,-4827.729,365.9878,'Iron Rune Construct'), +(@CONSTRUCT,8,864.8306,-4741.804,365.9878,'Iron Rune Construct'), +(@CONSTRUCT,9,966.0306,-4488.406,365.9878,'Iron Rune Construct'), +(@CONSTRUCT,10,1030.845,-4374.208,346.4599,'Iron Rune Construct'), +(@CONSTRUCT,11,1063.375,-4205.252,346.4599,'Iron Rune Construct'), +(@CONSTRUCT,12,1066.279,-4072.605,289.821,'Iron Rune Construct'), +(@CONSTRUCT,13,1066.46,-3833.815,282.9599,'Iron Rune Construct'), +(@CONSTRUCT,14,1236.65,-3685.513,282.9599,'Iron Rune Construct'), +(@CONSTRUCT,15,1357.56,-3430.121,217.8767,'Iron Rune Construct'), +(@CONSTRUCT,16,1382.808,-3290.728,217.8767,'Iron Rune Construct'), +(@CONSTRUCT,17,1388.928,-3261.844,203.7378,'Iron Rune Construct'), +(@CONSTRUCT,18,1390.475,-3262.215,161.9602,'Iron Rune Construct'); + +DELETE FROM `spell_scripts` WHERE `id`=44688 AND `command`=14; +INSERT INTO `spell_scripts` (`id`,`effIndex`,`delay`,`command`,`datalong`,`datalong2`,`dataint`,`x`,`y`,`z`,`o`) VALUES +(44688,0,0,14,46598,0,0,0,0,0,0), +(44688,0,0,15,44741,1,0,0,0,0,0); -- cgit v1.2.3 From 6e39aacdf677fe2cc06be4c9aef20a8291a1a977 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Wed, 8 Oct 2014 07:03:12 +0200 Subject: DB/Creature: Hira Snowdawn - missing fly around every 10 min By Killyana, closes #13266 --- sql/updates/world/2014_10_08_00_world.sql | 44 +++++++++++++++++++++++++++++++ 1 file changed, 44 insertions(+) create mode 100644 sql/updates/world/2014_10_08_00_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2014_10_08_00_world.sql b/sql/updates/world/2014_10_08_00_world.sql new file mode 100644 index 00000000000..baacc085323 --- /dev/null +++ b/sql/updates/world/2014_10_08_00_world.sql @@ -0,0 +1,44 @@ +-- +SET @Hira :=31238; + +UPDATE creature_template SET ScriptName='', `AIName`='SmartAI', InhabitType=4 WHERE entry=@Hira; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=10723; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`, `ErrorTextId`,`ScriptName`,`Comment`) VALUES +(15,10723,1,0,27,80,3,0,0,'','Show gossip menu if player''s level 80 or higher'), +(15,10723,1,0,25,54197,0,0,0,'','Show gossip menu if player has lerned 54197'); + +DELETE FROM `smart_scripts` WHERE `entryorguid` = @Hira AND `source_type` = 0; +DELETE FROM `smart_scripts` WHERE `entryorguid` = @Hira*100 AND `source_type` = 9; +DELETE FROM `smart_scripts` WHERE `entryorguid` = @Hira*100+1 AND `source_type` = 9; +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 +(@Hira, 0, 0, 0, 1, 0, 100, 0, 600000, 600000, 600000, 600000, 80, @Hira*100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Hira - OOC - actionlist'), +(@Hira*100, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Hira - actionlist - talk (emote)'), +(@Hira*100, 9, 1, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Hira - actionlist - talk'), +(@Hira*100, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 18, 33554432, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Hira - actionlist - set UNIT_FLAG_NOT_SELECTABLE'), +(@Hira*100, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 53, 1, @Hira, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Hira - actionlist - start wp'), +(@Hira,0 ,1 ,0 ,40 ,0 ,100 ,0, 11, 0, 0, 0 ,80, @Hira*100+1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ruul the Darkener - way point reached - Re action list'), +(@Hira*100+1, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 5815.272, 473.4902, 658.7961, 4.660029, 'Hira - actionlist - SET Orientation'), +(@Hira*100+1, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 19, 33554432, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Hira - actionlist - remove UNIT_FLAG_NOT_SELECTABLE'); + +DELETE FROM `waypoints` WHERE `entry`=@Hira; +INSERT INTO `waypoints` (`entry`,`pointid`,`position_x`,`position_y`,`position_z`,`point_comment`) VALUES +(@Hira,1,5806.834, 475.4562, 661.3664, 'Hira Snowdawn WP'), +(@Hira,2,5792.614, 466.3004, 662.0329, 'Hira Snowdawn WP'), +(@Hira,3,5786.764, 450.582, 662.5331, 'Hira Snowdawn WP'), +(@Hira,4,5791.111, 434.2068, 665.3663, 'Hira Snowdawn WP'), +(@Hira,5,5804.108, 423.6482, 665.6719, 'Hira Snowdawn WP'), +(@Hira,6,5821.129, 422.7363, 665.1718, 'Hira Snowdawn WP'), +(@Hira,7,5835.191, 431.9838, 663.9774, 'Hira Snowdawn WP'), +(@Hira,8,5841.177, 447.7776, 662.783, 'Hira Snowdawn WP'), +(@Hira,9,5836.82, 464.0104, 661.894, 'Hira Snowdawn WP'), +(@Hira,10,5823.853, 474.5901, 661.3664, 'Hira Snowdawn WP'), +(@Hira,11,5815.272, 473.4902, 658.7961, 'Hira Snowdawn WP'); + +DELETE FROM `creature_text` WHERE `entry` IN (@Hira); +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`, `BroadcastTextID`) VALUES +(@Hira, 0, 0, 'Come, Cloudwing. Let''s do a lap.', 12, 0, 100, 0, 0, 0, 'Hira Snowdawn', 32247), +(@Hira, 0, 1, 'Feeling as restless as I am, Cloudwing? Then let us fly!', 12, 0, 100, 0, 0, 0, 'Hira Snowdawn', 32252), +(@Hira, 0, 2, 'I''m bored, Cloudwing. Go, go!', 12, 0, 100, 0, 0, 0, 'Hira Snowdawn', 32251), +(@Hira, 1, 0, '%s sighs softly and rolls her shoulders.', 16, 0, 100, 0, 0, 0, 'Hira Snowdawn', 32249), +(@Hira, 1, 1, '%s looks around Krasus'' Landing, bored.', 16, 0, 100, 0, 0, 0, 'Hira Snowdawn', 32244), +(@Hira, 1, 2, '%s yawns quietly into the palm of her hand.', 16, 0, 100, 0, 0, 0, 'Hira Snowdawn', 32245); -- cgit v1.2.3 From d1d03aa44f79f0811811b4a0d2c3d392ed73e0c1 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Wed, 8 Oct 2014 07:07:23 +0200 Subject: DB/Misc: Remove few startup errors --- sql/updates/world/2014_10_08_01_world.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) create mode 100644 sql/updates/world/2014_10_08_01_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2014_10_08_01_world.sql b/sql/updates/world/2014_10_08_01_world.sql new file mode 100644 index 00000000000..f7fb328965b --- /dev/null +++ b/sql/updates/world/2014_10_08_01_world.sql @@ -0,0 +1,10 @@ +-- +UPDATE `creature_text` SET `BroadcastTextId`=0 WHERE `entry`=3977 AND `groupid`=1; +UPDATE `creature_text` SET `BroadcastTextId`=0 WHERE `entry`=11380 AND `groupid`=0; +UPDATE `creature_text` SET `BroadcastTextId`=0 WHERE `entry`=23863 AND `groupid`=2; +UPDATE `creature_text` SET `BroadcastTextId`=0 WHERE `entry`=23863 AND `groupid`=3; +UPDATE `creature_text` SET `BroadcastTextId`=0 WHERE `entry`=23863 AND `groupid`=4; +UPDATE `creature_text` SET `BroadcastTextId`=0 WHERE `entry`=23863 AND `groupid`=5; +UPDATE `creature_text` SET `BroadcastTextId`=0 WHERE `entry`=23863 AND `groupid`=6; +UPDATE `creature_text` SET `BroadcastTextId`=0 WHERE `entry`=23863 AND `groupid`=8; +UPDATE `creature_text` SET `BroadcastTextId`=0 WHERE `entry`=23863 AND `groupid`=9; -- cgit v1.2.3 From 97c8ab65d2fb683cd62262f7cbb674b36eaa4b88 Mon Sep 17 00:00:00 2001 From: Dr-J Date: Wed, 8 Oct 2014 14:10:14 +0100 Subject: DB/Conditions: Use Camera (Cultivating an Image) Camera is meant to work on other dead iron dwarfs not just Iron Rune-Smith Runic Lightning Gunner and Iron Rune Overseer already have sai to give credit/despawn on spellhit but spell was conditioned to only hit Iron Rune-Smith --- sql/updates/world/2014_10_08_02_world.sql | 8 ++++++++ 1 file changed, 8 insertions(+) create mode 100644 sql/updates/world/2014_10_08_02_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2014_10_08_02_world.sql b/sql/updates/world/2014_10_08_02_world.sql new file mode 100644 index 00000000000..8e594784478 --- /dev/null +++ b/sql/updates/world/2014_10_08_02_world.sql @@ -0,0 +1,8 @@ +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=48046; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(17, 0, 48046, 0, 0, 31, 1, 3, 26408, 0, 0, 0, 0, '', "Use Camera targets Iron Rune-Smith"), +(17, 0, 48046, 0, 0, 36, 1, 0, 0, 0, 1, 0, 0, '', "Target must be dead"), +(17, 0, 48046, 0, 1, 31, 1, 3, 26414, 0, 0, 0, 0, '', "Use Camera targets Runic Lightning Gunner"), +(17, 0, 48046, 0, 1, 36, 1, 0, 0, 0, 1, 0, 0, '', "Target must be dead"), +(17, 0, 48046, 0, 2, 31, 1, 3, 27177, 0, 0, 0, 0, '', "Use Camera targets Iron Rune Overseer"), +(17, 0, 48046, 0, 2, 36, 1, 0, 0, 0, 1, 0, 0, '', "Target must be dead"); -- cgit v1.2.3 From d77ff3098e97fcb0d02c84cb78dfd5a329924871 Mon Sep 17 00:00:00 2001 From: Dr-J Date: Wed, 8 Oct 2014 14:14:33 +0100 Subject: Fix typo which was causing error about duplicate entry --- sql/updates/world/2014_10_08_02_world.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'sql/updates') diff --git a/sql/updates/world/2014_10_08_02_world.sql b/sql/updates/world/2014_10_08_02_world.sql index 8e594784478..b53cf736b62 100644 --- a/sql/updates/world/2014_10_08_02_world.sql +++ b/sql/updates/world/2014_10_08_02_world.sql @@ -1,4 +1,4 @@ -DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry`=48046; +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=17 AND `SourceEntry`=48046; INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES (17, 0, 48046, 0, 0, 31, 1, 3, 26408, 0, 0, 0, 0, '', "Use Camera targets Iron Rune-Smith"), (17, 0, 48046, 0, 0, 36, 1, 0, 0, 0, 1, 0, 0, '', "Target must be dead"), -- cgit v1.2.3 From bec9e277bd4e64437074f130eaeec4e25619e0f4 Mon Sep 17 00:00:00 2001 From: Aokromes Date: Thu, 9 Oct 2014 00:20:39 +0200 Subject: DB/Spells: Add Naxxramas teleports coords By dr-j, closes #13255 --- sql/updates/world/2014_10_09_00_world.sql | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 sql/updates/world/2014_10_09_00_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2014_10_09_00_world.sql b/sql/updates/world/2014_10_09_00_world.sql new file mode 100644 index 00000000000..00d70229bea --- /dev/null +++ b/sql/updates/world/2014_10_09_00_world.sql @@ -0,0 +1,5 @@ +-- +DELETE FROM `spell_target_position` WHERE `id` IN (28444,72613); +INSERT INTO `spell_target_position` (`id`, `effIndex`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`, `VerifiedBuild`) VALUES +(72613, 0, 533, 3005.509277, -3434.641113, 304.195, 5.81041, 0), +(28444, 0, 533, 3005.509277, -3434.641113, 304.195, 5.81041, 0); -- cgit v1.2.3 From ea17cfb92d0da0d300974c990217eedbe6a3fe4b Mon Sep 17 00:00:00 2001 From: Aokromes Date: Thu, 9 Oct 2014 16:55:41 +0200 Subject: DB/Spell: Scrape Corrosive Spit By Rushor and untaught, closes #12189 --- sql/updates/world/2014_10_09_01_world.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 sql/updates/world/2014_10_09_01_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2014_10_09_01_world.sql b/sql/updates/world/2014_10_09_01_world.sql new file mode 100644 index 00000000000..5ffe056a8c9 --- /dev/null +++ b/sql/updates/world/2014_10_09_01_world.sql @@ -0,0 +1,7 @@ +-- +DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=47435; +INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES +(47435, -47447, 0, 'remove debuff'); +DELETE FROM `conditions` WHERE `sourcetypeorreferenceid`=17 AND `sourceentry`=47435; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(17,0,47435,0,0,1,0,47447,1,0,0,0,0,'','Cast ''Scrape Corrosive Spit'' only if player has ''Corrosive Spit'''); -- cgit v1.2.3 From 16cbdcde54e13d798a30eb9034e98e51a8e33d90 Mon Sep 17 00:00:00 2001 From: Dr-J Date: Thu, 9 Oct 2014 20:26:50 +0100 Subject: DB/Creature: Ravandwyr * Script repeating random trick event * Script replacement of Archmage Vargoth's Staff Thanks to @Kittnz for getting data on last missing event. --- sql/updates/world/2014_10_09_02_world.sql | 215 ++++++++++++++++++++++++++++++ 1 file changed, 215 insertions(+) create mode 100644 sql/updates/world/2014_10_09_02_world.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2014_10_09_02_world.sql b/sql/updates/world/2014_10_09_02_world.sql new file mode 100644 index 00000000000..32b79006de6 --- /dev/null +++ b/sql/updates/world/2014_10_09_02_world.sql @@ -0,0 +1,215 @@ +SET @Guid := 74522; +SET @Entry := 19610; + +DELETE FROM `creature_text` WHERE `entry` in(19610,19217); +INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`,`BroadcastTextID`) VALUES +(19610, 0, 0, 'A skunk! Eeeeeeeeeeeeeeeeeew! Don''t touch me!', 12, 0, 100, 0, 0, 0, 'Irradiated Worker',17857), +(19610, 1, 0, 'Get it away from me!', 12, 0, 100, 0, 0, 0, 'Irradiated Worker',17858), +(19610, 2, 0, 'Show us a trick, Ravandwyr!', 12, 0, 100, 0, 0, 0, 'Irradiated Worker',17852), +(19610, 3, 0, 'Let me outta here! Guys... guys?', 12, 0, 100, 0, 0, 0, 'Irradiated Worker',17874), +(19610, 4, 0, 'Oh man, he got you good!', 12, 0, 100, 0, 0, 0, 'Irradiated Worker',17875), +(19610, 5, 0, 'Remember how you''re always telling us to chill?', 12, 0, 100, 11, 0, 0, 'Irradiated Worker',17876), +(19610, 6, 0, 'That was the best trick ever! Ok, boys, let''s go get a drink.', 12, 0, 100, 4, 0, 0, 'Irradiated Worker',17853), +(19610, 7, 0, 'My eyebrows! You singed my eyebrows!', 12, 0, 100, 22, 0, 0, 'Irradiated Worker',20285), +(19610, 8, 0, 'Don''t worry. It''s an improvement!', 12, 0, 100, 11, 0, 0, 'Irradiated Worker',20286), +(19217, 0, 0, 'Oh, another show already? Very well then...', 12, 0, 100, 1, 0, 0, 'Ravandwyr',17848), +(19217, 1, 0, '%s sighs audibly and glances at Sagan.', 16, 0, 100, 0, 0, 0, 'Ravandwyr',17849), +(19217, 2, 0, 'I shall transform my familiar, Sagan, into something truly wondrous!', 12, 0, 100, 25, 0, 0, 'Ravandwyr',17855), +(19217, 3, 0, 'And, for my next trick...', 12, 0, 100, 1, 0, 0, 'Ravandwyr',17850), +(19217, 4, 0, 'A simple practical joke.', 12, 0, 100, 25, 0, 0, 'Ravandwyr',17877), +(19217, 5, 0, 'Thank you for watching, everyone! If you''d be so kind as to bring your non-irradiated currency to tomorrow''s performance, I''d appreciate it.', 12, 0, 100, 2, 0, 0, 'Ravandwyr',17856), +(19217, 6, 0, 'I shall breathe fire!', 12, 0, 100, 25, 0, 0, 'Ravandwyr',17854); + +UPDATE `creature_template` SET `ainame`='SmartAI', `scriptname`='' WHERE `entry` IN(19610,19217,19482); +DELETE FROM `smart_scripts` WHERE `entryorguid` IN(19610,19217,-@Guid-0,-@Guid-1,-@Guid-2,19482) AND `source_type`=0; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN(1921700,1921701,1921702) AND `source_type`=9; + +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 +(1921700, 9, 0, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ravandwyr - Script 1 - Say Line 0'), +(1921700, 9, 1, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ravandwyr - Script 1 - Say Line 1'), +(1921700, 9, 2, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 1, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ravandwyr - Script 1 - Say Line 3'), +(1921700, 9, 3, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 1, 4, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ravandwyr - Script 1 - Say Line 4'), +(1921700, 9, 4, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 11, 34326, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ravandwyr - Script 1 - Cast Frost Nova'), +(1921700, 9, 5, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 45, 3, 3, 0, 0, 0, 0, 10, @Guid+1, 19610, 0, 0, 0, 0, 0, 'Ravandwyr - Script 1 - Set Data Irradiated Worker'), +(1921700, 9, 6, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 1, 3, 0, 0, 0, 0, 0, 10, @Guid+1, 19610, 0, 0, 0, 0, 0, 'Ravandwyr - Script 1 - Say Line 3 on Irradiated Worker'), +(1921700, 9, 7, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 5, 11, 0, 0, 0, 0, 0, 9, 19610, 0, 20, 0, 0, 0, 0, 'Ravandwyr - Script 1 - Play Emote OneShotLaugh'), +(1921700, 9, 8, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 1, 4, 0, 0, 0, 0, 0, 10, @Guid+2, 19610, 0, 0, 0, 0, 0, 'Ravandwyr - Script 1 - Say Line 4 on Irradiated Worker'), +(1921700, 9, 9, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 5, 11, 0, 0, 0, 0, 0, 9, 19610, 0, 20, 0, 0, 0, 0, 'Ravandwyr - Script 1 - Play Emote OneShotLaugh'), +(1921700, 9, 10, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 1, 5, 0, 0, 0, 0, 0, 10, @Guid+0, 19610, 0, 0, 0, 0, 0, 'Ravandwyr - Script 1 - Say Line 5 on Irradiated Worker'), +(1921700, 9, 11, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 1, 5, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ravandwyr - Script 1 - Say Line 5'), +(1921700, 9, 12, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 5, 4, 0, 0, 0, 0, 0, 9, 19610, 0, 20, 0, 0, 0, 0, 'Ravandwyr - Script 1 - Play Emote OneShotCheer'), +(1921700, 9, 13, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 1, 6, 0, 0, 0, 0, 0, 10, @Guid+2, 19610, 0, 0, 0, 0, 0, 'Ravandwyr - Script 1 - Say Line 6'), +(1921700, 9, 14, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 45, 2, 2, 0, 0, 0, 0, 9, 19610, 0, 100, 0, 0, 0, 0, 'Ravandwyr - Script 1 - Set Data on Irradiated Worker'), +(1921701, 9, 0, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ravandwyr - Script 2 - Say Line 0'), +(1921701, 9, 1, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ravandwyr - Script 2 - Say Line 1'), +(1921701, 9, 2, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 1, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ravandwyr - Script 2 - Say Line 3'), +(1921701, 9, 3, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ravandwyr - Script 2 - Say Line 2'), +(1921701, 9, 4, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 11, 34656, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ravandwyr - Script 2 - Cast Arcane Explosion (Cosmetic)'), +(1921701, 9, 5, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 45, 1, 1, 0, 0, 0, 0, 19, 19482, 0, 0, 0, 0, 0, 0, 'Ravandwyr - Script 2 - Set Data Sagan'), +(1921701, 9, 6, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 10, @Guid+2, 19610, 0, 0, 0, 0, 0, 'Ravandwyr - Script 2 - Say Line 0 on Irradiated Worker'), +(1921701, 9, 7, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 1, 1, 0, 0, 0, 0, 0, 10, @Guid+1, 19610, 0, 0, 0, 0, 0, 'Ravandwyr - Script 2 - Say Line 1 on Irradiated Worker'), +(1921701, 9, 8, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 45, 2, 2, 0, 0, 0, 0, 19, 19482, 0, 0, 0, 0, 0, 0, 'Ravandwyr - Script 2 - Set Data Sagan'), +(1921701, 9, 9, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 1, 5, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ravandwyr - Script 2 - Say Line 5'), +(1921701, 9, 10, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 5, 4, 0, 0, 0, 0, 0, 9, 19610, 0, 20, 0, 0, 0, 0, 'Ravandwyr - Script 2 - Play Emote OneShotCheer'), +(1921701, 9, 11, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 1, 6, 0, 0, 0, 0, 0, 10, @Guid+2, 19610, 0, 0, 0, 0, 0, 'Ravandwyr - Script 2 - Say Line 6'), +(1921701, 9, 12, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 45, 2, 2, 0, 0, 0, 0, 9, 19610, 0, 100, 0, 0, 0, 0, 'Ravandwyr - Script 2 - Set Data on Irradiated Worker'), +(1921702, 9, 0, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ravandwyr - Script 3 - Say Line 0'), +(1921702, 9, 1, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ravandwyr - Script 3 - Say Line 1'), +(1921702, 9, 2, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 1, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ravandwyr - Script 3 - Say Line 3'), +(1921702, 9, 3, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 1, 6, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ravandwyr - Script 3 - Say Line 6'), +(1921702, 9, 4, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 11, 29389, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ravandwyr - Script 3 - Cast Firebreathing'), +(1921702, 9, 5, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 1, 7, 0, 0, 0, 0, 0, 10, @Guid+1, 19610, 0, 0, 0, 0, 0, 'Ravandwyr - Script 3 - Say Line 7 on Irradiated Worker'), +(1921702, 9, 6, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 1, 8, 0, 0, 0, 0, 0, 10, @Guid+2, 19610, 0, 0, 0, 0, 0, 'Ravandwyr - Script 3 - Say Line 8 on Irradiated Worker'), +(1921702, 9, 7, 0, 0, 0, 100, 0, 2000, 2000, 0, 0, 1, 5, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ravandwyr - Script 3 - Say Line 5'), +(1921702, 9, 8, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 5, 4, 0, 0, 0, 0, 0, 9, 19610, 0, 20, 0, 0, 0, 0, 'Ravandwyr - Script 3 - Play Emote OneShotCheer'), +(1921702, 9, 9, 0, 0, 0, 100, 0, 3000, 3000, 0, 0, 1, 6, 0, 0, 0, 0, 0, 10, @Guid+2, 19610, 0, 0, 0, 0, 0, 'Ravandwyr - Script 3 - Say Line 6'), +(1921702, 9, 10, 0, 0, 0, 100, 0, 4000, 4000, 0, 0, 45, 2, 2, 0, 0, 0, 0, 9, 19610, 0, 100, 0, 0, 0, 0, 'Ravandwyr - Script 3 - Set Data on Irradiated Worker'), +(19217, 0, 0, 0, 38, 0, 100, 0, 1, 1, 0, 0, 87, 1921700, 1921701, 1921702, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Ravandwyr - On Data Set - Run Script'), +(19217, 0, 1, 2, 1, 0, 100, 0, 420000, 600000, 420000, 600000, 45, 1, 1, 0, 0, 0, 0, 10, @Guid+0, 19610, 0, 0, 0, 0, 0, 'Ravandwyr - OOC - Set Data'), +(19217, 0, 2, 3, 61, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 10, @Guid+1, 19610, 0, 0, 0, 0, 0, 'Ravandwyr - OOC - Set Data'), +(19217, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 10, @Guid+2, 19610, 0, 0, 0, 0, 0, 'Ravandwyr - OOC - Set Data'), +(19217, 0, 4, 5, 38, 0, 100, 0, 2, 2, 0, 0, 45, 1, 1, 0, 0, 0, 0, 10, @Guid+0, 19610, 0, 0, 0, 0, 0, 'Ravandwyr - On Data Set - Set Data'), +(19217, 0, 5, 6, 61, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 10, @Guid+1, 19610, 0, 0, 0, 0, 0, 'Ravandwyr - On Data Set - Set Data'), +(19217, 0, 6, 0, 61, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 10, @Guid+2, 19610, 0, 0, 0, 0, 0, 'Ravandwyr - On Data Set - Set Data'), +(19217, 0, 7, 8, 62, 0, 100, 0, 7981, 0, 0, 0, 85, 35378, 2, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Ravandwyr - On Gossip Option 0 Selected - Invoker Cast Summon Archmages Staff'), +(19217, 0, 8, 0, 61, 0, 100, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'Ravandwyr - On Gossip Option 0 Selected - Close Gossip'), +(19482, 0, 0, 1, 38, 0, 100, 0, 1, 1, 0, 0, 11, 34718, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Sagan - On Data Set - Cast Transform Sagan (Skunk)'), +(19482, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 53, 0, 19482, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Sagan - On Data Set - Start WP'), +(19482, 0, 2, 0, 38, 0, 100, 0, 2, 2, 0, 0, 28, 34718, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Sagan - On Data Set - Remove Aura Transform Sagan (Skunk)'), +(-@Guid-0, 0, 0, 7, 38, 0, 100, 1, 1, 1, 0, 0, 53, 0, (@Entry*100)+0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Irradiated Worker - On Data Set Start WP'), +(-@Guid-1, 0, 0, 7, 38, 0, 100, 1, 1, 1, 0, 0, 53, 0, (@Entry*100)+1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Irradiated Worker - On Data Set Start WP'), +(-@Guid-2, 0, 0, 7, 38, 0, 100, 1, 1, 1, 0, 0, 53, 0, (@Entry*100)+2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Irradiated Worker - On Data Set Start WP'), +(-@Guid-0, 0, 1, 0, 38, 0, 100, 1, 2, 2, 0, 0, 53, 0, (@Entry*100)+3, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Irradiated Worker - On Data Set Start WP'), +(-@Guid-1, 0, 1, 0, 38, 0, 100, 1, 2, 2, 0, 0, 53, 0, (@Entry*100)+3, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Irradiated Worker - On Data Set Start WP'), +(-@Guid-2, 0, 1, 0, 38, 0, 100, 1, 2, 2, 0, 0, 53, 0, (@Entry*100)+3, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Irradiated Worker - On Data Set Start WP'), +(-@Guid-0, 0, 2, 3, 40, 0, 100, 1, 15, (@Entry*100)+0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Irradiated Worker - On Reached WP15 - Say Line'), +(-@Guid-0, 0, 3, 8, 61, 0, 100, 1, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 19, 19217, 0, 0, 0, 0, 0, 0, 'Irradiated Worker - On Reached WP15 - Set Data Ravandwyr'), +(-@Guid-1, 0, 2, 0, 38, 0, 100, 1, 3, 3, 0, 0, 11, 34973, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Irradiated Worker - On Data Set - Cast Ravandwyrs Ice Block'), +(-@Guid-0, 0, 4, 0, 40, 0, 100, 1, 39, (@Entry*100)+3, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Irradiated Worker - On Reached WP52 - Despawn'), +(-@Guid-1, 0, 4, 0, 40, 0, 100, 1, 39, (@Entry*100)+3, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Irradiated Worker - On Reached WP52 - Despawn'), +(-@Guid-2, 0, 4, 0, 40, 0, 100, 1, 39, (@Entry*100)+3, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Irradiated Worker - On Reached WP52 - Despawn'), +(-@Guid-0, 0, 5, 6, 11, 0, 100, 0, 0, 0, 0, 0, 47, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Irradiated Worker - On Spawn - Set Invisible'), +(-@Guid-1, 0, 5, 6, 11, 0, 100, 0, 0, 0, 0, 0, 47, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Irradiated Worker - On Spawn - Set Invisible'), +(-@Guid-2, 0, 5, 6, 11, 0, 100, 0, 0, 0, 0, 0, 47, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Irradiated Worker - On Spawn - Set Invisible'), +(-@Guid-0, 0, 6, 0, 61, 0, 100, 0, 0, 0, 0, 0, 17, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Irradiated Worker - On Spawn - Set Emote State None'), +(-@Guid-1, 0, 6, 0, 61, 0, 100, 0, 0, 0, 0, 0, 17, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Irradiated Worker - On Spawn - Set Emote State None'), +(-@Guid-2, 0, 6, 0, 61, 0, 100, 0, 0, 0, 0, 0, 17, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Irradiated Worker - On Spawn - Set Emote State None'), +(-@Guid-0, 0, 7, 0, 61, 0, 100, 0, 0, 0, 0, 0, 47, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Irradiated Worker - On Data Set - Set Visible'), +(-@Guid-1, 0, 7, 0, 61, 0, 100, 0, 0, 0, 0, 0, 47, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Irradiated Worker - On Data Set - Set Visible'), +(-@Guid-2, 0, 7, 0, 61, 0, 100, 0, 0, 0, 0, 0, 47, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Irradiated Worker - On Data Set - Set Visible'), +(-@Guid-0, 0, 8, 0, 61, 0, 100, 0, 0, 0, 0, 0, 66, 0, 0, 0, 0, 0, 0, 19, 19217, 0, 0, 0, 0, 0, 0, 'Irradiated Worker - Reached WP - Set Orientation'), +(-@Guid-1, 0, 8, 0, 40, 0, 100, 0, 15, (@Entry*100)+1, 0, 0, 66, 0, 0, 0, 0, 0, 0, 19, 19217, 0, 0, 0, 0, 0, 0, 'Irradiated Worker - On Reached WP - Set Orientation'), +(-@Guid-2, 0, 8, 0, 40, 0, 100, 0, 4, (@Entry*100)+2, 0, 0, 66, 0, 0, 0, 0, 0, 0, 19, 19217, 0, 0, 0, 0, 0, 0, 'Irradiated Worker - On Reached WP - Set Orientation'); + +DELETE FROM `creature` WHERE `guid` In(@Guid,@Guid+1,@Guid+2); +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +-- GUID: Full: 0xF1304C9A00055BAB Type: Unit Entry: 19610 Low: 351147 +(@Guid+0, 19610, 530, 1, 1, 0, 1, 2987.086, 3693.867, 142.8286, 1.888375, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0), +-- GUID: Full: 0xF1304C9A00055BAA Type: Unit Entry: 19610 Low: 351146 +(@Guid+1, 19610, 530, 1, 1, 0, 1, 2985.687, 3696.518, 142.7822, 1.968468, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0), +-- GUID: Full: 0xF1304C9A00055BA9 Type: Unit Entry: 19610 Low: 351145 +(@Guid+2, 19610, 530, 1, 1, 0, 1, 2984.306, 3699.182, 142.6974, 2.028504, 300, 0, 0, 0, 0, 0, 0, 0, 0, 0); + +DELETE FROM `waypoints` WHERE `entry` BETWEEN (@Entry*100)+0 AND (@Entry*100)+3; +DELETE FROM `waypoints` WHERE `entry` =19482; + +INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES +-- Entry: Full: 0xF1304C9A00055BAB Type: Unit Entry: 19610 Low: 351147 +((@Entry*100)+0, 1, 2984.458, 3699.44, 142.6468, 'Irradiated Worker'), +((@Entry*100)+0, 2, 2982.822, 3701.982, 142.6412, 'Irradiated Worker'), +((@Entry*100)+0, 3, 2980.689, 3704.22, 142.5162, 'Irradiated Worker'), +((@Entry*100)+0, 4, 2979.411, 3706.947, 142.5162, 'Irradiated Worker'), +((@Entry*100)+0, 5, 2972.232, 3710.486, 142.5704, 'Irradiated Worker'), +((@Entry*100)+0, 6, 2975.728, 3712.639, 142.3912, 'Irradiated Worker'), +((@Entry*100)+0, 7, 2978.256, 3714.196, 142.3912, 'Irradiated Worker'), +((@Entry*100)+0, 8, 2980.499, 3716.544, 142.3912, 'Irradiated Worker'), +((@Entry*100)+0, 9, 2983.385, 3717.424, 142.46, 'Irradiated Worker'), +((@Entry*100)+0, 10, 2988.857, 3715.101, 143.0921, 'Irradiated Worker'), +((@Entry*100)+0, 11, 2990.199, 3717.815, 143.0774, 'Irradiated Worker'), +((@Entry*100)+0, 12, 2991.541, 3720.528, 143.1886, 'Irradiated Worker'), +((@Entry*100)+0, 13, 2992.891, 3723.256, 143.4944, 'Irradiated Worker'), +((@Entry*100)+0, 14, 2993.456, 3724.4, 143.6318, 'Irradiated Worker'), +((@Entry*100)+0, 15, 2997.077, 3726.937, 143.8528, 'Irradiated Worker'), +-- Entry: Full: 0xF1304C9A00055BAA Type: Unit Entry: 19610 Low: 351146 +((@Entry*100)+1, 1, 2982.834, 3701.963, 142.6412, 'Irradiated Worker'), +((@Entry*100)+1, 2, 2981.199, 3704.505, 142.5162, 'Irradiated Worker'), +((@Entry*100)+1, 3, 2979.416, 3706.937, 142.5162, 'Irradiated Worker'), +((@Entry*100)+1, 4, 2978.139, 3709.664, 142.3633, 'Irradiated Worker'), +((@Entry*100)+1, 5, 2974.786, 3712.059, 142.2566, 'Irradiated Worker'), +((@Entry*100)+1, 6, 2978.282, 3714.212, 142.3912, 'Irradiated Worker'), +((@Entry*100)+1, 7, 2980.81, 3715.77, 142.3912, 'Irradiated Worker'), +((@Entry*100)+1, 8, 2983.369, 3717.418, 142.4579, 'Irradiated Worker'), +((@Entry*100)+1, 9, 2986.255, 3718.298, 142.6792, 'Irradiated Worker'), +((@Entry*100)+1, 10, 2990.187, 3717.79, 143.0789, 'Irradiated Worker'), +((@Entry*100)+1, 11, 2991.529, 3720.504, 143.1872, 'Irradiated Worker'), +((@Entry*100)+1, 12, 2992.871, 3723.217, 143.4897, 'Irradiated Worker'), +((@Entry*100)+1, 13, 2994.22, 3725.945, 143.6921, 'Irradiated Worker'), +((@Entry*100)+1, 14, 2994.786, 3727.09, 143.8295, 'Irradiated Worker'), +((@Entry*100)+1, 15, 2993.273, 3728.817, 144.0368, 'Irradiated Worker'), +-- Entry: Full: 0xF1304C9A00055BA9 Type: Unit Entry: 19610 Low: 351145 +((@Entry*100)+2, 1, 2976.518, 3713.125, 142.3912, 'Irradiated Worker'), +((@Entry*100)+2, 2, 2976.683, 3713.479, 142.6767, 'Irradiated Worker'), +((@Entry*100)+2, 3, 2991.181, 3719.8, 143.1453, 'Irradiated Worker'), +((@Entry*100)+2, 4, 2996.115, 3729.779, 143.9875, 'Irradiated Worker'), +-- End WP +((@Entry*100)+3, 1, 2995.449, 3728.861, 144.042, 'Irradiated Worker'), +((@Entry*100)+3, 2, 2993.671, 3726.411, 143.748, 'Irradiated Worker'), +((@Entry*100)+3, 3, 2992.502, 3723.404, 143.5121, 'Irradiated Worker'), +((@Entry*100)+3, 4, 2990.972, 3722.039, 143.2026, 'Irradiated Worker'), +((@Entry*100)+3, 5, 2987.993, 3719.381, 142.7629, 'Irradiated Worker'), +((@Entry*100)+3, 6, 2983.944, 3718.579, 142.5269, 'Irradiated Worker'), +((@Entry*100)+3, 7, 2982.988, 3715.74, 142.4609, 'Irradiated Worker'), +((@Entry*100)+3, 8, 2980.014, 3713.131, 142.628, 'Irradiated Worker'), +((@Entry*100)+3, 9, 2980.164, 3711.079, 142.6879, 'Irradiated Worker'), +((@Entry*100)+3, 10, 2980.455, 3707.102, 142.523, 'Irradiated Worker'), +((@Entry*100)+3, 11, 2980.064, 3704.01, 142.2676, 'Irradiated Worker'), +((@Entry*100)+3, 12, 2980.808, 3701.123, 142.6412, 'Irradiated Worker'), +((@Entry*100)+3, 13, 2983.227, 3692.621, 143.0479, 'Irradiated Worker'), +((@Entry*100)+3, 14, 2986.019, 3691.538, 142.9493, 'Irradiated Worker'), +((@Entry*100)+3, 15, 2988.529, 3688.696, 142.8852, 'Irradiated Worker'), +((@Entry*100)+3, 16, 2994.542, 3689.015, 143.4549, 'Irradiated Worker'), +((@Entry*100)+3, 17, 2997.563, 3689.176, 143.6308, 'Irradiated Worker'), +((@Entry*100)+3, 18, 3000.586, 3689.337, 143.6308, 'Irradiated Worker'), +((@Entry*100)+3, 19, 3003.604, 3689.804, 143.6307, 'Irradiated Worker'), +((@Entry*100)+3, 20, 3006.637, 3689.782, 143.6307, 'Irradiated Worker'), +((@Entry*100)+3, 21, 3009.671, 3689.76, 143.6307, 'Irradiated Worker'), +((@Entry*100)+3, 22, 3012.702, 3689.738, 143.6307, 'Irradiated Worker'), +((@Entry*100)+3, 23, 3015.754, 3690.37, 143.6307, 'Irradiated Worker'), +((@Entry*100)+3, 24, 3018.766, 3690.016, 143.6306, 'Irradiated Worker'), +((@Entry*100)+3, 25, 3021.777, 3689.662, 143.6306, 'Irradiated Worker'), +((@Entry*100)+3, 26, 3024.792, 3689.307, 143.6306, 'Irradiated Worker'), +((@Entry*100)+3, 27, 3027.821, 3689.124, 143.6306, 'Irradiated Worker'), +((@Entry*100)+3, 28, 3030.809, 3688.724, 143.2758, 'Irradiated Worker'), +((@Entry*100)+3, 29, 3033.767, 3688.14, 143.0482, 'Irradiated Worker'), +((@Entry*100)+3, 30, 3036.724, 3687.555, 142.9637, 'Irradiated Worker'), +((@Entry*100)+3, 31, 3039.848, 3684.927, 142.7658, 'Irradiated Worker'), +((@Entry*100)+3, 32, 3042.658, 3686.022, 142.7131, 'Irradiated Worker'), +((@Entry*100)+3, 33, 3045.463, 3687.116, 142.6446, 'Irradiated Worker'), +((@Entry*100)+3, 34, 3048.52, 3687.687, 142.3446, 'Irradiated Worker'), +((@Entry*100)+3, 35, 3051.203, 3689.113, 142.5257, 'Irradiated Worker'), +((@Entry*100)+3, 36, 3053.872, 3690.532, 140.5028, 'Irradiated Worker'), +((@Entry*100)+3, 37, 3056.601, 3691.824, 142.8937, 'Irradiated Worker'), +((@Entry*100)+3, 38, 3058.226, 3692.761, 143.2548, 'Irradiated Worker'), +((@Entry*100)+3, 39, 3058.292, 3692.803, 143.258, 'Irradiated Worker'), +-- Sagan +(19482, 1, 2996.497, 3734.341, 144.3418, 'Sagan '), +(19482, 2, 2993.747, 3734.091, 144.0918, 'Sagan '), +(19482, 3, 2991.747, 3732.591, 144.0918, 'Sagan '), +(19482, 4, 2990.747, 3730.341, 144.0918, 'Sagan '), +(19482, 5, 2991.247, 3727.591, 144.0918, 'Sagan '), +(19482, 6, 2993.497, 3725.591, 144.0918, 'Sagan '), +(19482, 7, 2996.747, 3724.341, 144.0918, 'Sagan '), +(19482, 8, 2999.997, 3725.841, 144.0918, 'Sagan '), +(19482, 9, 3001.247, 3730.091, 144.0918, 'Sagan '); + +DELETE FROM `gossip_menu_option` WHERE `menu_id`=7981; +INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `OptionBroadcastTextID`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`, `BoxBroadcastTextID`) VALUES +(7981, 0, 0, 'I''ve lost Archmage Vargoth''s Staff. Can you replace it?', 18546, 1, 1, 0, 0, 0, 0, '', 0); + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=7981; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES +(15, 7981, 0, 0, 0, 2, 0, 28455, 1, 0, 1, 0, 0, '', 'Gossip Option requires Player does not have Archmage Vargoths Staff'), +(15, 7981, 0, 0, 0, 8, 0, 10174, 0, 0, 0, 0, 0, '', 'Gossip Option requires Curse of the Violet Tower rewarded'), +(15, 7981, 0, 0, 0, 8, 0, 10209, 0, 0, 1, 0, 0, '', 'Gossip Option requires Player is not rewarded for Summoner Kanthins Prize'); + +UPDATE `creature_text` SET `probability`=20 WHERE `entry`=19541; -- cgit v1.2.3