# My Collection on Gems of War Database - Auto Updates! **URL:** \ **Category:** Community Content\ **Created:** [January 23, 2017, 7:23am UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799 "2017-01-23T07:23:31Z")\ **Posts on this page:** 20\ **Page:** 5
**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:** [January 23, 2017, 4:19pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/81 "2017-01-23T16:19:40Z")
OK, I just got my collection set up. Painless and seems to work perfectly. Ahh wait, got you a bug. The _Teams_ section down at the bottom isn’t registering hero weapons. For example, the “S&M” team there has Sun and Moon after Mercy, but it doesn’t show. ![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/3/1/3106ff5231b9984c5af4e34bbe16fc7c93a8d16b.png) ---
**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:** [January 23, 2017, 4:24pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/82 "2017-01-23T16:24:25Z")
Yup! Known issue, I’ll fix it today. > [@My Collection on Gems of War Database - Auto Updates!](http://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/38): > > Yep, I see the issue. Weapons aren’t being handled properly there. I’ll fix it tomorrow, thanks for the report! ---
**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:** [January 23, 2017, 4:25pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/83 "2017-01-23T16:25:22Z")
Oops. I would also bemoan the inability to sort by _base_ rarity but I assume that’s an issue carried over from the game itself, seeing as it can’t do that either. ---
**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:** [January 23, 2017, 4:35pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/84 "2017-01-23T16:35:26Z")
Oh, I can do that, it just becomes a question of how many columns to throw in that table! I feel like I’m pushing it with what’s there already… ---
**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:** [January 23, 2017, 4:45pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/85 "2017-01-23T16:45:48Z")
Can’t you make columns optional, with a Choose Column buttons like in the trooptable page? ---
**Author:** ![GameTagwastaken](https://avatars.discourse-cdn.com/v4/letter/g/7ab992/32.png) [@GameTagwastaken](https://community.gemsofwar.com/u/GameTagwastaken)\ **Post date:** [January 23, 2017, 5:02pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/87 "2017-01-23T17:02:23Z")
Solid update but it appears to have broken something on the console side. Rarities for all troops reset to their base values with any refresh. [http://ashtender.com/gems/console/collection](http://ashtender.com/gems/console/collection) Encouragingly, this happens even after updating a rarity, saving, and then f5ing, so it is likely a display issue not a data/table issue. I’m on Chrome. ---
**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:** [January 23, 2017, 5:03pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/88 "2017-01-23T17:03:44Z")
Thanks for the report. I’ll take a look. ---
**Author:** ![Gortus](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/gortus/32/9265_2.png) [@Gortus](https://community.gemsofwar.com/u/Gortus)\ **Post date:** [January 23, 2017, 5:07pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/89 "2017-01-23T17:07:36Z")
Lyya, you are freaking amazing. ---
**Author:** ![efh313](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/efh313/32/34349_2.png) [@efh313](https://community.gemsofwar.com/u/efh313)\ **Post date:** [January 23, 2017, 5:25pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/90 "2017-01-23T17:25:44Z")
@Lyya= THE BEST! (drops the mic) ---
**Author:** ![Haladini](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/haladini/32/3794_2.png) [@Haladini](https://community.gemsofwar.com/u/Haladini)\ **Post date:** [January 23, 2017, 5:36pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/91 "2017-01-23T17:36:29Z")
Even more thanks, Lyya - this tool is getting to be awesome ---
**Author:** ![htismaqe](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/htismaqe/32/23893_2.png) [@htismaqe](https://community.gemsofwar.com/u/htismaqe)\ **Post date:** [January 23, 2017, 5:40pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/92 "2017-01-23T17:40:57Z")
@Lyya This is flipping amazing. Seriously needed this for months since I have so few troops left to upgrade and I want to plan my resources to the individual stone… ---
**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:** [January 23, 2017, 5:44pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/93 "2017-01-23T17:44:56Z")
Okay, the rarity bug should be fixed. Provided you didn’t save over a troop’s row, the value should be restored if you refresh the page. If you did, I’m afraid you’ll need to re-enter the rarity information again. I’m terribly sorry for the inconvenience. ---
**Author:** ![GameTagwastaken](https://avatars.discourse-cdn.com/v4/letter/g/7ab992/32.png) [@GameTagwastaken](https://community.gemsofwar.com/u/GameTagwastaken)\ **Post date:** [January 23, 2017, 5:58pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/94 "2017-01-23T17:58:27Z")
Thanks, Lyya! I can’t speak for anyone else but I figured it was fixable and didn’t reset any values, so you don’t need to worry about me. I also love the gray background for unowned troops; simple but helpful. ---
**Author:** ![Rasper](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/rasper/32/2363_2.png) [@Rasper](https://community.gemsofwar.com/u/Rasper)\ **Post date:** [January 23, 2017, 6:28pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/95 "2017-01-23T18:28:32Z")
![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/1/b/1b9da7e011246a74d72800b0e9b764fefb21d475.png) There are 5 mythics I’m currently missing, as shown. I have “show unobtained” unchecked. But it is adding Abynissa, Gard’s Avatar, and Plague to my needed summary. It correctly doesn’t count Wulfgarok and Pharos-Ra. Interestingly, if I add a filter of =“0” to the level sort, only Wulfgarok and Pharos-Ra are displayed, which leads me to believe that even though it shows the level for Aby, Gard, and Plague as 0 there is something else in their fields (a hidden character perhaps), which is causing the summary to show wrong too. To further this, if you do sort in game by amount and toggle show-all on, Wulf and Phar show at the front while Aby, Gard, and Plague show at the end. ---
**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:** [January 23, 2017, 6:34pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/96 "2017-01-23T18:34:27Z")
Both issues should now be addressed. Weapons will show their names in the team list at the bottom, and there’s a hidden-by-default “Base Rarity” column you can enable via the “Tools” menu. ---
**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:** [January 23, 2017, 6:35pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/97 "2017-01-23T18:35:41Z")
I’ll take a look. ---
**Author:** ![DamageInc](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/damageinc/32/16135_2.png) [@DamageInc](https://community.gemsofwar.com/u/DamageInc)\ **Post date:** [January 23, 2017, 6:44pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/98 "2017-01-23T18:44:09Z")
Well done @Lyya! Truly a great program! ---
**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:** [January 23, 2017, 6:44pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/99 "2017-01-23T18:44:54Z")
Okay, refresh – issue should be resolved. ---
**Author:** ![Rasper](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/rasper/32/2363_2.png) [@Rasper](https://community.gemsofwar.com/u/Rasper)\ **Post date:** [January 23, 2017, 6:47pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/100 "2017-01-23T18:47:02Z")
> [@Lyya](#): > > Okay, refresh – issue should be resolved. Perfect. Out of curiosity, what happened? Was the data for level off? I noticed that =“0” showed Wulf and Pharos, and \>0 showed the other 3, and \>1 showed none, so I figure something was hinky in how their DB reports those 3. ---
**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:** [January 23, 2017, 6:51pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/101 "2017-01-23T18:51:22Z")
It’s because that troop is marked as count=0 but level=1, while others are count=0 and level=0. I now treat either count=0 or level=0 to mean “unowned.” [Previous page](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799.md?page=4) [Next page](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799.md?page=6)