Results 1 to 4 of 4
Thread: Custom Vendors - set item number
-
31-05-11, 02:29 PM #1Beginner

- Join Date
- May 2011
- Posts
- 13
- Rep Power
- 15
- Reputation
- 2
Custom Vendors - set item number
Register to remove this adhello 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: --can anyone help me to add 20 instead of just one Alterac Manna Biscuit..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);
Sry my bad english
-
31-05-11, 03:08 PM #2
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
-
31-05-11, 03:49 PM #3Beginner

- Join Date
- May 2011
- Posts
- 13
- Rep Power
- 15
- Reputation
- 2
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 1you 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
-
03-06-11, 05:45 AM #4Beginner

- Join Date
- Nov 2010
- Posts
- 4
- Rep Power
- 16
- Reputation
- 1
Register to remove this adGo to truice or item_template and set BuyCount to 20...You can also change maxcount and stackable to 200 so players can carry 200...



Reply With Quote






