New Cannith crafting site!

[SpiritofNight]

So... I was getting frustrated with the difficulties in optimising my crafting items.
I couldn't easily find prefixes and suffixes which matched for good effect, especially when building items for casters.
The ingame interface takes too long to load, and isnt that easy to understand, especially which effects are prefixes, and suffixes... so I decided to build a giant database of all the craftable effects, and compile a sortable, filterable table for them.

Check it out at http://cannith.deathwishgame.co.uk.

Any suggestions or comments would be greatly appreciated.

[wisdomstorment]

Good effort!! +1

Someone posted a spreadsheet yesterday as well. Have a look at the crafting forums for the link.

[TimoteoDeLani]

Looks nice. BTW ...

Proof Against Pioson <- typo

[SpiritofNight]

Looks nice. BTW ...

Proof Against Pioson <- typo

Fixed, thank you,

[SpiritofNight]

UPDATE!

Can now be filtered by type of item!
You no longer have to sort, you can simply narrow the enchants to what you need!

Feedback will be most appreciated.

[SpiritofNight]

accidental double post deleted

[insaneuou]

veny nice

[SpiritofNight]

Oops! forgot to actually upload the changes to the server.

NOW it has the new functionality!

[Sleepsalot]

Just one thing Make the link Clickable here. Rest looks great

Sleeps


So... I was getting frustrated with the difficulties in optimising my crafting items.
I couldn't easily find prefixes and suffixes which matched for good effect, especially when building items for casters.
The ingame interface takes too long to load, and isnt that easy to understand, especially which effects are prefixes, and suffixes... so I decided to build a giant database of all the craftable effects, and compile a sortable, filterable table for them.

Check it out at cannith.deathwishgame.co.uk.

Any suggestions or comments would be greatly appreciated.

[SpiritofNight]

Done

[NinjaNeed]

Nice site.

Just a couple of suggestions, we dont really need to know that an item can have +11 skill on it when we already know it can have +7.

And, if you ignore the above comment (and I understand if you do) then there is a way to make it sort regardless of number, ie search +11 is currently above search +7 which imo it should not be.

[SpiritofNight]

Indeed, I am working on a way to have it collapse all the skill/spell enhance types into the same entry in the table.

Its currently a bit... wordy.

[SteeleTrueheart]

trinket & bracers filters are back to front.

I think it would also benefit from the crafting level and the amount it adds to the item level & overall +

[NinjaNeed]

lol

Well, that would be pretty simple if you were using xml but it looks like your using some kind of excel document so not sure how to go about doing it.

Still a nice site :)

[Cam_Neely]

fantastic work, was thinking about making something of the sort in xls for personal use.

Is it complete? For example I looked for something to match with my goggles of +2 attack, and the only prefixes were +int, blindness immunity and underwater action. But I thought there was more last time I looked in game.

[SpiritofNight]

trinket & bracers filters are back to front.

I think it would also benefit from the crafting level and the amount it adds to the item level & overall +
Filter order fixed, thanks. level is going to be in at some point, theres space in the database.


lol

Well, that would be pretty simple if you were using xml but it looks like your using some kind of excel document so not sure how to go about doing it.

Still a nice site :)
I'm using MySQL actually, so adding/changing things is relatively easy.


Is it complete? For example I looked for something to match with my goggles of +2 attack, and the only prefixes were +int, blindness immunity and underwater action. But I thought there was more last time I looked in game.

Yes, this is an absolutely complete list of all the enchants in the system at the moment. I copied them all by hand.

[FrozenNova]

Fantastically useful - a great resource.
Would be nice to also have the effect level as well, so I don't have to troop to the device to check whether I can make it or not.

[SpiritofNight]

Fantastically useful - a great resource.
Would be nice to also have the effect level as well, so I don't have to troop to the device to check whether I can make it or not.

Is my next port of call. It may take some time though. there are just under 900 lines of data, and no easy way to do them, so I have to do everything by hand.

[SpiritofNight]

Upgrade complete!

It now collapses similar affixes (ie all +balance skill affixes, all +armor affixes, etc.) into one row.

Can be toggled with a button.

Any more suggestions?

(those of you asking for crafting level. I *will* be putting this in, as soon as i get time to transcribe them all.)

[Cam_Neely]

If i click just goggles, nothing shows up, but when I did that before, it was working, seems something got messed up in an update.

Also, if I click something like cloak, then prefix, nothing shows.

[SpiritofNight]

If i click just goggles, nothing shows up, but when I did that before, it was working, seems something got messed up in an update.

Also, if I click something like cloak, then prefix, nothing shows.

Indeed, thanks for noticing. I forgot to update the indexing when I added the new filtering.
Thank you!
Should be working properly now

[Glenalth]

Any chance of a version formatted to fit the MyDDO browser window?

[badbob117]

Very nice planner man. Will def put your site to good use .

Thanks and keep up the great work. :)

[SpiritofNight]

Any chance of a version formatted to fit the MyDDO browser window?

How can I go about testing this?
I'd love to provide.

EDIT: found how to navigate to the page from inside the browser, now... does the my.ddo browser submit any useful data to the site which will let me format it automatically if its using the ingame browser, rather than having the user select it manually?

[BeccaBop]

Another suggestion...

What is the + of each shard?

Like, if I am level 7, and want to make some twink stuff, I have to think ahead about the ML of the item. So if I want to make a feather falling ring of improved false life, I'd like to the the + of each shard before I begin.




Also, I am using Chrome, and am unable to use the site. I will totally be using this in Firefox, but thought you would like to know it looks and acts weird about your most recent updates in that particular browser.

[BeccaBop]

Aw heck, another suggestion, since it'd be easy enough (BTW, you are AWESOME for doing this).

The "type" filter radio buttons (arcane, divine, elemental) could use an "all" setting, for ease.

By the way, what you are doing is EXACTLY what I had hoped someone would do. This is really incredible. +1 to you as often as it lets me!!

[Cam_Neely]

The "type" filter radio buttons (arcane, divine, elemental) could use an "all" setting, for ease.

Already sort of in place, just dont select any of the three:)

Seems to be working much better now, very useful

+1

[HAL]

Very nice. I started doing an Excel spreadsheet but this is much more functional.

Thanks!

[Cam_Neely]

hum seems that the prefix/suffix thing is borked again. I can select goggles or cape and everything shows up. But if I think select either prefix or suffix, there is nothing in the list

[IONDragonx]

I noticed that you had the +1-5 enhancement bonus shards as Prefixes. They are neither prefix or suffix, though. Perhaps they should be left out altogether?

Would you be interested in making a separate table for the materials? It would be so useful to know what items would be useful to deconstruct to get the right materials for a new shard. It would also help to clear out the useless collectibles that I carry. I have a lot because I don't know which would be useful for crafting in the future.

[Kza]

Nice job, helps me alot. Thanks :-)

[IONDragonx]

You have four entries that start with the typo:
Lignthing
and four more with the typo:
Ligntning
You already have four entries that are properly spelled.

[Cordovan]

Just wanted to say that you're doing some nice work here, keep it up!

[IONDragonx]

I don't see any shards of Nimbleness, but I know that they exist in game.

Also, you have "roaring" in lower case. Nit-picky, I know...

[Asmodeus451]

WOW. you know you did something cool when a Dev compliments you

[IONDragonx]

Save, Reflex +X is listed for all 5 bonuses instead of combined into one listing like the others.

There is no listing for Efficient Metamagic - Empower I nor Efficient Metamagic - Enlarge II. (Although I have no proof that they exist in game)

All eight of the entries starting with Efficient Metamagic can be compressed. You are listing the I and II versions separately.

Nit-picky again, but you switch back and forth between slashes and commas as separators. Stick with one. (Ex: Dexterity +1/2/3/4/5/6 vs Balance +1,3,5,7,10,11,13)

Hey, don't forget: This is an AWESOME tool! Thank You!

[TheGish]

I'd love to see the level of the recipe and be able to filter based on it. I haven't spent much time crafting and I can't make everything. It'd be great to filter based on what I can actually make.

[IONDragonx]

Hmmm:
->Several recipes have been removed from the unbound crafting devices, but remain on the bound devices.

This coming from:
http://forums.ddo.com/showthread.php?t=206066

Maybe a new column? Bound/Unbound

[Glenalth]

How can I go about testing this?
I'd love to provide.

EDIT: found how to navigate to the page from inside the browser, now... does the my.ddo browser submit any useful data to the site which will let me format it automatically if its using the ingame browser, rather than having the user select it manually?

It should return a user agent string when queried.

[uncus2]

One error in the db - Arcane sigils only work on Docents [Armor], not on trinkets.

[Wizzly_Bear]

Nice work.

[Jinpo]

one database error. Healing Lore and Efficient Metamagic: Empowered Healing can be put on a shield.

[TheDjinnFor]

Benevolance should be benevolence. I found this error when searching under trinket prefixes, if that says anything for you.

Nice tool, though, thanks.

[SpiritofNight]

It should return a user agent string when queried.

Thank you. Got it sorted. It now runs with only the necessary columns when run in the game's built-in browser.

Typos with Arcane Sigil, and excessive Lightning resist entries have been fixed, and the mismatching , and / in collapsed entries have also been fixed.

[BeccaBop]

I think I speak for all of us, once again, you rock.

The speed at which I can see changes is really impressive.

I am sure we all appreciate it.

[SpiritofNight]

So... now the immortal question... how does one go about making it an official fansite?

First off, I think I'm going to update the color scheme :)

Its a bit... dull at the moment.

NB: for those of you who want crafting level, and mats to make, I havent forgotten about you. I just can't face 900 sets of data entry right now. It took a lot of effort to get it where it is, and I'm taking a slight breather to get it looking good before I get back to the "hard" work.

[boz666]

I tried to use this in Firefox (4) and I got a javascript error -

oTable is not defined - line 66 cannith.js

[SpiritofNight]

I tried to use this in Firefox (4) and I got a javascript error -

oTable is not defined - line 66 cannith.js

Fixed in the latest update. Noticed it myself when tweaking about with it.

Was introduced during the update to make it work with my.ddo ingame client.

EDIT: Also now added styling to the site. Style comments now appreciated. I know I'm not very good at it.

[boz666]

Some more (hopefully) helpful feedback:

Still getting 'oTable is not defined' when selecting a Filter (line 82) or hitting expand (line 67).

[SpiritofNight]

Some more (hopefully) helpful feedback:

Still getting 'oTable is not defined' when selecting a Filter (line 82) or hitting expand (line 67).

*ahem* my bad.... now it is working. My end at least.

[Rumbaar]

Been looking for something like that, very good work. I'll come back when I can +rep again.

Wish Turbine made it easier for users to create these type of player resources, like EVE Online does.

[boz666]

Works again now.

Great job!

[IONDragonx]

Moderator suggestion:

Shouldn't we move this to the crafting forum?

[Glenalth]

The MyDDO version looks good.

The missing functionality of the columns listing all applicable gear per shard hurts a bit, but it still makes a good quick reference with the filter buttons.

[geoffhanna]

Very nice! Thanks!

[Cordovan]

Moderator suggestion:

Shouldn't we move this to the crafting forum?

Agreed and done!

[bbqzor]

This is the tool that should have been released for the in-game crafting UI. Simply being able to search by prefix/suffix is so intuitive and yet until now has been lacking. For that, I am very grateful! The rest is simply above and beyond.

Didnt have the time to go over it in high detail but noticed two things at a glance.

One, Blueshine cant apply to shields. I know it says it can initially on the crafting UI, but it also has 'required: metal armor' and it does not count shields as armor. I tried it on a mithral shield and it didnt work, I suppose its worth verifying it on a steel shield just in case. But likely it should get changed to a 'no' so people dont plan to craft something that wont crunch.

Two, the different entries for things with 'lesser' and 'greater' versions arent collapsing, and I really wish they would. Its amazingly convenient to have things like Balance 1-13 all on one line, and really it seems things like Fire Resistance and False Life which also have different tiers could benefit from the same treatment. So like Lesser/Regular/Greater False Life would be on one line, just like Balance 1-13, for example.

Props again, it really is a good tool and Ill give it a closer look when I have time and note any further comments. Cheers.

[Lighti]

mobility is missing.

[SpiritofNight]

This is the tool that should have been released for the in-game crafting UI. Simply being able to search by prefix/suffix is so intuitive and yet until now has been lacking. For that, I am very grateful! The rest is simply above and beyond.

Didnt have the time to go over it in high detail but noticed two things at a glance.

One, Blueshine cant apply to shields. I know it says it can initially on the crafting UI, but it also has 'required: metal armor' and it does not count shields as armor. I tried it on a mithral shield and it didnt work, I suppose its worth verifying it on a steel shield just in case. But likely it should get changed to a 'no' so people dont plan to craft something that wont crunch.

Two, the different entries for things with 'lesser' and 'greater' versions arent collapsing, and I really wish they would. Its amazingly convenient to have things like Balance 1-13 all on one line, and really it seems things like Fire Resistance and False Life which also have different tiers could benefit from the same treatment. So like Lesser/Regular/Greater False Life would be on one line, just like Balance 1-13, for example.

Props again, it really is a good tool and Ill give it a closer look when I have time and note any further comments. Cheers.

I'll test the blueshine thing myself when I get a moment. And I agree that there are a few more affixes which could do with collapsing. I'll get on that shortly.

[Indel_Eventine]

Very nice, I have only been deconstructing waiting for something like this to appear! :D

On your numbers lists, you use 1/3/5... you could replace that with 1, 3, .. 13 and save some room. (imo, don't waste time if you are ok with it)

Does the save vs enchantment really go to 6 while the others only 5? seems odd

Very nice!!!

[SpiritofNight]

Very nice, I have only been deconstructing waiting for something like this to appear! :D

On your numbers lists, you use 1/3/5... you could replace that with 1, 3, .. 13 and save some room. (imo, don't waste time if you are ok with it)

Does the save vs enchantment really go to 6 while the others only 5? seems odd

Very nice!!!

Yes, it really does. Bizarre, i know.

[NinetyNineTails]

Site has Striding listed as a suffix. I just made a 15% striding ring and it came out as a prefix (more's the pity).

[simo0208]

Would it be possible to add the shard level to create the item? I know it's a lot more work, but it would rock so much. Thanks so much for this. Added to my favorites and +1 rep! :)

[SpiritofNight]

Site has Striding listed as a suffix. I just made a 15% striding ring and it came out as a prefix (more's the pity).

Thank you for finding this out. Fixed

[SpiritofNight]

For those of you following this space, I will be adding crafting levels, and crafting materials to the database in the upcoming days. Would have been today, but the crafting hall went down so I lost the ability to transcribe from there.

I will be copying levels from the DDO wiki while the Hall is closed, but will be checking through everything myself by hand to ensure correctness when it comes back up.

Thank you to all of my followers for your very kind comments.
It gives me a great sense of pride and achievement to know that it is being used well.

[Iazani]

Bookmarked...

[Rimllar]

Very nice and extremely useful...

Only comment I have is that I saw the check boxes (goggles? amulet? trinket? etc) as being "OR" as opposed to "AND".

That is, if I choose "googles?" then I expected it to select only goggles=Yes
If I then chose "amulet?", I would expect it to also show amulet=yes (that is either googles=yes or amulet=yes, not requiring BOTH googles=yes and amulet=yes)

Would be nice to be to see what prefixes can be put on either googles or amulets (or bracers or rings, etc). I am rarely interested in know what I can craft that could go onto 2 different items exclsuively.

[SpiritofNight]

Now updated to include crafting level.
Collapsed entries will have to be expanded to show the crafting levels of the sub-affixes.

Will be adding filtering by crafting level tomorrow. Its 3am here so I'm going to bed.

Question to those watching this space: The title bar is getting a bit cluttered, I want to shrink the titles of the columns, what can I abbreviate the headers to?

EDIT: Bear in mind that, for now with the crafting system down, the numbers are taken from the Wiki. They may need updating when the system comes back up (I'm assuming with the downtime on Monday). Also there are some that are missing from the wiki.

[SpiritofNight]

Filtering by crafting level is in!

[erikbozelie]

filters apear to be beyond broken atm.

[jjflanigan]

Filtering by crafting level is in!

Your columns are off by one so each filter checkbox is currently filtering the previous option instead of itself.

[SpiritofNight]

filters apear to be beyond broken atm.

They were only a bit broken. And are now un-broken

[IONDragonx]

Armor column has disappeared for me.

When I tried to use the filters to bring up all the Weapon Suffixes, it dropped out +10% Alacrity and all of the Banes which I know were in the list before.

[SpiritofNight]

Armor column has disappeared for me.

When I tried to use the filters to bring up all the Weapon Suffixes, it dropped out +10% Alacrity and all of the Banes which I know were in the list before.

Found the issue and fixed it. Thanks

[IONDragonx]

Found the issue and fixed it. Thanks

:| Well, now I click Weapon Suffix and NO records come up...

[SpiritofNight]

:| Well, now I click Weapon Suffix and NO records come up...

Not happening like that for me... F5 and try again?

[IONDragonx]

Not happening like that for me... F5 and try again?
That worked. Thanks.

[puget]

Seems to me as I watch this thread, and the OP love and dedication for this game at large.....Turbine should be thinking about how they can get the OP on their development team before it is too late.

[Asmodeus451]

Seems to me as I watch this thread, and the OP love and dedication for this game at large.....Turbine should be thinking about how they can get the OP on their development team before it is too late.

hey, why not?

from what i hear Cordovan was an active member of the DDO community LONG before Turbine hired him.

i'm all for competant people who love the game getting a chance to work on it and improve it

[jjflanigan]

hey, why not?

from what i hear Cordovan was an active member of the DDO community LONG before Turbine hired him.

i'm all for competant people who love the game getting a chance to work on it and improve it

Not to derail the thread -- but man, if only ;)

[SpiritofNight]

Not to derail the thread -- but man, if only ;)

I'd love to work for them... but I'm not in America.

[puget]

Not to derail the thread -- but man, if only ;)

Well, you have part of your resume right here on the forums man. I say go for it if you ever see an opening. It will be on the interwebz somewhere, and you obviously have a passion for the game.

[SpiritofNight]

We all hope that crafting will be back up tomorrow with the downtime.

When it comes up, I will do a quick check to make sure everything seems in order, then I will update all the items which do not currently have crafting levels associated with them.

Thank you all for your help with this project, you've all been very kind.
Any further assistance finding bugs etc will be greatly appreciated.

Thank you all, you make me proud to be a part of the community.

[Asmodeus451]

just as an FYI: currently, weather WAI or not, Weapon Prefixes and Suffixes can be applied to shields.

not sure if this will still be true come monday when Crafting returrns, but worth checking out

[SpiritofNight]

just as an FYI: currently, weather WAI or not, Weapon Prefixes and Suffixes can be applied to shields.

not sure if this will still be true come monday when Crafting returrns, but worth checking out

Strictly, anything which is "offhand weapon/shield" works on any one handed weapon or shield.

So bane, flaming etc can be put on shields,

And *most* shield properties can be put on onehanded weapons.

[Asmodeus451]

true. but your site doesnt reflect it.

looked up Shock today, a prefix i HAVE on a sheild i made, yet on the site, under th shield column for Shock it says "no"

just trying to help you make your Helper accurate is all

[SpiritofNight]

true. but your site doesnt reflect it.

looked up Shock today, a prefix i HAVE on a sheild i made, yet on the site, under th shield column for Shock it says "no"

just trying to help you make your Helper accurate is all

Dont get me wrong, i wasnt intending to criticise at all :)

It is just slightly tricky to figure out which of the enhancements, manually, can be put on shields/1h weapons.

[rvdvelden]

Great site, lots of useful info, but one question keeps burning in my mind. I've reset all the filters, put the crafting level between 0 and 99999 and still I get this:

"Showing 1 to 100 of 860 entries (filtered from 967 total entries)"

What happened to the 107 entries I can't see???

[SpiritofNight]

Great site, lots of useful info, but one question keeps burning in my mind. I've reset all the filters, put the crafting level between 0 and 99999 and still I get this:

"Showing 1 to 100 of 860 entries (filtered from 967 total entries)"

What happened to the 107 entries I can't see???

Those are the hidden entries which are either the collapsed versions of affixes, or the uncollapsed ones, depending on which state you are toggled into.

[rvdvelden]

Thank you for the quick and clear answer!

[rvdvelden]

Two things that you may want to fix:
1) Concentration is messed up (concentration +13 on level 39 for instance)
2) Jump is missing altogether

[MagicalDad]

Contributed my .5 GBP :)

BTW, next set of improvements that would be pretty fantastic is to add a hover-over on each effect with its cost in essences/shards/collectibles.

[SpiritofNight]

For those of you watching this spot, I have not gone completely off the radar.

I'm currently implementing more crafting details (materials (lesser/greater/extras)) as a popup when you mouse-over the crafting recipe names.

I'm tempted to outsource the data entry to the community, but to a certain extent i'm nervous about people intentionally putting in erroneous data (trolls will troll).
This community is lovely an' all, but theres -always- some rogue people.

My potential sollution to this was map the IP of a few people who have contributed helpfully to this thread, and allow them access to add/modify data if they wish.

Thoughts?