# Gems of War Database - updated troops list and much more! **URL:** \ **Category:** Community Guides\ **Created:** [April 26, 2016, 9:02pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037 "2016-04-26T21:02:42Z")\ **Posts on this page:** 20\ **Page:** 2
**Author:** ![Jainus](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/jainus/32/34949_2.png) [@Jainus](https://community.gemsofwar.com/u/Jainus)\ **Post date:** [April 27, 2016, 9:10am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/21 "2016-04-27T09:10:01Z")
Good work @Lyya @Nimhain@sirrian can we get this one pinned please? ---
**Author:** ![LostInLust](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/lostinlust/32/19371_2.png) [@LostInLust](https://community.gemsofwar.com/u/LostInLust)\ **Post date:** [April 27, 2016, 9:26am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/22 "2016-04-27T09:26:25Z")
This is a piece of very good job. Thank you. ---
**Author:** ![Nimhain](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/nimhain/32/47049_2.png) [@Nimhain](https://community.gemsofwar.com/u/Nimhain)\ **Post date:** [April 27, 2016, 11:02am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/23 "2016-04-27T11:02:21Z")
---
**Author:** ![Lyya](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/lyya/32/3650_2.png) [@Lyya](https://community.gemsofwar.com/u/Lyya)\ **Post date:** [April 28, 2016, 8:29am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/24 "2016-04-28T08:29:02Z")
Missing art should all be fixed as of tonight. ---
**Author:** ![YoshinoKirin](https://avatars.discourse-cdn.com/v4/letter/y/977dab/32.png) [@YoshinoKirin](https://community.gemsofwar.com/u/YoshinoKirin)\ **Post date:** [April 28, 2016, 2:20pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/25 "2016-04-28T14:20:20Z")
Nice work and highly appreciated ❤ Thank you so much, Lyya! 😍❤ ---
**Author:** ![killerman3333](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/killerman3333/32/4068_2.png) [@killerman3333](https://community.gemsofwar.com/u/killerman3333)\ **Post date:** [April 28, 2016, 3:04pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/26 "2016-04-28T15:04:22Z")
That shout out you got from tracet, how does it feel? ---
**Author:** ![Korbit](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/korbit/32/6407_2.png) [@Korbit](https://community.gemsofwar.com/u/Korbit)\ **Post date:** [April 28, 2016, 8:56pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/27 "2016-04-28T20:56:13Z")
That are some good News. Great 🕶👍 ---
**Author:** ![Lyya](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/lyya/32/3650_2.png) [@Lyya](https://community.gemsofwar.com/u/Lyya)\ **Post date:** [April 29, 2016, 4:56am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/28 "2016-04-29T04:56:58Z")
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. ---
**Author:** ![Yantur](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/yantur/32/4304_2.png) [@Yantur](https://community.gemsofwar.com/u/Yantur)\ **Post date:** [May 2, 2016, 9:56pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/29 "2016-05-02T21:56:58Z")
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). ---
**Author:** ![Lyya](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/lyya/32/3650_2.png) [@Lyya](https://community.gemsofwar.com/u/Lyya)\ **Post date:** [May 2, 2016, 10:08pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/30 "2016-05-02T22:08:54Z")
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](http://gems.atspace.tv/troops.php?color1=red&color2=blue&sort=byRarity) ---
**Author:** ![Yantur](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/yantur/32/4304_2.png) [@Yantur](https://community.gemsofwar.com/u/Yantur)\ **Post date:** [May 2, 2016, 11:06pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/31 "2016-05-02T23:06:38Z")
Lyya - you’re right - have overseen that you can select two colors already. ---
**Author:** ![Lyya](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/lyya/32/3650_2.png) [@Lyya](https://community.gemsofwar.com/u/Lyya)\ **Post date:** [May 2, 2016, 11:14pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/32 "2016-05-02T23:14:41Z")
Experimenting with a tabular view. Is this at all useful for people? [http://gems.atspace.tv/troopdata.php?format=table](http://gems.atspace.tv/troopdata.php?format=table) ---
**Author:** ![killerman3333](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/killerman3333/32/4068_2.png) [@killerman3333](https://community.gemsofwar.com/u/killerman3333)\ **Post date:** [May 2, 2016, 11:25pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/33 "2016-05-02T23:25:06Z")
Lyla thank you for also telling us (in your list) where to get the arcane stones too. ---
**Author:** ![Korbit](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/korbit/32/6407_2.png) [@Korbit](https://community.gemsofwar.com/u/Korbit)\ **Post date:** [May 2, 2016, 11:26pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/34 "2016-05-02T23:26:13Z")
You HAVE to integrate this format! 😃 Looks very good so far… Btw… I love tabular views… ---
**Author:** ![Korbit](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/korbit/32/6407_2.png) [@Korbit](https://community.gemsofwar.com/u/Korbit)\ **Post date:** [May 2, 2016, 11:35pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/35 "2016-05-02T23:35:41Z")
The font size is pretty compact. In my Opinion the perfect Setting. All functions are working to 100%. ---
**Author:** ![actreal](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/actreal/32/1945_2.png) [@actreal](https://community.gemsofwar.com/u/actreal)\ **Post date:** [May 2, 2016, 11:39pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/36 "2016-05-02T23:39:57Z")
> [@Lyya](#): > > Experimenting with a tabular view. Is this at all useful for people? > > [http://gems.atspace.tv/troopdata.php?format=table](http://gems.atspace.tv/troopdata.php?format=table) 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. ---
**Author:** ![Lyya](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/lyya/32/3650_2.png) [@Lyya](https://community.gemsofwar.com/u/Lyya)\ **Post date:** [May 3, 2016, 12:24am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/37 "2016-05-03T00:24:51Z")
I’ll look into providing a custom sort for colors! Updated again at [http://gems.atspace.tv/troopdata.php?format=table](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. ---
**Author:** ![Lyya](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/lyya/32/3650_2.png) [@Lyya](https://community.gemsofwar.com/u/Lyya)\ **Post date:** [May 3, 2016, 5:18am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/38 "2016-05-03T05:18:48Z")
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. ---
**Author:** ![Lyya](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/lyya/32/3650_2.png) [@Lyya](https://community.gemsofwar.com/u/Lyya)\ **Post date:** [May 3, 2016, 5:25pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/39 "2016-05-03T17:25:29Z")
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](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](http://gems.atspace.tv/trooptable.php?sort=rarity&filter-colors=blue%2Fred) ---
**Author:** ![Lyya](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/lyya/32/3650_2.png) [@Lyya](https://community.gemsofwar.com/u/Lyya)\ **Post date:** [May 5, 2016, 5:58am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/40 "2016-05-05T05:58:22Z")
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: > **[Troops - Gems of War Database](https://gowdb.com/troops/)** > > A list of all troops in Gems of War and their statistics. 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. [Previous page](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037.md?page=1) [Next page](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037.md?page=3)