diff options
| -rw-r--r-- | sql/FULL/world_scripts_full.sql | 4 | ||||
| -rw-r--r-- | sql/FULL/world_spell_full.sql | 188 | ||||
| -rw-r--r-- | sql/FULL/world_tmp_full.sql | 193 | ||||
| -rw-r--r-- | sql/updates/4451_world_tmp.sql | 1 |
4 files changed, 197 insertions, 189 deletions
diff --git a/sql/FULL/world_scripts_full.sql b/sql/FULL/world_scripts_full.sql index 6491cb49270..b700a19f87b 100644 --- a/sql/FULL/world_scripts_full.sql +++ b/sql/FULL/world_scripts_full.sql @@ -113,6 +113,7 @@ UPDATE `creature_template` SET `ScriptName`='npc_dark_rider_of_acherus' WHERE `e UPDATE `creature_template` SET `ScriptName`='npc_ros_dark_rider' WHERE `entry`=28768; UPDATE `creature_template` SET `ScriptName`='npc_dkc1_gothik' WHERE `entry`=28658; UPDATE `creature_template` SET `ScriptName`='npc_a_special_surprise' WHERE `entry` IN (29032, 29061, 29065, 29067, 29068, 29070, 29074, 29072, 29073, 29071); +UPDATE `creature_template` SET `ScriptName`='npc_demolisher_engineerer' WHERE `entry` IN (30400, 30499); /* */ /* ZONE */ @@ -675,7 +676,8 @@ UPDATE `creature_template` SET `ScriptName`='boss_stalagg' WHERE `entry`=15929; UPDATE `creature_template` SET `ScriptName`='boss_fugen' WHERE `entry`=15930; UPDATE `creature_template` SET `ScriptName`='boss_sapphiron' WHERE `entry`=15989; UPDATE `creature_template` SET `ScriptName`='boss_kelthuzad' WHERE `entry`=15990; -UPDATE `creature_template` SET `ScriptName`='' WHERE `entry`=16062; +UPDATE `creature_template` SET `ScriptName`='' WHERE `entry` IN (16062, 30000); +UPDATE `creature_template` SET `ScriptName`='trigger_periodic' WHERE `entry` IN (16474, 16697, 16129); /* NETHERSTORM */ UPDATE `gameobject_template` SET `ScriptName`='go_manaforge_control_console' WHERE `entry` IN (183770,183956,184311,184312); diff --git a/sql/FULL/world_spell_full.sql b/sql/FULL/world_spell_full.sql index af704f5f1f5..31a5c5c091f 100644 --- a/sql/FULL/world_spell_full.sql +++ b/sql/FULL/world_spell_full.sql @@ -138,28 +138,6 @@ INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comm -- -------- --- TRIGGER --- -------- - -INSERT INTO creature_template (entry, spell1, flags_extra, scriptname) VALUES -(23095, 40980, 128, 'molten_flame'), # molten_flame -# (23085, 40117, 128, ''), # volcano -(23336, 40836, 128, ''), # flame crash -(23259, 40610, 128, ''), # blaze -(23069, 40029, 128, ''), # demon fire -(24187, 43218, 128, ''), # pillar of fire -(17662, 30914, 128, ''), # Broggok Poison Cloud -(25879, 46262, 128, ''), # Void Zone Periodic -(16363, 28158, 128, ''), # Grobbulus Cloud -(29379, 54362, 128, '') # Grobbulus Cloud (H) -ON DUPLICATE KEY UPDATE -spell1 = VALUES(spell1), -flags_extra = VALUES(flags_extra), -scriptname = VALUES(scriptname); - -UPDATE creature_template SET speed = 1.0 WHERE entry = 23095; # molten_flame - --- -------- -- CLICK -- -------- @@ -523,8 +501,6 @@ INSERT INTO `spell_target_position` (`id`, `target_map`, `target_position_x`, `t -- -------- -- MISC -- -------- -UPDATE `creature_template` SET `flags_extra` = 33 WHERE `entry` = 23576; /*no crush*/ - DELETE FROM `playercreateinfo_spell` WHERE Spell = 56816; INSERT INTO `playercreateinfo_spell` (`race`, `class`, `Spell`, `Note`) VALUES (0, 6, 56816, 'Rune Strike'); @@ -1555,27 +1531,8 @@ INSERT INTO `spell_affect` (`entry`, `effectId`, `SpellClassMask0`, `SpellClassM (44544,0,685904631,1151048,0); -- Fingers of frost -- -------- --- PET --- -------- -INSERT INTO creature_template (entry, spell1, spell2, spell3, spell4) VALUES -(15352, 36213, 0, 0, 0), # Greater Earth Elemental -(15438, 57984, 12470, 13376, 0), # Greater Fire Elemental -(29264, 58861, 58875, 58867, 58857), # Spirit Wolf -(510, 31707, 33395, 0, 0) # Water Elemental -ON DUPLICATE KEY UPDATE -spell1 = VALUES(spell1), -spell2 = VALUES(spell2), -spell3 = VALUES(spell3), -spell4 = VALUES(spell4); - --- Three-seat mammoth -UPDATE creature_template SET VehicleId = 312 WHERE entry IN (31857,31858,31861,31862,32212,32213,32633,32640); - --- -------- -- Death Knight -- -------- -update creature_template set spell5=51890 where entry = 28511; -- Eye of Acherus flight - DELETE FROM `spell_script_target` WHERE entry IN (51859, 48743, 52124, 52479, 52576, 53110); INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES @@ -1596,64 +1553,11 @@ DELETE FROM `spell_target_position` WHERE `id`=51852; INSERT INTO `spell_target_position` (`id`, `target_map`, `target_position_x`, `target_position_y`, `target_position_z`, `target_orientation`) VALUES (51852, 609, 2361.21, -5660.45, 503.828, 4.49); -update creature_template set minlevel=50,maxlevel=52,minhealth=2215,maxhealth=2317,faction_A=2084,faction_H=2084,mindmg=50,maxdmg=50 where entry=28528; -- ghoul -UPDATE `creature_template` SET spell1=52372,spell2=52373,spell3=52374,spell4=52375 WHERE `entry`=28406; - -- death charger DELETE FROM spell_area WHERE spell = 52693; INSERT INTO spell_area (`spell`, `area`, `quest_start`, `quest_start_active`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`) VALUES (52693, 4298, 12687, 1, 12687, 0, 0, 0, 1); --- Horses for quest 12680 / not sure if its offilike -UPDATE creature_template SET `VehicleId`=200 WHERE `entry` IN (28605,28606,28607); - --- Vehicle and summon spell(summon npc 28788) for Acherus Deathcharger -UPDATE creature_template SET `spell1`=52362, `VehicleId`=200 WHERE `entry`=28782; - --- DK quest data TODO: remove these when DB projects release with proper data -DELETE FROM `creature_questrelation` WHERE `quest`=12701; -INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (28377, 12701); -DELETE FROM `creature_involvedrelation` WHERE `quest`=12701; -INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (28377, 12701); -DELETE FROM `creature_involvedrelation` WHERE `quest`=12723; -INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (28914, 12723); -DELETE FROM `creature_questrelation` WHERE `quest`=12724; -INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (28914, 12724); -DELETE FROM `creature_involvedrelation` WHERE `quest`=12724; -INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (28914, 12724); -DELETE FROM `creature_questrelation` WHERE `quest`=12725; -INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (28913, 12725); -DELETE FROM `creature_involvedrelation` WHERE `quest`=12725; -INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (28912, 12725); -DELETE FROM `creature_questrelation` WHERE `quest`=12727; -INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (28912, 12727); -DELETE FROM `creature_involvedrelation` WHERE `quest`=12727; -INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (28913, 12727); -DELETE FROM `creature_questrelation` WHERE `quest` = 12754; -INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (28914, 12754); -DELETE FROM `creature_involvedrelation` WHERE `quest` = 12754; -INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (28914, 12754); -DELETE FROM `creature_questrelation` WHERE `quest` = 12757; -INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (28914, 12757); -DELETE FROM `creature_questrelation` WHERE `quest` = 12754; -INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (28914, 12754); -DELETE FROM `creature_involvedrelation` WHERE `quest` = 12754; -INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (28914, 12754); -DELETE FROM `creature_questrelation` WHERE `quest` = 12755; -INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (28914, 12755); -DELETE FROM `creature_involvedrelation` WHERE `quest` = 12756; -INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (28914, 12756); -DELETE FROM `creature_questrelation` WHERE `quest` = 12757; -INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (28914, 12757); -DELETE FROM `creature_involvedrelation` WHERE `quest` = 12800; -INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (31082, 12800); -DELETE FROM `creature_questrelation` WHERE `quest` = 12801; -INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (31082, 12801); -DELETE FROM `creature_involvedrelation` WHERE `quest` = 12801; -INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (29173, 12801); -UPDATE `quest_template` SET `PrevQuestId`=13166 WHERE `entry`=13188; -UPDATE `quest_template` SET `PrevQuestId`=13166 WHERE `entry`=13189; - DELETE FROM `npc_spellclick_spells` WHERE `spell_id` IN ( 54568, 54575, 52263, 52280, 52447); INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_start`, `quest_start_active`, `quest_end`, `cast_flags`) VALUES @@ -1666,16 +1570,6 @@ INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_start`, `qu (28833, 52447, 12701, 1, 12701, 1), -- Scarlet Cannon Master (28887, 52447, 12701, 1, 12701, 1); -UPDATE creature_template SET spell1=52435,spell2=52576,spell5=52588,VehicleId=68,speed=0 WHERE entry IN (28833,28887); -UPDATE creature_template SET spell1=52211 WHERE entry=28864; --- Citizen of New Avalon -UPDATE creature_template SET unit_flags = 537166336, dynamicflags = 0 WHERE entry = 28942; --- frostbrood vanquisher -update creature_template set maxhealth = 133525, minhealth = 133525, maxmana = 51360, minmana = 51360, spell1 = 53114, spell2 = 53112, spell3=53110, VehicleId = 156 where entry = 28670; - -UPDATE `creature` SET `phaseMask`=128 WHERE `id` IN (31082,29173,29199,29204,29200); - - -- -------- -- NAXXARAMAS -- -------- @@ -1702,27 +1596,6 @@ INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comm (-39091,-39092, 0, 'Negative Charge'); # ( 39093,-39092, 0, 'Negative Charge'); -INSERT INTO creature_template (entry, spell1, flags_extra, scriptname) VALUES -(16363, 28158, 128, ''), # Grobbulus Cloud -(29379, 54362, 128, ''), # Grobbulus Cloud (H) -(16697, 28158, 128, ''), # Void Zone -(29379, 54362, 128, '') # Void Zone (H) -ON DUPLICATE KEY UPDATE -spell1 = VALUES(spell1), -flags_extra = VALUES(flags_extra), -scriptname = VALUES(scriptname); - -INSERT INTO creature_template (entry, baseattacktime, spell1, flags_extra, scriptname) VALUES -(16474, 1000, 28547, 128, 'trigger_periodic'), # Blizzard (Sapphiron) -(30000, 1000, 55699, 128, ''), # Blizzard (Sapphiron) (H) -(16697, 1000, 28865, 128, 'trigger_periodic'), # Void Zone (Lady Blaumeux) -(16129, 10000, 27812, 128, 'trigger_periodic') # Shadow Fissure (Kel'thezad) -ON DUPLICATE KEY UPDATE -baseattacktime = VALUES(baseattacktime), -spell1 = VALUES(spell1), -flags_extra = VALUES(flags_extra), -scriptname = VALUES(scriptname); - DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (29912); INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_start`, `quest_start_active`, `quest_end`, `cast_flags`) VALUES (29912, 55479, 0, 0, 0, 3); # Obedience Crystal - Force Obedience @@ -1742,61 +1615,9 @@ INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES (27935, 1, 16060), # To Anchor 1 - Gothik (27936, 1, 16060); # To Anchor 2 - Gothik -INSERT INTO creature_template (entry, spell1, spell2, spell3, spell4, spell5, spell6, spell7, spell8) VALUES -(16573, 15284, 28991, 28969, 34970, 0, 0, 0, 28864), # Crypt Guard -(29256, 15284, 28991, 56098, 34970, 0, 0, 0, 28864), # Crypt Guard (H) -(16506, 54095, 0, 0, 0, 0, 0, 0, 28732), # Naxxramas Worshipper -(29274, 54096, 0, 0, 0, 0, 0, 0, 54097), # Naxxramas Worshipper (H) -(17055, 54121, 0, 0, 0, 0, 0, 0, 0), # Maexxna Spiderling -(29279, 28776, 0, 0, 0, 0, 0, 0, 0), # Maexxna Spiderling (H) -(16486, 28622, 0, 0, 0, 0, 0, 0, 0), # Web Wrap -(30183, 28622, 0, 0, 0, 0, 0, 0, 0), # Web Wrap (H) -(16984, 15496, 0, 0, 0, 0, 0, 0, 0), # Plagued Warrior -(29632, 15496, 0, 0, 0, 0, 0, 0, 0), # Plagued Warrior (H) -(16983, 32736, 30138, 0, 0, 0, 0, 0, 0), # Plagued Champion -(29632, 32736, 54889, 0, 0, 0, 0, 0, 0), # Plagued Champion (H) -(16981, 15496, 54890, 0, 0, 0, 0, 0, 0), # Plagued Guardian -(29632, 15496, 54891, 0, 0, 0, 0, 0, 0), # Plagued Guardian (H) -(16286, 0, 0, 0, 0, 0, 0, 0, 29232), # Spore -(30068, 0, 0, 0, 0, 0, 0, 0, 29232), # Spore (H) -(16290, 28156, 0, 0, 0, 0, 0, 0, 0), # Fallout Slime -(29388, 54367, 0, 0, 0, 0, 0, 0, 0), # Fallout Slime (H) -(16360, 29307, 0, 0, 0, 0, 0, 0, 0), # Zombie Chow -(30303, 29307, 0, 0, 0, 0, 0, 0, 0), # Zombie Chow (H) -(16803, 0, 0, 0, 61696, 29060, 29061, 0, 0), # Death Knight Understudy -(29941, 0, 0, 0, 61696, 29060, 29061, 0, 0), # Death Knight Understudy (H) -(16124, 55604, 0, 0, 0, 0, 0, 0, 27892), # Unrelenting Trainee -(16125, 27825, 0, 0, 0, 0, 0, 0, 27928), # Unrelenting Death Knight -(16126, 27831, 55606, 0, 0, 0, 0, 0, 27935), # Unrelenting Rider -(16127, 27989, 0, 0, 0, 0, 0, 0, 0), # Spectral Trainee -(16148, 56408, 0, 0, 0, 0, 0, 0, 0), # Spectral Death Knight -(16150, 27994, 55648, 55606, 0, 0, 0, 0, 0), # Spectral Rider -(16149, 27993, 0, 0, 0, 0, 0, 0, 0), # Spectral Horse -(29985, 55645, 0, 0, 0, 0, 0, 0, 27892), # Unrelenting Trainee (H) -(29986, 27825, 0, 0, 0, 0, 0, 0, 27928), # Unrelenting Death Knight (H) -(29987, 55638, 55608, 0, 0, 0, 0, 0, 27935), # Unrelenting Rider (H) -(30264, 56407, 0, 0, 0, 0, 0, 0, 0), # Spectral Trainee (H) -(29990, 56408, 0, 0, 0, 0, 0, 0, 0), # Spectral Death Knight (H) -(29988, 55646, 27995, 55608, 0, 0, 0, 0, 0), # Spectral Rider (H) -(29989, 27993, 0, 0, 0, 0, 0, 0, 0) # Spectral Horse (H) -ON DUPLICATE KEY UPDATE -spell1 = VALUES(spell1), -spell2 = VALUES(spell2), -spell3 = VALUES(spell3), -spell4 = VALUES(spell4), -spell5 = VALUES(spell5), -spell6 = VALUES(spell6), -spell7 = VALUES(spell7), -spell8 = VALUES(spell8); - -# Spore -UPDATE `creature_template` SET `minlevel`='80',`maxlevel`='80',`faction_A`='21',`faction_H`='21' WHERE entry IN (16286,30068); - - -- -------- -- WINTERGRASP -- -------- - DELETE FROM `game_event` WHERE `entry` IN (50,51); INSERT INTO `game_event` (`entry`, `description`, `world_event`) VALUES (50, 'Wintergrasp Alliance Defence', 5), @@ -1822,12 +1643,3 @@ INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES DELETE FROM `spell_linked_spell` WHERE `spell_trigger` IN (54643); INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES ( 54643,-54643, 2, 'Wintergrasp Defender Teleport'); - -update creature_template set maxhealth = 30000, minhealth = 30000, speed = 2, spell1=50025, spell2=50989, VehicleId = 36 where entry = 27881; -update creature_template set maxhealth = 50000, minhealth = 50000, speed = 1.6, spell1=50896, spell2=50652, VehicleId = 106 where entry = 28094; -update creature_template set maxhealth = 75000, minhealth = 75000, speed = 1, spell1=51678, VehicleId = 117 where entry IN (28312,32627); -update creature_template set maxhealth = 50000, minhealth = 50000, spell1=51362, VehicleId = 116 where entry IN (28319,32629); - -update creature_template set scriptname = "npc_demolisher_engineerer" where entry in (30400,30499); - -UPDATE creature_template SET VehicleId = 174 WHERE entry IN (31125,31722); diff --git a/sql/FULL/world_tmp_full.sql b/sql/FULL/world_tmp_full.sql new file mode 100644 index 00000000000..c62373d9a90 --- /dev/null +++ b/sql/FULL/world_tmp_full.sql @@ -0,0 +1,193 @@ +-- -------- +-- TRIGGER +-- -------- + +INSERT INTO creature_template (entry, spell1, flags_extra, scriptname) VALUES +(23095, 40980, 128, 'molten_flame'), # molten_flame +# (23085, 40117, 128, ''), # volcano +(23336, 40836, 128, ''), # flame crash +(23259, 40610, 128, ''), # blaze +(23069, 40029, 128, ''), # demon fire +(24187, 43218, 128, ''), # pillar of fire +(17662, 30914, 128, ''), # Broggok Poison Cloud +(25879, 46262, 128, ''), # Void Zone Periodic +(16363, 28158, 128, ''), # Grobbulus Cloud +(29379, 54362, 128, '') # Grobbulus Cloud (H) +ON DUPLICATE KEY UPDATE +spell1 = VALUES(spell1), +flags_extra = VALUES(flags_extra), +scriptname = VALUES(scriptname); + +UPDATE creature_template SET speed = 1.0 WHERE entry = 23095; # molten_flame + +-- -------- +-- MISC +-- -------- +UPDATE `creature_template` SET `flags_extra` = 33 WHERE `entry` = 23576; /*no crush*/ + +-- -------- +-- PET +-- -------- +INSERT INTO creature_template (entry, spell1, spell2, spell3, spell4) VALUES +(15352, 36213, 0, 0, 0), # Greater Earth Elemental +(15438, 57984, 12470, 13376, 0), # Greater Fire Elemental +(29264, 58861, 58875, 58867, 58857), # Spirit Wolf +(510, 31707, 33395, 0, 0) # Water Elemental +ON DUPLICATE KEY UPDATE +spell1 = VALUES(spell1), +spell2 = VALUES(spell2), +spell3 = VALUES(spell3), +spell4 = VALUES(spell4); + +-- Three-seat mammoth +UPDATE creature_template SET VehicleId = 312 WHERE entry IN (31857,31858,31861,31862,32212,32213,32633,32640); + +-- -------- +-- Death Knight +-- -------- +update creature_template set spell5=51890 where entry = 28511; -- Eye of Acherus flight + +update creature_template set minlevel=50,maxlevel=52,minhealth=2215,maxhealth=2317,faction_A=2084,faction_H=2084,mindmg=50,maxdmg=50 where entry=28528; -- ghoul +UPDATE `creature_template` SET spell1=52372,spell2=52373,spell3=52374,spell4=52375 WHERE `entry`=28406; + +-- Horses for quest 12680 / not sure if its offilike +UPDATE creature_template SET `VehicleId`=200, spell1=52264, spell2=52268 WHERE `entry` IN (28605, 28606, 28607); + +-- Vehicle and summon spell(summon npc 28788) for Acherus Deathcharger +UPDATE creature_template SET `spell1`=52362, `VehicleId`=200 WHERE `entry`=28782; + +-- DK quest data TODO: remove these when DB projects release with proper data +DELETE FROM `creature_questrelation` WHERE `quest`=12701; +INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (28377, 12701); +DELETE FROM `creature_involvedrelation` WHERE `quest`=12701; +INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (28377, 12701); +DELETE FROM `creature_involvedrelation` WHERE `quest`=12723; +INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (28914, 12723); +DELETE FROM `creature_questrelation` WHERE `quest`=12724; +INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (28914, 12724); +DELETE FROM `creature_involvedrelation` WHERE `quest`=12724; +INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (28914, 12724); +DELETE FROM `creature_questrelation` WHERE `quest`=12725; +INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (28913, 12725); +DELETE FROM `creature_involvedrelation` WHERE `quest`=12725; +INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (28912, 12725); +DELETE FROM `creature_questrelation` WHERE `quest`=12727; +INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (28912, 12727); +DELETE FROM `creature_involvedrelation` WHERE `quest`=12727; +INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (28913, 12727); +DELETE FROM `creature_questrelation` WHERE `quest` = 12754; +INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (28914, 12754); +DELETE FROM `creature_involvedrelation` WHERE `quest` = 12754; +INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (28914, 12754); +DELETE FROM `creature_questrelation` WHERE `quest` = 12757; +INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (28914, 12757); +DELETE FROM `creature_questrelation` WHERE `quest` = 12754; +INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (28914, 12754); +DELETE FROM `creature_involvedrelation` WHERE `quest` = 12754; +INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (28914, 12754); +DELETE FROM `creature_questrelation` WHERE `quest` = 12755; +INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (28914, 12755); +DELETE FROM `creature_involvedrelation` WHERE `quest` = 12756; +INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (28914, 12756); +DELETE FROM `creature_questrelation` WHERE `quest` = 12757; +INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (28914, 12757); +DELETE FROM `creature_involvedrelation` WHERE `quest` = 12800; +INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (31082, 12800); +DELETE FROM `creature_questrelation` WHERE `quest` = 12801; +INSERT INTO `creature_questrelation` (`id`, `quest`) VALUES (31082, 12801); +DELETE FROM `creature_involvedrelation` WHERE `quest` = 12801; +INSERT INTO `creature_involvedrelation` (`id`, `quest`) VALUES (29173, 12801); +UPDATE `quest_template` SET `PrevQuestId`=13166 WHERE `entry`=13188; +UPDATE `quest_template` SET `PrevQuestId`=13166 WHERE `entry`=13189; + +UPDATE creature_template SET spell1=52435,spell2=52576,spell5=52588,VehicleId=68,speed=0 WHERE entry IN (28833,28887); +UPDATE creature_template SET spell1=52211 WHERE entry=28864; +-- Citizen of New Avalon +UPDATE creature_template SET unit_flags = 537166336, dynamicflags = 0 WHERE entry = 28942; +-- frostbrood vanquisher +update creature_template set maxhealth = 133525, minhealth = 133525, maxmana = 51360, minmana = 51360, spell1 = 53114, spell2 = 53112, spell3=53110, VehicleId = 156 where entry = 28670; + +UPDATE `creature` SET `phaseMask`=128 WHERE `id` IN (31082,29173,29199,29204,29200); + +-- -------- +-- NAXXARAMAS +-- -------- +INSERT INTO creature_template (entry, spell1, flags_extra, scriptname) VALUES +(16363, 28158, 128, ''), # Grobbulus Cloud +(29379, 54362, 128, ''), # Grobbulus Cloud (H) +(16697, 28158, 128, ''), # Void Zone +(29379, 54362, 128, '') # Void Zone (H) +ON DUPLICATE KEY UPDATE +spell1 = VALUES(spell1), +flags_extra = VALUES(flags_extra), +scriptname = VALUES(scriptname); + +INSERT INTO creature_template (entry, baseattacktime, spell1, flags_extra) VALUES +(16474, 1000, 28547, 128), # Blizzard (Sapphiron) +(30000, 1000, 55699, 128), # Blizzard (Sapphiron) (H) +(16697, 1000, 28865, 128), # Void Zone (Lady Blaumeux) +(16129, 10000, 27812, 128) # Shadow Fissure (Kel'thezad) +ON DUPLICATE KEY UPDATE +baseattacktime = VALUES(baseattacktime), +spell1 = VALUES(spell1), +flags_extra = VALUES(flags_extra); + +INSERT INTO creature_template (entry, spell1, spell2, spell3, spell4, spell5, spell6, spell7, spell8) VALUES +(16573, 15284, 28991, 28969, 34970, 0, 0, 0, 28864), # Crypt Guard +(29256, 15284, 28991, 56098, 34970, 0, 0, 0, 28864), # Crypt Guard (H) +(16506, 54095, 0, 0, 0, 0, 0, 0, 28732), # Naxxramas Worshipper +(29274, 54096, 0, 0, 0, 0, 0, 0, 54097), # Naxxramas Worshipper (H) +(17055, 54121, 0, 0, 0, 0, 0, 0, 0), # Maexxna Spiderling +(29279, 28776, 0, 0, 0, 0, 0, 0, 0), # Maexxna Spiderling (H) +(16486, 28622, 0, 0, 0, 0, 0, 0, 0), # Web Wrap +(30183, 28622, 0, 0, 0, 0, 0, 0, 0), # Web Wrap (H) +(16984, 15496, 0, 0, 0, 0, 0, 0, 0), # Plagued Warrior +(29632, 15496, 0, 0, 0, 0, 0, 0, 0), # Plagued Warrior (H) +(16983, 32736, 30138, 0, 0, 0, 0, 0, 0), # Plagued Champion +(29632, 32736, 54889, 0, 0, 0, 0, 0, 0), # Plagued Champion (H) +(16981, 15496, 54890, 0, 0, 0, 0, 0, 0), # Plagued Guardian +(29632, 15496, 54891, 0, 0, 0, 0, 0, 0), # Plagued Guardian (H) +(16286, 0, 0, 0, 0, 0, 0, 0, 29232), # Spore +(30068, 0, 0, 0, 0, 0, 0, 0, 29232), # Spore (H) +(16290, 28156, 0, 0, 0, 0, 0, 0, 0), # Fallout Slime +(29388, 54367, 0, 0, 0, 0, 0, 0, 0), # Fallout Slime (H) +(16360, 29307, 0, 0, 0, 0, 0, 0, 0), # Zombie Chow +(30303, 29307, 0, 0, 0, 0, 0, 0, 0), # Zombie Chow (H) +(16803, 0, 0, 0, 61696, 29060, 29061, 0, 0), # Death Knight Understudy +(29941, 0, 0, 0, 61696, 29060, 29061, 0, 0), # Death Knight Understudy (H) +(16124, 55604, 0, 0, 0, 0, 0, 0, 27892), # Unrelenting Trainee +(16125, 27825, 0, 0, 0, 0, 0, 0, 27928), # Unrelenting Death Knight +(16126, 27831, 55606, 0, 0, 0, 0, 0, 27935), # Unrelenting Rider +(16127, 27989, 0, 0, 0, 0, 0, 0, 0), # Spectral Trainee +(16148, 56408, 0, 0, 0, 0, 0, 0, 0), # Spectral Death Knight +(16150, 27994, 55648, 55606, 0, 0, 0, 0, 0), # Spectral Rider +(16149, 27993, 0, 0, 0, 0, 0, 0, 0), # Spectral Horse +(29985, 55645, 0, 0, 0, 0, 0, 0, 27892), # Unrelenting Trainee (H) +(29986, 27825, 0, 0, 0, 0, 0, 0, 27928), # Unrelenting Death Knight (H) +(29987, 55638, 55608, 0, 0, 0, 0, 0, 27935), # Unrelenting Rider (H) +(30264, 56407, 0, 0, 0, 0, 0, 0, 0), # Spectral Trainee (H) +(29990, 56408, 0, 0, 0, 0, 0, 0, 0), # Spectral Death Knight (H) +(29988, 55646, 27995, 55608, 0, 0, 0, 0, 0), # Spectral Rider (H) +(29989, 27993, 0, 0, 0, 0, 0, 0, 0) # Spectral Horse (H) +ON DUPLICATE KEY UPDATE +spell1 = VALUES(spell1), +spell2 = VALUES(spell2), +spell3 = VALUES(spell3), +spell4 = VALUES(spell4), +spell5 = VALUES(spell5), +spell6 = VALUES(spell6), +spell7 = VALUES(spell7), +spell8 = VALUES(spell8); + +# Spore +UPDATE `creature_template` SET `minlevel`='80',`maxlevel`='80',`faction_A`='21',`faction_H`='21' WHERE entry IN (16286,30068); + +-- -------- +-- WINTERGRASP +-- -------- +update creature_template set maxhealth = 30000, minhealth = 30000, speed = 2, spell1=50025, spell2=50989, VehicleId = 36 where entry = 27881; +update creature_template set maxhealth = 50000, minhealth = 50000, speed = 1.6, spell1=50896, spell2=50652, VehicleId = 106 where entry = 28094; +update creature_template set maxhealth = 75000, minhealth = 75000, speed = 1, spell1=51678, VehicleId = 117 where entry IN (28312,32627); +update creature_template set maxhealth = 50000, minhealth = 50000, spell1=51362, VehicleId = 116 where entry IN (28319,32629); + +UPDATE creature_template SET VehicleId = 174 WHERE entry IN (31125,31722); diff --git a/sql/updates/4451_world_tmp.sql b/sql/updates/4451_world_tmp.sql new file mode 100644 index 00000000000..30f12539d75 --- /dev/null +++ b/sql/updates/4451_world_tmp.sql @@ -0,0 +1 @@ +UPDATE creature_template SET `VehicleId`=200, spell1=52264, spell2=52268 WHERE `entry` IN (28605, 28606, 28607); |