From ab5b273d3cc02f9db39864b39c55a619dc0a88e6 Mon Sep 17 00:00:00 2001 From: megamage Date: Fri, 22 May 2009 10:29:48 -0500 Subject: *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 --- sql/updates/3466_world_scripts_(wintergrasp).sql | 19 +++++++++++++++++++ 1 file changed, 19 insertions(+) create mode 100644 sql/updates/3466_world_scripts_(wintergrasp).sql (limited to 'sql') 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 -- cgit v1.2.3