$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 {