X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=e-DoKo.git;a=blobdiff_plain;f=include%2Ffunctions.php;h=a332347d38213a4c93c6756061d48e8ce6adbf6d;hp=fc46a61e576fc3a06484336e4f86e25e21b177a8;hb=2a529cf743274f63cd15f7f33b58b943338e1049;hpb=34dca92fa9209df27921dcc58b9ea5bfb8f131f0 diff --git a/include/functions.php b/include/functions.php index fc46a61..a332347 100644 --- a/include/functions.php +++ b/include/functions.php @@ -1,5 +1,5 @@ +/* Copyright 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013 Arun Persaud * * This file is part of e-DoKo. * @@ -30,42 +30,45 @@ function config_check() /* check if some variables are set in the config file, else set defaults */ if(!isset($EmailName)) - $EmailName="[DoKo] "; + $EmailName='[DoKo] '; if(isset($EMAIL_REPLY)) { - ini_set("sendmail_from",$EMAIL_REPLY); + ini_set('sendmail_from',$EMAIL_REPLY); } if(!isset($ADMIN_NAME)) { output_header(); - echo "

Setup not completed

"; - echo "You need to set \$ADMIN_NAME in config.php."; + echo '

Setup not completed

'; + echo 'You need to set $ADMIN_NAME in config.php.'; output_footer(); exit(); } if(!isset($ADMIN_EMAIL)) { output_header(); - echo "

Setup not completed

"; - echo "You need to set \$ADMIN_EMAIL in config.php. ". - "If something goes wrong an email will be send to this address."; + echo '

Setup not completed

'; + echo 'You need to set $ADMIN_EMAIL in config.php. '. + 'If something goes wrong an email will be send to this address.'; output_footer(); exit(); } if(!isset($DB_work)) { output_header(); - echo "

Setup not completed

"; - echo "You need to set \$DB_work in config.php. ". - "If this is set to 1, the game will be suspended and one can work safely on the database.". - "The default should be 0 for the game to work."; + echo '

Setup not completed

'; + echo 'You need to set $DB_work in config.php. '. + 'If this is set to anything else than 0, the game will be suspended and one can work safely on the database. '. + 'A message will be displayed that it will probably take about N minutes, with N being the number $DB_work is set to. '. + 'The default should be 0 for the game to work.'; output_footer(); exit(); } if($DB_work) { output_header(); - echo "Working on the database...please check back later."; + echo '
'. + _("Working on some aspect of e-DoKo... This will probably take max. $DB_work minutes. It could be over in a few seconds too though ;)"). + '
'; output_footer(); exit(); } @@ -103,101 +106,106 @@ define("CARDS_GAMEOVER", 5); /* show all cards from everyone (looking at some 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); + $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) @@ -566,6 +574,9 @@ function create_array_of_random_numbers($useridA,$useridB,$useridC,$useridD) if($debug) { + /* fix the hands; makes debugging easier; the following hands have lots of sicknesses, + * to make testing easier + */ $r[ 0]=1; $r[12]=47; $r[24]=13; $r[36]=37; $r[ 1]=2; $r[13]=23; $r[25]=14; $r[37]=38; $r[ 2]=3; $r[14]=27; $r[26]=15; $r[38]=39; @@ -582,7 +593,7 @@ function create_array_of_random_numbers($useridA,$useridB,$useridC,$useridD) else { /* check if we can find a game were non of the player was involved and return - * cards insted + * cards instead */ $userstr = "'".implode("','",array($useridA,$useridB,$useridC,$useridD))."'"; $randomnumbers = DB_get_unused_randomnumbers($userstr); @@ -971,7 +982,7 @@ function can_call($what,$hash) return 0; } -function display_table () +function display_table_begin () { global $gameid, $GT, $debug,$INDEX,$defaulttimezone,$session; global $RULES,$GAME,$gametype; @@ -991,10 +1002,59 @@ function display_table () "WHERE Hand.game_id='".$gameid."' ". "ORDER BY position ASC"); - echo "
\n". - " \"table\"\n"; - while($r = DB_fetch_array($result)) - { + $row0 = DB_fetch_array($result); + $row1 = DB_fetch_array($result); + $row2 = DB_fetch_array($result); + $row3 = DB_fetch_array($result); + + echo "
\n"; + display_single_user($row1); + echo "\n
\n"; + display_single_user($row0,1); /* mark starting player in case re/contra is not set yet */ + echo " \"table\"\n"; + display_single_user($row2); + + return; +} +function display_table_end () +{ + global $gameid, $GT, $debug,$INDEX,$defaulttimezone,$session; + global $RULES,$GAME,$gametype; + + $result = DB_query("SELECT User.fullname as name,". + " Hand.position as position, ". + " User.id, ". + " Hand.party as party, ". + " Hand.sickness as sickness, ". + " Hand.point_call, ". + " User.last_login, ". + " 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"); + + $row0 = DB_fetch_array($result); + $row1 = DB_fetch_array($result); + $row2 = DB_fetch_array($result); + $row3 = DB_fetch_array($result); + + echo "
\n"; + display_single_user($row3); + echo "
\n"; + + return; +} + +function display_single_user($r,$start=0) +{ + /* start=1, mark starting player, default=0, so the player on the left is not marked */ + + global $gameid, $GT, $debug,$INDEX,$defaulttimezone,$session; + global $RULES,$GAME,$gametype; + $name = $r[0]; $pos = $r[1]; $user = $r[2]; @@ -1014,6 +1074,10 @@ function display_table () echo "
\n"; + /* mark starting player */ + if($start && ! ($party=="re" || $party=="contra")) + echo ' '._('Starting Player')."
\n"; + if($debug) echo " "; if($vacation = check_vacation($user)) @@ -1139,42 +1203,45 @@ function display_table () "title=\"local time: ".date("Y-m-d H:i:s",$timenow). " ". "last login: ".date("Y-m-d H:i:s",$lastlogin)."\" />"; - echo " "; + echo "
"; /* show how many tricks the person made */ 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 "\n"; echo "
\n"; - - } - echo "
\n"; /* end output table */ - - - return; } -function display_user_menu($id) +function display_user_menu($id, $skiphash=NULL) { global $WIKI,$INDEX; - $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) )". - " AND ( Game.status='pre' OR Game.status='play' )". - " ORDER BY Game.session" ); + 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'". + " 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) )". + " AND ( Game.status='pre' OR Game.status='play' )". + " ORDER BY Game.session" ); $i=0; while( $r = DB_fetch_array($result)) @@ -1184,13 +1251,17 @@ function display_user_menu($id) echo "\n
\n "; echo _('It\'s your turn in these games').":\n"; } + else + { + echo ", "; + } $i++; echo " game ".DB_format_gameid($r[1])." \n"; + "\"> ".DB_format_gameid($r[1])." \n"; if($i>4) { - echo " ...\n"; + echo ", ...\n"; break; } } @@ -1211,28 +1282,33 @@ function generate_score_table($session) $score = array(); $i=0; - /* get all ids */ + /* get all ids, scores and gametypes */ $gameids = DB_get_gameids_of_finished_games_by_session($session); if($gameids == NULL) return $score; - /* get player id, names... from the first game */ $player = array(); - $result = DB_query("SELECT User.id, User.fullname from Hand". - " LEFT JOIN User On Hand.user_id=User.id". - " WHERE Hand.game_id=".$gameids[0]); + $player_party = array(); + + /* get player id from the first game */ + $result = DB_query("SELECT user_id from Hand". + " WHERE Hand.game_id=".$gameids[0][0]); while( $r = DB_fetch_array($result)) $player[$r[0]] = 0; + /* get party of players for each game in the session */ + foreach($player as $id=>$points) + $player_party[$id]=DB_get_party_by_session_and_userid($session,$id); + /* get points and generate table */ foreach($gameids as $gameid) { - $re_score = DB_get_score_by_gameid($gameid); - $gametype = DB_get_gametype_by_gameid($gameid); + $re_score = $gameid[1]; + $gametype = $gameid[2]; foreach($player as $id=>$points) { - $party = DB_get_party_by_gameid_and_userid($gameid,$id); + $party = $player_party[$id][$i][0]; if($party == "re") if($gametype=="solo") $player[$id] += 3*$re_score; @@ -1241,7 +1317,7 @@ function generate_score_table($session) else if ($party == "contra") $player[$id] -= $re_score; } - $score[$i]['gameid'] = $gameid ; + $score[$i]['gameid'] = $gameid[0] ; $score[$i]['players'] = $player; $score[$i]['points'] = abs($re_score); $score[$i]['solo'] = ($gametype=="solo"); @@ -1256,14 +1332,14 @@ function generate_global_score_table() { $return = array(); - /* get all ids */ + /* get all ids, scores and gametypes */ $gameids = DB_get_gameids_of_finished_games_by_session(0); if($gameids == NULL) return ''; - /* get player id, names... from the User table */ $player = array(); + /* get player id, names... from the User table */ $result = DB_query('SELECT User.id, User.fullname FROM User'); /* save information in an array */ @@ -1274,15 +1350,15 @@ function generate_global_score_table() /* get points and generate table */ foreach($gameids as $gameid) { - $re_score = DB_get_score_by_gameid($gameid); - $gametype = DB_get_gametype_by_gameid($gameid); + $re_score = $gameid[1]; + $gametype = $gameid[2]; /* get players involved in this game */ - $result = DB_query('SELECT user_id FROM Hand WHERE game_id='.DB_quote_smart($gameid)); + $result = DB_query('SELECT user_id FROM Hand WHERE game_id='.DB_quote_smart($gameid[0])); while($r = DB_fetch_array($result)) { $id = $r[0]; - $party = DB_get_party_by_gameid_and_userid($gameid,$id); + $party = DB_get_party_by_gameid_and_userid($gameid[0],$id); if($party == 're') if($gametype=='solo') $player[$id]['points'] += 3*$re_score; @@ -1579,4 +1655,91 @@ function get_user_token($userid) 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; +} + ?>