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.
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