aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authormegamage <none@none>2009-08-29 23:20:16 -0500
committermegamage <none@none>2009-08-29 23:20:16 -0500
commitd802cd3811c77a1b0bef95a65fdfc4872ff557a8 (patch)
tree68be363ef1f3ce843a32254a9b8fd122b7803434 /sql
parent6954eae60ac320639451bd83782f294da367b733 (diff)
*More update about positions.
*Ulduar: do not allow demolisher to regenerate pyrite. Player must shoot down and grab the containers to refill pyrite. --HG-- branch : trunk
Diffstat (limited to 'sql')
-rw-r--r--sql/FULL/world_spell_full.sql3
-rw-r--r--sql/updates/5475_world_scripts_ulduar.sql3
2 files changed, 5 insertions, 1 deletions
diff --git a/sql/FULL/world_spell_full.sql b/sql/FULL/world_spell_full.sql
index aa5bb7610a6..7e54af3df84 100644
--- a/sql/FULL/world_spell_full.sql
+++ b/sql/FULL/world_spell_full.sql
@@ -2193,12 +2193,13 @@ spell5 = VALUES(spell5),
spell6 = VALUES(spell6),
vehicleid = VALUES(vehicleid);
-DELETE FROM `spell_script_target` WHERE `entry` IN (62427,62374,62399,62056,63985);
+DELETE FROM `spell_script_target` WHERE `entry` IN (62427,62496,62374,62399,62056,63985);
INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
(62427, 1, 33109), # Load into Catapult
(62374, 1, 33060), # Pursued
(62374, 1, 33109),
(62399, 1, 33139), # Overload Circuit
+(62496, 1, 33167), # Liquid Pyrite - Salvaged Demolisher Mechanic Seat
(63985, 1, 32934), # Stone Grip
(62056, 1, 32934);
diff --git a/sql/updates/5475_world_scripts_ulduar.sql b/sql/updates/5475_world_scripts_ulduar.sql
new file mode 100644
index 00000000000..8939ee109a7
--- /dev/null
+++ b/sql/updates/5475_world_scripts_ulduar.sql
@@ -0,0 +1,3 @@
+DELETE FROM `spell_script_target` WHERE `entry` IN (62496);
+INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
+(62496, 1, 33167); # Liquid Pyrite - Salvaged Demolisher Mechanic Seat