anyone have custom gold vendor

[bomberman]

hey everyone, just wondering if anyone has a custom gold vendor script for an ascent server, and in .sql format, also if you could please tell me if it goes in the script_bin file or to just execute it into the database, thanks for the help ^_^ :wave:

[Dryice]

Is .mod gold 100000 to much for you?

[kayleta]

Just make an item that will sell for like 6k gold then make a vendor for it and of course make it cheap to buy so you can just buy then sell buy then sell...

[havak]

its easy to make one. just take an npc u dont use, then go into sql and find it and change the entry number to something you will remember. now go to WoW Vendetta - Wage Your War and make like a ring with no stats that sells, for like 1000 gold and call it something like resell me for gold. put the item quote as like worth millions. after that spawn the npc ingame (with the new number)and it should have no items now. then just add your ring u made to the vendor. if u want to change the name to like gold seller that is also easy. just find the npc u used again in sql and go to name and change it .

should take like 5 min hope i helped.

[cylas]

Execute this or throw it into a sql file and execute batch file via navicat etc. Whatever you prefer. Enjoy =) BTW this is for ascent and I use the ncdb 0.2.2. This is what I use personally and have saved on my desktop for making vendors quick.

/*Create NPC - Goldvender - ID 50100*/
INSERT INTO creature_names VALUES (50100, "Gold Vendor", "Custom Vendorr", 0, 4, 0, 3, 0, 0, 18106, 0, 0, 0, 0, 0, 0, 0);
INSERT INTO creature_proto VALUES (50100, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0, 3, 8, 15, 0);

/*Create Item To Be Sold For Gold*/
INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
VALUES (888888,2,0,-1,"Buy Me And Sell me","Buy Me And Sell me","Buy Me And Sell me","Buy Me And Sell me",0000,6,0,0000,5000000,13,-1,-1,0,0,0,0,0,0,0,0,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,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,0,0,0,0,0,0,0,"I Get You Gold Fast",0,0,0,0,0,1,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);

/*Insert Item Into Vendor*/
INSERT INTO vendors (`vendorGuid`, `itemGuid`, `amount`) VALUES(50100, 888888, 1);

Now see guys that wasn't so hard to help someone out was it? a few notes in the code and he'll be making tons of his own vendors in seconds.