ScoreBoard

[insert_php]
define(‘DONOTCACHEPAGE’, true);
function get_scoreboard_sql($year, $month) {
$sql = “SELECT name, SUM(points) as score, GROUP_CONCAT(points, ‘ ‘, IFNULL(shortdescription, ‘miscellaneous activity’) ORDER BY eventdate SEPARATOR ‘, ‘) as details” .
” FROM aylus_HonorPoints” .
” WHERE year(eventdate) = ” . $year . ” and month(eventdate) = ” . $month . ” and approved = 1″ .
” GROUP BY name” .
” ORDER BY SUM(points) DESC”;
return $sql;
}

$start = date(“Y-m-01”);
$stop = ‘2015-09-01’;

// Create connection
$conn = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
// Check connection
if ($conn->connect_error) {
die(“Connection failed: ” . $conn->connect_error);
}

$is_current = true;
while ($start >= $stop)
{
$result = $conn->query(get_scoreboard_sql(date(‘Y’, strtotime($start)), date(‘m’, strtotime($start))));

if (!$is_current)
echo ‘

‘;
echo ‘

‘;
if ($is_current)
echo ‘

Current counting period: ‘ . date(‘F Y’, strtotime($start)) . ‘

‘;
else
echo ‘

Archive: ‘ . date(‘F Y’, strtotime($start)) . ‘

‘;
echo ‘

‘;

$start = date(‘Y-m-01’, strtotime($start . ‘ – 1 MONTH’));
$is_current = false;
}

$conn->close();
[/insert_php]

Archive: July-August, 2015