Skills entries brainstorming

For the Skills type database entries, here's what I was thinking each relevant column would look like (off the top of my head).

Remember this is what determines how these results are connected to each other, filtered etc. Some of these columns already exist (and are best re-used to save on space and performance) so will be 'repurposed' for Skills. Have a look around on similar sites like Arreat or archived Amazon Basin and let me know if you think there are any other types of information we could include for each Skill entry - remember the information must be easy to source and contribute in a standardised format like the rest of the contributions we've seen so far.

• Name of the Skill (self-explanatory)
• Required Level - character level required to use the skill
• Skill Prerequisites - other skills (and level of) required to train this skill for the first time
• Stats - for each level, up to 20 (or beyond due to +skills? what about up to 30? how would this be calculated?), the values of things like mana cost, attack%, walk/run speed, duration etc. etc.
• Synergies - other skills that synergise with this skill, and their values

The 'description' for Skills would be filled in separately by contributors as is the case for items at this time.

Anything else you think would be worthy of a space in the database for Skills? Try to think wide about this - is there any data that would pair up well with other parts of the site, both existing and planned?

Stormlash wrote: 3 years ago

Teebling wrote: 3 years ago

[*]Stats - for each level, up to 20 (or beyond due to +skills? what about up to 30? how would this be calculated?), the values of things like mana cost, attack%, walk/run speed, duration etc. etc.

Up to 60.

Okay, can be done. Is there anywhere that has the static values for each of these additional 40 levels though? On Arreat it lists them up to 20. Or is there a formula we could use to 'extrapolate' the values?

Guys these are all great observations and resources on their own but I can't do anything with them to solve the actual problem of getting this data consolidated and crowdsourced onto the site here. We need to find a way to make it so that people can contribute this data, by inputting text into contribution-type posts (like how it has been done for items).

If that involves deciphering binaries from the in-game files, it's way beyond my technical skill. If it involves a formula for skills that follow a linear Pattern, we need to know what the formula is and where it is found.

Udyret wrote: 3 years ago

Alphabetical Skill Listing

This is going to be helpful for me creating the 'Slots' for the database entries.

Stormlash wrote: 3 years ago

Teebling wrote: 3 years ago

We need to find a way to make it so that people can contribute this data, by inputting text into contribution-type posts (like how it has been done for items).

Just upload the entries and I'll fill them up like I did with Bases.

That'd be awesome

Stormlash, but to share the load amongst others who would want to do the same thing, where would you find that information for levels 21-60? The process would be a lot less painful if we could somehow collate all of that information in a public place.

Stormlash wrote: 3 years ago

If you don't find an easier solution, I'm just saying, I've been there, I did it before and I can do it again.

Okay Stormy, that's a lot of work! Wouldn't want you to get overloaded. Let's wait and see if anyone else has any ideas on how to approach this first, but good to know there's your method as a backup

After everything that has been posted, I'm leaning more towards @

Stormlash's offer of hard writing the values in.

I have to say I'm really impressed by what you have developed @SudoDragon, and now that @Arsteel has shown how the great majority could be calculated with ease.

That said, I don't want to have to re-engineer everything on my side of things as I feel that'll be taking time away from development where instead that could be delegated to contributors.

SudoDragon wrote: 3 years ago

That makes sense @Teebling - but maybe we can go with a hybrid approach? I could put together a spreadsheet with the various formulas for each skill so you don't have to reverse-engineer the code from my skill calculator. I've put together an example for

Magic Arrow and

Fire Arrow in google sheets. You could still go with manual entry, but having the data in this format would speed things up (though we'll have to check some against the game for correctness of course). Or if you want you can use the formulas in the sheet to power the skill entries directly - it should be much less effort with them in this simpler form.

Let me know if you think this would be useful, and I can spends a couple of days filling in the rest of the skills.

I reckon this would really help @

Stormlash and the other contributors inputting the data contribs - that’d save him from having to constantly enter single player games to copy info.

If the sheets were already up and populated with data from those formulas that would also speed up the process as it would allow multiple other contributors access to the data for the contribs, so yes, that would be great Sudo!