From 7098a1b835b6f7aca6c68cab60fe4858ea2abf1e Mon Sep 17 00:00:00 2001
From: Vainsocial root <root@vainsocial>
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(-)

(limited to 'queries/player.sql')

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

