diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/FULL/world_script_waypoints.sql | 29 | ||||
| -rw-r--r-- | sql/FULL/world_scripts_full.sql | 3 | ||||
| -rw-r--r-- | sql/updates/5270_world_scripts.sql | 30 |
3 files changed, 62 insertions, 0 deletions
diff --git a/sql/FULL/world_script_waypoints.sql b/sql/FULL/world_script_waypoints.sql index 046efe26c91..3ba9b421059 100644 --- a/sql/FULL/world_script_waypoints.sql +++ b/sql/FULL/world_script_waypoints.sql @@ -13,6 +13,35 @@ CREATE TABLE script_waypoint ( PRIMARY KEY (entry, pointid) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Creature waypoints'; +DELETE FROM script_waypoint entry = 24156; +INSERT INTO script_waypoint VALUES +(24156,1,1859.74, -6178.15, 24.3033, 0, ''), +(24156,2,1866.06, -6172.81, 23.9216, 0, ''), +(24156,3,1876.43, -6167.42, 23.7332, 0, ''), +(24156,4,1903.37, -6167.9, 23.312, 0, ''), +(24156,5,1934.43, -6168.46, 23.7148, 0, ''), +(24156,6,1942.38, -6168.21, 23.7133, 0, ''), +(24156,7,1953.48, -6172.4, 24.2785, 0, ''), +(24156,8,1969.21, -6179.69, 23.8501, 0, ''), +(24156,9,1992.18, -6177.24, 21.3992, 0, ''), +(24156,10,2015.73, -6174.73, 15.3766, 0, ''), +(24156,11,2016.99, -6156.39, 12.5927, 0, ''), +(24156,12,2018.14, -6130.62, 6.31995, 0, ''), +(24156,13,2043.73, -6119.18, 5.17474, 0, ''), +(24156,14,2080.99, -6100.03, 7.72235, 0, ''), +(24156,15,2115.47, -6096.21, 5.36958, 0, ''), +(24156,16,2130.36, -6151.59, 1.24893, 0, ''), +(24156,17,2160.5, -6098.78, 3.14191, 0, ''), +(24156,18,2161.26, -6101.38, 2.81571, 0, ''), +(24156,19,2172.54, -6108.54, 2.26422, 0, ''), +(24156,20,2206.69, -6110.46, 0.787735, 0, ''), +(24156,21,2228.23, -6090.02, 1.17018, 0, ''), +(24156,22,2262.76, -6056.79, 1.82852, 0, ''), +(24156,23,2285.54, -6046.96, 1.6305, 0, ''), +(24156,24,2298.05, -6041.56, 2.01465, 0, ''), +(24156,25,2307.53, -6031.23, 2.93796, 0, ''), +(24156,26,2309.46, -6024.45, 3.65369, 5000, ''); + DELETE FROM script_waypoint WHERE entry = 20415; INSERT INTO script_waypoint VALUES (20415 ,0, 2488.77, 2184.89, 104.64, 0, ''), diff --git a/sql/FULL/world_scripts_full.sql b/sql/FULL/world_scripts_full.sql index 9c4392265c1..8a4976fceda 100644 --- a/sql/FULL/world_scripts_full.sql +++ b/sql/FULL/world_scripts_full.sql @@ -568,6 +568,9 @@ UPDATE `creature_template` SET `ScriptName`='npc_trollbane' WHERE `entry`=16819; UPDATE `creature_template` SET `ScriptName`='npc_00x09hl' WHERE `entry`=7806; UPDATE `creature_template` SET `ScriptName`='npc_rinji' WHERE `entry`=7780; +/* Howling Fjord */ +UPDATE `creature_template` SET `ScriptName` = 'npc_plaguehound_tracker' WHERE `entry` = 24156; + /* ICECROWN */ UPDATE creature_template SET ScriptName='npc_arete' WHERE entry=29344; diff --git a/sql/updates/5270_world_scripts.sql b/sql/updates/5270_world_scripts.sql new file mode 100644 index 00000000000..071e823befc --- /dev/null +++ b/sql/updates/5270_world_scripts.sql @@ -0,0 +1,30 @@ +DELETE FROM script_waypoint entry = 24156; +INSERT INTO script_waypoint VALUES +(24156,1,1859.74, -6178.15, 24.3033, 0, ''), +(24156,2,1866.06, -6172.81, 23.9216, 0, ''), +(24156,3,1876.43, -6167.42, 23.7332, 0, ''), +(24156,4,1903.37, -6167.9, 23.312, 0, ''), +(24156,5,1934.43, -6168.46, 23.7148, 0, ''), +(24156,6,1942.38, -6168.21, 23.7133, 0, ''), +(24156,7,1953.48, -6172.4, 24.2785, 0, ''), +(24156,8,1969.21, -6179.69, 23.8501, 0, ''), +(24156,9,1992.18, -6177.24, 21.3992, 0, ''), +(24156,10,2015.73, -6174.73, 15.3766, 0, ''), +(24156,11,2016.99, -6156.39, 12.5927, 0, ''), +(24156,12,2018.14, -6130.62, 6.31995, 0, ''), +(24156,13,2043.73, -6119.18, 5.17474, 0, ''), +(24156,14,2080.99, -6100.03, 7.72235, 0, ''), +(24156,15,2115.47, -6096.21, 5.36958, 0, ''), +(24156,16,2130.36, -6151.59, 1.24893, 0, ''), +(24156,17,2160.5, -6098.78, 3.14191, 0, ''), +(24156,18,2161.26, -6101.38, 2.81571, 0, ''), +(24156,19,2172.54, -6108.54, 2.26422, 0, ''), +(24156,20,2206.69, -6110.46, 0.787735, 0, ''), +(24156,21,2228.23, -6090.02, 1.17018, 0, ''), +(24156,22,2262.76, -6056.79, 1.82852, 0, ''), +(24156,23,2285.54, -6046.96, 1.6305, 0, ''), +(24156,24,2298.05, -6041.56, 2.01465, 0, ''), +(24156,25,2307.53, -6031.23, 2.93796, 0, ''), +(24156,26,2309.46, -6024.45, 3.65369, 5000, ''); + +UPDATE creature_template SET ScriptName = 'npc_plaguehound_tracker' WHERE entry = 24156;
\ No newline at end of file |