$page_data .= "<td class='border_left'>{$home_prediction} - {$away_prediction}<td>{$score}<td>{$runningTotals[$userID]}";
}
}
$page_data .= "</table></div></div></div>";
$file_name = __DIR__ . "/allpredictions_table.php";
file_put_contents($file_name, $page_data);
// Create Leaderboard Page
$page_data = "<div class='row'><div class='small-12 columns'><div class='table_container'><strong>Last updated: " . date("F j, Y, g:i a") . "</strong><table id='leaderboard_table'><thead><th id='th_home'>Name<th id='th_score'>Score<tbody>";
foreach ($users as $row) {
$userID = $row['id'];
$name = $row['name'];
$score = 0;
foreach ($fixtures as $inner_row) {
$fixtureID = $inner_row['id'];
$home_score = $inner_row['home_score'];
$away_score = $inner_row['away_score'];
$prediction = getPrediction($fixtureID, $userID);
if ($prediction === NULL) {
$home_prediction = 0;
$away_prediction = 0;
} else {
$home_prediction = $prediction['home_prediction'];
$away_prediction = $prediction['away_prediction'];
}
$score = $score + $scoring->calcScore($home_score, $away_score, $home_prediction, $away_prediction);
}
$page_data .= "<tr><td>{$name}</td><td>{$score}</td></tr>";
}
$page_data .= "</table></div></div></div>";
$file_name = __DIR__ . "/leaderboard_table.php";
file_put_contents($file_name, $page_data);
increaseCount($results["symbol"], $symbol);
increaseCount($results["duration"], $duration);
increaseCount($results["pitch"], $pitch);
}
// $stmt2->bind_param("i", $i);
// $stmt2->execute();
// $stmt2->bind_result($data);
// $stmt2->fetch();
if ($num_submissions >= 2) {
// when >= 3: at least 60% of submissions must agree
// when 2: both must agree
$threshold = $num_submissions == 2 ? 2 : $num_submissions * 0.6;
$prediction = array();
getPrediction($prediction, $results["symbol"], "symbol", $threshold);
getPrediction($prediction, $results["duration"], "duration", $threshold);
getPrediction($prediction, $results["pitch"], "pitch", $threshold);
if (count($prediction) == 3) {
$filename = getFilename($prediction, $i);
$res = $mysqli->query("SELECT data FROM pictures WHERE id = {$i}");
$row = $res->fetch_row();
$data = $row[0];
if (saveFile($filename, $data)) {
echo "{$filename} saved";
$exported++;
} else {
echo "could not save file";
}
} else {
echo "skipped: inconclusive submissions";
}
} else {
