diff options
author | megamage <none@none> | 2009-05-22 10:29:48 -0500 |
---|---|---|
committer | megamage <none@none> | 2009-05-22 10:29:48 -0500 |
commit | ab5b273d3cc02f9db39864b39c55a619dc0a88e6 (patch) | |
tree | 0a4c70cceda85c10e754ef70abb0b111c274ec26 /sql | |
parent | 4ba955c4ebe1c91ac1b40246d148d34bd7680b09 (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).sql | 19 |
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 |