{
echo "couldn't find one of the names, please start a new game";
output_footer();
+ DB_close();
exit();
}
{
echo "Error defining ruleset: $ruleset";
output_footer();
+ DB_close();
exit();
};
echo "Can't find you in the database, please check the url.<br />\n";
echo "perhaps the game has been cancled, check by login in <a href=\"$host\">here</a>.";
output_footer();
+ DB_close();
exit();
}
echo "Can't find you in the database, please check the url.<br />\n";
echo "perhaps the game has been cancled, check by login in <a href=\"$host\">here</a>.";
output_footer();
+ DB_close();
exit();
}
$message = "Everyone finish the questionary in game $gameid, ".
"please visit this link now to continue: \n".
" ".$host."?me=".$userhash."\n\n" ;
- mymail($To,$EmailName." finished setup",$message);
+ mymail($To,$EmailName." finished setup in game $gameid",$message);
}
};
echo "The game has been canceled because ".DB_get_name_by_userid($nines).
" has five or more nines and nobody is playing solo.\n";
output_footer();
+ DB_close();
exit();
}
else if($poverty==1)
$message = "Someone has poverty, it's your turn to decide, if you want to take the trump. Please visit:".
" ".$host."?me=".$userhash."\n\n" ;
- mymail($To,$EmailName." poverty",$message);
+ mymail($To,$EmailName." poverty (game $gameid)",$message);
}
/* this user is done */
$message = "Someone has poverty, it's your turn to decide, ".
"if you want to take the trump. Please visit:".
" ".$host."?me=".$userhash."\n\n" ;
- mymail($To,$EmailName." poverty",$message);
+ mymail($To,$EmailName." poverty (game $gameid)",$message);
}
}
echo "<p style=\"background-color:red\";>Game $gameid has been cancled.<br /><br /></p>";
output_footer();
+ DB_close();
exit();
}
/* email startplayer) */
$message = "It's your turn now in game $gameid.\n".
"Use this link to play a card: ".$host."?me=".$hash."\n\n" ;
- mymail($email,$EmailName."ready, set, go... ",$message);
+ mymail($email,$EmailName."ready, set, go... (game $gameid) ",$message);
}
else
echo " Please, <a href=\"$host?me=$me\">start</a> the game.<br />";
$message = "A card has been played in game $gameid.\n\n".
"It's your turn now.\n".
"Use this link to play a card: ".$host."?me=".$next_hash."\n\n" ;
- mymail($email,$EmailName."a card has been played",$message);
+ mymail($email,$EmailName."a card has been played in game $gameid",$message);
}
}
else
echo "error in testing the status";
}
output_footer();
+ DB_close();
exit();
}
/* user status page */
echo "<p>and these are your games that are already done:<br />Game: \n";
+ $output=array();
$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 "<a href=\"".$host."?me=".$r[0]."\">#".$r[1]." </a>, ";
- echo "</p>\n";
+ $output[]= "<a href=\"".$host."?me=".$r[0]."\">#".$r[1]." </a>";
+ echo implode(", ",$output)."</p>\n";
$names = DB_get_all_names();
echo "<p>registered players:<br />\n";
- foreach ($names as $name)
- echo "$name, \n";
+ echo implode(", ",$names)."\n";
echo "</p>\n";
echo "<p>Want to start a new game? Visit <a href=\"".$host."?new\">this page.</a></p>";
}
};
output_footer();
+ DB_close();
exit();
}
/* page for registration */
$game = mysql_fetch_array($r,MYSQL_NUM);
$done = mysql_fetch_array($r,MYSQL_NUM);
}
- output_home_page($pre[0],$game[0],$done[0]);
+
+ $r=mysql_query("SELECT AVG(datediff(mod_date,create_date)) FROM Game where status='gameover' ");
+ if($r)
+ $avgage= mysql_fetch_array($r,MYSQL_NUM);
+ else
+ $avgage[0]=0;
+
+ output_home_page($pre[0],$game[0],$done[0],$avgage[0]);
}
output_footer();