X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=e-DoKo.git;a=blobdiff_plain;f=include%2Freminder.php;h=61bd37ba1322d9104213353ae23c0080a79e59e8;hp=1e3135c66e0c153e3ab7f6664a67d7a0f8be23a6;hb=4cbc3848a891ac9addf10264d24a9f4273c5e355;hpb=09515348107d9aab7823a12d31b082a2ebb75555;ds=sidebyside diff --git a/include/reminder.php b/include/reminder.php index 1e3135c..61bd37b 100644 --- a/include/reminder.php +++ b/include/reminder.php @@ -5,7 +5,11 @@ if(!isset($HOST)) exit; -output_status(); +if(!myisset("me")) + { + echo "Hmm, you really shouldn't mess with the urls.
\n"; + return; + } $me = $_REQUEST["me"]; @@ -15,9 +19,7 @@ if(!$myid) { echo "Can't find you in the database, please check the url.
\n"; echo "perhaps the game has been canceled, check by login in here."; - output_footer(); - DB_close(); - exit(); + return; } DB_update_user_timestamp($myid); @@ -27,19 +29,17 @@ $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); +$r = DB_query_array("SELECT mod_date,player,status from Game WHERE id='$gameid' " ); 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" ; + " ".$HOST.$INDEX."?action=game&me=".$userhash."\n\n" ; /* make sure we don't send too many reminders to one person */ if(DB_get_reminder($r[1],$gameid)>0) @@ -49,12 +49,13 @@ if( (time()-strtotime($r[0]) > 60*60*24*7) && ($r[2]!='gameover') ) /* = 1 week else { DB_set_reminder($r[1],$gameid); - mymail($To,$EmailName."Reminder: game ".DB_format_gameid($gameid)." it's your turn",$message); + $subject ='Reminder: game '.DB_format_gameid($gameid)." it's your turn"; + mymail($r[1],$subject,$message); echo "

Game ".DB_format_gameid($gameid). ": an email has been sent out.

"; } } else - echo "

You need to wait longer before you can send out a reminder...

\n"; + echo '

You need to wait longer before you can send out a reminder...

\n'; ?> \ No newline at end of file