How to add an item to a vendor
Using Navicat.
Open merchant_buylists table
In the first field you put the items ID number. In the second field you put the price you want the vendor to sell it for. In the third field you put the shop ID number. This is found by looking in the merchant_shopids. In the fourth field you put the position of the item. If the shop has 54 items already and you want it at the end of the list, you give it item 55. This field is unique to just that vendors list. So you can not have 2 of the same item positions for one list.
Ok, to put it all togather.
I want to sell dual SLS at Trader Jackson fighter shop in TI for 150a and I want it listed last.
I need to look up Trader Jackson shop Id number in the merchant_shopids table. Her npc ID is 7002, so I look that up and she has 2 shop IDs. 11 and 12 Which one is which? Look in her html file. (7002.htm in the data/html/merchants folder) 11 is for fighter and 12 is for mystic. Dual SLS are item ID 2626 (find in weapons table) Trader Jackson has 54 items currently in the merchant_buylist. So my data to input into the merchant_buylists is 2626 150 11 55
Click the check mark at the bottom and exit navicat. Restart server to reload the list.
Yes, sorry this is confusing. If you do look through the above files/tables, you will see the method to the madness.
To make a GMshop, find a vendor that you want to add items to, get his ID and follow the guide above.
