aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authormegamage <none@none>2009-05-22 10:29:48 -0500
committermegamage <none@none>2009-05-22 10:29:48 -0500
commitab5b273d3cc02f9db39864b39c55a619dc0a88e6 (patch)
tree0a4c70cceda85c10e754ef70abb0b111c274ec26 /sql
parent4ba955c4ebe1c91ac1b40246d148d34bd7680b09 (diff)
*Some work on wintergrasp. Player can get ranks by killing other players and can build vehicles at workshop. Vehicles can be used to destroy buildings. Except these no other thing is done.
--HG-- branch : trunk
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/3466_world_scripts_(wintergrasp).sql19
1 files changed, 19 insertions, 0 deletions
diff --git a/sql/updates/3466_world_scripts_(wintergrasp).sql b/sql/updates/3466_world_scripts_(wintergrasp).sql
new file mode 100644
index 00000000000..ac757d126de
--- /dev/null
+++ b/sql/updates/3466_world_scripts_(wintergrasp).sql
@@ -0,0 +1,19 @@
+DELETE FROM `spell_script_target` WHERE entry IN
+(56575,56661,56663,56665,56667,56669,61408);
+INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES
+(56575, 1, 27852),
+(56661, 1, 27852),
+(56663, 1, 27852),
+(56665, 1, 27852),
+(56667, 1, 27852),
+(56669, 1, 27852),
+(61408, 1, 27852);
+
+
+update creature_template set maxhealth = 133525, minhealth = 133525, maxmana = 51360, minmana = 51360, spell1 = 53114, spell2 = 53112, spell3=53110 where entry = 28670;
+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); \ No newline at end of file