diff options
| author | Vainsocial root <root@vainsocial> | 2017-03-12 10:15:57 +0000 |
|---|---|---|
| committer | Vainsocial root <root@vainsocial> | 2017-03-12 10:17:09 +0000 |
| commit | 7098a1b835b6f7aca6c68cab60fe4858ea2abf1e (patch) | |
| tree | febef07256f3972be2a5296aeb3d11fde62d65e6 /queries/player.sql | |
| parent | 42d85b580c9cd1a0b4a8dbd453b67e6e4ccedb1a (diff) | |
| download | shrinker-7098a1b835b6f7aca6c68cab60fe4858ea2abf1e.tar.gz shrinker-7098a1b835b6f7aca6c68cab60fe4858ea2abf1e.zip | |
hotfix API returning xp as float
Diffstat (limited to 'queries/player.sql')
| -rw-r--r-- | queries/player.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/queries/player.sql b/queries/player.sql index eb0d043..209aabb 100644 --- a/queries/player.sql +++ b/queries/player.sql @@ -20,7 +20,7 @@ players.player->'data'->>'id' AS "api_id", shardid AS "shard_id", players.player->'data'->'attributes'->>'name' AS "name", (players.player->'data'->'attributes'->'stats'->>'level')::int AS "level", -(players.player->'data'->'attributes'->'stats'->>'xp')::int AS "xp", +(players.player->'data'->'attributes'->'stats'->>'xp')::float::int AS "xp", (players.player->'data'->'attributes'->'stats'->>'played')::int AS "played", (players.player->'data'->'attributes'->'stats'->>'played_ranked')::int AS "played_ranked", (players.player->'data'->'attributes'->'stats'->>'played')::int - (players.player->'data'->'attributes'->'stats'->>'played_ranked')::int AS "played_casual", |