# 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:** 14
### Author:  [@Lyya](https://community.gemsofwar.com/u/Lyya)
#### Post date: [September 25, 2016, 9:20pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/262 "2016-09-25T21:20:05Z")
That’s right, I tried to get smart about stone sorting and follow the in-game sorting rules (which is how they’re sorted in the Hero Collection tab). In the absence of feedback, it’s hard to know which is more appropriate for site users, so I just make educated guesses at most of the site design. Sometimes I miss the mark… I’m happy to change the sort for that column to be alphabetical if people think it’d be better that way.
---
### Author:  [@Reachground](https://community.gemsofwar.com/u/Reachground)
#### Post date: [September 25, 2016, 9:24pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/263 "2016-09-25T21:24:12Z")
> [@Lyya](#):
>
> That’s right, I tried to get smart about stone sorting and follow the in-game sorting rules (which is how they’re sorted in the Hero Collection tab). In the absence of feedback, it’s hard to know which is more appropriate for site users, so I just make educated guesses at most of the site design. Sometimes I miss the mark… I’m happy to change the sort for that column to be alphabetical if people think it’d be better that way.
Thanks for your quick response. Since I took a look at it closer I understood the system. It still doesn’t mean anything to me though. Naturally I’d love to have it alphabetically (since there already is a button for color, not exactly the same I know). Let’s see what other people have to say. Hopefully we get some voices from new:ish players as well.
---
### Author:  [@Gortus](https://community.gemsofwar.com/u/Gortus)
#### Post date: [September 25, 2016, 10:38pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/264 "2016-09-25T22:38:41Z")
I can imagine use cases for matching the game but personally I’d prefer alphabetical.
---
### Author:  [@actreal](https://community.gemsofwar.com/u/actreal)
#### Post date: [September 25, 2016, 11:31pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/265 "2016-09-25T23:31:38Z")
When I ran a poll for a similar list, before @Lyya’s awesome website superseded it, there was a strong consensus for sorting by GoW order:
> [@Poll: GoW Wiki - How to Sort the Troop List](http://community.gemsofwar.com/t/poll-gow-wiki-how-to-sort-the-troop-list/3761):
>
> So in the next few days I’m planning to reprogram the sorting on the [main Troops table](http://gems-of-war.wikia.com/wiki/Troops) on the GoW wiki. It currently sorts by Primary Colour OR Secondary Colour, in alphabetical order by colour name. I’m going to make it sort by both colours at once, which will be much more useful. Now which colour is primary and which is secondary is important, because they determine which traitstones a Troop needs. However, for sorting, I think the best choice is to sort both together (i.e. group Red/Yello…
The sorting order is consistent throughout the game, and mana is credited within the game in this order when there are multiple matches (Blue first, then Green etc.)
So, while I acknowledge that this might be non-intuitive for newer players, I would argue that the solution is for newer players to learn the GoW order, rather than Lyya change her website.
---
### Author:  [@Lyya](https://community.gemsofwar.com/u/Lyya)
#### Post date: [September 26, 2016, 4:06am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/266 "2016-09-26T04:06:34Z")
Thanks for the bug report, @Shimrra. It should be fixed now.
---
### Author:  [@Shimrra](https://community.gemsofwar.com/u/Shimrra)
#### Post date: [September 26, 2016, 9:52am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/267 "2016-09-26T09:52:31Z")
Looks to be, just tested. Nice!
---
### Author:  [@Lyya](https://community.gemsofwar.com/u/Lyya)
#### Post date: [December 5, 2016, 6:42am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/269 "2016-12-05T06:42:23Z")
After a few months of lying fallow:
**Gems of War Quiz!**
> **[Quiz - Extras - Gems of War Database](https://gowdb.com/extras/quiz)**
>
> Take this quiz to test your knowledge of Gems of War!
You’re the Hero of a war-torn world in chaos. You’ve faced every challenge you’ve been given and emerged victorious — and learned a thing or two along the way. But how well do you really know the myriad denizens of Krystara? Take a 20-question quiz to test your knowledge!
---
### Author:  [@Gortus](https://community.gemsofwar.com/u/Gortus)
#### Post date: [December 5, 2016, 2:23pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/270 "2016-12-05T14:23:39Z")
I didn’t get 20/20 so I must not be addicted to GoW, right?
---
### Author:  [@Kurokazna](https://community.gemsofwar.com/u/Kurokazna)
#### Post date: [December 5, 2016, 2:40pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/271 "2016-12-05T14:40:57Z")
This is awesome.
I got 19/20 because I had a momentary brain lapse when it came to Tassarion. Wonderful feature though!
Edit: Second quiz, I got 19/20 again because I didn’t remember Blackhawk’s kingdom bonus :\<
I need to get better at this
---
### Author:  [@LYNDALE](https://community.gemsofwar.com/u/LYNDALE)
#### Post date: [December 7, 2016, 1:14am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/272 "2016-12-07T01:14:22Z")
I have to say this is one amazing site. I can’t imagine the hours you put into everything! Much impressed Lyya.
---
### Author:  [@Lyya](https://community.gemsofwar.com/u/Lyya)
#### Post date: [December 8, 2016, 2:41am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/273 "2016-12-08T02:41:59Z")
Rearranged the kingdoms page ([Kingdoms - Gems of War Database](http://ashtender.com/gems/kingdoms)) to be more visually appealing, and added kingdom shields to the page.
Created per-kingdom pages and moved the quests into the per-kingdom pages; [Blighted Lands - Kingdoms - Gems of War Database](http://ashtender.com/gems/kingdoms/blighted-lands) contains the kingdom details and quests for that one kingdom.
Added a quiz question requiring you to identify a kingdom by shield.
---
### Author:  [@Jainus](https://community.gemsofwar.com/u/Jainus)
#### Post date: [December 8, 2016, 8:28pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/274 "2016-12-08T20:28:38Z")
Just to flag that @lyya has updated the table after some requests / questions / nagging from yours truly:
Damage values of \> 999 are now flagged as “kills” instead of “damages.”
Anything targeting all enemies now has " (all)" appended to the spell component.
Anything targeting an ally now has " (ally)" appended to the spell component.
Anything targeting all allies now has " (all allies)" appended to the spell component.
Negative status effects that target the caster now have " (self)" appended to the spell component.
Added a column, hidden by default, that contains the “Spell Bonus,” or type/condition that causes the spell to become more effective. For example, “Red target,” or “Goblin,” or “Kill” (for those spells that do extra effects when they manage to kill something).
…so even more great info and ease of hunting…
I’d not spent long on the site before, but doing so now, it’s an amazing bit of work…
@Sirrian @Nimhain can the main GoW site not reference this site rather than the current (or rather, not-current, very old and out-of-date) troops list and other stuff? Or are there EULA and similar copyright issues…?
---
### Author:  [@Gortus](https://community.gemsofwar.com/u/Gortus)
#### Post date: [December 9, 2016, 1:51am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/275 "2016-12-09T01:51:17Z")
Excellent improvements! Thank you Lyya (and Jainus for instigating).
---
### Author:  [@Lyya](https://community.gemsofwar.com/u/Lyya)
#### Post date: [December 19, 2016, 10:16am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/276 "2016-12-19T10:16:01Z")
I’ve migrated my site’s backend tech to something better and faster in an effort to speed up the page load times, which have recently started to really grind to a crawl. If I did it right, the change should be mostly unnoticeable aside from better load times, but as always, if you see something that’s either factually incorrect or otherwise broken, please let me know.
---
### Author:  [@Annaerith](https://community.gemsofwar.com/u/Annaerith)
#### Post date: [December 22, 2016, 12:06pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/277 "2016-12-22T12:06:57Z")
i have a request, @Lyya
**please add to the home page a search window for Troops** (not table)
i think thats the feature most commonly needed and id love to have one click-load less of waiting to get there 😜
---
### Author:  [@Lyya](https://community.gemsofwar.com/u/Lyya)
#### Post date: [December 22, 2016, 9:33pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/278 "2016-12-22T21:33:03Z")
Added. There’s now a dropdown on [http://ashtender.com/gems](http://ashtender.com/gems) that forwards the filter to [http://ashtender.com/gems/troops](http://ashtender.com/gems/troops). I’ve also added an autocomplete dropdown that contains the names of all troops, to hopefully make the input process easier (doesn’t seem to be respected by iPhone, but works on PC browsers).
Let me know if this meets your needs!
Lyya
---
### Author:  [@Annaerith](https://community.gemsofwar.com/u/Annaerith)
#### Post date: [December 22, 2016, 11:43pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/279 "2016-12-22T23:43:29Z")
love it! thanks
---
### Author:  [@Ariel](https://community.gemsofwar.com/u/Ariel)
#### Post date: [December 23, 2016, 7:07am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/280 "2016-12-23T07:07:55Z")
I assume the Summoner power should say:
Give all Allies 4 Life. Summon a level [Magic] Ghoul.
It’s partly blank right now.
Not to nitpick, the site is amazing.
---
### Author:  [@Lyya](https://community.gemsofwar.com/u/Lyya)
#### Post date: [December 23, 2016, 1:48pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/281 "2016-12-23T13:48:11Z")
Thanks for the report, was a regression I missed. Should be corrected now.
---
### Author:  [@Jainus](https://community.gemsofwar.com/u/Jainus)
#### Post date: [January 7, 2017, 9:42am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/282 "2017-01-07T09:42:20Z")
Hi @lyya - couldn’t find the right thread to post this in…
On the events part of your site’s front page, the troops aren’t quite in the right order and the dates aren’t lining up properly…
For example:
- Pharos-Ra is the most recent troop, on 6/1/17
- Void Portal and Dark Troll on 1/1/17
- Ice Golem was posted out to everyone also on 25/12/16 (I think)
- Urska Wanderer and Snowy Owl should be together on 25/12/16
- Snow Guardian and Frostling should be together on 18/12/16
Also the images aren’t spacing evenly… which would bug me… 😃
[Previous page](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037.md?page=13)
[Next page](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037.md?page=15)