summaryrefslogtreecommitdiffstats
path: root/include/reminder.php
diff options
context:
space:
mode:
authorArun Persaud <arun@nubati.net>2008-04-26 11:52:49 -0700
committerArun Persaud <arun@nubati.net>2008-04-26 11:52:49 -0700
commit09515348107d9aab7823a12d31b082a2ebb75555 (patch)
tree2e6c01eb6fdc07390c73cb46142c5efda39f567d /include/reminder.php
parent0c5b3eeca3006f61dd326a86e8989c52694d581b (diff)
downloade-DoKo-09515348107d9aab7823a12d31b082a2ebb75555.tar.gz
e-DoKo-09515348107d9aab7823a12d31b082a2ebb75555.tar.bz2
e-DoKo-09515348107d9aab7823a12d31b082a2ebb75555.zip
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>
Diffstat (limited to 'include/reminder.php')
-rw-r--r--include/reminder.php60
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