diff options
author | Arun Persaud <arun@nubati.net> | 2008-04-26 11:52:49 -0700 |
---|---|---|
committer | Arun Persaud <arun@nubati.net> | 2008-04-26 11:52:49 -0700 |
commit | 09515348107d9aab7823a12d31b082a2ebb75555 (patch) | |
tree | 2e6c01eb6fdc07390c73cb46142c5efda39f567d /include/reminder.php | |
parent | 0c5b3eeca3006f61dd326a86e8989c52694d581b (diff) | |
download | e-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.php | 60 |
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 |