# My Collection on Gems of War Database - Auto Updates!

**URL:** <https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799>\
**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:** 11

<div class="post-metadata">

**Author:** ![MakoSipper](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/makosipper/32/1933_2.png) [@MakoSipper](https://community.gemsofwar.com/u/MakoSipper)\
**Post date:** [February 4, 2017, 7:04pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/203 "2017-02-04T19:04:46Z")

</div>

I wish there were a way of donating to your time and effort spent, even if it were somewhat a secret option that wouldn’t make you feel like you were monetizing ashtender 😉

---

<div class="post-metadata">

**Author:** ![HKdirewolf](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/hkdirewolf/32/21614_2.png) [@HKdirewolf](https://community.gemsofwar.com/u/HKdirewolf)\
**Post date:** [February 4, 2017, 7:06pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/204 "2017-02-04T19:06:57Z")

</div>

I’m donating enough by actually using the site. That’s all she’s going to get from me!

Now that’s a blessing.

And I gotta tell you, the customer service here is not the best. 2 star yelp review.

---

<div class="post-metadata">

**Author:** ![SkittishSloth](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/skittishsloth/32/15154_2.png) [@SkittishSloth](https://community.gemsofwar.com/u/SkittishSloth)\
**Post date:** [February 4, 2017, 8:27pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/205 "2017-02-04T20:27:00Z")

</div>

![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/5/7/57acae87d23901804351352c6c4331099489882e.jpg)

---

<div class="post-metadata">

**Author:** ![Annaerith](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/annaerith/32/13840_2.png) [@Annaerith](https://community.gemsofwar.com/u/Annaerith)\
**Post date:** [February 7, 2017, 2:07pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/206 "2017-02-07T14:07:09Z")

</div>

doesnt show templar nor paladin, maybe more

did i miss something why they shouldnt show with searching “knight” or “Knight”? (shows 21 results)

> **[Troops - Gems of War Database](https://gowdb.com/troops/?sort=byRarity&filter=Knight)**
>
> A list of all troops in Gems of War and their statistics.

---

<div class="post-metadata">

**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:** [February 7, 2017, 3:16pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/207 "2017-02-07T15:16:14Z")

</div>

Hyphen seems to be giving it trouble (it shouldn’t, that’s a bug). You can work around it for now by searching specifically for a type:

> **[Troops - Gems of War Database](https://gowdb.com/troops/?sort=byRarity&filter=Type%3Aknight)**
>
> A list of all troops in Gems of War and their statistics.

---

<div class="post-metadata">

**Author:** ![XLS78](https://avatars.discourse-cdn.com/v4/letter/x/b2d939/32.png) [@XLS78](https://community.gemsofwar.com/u/XLS78)\
**Post date:** [February 10, 2017, 1:16pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/208 "2017-02-10T13:16:42Z")

</div>

Not sure if this is possible, but could the site pull in (and export) guild stats by member for your current guild as well? This would likely simplify some guild master work significantly. Thanks for considering!

---

<div class="post-metadata">

**Author:** ![Annaerith](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/annaerith/32/13840_2.png) [@Annaerith](https://community.gemsofwar.com/u/Annaerith)\
**Post date:** [February 10, 2017, 1:46pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/209 "2017-02-10T13:46:57Z")

</div>

> [@Lyya](#):
>
> Your account is not used in the process of making the necessary API calls. It’s basically like looking up someone’s info in-game (when you click someone in battle history, or on the top 100 list).

i have no idea how to check guild donations/trophies/seals information if the site sticks to this method, there is probably no way unless some other method to gain data is developed

for a moment i was thinking to use a guildless account to receive a guild invitation to use it to look up a certain guild but even that will give access to only a guild summary similiar to guild ranking list, not to the roster

regardless to the method used to get information from roster it would have to use one of guild members account to do the “api calls” - which is not safe - thats my understanding of the problem

---

<div class="post-metadata">

**Author:** ![MakoSipper](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/makosipper/32/1933_2.png) [@MakoSipper](https://community.gemsofwar.com/u/MakoSipper)\
**Post date:** [February 12, 2017, 5:01am UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/210 "2017-02-12T05:01:25Z")

</div>

Hi! Would it be possible to freeze the top row, with the column names, so it’s always visible as you scroll down? Currently, this is true only for the bar with Tools button and “%d found.”.

Thanks in advance!

---

<div class="post-metadata">

**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:** [February 12, 2017, 5:45am UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/211 "2017-02-12T05:45:11Z")

</div>

I will give it a try. The trouble is that CSS “sticky” is defined in such a way as to be useless for table elements like “thead.” From [position - CSS: Cascading Style Sheets | MDN](https://developer.mozilla.org/en-US/docs/Web/CSS/position#Sticky_positioning:)

> sticky The box position is calculated according to the normal flow (this is called the position in normal flow). Then the box is offset relative to its flow root and containing block and in all cases, including table elements, does not affect the position of any following boxes. When a box B is stickily positioned, the position of the following box is calculated as though B were not offset. The effect of ‘position: sticky’ on table elements is the same as for ‘position: relative’.

Chrome does seem to support sticky table elements, but no other browser does, and I’m not sure I can account for both in just CSS. If I can’t come up with anything then the ability to stick the header may need to wait.

---

<div class="post-metadata">

**Author:** ![MakoSipper](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/makosipper/32/1933_2.png) [@MakoSipper](https://community.gemsofwar.com/u/MakoSipper)\
**Post date:** [February 12, 2017, 2:59pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/212 "2017-02-12T14:59:59Z")

</div>

Alright, thanks a lot for looking into it! If that’s too much work, don’t bother, as the collection page is fine as it is, and you can easily deduce what each column means – this is just for a little bit more of “comfort”. 😉

---

<div class="post-metadata">

**Author:** ![Whiskeyjack](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/whiskeyjack/32/65850_2.png) [@Whiskeyjack](https://community.gemsofwar.com/u/Whiskeyjack)\
**Post date:** [February 20, 2017, 10:29am UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/213 "2017-02-20T10:29:07Z")

</div>

Hi Lyya, not sure if something changed on your site or whether it’s an issue with chrome on android, but the table is now coming up funny on mobile and I can’t view troop names. It was fine until this weekend. Any ideas? Unfortunately I don’t remember if I updated the chrome app or not.

 ![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/d/2/d2028123e3ccc6f09c7581e98bd68a51a2df78fd.png)

---

<div class="post-metadata">

**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:** [February 20, 2017, 3:23pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/214 "2017-02-20T15:23:49Z")

</div>

Thanks for the report. I’ll take a look.

Nothing has changed on the site; did the phone take an update?

---

<div class="post-metadata">

**Author:** ![Whiskeyjack](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/whiskeyjack/32/65850_2.png) [@Whiskeyjack](https://community.gemsofwar.com/u/Whiskeyjack)\
**Post date:** [February 20, 2017, 3:33pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/215 "2017-02-20T15:33:16Z")

</div>

No update to the firm software, but looking in Google play chrome was recently updated so it could well be that

---

<div class="post-metadata">

**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:** [February 20, 2017, 3:41pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/216 "2017-02-20T15:41:44Z")

</div>

Ah, okay. I think I know what’s up. Will try to have a fix today. I don’t have an Android phone so it’s hard to test.

---

<div class="post-metadata">

**Author:** ![Whiskeyjack](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/whiskeyjack/32/65850_2.png) [@Whiskeyjack](https://community.gemsofwar.com/u/Whiskeyjack)\
**Post date:** [February 20, 2017, 3:50pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/217 "2017-02-20T15:50:40Z")

</div>

Thanks so much for looking into it. it’s definitely a chrome issue - I just tried another browser which uses a different engine and it renders fine.

In chrome, I can bring the checklist up but only by clicking where it **should** be (to the right of where it is. If I click where it actually is, nothing happens.

Anyway no rush for me personally as I can just use an alternative browser 🙂

---

<div class="post-metadata">

**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:** [February 20, 2017, 4:49pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/218 "2017-02-20T16:49:29Z")

</div>

Try reloading the page in Chrome and let me know if it works.

For those interested, I’ve long since supported a sticky first column for my tables on iOS devices. Recently, sticky positioning has been added to Webkit-based browsers, but their support for it differs from iOS’s, and it’s led to a number of site bugs for me. I’ve attempted to disable the sticky column for Webkit browsers (sorry Chrome users!) until the issue is resolved. If this doesn’t work, I may have to disable the sticky column for _all_ browsers, but as an iPhone user that’d make me sad.

---

<div class="post-metadata">

**Author:** ![MakoSipper](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/makosipper/32/1933_2.png) [@MakoSipper](https://community.gemsofwar.com/u/MakoSipper)\
**Post date:** [February 20, 2017, 5:04pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/219 "2017-02-20T17:04:51Z")

</div>

Happy Cake Day! 🍰

---

<div class="post-metadata">

**Author:** ![Whiskeyjack](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/whiskeyjack/32/65850_2.png) [@Whiskeyjack](https://community.gemsofwar.com/u/Whiskeyjack)\
**Post date:** [February 20, 2017, 5:04pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/220 "2017-02-20T17:04:56Z")

</div>

![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/7/5/75fd6097f8dc0ba24eda1c56b2cc76a22efee132.png)  
Hooray, it works! Thanks Lyya, you’re the best! 😁

Weirdly the checklist link is still behaving oddly so I have to touch a blank space to the right of the text. See below screenshots where the white blob shows my touch:

 ![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/f/1/f140f7ab390859444e4a952df10d1070b16037e3.png)

 ![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/9/a/9a74d0012759b806342f00671e7752e7a1039689.png)

---

<div class="post-metadata">

**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:** [February 20, 2017, 5:11pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/221 "2017-02-20T17:11:57Z")

</div>

The fun never stops, does it?

I’ll take a look at that as well, though it might have to wait until later this afternoon.

Thanks for the reports!

---

<div class="post-metadata">

**Author:** ![Whiskeyjack](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/whiskeyjack/32/65850_2.png) [@Whiskeyjack](https://community.gemsofwar.com/u/Whiskeyjack)\
**Post date:** [February 20, 2017, 5:18pm UTC](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799/222 "2017-02-20T17:18:20Z")

</div>

The joys of multiple standards across multiple versions of browsers, devices and operating systems! Glad I haven’t tried to build a website since HTML and JavaScript were all the rage…

[Previous page](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799.md?page=10)

[Next page](https://community.gemsofwar.com/t/my-collection-on-gems-of-war-database-auto-updates/18799.md?page=12)
