Insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `leader`)
values ('800001', "Cloth & Leather Armor Vendor", "", '', '0', '7', '0', '1','31962', '0', '0', '0', '1', '1', '0');

insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`)
values ('800001', '80', '80', '35', '1905120', '1905120', '7333248', '1.15', '129', '100', '0', '200000', '200000', '0', '0', '0', '0', '1000', '500000000', '200000', '200000', '200000', '200000', '200000', '200000', '0', '0', "0", '1', '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0');

insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `leader`)
values ('800000', "Jewelry Vendor", "", '', '0', '7', '0', '1', '31962', '0', '0', '0', '1', '1', '0');

insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`)
values ('800000', '80', '80', '35', '1905120', '1905120', '7333248', '1.15', '129', '100', '0', '200000', '200000', '0', '0', '0', '0', '1000', '500000000', '200000', '200000', '200000', '200000', '200000', '200000', '0', '0', "0", '1', '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0');

insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `leader`)
values ('800004', "Misc & Quest items Vendor", "", '', '0', '7', '0', '1', '31962', '0', '0', '0', '1', '1', '0');

insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`)
values ('800004', '80', '80', '35', '1905120', '1905120', '7333248', '1.15', '129', '100', '0', '200000', '200000', '0', '0', '0', '0', '1000', '500000000', '200000', '200000', '200000', '200000', '200000', '200000', '0', '0', "0", '1', '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0');

insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `leader`)
values ('800002', "Plate & Mail Armor Vendor", "", '', '0', '7', '0', '1', '31962', '0', '0', '0', '1', '1', '0');

insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`)
values ('800002', '80', '80', '35', '1905120', '1905120', '7333248', '1.15', '129', '100', '0', '200000', '200000', '0', '0', '0', '0', '1000', '500000000', '200000', '200000', '200000', '200000', '200000', '200000', '0', '0', "0", '1', '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0');

insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `leader`)
values ('800003', "Cloaks Vendor", "", '', '0', '7', '0', '1', '31962', '0', '0', '0', '1', '1', '0');

insert into `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `death_state`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell_flags`, `modImmunities`)
values ('800003', '80', '80', '35', '1905120', '1905120', '7333248', '1.15', '129', '100', '0', '200000', '200000', '0', '0', '0', '0', '1000', '500000000', '200000', '200000', '200000', '200000', '200000', '200000', '0', '0', "0", '1', '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `vendors` (`entry`,`item`,`amount`) VALUES
('800004','54653','0'),
('800004','54651','0'),
('800004','53510','0'),
('800004','52563','0'),
('800004','52706','0'),
('800004','54215','0'),
('800004','52276','0'),
('800004','53637','0'),
('800004','52541','0'),
('800004','52566','0'),
('800004','52731','0'),
('800004','52709','0'),
('800004','52565','0'),
('800004','52562','0');
INSERT INTO `vendors` (`entry`,`item`,`amount`) VALUES
('800003','53115','0'),
('800003','54556','0'),
('800003','53489','0'),
('800003','54583','0'),
('800003','54617','0'),
('800003','53097','0');
INSERT INTO `vendors` (`entry`,`item`,`amount`) VALUES
('800002','53129','0'),
('800002','54579','0'),
('800002','53121','0'),
('800002','54565','0'),
('800002','53111','0'),
('800002','54564','0'),
('800002','53487','0'),
('800002','54586','0'),
('800002','53112','0'),
('800002','54559','0'),
('800002','53125','0'),
('800002','54578','0'),
('800002','53113','0'),
('800002','54566','0'),
('800002','53488','0'),
('800002','54587','0'),
('800002','53127','0'),
('800002','54577','0');
INSERT INTO `vendors` (`entry`,`item`,`amount`) VALUES
('800001','53118','0'),
('800001','54562','0'),
('800001','53117','0'),
('800001','54560','0'),
('800001','53114','0'),
('800001','54561','0'),
('800001','53134','0'),
('800001','54584','0'),
('800001','53126','0'),
('800001','54580','0'),
('800001','53486','0'),
('800001','54582','0');
INSERT INTO `vendors` (`entry`,`item`,`amount`) VALUES
('800000','53103','0'),
('800000','54557','0'),
('800000','53132','0'),
('800000','54581','0'),
('800000','53116','0'),
('800000','54563','0'),
('800000','53110','0'),
('800000','54567','0'),
('800000','53490','0'),
('800000','54585','0'),
('800000','53133','0'),
('800000','54576','0'),
('800000','54572','0'),
('800000','54588','0'),
('800000','54573','0'),
('800000','54589','0'),
('800000','54571','0'),
('800000','54591','0'),
('800000','54569','0'),
('800000','54590','0');