Vendors of tradeskill goods

[eski2]

For people playing on the minilogin servers, buying a potion from a shaman vendor is not an option. This is a shame as potions add viability to soloing (although i really can't figure the potion belt out, it's more awkward than in other games i've played).

Since the economy of a soloer is isolated and might be really warped (some will just give themselves bazillions of plat because they can, i know i had to see what it was like to be too encumbered to move from plat, ah!), the only way to get them in game is either create an alt and tradeskill them (which is not much fun without macros and a viable economy to gather the ingredients for you) or use gm commands. Gm commands are like game killers, potentially, and i'd like to minimise them in my solo game. I played with the idea of having some means of trading between servers but the potential for abuse was horrible.

(I remember how i felt when my EQ server was overrun by people botting or playing for money in third world sweatshops... i stopped playing because i couldn't compete if i didn't cheat, bit like baseball players and steroids i suppose.)

Would it be hard to select all tradeskill produced items and put them on vendors? i presume the cost of almost every item has already been chosen in Titanium as i used to see player made products on vendors occasionally but it was cheaper to buy at the bazaar. without a working bazaar in a solo game, a vendor would be a good alternative and the prices shouldn't make them over used.

Note to self; must learn SQL. I suspect this is really easy to organise with a few lines of coding.

[ndnet]

Some groundwork for this. If you're able to run SQL queries against your database, these could be helpful in going the rest of the way towards what you're wanting.

"What tradeskill-resultant items are in my databaes?" The recipe names seem to be a good enough description.
SELECT
a.name as 'Recipe Name',
b.item_id as 'Items Table ID'
FROM
tradeskill_recipe as a,
tradeskill_recipe_entries as b
WHERE
a.id = b.recipe_id AND
b.successcount >= 1


If you want not only the tradeskill items but also their components, you might be more interested in this query. Essentially, the above query without the constraint that the item is returned on success:
SELECT
a.name as 'Recipe Name',
b.item_id as 'Items Table ID'
FROM
tradeskill_recipe as a,
tradeskill_recipe_entries as b
WHERE
a.id = b.recipe_id

You're gonna get a lot of items from these queries so it might be best to break up your purchasable item list by tradeskill:

SELECT
a.name as 'Recipe Name',
b.item_id as 'Items Table ID'
FROM
tradeskill_recipe as a,
tradeskill_recipe_entries as b
WHERE
a.id = b.recipe_id AND
a.tradeskill = TRADESKILLNUMBER


Where you match TRADESKILLNUMBER with one of the following values:
55 FISHING
56 MAKE_POISON
57 TINKERING
58 RESEARCH
59 ALCHEMY
60 BAKING
61 TAILORING
62 SENSE_TRAPS
63 BLACKSMITHING
64 FLETCHING
65 BREWING
66 ALCOHOL_TOLERANCE
67 BEGGING
68 JEWELRY_MAKING
69 POTTERY

What's left is to go after the merchantlist and npc_types tables. merchantlist is a very simple table comprised of only merchantid, slot, and itemid -- The merchantid corresponds to the npc_types's field merchant_id -- Match these up and the NPC should sell what's listed in merchantlist (Well you also have to make the npc_type class '41' for merchant).

[ndnet]

A bit more time spent with this. Someone more versed with SQL might be able to whip this into something more optimized, but here's what I came up with.

This bit of SQL accomplishes the following:
- Creates a new npc_type entry and merchantlist entries
Given the following:
- Tradeskill number (from post above)
- MerchantID number (check your database and find a number not in use, plug it in)
- Merchant name and associated values to use in the npc_types entry, e.g. race, class, level, hp, etc -- you can customize this as much as you want.


DROP TABLE IF EXISTS merchantlist_tskills;

CREATE TABLE IF NOT EXISTS
merchantlist_tskills
(slot INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, itemid INTEGER);

INSERT INTO merchantlist_tskills (itemid) (
SELECT
tradeskill_recipe_entries.item_id
FROM
tradeskill_recipe,
tradeskill_recipe_entries
WHERE
tradeskill_recipe.id = tradeskill_recipe_entries.recipe_id AND
tradeskill_recipe.tradeskill = TRADESKILLNUMBER AND
tradeskill_recipe_entries.successcount = 1
);
INSERT INTO merchantlist (merchantid, slot, item)
(SELECT 'MERCHANTID', slot, itemid FROM merchantlist_tskills);

DROP TABLE merchantlist_tskills;

INSERT INTO npc_types (name, level, race, class, gender, texture, merchant_id) VALUES ('MERCHANT_NAME00', 1, 1, 41, 0, 0, MERCHANTID);


When done, you should have a lot of new merchantlist entries and a new npc_type entry. You should then be able to use the #dbspawn command (I believe) to go poop your new merchant out wherever you want and perform other associated world-building magicks to set them up.

To note, I have not tested this in-game. I'm not sure what the ramifications are for having a merchantlist's slot value go so high (prior to this, the max amount of items a merchant has listed in my DB from PEQ is 78.. 80 might be the most the server will recognize).

Let me know how it goes ;)

[eski2]

I think i might have done that right, although my brain kept thinking of drop down boxes and "create new merchant" buttons, as i hate checking things like "what is the next free merchant id?" as if you make a mistake, it's a big one. I still don't know how to back up the database. Oh, is there any way to get eqemu to reload the database without closing and re-oping the application? When i make changes it's tedious to have to close all and reload.

I'll post the results ASAP.

[eski2]

no luck, i can spawn the vendor but he has no inventory.

I use SELECT
a.name as 'Recipe Name',
b.item_id as 'Items Table ID'
FROM
tradeskill_recipe as a,
tradeskill_recipe_entries as b
WHERE
a.id = b.recipe_id AND
a.tradeskill = 59
and i can see the right results, exported it looks like
"Recipe Name","Items Table ID"
"essence of concealment",51144
"essence of concealment",16518
"essence of concealment",10062
"essence of concealment",14246
"essence of concealment",65590
"essence of concealment",17901
"essence of concealment",17770
"essence of concealment",10062
"concoction of flame i",51432
"concoction of flame i",51396
etc.

So i must be close. Merchant ID 345178 was unused so i tried
INSERT INTO merchantlist (merchantid, slot, item)
(SELECT '345178', slot, itemid FROM merchantlist_tskills);

DROP TABLE merchantlist_tskills;

INSERT INTO npc_types (name, level, race, class, gender, texture, merchant_id) VALUES ('Alchemy_Vendor', 1, 1, 41, 0, 0, 345178);

Was that what you meant? "SELECT * FROM merchantlist m; " showed the last as 345177, i thought that a new one would have been created?

[ndnet]

Did you run the whole query in the last code block? There was a lot there which set up and populated a temporary table to be used for sticking stuff back into the merchantlist table.

I'll go through it line by line and explain the reasoning:

DROP TABLE IF EXISTS merchantlist_tskills;

This I just added because I was debugging the script a lot so I wanted to ensure some cleanup was done no matter if it finished or not.


CREATE TABLE IF NOT EXISTS
merchantlist_tskills
(slot INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, itemid INTEGER);

This creates the table merchantlist_tskills for our temporary storage. If doing this one line at a time to find where it's stopping, make sure the table exists after this query or the rest is just going to bomb out.


INSERT INTO merchantlist_tskills (itemid) (
SELECT
tradeskill_recipe_entries.item_id
FROM
tradeskill_recipe,
tradeskill_recipe_entries
WHERE
tradeskill_recipe.id = tradeskill_recipe_entries.recipe_id AND
tradeskill_recipe.tradeskill = TRADESKILLNUMBER AND
tradeskill_recipe_entries.successcount = 1
);
This populates the temporary table we just made with item IDs and slot numbers to get it ready to be shoved into the merchantlist table.

INSERT INTO merchantlist (merchantid, slot, item)
(SELECT 'MERCHANTID', slot, itemid FROM merchantlist_tskills);

This grabs the data from our temporary table, adds an extra field (the merchantid), and throws it all into the merchantlist table, creating the merchant's inventory data. In your response, this doesn't appear to have been run because there were no entries with that merchantid.

DROP TABLE merchantlist_tskills;
This is to clean up the temporary table we made since we no longer need it.

INSERT INTO npc_types (name, level, race, class, gender, texture, merchant_id) VALUES ('MERCHANT_NAME00', 1, 1, 41, 0, 0, MERCHANTID);
And finally this creates a new npc_types entry for the NPC with class of merchant and connected to the right merchant ID from the merchantlist table. This query apparently worked as you were able to spawn the NPC? But I suppose it failed for you somewhere prior to that.

Make sure that you're running everything, though, as starting in the middle will wind up with some odd stuffs.

[eski2]

I got sick of bashing my head against the wall because of my sql ignorance.
I exported the list of SELECT
a.name as 'Recipe Name',
b.item_id as 'Items Table ID'
FROM
tradeskill_recipe as a,
tradeskill_recipe_entries as b
WHERE
a.id = b.recipe_id AND
a.tradeskill = 59 to CSV, imported it into excel and exported it as tab delimited, then used GeorgeS' merchant tool to paste in the list that way. Very clumsy, but it seemed to work. I think i'm stuffing up the INSERT INTO merchantlist (merchantid, slot, item)
(SELECT 'MERCHANTID', slot, itemid FROM merchantlist_tskills); section. I'll try booting up and if it worked i'll post, otherwise time to call it a night.

[eski2]

partial success. i think i hit the limit on vendor items, and also mutiple dose potions are being sold as single use. Some items were selling for 0, presumably they are supposed to be no drop or something. But this is sort of working!

[ndnet]

Could you post the limit on the number of items allowable by vendors? I'd imagine it's something like 80, but it'd be nice to know what limitations you ran into when trying this.

Thanks :)

[eski2]

I don't know how to do that, except counting the items manually? Part of the problem is that many things with the same name have different item ID's and i think what is displayed is not what is really there. I'll see what i can do.

"Recipe Name","Items Table ID"
"essence of concealment",51144
"essence of concealment",16518
"essence of concealment",10062
"essence of concealment",14246
"essence of concealment",65590
"essence of concealment",17901
"essence of concealment",17770
"essence of concealment",10062

[eski2]

Is there a log or something in the eq client that would help?

[eski2]

Maybe i'm wrong? maybe it is all there; i see a 5 dose of assailing (which has only one when you buy it) going alphabetically to zombie skin?

[eski2]

...

INSERT INTO merchantlist_tskills (itemid) (
SELECT
tradeskill_recipe_entries.item_id
FROM
tradeskill_recipe,
tradeskill_recipe_entries
WHERE
tradeskill_recipe.id = tradeskill_recipe_entries.recipe_id AND
tradeskill_recipe.tradeskill = TRADESKILLNUMBER AND
tradeskill_recipe_entries.successcount = 1
);

I'm uncertain as to what are things i should change in this code quote, but i'm assuming all i have to do is swap TRADESKILLNUMBER for 60 if i want a baker merchant.

INSERT INTO merchantlist (merchantid, slot, item)
(SELECT 'MERCHANTID', slot, itemid FROM merchantlist_tskills);

This grabs the data from our temporary table, adds an extra field (the merchantid), and throws it all into the merchantlist table, creating the merchant's inventory data. In your response, this doesn't appear to have been run because there were no entries with that merchantid.




If i do this verbatim, i get the error "Incorrect integer value: 'MERCHANTID' for column 'merchantid' at row 1" so i am guessing MERCHANTID has to be picked from
SELECT * FROM merchantlist m;
and looking at the last entry, which gives "345202 0 0" , so i blindly substitute in
INSERT INTO merchantlist (merchantid, slot, item)
(SELECT 345202, slot, itemid FROM merchantlist_tskills);
and get "Duplicate entry '345202-22129' for key 2" and then i realise i really don't know SQL at all. I try incrementing and get "Duplicate entry '345203-22129' for key 2". Maybe i need to type
INSERT INTO merchantlist (345203, slot, item) ?

I really don't know what i'm doing :P

[ndnet]

MERCHANTID has to be a unique number that you picked after finding one that isn't already in use in your merchantlist table. As for TRADESKILLNUMBER, you have that assumption correct.

[GeorgeS]

Actually, with merchant editor, assigning all tradeskill items to random merchants is very doable.

(1) Identify all tradeskill items and create a tab delimited file itenmane <tab> itemid.
(2) Import into merchant editor with import item list menu item
(3) Items appear in item buffer
(4) click expand and make sure add to selected merchants=100%
(5) Zone name = ALL, search and result of all merchants are loaded
(6) Select ALL merchants - shift mouse click selection
(7) Click on Select ALL merchants - wait a while till done
(7a) Click on save


Now you've appended all merchants with all items in buffer list.
What I do is add selected merchants=33%, so each item has a 33% chance of being added. This in effect randomizes the merchant sell lists...

Hope that helps

GeorgeS

[eski2]

In case anyone is interested, I noticed the baking list had a huge number of duplicate names so i've tried to use excel to eliminate dupes.

cheesy potato soup 66114
muckskipper chowder 66119
herb crusted whitefish 66118
poached chub 66116
glazed carp 66117
1 lb. cragbeast meat 51206
1 lb. hynid meat 51381
1 lb. saltwater crab 51176
1 lb. saltwater tuna 51191
barbequed crab appetizers 58353
barbequed crab cakes 58358
barbequed crab meat 58296
barbequed crab rolls 58354
barbequed crab souffle 58357
barbequed crab soup 58356
barbequed crab steaks 58359
barbequed crab stew 58355
barbequed crab pie 58360
barbequed crab sandwich 58361
barbequed cragbeast jerky 58533
barbequed cragbeast kabobs 58536
barbequed cragbeast meat 58480
barbequed cragbeast sandwich 58538
barbequed cragbeast souffle 58534
barbequed cragbeast soup 58532
barbequed cragbeast steaks 58535
barbequed cragbeast stew 58531
barbequed cragbeast pie 58537
barbequed hynid jerky 58616
barbequed hynid kabobs 58619
barbequed hynid meat 58563
barbequed hynid sandwich 58621
barbequed hynid souffle 58617
barbequed hynid soup 58615
barbequed hynid steaks 58618
barbequed hynid stew 58614
barbequed hynid pie 58620
barbequed tuna cakes 58450
barbequed tuna meat 58388
barbequed tuna rolls 58446
barbequed tuna salad 58445
barbequed tuna souffle 58449
barbequed tuna soup 58448
barbequed tuna steaks 58451
barbequed tuna stew 58447
barbequed tuna pie 58452
barbequed tuna sandwich 58453
beer-battered crab appetizers 58371
beer-battered crab cakes 58376
beer-battered crab meat 58298
beer-battered crab rolls 58372
beer-battered crab souffle 58375
beer-battered crab soup 58374
beer-battered crab steaks 58377
beer-battered crab stew 58373
beer-battered crab pie 58378
beer-battered crab sandwich 58379
beer-battered cragbeast jerky 58549
beer-battered cragbeast kabobs 58552
beer-battered cragbeast meat 58482
beer-battered cragbeast sandwich 58554
beer-battered cragbeast souffle 58550
beer-battered cragbeast soup 58548
beer-battered cragbeast steaks 58551
beer-battered cragbeast stew 58547
beer-battered cragbeast pie 58553
beer-battered hynid jerky 58632
beer-battered hynid kabobs 58635
beer-battered hynid meat 58565
beer-battered hynid sandwich 58637
beer-battered hynid souffle 58633
beer-battered hynid soup 58631
beer-battered hynid steaks 58634
beer-battered hynid stew 58630
beer-battered hynid pie 58636
beer-battered tuna cakes 58468
beer-battered tuna meat 58390
beer-battered tuna rolls 58464
beer-battered tuna salad 58463
beer-battered tuna souffle 58467
beer-battered tuna soup 58466
beer-battered tuna steaks 58469
beer-battered tuna stew 58465
beer-battered tuna pie 58470
beer-battered tuna sandwich 58471
beer-braised crab appetizers 58362
beer-braised crab cakes 58367
beer-braised crab meat 58297
beer-braised crab rolls 58363
beer-braised crab souffle 58366
beer-braised crab soup 58365
beer-braised crab steaks 58368
beer-braised crab stew 58364
beer-braised crab pie 58369
beer-braised crab sandwich 58370
beer-braised cragbeast jerky 58541
beer-braised cragbeast kabobs 58544
beer-braised cragbeast meat 58481
beer-braised cragbeast sandwich 58546
beer-braised cragbeast souffle 58542
beer-braised cragbeast soup 58540
beer-braised cragbeast steaks 58543
beer-braised cragbeast stew 58539
beer-braised cragbeast pie 58545
beer-braised hynid jerky 58624
beer-braised hynid kabobs 58627
beer-braised hynid meat 58564
beer-braised hynid sandwich 58629
beer-braised hynid souffle 58625
beer-braised hynid soup 58623
beer-braised hynid steaks 58626
beer-braised hynid stew 58622
beer-braised hynid pie 58628
beer-braised tuna cakes 58459
beer-braised tuna meat 58389
beer-braised tuna rolls 58455
beer-braised tuna salad 58454
beer-braised tuna souffle 58458
beer-braised tuna soup 58457
beer-braised tuna steaks 58460
beer-braised tuna stew 58456
beer-braised tuna pie 58461
beer-braised tuna sandwich 58462
buttered crab appetizers 58326
buttered crab cakes 58331
buttered crab meat 58293
buttered crab rolls 58327
buttered crab souffle 58330
buttered crab soup 58329
buttered crab steaks 58332
buttered crab stew 58328
buttered crab pie 58333
buttered crab sandwich 58334
buttered cragbeast jerky 58509
buttered cragbeast kabobs 58512
buttered cragbeast meat 58477
buttered cragbeast sandwich 58514
buttered cragbeast souffle 58510
buttered cragbeast soup 58508
buttered cragbeast steaks 58511
buttered cragbeast stew 58507
buttered cragbeast pie 58513
buttered hynid jerky 58592
buttered hynid kabobs 58595
buttered hynid meat 58560
buttered hynid sandwich 58597
buttered hynid souffle 58593
buttered hynid soup 58591
buttered hynid steaks 58594
buttered hynid stew 58590
buttered hynid pie 58596
buttered tuna cakes 58423
buttered tuna meat 58385
buttered tuna rolls 58419
buttered tuna salad 58418
buttered tuna souffle 58422
buttered tuna soup 58421
buttered tuna steaks 58424
buttered tuna stew 58420
buttered tuna pie 58425
buttered tuna sandwich 58426
caesar salad 58641
saltwater crab meat 58288
cragbeast meat 58472
dried crab meat 58289
dried cragbeast meat 58473
dried hynid meat 58556
dried tuna meat 58381
dwarven salad 58644
elven salad 58642
erudian salad 58643
garlic-buttered crab appetizers 58335
garlic-buttered crab cakes 58340
garlic-buttered crab meat 58294
garlic-buttered crab rolls 58336
garlic-buttered crab souffle 58339
garlic-buttered crab soup 58338
garlic-buttered crab steaks 58341
garlic-buttered crab stew 58337
garlic-buttered crab pie 58342
garlic-buttered crab sandwich 58343
garlic-buttered cragbeast jerky 58517
garlic-buttered cragbeast kabobs 58520
garlic-buttered cragbeast meat 58478
garlic-buttered cragbeast sandwich 58522
garlic-buttered cragbeast souffle 58518
garlic-buttered cragbeast soup 58516
garlic-buttered cragbeast steaks 58519
garlic-buttered cragbeast stew 58515
garlic-buttered cragbeast pie 58521
garlic-buttered hynid jerky 58600
garlic-buttered hynid kabobs 58603
garlic-buttered hynid meat 58561
garlic-buttered hynid sandwich 58605
garlic-buttered hynid souffle 58601
garlic-buttered hynid soup 58599
garlic-buttered hynid steaks 58602
garlic-buttered hynid stew 58598
garlic-buttered hynid pie 58604
garlic-buttered tuna cakes 58432
garlic-buttered tuna meat 58386
garlic-buttered tuna rolls 58428
garlic-buttered tuna salad 58427
garlic-buttered tuna souffle 58431
garlic-buttered tuna soup 58430
garlic-buttered tuna steaks 58433
garlic-buttered tuna stew 58429
garlic-buttered tuna pie 58434
garlic-buttered tuna sandwich 58435
grilled crab appetizers 58299
grilled crab cakes 58304
grilled crab meat 58290
grilled crab rolls 58300
grilled crab souffle 58303
grilled crab soup 58302
grilled crab steaks 58305
grilled crab stew 58301
grilled crab pie 58306
grilled crab sandwich 58307
grilled cragbeast jerky 58485
grilled cragbeast kabobs 58488
grilled cragbeast meat 58474
grilled cragbeast sandwich 58490
grilled cragbeast souffle 58486
grilled cragbeast soup 58484
grilled cragbeast steaks 58487
grilled cragbeast stew 58483
grilled cragbeast pie 58489
grilled hynid jerky 58568
grilled hynid kabobs 58571
grilled hynid meat 58557
grilled hynid sandwich 58573
grilled hynid souffle 58569
grilled hynid soup 58567
grilled hynid steaks 58570
grilled hynid stew 58566
grilled hynid pie 58572
grilled tuna meat 58382
grilled tuna rolls 58392
grilled tuna salad 58391
grilled tuna souffle 58395
grilled tuna soup 58394
grilled tuna steaks 58397
grilled tuna stew 58393
grilled tuna pie 58398
grilled tuna sandwich 58399
hynid meat 58555
lemon-buttered crab appetizers 58344
lemon-buttered crab cakes 58349
lemon-buttered crab meat 58295
lemon-buttered crab rolls 58345
lemon-buttered crab souffle 58348
lemon-buttered crab soup 58347
lemon-buttered crab steaks 58350
lemon-buttered crab stew 58346
lemon-buttered crab pie 58351
lemon-buttered crab sandwich 58352
lemon-buttered cragbeast jerky 58525
lemon-buttered cragbeast kabobs 58528
lemon-buttered cragbeast meat 58479
lemon-buttered cragbeast sandwich 58530
lemon-buttered cragbeast souffle 58526
lemon-buttered cragbeast soup 58524
lemon-buttered cragbeast steaks 58527
lemon-buttered cragbeast stew 58523
lemon-buttered cragbeast pie 58529
lemon-buttered hynid jerky 58608
lemon-buttered hynid kabobs 58611
lemon-buttered hynid meat 58562
lemon-buttered hynid sandwich 58613
lemon-buttered hynid souffle 58609
lemon-buttered hynid soup 58607
lemon-buttered hynid steaks 58610
lemon-buttered hynid stew 58606
lemon-buttered hynid pie 58612
lemon-buttered tuna cakes 58441
lemon-buttered tuna meat 58387
lemon-buttered tuna rolls 58437
lemon-buttered tuna salad 58436
lemon-buttered tuna souffle 58440
lemon-buttered tuna soup 58439
lemon-buttered tuna steaks 58442
lemon-buttered tuna stew 58438
lemon-buttered tuna pie 58443
lemon-buttered tuna sandwich 58444
medium salad 58639
small salad 58638
smoked crab appetizers 58317
smoked crab cakes 58322
smoked crab meat 58292
smoked crab rolls 58318
smoked crab souffle 58321
smoked crab soup 58320
smoked crab steaks 58323
smoked crab stew 58319
smoked crab pie 58324
smoked crab sandwich 58325
smoked cragbeast jerky 58501
smoked cragbeast kabobs 58504
smoked cragbeast meat 58476
smoked cragbeast sandwich 58506
smoked cragbeast souffle 58502
smoked cragbeast soup 58500
smoked cragbeast steaks 58503
smoked cragbeast stew 58499
smoked cragbeast pie 58505
smoked hynid jerky 58584
smoked hynid kabobs 58587
smoked hynid meat 58559
smoked hynid sandwich 58589
smoked hynid souffle 58585
smoked hynid soup 58583
smoked hynid steaks 58586
smoked hynid stew 58582
smoked hynid pie 58588
smoked tuna cakes 58414
smoked tuna meat 58384
smoked tuna rolls 58410
smoked tuna salad 58409
smoked tuna souffle 58413
smoked tuna soup 58412
smoked tuna steaks 58415
smoked tuna stew 58411
smoked tuna pie 58416
smoked tuna sandwich 58417
spiced crab appetizers 58308
spiced crab cakes 58313
spiced crab meat 58291
spiced crab rolls 58309
spiced crab souffle 58312
spiced crab soup 58311
spiced crab steaks 58314
spiced crab stew 58310
spiced crab pie 58315
spiced crab sandwich 58316
spiced cragbeast jerky 58493
spiced cragbeast meat 58475
spiced cragbeast sandwich 58498
spiced cragbeast souffle 58494
spiced cragbeast steaks 58495
spiced cragbeast pie 58497
spiced hynid jerky 58576
spiced hynid kabobs 58579
spiced hynid meat 58558
spiced hynid sandwich 58581
spiced hynid souffle 58577
spiced hynid soup 58575
spiced hynid steaks 58578
spiced hynid stew 58574
spiced hynid pie 58580
spiced tuna cakes 58405
spiced tuna meat 58383
spiced tuna rolls 58401
spiced tuna salad 58400
spiced tuna souffle 58404
spiced tuna soup 58403
spiced tuna steaks 58406
spiced tuna stew 58402
spiced tuna pie 58407
spiced tuna sandwich 58408
tuna meat 58380
frost giant steak 19989
muskie marinade 20384
halas 10lb meat pie 9752
filleted mammoth 9747
filleted wolf 9746
filleted bear 9744
filleted lion 9745
cream 9726
creamy fennel sauce 9743
bear fillet in cream 9748
apricot marmalade 9660
marmalade sandwich 24465
jumjum salad (ground) 9661
royal mints 9657
slice of jumjum cake 9655
mature cheese 9659
loaf of bread 13015
misty thicket picnic 9662
lucky cabbage 9653
chocolate marr cherries 19992
taelosian mountain wheat flour 58150
wayfarer muffin 58193
wayfarer pie 58198
wayfarer pastry 58196
shellcracker's seaside salad 9778
birthday cake 16562
birthday cake slice 16564
taelosian wheat flour 58155
jaggedpine stir fry 8190
spicy tuna salad sandwich 55526
tuna rice surprise 55532
taelosian tuna kabobs 55528
pan-seared orange tuna 55527
egg batter 67741
grilled guppy 66115
wayfarer wheat crackers 58219
wayfarer loaf 58192
wayfarer cookie 58182
wayfarer fruitcake 58187
clump of dough 13090
thick lotus paste 9648
hot-n-spicy toelings 13461
ohabah truffles 9754
rat ear turnovers 13492
beetle eye pie 13490
mammoth fillet in cream 9751
lotus pie 9649
wolf fillet in cream 9750
lion fillet in cream 9749
pickled gator 13454
shark fillet 13457
raptor steak 20399
wedding cake 16561
wedding cake slice 16563
owlbear sandwich 14589
berry pie 13493
fruit pie 13494
vegetable pie 13491
candied tae ew 27809
batwing crunchies 13462
fish rolls 13475
fish fillets 13468
mind worm steaks 30191
dragon steaks 19995
pickled drake 19169
centi steaks 30190
tae ew soup 27807
rat sandwich 13474
wooly spider crunchies 13463
sonicwolf sandwich 14588
boiled rockhopper egg 3457
blackened panther 20398
pickled wyvern 19166
pickled frost giant 19171
jumjum cake (ground) 9654
grilled cheese sandwich 8193
patty melt 8194
potameid pate 8198
centi toe stew 30189
blackened teir'dal 13459
holy cake 9733
pixie powder cinnesticks 19993
cheesy anaconda casserole 8184
cheesy griffon casserole 8185
dark chocolate creme 9755
pickled wurm 19167
beer braised lion 13451
beer braised bear 13447
beer braised rat 13449
bear steaks 13442
cheesy vegetable casserole 8186
storm giant steak 19990
wolf steaks 13441
pinemyer pasta 8177
dwarf chops 13458
griffon stir fry 8191
pasta with meat sauce 8180
pasta with cheese 8178
siren pickles 19162
smoked shark 13470
smoked wood elf 13469
vegetable pasta 8179
thunder salmon in cream 9771
white chocolate 16560
winter chocolate 16570
bear sandwich 13472
gator steaks 13444
lion steaks 13443
lizard-on-a-stick 13465
meat pie 13017
pickled lizard 13453
scorpion sandwich 19988
snake pickles 20397
snake steak 20396
batwing pie 13599
beer braised gator 13450
kobold steaks 19994
hearty meat sauce 8176
owlbear steaks 14884
pickled bixie 13455
pickled froglok 13452
pound cake 13495
anaconda stir fry 8192
beer braised mammoth 13448
beer braised wolf 13446
fish in cream sauce 23581
gnoll chops 8219
green gill juice 9781
liquidised gator 9763
liquidised rat 9761
liquidised snake 9762
noodles 8175
omelette du fromage 8187
panther pate 8278
gnome kabobs 13466
ranger's omelet 8188
rolled cutlassfish 20389
bug bites 13600
candied spider 13497
chocolate cookies 16571
chocolate muffins 16572
cup cakes 13488
edible goo 13498
fish head soup 13479
muffin 13014
pickled gnoll 8223
rabbit stew 11350
rat ear sandwich 13478
rat kabobs 13467
vegetable soup 13480
wolf sandwich 13471
griffon melt 8196
anaconda melt 8195
bixie crunchies 13464
cookies 13482
gnome shaped cookie 13484
troll shaped cookie 13485
animal shaped cookie 13486
barbarian shaped cookie 13483
salmon fillets 20392
caynar nut stuffed trout 19999
deadly medley 13602
dryad pate 8199
sea green cookies 19172
saucy bearmeat 1451
mammoth steaks 13445
shark rolls 13477
elven veal 13460
carp fillets 20393
chub fillets 20394
pike fillets 20395
trout fillets 20391
gator rolls 13476
hot cross buns 13496
kunzar glue 23613
butter 29742
mammoth sandwich 13473
ulthork meat pie 1427
pickled dryad 8221
tae ew roll 27806
pickled storm giant 19170
uncooked rat ear pie 13191
snow griffin souffle 1428
tae ew sandwich 27805
pickled troll 13456
pickled dragon 19165
pickled unicorn 19177
white chocolate cookies 16573
white chocolate muffins 16574
orange flavored cod 19998
weary wrass in cream 9773
pickled faun 19178
pot of spicy fish stew 5566
salty whitefish fillets 20388
vegetable roughy 20385
large slumberfish pie 9774
swamp rat crunchies 29756
tae ew skewers 27804
tae ew pie 27808
sifaye pickles 19176
spine poison extract 14798
spiced heartfruit 29788
blood raven stew 29749
boar chops 29771
breaded giant halibut 15969
breaded giant snapper 15968
breaded storm salmon 15967
brown gravy 29753
buttered crawdad 15963
candied cockroach 15962
dressing 29766
giant halibut steak 15966
giant snapper steak 15965
hero sandwich 29762
smoked hero parts 29765
spiced hero parts 29764
hobgoblin surprise 29751
jord meat pie 29769
mephit meat pie 29743
phoenix dough 29745
mephit sandwich 15957
bucket of crab legs 29775
cracked regrua meat 29776
slarghilug stuffed poppers 29747
storm salmon fillet 15964
tormentor stir fry 29758
triloun tail soup 29773
vann toe stew 29767
tundrabear sandwich 1425
abalone steaks 65492
crispy gourami 65493
dried seaweed 65494
grilled eel 65496
sea cucumber soup 65491
sea urchin stew 65495
moonstone tear 29784
catfish croak sandwich 12451
green gill in cream 9783
elf essence 11274
grilled tuna cakes 58396
large salad 58640
spiced cragbeast soup 58492
spiced cragbeast stew 58491
spiced cinnamon powder 15757
ordin's oatmeal 58059
sea dragon steaks 19996
calamari 7134
coconut milk 7773
caribe fillets 7139
coffee ice cream 75009
cherry ice cream 75007
coconut ice cream 75010
chocolate ice cream 75006
chocolate mint ice cream 75817
lemon ice cream 75008
chocolate ice cream cake 75781
chocolate ice cream cake slice 75787
chocolate mint ice cream crunch 75827
chocolate walnut ice cream 75018
berry walnut ice cream 75822
chocolate walnut ice cream crunch 75763
berry walnut crunch 75832
chocolate caynar ice cream 75012
berry ice cream 75818
cherry walnut ice cream 75019
lemon walnut ice cream 75020
cherry ice cream cake 75782
lemon walnut ice cream crunch 75765
cherry ice cream crunch 75752
cherry ice cream cake slice 75788
chocolate golanda ice cream 75030
chocolate mint golanda ice cream 75825
coconut golanda ice cream 75034
berry ice cream crunch 75828
lemon ice cream crunch 75753
coffee caynar ice cream 75015
berry ice cream cake 75838
berry ice cream cake slice 75840
chocolate kiola ice cream 75024
chocolate mint ice cream cake 75837
chocolate mint ice cream cake slice 75839
chocolate mint caynar ice cream 75819
chocolate mint caynar nut crunch 75829
cragbeast omelet 45546
grilled nest drake meat 45378
hynid omelet 45547
hynid omelet with cheese 45555
nest drake sausage 45564
omelet supreme 45562
omelet with cheese 45548
sausage casing 45572
vegetable omelet 45541
vegetable omelet with cheese 45549
cobalt cup cakes 19173
planar fruit pies 29754
clockwork observer gauntlets 65443
clockwork observer vambraces 65441
bristlebanes party platter 29781
Artisans Seal 22
saucy bunnymeat 13427
frost bunny stew 15
spicy ulthork meat 17906
celestial essence 11866
Vegetables 13419
Grandmaster Baker's Spoon 15
Hard Boiled Snake Egg 15
baked pumpkin seeds 29742
Pumpkin Pie 36110
Pumpkin Bread 36112
powdered sandstorm pearl 17906
jumjum salad (dropped) 13976
jumjum salad (vendor) 15
jumjum cake (dropped) 17947
jumjum cake (vendor) 17947

[eski2]

tailoring list with dupes removed
lemming fur backpack 51172
small leather skullcap 2013
small leather mask 2014
small leather gorget 2015
small leather tunic 2016
small leather shoulderpads 2017
small leather cloak 2018
small leather belt 2019
small leather sleeves 2020
small leather wristbands 2021
small leather gloves 2022
small leather leggings 2023
small leather boots 2024
mithril fern boots 8877
blackened mithril netted gloves 8872
moss-threaded rawhide leggings 8790
braids of pine 8866
picnic basket 9656
aged etched scale bull whip 63786
aged etched scale stock whip 63785
barbed aged whip 63790
barbed etched whip 63789
barbed stock whip 63788
bola 63795
bolstered cragbeast backpack 63819
bolstered cragbeast bag 63820
bolstered cragbeast pack 63821
bolstered hynid-hide backpack 63807
bull whip 63780
cragbeast backpack 63811
etched scale bull whip 63783
etched scale snake whip 63784
etched scale stock whip 63782
explosive bola 63798
hynid-hide backpack 63799
hynid-hide bag 63800
hynid-hide pack 63801
hynid-hide sack 63802
snake whip 63781
snake whip cracker 63844
steel-reinforced cragbeast backpack 63815
steel-reinforced cragbeast pack 63817
steel-reinforced hynid-hide backpack 63803
steel-reinforced hynid-hide bag 63804
steel-reinforced hynid-hide pack 63805
steel-reinforced hynid-hide sack 63806
steel-laced aged bull whip 63793
steel-laced aged snake whip 63794
steel-laced etched bull whip 63791
steel-laced etched snake whip 63792
steel-weighted bola 63796
stock whip 63779
concussive bola 63797
treated aligned steel thread 63841
treated shimmering steel thread 63842
whip cracker 63843
shade silk thread 2791
preserved aged muramite etched scales 58038
preserved muramite etched scales 58053
muramite silk thread 54096
muramite leather padding 54095
infused muramite leather 54103
stretched kobold leather 51101
leathery twine 51106
hand made backpack 17969
muramite needle 60187
hynid-hair thread 60188
sewn flesh parchment 60166
infused muramite thread 54104
parchment of flesh 29975
robe of the lost circle 12256
ice silk swatch 25664
low quality bear skin 13750
medium quality rockhopper hide 2786
ruined wolf pelt 13782
ceremonial solstice robe 9670
ruined bear pelt 13781
leather padding 16488
low quality cat pelt 12084
medium quality bear skin 13751
low quality wolf skin 13753
silk thread 16486
silk swatch 16482
shade silk cord 2793
gnoll fur patch 1210
low quality rockhopper hide 2788
silk cord 16489
acrylia reinforced belt 6172
acrylia reinforced boots 6177
acrylia reinforced cloak 6171
acrylia reinforced gloves 6175
acrylia reinforced gorget 6168
acrylia reinforced leggings 6176
acrylia reinforced mantle 6170
acrylia reinforced mask 6167
acrylia reinforced skullcap 6166
acrylia reinforced sleeves 6173
acrylia reinforced tunic 6169
acrylia reinforced wristbands 6174
acrylia studded belt 6088
acrylia studded boots 6093
cobalt drake tunic 24803
wu's fighting shirt 25719
small patchwork sleeves 2120
black pantherskin tunic 24839
black pantherskin mask 24837
acrylia studded shoulderpads 6086
black pantherskin cloak 24841
black pantherskin leggings 24846
black pantherskin boots 24847
black pantherskin belt 24842
bearskin potion bag 17811
haze panther boots 24859
wu's fighting mask 25717
large patchwork tunic 2128
ruined cat pelt 13783
spinechill silk swatch 27760
wu's fighting collar 25718
large tattered gorget 2127
tattered shoulderpads 2105
tattered gorget 2103
tattered mask 2102
large patchwork boots 2136
cured silk mask 1181
small tattered gorget 2115
small patchwork cloak 2118
small patchwork boots 2124
raw silk sandals 1171
wu's fighting pantaloons 25725
crystalline silk swatch 25663
large tattered skullcap 2125
raw silk headband 1160
tattered wristbands 2109
large patchwork cloak 2130
large patchwork sleeves 2132
patchwork boots 2112
patchwork cloak 2106
patchwork tunic 2104
patchwork sleeves 2108
small tattered mask 2114
large tattered mask 2126
large patchwork pants 2135
tattered skullcap 2101
small tattered skullcap 2113
ice silk choker 24758
shaded hide wristband 30187
ice silk amice 24760
shaded hide leggings 30183
shaded hide boots 30180
ice silk pantaloons 24765
shaded hide tunic 30188
shaded hide sleeves 30177
shaded hide skullcap 30182
cobalt drake belt 24806
arctic wyvern shoulderpads 24816
arctic wyvern gorget 24814
arctic wyvern mask 24813
arctic wyvern belt 24818
cobalt drake cloak 24805
shaded hide amice 30185
haze panther tunic 24851
haze panther gorget 24850
cobalt drake wristbands 24808
raw silk collar 1162
raw silk mask 1161
crystalline silk wristbands 25659
shaded hide cloak 30178
othmir fur cloak 24897
small patchwork pants 2123
cobalt drake gorget 24802
large tattered gloves 2134
greyhopper hide mask 7788
studded hopperhide mask 2763
cured shade silk mask 6071
shade silk swatch 2794
large leather skullcap 2025
large leather mask 2026
large leather tunic 2028
large leather shoulderpads 2029
large leather cloak 2030
large leather belt 2031
large leather sleeves 2032
large leather gloves 2034
large leather boots 2036
haze panther cloak 24853
small tattered gloves 2122
small tattered belt 2119
small tattered shoulderpads 2117
small tattered wristbands 2121
small patchwork tunic 2116
patchwork pants 2111
tattered belt 2107
tattered gloves 2110
large tattered belt 2131
large tattered shoulderpads 2129
cobalt drake boots 24811
cobalt drake gloves 24809
cobalt drake leggings 24810
cobalt drake mask 24801
cobalt drake shoulderpads 24804
cobalt drake sleeves 24807
haze panther belt 24854
haze panther gloves 24857
haze panther leggings 24858
haze panther mask 24849
haze panther shoulderpads 24852
haze panther skullcap 24848
haze panther sleeves 24855
haze panther wristbands 24856
black pantherskin gloves 24845
black pantherskin gorget 24838
black pantherskin shoulderpads 24840
black pantherskin skullcap 24836
black pantherskin sleeves 24843
black pantherskin wristbands 24844
tigeraptor belt 24830
tigeraptor boots 24835
tigeraptor cloak 24829
tigeraptor gloves 24833
tigeraptor gorget 24826
tigeraptor leggings 24834
tigeraptor mask 24825
tigeraptor skullcap 24824
tigeraptor sleeves 24831
tigeraptor tunic 24827
tigeraptor wristbands 24832
othmir fur cap 24989
othmir fur moccasins 24991
holgresh fur cap 24993
holgresh fur cloak 24893
holgresh fur moccasins 24994
velium hound fur cloak 24898
velium hound fur cap 24990
velium hound fur moccasins 24992
arctic wyvern boots 24823
arctic wyvern cloak 24817
arctic wyvern gloves 24821
arctic wyvern leggings 24822
arctic wyvern skullcap 24812
arctic wyvern sleeves 24819
arctic wyvern tunic 24815
arctic wyvern wristbands 24820
fire undergarment tunic 15986
fleeting quiver 17327
large leather leggings 2035
leather boots 2012
leather skullcap 2001
leather mask 2002
leather gorget 2003
leather tunic 2004
leather shoulderpads 2005
leather cloak 2006
leather belt 2007
leather sleeves 2008
leather wristbands 2009
leather gloves 2010
leather leggings 2011
crystalline silk mantle 25655
crystalline silk collar 25653
crystalline silk mask 25663
crystalline silk sleeves 25658
large leather wristbands 2033
large leather gorget 2027
large tattered wristbands 2133
medium quality wolf skin 13754
medium quality cat pelt 12085
velium mastodon fur cloak 26999
silk bandage 16487
shade silk bandage 2792
thin leather strap 5581
rallic pack 17359
tailored wrist pouch 17085
tailored small bag 17047
tailored large belt pouch 17083
shadow silk 16483
large shadow silk 16484
inky shadow silk 16485
monk training bag 12688
gnoll fur patch quarter 1329
patched gnoll fur bundle 1330
crystalline silk mesh 11636
tailored quiver 17804
tailor-made whip 5060
tattered hopperhide belt 2756
tattered hopperhide boots 2761
tattered hopperhide cloak 2755
tattered hopperhide gloves 2759
tattered hopperhide gorget 2752
tattered hopperhide mask 2751
tattered hopperhide pants 2760
tattered hopperhide shoulderpads 2754
tattered hopperhide skullcap 2750
tattered hopperhide sleeves 2757
tattered hopperhide tunic 2753
tattered hopperhide wristbands 2758
raw silk cloak 1165
raw silk gloves 1169
raw silk leggings 1170
raw silk mantle 1164
raw silk robe 1163
raw silk sash 1166
raw silk sleeves 1167
raw silk wristbands 1168
shade silk collar 2797
shade silk cloak 2800
shade silk wristbands 2803
shade silk mantle 2799
shade silk mask 2796
shade silk sash 2801
shade silk sleeves 2802
shade silk gloves 2804
shade silk sandals 2806
shade silk leggings 2805
shade silk robe 2798
shaded hopperhide belt 30718
shaded hopperhide boots 30723
shaded hopperhide cloak 30717
shaded hopperhide gloves 30721
shaded hopperhide gorget 30714
shaded hopperhide mask 30713
shaded hopperhide pants 30722
shaded hopperhide shoulderpads 30716
shaded hopperhide skullcap 30712
shaded hopperhide sleeves 30719
shaded hopperhide tunic 30715
shaded hopperhide wristbands 30720
studded gorget 2203
studded leggings 2211
studded shoulderpads 2205
studded belt 2207
studded boots 2212
studded gloves 2210
studded sleeves 2208
studded mask 2202
studded wristbands 2209
studded skullcap 2201
studded cloak 2206
studded tunic 2204
studded hopperhide belt 2768
studded hopperhide wristbands 2770
studded hopperhide gorget 2764
studded hopperhide skullcap 2762
studded hopperhide shoulderpads 2766
studded hopperhide sleeves 2769
studded hopperhide boots 2773
studded hopperhide cloak 2767
studded hopperhide gloves 2771
studded hopperhide leggings 2772
studded hopperhide tunic 2765
cured silk cloak 1185
cured silk collar 1182
cured silk gi 1183
cured silk handwraps 1189
cured silk headband 1180
cured silk leggings 1190
cured silk mantle 1184
cured silk sandals 1191
cured silk sash 1186
cured silk sleeves 1187
cured silk wristbands 1188
cured shade silk collar 6072
cured shade silk gloves 6079
cured shade silk headband 6070
cured shade silk leggings 6080
cured shade silk mantle 6074
cured shade silk robe 6073
cured shade silk sandals 6081
cured shade silk sash 6076
cured shade silk sleeves 6077
cured shade silk wristbands 6078
cured shade silk cloak 6075
greyhopper hide belt 7794
greyhopper hide boots 7782
greyhopper hide cape 7787
greyhopper hide gloves 7792
greyhopper hide gorget 7791
greyhopper hide hood 7793
greyhopper hide leggings 7783
greyhopper hide shoulderpads 7786
greyhopper hide sleeves 7785
greyhopper hide tunic 7781
greyhopper hide wristbands 7784
wu's fighting cap 25716
wu's fighting cloak 25721
wu's fighting gauntlets 1192
wu's fighting mantle 25720
wu's fighting sash 25722
wu's fighting sleeves 25723
wu's fighting slippers 25726
wu's fighting wristbands 25724
reinforced belt 2243
small reinforced belt 2255
large reinforced belt 2267
small studded belt 2219
small studded boots 2224
small studded cloak 2218
small studded gloves 2222
small studded gorget 2215
small studded leggings 2223
small studded mask 2214
small studded shoulderpads 2217
small studded skullcap 2213
small studded sleeves 2220
small studded tunic 2216
small studded wristbands 2221
large studded belt 2231
large studded boots 2236
large studded cloak 2230
large studded gloves 2234
large studded gorget 2227
large studded leggings 2235
large studded mask 2226
large studded shoulderpads 2229
large studded skullcap 2225
large studded sleeves 2232
large studded tunic 2228
large studded wristbands 2233
reinforced boots 2248
small reinforced boots 2260
large reinforced boots 2272
reinforced cloak 2242
small reinforced cloak 2254
large reinforced cloak 2266
reinforced gloves 2246
small reinforced gloves 2258
large reinforced gloves 2270
reinforced gorget 2239
small reinforced gorget 2251
large reinforced gorget 2263
reinforced leggings 2247
small reinforced leggings 2259
large reinforced leggings 2271
reinforced mask 2238
small reinforced mask 2250
large reinforced mask 2262
reinforced shoulderpads 2241
small reinforced shoulderpads 2253
large reinforced shoulderpads 2265
reinforced skullcap 2237
small reinforced skullcap 2249
large reinforced skullcap 2261
reinforced sleeves 2244
small reinforced sleeves 2256
large reinforced sleeves 2268
reinforced tunic 2240
small reinforced tunic 2252
large reinforced tunic 2264
reinforced wristbands 2245
small reinforced wristbands 2257
large reinforced wristbands 2269
reinforced hopperhide belt 2780
reinforced hopperhide boots 2785
reinforced hopperhide cloak 2779
reinforced hopperhide gloves 2783
reinforced hopperhide gorget 2776
reinforced hopperhide mask 2775
reinforced hopperhide leggings 2784
reinforced hopperhide mantle 2778
reinforced hopperhide sleeves 2781
reinforced hopperhide skullcap 2774
reinforced hopperhide tunic 2777
reinforced hopperhide wristbands 2782
acrylia studded cloak 6087
acrylia studded gloves 6091
acrylia studded gorget 6084
acrylia studded leggings 6092
acrylia studded mask 6083
acrylia studded skullcap 6082
acrylia studded sleeves 6089
acrylia studded tunic 6085
acrylia studded wristbands 6090
shaded hide belt 30186
shaded hide gloves 30181
shaded hide gorget 30184
shaded hide mask 30179
rough belt strap 3922
black chitin belt 3925
bone beaded belt 3924
owlbear feathered leggings 3926
cobalt drake skullcap 24800
tigeraptor shoulderpads 24828
crystalline silk cap 25651
crystalline silk cloak 25656
crystalline silk gloves 25660
crystalline silk pantaloons 25661
crystalline silk sash 25657
crystalline silk shirt 25654
crystalline silk slippers 25662
ice silk cap 24756
ice silk cloak 25665
ice silk robe 24759
ice silk sash 24761
ice silk sleeves 24762
ice silk veil 24757
ice silk bracelet 24763
ice silk lined shoes 24766
ice silk gloves 24764
tae ew leather bracers 27789
tae ew leather sleeves 27793
tae ew leather pants 27791
hardened lizard hide 27761
tae ew silk bracers 27782
tae ew silk gloves 27780
tae ew silk sleeves 27786
tae ew silk cap 27783
tae ew silk pants 27784
tae ew silk robe 27785
tae ew silk boots 27781
nightmare silk string 29999
cured brontotherium hide 11654
slarghilug kelp string 29998
air arachnid silk string 29997
mystic cloak 1057
vegerog fiber string 29996
fiend gut string 29995
cord of tormented muscle 29489
stormweave swatch 29195
nightmare arachnid swatch 29595
firesilk swatch 29591
earthtwine swatch 29592
airsilk swatch 29593
watertwine swatch 29594
night terror boots 30668
night terror cap 30669
night terror gloves 30663
night terror pantaloons 30629
night terror sleeves 30628
night terror wristband 30692
robe of haunted dreams 29660
stormweave pantaloons 32213
stormweave sleeves 32212
stormweave wristband 32217
stormweave gloves 32214
stormweave cap 32216
robe of perpetual tempest 32211
stormweave boots 32215
firestrand gloves 29664
firestrand wristband 29699
firestrand boots 29666
firestrand cap 29689
firestrand sleeves 29662
firestrand pantaloons 29663
robe of eternal fire 29628
earthweave cap 30469
earthweave wristband 30470
earthweave sleeves 30465
earthweave gloves 30467
earthweave boots 30468
earthweave pantaloons 30466
robe of ancient earth 29646
airstrand cap 30424
airstrand pantaloons 30199
robe of immaculate air 29659
airstrand wristband 30441
airstrand sleeves 30198
airstrand gloves 30368
airstrand boots 30397
waterweave cap 30615
waterweave wristband 30627
waterweave sleeves 30550
waterweave gloves 30613
waterweave boots 30614
waterweave pantaloons 30600
robe of primordial waters 29629
dream haunt boots 30905
dream haunt bracer 30903
dream haunt cap 30899
dream haunt gloves 30904
dream haunt sleeves 30901
dream haunt leggings 30902
dream haunt tunic 30900
storm rider bracer 30911
storm rider gloves 30912
storm rider boots 30913
storm rider sleeves 30909
storm rider leggings 30910
storm rider tunic 30907
storm rider cap 30906
firehide bracer 30733
firehide cap 30699
firehide sleeves 30731
firehide leggings 30732
firehide gloves 30734
firehide boots 30785
firehide tunic 30730
stonehide bracer 30814
stonehide cap 30786
stonehide sleeves 30788
stonehide leggings 30789
stonehide gloves 30842
stonehide boots 30843
stonehide tunic 30787
trilounhide bracer 30896
trilounhide boots 30898
trilounhide gloves 30897
trilounhide cap 30892
trilounhide sleeves 30894
trilounhide leggings 30895
trilounhide tunic 30893
windskin bracer 30848
windskin cap 30844
windskin sleeves 30846
windskin leggings 30847
windskin tunic 30845
cured ethereal energy 16287
tae ew leather belt 27802
tae ew leather gloves 27787
tae ew leather boots 27788
tae ew leather cap 27790
tae ew leather tunic 27792
tae ew hide sack 17123
tae ew whip 27801
silvery grey ribbon 65139
silvery black ribbon 65140
golden grey ribbon 65141
golden black ribbon 65142
platinum grey ribbon 65143
platinum black ribbon 65144
silvery blue ribbon 65161
silvery beige ribbon 65162
golden blue ribbon 65163
golden beige ribbon 65164
platinum blue ribbon 65165
platinum beige ribbon 65166
silvery white ribbon 65183
silvery seagreen ribbon 65184
golden white ribbon 65185
golden seagreen ribbon 65186
platinum white ribbon 65187
platinum seagreen ribbon 65188
silvery crimson ribbon 65205
silvery forestgreen ribbon 65206
golden crimson ribbon 65207
golden forestgreen ribbon 65208
platinum crimson ribbon 65209
platinum forestgreen ribbon 65210
silvery cyan ribbon 65227
silvery teal ribbon 65228
golden cyan ribbon 65229
golden teal ribbon 65230
platinum cyan ribbon 65231
platinum teal ribbon 65232
silvery indigo ribbon 65249
silvery brown ribbon 65250
golden indigo ribbon 65251
golden brown ribbon 65252
platinum indigo ribbon 65253
platinum brown ribbon 65254
folded medicine bag 65463
folded bearskin potion bag 65464
magi'kot's bangle of convergence 11303
magi'kot's tiara of convergence 9944
magi'kot's shoes of convergence 20428
magi'kot's gloves of convergence 13619
magi'kot's sleeves of convergence 11598
magi'kot's pants of convergence 19021
magi'kot's robe of convergence 32141
crystalline silk fiber 1830
silk coldain prayer shawl 1179
embroidered coldain prayer shawl 1198
spool of sacred coldain thread 1832
runed coldain prayer shawl 1199
Khati Sha Handwraps 3664
preserved sarnak brain 12409
leatherfoot belt pouch 17142
bolstered hynid-hide bag 63808
bolstered hynid-hide pack 63809
bolstered hynid-hide sack 63810
cragbeast bag 63812
steel-reinforced cragbeast bag 63816
leatherfoot wrist pouch 17140
leatherfoot small pouch 17141
leatherfoot haversack 17145
patch of dire wolf fur 24466
woven dire wolf fur 24467
serene woven platinum wristband 24288
stormreaper boned tunic 24367
stormreaper boned belt 24364
stormreaper boned cloak 24368
stormreaper boned leggings 24369
boot gasket 72047
murkglider sleeves 72334
pale murkglider belt 72300
pale murkglider shawl 72308
faded feran belt 72316
feran tunic 72328
murkglider gloves 72304
murkglider boots 72306
murkglider wristband 72332
pale murkglider collar 72302
murkglider cap 72310
feran sleeves 72338
murkglider robe 72312
poor goblin disguise 62835
feran wristband 72336
murkglider leggings 72314
pants of concealed blades 9596
feran wristband of ice 72337
feran helm 72326
feran gloves 72320
feran leggings 72330
kizash's leggings of savage heart 68983
kizash's savage heart bracer 68909
kizash's savage heart cap 67730
kizash's savage heart gloves 68907
kizash's savage heart sandals 68908
kizash's savage heart sleeves 68906
kizash's tunic of savage heart 68982
gaelin's leggings of woodlands 68981
gaelin's tunic of woodlands 68980
gaelin's woodland bracer 68904
gaelin's woodland cap 67729
gaelin's woodland sandals 68903
gaelin's woodland sleeves 68901
gaelin's woodland gauntlets 68902
lelyen's bracer of entrancement 68929
lelyen's circlet of entrancement 67734
lelyen's gloves of entrancement 68927
lelyen's pantaloons of entrancement 68989
lelyen's robe of entrancement 68988
lelyen's sandals of entrancement 68928
lelyen's sleeves of entrancement 68926
jennu's bracer of creation 68919
jennu's circlet of creation 67732
jennu's gloves of creation 68917
jennu's pantaloons of creation 68987
jennu's robe of creation 68986
jennu's sandals of creation 68918
jennu's sleeves of creation 68916
wristband of strife 72333
robe of strife 72313
feran boots 72322
pressl's bracer of balance 68899
pressl's cap of balance 67728
pressl's gloves of balance 68897
pressl's leggings of balance 68979
pressl's robe of balance 68978
pressl's sandals of balance 68898
pressl's sleeves of balance 68896
leggings of strife 72315
drachnid silk swatch 81855
nolaen's lifereaper bracer 68924
nolaen's lifereaper circlet 67733
nolaen's lifereaper gloves 68922
nolaen's lifereaper pantaloons 68991
nolaen's lifereaper robe 68990
nolaen's lifereaper sandals 68923
nolaen's lifereaper sleeves 68921
nunkin's bracer of pure elements 68914
nunkin's circlet of pure elements 67731
nunkin's gloves of pure elements 68912
nunkin's pantaloons of pure elements 68985
nunkin's robe of pure elements 68984
nunkin's sandals of pure elements 68913
nunkin's sleeves of pure elements 68911
imbued vale studded gloves 1938
stormreaper chainwoven veil 24371
terrorantula swatch 22092
infused terrorantula silk 24272
steelsilk mask 25667
steelsilk collar 25668
steelsilk gauntlets 25675
steelsilk helm 25666
steelsilk greaves 25676
steelsilk breastplate 25669
imbued steelsilk mask 25679
imbued steelsilk collar 25680
imbued steelsilk waistband 25684
imbued steelsilk boots 25689
imbued steelsilk cloak 25683
imbued steelsilk vambraces 25685
imbued steelsilk pauldron 25682
imbued steelsilk gauntlets 25687
imbued steelsilk greaves 25688
imbued steelsilk helm 25678
imbued steelsilk breastplate 25681
woven platinum cord 24265
woven platinum veil 24259
woven platinum wristband 24262
woven platinum mantle 24264
woven platinum gloves 24267
woven platinum cap 24263
woven platinum sleeves 24266
woven platinum slippers 24261
woven platinum cloak 24269
woven platinum trousers 24270
woven platinum robe 24268
serene woven platinum choker 24286
serene woven platinum cord 24291
serene woven platinum veil 24285
serene woven platinum mantle 24290
serene woven platinum slippers 24287
serene woven platinum sleeves 24292
serene woven platinum cap 24289
serene woven platinum cloak 24295
serene woven platinum trousers 24296
serene woven platinum robe 24294
fulvous woven platinum choker 24274
fulvous woven platinum cord 24279
fulvous woven platinum veil 24273
fulvous woven platinum gloves 24281
fulvous woven platinum wristband 24276
fulvous woven platinum mantle 24278
fulvous woven platinum slippers 24275
fulvous woven platinum cap 24277
fulvous woven platinum sleeves 24280
fulvous woven platinum cloak 24283
fulvous woven platinum trousers 24284
fulvous woven platinum robe 24282
neriad's woven platinum choker 24298
neriad's woven platinum cord 24303
neriad's woven platinum veil 24297
neriad's woven platinum gloves 24305
neriad's woven platinum mantle 24302
neriad's woven platinum wristband 24300
neriad's woven platinum slippers 24299
neriad's woven platinum cap 24301
neriad's woven platinum sleeves 24304
neriad's woven platinum cloak 24307
neriad's woven platinum trousers 24308
neriad's woven platinum robe 24306
rigid steelweave mask 24309
rigid steelweave cloak 24319
rigid steelweave belt 24315
rigid steelweave pauldrons 24314
rigid steelweave bracer 24312
rigid steelweave helm 24313
rigid steelweave vambraces 24316
rigid steelweave boots 24311
rigid steelweave greaves 24320
rigid steelweave breastplate 24318
tailored large bag 17084
owlbear hide tunic 3923
imbued mithril reinforced mask 1966
imbued mithril reinforced gorget 1967
imbued mithril reinforced bracer 1973
imbued mithril reinforced belt 1971
imbued mithril reinforced mantle 1969
imbued mithril reinforced skullcap 1965
imbued mithril reinforced boots 1976
imbued mithril reinforced gloves 1974
imbued mithril reinforced sleeves 1972
imbued mithril reinforced cloak 1970
imbued mithril reinforced leggings 1975
imbued mithril reinforced tunic 1968
tunarean soldier gorget 24398
tunarean soldier mask 24397
tunarean soldier shoulderpads 24402
tunarean soldier gloves 24405
tunarean soldier wristguard 24400
tunarean soldier cap 24401
tunarean soldier boots 24399
tunarean soldier belt 24403
tunarean soldier sleeves 24404
tunarean soldier cloak 24407
tunarean soldier leggings 24408
tunarean soldier tunic 24406
vale studded mask 1978
vale studded wristbands 1985
vale studded belt 1983
vale studded gorget 1979
serene steelweave mask 24334
serene steelweave collar 24335
serene steelweave cloak 24344
serene steelweave belt 24340
serene steelweave pauldrons 24339
serene steelweave gauntlets 24342
serene steelweave bracer 24337
serene steelweave helm 24338
serene steelweave vambraces 24341
serene steelweave boots 24336
serene steelweave greaves 24345
serene steelweave breastplate 24343
fulvous steelweave mask 24322
fulvous steelweave collar 24323
fulvous steelweave cloak 24332
fulvous steelweave belt 24328
fulvous steelweave pauldrons 24327
fulvous steelweave gauntlets 24330
fulvous steelweave bracer 24325
fulvous steelweave helm 24326
fulvous steelweave vambraces 24329
fulvous steelweave boots 24324
fulvous steelweave greaves 24333
fulvous steelweave breastplate 24331
windskin gloves 30849
windskin boots 30851
vale studded shoulderpads 1981
vale studded sleeves 1984
vale studded cloak 1982
vale studded gloves 1986
vale studded boots 1988
imbued vale studded mask 1930
imbued vale studded gorget 1931
imbued vale studded wristbands 1937
imbued vale studded belt 1935
imbued vale studded shoulderpads 1933
imbued vale studded skullcap 1929
imbued vale studded sleeves 1936
imbued vale studded boots 1940
imbued vale studded cloak 1934
imbued vale studded leggings 1939
imbued vale studded tunic 1932
vale studded tunic 1980
vale reinforced mask 1990
vale reinforced belt 1995
vale reinforced gorget 1991
vale reinforced mantle 1993
vale reinforced wristbands 1997
vale reinforced skullcap 1989
vale reinforced sleeves 1996
vale reinforced boots 2000
vale reinforced gloves 1998
vale reinforced cloak 1994
vale reinforced leggings 1999
vale reinforced tunic 1992
imbued vale reinforced mask 1942
imbued vale reinforced gorget 1943
imbued vale reinforced belt 1947
imbued vale reinforced mantle 1945
imbued vale reinforced skullcap 1941
imbued vale reinforced wristbands 1949
imbued vale reinforced sleeves 1948
imbued vale reinforced boots 1952
imbued vale reinforced cloak 1946
imbued vale reinforced leggings 1951
imbued vale reinforced tunic 1944
leatherfoot backpack 17144
clockwork observer breastplate 65440
stormreaper boned gorget 24359
stormreaper boned mask 24358
stormreaper boned shoulderpads 24363
stormreaper boned gloves 24366
stormreaper boned cap 24362
stormreaper boned boots 24360
stormreaper boned sleeves 24365
tunarean scout veil 24410
tunarean scout gorget 24411
tunarean scout gloves 24418
tunarean scout bracelet 24413
tunarean scout cape 24420
tunarean scout mantle 24415
tunarean scout skirt 24416
tunarean scout sleeves 24417
tunarean scout boots 24412
tunarean scout coif 24414
tunarean scout leggings 24421
tunarean scout tunic 24419
robe of the radiant 65149
robe of the inverse 65150
robe of the ethereal 65151
robe of dew 65152
robe of visage 65153
robe of tempest 65154
robe of neglect 65171
robe of breath 65172
robe of the astral 65173
robe of tashani 65174
robe of expertise 65175
robe of intellect 65176
robe of sorcery 65193
robe of skewn 65194
robe of tears 65195
robe of slant 65196
robe of impulse 65197
robe of virtue 65198
robe of mana 65215
robe of scent 65216
robe of concussion 65217
robe of lodestone 65218
robe of obliteration 65219
robe of capacity 65220
robe of abatement 65237
robe of obligation 65238
robe of requisition 65239
robe of asylum 65240
robe of tenancy 65241
robe of misery 65242
coldain hunting blanket 30135
cap of the white rose 16
bracer of the white rose 16
sleeves of the white rose 16
boots of the white rose 16
leggings of the white rose 16
gloves of the white rose 16
tunic of the white rose 16
Bracer of the Craft Keeper 61152
Cap of the Craft Keeper 17966
Gloves of the Craft Keeper 61156
Sandals of the Craft Keeper 61154
Sleeves of the Craft Keeper 61153
Trousers of the Craft Keeper 38808
Robe of the Craft Keeper 17908
treated silk fibres 17908
sacred tunare silk 17908
woven mandrake 17165
cap of the leafrunner 16
bracer of the leafrunner 38739
sleeves of the leafrunner 16
boots of the leafrunner 16
leggings of the leafrunner 16
gloves of the leafrunner 16
tunic of the leafrunner 16
Grandmaster Tailor's Needle 17165
Unholy Silk Bracers 22591
Unholy Silk Gloves 22595
Unholy Silk Robe 22596
Unholy Silk Skullcap 22590
Unholy Silk Sleeves 22586
Unholy Silk Sandals 22592
Unholy Silk Trousers 22594
Skullcap of the Spurned Initiate 22635
Bracer of the Spurned Initiate 22636
Slippers of the Spurned Initiate 22637
Sleeves of the Spurned Initiate 22631
Trousers of the Spurned Initiate 22625
Gloves of the Spurned Initiate 22626
Robe of the Spurned Initiate 92876
Mended Tapestry 17768
Robe of Abrogation 65145
initiates scale armbands 51301
initiates scale boots 51304
initiates scale bracer 51302
initiates scale breastplate 51306
initiates scale gauntlets 51331
initiates scale helm 16
initiates scale legplates 16
Cap of the Arcane Order 16
Bracer of the Arcane Order 16
Sleeves of the Arcane Order 16
Sandals of the Arcane Order 16
Trousers of the Arcane Order 16
Gloves of the Arcane Order 16
Robe of the Arcane Order 16
Ethereal Silk Swatch 16286
Gloves of the Stonehand 16
Stonehand Robe Material 17261
Robe of the Stonehand 16
Stonehand Gloves Material 17261
Trousers of the Stonehand 16
Stonehand Trousers Material 17261
Sandals of the Stonehand 16
Stonehand Sandal Material 17261
Sleeves of the Stonehand 16
Stonehand Sleeve Material 17261
Bracer of the Stonehand 16
Stonehand Bracer Material 17261
Cap of the Stonehand 16
Stonehand Cap Material 17261
Silent Fist Cap Material 17270
Cap of the Silent Fist 16
Silent Fist Bracer Material 17270
Bracer of the Silent Fist 16
Silent Fist Sleeve Material 17270
Sleeves of the Silent Fist 16
Silent Fist Sandal Material 17270
Sandals of the Silent Fist 16
Silent Fist Trousers Material 17270
Trousers of the Silent Fist 16
Silent Fist Gloves Material 17270
Gloves of the Silent Fist 16
Silent Fist Robe Material 17270
Robe of the Silent Fist 16
Boots of the Collective Initiate 16
Bracer of the Collective Initiate 16
Cap of the Collective Initiate 16
Gloves of the Collective Initiate 16
Legs of the Collective Initiate 16
Robe of the Collective Initiate 16
Sleeves of the Collective Initiate 16
Black Rawhide Tunic 8763
Shark Tooth Sleeves 17165
Shadowjade Weave 8884

[eski2]

and when i tried this with the merchant tool, i could see cured silk mask to tattered wristbands only. ??

[eski2]

1073 entries without dupes, i'll try chopping it up and see if i can get it working, pity i don't know how to tell excel to do this automatically, is there a way to use SQL to create lists of size 80 entries or an easy way to use excel to chop it into chunks of 80?

[GeorgeS]

and when i tried this with the merchant tool, i could see cured silk mask to tattered wristbands only. ??

I'm not sure how many max items an NPC can have at one time.

GeorgeS