Multivendor Glyph/Created by MrSolid/Exclusively for ACWeb

/*
// / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / //
//                                                                                           //
//    ____                _           _   _             __  __      ____        _ _     _    //
//   / ___|_ __ ___  __ _| |_ ___  __| | | |__  _   _  |  \/  |_ __/ ___|  ___ | (_) __| |   //
//  | |   | '__/ _ \/ _` | __/ _ \/ _` | | '_ \| | | | | |\/| | '__\___ \ / _ \| | |/ _` |   //
//  | |___| | |  __/ (_| | ||  __/ (_| | | |_) | |_| | | |  | | |   ___) | (_) | | | (_| |   //
//   \____|_|  \___|\__,_|\__\___|\__,_| |_.__/ \__, | |_|  |_|_|  |____/ \___/|_|_|\__,_|   //
//                                              |___/                                        //
//                                                                                           //
// / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / / //

Created by MrSolid, 2017. Exclusively for the ACWeb Community.
*/

SET @ENTRY = (SELECT MAX(entry)+1 FROM creature_template);
SET @MENU_ID = (SELECT MAX(menu_id)+1 FROM gossip_menu_option);
SET @VENDOR_NAME1 = 'Warrior';
SET @VENDOR_ID1 = 500111;
SET @VENDOR_NAME2 = 'Paladin';
SET @VENDOR_ID2 = 500068;
SET @VENDOR_NAME3 = 'Death Knight';
SET @VENDOR_ID3 = 500026;
SET @VENDOR_NAME4 = 'Hunter';
SET @VENDOR_ID4 = 500046;
SET @VENDOR_NAME5 = 'Shaman';
SET @VENDOR_ID5 = 500097;
SET @VENDOR_NAME6 = 'Rogue';
SET @VENDOR_ID6 = 500095;
SET @VENDOR_NAME7 = 'Druid';
SET @VENDOR_ID7 = 500027;
SET @VENDOR_NAME8 = 'Mage';
SET @VENDOR_ID8 = 500057;
SET @VENDOR_NAME9 = 'Priest';
SET @VENDOR_ID9 = 500113;
SET @VENDOR_NAME10 = 'Warlock';
SET @VENDOR_ID10 = 500110;

INSERT INTO `creature_template` (`entry`, `modelid1`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `dmgschool`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `RacialLeader`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES
(@ENTRY, 1298, "Glyphs", "MultiVendor", NULL, @MENU_ID, 10, 10, 0, 35, 129, 1, 1.14286, 1, 0, 0, 1500, 0, 1, 512, 2048, 8, 0, 0, 0, 0, 0, 7, 138412032, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 0, 0, 1, 0, 2, '');

DELETE FROM `npc_vendor` WHERE entry BETWEEN 500026 AND 500113;
INSERT INTO `npc_vendor` (`entry`,`item`) VALUES
('500026','43533'),
('500026','43534'),
('500026','43535'),
('500026','43536'),
('500026','43537'),
('500026','43538'),
('500026','43539'),
('500026','43541'),
('500026','43542'),
('500026','43543'),
('500026','43544'),
('500026','43545'),
('500026','43546'),
('500026','43547'),
('500026','43548'),
('500026','43549'),
('500026','43550'),
('500026','43551'),
('500026','43552'),
('500026','43553'),
('500026','43554'),
('500026','43671'),
('500026','43672'),
('500026','43673'),
('500026','43825'),
('500026','43826'),
('500026','43827'),
('500026','45799'),
('500026','45800'),
('500026','45803'),
('500026','45804'),
('500026','45805'),
('500026','45806'),
('500027','40896'),
('500027','40897'),
('500027','40899'),
('500027','40900'),
('500027','40901'),
('500027','40902'),
('500027','40903'),
('500027','40906'),
('500027','40908'),
('500027','40909'),
('500027','40912'),
('500027','40913'),
('500027','40914'),
('500027','40915'),
('500027','40916'),
('500027','40919'),
('500027','40920'),
('500027','40921'),
('500027','40922'),
('500027','40923'),
('500027','40924'),
('500027','43316'),
('500027','43331'),
('500027','43332'),
('500027','43334'),
('500027','43335'),
('500027','43674'),
('500027','44922'),
('500027','44928'),
('500027','45601'),
('500027','45602'),
('500027','45603'),
('500027','45604'),
('500027','45622'),
('500027','45623'),
('500027','46372'),
('500027','48720'),
('500027','50125'),
('500046','42897'),
('500046','42898'),
('500046','42899'),
('500046','42900'),
('500046','42901'),
('500046','42902'),
('500046','42903'),
('500046','42904'),
('500046','42905'),
('500046','42906'),
('500046','42907'),
('500046','42908'),
('500046','42909'),
('500046','42910'),
('500046','42911'),
('500046','42912'),
('500046','42913'),
('500046','42914'),
('500046','42915'),
('500046','42916'),
('500046','42917'),
('500046','43338'),
('500046','43350'),
('500046','43351'),
('500046','43354'),
('500046','43355'),
('500046','43356'),
('500046','45625'),
('500046','45731'),
('500046','45732'),
('500046','45733'),
('500046','45734'),
('500046','45735'),
('500057','42734'),
('500057','42735'),
('500057','42736'),
('500057','42737'),
('500057','42738'),
('500057','42739'),
('500057','42740'),
('500057','42741'),
('500057','42742'),
('500057','42743'),
('500057','42744'),
('500057','42745'),
('500057','42746'),
('500057','42747'),
('500057','42748'),
('500057','42749'),
('500057','42750'),
('500057','42751'),
('500057','42752'),
('500057','42753'),
('500057','42754'),
('500057','43339'),
('500057','43357'),
('500057','43359'),
('500057','43360'),
('500057','43361'),
('500057','43364'),
('500057','44684'),
('500057','44920'),
('500057','44955'),
('500057','45736'),
('500057','45737'),
('500057','45738'),
('500057','45739'),
('500057','45740'),
('500057','50045'),
('500068','41092'),
('500068','41094'),
('500068','41095'),
('500068','41096'),
('500068','41097'),
('500068','41098'),
('500068','41099'),
('500068','41100'),
('500068','41101'),
('500068','41102'),
('500068','41103'),
('500068','41104'),
('500068','41105'),
('500068','41106'),
('500068','41107'),
('500068','41108'),
('500068','41109'),
('500068','41110'),
('500068','43340'),
('500068','43365'),
('500068','43366'),
('500068','43367'),
('500068','43368'),
('500068','43369'),
('500068','43867'),
('500068','43868'),
('500068','43869'),
('500068','45741'),
('500068','45742'),
('500068','45743'),
('500068','45744'),
('500068','45745'),
('500068','45746'),
('500068','45747'),
('500095','42954'),
('500095','42955'),
('500095','42956'),
('500095','42957'),
('500095','42958'),
('500095','42959'),
('500095','42960'),
('500095','42961'),
('500095','42962'),
('500095','42963'),
('500095','42964'),
('500095','42965'),
('500095','42966'),
('500095','42967'),
('500095','42968'),
('500095','42969'),
('500095','42970'),
('500095','42971'),
('500095','42972'),
('500095','42973'),
('500095','42974'),
('500095','43343'),
('500095','43376'),
('500095','43377'),
('500095','43378'),
('500095','43379'),
('500095','43380'),
('500095','45761'),
('500095','45762'),
('500095','45764'),
('500095','45766'),
('500095','45767'),
('500095','45768'),
('500095','45769'),
('500097','41517'),
('500097','41518'),
('500097','41524'),
('500097','41526'),
('500097','41527'),
('500097','41529'),
('500097','41530'),
('500097','41531'),
('500097','41532'),
('500097','41533'),
('500097','41534'),
('500097','41535'),
('500097','41536'),
('500097','41537'),
('500097','41538'),
('500097','41539'),
('500097','41540'),
('500097','41541'),
('500097','41542'),
('500097','41547'),
('500097','41552'),
('500097','43344'),
('500097','43381'),
('500097','43385'),
('500097','43386'),
('500097','43388'),
('500097','43725'),
('500097','44923'),
('500097','45770'),
('500097','45771'),
('500097','45772'),
('500097','45775'),
('500097','45776'),
('500097','45777'),
('500097','45778'),
('500110','42453'),
('500110','42454'),
('500110','42455'),
('500110','42456'),
('500110','42457'),
('500110','42458'),
('500110','42459'),
('500110','42460'),
('500110','42461'),
('500110','42462'),
('500110','42463'),
('500110','42464'),
('500110','42465'),
('500110','42466'),
('500110','42467'),
('500110','42468'),
('500110','42469'),
('500110','42470'),
('500110','42471'),
('500110','42472'),
('500110','42473'),
('500110','43389'),
('500110','43390'),
('500110','43391'),
('500110','43392'),
('500110','43393'),
('500110','43394'),
('500110','45779'),
('500110','45780'),
('500110','45781'),
('500110','45782'),
('500110','45783'),
('500110','45785'),
('500110','45789'),
('500110','50077'),
('500111','43395'),
('500111','43396'),
('500111','43397'),
('500111','43398'),
('500111','43399'),
('500111','43400'),
('500111','43412'),
('500111','43413'),
('500111','43414'),
('500111','43415'),
('500111','43416'),
('500111','43417'),
('500111','43418'),
('500111','43419'),
('500111','43420'),
('500111','43421'),
('500111','43422'),
('500111','43423'),
('500111','43424'),
('500111','43425'),
('500111','43426'),
('500111','43427'),
('500111','43428'),
('500111','43429'),
('500111','43430'),
('500111','43431'),
('500111','43432'),
('500111','45790'),
('500111','45792'),
('500111','45793'),
('500111','45794'),
('500111','45795'),
('500111','45797'),
('500111','49084'),
('500113','42396'),
('500113','42397'),
('500113','42398'),
('500113','42399'),
('500113','42400'),
('500113','42401'),
('500113','42402'),
('500113','42403'),
('500113','42404'),
('500113','42405'),
('500113','42406'),
('500113','42407'),
('500113','42408'),
('500113','42409'),
('500113','42410'),
('500113','42411'),
('500113','42412'),
('500113','42414'),
('500113','42415'),
('500113','42416'),
('500113','42417'),
('500113','43342'),
('500113','43370'),
('500113','43371'),
('500113','43372'),
('500113','43373'),
('500113','43374'),
('500113','45753'),
('500113','45755'),
('500113','45756'),
('500113','45757'),
('500113','45758'),
('500113','45760');

INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`) VALUES
(@MENU_ID, 1, 4, @VENDOR_NAME1, 3, 128, @VENDOR_ID1, 0, 0, 0, ''),
(@MENU_ID, 2, 4, @VENDOR_NAME2, 3, 128, @VENDOR_ID2, 0, 0, 0, ''),
(@MENU_ID, 3, 4, @VENDOR_NAME3, 3, 128, @VENDOR_ID3, 0, 0, 100, ''),
(@MENU_ID, 4, 4, @VENDOR_NAME4, 3, 128, @VENDOR_ID4, 0, 0, 0, ''),
(@MENU_ID, 5, 4, @VENDOR_NAME5, 3, 128, @VENDOR_ID5, 0, 0, 0, ''),
(@MENU_ID, 6, 4, @VENDOR_NAME6, 3, 128, @VENDOR_ID6, 0, 0, 100, ''),
(@MENU_ID, 7, 4, @VENDOR_NAME7, 3, 128, @VENDOR_ID7, 0, 0, 0, ''),
(@MENU_ID, 8, 4, @VENDOR_NAME8, 3, 128, @VENDOR_ID8, 0, 0, 0, ''),
(@MENU_ID, 9, 4, @VENDOR_NAME9, 3, 128, @VENDOR_ID9, 0, 0, 100, ''),
(@MENU_ID, 10, 4, @VENDOR_NAME10, 3, 128, @VENDOR_ID10, 0, 0, 100, '');