diff options
| author | tartalo <none@none> | 2009-11-07 19:38:21 +0100 |
|---|---|---|
| committer | tartalo <none@none> | 2009-11-07 19:38:21 +0100 |
| commit | 808fe9ea6324e0e5497d881b8374b9f75259c5cd (patch) | |
| tree | d30c927f3066f340ebcc1cda1f018254cccca2cc /sql | |
| parent | 5b7ef6fd2fd95e944807f07dcf181b9f1e4ea573 (diff) | |
Borean Tundra, support for quest 'Escape from the Winterfin Caverns', by manuel
Borean Tundra, support for quest 'Unfit for Death', by Malcrom and manuel
Borean Tundra, support for quest 'Drake Hunt' (both versions), by manuel
Closes #66
--HG--
branch : trunk
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/FULL/world_script_waypoints.sql | 46 | ||||
| -rw-r--r-- | sql/FULL/world_scripts_full.sql | 5 | ||||
| -rw-r--r-- | sql/updates/6213_world_scripts.sql | 49 |
3 files changed, 100 insertions, 0 deletions
diff --git a/sql/FULL/world_script_waypoints.sql b/sql/FULL/world_script_waypoints.sql index 9b017e6b574..a839f97ebc7 100644 --- a/sql/FULL/world_script_waypoints.sql +++ b/sql/FULL/world_script_waypoints.sql @@ -1675,3 +1675,49 @@ INSERT INTO `script_waypoint` VALUES (23784, 21, 1608.51, -6175.83, 8.80075, 5, 'Apothecary Hanes'), (23784, 22, 1619.15, -6167.6, 9.39125, 5, 'Apothecary Hanes'), (23784, 23, 1634.05, -6153.81, 8.08527, 5, 'Apothecary Hanes'); + +DELETE FROM `script_waypoint` WHERE `entry`=25208; +INSERT INTO `script_waypoint` VALUES + (25208, 0, 4014.01, 6391.91, 29.9735, 17000, ''), + (25208, 1, 4029.05, 6374.1, 28.8288, 0, ''), + (25208, 2, 4039.11, 6370.05, 27.8701, 0, ''), + (25208, 3, 4052.24, 6364.92, 27.2941, 0, ''), + (25208, 4, 4058.31, 6357.79, 26.3543, 0, ''), + (25208, 5, 4062.46, 6346.26, 24.3838, 0, ''), + (25208, 6, 4063.82, 6334.14, 25.3818, 0, ''), + (25208, 7, 4062.66, 6319.39, 24.9775, 0, ''), + (25208, 8, 4061.14, 6307.67, 24.4034, 0, ''), + (25208, 9, 4059.64, 6301.33, 24.5615, 0, ''), + (25208, 10, 4066.46, 6292.12, 24.3167, 0, ''), + (25208, 11, 4078.37, 6280.88, 26.6926, 0, ''), + (25208, 12, 4087.03, 6281.33, 27.4604, 0, ''), + (25208, 13, 4097.8, 6282.47, 25.4414, 0, ''), + (25208, 14, 4107.07, 6279.26, 25.2578, 0, ''), + (25208, 15, 4114.68, 6279.78, 24.7762, 0, ''), + (25208, 16, 4122.9, 6280.34, 26.1671, 0, ''), + (25208, 17, 4127.69, 6280.67, 28.1951, 0, ''), + (25208, 18, 4134.75, 6282.09, 28.9761, 0, ''), + (25208, 19, 4141.62, 6281.92, 29.3518, 0, ''), + (25208, 20, 4152.14, 6281.43, 30.6951, 0, ''), + (25208, 21, 4159.63, 6282.6, 30.2401, 0, ''), + (25208, 22, 4169.82, 6289.25, 24.182, 0, ''), + (25208, 23, 4181.02, 6293.88, 18.035, 0, ''), + (25208, 24, 4189.27, 6295.87, 14.4513, 0, ''), + (25208, 25, 4200.09, 6298.4, 12.7249, 0, ''), + (25208, 26, 4206.46, 6291.56, 10.9628, 0, ''), + (25208, 27, 4211.45, 6282.82, 9.05693, 0, ''), + (25208, 28, 4215.22, 6277.25, 8.54002, 0, ''), + (25208, 29, 4215.28, 6268.57, 8.30674, 0, ''), + (25208, 30, 4224.23, 6269.53, 6.97205, 0, ''), + (25208, 31, 4235.98, 6270.9, 3.27214, 0, ''), + (25208, 32, 4242.67, 6269.45, 1.45579, 0, ''), + (25208, 33, 4250.43, 6262.49, 0.611961, 0, ''), + (25208, 34, 4259.07, 6253.33, -0.0686721, 0, ''), + (25208, 35, 4261.11, 6248.81, -0.112029, 0, ''), + (25208, 36, 4257.58, 6234.09, -0.094803, 0, ''), + (25208, 37, 4252.62, 6224.3, -0.154816, 0, ''), + (25208, 38, 4247.92, 6214.75, -0.221144, 0, ''), + (25208, 39, 4254.04, 6205.58, -0.186623, 0, ''), + (25208, 40, 4262.6, 6194.47, -0.145114, 0, ''), + (25208, 41, 4268.96, 6189.47, 0.0303093, 21000, ''); + diff --git a/sql/FULL/world_scripts_full.sql b/sql/FULL/world_scripts_full.sql index 5b78e2672fe..df559456193 100644 --- a/sql/FULL/world_scripts_full.sql +++ b/sql/FULL/world_scripts_full.sql @@ -362,6 +362,11 @@ UPDATE `creature_template` SET `ScriptName`='npc_loklira_crone' WHERE `entry`=29 UPDATE `creature_template` SET `ScriptName`='npc_victorious_challenger' WHERE `entry`=30012; UPDATE `creature_template` SET `ScriptName`='npc_mcgoyver' WHERE `entry`=24040; UPDATE `creature_template` SET `ScriptName`='npc_jenny' WHERE `entry`=25969; +UPDATE `creature_template` SET `ScriptName`='npc_lurgglbr' WHERE `entry`=25208; +UPDATE `creature_template` SET `ScriptName`='npc_nexus_drake_hatchling' WHERE `entry`=26127; +UPDATE `creature_template` SET `ScriptName`='npc_nesingwary_trapper' WHERE `entry`=25835; +UPDATE `item_template` SET `ScriptName`='item_pile_fake_furs' WHERE `entry`=35127; + /* BURNING STEPPES */ UPDATE `creature_template` SET `ScriptName`='npc_ragged_john' WHERE `entry`=9563; diff --git a/sql/updates/6213_world_scripts.sql b/sql/updates/6213_world_scripts.sql new file mode 100644 index 00000000000..8a34414f200 --- /dev/null +++ b/sql/updates/6213_world_scripts.sql @@ -0,0 +1,49 @@ +UPDATE `creature_template` SET `ScriptName`='npc_lurgglbr' WHERE `entry`=25208; +UPDATE `creature_template` SET `ScriptName`='npc_nexus_drake_hatchling' WHERE `entry`=26127; +UPDATE `creature_template` SET `ScriptName`='npc_nesingwary_trapper' WHERE `entry`=25835; +UPDATE `item_template` SET `ScriptName`='item_pile_fake_furs' WHERE `entry`=35127; + +DELETE FROM `script_waypoint` WHERE `entry`=25208; +INSERT INTO `script_waypoint` VALUES + (25208, 0, 4014.01, 6391.91, 29.9735, 17000, ''), + (25208, 1, 4029.05, 6374.1, 28.8288, 0, ''), + (25208, 2, 4039.11, 6370.05, 27.8701, 0, ''), + (25208, 3, 4052.24, 6364.92, 27.2941, 0, ''), + (25208, 4, 4058.31, 6357.79, 26.3543, 0, ''), + (25208, 5, 4062.46, 6346.26, 24.3838, 0, ''), + (25208, 6, 4063.82, 6334.14, 25.3818, 0, ''), + (25208, 7, 4062.66, 6319.39, 24.9775, 0, ''), + (25208, 8, 4061.14, 6307.67, 24.4034, 0, ''), + (25208, 9, 4059.64, 6301.33, 24.5615, 0, ''), + (25208, 10, 4066.46, 6292.12, 24.3167, 0, ''), + (25208, 11, 4078.37, 6280.88, 26.6926, 0, ''), + (25208, 12, 4087.03, 6281.33, 27.4604, 0, ''), + (25208, 13, 4097.8, 6282.47, 25.4414, 0, ''), + (25208, 14, 4107.07, 6279.26, 25.2578, 0, ''), + (25208, 15, 4114.68, 6279.78, 24.7762, 0, ''), + (25208, 16, 4122.9, 6280.34, 26.1671, 0, ''), + (25208, 17, 4127.69, 6280.67, 28.1951, 0, ''), + (25208, 18, 4134.75, 6282.09, 28.9761, 0, ''), + (25208, 19, 4141.62, 6281.92, 29.3518, 0, ''), + (25208, 20, 4152.14, 6281.43, 30.6951, 0, ''), + (25208, 21, 4159.63, 6282.6, 30.2401, 0, ''), + (25208, 22, 4169.82, 6289.25, 24.182, 0, ''), + (25208, 23, 4181.02, 6293.88, 18.035, 0, ''), + (25208, 24, 4189.27, 6295.87, 14.4513, 0, ''), + (25208, 25, 4200.09, 6298.4, 12.7249, 0, ''), + (25208, 26, 4206.46, 6291.56, 10.9628, 0, ''), + (25208, 27, 4211.45, 6282.82, 9.05693, 0, ''), + (25208, 28, 4215.22, 6277.25, 8.54002, 0, ''), + (25208, 29, 4215.28, 6268.57, 8.30674, 0, ''), + (25208, 30, 4224.23, 6269.53, 6.97205, 0, ''), + (25208, 31, 4235.98, 6270.9, 3.27214, 0, ''), + (25208, 32, 4242.67, 6269.45, 1.45579, 0, ''), + (25208, 33, 4250.43, 6262.49, 0.611961, 0, ''), + (25208, 34, 4259.07, 6253.33, -0.0686721, 0, ''), + (25208, 35, 4261.11, 6248.81, -0.112029, 0, ''), + (25208, 36, 4257.58, 6234.09, -0.094803, 0, ''), + (25208, 37, 4252.62, 6224.3, -0.154816, 0, ''), + (25208, 38, 4247.92, 6214.75, -0.221144, 0, ''), + (25208, 39, 4254.04, 6205.58, -0.186623, 0, ''), + (25208, 40, 4262.6, 6194.47, -0.145114, 0, ''), + (25208, 41, 4268.96, 6189.47, 0.0303093, 21000, ''); |
