Welcome to LOTRO-crafting!

NEWS - 31st March

Ok folks, this is important. I am NO LONGER going to be maintaining lotro-crafting. It took me long enough to admit it to myself, but this is way too much work for one (small) hobbit to do on her own. I know people have offered help, but again, being honest, I'm probably too much of a control freak to have let that happen. However, I will be keeping this site live, until someone tells me they want to take it over.

I'm NOT looking for any cash. I just want someone who has the ability, and the time that I do not have, to give this site the makeover that it deserves (and grind entering recipes!). Please send me an email if you are interested. I will pass over the database (it's in SQL Server 2005), the webpages (asp.net, designed in Visual Web Developer), the spreadsheet with all the missing recipes on, and the rights to the web domain.

Sorry it came to this, but it has begun to feel more and more like a chore to log in and do data entry when I could be playing the game (or working on other projects - like real life).

There are plenty of other sites to get this information - yes, I presented it slightly differently, but the data IS out there. I suggest you look at the following for great sites with plenty of information:

The LOTRO Lorebook, Lotro Life

I'm releasing this info a day early because I didn't want people to think it was an April Fools Day joke (it's NOT).

As at 19th March - Missing Recipes - in Database/Total known - all other professions are fully in the DB as far as I know :)

Metalsmith: 349/379 (30 in file)
Scholar: 17/84 (67 in file)
Tailor: 5/692 (687 in file)
Weaponsmith: 11/201 (190 in file)
Woodworker: 11/176 (165 in file)

Recipes in DB: 762/1901 (1,139 to go argh!)

Future Plans:

In vaguely the order I'm intending on working on them

Add all the other recipes!
Add missing pictures
(internal DB modification - have one large table with all item stats in it, instead of separate tables for jewellery, armour etc)
Redesign recipe pages so that "basic" item created on left, recipe info in middle, critical item on right
Add drop down lists to armour listing pages and weapon listing pages so you can select type & slot
Continue adding NPC inventories
Tidy up crafting mobs/rares/mastery pages and make the "show recipe" detail pages have a nested table for tier & vocation rather than duplicate lines.
Add pages so you can see what is available in a village & area (maybe include maps?)
Change quest detail to more of a summary but all the relevant links to NPCs etc
Add more quests

17th March

Pretty sure I've now gone through all the name changes, deleted obsolete recipes and made a start on some new ones. The reason why recipe NUMBERS don't seem to have gone up much is that I've got rid of a few that no longer seem to be in game.

LOTRO Connect 2008 convention, Birmingham, England

Codemasters Online held a global gaming event on March 14th/15th in Birmingham, England, called "Connect 2008". They presented all of their games there (like Lord of the Rings Online, D&D Online, Archlord, RF Online and others) as well as introducing some new ones (Jumpgate Evolution). The event was attended by game developers.

I (Ariadne) was there (on the Friday)! here's my --Writeup--

13th March

Continuing to amend names as changed by a recent stealth(ish) patch. Another 100 or so recipes, let alone items etc need to be changed.

3rd March

Completed food costs table- now auto-updated

18th January - no recipes today, instead updated rare drops list to include most mobs that drop shards (hopefully all, but I'm keeping options open in case I missed any!

16th January - yes I'm still adding recipes, not always adding new comments, but I am keeping to my resolution!

11th January

New Years resolution went out of the window earlier this week when I caught the virus that currently is affecting 1/8 of the UK :( Started re-entering recipes again today.

2nd January 2008

Corrected names of "Hardened/Heavy Dwarf-Iron" recipes to "Dwarf Hardened Iron" recipes as per in-game change.
Added a few missing pictures.

Happy New Year everyone!!!

Resolution: to get back to adding stuff to the database. My aim is to add 10 new items/recipes or work an hour at least every day!

Recipes in database as at the end of 2007: 545

Items in the database as at the end of 2007: 1538

31st October

Well I couldn't do these changes on my own, so my wonderful web guru Simetac stepped in again and offered his wisdom!

Recipe listing now shows links to both the basic item created, and the critical result
Item listing now shows the colour of the item without having to click on the link

10th October

Added some more recipes
Added Class to recipe page (eg Weaponsmith!)
Had a go at trying to get it to show critical item created on recipe listing page, with a hyperlink, but gave up and will wait until I can confer with my web guru!

3rd October

Continuing to enter recipes, slowly but surely. Added some more of the missing pictures. Corrected some spelling errors

September 2007

no major updates, just added recipes

August 2007

Went through Cook recipes to work out which ingredients have changed (none).
Added the 3 new Cook reputation recipes
Added prospector & forester new reputation recipes
Made a start on checking & amending changed Jeweller recipes (adding new Jeweller recipes on the way!)
Book 10 changes

Amended experience types to show Easy, Simple, Low, Medium, High with experience gain
Changed all Farmer Seed recipes to award "Simple (4)" exp
Changed all Farmer Crop recipes to award "Simple (4)" exp
Added note about chance of producing a Bushel of Straw to Oat, Spring Barley and Winter Barley Field Recipes
Changed all Cook "Ingredient" recipes to "Simple (4)" exp
Added (old) to original one-shot recipes for all classes
Added changes to durability & sturdiness to tools
Changed T4 & T5 Cook recipes to use Superior Ovens where appropriate
Changed exp gain for beer and ale recipes from Low (6) to Medium (8)
Amended recipe for Serene Stew quest
Amended equipment type for Jeweller from Forge to Superior Forge where appropriate
Amended "component" recipes and changed exp gain from Light (6) to Simple (4)

Added recipe counts for each class to vocation overview table & recipe listing, so you know how many recipes I have in the database for each class
Decided, as a result of realising how many recipes I HAVEN'T got on the DB yet to put development on hold until I get more content!
Made the "crafting" items, "consumable" items, and "class specific" links actually do something other than just take you to the full item listing page
Added food, armour, weapon, and jewellery stat info to item detail

July 2007

Created & populated jewellery stat table
Uploaded new autocount info for items, quests, recipes, npcs (it's in the menu on the left)
Uploaded new Armour Stats table
Uploaded change in item detail & item listing pages
Uploaded new item page
Uploaded new changes including drop down list filtering
Finished adding all Jeweller recipes
Continued some offline development for weapons & armour stats
Working on a change in layout - weapons and armour will be able to be viewed separately, with stats in the grid, such as AC, or DPS (all sortable of course). It's not ready to upload yet, but that's taking some time to do..
Finished adding in all Farmer recipes
Added apprentice Metalsmith recipes (the autogained ones)
Changed recipe & item listing so they display the full list unless you decide to filter, done by request.
Added Food stats table and filled it with all known knowledge so far. Please help fill in the gaps!

June 2007

Added a few more quests. Updated tiers for recipes already in database.
Finished entered ALL new cook recipes (all the alcoholic ones (hic!))
Updated Novice Farmhand inventory
Updated Expert Cook inventory
Added recipe count and links to profession pages from Crafting overview table
Changed layout so you can view rare mob drops and mastery drops separately
Added additional view for mastery/rare items that shows recipe tier & class for recipes that use this item. This isn't the neatest view yet, but I've added the tidying up to my list. Getting it up there was the most important thing I think.
Added Provisioner, Novice Weaponcrafter, Supplier inventories
Added 69 NPCs, 1 recipe, 14 items
Added all Forester recipes
Added Grocer inventory
Added Novice Metalsmith, Novice Scholar, and Novice Tailor inventories.
Completed adding all Prospector recipes
Added Novice Farmhand, Expert Cook inventories.
Added recipe type to recipe detail (ie "dropped, auto, bought)
Added "Recipe scribed by" [link to recipe scroll item] to recipe detail
Removed recipe scroll from ingredients in recipes
Added "Scribes recipe" [link to recipe] to item detail
Added all mastery items to creature locations listing, and added the mastery items into the database.
Added recipe listing to vocation detail pages
Added ability to sort recipes by vocation
Added crafting progression quests to vocation detail pages
Added ability to be able to sort items viewed by item type (click on the header)

Changed the way the menu is laid out. This will mean it's easier for me to add submenus etc, although the other way was neater codewise, this is more flexible (I hope!)

Updated Novice Cook inventory after game update. Swore a bit about the removal of item categories, but decided to leave them in for the moment in case they come back in game.

rest of May 2007

With the help of Simetac, an old friend from my EQ1 days...re-generated the "large picture" that appears on item detail pages, so it's not an image file, it's actually composed of stats. This means it'll be searchable on later!
made a start on adding rare item recipes (from the crafting mobs drop list)
Added Mastery effects and items to the recipe page.
Added pre-requisite and follow-on quest detail
Changed the appearance of filter types to something a little more visually pleasing
Added tools listing (when you click on links in recipes)
Added equipment locations
Re-vamped NPC detail and quest detail to match item detail layout changes
Updated the crafting mobs page - items now link, and the table is sortable by columns.
Made a start on displaying recipes. (mastery effects & items to come shortly)
Changed layout of item detail slightly to improve appearance.

16th May 2007 - The database went live! NPC listing page, and the new improved quest page.

4th-6th May - Gave up on IIS, installed SQL Server 2005, Visual Web Developer for website stuff, recoded site for aspx (asp.net).

19th-22nd April 2007 - Technical difficulties with IIS & offline DB. Had to reinstall XP

17 April 2007 - uploaded new version of the database, uploaded new version of the quest page,uploaded new quest detail page

09 April 2007 - Updated "About us" page

08 April 2007 - Added "active user" mod to the forum, Added "About us" page, Added "Links" page, Changed news page to this!

06 April 2007 - Forum up and running