} else {
if (streq($_POST["submitBtn"], "Update")) {
//Update or switch type
$game = new Lan_games();
if (isset($_POST["game"]) && 1 == $game->get($game->escape($_POST["game"]))) {
$master->Smarty->assign("image", "images/games/" . $game->picture);
$logoAssigned = true;
} else {
$master->Smarty->assign("image", "images/games/other.png");
}
setupLanTime("when", strtotime($form->occurs), $master->Smarty);
$userlist = array();
$user = new Lan_users();
$attendees = new Lan_attendees();
$lanid = getCurrentLID();
$user->query("SELECT user_id,username FROM {$user->__table} WHERE {$user->__table}.user_id IN (SELECT user_id FROM {$attendees->__table} WHERE `lan_id` = '{$lanid}') ORDER BY user_id");
while ($user->fetch()) {
$userlist[] = clone $user;
}
$master->Smarty->assign("userlist", $userlist);
} else {
//Save
if (0 == strlen($form->id)) {
if (CheckPermission("timetable", "add event")) {
$form->insert();
} else {
$master->AddError("You do not have permissions to add events.");
break;
}
} else {
if (CheckPermission("timetable", "edit all events") || CheckPermission("timetable", "edit own event") && streq(getCurrentUID(), $form->owner)) {
$userlist = array();
$user = new Lan_users();
$attendees = new Lan_attendees();
$arrived = new Lan_arrivals();
$seat = new Lan_seats();
$filter = "current";
if (isset($_GET["filter"])) {
$filter = $_GET["filter"];
$master->Smarty->assign("filter", $filter);
}
switch ($filter) {
default:
case 'current':
$lanid = getCurrentLID();
$user->query("SELECT *, {$arrived->__table}.aid as arrived,{$seat->__table}.seat_name, {$seat->__table}.id as seat_id, {$user->__table}.user_id as userid FROM {$user->__table} LEFT JOIN {$arrived->__table} on {$arrived->__table}.user_id " . " = {$user->__table}.user_id LEFT JOIN {$seat->__table} on {$seat->__table}.user_id = {$user->__table}.user_id WHERE {$seat->__table}.lan_id = '{$lanid}' AND {$user->__table}.user_id IN (SELECT user_id FROM {$attendees->__table} WHERE `lan_id` = '{$lanid}') ORDER BY {$user->__table}.username");
while ($user->fetch()) {
if (strlen($user->arrived) == 0) {
$user->arrived = "No";
} else {
$user->arrived = "Yes";
}
//Pull tickets
$sold = new Lan_addons_sold();
$addon = new Lan_addons_groups();
$sold->whereAdd("user_id = {$user->user_id}");
//$sold->user_id ;
$sold->lan_id = getCurrentLID();
$sold->joinAdd($addon);
$sold->find();
$tickets = array();
