[ANTRIX][CUSTOM] GM Vendors 2.0

This project can be found here:

http://forum.ragezone.com/f114/ascen...6/#post2507444

To mods: Request to have this thread merged with the new one under the same name, if thats not possible, please just delete this one.

This query will get rid of old AMVendors if you dont want duplicates, but you might want to keep the "low weapons" and "medium weapons" in AMVendors.

Code:

---

DELETE FROM creature_names WHERE entry BETWEEN '32000' AND '32015';
DELETE FROM creature_proto WHERE entry BETWEEN '32000' AND '32015';
DELETE FROM creature_spawns WHERE entry BETWEEN '32000' AND '32015';
DELETE FROM vendors WHERE vendorGuid BETWEEN '32000' AND '32015';

---

wow pretty cool thanks alot this takes a whole lotta of work outta my hands thanks alot and i hope you do more

My work can be found on terranet forums, whatever I release I usually put it there, if theres something you want to request me to do you can give me a PM, I'll have a look once I get time :).

Working Great ;) Nice work! ;D

thx for that, its awesome

How to buy stuff from the tier vendors when ju need badges?

Quote:

---

Originally Posted by Dannstah

How to buy stuff from the tier vendors when ju need badges?

---

then just type .lookupitem and type in the name of the item and when u get the id then .additem (id) and this way it skips the whole badge thing

UPDATE items set ItemExtendedCost=0

If you dont want the items to cost any badges and stuffs like that ;D

were do i set that " items set ItemExtendedCost=0 " rule ? i really want to know, so please help me out

//hertz

were do i set that rule? " set ItemExtendedCost=0 " please help me

Put it in QUERY and right click on "UPDATE items set ItemExtendedCost=0"
and select Execute Query > Execute current query

Its a sql query, just execute it with a sql manager.

Keep in mind that will make ALL items to 0 honor cost in all vendors. As well as any quest item requirements and stuff.

If you only want to get rid of the honor cost for the items I have, just run this:

Code:

---

UPDATE items SET ItemExtendedCost=0 WHERE name LIKE '%Merciless Gladiator\'s%';

---

or you can do it by itemset and ID

Code:

---

UPDATE items SET ItemExtendedCost=0 WHERE itemset BETWEEN '700' AND '716';
UPDATE items SET ItemExtendedCost=0 WHERE WHERE entry IN ('31958','31959','31965','31966','31984','31985','31986','32003','32014','32025','32026','32027','32028','32044','32046','32052','32053','32054','32055','32962','32963','32964');

---

Whatever suits you.

Anyways I'm going on vacation so wont be maintaining this thread for a few days.

Ideas for more vendors how about cloaks and also gems also an idea is one that sells the items the ya need to get the tier 5 ect like you can buy the items for gold off those.


Just some ideas.

WoW man these Vendors are brilliant my PLayers on my server love them thanks.