NPC Vendore Haris Pilton http://www.wowhead.com/?npc=18756

[cut]DELETE FROM `npc_vendor` WHERE `entry` = 18756;
INSERT INTO `npc_vendor` (`entry`,`item`,`maxcount`,`incrtime`,`extendedcost`) VALUES
(18756, 38082, 0, 0, 0),
(18756, 51809, 0, 0, 0),
(18756, 38091, 1, 3600, 0),
(18756, 37934, 1, 3600, 0),
(18756, 38090, 2, 3600, 0);[/cut]

Honor Hold

Grunda Bronzewing (35101) mount (http://www.wowhead.com/?npc=35101)

[cut]INSERT INTO `creature_addon` ( `guid` , `mount` , `bytes1` , `bytes2` , `emote` , `moveflags` , `auras` ) VALUES ('131372', '17697', '0', '0', '0', '0', '') ;[/cut]

War Horse [Stable] (16884) replaced by Ebon Gryphon and Snowy Gryphon

[cut]DELETE FROM `creature` WHERE `guid` = 59225 ;
DELETE FROM `creature` WHERE `guid` = 56900 ;
UPDATE `creature_template` SET `minlevel` = 60, `maxlevel` = 60, `minhealth` = 4979, `maxhealth` = 4979 WHERE `entry` = 18359 ;
UPDATE `creature_template` SET `minlevel` = 60, `maxlevel` = 60, `minhealth` = 4979, `maxhealth` = 4979 WHERE `entry` = 18357 ;
INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`sp awndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`) VALUES
(59225, 18359, 530, 1, 1, 0, 0, -669.985, 2739.88, 94.03, 4.604430, 480, 0, 0, 4979, 0, 0, 0),
(56900, 18357, 530, 1, 1, 0, 0, -679.36, 2741.085, 93.91, 4.645923, 480, 0, 0, 4979, 0, 0, 0);[/cut]

Logistics Officer Ulrike(17657)

[cut]UPDATE `creature` SET `position_x` = -675.431, `position_y` = 2610.523, `position_z` = 86.51, `orientation` = 6.208084 WHERE `guid` = 74343 ;[/cut]

Honor Hold Defender (20513)

[cut]DELETE FROM `creature` WHERE `guid` = 92018 ;[/cut]

-- Легионер из Крепости Завоевателей

[cut]DELETE FROM `creature_template_addon` WHERE (`entry`=26839);

INSERT INTO `creature_addon` (`guid`, `mount`, `bytes1`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES
(108632, 0, 8, 257, 0, 0, NULL),
(108633, 0, 8, 257, 0, 0, NULL),
(108638, 0, 8, 257, 0, 0, NULL),
(108639, 0, 8, 257, 0, 0, NULL),
(108640, 0, 8, 257, 0, 0, NULL);[/cut]

-- Капитан Костяная Челюсть

[cut]INSERT INTO `creature_addon` (`guid`, `mount`, `bytes1`, `bytes2`, `emote`, `moveflags`, `auras`) VALUES
(108234, 0, 8, 257, 0, 0, NULL);[/cut]

-- Горгонна

[cut]UPDATE `creature` SET `position_x` = 3270.81, `position_y` = -2197.35, `position_z` = 117.373, `orientation` = 4.31224 WHERE `guid` = 119653;[/cut]

-- Комендант казарм Рекку

[cut]UPDATE `creature` SET `position_x` = 3256.03, `position_y` = -2202.69, `position_z` = 117.029, `orientation` = 5.82256 WHERE `guid` = 32335;[/cut]

-- Сержант Назгрим

[cut]UPDATE `creature` SET `position_x` = 3275.15, `position_y` = -2212.84, `position_z` = 117.029, `orientation` = 2.49275 WHERE `guid` = 119557;[/cut]

-- Торговец шкурами Джун'ик

[cut]UPDATE `creature` SET `position_x` = 3237.54, `position_y` = -2267.85, `position_z` = 115.785, `orientation` = 1.44243 WHERE `guid` = 119550;
[/cut]
-- Сержант Туркин

[cut]UPDATE `creature` SET `spawndist` = 0, `MovementType` = 0 WHERE `guid` = 87322;
[/cut]
-- Гренникс Ножеверт

[cut]UPDATE `creature` SET `position_x` = 3281.23, `position_y` = -2288.77, `position_z` = 108.508, `orientation` = 1.27409 WHERE `guid` = 119656;[/cut]

-- Букмекер Вел'джен

[cut]UPDATE `creature` SET `position_x` = 3271.18, `position_y` = -2283.29, `position_z` = 108.506, `orientation` = 0.837758 WHERE `guid` = 119657;[/cut]

Valeera Sanguinar (29607) [old npc]

[cut]DELETE FROM `creature` WHERE `guid` = 95174 ;[/cut]

Broll Bearmantle (29604) [old npc]

[cut]DELETE FROM `creature` WHERE `guid` = 95173 ;[/cut]

Varian Wrynn (11699) [old npc]

[cut]DELETE FROM `creature` WHERE `guid` = 98392 ;[/cut]

Scourge Commander Thalanor (28510) ------> mount

[cut]INSERT INTO `creature_addon` ( `guid` , `mount` , `bytes1` , `bytes2` , `emote` , `moveflags` , `auras` ) VALUES ('96140', '26308', '0', '0', '0', '0', '') ;[/cut]

-- Главный канонир Зирхат

[cut]UPDATE `creature` SET `MovementType` = 2 WHERE `guid` = 112694;

INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) VALUES
(112694, 1, 2664.8, -509.573, 49.597, 15000, 0, 0, 0, 0, 0, 0, 0, 0, 4.23313, 0, 0),
(112694, 2, 2669.85, -499.259, 52.1344, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.942307, 0, 0),
(112694, 3, 2675.89, -486.133, 50.8372, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1.17623, 0, 0),
(112694, 4, 2667.37, -475.058, 50.0349, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2.14934, 0, 0),
(112694, 5, 2659.48, -460.279, 50.1145, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2.16505, 0, 0),
(112694, 6, 2654.01, -463.189, 50.8594, 15000, 0, 0, 0, 0, 0, 0, 0, 0, 3.57484, 0, 0),
(112694, 7, 2659.03, -460.456, 50.1516, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.19513, 0, 0),
(112694, 8, 2667.13, -475.143, 50.0582, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.19905, 0, 0),
(112694, 9, 2675.43, -486.378, 50.8567, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4.50005, 0, 0),
(112694, 10, 2669.39, -499.464, 52.049, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4.26051, 0, 0);
[/cut]

-- Жрец-ворон Алого Натиска

[cut]INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
(151034, 27202, 571, 1, 1, 24399, 0, 2614.15, -430.152, 36.5684, 2.44304, 600, 0, 0, 7432, 7332, 0, 2);

INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) VALUES
(151034, 1, 2614.17, -430.055, 36.6038, 12000, 0, 0, 0, 0, 0, 0, 0, 0, 2.4022, 0, 0),
(151034, 2, 2619.95, -434.959, 38.2038, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.83204, 0, 0),
(151034, 3, 2632.35, -437.134, 44.239, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6.17369, 0, 0),
(151034, 4, 2645.82, -438.149, 50.6503, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6.12263, 0, 0),
(151034, 5, 2672.87, -461.795, 50.3602, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.57286, 0, 0),
(151034, 6, 2677.07, -462.584, 50.7403, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6.0166, 0, 0),
(151034, 7, 2677.76, -464.574, 50.8034, 12000, 0, 0, 0, 0, 0, 0, 0, 0, 4.97988, 0, 0),
(151034, 8, 2676.67, -462.322, 50.7094, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2.43283, 0, 0),
(151034, 9, 2672.41, -461.585, 50.3146, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2.60169, 0, 0),
(151034, 10, 2645.6, -437.792, 50.5613, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2.65745, 0, 0),
(151034, 11, 2631.99, -437.154, 44.0534, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3.12005, 0, 0),
(151034, 12, 2619.26, -434.75, 37.9252, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2.72627, 0, 0);

-- Матрос Алого Натиска

DELETE FROM `creature_template_addon` WHERE (`entry`=27233);

-- Рыцарь Алого Натиска

UPDATE `creature` SET `MovementType` = 2 WHERE `guid` = 112825;

INSERT INTO `creature_movement` (`id`, `point`, `position_x`, `position_y`, `position_z`, `waittime`, `textid1`, `textid2`, `textid3`, `textid4`, `textid5`, `emote`, `spell`, `wpguid`, `orientation`, `model1`, `model2`) VALUES
(112825, 1, 2719.76, -522.16, 91.515, 14000, 0, 0, 0, 0, 0, 0, 0, 0, 4.32361, 0, 0),
(112825, 2, 2724.91, -513.673, 94.5902, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.985669, 0, 0),
(112825, 3, 2726.8, -494.186, 94.494, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2.19518, 0, 0),
(112825, 4, 2711.5, -470.517, 86.3185, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2.16377, 0, 0),
(112825, 5, 2700.96, -448.767, 78.8676, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2.01454, 0, 0),
(112825, 6, 2694.27, -434.556, 73.4892, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1.95564, 0, 0),
(112825, 7, 2686.82, -431.794, 71.0322, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2.83921, 0, 0),
(112825, 8, 2650.05, -431.806, 53.2232, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3.26176, 0, 0),
(112825, 9, 2640.44, -441.648, 48.4192, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 3.99725, 0, 0),
(112825, 10, 2650.21, -431.995, 53.2436, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3.21893, 0, 0),
(112825, 11, 2687.31, -431.749, 71.2584, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.59476, 0, 0),
(112825, 12, 2694.58, -434.835, 73.6362, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.20599, 0, 0),
(112825, 13, 2701.56, -449.077, 79.1171, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.0489, 0, 0),
(112825, 14, 2711.83, -470.454, 86.4105, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5.2099, 0, 0),
(112825, 15, 2727.22, -494.605, 94.7299, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4.8447, 0, 0),
(112825, 16, 2725.11, -513.904, 94.7033, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4.15748, 0, 0);[/cut]

-- Палач Алого Натиска

[cut]DELETE FROM `creature` WHERE (`guid`=120752);[/cut]