1 files changed, 60 insertions, 0 deletions
diff --git a/include/reminder.php b/include/reminder.php
new file mode 100644
index 0000000..1e3135c
--- /dev/null
+++ b/include/reminder.php
@@ -0,0 +1,60 @@
+<?php
+/* make sure that we are not called from outside the scripts, 
+ * use a variable defined in config.php to check this
+ */
+if(!isset($HOST))
+  exit;
+
+output_status();
+
+$me = $_REQUEST["me"];
+
+/* test for valid ID */
+$myid = DB_get_userid('hash',$me);
+if(!$myid)
+  {
+    echo "Can't find you in the database, please check the url.<br />\n";
+    echo "perhaps the game has been canceled, check by login in <a href=\"$INDEX\">here</a>.";
+    output_footer();
+    DB_close();
+    exit();
+  }
+
+DB_update_user_timestamp($myid);
+
+/* get some information from the DB */
+$gameid   = DB_get_gameid_by_hash($me);
+$myname   = DB_get_name('hash',$me);
+
+/* check if player hasn't done anything in a while */
+$result = mysql_query("SELECT mod_date,player,status from Game WHERE id='$gameid' " );
+$r = mysql_fetch_array($result,MYSQL_NUM);
+if( (time()-strtotime($r[0]) > 60*60*24*7)  && ($r[2]!='gameover') ) /* = 1 week */
+  {
+    $name = DB_get_name('userid',$r[1]);
+    $To   = DB_get_email('userid',$r[1]);
+    $userhash = DB_get_hash_from_gameid_and_userid($gameid,$r[1]);
+
+    $message = "Hello $name, \n\n".
+      "It's your turn in game ".DB_format_gameid($gameid)." \n".
+      "Actually everyone else is waiting for you for more than a week now ;)\n\n".
+      "Please visit this link now to continue: \n".
+      " ".$HOST.$INDEX."?me=".$userhash."\n\n" ;
+
+    /* make sure we don't send too  many reminders to one person */
+    if(DB_get_reminder($r[1],$gameid)>0)
+      {
+	echo "<p>An email has already been sent out.</p>\n";
+      }
+    else
+      {
+	DB_set_reminder($r[1],$gameid);
+	mymail($To,$EmailName."Reminder: game ".DB_format_gameid($gameid)." it's your turn",$message);
+
+	echo "<p style=\"background-color:red\";>Game ".DB_format_gameid($gameid).
+	  ": an email has been sent out.<br /><br /></p>";
+      }
+  }
+ else
+   echo "<p>You need to wait longer before you can send out a reminder...</p>\n";
+?>
+\ No newline at end of file