<?php
-/* Copyright 2006, 2007, 2008, 2009, 2010, 2011, 2012 Arun Persaud <arun@nubati.net>
+/* Copyright 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013 Arun Persaud <arun@nubati.net>
*
* This file is part of e-DoKo.
*
function mymail($uid,$gameid=0,$type,$message)
{
- global $EmailName,$WIKI;
+ global $EmailName,$WIKI,$PREF;
- /* do we send the email right away or save it in the database? */
- $send_now = 1;
-
- /* add standard header and footer */
- $subject = "$EmailName ";
- if($gameid)
- $game = DB_format_gameid($gameid);
- else
- $game = '';
-
- switch($type)
+ /* uid can be either a single uid or an array, convert everything to
+ * an array, so that we can loop over it */
+ if(!is_array($uid))
{
- case GAME_CANCELED:
- $subject.=sprintf(_("Game %s canceled"),$game);
- break;
- case GAME_CANCELED_POVERTY:
- $subject.=sprintf(_("Game %s canceled (poverty not resolved)"),$game);
- break;
- case GAME_CANCELED_TIMEOUT:
- $subject.=sprintf(_("Game %s canceled (timed out)"),$game);
- break;
- case GAME_YOUR_TURN:
- $subject.=sprintf(_("A card has been played in game %s"),$game);
- break;
- case GAME_READY:
- $subject.=sprintf(_("Ready, set, go... (game %s)"),$game);
- break;
- case GAME_POVERTY:
- $subject.=sprintf(_("Poverty (game %s)"),$game);
- break;
- case GAME_DPOVERTY:
- $subject.=sprintf(_("Double poverty (game %s)"),$game);
- break;
- case GAME_OVER:
- $subject.=sprintf(_("Game over (game %s)"),$game);
- break;
- case GAME_RECOVERY:
- $subject.=_("Recovery");
- break;
- case GAME_REMINDER:
- $subject.=sprintf(_("Reminder: game %s it's your turn"),$game);
- break;
- case GAME_NEW:
- $subject.=sprintf(_("You are invited to a game of DoKo (game %s)"),$game);
- break;
- default:
- $subject.=sprintf(_("Problem with email, contact admin (errorcode %d)"),$gameid);
+ $to_uid=$uid;
+ $uid = array();
+ $uid[]=$to_uid;
}
- /* standard goodbye */
- $footer = "\nHave a nice day\n".
- " your E-Doko service department\n\n".
- "-- \n".
- "You can change your mail delivery mode in the preference menu.\n".
- 'web: http://doko.nubati.net '.
- "help, bugs, etc.: $WIKI";
-
- if(is_array($uid))
+ foreach($uid as $user)
{
- /* send email to more than one person */
+ /* do we send the email right away or save it in the database? */
+ $send_now = 1;
- $header = "Hello all\n\n";
-
- foreach($uid as $user)
- {
- $all[] = DB_get_email('userid',$user);
- }
- $To = implode(",",$all);
- }
- else
- {
- /* standard greeting */
- $name = DB_get_name('userid',$uid);
- $header = "Hello $name\n\n";
-
- $To = DB_get_email('userid',$uid);
+ $name = DB_get_name('userid',$user);
+ $To = DB_get_email('userid',$user);
/* check if user wants email right away or if we should save it in
* the database for later delivery
*/
- $PREF = DB_get_PREF($uid);
- if( $PREF['digest'] != 'digest-off' )
- $send_now = 0;
- }
+ $uidPREF = DB_get_PREF($user);
+ if( $uidPREF['digest'] != 'digest-off' )
+ $send_now = 0;
+ /* use local language */
+ set_language($uidPREF['language']);
- if($send_now)
- sendmail($To,$subject,$header.$message.$footer);
- else
- {
- /* store email in database */
- DB_digest_insert_email($To,$message,$type,$gameid);
+ $header = sprintf(_('Hello %s'),$name);
+ $header .= "\n\n";
+
+ /* add standard header and footer */
+ $subject = "$EmailName ";
+ if($gameid)
+ $game = DB_format_gameid($gameid);
+ else
+ $game = '';
+
+ switch($type)
+ {
+ case GAME_CANCELED:
+ $subject.=sprintf(_('Game %s canceled'),$game);
+ break;
+ case GAME_CANCELED_POVERTY:
+ $subject.=sprintf(_('Game %s canceled (poverty not resolved)'),$game);
+ break;
+ case GAME_CANCELED_TIMEOUT:
+ $subject.=sprintf(_('Game %s canceled (timed out)'),$game);
+ break;
+ case GAME_YOUR_TURN:
+ $subject.=sprintf(_('A card has been played in game %s'),$game);
+ break;
+ case GAME_READY:
+ $subject.=sprintf(_('Ready, set, go... (game %s)'),$game);
+ break;
+ case GAME_POVERTY:
+ $subject.=sprintf(_('Poverty (game %s)'),$game);
+ break;
+ case GAME_DPOVERTY:
+ $subject.=sprintf(_('Double poverty (game %s)'),$game);
+ break;
+ case GAME_OVER:
+ $subject.=sprintf(_('Game over (game %s)'),$game);
+ break;
+ case GAME_RECOVERY:
+ $subject.=_('Recovery');
+ break;
+ case GAME_REMINDER:
+ $subject.=sprintf(_("Reminder: game %s it's your turn"),$game);
+ break;
+ case GAME_NEW:
+ $subject.=sprintf(_('You are invited to a game of DoKo (game %s)'),$game);
+ break;
+ default:
+ $subject.=sprintf(_('Problem with email, contact admin (errorcode %d)'),$gameid);
+ }
+
+ /* standard goodbye */
+ $footer = "\n"._('Have a nice day')."\n "._('your E-Doko service department').
+ "\n\n".
+ "-- \n".
+ _('You can change your mail delivery mode in the preference menu.').
+ "\n".
+ _('web').': http://doko.nubati.net '.
+ _('help, bugs, etc.').": $WIKI";
+
+ if($send_now)
+ sendmail($To,$subject,$header.$message.$footer);
+ else
+ {
+ /* store email in database */
+ DB_digest_insert_email($To,$message,$type,$gameid);
+ }
}
+
+ /* reset language to original user*/
+ set_language($PREF['language']);
+
+ return;
}
function sendmail($To,$Subject,$message)
if(isset($EMAIL_REPLY))
$header .= "From: e-DoKo daemon <$EMAIL_REPLY>\r\n";
+ $header .= "Content-Type: text/plain; charset = \"UTF-8\";\r\n";
+ $header .= "Content-Transfer-Encoding: 8bit\r\n";
+ $header .= "\r\n";
+
if($debug)
{
/* display email on screen,
"<a href=\"$1\">$1</a>", $message);
echo "<br />To: $To<br />";
- if($header != "")
- echo $header."<br />";
+ echo $header."<br />";
echo "Subject: $Subject <br />$message<br />\n";
}
else
- if($header != "")
- mail($To,$Subject,$message,$header);
- else
- mail($To,$Subject,$message);
+ mail($To,$Subject,$message,$header);
+
return;
}
" Hand.hash, ".
" User.timezone, ".
" User.email ".
- "FROM Hand ".
- "LEFT JOIN User ON User.id=Hand.user_id ".
- "WHERE Hand.game_id='".$gameid."' ".
- "ORDER BY position ASC");
+ " FROM Hand".
+ " LEFT JOIN User ON User.id=Hand.user_id".
+ " WHERE Hand.game_id=".DB_quote_smart($gameid).
+ " ORDER BY position ASC");
$row0 = DB_fetch_array($result);
$row1 = DB_fetch_array($result);
" Hand.hash, ".
" User.timezone, ".
" User.email ".
- "FROM Hand ".
- "LEFT JOIN User ON User.id=Hand.user_id ".
- "WHERE Hand.game_id='".$gameid."' ".
- "ORDER BY position ASC");
+ " FROM Hand".
+ " LEFT JOIN User ON User.id=Hand.user_id".
+ " WHERE Hand.game_id=".DB_quote_smart($gameid).
+ " ORDER BY position ASC");
$row0 = DB_fetch_array($result);
$row1 = DB_fetch_array($result);
$stop = substr($vacation[1],0,10);
$comment = $vacation[2];
- $title = "begin: $start end: $stop $comment";
- echo " <span class=\"vacation\" title=\"$title\">$gravatar (on vacation until $stop)</span> \n";
+ $title = _("begin:")." $start "._("end:")." $stop $comment";
+ echo " <span class=\"vacation\" title=\"$title\">$gravatar "._("(on vacation until $stop)")."</span> \n";
}
else
echo " $gravatar \n";
switch($wins)
{
case 0:
- echo "#tricks 0"; break;
+ echo _('#tricks 0'); break;
case 1:
- echo "#tricks 1"; break;
+ echo _('#tricks 1'); break;
case 2:
case 3:
case 4:
- echo "#tricks few"; break;
+ echo _('#tricks few'); break;
default:
- echo "#tricks many"; break;
+ echo _('#tricks many'); break;
}
echo "</span>\n";
echo " </div>\n";
if($skiphash)
$result = DB_query("SELECT Hand.hash,Hand.game_id,Game.player from Hand".
" LEFT JOIN Game On Hand.game_id=Game.id".
- " WHERE Hand.user_id='$id'".
- " AND Hand.hash!='$skiphash'".
+ " WHERE Hand.user_id=".DB_quote_smart($id).
+ " AND Hand.hash!=".DB_quote_smart($skiphash).
" AND ( Game.player='$id' OR ISNULL(Game.player) )".
" AND ( Game.status='pre' OR Game.status='play' )".
" ORDER BY Game.session" );
else
$result = DB_query("SELECT Hand.hash,Hand.game_id,Game.player from Hand".
" LEFT JOIN Game On Hand.game_id=Game.id".
- " WHERE Hand.user_id='$id'".
- " AND ( Game.player='$id' OR ISNULL(Game.player) )".
+ " WHERE Hand.user_id=".DB_quote_smart($id).
+ " AND ( Game.player=".DB_quote_smart($id)." OR ISNULL(Game.player) )".
" AND ( Game.status='pre' OR Game.status='play' )".
" ORDER BY Game.session" );
/* get player id from the first game */
$result = DB_query("SELECT user_id from Hand".
- " WHERE Hand.game_id=".$gameids[0][0]);
+ " WHERE Hand.game_id=".DB_quote_smart($gameids[0][0]));
while( $r = DB_fetch_array($result))
$player[$r[0]] = 0;
/* truncate table if we have too many games */
$max = sizeof($score);
- if($max>6) $output.=" (table truncated to last 6 games)\n";
+ if($max>6) $output.=" "._("(table truncated to last 6 games)")."\n";
/* output header */
foreach($score[0]['players'] as $id=>$points)
{
/* get start date */
$result = DB_query_array("SELECT value FROM User_Prefs".
- " WHERE user_id='$userid' AND pref_key='vacation start'" );
+ " WHERE user_id=".DB_quote_smart($userid)." AND pref_key='vacation start'" );
if($result)
$start = $result[0];
else
/* get end date */
$result = DB_query_array("SELECT value FROM User_Prefs".
- " WHERE user_id='$userid' AND pref_key='vacation stop'" );
+ " WHERE user_id=".DB_quote_smart($userid)." AND pref_key='vacation stop'" );
if($result)
$stop = $result[0];
else
/* get comment */
$result = DB_query_array("SELECT value FROM User_Prefs".
- " WHERE user_id='$userid' AND pref_key='vacation comment'" );
+ " WHERE user_id=".DB_quote_smart($userid)." AND pref_key='vacation comment'" );
if($result)
$comment = $result[0];
else
return $token;
}
+function verify_password($email, $password)
+{
+ /* verify password, if old password has length 32 assume it's an old md5, else use new password scheme */
+ /* return 0 if verified, else return error code
+ * 1 can't find email
+ * 2 can't calculate correct hash
+ * 3 misc error
+ */
+
+ /* check user email by getting his id */
+ $userid = DB_get_userid('email',$email);
+ if(!$userid)
+ return 1;
+
+ /* test for temporary passwords, only valid for one date (tested in the DB) */
+ $tmppasswd = md5($password);
+ if(DB_check_recovery_passwords($tmppasswd,$email))
+ return 0;
+
+ /* get saved password */
+ $existingpassword = DB_get_passwd_by_userid($userid);
+
+ if(strlen($existingpassword)==32) /* old password type */
+ {
+ if ($existingpassword == md5($password))
+ {
+ /* update password to new crypt version */
+ // create a password hash using the crypt function, need php 5.3 for this
+ // create and random salt
+ $salt = substr(str_replace('+', '.', base64_encode(sha1(microtime(true), true))), 0, 22);
+ // hash incoming password using 12 rounds of blowfish
+ $hash = crypt($password, '$2y$12$' . $salt);
+ if(strlen($hash)>13)
+ DB_query("UPDATE User SET password='$hash' where id='$userid'");
+ else
+ return 2;
+
+ return 0;
+ }
+ }
+ else
+ {
+ if ($existingpassword == crypt($password, $existingpassword))
+ return 0;
+ };
+
+ return 3;
+}
+
+/* language functions */
+function detectlanguage()
+{
+ /* read out browser's prefered language, taken from php-manual*/
+ $langcode = explode(";", $_SERVER['HTTP_ACCEPT_LANGUAGE']);
+ $langcode = explode(",", $langcode['0']);
+ return $langcode['0'];
+}
+
+function set_language($l,$type='lang')
+{
+ if($type=='uid')
+ {
+ $userPREF = DB_get_PREF($l);
+ $l = $userPREF['language'];
+ };
+
+ switch($l)
+ {
+ case 'de':
+ putenv("LC_ALL=de_DE");
+ setlocale(LC_ALL, "de_DE");
+ break;
+ default:
+ putenv("LC_ALL=en_US");
+ setlocale(LC_ALL, "en_US");
+ break;
+ }
+
+ // Specify location of translation tables
+ bindtextdomain("edoko", "./locale");
+ bind_textdomain_codeset("edoko", 'UTF-8');
+ // Choose domain
+ textdomain("edoko");
+
+ return;
+}
+
?>