Gems of War Database - updated troops list and much more!

Good work @Lyya

@Nimhain@sirrian can we get this one pinned please?

1 Like

This is a piece of very good job. Thank you.

2 Likes

Missing art should all be fixed as of tonight.

3 Likes

Nice work and highly appreciated :heart:
Thank you so much, Lyya! :heart_eyes::heart:

1 Like

That shout out you got from tracet, how does it feel?

That are some good News. Great :sunglasses::thumbsup:

1 Like

Added traitstone costs in the info bubble that pops up when you click a trait. I had to hand-enter the formula so I might have made some mistakes; feedback here would be appreciated since I don’t have all troops at all levels to test.

7 Likes

The List is beautiful and very helpful.
What would be really helpful to me is a filter to sort out troops who need a special arcane traitstone - so i can find out on which troop to spend the weekly troop traits (e.g. showing only troops who need arcane blood).

2 Likes

You can do this already, just use the dropdown filters at the top of the page to set troop color filters. For example, this week’s stone is red/blue, so this will give you the list of all troops that need that stone, legendaries first:

http://gems.atspace.tv/troops.php?color1=red&color2=blue&sort=byRarity

5 Likes

Lyya - you’re right - have overseen that you can select two colors already.

Experimenting with a tabular view. Is this at all useful for people?

http://gems.atspace.tv/troopdata.php?format=table

3 Likes

Lyla thank you for also telling us (in your list) where to get the arcane stones too.

You HAVE to integrate this format! :smiley:
Looks very good so far…
Btw… I love tabular views…

The font size is pretty compact.
In my Opinion the perfect Setting.
All functions are working to 100%.

Love the tabular view. Can the colour sort be in GoW order: Blue, Green, Red, Yellow, Purple, Brown? That way it lines up with how the traitstones are listed in Hero Collection.

1 Like

I’ll look into providing a custom sort for colors!

Updated again at http://gems.atspace.tv/troopdata.php?format=table with support for filtering each column, and added traits, as well as tooltips for the spell data.

3 Likes

Colors in both the card view and the table view are now sorted as per the game, in the order you’ve specified. I’ve also made the sort by rarity actually by rarity instead of alphabetical.

Note that (on PC) you can hold “shift” when clicking headers to add secondary sorts. So you can first sort by kingdom using the header, and then subsequently by rarity by shift+clicking the rarity header.

4 Likes

Separated the troop table from the rest of the troop data, as the code was getting too complicated to support them both in the same PHP source. The troop table is now here:

http://gems.atspace.tv/trooptable.php

It’s linked off the main site with an obtuse “table” icon.

It now supports query parameters and “permalinking” your current sort and filter set, to make it easier to copy/paste into the forums. For example, here are this week’s traitstone candidates, sorted by rarity:

http://gems.atspace.tv/trooptable.php?sort=rarity&filter-colors=blue%2Fred

3 Likes

I’m in the process of migrating to better hosting, and so all the content links are being changed. The new site (with a facelift) can be found at:

Feedback on the design would be appreciated. Once I’ve verified all the links are working, I’ll update the shortcuts in the OP. This host allows me to shorten URLs, which will make everything substantially less verbose on copy/paste.

4 Likes