From 7d8174d8d839cc2af397e90d1634fe9d217782e4 Mon Sep 17 00:00:00 2001 From: megamage Date: Sun, 7 Jun 2009 23:36:37 -0500 Subject: *Some small update of kelthuzad script. --HG-- branch : trunk --- sql/updates/3856_world_spell_(naxx).sql | 9 +++++++++ sql/world_spell_full.sql | 7 ++++++- 2 files changed, 15 insertions(+), 1 deletion(-) create mode 100644 sql/updates/3856_world_spell_(naxx).sql (limited to 'sql') diff --git a/sql/updates/3856_world_spell_(naxx).sql b/sql/updates/3856_world_spell_(naxx).sql new file mode 100644 index 00000000000..3b3895b3c4d --- /dev/null +++ b/sql/updates/3856_world_spell_(naxx).sql @@ -0,0 +1,9 @@ +UPDATE `creature_template` SET `minlevel`='80',`maxlevel`='80',`faction_A`='21',`faction_H`='21' WHERE entry IN (16286,30068); + +INSERT INTO creature_template (entry, baseattacktime, spell1, flags_extra, scriptname) VALUES +(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); diff --git a/sql/world_spell_full.sql b/sql/world_spell_full.sql index c1a59dd43c2..54577ff975e 100644 --- a/sql/world_spell_full.sql +++ b/sql/world_spell_full.sql @@ -1666,7 +1666,8 @@ 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) +(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), @@ -1739,6 +1740,10 @@ 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 -- -------- -- cgit v1.2.3