(MANGOS) Trade Skill Vendor

6 New vendors fully equiped for TBC & your trade skill needs.

A Leather vendor, with leather, Hides & Salts.
An Alchemy Vendor with all Herbs, vials, & a few fish (oily blackmouth).
An Enchanting Vendor with all rods, dusts, shards, & essensces.
An Ore Vendor with all bars & stones.
A Cloth vendor with every cloth type.
And a complete gem vendor.

Installation is as simple as copying the contents of the file and executing all the quaries in your DB.

Installation:
1) Open SQLyog
2) Open Xs_Trade_Vendors.txt
3) Select everything in the File & Copy.
4) In SQLyog click Mangos_bc
5) In the query section, to the right of Mangos_bc paste what you just copied from XS_trade_Vendor.txt
6) Right click in the query window
7) Execute Query ->
8) Execute All Queries

Done, just add Vendors where you want with the following commands


vendors are:
.addspw 100031
.addspw 100032
.addspw 100033
.addspw 100034
.addspw 100035
.addspw 100036

http://home.comcast.net/~xecuter/alchy.gifhttp://home.comcast.net/~xecuter/ore.gif
http://home.comcast.net/~xecuter/ench.gifhttp://home.comcast.net/~xecuter/cloth.gif
http://home.comcast.net/~xecuter/leather.gifhttp://home.comcast.net/~xecuter/gem.gif

nice job mate

Quote:

---

Originally Posted by ekarlate

nice job mate

---

Thx much, did you find anything missing from the vendors that you felt should be there?

i have a server working mangos 2.0.8
how i can add that in the sql

can u pls tell me the step is hard to do it 1-1


thanks hope to hear from u soon!!

Few missing enchanting items i found so far

12809 = Guardian Stone
20725 = Nexus Crystal
11754 = Black Diamond

Very good job making these tho :)

This is really nice - any chance we could get a edited back version of this for Mangos 1.21?

I got it to spawn in Org...but the problem is, it attacks us.

Are these for alliance only?

nice.. thx for the post !

Thanx for the info, i'll look into adding those missing things tomorrow, power is gonna be out here for a bit.

Change the faction of the traders lets say to 35

Then both sides can use them

Quote:

---

Originally Posted by Neosophye

Change the faction of the traders lets say to 35

Then both sides can use them

---

I put faction 474, it works now for horde, I'll see for alliance.

Not working, it runs the query, but it doesn't make the table under creature_template..

Quote:

---

Originally Posted by Hallik09

Not working, it runs the query, but it doesn't make the table under creature_template..

---

it works fine for me.

The table already exists, this just adds new entry's to it.
make sure navicat isn't limiting the number of viewable entries.

That's what I meant, after running the query, I checked under creature_template, and I didn't find the new entries. When I try to spawn them in-game, I get an error like the creature ID doesn't exist.