diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/3856_world_spell_(naxx).sql | 9 | ||||
| -rw-r--r-- | sql/world_spell_full.sql | 7 |
2 files changed, 15 insertions, 1 deletions
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 -- -------- |