(MANGOS) Trade Skill Vendor

[Xecuter]

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

[MentaL]

[Xecuter]

[ekarlate]

nice job mate

[Xecuter]

nice job mate

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

[sony7771]

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!!

[Neosophye]

Few missing enchanting items i found so far

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

Very good job making these tho :)

[KillMeForPrizes]

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

[ShadeZeRO]

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

Are these for alliance only?

[anubizthot]

nice.. thx for the post !

[Xecuter]

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

[Neosophye]

Change the faction of the traders lets say to 35

Then both sides can use them

[ShadeZeRO]

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.

[Hallik09]

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

[ShadeZeRO]

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.

[Hallik09]

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.

[Xecuter]

Few missing enchanting items i found so far

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

Very good job making these tho :)

Added ^^ to the enchanting vendor and reuploaded a new File.

[Xecuter]

changed npc factions so that both alliance & horde could use them

[valandillos]

Hey, it's already asked, but does this also work before 1.12.x evrsions of wow?
Hope so...
PLZ answer me soon! I CANT WAIT :P
hehe Thnx for commend^^

Grtz

[valandillos]

Ok they work but 3 of them are blocks so change there creature id and you will have beautifull vendors THANKS

100031 has a tbc creature id i changed into NE :P
100033 (was it i though also one) and 10035 But you have to look
for yourself when you have no TBC server.

THNAKKSS they are soo beuaty :P