PDA

View Full Version : Custom Vendors - set item number



rampeixe
31-05-11, 02: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: --
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 :)

abusofy2000
31-05-11, 03: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, 03: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

diantonio
03-06-11, 05:45 AM
Go to truice or item_template and set BuyCount to 20...You can also change maxcount and stackable to 200 so players can carry 200...