REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (500680, 0, 0, 0, 0, 0, 28213, 0, 28213, 0, 'Arena SET 6', '', '', 8217, 80, 80, 2, 118, 118, 129, 1, 1.14286, 1, 3, 2500, 4000, 0, 7000, 27.4, 1000, 1000, 2, 36864, 8, 0, 0, 0, 0, 0, 114, 172, 43, 7, 76, 0, 0, 0, 0, 150, 150, 150, 150, 150, 59710, 59713, 20672, 59711, 0, 0, 0, 0, 0, 0, 1003, 12300, '', 0, 3, 100, 15, 1, 1, 0, 0, 0, 0, 0, 0, 0, 1, 1290, 617299803, 2, 'npc_lady_sylvanas_windrunner', 1);

DELETE FROM `npc_vendor` WHERE (`entry`=500680);
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES
(500680, 0, 40787, 0, 0, 0),
(500680, 0, 40788, 0, 0, 0),
(500680, 0, 40789, 0, 0, 0),
(500680, 0, 40807, 0, 0, 0),
(500680, 0, 40808, 0, 0, 0),
(500680, 0, 40809, 0, 0, 0),
(500680, 0, 40826, 0, 0, 0),
(500680, 0, 40827, 0, 0, 0),
(500680, 0, 40828, 0, 0, 0),
(500680, 0, 40847, 0, 0, 0),
(500680, 0, 40848, 0, 0, 0),
(500680, 0, 40849, 0, 0, 0),
(500680, 0, 40866, 0, 0, 0),
(500680, 0, 40868, 0, 0, 0),
(500680, 0, 40869, 0, 0, 0),
(500680, 0, 40907, 0, 0, 0),
(500680, 0, 40927, 0, 0, 0),
(500680, 0, 40933, 0, 0, 0),
(500680, 0, 40939, 0, 0, 0),
(500680, 0, 40963, 0, 0, 0),
(500680, 0, 40992, 0, 0, 0),
(500680, 0, 40993, 0, 0, 0),
(500680, 0, 41001, 0, 0, 0),
(500680, 0, 41007, 0, 0, 0),
(500680, 0, 41013, 0, 0, 0),
(500680, 0, 41019, 0, 0, 0),
(500680, 0, 41027, 0, 0, 0),
(500680, 0, 41033, 0, 0, 0),
(500680, 0, 41038, 0, 0, 0),
(500680, 0, 41044, 0, 0, 0),
(500680, 0, 41081, 0, 0, 0),
(500680, 0, 41087, 0, 0, 0),
(500680, 0, 41137, 0, 0, 0),
(500680, 0, 41143, 0, 0, 0),
(500680, 0, 41151, 0, 0, 0),
(500680, 0, 41157, 0, 0, 0),
(500680, 0, 41199, 0, 0, 0),
(500680, 0, 41205, 0, 0, 0),
(500680, 0, 41211, 0, 0, 0),
(500680, 0, 41217, 0, 0, 0),
(500680, 0, 41275, 0, 0, 0),
(500680, 0, 41281, 0, 0, 0),
(500680, 0, 41287, 0, 0, 0),
(500680, 0, 41293, 0, 0, 0),
(500680, 0, 41298, 0, 0, 0),
(500680, 0, 41304, 0, 0, 0),
(500680, 0, 41310, 0, 0, 0),
(500680, 0, 41316, 0, 0, 0),
(500680, 0, 41321, 0, 0, 0),
(500680, 0, 41327, 0, 0, 0),
(500680, 0, 41650, 0, 0, 0),
(500680, 0, 41655, 0, 0, 0),
(500680, 0, 41661, 0, 0, 0),
(500680, 0, 41667, 0, 0, 0),
(500680, 0, 41672, 0, 0, 0),
(500680, 0, 41678, 0, 0, 0),
(500680, 0, 41683, 0, 0, 0),
(500680, 0, 41715, 0, 0, 0),
(500680, 0, 41767, 0, 0, 0),
(500680, 0, 41773, 0, 0, 0),
(500680, 0, 41854, 0, 0, 0),
(500680, 0, 41859, 0, 0, 0),
(500680, 0, 41864, 0, 0, 0),
(500680, 0, 41869, 0, 0, 0),
(500680, 0, 41874, 0, 0, 0),
(500680, 0, 41915, 0, 0, 0),
(500680, 0, 41921, 0, 0, 0),
(500680, 0, 41927, 0, 0, 0),
(500680, 0, 41934, 0, 0, 0),
(500680, 0, 41940, 0, 0, 0),
(500680, 0, 41946, 0, 0, 0),
(500680, 0, 41953, 0, 0, 0),
(500680, 0, 41959, 0, 0, 0),
(500680, 0, 41965, 0, 0, 0),
(500680, 0, 41971, 0, 0, 0),
(500680, 0, 41993, 0, 0, 0),
(500680, 0, 41998, 0, 0, 0),
(500680, 0, 42011, 0, 0, 0),
(500680, 0, 42017, 0, 0, 0);

REPLACE INTO `creature_template` (`entry`, `heroic_entry`, `KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (1112221, 0, 0, 0, 26939, 0, 24361, 0, 'А7 vendor', 'A7', '', 81, 81, 10000, 10000, 10000, 10000, 10029, 35, 35, 4224, 1.15, 1, 1, 327, 491, 0, 123, 2, 1500, 1500, 0, 0, 0, 0, 0, 0, 0, 0, 262, 393, 98, 7, 138936390, 0, 0, 0, 999, 999, 999, 999, 999, 999, 0, 0, 0, 0, 0, 1500, 1700, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, '');

DELETE FROM `npc_vendor` WHERE (`entry`=1112221);
INSERT INTO `npc_vendor` (entry, item, maxcount, incrtime, ExtendedCost) VALUES
(1112221, 40790, 0, 0, 0),
(1112221, 40810, 0, 0, 0),
(1112221, 40829, 0, 0, 0),
(1112221, 40850, 0, 0, 0),
(1112221, 40870, 0, 0, 0),
(1112221, 41276, 0, 0, 0),
(1112221, 41288, 0, 0, 0),
(1112221, 41299, 0, 0, 0),
(1112221, 41311, 0, 0, 0),
(1112221, 41322, 0, 0, 0),
(1112221, 41662, 0, 0, 0),
(1112221, 41668, 0, 0, 0),
(1112221, 41679, 0, 0, 0),
(1112221, 41716, 0, 0, 0),
(1112221, 41774, 0, 0, 0),
(1112221, 41282, 0, 0, 0),
(1112221, 41294, 0, 0, 0),
(1112221, 41305, 0, 0, 0),
(1112221, 41317, 0, 0, 0),
(1112221, 41328, 0, 0, 0),
(1112221, 41855, 0, 0, 0),
(1112221, 41860, 0, 0, 0),
(1112221, 41865, 0, 0, 0),
(1112221, 41870, 0, 0, 0),
(1112221, 41875, 0, 0, 0),
(1112221, 41916, 0, 0, 0),
(1112221, 41922, 0, 0, 0),
(1112221, 41928, 0, 0, 0),
(1112221, 41935, 0, 0, 0),
(1112221, 41941, 0, 0, 0),
(1112221, 41947, 0, 0, 0),
(1112221, 41954, 0, 0, 0),
(1112221, 41960, 0, 0, 0),
(1112221, 41966, 0, 0, 0),
(1112221, 41972, 0, 0, 0),
(1112221, 41088, 0, 0, 0),
(1112221, 41144, 0, 0, 0),
(1112221, 41158, 0, 0, 0),
(1112221, 41206, 0, 0, 0),
(1112221, 41218, 0, 0, 0),
(1112221, 40910, 0, 0, 0),
(1112221, 40928, 0, 0, 0),
(1112221, 40934, 0, 0, 0),
(1112221, 40940, 0, 0, 0),
(1112221, 40964, 0, 0, 0),
(1112221, 40792, 0, 0, 0),
(1112221, 40812, 0, 0, 0),
(1112221, 40831, 0, 0, 0),
(1112221, 40852, 0, 0, 0),
(1112221, 40872, 0, 0, 0),
(1112221, 41651, 0, 0, 0),
(1112221, 41656, 0, 0, 0),
(1112221, 41673, 0, 0, 0),
(1112221, 41684, 0, 0, 0),
(1112221, 41768, 0, 0, 0),
(1112221, 40791, 0, 0, 0),
(1112221, 40811, 0, 0, 0),
(1112221, 40830, 0, 0, 0),
(1112221, 40851, 0, 0, 0),
(1112221, 40871, 0, 0, 0),
(1112221, 41994, 0, 0, 0),
(1112221, 41999, 0, 0, 0),
(1112221, 42006, 0, 0, 0),
(1112221, 42012, 0, 0, 0),
(1112221, 42018, 0, 0, 0),
(1112221, 41082, 0, 0, 0),
(1112221, 41138, 0, 0, 0),
(1112221, 41152, 0, 0, 0),
(1112221, 41200, 0, 0, 0),
(1112221, 41212, 0, 0, 0),
(1112221, 40995, 0, 0, 0),
(1112221, 41008, 0, 0, 0),
(1112221, 41020, 0, 0, 0),
(1112221, 41034, 0, 0, 0),
(1112221, 41045, 0, 0, 0),
(1112221, 40994, 0, 0, 0),
(1112221, 41002, 0, 0, 0),
(1112221, 41014, 0, 0, 0),
(1112221, 41028, 0, 0, 0),
(1112221, 41039, 0, 0, 0);