# 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:** 25
### Author:  [@CyberZ](https://community.gemsofwar.com/u/CyberZ)
#### Post date: [September 6, 2019, 1:34pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/485 "2019-09-06T13:34:33Z")
Is there a problem with the link function. Im creating an account and then trying to link my gow profile.
It does’nt work (cant find my profile). Im sure of my answers for the link (invitation name + 2 stones quantities).
---
### Author:  [@HugeOgre](https://community.gemsofwar.com/u/HugeOgre)
#### Post date: [September 6, 2019, 7:13pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/486 "2019-09-06T19:13:18Z")
My Collection page is down for me
---
### Author:  [@Mana\_Surgeon](https://community.gemsofwar.com/u/Mana_Surgeon)
#### Post date: [September 11, 2019, 9:14pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/487 "2019-09-11T21:14:08Z")
Also notable that last week’s new Dragon’s Claw troops are missing from the database (though Lamashtu is there for this week).
---
### Author:  [@HugeOgre](https://community.gemsofwar.com/u/HugeOgre)
#### Post date: [September 20, 2019, 8:11pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/489 "2019-09-20T20:11:14Z")
Aquaticus is not in GoWDB
---
### Author:  [@Mana\_Surgeon](https://community.gemsofwar.com/u/Mana_Surgeon)
#### Post date: [October 22, 2019, 7:24pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/490 "2019-10-22T19:24:07Z")
Just popping in to note that the site is getting a bit buggy again - the home page does not display the current events.
Also, the missing troops from September (Volthrenax, Thaumaris, Aquaticus) are still missing.
Finally, a minor suggestion - the troop table lets you sort on any troop stat except magic. Any way this could be added?
Thanks again Lyya.
---
### Author:  [@EliteMasterEric](https://community.gemsofwar.com/u/EliteMasterEric)
#### Post date: [October 22, 2019, 7:55pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/491 "2019-10-22T19:55:17Z")
It seems like the site isn’t being worked on in terms of new features, but an Elite Level leaderboard would be cool.
---
### Author:  [@madking](https://community.gemsofwar.com/u/madking)
#### Post date: [October 23, 2019, 8:15pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/492 "2019-10-23T20:15:55Z")
Am I the only one getting an error 500 when I try to go into my collection?
---
### Author:  [@TimberWolfe](https://community.gemsofwar.com/u/TimberWolfe)
#### Post date: [October 23, 2019, 11:24pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/493 "2019-10-23T23:24:40Z")
I’ve been getting it for a few days now
---
### Author:  [@Lyya](https://community.gemsofwar.com/u/Lyya)
#### Post date: [October 24, 2019, 9:37pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/494 "2019-10-24T21:37:55Z")
Sorry everyone. I’ve fixed the My Collection page and added art for the missing troops and spells. If there are troops/pets/weapons/etc. missing from the site, please let me know and I’ll add them manually.
---
### Author:  [@TimberWolfe](https://community.gemsofwar.com/u/TimberWolfe)
#### Post date: [October 24, 2019, 11:12pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/495 "2019-10-24T23:12:49Z")
Working. Thank you so much for all your hard work.
---
### Author:  [@Ashasekayi](https://community.gemsofwar.com/u/Ashasekayi)
#### Post date: [October 24, 2019, 11:38pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/496 "2019-10-24T23:38:34Z")
Thanks @Lyya 🤗
---
### Author:  [@Mana\_Surgeon](https://community.gemsofwar.com/u/Mana_Surgeon)
#### Post date: [October 25, 2019, 12:01am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/497 "2019-10-25T00:01:43Z")
Thanks Lyya, I appreciate your keeping the site up to date! The events/front page are fixed.
Still missing from the troop database:
Volthrenax
Thaumaris
Aquaticus
All 4 Wild Court Faction troops
---
### Author:  [@Lyya](https://community.gemsofwar.com/u/Lyya)
#### Post date: [October 25, 2019, 2:23pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/498 "2019-10-25T14:23:50Z")
Got it. I’ll add these today. Thanks!
---
### Author:  [@Lyya](https://community.gemsofwar.com/u/Lyya)
#### Post date: [October 25, 2019, 11:20pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/499 "2019-10-25T23:20:02Z")
I’ve added the specified 7 troops and also Droggo. Thanks very much for the report. Please let me know if there are any others that are missing.
Thanks,
Lyya
---
### Author:  [@Lyya](https://community.gemsofwar.com/u/Lyya)
#### Post date: [October 25, 2019, 11:23pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/500 "2019-10-25T23:23:22Z")
> [@Mana\_Surgeon](#):
>
> Finally, a minor suggestion - the troop table lets you sort on any troop stat except magic. Any way this could be added?
Are you referring to the troop’s Magic stat or their mana cost? If the former, I’d love to understand what you’d do with a sort on Magic, since the meaning of that stat varies from spell to spell – it’s not really interesting that one troop has a higher max Magic stat than another (I imagine). If you mean their mana cost, then that can be done by adding the Cost column to the table via “Choose Columns” and then sorting by it.
Thanks,
Lyya
---
### Author:  [@Mana\_Surgeon](https://community.gemsofwar.com/u/Mana_Surgeon)
#### Post date: [October 25, 2019, 11:30pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/501 "2019-10-25T23:30:17Z")
Magic stat. It’s not necessarily for sorting - without access to the magic stat, you can’t calculate and compare spell damages while in the troop table. Leads to a lot of extra clicking, as you are instead required to bring up the troop’s page, then go back to the table.
Thanks again!
---
### Author:  [@Lyya](https://community.gemsofwar.com/u/Lyya)
#### Post date: [October 26, 2019, 5:17am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/502 "2019-10-26T05:17:31Z")
Oh, I get it. So what you’re really after here is something in the description like:
“Deal [Magic + 4] damage to an enemy. Deal double damage if the enemy is Enraged. (MAX Magic: 10)”
Yes?
---
### Author:  [@Mana\_Surgeon](https://community.gemsofwar.com/u/Mana_Surgeon)
#### Post date: [October 29, 2019, 12:00am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/503 "2019-10-29T00:00:20Z")
Thanks for the troop updates, I saw that they are all now up on the site and in the timeline (my favorite “extra,” although the delve rooms are nice too)!
Re: troop magic stats on the table, yes, exactly what you said. Hope that’s an easy add?
---
### Author:  [@Lyya](https://community.gemsofwar.com/u/Lyya)
#### Post date: [October 29, 2019, 12:28am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/504 "2019-10-29T00:28:26Z")
Not hard to add, I can do that in a day or so. Thanks for the suggestion!
---
### Author:  [@Lyya](https://community.gemsofwar.com/u/Lyya)
#### Post date: [October 29, 2019, 7:31am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/505 "2019-10-29T07:31:40Z")
Done, please let me know if that takes care of your needs.
Lyya
[Previous page](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037.md?page=24)
[Next page](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037.md?page=26)