/*
* Arena Tournament Server
* Copyright (C) 2008 Arena Tournament Team <Jur0 & sT@N>
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Affero General Public License for more details.
*
* You should have received a copy of the GNU Affero General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*
*/
delete from creature_proto where entry = '600008';
delete from creature_names where entry = '600008';
delete from vendors where item in(30450, 30449, 30447, 30448, 30446, 30720, 30664, 30665, 33067, 33065, 33055, 33068, 33066, 33056, 33064, 33057, 28378, 28377, 29369, 29367, 30350, 30346, 30059, 30018, 30008, 30022, 30017, 30015, 30061, 29922, 28793, 29997, 33058, 30110, 28790, 29920, 30109, 30052, 28791, 33054, 29287, 29290, 29279, 29283, 28288, 27896, 27770, 28830, 28823, 28789, 30663, 30619, 27683, 28190, 30626, 30620, 30627, 30735, 29375, 29382, 28777, 28672, 28660, 30098, 24258, 29992, 29989, 29994, 24259, 29373, 29379, 29368, 29374, 29381, 29370, 29376, 29383, 28785, 23766, 23765, 24276, 24274, 29536, 29535) and entry = '600008';
INSERT INTO creature_names VALUES(600008, 'Accessories Vendor', 'Test Vendor', '', 0, 7, 0, 1, 0, 0, 10045, 0, 0, 0, 1, 1, 1, 0);
INSERT INTO creature_proto VALUES(600008, 70, 70, 1741, 9212, 9212, 0, 1, 128, 2000, 0, 624, 871, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 360000, 6807, 0, 0, 0, 0, 0, 0, 1.5, 1, '', 0, 0, 0, 0, 2.5, 8, 14, 0);
INSERT INTO vendors VALUES
('600008','33067','1','-1','0'),
('600008','33065','1','-1','0'),
('600008','33068','1','-1','0'),
('600008','33066','1','-1','0'),
('600008','33056','1','-1','0'),
('600008','33064','1','-1','0'),
('600008','33057','1','-1','0'),
('600008','28378','1','-1','0'),
('600008','28377','1','-1','0'),
('600008','29369','1','-1','0'),
('600008','29367','1','-1','0'),
('600008','30350','1','-1','0'),
('600008','30346','1','-1','0'),
('600008','30059','1','-1','0'),
('600008','30018','1','-1','0'),
('600008','30008','1','-1','0'),
('600008','30022','1','-1','0'),
('600008','30017','1','-1','0'),
('600008','30015','1','-1','0'),
('600008','30061','1','-1','0'),
('600008','29922','1','-1','0'),
('600008','30450','1','-1','0'),
('600008','30449','1','-1','0'),
('600008','30447','1','-1','0'),
('600008','30448','1','-1','0'),
('600008','30446','1','-1','0'),
('600008','30720','1','-1','0'),
('600008','30664','1','-1','0'),
('600008','30665','1','-1','0'),
('600008','28793','1','-1','0'),
('600008','33055','1','-1','0'),
('600008','29997','1','-1','0'),
('600008','33058','1','-1','0'),
('600008','30110','1','-1','0'),
('600008','28790','1','-1','0'),
('600008','29920','1','-1','0'),
('600008','30109','1','-1','0'),
('600008','30052','1','-1','0'),
('600008','28791','1','-1','0'),
('600008','33054','1','-1','0'),
('600008','29287','1','-1','0'),
('600008','29290','1','-1','0'),
('600008','29279','1','-1','0'),
('600008','29283','1','-1','0'),
('600008','28288','1','-1','0'),
('600008','27896','1','-1','0'),
('600008','27770','1','-1','0'),
('600008','28830','1','-1','0'),
('600008','28823','1','-1','0'),
('600008','28789','1','-1','0'),
('600008','30663','1','-1','0'),
('600008','30619','1','-1','0'),
('600008','27683','1','-1','0'),
('600008','28190','1','-1','0'),
('600008','30626','1','-1','0'),
('600008','30620','1','-1','0'),
('600008','30627','1','-1','0'),
('600008','30735','1','-1','0'),
('600008','29375','1','-1','0'),
('600008','29382','1','-1','0'),
('600008','28777','1','-1','0'),
('600008','28672','1','-1','0'),
('600008','28660','1','-1','0'),
('600008','30098','1','-1','0'),
('600008','24258','1','-1','0'),
('600008','29992','1','-1','0'),
('600008','29989','1','-1','0'),
('600008','29994','1','-1','0'),
('600008','24259','1','-1','0'),
('600008','29373','1','-1','0'),
('600008','29379','1','-1','0'),
('600008','29368','1','-1','0'),
('600008','29374','1','-1','0'),
('600008','29381','1','-1','0'),
('600008','29370','1','-1','0'),
('600008','29376','1','-1','0'),
('600008','29383','1','-1','0'),
('600008','28785','1','-1','0'),
('600008','23766','1','-1','0'),
('600008','23765','1','-1','0'),
('600008','24276','1','-1','0'),
('600008','24274','1','-1','0'),
('600008','29536','1','-1','0'),
('600008','29535','1','-1','0');
/*
* Arena Tournament Server
* Copyright (C) 2008 Arena Tournament Team <Jur0 & sT@N>
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Affero General Public License for more details.
*
* You should have received a copy of the GNU Affero General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*
*/
delete from creature_proto where entry = '600004';
delete from creature_names where entry = '600004';
delete from vendors where item in (32997, 32979, 32980, 32981, 32799, 32811, 32787, 32807, 32820, 32795, 29990, 30050, 30064, 29986, 30020, 29972, 29987, 29918, 29977, 30107, 30056, 30100, 30079, 30067, 32516, 32090, 32089, 31973, 31974, 31975, 31976, 31977, 31979, 31980, 31981, 31982, 31983, 30211, 30212, 30213, 30215, 30214, 32047, 32048, 32049, 32050, 32051, 30206, 30205, 30207, 30210, 30196, 32015, 32016, 32017, 32018, 32019, 32034, 32035, 32036, 32037, 32038, 30153, 30152, 30151, 30154, 30150, 30160, 30161, 30162, 30159, 30163) and entry = '600004';
INSERT INTO creature_names VALUES (600004, 'Cloth Armor Vendor', 'Test Vendor', '', 0, 7, 0, 1, 0, 0, 18487, 0, 0, 0, 1, 1, 1, 0);
INSERT INTO creature_proto VALUES (600004, 70, 70, 1741, 9212, 9212, 0, 1, 128, 2000, 0, 624, 871, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 360000, 6807, 0, 0, 0, 0, 0, 0, 1.5, 1, '', 0, 0, 0, 0, 2.5, 8, 14, 0);
INSERT INTO vendors VALUES
('600004','32979','1','-1','0'),
('600004','32980','1','-1','0'),
('600004','32981','1','-1','0'),
('600004','32799','1','-1','0'),
('600004','32811','1','-1','0'),
('600004','32787','1','-1','0'),
('600004','32807','1','-1','0'),
('600004','32820','1','-1','0'),
('600004','32795','1','-1','0'),
('600004','29990','1','-1','0'),
('600004','30050','1','-1','0'),
('600004','30064','1','-1','0'),
('600004','29986','1','-1','0'),
('600004','30020','1','-1','0'),
('600004','29972','1','-1','0'),
('600004','29987','1','-1','0'),
('600004','29918','1','-1','0'),
('600004','29977','1','-1','0'),
('600004','30107','1','-1','0'),
('600004','30056','1','-1','0'),
('600004','30100','1','-1','0'),
('600004','30079','1','-1','0'),
('600004','30067','1','-1','0'),
('600004','32516','1','-1','0'),
('600004','32090','1','-1','0'),
('600004','32089','1','-1','0'),
('600004','31973','1','-1','0'),
('600004','31974','1','-1','0'),
('600004','31975','1','-1','0'),
('600004','31976','1','-1','0'),
('600004','31977','1','-1','0'),
('600004','31979','1','-1','0'),
('600004','31980','1','-1','0'),
('600004','31981','1','-1','0'),
('600004','31982','1','-1','0'),
('600004','31983','1','-1','0'),
('600004','30211','1','-1','0'),
('600004','30212','1','-1','0'),
('600004','30213','1','-1','0'),
('600004','30215','1','-1','0'),
('600004','30214','1','-1','0'),
('600004','32047','1','-1','0'),
('600004','32048','1','-1','0'),
('600004','32049','1','-1','0'),
('600004','32050','1','-1','0'),
('600004','32051','1','-1','0'),
('600004','30206','1','-1','0'),
('600004','30205','1','-1','0'),
('600004','30207','1','-1','0'),
('600004','30210','1','-1','0'),
('600004','30196','1','-1','0'),
('600004','32015','1','-1','0'),
('600004','32016','1','-1','0'),
('600004','32017','1','-1','0'),
('600004','32018','1','-1','0'),
('600004','32019','1','-1','0'),
('600004','32034','1','-1','0'),
('600004','32035','1','-1','0'),
('600004','32036','1','-1','0'),
('600004','32037','1','-1','0'),
('600004','32038','1','-1','0'),
('600004','30153','1','-1','0'),
('600004','30152','1','-1','0'),
('600004','30151','1','-1','0'),
('600004','30154','1','-1','0'),
('600004','30150','1','-1','0'),
('600004','30160','1','-1','0'),
('600004','30161','1','-1','0'),
('600004','30162','1','-1','0'),
('600004','30159','1','-1','0'),
('600004','30163','1','-1','0');
/*
* Arena Tournament Server
* Copyright (C) 2008 Arena Tournament Team <Jur0 & sT@N>
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Affero General Public License for more details.
*
* You should have received a copy of the GNU Affero General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*
*/
delete from creature_proto where entry in ('600000');
delete from creature_names where entry in ('600000');
delete from vendors where item in (35396, 35397, 35398, 35399, 35400, 35417, 35418, 35419, 35420, 35421, 35422, 35423, 35424, 35425, 35426, 35427, 35428, 35429, 35430, 35431, 35432, 35433, 35434, 35435, 35436, 35437, 35438, 35439, 35440, 35441, 35442, 35443, 35444, 35445, 35446, 35447, 35448, 35449, 35450, 35451, 35452, 35453, 35454, 35455, 35456, 35457, 35458, 35459, 35460, 35461, 35462, 29190, 29189, 29191, 29192, 29186, 30846, 28886, 28887, 28888, 28889, 35728, 35731, 35730, 35729);
INSERT INTO `creature_names` VALUES ('600000', 'Enchantments Vendor', '', '', '0', '7', '0', '1', '0', '0', '18487', '0', '0', '0', '1', '1', '1', '0');
INSERT INTO creature_proto VALUES (600000, 70, 70, 1741, 9212, 9212, 0, 1, 128, 2000, 0, 624, 871, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 360000, 6807, 0, 0, 0, 0, 0, 0, 1.5, 1, '', 0, 0, 0, 0, 2.5, 8, 14, 0);
INSERT INTO vendors VALUES
('600000','35452','1','-1','0'),
('600000','35453','1','-1','0'),
('600000','35454','1','-1','0'),
('600000','35455','1','-1','0'),
('600000','35456','1','-1','0'),
('600000','35457','1','-1','0'),
('600000','35458','1','-1','0'),
('600000','35459','1','-1','0'),
('600000','35460','1','-1','0'),
('600000','35461','1','-1','0'),
('600000','35462','1','-1','0'),
('600000','35422','1','-1','0'),
('600000','35423','1','-1','0'),
('600000','35424','1','-1','0'),
('600000','35425','1','-1','0'),
('600000','35426','1','-1','0'),
('600000','35427','1','-1','0'),
('600000','35428','1','-1','0'),
('600000','35429','1','-1','0'),
('600000','35430','1','-1','0'),
('600000','35431','1','-1','0'),
('600000','35396','1','-1','0'),
('600000','35397','1','-1','0'),
('600000','35398','1','-1','0'),
('600000','35399','1','-1','0'),
('600000','35400','1','-1','0'),
('600000','35417','1','-1','0'),
('600000','35418','1','-1','0'),
('600000','35419','1','-1','0'),
('600000','35420','1','-1','0'),
('600000','35421','1','-1','0'),
('600000','35432','1','-1','0'),
('600000','35433','1','-1','0'),
('600000','35434','1','-1','0'),
('600000','35437','1','-1','0'),
('600000','35435','1','-1','0'),
('600000','35436','1','-1','0'),
('600000','35438','1','-1','0'),
('600000','35439','1','-1','0'),
('600000','35440','1','-1','0'),
('600000','35441','1','-1','0'),
('600000','35442','1','-1','0'),
('600000','35443','1','-1','0'),
('600000','35444','1','-1','0'),
('600000','35445','1','-1','0'),
('600000','35446','1','-1','0'),
('600000','35447','1','-1','0'),
('600000','35448','1','-1','0'),
('600000','35449','1','-1','0'),
('600000','35450','1','-1','0'),
('600000','35451','1','-1','0'),
('600000','29190','1','-1','0'),
('600000','29189','1','-1','0'),
('600000','29191','1','-1','0'),
('600000','29192','1','-1','0'),
('600000','29186','1','-1','0'),
('600000','30846','1','-1','0'),
('600000','28886','1','-1','0'),
('600000','28887','1','-1','0'),
('600000','28888','1','-1','0'),
('600000','28889','1','-1','0'),
('600000','35728','1','-1','0'),
('600000','35731','1','-1','0'),
('600000','35730','1','-1','0'),
('600000','35729','1','-1','0');
/*items NTY */
INSERT IGNORE INTO `items` (`entry`, `class`, `subclass`, `field4`, `name1`, `name2`, `name3`, `name4`, `displayid`, `quality`, `flags`, `buyprice`, `sellprice`, `inventorytype`, `allowableclass`, `allowablerace`, `itemlevel`, `requiredlevel`, `RequiredSkill`, `RequiredSkillRank`, `RequiredSkillSubRank`, `RequiredPlayerRank1`, `RequiredPlayerRank2`, `RequiredFaction`, `RequiredFactionStanding`, `Unique`, `maxcount`, `ContainerSlots`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `dmg_min3`, `dmg_max3`, `dmg_type3`, `dmg_min4`, `dmg_max4`, `dmg_type4`, `dmg_min5`, `dmg_max5`, `dmg_type5`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `range`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `page_id`, `page_language`, `page_material`, `quest_id`, `lock_id`, `lock_material`, `sheathID`, `randomprop`, `unk203_1`, `block`, `itemset`, `MaxDurability`, `ZoneNameID`, `mapid`, `bagfamily`, `TotemCategory`, `socket_color_1`, `unk201_3`, `socket_color_2`, `unk201_5`, `socket_color_3`, `unk201_7`, `socket_bonus`, `GemProperties`, `ItemExtendedCost`, `ArenaRankRequirement`, `ReqDisenchantSkill`, `unk2`) VALUES
('35452',0,8,-1,'Enchant Weapon - Battlemaster','','','','48854',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46527,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35453',0,8,-1,'Enchant Weapon - Greater Agility','','','','48855',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46529,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35454',0,8,-1,'Enchant Weapon - Major Healing','','','','48856',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46531,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35455',0,8,-1,'Enchant Weapon - Major Intellect','','','','21204',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46532,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35456',0,8,-1,'Enchant Weapon - Major Spellpower','','','','48857',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46533,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35457',0,8,-1,'Enchant Weapon - Major Striking','','','','48858',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46535,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35458',0,8,-1,'Enchant Weapon - Mongoose','','','','48859',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46536,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35459',0,8,-1,'Enchant Weapon - Potency','','','','48860',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46537,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35460',0,8,-1,'Enchant Weapon - Soulfrost','','','','48861',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46538,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35461',0,8,-1,'Enchant Weapon - Spellsurge','','','','30995',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46539,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35462',0,8,-1,'Enchant Weapon - Sunfire','','','','48862',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46540,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35422',0,8,-1,'Enchant Bracer - Major Defense','','','','48821',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46495,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35423',0,8,-1,'Enchant Bracer - Major Intellect','','','','48823',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46496,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35424',0,8,-1,'Enchant Bracer - Restore Mana Prime','','','','48826',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46497,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35425',0,8,-1,'Enchant Bracer - Spellpower','','','','48827',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46498,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35426',0,8,-1,'Enchant Bracer - Stats','','','','48828',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46499,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35427',0,8,-1,'Enchant Bracer - Superior Healing','','','','48829',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46500,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35428',0,8,-1,'Enchant Chest - Exceptional Health','','','','48830',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46501,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35429',0,8,-1,'Enchant Chest - Exceptional Stats','','','','48831',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46502,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35430',0,8,-1,'Enchant Chest - Major Resilience','','','','48832',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46503,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35431',0,8,-1,'Enchant Chest - Major Spirit','','','','48833',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46504,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35396',0,8,-1,'Enchant 2H Weapon - Major Agility','','','','48809',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46461,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35397',0,8,-1,'Enchant 2H Weapon - Savagery','','','','16598',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46462,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35398',0,8,-1,'Enchant Boots - Boar\'s Speed','','','','48810',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46470,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35399',0,8,-1,'Enchant Boots - Cat\'s Swiftness','','','','48811',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46471,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35400',0,8,-1,'Enchant Boots - Dexterity','','','','48812',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46472,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35417',0,8,-1,'Enchant Boots - Fortitude','','','','48813',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46490,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35418',0,8,-1,'Enchant Boots - Surefooted','','','','48814',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46491,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35419',0,8,-1,'Enchant Boots - Vitality','','','','48819',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46492,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35420',0,8,-1,'Enchant Bracer - Brawn','','','','48820',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46493,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35421',0,8,-1,'Enchant Bracer - Fortitude','','','','48822',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46494,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35432',0,8,-1,'Enchant Cloak - Greater Agility','','','','48834',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46505,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35433',0,8,-1,'Enchant Cloak - Greater Arcane Resistance','','','','48835',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46506,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35434',0,8,-1,'Enchant Cloak - Greater Shadow Resistance','','','','48836',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46507,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35437',0,8,-1,'Enchant Cloak - Major Armor','','','','48837',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46510,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35435',0,8,-1,'Enchant Cloak - Major Resistance','','','','48838',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46508,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35436',0,8,-1,'Enchant Cloak - Spell Penetration','','','','48839',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46509,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35438',0,8,-1,'Enchant Gloves - Assault','','','','48840',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46511,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35439',0,8,-1,'Enchant Gloves - Blasting','','','','48841',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46512,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35440',0,8,-1,'Enchant Gloves - Major Healing','','','','48842',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46513,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35441',0,8,-1,'Enchant Gloves - Major Spellpower','','','','48843',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46514,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35442',0,8,-1,'Enchant Gloves - Major Strength','','','','48844',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46515,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35443',0,8,-1,'Enchant Gloves - Spell Strike','','','','48845',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46516,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35444',0,8,-1,'Enchant Ring - Healing Power','','','','43104',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46517,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35445',0,8,-1,'Enchant Ring - Spellpower','','','','48846',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46518,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35446',0,8,-1,'Enchant Ring - Stats','','','','48847',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46519,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35447',0,8,-1,'Enchant Ring - Striking','','','','48848',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46520,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35448',0,8,-1,'Enchant Shield - Intellect','','','','48849',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46522,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35449',0,8,-1,'Enchant Shield - Major Stamina','','','','48850',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46524,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35450',0,8,-1,'Enchant Shield - Resistance','','','','48852',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46525,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35451',0,8,-1,'Enchant Shield - Shield Block','','','','48853',1,64,2600,650,0,-1,-1,70,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',46526,0,-1,1000,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,'',0,0,0,0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('29190',12,0,-1,'Glyph of Renewal','','','','40398',2,64,1000000,250000,0,-1,-1,70,70,0,0,0,0,0,947,6,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',35445,0,-1,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,1,'',0,0,0,0,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('29189',12,0,-1,'Glyph of Renewal','','','','40398',2,64,1000000,250000,0,-1,-1,70,70,0,0,0,0,0,946,6,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',35445,0,-1,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,1,'',0,0,0,0,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('29191',12,0,-1,'Glyph of Power','','','','40399',2,64,1000000,250000,0,-1,-1,70,70,0,0,0,0,0,935,6,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',35447,0,-1,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,1,'',0,0,0,0,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('29192',12,0,-1,'Glyph of Ferocity','','','','40400',2,64,1000000,250000,0,-1,-1,70,70,0,0,0,0,0,942,6,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',35452,0,-1,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,1,'',0,0,0,0,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('29186',12,0,-1,'Glyph of the Defender','','','','40396',2,64,1000000,250000,0,-1,-1,70,70,0,0,0,0,0,989,6,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',35443,0,-1,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,1,'',0,0,0,0,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('30846',12,0,-1,'Glyph of the Outcast','','','','42960',2,32832,1000000,250000,0,-1,-1,70,70,0,0,0,0,0,1011,6,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',37891,0,-1,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,1,'',0,0,0,0,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('28886',12,0,-1,'Greater Inscription of Discipline','','','','40107',3,64,0,0,0,-1,-1,70,70,0,0,0,0,0,932,7,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',35406,0,-1,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,1,'',0,0,0,0,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('28887',12,0,-1,'Greater Inscription of Faith','','','','40109',3,64,0,0,0,-1,-1,70,70,0,0,0,0,0,932,7,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',35404,0,-1,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,1,'',0,0,0,0,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('28888',12,0,-1,'Greater Inscription of Vengeance','','','','40112',3,64,0,0,0,-1,-1,70,70,0,0,0,0,0,932,7,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',35417,0,-1,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,1,'',0,0,0,0,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('28889',12,0,-1,'Greater Inscription of Warding','','','','40082',3,64,0,0,0,-1,-1,70,70,0,0,0,0,0,932,7,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',35402,0,-1,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,1,'',0,0,0,0,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35728',12,0,-1,'Greater Inscription of the Blade','','','','40103',3,64,0,0,0,-1,-1,70,70,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',35439,0,-1,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,1,'',0,0,0,0,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35729',12,0,-1,'Greater Inscription of the Knight','','','','40104',3,64,0,0,0,-1,-1,70,70,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',35433,0,-1,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,1,'',0,0,0,0,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35730',12,0,-1,'Greater Inscription of the Oracle','','','','40106',3,64,0,0,0,-1,-1,70,70,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',35435,0,-1,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,1,'',0,0,0,0,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0),
('35731',12,0,-1,'Greater Inscription of the Orb','','','','40394',3,64,0,0,0,-1,-1,70,70,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,'0','0',0,0,0,0,0,0,0,0,0,0,'0',35437,0,-1,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,0,0,0,-1,0,-1,1,'',0,0,0,0,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0);
/*
* Arena Tournament Server
* Copyright (C) 2008 Arena Tournament Team <Jur0 & sT@N>
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Affero General Public License for more details.
*
* You should have received a copy of the GNU Affero General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*
*/
delete from creature_proto where entry = '600001';
delete from creature_names where entry = '600001';
delete from vendors where item in (25897, 25890, 25901, 25896, 25894, 25899, 25895, 25893, 32409, 28557, 25898, 34220, 24031, 24036, 24032, 32410, 24027, 24028, 24030, 24029, 24037, 24035, 24047, 24053, 24051, 24033, 24039, 24050, 31861, 24048, 31868, 24061, 24060, 24065, 24067, 24066, 31867, 24058, 24059, 24056, 24057, 24055, 24054, 31863, 31865, 33782, 32640, 32641, 32637, 32638, 32635, 32639, 32634, 32636) and entry = '600001';
INSERT INTO creature_names VALUES (600001, 'Gems Vendor', 'Test Vendor', '', 0, 7, 0, 1, 0, 0, 18487, 0, 0, 0, 1, 1, 1, 0);
INSERT INTO creature_proto VALUES (600001, 70, 70, 1741, 9212, 9212, 0, 1, 128, 2000, 0, 624, 871, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 360000, 6807, 0, 0, 0, 0, 0, 0, 1.5, 1, '', 0, 0, 0, 0, 2.5, 8, 14, 0);
INSERT INTO vendors VALUES
('600001','25897','1','-1','0'),
('600001','25890','1','-1','0'),
('600001','25901','1','-1','0'),
('600001','25896','1','-1','0'),
('600001','25894','1','-1','0'),
('600001','25899','1','-1','0'),
('600001','25895','1','-1','0'),
('600001','25893','1','-1','0'),
('600001','32409','1','-1','0'),
('600001','28557','1','-1','0'),
('600001','25898','1','-1','0'),
('600001','34220','1','-1','0'),
('600001','24031','1','-1','0'),
('600001','24036','1','-1','0'),
('600001','24032','1','-1','0'),
('600001','32410','1','-1','0'),
('600001','24027','1','-1','0'),
('600001','24028','1','-1','0'),
('600001','24030','1','-1','0'),
('600001','24029','1','-1','0'),
('600001','24037','1','-1','0'),
('600001','24035','1','-1','0'),
('600001','24047','1','-1','0'),
('600001','24053','1','-1','0'),
('600001','24051','1','-1','0'),
('600001','24033','1','-1','0'),
('600001','24039','1','-1','0'),
('600001','24050','1','-1','0'),
('600001','31861','1','-1','0'),
('600001','24048','1','-1','0'),
('600001','31868','1','-1','0'),
('600001','24061','1','-1','0'),
('600001','24060','1','-1','0'),
('600001','24065','1','-1','0'),
('600001','24067','1','-1','0'),
('600001','24066','1','-1','0'),
('600001','31867','1','-1','0'),
('600001','24058','1','-1','0'),
('600001','24059','1','-1','0'),
('600001','24056','1','-1','0'),
('600001','24057','1','-1','0'),
('600001','24055','1','-1','0'),
('600001','24054','1','-1','0'),
('600001','31863','1','-1','0'),
('600001','31865','1','-1','0'),
('600001','33782','1','-1','0'),
('600001','32640','1','-1','0'),
('600001','32641','1','-1','0'),
('600001','32637','1','-1','0'),
('600001','32638','1','-1','0'),
('600001','32635','1','-1','0'),
('600001','32639','1','-1','0'),
('600001','32634','1','-1','0'),
('600001','32636','1','-1','0');
/*
* Arena Tournament Server
* Copyright (C) 2008 Arena Tournament Team <Jur0 & sT@N>
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Affero General Public License for more details.
*
* You should have received a copy of the GNU Affero General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*
*/
/*TODO: Find the real DisplayID as on the TTR.*/
/*Item Buyprice Updates*/
UPDATE items SET buyprice = '5000' WHERE entry = '22147';
UPDATE items SET buyprice = '2000' WHERE entry = '17030';
UPDATE items SET buyprice = '1000' WHERE entry = '17029';
UPDATE items SET buyprice = '3000' WHERE entry = '21177';
UPDATE items SET buyprice = '25' WHERE entry = '5140';
UPDATE items SET buyprice = '1000' WHERE entry = '17020';
UPDATE items SET buyprice = '2000' WHERE entry = '17033';
UPDATE items SET buyprice = '1500' WHERE entry = '22148';
UPDATE items SET buyprice = '5000' WHERE entry = '5565';
UPDATE items SET buyprice = '12000' WHERE entry = '21991';
UPDATE items SET buyprice = '8000' WHERE entry = '29449';
UPDATE items SET buyprice = '20000' WHERE entry = '22832';
UPDATE items SET buyprice = '2500' WHERE entry = '32453';
UPDATE items SET buyprice = '2500' WHERE entry = '29450';
UPDATE items SET buyprice = '30' WHERE entry = '17057';
UPDATE items SET buyprice = '20000' WHERE entry = '22829';
UPDATE items SET buyprice = '0' WHERE entry = '6265';
UPDATE items SET buyprice = '8000' WHERE entry = '29451';
UPDATE items SET buyprice = '0' WHERE entry = '29471';
UPDATE items SET buyprice = '30' WHERE entry = '17058';
UPDATE items SET buyprice = '30' WHERE entry = '17056';
UPDATE items SET buyprice = '10000' WHERE entry = '34582';
UPDATE items SET buyprice = '10000' WHERE entry = '34581';
/*Deletion Queries*/
DELETE FROM creature_proto WHERE entry = '26304';
DELETE FROM creature_names WHERE entry = '26304';
DELETE FROM vendors WHERE item IN (22147, 17030, 17029, 21177, 5140, 17020, 17033, 22148, 5565, 21991, 29449, 22832, 32453, 29450, 17057, 22829, 6265, 29451, 29471, 17058, 17056, 34582, 34581) AND entry = '26304';
/*Inserts*/
INSERT INTO creature_names VALUES (26304, 'General Goods Vendor', '', '', 0, 7, 0, 1, 0, 0, 18487, 0, 0, 0, 1, 1, 1, 0);
INSERT INTO creature_proto VALUES (26304, 70, 70, 1741, 9212, 9212, 0, 1, 128, 2000, 0, 624, 871, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 360000, 6807, 0, 0, 0, 0, 0, 0, 1.5, 1, '', 0, 0, 0, 0, 2.5, 8, 14, 0);
INSERT INTO vendors VALUES
('26304','22147','1','-1','0'),
('26304','17030','1','-1','0'),
('26304','17029','1','-1','0'),
('26304','21177','20','-1','0'),
('26304','5140','1','-1','0'),
('26304','17020','1','-1','0'),
('26304','17033','1','-1','0'),
('26304','22148','1','-1','0'),
('26304','5565','1','-1','0'),
('26304','21991','1','-1','0'),
('26304','29449','5','-1','0'),
('26304','22832','1','-1','0'),
('26304','32453','5','-1','0'),
('26304','29450','5','-1','0'),
('26304','17057','1','-1','0'),
('26304','22829','1','-1','0'),
('26304','6265','1','-1','0'),
('26304','29451','5','-1','0'),
('26304','29471','1','-1','0'),
('26304','17058','1','-1','0'),
('26304','17056','1','-1','0'),
('26304','34582','200','-1','0'),
('26304','34581','200','-1','0');
/*
* Arena Tournament Server
* Copyright (C) 2008 Arena Tournament Team <Jur0 & sT@N>
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Affero General Public License for more details.
*
* You should have received a copy of the GNU Affero General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*
*/
delete from creature_proto where entry = '600002';
delete from creature_names where entry = '600002';
delete from vendors where item in (32798, 32786, 32810, 32800, 32788, 32812, 32802, 32790, 32814, 32808, 32796, 32821, 30106, 30029, 30101, 30060, 29984, 29947, 30075, 30062, 28803, 28828, 29966, 29995, 30092, 30111, 30055, 32088, 32087,31987, 31988, 31989, 31990, 31991, 31967, 31968, 31969, 31971, 31972, 32056, 32057, 32058, 32059, 32060, 30222, 30223, 30228, 30229, 30230, 30216, 30217, 30219, 30220, 30221, 30231, 30232, 30233, 30234, 30235, 30144, 30145, 30146, 30148, 30149, 31998, 31999, 32000, 32001, 32002) and entry = '600002';
INSERT INTO creature_names VALUES (600002, 'Leather Armor Vendor', 'Test Vendor', '', 0, 7, 0, 1, 0, 0, 18487, 0, 0, 0, 1, 1, 1, 0);
INSERT INTO creature_proto VALUES (600002, 70, 70, 1741, 9212, 9212, 0, 1, 128, 2000, 0, 624, 871, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 360000, 6807, 0, 0, 0, 0, 0, 0, 1.5, 1, '', 0, 0, 0, 0, 2.5, 8, 14, 0);
INSERT INTO vendors VALUES
('600002','32798','1','-1','0'),
('600002','32786','1','-1','0'),
('600002','32810','1','-1','0'),
('600002','32800','1','-1','0'),
('600002','32788','1','-1','0'),
('600002','32812','1','-1','0'),
('600002','32802','1','-1','0'),
('600002','32790','1','-1','0'),
('600002','32814','1','-1','0'),
('600002','32808','1','-1','0'),
('600002','32796','1','-1','0'),
('600002','32821','1','-1','0'),
('600002','30106','1','-1','0'),
('600002','30029','1','-1','0'),
('600002','30101','1','-1','0'),
('600002','30060','1','-1','0'),
('600002','29984','1','-1','0'),
('600002','29947','1','-1','0'),
('600002','30075','1','-1','0'),
('600002','30062','1','-1','0'),
('600002','28803','1','-1','0'),
('600002','28828','1','-1','0'),
('600002','29966','1','-1','0'),
('600002','29995','1','-1','0'),
('600002','30092','1','-1','0'),
('600002','30111','1','-1','0'),
('600002','30055','1','-1','0'),
('600002','32088','1','-1','0'),
('600002','32087','1','-1','0'),
('600002','31987','1','-1','0'),
('600002','31988','1','-1','0'),
('600002','31989','1','-1','0'),
('600002','31990','1','-1','0'),
('600002','31991','1','-1','0'),
('600002','31967','1','-1','0'),
('600002','31968','1','-1','0'),
('600002','31969','1','-1','0'),
('600002','31971','1','-1','0'),
('600002','31972','1','-1','0'),
('600002','32056','1','-1','0'),
('600002','32057','1','-1','0'),
('600002','32058','1','-1','0'),
('600002','32059','1','-1','0'),
('600002','32060','1','-1','0'),
('600002','30222','1','-1','0'),
('600002','30223','1','-1','0'),
('600002','30228','1','-1','0'),
('600002','30229','1','-1','0'),
('600002','30230','1','-1','0'),
('600002','30216','1','-1','0'),
('600002','30217','1','-1','0'),
('600002','30219','1','-1','0'),
('600002','30220','1','-1','0'),
('600002','30221','1','-1','0'),
('600002','30231','1','-1','0'),
('600002','30232','1','-1','0'),
('600002','30233','1','-1','0'),
('600002','30234','1','-1','0'),
('600002','30235','1','-1','0'),
('600002','30144','1','-1','0'),
('600002','30145','1','-1','0'),
('600002','30146','1','-1','0'),
('600002','30148','1','-1','0'),
('600002','30149','1','-1','0'),
('600002','31998','1','-1','0'),
('600002','31999','1','-1','0'),
('600002','32000','1','-1','0'),
('600002','32001','1','-1','0'),
('600002','32002','1','-1','0');
/*
* Arena Tournament Server
* Copyright (C) 2008 Arena Tournament Team <Jur0 & sT@N>
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Affero General Public License for more details.
*
* You should have received a copy of the GNU Affero General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*
*/
delete from creature_proto where entry = '600003';
delete from creature_names where entry = '600003';
delete from vendors where item in (32997, 32998, 32999, 32809, 32797, 32785, 32816, 32803, 32792, 32817, 32804, 32792, 30104, 30026, 30047, 30097, 29921, 30030, 30068, 28827, 29985, 29991, 29951, 29976, 30054, 30091, 30066, 30085, 32085, 32086, 31960, 31961, 31962, 31963, 31964, 30139, 30140, 30141, 30142, 30143, 30185, 30189, 30190, 30192, 30194, 30164, 30165, 30166, 30167, 30168, 30169, 30170, 30171, 30172, 30173,32004, 32005, 32006, 32007, 32008, 32009, 32010, 32011, 32012, 32013, 32029, 32030, 32031, 32032, 32033) and entry = '600003';
INSERT INTO creature_names VALUES (600003, 'Mail Armor Vendor', 'Test Vendor', '', 0, 7, 0, 1, 0, 0, 18487, 0, 0, 0, 1, 1, 1, 0);
INSERT INTO creature_proto VALUES (600003, 70, 70, 1741, 9212, 9212, 0, 1, 128, 2000, 0, 624, 871, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 360000, 6807, 0, 0, 0, 0, 0, 0, 1.5, 1, '', 0, 0, 0, 0, 2.5, 8, 14, 0);
INSERT INTO vendors VALUES
('600003','32997','1','-1','0'),
('600003','32998','1','-1','0'),
('600003','32999','1','-1','0'),
('600003','32809','1','-1','0'),
('600003','32797','1','-1','0'),
('600003','32785','1','-1','0'),
('600003','32816','1','-1','0'),
('600003','32803','1','-1','0'),
('600003','32792','1','-1','0'),
('600003','32817','1','-1','0'),
('600003','32804','1','-1','0'),
('600003','32792','1','-1','0'),
('600003','30104','1','-1','0'),
('600003','30026','1','-1','0'),
('600003','30047','1','-1','0'),
('600003','30097','1','-1','0'),
('600003','29921','1','-1','0'),
('600003','30030','1','-1','0'),
('600003','30068','1','-1','0'),
('600003','28827','1','-1','0'),
('600003','29985','1','-1','0'),
('600003','29991','1','-1','0'),
('600003','29951','1','-1','0'),
('600003','29976','1','-1','0'),
('600003','30054','1','-1','0'),
('600003','30091','1','-1','0'),
('600003','30066','1','-1','0'),
('600003','30085','1','-1','0'),
('600003','32085','1','-1','0'),
('600003','32086','1','-1','0'),
('600003','31960','1','-1','0'),
('600003','31961','1','-1','0'),
('600003','31962','1','-1','0'),
('600003','31963','1','-1','0'),
('600003','31964','1','-1','0'),
('600003','30139','1','-1','0'),
('600003','30140','1','-1','0'),
('600003','30141','1','-1','0'),
('600003','30142','1','-1','0'),
('600003','30143','1','-1','0'),
('600003','30185','1','-1','0'),
('600003','30189','1','-1','0'),
('600003','30190','1','-1','0'),
('600003','30192','1','-1','0'),
('600003','30194','1','-1','0'),
('600003','30164','1','-1','0'),
('600003','30165','1','-1','0'),
('600003','30166','1','-1','0'),
('600003','30167','1','-1','0'),
('600003','30168','1','-1','0'),
('600003','30169','1','-1','0'),
('600003','30170','1','-1','0'),
('600003','30171','1','-1','0'),
('600003','30172','1','-1','0'),
('600003','30173','1','-1','0'),
('600003','32004','1','-1','0'),
('600003','32005','1','-1','0'),
('600003','32006','1','-1','0'),
('600003','32007','1','-1','0'),
('600003','32008','1','-1','0'),
('600003','32009','1','-1','0'),
('600003','32010','1','-1','0'),
('600003','32011','1','-1','0'),
('600003','32012','1','-1','0'),
('600003','32013','1','-1','0'),
('600003','32029','1','-1','0'),
('600003','32030','1','-1','0'),
('600003','32031','1','-1','0'),
('600003','32032','1','-1','0'),
('600003','32033','1','-1','0');
/*
* Arena Tournament Server
* Copyright (C) 2008 Arena Tournament Team <Jur0 & sT@N>
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Affero General Public License for more details.
*
* You should have received a copy of the GNU Affero General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*
*/
delete from creature_proto where entry = '600007';
delete from creature_names where entry = '600007';
delete from vendors where item in(31992, 31993, 31995, 31996, 31997, 32020, 32021, 32022, 32023, 32024, 32039, 32040, 32041, 32042, 32043, 30123, 30125, 30124, 30126, 30127, 30129, 30130, 30132, 30133, 30131, 30134, 30135, 30136, 30137, 30138, 30486, 30487, 30488, 30489, 30490, 30113, 30115, 30114, 30116, 30117, 30120, 30118, 30119, 30121, 30122, 32801, 32813, 32789, 32988, 32989, 32990, 32805, 32818, 32793, 32806, 32819, 32794, 30112, 30027, 32267,30057, 30048, 29983, 30096, 29965, 30065, 29950, 28795, 28824, 28779, 29998, 32515, 30053, 30102, 30081, 30084, 32084) and entry = '600007';
INSERT INTO creature_names VALUES(600007, 'Plate Armor Vendor', 'Test Vendor', '', 0, 7, 0, 1, 0, 0, 10045, 0, 0, 0, 1, 1, 1, 0);
INSERT INTO creature_proto VALUES(600007, 70, 70, 1741, 9212, 9212, 0, 1, 128, 2000, 0, 624, 871, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 360000, 6807, 0, 0, 0, 0, 0, 0, 1.5, 1, '', 0, 0, 0, 0, 2.5, 8, 14, 0);
INSERT INTO vendors VALUES
('600007','31992','1','-1','0'),
('600007','31993','1','-1','0'),
('600007','31995','1','-1','0'),
('600007','31996','1','-1','0'),
('600007','31997','1','-1','0'),
('600007','32020','1','-1','0'),
('600007','32021','1','-1','0'),
('600007','32022','1','-1','0'),
('600007','32023','1','-1','0'),
('600007','32024','1','-1','0'),
('600007','32039','1','-1','0'),
('600007','32040','1','-1','0'),
('600007','32041','1','-1','0'),
('600007','32042','1','-1','0'),
('600007','32043','1','-1','0'),
('600007','30123','1','-1','0'),
('600007','30125','1','-1','0'),
('600007','30124','1','-1','0'),
('600007','30126','1','-1','0'),
('600007','30127','1','-1','0'),
('600007','30129','1','-1','0'),
('600007','30130','1','-1','0'),
('600007','30132','1','-1','0'),
('600007','30133','1','-1','0'),
('600007','30131','1','-1','0'),
('600007','30134','1','-1','0'),
('600007','30135','1','-1','0'),
('600007','30136','1','-1','0'),
('600007','30137','1','-1','0'),
('600007','30138','1','-1','0'),
('600007','30486','1','-1','0'),
('600007','30487','1','-1','0'),
('600007','30488','1','-1','0'),
('600007','30489','1','-1','0'),
('600007','30490','1','-1','0'),
('600007','30113','1','-1','0'),
('600007','30115','1','-1','0'),
('600007','30114','1','-1','0'),
('600007','30116','1','-1','0'),
('600007','30117','1','-1','0'),
('600007','30120','1','-1','0'),
('600007','30118','1','-1','0'),
('600007','30119','1','-1','0'),
('600007','30121','1','-1','0'),
('600007','30122','1','-1','0'),
('600007','32801','1','-1','0'),
('600007','32813','1','-1','0'),
('600007','32789','1','-1','0'),
('600007','32988','1','-1','0'),
('600007','32989','1','-1','0'),
('600007','32990','1','-1','0'),
('600007','32805','1','-1','0'),
('600007','32818','1','-1','0'),
('600007','32793','1','-1','0'),
('600007','32806','1','-1','0'),
('600007','32819','1','-1','0'),
('600007','32794','1','-1','0'),
('600007','30112','1','-1','0'),
('600007','30027','1','-1','0'),
('600007','32267','1','-1','0'),
('600007','30057','1','-1','0'),
('600007','30048','1','-1','0'),
('600007','29983','1','-1','0'),
('600007','30096','1','-1','0'),
('600007','29965','1','-1','0'),
('600007','30065','1','-1','0'),
('600007','29950','1','-1','0'),
('600007','28795','1','-1','0'),
('600007','28824','1','-1','0'),
('600007','28779','1','-1','0'),
('600007','29998','1','-1','0'),
('600007','32515','1','-1','0'),
('600007','30053','1','-1','0'),
('600007','30102','1','-1','0'),
('600007','30081','1','-1','0'),
('600007','30084','1','-1','0'),
('600007','32084','1','-1','0');
/*
* Arena Tournament Server
* Copyright (C) 2008 Arena Tournament Team <Jur0 & sT@N>
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Affero General Public License for more details.
*
* You should have received a copy of the GNU Affero General Public License
* along with this program. If not, see <http://www.gnu.org/licenses/>.
*
*/
delete from creature_proto where entry = '600006';
delete from creature_names where entry = '600006';
delete from vendors where item in(33313, 31958, 31959, 31965, 31986, 31966, 31978, 32963, 31984, 31985, 32003, 32014, 32025, 32026, 32027, 33309, 32961, 32028, 32964, 32044, 32045, 32046, 32052, 32053, 32962, 32054, 32055, 33937, 33077, 33949, 33946, 33943, 33076, 33940, 33952, 33078, 30103, 29949, 29948, 29981, 28794, 28782, 28783, 28774, 28773, 32944, 29962, 29924, 29996, 29988, 29982, 29923, 30105, 30082, 30108, 30090, 30080, 30058, 30049, 30051, 30063, 29993, 27886, 32756, 29388, 29389, 29390, 29275, 29270, 29273, 29272, 29269, 29271, 29274, 29267, 29268) and entry = '600006';
INSERT INTO creature_names VALUES(600006, 'Weapon Vendor', 'Test Vendor', '', 0, 7, 0, 1, 0, 0, 10045, 0, 0, 0, 1, 1, 1, 0);
INSERT INTO creature_proto VALUES(600006, 70, 70, 1741, 9212, 9212, 0, 1, 128, 2000, 0, 624, 871, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 360000, 6807, 0, 0, 0, 0, 0, 0, 1.5, 1, '', 0, 0, 0, 0, 2.5, 8, 14, 0);
INSERT INTO vendors VALUES
('600006','33313','1','-1','0'),
('600006','31958','1','-1','0'),
('600006','31959','1','-1','0'),
('600006','31965','1','-1','0'),
('600006','31986','1','-1','0'),
('600006','31966','1','-1','0'),
('600006','31978','1','-1','0'),
('600006','32963','1','-1','0'),
('600006','31984','1','-1','0'),
('600006','31985','1','-1','0'),
('600006','32003','1','-1','0'),
('600006','32014','1','-1','0'),
('600006','32025','1','-1','0'),
('600006','32026','1','-1','0'),
('600006','32027','1','-1','0'),
('600006','33309','1','-1','0'),
('600006','32961','1','-1','0'),
('600006','32028','1','-1','0'),
('600006','32964','1','-1','0'),
('600006','32044','1','-1','0'),
('600006','32045','1','-1','0'),
('600006','32046','1','-1','0'),
('600006','32052','1','-1','0'),
('600006','32053','1','-1','0'),
('600006','32962','1','-1','0'),
('600006','32054','1','-1','0'),
('600006','32055','1','-1','0'),
('600006','33937','1','-1','0'),
('600006','33077','1','-1','0'),
('600006','33949','1','-1','0'),
('600006','33946','1','-1','0'),
('600006','33943','1','-1','0'),
('600006','33076','1','-1','0'),
('600006','33940','1','-1','0'),
('600006','33952','1','-1','0'),
('600006','33078','1','-1','0'),
('600006','30103','1','-1','0'),
('600006','29949','1','-1','0'),
('600006','29948','1','-1','0'),
('600006','29981','1','-1','0'),
('600006','28794','1','-1','0'),
('600006','28782','1','-1','0'),
('600006','28783','1','-1','0'),
('600006','28774','1','-1','0'),
('600006','28773','1','-1','0'),
('600006','32944','1','-1','0'),
('600006','29962','1','-1','0'),
('600006','29924','1','-1','0'),
('600006','29996','1','-1','0'),
('600006','29988','1','-1','0'),
('600006','29982','1','-1','0'),
('600006','29923','1','-1','0'),
('600006','30105','1','-1','0'),
('600006','30082','1','-1','0'),
('600006','30108','1','-1','0'),
('600006','30090','1','-1','0'),
('600006','30080','1','-1','0'),
('600006','30058','1','-1','0'),
('600006','30049','1','-1','0'),
('600006','30051','1','-1','0'),
('600006','30063','1','-1','0'),
('600006','29993','1','-1','0'),
('600006','27886','1','-1','0'),
('600006','32756','1','-1','0'),
('600006','29388','1','-1','0'),
('600006','29389','1','-1','0'),
('600006','29390','1','-1','0'),
('600006','29275','1','-1','0'),
('600006','29270','1','-1','0'),
('600006','29273','1','-1','0'),
('600006','29272','1','-1','0'),
('600006','29269','1','-1','0'),
('600006','29271','1','-1','0'),
('600006','29274','1','-1','0'),
('600006','29267','1','-1','0'),
('600006','29268','1','-1','0');