# 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:** 15
**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:** [January 7, 2017, 11:09am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/283 "2017-01-07T11:09:54Z")
Yeah, I’m not sure what’s up with the last-modified detection but it’s definitely picking up false positives somewhere. I’ll clean it up for now and look into what’s causing the errant behavior sometime this weekend. ---
**Author:** ![GameTagwastaken](https://avatars.discourse-cdn.com/v4/letter/g/7ab992/32.png) [@GameTagwastaken](https://community.gemsofwar.com/u/GameTagwastaken)\ **Post date:** [March 1, 2017, 5:16pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/284 "2017-03-01T17:16:28Z")
@Lyya, Mongo can be added to the console database. There was no formal announcement but he has been added as a mailbox bonus with patch 2.2. This post is the best confirmation I have as @Stan hasn’t updated the console troop thread yet : [CONSOLE: 2.2 Patch Notes - #57 by GoldPhoenix0](http://community.gemsofwar.com/t/console-2-2-patch-notes/20637/57) ---
**Author:** ![Stan](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/stan/32/29888_2.png) [@Stan](https://community.gemsofwar.com/u/Stan)\ **Post date:** [March 1, 2017, 5:22pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/285 "2017-03-01T17:22:19Z")
I’m on it. It sounds like there may have been some other troops dropped into chests and I’ll update the list as we get confirmed reports, or better yet, confirmation from a dev. ---
**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 26, 2017, 12:55am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/286 "2017-04-26T00:55:49Z")
My site is down for emergency maintenance. The MySQL backend is being serviced. A rough ETA on a fix is 1-2 hours from now. I am mobile right now so I can’t put a redirect/parking page up, so please inform others who may be asking in over channels. Apologies for the inconvenience. ---
**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 26, 2017, 12:58am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/287 "2017-04-26T00:58:25Z")
Never mind, seems like it’s back online. Let’s hope it stays that way! ---
**Author:** ![Papa](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/papa/32/26282_2.png) [@Papa](https://community.gemsofwar.com/u/Papa)\ **Post date:** [April 26, 2017, 1:26am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/288 "2017-04-26T01:26:21Z")
Thanks, Lyya, for all the unpaid work you do for this game. The resources you provide are invaluable. ---
**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:** [June 20, 2017, 7:32am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/289 "2017-06-20T07:32:13Z")
My site appears to be down. I’ve contacted my host and will hopefully have a resolution by tomorrow. Thanks for your patience. ---
**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:** [June 20, 2017, 7:50am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/290 "2017-06-20T07:50:03Z")
And it’s back. ---
**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:** [July 24, 2017, 12:35am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/291 "2017-07-24T00:35:32Z")
I am going overseas on vacation for a couple of weeks starting tomorrow until 7 August. The Gems of War Database may be slow to update during that time. ---
**Author:** ![Strat](https://avatars.discourse-cdn.com/v4/letter/s/2bfe46/32.png) [@Strat](https://community.gemsofwar.com/u/Strat)\ **Post date:** [August 2, 2017, 4:05pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/292 "2017-08-02T16:05:39Z")
@Lyya I hope your having a nice time on vacation. When you get back there is a minor error in your Events section: troops are showing +25% to all Skills, instead of the new +10%. Thanks again for making such a great database! ---
**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:** [August 3, 2017, 12:15am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/293 "2017-08-03T00:15:12Z")
Thanks for the report. Took me a bit to see where the 10% text was coming from, but it should now be correct for all languages. ---
**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:** [August 11, 2017, 10:22pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/294 "2017-08-11T22:22:25Z")
I’ve fixed a bunch of small issues with the tables on my site today. 1. Default sort is more sensible for most numeric fields now (descending order where appropriate). No more annoying “click the column twice to see it in the view I care about.” 2. Reverse sorts will now only apply on the second time a column is clicked in a row; previously, the tables would remember the sort direction for each column and would apply the reverse sort if you ever returned to that column later, which was really annoying. 3. The alternating zebra-stripes on the grid rows will now change colors (light to dark) whenever the value of the sort column substantially changes. This makes it easier to view a sorted table as a group. Example (note the colors change as guild names change, given the current sort by guild): ![image](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/0/9/095411dc14607017fd8339ecc6823a45d418630a.png) Hopefully these make the tables a bit easier to use. ---
**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:** [August 25, 2017, 6:38pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/295 "2017-08-25T18:38:06Z")
Added “Release Date” column to the [troop table](http://ashtender.com/gems/trooptable), hidden by default. ---
**Author:** ![Tacet](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/tacet/32/35_2.png) [@Tacet](https://community.gemsofwar.com/u/Tacet)\ **Post date:** [August 25, 2017, 6:51pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/296 "2017-08-25T18:51:27Z")
> [@Lyya](#): > > Added “Release Date” column to the troop table, hidden by default. Very nice! Any chance a version column could be added too to indicate the version of release for each troop? ---
**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:** [August 25, 2017, 6:54pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/297 "2017-08-25T18:54:55Z")
As in, the version number of the game at the time of the troop’s release? ---
**Author:** ![Tacet](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/tacet/32/35_2.png) [@Tacet](https://community.gemsofwar.com/u/Tacet)\ **Post date:** [August 25, 2017, 7:21pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/298 "2017-08-25T19:21:16Z")
> [@Lyya](#): > > As in, the version number of the game at the time of the troop’s release? Yes, that. 😃 ---
**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:** [August 25, 2017, 7:23pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/299 "2017-08-25T19:23:12Z")
It’s easy enough to add that, if it provides value to people. ---
**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:** [August 26, 2017, 1:46am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/300 "2017-08-26T01:46:07Z")
Added the game version as best as I can tell to the existing troops. In the future, new troops will automagically get their versions set, this batch was hand-edited. I wasn’t playing at the very very beginning (started in 1.0.4) so I don’t know what the first public release was – 1.0? – or when exactly 1.0.1 or 1.0.2 dropped. If anyone knows this exactly, I can update the version info for the oldest troops. ---
**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:** [August 31, 2017, 1:21am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/301 "2017-08-31T01:21:21Z")
The GoW Database has been updated to reflect the 3.1 changes. Please note that Dungeon Boss troops will not be visible in the troop lists until I have a means of separating them from obtainable troops in My Collection and the Leaderboards. ---
**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:** [August 31, 2017, 3:07pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/302 "2017-08-31T15:07:20Z")
Boss troops now have their own separate page, [http://ashtender.com/gems/bosses](http://ashtender.com/gems/bosses). [Previous page](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037.md?page=14) [Next page](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037.md?page=16)