From 810e9cb1dcdec9048f4a2544393844651531cc75 Mon Sep 17 00:00:00 2001 From: Hugues Hiegel Date: Tue, 11 Nov 2008 00:25:10 +0100 Subject: Don't add empty users --- Badges_v2.php | 9 ++++++--- 1 file changed, 6 insertions(+), 3 deletions(-) diff --git a/Badges_v2.php b/Badges_v2.php index 551b899..f79b2f3 100644 --- a/Badges_v2.php +++ b/Badges_v2.php @@ -278,9 +278,12 @@ function make_db_cache($username){ } } - $QUERY=(sprintf("REPLACE INTO users (statsstart,playcount,lastupdate,username) VALUES ('%s',%s,'%s','%s');", - time(), $data['playcount'], gpc_addslashes($data['statsstart']), gpc_addslashes(strtolower($username)))); - mysql_query($QUERY); + if ($playcount != 0) + { + $QUERY=(sprintf("REPLACE INTO users (statsstart,playcount,lastupdate,username) VALUES ('%s',%s,'%s','%s');", + time(), $data['playcount'], gpc_addslashes($data['statsstart']), gpc_addslashes(strtolower($username)))); + mysql_query($QUERY); + } } } -- cgit v1.2.3