# 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:** 1
**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, 2016, 9:02pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/1 "2016-04-26T21:02:42Z")
Hi everyone, I’ve created a webpage that can be used to browse and search for all the troops, classes, weapons, kingdoms in Gems of War, along with many other features. It is called the “Gems of War Database” and can be found here: > **[Gems of War Database](https://gowdb.com)** > > The definitive resource for all troops and content in Gems of War. ~~[http://ashtender.com/gems~~](http://ashtender.com/gems~~) **Troop List** The troop list can be found here: > **[Troops - Gems of War Database](https://gowdb.com/troops/)** > > A list of all troops in Gems of War and their statistics. ~~[http://ashtender.com/gems/troops~~](http://ashtender.com/gems/troops~~) In addition to what the official Troop List supports, the replacement list has: - Up-to-date stats information for all stats to level 20 - Ascension modifiers for all stats - Trait names and tooltip descriptions - Filtering and sorting much like the in-game filters and sorts - More easily-distinguishable spell colors - More easily-distinguishable rarity indicated by troop borders - Support for all supported game languages: - German: [http://gowdb.com/de-DE/troops](http://gowdb.com/de-DE/troops) - French: [Unités - Encyclopédie Gems of War](http://gowdb.com/fr-FR/troops) - Italian: [Truppe - Enciclopedia Gems of War](http://gowdb.com/it-IT/troops) - Spanish: [Tropas - Enciclopedia Gems of War](http://gowdb.com/es-ES/troops) - Russian: [Войска - База Данных Gems of War](http://gowdb.com/ru-RU/troops) Additionally, you can link to a specific troop by name: > **[Mercy - Troops - Gems of War Database](https://gowdb.com/troops/6167)** > > Divine Grace (12 Blue/Green): Give \[Magic\] Life to the weakest Ally, transform Purple Gems to Yellow to boost the effect. Cleanse all allies. \[3:1\] > **[Anointed One - Troops - Gems of War Database](https://gowdb.com/troops/6152)** > > Frenzy (12 Blue/Red): Gain \[Magic + 1\] Attack and Life, and transform all Green Gems to Red to boost the effect. \[3:1\] Or you can link by ID: > **[Mercy - Troops - Gems of War Database](https://gowdb.com/troops/6167)** > > Divine Grace (12 Blue/Green): Give \[Magic\] Life to the weakest Ally, transform Purple Gems to Yellow to boost the effect. Cleanse all allies. \[3:1\] The default page is paginated to keep load times and client load down. To see all troops at once, a tabular view can be found here: > **[Troop Table - Gems of War Database](https://gowdb.com/trooptable)** > > A table of all troops in Gems of War and their statistics. This is also linked off the filter bar on the main page. **Weapon List** There is also a weapons list, which is very similar to the troops list. > **[Weapons - Gems of War Database](https://gowdb.com/weapons/)** > > A list of all weapons in Gems of War and their statistics. > **[Weapon Table - Gems of War Database](https://gowdb.com/weapontable)** > > A table of all weapons in Gems of War and their statistics. Just like the troops list, it supports sorts, filters, and colors as part of the query parameters: > **[Weapons - Gems of War Database](https://gowdb.com/weapons/?filter=yasmine)** > > A list of all weapons in Gems of War and their statistics. > **[Weapons - Gems of War Database](https://gowdb.com/weapons/?color1=green&sort=byRarity)** > > A list of all weapons in Gems of War and their statistics. And you can also directly link a weapon by either ID or by name! > **[Arrow of Slaying - Weapons - Gems of War Database](https://gowdb.com/weapons/1082)** > > Arrow of Slaying (18 Blue/Green): Deal \[Magic + 10\] damage to an Enemy. > **[Yasmine's Chalice - Weapons - Gems of War Database](https://gowdb.com/weapons/1122)** > > Yasmine's Chalice (13 Green/Yellow): Give \[Magic / 2\] Life and Armor to all Allies. If there are 13 or more Green Gems, gain an extra turn. > **[Burning Scythe - Weapons - Gems of War Database](https://gowdb.com/weapons/1124)** > > Burning Scythe (14 Red/Purple): Deal \[(Magic / 2) + 2\] damage to all Enemies. Burn a random Enemy and Disease another. > **[Cauldron - Weapons - Gems of War Database](https://gowdb.com/weapons/1086)** > > Cauldron (20 Green/Brown): Give \[Magic + 1\] Life to an Ally, and double their Attack. \[1:1\] And localized links! > **[Cálice de Yasmine - Armas - Enciclopedia Gems of War](https://gowdb.com/es-ES/weapons/1122)** > > Cálice de Yasmine (13 Verde/Amarillo): Dona \[Magia / 2\] de Vida y Armadura a todos los aliados. Si hay 13 o más Gemas Verdes en el tablero, gana un turno extra. [http://gowdb.com/de-DE/weapons/stulpenhandschuhe-des-wildhüters](http://gowdb.com/de-DE/weapons/stulpenhandschuhe-des-wildh%C3%BCters) (whew) **Hero Class List** > **[Classes - Gems of War Database](https://gowdb.com/classes/)** > > A list of all classes in Gems of War and their statistics. As with troops and weapons, it’s possible to link Hero classes directly: > **[Warlord - Classes - Gems of War Database](https://gowdb.com/classes/11135)** > > Warlord's Battlecry (14 Red): Deal \[Magic + 2\] damage to an Enemy, boosted by the Enemy's Attack. \[1:1\] > **[Necromancer - Classes - Gems of War Database](https://gowdb.com/classes/11140)** > > Creeping Death (14 Purple): Death Mark the strongest and weakest Enemies. Deal \[Magic + 1\] damage to all Enemies. Hero perks have mouseover tips. **Team Builder** If you’d like to experiment with builds, you can do so on the site. Just click the “Add to team” link that shows up when you mouseover the troop portraits, and you’ll start building a team. Do so with other troops, or pick one from the set of (hopefully helpful) suggestions that show up, and when you’ve created a team, click “Publish Team” to create a page you can then show to others. An example team might look like: [http://gowdb.com/teams/templar,mercy,paladin,valkyrie](http://gowdb.com/teams/templar,mercy,paladin,valkyrie) **Kingdoms and Quests** You can see details about all of the released kingdoms here: > **[Kingdoms - Gems of War Database](https://gowdb.com/kingdoms/)** > > A list of all kingdoms in Gems of War and their statistics. You’ll find information about what the kingdom’s banner does, as well as a list of all troops in that kingdom. Additionally, each kingdom has a link to a page containing all of the kingdom quest text. For example, all of the Maugrim Woods text is here (of course, Thar Be Spoilers after this link): > **[Maugrim Woods - Kingdoms - Gems of War Database](https://gowdb.com/kingdoms/3008)** > > The Wolves of the Wilds: Hostile tribes of Wargare - the wolf people - live deep within Maugrim Woods. **PlayStation 4 and Xbox One Collections** Console views are available on every page in the Database. These views restrict troops, weapons, classes, and kingdoms to those present on the two console platforms. The landing pages are here: [Gems of War Database](http://gowdb.com/ps/) (Note the final slash is unfortunately needed!) [Gems of War Database](http://gowdb.com/xbox/) (Note the final slash is unfortunately needed!) The troops list is: > **[Troops - Gems of War Database](https://gowdb.com/ps/troops/)** > > A list of all troops in Gems of War and their statistics. > **[Troops - Gems of War Database](https://gowdb.com/xbox/troops/)** > > A list of all troops in Gems of War and their statistics. The troop table is: > **[Troop Table - Gems of War Database](https://gowdb.com/ps/trooptable)** > > A table of all troops in Gems of War and their statistics. > **[Troop Table - Gems of War Database](https://gowdb.com/xbox/trooptable)** > > A table of all troops in Gems of War and their statistics. etc. **Account Linking and My Collection** It’s now possible to link your Gems of War account (PC/Mobile or Console) with your DB account and import a list of your troops and remaining Traitstones! This is a great planning tool for people working on their Collections. For details, see the below threads: > [@My Collection on Gems of War Database - Auto Updates!](http://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799): > > Hi everyone, I’ve just made an addition to the My Collection feature of the GoW Database that might save you some time. The site can now update your Hero data automatically whenever you visit! This provides several benefits, not the least of which is that all the edit fields become read only and you don’t have to type anything in anymore. slight_smile To do this, you’ll need to link your Gems of War account with your DB account. You can get there from your Account page, or from the My Co… > [@GoW DB: PS4 and Xbox Account Linking](http://community.gemsofwar.com/t/gow-db-ps4-and-xbox-account-linking/28275): > > Copied from [Gems of War Database](http://ashtender.com/gems) : PS4 and Xbox Account Linking I’ve got some exciting news for Console players! It’s finally possible to link your PlayStation 4 or Xbox One account with your Gems of War Database account, which allows for automatic updates to your account from the game, as well as resource tracking – just like PC and Console players have had available since early this year! To link your accounts, go to your [Account](http://ashtender.com/gems/account) page, and enter your invite code as well as other informatio… **Leaderboards** For those interested in a friendly competition, the Gems of War Database is now tracking the linked players with the highest level and those with the most unique troops ascended to Mythic. Details can be found in the below thread: > [@GoW DB: Leaderboards and Menu Organization](http://community.gemsofwar.com/t/gow-db-leaderboards-and-menu-organization/28269): > > Copied from [Gems of War Database](http://ashtender.com/gems) : Leaderboards and Menu Organization I’ve made a small update to the site to reoganize the non-essential “toy” pages of the site under its own heading, “Extras.” Of the currently-linked pages, this includes only the [Quiz](http://ashtender.com/gems/quiz) page. I’m taking this opportunity to officially introduce the [Ascension Leaderboard](http://ashtender.com/gems/extras/ascension)! This page is way to “compete” (just for fun) with other players as to who has the most troops fully-ascended and leveled to 20. Though it’s seen quite some … **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! **Disclaimer** Note that while I will attempt to keep the site up to date as changes roll out, there’s no guarantee that it will remain accurate. The game is subject to change at any time. You’ve been warned! Feedback is always welcome. Try it out and let me know what I can improve! Lyya ---
**Author:** ![TaliaParks](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/taliaparks/32/11738_2.png) [@TaliaParks](https://community.gemsofwar.com/u/TaliaParks)\ **Post date:** [April 26, 2016, 9:14pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/2 "2016-04-26T21:14:17Z")
In with a Bookmark! ---
**Author:** ![Macawi](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/macawi/32/21289_2.png) [@Macawi](https://community.gemsofwar.com/u/Macawi)\ **Post date:** [April 26, 2016, 9:15pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/3 "2016-04-26T21:15:44Z")
Very good work @Lyya. It’s pleasant to see you going the extra mile, it really shows your dedication and enthusiasm for the game. 👍 ---
**Author:** ![Eika](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/eika/32/103088_2.png) [@Eika](https://community.gemsofwar.com/u/Eika)\ **Post date:** [April 26, 2016, 9:20pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/4 "2016-04-26T21:20:02Z")
Kind of you Macawi, you always seems to cheer up people. 🙂 Btw love your work, Lyya!!!😍 ---
**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 26, 2016, 9:37pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/5 "2016-04-26T21:37:49Z")
Great work and many thanks for this @Lyya! Especially for the languages support. I bet the one or other will help this a lot! I checked it out already. I found some Troops with no Image so far. I hope it helps a bit 🙂 BUNNI’NOG HELLHOUND HERALD OF CHAOS INFERNAL KING QUASIT RAKSHANIN RUNESMITH SPRING IMP SUCCUBUS TWISTED HERO VENBARAK Do you think its possible to sort the Troops by Traitstones? Especially the Arcane? This would save some Time for me betweenwhiles. But however. Just a suggestion, hehe. Thank you for the very helpful Project 😺 ---
**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, 2016, 9:39pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/6 "2016-04-26T21:39:53Z")
Thanks for the feedback, @Korbit. The issue with the missing images is, I’m pointing to images hosted by [http://gemsofwar.com](http://gemsofwar.com), and they haven’t uploaded images for the latest troops (presumably because the Troop List doesn’t have those troops yet!). I could add the images myself but I’d want to get their permission before rehosting those images. ---
**Author:** ![Razzagor](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/razzagor/32/50037_2.png) [@Razzagor](https://community.gemsofwar.com/u/Razzagor)\ **Post date:** [April 26, 2016, 10:02pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/7 "2016-04-26T22:02:34Z")
Thank you, thank you, thank you! This is just the THING i was needing! ❤❤❤❤❤❤❤ ← Extra likes that you deserve. ---
**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:** [April 26, 2016, 11:44pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/8 "2016-04-26T23:44:47Z")
Top stuff! I changed the category for this thread to Community Guides so it’ll be easier to find for old and new forum folk alike. ---
**Author:** ![temmie143](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/temmie143/32/239_2.png) [@temmie143](https://community.gemsofwar.com/u/temmie143)\ **Post date:** [April 27, 2016, 12:34am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/9 "2016-04-27T00:34:23Z")
So needed, thanks so much! This is greatly appreciated in countless useful ways!!! One question, I could guess but I will ask instead,…what do the letters R, UR, E, L, M stand for? ---
**Author:** ![Eika](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/eika/32/103088_2.png) [@Eika](https://community.gemsofwar.com/u/Eika)\ **Post date:** [April 27, 2016, 12:38am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/10 "2016-04-27T00:38:17Z")
Hi, they stand for the first letters for the base rarities. ---
**Author:** ![Zelfore](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/zelfore/32/22295_2.png) [@Zelfore](https://community.gemsofwar.com/u/Zelfore)\ **Post date:** [April 27, 2016, 12:45am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/11 "2016-04-27T00:45:16Z")
More specifically, they are the stats you’ll gain when ascending a troop to that rarity. Ascending an Ultra Rare (UR) to Epic (E) will give such and such stats. ---
**Author:** ![mkshandley](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/mkshandley/32/3549_2.png) [@mkshandley](https://community.gemsofwar.com/u/mkshandley)\ **Post date:** [April 27, 2016, 2:39am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/12 "2016-04-27T02:39:35Z")
nice works Lyya ---
**Author:** ![peremptor](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/peremptor/32/4176_2.png) [@peremptor](https://community.gemsofwar.com/u/peremptor)\ **Post date:** [April 27, 2016, 3:18am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/13 "2016-04-27T03:18:39Z")
Well done and much appreciated. ---
**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:** [April 27, 2016, 3:31am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/14 "2016-04-27T03:31:23Z")
I’ll need to mention you and this guide/list when I do the weekly event video tomorrow. Great work! ---
**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 27, 2016, 8:06am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/15 "2016-04-27T08:06:30Z")
in the filter can i make it filter out specific kingdoms such as groshnok and broken spire at the same time? ---
**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 27, 2016, 8:08am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/16 "2016-04-27T08:08:46Z")
The filter is a “filter-in,” not a “filter-out.” Whatever you put in there, it’ll attempt to match text within the entire troop description (except for probably tooltips). If it can find it, the troop will be shown, and if not, it won’t. There’s no provision currently for complex filter queries. ---
**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 27, 2016, 8:13am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/17 "2016-04-27T08:13:18Z")
Is there a way to make it filter out by clicking on the box itself or check mark. I know i am the only one asking but i really want to win the draft using your troop list. ---
**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 27, 2016, 8:14am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/18 "2016-04-27T08:14:41Z")
I’m not entirely sure what you’re asking, but the answer is “probably not.” What is it about the current troop list that would prevent you from manually filtering to a kingdom? Just sort by kingdom and scroll to where you want to be – or am I missing something? ---
**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 27, 2016, 8:22am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/19 "2016-04-27T08:22:43Z")
I need to be able to omit certain kingdoms, as well as be able to stack the omission on top of searching for particular skills and traits. My draft team is specific and i already planned out how to argue for its greatness but if even one troop is missing i would have to change my strategy completely. I have too many teams so the moment i choose my first troop i am locked into a specific line-up and then i have to hope no one chooses any of my desired troops. So having a tool as great as yours which is better than the current tool i was using will help greatly but i want to be 100% i can swap out troops at a moments notice. It is common knowledge i am in the draft now so i might as well not hide my intentions any further. I am the villain of the draft or at least i feel that way. Be my accomplice please? ---
**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 27, 2016, 8:23am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/20 "2016-04-27T08:23:47Z")
Taking this offline. [Next page](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037.md?page=2)