# Gems of War Database - updated troops list and much more!
**URL:** https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037
**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:** 6
### Author:  [@Lyya](https://community.gemsofwar.com/u/Lyya)
#### Post date: [May 15, 2016, 2:30am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/102 "2016-05-15T02:30:44Z")
I would like to make the feature more accessible for sure. I’m a bit worried about how to expose things like rearranging without drag and drop, but I’ll come up with something.
---
### Author:  [@Lyya](https://community.gemsofwar.com/u/Lyya)
#### Post date: [May 15, 2016, 4:48am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/103 "2016-05-15T04:48:35Z")
Calculated the team bonuses to the stats shown for each troop in the team page. Added the green buff indicator for buffed stats. Unfortunately, I don’t believe the kingdom or type bonus data is in the external data file, which means it’s likely these are baked into the client binary (for whatever reason; they have a perfectly good “Kingdom” entry they could have tied the bonuses to). This means that I had to enter the team bonuses by hand, and may have made a mistake. It also means that I’ll need to hand-edit that file if the kingdom bonuses ever change. Ah well.
[http://ashtender.com/gems/teams/goblin,hobgoblin,boar-rider,goblin-king,c](http://ashtender.com/gems/teams/goblin,hobgoblin,boar-rider,goblin-king,c)
---
### Author:  [@Ozball](https://community.gemsofwar.com/u/Ozball)
#### Post date: [May 15, 2016, 4:54am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/104 "2016-05-15T04:54:41Z")
I’m not sure how you get your text from the game files, but the file Common.xml in Gems of War/res/Text/en\_US/ has all the bonuses listed starting from line 1307
---
### Author:  [@Lyya](https://community.gemsofwar.com/u/Lyya)
#### Post date: [May 15, 2016, 4:56am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/105 "2016-05-15T04:56:20Z")
Yes, the text is there, but the actual values as usable by code (something like an array of buff structs) is not present anywhere. Parsing the text in code is error-prone and slow, which leaves me with no choice but to translate the text to a table of my own.
---
### Author:  [@Ozball](https://community.gemsofwar.com/u/Ozball)
#### Post date: [May 15, 2016, 4:58am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/106 "2016-05-15T04:58:26Z")
Fair enough. Just out of curiosity were do you get most of your information from? The json files? or somewhere else?
---
### Author:  [@Lyya](https://community.gemsofwar.com/u/Lyya)
#### Post date: [May 15, 2016, 4:59am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/107 "2016-05-15T04:59:23Z")
Everything comes from world.json except the text (which comes from common.xml and world.xml) and the images.
---
### Author:  [@Lyya](https://community.gemsofwar.com/u/Lyya)
#### Post date: [May 15, 2016, 7:10am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/108 "2016-05-15T07:10:40Z")
The Database now supports team building without drag/drop:
- Added a link that appears over the card art when you hover over it, which when clicked will add the troop to the first empty team builder slot.
- Added a “+” button for each suggestion which will add it to the first empty slot.
- Added up and down arrows to the team builder slots to enable mouse clicks/touches to move troops up and down the list.
Note that while this makes the team builder technically usable on mobile, it’s not an awesome experience, due to how those devices scroll. I don’t think I’m going to focus too much on making this aspect of the site particularly optimized toward mobile.
---
### Author:  [@TaliaParks](https://community.gemsofwar.com/u/TaliaParks)
#### Post date: [May 15, 2016, 1:25pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/109 "2016-05-15T13:25:39Z")
I wouldn’t worry about it too much either @Lyya, most site developers rather just create a separate mobile version than to try and adapt one version to work on both computer and mobile.
The fact you are trying to please everyone is enough for me 🙂
---
### Author:  [@Machiknight](https://community.gemsofwar.com/u/Machiknight)
#### Post date: [May 15, 2016, 1:33pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/110 "2016-05-15T13:33:59Z")
Do you ever sleep?!
---
### Author:  [@Ozball](https://community.gemsofwar.com/u/Ozball)
#### Post date: [May 16, 2016, 6:12am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/111 "2016-05-16T06:12:33Z")
Currently having trouble accessing the site. (on both laptop and phone, but they’re on the same internet connection at the moment) Just sitting at “Waiting for [ashtender.com](http://ashtender.com)”. I’ll check in a bit to see if it’s just me (the rest of my net is working fine), but figured I’d let you know incase it’s a wider issue @Lyya
---
### Author:  [@Lyya](https://community.gemsofwar.com/u/Lyya)
#### Post date: [May 16, 2016, 6:14am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/112 "2016-05-16T06:14:09Z")
It’s a wider issue. I’ve already contacted my host, and they’re working to bring the site back online. Thanks for the notice though!
---
### Author:  [@Lyya](https://community.gemsofwar.com/u/Lyya)
#### Post date: [May 16, 2016, 6:19am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/113 "2016-05-16T06:19:08Z")
Looks to be back online now.
---
### Author:  [@Lyya](https://community.gemsofwar.com/u/Lyya)
#### Post date: [May 17, 2016, 1:05am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/114 "2016-05-17T01:05:17Z")
Back down again. Hosting company is aware and working on a fix.
---
### Author:  [@TaliaParks](https://community.gemsofwar.com/u/TaliaParks)
#### Post date: [May 17, 2016, 1:19am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/115 "2016-05-17T01:19:14Z")
Is the problem rooted with you, or is it them?
---
### Author:  [@Lyya](https://community.gemsofwar.com/u/Lyya)
#### Post date: [May 17, 2016, 1:24am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/116 "2016-05-17T01:24:35Z")
Them. Some sort of DDOS on their server.
If this keeps up, I’m going to have to switch hosts again…sigh.
---
### Author:  [@Zelfore](https://community.gemsofwar.com/u/Zelfore)
#### Post date: [May 17, 2016, 1:26am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/117 "2016-05-17T01:26:19Z")
> [@Lyya](#):
>
> If this keeps up, I’m going to have to switch hosts again…sigh.
If that should happen, I will rewire all links I’ve posted connecting to it! _`*salutes*`_
---
### Author:  [@TaliaParks](https://community.gemsofwar.com/u/TaliaParks)
#### Post date: [May 17, 2016, 1:38am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/118 "2016-05-17T01:38:02Z")
That’ll cover about 1% of the total number of links 😉
---
### Author:  [@Lyya](https://community.gemsofwar.com/u/Lyya)
#### Post date: [May 17, 2016, 3:29am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/119 "2016-05-17T03:29:41Z")
Site’s back up.
[ ](https://www.youtube.com/watch?v=2H5uWRjFsGc)
---
### Author:  [@Lyya](https://community.gemsofwar.com/u/Lyya)
#### Post date: [May 17, 2016, 8:28am UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/120 "2016-05-17T08:28:51Z")
For those keeping score at home, It’s Late O’Clock, and the site’s back offline. I’m going to bed.
---
### Author:  [@Lyya](https://community.gemsofwar.com/u/Lyya)
#### Post date: [May 18, 2016, 7:39pm UTC](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037/121 "2016-05-18T19:39:47Z")
Some improvements I’ve been working on these last few days:
- Added livefyre commenting to individual troop, weapon, and class pages. Not sure it’s useful, but per-troop discussions can take place there if y’all want.
- Improved the cosmetics of the team builder, adding in the “strip” artwork that’s used in the in-game troop lineup (currently for troops only, not weapons).
- Removed the unnecessary qtip pops for links to individual troops; right-click the link now to copy it (like you would anywhere else on the web), left-click to go to the troop page.
[Previous page](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037.md?page=5)
[Next page](https://community.gemsofwar.com/t/gems-of-war-database-updated-troops-list-and-much-more/6037.md?page=7)