diff options
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 |