merchant id setup question
 

ok i am going fine with creating merchants. what i need to find out is if anyone has a list of merchant id's that shows id no's and the items that are included. I realize that this may be a huge request to fill... I do have mysql and mysql control center.
I also am trying to figure out how to put a helmet on a plate wearing vendor without changing it's gender.
I am a newb and this is my first posting.. i have been reading the forums and have garnered a wealth of info so far.
Also... is there a way ingame to edit a merchant and add his id tag etc. to make him work?
I'm hoping to be able to do this in the game... it seems a bit faster than doing it with the editors.

thanks for the great site. you all will make a programmer out of me yet! :)

(my head is spinning :!: this is gettin to be a really fun challenge!

The #spawn command lets you set the merchant id, not had a look at any of those commands for a while thought there could be one specifically. Try #help mer or #help id in game see if any of the results are useful. I do know spawn works though, see the sticky above.

Sorry, can't help with anything else :(

This is the perfect example of the sort of attitude people need :)


Monrezz

SELECT item FROM merchantlist WHERE merchantid = <your_merchant_id>;

That will dump a list of item id's for a given merchantid, and the merchantlist table is where you'll want to add/remove items on your merchants. If that's a pain for you like it is for me give it a little bit and I'll do up a perl script or two to make it a bit easier and post it for download.

I think he was asking for a complete list of items on Merchants in EQLive, not an SQL statement to list the items on merchants on his Emu server.

Monrezz

Be nice, wouldn't it?

Very :D

Still, going to do up that script because it annoys me having to work at a mysql prompt more than I have to. About 15% done just now.

Hey monrezz, you know offhand what the max value for the slot column under the merchantlist table is? For the emu I mean, not in the db.

i believe max is 80 like on live(havent tested this though)

Good enough, I'll cap at 64 just to be on the safe side and adjust it later if it turns out to be worth the trouble.

Ok; after many interruptions, some nintendo playing, a few beers, dinner, and other sundry things it's done, hosted, and announced.

a nice and convenient tool. We need more of these handy scripts. Thanks.