How to make Custom Vendors [Pic Guide]

[PaikProductions]

Hello,

Here is a Quik: How to make vendor guide!
I hade some time and decide to make a tut how i make the vendors.
here we go:

first login your database!
http://img166.imageshack.us/img166/9407/firststepbh1.jpg (http://imageshack.us/)

Go to creature_spawns and create your npc!
http://img166.imageshack.us/img166/7746/secondstepjn9.jpg (http://imageshack.us/)

After that go to creature_proto and create the levels etc. of your NPC - best faction to use is: 1741 http://www.ac-web.org/forum/venise/smilies/biggrin.gif
http://img166.imageshack.us/img166/8704/3stepek0.jpg (http://imageshack.us/)

Go to vendors!
http://img78.imageshack.us/img78/2209/4stepqa5.jpg (http://imageshack.us/)

Now after that, Click at the "+" button to add a item. Entry = ID of your NPC [Vendor], Item = ID of the item, Amount = How much the vendor have of that item. 1 = Can't be sold out 0 = Can't be sold out -1 = Can't be sold out!
I use -1. The other three just let them on 0!
http://img407.imageshack.us/img407/192/5stepwn7.jpg (http://imageshack.us/)

Go to Wowhead! (http://www.wowhead.com/) as e.g. use daggers:
http://img246.imageshack.us/img246/5448/step6dy5.jpg (http://imageshack.us/)

Then click on the dagger you like to add at your vendor, look above in your explore bar and use the ID as Item ID!
http://img246.imageshack.us/img246/92/step7wv7.jpg (http://imageshack.us/)

Put the ID that you just have copyed into item:
http://img246.imageshack.us/img246/1859/step8uj2.jpg (http://imageshack.us/)

After you fully created your vendor and you think you done, then if you want to share it, follow the steps that now comes:
http://img407.imageshack.us/img407/8536/step9sp8.jpg (http://imageshack.us/)
http://img368.imageshack.us/img368/9868/step10hx7.jpg (http://imageshack.us/)

After thats done open your file you just extracted as SQL file (its in your HeidiSQL, navicate etc you use)! Then scroll down to your vendor ID, Copy everything of that vendor and paste it in "NOTEPAD":
http://img368.imageshack.us/img368/5607/step11nz8.jpg (http://imageshack.us/)

After you put it in "NOTEPAD" save it as SQL file!, make sure you put .sql after the name!!!!:
http://img368.imageshack.us/img368/5492/step12nq1.jpg (http://imageshack.us/)


Text Guide:
first login your database!
then go to creature_spawns and create your npc.
After that go to creature_proto and create the levels etc. of your NPC - best faction to use is: 1741 http://www.ac-web.org/forum/venise/smilies/biggrin.gif. Go to vendors!
Now after that, Click at the "+" button to add a item. Entry = ID of your NPC [Vendor], Item = ID of the item, Amount = How much the vendor have of that item. 1 = Can't be sold out 0 = Can't be sold out -1 = Can't be sold out!
I use -1. The other three just let them on 0! Go to Wowhead! (http://www.wowhead.com/) as e.g. use daggers. Then click on the dagger you like to add at your vendor, look above in your explore bar and use the ID as Item ID! Put the ID that you just have copyed into item. After you fully created your vendor and you think you done, then if you want to share it, follow the steps that now comes. After thats done open your file you just extracted as SQL file (its in your HeidiSQL, navicate etc you use)! Then scroll down to your vendor ID, Copy everything of that vendor and paste it in "NOTEPAD". After you put it in "NOTEPAD" save it as SQL file!, make sure you put .sql after the name!!!

Congratulations you have succesfully made a vendor if you did it right! If something is not clear feel free to post a comment.http://www.ac-web.org/forum/venise/smilies/biggrin.gif

Credits:

-PaikProductions

[Easymode]

Ew why do you use HiediSQL, Have you tryed Navicat, i find it much simpler, and easy to use,
And Also :)
You Can Put &xml after the Item's (id) To get the display id, so say

example :www.wowhead.com/?item=40395
Put &xml After the item=40395 And a page wil load in XML, then scroll down till you see something looking like
<icon displayId="57250<---(This is the items display)">INV_Mace_82</icon>

So should look like this
www.wowhead.com/?item=40395&xml

Good luck

[enegue]

Thanks for having a picture guide, although I already made a guide on this without pictures though. By the way, no offense but, HeidiSQL sucks.

[PaikProductions]

Ye i know HeidiSQL sucks but it works fine i don't realy care about it :P!