[chronojump-server] Tasks completed are not being shown when retrieving players with tasks query

[Marcos Venteo Garcia <mventeo src gnome org>]

commit 35ffda4aa8456a828a4188886c05872502c2dc06
Author: Marcos Venteo <mventeo gmail com>
Date:   Sun May 28 18:38:39 2017 +0200

    Tasks completed are not being shown when retrieving players with tasks query

 chronojump-flask/chronojump_server.py |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)
---
diff --git a/chronojump-flask/chronojump_server.py b/chronojump-flask/chronojump_server.py
index 72e8ca5..aca01fc 100644
--- a/chronojump-flask/chronojump_server.py
+++ b/chronojump-flask/chronojump_server.py
@@ -182,7 +182,7 @@ def get_all_players():
     """Get all the players, with the tasks associated with them."""
     sql = "select person.id as person_id, person.imageName, person.name, person.weight,"
     sql += "person.height,person.RFID, task.id as task_id, task.comment "
-    sql += "from person left join task on task.personId=person.id and task.dt >= curdate()"
+    sql += "from person left join task on task.personId=person.id and task.done = 0"
     cursor = mysql.connect().cursor()
 
     cursor.execute(sql)