From 7098a1b835b6f7aca6c68cab60fe4858ea2abf1e Mon Sep 17 00:00:00 2001 From: Vainsocial root Date: Sun, 12 Mar 2017 10:15:57 +0000 Subject: hotfix API returning xp as float --- queries/player.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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", -- cgit v1.3.1