Game Mechanics: Blacksmithing Trivals

[Vandy]

Here is a snapshot from Oct 18 2000 of blacksmith trivals. The current state of many of the items included banded are far too low. Not sure what the current reasoning is for posted trivals as all I have found is a picture of the EQ Strategy guide which has INCORRECT trivals as well as tons of other incorrect information.



http://web.archive.org/web/200010180...g/trivials.asp

[smooman]

backing this up with a snapshot from the wayback machine.

http://web.archive.org/web/200002290.../smithing.html

[Vandy]

Here is a complete blacksmithing guide I pulled from an old Graffe's archive.


K.C.'s guide to becoming a mater smithe!

[Vandy]

UPDATE tradeskill_recipe Set trivial = CASE
						WHEN name='banded belt' THEN 135
						WHEN name='banded boots' THEN 135
						WHEN name='banded bracer' THEN 102
						WHEN name='banded cloak' THEN 175
						WHEN name='banded gauntlets' THEN 168
						WHEN name='banded gorget' THEN 102
						WHEN name='banded helm' THEN 135
						WHEN name='banded leggings' THEN 168
						WHEN name='banded mail' THEN 135
						WHEN name='banded  mantle' THEN 168
						WHEN name='banded mask' THEN 135
						WHEN name='banded sleeves' THEN 135
						WHEN name='sewing kit' THEN 135
						WHEN name= 'shaped cookie cutters' THEN 56
						WHEN name= 'studs' THEN 41
						WHEN name= 'sheet metal' THEN 56
						WHEN name= 'steel boing' THEN 41
						WHEN name= 'skewers' THEN 115
						WHEN name= 'metal bits' THEN 21
						WHEN name= 'pot' THEN 122
					ELSE trivial
					END
WHERE name IN ('banded belt', 'banded boots', 'banded bracer', 'banded cloak', 'banded gauntlets', 'banded gorget', 'banded helm', 'banded leggings', 'banded mail', 'banded mantle', 'banded mask', 'banded sleeves', 'sewing kit',  'shaped cookie cutters', 'studs', 'sheet metal', 'steel boing', 'skewers', 'metal bits', 'pot');

[Vandy]

Link to an old thread from 2009 with links to Trivals from classic-kunark posted by a Dev

http://www.project1999.org/forums/showthread.php?t=75

[Vandy]

A link that was posted by the Dev in the thread above was dead so I found a copy from 2001 on the waybackmachine.

http://web.archive.org/web/200104121...bbg/train.html

[nilbog]

Thanks for taking the time to help list the items.

I really dislike the tradeskill tables and how they are related. Unfortunately I couldn't use your query as a select because the naming schema can't rely just on recipe names or craziness ensues :T

To get what I needed in one query, I chose to grab the item ids, and then look into recipes where they are used for blacksmithing. This turned out to look convoluted, but it worked.

select
tre.item_id,
tr.name,
tr.trivial
from tradeskill_recipe_entries tre
left join tradeskill_recipe tr on (tr.id = tre.recipe_id)
where 
(tr.tradeskill = '63') and
tre.item_id in (select id from items where name like '%cookie cutter') or
tre.item_id in (select id from items where name in ('banded belt', 'banded boots', 'banded bracer', 'banded cloak', 'banded gauntlets', 'banded gorget', 'banded helm', 'banded leggings', 'banded mail', 'banded mantle', 'banded mask', 'banded sleeves', 'sewing kit',  'studs', 'sheet metal', 'steel boning', 'skewers', 'metal bits', 'pot'))
and (tre.successcount > '0')
and (tr.tradeskill not in (60,69))
order by tr.name

13436    Animal Shaped Cookie Cutter    40
3059    banded belt    95
3064    banded boots    95
3061    banded bracer    95
3058    banded cloak    102
3062    banded gauntlets    102
3055    banded gorget    92
3053    banded helm    106
3063    banded leggings    108
3056    banded mail    115
3057    banded mantle    95
3054    banded mask    90
3060    banded sleeves    102
13433    Barbarian Shaped Cookie Cutter    40
13434    Gnome Shaped Cookie Cutter    40
16905    Metal Bits    18
13432    Pot    50
12003    sheet metal    31
13430    skewers    38
12073    Steel Boning    37
12072    studs    35
13435    Troll Shaped Cookie Cutter    40

It won't be difficult to change these trivials to be era-appropriate. When I update them, I need to know if it will be the same throughout the timeline though, else I need to apply a rule to when their trivials decrease, if before Luclin.

Did these recipe trivials persist throughout Velious?

[nilbog]

The best evidence I can find was in the 2002 patch:

JUNE 5, 2002

Made some changes to the General Blacksmithing difficulties to make the progression in this trade skill more logical and to allow for more variety in that path.
http://www.tski.co.jp/baldio/patch/20020605a.html

If that's the case, I will update these for the next patch.

Additionally, if there are other blacksmithing issues, I will query them up for discussion. I really don't know enough about it without community discussion.

Thanks.

[Vega]

This reminds me of another bug report I need to file on blacksmithing, but have been lazy about researching. I'll make a separate thread though so as not to convolute this one.

[Vandy]

EQTraders from 2002
http://web.archive.org/web/200208020...eqtraders.com/

June 10, 2002
Just a few quick updates:

Cazic-Thule jewelcraft has been deciphered, and the first pieces have been successfully made. Recipes and stats are on the Cazic-Thule recipes page.

The dust is finally starting to slowly settle from the June 5 patch and all the changes to smithing trivials. It's still going to take a while to get it all updated, but we're getting there. For all of those asking on the various forums, as far as we know only smithing trivials were changed.