From d6db97f4f1cf2e127fa9994a00b4b05dde339509 Mon Sep 17 00:00:00 2001 From: Malcrom Date: Mon, 25 Jun 2012 20:08:07 -0230 Subject: DB/SQL: Filename fix and some comments updated. --- .../world/2012_06_12_00_world_transport.sql | 24 +-- sql/updates/world/2012_06_24_00_world_quest.sql | 167 --------------------- sql/updates/world/2012_06_24_01_world_quest.sql | 167 +++++++++++++++++++++ 3 files changed, 179 insertions(+), 179 deletions(-) delete mode 100644 sql/updates/world/2012_06_24_00_world_quest.sql create mode 100644 sql/updates/world/2012_06_24_01_world_quest.sql (limited to 'sql') diff --git a/sql/updates/world/2012_06_12_00_world_transport.sql b/sql/updates/world/2012_06_12_00_world_transport.sql index 3099292f48d..d3a35c254d9 100644 --- a/sql/updates/world/2012_06_12_00_world_transport.sql +++ b/sql/updates/world/2012_06_12_00_world_transport.sql @@ -45,19 +45,19 @@ INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type (@ENTRY*100,9,3,0,0,0,100,0,3000,3000,0,0,5,5,0,0,0,0,0,19,34715,100,0,0,0,0,0,'Zeppelin: - Script Dock Orgrimmar - Sky-Captain Blastnut emote'), (@ENTRY*100,9,4,0,0,0,100,0,1000,1000,0,0,5,25,0,0,0,0,0,19,34721,100,0,0,0,0,0,'Zeppelin: - Script Dock Orgrimmar - Chief Officer Ograh emote'), -- Script 1 -(@ENTRY*100+1,9,0,0,0,0,100,0,0,0,0,0,1,1,0,0,0,0,0,19,34715,100,0,0,0,0,0,'Zeppelin: - Script Dock Orgrimmar - Sky-Captain Blastnut Say 1'), -(@ENTRY*100+1,9,1,0,0,0,100,0,0,0,0,0,1,0,0,0,0,0,0,19,34721,100,0,0,0,0,0,'Zeppelin: - Script Dock Orgrimmar - Chief Officer Ograh Say 0'), -(@ENTRY*100+1,9,2,0,0,0,100,0,4000,4000,0,0,5,25,0,0,0,0,0,19,34721,100,0,0,0,0,0,'Zeppelin: - Script Dock Orgrimmar - Chief Officer Ograh emote'), +(@ENTRY*100+1,9,0,0,0,0,100,0,0,0,0,0,1,1,0,0,0,0,0,19,34715,100,0,0,0,0,0,'Zeppelin: - Script Leave Orgrimmar - Sky-Captain Blastnut Say 1'), +(@ENTRY*100+1,9,1,0,0,0,100,0,0,0,0,0,1,0,0,0,0,0,0,19,34721,100,0,0,0,0,0,'Zeppelin: - Script Leave Orgrimmar - Chief Officer Ograh Say 0'), +(@ENTRY*100+1,9,2,0,0,0,100,0,4000,4000,0,0,5,25,0,0,0,0,0,19,34721,100,0,0,0,0,0,'Zeppelin: - Script Leave Orgrimmar - Chief Officer Ograh emote'), -- Script 2 -(@ENTRY*100+2,9,0,0,0,0,100,0,0,0,0,0,1,2,0,0,0,0,0,19,34715,100,0,0,0,0,0,'Zeppelin: - Script Dock Orgrimmar - Sky-Captain Blastnut Say 2'), -(@ENTRY*100+2,9,1,0,0,0,100,0,0,0,0,0,1,1,0,0,0,0,0,19,34721,100,0,0,0,0,0,'Zeppelin: - Script Dock Orgrimmar - Chief Officer Ograh Say 1'), -(@ENTRY*100+2,9,2,0,0,0,100,0,0,0,0,0,1,0,0,0,0,0,0,19,34766,100,0,0,0,0,0,'Zeppelin: - Script Dock Orgrimmar - Krendle Bigpockets Say 0'), -(@ENTRY*100+2,9,3,0,0,0,100,0,3000,3000,0,0,5,5,0,0,0,0,0,19,34715,100,0,0,0,0,0,'Zeppelin: - Script Dock Orgrimmar - Sky-Captain Blastnut emote'), -(@ENTRY*100+2,9,4,0,0,0,100,0,1000,1000,0,0,5,25,0,0,0,0,0,19,34721,100,0,0,0,0,0,'Zeppelin: - Script Dock Orgrimmar - Chief Officer Ograh emote'), +(@ENTRY*100+2,9,0,0,0,0,100,0,0,0,0,0,1,2,0,0,0,0,0,19,34715,100,0,0,0,0,0,'Zeppelin: - Script Dock Thunder Bluff - Sky-Captain Blastnut Say 2'), +(@ENTRY*100+2,9,1,0,0,0,100,0,0,0,0,0,1,1,0,0,0,0,0,19,34721,100,0,0,0,0,0,'Zeppelin: - Script Dock Thunder Bluff - Chief Officer Ograh Say 1'), +(@ENTRY*100+2,9,2,0,0,0,100,0,0,0,0,0,1,0,0,0,0,0,0,19,34766,100,0,0,0,0,0,'Zeppelin: - Script Dock Thunder Bluff - Krendle Bigpockets Say 0'), +(@ENTRY*100+2,9,3,0,0,0,100,0,3000,3000,0,0,5,5,0,0,0,0,0,19,34715,100,0,0,0,0,0,'Zeppelin: - Script Dock Thunder Bluff - Sky-Captain Blastnut emote'), +(@ENTRY*100+2,9,4,0,0,0,100,0,1000,1000,0,0,5,25,0,0,0,0,0,19,34721,100,0,0,0,0,0,'Zeppelin: - Script Dock Thunder Bluff - Chief Officer Ograh emote'), -- Script 3 -(@ENTRY*100+3,9,0,0,0,0,100,0,0,0,0,0,1,3,0,0,0,0,0,19,34715,100,0,0,0,0,0,'Zeppelin: - Script Dock Orgrimmar - Sky-Captain Blastnut Say 3'), -(@ENTRY*100+3,9,1,0,0,0,100,0,0,0,0,0,1,2,0,0,0,0,0,19,34721,100,0,0,0,0,0,'Zeppelin: - Script Dock Orgrimmar - Chief Officer Ograh Say 2'), -(@ENTRY*100+3,9,2,0,0,0,100,0,4000,4000,0,0,5,25,0,0,0,0,0,19,34721,100,0,0,0,0,0,'Zeppelin: - Script Dock Orgrimmar - Chief Officer Ograh emote'); +(@ENTRY*100+3,9,0,0,0,0,100,0,0,0,0,0,1,3,0,0,0,0,0,19,34715,100,0,0,0,0,0,'Zeppelin: - Script Leave Thunder Bluff - Sky-Captain Blastnut Say 3'), +(@ENTRY*100+3,9,1,0,0,0,100,0,0,0,0,0,1,2,0,0,0,0,0,19,34721,100,0,0,0,0,0,'Zeppelin: - Script Leave Thunder Bluff - Chief Officer Ograh Say 2'), +(@ENTRY*100+3,9,2,0,0,0,100,0,4000,4000,0,0,5,25,0,0,0,0,0,19,34721,100,0,0,0,0,0,'Zeppelin: - Script Leave Thunder Bluff - Chief Officer Ograh emote'); -- Watcher Tolwe SAI SET @ENTRY := 34723; UPDATE `creature_template` SET `AIName`= 'SmartAI',`ScriptName`='' WHERE `entry`=@ENTRY; @@ -76,7 +76,7 @@ INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`pr (34715,2,0,'Watch your step! Don''t want you becoming a smudge down there. Welcome to Thunder Bluff!',12,1,100,1,0,0,'Sky-Captain Blastnut - Dock at Thunder Bluff'), -- wait 3 sec do emote 5 (34715,3,0,'Okay, boys, let''s get this baby over to Orgrimmar!',12,1,100,25,0,0,'Sky-Captain Blastnut - Leave for Orgrimmar'), (34721,0,0,'Move it, Zippik! We don''t have all day!',12,1,100,5,0,0,'Chief Officer Ograh - Leave for Thunder Bluff'), -(34721,1,0,'Careful. CAREFUL! Did I feel a shudder? You''re going to knock that tower down, oaf!',12,1,100,5,0,0,'Chief Officer Ograh - Dock at Thunder Bluff'), -- wait 4 sec do emote 25 +(34721,1,0,'Careful. CAREFUL! Did I feel a shudder? You''re going to knock that tower down, oaf!',12,1,100,5,0,0,'Chief Officer Ograh - Dock at Orgrimmar & Thunder Bluff'), (34721,2,0,'We''re behind schedule! Turn this tub east! EAST!',12,1,100,5,0,0,'Chief Officer Ograh - Leave for Orgrimmar'), (34766,0,0,'Step right up! The zeppelin to Orgrimmar has arrived! All aboard to Durotar!',14,0,100,22,0,11804,'Krendle Bigpockets - Dock at Thunder Bluff'), (34765,0,0,'The zeppelin to Thunder Bluff has arrived! All aboard for a smooth ride across the Barrens!',14,0,100,22,0,11804,'Zelli Hotnozzle - Dock at Orgrimmar'); diff --git a/sql/updates/world/2012_06_24_00_world_quest.sql b/sql/updates/world/2012_06_24_00_world_quest.sql deleted file mode 100644 index ec0d39b0c62..00000000000 --- a/sql/updates/world/2012_06_24_00_world_quest.sql +++ /dev/null @@ -1,167 +0,0 @@ -DELETE FROM `gameobject_questrelation` WHERE `id` IN (187564,187914,187916,187917,187919,187920,187921,187922,187923,187924,187925,187926,187927,187928,187929,187930,187931,187931,187932,187933,187934,187935,187936,187937,187938,187939,187940,187941,187942,187943,187944,187945,187946,194032,194035,194036,194038,194040,194044,194045,194049); -INSERT INTO `gameobject_questrelation` (`id`,`quest`) VALUES -(187564,11580), -(187914,11732), -(187916,11734), -(187917,11735), -(187919,11736), -(187920,11737), -(187921,11738), -(187922,11739), -(187923,11740), -(187924,11741), -(187925,11742), -(187926,11743), -(187927,11744), -(187928,11745), -(187929,11746), -(187930,11747), -(187931,11748), -(187932,11749), -(187933,11750), -(187934,11751), -(187935,11752), -(187936,11753), -(187937,11754), -(187938,11755), -(187939,11756), -(187940,11757), -(187941,11758), -(187942,11759), -(187943,11760), -(187944,11761), -(187945,11762), -(187946,11763), -(194032,13440), -(194035,13442), -(194036,13443), -(194038,13444), -(194040,13445), -(194044,13446), -(194045,13447), -(194049,13449); - -DELETE FROM `gameobject_involvedrelation` WHERE `id` IN (187564,187914,187916,187917,187919,187920,187921,187922,187923,187924,187925,187926,187927,187928,187929,187930,187931,187931,187932,187933,187934,187935,187936,187937,187938,187939,187940,187941,187942,187943,187944,187945,187946,194032,194035,194036,194038,194040,194044,194045,194049); -INSERT INTO `gameobject_involvedrelation` (`id`,`quest`) VALUES -(187564,11580), -(187914,11732), -(187916,11734), -(187917,11735), -(187919,11736), -(187920,11737), -(187921,11738), -(187922,11739), -(187923,11740), -(187924,11741), -(187925,11742), -(187926,11743), -(187927,11744), -(187928,11745), -(187929,11746), -(187930,11747), -(187931,11748), -(187932,11749), -(187933,11750), -(187934,11751), -(187935,11752), -(187936,11753), -(187937,11754), -(187938,11755), -(187939,11756), -(187940,11757), -(187941,11758), -(187942,11759), -(187943,11760), -(187944,11761), -(187945,11762), -(187946,11763), -(194032,13440), -(194035,13442), -(194036,13443), -(194038,13444), -(194040,13445), -(194044,13446), -(194045,13447), -(194049,13449); - -DELETE FROM `gameobject_questrelation` WHERE `id` IN (187559,187947,187948,187949,187950,187951,187952,187953,187954,187955,187956,187957,187958,187959,187960,187961,187962,187963,187964,187965,187966,187967,187968,187969,187970,187971,187972,187973,187974,187975,194033,194034,194037,194039,194042,194043,194046,194048); -INSERT INTO `gameobject_questrelation` (`id`,`quest`) VALUES -(187559,11581), -(187947,11764), -(187948,11765), -(187949,11766), -(187950,11767), -(187951,11768), -(187952,11769), -(187953,11770), -(187954,11771), -(187955,11772), -(187956,11773), -(187957,11774), -(187958,11775), -(187959,11776), -(187960,11777), -(187961,11778), -(187962,11779), -(187963,11780), -(187964,11781), -(187965,11782), -(187966,11783), -(187967,11784), -(187968,11785), -(187969,11786), -(187970,11787), -(187971,11799), -(187972,11800), -(187973,11801), -(187974,11802), -(187975,11803), -(194033,13441), -(194034,13450), -(194037,13451), -(194039,13453), -(194042,13454), -(194043,13455), -(194046,13457), -(194048,13458); - -DELETE FROM `gameobject_involvedrelation` WHERE `id` IN (187559,187947,187948,187949,187950,187951,187952,187953,187954,187955,187956,187957,187958,187959,187960,187961,187962,187963,187964,187965,187966,187967,187968,187969,187970,187971,187972,187973,187974,187975,194033,194034,194037,194039,194042,194043,194046,194048); -INSERT INTO `gameobject_involvedrelation` (`id`,`quest`) VALUES -(187559,11581), -(187947,11764), -(187948,11765), -(187949,11766), -(187950,11767), -(187951,11768), -(187952,11769), -(187953,11770), -(187954,11771), -(187955,11772), -(187956,11773), -(187957,11774), -(187958,11775), -(187959,11776), -(187960,11777), -(187961,11778), -(187962,11779), -(187963,11780), -(187964,11781), -(187965,11782), -(187966,11783), -(187967,11784), -(187968,11785), -(187969,11786), -(187970,11787), -(187971,11799), -(187972,11800), -(187973,11801), -(187974,11802), -(187975,11803), -(194033,13441), -(194034,13450), -(194037,13451), -(194039,13453), -(194042,13454), -(194043,13455), -(194046,13457), -(194048,13458); diff --git a/sql/updates/world/2012_06_24_01_world_quest.sql b/sql/updates/world/2012_06_24_01_world_quest.sql new file mode 100644 index 00000000000..ec0d39b0c62 --- /dev/null +++ b/sql/updates/world/2012_06_24_01_world_quest.sql @@ -0,0 +1,167 @@ +DELETE FROM `gameobject_questrelation` WHERE `id` IN (187564,187914,187916,187917,187919,187920,187921,187922,187923,187924,187925,187926,187927,187928,187929,187930,187931,187931,187932,187933,187934,187935,187936,187937,187938,187939,187940,187941,187942,187943,187944,187945,187946,194032,194035,194036,194038,194040,194044,194045,194049); +INSERT INTO `gameobject_questrelation` (`id`,`quest`) VALUES +(187564,11580), +(187914,11732), +(187916,11734), +(187917,11735), +(187919,11736), +(187920,11737), +(187921,11738), +(187922,11739), +(187923,11740), +(187924,11741), +(187925,11742), +(187926,11743), +(187927,11744), +(187928,11745), +(187929,11746), +(187930,11747), +(187931,11748), +(187932,11749), +(187933,11750), +(187934,11751), +(187935,11752), +(187936,11753), +(187937,11754), +(187938,11755), +(187939,11756), +(187940,11757), +(187941,11758), +(187942,11759), +(187943,11760), +(187944,11761), +(187945,11762), +(187946,11763), +(194032,13440), +(194035,13442), +(194036,13443), +(194038,13444), +(194040,13445), +(194044,13446), +(194045,13447), +(194049,13449); + +DELETE FROM `gameobject_involvedrelation` WHERE `id` IN (187564,187914,187916,187917,187919,187920,187921,187922,187923,187924,187925,187926,187927,187928,187929,187930,187931,187931,187932,187933,187934,187935,187936,187937,187938,187939,187940,187941,187942,187943,187944,187945,187946,194032,194035,194036,194038,194040,194044,194045,194049); +INSERT INTO `gameobject_involvedrelation` (`id`,`quest`) VALUES +(187564,11580), +(187914,11732), +(187916,11734), +(187917,11735), +(187919,11736), +(187920,11737), +(187921,11738), +(187922,11739), +(187923,11740), +(187924,11741), +(187925,11742), +(187926,11743), +(187927,11744), +(187928,11745), +(187929,11746), +(187930,11747), +(187931,11748), +(187932,11749), +(187933,11750), +(187934,11751), +(187935,11752), +(187936,11753), +(187937,11754), +(187938,11755), +(187939,11756), +(187940,11757), +(187941,11758), +(187942,11759), +(187943,11760), +(187944,11761), +(187945,11762), +(187946,11763), +(194032,13440), +(194035,13442), +(194036,13443), +(194038,13444), +(194040,13445), +(194044,13446), +(194045,13447), +(194049,13449); + +DELETE FROM `gameobject_questrelation` WHERE `id` IN (187559,187947,187948,187949,187950,187951,187952,187953,187954,187955,187956,187957,187958,187959,187960,187961,187962,187963,187964,187965,187966,187967,187968,187969,187970,187971,187972,187973,187974,187975,194033,194034,194037,194039,194042,194043,194046,194048); +INSERT INTO `gameobject_questrelation` (`id`,`quest`) VALUES +(187559,11581), +(187947,11764), +(187948,11765), +(187949,11766), +(187950,11767), +(187951,11768), +(187952,11769), +(187953,11770), +(187954,11771), +(187955,11772), +(187956,11773), +(187957,11774), +(187958,11775), +(187959,11776), +(187960,11777), +(187961,11778), +(187962,11779), +(187963,11780), +(187964,11781), +(187965,11782), +(187966,11783), +(187967,11784), +(187968,11785), +(187969,11786), +(187970,11787), +(187971,11799), +(187972,11800), +(187973,11801), +(187974,11802), +(187975,11803), +(194033,13441), +(194034,13450), +(194037,13451), +(194039,13453), +(194042,13454), +(194043,13455), +(194046,13457), +(194048,13458); + +DELETE FROM `gameobject_involvedrelation` WHERE `id` IN (187559,187947,187948,187949,187950,187951,187952,187953,187954,187955,187956,187957,187958,187959,187960,187961,187962,187963,187964,187965,187966,187967,187968,187969,187970,187971,187972,187973,187974,187975,194033,194034,194037,194039,194042,194043,194046,194048); +INSERT INTO `gameobject_involvedrelation` (`id`,`quest`) VALUES +(187559,11581), +(187947,11764), +(187948,11765), +(187949,11766), +(187950,11767), +(187951,11768), +(187952,11769), +(187953,11770), +(187954,11771), +(187955,11772), +(187956,11773), +(187957,11774), +(187958,11775), +(187959,11776), +(187960,11777), +(187961,11778), +(187962,11779), +(187963,11780), +(187964,11781), +(187965,11782), +(187966,11783), +(187967,11784), +(187968,11785), +(187969,11786), +(187970,11787), +(187971,11799), +(187972,11800), +(187973,11801), +(187974,11802), +(187975,11803), +(194033,13441), +(194034,13450), +(194037,13451), +(194039,13453), +(194042,13454), +(194043,13455), +(194046,13457), +(194048,13458); -- cgit v1.2.3