} 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();