public static function evalScore($round)
{
$query = "select player from player";
$result = mysql_query($query) or die("Error in query: {$query}. " . mysql_error());
while ($player = mysql_fetch_assoc($result)) {
$pts = 0;
$query1 = "select * from main where player='" . $player['player'] . "' and round='" . $round . "' ";
$result1 = mysql_query($query1) or die("Error in query: {$query1}. " . mysql_error());
while ($main = mysql_fetch_assoc($result1)) {
$pts += $main['eff_pts'];
}
$query2 = "select sid from score where player='" . $player['player'] . "' and round='" . $round . "' ";
$result2 = mysql_query($query2) or die("Error in query: {$query2}. " . mysql_error());
if (mysql_num_rows($result2) == 0) {
$query3 = "insert into score (player,\n\t\t\t\t\t\t\t\t\t\t\t round,\n\t\t\t\t\t\t\t\t\t\t\t pts\n\t\t\t\t\t\t\t\t\t\t\t)\n\t\t\t\t\t\t\t\t\t\t\t values('" . $player['player'] . "',\n\t\t\t\t\t\t\t\t\t\t\t\t\t '" . $round . "',\n\t\t\t\t\t\t\t\t\t\t\t\t\t '" . $pts . "'\n\t\t\t\t\t\t\t\t\t\t\t\t\t)\n\t\t\t\t\t\t";
mysql_query($query3) or die("Error in query: {$query3}. " . mysql_error());
} else {
$query3 = "update score set pts='" . $pts . "'\n\t\t\t\t\t\t\t\t\t\t where player='" . $player['player'] . "' and \n\t\t\t\t\t\t\t\t\t\t\t\t round='" . $round . "'\n\t\t\t\t\t\t";
mysql_query($query3) or die("Error in query: {$query3}. " . mysql_error());
}
Ikts::evalAggPts($player['player'], $round);
}
Ikts::evalRank($round);
Ikts::evalAggRank($round);
}
