X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=e-DoKo.git;a=blobdiff_plain;f=db.php;h=646f0043a27b66c7facf5cc57d59ce9e2b896fa2;hp=867be1685942db70ce2520630d91a1f5cf6f7c00;hb=c0e030bb5068085ef52cc8bd0c91f025fb78045e;hpb=d8eac0035f97a64371557e7da8b9730fe28d8788

diff --git a/db.php b/db.php
index 867be16..646f004 100644
--- a/db.php
+++ b/db.php
@@ -907,12 +907,37 @@ function DB_format_gameid($gameid)
   $session = DB_get_session_by_gameid($gameid);
   
   /* get number of game */
-  $result = mysql_query("SELECT COUNT(*),create_date FROM Game WHERE session='$session' ".
-			" GROUP by session".
-			" HAVING TIMEDIFF(create_date, (SELECT create_date FROM Game WHERE id='$gameid'))<=0");
+  $result = mysql_query("SELECT COUNT(*),create_date FROM Game".
+			" WHERE session='$session' ".
+			" AND TIMEDIFF(create_date, (SELECT create_date FROM Game WHERE id='$gameid'))<=0 ".
+			" GROUP by session");
   $r = mysql_fetch_array($result,MYSQL_NUM);
   
   return $session.".".$r[0];
 }
 
+function DB_get_reminder($user,$gameid)
+{
+  $queryresult = mysql_query("SELECT COUNT(*) FROM Reminder ".
+			     "  WHERE user_id=$user ".
+			     "  AND game_id=$gameid ".
+			     "  AND DATE_SUB(CURDATE(),INTERVAL 1 DAY) <= create_date".
+			     "  GROUP BY user_id " );
+  
+  $r = mysql_fetch_array($queryresult,MYSQL_NUM);
+  if($r)
+    return $r[0];
+  else
+    return 0;
+}
+
+function DB_set_reminder($user,$gameid)
+{
+  mysql_query("INSERT INTO Reminder ".
+	      "  VALUES(NULL, ".DB_quote_smart($user).", ".DB_quote_smart($gameid).
+              ", NULL) ");
+  return 0;
+}
+
+
 ?>
\ No newline at end of file