Custom Vendors - set item number

**rampeixe** · 31-05-11, 01:29 PM

hello there

I want make a vendor that sell items, so far i did it well, the problem is i dont know a way to add a number of the item inself . for exemple i want 20 Alterac Manna Biscuit in the some slot but i only can get just one... i used this DataBase query: --

HTML 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,19301,0,0,0);

can anyone help me to add 20 instead of just one Alterac Manna Biscuit..
Sry my bad english

› See More: Custom Vendors - set item number

**abusofy2000** · 31-05-11, 02:08 PM

you see my one
1. open your MySQL by HeidiSQL then go to world and open creature_template press on data
2. look for a vendor from the mneu then duplicate it make new entry for it and if you like cheng the modil as you like dont forget press post at last
3.open npc_vendor then add the item you like press post then rset the server
that is all

**rampeixe** · 31-05-11, 02:49 PM

you see my one
1. open your MySQL by HeidiSQL then go to world and open creature_template press on data
2. look for a vendor from the mneu then duplicate it make new entry for it and if you like cheng the modil as you like dont forget press post at last
3.open npc_vendor then add the item you like press post then rset the server
that is all

maybe i didn't explain well what i want.. in my example i create one custom vendor that sells 1xAlterac Manna Biscuit, but the point is i want that custom vendor show 20xAlterac Manna Biscuit by the same price, not just 1