[Archive] (Beginner Tutorial) - How to create a vendor
[Archive] (Beginner Tutorial) - How to create a vendor
11-04-2025, 05:04 PM
Original source
This is a share by Valkryst, I have asked him if I was allowed to share it and got his permission:
Before you decide to make a vendor there are a few important things that you need to figure out. These important bits of information include:
- What items will the vendor sell.
- Are any of the items rare or available in limited quantity?
- If any of the items are rare or available in limited quantity, how often should the vendor restock those items?
- In what order should the items be displayed in the vendor panel?
- Are any of the items being sold custom?
Just in case anyone wants to know what I’m running:
Windows 8, x64 — Home
Debian 7 x32 — Server
TrinityCore — Latest version as of 18/August/2014
WoTLK 3.3.5a
Assuming that you already have both the NPC you'll be using as a vendor and the items that the vendor will be selling created and ready-to-use, we can begin.
You will first need to run SELECT * FROM creature_template WHERE entry=vendorNPCEntryID; on your database to view the data for the vendor NPC. Now that the record for the vendor NPC is up, you only need to edit the npcflag field and set it to 128. The NPC will now be recognized as a vendor. Now use the following query to add an item to the vendor NPC's vendor panel.
Code:
/* To insert a single item into the vendor's vendor panel use this query.*/INSERT INTO npc_vendor (entry, slot, item, maxcount, incrtime, ExtendedCost) VALUES (0, 0, 0, 0, 0);
Code:
/* To insert multiple items at once, just chain the values together as seen below. This example allows for two items to be added to the vendor's vendor panel. */INSERT INTO npc_vendor (entry, slot, item, maxcount, incrtime, ExtendedCost) VALUES (0, 0, 0, 0, 0, 0, 0), (0, 0, 0, 0, 0, 0);
Now that you've created a vendor NPC and populated it's vendor panel with items to sell, you'll need to restartworldserver then you're ready to go!
Field Explanations:
entry - The entry ID of the vendor NPC. This is under the entry field of the creature_template table.
slot - The position in the vendor panel where this item will be located. As you can see in the image below, the slots are numbered left-to-right and top-to-bottom. This pattern repeats over all pages, but the numbers will continue incrementing.
![[Image: Post-15-Image-1.jpg]](http://valkryst.com/blog/wp-content/uploads/2014/08/Post-15-Image-1.jpg)
item - The entry ID of the item being sold. This is under the entry field of the item_template table.
maxcount - The maximum number of items carried by the vendor at any time. If you want the vendor to carry an unlimited number of the item then set this to 0 else set it to any positive number. In the image below the maxcount value is circled.
![[Image: Post-15-Image-2.jpg]](http://valkryst.com/blog/wp-content/uploads/2014/08/Post-15-Image-2.jpg)
incrtime - The time, in seconds (not milliseconds!), between restocks. As an example of how this is used... If maxcount is set to 4, incrtime set to 30, and the BuyCount field on the item in the item_template table is set to 2 then the vendor restocks 2 of the item every 30 seconds up to a total of4 items.
ExtendedCost - The value here corresponds to the ID in ItemExtendedCost.dbc and that ID controls the item's non monetary price, be it honor points, arena points, different types of badges or any combination of the above. (Taken from the TrinityCore documentation)
If you want to stay up-to-date with my latest tutorials or if you just want an easier way to view all of my tutorials and releases in one place then take a look at my blog.
rektbyfaith
11-04-2025, 05:04 PM #1Archived author: ExO • Posted: 2025-11-04T18:04:29.758927
Original source
This is a share by Valkryst, I have asked him if I was allowed to share it and got his permission:
Before you decide to make a vendor there are a few important things that you need to figure out. These important bits of information include:
- What items will the vendor sell.
- Are any of the items rare or available in limited quantity?
- If any of the items are rare or available in limited quantity, how often should the vendor restock those items?
- In what order should the items be displayed in the vendor panel?
- Are any of the items being sold custom?
Just in case anyone wants to know what I’m running:
Windows 8, x64 — Home
Debian 7 x32 — Server
TrinityCore — Latest version as of 18/August/2014
WoTLK 3.3.5a
Assuming that you already have both the NPC you'll be using as a vendor and the items that the vendor will be selling created and ready-to-use, we can begin.
You will first need to run SELECT * FROM creature_template WHERE entry=vendorNPCEntryID; on your database to view the data for the vendor NPC. Now that the record for the vendor NPC is up, you only need to edit the npcflag field and set it to 128. The NPC will now be recognized as a vendor. Now use the following query to add an item to the vendor NPC's vendor panel.
Code:
/* To insert a single item into the vendor's vendor panel use this query.*/INSERT INTO npc_vendor (entry, slot, item, maxcount, incrtime, ExtendedCost) VALUES (0, 0, 0, 0, 0);
Code:
/* To insert multiple items at once, just chain the values together as seen below. This example allows for two items to be added to the vendor's vendor panel. */INSERT INTO npc_vendor (entry, slot, item, maxcount, incrtime, ExtendedCost) VALUES (0, 0, 0, 0, 0, 0, 0), (0, 0, 0, 0, 0, 0);
Now that you've created a vendor NPC and populated it's vendor panel with items to sell, you'll need to restartworldserver then you're ready to go!
Field Explanations:
entry - The entry ID of the vendor NPC. This is under the entry field of the creature_template table.
slot - The position in the vendor panel where this item will be located. As you can see in the image below, the slots are numbered left-to-right and top-to-bottom. This pattern repeats over all pages, but the numbers will continue incrementing.
item - The entry ID of the item being sold. This is under the entry field of the item_template table.
maxcount - The maximum number of items carried by the vendor at any time. If you want the vendor to carry an unlimited number of the item then set this to 0 else set it to any positive number. In the image below the maxcount value is circled.
incrtime - The time, in seconds (not milliseconds!), between restocks. As an example of how this is used... If maxcount is set to 4, incrtime set to 30, and the BuyCount field on the item in the item_template table is set to 2 then the vendor restocks 2 of the item every 30 seconds up to a total of4 items.
ExtendedCost - The value here corresponds to the ID in ItemExtendedCost.dbc and that ID controls the item's non monetary price, be it honor points, arena points, different types of badges or any combination of the above. (Taken from the TrinityCore documentation)
If you want to stay up-to-date with my latest tutorials or if you just want an easier way to view all of my tutorials and releases in one place then take a look at my blog.
11-04-2025, 05:04 PM
Original source
Hi,
in the multiple Values, you have one "0" too much.
VALUES (0, 0, 0, 0, 0, 0, 0), should be 6 numbers
like this (0, 0, 0, 0, 0, 0);
Thx much for the tutorial, works great.
Greetings Seth
rektbyfaith
11-04-2025, 05:04 PM #2Archived author: ExO • Posted: 2025-11-04T18:04:29.758927
Original source
Hi,
in the multiple Values, you have one "0" too much.
VALUES (0, 0, 0, 0, 0, 0, 0), should be 6 numbers
like this (0, 0, 0, 0, 0, 0);
Thx much for the tutorial, works great.
Greetings Seth
11-04-2025, 05:04 PM
Original source
Quote:Sethargo said:Hey there! Great to know, glad to hear it helped you out!
Hi,
in the multiple Values, you have one "0" too much.
VALUES (0, 0, 0, 0, 0, 0, 0), should be 6 numbers
like this (0, 0, 0, 0, 0, 0);
Thx much for the tutorial, works great.
Greetings Seth
Click to expand...
rektbyfaith
11-04-2025, 05:04 PM #3Archived author: ExO • Posted: 2025-11-04T18:04:29.758927
Original source
Quote:Sethargo said:Hey there! Great to know, glad to hear it helped you out!
Hi,
in the multiple Values, you have one "0" too much.
VALUES (0, 0, 0, 0, 0, 0, 0), should be 6 numbers
like this (0, 0, 0, 0, 0, 0);
Thx much for the tutorial, works great.
Greetings Seth
Click to expand...
11-04-2025, 05:04 PM
Original source
cool stuff
![[Image: 1f642.png]](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
rektbyfaith
11-04-2025, 05:04 PM #4Archived author: ExO • Posted: 2025-11-04T18:04:29.758927
Original source
cool stuff
11-04-2025, 05:04 PM
Original source
Nice post, detailed, could this work on 5.4.8?
rektbyfaith
11-04-2025, 05:04 PM #5Archived author: ExO • Posted: 2025-11-04T18:04:29.758927
Original source
Nice post, detailed, could this work on 5.4.8?
11-04-2025, 05:04 PM
Original source
Quote:karaflas said:I haven't checked how it's handled on 5.4.8, the database colums etc however it should work just fine, yes.
Nice post, detailed, could this work on 5.4.8?
Click to expand...
Otherwise post your issues, and I'll help you out!
rektbyfaith
11-04-2025, 05:04 PM #6Archived author: ExO • Posted: 2025-11-04T18:04:29.758927
Original source
Quote:karaflas said:I haven't checked how it's handled on 5.4.8, the database colums etc however it should work just fine, yes.
Nice post, detailed, could this work on 5.4.8?
Click to expand...
Otherwise post your issues, and I'll help you out!
rektbyfaith
11-04-2025, 05:04 PM #7Archived author: ExO • Posted: 2025-11-04T18:04:29.758927
Original source
nice
11-04-2025, 05:04 PM
Original source
Great
rektbyfaith
11-04-2025, 05:04 PM #8Archived author: ExO • Posted: 2025-11-04T18:04:29.758927
Original source
Great
11-04-2025, 05:04 PM
Original source
Very usefull!
rektbyfaith
11-04-2025, 05:04 PM #9Archived author: ExO • Posted: 2025-11-04T18:04:29.758927
Original source
Very usefull!
11-04-2025, 05:04 PM
Original source
Great, thanks!
rektbyfaith
11-04-2025, 05:04 PM #10Archived author: ExO • Posted: 2025-11-04T18:04:29.758927
Original source
Great, thanks!
Recently Browsing
1 Guest(s)
1 Guest(s)
Recently Browsing
1 Guest(s)
1 Guest(s)