示例#1
0
<?php

require SCRIPTROOT . 'jamstates.php';
$stmt = $dbconnection->prepare('SELECT * FROM jams ORDER BY suggestionsbegin DESC;');
$stmt->execute();
$rows = $stmt->fetchAll();
$jams = array();
foreach ($rows as $row) {
    $jam = array();
    $jam['id'] = $row['id'];
    $jam['title'] = $row['title'];
    $jam['status'] = $row['status'];
    $jam['suggestionsbegin'] = SuggestionsBegin($row);
    $jam['votingbegins'] = VotingBegins($row);
    $jam['themeannounce'] = ThemeAnnounce($row);
    $jam['jambegins'] = JamBegins($row);
    $jam['submissionsbegin'] = SubmissionsBegin($row);
    $jam['submissionsend'] = SubmissionsEnd($row);
    $jam['judgingends'] = JudgingEnds($row);
    array_push($jams, $jam);
}
SendResponse($jams);
示例#2
0
function JamRemainingTime($Jam)
{
    if ($Jam['status'] == JamStatus::Disabled || $Jam['status'] == JamStatus::Complete) {
        return 0;
    } else {
        if ($Jam['status'] == JamStatus::Judging) {
            return JudgingEnds($Jam) - time();
        } else {
            if ($Jam['status'] == JamStatus::ReceivingGameSubmissions) {
                return SubmissionsEnd($Jam) - time();
            } else {
                if ($Jam['status'] == JamStatus::JamRunning) {
                    return SubmissionsBegin($Jam) - time();
                } else {
                    if ($Jam['status'] == JamStatus::ThemeAnnounced) {
                        return JamBegins($Jam) - time();
                    } else {
                        if ($Jam['status'] == JamStatus::ThemeVoting) {
                            return ThemeAnnounce($Jam) - time();
                        } else {
                            if ($Jam['status'] == JamStatus::WaitingThemeApprovals) {
                                return VotingBegins($Jam) - time();
                            } else {
                                if ($Jam['status'] == JamStatus::ReceivingSuggestions) {
                                    return ApprovalsBegin($Jam) - time();
                                } else {
                                    if ($Jam['status'] == JamStatus::WaitingSuggestionsStart) {
                                        return SuggestionsBegin($Jam) - time();
                                    }
                                }
                            }
                        }
                    }
                }
            }
        }
    }
}