From 09515348107d9aab7823a12d31b082a2ebb75555 Mon Sep 17 00:00:00 2001
From: Arun Persaud <arun@nubati.net>
Date: Sat, 26 Apr 2008 11:52:49 -0700
Subject: CLEANUP: make index.php very short and move everything in separate
 files

created an include dir and almost everything that was in index.php is now in separate
files and gets only included in index.php... makes index.php look a lot nicer ;)

Signed-off-by: Arun Persaud <arun@nubati.net>
---
 include/reminder.php | 60 ++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 60 insertions(+)
 create mode 100644 include/reminder.php

(limited to 'include/reminder.php')

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
-- 
cgit v1.2.3-18-g5258