X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=e-DoKo.git;a=blobdiff_plain;f=index.php;h=2a688fd1a60b60f4725e30e6ca4410c3682e2881;hp=de8dc1d309b7fe6501d30d01f0a4dadeccdffb60;hb=01e982e40cc5679cdb4647aec7c37d3d789eeb4b;hpb=465e73265bc236531832686a8ae54894be928b81 diff --git a/index.php b/index.php index de8dc1d..2a688fd 100644 --- a/index.php +++ b/index.php @@ -214,6 +214,58 @@ else if(myisset("cancle","me")) else echo "

You need to wait longer before you can cancle a game...

\n"; } +/* send out a reminder */ +else if(myisset("remind","me")) + { + $me = $_REQUEST["me"]; + + /* test for valid ID */ + $myid = DB_get_userid_by_hash($me); + if(!$myid) + { + echo "Can't find you in the database, please check the url.
\n"; + echo "perhaps the game has been cancled, check by login in here."; + output_footer(); + DB_close(); + exit(); + } + + DB_update_user_timestamp($myid); + + /* get some information from the DB */ + $gameid = DB_get_gameid_by_hash($me); + $myname = DB_get_name_by_hash($me); + + /* check if game really is old enough */ + $result = mysql_query("SELECT mod_date,player,status from Game WHERE id='$gameid' " ); + $r = mysql_fetch_array($result,MYSQL_NUM); + if( (time()-strtotime($r[0]) > 60*60*24*7) && ($r[2]!='gameover') ) /* = 1 week */ + { + $name = DB_get_name_by_userid($r[1]); + $To = DB_get_email_by_userid($r[1]); + $userhash = DB_get_hash_from_gameid_and_userid($gameid,$r[1]); + + $message = "Hello $name, \n\n". + "It's your turn in game ".DB_format_gameid($gameid)." \n". + "Actually everyone else is waiting for you for more than a week now ;)\n\n". + "Please visit this link now to continue: \n". + " ".$host."?me=".$userhash."\n\n" ; + + if(DB_get_reminder($r[1],$gameid)>0) + { + echo "

An email has already been sent out.

\n"; + } + else + { + DB_set_reminder($r[1],$gameid); + mymail($To,$EmailName."Reminder: game ".DB_format_gameid($gameid)." it's your turn",$message); + + echo "

Game ".DB_format_gameid($gameid).": an email has been sent out.

"; + } + } + else + echo "

You need to wait longer before you can send out a reminder...

\n"; + } /* handle request from one specific player for one game, * (the hash is set on a per game base) */ else if(myisset("me")) @@ -285,63 +337,6 @@ else if(myisset("me")) /* put everyting in a form */ echo "
\n"; - /* output left menu */ - - display_user_menu(); - - /* output right menu */ - - /* display rule set for this game */ - echo "
\n"; - - if($gamestatus != 'pre') - echo " Gametype: $GT
\n"; - - echo "Rules:
\n"; - echo "10ofhearts : ".$RULES["dullen"] ."
\n"; - echo "schweinchen: ".$RULES["schweinchen"] ."
\n"; - echo "call: ".$RULES["call"] ."
\n"; - - echo "
\n"; - if($mystatus == 'play' ) - { - output_form_calls($me); - - echo "
\nA short comment:\n"; - echo "
"; - } - - echo "\n"; - - - if($mystatus=='gameover' && DB_get_game_status_by_gameid($gameid)=='gameover' ) - { - echo "
\n"; - - $session = DB_get_session_by_gameid($gameid); - $result = mysql_query("SELECT id,create_date FROM Game". - " WHERE session=$session". - " ORDER BY create_date DESC". - " LIMIT 1"); - $r = -1; - if($result) - $r = mysql_fetch_array($result,MYSQL_NUM); - - if(!$session || $gameid==$r[0]) - { - /* suggest a new game with the same people in it, just rotated once (unless last game was solo) */ - $names = DB_get_all_names_by_gameid($gameid); - $type = DB_get_gametype_by_gameid($gameid); - - if($type=="solo") - output_ask_for_new_game($names[0],$names[1],$names[2],$names[3],$gameid); - else - output_ask_for_new_game($names[1],$names[2],$names[3],$names[0],$gameid); - } - } - - echo "
\n"; - /* output game */ /* output extra division in case this game is part of a session */ @@ -354,9 +349,9 @@ else if(myisset("me")) foreach($hashes as $hash) { if($hash == $me) - echo "$i "; + echo "$i \n"; else - echo "$i "; + echo "$i \n"; $i++; } echo "\n"; @@ -394,7 +389,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 @@ -444,12 +439,12 @@ else if(myisset("me")) * unless a user tries to cheat ;) * can also happen if user reloads the page! */ - echo "

You need to answer the questions.

"; + echo "

You need to answer the questions.

"; DB_set_hand_status_by_hash($me,'init'); } else { - echo "Processing what you selected in the last step...
"; + echo "

Processing what you selected in the last step..."; /* check if this sickness needs to be handled first */ $gametype = DB_get_gametype_by_gameid($gameid); @@ -495,7 +490,7 @@ else if(myisset("me")) DB_set_sickness_by_hash($me,"nines"); } - echo " Ok, done with checking, please go to the next step of the setup.
"; + echo " Ok, done with checking, please go to the next step of the setup.

"; /* move on to the next stage*/ DB_set_hand_status_by_hash($me,'poverty'); @@ -520,8 +515,7 @@ else if(myisset("me")) foreach($userids as $user) { $To = DB_get_email_by_userid($user); - $userhash = DB_get_hash_from_gameid_and_userid($gameid,$user); - if($userhash != $me) + $userhash = DB_get_hash_from_gameid_and_userid($gameid,$user); if($userhash != $me) { $message = "Everyone finish the questionary in game ".DB_format_gameid($gameid).", ". "please visit this link now to continue: \n". @@ -540,7 +534,8 @@ else if(myisset("me")) * set that one in the Game table * tell people about it. */ - echo "
Checking if someone else selected solo, nines, wedding or poverty.
"; + echo "
\n"; + echo "

Checking if someone else selected solo, nines, wedding or poverty.

"; /* check if everyone has reached this stage */ $userids = DB_get_all_userid_by_gameid($gameid); @@ -814,11 +809,11 @@ else if(myisset("me")) $result = mysql_query("UPDATE Hand_Card SET hand_id='$myhand' WHERE hand_id='$userhand' AND card_id<'27'" ); /* 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"; + echo "
\n"; } else if(myisset("trump","exchange") && $_REQUEST["trump"]>0 && ($who==$mypos || $who==$mypos*10)) { @@ -919,7 +914,7 @@ else if(myisset("me")) 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"; + echo "
you need to get rid of a few cards
\n"; set_gametype($gametype); /* this sets the $CARDS variable */ $mycards = DB_get_hand($me); @@ -931,12 +926,12 @@ else if(myisset("me")) display_link_card($card,$PREF["cardset"],$type); echo " \n"; echo " \n"; - echo "\n"; + echo "
\n"; } } else if($who == $mypos || $who == $mypos*10) { - echo "
\n"; + echo "
\n"; foreach($userids as $user) { $name = DB_get_name_by_userid($user); @@ -954,7 +949,7 @@ else if(myisset("me")) } } echo "No,way I take those trump...
\n"; - echo "
\n"; + echo "
\n"; echo "Your cards are:
\n"; $mycards = DB_get_hand($me); @@ -1030,6 +1025,7 @@ else if(myisset("me")) else echo "\n
"; } + echo "
\n"; break; case 'play': case 'gameover': @@ -1061,8 +1057,8 @@ else if(myisset("me")) /* has the game started? No, then just wait here...*/ if($gamestatus == 'pre') { - echo "You finished the setup, but not everyone else finished it... ". - "so you need to wait for the others. Just wait for the an email...
"; + echo "

You finished the setup, but not everyone else finished it... ". + "so you need to wait for the others. Just wait for the an email...

"; break; /* not sure this works... the idea is that you can * only play a card after everyone is ready to play */ } @@ -1125,7 +1121,7 @@ else if(myisset("me")) date_default_timezone_set($zone); /* check if first schweinchen has been played */ - if($r[0] == 19 || $r[0] == 20 ) + if( $GAME["schweinchen"] && ($r[0] == 19 || $r[0] == 20) ) $GAME["schweinchen"]++; /* save card to be able to find the winner of the trick later */ @@ -1235,9 +1231,9 @@ else if(myisset("me")) $playid = DB_play_card($trickid,$handcardid,$sequence); /* check for schweinchen */ - if($card == 19 || $card == 20 ) + if($GAME["schweinchen"] && ($card == 19 || $card == 20) ) { - $GAME["schweinchen"]++; + $GAME["schweinchen"]++; // count how many have been played including this one if($GAME["schweinchen"]==3 && $RULES["schweinchen"]=="second" ) DB_insert_comment("Schweinchen! ",$playid,$myid); if($RULES["schweinchen"]=="both" ) @@ -1481,18 +1477,6 @@ else if(myisset("me")) } else if($mystatus=='gameover') { - /* get time from the last action of the game */ - $result = mysql_query("SELECT mod_date from Game WHERE id='$gameid' " ); - $r = mysql_fetch_array($result,MYSQL_NUM); - $gameend = time() - strtotime($r[0]); - - if( $gameend < 60*60*24*7 ) - { - echo "
\nA short comment:\n"; - echo "\n"; - echo "\n"; - } - $oldcards = DB_get_all_hand($me); $oldcards = mysort($oldcards,$gametype); echo "Your cards were:
\n"; @@ -1549,6 +1533,69 @@ else if(myisset("me")) default: myerror("error in testing the status"); } + /* output left menu */ + display_user_menu(); + + /* output right menu */ + + /* display rule set for this game */ + echo "
\n"; + + if($gamestatus != 'pre') + echo " Gametype: $GT
\n"; + + echo "Rules:
\n"; + echo "10ofhearts : ".$RULES["dullen"] ."
\n"; + echo "schweinchen: ".$RULES["schweinchen"] ."
\n"; + echo "call: ".$RULES["call"] ."
\n"; + + echo "
\n"; + if($gamestatus == 'play' ) + output_form_calls($me); + + /* get time from the last action of the game */ + $result = mysql_query("SELECT mod_date from Game WHERE id='$gameid' " ); + $r = mysql_fetch_array($result,MYSQL_NUM); + $gameend = time() - strtotime($r[0]); + + if($gamestatus == 'play' || $gameend < 60*60*24*7) + { + echo "
\nA short comment:\n"; + echo "
"; + } + + echo "\n"; + + + if($mystatus=='gameover' && DB_get_game_status_by_gameid($gameid)=='gameover' ) + { + echo "
\n"; + + $session = DB_get_session_by_gameid($gameid); + $result = mysql_query("SELECT id,create_date FROM Game". + " WHERE session=$session". + " ORDER BY create_date DESC". + " LIMIT 1"); + $r = -1; + if($result) + $r = mysql_fetch_array($result,MYSQL_NUM); + + if(!$session || $gameid==$r[0]) + { + /* suggest a new game with the same people in it, just rotated once (unless last game was solo) */ + $names = DB_get_all_names_by_gameid($gameid); + $type = DB_get_gametype_by_gameid($gameid); + + if($type=="solo") + output_ask_for_new_game($names[0],$names[1],$names[2],$names[3],$gameid); + else + output_ask_for_new_game($names[1],$names[2],$names[3],$names[0],$gameid); + } + } + + echo "
\n"; + + echo "
\n"; output_footer(); DB_close(); @@ -1720,6 +1767,7 @@ else if( myisset("email","password") || isset($_SESSION["name"]) ) display_user_menu(); + echo "
"; echo "

These are all your games:

\n"; echo "

Session:
\n"; echo " p = pre-game phase "; @@ -1767,12 +1815,17 @@ else if( myisset("email","password") || isset($_SESSION["name"]) ) else { $name = DB_get_name_by_userid($r[3]); + $gameid = $r[1]; + if(DB_get_reminder($r[3],$gameid)==0) + if(time()-strtotime($r[2]) > 60*60*24*7) + echo "". + "Send a reminder."; echo "(it's $name's turn)\n"; }; } 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". + echo "". + "Cancel?". " (clicking here is final and can't be restored)"; } @@ -1781,7 +1834,7 @@ else if( myisset("email","password") || isset($_SESSION["name"]) ) $names = DB_get_all_names(); echo "

Registered players:

\n

\n"; echo implode(", ",$names)."\n"; - echo "

\n"; + echo "

\n
"; } } else