Thread: [MaNGOS] Tier 10 Vendor

<Noob Saibot>
<Tier 10 Vendor>

Code:

INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (56000, 0, 0, 0, 0, 0, 29855, 0, 29855, 0, 'Noob Saibot', 'Tier 10 Vendor', '', 0, 80, 80, 11770, 11770, 0, 0, 8219, 35, 35, 128, 1, 1, 0, 322, 483, 0, 121, 1.2, 2000, 2000, 4, 33282, 0, 0, 0, 0, 0, 0, 258, 386, 97, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 2, '');

INSERT INTO `npc_vendor` (entry, item, maxcount, incrtime, ExtendedCost) VALUES 
(56000, 51220, 0, 0, 0),
(56000, 51221, 0, 0, 0),
(56000, 51222, 0, 0, 0),
(56000, 51223, 0, 0, 0),
(56000, 51224, 0, 0, 0),
(56000, 51225, 0, 0, 0),
(56000, 51226, 0, 0, 0),
(56000, 51227, 0, 0, 0),
(56000, 51228, 0, 0, 0),
(56000, 51229, 0, 0, 0),
(56000, 51230, 0, 0, 0),
(56000, 51231, 0, 0, 0),
(56000, 51232, 0, 0, 0),
(56000, 51233, 0, 0, 0),
(56000, 51234, 0, 0, 0),
(56000, 51235, 0, 0, 0),
(56000, 51236, 0, 0, 0),
(56000, 51237, 0, 0, 0),
(56000, 51238, 0, 0, 0),
(56000, 51239, 0, 0, 0),
(56000, 51240, 0, 0, 0),
(56000, 51241, 0, 0, 0),
(56000, 51242, 0, 0, 0),
(56000, 51243, 0, 0, 0),
(56000, 51244, 0, 0, 0),
(56000, 51245, 0, 0, 0),
(56000, 51246, 0, 0, 0),
(56000, 51247, 0, 0, 0),
(56000, 51248, 0, 0, 0),
(56000, 51249, 0, 0, 0),
(56000, 51250, 0, 0, 0),
(56000, 51251, 0, 0, 0),
(56000, 51252, 0, 0, 0),
(56000, 51253, 0, 0, 0),
(56000, 51254, 0, 0, 0),
(56000, 51255, 0, 0, 0),
(56000, 51256, 0, 0, 0),
(56000, 51257, 0, 0, 0),
(56000, 51258, 0, 0, 0),
(56000, 51259, 0, 0, 0),
(56000, 51260, 0, 0, 0),
(56000, 51261, 0, 0, 0),
(56000, 51262, 0, 0, 0),
(56000, 51263, 0, 0, 0),
(56000, 51264, 0, 0, 0),
(56000, 51265, 0, 0, 0),
(56000, 51266, 0, 0, 0),
(56000, 51267, 0, 0, 0),
(56000, 51268, 0, 0, 0),
(56000, 51269, 0, 0, 0),
(56000, 51270, 0, 0, 0),
(56000, 51271, 0, 0, 0),
(56000, 51272, 0, 0, 0),
(56000, 51273, 0, 0, 0),
(56000, 51274, 0, 0, 0),
(56000, 51275, 0, 0, 0),
(56000, 51276, 0, 0, 0),
(56000, 51277, 0, 0, 0),
(56000, 51278, 0, 0, 0),
(56000, 51279, 0, 0, 0),
(56000, 51280, 0, 0, 0),
(56000, 51281, 0, 0, 0),
(56000, 51282, 0, 0, 0),
(56000, 51283, 0, 0, 0),
(56000, 51284, 0, 0, 0),
(56000, 51285, 0, 0, 0),
(56000, 51286, 0, 0, 0),
(56000, 51287, 0, 0, 0),
(56000, 51288, 0, 0, 0),
(56000, 51289, 0, 0, 0),
(56000, 51295, 0, 0, 0),
(56000, 51296, 0, 0, 0),
(56000, 51297, 0, 0, 0),
(56000, 51298, 0, 0, 0),
(56000, 51299, 0, 0, 0),
(56000, 51300, 0, 0, 0),
(56000, 51301, 0, 0, 0),
(56000, 51302, 0, 0, 0),
(56000, 51303, 0, 0, 0),
(56000, 51304, 0, 0, 0),
(56000, 51305, 0, 0, 0),
(56000, 51306, 0, 0, 0),
(56000, 51307, 0, 0, 0),
(56000, 51308, 0, 0, 0),
(56000, 51309, 0, 0, 0),
(56000, 51310, 0, 0, 0),
(56000, 51311, 0, 0, 0),
(56000, 51312, 0, 0, 0),
(56000, 51313, 0, 0, 0),
(56000, 51314, 0, 0, 0);

To add in-game:

Code:

.npc add 56000

Arcemu:

Code:

insert into `creature_names` (`entry`, `name`, `subname`, `info_str`, `Flags1`, `type`, `family`, `rank`, `killcredit1`, `killcredit2`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `leader`) 
values ('56000', "Noob Saibot", "Tier 10 Vendor", '', '0', '10', '0', '3', '0', '0', '29855', '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`, `summonguard`) 
values ('56000', '80', '80', '7', '11770', '11770', '', '1', '129', '1000', '0', '322', '483', '0', '0', '0', '0', '30000', '8219', '0', '0', '0', '0', '0', '0', '0', '0', "0", '0', '0', '0', '0', '2.50', '8.00', '14.00', '0', '0', '0', '0', '0', '0', '0', '0');

INSERT INTO `vendors` (`entry`,`item`,`amount`) VALUES 
(56000, 51220, 1),
(56000, 51221, 1),
(56000, 51222, 1),
(56000, 51223, 1),
(56000, 51224, 1),
(56000, 51225, 1),
(56000, 51226, 1),
(56000, 51227, 1),
(56000, 51228, 1),
(56000, 51229, 1),
(56000, 51230, 1),
(56000, 51231, 1),
(56000, 51232, 1),
(56000, 51233, 1),
(56000, 51234, 1),
(56000, 51235, 1),
(56000, 51236, 1),
(56000, 51237, 1),
(56000, 51238, 1),
(56000, 51239, 1),
(56000, 51240, 1),
(56000, 51241, 1),
(56000, 51242, 1),
(56000, 51243, 1),
(56000, 51244, 1),
(56000, 51245, 1),
(56000, 51246, 1),
(56000, 51247, 1),
(56000, 51248, 1),
(56000, 51249, 1),
(56000, 51250, 1),
(56000, 51251, 1),
(56000, 51252, 1),
(56000, 51253, 1),
(56000, 51254, 1),
(56000, 51255, 1),
(56000, 51256, 1),
(56000, 51257, 1),
(56000, 51258, 1),
(56000, 51259, 1),
(56000, 51260, 1),
(56000, 51261, 1),
(56000, 51262, 1),
(56000, 51263, 1),
(56000, 51264, 1),
(56000, 51265, 1),
(56000, 51266, 1),
(56000, 51267, 1),
(56000, 51268, 1),
(56000, 51269, 1),
(56000, 51270, 1),
(56000, 51271, 1),
(56000, 51272, 1),
(56000, 51273, 1),
(56000, 51274, 1),
(56000, 51275, 1),
(56000, 51276, 1),
(56000, 51277, 1),
(56000, 51278, 1),
(56000, 51279, 1),
(56000, 51280, 1),
(56000, 51281, 1),
(56000, 51282, 1),
(56000, 51283, 1),
(56000, 51284, 1),
(56000, 51285, 1),
(56000, 51286, 1),
(56000, 51287, 1),
(56000, 51288, 1),
(56000, 51289, 1),
(56000, 51295, 1),
(56000, 51296, 1),
(56000, 51297, 1),
(56000, 51298, 1),
(56000, 51299, 1),
(56000, 51300, 1),
(56000, 51301, 1),
(56000, 51302, 1),
(56000, 51303, 1),
(56000, 51304, 1),
(56000, 51305, 1),
(56000, 51306, 1),
(56000, 51307, 1),
(56000, 51308, 1),
(56000, 51309, 1),
(56000, 51310, 1),
(56000, 51311, 1),
(56000, 51312, 1),
(56000, 51313, 1),
(56000, 51314, 1);

Here is Trinity

Code:

-- Add Vendor
DELETE FROM `creature_template` WHERE `entry`=56000;
INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES (56000, 0, 0, 0, 0, 0, 29855, 0, 0, 0, 'Noob Saibot', 'Tier 10 Vendor', 0, 80, 80, 2, 35, 35, 128, 1, 1.14286, 1, 0, 0, 0, 0, 0, 1, 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, 3, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0);
-- Add items to vendor
DELETE FROM `npc_vendor` WHERE `entry`=56000;
INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`) VALUES 
(56000,0,51220,0,0,0),
(56000,0,51221,0,0,0),
(56000,0,51222,0,0,0),
(56000,0,51223,0,0,0),
(56000,0,51224,0,0,0),
(56000,0,51225,0,0,0),
(56000,0,51226,0,0,0),
(56000,0,51227,0,0,0),
(56000,0,51228,0,0,0),
(56000,0,51229,0,0,0),
(56000,0,51230,0,0,0),
(56000,0,51231,0,0,0),
(56000,0,51232,0,0,0),
(56000,0,51233,0,0,0),
(56000,0,51234,0,0,0),
(56000,0,51235,0,0,0),
(56000,0,51236,0,0,0),
(56000,0,51237,0,0,0),
(56000,0,51238,0,0,0),
(56000,0,51239,0,0,0),
(56000,0,51240,0,0,0),
(56000,0,51241,0,0,0),
(56000,0,51242,0,0,0),
(56000,0,51243,0,0,0),
(56000,0,51244,0,0,0),
(56000,0,51245,0,0,0),
(56000,0,51246,0,0,0),
(56000,0,51247,0,0,0),
(56000,0,51248,0,0,0),
(56000,0,51249,0,0,0),
(56000,0,51250,0,0,0),
(56000,0,51251,0,0,0),
(56000,0,51252,0,0,0),
(56000,0,51253,0,0,0),
(56000,0,51254,0,0,0),
(56000,0,51255,0,0,0),
(56000,0,51256,0,0,0),
(56000,0,51257,0,0,0),
(56000,0,51258,0,0,0),
(56000,0,51259,0,0,0),
(56000,0,51260,0,0,0),
(56000,0,51261,0,0,0),
(56000,0,51262,0,0,0),
(56000,0,51263,0,0,0),
(56000,0,51264,0,0,0),
(56000,0,51265,0,0,0),
(56000,0,51266,0,0,0),
(56000,0,51267,0,0,0),
(56000,0,51268,0,0,0),
(56000,0,51269,0,0,0),
(56000,0,51270,0,0,0),
(56000,0,51271,0,0,0),
(56000,0,51272,0,0,0),
(56000,0,51273,0,0,0),
(56000,0,51274,0,0,0),
(56000,0,51275,0,0,0),
(56000,0,51276,0,0,0),
(56000,0,51277,0,0,0),
(56000,0,51278,0,0,0),
(56000,0,51279,0,0,0),
(56000,0,51280,0,0,0),
(56000,0,51281,0,0,0),
(56000,0,51282,0,0,0),
(56000,0,51283,0,0,0),
(56000,0,51284,0,0,0),
(56000,0,51285,0,0,0),
(56000,0,51286,0,0,0),
(56000,0,51287,0,0,0),
(56000,0,51288,0,0,0),
(56000,0,51289,0,0,0),
(56000,0,51295,0,0,0),
(56000,0,51296,0,0,0),
(56000,0,51297,0,0,0),
(56000,0,51298,0,0,0),
(56000,0,51299,0,0,0),
(56000,0,51300,0,0,0),
(56000,0,51301,0,0,0),
(56000,0,51302,0,0,0),
(56000,0,51303,0,0,0),
(56000,0,51304,0,0,0),
(56000,0,51305,0,0,0),
(56000,0,51306,0,0,0),
(56000,0,51307,0,0,0),
(56000,0,51308,0,0,0),
(56000,0,51309,0,0,0),
(56000,0,51310,0,0,0),
(56000,0,51311,0,0,0),
(56000,0,51312,0,0,0),
(56000,0,51313,0,0,0),
(56000,0,51314,0,0,0);

Or get from pastebin.com