PvP System


-- =================
-- PvP System
-- =================

-- =================
-- Test Arena Vendors
-- =================

SET @GUID := 199925;

DELETE FROM `creature` WHERE `guid` BETWEEN 199925 AND 199999;

INSERT INTO `creature` VALUES (@GUID := @GUID + 0, 18898, 13, 1, 0, 0, 19.1657, -65.5787, -144.709, 1.5724, 300, 0, 0, 11000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 19857, 13, 1, 0, 0, 21.2587, -65.5752, -144.709, 1.5724, 300, 0, 0, 11000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 20278, 13, 1, 0, 0, 23.0017, -65.5723, -144.709, 1.5724, 300, 0, 0, 11000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 23396, 13, 1, 0, 0, 25.0177, -65.5689, -144.709, 1.5724, 300, 0, 0, 11000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 24392, 13, 1, 0, 0, 27.0127, -65.5656, -144.709, 1.5724, 300, 0, 0, 11000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 24394, 13, 1, 0, 0, 29.8127, -65.5609, -144.709, 1.5724, 300, 0, 0, 11000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 24395, 13, 1, 0, 0, 32, -65.5609, -144.709, 1.5724, 300, 0, 0, 11000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 24451, 13, 1, 0, 0, 34, -65.5609, -144.709, 1.5724, 300, 0, 0, 11000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 24452, 13, 1, 0, 0, 36, -65.5609, -144.709, 1.5724, 300, 0, 0, 11000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 25176, 13, 1, 0, 0, 38, -65.5609, -144.709, 1.5724, 300, 0, 0, 11000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 25177, 13, 1, 0, 0, 40, -65.5609, -144.709, 1.5724, 300, 0, 0, 11000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 25178, 13, 1, 0, 0, 42, -65.5609, -144.709, 1.5724, 300, 0, 0, 11000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 25179, 13, 1, 0, 0, 44, -65.5609, -144.709, 1.5724, 300, 0, 0, 11000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 26352, 13, 1, 0, 0, 46, -65.5609, -144.709, 1.5724, 300, 0, 0, 11000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 26378, 13, 1, 0, 0, 48, -65.5609, -144.709, 1.5724, 300, 0, 0, 11000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 26383, 13, 1, 0, 0, 50, -65.5609, -144.709, 1.5724, 300, 0, 0, 11000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 26384, 13, 1, 0, 0, 52, -65.5609, -144.709, 1.5724, 300, 0, 0, 11000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 27668, 13, 1, 0, 0, 54, -65.5609, -144.709, 1.5724, 300, 0, 0, 11000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 27721, 13, 1, 0, 0, 56, -65.5609, -144.709, 1.5724, 300, 0, 0, 11000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 27722, 13, 1, 0, 0, 58, -65.5609, -144.709, 1.5724, 300, 0, 0, 11000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 28225, 13, 1, 0, 0, 60, -65.5609, -144.709, 1.5724, 300, 0, 0, 11000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 77771, 13, 1, 0, 0, 62, -65.5609, -144.709, 1.5724, 300, 0, 0, 11000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 77772, 13, 1, 0, 0, 64, -65.5609, -144.709, 1.5724, 300, 0, 0, 11000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 77773, 13, 1, 0, 0, 66, -65.5609, -144.709, 1.5724, 300, 0, 0, 11000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 77774, 13, 1, 0, 0, 68, -65.5609, -144.709, 1.5724, 300, 0, 0, 11000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 77775, 13, 1, 0, 0, 70, -65.5609, -144.709, 1.5724, 300, 0, 0, 11000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 77776, 13, 1, 0, 0, 72, -65.5609, -144.709, 1.5724, 300, 0, 0, 11000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 77777, 13, 1, 0, 0, 74, -65.5609, -144.709, 1.5724, 300, 0, 0, 11000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 77778, 13, 1, 0, 0, 76, -65.5609, -144.709, 1.5724, 300, 0, 0, 11000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 1200050, 13, 1, 0, 0, 78, -65.5609, -144.709, 1.5724, 300, 0, 0, 11000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 1200057, 13, 1, 0, 0, 80, -65.5609, -144.709, 1.5724, 300, 0, 0, 11000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 1200061, 13, 1, 0, 0, 82, -65.5609, -144.709, 1.5724, 300, 0, 0, 11000, 0, 0, 0);

-- =================
-- Test Honor Vendors
-- =================

INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 12777, 13, 1, 0, 0, 32, -68.8927, -144.709, 1.5724, 300, 0, 0, 5700, 0, 0, 0);
-- INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 12785, 13, 1, 0, 0, 34, -68.8927, -144.709, 1.5724, 300, 0, 0, 5700, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 12792, 13, 1, 0, 0, 36, -68.8927, -144.709, 1.5724, 300, 0, 0, 5700, 0, 0, 0);
-- INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 12795, 13, 1, 0, 0, 38, -68.8927, -144.709, 1.5724, 300, 0, 0, 5700, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 23446, 13, 1, 0, 0, 40, -68.8927, -144.709, 1.5724, 300, 0, 0, 5700, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 23447, 13, 1, 0, 0, 42, -68.8927, -144.709, 1.5724, 300, 0, 0, 5700, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 24520, 13, 1, 0, 0, 44, -68.8927, -144.709, 1.5724, 300, 0, 0, 5700, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 24668, 13, 1, 0, 0, 46, -68.8927, -144.709, 1.5724, 300, 0, 0, 5700, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 24670, 13, 1, 0, 0, 48, -68.8927, -144.709, 1.5724, 300, 0, 0, 5700, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 24672, 13, 1, 0, 0, 50, -68.8927, -144.709, 1.5724, 300, 0, 0, 5700, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 26393, 13, 1, 0, 0, 52, -68.8927, -144.709, 1.5724, 300, 0, 0, 5700, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 26395, 13, 1, 0, 0, 54, -68.8927, -144.709, 1.5724, 300, 0, 0, 5700, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 26397, 13, 1, 0, 0, 56, -68.8927, -144.709, 1.5724, 300, 0, 0, 5700, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 26398, 13, 1, 0, 0, 58, -68.8927, -144.709, 1.5724, 300, 0, 0, 5700, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 77710, 13, 1, 0, 0, 60, -68.8927, -144.709, 1.5724, 300, 0, 0, 5700, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 77779, 13, 1, 0, 0, 62, -68.8927, -144.709, 1.5724, 300, 0, 0, 5700, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 1200051, 13, 1, 0, 0, 64, -68.8927, -144.709, 1.5724, 300, 0, 0, 5700, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 1200052, 13, 1, 0, 0, 66, -68.8927, -144.709, 1.5724, 300, 0, 0, 5700, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 1200053, 13, 1, 0, 0, 68, -68.8927, -144.709, 1.5724, 300, 0, 0, 5700, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 1200054, 13, 1, 0, 0, 70, -68.8927, -144.709, 1.5724, 300, 0, 0, 5700, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 1200055, 13, 1, 0, 0, 72, -68.8927, -144.709, 1.5724, 300, 0, 0, 5700, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 1200056, 13, 1, 0, 0, 74, -68.8927, -144.709, 1.5724, 300, 0, 0, 5700, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 1200059, 13, 1, 0, 0, 76, -68.8927, -144.709, 1.5724, 300, 0, 0, 5700, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 1200060, 13, 1, 0, 0, 78, -68.8927, -144.709, 1.5724, 300, 0, 0, 5700, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 26304, 13, 1, 0, 0, 80, -68.8927, -144.709, 1.5724, 300, 0, 0, 5700, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID := @GUID + 1, 26305, 13, 1, 0, 0, 82, -68.8927, -144.709, 1.5724, 300, 0, 0, 5700, 0, 0, 0);

-- ATTENTION 20278 costum atm

-- Honor Set Vendor
-- S1 1200057 1200050- reduced
-- S2 1200061 77778- reduced
-- S3 77777 77773- reduced 
-- S4 26352
-- Offparts Vendors
-- S1 1200056 & 1200051
-- S2 1200059 & 1200060
-- S3 77710 & 77779 
-- S4 24520 & 23446

-- epic gems equivalent BuyPrice
-- UPDATE `item_template` SET `BuyPrice` = 200000 WHERE `entry` IN (32227,32228,32229,32230,32231,32249); -- 0

-- Scotty 1200007
UPDATE `creature_template` SET `modelid_A`=21290, `modelid_H`=21290, `subname`='Alterac Valley Mark Trader', `armor`=6800, `unit_flags`=512, `rank`=1 WHERE `entry` = 1200007;
UPDATE `creature_model_info` SET `modelid_other_gender`=0 WHERE `modelid`=21290; -- 21289
UPDATE `quest_template` SET `Name`='Small Mark Trade', `Details`='Deal or no Deal?', `Objectives`='1 of each Honor Mark for 2 Alterac Valley Honor Marks', `OfferRewardText`='You are welcome!', `RequestItemsText`='You need 1 of each Marks to trade.', `ReqItemId2`=20559, `ReqItemId3`=29024, `ReqItemCount1`=1 , `ReqItemCount2`=1, `ReqItemCount3`=1, `RewChoiceItemId2`=0, `RewChoiceItemId3`=0, `RewChoiceItemCount1`=2, `RewChoiceItemCount2`=0, `RewChoiceItemCount3`=0 WHERE `entry` = 100017;
UPDATE `quest_template` SET `Name`='Medium Mark Trade', `Details`='Deal or no Deal?', `Objectives`='5 of each Honor Mark for 10 Alterac Valley Honor Marks', `OfferRewardText`='You are welcome!', `RequestItemsText`='You need 5 of each Marks to trade.', `ReqItemId2`=20559, `ReqItemId3`=29024, `ReqItemCount1`=5, `ReqItemCount2`=5, `ReqItemCount3`=5, `RewChoiceItemId2`=0, `RewChoiceItemId3`=0, `RewChoiceItemCount1`=10, `RewChoiceItemCount2`=0, `RewChoiceItemCount3`=0 WHERE `entry` = 100018;
UPDATE `quest_template` SET `Name`='Big Mark Trade', `Details`='Deal or no Deal?', `Objectives`='10 of each Honor Mark for 20 Alterac Valley Honor Marks', `OfferRewardText`='You are welcome!', `RequestItemsText`='You need 10 of each Marks to trade.', `ReqItemId2`=20559, `ReqItemId3`=29024, `ReqItemCount1`=10, `ReqItemCount2`=10, `ReqItemCount3`=10, `RewChoiceItemId2`=0, `RewChoiceItemId3`=0, `RewChoiceItemCount1`=20, `RewChoiceItemCount2`=0, `RewChoiceItemCount3`=0 WHERE `entry` = 100019;

-- Rechecking

-- 26304 and 26305 really broken cant be used atm.

DELETE FROM `creature_template` WHERE `entry` IN (18898,19857,20278,23396,24392,24394,24395,24451,24452,25176,25177,25178,25179,26352,26378,26383,26384,27668,27721,27722,28225,77771,77772,77773,77774,77775,77776,77777,77778,1200050,1200057,1200061);
INSERT INTO `creature_template` VALUES (18898, 0, NULL, 18293, 0, 18293, 0, 'Explodyne Fizzlespurt', 'Arena Vendor', NULL, 70, 70, 7900, 7900, 0, 0, 6800, 1, 35, 35, 129, 1.125, 1, 0, 60, 101, 0, 1695, 2000, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, '', 0, 3, 0, 1, 0, 0, 2, '');
INSERT INTO `creature_template` VALUES (19857, 0, NULL, 19225, 0, 19225, 0, 'Meminnie', 'Arena Vendor', NULL, 70, 70, 7800, 7800, 0, 0, 6800, 1, 35, 35, 129, 1.125, 1, 0, 202, 350, 0, 5796, 2000, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, '', 1, 3, 0, 1, 0, 0, 2, '');
INSERT INTO `creature_template` VALUES (20278, 0, NULL, 18290, 0, 18290, 0, 'Vixton Pinchwhistle', 'Arena Vendor', NULL, 70, 70, 6300, 6300, 0, 0, 6800, 1, 35, 35, 129, 1.125, 0.85, 0, 202, 350, 0, 5796, 2000, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, '', 1, 3, 0, 1, 0, 0, 2, '');
INSERT INTO `creature_template` VALUES (23396, 0, NULL, 21462, 0, 21462, 0, 'Krixel Pinchwhistle', 'Arena Vendor', NULL, 70, 70, 11000, 11000, 0, 0, 6800, 1, 35, 35, 129, 1.1, 1, 0, 300, 350, 0, 0, 2000, 0, 514, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, '', 0, 3, 0, 1, 0, 0, 2, '');
INSERT INTO `creature_template` VALUES (24392, 0, NULL, 22393, 0, 22393, 0, 'Leeni "Smiley" Smalls', 'Arena Vendor', NULL, 70, 70, 11000, 11000, 0, 0, 6800, 1, 35, 35, 128, 1.5, 1, 0, 220, 350, 0, 10500, 2000, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, '', 0, 3, 0, 1, 0, 0, 2, '');
INSERT INTO `creature_template` VALUES (24394, 0, NULL, 22398, 0, 22398, 0, 'Dellix Pinchwhistle', 'Arena Vendor', NULL, 70, 70, 11000, 11000, 0, 0, 6800, 1, 35, 35, 128, 1, 1, 0, 0, 0, 0, 0, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, '', 0, 3, 0, 1, 0, 0, 2, '');
INSERT INTO `creature_template` VALUES (24395, 0, NULL, 22399, 0, 22399, 0, 'Zindik Pinchwhistle', 'Arena Vendor', NULL, 70, 70, 11000, 11000, 0, 0, 6800, 1, 35, 35, 128, 1, 1, 0, 0, 0, 0, 0, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, '', 0, 3, 0, 1, 0, 0, 2, '');
INSERT INTO `creature_template` VALUES (24451, 0, NULL, 22438, 0, 22438, 0, 'Elli Blastnozzle', 'Arena Vendor', NULL, 70, 70, 11000, 11000, 0, 0, 6800, 1, 35, 35, 128, 1, 1, 0, 0, 0, 0, 0, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, '', 0, 3, 0, 1, 0, 0, 2, '');
INSERT INTO `creature_template` VALUES (24452, 0, NULL, 22439, 0, 22439, 0, 'Paree Blastnozzle', 'Arena Vendor', NULL, 70, 70, 11000, 11000, 0, 0, 6800, 1, 35, 35, 128, 1, 1, 0, 0, 0, 0, 0, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, '', 0, 3, 0, 1, 0, 0, 2, '');
INSERT INTO `creature_template` VALUES (25176, 0, NULL, 22398, 0, 22398, 0, 'Grikkin Copperspring', 'Arena Vendor', NULL, 70, 70, 11000, 11000, 0, 0, 6800, 1, 35, 35, 129, 1.1, 1, 0, 220, 450, 0, 7500, 2000, 0, 514, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, '', 0, 3, 0, 1, 0, 0, 2, '');
INSERT INTO `creature_template` VALUES (25177, 0, NULL, 22438, 0, 22438, 0, 'Evee Copperspring', 'Arena Vendor', NULL, 70, 70, 4100, 4100, 0, 0, 6800, 1, 35, 35, 129, 1.1, 1, 0, 0, 0, 0, 0, 2000, 0, 514, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, '', 0, 3, 0, 1, 0, 0, 2, '');
INSERT INTO `creature_template` VALUES (25178, 0, NULL, 22399, 0, 22399, 0, 'Ecton Brasstumbler', 'Arena Vendor', NULL, 70, 70, 11000, 11000, 0, 0, 6800, 1, 35, 35, 128, 1.05, 1, 0, 220, 350, 0, 11400, 2000, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, '', 0, 1, 0, 1, 0, 0, 2, '');
INSERT INTO `creature_template` VALUES (25179, 0, NULL, 22439, 0, 22439, 0, 'Frixee Brasstumbler', 'Arena Vendor', NULL, 70, 70, 8400, 8400, 0, 0, 6800, 1, 35, 35, 129, 1.1, 1, 0, 220, 450, 0, 7500, 2000, 0, 514, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, '', 0, 3, 0, 1, 0, 0, 2, '');
INSERT INTO `creature_template` VALUES (26352, 0, NULL, 23768, 0, 23768, 0, 'Big Zokk Torquewrench', 'Arena Vendor', '', 70, 70, 11000, 11000, 0, 0, 6800, 1, 35, 35, 129, 1.5, 1, 0, 320, 410, 0, 7500, 2000, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, '', 0, 1, 0, 1, 0, 0, 2, '');
INSERT INTO `creature_template` VALUES (26378, 0, NULL, 22438, 0, 22438, 0, 'Evee Copperspring', 'Arena Vendor', '', 70, 70, 11000, 11000, 0, 0, 6800, 1, 35, 35, 128, 1.05, 1, 0, 0, 0, 0, 0, 2000, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, '', 0, 1, 0, 1, 0, 0, 2, '');
INSERT INTO `creature_template` VALUES (26383, 0, NULL, 22398, 0, 22398, 0, 'Grikkin Copperspring', 'Arena Vendor', '', 70, 70, 11000, 11000, 0, 0, 6800, 1, 35, 35, 128, 1, 1, 0, 0, 0, 0, 0, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, '', 0, 1, 0, 1, 0, 0, 2, '');
INSERT INTO `creature_template` VALUES (26384, 0, NULL, 22439, 0, 22439, 0, 'Frixee Brasstumbler', 'Arena Vendor', '', 70, 70, 11000, 11000, 0, 0, 6800, 1, 35, 35, 128, 1, 1, 0, 0, 0, 0, 0, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, '', 0, 1, 0, 1, 0, 0, 2, '');
INSERT INTO `creature_template` VALUES (27668, 0, NULL, 24735, 0, 24735, 0, 'Ontok Shatterhorn', 'Arena Vendor', '', 70, 70, 12000, 12000, 0, 0, 6800, 1, 35, 35, 128, 1, 1, 0, 0, 0, 0, 0, 2000, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, '', 0, 3, 0, 1, 8044, 0, 2, '');
INSERT INTO `creature_template` VALUES (27721, 0, NULL, 24764, 0, 24764, 0, 'Drelik Blastpipe', 'Arena Vendor', '', 70, 70, 11000, 11000, 0, 0, 6800, 1, 35, 35, 129, 1.2, 1, 0, 120, 350, 0, 7500, 2000, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, '', 0, 1, 0, 1, 0, 0, 2, '');
INSERT INTO `creature_template` VALUES (27722, 0, NULL, 24764, 0, 24764, 0, 'Drolig Blastpipe', 'Arena Vendor', '', 70, 70, 11000, 11000, 0, 0, 6800, 1, 35, 35, 129, 1.2, 1, 0, 120, 350, 0, 7500, 2000, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, '', 0, 1, 0, 1, 0, 0, 2, '');
INSERT INTO `creature_template` VALUES (28225, 0, NULL, 25219, 0, 25219, 0, 'Griz Gutshank', 'Arena Vendor', '', 70, 70, 11000, 11000, 0, 0, 6800, 1, 35, 35, 128, 1, 1, 0, 0, 0, 0, 0, 2000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, '', 0, 3, 0, 1, 0, 0, 2, '');
INSERT INTO `creature_template` VALUES (77771, 0, NULL, 22393, 0, 22393, 0, 'Leeni "Kicher" Erbse', 'Arena Vendor', '', 70, 70, 11000, 11000, 0, 0, 6800, 1, 35, 35, 128, 1.5, 1, 0, 220, 350, 0, 10500, 2000, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, '', 0, 3, 0, 1, 0, 0, 2, '');
INSERT INTO `creature_template` VALUES (77772, 0, NULL, 21462, 0, 21462, 0, 'Krixel Quetschpfeiffe', 'Arena Vendor', '', 70, 70, 11000, 11000, 0, 0, 6800, 1, 35, 35, 128, 1.5, 1, 0, 220, 350, 0, 10500, 2000, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, '', 0, 3, 0, 1, 0, 0, 2, '');
INSERT INTO `creature_template` VALUES (77773, 0, NULL, 18293, 0, 18293, 0, 'Explodyne Fizzlespurt', 'Arena Vendor', '', 70, 70, 11000, 11000, 0, 0, 6800, 1, 35, 35, 128, 1.5, 1, 0, 220, 350, 0, 10500, 2000, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, '', 0, 3, 0, 1, 0, 0, 2, '');
INSERT INTO `creature_template` VALUES (77774, 0, NULL, 22398, 0, 22398, 0, 'Grikkin Kupferspule', 'Arena Vendor', '', 70, 70, 11000, 11000, 0, 0, 6800, 1, 35, 35, 128, 1.5, 1, 0, 220, 350, 0, 10500, 2000, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, '', 0, 3, 0, 1, 0, 0, 2, '');
INSERT INTO `creature_template` VALUES (77775, 0, NULL, 19225, 0, 19225, 0, 'Meminnie', 'Arena Vendor', '', 70, 70, 11000, 11000, 0, 0, 6800, 1, 35, 35, 128, 1.5, 1, 0, 220, 350, 0, 10500, 2000, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, '', 0, 3, 0, 1, 0, 0, 2, '');
INSERT INTO `creature_template` VALUES (77776, 0, NULL, 22439, 0, 22439, 0, 'Frixi Messingkipper', 'Arena Vendor', '', 70, 70, 11000, 11000, 0, 0, 6800, 1, 35, 35, 128, 1.5, 1, 0, 220, 350, 0, 10500, 2000, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, '', 0, 3, 0, 1, 0, 0, 2, '');
INSERT INTO `creature_template` VALUES (77777, 0, NULL, 22399, 0, 22399, 0, 'Ecton Messingkipper', 'Arena Vendor', '', 70, 70, 11000, 11000, 0, 0, 6800, 1, 35, 35, 128, 1.5, 1, 0, 220, 350, 0, 10500, 2000, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, '', 0, 3, 0, 1, 0, 0, 2, '');
INSERT INTO `creature_template` VALUES (77778, 0, NULL, 22438, 0, 22438, 0, 'Ivi Kupferspule', 'Arena Vendor', '', 70, 70, 11000, 11000, 0, 0, 6800, 1, 35, 35, 128, 1.5, 1, 0, 220, 350, 0, 10500, 2000, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, '', 0, 3, 0, 1, 0, 0, 2, '');
INSERT INTO `creature_template` VALUES (1200050, 0, NULL, 18290, 0, 18290, 0, 'Vixton Quetschpfeife', 'Arena Vendor', '', 70, 70, 6300, 6300, 0, 0, 6800, 1, 35, 35, 129, 1.125, 0.8, 0, 202, 350, 0, 0, 2000, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, '', 1, 3, 0, 1, 0, 0, 2, '');
INSERT INTO `creature_template` VALUES (1200057, 0, NULL, 22438, 0, 22438, 0, 'Ivi Kupferspule', 'Arena Vendor', '', 70, 70, 6986, 6986, 0, 0, 0, 1, 35, 35, 128, 1.05, 1, 0, 0, 0, 0, 0, 2000, 0, 512, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, '', 0, 1, 0, 1, 0, 0, 2, '');
INSERT INTO `creature_template` VALUES (1200061, 0, NULL, 21462, 0, 21462, 0, 'Krixel Pinchwhistle', 'Arena Vendor', NULL, 70, 70, 11000, 11000, 0, 0, 6800, 1, 35, 35, 129, 1.1, 1, 0, 300, 350, 0, 0, 2000, 0, 514, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, 0, 0, '', 0, 3, 0, 1, 0, 0, 2, '');

-- Honorvendor +++
UPDATE `creature_template` SET `faction_A`=35, `faction_H`= 35, `npcflag`=`npcflag`|128, `unit_flags`=`unit_flags`|2 WHERE `entry` IN (12777,12785,12792,12795,23446,23447,24520,24668,24670,24672,26393,26395,26397,26398,77710,77779,1200051,1200052,1200053,1200054,1200055,1200056,1200059,1200060);

-- S2 Glaive for Shoulder NPC
DELETE FROM `creature_equip_template` WHERE `entry` = 8044;
INSERT INTO `creature_equip_template` VALUES
(8044,41562,0,0,33490434,0,0,529,0,0);

-- Change Season 1 Settings in Live NPC to Less Arena Points without Rating except for Shoulders
UPDATE `npc_vendor` SET `ExtendedCost`='2388' WHERE `ExtendedCost`='1758' AND `entry` = 1200050; -- 1000       -> 800
UPDATE `npc_vendor` SET `ExtendedCost`='22' WHERE `ExtendedCost`='2337' AND `entry` = 1200050;  -- 1875(1600R) -> 1630
UPDATE `npc_vendor` SET `ExtendedCost`='2373' WHERE `ExtendedCost`='2359' AND `entry` = 1200050; -- 1500(2200R) -> 1304(1950R) -- 24 1304
UPDATE `npc_vendor` SET `ExtendedCost`='26' WHERE `ExtendedCost`='2360' AND `entry` = 1200050;   -- 3750(2050R) -> 3261
UPDATE `npc_vendor` SET `ExtendedCost`='148' WHERE `ExtendedCost`='2361' AND `entry` = 1200050; -- 3150(2050R) -> 2739
UPDATE `npc_vendor` SET `ExtendedCost`='133' WHERE `ExtendedCost`='2362' AND `entry` = 1200050; -- 2625(2050R) -> 2283
UPDATE `npc_vendor` SET `ExtendedCost`='21' WHERE `ExtendedCost`='2363' AND `entry` = 1200050; -- 1125(2050R) -> 978
UPDATE `npc_vendor` SET `ExtendedCost`='21' WHERE `ExtendedCost`='2283' AND `entry` = 1200050 AND `item` IN (28346,32452);   -- 1125       -> 978
UPDATE `npc_vendor` SET `ExtendedCost`='22' WHERE `ExtendedCost`='2364' AND `entry` = 1200050; -- 1875(2050R) -> 1630
UPDATE `npc_vendor` SET `ExtendedCost`='22' WHERE `ExtendedCost`='2365' AND `entry` = 1200050; -- 1875(1700R) -> 1630
UPDATE `npc_vendor` SET `ExtendedCost`='22' WHERE `ExtendedCost`='2366' AND `entry` = 1200050; -- 1875(1550R) -> 1630

-- shoulder pads 2.00k r 1500p -> 1435
DELETE FROM `npc_vendor` WHERE `entry` = 1200061 AND `item` IN (30490,31964,31971,31976,31979,31990,31996,32001,32008,32013,32018,32024,32033,32037,32043,32047,32059);
INSERT INTO `npc_vendor` VALUES
(1200061,30490,0,0,1435), --  2359
(1200061,31964,0,0,1435),(1200061,31971,0,0,1435),(1200061,31976,0,0,1435),(1200061,31979,0,0,1435),(1200061,31990,0,0,1435),(1200061,31996,0,0,1435),(1200061,32001,0,0,1435),(1200061,32008,0,0,1435),(1200061,32013,0,0,1435),(1200061,32018,0,0,1435),(1200061,32024,0,0,1435),(1200061,32033,0,0,1435),(1200061,32037,0,0,1435),(1200061,32043,0,0,1435),(1200061,32047,0,0,1435),(1200061,32059,0,0,1435);

-- S1 Vendor
-- Arena Points without Rating (Value)
-- 600(2374)
-- 650(2357)
-- 675(2343)
-- 800(2388)
-- 900(2387)
-- 1000(1758)
-- 1125(2283)
-- 1500(2288)
-- 1630(22)
-- 1875(2285)

DELETE FROM `npc_vendor` WHERE `entry` = 20278;
-- 2H Weapon
INSERT INTO `npc_vendor` VALUES (20278, 24550, 0, 0, 2238); -- 2285 -- 2237(2238 for no av marks)
INSERT INTO `npc_vendor` VALUES (20278, 24557, 0, 0, 2238);
INSERT INTO `npc_vendor` VALUES (20278, 28294, 0, 0, 2238);
INSERT INTO `npc_vendor` VALUES (20278, 28298, 0, 0, 2238);
INSERT INTO `npc_vendor` VALUES (20278, 28299, 0, 0, 2238);
INSERT INTO `npc_vendor` VALUES (20278, 28300, 0, 0, 2238);
INSERT INTO `npc_vendor` VALUES (20278, 28476, 0, 0, 2238);
-- 1H Caster
INSERT INTO `npc_vendor` VALUES (20278, 28297, 0, 0, 2238); -- 2283 -- 2238
INSERT INTO `npc_vendor` VALUES (20278, 32450, 0, 0, 2238);
INSERT INTO `npc_vendor` VALUES (20278, 32451, 0, 0, 2238);
-- 1H Melee
INSERT INTO `npc_vendor` VALUES (20278, 28295, 0, 0, 2239); -- 2283 -- 2239
INSERT INTO `npc_vendor` VALUES (20278, 28305, 0, 0, 2239);
INSERT INTO `npc_vendor` VALUES (20278, 28308, 0, 0, 2239);
INSERT INTO `npc_vendor` VALUES (20278, 28312, 0, 0, 2239);
INSERT INTO `npc_vendor` VALUES (20278, 28313, 0, 0, 2239);
-- Offhand
INSERT INTO `npc_vendor` VALUES (20278, 28302, 0, 0, 2240); -- 2343 -- 2240
INSERT INTO `npc_vendor` VALUES (20278, 28307, 0, 0, 2240);
INSERT INTO `npc_vendor` VALUES (20278, 28309, 0, 0, 2240);
INSERT INTO `npc_vendor` VALUES (20278, 28310, 0, 0, 2240);
INSERT INTO `npc_vendor` VALUES (20278, 28314, 0, 0, 2240);
INSERT INTO `npc_vendor` VALUES (20278, 28346, 0, 0, 2240);
INSERT INTO `npc_vendor` VALUES (20278, 32452, 0, 0, 2240);
-- Thrown/Wand/Idol/Libram/Totem
INSERT INTO `npc_vendor` VALUES (20278, 28319, 0, 0, 2241); -- 2374 -- 2241
INSERT INTO `npc_vendor` VALUES (20278, 28320, 0, 0, 2241);
INSERT INTO `npc_vendor` VALUES (20278, 28355, 0, 0, 2241);
INSERT INTO `npc_vendor` VALUES (20278, 28356, 0, 0, 2241);
INSERT INTO `npc_vendor` VALUES (20278, 28357, 0, 0, 2241);
INSERT INTO `npc_vendor` VALUES (20278, 33936, 0, 0, 2241);
INSERT INTO `npc_vendor` VALUES (20278, 33939, 0, 0, 2241);
INSERT INTO `npc_vendor` VALUES (20278, 33942, 0, 0, 2241);
INSERT INTO `npc_vendor` VALUES (20278, 33945, 0, 0, 2241);
INSERT INTO `npc_vendor` VALUES (20278, 33948, 0, 0, 2241);
INSERT INTO `npc_vendor` VALUES (20278, 33951, 0, 0, 2241);

-- Shield
INSERT INTO `npc_vendor` VALUES (20278, 28358, 0, 0, 2242); -- 2374 -- 2242
-- Gauntlets
INSERT INTO `npc_vendor` VALUES (20278, 24549, 0, 0, 2255); -- 2254 -- 2277(2255 for eots marks)
INSERT INTO `npc_vendor` VALUES (20278, 24556, 0, 0, 2255);
INSERT INTO `npc_vendor` VALUES (20278, 25834, 0, 0, 2255);
INSERT INTO `npc_vendor` VALUES (20278, 25857, 0, 0, 2255);
INSERT INTO `npc_vendor` VALUES (20278, 26000, 0, 0, 2255);
INSERT INTO `npc_vendor` VALUES (20278, 27470, 0, 0, 2255);
INSERT INTO `npc_vendor` VALUES (20278, 27703, 0, 0, 2255);
INSERT INTO `npc_vendor` VALUES (20278, 27707, 0, 0, 2255);
INSERT INTO `npc_vendor` VALUES (20278, 27880, 0, 0, 2255);
INSERT INTO `npc_vendor` VALUES (20278, 28126, 0, 0, 2255);
INSERT INTO `npc_vendor` VALUES (20278, 28136, 0, 0, 2255);
INSERT INTO `npc_vendor` VALUES (20278, 28335, 0, 0, 2255);
INSERT INTO `npc_vendor` VALUES (20278, 30188, 0, 0, 2255);
INSERT INTO `npc_vendor` VALUES (20278, 31375, 0, 0, 2255);
INSERT INTO `npc_vendor` VALUES (20278, 31397, 0, 0, 2255);
INSERT INTO `npc_vendor` VALUES (20278, 31409, 0, 0, 2255);
INSERT INTO `npc_vendor` VALUES (20278, 31614, 0, 0, 2255);
-- Shoulders
INSERT INTO `npc_vendor` VALUES (20278, 24546, 0, 0, 2278); -- 2373 -- 2278
INSERT INTO `npc_vendor` VALUES (20278, 24554, 0, 0, 2278);
INSERT INTO `npc_vendor` VALUES (20278, 25832, 0, 0, 2278);
INSERT INTO `npc_vendor` VALUES (20278, 25854, 0, 0, 2278);
INSERT INTO `npc_vendor` VALUES (20278, 25999, 0, 0, 2278);
INSERT INTO `npc_vendor` VALUES (20278, 27473, 0, 0, 2278);
INSERT INTO `npc_vendor` VALUES (20278, 27706, 0, 0, 2278);
INSERT INTO `npc_vendor` VALUES (20278, 27710, 0, 0, 2278);
INSERT INTO `npc_vendor` VALUES (20278, 27883, 0, 0, 2278);
INSERT INTO `npc_vendor` VALUES (20278, 28129, 0, 0, 2278);
INSERT INTO `npc_vendor` VALUES (20278, 28139, 0, 0, 2278);
INSERT INTO `npc_vendor` VALUES (20278, 28333, 0, 0, 2278);
INSERT INTO `npc_vendor` VALUES (20278, 30186, 0, 0, 2278);
INSERT INTO `npc_vendor` VALUES (20278, 31378, 0, 0, 2278);
INSERT INTO `npc_vendor` VALUES (20278, 31407, 0, 0, 2278);
INSERT INTO `npc_vendor` VALUES (20278, 31412, 0, 0, 2278);
INSERT INTO `npc_vendor` VALUES (20278, 31619, 0, 0, 2278);
-- Chest
INSERT INTO `npc_vendor` VALUES (20278, 24544, 0, 0, 2279); -- 2258 -- 2279
INSERT INTO `npc_vendor` VALUES (20278, 24552, 0, 0, 2279);
INSERT INTO `npc_vendor` VALUES (20278, 25831, 0, 0, 2279);
INSERT INTO `npc_vendor` VALUES (20278, 25856, 0, 0, 2279);
INSERT INTO `npc_vendor` VALUES (20278, 25997, 0, 0, 2279);
INSERT INTO `npc_vendor` VALUES (20278, 27469, 0, 0, 2279);
INSERT INTO `npc_vendor` VALUES (20278, 27702, 0, 0, 2279);
INSERT INTO `npc_vendor` VALUES (20278, 27711, 0, 0, 2279);
INSERT INTO `npc_vendor` VALUES (20278, 27879, 0, 0, 2279);
INSERT INTO `npc_vendor` VALUES (20278, 28130, 0, 0, 2279);
INSERT INTO `npc_vendor` VALUES (20278, 28140, 0, 0, 2279);
INSERT INTO `npc_vendor` VALUES (20278, 28334, 0, 0, 2279);
INSERT INTO `npc_vendor` VALUES (20278, 30200, 0, 0, 2279);
INSERT INTO `npc_vendor` VALUES (20278, 31379, 0, 0, 2279);
INSERT INTO `npc_vendor` VALUES (20278, 31396, 0, 0, 2279);
INSERT INTO `npc_vendor` VALUES (20278, 31413, 0, 0, 2279);
INSERT INTO `npc_vendor` VALUES (20278, 31613, 0, 0, 2279);
-- Helmet
INSERT INTO `npc_vendor` VALUES (20278, 24545, 0, 0, 2280); -- 2262-2280- 
INSERT INTO `npc_vendor` VALUES (20278, 24553, 0, 0, 2280);
INSERT INTO `npc_vendor` VALUES (20278, 25830, 0, 0, 2280);
INSERT INTO `npc_vendor` VALUES (20278, 25855, 0, 0, 2280);
INSERT INTO `npc_vendor` VALUES (20278, 25998, 0, 0, 2280);
INSERT INTO `npc_vendor` VALUES (20278, 27471, 0, 0, 2280);
INSERT INTO `npc_vendor` VALUES (20278, 27704, 0, 0, 2280);
INSERT INTO `npc_vendor` VALUES (20278, 27708, 0, 0, 2280);
INSERT INTO `npc_vendor` VALUES (20278, 27881, 0, 0, 2280);
INSERT INTO `npc_vendor` VALUES (20278, 28127, 0, 0, 2280);
INSERT INTO `npc_vendor` VALUES (20278, 28137, 0, 0, 2280);
INSERT INTO `npc_vendor` VALUES (20278, 28331, 0, 0, 2280);
INSERT INTO `npc_vendor` VALUES (20278, 30187, 0, 0, 2280);
INSERT INTO `npc_vendor` VALUES (20278, 31376, 0, 0, 2280);
INSERT INTO `npc_vendor` VALUES (20278, 31400, 0, 0, 2280);
INSERT INTO `npc_vendor` VALUES (20278, 31410, 0, 0, 2280);
INSERT INTO `npc_vendor` VALUES (20278, 31616, 0, 0, 2280);
-- Legs
INSERT INTO `npc_vendor` VALUES (20278, 24547, 0, 0, 2281); -- 2264-2281
INSERT INTO `npc_vendor` VALUES (20278, 24555, 0, 0, 2281);
INSERT INTO `npc_vendor` VALUES (20278, 25833, 0, 0, 2281);
INSERT INTO `npc_vendor` VALUES (20278, 25858, 0, 0, 2281);
INSERT INTO `npc_vendor` VALUES (20278, 26001, 0, 0, 2281);
INSERT INTO `npc_vendor` VALUES (20278, 27472, 0, 0, 2281);
INSERT INTO `npc_vendor` VALUES (20278, 27705, 0, 0, 2281);
INSERT INTO `npc_vendor` VALUES (20278, 27709, 0, 0, 2281);
INSERT INTO `npc_vendor` VALUES (20278, 27882, 0, 0, 2281);
INSERT INTO `npc_vendor` VALUES (20278, 28128, 0, 0, 2281);
INSERT INTO `npc_vendor` VALUES (20278, 28138, 0, 0, 2281);
INSERT INTO `npc_vendor` VALUES (20278, 28332, 0, 0, 2281);
INSERT INTO `npc_vendor` VALUES (20278, 30201, 0, 0, 2281);
INSERT INTO `npc_vendor` VALUES (20278, 31377, 0, 0, 2281);
INSERT INTO `npc_vendor` VALUES (20278, 31406, 0, 0, 2281);
INSERT INTO `npc_vendor` VALUES (20278, 31411, 0, 0, 2281);
INSERT INTO `npc_vendor` VALUES (20278, 31618, 0, 0, 2281);
--
-- nonblizzlike rar gems for honor+12g
-- INSERT INTO `npc_vendor` VALUES (20278, 23436, 0, 0, 2404);
-- INSERT INTO `npc_vendor` VALUES (20278, 23437, 0, 0, 2404);
-- INSERT INTO `npc_vendor` VALUES (20278, 23438, 0, 0, 2404);
-- INSERT INTO `npc_vendor` VALUES (20278, 23439, 0, 0, 2404);
-- INSERT INTO `npc_vendor` VALUES (20278, 23440, 0, 0, 2404);
-- INSERT INTO `npc_vendor` VALUES (20278, 23441, 0, 0, 2404);
-- nonblizzlike epic gems for honor
-- ('@ENTRY','32227','0','0','2404'),
-- ('@ENTRY','32229','0','0','2404'),
-- ('@ENTRY','32228','0','0','2404'),
-- ('@ENTRY','32230','0','0','2404'),
-- ('@ENTRY','32231','0','0','2404'),
-- ('@ENTRY','32249','0','0','2404');

-- S3 Vendor
DELETE FROM `npc_vendor` WHERE `entry` = 77777;
-- Shield
INSERT INTO `npc_vendor` VALUES (77777, 33661, 0, 0, 2364);
INSERT INTO `npc_vendor` VALUES (77777, 33735, 0, 0, 2364);
INSERT INTO `npc_vendor` VALUES (77777, 33755, 0, 0, 2364);
-- Offhand
INSERT INTO `npc_vendor` VALUES (77777, 33662, 0, 0, 2363);
INSERT INTO `npc_vendor` VALUES (77777, 33689, 0, 0, 2363);
INSERT INTO `npc_vendor` VALUES (77777, 33705, 0, 0, 2363);
INSERT INTO `npc_vendor` VALUES (77777, 33734, 0, 0, 2363);
INSERT INTO `npc_vendor` VALUES (77777, 33756, 0, 0, 2363);
INSERT INTO `npc_vendor` VALUES (77777, 33801, 0, 0, 2363);
INSERT INTO `npc_vendor` VALUES (77777, 34015, 0, 0, 2363);
INSERT INTO `npc_vendor` VALUES (77777, 34016, 0, 0, 2363);
INSERT INTO `npc_vendor` VALUES (77777, 33681, 0, 0, 2363);
INSERT INTO `npc_vendor` VALUES (77777, 33736, 0, 0, 2363);
INSERT INTO `npc_vendor` VALUES (77777, 34033, 0, 0, 2363);
-- Shoulder
INSERT INTO `npc_vendor` VALUES (77777, 33668, 0, 0, 2359);
INSERT INTO `npc_vendor` VALUES (77777, 33674, 0, 0, 2359);
INSERT INTO `npc_vendor` VALUES (77777, 33679, 0, 0, 2359);
INSERT INTO `npc_vendor` VALUES (77777, 33682, 0, 0, 2359);
INSERT INTO `npc_vendor` VALUES (77777, 33693, 0, 0, 2359);
INSERT INTO `npc_vendor` VALUES (77777, 33699, 0, 0, 2359);
INSERT INTO `npc_vendor` VALUES (77777, 33703, 0, 0, 2359);
INSERT INTO `npc_vendor` VALUES (77777, 33710, 0, 0, 2359);
INSERT INTO `npc_vendor` VALUES (77777, 33715, 0, 0, 2359);
INSERT INTO `npc_vendor` VALUES (77777, 33720, 0, 0, 2359);
INSERT INTO `npc_vendor` VALUES (77777, 33726, 0, 0, 2359);
INSERT INTO `npc_vendor` VALUES (77777, 33732, 0, 0, 2359);
INSERT INTO `npc_vendor` VALUES (77777, 33742, 0, 0, 2359);
INSERT INTO `npc_vendor` VALUES (77777, 33747, 0, 0, 2359);
INSERT INTO `npc_vendor` VALUES (77777, 33753, 0, 0, 2359);
INSERT INTO `npc_vendor` VALUES (77777, 33757, 0, 0, 2359);
INSERT INTO `npc_vendor` VALUES (77777, 33770, 0, 0, 2359);
-- Melee MH
INSERT INTO `npc_vendor` VALUES (77777, 33669, 0, 0, 2362);
INSERT INTO `npc_vendor` VALUES (77777, 33733, 0, 0, 2362);
INSERT INTO `npc_vendor` VALUES (77777, 33737, 0, 0, 2362);
INSERT INTO `npc_vendor` VALUES (77777, 33754, 0, 0, 2362);
INSERT INTO `npc_vendor` VALUES (77777, 33762, 0, 0, 2362);
-- Caster MH
INSERT INTO `npc_vendor` VALUES (77777, 33687, 0, 0, 2361); 
INSERT INTO `npc_vendor` VALUES (77777, 33743, 0, 0, 2361);
INSERT INTO `npc_vendor` VALUES (77777, 33763, 0, 0, 2361);
-- Wands etc
INSERT INTO `npc_vendor` VALUES (77777, 33764, 0, 0, 2339);
INSERT INTO `npc_vendor` VALUES (77777, 33765, 0, 0, 2339);
INSERT INTO `npc_vendor` VALUES (77777, 33841, 0, 0, 2339);
INSERT INTO `npc_vendor` VALUES (77777, 33842, 0, 0, 2339);
INSERT INTO `npc_vendor` VALUES (77777, 33843, 0, 0, 2339);
INSERT INTO `npc_vendor` VALUES (77777, 33938, 0, 0, 2339);
INSERT INTO `npc_vendor` VALUES (77777, 33941, 0, 0, 2339);
INSERT INTO `npc_vendor` VALUES (77777, 33944, 0, 0, 2339);
INSERT INTO `npc_vendor` VALUES (77777, 33947, 0, 0, 2339);
INSERT INTO `npc_vendor` VALUES (77777, 33950, 0, 0, 2339);
INSERT INTO `npc_vendor` VALUES (77777, 33953, 0, 0, 2339);
INSERT INTO `npc_vendor` VALUES (77777, 34014, 0, 0, 2339);
INSERT INTO `npc_vendor` VALUES (77777, 34059, 0, 0, 2339);
INSERT INTO `npc_vendor` VALUES (77777, 34066, 0, 0, 2339);
-- 2H Weapon & Ranged
INSERT INTO `npc_vendor` VALUES (77777, 33006, 0, 0, 2360);
INSERT INTO `npc_vendor` VALUES (77777, 33663, 0, 0, 2360);
INSERT INTO `npc_vendor` VALUES (77777, 33670, 0, 0, 2360);
INSERT INTO `npc_vendor` VALUES (77777, 33688, 0, 0, 2360);
INSERT INTO `npc_vendor` VALUES (77777, 33716, 0, 0, 2360);
INSERT INTO `npc_vendor` VALUES (77777, 33727, 0, 0, 2360);
INSERT INTO `npc_vendor` VALUES (77777, 33766, 0, 0, 2360);
INSERT INTO `npc_vendor` VALUES (77777, 34529, 0, 0, 2360);
INSERT INTO `npc_vendor` VALUES (77777, 34530, 0, 0, 2360);
INSERT INTO `npc_vendor` VALUES (77777, 34540, 0, 0, 2360);
-- Chest
INSERT INTO `npc_vendor` VALUES (77777, 33664, 0, 0, 2337);
INSERT INTO `npc_vendor` VALUES (77777, 33675, 0, 0, 2337);
INSERT INTO `npc_vendor` VALUES (77777, 33680, 0, 0, 2337);
INSERT INTO `npc_vendor` VALUES (77777, 33685, 0, 0, 2337);
INSERT INTO `npc_vendor` VALUES (77777, 33694, 0, 0, 2337);
INSERT INTO `npc_vendor` VALUES (77777, 33695, 0, 0, 2337);
INSERT INTO `npc_vendor` VALUES (77777, 33704, 0, 0, 2337);
INSERT INTO `npc_vendor` VALUES (77777, 33706, 0, 0, 2337);
INSERT INTO `npc_vendor` VALUES (77777, 33711, 0, 0, 2337);
INSERT INTO `npc_vendor` VALUES (77777, 33721, 0, 0, 2337);
INSERT INTO `npc_vendor` VALUES (77777, 33722, 0, 0, 2337);
INSERT INTO `npc_vendor` VALUES (77777, 33728, 0, 0, 2337);
INSERT INTO `npc_vendor` VALUES (77777, 33738, 0, 0, 2337);
INSERT INTO `npc_vendor` VALUES (77777, 33748, 0, 0, 2337);
INSERT INTO `npc_vendor` VALUES (77777, 33749, 0, 0, 2337);
INSERT INTO `npc_vendor` VALUES (77777, 33760, 0, 0, 2337);
INSERT INTO `npc_vendor` VALUES (77777, 33771, 0, 0, 2337);
-- Head
INSERT INTO `npc_vendor` VALUES (77777, 33666, 0, 0, 2365);
INSERT INTO `npc_vendor` VALUES (77777, 33672, 0, 0, 2365);
INSERT INTO `npc_vendor` VALUES (77777, 33677, 0, 0, 2365);
INSERT INTO `npc_vendor` VALUES (77777, 33683, 0, 0, 2365);
INSERT INTO `npc_vendor` VALUES (77777, 33691, 0, 0, 2365);
INSERT INTO `npc_vendor` VALUES (77777, 33697, 0, 0, 2365);
INSERT INTO `npc_vendor` VALUES (77777, 33701, 0, 0, 2365);
INSERT INTO `npc_vendor` VALUES (77777, 33708, 0, 0, 2365);
INSERT INTO `npc_vendor` VALUES (77777, 33713, 0, 0, 2365);
INSERT INTO `npc_vendor` VALUES (77777, 33718, 0, 0, 2365);
INSERT INTO `npc_vendor` VALUES (77777, 33724, 0, 0, 2365);
INSERT INTO `npc_vendor` VALUES (77777, 33730, 0, 0, 2365);
INSERT INTO `npc_vendor` VALUES (77777, 33740, 0, 0, 2365);
INSERT INTO `npc_vendor` VALUES (77777, 33745, 0, 0, 2365);
INSERT INTO `npc_vendor` VALUES (77777, 33751, 0, 0, 2365);
INSERT INTO `npc_vendor` VALUES (77777, 33758, 0, 0, 2365);
INSERT INTO `npc_vendor` VALUES (77777, 33768, 0, 0, 2365);
-- Legs
INSERT INTO `npc_vendor` VALUES (77777, 33667, 0, 0, 2366);
INSERT INTO `npc_vendor` VALUES (77777, 33673, 0, 0, 2366);
INSERT INTO `npc_vendor` VALUES (77777, 33678, 0, 0, 2366);
INSERT INTO `npc_vendor` VALUES (77777, 33686, 0, 0, 2366);
INSERT INTO `npc_vendor` VALUES (77777, 33692, 0, 0, 2366);
INSERT INTO `npc_vendor` VALUES (77777, 33698, 0, 0, 2366);
INSERT INTO `npc_vendor` VALUES (77777, 33702, 0, 0, 2366);
INSERT INTO `npc_vendor` VALUES (77777, 33709, 0, 0, 2366);
INSERT INTO `npc_vendor` VALUES (77777, 33714, 0, 0, 2366);
INSERT INTO `npc_vendor` VALUES (77777, 33719, 0, 0, 2366);
INSERT INTO `npc_vendor` VALUES (77777, 33725, 0, 0, 2366);
INSERT INTO `npc_vendor` VALUES (77777, 33731, 0, 0, 2366);
INSERT INTO `npc_vendor` VALUES (77777, 33741, 0, 0, 2366);
INSERT INTO `npc_vendor` VALUES (77777, 33746, 0, 0, 2366);
INSERT INTO `npc_vendor` VALUES (77777, 33752, 0, 0, 2366);
INSERT INTO `npc_vendor` VALUES (77777, 33761, 0, 0, 2366);
INSERT INTO `npc_vendor` VALUES (77777, 33769, 0, 0, 2366);
-- Gloves
INSERT INTO `npc_vendor` VALUES (77777, 33665, 0, 0, 2286);
INSERT INTO `npc_vendor` VALUES (77777, 33671, 0, 0, 2286);
INSERT INTO `npc_vendor` VALUES (77777, 33676, 0, 0, 2286);
INSERT INTO `npc_vendor` VALUES (77777, 33684, 0, 0, 2286);
INSERT INTO `npc_vendor` VALUES (77777, 33690, 0, 0, 2286);
INSERT INTO `npc_vendor` VALUES (77777, 33696, 0, 0, 2286);
INSERT INTO `npc_vendor` VALUES (77777, 33700, 0, 0, 2286);
INSERT INTO `npc_vendor` VALUES (77777, 33707, 0, 0, 2286);
INSERT INTO `npc_vendor` VALUES (77777, 33712, 0, 0, 2286);
INSERT INTO `npc_vendor` VALUES (77777, 33717, 0, 0, 2286);
INSERT INTO `npc_vendor` VALUES (77777, 33723, 0, 0, 2286);
INSERT INTO `npc_vendor` VALUES (77777, 33729, 0, 0, 2286);
INSERT INTO `npc_vendor` VALUES (77777, 33739, 0, 0, 2286);
INSERT INTO `npc_vendor` VALUES (77777, 33744, 0, 0, 2286);
INSERT INTO `npc_vendor` VALUES (77777, 33750, 0, 0, 2286);
INSERT INTO `npc_vendor` VALUES (77777, 33759, 0, 0, 2286);
INSERT INTO `npc_vendor` VALUES (77777, 33767, 0, 0, 2286);

DELETE FROM `npc_vendor` WHERE `entry` IN (77779,77710) AND `item` IN (35326,35327,34049,34579,34163,34576,34162,34577,33832,34578,34050,34580);
-- 2.3 release
INSERT INTO `npc_vendor` VALUES (77710, 34576, 0, 0, 2289);
INSERT INTO `npc_vendor` VALUES (77710, 34577, 0, 0, 2289);
INSERT INTO `npc_vendor` VALUES (77710, 34578, 0, 0, 2289);
INSERT INTO `npc_vendor` VALUES (77710, 34579, 0, 0, 2289);
INSERT INTO `npc_vendor` VALUES (77710, 34580, 0, 0, 2289);
INSERT INTO `npc_vendor` VALUES (77779, 34576, 0, 0, 2289);
INSERT INTO `npc_vendor` VALUES (77779, 34577, 0, 0, 2289);
INSERT INTO `npc_vendor` VALUES (77779, 34578, 0, 0, 2289);
INSERT INTO `npc_vendor` VALUES (77779, 34579, 0, 0, 2289);
INSERT INTO `npc_vendor` VALUES (77779, 34580, 0, 0, 2289);

-- 2.4 other vendor with 2.4 -> S4 Honor Vendor
-- INSERT INTO `npc_vendor` VALUES (77710, 35327, 0, 0, 2289);
-- INSERT INTO `npc_vendor` VALUES (77779, 35327, 0, 0, 2289);

#!sql

-- https://github.com/Looking4Group/L4G_Core/issues/441
-- Shattrath & Stuff
-- ======================================================
-- Texts & Scripts
-- ======================================================

UPDATE `creature_ai_texts` SET `content_loc3`='Zögert nicht! Bestellt jetzt und Ihr erhaltet mein ultrakinetisches Waffelbügeleisen ohne Aufpreis!' WHERE `entry` = -836;
UPDATE `creature_ai_texts` SET `content_loc3`='Ob Rotwein-, Grasflecken oder sogar tierische Hinterlassenschaften... Kein Fleck ist dem elektrostatischen Makulationsblaster gewachsen!' WHERE `entry` = -835;
UPDATE `creature_ai_texts` SET `content_loc3`='Abgeleitet von innovativer Militärtechnologie der Offensive der Zerschmetterten Hand, es entfernt hartnäckige Flecken mit Leichtigkeit!' WHERE `entry` = -834; 
UPDATE `creature_ai_texts` SET `content_loc3`='Seid der erste aus Eurem Umfeld der den unglaublichen elektrostatischen Makulaturblaster besitzt!' WHERE `entry` = -833;
UPDATE `creature_ai_texts` SET `content_loc3`='Es wird langsam, Waffelfritte, es wird... Hast du etwa keine Produktpräsentation zu machen, oder was?' WHERE `entry` = -832;
UPDATE `creature_ai_texts` SET `content_loc3`='He, Herold, wie sieht\'s mit den Nachforschungen aus? Wenn du schnell genug Resultate liefert, könnte auch ein ultrakinetisches Waffelbügeleisen für dich mit dabei sein!' WHERE `entry` = -831;

-- ====================
-- Spawns
-- ====================

-- frei ab 68300 in shattrath 68383 68393 68400 68403 68404 68405 68410 68415 68416 bis 68530

-- Fehlender Soldat GUID 96600
DELETE FROM `creature` WHERE `guid` IN (96600,107577,70234);
INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES
(96600, 25137, 530, 1,-1848.1287,5316.6601,-12.4278,4.8345,180,0,0),
(107577, 19687, 530, 1, -1976.909, 5112.424, 7.589328, 4.276057, 120, 0, 0),
(70234, 19687, 530, 1, -2157.8547, 5143.3159,-21.3940, 3.8920, 120, 0, 0);

-- Delete Custom Unneeded Exploitable Stuff
DELETE FROM `creature` WHERE `guid` IN (36095,45532,45604,45611,45615,45624,45632,45637,45741,46137,53940,84269,92517,98086,107061,124516,163912,174558,221620,312393,351441,529506,604678,605542,605601,605637,605654,605691,605704,605721,605739,605754,605830,605861,605879,605905,605920,605989,605996,606011,606182,606214,606255,606293,606312,606349,606391,606507,606521,606538,606548,606567,606581,606610,606637,606649,606666,606681,606703,606870,606883,606891,606925,606973,607027,607050,607149,607167,607189,607243,607255,607332,607356,607371,607444,607499,607593,607610,607622,607635,607651,607822,607839,607866,607883,607922,607968,608031,608098,608175,608243,608257,608275,608321,608348,608378,608391,608460,608538,608552,608562,608584,608611,608627,608922,608947,608969,609048,610375,610405,610428,610547,610578,610608,610634,610682,610712,610938,611084,611159,611216,611259,611292,611308,611452,611478,611618,611650,611670,611693,611719,611733,615216,615418,615432,615453,615501,615520,615534,615666,615687,615700,615714,615734,615786,615901,615916,615927,615939,615949,615958,615978,615992,616004,616014,616048,616065,616102,616119,616134,616145,616158,616230,616249,616268,616279,616306,616321,618916,618936,618952,618978,618999,619068,619084,619100,619127,619271,619297,619386,619471,619521,619774,619791,619809,619824,619838,619858,619873,619886,619903,620044,620066,620085,620101,620116,620132,620157,620190,620232,620249,620260,620282,620309,620334,620363,620377,620399,620413,620423,620438,620453,620840,621331,621387,621475,621486,621496,621513,621528,621540,621553,621567,621592,621607,621620,621636,621661,621672,621688,621701,621727,621754,621768,621783,621803,621814,621831,621859,622704,622721,622729,622743,622843,622856,622867,622874,622950,622958,622981,622996,623041,623065,623083,623098,623132,623155,623167,623182,623189,623208,623220,623231,623415,623456,623473,623503,623521,623531,623546,623556,623566,623582,623592,623810,623817,624584,624594,624609,624626,624639,624653,624668,624672,624742,624758,624778,624805,624817,624829,624894,624910,625050,625062,625073,625090,625119,625131,625142,625218,625294,625305,625321,625335,625361,625378,625414,625554,625569,668268,679332,1332722,1334878);

-- ======================================================
-- NPC Research
-- ======================================================

-- Scotty Markentauscher
UPDATE `creature_template` SET `modelid_A`='21277',`modelid_A2`='21289',`modelid_H`='21288',`modelid_H2`='21290',`minhealth`='11000',`maxhealth`='11000',`subname`='',`minmana`='0',`maxmana`='0',`armor`='7100',`type`='7',`flags_extra`='2' WHERE `entry` = 1200007;

-- Shattered Sun Trainees 25134,25135,25136,25137
UPDATE `creature_template` SET `AIName`="EventAI" WHERE `entry` IN (25134,25135,25136,25137);
DELETE FROM `creature_ai_scripts` WHERE `entryorguid` IN (25134,25135,25136,25137);
INSERT INTO `creature_ai_scripts` (`id`, `entryOrGUID`, `event_type`, `event_inverse_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action1_type`, `action1_param1`, `action1_param2`, `action1_param3`, `action2_type`, `action2_param1`, `action2_param2`, `action2_param3`, `action3_type`, `action3_param1`, `action3_param2`, `action3_param3`, `comment`) VALUES
(2513401,25134,1,0,100,1,0,3000,3000,3000,10,36,43,54,0,0,0,0,0,0,0,0,"Shattered Sun Trainee - Out of Combat - Emote OneShotAttack1H or OneShotParryShield"),
(2513501,25135,1,0,100,1,0,3000,3000,3000,10,36,43,54,0,0,0,0,0,0,0,0,"Shattered Sun Trainee - Out of Combat - Emote OneShotAttack1H or OneShotParryShield"),
(2513601,25136,1,0,100,1,0,3000,3000,3000,10,36,43,54,0,0,0,0,0,0,0,0,"Shattered Sun Trainee - Out of Combat - Emote OneShotAttack1H or OneShotParryShield"),
(2513701,25137,1,0,100,1,0,3000,3000,3000,10,36,43,54,0,0,0,0,0,0,0,0,"Shattered Sun Trainee - Out of Combat - Emote OneShotAttack1H or OneShotParryShield");

-- Horde Warbringer 15350
UPDATE `creature_template` SET `dynamicflags`='0' WHERE `entry` = 15350;

-- Alliance Brigadier General 15351
-- UPDATE `creature_template` SET  WHERE `entry` = 15351;

-- 19688 Sryer Guard are no Vendors
UPDATE `creature_template` SET `npcflag` = '0' WHERE `entry` = '19688';

-- Skyguard Neather Ray Should not be moving
UPDATE `creature` SET `spawndist`='0', `MovementType`='0',`orientation`='1.1693' WHERE guid = 79011;

-- Mounted Neophyte 19390

-- ZF Zombie
UPDATE `creature_template` SET `lootid`=7286,`pickpocketloot`=7286 WHERE `entry` = 7286;

-- Omen https://github.com/TBCPvP/TBCPvP/commit/d0abea4bc81f493d489e95e7fb14f3b9d4295288
UPDATE `creature` SET `spawnmask`='1' WHERE `guid` = 2468;
UPDATE `creature_template` SET `minlevel`='73',`maxlevel`='73',`minhealth`='1000000',`maxhealth`='1000000',`armor`='7700',`speed`='2',`mindmg`='1000',`maxdmg`='2000',`baseattacktime`='1000',`dynamicflags`='0',`unit_flags`='0',`resistance1`='100',`resistance2`='100',`resistance3`='100',`resistance4`='100',`resistance5`='100',`resistance6`='100',`mechanic_immune_mask`='1073725439',`flags_extra`=`flags_extra`|'65536'|'33554432' WHERE `entry` = 15467;

-- Omen Adds
-- Minion of Omen 15466

-- ======================================================
-- Visuals & Positioning & Movement
-- ======================================================

UPDATE `creature` SET `position_x`='-1930.9318', `position_y`='5234.0239', `position_z`='-41.8173', `orientation`='1.2333',`spawndist`='0',`movementtype`='0' WHERE `guid` = 68397;

-- movement or delete 68464

UPDATE `creature` SET `position_x`='-1971.1124',`position_y`='5175.1484',`position_z`='-38.2741',`orientation`='0.6510' WHERE `guid` = 1717948;

-- got ai
DELETE FROM `creature_template_addon` WHERE `entry` IN (25134,25135,25136,25137);
-- INSERT INTO `creature_template_addon` VALUES 
-- (25134,0,0,0,0,4097,389,0,''),
-- (25135,0,0,0,0,4097,389,0,''),
-- (25136,0,0,0,0,4097,389,0,''),
-- (25137,0,0,0,0,4097,389,0,'');

SET @NPC := 70228; 
UPDATE `creature` SET `MovementType` = 2 WHERE guid = @NPC;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes0`, `bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,16843008, 4097, 17063, ''); 
DELETE FROM `waypoint_data` WHERE `id`=@PATH; -- @PATH = @NPC*10
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1,-1917.57,5268.41,3.7821,15000,0,0,100,0),   
(@PATH,2,-1931.62,5226.32,13.6659,0,0,0,100,0),  
(@PATH,3,-1944.13,5188.91,16.7801,0,0,0,100,0),  
(@PATH,4,-1953.77,5160.06,17.2677,0,0,0,100,0),   
(@PATH,5,-1957.69,5148.34,16.6797,0,0,0,100,0), 
(@PATH,6,-1963.00,5132.45,13.3904,15000,0,0,100,0),
(@PATH,7,-1957.69,5148.34,16.6797,0,0,0,100,0), 
(@PATH,8,-1953.77,5160.06,17.2677,0,0,0,100,0),   
(@PATH,9,-1944.13,5188.91,16.7801,0,0,0,100,0),  
(@PATH,10,-1931.62,5226.32,13.6659,0,0,0,100,0);

SET @NPC := 70220; 
UPDATE `creature` SET `MovementType` = 2 WHERE guid = @NPC;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes0`, `bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,16843008, 4097, 17063, ''); 
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1,-1603.2742,5342.6855,17.1795,0,0,0,100,0),
(@PATH,2,-1587.0461,5337.2846,17.2044,0,0,0,100,0),
(@PATH,3,-1565.5823,5330.1416,13.2020,15000,0,0,100,0),
(@PATH,4,-1587.0461,5337.2846,17.2044,0,0,0,100,0),
(@PATH,5,-1603.2742,5342.6855,17.1795,0,0,0,100,0),
(@PATH,6,-1621.5233,5348.6396,16.8502,0,0,0,100,0),
(@PATH,7,-1660.5310,5361.7021,13.5978,0,0,0,100,0),
(@PATH,8,-1701.1354,5375.3281,4.0023,15000,0,0,100,0),
(@PATH,9,-1660.5310,5361.7021,13.5978,0,0,0,100,0),
(@PATH,10,-1621.5233,5348.6396,16.8502,0,0,0,100,0);

SET @NPC := 68924; 
UPDATE `creature` SET `MovementType` = 2 WHERE guid = @NPC;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes0`, `bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,0, 4097, 0, ''); 
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1,-1909.3576,5846.2006,129.8383,0,0,0,100,0),
(@PATH,2,-1829.4794,5753.8984,130.5373,0,0,0,100,0),
(@PATH,3,-1857.7979,5762.3403,129.5581,0,0,0,100,0),
(@PATH,4,-1883.7142,5802.0180,130.5973,0,0,0,100,0),
(@PATH,5,-1901.5517,5831.3994,128.3695,0,0,0,100,0),
(@PATH,6,-1911.5161,5850.2978,130.2447,0,0,0,100,0),
(@PATH,7,-1920.7230,5868.8081,133.6996,0,0,0,100,0),
(@PATH,8,-1940.8338,5909.9321,145.8621,0,0,0,100,0),
(@PATH,9,-1959.9373,5956.9394,159.5592,0,0,0,100,0),
(@PATH,10,-1967.5106,5973.1679,157.6849,0,0,0,100,0),
(@PATH,11,-1972.6784,5976.1484,157.3017,0,0,0,100,0),
(@PATH,12,-1989.1994,5966.6025,156.1271,0,0,0,100,0),
(@PATH,13,-2004.0787,5972.5307,151.1060,0,0,0,100,0),
(@PATH,14,-2023.9764,6065.4990,121.1087,0,0,0,100,0),
(@PATH,15,-2035.5645,6083.7011,115.9172,60000,0,0,100,0);
-- (@PATH,15,XXX,YYY,ZZZ,WAIT,0,0,100,0), 

-- Emote for Zula Schmelzzorn - Schmiedin in Shattrath Entry: 20125
DELETE FROM `creature_addon` WHERE `guid` = 16800701;
INSERT INTO `creature_addon` VALUES 
(16800701,0,0,0,0,4097,233,0,'');

-- Pathing for Vekax Entry: 22429
UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-1668.65,`position_y`=5531.648,`position_z`=2.084388 WHERE `guid`=78783;
SET @NPC := 78783;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`) VALUES (@NPC,@PATH); 
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`move_type`,`wpguid`) VALUES
(@PATH,1,-1668.65,5531.648,2.084388,0,0),
(@PATH,2,-1675.535,5539.932,4.808745,0,0),
(@PATH,3,-1669.465,5544.53,5.413347,0,0),
(@PATH,4,-1656.403,5534.61,6.1091,0,0),
(@PATH,5,-1642.701,5537.171,6.172705,0,0),
(@PATH,6,-1641.732,5532.27,5.289427,0,0),
(@PATH,7,-1638.772,5516.784,-3.276233,0,0),
(@PATH,8,-1633.397,5489.191,-14.53821,0,0),
(@PATH,9,-1629.011,5484.991,-14.49736,0,0),
(@PATH,10,-1624.565,5486.951,-14.3688,0,0),
(@PATH,11,-1615.755,5487.401,-14.04851,0,0),
(@PATH,12,-1606.827,5480.522,-14.09892,0,0),
(@PATH,13,-1602.518,5469.729,-14.09986,0,0),
(@PATH,14,-1604.27,5462.537,-14.10011,0,0),
(@PATH,15,-1612.627,5453.875,-14.09042,0,0),
(@PATH,16,-1623.32,5451.606,-14.07838,0,0),
(@PATH,17,-1633.862,5457.565,-14.19732,0,0),
(@PATH,18,-1637.261,5469.756,-14.69115,0,0),
(@PATH,19,-1632.431,5481.022,-14.52123,0,0),
(@PATH,20,-1637.261,5469.756,-14.69115,0,0),
(@PATH,21,-1633.862,5457.565,-14.19732,0,0),
(@PATH,22,-1623.32,5451.606,-14.07838,0,0),
(@PATH,23,-1612.843,5453.652,-14.09002,0,0),
(@PATH,24,-1604.27,5462.537,-14.10011,0,0),
(@PATH,25,-1602.518,5469.729,-14.09986,0,0),
(@PATH,26,-1606.827,5480.522,-14.09892,0,0),
(@PATH,27,-1615.755,5487.401,-14.04851,0,0),
(@PATH,28,-1624.565,5486.951,-14.3688,0,0),
(@PATH,29,-1629.011,5484.991,-14.49736,0,0),
(@PATH,30,-1633.36,5489.002,-14.55791,0,0),
(@PATH,31,-1638.772,5516.784,-3.276233,0,0),
(@PATH,32,-1641.732,5532.27,5.289427,0,0),
(@PATH,33,-1642.701,5537.171,6.172705,0,0),
(@PATH,34,-1656.217,5534.645,6.133076,0,0),
(@PATH,35,-1669.465,5544.53,5.413347,0,0),
(@PATH,36,-1675.535,5539.932,4.808745,0,0),
(@PATH,37,-1668.774,5531.669,2.197366,0,0),
(@PATH,38,-1648.668,5528.287,-5.18554,0,0);

-- Pathing for Skettis Outcast Entry: 19075
UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-1622.079,`position_y`=5473.997,`position_z`=-4.175363 WHERE `guid`=68385;
SET @NPC := 68385;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`) VALUES (@NPC,@PATH); 
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`move_type`,`wpguid`) VALUES
(@PATH,1,-1622.079,5473.997,-4.175363,0,0),
(@PATH,2,-1624.692,5470.754,-4.14517,0,0),
(@PATH,3,-1624.417,5467.651,-4.055672,0,0),
(@PATH,4,-1622.095,5464.667,-4.021505,0,0),
(@PATH,5,-1618.157,5464.342,-4.122393,0,0),
(@PATH,6,-1614.648,5466.909,-3.965191,0,0),
(@PATH,7,-1614.635,5471.312,-4.240356,0,0),
(@PATH,8,-1618.361,5474.586,-3.982594,0,0);

-- Pathing for Hagerer Kriegsveteran - Brücke Süd-Osten Entry: 19684
SET @NPC := 6803494; 
UPDATE `creature` SET `MovementType` = 2 WHERE guid = @NPC;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,1,0, ''); 
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1,-1915.82,5273.44,2.7471,0,0,0,100,0),  
(@PATH,2, -1931.39,5226.66,13.5965,0,0,0,100,0),  
(@PATH,3,-1944.52,5187.46,16.8613,0,0,0,100,0),  
(@PATH,4,-1955.80,5153.97,17.2815,18000,0,0,100,0),
(@PATH,5,-1944.52,5187.46,16.8613,0,0,0,100,0),  
(@PATH,6,-1931.39,5226.66,13.5965,0,0,0,100,0),  
(@PATH,7,-1915.82,5273.44,2.7471,0,0,0,100,0),  
(@PATH,8,-1901.46,5316.08,0.8826,18000,0,0,100,0);

-- Pathing for Shattrath City Peacekeeper - Südöstlich außerhalb von Shattrath Entry: 19687
SET @NPC := 70236; 
UPDATE `creature` SET `MovementType` = 2 WHERE guid = @NPC;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes0`, `bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,16843008, 4097, 17063, ''); 
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES 
(@PATH,1,'-2100.4375','5115.8974','-1.1131',0,0,0,100,0),
(@PATH,2,'-2113.2951','5105.6357','-2.5311',0,0,0,100,0),   
(@PATH,3,'-2147.6708','5110.3378','-15.0644',0,0,0,100,0),   
(@PATH,4,'-2167.4299','5124.5463','-21.0858',10000,0,0,100,0),
(@PATH,5,'-2147.6708','5110.3378','-15.0644',0,0,0,100,0),   
(@PATH,6,'-2113.2951','5105.6357','-2.5311',0,0,0,100,0),  
(@PATH,7,'-2081.3798','5118.1401','4.4815',0,0,0,100,0),   
(@PATH,8,'-2058.7641','5124.8432','7.2969',0,0,0,100,0), 
(@PATH,9,'-2022.5397','5123.8784','8.6188',0,0,0,100,0), 
(@PATH,10,'-1975.2087','5097.6137','8.1237',5000,0,0,100,0),  
(@PATH,11,'-1958.0531','5088.0937','10.9466',0,0,0,100,0), 
(@PATH,12,'-1934.2985','5055.6650','19.8275',0,0,0,100,0), 
(@PATH,13,'-1958.7603','5026.1494','32.5082',10000,0,0,100,0),  
(@PATH,14,'-1934.2985','5055.6650','19.8275',0,0,0,100,0), 
(@PATH,15,'-1958.0531','5088.0937','10.9466',0,0,0,100,0), 
(@PATH,16,'-1975.2087','5097.6137','8.1237',5000,0,0,100,0),  
(@PATH,17,'-2022.5397','5123.8784','8.6188',0,0,0,100,0), 
(@PATH,18,'-2058.7641','5124.8432','7.2969',0,0,0,100,0), 
(@PATH,19,'-2081.3798','5118.14','4.4815',0,0,0,100,0);

-- wache richtung zangar
SET @NPC := 70217; 
UPDATE `creature` SET `MovementType` = 2 WHERE guid = @NPC;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`bytes0`, `bytes2`,`mount`,`auras`) VALUES (@NPC,@PATH,16843008, 4097, 17063, ''); 
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1,-1502.2634,5221.4775,30.6943,0,0,0,100,0),
(@PATH,2,-1512.3363,5233.6938,24.9189,0,0,0,100,0),
(@PATH,3,-1519.7844,5247.8999,19.7742,0,0,0,100,0),
(@PATH,4,-1521.6088,5262.7001,15.5909,0,0,0,100,0),
(@PATH,5,-1516.9725,5288.2055,11.2077,0,0,0,100,0),
(@PATH,6,-1519.8223,5305.3364,9.4219,0,0,0,100,0),
(@PATH,7,-1526.4892,5316.3701,8.8861,0,0,0,100,0),
(@PATH,8,-1530.2252,5317.6201,8.7321,5000,0,0,100,0),
(@PATH,9,-1526.4892,5316.3701,8.8861,0,0,0,100,0),
(@PATH,10,-1519.8223,5305.3364,9.4219,0,0,0,100,0),
(@PATH,11,-1516.9725,5288.2055,11.2077,0,0,0,100,0),
(@PATH,12,-1521.6088,5262.7001,15.5909,0,0,0,100,0),
(@PATH,13,-1519.7844,5247.8999,19.7742,0,0,0,100,0),
(@PATH,14,-1512.3363,5233.6938,24.9189,0,0,0,100,0),
(@PATH,15,-1502.2634,5221.4775,30.6943,0,0,0,100,0),
(@PATH,16,-1475.9080,5195.1665,46.5130,0,0,0,100,0),
(@PATH,17,-1508.3936,5209.3168,31.6188,0,0,0,100,0),
(@PATH,18,-1537.2144,5208.5449,25.1562,0,0,0,100,0),
(@PATH,19,-1562.2349,5197.9140,21.8793,0,0,0,100,0),
(@PATH,20,-1598.0568,5153.9970,17.9683,0,0,0,100,0),
(@PATH,21,-1626.1721,5117.2783,11.4690,0,0,0,100,0),
(@PATH,22,-1648.7716,5097.7583,9.1887,0,0,0,100,0),
(@PATH,23,-1635.0925,5082.3608,6.9086,0,0,0,100,0),
(@PATH,24,-1619.6885,5070.3823,0.2725,0,0,0,100,0),
(@PATH,25,-1601.5462,5066.8701,-5.6706,0,0,0,100,0),
(@PATH,26,-1578.2709,5069.7885,-11.8416,0,0,0,100,0),
(@PATH,27,-1553.1037,5078.8100,-17.3400,0,0,0,100,0),
(@PATH,28,-1541.0637,5090.6923,-19.1689,0,0,0,100,0),
(@PATH,29,-1533.6447,5112.5146,-20.1930,0,0,0,100,0),
(@PATH,30,-1535.6831,5113.8447,-20.5640,5000,0,0,100,0),
(@PATH,31,-1541.0637,5090.6923,-19.1689,0,0,0,100,0),
(@PATH,32,-1553.1037,5078.8100,-17.3400,0,0,0,100,0),
(@PATH,33,-1578.2709,5069.7885,-11.8416,0,0,0,100,0),
(@PATH,34,-1601.5462,5066.8701,-5.6706,0,0,0,100,0),
(@PATH,35,-1619.6885,5070.3823,0.2725,0,0,0,100,0),
(@PATH,36,-1635.0925,5082.3608,6.9086,0,0,0,100,0),
(@PATH,37,-1648.7716,5097.7583,9.1887,0,0,0,100,0),
(@PATH,38,-1626.1721,5117.2783,11.4690,0,0,0,100,0),
(@PATH,39,-1598.0568,5153.9970,17.9683,0,0,0,100,0),
(@PATH,40,-1562.2349,5197.9140,21.8793,0,0,0,100,0),
(@PATH,41,-1537.2144,5208.5449,25.1562,0,0,0,100,0),
(@PATH,42,-1508.3936,5209.3168,31.6188,0,0,0,100,0),
(@PATH,43,-1475.9080,5195.1665,46.5130,15000,0,0,100,0);

-- pvp kids
SET @NPC := 68568; 
UPDATE `creature` SET `MovementType` = 2 WHERE guid = @NPC;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` VALUES (@NPC,@PATH,0,16777472,0,4097,0,0,''); 
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1,-1865.1380,5226.7050,-40.2091,0,1,0,100,0),
(@PATH,2,-1874.0732,5221.7236,-40.2091,0,1,0,100,0),
(@PATH,3,-1896.9624,5217.5102,-48.0995,0,1,0,100,0), 
(@PATH,4,-1936.0278,5217.9941,-47.2738,0,1,0,100,0),
(@PATH,5,-1957.4179,5253.1718,-42.4121,0,1,0,100,0),
(@PATH,6,-1959.2875,5257.5942,-38.8516,0,1,0,100,0),
(@PATH,7,-1962.2069,5268.2412,-38.8108,0,1,0,100,0),
(@PATH,8,-1972.4090,5266.1381,-38.8508,0,1,0,100,0),
(@PATH,9,-1975.5362,5261.1347,-41.9375,0,1,0,100,0),
(@PATH,10,-1973.3724,5214.8261,-47.7292,0,1,0,100,0),
(@PATH,11,-1968.0831,5190.0449,-40.2076,0,1,0,100,0),
(@PATH,12,-1945.9741,5171.5532,-40.2092,0,1,0,100,0),
(@PATH,13,-1905.5919,5176.2368,-40.2092,0,1,0,100,0),
(@PATH,14,-1868.4006,5174.7724,-50.0506,0,1,0,100,0),
(@PATH,15,-1825.6529,5168.1435,-48.9272,0,1,0,100,0),
(@PATH,16,-1798.4946,5181.3803,-41.8442,0,1,0,100,0),
(@PATH,17,-1777.8391,5215.7353,-49.1428,0,1,0,100,0),
(@PATH,18,-1759.4946,5243.5415,-40.8305,0,1,0,100,0),
(@PATH,19,-1750.2081,5258.2495,-40.2078,0,1,0,100,0),
(@PATH,20,-1772.9831,5264.2685,-38.8104,0,1,0,100,0), 
(@PATH,21,-1778.1439,5251.1411,-40.2091,0,1,0,100,0),
(@PATH,22,-1807.3149,5238.1420,-42.0734,0,1,0,100,0),
(@PATH,23,-1830.6756,5214.0410,-40.2093,0,1,0,100,0),
(@PATH,24,-1840.7662,5218.4252,-38.0447,0,1,0,100,0),
(@PATH,25,-1853.2336,5224.8989,-38.0447,0,1,0,100,0);

UPDATE `creature` SET `movementtype`='2' WHERE `guid` = 69137;
SET @NPC := 69137;
SET @PATH := @NPC * 10;  
DELETE FROM `creature_addon` WHERE `guid`=@NPC;
INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes0`,`bytes1`,`bytes2`,`emote`,`moveflags`,`auras`) VALUES (@NPC,@PATH,19869,16777472,0,4097,0,0,'');
DELETE FROM `waypoint_data` WHERE `id`=@PATH;
INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
(@PATH,1,'-1797.21814','5629.5776','130.8128',0,0,0,100,0),
(@PATH,2,'-1795.8704','5633.7294','130.7822',0,0,0,100,0),
(@PATH,3,'-1786.7004','5661.3969','129.4054',0,0,0,100,0),
(@PATH,4,'-1776.8057','5690.7163','128.03428',0,0,0,100,0),
(@PATH,5,'-1777.8790','5687.5952','128.0998',0,0,0,100,0);

-- trigger steht falsch
UPDATE `creature` SET `position_x`='-1846.6214', `position_y`='6378.0756', `position_z`='48.8201', `orientation`='1.0103',`spawndist`='0',`movementtype`='0',`map`='530' WHERE `guid` = 16800087;
--
INSERT IGNORE INTO `creature_addon` (`guid`,`emote`) VALUES
(12159,173),
(12268,173),
(12269,173);

-- shattrath aldor 0 action
UPDATE `creature` SET `spawnmask` = 0 WHERE `guid` = 68464;

-- ======================================================
-- Linking
-- ======================================================
--
DELETE FROM `creature_formations` WHERE `leaderguid` IN (68924,68568,68567,69136,69137,69138,69139);
DELETE FROM `creature_formations` WHERE `memberguid` IN (68924,68568,68567,69136,69137,69138,69139);
INSERT IGNORE INTO `creature_formations` VALUES 
(68924,68924,60,360,2),
(68924,68493,2,0,2),
(68924,68925,4,0,2),
(68924,68494,6,0,2),
(68924,68923,8,0,2),
(68924,68492,10,0,2),
-- Flüchtlingsjungs
(68568,68568,60,360,2),
(68568,68567,3,0,2),
(69137,69137,100,360,3),
(69137,69136,4,1,3),
(69137,69138,4,5,3),
(69137,69139,6,0,3);
--

--
-- ======================================================
-- Respawn
-- ======================================================
--
--
-- ======================================================
-- Gameobjects
-- ======================================================

-- bg anmelder freihalten
UPDATE `gameobject` SET `position_x`='-1982.1893',`position_y`='5263.6328',`position_z`='-41.7449' WHERE `guid` = 43727;
UPDATE `gameobject` SET `position_x`='-1954.2205',`position_y`='5250.5585',`position_z`='-42.4001' WHERE `guid` = 43703;

DELETE FROM `gameobject` WHERE `guid` = 9970818;
INSERT INTO `gameobject` VALUES (9970818,183402,1,1,16232.5859,16297.9716,13.17430,0,0,0,-0.05,0.90,25,100,1); -- 0.665095,0.746758
UPDATE `gameobject` SET `animprogress`=100 WHERE `guid` IN (7332252,9970817);

-- ======================================================
-- Miscellaneous
-- ======================================================

-- G'eras
DELETE FROM `npc_vendor` WHERE `entry` = 18525;
-- 2.0
INSERT INTO `npc_vendor` VALUES (18525, 29266, 0, 0, 1037);
INSERT INTO `npc_vendor` VALUES (18525, 29267, 0, 0, 1037);
INSERT INTO `npc_vendor` VALUES (18525, 29268, 0, 0, 1037);
INSERT INTO `npc_vendor` VALUES (18525, 29269, 0, 0, 1015);
INSERT INTO `npc_vendor` VALUES (18525, 29270, 0, 0, 1015);
INSERT INTO `npc_vendor` VALUES (18525, 29271, 0, 0, 1015);
INSERT INTO `npc_vendor` VALUES (18525, 29272, 0, 0, 1015);
INSERT INTO `npc_vendor` VALUES (18525, 29273, 0, 0, 1015);
INSERT INTO `npc_vendor` VALUES (18525, 29274, 0, 0, 1015);
INSERT INTO `npc_vendor` VALUES (18525, 29275, 0, 0, 1040);
INSERT INTO `npc_vendor` VALUES (18525, 29367, 0, 0, 1015);
INSERT INTO `npc_vendor` VALUES (18525, 29368, 0, 0, 1015);
INSERT INTO `npc_vendor` VALUES (18525, 29369, 0, 0, 1015);
INSERT INTO `npc_vendor` VALUES (18525, 29370, 0, 0, 1027);
INSERT INTO `npc_vendor` VALUES (18525, 29373, 0, 0, 1015);
INSERT INTO `npc_vendor` VALUES (18525, 29374, 0, 0, 1015);
INSERT INTO `npc_vendor` VALUES (18525, 29375, 0, 0, 1015);
INSERT INTO `npc_vendor` VALUES (18525, 29376, 0, 0, 1027);
INSERT INTO `npc_vendor` VALUES (18525, 29379, 0, 0, 1015);
INSERT INTO `npc_vendor` VALUES (18525, 29381, 0, 0, 1015);
INSERT INTO `npc_vendor` VALUES (18525, 29382, 0, 0, 1015);
INSERT INTO `npc_vendor` VALUES (18525, 29383, 0, 0, 1027);
INSERT INTO `npc_vendor` VALUES (18525, 29384, 0, 0, 1015);
INSERT INTO `npc_vendor` VALUES (18525, 29385, 0, 0, 1015);
INSERT INTO `npc_vendor` VALUES (18525, 29386, 0, 0, 1015);
INSERT INTO `npc_vendor` VALUES (18525, 29387, 0, 0, 1027);
INSERT INTO `npc_vendor` VALUES (18525, 29388, 0, 0, 1642);
INSERT INTO `npc_vendor` VALUES (18525, 29389, 0, 0, 1642);
INSERT INTO `npc_vendor` VALUES (18525, 29390, 0, 0, 1642);
INSERT INTO `npc_vendor` VALUES (18525, 30761, 0, 0, 1454);
INSERT INTO `npc_vendor` VALUES (18525, 30762, 0, 0, 1454);
INSERT INTO `npc_vendor` VALUES (18525, 30763, 0, 0, 1452);
INSERT INTO `npc_vendor` VALUES (18525, 30764, 0, 0, 1452);
INSERT INTO `npc_vendor` VALUES (18525, 30766, 0, 0, 1454);
INSERT INTO `npc_vendor` VALUES (18525, 30767, 0, 0, 1452);
INSERT INTO `npc_vendor` VALUES (18525, 30768, 0, 0, 1452);
INSERT INTO `npc_vendor` VALUES (18525, 30769, 0, 0, 1454);
INSERT INTO `npc_vendor` VALUES (18525, 30770, 0, 0, 1452);
INSERT INTO `npc_vendor` VALUES (18525, 30772, 0, 0, 1454);
INSERT INTO `npc_vendor` VALUES (18525, 30773, 0, 0, 1454);
INSERT INTO `npc_vendor` VALUES (18525, 30774, 0, 0, 1452);
INSERT INTO `npc_vendor` VALUES (18525, 30776, 0, 0, 1454);
INSERT INTO `npc_vendor` VALUES (18525, 30778, 0, 0, 1454);
INSERT INTO `npc_vendor` VALUES (18525, 30779, 0, 0, 1452);
INSERT INTO `npc_vendor` VALUES (18525, 30780, 0, 0, 1452);
-- 2.1
INSERT INTO `npc_vendor` VALUES (18525, 23572, 0, 0, 1909);
INSERT INTO `npc_vendor` VALUES (18525, 32083, 0, 0, 1040);
INSERT INTO `npc_vendor` VALUES (18525, 32084, 0, 0, 1040);
INSERT INTO `npc_vendor` VALUES (18525, 32085, 0, 0, 1040);
INSERT INTO `npc_vendor` VALUES (18525, 32086, 0, 0, 1040);
INSERT INTO `npc_vendor` VALUES (18525, 32087, 0, 0, 1040);
INSERT INTO `npc_vendor` VALUES (18525, 32088, 0, 0, 1040);
INSERT INTO `npc_vendor` VALUES (18525, 32089, 0, 0, 1040);
INSERT INTO `npc_vendor` VALUES (18525, 32090, 0, 0, 1040);
-- 2.3
INSERT INTO `npc_vendor` VALUES (18525, 33192, 0, 0, 1015);
INSERT INTO `npc_vendor` VALUES (18525, 33207, 0, 0, 2059);
INSERT INTO `npc_vendor` VALUES (18525, 33222, 0, 0, 2059);
INSERT INTO `npc_vendor` VALUES (18525, 33279, 0, 0, 2059);
INSERT INTO `npc_vendor` VALUES (18525, 33280, 0, 0, 2059);
INSERT INTO `npc_vendor` VALUES (18525, 33287, 0, 0, 2059);
INSERT INTO `npc_vendor` VALUES (18525, 33291, 0, 0, 2059);
INSERT INTO `npc_vendor` VALUES (18525, 33296, 0, 0, 2060);
INSERT INTO `npc_vendor` VALUES (18525, 33304, 0, 0, 2059);
INSERT INTO `npc_vendor` VALUES (18525, 33324, 0, 0, 2059);
INSERT INTO `npc_vendor` VALUES (18525, 33325, 0, 0, 2060);
INSERT INTO `npc_vendor` VALUES (18525, 33331, 0, 0, 2059);
INSERT INTO `npc_vendor` VALUES (18525, 33333, 0, 0, 2059);
INSERT INTO `npc_vendor` VALUES (18525, 33334, 0, 0, 2060);
INSERT INTO `npc_vendor` VALUES (18525, 33386, 0, 0, 2059);
INSERT INTO `npc_vendor` VALUES (18525, 33484, 0, 0, 2059);
INSERT INTO `npc_vendor` VALUES (18525, 33501, 0, 0, 2049);
INSERT INTO `npc_vendor` VALUES (18525, 33502, 0, 0, 1452);
INSERT INTO `npc_vendor` VALUES (18525, 33503, 0, 0, 1452);
INSERT INTO `npc_vendor` VALUES (18525, 33504, 0, 0, 1452);
INSERT INTO `npc_vendor` VALUES (18525, 33505, 0, 0, 1452);
INSERT INTO `npc_vendor` VALUES (18525, 33506, 0, 0, 1452);
INSERT INTO `npc_vendor` VALUES (18525, 33507, 0, 0, 1452);
INSERT INTO `npc_vendor` VALUES (18525, 33508, 0, 0, 1452);
INSERT INTO `npc_vendor` VALUES (18525, 33509, 0, 0, 1452);
INSERT INTO `npc_vendor` VALUES (18525, 33510, 0, 0, 1452);
INSERT INTO `npc_vendor` VALUES (18525, 33512, 0, 0, 2059);
INSERT INTO `npc_vendor` VALUES (18525, 33513, 0, 0, 2060);
INSERT INTO `npc_vendor` VALUES (18525, 33514, 0, 0, 2059);
INSERT INTO `npc_vendor` VALUES (18525, 33515, 0, 0, 2049);
INSERT INTO `npc_vendor` VALUES (18525, 33516, 0, 0, 2060);
INSERT INTO `npc_vendor` VALUES (18525, 33517, 0, 0, 2059);
INSERT INTO `npc_vendor` VALUES (18525, 33518, 0, 0, 2049);
INSERT INTO `npc_vendor` VALUES (18525, 33519, 0, 0, 2059);
INSERT INTO `npc_vendor` VALUES (18525, 33520, 0, 0, 2060);
INSERT INTO `npc_vendor` VALUES (18525, 33522, 0, 0, 2049);
INSERT INTO `npc_vendor` VALUES (18525, 33523, 0, 0, 2059);
INSERT INTO `npc_vendor` VALUES (18525, 33524, 0, 0, 2059);
INSERT INTO `npc_vendor` VALUES (18525, 33527, 0, 0, 2049);
INSERT INTO `npc_vendor` VALUES (18525, 33528, 0, 0, 2059);
INSERT INTO `npc_vendor` VALUES (18525, 33529, 0, 0, 2060);
INSERT INTO `npc_vendor` VALUES (18525, 33530, 0, 0, 2049);
INSERT INTO `npc_vendor` VALUES (18525, 33531, 0, 0, 2059);
INSERT INTO `npc_vendor` VALUES (18525, 33532, 0, 0, 2060);
INSERT INTO `npc_vendor` VALUES (18525, 33534, 0, 0, 2059);
INSERT INTO `npc_vendor` VALUES (18525, 33535, 0, 0, 2060);
INSERT INTO `npc_vendor` VALUES (18525, 33536, 0, 0, 2059);
INSERT INTO `npc_vendor` VALUES (18525, 33537, 0, 0, 2059);
INSERT INTO `npc_vendor` VALUES (18525, 33538, 0, 0, 2049);
INSERT INTO `npc_vendor` VALUES (18525, 33539, 0, 0, 2059);
INSERT INTO `npc_vendor` VALUES (18525, 33540, 0, 0, 2060);
INSERT INTO `npc_vendor` VALUES (18525, 33552, 0, 0, 2049);
INSERT INTO `npc_vendor` VALUES (18525, 33557, 0, 0, 2060);
INSERT INTO `npc_vendor` VALUES (18525, 33559, 0, 0, 2059);
INSERT INTO `npc_vendor` VALUES (18525, 33566, 0, 0, 2049);
INSERT INTO `npc_vendor` VALUES (18525, 33577, 0, 0, 2059);
INSERT INTO `npc_vendor` VALUES (18525, 33578, 0, 0, 2060);
INSERT INTO `npc_vendor` VALUES (18525, 33579, 0, 0, 2049);
INSERT INTO `npc_vendor` VALUES (18525, 33580, 0, 0, 2060);
INSERT INTO `npc_vendor` VALUES (18525, 33582, 0, 0, 2059);
INSERT INTO `npc_vendor` VALUES (18525, 33583, 0, 0, 2059);
INSERT INTO `npc_vendor` VALUES (18525, 33584, 0, 0, 2049);
INSERT INTO `npc_vendor` VALUES (18525, 33585, 0, 0, 2049);
INSERT INTO `npc_vendor` VALUES (18525, 33586, 0, 0, 2059);
INSERT INTO `npc_vendor` VALUES (18525, 33587, 0, 0, 2059);
INSERT INTO `npc_vendor` VALUES (18525, 33588, 0, 0, 2060);
INSERT INTO `npc_vendor` VALUES (18525, 33589, 0, 0, 2060);
INSERT INTO `npc_vendor` VALUES (18525, 33593, 0, 0, 2060);
INSERT INTO `npc_vendor` VALUES (18525, 33810, 0, 0, 2049);
INSERT INTO `npc_vendor` VALUES (18525, 33965, 0, 0, 2049);
INSERT INTO `npc_vendor` VALUES (18525, 33970, 0, 0, 2059);
INSERT INTO `npc_vendor` VALUES (18525, 33972, 0, 0, 2049);
INSERT INTO `npc_vendor` VALUES (18525, 33973, 0, 0, 2059);
INSERT INTO `npc_vendor` VALUES (18525, 33974, 0, 0, 2059);
-- Some Battlemaster Trinkets 2.3 Season 3
INSERT INTO `npc_vendor` VALUES (18525, 33832, 0, 0, 2049);
INSERT INTO `npc_vendor` VALUES (18525, 34049, 0, 0, 2049);
INSERT INTO `npc_vendor` VALUES (18525, 34050, 0, 0, 2049);
INSERT INTO `npc_vendor` VALUES (18525, 34162, 0, 0, 2049);
INSERT INTO `npc_vendor` VALUES (18525, 34163, 0, 0, 2049);
-- 2.4
-- INSERT INTO `npc_vendor` VALUES (18525, 30183, 0, 0, 1642);
-- INSERT INTO `npc_vendor` VALUES (18525, 35321, 0, 0, 2059);
-- INSERT INTO `npc_vendor` VALUES (18525, 35324, 0, 0, 2059);
-- INSERT INTO `npc_vendor` VALUES (18525, 35326, 0, 0, 2049);

-- 2.2 Eye Vendor
DELETE FROM `npc_vendor` WHERE `entry` = 18255 AND `item` IN (33124,33205,33209);
INSERT INTO `npc_vendor` VALUES (18255, 33124, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (18255, 33205, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (18255, 33209, 0, 0, 0);

-- 2.2 Jewelcrafter Gems
DELETE FROM `npc_vendor` WHERE `entry` IN (20242, 23007, 21643, 21655, 21432) AND `item` IN (33305,33156,33158,33157,33160,33159,33155);
INSERT INTO `npc_vendor` VALUES (20242, 33305, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (23007, 33305, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (20242, 33156, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (23007, 33156, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (21643, 33158, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (21655, 33157, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (21643, 33160, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (21432, 33159, 0, 0, 0);
INSERT INTO `npc_vendor` VALUES (21432, 33155, 0, 0, 0);

-- ======================================================
-- Non Blizzlike Stuff
-- ======================================================
--
-- Target Dummys 
--
-- target dummy enhancements
UPDATE `creature_template` SET `scale`='2',`minhealth`='99999999',`maxhealth`='99999999',`subname`='6200 Armor',`rank`='3',`mindmg`='0',`maxdmg`='0',`baseattacktime`='0',`unit_flags`='393216',`mechanic_immune_mask`='787431423',`flags_extra`='65536' WHERE `entry` IN ('1200062','1200063');
UPDATE `creature_template` SET `scale`='2',`minhealth`='99999999',`maxhealth`='99999999',`subname`='7700 Armor',`rank`='3',`mindmg`='0',`maxdmg`='0',`baseattacktime`='0',`unit_flags`='393216',`mechanic_immune_mask`='787431423',`flags_extra`='65536' WHERE `entry` IN ('1200064','1200065');
UPDATE `creature_template` SET `name`='Player Combat Dummy',`maxlevel`='70',`scale`='1',`minhealth`='99999999',`maxhealth`='99999999',`subname`='0 Armor',`armor`='0',`mindmg`='0',`maxdmg`='0',`baseattacktime`='0',`type`='7',`unit_flags`='393216',`dynamicflags`='8',`flags_extra`='65536' WHERE `entry` = 1200058; 
DELETE FROM `creature_template` WHERE `entry` = 1200066;
INSERT INTO `creature_template` VALUES
(1200066,0,NULL,3019,NULL,3019,NULL,'Player Combat Dummy','0 Armor',NULL,70,70,99999999,99999999,0,0,0,1,31,31,0,0.001,1,0,0,0,0,0,2000,0,393216,8,0,0,0,0,0,0,0,0,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,NULL,0,0,'',0,3,0,NULL,NULL,NULL,65536,'npc_theramore_combat_dummy');

-- SET @GUID := 100943;
DELETE FROM `creature` WHERE `guid` BETWEEN 10000100 AND 10000153;
DELETE FROM `creature_addon` WHERE `guid` BETWEEN 10000100 AND 10000153;
INSERT INTO `creature` VALUES (10000100, 1200062, 0, 1, 0, 0, -4927.25, -1189.49, 501.652, 2.7803, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000101, 1200063, 0, 1, 0, 0, -4946.93, -1166.94, 501.706, 5.482, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000102, 1200064, 0, 1, 0, 0, -4913.43, -1155.4, 501.551, 3.0276, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000103, 1200065, 0, 1, 0, 0, -4912.9, -1148.23, 501.467, 3.0669, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000104, 1200058, 0, 1, 0, 0, -4935.55, -1139.53, 501.459, 6.2203, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000105, 1200066, 0, 1, 0, 0, -4935.95, -1149.67, 501.497, 6.2203, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000106, 1200062, 0, 1, 0, 0, -8789.56, 365.582, 101.019, 5.4043, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000107, 1200063, 0, 1, 0, 0, -8795.94, 360.298, 101.019, 5.4043, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000108, 1200064, 0, 1, 0, 0, -8776.03, 353.849, 101.019, 2.2509, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000109, 1200065, 0, 1, 0, 0, -8785, 346.594, 101.019, 2.2509, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000110, 1200058, 0, 1, 0, 0, -8791.59, 340.007, 101.019, 1.2849, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000111, 1200066, 0, 1, 0, 0, -8801.17, 353.903, 101.02, 6.1661, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000112, 1200062, 1, 1, 0, 0, 9968.58, 2258.27, 1335.1, 4.4134, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000113, 1200063, 1, 1, 0, 0, 9979.49, 2259.72, 1333.78, 4.4134, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000114, 1200064, 1, 1, 0, 0, 9936.56, 2257.34, 1334.88, 4.9986, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000115, 1200065, 1, 1, 0, 0, 9924.86, 2258.48, 1333.06, 4.9986, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000116, 1200058, 1, 1, 0, 0, 9932.75, 2323.83, 1336.55, 0.0348, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000117, 1200066, 1, 1, 0, 0, 9968.94, 2324.78, 1336.55, 3.1686, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000118, 1200062, 530, 1, 0, 0, -3850.77, -11311.1, -126.667, 4.2455, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000119, 1200063, 530, 1, 0, 0, -3843.67, -11314.6, -126.597, 4.2455, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000120, 1200064, 530, 1, 0, 0, -3834.93, -11319.1, -126.51, 4.2455, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000121, 1200065, 530, 1, 0, 0, -3828.14, -11322.5, -126.444, 4.2455, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000122, 1200058, 530, 1, 0, 0, -3827.6, -11308.7, -126.387, 4.2455, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000123, 1200066, 530, 1, 0, 0, -3836.45, -11304.3, -126.474, 4.2455, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000124, 1200062, 1, 1, 0, 0, 2160.05, -4635.35, 52.3962, 3.5421, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000125, 1200063, 1, 1, 0, 0, 2154.59, -4624.37, 52.4726, 3.8837, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000126, 1200064, 1, 1, 0, 0, 2113.29, -4625.04, 58.676, 2.8902, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000127, 1200065, 1, 1, 0, 0, 2108.89, -4610.06, 58.7025, 4.1704, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000128, 1200058, 1, 1, 0, 0, 2084.97, -4618.06, 58.6134, 6.2517, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000129, 1200066, 1, 1, 0, 0, 2094.03, -4607.1, 58.6739, 4.8812, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000130, 1200062, 1, 1, 0, 0, -1408.7, -83.2666, 158.935, 0.9691, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000131, 1200063, 1, 1, 0, 0, -1429.37, -86.4949, 161.102, 0.2268, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000132, 1200064, 1, 1, 0, 0, -1416.69, -77.7832, 158.726, 0.973, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000133, 1200065, 1, 1, 0, 0, -1423.67, -73.2963, 157.621, 0.969, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000134, 1200058, 1, 1, 0, 0, -1437.5, -61.7228, 156.943, 6.1683, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000135, 1200066, 1, 1, 0, 0, -1431.51, -68.8002, 156.875, 0.8277, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000136, 1200062, 0, 1, 0, 0, 1779.52, 334.685, -62.2897, 2.4343, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000137, 1200063, 0, 1, 0, 0, 1782.18, 343.369, -62.3427, 2.7916, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000138, 1200064, 0, 1, 0, 0, 1770.62, 350.829, -62.2893, 4.4134, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000139, 1200065, 0, 1, 0, 0, 1763.92, 353.244, -62.2893, 4.9867, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000140, 1200058, 0, 1, 0, 0, 1794.65, 367.026, -60.159, 2.6384, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000141, 1200066, 0, 1, 0, 0, 1794.97, 375.259, -60.159, 3.738, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000142, 1200062, 530, 1, 0, 0, 9854.57, -7391.59, 13.6415, 4.7551, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000143, 1200063, 530, 1, 0, 0, 9847.67, -7392.12, 13.6419, 4.7573, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000144, 1200064, 530, 1, 0, 0, 9836.14, -7388.56, 13.6227, 5.2813, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000145, 1200065, 530, 1, 0, 0, 9832.6, -7394.76, 13.6091, 6.0156, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000146, 1200058, 530, 1, 0, 0, 9870.89, -7391.87, 13.6028, 3.964, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000147, 1200066, 530, 1, 0, 0, 9865.46, -7389.68, 13.618, 4.7355, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000148, 1200062, 1, 1, 0, 0, 16260.9, 16247, 24.6619, 1.9079, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000149, 1200063, 1, 1, 0, 0, 16268.8, 16249.8, 23.6558, 1.9079, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000150, 1200064, 1, 1, 0, 0, 16279.9, 16253.7, 23.8619, 1.9079, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000151, 1200065, 1, 1, 0, 0, 16289.2, 16257, 23.3671, 1.9079, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000152, 1200058, 1, 1, 0, 0, 16287.4, 16266.9, 19.9136, 3.3216, 30, 0, 0, 99999999, 0, 0, 0);
INSERT INTO `creature` VALUES (10000153, 1200066, 1, 1, 0, 0, 16285.3, 16278.5, 17.1308, 3.3216, 30, 0, 0, 99999999, 0, 0, 0);

SET @GUID := 100943;
INSERT INTO `creature_addon` VALUES (10000100, 0, 0, 0, 0, 0, 0, 0, '32610 0');
INSERT INTO `creature_addon` VALUES (10000101, 0, 0, 0, 0, 0, 0, 0, '32610 0');
INSERT INTO `creature_addon` VALUES (10000102, 0, 0, 0, 0, 0, 0, 0, '32610 0');
INSERT INTO `creature_addon` VALUES (10000103, 0, 0, 0, 0, 0, 0, 0, '32610 0');
INSERT INTO `creature_addon` VALUES (10000104, 0, 0, 0, 0, 0, 0, 0, '32610 0');
INSERT INTO `creature_addon` VALUES (10000105, 0, 0, 0, 0, 0, 0, 0, '32610 0');
INSERT INTO `creature_addon` VALUES (10000106, 0, 0, 0, 0, 0, 0, 0, '32610 0');
INSERT INTO `creature_addon` VALUES (10000107, 0, 0, 0, 0, 0, 0, 0, '32610 0');
INSERT INTO `creature_addon` VALUES (10000108, 0, 0, 0, 0, 0, 0, 0, '32610 0');
INSERT INTO `creature_addon` VALUES (10000109, 0, 0, 0, 0, 0, 0, 0, '32610 0');
INSERT INTO `creature_addon` VALUES (10000110, 0, 0, 0, 0, 0, 0, 0, '32610 0');
INSERT INTO `creature_addon` VALUES (10000111, 0, 0, 0, 0, 0, 0, 0, '32610 0');
INSERT INTO `creature_addon` VALUES (10000112, 0, 0, 0, 0, 0, 0, 0, '32610 0');
INSERT INTO `creature_addon` VALUES (10000113, 0, 0, 0, 0, 0, 0, 0, '32610 0');
INSERT INTO `creature_addon` VALUES (10000114, 0, 0, 0, 0, 0, 0, 0, '32610 0');
INSERT INTO `creature_addon` VALUES (10000115, 0, 0, 0, 0, 0, 0, 0, '32610 0');
INSERT INTO `creature_addon` VALUES (10000116, 0, 0, 0, 0, 0, 0, 0, '32610 0');
INSERT INTO `creature_addon` VALUES (10000117, 0, 0, 0, 0, 0, 0, 0, '32610 0');
INSERT INTO `creature_addon` VALUES (10000118, 0, 0, 0, 0, 0, 0, 0, '32610 0');
INSERT INTO `creature_addon` VALUES (10000119, 0, 0, 0, 0, 0, 0, 0, '32610 0');
INSERT INTO `creature_addon` VALUES (10000120, 0, 0, 0, 0, 0, 0, 0, '32610 0');
INSERT INTO `creature_addon` VALUES (10000121, 0, 0, 0, 0, 0, 0, 0, '32610 0');
INSERT INTO `creature_addon` VALUES (10000122, 0, 0, 0, 0, 0, 0, 0, '32610 0');
INSERT INTO `creature_addon` VALUES (10000123, 0, 0, 0, 0, 0, 0, 0, '32610 0');
INSERT INTO `creature_addon` VALUES (10000124, 0, 0, 0, 0, 0, 0, 0, '32609 0');
INSERT INTO `creature_addon` VALUES (10000125, 0, 0, 0, 0, 0, 0, 0, '32609 0');
INSERT INTO `creature_addon` VALUES (10000126, 0, 0, 0, 0, 0, 0, 0, '32609 0');
INSERT INTO `creature_addon` VALUES (10000127, 0, 0, 0, 0, 0, 0, 0, '32609 0');
INSERT INTO `creature_addon` VALUES (10000128, 0, 0, 0, 0, 0, 0, 0, '32609 0');
INSERT INTO `creature_addon` VALUES (10000129, 0, 0, 0, 0, 0, 0, 0, '32609 0');
INSERT INTO `creature_addon` VALUES (10000130, 0, 0, 0, 0, 0, 0, 0, '32609 0');
INSERT INTO `creature_addon` VALUES (10000131, 0, 0, 0, 0, 0, 0, 0, '32609 0');
INSERT INTO `creature_addon` VALUES (10000132, 0, 0, 0, 0, 0, 0, 0, '32609 0');
INSERT INTO `creature_addon` VALUES (10000133, 0, 0, 0, 0, 0, 0, 0, '32609 0');
INSERT INTO `creature_addon` VALUES (10000134, 0, 0, 0, 0, 0, 0, 0, '32609 0');
INSERT INTO `creature_addon` VALUES (10000135, 0, 0, 0, 0, 0, 0, 0, '32609 0');
INSERT INTO `creature_addon` VALUES (10000136, 0, 0, 0, 0, 0, 0, 0, '32609 0');
INSERT INTO `creature_addon` VALUES (10000137, 0, 0, 0, 0, 0, 0, 0, '32609 0');
INSERT INTO `creature_addon` VALUES (10000138, 0, 0, 0, 0, 0, 0, 0, '32609 0');
INSERT INTO `creature_addon` VALUES (10000139, 0, 0, 0, 0, 0, 0, 0, '32609 0');
INSERT INTO `creature_addon` VALUES (10000140, 0, 0, 0, 0, 0, 0, 0, '32609 0');
INSERT INTO `creature_addon` VALUES (10000141, 0, 0, 0, 0, 0, 0, 0, '32609 0');
INSERT INTO `creature_addon` VALUES (10000142, 0, 0, 0, 0, 0, 0, 0, '32609 0');
INSERT INTO `creature_addon` VALUES (10000143, 0, 0, 0, 0, 0, 0, 0, '32609 0');
INSERT INTO `creature_addon` VALUES (10000144, 0, 0, 0, 0, 0, 0, 0, '32609 0');
INSERT INTO `creature_addon` VALUES (10000145, 0, 0, 0, 0, 0, 0, 0, '32609 0');
INSERT INTO `creature_addon` VALUES (10000146, 0, 0, 0, 0, 0, 0, 0, '32609 0');
INSERT INTO `creature_addon` VALUES (10000147, 0, 0, 0, 0, 0, 0, 0, '32609 0');

DELETE FROM `creature` WHERE `guid` IN (1688648,1688649,1688688,1688689,1688690,1688708,1688726,1688744,1688745);
SET @GUID:= 100980;
INSERT INTO `creature` VALUES (@GUID:= @GUID + 0, 1000001, 29, 1, 0, 0, 16.3467, 7.4524, -144.709, 3.1423, 25, 0, 0, 100000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID:= @GUID + 1, 1000003, 29, 1, 0, 0, 15.8870, 2.8598, -144.7090, 3.1423, 25, 0, 0, 100000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID:= @GUID + 1, 1000001, 1, 1, 0, 0, -2909.2058, -256.8643, 52.9412, 3.1921, 25, 0, 0, 100000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID:= @GUID + 1, 1000003, 1, 1, 0, 0, -2909.4821, -251.4043, 52.9412, 3.192, 25, 0, 0, 100000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID:= @GUID + 1, 1000001, 530, 1, 0, 0, 10352.5996, -6362.8139, 34.6794, 2.91885, 25, 0, 0, 100000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID:= @GUID + 1, 1000003, 530, 1, 0, 0, 10352.5, -6357.56, 33.5492, 2.91885, 25, 0, 0, 100000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID:= @GUID + 1, 1000001, 0, 1, 0, 0, -6235.0737, 334.9637, 383.1651, 2.97499, 25, 0, 0, 100000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID:= @GUID + 1, 1000003, 0, 1, 0, 0, -6236.31, 330.716, 382.826, 2.97499, 25, 0, 0, 100000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID:= @GUID + 1, 1000001, 530, 1, 0, 0, -3959.8903, -13927.6533, 101.0719, 2.59143, 25, 0, 0, 100000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID:= @GUID + 1, 1000003, 530, 1, 0, 0, -3958.58, -13932.1, 100.944, 2.59143, 25, 0, 0, 100000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID:= @GUID + 1, 1000001, 1, 1, 0, 0, -611.9669, -4245.6391, 38.9562, 3.14205, 25, 0, 0, 100000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID:= @GUID + 1, 1000003, 1, 1, 0, 0, -612.4235, -4255.2246, 38.9562, 3.14205, 25, 0, 0, 100000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID:= @GUID + 1, 1000001, 0, 1, 0, 0, 1656.5402, 1674.1586, 120.7188, 0.0073, 25, 0, 0, 100000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID:= @GUID + 1, 1000003, 0, 1, 0, 0, 1656.4736, 1683.2025, 120.7188, 0.0073, 25, 0, 0, 100000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID:= @GUID + 1, 1000001, 1, 1, 0, 0, 10318.0273, 839.0876, 1326.4888, 4.9127, 25, 0, 0, 100000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID:= @GUID + 1, 1000003, 1, 1, 0, 0, 10324.4111, 837.8303, 1326.3692, 4.0056, 25, 0, 0, 100000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID:= @GUID + 1, 1000001, 0, 1, 0, 0, -8946.3330, -140.3869, 83.5640, 3.1573, 25, 0, 0, 100000, 0, 0, 0);
INSERT INTO `creature` VALUES (@GUID:= @GUID + 1, 1000003, 0, 1, 0, 0, -8946.46, -132.317, 83.6775, 3.19178, 25, 0, 0, 100000, 0, 0, 0);

Looking4Group / L4G_Core

Shattrath #441

Sources:

Arena:

PvP System