Follow us on
Follow us on Facebook Follow us on Twitter Watch us on YouTube


MMOCoin

Results 1 to 4 of 4
  1. #1
    Beginner

    Join Date
    May 2011
    Posts
    13
    Rep Power
    15
    Reputation
    2

    Custom Vendors - set item number


    Register to remove this ad
    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

  2. #2
    Beginner
    abusofy2000's Avatar
    Join Date
    Apr 2011
    Posts
    3
    Rep Power
    15
    Reputation
    1
    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

  3. #3
    Beginner

    Join Date
    May 2011
    Posts
    13
    Rep Power
    15
    Reputation
    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
    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

  4. #4
    Beginner

    Join Date
    Nov 2010
    Posts
    4
    Rep Power
    16
    Reputation
    1

    Register to remove this ad
    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...

 

 

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -5. The time now is 06:26 AM.
Powered by vBulletin® Copyright ©2000-2026, Jelsoft Enterprises Ltd.
vBulletin Licensed to: MMOPro.org
vBulletin Skin By: PurevB.com