X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=e-DoKo.git;a=blobdiff_plain;f=functions.php;h=0ce3104701f2175c24d53f6e63053904ba8846d7;hp=a52ad7a86cca139b4660d31f34c75b9ab4230977;hb=becb5e1267866b1fa858c08125fdba81003dfc65;hpb=987f4b37750c1c4c6d414a3cb8ae5e7b798fe41a diff --git a/functions.php b/functions.php index a52ad7a..0ce3104 100644 --- a/functions.php +++ b/functions.php @@ -1,100 +1,282 @@ 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."; + 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."; + output_footer(); + exit(); + } + if($DB_work) + { + output_header(); + echo "Working on the database...please check back later."; + output_footer(); + exit(); + } -/* - * end config - */ + return; +} +function mymail($To,$Subject,$message,$header="") +{ + global $debug,$EMAIL_REPLY; -/* helper function */ -function mymail($To,$Subject,$message) -{ - global $debug; + if(isset($EMAIL_REPLY)) + $header .= "From: e-DoKo daemon <$EMAIL_REPLY>\r\n"; if($debug) { - $message = str_replace("\n","
",$message); - echo "
To: $To
Subject: $Subject
$message
\n"; + $message = str_replace("\n","
\n",$message); + $message = ereg_replace("[[:alpha:]]+://[^<>[:space:]]+[[:alnum:]/]", + "\\0", $message); + + echo "
To: $To
"; + if($header != "") + echo $header."
"; + echo "Subject: $Subject
$message
\n"; } else - mail($To,$Subject,$message); + if($header != "") + mail($To,$Subject,$message,$header); + else + mail($To,$Subject,$message); + return; +} + +function myisset() +{ + /* returns 1 if all names passed as args are defined by a GET or POST statement, + * else return 0 + */ + + $ok = 1; + $args = func_get_args(); + + foreach($args as $arg) + { + $ok = $ok * isset($_REQUEST[$arg]); + /*echo "$arg: ok = $ok
"; + */ + } + return $ok; +} + +function myerror($message) +{ + echo "".htmlspecialchars($message)."\n"; + mymail($ADMIN_EMAIL,$EmailName." Error in Code",$message); return; } -function is_trump($c) { return (($c<27) ? 1:0);} -function is_club($c) { return (in_array($c,array('27','28','29','30','31','32','33','34')));} -function is_spade($c) { return (in_array($c,array('35','36','37','38','39','40','41','42')));} -function is_heart($c) { return (in_array($c,array('43','44','45','46','47','48')));} +function pos_array($c,$arr) +{ + $ret = 0; + + $i = 0; + foreach($arr as $a) + { + $i++; + if($a == $c) + { + $ret = $i; + break; + } + } + return $ret; +} + +function is_trump($c) +{ + global $CARDS; + + if(in_array($c,$CARDS["trump"])) + return 1; + else + return 0; +} + +function is_same_suite($c1,$c2) +{ + global $CARDS; + + if(in_array($c1,$CARDS["trump"] ) && in_array($c2,$CARDS["trump"] ) ) return 1; + if(in_array($c1,$CARDS["clubs"] ) && in_array($c2,$CARDS["clubs"] ) ) return 1; + if(in_array($c1,$CARDS["hearts"] ) && in_array($c2,$CARDS["hearts"] ) ) return 1; + if(in_array($c1,$CARDS["spades"] ) && in_array($c2,$CARDS["spades"] ) ) return 1; + if(in_array($c1,$CARDS["diamonds"]) && in_array($c2,$CARDS["diamonds"]) ) return 1; + + return 0; +} -function compare_cards($a,$b) +function compare_cards($a,$b,$game) { - /* if a is higher than b return 1, else 0, a being the card first played */ - - /* first map all cards to the odd number */ + /* if "a" is higher than "b" return 1, else 0, "a" being the card first played */ + + global $CARDS; + global $RULES; + global $GAME; + + /* first map all cards to the odd number, + * this insure that the first card wins the trick + * if they are the same card + */ if( $a/2 - (int)($a/2) != 0.5) $a--; if( $b/2 - (int)($b/2) != 0.5) $b--; - - if(is_trump($a) && $a<=$b) + + /* some special cases */ + switch($game) + { + case "normal": + case "silent": + if($RULES["schweinchen"]=="both" && $GAME["schweinchen"]) + { + if($a == 19 || $a == 20 ) + return 1; + if($b == 19 || $b == 20 ) + return 0; + }; + if($RULES["schweinchen"]=="second" && $GAME["schweinchen"]==3) + { + if($a == 19 || $a == 20 ) + return 1; + if($b == 19 || $b == 20 ) + return 0; + }; + case "trump": + case "heart": + case "spade": + case "club": + if($RULES["dullen"]=="secondwins") + if($a==1 && $b==1) /* both 10 of hearts */ + return 0; /* second one wins.*/ + } + + /* normal case */ + if(is_trump($a) && is_trump($b) && $a<=$b) return 1; - else if(is_trump($a) && $a>$b) + else if(is_trump($a) && is_trump($b) ) return 0; - else + else { /*$a is not a trump */ if(is_trump($b)) return 0; else - { + { /* both no trump */ + /* both clubs? */ - if( is_club($a) && is_club($b)) - if($a<=$b) + $posA = pos_array($a,$CARDS["clubs"]); + $posB = pos_array($b,$CARDS["clubs"]); + if($posA && $posB) + if($posA <= $posB) + return 1; + else + return 0; + + /* both spades? */ + $posA = pos_array($a,$CARDS["spades"]); + $posB = pos_array($b,$CARDS["spades"]); + if($posA && $posB) + if($posA <= $posB) return 1; else return 0; - /* both spade? */ - if( is_spade($a) && is_spade($b)) - if($a<=$b) + + /* both hearts? */ + $posA = pos_array($a,$CARDS["hearts"]); + $posB = pos_array($b,$CARDS["hearts"]); + if($posA && $posB) + if($posA <= $posB) return 1; else return 0; - /* both heart? */ - if( is_heart($a) && is_heart($b)) - if($a<=$b) + + /* both diamonds? */ + $posA = pos_array($a,$CARDS["diamonds"]); + $posB = pos_array($b,$CARDS["diamonds"]); + if($posA && $posB) + if($posA <= $posB) return 1; else return 0; - return 1; - } + + /* not the same suit and no trump: a wins */ + return 1; + } } - -} +} -function get_winner($p) +function get_winner($p,$mode) { - /* get all 4 cards played in a trick */ - $c1 = $p[1]; - $c2 = $p[2]; - $c3 = $p[3]; - $c4 = $p[4]; - - /* find out who won */ - if( compare_cards($c1,$c2) && compare_cards($c1,$c3) && compare_cards($c1,$c4) ) - return 1; - if( compare_cards($c2,$c3) && compare_cards($c2,$c4) ) - return 2; - if( compare_cards($c3,$c4) ) - return 3; - return 4; + /* get all 4 cards played in a trick, in the order they are played */ + $tmp = $p[1]; + $c1 = $tmp["card"]; + $c1pos = $tmp["pos"]; + + $tmp = $p[2]; + $c2 = $tmp["card"]; + $c2pos = $tmp["pos"]; + + $tmp = $p[3]; + $c3 = $tmp["card"]; + $c3pos = $tmp["pos"]; + + $tmp = $p[4]; + $c4 = $tmp["card"]; + $c4pos = $tmp["pos"]; + + /* first card is better than all the rest */ + if( compare_cards($c1,$c2,$mode) && compare_cards($c1,$c3,$mode) && compare_cards($c1,$c4,$mode) ) + return $c1pos; + + /* second card is better than first and better than the rest */ + if( !compare_cards($c1,$c2,$mode) && compare_cards($c2,$c3,$mode) && compare_cards($c2,$c4,$mode) ) + return $c2pos; + + /* third card is better than first card and better than last */ + if( !compare_cards($c1,$c3,$mode) && compare_cards($c3,$c4,$mode) ) + /* if second card is better than first, third card needs to be even better */ + if( !compare_cards($c1,$c2,$mode) && !compare_cards($c2,$c3,$mode) ) + return $c3pos; + /* second is worse than first, e.g. not following suite */ + else if (compare_cards($c1,$c2,$mode) ) + return $c3pos; + + /* non of the above */ + return $c4pos; } function count_nines($cards) @@ -108,14 +290,14 @@ function count_nines($cards) else if($c == "41" || $c == "42") $nines++; else if($c == "47" || $c == "48") $nines++; } - + return $nines; } function check_wedding($cards) { - if( in_array("3",$cards) && in_array("2",$cards) ) + if( in_array("3",$cards) && in_array("4",$cards) ) return 1; return 0; @@ -123,312 +305,568 @@ function check_wedding($cards) function count_trump($cards) { + global $RULES; + $trump = 0; /* count each trump */ foreach($cards as $c) - if( (int)($c) <27) + if( (int)($c) <27) $trump++; - /* subtract foxes */ - if( in_array("19",$cards)) - $trump--; - if( in_array("20",$cards) ) - $trump--; - /* add one, in case the player has both foxes (schweinchen) */ - if( in_array("19",$cards) && in_array("20",$cards) ) - $trump++; + switch($RULES["schweinchen"]) + { + case "none": + break; + case "second": + case "secondaftercall": + /* add one, in case the player has both foxes (schweinchen) */ + if( in_array("19",$cards) && in_array("20",$cards) ) + $trump++; + case "both": + /* subtract foxes */ + if( in_array("19",$cards)) + $trump--; + if( in_array("20",$cards) ) + $trump--; + break; + } return $trump; } -function card_to_name($card) +function create_array_of_random_numbers($useridA,$useridB,$useridC,$useridD) { - switch($card) + global $debug; + + $r = array(); + + if($debug) { - case 1: - case 2: - return "ten of hearts"; - case 3: - case 4: - return "queen of clubs"; - case 5: - case 6: - return "queen of spades"; - case 7: - case 8: - return "queen of hearts"; - case 9: - case 10: - return "queen of diamonds"; - case 11: - case 12: - return "jack of clubs"; - case 13: - case 14: - return "jack of spades"; - case 15: - case 16: - return "jack of hearts"; - case 17: - case 18: - return "jack of diamonds"; - case 19: - case 20: - return "ace of diamonds"; - case 21: - case 22: - return "ten of diamonds"; - case 23: - case 24: - return "king of diamonds"; - case 25: - case 26: - return "nine of diamonds";; - case 27: - case 28: - return "ace of clubs"; - case 29: - case 30: - return "ten of clubs"; - case 31: - case 32: - return "king of clubs"; - case 33: - case 34: - return "nine of clubs"; - case 35: - case 36: - return "ace of spades"; - case 37: - case 38: - return "ten of spades"; - case 39: - case 40: - return "king of spades"; - case 41: - case 42: - return "nine of spades"; - case 43: - case 44: - return "ace of hearts"; - case 45: - case 46: - return "king of hearts"; - case 47: - case 48: - return "nine of hearts"; - default: - return "something went wrong, please contact the admin. Error: code1."; + $r[ 0]=1; $r[12]=47; $r[24]=13; $r[36]=37; + $r[ 1]=2; $r[13]=48; $r[25]=14; $r[37]=38; + $r[ 2]=3; $r[14]=27; $r[26]=15; $r[38]=39; + $r[ 3]=4; $r[15]=16; $r[27]=28; $r[39]=40; + $r[ 4]=5; $r[16]=17; $r[28]=29; $r[40]=41; + $r[ 5]=18; $r[17]=6; $r[29]=30; $r[41]=42; + $r[ 6]=19; $r[18]=7; $r[30]=31; $r[42]=43; + $r[ 7]=20; $r[19]=8; $r[31]=32; $r[43]=44; + $r[ 8]=45; $r[20]=9; $r[32]=21; $r[44]=33; + $r[ 9]=46; $r[21]=10; $r[33]=22; $r[45]=34; + $r[10]=35; $r[22]=11; $r[34]=23; $r[46]=25; + $r[11]=36; $r[23]=12; $r[35]=24; $r[47]=26; } + else + { + /* check if we can find a game were non of the player was involved and return + * cards insted + */ + $userstr = "'".implode("','",array($useridA,$useridB,$useridC,$useridD))."'"; + $randomnumbers = DB_get_unused_randomnumbers($userstr); + $randomnumbers = explode(":",$randomnumbers); + + if(sizeof($randomnumbers)==48) + return $randomnumbers; + + /* need to create new numbers */ + for($i=0;$i<48;$i++) + $r[$i]=$i+1; + + /* shuffle using a better random generator than the standard one */ + for ($i = 0; $i <48; $i++) + { + $j = @mt_rand(0, $i); + $tmp = $r[$i]; + $r[$i] = $r[$j]; + $r[$j] = $tmp; + } + }; + + return $r; +} + +function display_cards($me,$myturn) +{ + return; } -function card_value($card) +function have_suit($cards,$c) { - switch($card) + global $CARDS; + $suite = array(); + + if(in_array($c,$CARDS["trump"])) + $suite = $CARDS["trump"]; + else if(in_array($c,$CARDS["clubs"])) + $suite = $CARDS["clubs"]; + else if(in_array($c,$CARDS["spades"])) + $suite = $CARDS["spades"]; + else if(in_array($c,$CARDS["hearts"])) + $suite = $CARDS["hearts"]; + else if(in_array($c,$CARDS["diamonds"])) + $suite = $CARDS["diamonds"]; + + foreach($cards as $card) { - case 1: /* heart */ - case 2: - return 10; - case 3: /* clubes */ - case 4: - case 5: /* spades */ - case 6: - case 7: /* hearts */ - case 8: - case 9: /* diamonds */ - case 10: - return 3; - case 11: /* clubes */ - case 12: - case 13: /* spades */ - case 14: - case 15: /* hearts */ - case 16: - case 17: /* diamonds */ - case 18: - return 2; - case 19: /* diamonds */ - case 20: - case 27: /* clubs */ - case 28: - case 35: /* spades */ - case 36: - case 43: /* hearts */ - case 44: - return 11; - case 21: /* diamonds */ - case 22: - case 29: /* clubs */ - case 30: - case 37: /* spades */ - case 38: - return 10; - case 23: /* diamonds */ - case 24: - case 31: /* clubs */ - case 32: - case 39: /* spades */ - case 40: - case 45: /* hearts */ - case 46: - return 4; - case 25: /* diamonds */ - case 26: - case 33: /* clubs */ - case 34: - case 41: /* spades */ - case 42: - case 47: /* hearts */ - case 48: - return 0; - default: - echo "something went wrong, please contact the admin. ErrorCode: 2
"; - return 0; + if(in_array($card,$suite)) + return 1; } + + return 0; } -function display_card($card) +function same_type($card,$c) { - /* cards are only availabl for the odd values, e.g. 1.png, 3.png, ... - * convert even cards to the matching odd value */ - - if( $card/2 - (int)($card/2) == 0.5) - echo "\"".card_to_name($card)."\"\n"; - else - echo "\"".card_to_name($card-1)."\"\n"; + global $CARDS; + $suite = ""; + + /* figure out what kind of card c is */ + if(in_array($c,$CARDS["trump"])) + $suite = $CARDS["trump"]; + else if(in_array($c,$CARDS["clubs"])) + $suite = $CARDS["clubs"]; + else if(in_array($c,$CARDS["spades"])) + $suite = $CARDS["spades"]; + else if(in_array($c,$CARDS["hearts"])) + $suite = $CARDS["hearts"]; + else if(in_array($c,$CARDS["diamonds"])) + $suite = $CARDS["diamonds"]; + + /* card is the same suid return 1 */ + if(in_array($card,$suite)) + return 1; - return; + return 0; } -function display_link_card($card) +function set_gametype($gametype) { - if( $card/2 - (int)($card/2) == 0.5) - echo "\"\"\n"; - else - echo "\"\"\n"; - return; + global $CARDS; + global $RULES; + + switch($gametype) + { + case "normal": + case "wedding": + case "poverty": + case "dpoverty": + case "trump": + case "silent": + $CARDS["trump"] = array('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16', + '17','18','19','20','21','22','23','24','25','26'); + $CARDS["diamonds"] = array(); + $CARDS["clubs"] = array('27','28','29','30','31','32','33','34'); + $CARDS["spades"] = array('35','36','37','38','39','40','41','42'); + $CARDS["hearts"] = array('43','44','45','46','47','48'); + $CARDS["foxes"] = array('19','20'); + if($RULES["dullen"]=='none') + { + $CARDS["trump"] = array('3','4','5','6','7','8','9','10','11','12','13','14','15','16', + '17','18','19','20','21','22','23','24','25','26'); + $CARDS["hearts"] = array('43','44','1','2','45','46','47','48'); + } + break; + case "queen": + $CARDS["trump"] = array('3','4','5','6','7','8','9','10'); + $CARDS["clubs"] = array('27','28','29','30','31','32','11','12','33','34'); + $CARDS["spades"] = array('35','36','37','38','39','40','13','14','41','42'); + $CARDS["hearts"] = array('43','44', '1', '2','45','46','15','16','47','48'); + $CARDS["diamonds"] = array('19','20','21','22','23','24','17','18','25','26'); + $CARDS["foxes"] = array(); + break; + case "jack": + $CARDS["trump"] = array('11','12','13','14','15','16','17','18'); + $CARDS["clubs"] = array('27','28','29','30','31','32','3', '4','33','34'); + $CARDS["spades"] = array('35','36','37','38','39','40','5', '6','41','42'); + $CARDS["hearts"] = array('43','44', '1', '2','45','46','7', '8','47','48'); + $CARDS["diamonds"] = array('19','20','21','22','23','24','9','10','25','26'); + $CARDS["foxes"] = array(); + break; + case "trumpless": + $CARDS["trump"] = array(); + $CARDS["clubs"] = array('27','28','29','30','31','32','3', '4','11','12','33','34'); + $CARDS["spades"] = array('35','36','37','38','39','40','5', '6','13','14','41','42'); + $CARDS["hearts"] = array('43','44', '1', '2','45','46','7', '8','15','16','47','48'); + $CARDS["diamonds"] = array('19','20','21','22','23','24','9','10','17','18','25','26'); + $CARDS["foxes"] = array(); + break; + case "club": + $CARDS["trump"] = array('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16', + '17','18','27','28','29','30','31','32','33','34'); + $CARDS["clubs"] = array(); + $CARDS["spades"] = array('35','36','37','38','39','40','41','42'); + $CARDS["hearts"] = array('43','44','45','46','47','48'); + $CARDS["diamonds"] = array('19','20','21','22','23','24','25','26'); + $CARDS["foxes"] = array(); + if($RULES["dullen"]=='none') + { + $CARDS["trump"] = array('3','4','5','6','7','8','9','10','11','12','13','14','15','16', + '17','18','27','28','29','30','31','32','33','34'); + $CARDS["hearts"] = array('43','44','1','2','45','46','47','48'); + } + break; + case "spade": + $CARDS["trump"] = array('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16', + '17','18','35','36','37','38','39','40','41','42'); + $CARDS["clubs"] = array('27','28','29','30','31','32','33','34'); + $CARDS["spades"] = array(); + $CARDS["hearts"] = array('43','44','45','46','47','48'); + $CARDS["diamonds"] = array('19','20','21','22','23','24','25','26'); + $CARDS["foxes"] = array(); + if($RULES["dullen"]=='none') + { + $CARDS["trump"] = array('3','4','5','6','7','8','9','10','11','12','13','14','15','16', + '17','18','35','36','37','38','39','40','41','42'); + $CARDS["hearts"] = array('43','44','1','2','45','46','47','48'); + } + break; + case "heart": + $CARDS["trump"] = array('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16', + '17','18','43','44','45','46','47','48'); + $CARDS["clubs"] = array('27','28','29','30','31','32','33','34'); + $CARDS["spades"] = array('35','36','37','38','39','40','41','42'); + $CARDS["hearts"] = array(); + $CARDS["diamonds"] = array('19','20','21','22','23','24','25','26'); + $CARDS["foxes"] = array(); + if($RULES["dullen"]=='none') + { + $CARDS["trump"] = array('3','4','5','6','7','8','9','10','11','12','13','14','15','16', + '17','18','43','44','1','2','45','46','47','48'); + } + break; + } } -function create_array_of_random_numbers() +function mysort($cards,$gametype) { - $r = array(); - $a = array(); - - for($i=1;$i<49;$i++) - $a[$i]=$i; - - $r = array_rand($a,48); - - return $r; + usort ( $cards, "sort_comp" ); + return $cards; } -function check_want_to_play($me) +function sort_comp($a,$b) { - ?> -
- Do you want to play a game of DoKo? - yes - no
- - Do you want to get an email for every card played or only if it your move? - every card - only on my turn
-\n"; - echo "\n"; - echo "\n"; - echo "
\n"; + global $CARDS; - return; + $ALL = array(); + $ALL = array_merge($CARDS["trump"],$CARDS["diamonds"],$CARDS["clubs"], + $CARDS["hearts"],$CARDS["spades"],$CARDS["diamonds"]); + + return pos_array($a,$ALL)-pos_array($b,$ALL); } -function check_for_sickness($me,$mycards) +function can_call($what,$hash) { - ?> -

nothing implemented so far, but give it a try anyway ;)

- -
- - do you want to play solo? - -
- - "; - echo " no
\n"; - } - else - { - echo " no
\n"; - }; - - echo "do you have poverty?"; - if(count_trump($mycards)<4) + global $RULES; + + $gameid = DB_get_gameid_by_hash($hash); + $gametype = DB_get_gametype_by_gameid($gameid); + $oldcall = DB_get_call_by_hash($hash); + $pcall = DB_get_partner_call_by_hash($hash); + + if( ($pcall!=NULL && $what >= $pcall) || + ($oldcall!=NULL && $what >=$oldcall) ) { - echo " yes"; - echo " no
\n"; + return 0; } - else + + $NRcards = count(DB_get_hand($hash)); + + $NRallcards = 0; + for ($i=1;$i<5;$i++) { - echo " no
\n"; + $user = DB_get_hash_from_game_and_pos($gameid,$i); + $NRallcards += count(DB_get_hand($user)); }; - echo "do you have too many nines?"; - if(count_nines($mycards)>4) - { - echo " yes"; - echo " no
\n"; - } - else - { - echo " no
\n"; - }; + /* in case of a wedding, everything will be delayed by an offset */ + $offset = 0; + if($gametype=="wedding") + { + $offset = DB_get_sickness_by_gameid($gameid); + if ($offset <0) /* not resolved */ + return 0; + }; - echo "\n"; - echo "\n"; + switch ($RULES["call"]) + { + case "1st-own-card": + if( 4-($what/30) >= 12 - ($NRcards + $offset)) + return 1; + break; + case "5th-card": + if( 27+4*($what/30) <= $NRallcards + $offset*4) + return 1; + break; + case "9-cards": + + if($oldcall!=NULL && $pcall!=NULL) + $mincall = ($oldcall>$pcall) ? $pcall : $oldcall; + else if($oldcall!=NULL) + $mincall = $oldcall; + else if ($pcall!=NULL) + $mincall = $pcall; + else + $mincall = -1; - echo "
\n"; + if( 12 <= ($NRcards + $offset)) + { + return 1; + } + else if ( 9 <= ($NRcards + $offset)) + { + if( ($mincall>=0 && $mincall==120) ) + return 1; + } + else if ( 6 <= ($NRcards + $offset)) + { + if( ($mincall>=0 && $mincall<=90 && $what<=60 ) ) + return 1; + } + else if ( 3 <= ($NRcards + $offset)) + { + if( ($mincall>=0 && $mincall<=60 && $what<=30 ) ) + return 1; + } + else if ( 0 <= ($NRcards + $offset)) + { + if( ($mincall>=0 && $mincall<=30 && $what==0 ) ) + return 1; + }; + break; + } - return; + return 0; } -function display_status() +function display_table () { - echo "
"; - echo " is someone playing solo, etc?"; - echo "
"; - + global $gameid, $GT, $debug,$INDEX,$defaulttimezone; + + $result = mysql_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 ". + "FROM Hand ". + "LEFT JOIN User ON User.id=Hand.user_id ". + "WHERE Hand.game_id='".$gameid."' ". + "ORDER BY position ASC"); + + echo "
\n". + " \"table\"\n"; + while($r = mysql_fetch_array($result,MYSQL_NUM)) + { + $name = $r[0]; + $pos = $r[1]; + $user = $r[2]; + $party = $r[3]; + $sickness = $r[4]; + $call = $r[5]; + $hash = $r[7]; + $timezone = $r[8]; + date_default_timezone_set($defaulttimezone); + $lastlogin = strtotime($r[6]); + date_default_timezone_set($timezone); + $timenow = strtotime(date("Y-m-d H:i:s")); + + echo "
\n"; + if(!$debug) + echo " $name \n"; + else + echo " $name\n"; + + /* add hints for poverty, wedding, solo, etc */ + if($GT=="poverty" && $party=="re") + if($sickness=="poverty") + { + $userhash = DB_get_hash_from_gameid_and_userid($gameid,$user); + $cards = DB_get_all_hand($userhash); + $trumpNR = count_trump($cards); + if($trumpNR) + echo " \"poverty"; + else + echo " \"poverty"; + } + else + echo " \"poverty\" />"; + + if($GT=="dpoverty") + if($party=="re") + if($sickness=="poverty") + { + $userhash = DB_get_hash_from_gameid_and_userid($gameid,$user); + $cards = DB_get_all_hand($userhash); + $trumpNR = count_trump($cards); + if($trumpNR) + echo " \"poverty"; + else + echo " \"poverty"; + } + else + echo " \"poverty\" />"; + else + if($sickness=="poverty") + { + $userhash = DB_get_hash_from_gameid_and_userid($gameid,$user); + $cards = DB_get_all_hand($userhash); + $trumpNR = count_trump($cards); + if($trumpNR) + echo " \"poverty2"; + else + echo " \"poverty2"; + } + else + echo " \"poverty2\" />"; + + if($GT=="wedding" && $party=="re") + if($sickness=="wedding") + echo " \"wedding\""; + else + echo " \"wedding"; + + if(ereg("solo",$GT) && $party=="re") + { + if(ereg("queen",$GT)) + echo " \"$GT\""; + else if(ereg("jack",$GT)) + echo " \"$GT\""; + else if(ereg("club",$GT)) + echo " \"$GT\""; + else if(ereg("spade",$GT)) + echo " \"$GT\""; + else if(ereg("heart",$GT)) + echo " \"$GT\""; + else if(ereg("trumpless",$GT)) + echo " \"$GT\""; + else if(ereg("trump",$GT)) + echo " \"$GT\""; + } + + /* add point calls */ + if($call!=NULL) + { + if($party=="re") + echo " \"re\""; + else + echo " \"contra\""; + switch($call) + { + case "0": + echo " \"0\""; + break; + case "30": + echo " \"30\""; + break; + case "60": + echo " \"60\""; + break; + case "90": + echo " \"90\""; + break; + } + } + + echo "
\n"; + echo " local time\n"; + echo " last login\n"; + echo "
\n"; + + } + echo "
\n"; /* end output table */ + + return; } -function display_news() + +function display_user_menu() { - global $wiki; - echo "
". - "Please hit shift+reload.
". - "New Database backend, lost a few features on the way.
". - "If you find more bugs, please list them in the wiki.
\n"; + global $wiki,$myid,$INDEX,$STATS; + echo "
\n". + " Go to my user page "; + + $result = mysql_query("SELECT Hand.hash,Hand.game_id,Game.player from Hand". + " LEFT JOIN Game On Hand.game_id=Game.id". + " WHERE Hand.user_id='$myid'". + " AND Game.player='$myid'". + " AND Game.status<>'gameover'". + " ORDER BY Game.session" ); + if(mysql_num_rows($result)) + echo "
It's your turn in these games:
\n"; + + while( $r = mysql_fetch_array($result,MYSQL_NUM)) + { + echo "game ".DB_format_gameid($r[1])."
\n"; + } + + echo "
Start a new game\n"; + + echo "
Statistics\n"; + + echo + "
Report bugs in the wiki\n"; + echo "
\n"; return; } -function display_cards($me,$myturn) +function generate_score_table($session) { - return; + + /* get all ids */ + $gameids = DB_get_gameids_of_finished_games_by_session($session); + + if($gameids == NULL) + return ""; + + $output = "
\n\n \n"; + + + /* get player id, names... from the first game */ + $player = array(); + $result = mysql_query("SELECT User.id, User.fullname from Hand". + " LEFT JOIN User On Hand.user_id=User.id". + " WHERE Hand.game_id=".$gameids[0]); + while( $r = mysql_fetch_array($result,MYSQL_NUM)) + { + $player[] = array( 'id' => $r[0], 'points' => 0 ); + $output.= " \n"; + } + $output.=" \n \n"; + + /* get points and generate table */ + foreach($gameids as $gameid) + { + $output.=" \n"; + + $re_score = DB_get_score_by_gameid($gameid); + foreach($player as $key=>$pl) + { + $party = DB_get_party_by_gameid_and_userid($gameid,$pl['id']); + if($party == "re") + if(DB_get_gametype_by_gameid($gameid)=="solo") + $player[$key]['points'] += 3*$re_score; + else + $player[$key]['points'] += $re_score; + else if ($party == "contra") + $player[$key]['points'] -= $re_score; + + $output.=" \n"; + } + $output.=" \n \n"; + } + + $output.="
".substr($r[1],0,2)." P
".$player[$key]['points']."".abs($re_score); + + /* check for solo */ + if(DB_get_gametype_by_gameid($gameid)=="solo") + $output.= " S"; + $output.="
\n"; + + return $output; } -?> \ No newline at end of file +?>