diff options
| -rw-r--r-- | sql/world_spell_full.sql | 46 |
1 files changed, 1 insertions, 45 deletions
diff --git a/sql/world_spell_full.sql b/sql/world_spell_full.sql index 1163adc50a2..efcc9a81949 100644 --- a/sql/world_spell_full.sql +++ b/sql/world_spell_full.sql @@ -161,52 +161,8 @@ spell1 = VALUES(spell1), flags_extra = VALUES(flags_extra), scriptname = VALUES(scriptname); -INSERT INTO creature_template (entry, spell1, spell2, flags_extra, scriptname) VALUES -(16474, 28547, 0, 128, 'trigger_periodic'), # Blizzard (Sapphiron) -(30000, 55699, 0, 128, '') # Blizzard (Sapphiron) (H) -ON DUPLICATE KEY UPDATE -spell1 = VALUES(spell1), -spell2 = VALUES(spell2), -flags_extra = VALUES(flags_extra), -scriptname = VALUES(scriptname); - UPDATE creature_template SET speed = 1.0 WHERE entry = 23095; # molten_flame -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) -(16984, 15496, 0, 0, 0, 0, 0, 0, 0), # Plagued Warrior -(29632, 15496, 0, 0, 0, 0, 0, 0, 0), # Plagued Warrior (H) -(16290, 28156, 0, 0, 0, 0, 0, 0, 0), # Fallout Slime -(29388, 54367, 0, 0, 0, 0, 0, 0, 0), # Fallout Slime (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); - -- -------- -- CLICK -- -------- @@ -1619,7 +1575,7 @@ 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, 'trigger_periodic'), # Blizzard (Sapphiron) (H) +(30000, 1000, 55699, 128, ''), # Blizzard (Sapphiron) (H) (16697, 1000, 28865, 128, 'trigger_periodic') # Void Zone (Lady Blaumeux) ON DUPLICATE KEY UPDATE baseattacktime = VALUES(baseattacktime), |