From c0e030bb5068085ef52cc8bd0c91f025fb78045e Mon Sep 17 00:00:00 2001
From: Arun <arun@etaner.(none)>
Date: Mon, 8 Oct 2007 16:01:26 +0200
Subject: NEW FEATURE: send out reminder email

if a player hasn't moved for a week a reminder email can be send out.
only one per day is possible, tracking in the db
---
 db.php | 24 ++++++++++++++++++++++++
 1 file changed, 24 insertions(+)

(limited to 'db.php')

diff --git a/db.php b/db.php
index a6b9c3b..646f004 100644
--- a/db.php
+++ b/db.php
@@ -916,4 +916,28 @@ function DB_format_gameid($gameid)
   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
-- 
cgit v1.2.3-18-g5258