X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=e-DoKo.git;a=blobdiff_plain;f=include%2Ffunctions.php;h=a17ce0811d28c018bac0d4b578f6d1cae297fcaf;hp=98feae40b45505f02eb5fe2cffb0541e2f277213;hb=0082bc6dc92a82f37517ea410f8fd29c1b77f01e;hpb=761622f46541afbaf2303a791595f6595f3208eb diff --git a/include/functions.php b/include/functions.php index 98feae4..a17ce08 100644 --- a/include/functions.php +++ b/include/functions.php @@ -1,5 +1,5 @@ +/* Copyright 2006, 2007, 2008, 2009, 2010, 2011, 2012 Arun Persaud * * This file is part of e-DoKo. * @@ -73,7 +73,35 @@ function config_check() return; } -function mymail($uid,$subject,$message) +/* define possible status for email subsjects */ +define("GAME_CANCELED", 0); +define("GAME_CANCELED_POVERTY", 1); +define("GAME_CANCELED_TIMEOUT", 2); +define("GAME_YOUR_TURN", 3); +define("GAME_READY", 4); +define("GAME_POVERTY", 5); +define("GAME_DPOVERTY", 6); +define("GAME_OVER", 7); +define("GAME_RECOVERY", 8); +define("GAME_REMINDER", 9); +define("GAME_NEW", 10); + +/* define possible status for showing cards */ + +define("CARDS_EMPTY", 0); /* show player's hand*/ +define("CARDS_SHOW", 1); /* show player's hand*/ +define("CARDS_MYTURN", 2); /* show radiobuttons for cards that can be played*/ +define("CARDS_EXCHANGE", 3); /* do we need to return cards to our partner in poverty?*/ +define("CARDS_GAMEOVER_ME", 4); /* show all cards from everyone*/ +define("CARDS_GAMEOVER", 5); /* show all cards from everyone (looking at someone else's game)*/ + + /* cards_status: SHOW show our hand + * MYTURN show radiobutton for cards that can be played + * EXCHANGE do we need to return cards to our partner in poverty? + * GAMEOVER show all cards from everyone + */ + +function mymail($uid,$gameid=0,$type,$message) { global $EmailName,$WIKI; @@ -81,7 +109,50 @@ function mymail($uid,$subject,$message) $send_now = 1; /* add standard header and footer */ - $subject = "$EmailName".$subject; + $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 = "\nHave a nice day\n". @@ -856,12 +927,12 @@ function can_call($what,$hash) } else if ( 9 == ($NRcards + $offset)) { - if( ($mincall>=0 && $mincall==120) ) + if( ($mincall>=0 && $mincall<=120 && $what<=90 ) ) return 2; } else if ( 9 < ($NRcards + $offset)) { - if( ($mincall>=0 && $mincall==120) ) + if( ($mincall>=0 && $mincall<=120 && $what<=90 ) ) return 1; } else if ( 6 == ($NRcards + $offset)) @@ -900,7 +971,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; @@ -920,10 +991,57 @@ 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); + 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) +{ + global $gameid, $GT, $debug,$INDEX,$defaulttimezone,$session; + global $RULES,$GAME,$gametype; + $name = $r[0]; $pos = $r[1]; $user = $r[2]; @@ -938,8 +1056,8 @@ function display_table () $lastlogin = strtotime($r[6]); date_default_timezone_set($timezone); $timenow = strtotime(date("Y-m-d H:i:s")); - $gravatar = "$name
"; - + $gravatar = "$name
\n \"$name's"; echo "
\n"; @@ -957,7 +1075,7 @@ function display_table () else echo " $gravatar \n"; if($debug) - echo"\n"; + echo" \n"; /* add hints for poverty, wedding, solo, etc */ if( $gametype != "solo") @@ -971,12 +1089,15 @@ function display_table () $cards = DB_get_all_hand($userhash); $trumpNR = count_trump($cards,'all'); if($trumpNR) - echo " \"poverty"; + echo " \n"; else - echo " \"poverty"; + echo " \n"; } else - echo " \"poverty\" title=\"poverty partner\" />"; + echo " \n"; if($GT=="dpoverty") if($party=="re") @@ -986,12 +1107,15 @@ function display_table () $cards = DB_get_all_hand($userhash); $trumpNR = count_trump($cards,'all'); if($trumpNR) - echo " \"poverty"; + echo " \n"; else - echo " \"poverty"; + echo " \n"; } else - echo " \"poverty\" title=\"poverty partner\" />"; + echo " \" title=\"poverty partner\" />\n"; else if($sickness=="poverty" || ($RULES['lowtrump']=='poverty' && $sickness=='lowtrump')) { @@ -999,67 +1123,70 @@ function display_table () $cards = DB_get_all_hand($userhash); $trumpNR = count_trump($cards,'all'); if($trumpNR) - echo " \"poverty2"; + echo " \n"; else - echo " \"poverty2"; + echo " \n"; } else - echo " \"poverty2\" title=\"poverty2 partner\" />"; + echo " \" title=\"poverty2 partner\" />\n"; if($GT=="wedding" && $party=="re") if($sickness=="wedding") - echo " \"wedding\""; + echo " \"wedding\"\n"; else - echo " \"wedding"; + echo " \n"; if( (strpos($GT,"solo")!==false) && $party=="re") { if(strpos($GT,"queen")!==false) - echo " \"$GT\""; + echo " \"$GT\"\n"; else if(strpos($GT,"jack")!==false) - echo " \"$GT\""; + echo " \"$GT\"\n"; else if(strpos($GT,"club")!==false) - echo " \"$GT\""; + echo " \"$GT\"\n"; else if(strpos($GT,"spade")!==false) - echo " \"$GT\""; + echo " \"$GT\"\n"; else if(strpos($GT,"heart")!==false) - echo " \"$GT\""; + echo " \"$GT\"\n"; else if(strpos($GT,"trumpless")!==false) - echo " \"$GT\""; + echo " \"$GT\"\n"; else if(strpos($GT,"trump")!==false) - echo " \"$GT\""; + echo " \"$GT\"\n"; } /* add point calls */ if($call!=NULL) { if($party=="re") - echo " \"re\""; + echo " \"re\"\n"; else - echo " \"contra\""; + echo " \"contra\"\n"; switch($call) { case "0": - echo " \"0\""; + echo " \"0\"\n"; break; case "30": - echo " \"30\""; + echo " \"30\"\n"; break; case "60": - echo " \"60\""; + echo " \"60\"\n"; break; case "90": - echo " \"90\""; + echo " \"90\"\n"; break; } } - echo "
\n"; - echo " ". - "\"time". - "\n"; + echo " \"time"; + echo "
"; /* show how many tricks the person made */ switch($wins) { @@ -1074,49 +1201,56 @@ function display_table () default: echo "#tricks many"; break; } - - echo "
\n"; - - } - echo "
\n"; /* end output table */ - - - return; + echo "\n"; + echo " \n"; } -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)) { if($i==0) { - echo "
\n"; - echo _('It\'s your turn in these games').":
\n"; + echo "\n
\n "; + echo _('It\'s your turn in these games').":\n"; + } + else + { + echo ", "; } $i++; - echo "game ".DB_format_gameid($r[1])."
\n"; + echo " ".DB_format_gameid($r[1])." \n"; if($i>4) { - echo "...
\n"; + echo ", ...\n"; break; } } if($i) - echo "
\n"; + echo "
\n\n"; return; } @@ -1131,28 +1265,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; @@ -1161,7 +1300,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"); @@ -1176,14 +1315,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 */ @@ -1194,15 +1333,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;