# Gems of War Database - updated troops list and much more!
**URL:** https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037
**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:** 12
### Author:  [@Lyya](https://community.gemsofwar.com/u/Lyya)
#### Post date: [July 30, 2016, 5:49am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/222 "2016-07-30T05:49:51Z")
Added battle summaries and links to team information for all quests in the quest pages. For example, on the Glacial Peaks quest page (at [Glacial Peaks - Kingdoms - Gems of War Database](http://ashtender.com/gems/kingdoms/glacial-peaks/quests)) the page now has (among others) the following objectives:
Stand accused!
Valkyrie: They violated the Temple!
[The Court Assembles](http://ashtender.com/gems/teams/6196,6187,6062,6189,c?banner=3011): Winter Wolf, Jackelope, Valkyrie, Yeti
Face trial!
Winter Knight: We must put them to death!
[The Court Decides](http://ashtender.com/gems/teams/6188,6062,6060,6060,c?banner=3011): Winter Knight, Valkyrie, Frost Giant, Frost Giant
Defend yourself!
Ice Witch: And pull out their eyes and tongues to be certain!
[Judge and Fairy](http://ashtender.com/gems/teams/6165,6196,6186,6108,c?banner=3011): Winter Imp, Winter Wolf, Snow Sprite, Ice Witch
---
### Author:  [@Lyya](https://community.gemsofwar.com/u/Lyya)
#### Post date: [August 6, 2016, 5:21am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/223 "2016-08-06T05:21:41Z")
Added Console views to every page in the Database. These views restrict troops, weapons, classes, and kingdoms to those present on Console. The landing page is here:
[http://ashtender.com/gems/console/](http://ashtender.com/gems/console/) (Note the final slash is unfortunately needed!)
The troops list is:
[http://ashtender.com/gems/console/troops](http://ashtender.com/gems/console/troops)
The troop table is:
[http://ashtender.com/gems/console/trooptable](http://ashtender.com/gems/console/trooptable)
etc.
Please note that while this restricts the view to content released for Console, it does not change any of the troop/weapon statistics to match those of the Console in case they differ from the PC’s version. Keep that in mind while team building.
Big thanks to @TaliaParks for seeding the database with “is-available” flags for each troop, weapon, class, and kingdom. Going forward, he’s going to maintain the Console collection as new troops are made available each week.
---
### Author:  [@Tacet](https://community.gemsofwar.com/u/Tacet)
#### Post date: [August 6, 2016, 5:35am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/224 "2016-08-06T05:35:02Z")
Thank you for everything that you do with the database. I use it at least once a week to check things. 🙂
---
### Author:  [@TaliaParks](https://community.gemsofwar.com/u/TaliaParks)
#### Post date: [August 6, 2016, 2:03pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/225 "2016-08-06T14:03:05Z")
Same here.
I bookmark 2 things for GoW, the Forums and the Database
---
### Author:  [@TaliaParks](https://community.gemsofwar.com/u/TaliaParks)
#### Post date: [August 8, 2016, 3:53pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/226 "2016-08-08T15:53:53Z")
Updated the list to include Blighted Lands Troops to the Console filter
---
### Author:  [@Stan](https://community.gemsofwar.com/u/Stan)
#### Post date: [August 8, 2016, 8:55pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/227 "2016-08-08T20:55:39Z")
@Lyya Thank you so much for doing this! As a console player, we can sometimes feel a little ‘second class’ and it is nice to get some user-generated content tailored for us.
---
### Author:  [@Lyya](https://community.gemsofwar.com/u/Lyya)
#### Post date: [August 10, 2016, 1:33am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/228 "2016-08-10T01:33:01Z")
Added a console dropdown in the upper right corner for every page, which works like the language dropdown:
---
### Author:  [@killerman3333](https://community.gemsofwar.com/u/killerman3333)
#### Post date: [August 10, 2016, 4:05am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/229 "2016-08-10T04:05:54Z")
I love all the work you have done making and updating the resource you made.
---
### Author:  [@Stan](https://community.gemsofwar.com/u/Stan)
#### Post date: [August 10, 2016, 9:10pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/230 "2016-08-10T21:10:33Z")
That is a perfect solution. Thanks for doing that, and to @Robert who I think had the idea.
---
### Author:  [@Strat](https://community.gemsofwar.com/u/Strat)
#### Post date: [August 11, 2016, 1:55am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/231 "2016-08-11T01:55:11Z")
> [@Stan](#):
>
> That is a perfect solution. Thanks for doing that, and to @Robert who I think had the idea.
It wasn’t his idea. But yes, The solution is perfect 😀.
PS: I’m 2 for 2 recently Sirrian also used the botting guild cheater “solution” / penalty as well.
Time to reset my dislocated shoulder after patting myself on the back.
Edit: Throwing around ideas is the easy part, doing the coding is the real deal.
---
### Author:  [@Stan](https://community.gemsofwar.com/u/Stan)
#### Post date: [August 11, 2016, 3:32am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/232 "2016-08-11T03:32:32Z")
My bad. Credit to you, then!
---
### Author:  [@Lyya](https://community.gemsofwar.com/u/Lyya)
#### Post date: [August 12, 2016, 6:23pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/233 "2016-08-12T18:23:58Z")
Added a tabular view of weapons, in the same vein as the troop table. Not sure it’s as useful, because the number of columns around which to pivot are considerably fewer, but it was easy to add so why the hell not.
> **[Weapon Table - Gems of War Database](https://gowdb.com/weapontable)**
>
> A table of all weapons in Gems of War and their statistics.
[http://ashtender.com/gems/console/weapontable](http://ashtender.com/gems/console/weapontable)
---
### Author:  [@Robert](https://community.gemsofwar.com/u/Robert)
#### Post date: [August 12, 2016, 7:39pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/234 "2016-08-12T19:39:33Z")
@Stan you were correct the first time…
@Strat
---
### Author:  [@Lyya](https://community.gemsofwar.com/u/Lyya)
#### Post date: [August 18, 2016, 11:31pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/235 "2016-08-18T23:31:25Z")
Added history to the Gems of War Database! It’s now possible to go back in time to look up a troop pre-changes to do comparisons (or to do it wholesale over the entire table). The UI affordance is a timer in the corner of the screen, like so:
I’ve thrown up the 6/17 World.json file just to use as a test, but _please note that I preserved only the world data, not the text_ from that date, and so the mechanics won’t line up with the troop spell descriptions. Going forward, this won’t be a problem, as I’ll save off the text files along with the world data. Just be careful with this first upload!
For those curious, the URL differences are as follows:
> **[War - Troops - Gems of War Database](https://gowdb.com/troops/6197)**
>
> Endless Conflict (20 Blue/Red/Brown): Burn all Enemies. Deal \[Magic + 1\] damage to an Enemy, boosted by my Attack. Gain an extra turn if the Enemy dies. \[1:1\]
[http://ashtender.com/gems/2016-06-17/troops/war](http://ashtender.com/gems/2016-06-17/troops/war)
This makes it really easy to find differences for a single troop, via the W3C HTML diff service:
[http://services.w3.org/htmldiff](http://services.w3.org/htmldiff)
Here is War from 6/17 as compared to now:
[http://services.w3.org/htmldiff?doc1=http%3A%2F%2Fashtender.com%2Fgems%2F2016-06-17%2Ftroops%2Fwar&doc2=http%3A%2F%2Fashtender.com%2Fgems%2Ftroops%2Fwar](http://services.w3.org/htmldiff?doc1=http%3A%2F%2Fashtender.com%2Fgems%2F2016-06-17%2Ftroops%2Fwar&doc2=http%3A%2F%2Fashtender.com%2Fgems%2Ftroops%2Fwar)
Here are all troops from 6/17 as compared to now:
[http://services.w3.org/htmldiff?doc1=http%3A%2F%2Fashtender.com%2Fgems%2F2016-06-17%2Ftrooptable&doc2=http%3A%2F%2Fashtender.com%2Fgems%2Ftrooptable](http://services.w3.org/htmldiff?doc1=http%3A%2F%2Fashtender.com%2Fgems%2F2016-06-17%2Ftrooptable&doc2=http%3A%2F%2Fashtender.com%2Fgems%2Ftrooptable)
---
### Author:  [@Lyya](https://community.gemsofwar.com/u/Lyya)
#### Post date: [August 19, 2016, 6:56am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/236 "2016-08-19T06:56:59Z")
Found a version from April, which is about when I started down this rabbit hole! This one even has a corresponding English text file I saved off.
> **[Dark Maiden - Troops - Gems of War Database](https://gowdb.com/troops/6013)**
>
> Maiden's Touch (10 Green/Red): Transform all Yellow Gems to a chosen color. Give \[Magic + 1\] Life to the first Ally, boosted by Gems transformed. \[3:1\]
[http://ashtender.com/gems/2016-04-23/troops/dark-maiden](http://ashtender.com/gems/2016-04-23/troops/dark-maiden)
Diff of Dark Maiden (with text differences!)
[http://services.w3.org/htmldiff?doc1=http%3A%2F%2Fashtender.com%2Fgems%2F2016-04-23%2Ftroops%2Fdark-maiden&doc2=http%3A%2F%2Fashtender.com%2Fgems%2Ftroops%2Fdark-maiden](http://services.w3.org/htmldiff?doc1=http%3A%2F%2Fashtender.com%2Fgems%2F2016-04-23%2Ftroops%2Fdark-maiden&doc2=http%3A%2F%2Fashtender.com%2Fgems%2Ftroops%2Fdark-maiden)
Where we’ve come since April!
As a table:
[http://services.w3.org/htmldiff?doc1=http%3A%2F%2Fashtender.com%2Fgems%2F2016-04-23%2Ftrooptable&doc2=http%3A%2F%2Fashtender.com%2Fgems%2Ftrooptable](http://services.w3.org/htmldiff?doc1=http%3A%2F%2Fashtender.com%2Fgems%2F2016-04-23%2Ftrooptable&doc2=http%3A%2F%2Fashtender.com%2Fgems%2Ftrooptable)
As a gigantic full-list diff:
[http://services.w3.org/htmldiff?doc1=http%3A%2F%2Fashtender.com%2Fgems%2F2016-04-23%2Ftroopquery&doc2=http%3A%2F%2Fashtender.com%2Fgems%2Ftroopquery](http://services.w3.org/htmldiff?doc1=http%3A%2F%2Fashtender.com%2Fgems%2F2016-04-23%2Ftroopquery&doc2=http%3A%2F%2Fashtender.com%2Fgems%2Ftroopquery)
---
### Author:  [@Jainus](https://community.gemsofwar.com/u/Jainus)
#### Post date: [August 19, 2016, 7:01am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/237 "2016-08-19T07:01:41Z")
Perhaps the devs could make the Troops List at the top of this website go to @lyya’s page rather than the long long long out-of-date page it still links to…? @sirrian @nimhain?
---
### Author:  [@Strat](https://community.gemsofwar.com/u/Strat)
#### Post date: [August 19, 2016, 2:28pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/238 "2016-08-19T14:28:30Z")
> [@Jainus](#):
>
> Perhaps the devs could make the Troops List at the top of this website go to @lyya’s page rather than the long long long out-of-date page it still links to…? @sirrian @nimhain?
That’s a great idea! Doesn’t the wiki already go to an external page now? PS some of the other top links are a bit stale as well.
---
### Author:  [@Spherix](https://community.gemsofwar.com/u/Spherix)
#### Post date: [August 21, 2016, 11:11am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/239 "2016-08-21T11:11:00Z")
So… [Winter Wolf](http://ashtender.com/gems/troops/6196) is showing up Blue/Purple, as it should, but the trait tooltips are saying they take Nature and Water stones, which isn’t right. I thought the data was pulled directly from the game files, but I do see that Winter Wolf was added manually when it was introduced, because decrypted files weren’t available at the time. What’s going on here, @Lyya?
---
### Author:  [@Lyya](https://community.gemsofwar.com/u/Lyya)
#### Post date: [August 21, 2016, 2:48pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/240 "2016-08-21T14:48:41Z")
Yeah, the game files have the troop listed with incorrect primary/secondary colors. I hard-coded costs based on the colors the game files had listed, which causes this troop to be incorrectly attributed; I noted it long ago. I actually do have the data now to fix this properly but haven’t gotten around to it.
---
### Author:  [@outlander](https://community.gemsofwar.com/u/outlander)
#### Post date: [August 21, 2016, 5:04pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/241 "2016-08-21T17:04:53Z")
Anyone knows about the Mythic troop Guerre? Just saw on chat room 001 as someone got it thru the chest but no idea from which chest? Im very curious.
[Previous page](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037.md?page=11)
[Next page](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037.md?page=13)