function content() { if (isset($_GET['event'])) { $event = new Event($_GET['event']); showReport($event); } else { eventList(); } }
function content() { $event = NULL; if (isset($_GET['name'])) { $event = new Event($_GET['name']); eventForm($event); } elseif (strcmp($_POST['mode'], "Create New Event") == 0) { if (Player::getSessionPlayer()->isHost()) { if (isset($_POST['insert'])) { insertEvent(); eventList(); } else { eventForm(); } } else { authFailed(); } } elseif (strcmp($_GET['mode'], "create") == 0) { eventForm(); } elseif (isset($_POST['name'])) { $event = new Event($_POST['name']); if (!$event->authCheck($_SESSION['username'])) { authFailed(); } else { if (strcmp($_POST['mode'], "Parse DCI Files") == 0) { dciInput(); } elseif (strcmp($_POST['mode'], "Auto-Input Event Data") == 0) { autoInput(); } elseif (strcmp($_POST['mode'], "Update Registration") == 0) { updateReg(); } elseif (strcmp($_POST['mode'], "Update Match Listing") == 0) { updateMatches(); } elseif (strcmp($_POST['mode'], "Update Medals") == 0) { updateMedals(); } elseif (strcmp($_POST['mode'], "Upload Trophy") == 0) { if (insertTrophy()) { $event->hastrophy = 1; } } elseif (strcmp($_POST['mode'], "Update Event Info") == 0) { $event = updateEvent(); } eventForm($event); } } else { echo "<table style=\"border-width: 0px;\" align=\"center\">"; echo "<tr><td>"; echo "<form action=\"event.php\" method=\"post\">"; echo "<input type=\"submit\" name=\"mode\" value=\"Create New Event\">"; echo "</form></td><td>"; echo "<form action=\"format.php\" method=\"post\">"; echo "<input type=\"submit\" name=\"mode\" value=\"View/Add Formats\">"; echo "</form></td></tr>"; echo "</table><br><br>"; eventList($_POST['series'], $_POST['season']); } }
<?php session_start(); include 'lib.php'; print_header("Event Report"); ?> <div class="grid_10 prefix_1 suffix_1"> <div id="gatherling_main" class="box"> <div class="uppertitle"> Event Report </div> <?php if (isset($_GET['event'])) { $event = new Event($_GET['event']); showReport($event); } else { eventList(); } ?> </div> </div> <?php print_footer(); ?> <?php function eventList($series = "", $season = "") { $db = Database::getConnection(); $result = $db->query("SELECT e.name AS name, e.format AS format,\n COUNT(DISTINCT n.player) AS players, e.host AS host, e.start AS start,\n e.finalized, e.cohost, e.series, e.season\n FROM events e\n LEFT OUTER JOIN entries AS n ON n.event = e.name\n WHERE 1=1 AND e.start < NOW() GROUP BY e.name ORDER BY e.start DESC");
function content() { $event = NULL; // Prevent surplufous warnings. TODO: fix the code so we don't try to access these if unset. if (!isset($_GET['action'])) { $_GET['action'] = ''; } if (!isset($_POST['mode'])) { $_POST['mode'] = ''; } if (!isset($_GET['mode'])) { $_GET['mode'] = ''; } if (!isset($_GET['series'])) { $_GET['series'] = ''; } if (!isset($_GET['season'])) { $_GET['season'] = ''; } $player = Player::getSessionPlayer(); if ((isset($_GET['name']) || isset($_POST['name'])) && !mode_is("Create New Event")) { if (isset($_POST['name'])) { $eventname = $_POST['name']; } else { $eventname = $_GET['name']; } $event = new Event($eventname); } // if -- can create new events if (Player::getSessionPlayer()->isSteward()) { if (mode_is("Create New Event")) { if (isset($_POST['insert'])) { $event = insertEvent(); eventForm($event); } else { eventForm(); } return; } elseif (mode_is("Create Next Event")) { $oldevent = new Event($_POST['name']); $newevent = new Event(""); $newevent->season = $oldevent->season; $newevent->number = $oldevent->number + 1; $newevent->format = $oldevent->format; $newevent->start = strftime("%Y-%m-%d %H:00:00", strtotime($oldevent->start) + 86400 * 7); $newevent->kvalue = $oldevent->kvalue; $newevent->finalized = 0; $newevent->player_editdecks = 1; $newevent->player_reportable = $oldevent->player_reportable; $newevent->prereg_allowed = $oldevent->prereg_allowed; $newevent->series = $oldevent->series; $newevent->host = $oldevent->host; $newevent->cohost = $oldevent->cohost; $newevent->mainrounds = $oldevent->mainrounds; $newevent->mainstruct = $oldevent->mainstruct; $newevent->finalrounds = $oldevent->finalrounds; $newevent->finalstruct = $oldevent->finalstruct; $newevent->name = sprintf("%s %d.%02d", $newevent->series, $newevent->season, $newevent->number); eventForm($newevent, true); return; } else { if (!isset($event)) { if (!isset($_POST['series'])) { $_POST['series'] = ''; } if (!isset($_POST['season'])) { $_POST['season'] = ''; } eventList($_POST['series'], $_POST['season']); } } } if ($event && $event->authCheck($player)) { if (strcmp($_GET['action'], "undrop") == 0) { $event->undropPlayer($_GET['player']); } if (mode_is("Start Event")) { $event->active = 1; $event->save(); $entries = $event->getEntries(); Standings::startEvent($entries, $event->name); $event->pairCurrentRound(); } if (mode_is("Recalculate Standings")) { $structure = $event->mainstruct; $event->recalculateScores($structure); Standings::updateStandings($event->name, $event->mainid, 1); } if (mode_is("Reset Event")) { $event->resetEvent(); } if (mode_is("Delete Matches and Re-Pair Round")) { $event->repairRound(); } if (mode_is("Reactivate Event")) { $event->active = 1; $event->player_editdecks = 1; $event->finalized = 0; $event->save(); } if (mode_is("Assign Medals")) { $event->assignMedals(); } if (mode_is("Parse DCI Files")) { dciInput(); } elseif (mode_is("Parse DCIv3 Files")) { dci3Input(); } elseif (mode_is("Auto-Input Event Data")) { autoInput(); } elseif (mode_is("Update Registration")) { updateReg(); } elseif (mode_is("Update Match Listing")) { updateMatches(); } elseif (mode_is("Update Medals")) { updateMedals(); } elseif (mode_is("Update Adjustments")) { updateAdjustments(); } elseif (mode_is("Upload Trophy")) { if (insertTrophy()) { $event->hastrophy = 1; } } elseif (mode_is("Update Event Info")) { $event = updateEvent(); } eventForm($event); } else { authFailed(); } }
function saveEvent($time, $title, $comment, $color = '', $shortname = '', $tags) { global $webdir; $json = new Services_JSON(); $time = mystrtotime($time, 'event'); if (!$time) { return $json->encode(array('ERROR', 'Your time sucked.')); } $user = $_SERVER['PHP_AUTH_USER']; $dbcs = 'sqlite:' . $webdir . '/events.db'; try { $db = new PDO($dbcs); } catch (PDOException $e) { return; } // save the event //sqlite> insert into events values (NULL, 1239717600, 'EMERGENCY LOAD TEST2','a 2nd comment','sam','#ffffff','elt2'); $sql = 'INSERT INTO events VALUES (NULL,?,?,?,?,?,?)'; $sth = $db->prepare($sql); $x = array($time, $title, $comment, $user, $color, $shortname); $ret = $sth->execute($x); if (!$ret) { return $json->encode(array('ERROR', 'EMERGENCY LOAD TEST (something bad happened... possibly a duplicate shortname?)')); } $eventid = $db->lastInsertId(); // maybe save each tag $tags = split(' ', $tags); foreach ($tags as $tag) { $tag = trim($tag); if (empty($tag)) { continue; } $sql = 'INSERT INTO tags VALUES (NULL,?)'; $sth = $db->prepare($sql); $x = array($tag); $ret = $sth->execute($x); if ($ret) { $ids[] = $db->lastInsertId(); } else { $sql = 'SELECT id FROM tags WHERE tag = ?'; $sth = $db->prepare($sql); $ret = $sth->execute($x); if ($ret) { $zz = $sth->fetch(); $ids[] = $zz[0]; } } } $sql = 'INSERT INTO t2e VALUES(?,?)'; foreach ($ids as $id) { $sth = $db->prepare($sql); $x = array($id, $eventid); $ret = $sth->execute($x); } $eventlist = eventList(); $eventtags = eventTagList(); return '{ "eventlist":' . $eventlist . ', "eventtags":' . $eventtags . '}'; }