Announcement

**Verdandi** · 10-17-2003, 04:27 PM

We do have that feature. It is the "Find recipes that use this item" link. If it says "There are no known recipes that use" the item, then there are currently no recipes in the database for it. We may have goofed in setting up the recipe(s) that should use it, or we may not have a use for it yet.

We don't usually put things in unless we know what they're for since there are a lot of items flagged as used in tradeskills that are only for obscure quests that we don't want to mess with. But sometimes, especially with the flood of new information with an expansion, it'll happen.

**Krazick** · 10-17-2003, 04:46 PM

This is easy... I will take your example item "white primrose".

1. Go to the main site page (www.eqtraders.com)... on the left you see various menu items (About, FAQ, Search...Quests, Links, PayPal, and a entry field with Find button next to it).

2. Into that entry field type in 'White Primrose" and Click the Find Button.

3. You will get a page with the basic information on the item, with a Link on the Name... Click on that Link

4. The next page will provide more detailed information... with a Link Find recipes that use this item. Click on this link

5. And this returns (for White Primrose) that No Recipes are found that use it. (we don't have any yet recorded).

If we change it to 'Chub'... we get Rujarkian Chub in the list.. Clicking on the Rujarkian Chub and then the 'Find recipes that use this item... gets back 4 Recipes back.

**Sanna** · 10-18-2003, 12:19 AM

What I have wished is for the ability to cut Krazick's step 4.

I search for cinnamon sticks. When it gives me the results page, I wish that page could also include a direct link to the "Recipes that use this item" page for cinnamon sticks.

Granted, I know I have NO IDEA how the DB works in terms of processing things and the stress it would generate to find all those links and return them as well. But, to me, it seems maybe worth it for not having to return that page in the middle, the Cinnamon Stick data page, when all I want from IT is the 'recipes' link.

I know, I know, I know you aren't taking DB modification ideas now. But someday, you might. To me, this seems worth considering as a bandwidth saving feature (assuming it doesn't cause the processor to expload or something due to giving one more chunk of data back on a search).

-- Sanna
i need to go learn stuff about databases and the like, so i know what's possible and what's not. i dislike being uneducated >_<

**Tudani** · 10-18-2003, 09:23 AM

I don't mind step 4. But when my search only returns one item I wish it could skip directly to the item information page. The way lucy works, if there's multiples you get a list to choose from, otherwise you go straight to your info. But...I'll ask when you're accepting ideas for database changes.

**Nieccole** · 10-18-2003, 12:40 PM

I'd have to agree with Sanna... I completely missed the "find recipies that use this" link, and it's frustrated me to no end... and now I feel kinda dumb for having missed it. Well, like I said before, Alla has an in-line link on the item info page so you don't need that link.
/shrug You'd think someone who's just waiting on AA to join the 1750 club would've been a bit more observant ... /boggle

I appreciate the help, and I definately appreciate the time and effort that's gone into this site since I started visiting... erm, years ago~ I'm more of a lurker in most cases

Sorry for the "Duh, I rooted myself" moment

Announcement

DB request/question

DB request/question

Comment

Comment

Comment

Comment

Comment

Mistress Tinkbang Tankboom - Ak'Anon, Tarew Marr Gneehugging Chantaranga of the 66th Mez Break - AA:59	Assisted by Nakigoe Sennamida, Druidess of 65 Foraged Steamfont Springwaters - AA:8 Quartic, Darkie Wizzy of 52 Self-Snares - Best Crit: 1680.
[BK-210 // BR-250 // BS-203 // FL-200 // JC-240 // PT-200 // TL-200 ]---[ TK-179 // RS-182 // FS-165 ]-- Points: 1503/1750 -- Shawl: EIGHT and wearing it ^_^.