[MaNGOS] High-End Gems Vendor

<Baal-ze-bubba>
<High-End Gems 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 (56005, 0, 0, 0, 0, 0, 10992, 0, 10992, 0, 'Baal-ze-bubba', 'High-End Gems Vendor', '', 0, 80, 80, 11770, 11770, 0, 0, 8219, 35, 35, 128, 1, 2, 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
(56005, 22459, 0, 0, 0),
(56005, 22460, 0, 0, 0),
(56005, 34142, 0, 0, 0),
(56005, 34143, 0, 0, 0),
(56005, 36766, 0, 0, 0),
(56005, 36767, 0, 0, 0),
(56005, 40111, 0, 0, 0),
(56005, 40112, 0, 0, 0),
(56005, 40113, 0, 0, 0),
(56005, 40114, 0, 0, 0),
(56005, 40115, 0, 0, 0),
(56005, 40116, 0, 0, 0),
(56005, 40117, 0, 0, 0),
(56005, 40118, 0, 0, 0),
(56005, 40119, 0, 0, 0),
(56005, 40120, 0, 0, 0),
(56005, 40121, 0, 0, 0),
(56005, 40122, 0, 0, 0),
(56005, 40123, 0, 0, 0),
(56005, 40124, 0, 0, 0),
(56005, 40125, 0, 0, 0),
(56005, 40126, 0, 0, 0),
(56005, 40127, 0, 0, 0),
(56005, 40128, 0, 0, 0),
(56005, 40129, 0, 0, 0),
(56005, 40130, 0, 0, 0),
(56005, 40131, 0, 0, 0),
(56005, 40132, 0, 0, 0),
(56005, 40133, 0, 0, 0),
(56005, 40134, 0, 0, 0),
(56005, 40135, 0, 0, 0),
(56005, 40136, 0, 0, 0),
(56005, 40137, 0, 0, 0),
(56005, 40138, 0, 0, 0),
(56005, 40139, 0, 0, 0),
(56005, 40140, 0, 0, 0),
(56005, 40141, 0, 0, 0),
(56005, 40142, 0, 0, 0),
(56005, 40143, 0, 0, 0),
(56005, 40144, 0, 0, 0),
(56005, 40145, 0, 0, 0),
(56005, 40146, 0, 0, 0),
(56005, 40147, 0, 0, 0),
(56005, 40148, 0, 0, 0),
(56005, 40149, 0, 0, 0),
(56005, 40150, 0, 0, 0),
(56005, 40151, 0, 0, 0),
(56005, 40152, 0, 0, 0),
(56005, 40153, 0, 0, 0),
(56005, 40154, 0, 0, 0),
(56005, 40155, 0, 0, 0),
(56005, 40156, 0, 0, 0),
(56005, 40157, 0, 0, 0),
(56005, 40158, 0, 0, 0),
(56005, 40159, 0, 0, 0),
(56005, 40160, 0, 0, 0),
(56005, 40161, 0, 0, 0),
(56005, 40162, 0, 0, 0),
(56005, 40163, 0, 0, 0),
(56005, 40164, 0, 0, 0),
(56005, 40165, 0, 0, 0),
(56005, 40166, 0, 0, 0),
(56005, 40167, 0, 0, 0),
(56005, 40168, 0, 0, 0),
(56005, 40169, 0, 0, 0),
(56005, 40170, 0, 0, 0),
(56005, 40171, 0, 0, 0),
(56005, 40172, 0, 0, 0),
(56005, 40173, 0, 0, 0),
(56005, 40174, 0, 0, 0),
(56005, 40175, 0, 0, 0),
(56005, 40176, 0, 0, 0),
(56005, 40177, 0, 0, 0),
(56005, 40178, 0, 0, 0),
(56005, 40179, 0, 0, 0),
(56005, 40180, 0, 0, 0),
(56005, 40181, 0, 0, 0),
(56005, 40182, 0, 0, 0),
(56005, 41285, 0, 0, 0),
(56005, 41307, 0, 0, 0),
(56005, 41333, 0, 0, 0),
(56005, 41335, 0, 0, 0),
(56005, 41339, 0, 0, 0),
(56005, 41375, 0, 0, 0),
(56005, 41376, 0, 0, 0),
(56005, 41377, 0, 0, 0),
(56005, 41378, 0, 0, 0),
(56005, 41379, 0, 0, 0),
(56005, 41380, 0, 0, 0),
(56005, 41381, 0, 0, 0),
(56005, 41382, 0, 0, 0),
(56005, 41385, 0, 0, 0),
(56005, 41389, 0, 0, 0),
(56005, 41395, 0, 0, 0),
(56005, 41396, 0, 0, 0),
(56005, 41397, 0, 0, 0),
(56005, 41398, 0, 0, 0),
(56005, 41400, 0, 0, 0),
(56005, 41401, 0, 0, 0),
(56005, 42142, 0, 0, 0),
(56005, 42143, 0, 0, 0),
(56005, 42144, 0, 0, 0),
(56005, 42145, 0, 0, 0),
(56005, 42146, 0, 0, 0),
(56005, 42148, 0, 0, 0),
(56005, 42149, 0, 0, 0),
(56005, 42150, 0, 0, 0),
(56005, 42151, 0, 0, 0),
(56005, 42152, 0, 0, 0),
(56005, 42153, 0, 0, 0),
(56005, 42154, 0, 0, 0),
(56005, 42155, 0, 0, 0),
(56005, 42156, 0, 0, 0),
(56005, 42157, 0, 0, 0),
(56005, 42158, 0, 0, 0),
(56005, 42701, 0, 0, 0),
(56005, 42702, 0, 0, 0),
(56005, 44066, 0, 0, 0),
(56005, 44076, 0, 0, 0),
(56005, 44078, 0, 0, 0),
(56005, 44081, 0, 0, 0),
(56005, 44082, 0, 0, 0),
(56005, 44084, 0, 0, 0),
(56005, 44087, 0, 0, 0),
(56005, 44088, 0, 0, 0),
(56005, 44089, 0, 0, 0),
(56005, 45054, 0, 0, 0),
(56005, 49110, 0, 0, 0);

---

To add in-game:

Code:

---

.npc add 56005

---

Thanks

http://i24.photobucket.com/albums/c1...esignature.png

Here is for 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 ('56005', "Baal-ze-bubba", "High-End Gems Vendor", '', '0', '10', '0', '3', '0', '0', '10992', '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 ('56005', '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
(56005, 22459, 1),
(56005, 22460, 1),
(56005, 34142, 1),
(56005, 34143, 1),
(56005, 36766, 1),
(56005, 36767, 1),
(56005, 40111, 1),
(56005, 40112, 1),
(56005, 40113, 1),
(56005, 40114, 1),
(56005, 40115, 1),
(56005, 40116, 1),
(56005, 40117, 1),
(56005, 40118, 1),
(56005, 40119, 1),
(56005, 40120, 1),
(56005, 40121, 1),
(56005, 40122, 1),
(56005, 40123, 1),
(56005, 40124, 1),
(56005, 40125, 1),
(56005, 40126, 1),
(56005, 40127, 1),
(56005, 40128, 1),
(56005, 40129, 1),
(56005, 40130, 1),
(56005, 40131, 1),
(56005, 40132, 1),
(56005, 40133, 1),
(56005, 40134, 1),
(56005, 40135, 1),
(56005, 40136, 1),
(56005, 40137, 1),
(56005, 40138, 1),
(56005, 40139, 1),
(56005, 40140, 1),
(56005, 40141, 1),
(56005, 40142, 1),
(56005, 40143, 1),
(56005, 40144, 1),
(56005, 40145, 1),
(56005, 40146, 1),
(56005, 40147, 1),
(56005, 40148, 1),
(56005, 40149, 1),
(56005, 40150, 1),
(56005, 40151, 1),
(56005, 40152, 1),
(56005, 40153, 1),
(56005, 40154, 1),
(56005, 40155, 1),
(56005, 40156, 1),
(56005, 40157, 1),
(56005, 40158, 1),
(56005, 40159, 1),
(56005, 40160, 1),
(56005, 40161, 1),
(56005, 40162, 1),
(56005, 40163, 1),
(56005, 40164, 1),
(56005, 40165, 1),
(56005, 40166, 1),
(56005, 40167, 1),
(56005, 40168, 1),
(56005, 40169, 1),
(56005, 40170, 1),
(56005, 40171, 1),
(56005, 40172, 1),
(56005, 40173, 1),
(56005, 40174, 1),
(56005, 40175, 1),
(56005, 40176, 1),
(56005, 40177, 1),
(56005, 40178, 1),
(56005, 40179, 1),
(56005, 40180, 1),
(56005, 40181, 1),
(56005, 40182, 1),
(56005, 41285, 1),
(56005, 41307, 1),
(56005, 41333, 1),
(56005, 41335, 1),
(56005, 41339, 1),
(56005, 41375, 1),
(56005, 41376, 1),
(56005, 41377, 1),
(56005, 41378, 1),
(56005, 41379, 1),
(56005, 41380, 1),
(56005, 41381, 1),
(56005, 41382, 1),
(56005, 41385, 1),
(56005, 41389, 1),
(56005, 41395, 1),
(56005, 41396, 1),
(56005, 41397, 1),
(56005, 41398, 1),
(56005, 41400, 1),
(56005, 41401, 1),
(56005, 42142, 1),
(56005, 42143, 1),
(56005, 42144, 1),
(56005, 42145, 1),
(56005, 42146, 1),
(56005, 42148, 1),
(56005, 42149, 1),
(56005, 42150, 1),
(56005, 42151, 1),
(56005, 42152, 1),
(56005, 42153, 1),
(56005, 42154, 1),
(56005, 42155, 1),
(56005, 42156, 1),
(56005, 42157, 1),
(56005, 42158, 1),
(56005, 42701, 1),
(56005, 42702, 1),
(56005, 44066, 1),
(56005, 44076, 1),
(56005, 44078, 1),
(56005, 44081, 1),
(56005, 44082, 1),
(56005, 44084, 1),
(56005, 44087, 1),
(56005, 44088, 1),
(56005, 44089, 1),
(56005, 45054, 1),
(56005, 49110, 1);

---