# 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:** 3
**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:** [May 5, 2016, 6:12am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/41 "2016-05-05T06:12:26Z")
Works as intended. ---
**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:** [May 6, 2016, 1:37am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/42 "2016-05-06T01:37:47Z")
Hey, @Lyya, hope you don’t mind but I linked your site in the Steam forums. If you need to change url again at anytime in the future, let me know and I’ll update the links. I greatly appreciate your comprehensive list and felt it’d help to inform others that don’t frequent the forums. Thanks so much for your effort and dedication! 😁 ---
**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:** [May 7, 2016, 8:21am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/43 "2016-05-07T08:21:17Z")
Added a weapons list, which is very similar to the troops list. [http://ashtender.com/gems/weapons](http://ashtender.com/gems/weapons) 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. > **[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://ashtender.com/gems/de-DE/weapons/stulpenhandschuhe-des-wildhueters](http://ashtender.com/gems/de-DE/weapons/stulpenhandschuhe-des-wildhueters) (whew) (I haven’t built the tabular view yet, that’s still coming.) As always, let me know if there’s anything missing from the data that might make your lives easier. Lyya Edit: Fixed the crappy low-res art, but aspect ratio is still wrong for the portraits. Will fix later. ---
**Author:** ![Jainus](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/jainus/32/34949_2.png) [@Jainus](https://community.gemsofwar.com/u/Jainus)\ **Post date:** [May 7, 2016, 12:04pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/44 "2016-05-07T12:04:50Z")
Nice… The hero class mythic weapons are shown as legendary and coming from events… presume should be shown as mythic and coming from 250 wins in class ? ---
**Author:** ![Ozball](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/ozball/32/36110_2.png) [@Ozball](https://community.gemsofwar.com/u/Ozball)\ **Post date:** [May 7, 2016, 12:10pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/45 "2016-05-07T12:10:53Z")
They are actually legendary and not mythic. However, you’re right, they’re not technically from Bundles or Special Events. (unless you count 250 wins with a class as a Special Event) It’s also interesting to note that they do not appear in the in-game weapons list when you hit Show All if you don’t already have them. EDIT: Actually even if you DO have them they will disappear from the list while Show All is Selected… And Show All is where it would normally list where you get the weapon from, so the only way to view it currently if you don’t have it is through the Hero screen and viewing the class, which won’t work if you don’t have it unlocked… ![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/2X/7/77e2d447761a9f37f5161ad896efc475a0a03f91.jpg) ![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/2X/0/00798d2d04b10c5a72193cf6ab30b5b2401199fc.jpg) (And yes @Lyya That is the Valkyrie team you suggested in the Valkyrie thread 😉 it’s working well, thanks for the suggestion!) ---
**Author:** ![Jainus](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/jainus/32/34949_2.png) [@Jainus](https://community.gemsofwar.com/u/Jainus)\ **Post date:** [May 7, 2016, 4:31pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/46 "2016-05-07T16:31:46Z")
Hmmm… I’m sure back when hero classes were launched, these were described in the preview video as mythic weapons… ---
**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:** [May 7, 2016, 4:50pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/47 "2016-05-07T16:50:24Z")
There’s nothing in the data files to support them being of mythic rarity, though as rarity for weapons is entirely subjective (they cannot be disenchanted or ascended, and they don’t have drop rates), there’s not much of a difference either way. If I can figure out how to differentiate class weapons from others, I can make them mythic in appearance. Noticed a bug wherein I’m not adjusting magic scaling properly for Crescendo and Burning Scythe, will address today. ---
**Author:** ![Jainus](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/jainus/32/34949_2.png) [@Jainus](https://community.gemsofwar.com/u/Jainus)\ **Post date:** [May 7, 2016, 6:19pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/48 "2016-05-07T18:19:01Z")
Note that those weapons do have different colour backgrounds - mythic turquoise, just as legendary is orange, epic is purple and so on… ---
**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:** [May 7, 2016, 6:21pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/49 "2016-05-07T18:21:19Z")
That’s true, but if you look at the border art in the Hero menu, they’re classified as Legendary despite that color. Might be an oversight on the dev team’s part, though likely not a high-priority one. ---
**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:** [May 7, 2016, 6:55pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/50 "2016-05-07T18:55:27Z")
Okay, I’ve updated the logic for spell calculations to appropriately account for magic scale factors. This fixes the description for Poison Master as well as Crescendo and Burning Scythe. I’ve also fixed the description for hero weapons, and made the requirement descriptions filterable. To see all hero weapons, use this filter: [http://ashtender.com/gems/weapons?filter=class+weapon+reward](http://ashtender.com/gems/weapons?filter=class+weapon+reward) The only weapons in there that seem out of place are Broken Hilt ( [http://ashtender.com/gems/weapons/1112](http://ashtender.com/gems/weapons/1112) ) and Shattered Blade ( [http://ashtender.com/gems/weapons/1111](http://ashtender.com/gems/weapons/1111) ). I don’t think that these weapons are in game, so it’s likely just placeholder data that was updated incorrectly. Unfortunately, there doesn’t appear to be a good way to filter them out of my query (unlike troops) so I either need to blacklist these IDs or just leave them. ---
**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:** [May 7, 2016, 7:01pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/51 "2016-05-07T19:01:39Z")
Oh, weapons based on hero armor are finally coming. 🙂 ---
**Author:** ![Cell](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/cell/32/5524_2.png) [@Cell](https://community.gemsofwar.com/u/Cell)\ **Post date:** [May 8, 2016, 1:11am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/52 "2016-05-08T01:11:16Z")
Very well done, you put in a lot of hard work, hats off to you ---
**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:** [May 8, 2016, 5:16am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/53 "2016-05-08T05:16:13Z")
I figured out how to include only implemented hero class weapons, so the other false positives (and unreleased content) will no longer show in the list. [http://ashtender.com/gems/weapons?filter=class+weapon+reward](http://ashtender.com/gems/weapons?filter=class+weapon+reward) now shows only the rewards for the 8 released classes. ---
**Author:** ![Ozball](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/ozball/32/36110_2.png) [@Ozball](https://community.gemsofwar.com/u/Ozball)\ **Post date:** [May 8, 2016, 7:53am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/54 "2016-05-08T07:53:19Z")
Currently summon descriptions don’t list what level the troop comes in at, or if it’s based on Magic it doesn’t say that either. They just say “Summons a level Thrall/Spider Swarm/Orc/etc” Troops Affected: Dark Master Dokkalfar Gar’Nok Giant Spider Goblin King Summoner Weapons Affected: Daemonomicon Nysha’s Skull ---
**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:** [May 8, 2016, 7:54am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/55 "2016-05-08T07:54:12Z")
Oof. Thanks for the info, I’ll correct it tomorrow. ---
**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:** [May 8, 2016, 8:17am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/56 "2016-05-08T08:17:59Z")
And fixed. Let me know if you find other inaccuracies please, I don’t really have regression tests or anything here so it’s basically just whack-a-feature! ---
**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:** [May 9, 2016, 5:16am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/57 "2016-05-09T05:16:40Z")
Added the Hero classes to the database. They can be found here: > **[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. Added hero perks with mouseover tips, as well as a blurb indicating which color mastery they get when leveling. Note that all level rewards for classes are assumed to be in addition to whatever base stats your Hero has. ---
**Author:** ![Soulless\_assassin](https://avatars.discourse-cdn.com/v4/letter/s/e9bcb4/32.png) [@Soulless\_assassin](https://community.gemsofwar.com/u/Soulless_assassin)\ **Post date:** [May 9, 2016, 6:25am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/59 "2016-05-09T06:25:45Z")
This is awesome! Thanks! ---
**Author:** ![yonizaf](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/yonizaf/32/1435_2.png) [@yonizaf](https://community.gemsofwar.com/u/yonizaf)\ **Post date:** [May 10, 2016, 8:30am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/60 "2016-05-10T08:30:47Z")
The troop table is great, very helpful. Although, I would like to have the option to sort by specific stats (such as attack or life). Are there any plans of adding such? ---
**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:** [May 10, 2016, 11:03am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/61 "2016-05-10T11:03:32Z")
Or for specific trait stones if possible. Though i could search for specific troop colors. [Previous page](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037.md?page=2) [Next page](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037.md?page=4)