X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=e-DoKo.git;a=blobdiff_plain;f=index.php;h=8e303ad28b12aafd9b4c6f25688e86e802a97bd9;hp=d135474612fde9d7cd0a7a292c5c42583af350ff;hb=0d893195c646305741d6a7f80b4b31343a6e8153;hpb=616c0a755263d974bf8953d71511a2860a3ff7ae diff --git a/index.php b/index.php index d135474..8e303ad 100644 --- a/index.php +++ b/index.php @@ -25,7 +25,14 @@ if(0) exit(); } -DB_open(); +if(DB_open()<0) + { + output_header(); + echo "Database error, can't connect..."; + output_footer(); + exit(); + } + output_header(); /* check if we want to start a new game */ @@ -84,20 +91,20 @@ if(myisset("new")) $ruleset = DB_get_ruleset_by_gameid($followup); /* just copy ruleset from old game, this way no manipulation is possible */ if($session) - mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', 'normal', NULL,'1','pre',". + mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', 'normal', NULL,NULL,'1','pre',". "'$ruleset','$session' ,NULL)"); else { /* get max session */ $max = DB_get_max_session(); $max++; - mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', 'normal', NULL,'1','pre',". + mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', 'normal', NULL,NULL,'1','pre',". "'$ruleset','$max' ,NULL)"); mysql_query("UPDATE Game SET session='".$max."' WHERE id=".DB_quote_smart($followup)); } } else - mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', 'normal', NULL,'1','pre', ". + mysql_query("INSERT INTO Game VALUES (NULL, NULL, '$randomNRstring', 'normal', NULL,NULL,'1','pre', ". "'$ruleset',NULL ,NULL)"); $game_id = mysql_insert_id(); @@ -219,8 +226,23 @@ else if(myisset("me")) $myname = DB_get_name_by_hash($me); $mystatus = DB_get_status_by_hash($me); $mypos = DB_get_pos_by_hash($me); - + $myhand = DB_get_handid_by_hash($me); + /* get prefs and save them */ + $result = mysql_query("SELECT value from User_Prefs". + " WHERE user_id='$myid' AND pref_key='cardset'" ); + $r = mysql_fetch_array($result,MYSQL_NUM); + if($r) + { + if($r[0]=="germancards" && (time()-strtotime( "2009-12-31 23:59:59")<0) ) /* licence only valid until then */ + $PREF["cardset"]="altenburg"; + else + $PREF["cardset"]="english"; + } + else + $PREF["cardset"]="english"; + + /* get rule set for this game */ $result = mysql_query("SELECT * FROM Rulesets". " LEFT JOIN Game ON Game.ruleset=Rulesets.id ". @@ -287,7 +309,7 @@ else if(myisset("me")) */ if( !myisset("in") ) { - echo "you need to answer the question."; + echo "

you need to answer the question.

"; DB_set_hand_status_by_hash($me,'start'); } else @@ -316,7 +338,7 @@ else if(myisset("me")) sort($mycards); echo "

your cards are:
\n"; foreach($mycards as $card) - display_card($card); + display_card($card,$PREF["cardset"]); echo "

\n"; check_for_sickness($me,$mycards); @@ -376,9 +398,7 @@ else if(myisset("me")) } else if($_REQUEST["poverty"] == "yes") { - echo "So you got poverty. You might as well have said nothing, since this is not implemented yet,". - " you need to play a normal game...to make it a bit harder, I'll tell the other people that". - " you only have a few trump... should make the game more interesting (although perhaps not for you:))
\n"; + echo "Don't think you can win with just a few trump...? ok, poverty chosen
\n"; DB_set_sickness_by_hash($me,"poverty"); } else if($_REQUEST["nines"] == "yes") @@ -401,7 +421,7 @@ else if(myisset("me")) * set that one in the Game table * tell people about it. */ - echo "
Checking if someone else selected solo, nines or wedding... Poverty not handled at the moment
"; + echo "
Checking if someone else selected solo, nines or wedding or poverty.
"; /* check if everyone has reached this stage */ $userids = DB_get_all_userid_by_gameid($gameid); @@ -429,49 +449,34 @@ else if(myisset("me")) /* check for different sickness and just output a general info */ - /* check for nines */ + $nines = 0; - foreach($userids as $user) - if(DB_get_sickness_by_userid_and_gameid($user,$gameid) == 'nines') - { - $nines = $user; - $name = DB_get_name_by_userid($user); - echo "$name has a Vorbehalt.
"; - break; - } - - /* check players for poverty */ $poverty = 0; + $wedding = 0; + $solo = 0; foreach($userids as $user) { - if(DB_get_sickness_by_userid_and_gameid($user,$gameid) == 'poverty') + $name = DB_get_name_by_userid($user); + $usersick = DB_get_sickness_by_userid_and_gameid($user,$gameid); + if($usersick == 'nines') + { + $nines = $user; + echo "$name has a Vorbehalt.
"; + break; + } + else if($usersick == 'poverty') { $poverty++; - $name = DB_get_name_by_userid($user); echo "$name has a Vorbehalt.
"; } - } - - /* check players for wedding */ - $wedding = 0; - foreach($userids as $user) - { - if(DB_get_sickness_by_userid_and_gameid($user,$gameid) == 'wedding') + else if($usersick == 'wedding') { $wedding=$user; - $name = DB_get_name_by_userid($user); echo "$name has a Vorbehalt.
" ; } - }; - - /* check for solo, output vorbehalt */ - $solo = 0; - foreach($userids as $user) - { - if(DB_get_sickness_by_userid_and_gameid($user,$gameid) == 'solo') + else if($usersick == 'solo') { $solo++; - $name = DB_get_name_by_userid($user); echo "$name has a Vorbehalt.
" ; } } @@ -508,17 +513,41 @@ else if(myisset("me")) output_footer(); exit(); } - else if($poverty==1 && $gametype !="poverty") + else if($poverty==1) { DB_set_gametype_by_gameid($gameid,"poverty"); $gametype = "poverty"; + $who=DB_get_sickness_by_gameid($gameid); + if(!$who) + { + $firstsick = DB_get_sickness_by_pos_and_gameid(1,$gameid); + if($firstsick == "poverty") + DB_set_sickness_by_gameid($gameid,2); /* who needs to be asked first */ + else + DB_set_sickness_by_gameid($gameid,1); /* who needs to be asked first */ + } } - else if($poverty==2 && $gametype !="dpoverty") + else if($poverty==2) { DB_set_gametype_by_gameid($gameid,"dpoverty"); $gametype = "dpoverty"; + $who=DB_get_sickness_by_gameid($gameid); + if(!$who) + { + $firstsick = DB_get_sickness_by_pos_and_gameid(1,$gameid); + if($firstsick == "poverty") + { + $seconsick = DB_get_sickness_by_pos_and_gameid(1,$gameid); + if($secondsick == "poverty") + DB_set_sickness_by_gameid($gameid,30); /* who needs to be asked first */ + else + DB_set_sickness_by_gameid($gameid,20); /* who needs to be asked first */ + } + else + DB_set_sickness_by_gameid($gameid,10); /* who needs to be asked first */ + } } - else if($wedding> 0 && $gametype !="wedding") + else if($wedding> 0) { DB_set_gametype_by_gameid($gameid,"wedding"); $gametype = "wedding"; @@ -541,7 +570,7 @@ else if(myisset("me")) $usersick = DB_get_sickness_by_userid_and_gameid($user,$gameid); if($usersick) - echo "$name has $usersick
"; /*TODO: perhaps save this in a string and store in Game? */ + echo "$name has $usersick.
"; /*TODO: perhaps save this in a string and store in Game? */ if($usersick=="poverty") $poverty++; @@ -596,26 +625,205 @@ else if(myisset("me")) DB_set_hand_status_by_hash($me,'play'); break; case "poverty": - /* use extra column in DB.Game to store whom to ask, - * should be set for poverty and dpoverty(use two digits for dpoverty?) earlier*/ - + case "dpoverty": /* check if poverty resolved (e.g. DB.Game who set to NULL) * yes? =>trump was taken, start game; break; - * - * check if we are being asked now - * no, display wait message, e.g. player X is asked at the moment + */ + $who=DB_get_sickness_by_gameid($gameid); + if($who<0) + { /* trump has been taken */ + DB_set_hand_status_by_hash($me,'play'); + break; + }; + + if($who>9) /*= two people still have trump on the table*/ + $add=10; + else + $add=1; + + /* check if we are being asked now + * no, display wait message, e.g. player X is asked at the moment + */ + $usersick = DB_get_sickness_by_userid_and_gameid($myid,$gameid); + if(myisset("trump") && $_REQUEST["trump"]=="no" && ($who==$mypos || $who==$mypos*10)) + { + /* user doesn't want to take trump */ + /* set next player who needs to be asked */ + $firstsick = (string) DB_get_sickness_by_pos_and_gameid($mypos+1,$gameid); + $secondsick = (string) DB_get_sickness_by_pos_and_gameid($mypos+2,$gameid); + + if($firstsick=="poverty") + { + if($secondsick=="poverty") + DB_set_sickness_by_gameid($gameid,$who+$add*3); + else + DB_set_sickness_by_gameid($gameid,$who+$add*2); + } + else + DB_set_sickness_by_gameid($gameid,$who+$add); + + /* this user is done */ + DB_set_hand_status_by_hash($me,'play'); + break; + } + else if(myisset("trump") && !myisset("exchange") && $_REQUEST["trump"]>0 && ($who==$mypos || $who==$mypos*10)) + { + /* user wants to take trump */ + $trump = $_REQUEST["trump"]; + + /* get hand id for user $trump */ + $userhand=DB_get_handid_by_gameid_and_userid($gameid,$trump); + /* copy trump from player A to B */ + $result = mysql_query("UPDATE Hand_Card SET hand_id='$myhand' WHERE hand_id='$userhand' AND card_id<'27'" ); + + /* set re/contra, if it is not already set */ + $party = DB_get_party_by_hash($me); + if(!$party) + { + foreach($userids as $user) + { + $hash = DB_get_hash_from_gameid_and_userid($gameid,$user); + if($user == $trump || $user == $myid) + DB_set_party_by_hash($hash,"re"); + else + DB_set_party_by_hash($hash,"contra"); + } + } + /* add hidden button with trump in it to get to the next point */ + echo "
\n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo " \n"; + echo "
\n"; + } + else if(myisset("trump","exchange") && $_REQUEST["trump"]>0 && ($who==$mypos || $who==$mypos*10)) + { + $trump = $_REQUEST["trump"]; + $exchange = $_REQUEST["exchange"]; + $userhand = DB_get_handid_by_gameid_and_userid($gameid,$trump); + + /* if exchange is set to a value>0, exchange that card back to user $trump */ + if($exchange >0) + { + $result = mysql_query("UPDATE Hand_Card SET hand_id='$userhand'". + " WHERE hand_id='$myhand' AND card_id='$exchange'" ); + }; + + /* if number of cards == 12, set status to play for both users */ + $result = mysql_query("SELECT COUNT(*) FROM Hand_Card WHERE hand_id='$myhand'" ); + $r = mysql_fetch_array($result,MYSQL_NUM); + if(!$r) + { + die("error in poverty"); + }; + if($r[0]==12) + { + if($gametype=="poverty" || $who<9) + { + DB_set_sickness_by_gameid($gameid,-1); /* done with poverty */ + } + else /* reduce poverty count by one, that is go to single digits $who */ + { + $add=1; + $who=$who/10; + + $firstsick = DB_get_sickness_by_pos_and_gameid($mypos+1,$gameid); + $secondsick = DB_get_sickness_by_pos_and_gameid($mypos+2,$gameid); + if($firstsick!="poverty") + DB_set_sickness_by_gameid($gameid,$who+$add); + else + { + if($secondsick!="poverty") + DB_set_sickness_by_gameid($gameid,$who+$add*2); + else + DB_set_sickness_by_gameid($gameid,$who+$add*3); + }; + } + + /* this user is done */ + DB_set_hand_status_by_hash($me,'play'); + /* and so is his partner */ + $hash = DB_get_hash_from_gameid_and_userid($gameid,$trump); + DB_set_hand_status_by_hash($hash,'play'); + + break; + } + else + { + /* else show all trump, have lowest card pre-selected, have hidden setting for */ + echo "you need to get rid of a few cards
\n"; + + set_gametype($gametype); /* this sets the $CARDS variable */ + $mycards = DB_get_hand($me); + $mycards = mysort($mycards,$gametype); + + echo "
\n"; + $type="exchange"; + foreach($mycards as $card) + display_link_card($card,$PREF["cardset"],$type); + echo " \n"; + echo " \n"; + echo " \n"; + echo "
\n"; + } + } + else if($who == $mypos || $who == $mypos*10) + { + foreach($userids as $user) + { + $name = DB_get_name_by_userid($user); + $usersick = DB_get_sickness_by_userid_and_gameid($user,$gameid); + + if($usersick=="poverty") + { + $hash =DB_get_hash_from_gameid_and_userid($gameid,$user); + $cards=DB_get_hand($hash); + $nrtrump=count_trump($cards); + /* count trump */ + if($nrtrump<4) + echo "Player $name has $nrtrump trump. Do you want to take them?". + "yes
"; + } + } + echo "I don't want to take any trump: ". + "yes
"; + } + else + { + echo "it's not your turn yet to decide if you want to take the trump or not."; + } + /* * yes, display number of trump and user's hand, ask if he wants to take it * no, set whom-to-ask to next player, email next player, cancle game if no next player * yes -> link to new page:display all cards, ask for N return cards * set re/contra * */ - case "dpoverty": - echo "TODO: handle poverty here (almost done in my developing version)"; - DB_set_hand_status_by_hash($me,'play'); }; } - + /* check if noone wanted to take trump, in that case the gamesickness would be set to 5 or 50 */ + $who=DB_get_sickness_by_gameid($gameid); + if($who==5 || $who==50) + { + $message = "Hello, \n\n". + "Game $gameid has been cancled since nobody wanted to take the trump.\n"; + + $userids = DB_get_all_userid_by_gameid($gameid); + foreach($userids as $user) + { + $To = DB_get_email_by_userid($user); + mymail($To,$EmailName."game cancled (poverty not resolved)",$message); + } + + /* delete everything from the dB */ + DB_cancel_game($me); + + echo "

Game $gameid has been cancled.

"; + output_footer(); + exit(); + } + /* check if all players are ready to play */ $ok=1; foreach($userids as $user) @@ -789,7 +997,7 @@ else if(myisset("me")) echo " ".$comment."\n"; echo " "; - display_card($r[0]); + display_card($r[0],$PREF["cardset"]); echo " \n"; /* end div card */ @@ -878,7 +1086,7 @@ else if(myisset("me")) /* display played card */ echo "
"; echo " you played
"; - display_card($card); + display_card($card,$PREF["cardset"]); echo "
\n"; /*check if we still have cards left, else set status to gameover */ @@ -1009,7 +1217,7 @@ else if(myisset("me")) { echo "Hello ".$myname.", it's your turn!
\n"; echo "Your cards are:
\n"; - echo "
\n"; + echo "\n"; /* do we have to follow suite? */ $followsuit = 0; @@ -1019,9 +1227,9 @@ else if(myisset("me")) foreach($mycards as $card) { if($followsuit && !same_type($card,$firstcard)) - display_card($card); + display_card($card,$PREF["cardset"]); else - display_link_card($card); + display_link_card($card,$PREF["cardset"]); } echo "
\nA short comments:\n"; @@ -1033,7 +1241,7 @@ else if(myisset("me")) { echo "Your cards are:
\n"; foreach($mycards as $card) - display_card($card); + display_card($card,$PREF["cardset"]); } else if($mystatus=='gameover') { @@ -1041,7 +1249,7 @@ else if(myisset("me")) $oldcards = mysort($oldcards,$gametype); echo "Your cards were:
\n"; foreach($oldcards as $card) - display_card($card); + display_card($card,$PREF["cardset"]); } echo "\n"; @@ -1129,6 +1337,7 @@ else if(myisset("me")) } else { + /* verify password and email */ if(strlen($password)!=32) $password = md5($password); @@ -1139,46 +1348,70 @@ else if(myisset("me")) if($ok) { - $time = DB_get_user_timestamp($uid); - $unixtime =strtotime($time); - - $offset = DB_get_user_timezone($uid); - $zone = return_timezone($offset); - date_default_timezone_set($zone); - - echo "last login: ".date("r",$unixtime)."
"; - - DB_update_user_timestamp($uid); - - echo "

these are the games you are playing in:
\n"; - $result = mysql_query("SELECT Hand.hash,Hand.game_id,Game.mod_date from Hand". - " LEFT JOIN Game On Hand.game_id=Game.id". - " WHERE Hand.user_id='$uid' AND Game.status<>'gameover'" ); - while( $r = mysql_fetch_array($result,MYSQL_NUM)) + if(myisset("setpref")) + { + $setpref=$_REQUEST["setpref"]; + switch($setpref) + { + case "germancards": + case "englishcards": + $result = mysql_query("SELECT * from User_Prefs". + " WHERE user_id='$uid' AND pref_key='cardset'" ); + if( mysql_fetch_array($result,MYSQL_NUM)) + $result = mysql_query("UPDATE User_Prefs SET value=".DB_quote_smart($setpref). + " WHERE user_id='$uid' AND pref_key='cardset'" ); + else + $result = mysql_query("INSERT INTO User_Prefs VALUES(NULL,'$uid','cardset',".DB_quote_smart($setpref).")"); + echo "Ok, changed you preferences for the cards.\n"; + break; + } + } + else /* output default user page */ { - echo "game #".$r[1]." "; - if(time()-strtotime($r[2]) > 60*60*24*30) - echo " The game has been running for over a month.". - " Do you want to cancel it? yes". - " (clicking here is final and can't be restored)"; - echo "
"; + $time = DB_get_user_timestamp($uid); + $unixtime =strtotime($time); + + $offset = DB_get_user_timezone($uid); + $zone = return_timezone($offset); + date_default_timezone_set($zone); + + /* display links to settings */ + output_user_settings($email,$password); + + echo "last login: ".date("r",$unixtime)."
"; + + DB_update_user_timestamp($uid); + + echo "

these are the games you are playing in:
\n"; + $result = mysql_query("SELECT Hand.hash,Hand.game_id,Game.mod_date from Hand". + " LEFT JOIN Game On Hand.game_id=Game.id". + " WHERE Hand.user_id='$uid' AND Game.status<>'gameover'" ); + while( $r = mysql_fetch_array($result,MYSQL_NUM)) + { + echo "game #".$r[1]." "; + if(time()-strtotime($r[2]) > 60*60*24*30) + echo " The game has been running for over a month.". + " Do you want to cancel it? yes". + " (clicking here is final and can't be restored)"; + echo "
"; + } + echo "

\n"; + + + echo "

and these are your games that are already done:
Game: \n"; + $result = mysql_query("SELECT hash,game_id from Hand WHERE user_id='$uid' AND status='gameover'" ); + while( $r = mysql_fetch_array($result,MYSQL_NUM)) + echo "#".$r[1]." , "; + echo "

\n"; + + $names = DB_get_all_names(); + echo "

registered players:
\n"; + foreach ($names as $name) + echo "$name, \n"; + echo "

\n"; + + echo "

Want to start a new game? Visit this page.

"; } - echo "

\n"; - - - echo "

and these are your games that are already done:
Game: \n"; - $result = mysql_query("SELECT hash,game_id from Hand WHERE user_id='$uid' AND status='gameover'" ); - while( $r = mysql_fetch_array($result,MYSQL_NUM)) - echo "#".$r[1]." , "; - echo "

\n"; - - $names = DB_get_all_names(); - echo "

registered players:
\n"; - foreach ($names as $name) - echo "$name, \n"; - echo "

\n"; - - echo "

Want to start a new game? Visit this page.

"; } else {