# 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:** 20
**Author:** ![Shimrra](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/shimrra/32/87_2.png) [@Shimrra](https://community.gemsofwar.com/u/Shimrra)\ **Post date:** [November 10, 2018, 10:35pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/383 "2018-11-10T22:35:08Z")
New(?) idea: Can the top rows in the database tables be frozen to the top of the screen like one can do in excel? ---
**Author:** ![Neritar](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/neritar/32/39263_2.png) [@Neritar](https://community.gemsofwar.com/u/Neritar)\ **Post date:** [November 11, 2018, 9:28am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/384 "2018-11-11T09:28:36Z")
Hi @Lyya! Thank you very much for your site! He is great and I use him very often. Did you notice that a lot of troops released this year disappear from the site? Probably it is the same issue as [GoW Spoilers](https://www.taransworld.com/Spoilers/) displaying troops that are already in the game ---
**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:** [November 11, 2018, 3:52pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/385 "2018-11-11T15:52:28Z")
I will investigate. Thanks for the heads-up. ---
**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:** [November 11, 2018, 4:27pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/386 "2018-11-11T16:27:54Z")
I see what happened, but it might take me a while to correct this. ---
**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:** [November 11, 2018, 5:10pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/387 "2018-11-11T17:10:16Z")
I _think_ I’ve restored everything. Please let me know if you see anything missing. Sorry for the trouble! Lyya ---
**Author:** ![TheIdleOne](https://avatars.discourse-cdn.com/v4/letter/t/c68b51/32.png) [@TheIdleOne](https://community.gemsofwar.com/u/TheIdleOne)\ **Post date:** [November 12, 2018, 1:48am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/388 "2018-11-12T01:48:24Z")
hi, I don’t see the new Doom of Ice ---
**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:** [November 12, 2018, 8:15am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/389 "2018-11-12T08:15:12Z")
I’ve added the six Dooms, thanks. ---
**Author:** ![Live](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/live/32/40596_2.png) [@Live](https://community.gemsofwar.com/u/Live)\ **Post date:** [November 12, 2018, 10:24am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/390 "2018-11-12T10:24:18Z")
Hmmm, they are ingame - only the blue one is obtainable yet. So My Collection tells me i could raise Dhrak-Zum to 6 but this is not possible until the brown Doom Events starts, i think. ---
**Author:** ![Magius](https://avatars.discourse-cdn.com/v4/letter/m/cdc98d/32.png) [@Magius](https://community.gemsofwar.com/u/Magius)\ **Post date:** [November 12, 2018, 10:37am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/391 "2018-11-12T10:37:52Z")
@Lyya… Would you consider to upgrade your class summary page to include the talent tree as well rather than clicking through to a class detail? At the moment it is showing perks that are no longer applicable I suppose. ---
**Author:** ![madking](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/madking/32/62439_2.png) [@madking](https://community.gemsofwar.com/u/madking)\ **Post date:** [December 7, 2018, 11:56am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/392 "2018-12-07T11:56:54Z")
maybe the Ascensione Leaderboard has some problems? ![image](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/f/4/f46697c69a0e312598502e4678160cd113aa96b5.png) ---
**Author:** ![jzg](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/jzg/32/53451_2.png) [@jzg](https://community.gemsofwar.com/u/jzg)\ **Post date:** [December 7, 2018, 12:04pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/393 "2018-12-07T12:04:00Z")
seams like all leaderboards are wrong atm ---
**Author:** ![TimeKnight](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/timeknight/32/50221_2.png) [@TimeKnight](https://community.gemsofwar.com/u/TimeKnight)\ **Post date:** [December 7, 2018, 12:23pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/394 "2018-12-07T12:23:02Z")
Are you sure? Because this 200K renown seems totally legit. 😛 ![Screenshot_2018-12-07-19-20-40-1](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/5/1/51b0af3a6d6390a40a0b1949fc86f546f808fe69.png) ---
**Author:** ![Neritar](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/neritar/32/39263_2.png) [@Neritar](https://community.gemsofwar.com/u/Neritar)\ **Post date:** [December 7, 2018, 1:12pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/395 "2018-12-07T13:12:37Z")
Every time you refresh that leaderboard your total renown on gowdb increments by your real total renown. My real total renown is 9820, after the first visit to that page it was shown as 19640, after refresh page - 29460 😄 ---
**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:** [December 7, 2018, 3:21pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/396 "2018-12-07T15:21:48Z")
Well, I must have screwed something up yesterday…I’ll see what went wrong and fix it today. ---
**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:** [December 7, 2018, 3:43pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/397 "2018-12-07T15:43:35Z")
I think I’ve got it sorted out. Sorry about that. Please let me know if you still see inaccuracies (especially inflated numbers). Thanks, Lyya ---
**Author:** ![Smash](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/smash/32/5574_2.png) [@Smash](https://community.gemsofwar.com/u/Smash)\ **Post date:** [December 7, 2018, 11:52pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/398 "2018-12-07T23:52:36Z")
You dont have Irongut listed, but have Phoenicia listed instead. ---
**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:** [December 8, 2018, 12:18am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/399 "2018-12-08T00:18:04Z")
Fixed. Sorry about that. ---
**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:** [December 11, 2018, 9:29pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/400 "2018-12-11T21:29:13Z")
Quick poll: should I remove zero-count troops from shared collections (I.e, any collection that isn’t yours and that was linked to you by another user)? I feel it would eliminate a step in the “please help me with my collection” queries, but at the potential cost of not being able to easily see that someone _doesn’t_ have something. Thoughts? _Poll ([view on site](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/400))_ ---
**Author:** ![HugeOgre](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/hugeogre/32/72202_2.png) [@HugeOgre](https://community.gemsofwar.com/u/HugeOgre)\ **Post date:** [December 11, 2018, 9:52pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/401 "2018-12-11T21:52:45Z")
a common use case for our guild is to use GoWDB shared collections for recruiting or moving players to a higher GW bracket. so when we look at the list first thing is to sort the unowned Mythics to see what critical troops might be missing. ---
**Author:** ![TheIdleOne](https://avatars.discourse-cdn.com/v4/letter/t/c68b51/32.png) [@TheIdleOne](https://community.gemsofwar.com/u/TheIdleOne)\ **Post date:** [December 11, 2018, 10:37pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/402 "2018-12-11T22:37:15Z")
> [@Lyya](#): > > Thoughts? A common question I get asked is what mythic should I craft next? Helps a lot not to guess what they’re missing. A filter option to temporarily hide unowned troops would be handy though. [Previous page](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037.md?page=19) [Next page](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037.md?page=21)