public static function nextActive()
{
$stmt = parent::$conn->prepare("SELECT * FROM contest WHERE contest_start = 0 ORDER BY contest_id ASC LIMIT 1");
$contest = new contest($stmt);
if ($contest->found()) {
return $contest;
}
$stmt = parent::$conn->prepare("SELECT contest_name, contest_desc FROM contest GROUP BY contest_name, contest_desc ORDER BY COUNT(*) ASC, RAND() LIMIT 1");
$randcontest = new contest($stmt);
if (!$randcontest->found()) {
return new contest(['name' => 'Placeholder', 'desc' => '-']);
}
return new contest(['name' => $randcontest->name, 'desc' => $randcontest->desc]);
}
?>
<div id="contests">
<?php
echo $contest->count();
?>
contests found <?php
if ($max == 10) {
?>
(10 newest shown - <a href="/manage/contest/all">click here to show all</a>)<?php
}
?>
</div>
<?php
while ($contest->found() && $i++ < $max) {
?>
<div id="<?php
echo $i;
?>
">
<?php
if ($contest->start == 0) {
echo $contest->name, ': ', $contest->desc, ' [queued]';
} else {
if ($contest->end == 0) {
echo $contest->name, ': ', $contest->desc, ' [active since ', date('H:i:s d-m-Y', $contest->start), ']';
} else {
echo $contest->name, ': ', $contest->desc, ' [', date('H:i:s d-m-Y', $contest->start), '] to [', date('H:i:s d-m-Y', $contest->end), ']';
$medal = $contest->medal();
while ($medal->found()) {
