<?php //Put non UI logic in a difference file include 'attendance.logic.php'; $lan = new Lan_events(); $success = $lan->get(getCurrentLID()); $state = "notsignedup"; if ($success) { $lan->text = str_replace("\\n", "\n", $lan->text); $lan->text = str_replace("\\r", "\r", $lan->text); $master->Smarty->assign("lan", $lan); $attendees = new Lan_attendees(); $user = new Lan_users(); $attendees->lan_id = getCurrentLID(); $attendees->joinAdd($user); $attendees->orderBy('username'); $attendees->find(); $attendeeslist = array(); while ($attendees->fetch()) { if (streq(getCurrentUID(), $attendees->user_id)) { $state = "signedup"; } $sold = new Lan_addons_sold(); $sold->lan_id = getCurrentLID(); $sold->user_id = $attendees->user_id; $sold->find(); $soldlists = array(); while ($sold->fetch()) { $g = new Lan_addons_groups(); $g->get($sold->addon_id); $soldlists[] = $g->name;
} } else { $master->Smarty->assign("message", "Unknown LAN selected."); break; } } break; case 'removeme': if (streq("0", getCurrentUID())) { $master->Smarty->assign("message", "Anonymous users cannot unregister."); break; } else { $lan = new Lan_events(); $success = $lan->get(getCurrentLID()); if ($success) { $attendees = new Lan_attendees(); $attendees->lan_id = getCurrentLID(); $attendees->user_id = getCurrentUID(); if ($attendees->count() == 0) { $master->Smarty->assign("message", "Oddly enough your already not signed up to this event!"); break; } else { $attendees->delete(); $master->Smarty->assign("message", "Removed your sign up!"); logMessage(getCurrentUID(), 0, "User is no longer attending LAN " . $lan->name . " [" . $lan->id . "]"); //check if they have any seats for this lan, if so remove them. $seat = new Lan_seats(); $seat->user_id = getCurrentUID(); $seat->lan_id = getCurrentLID(); if ($seat->find()) { $seat->delete();
$fdate = strftime("%Y-%m-%d %H:%M:00", $date); return $fdate; } function convertDateOut($data) { $date = strtotime($data); $fdate = strftime("%d/%m/%Y %H:%M", $date); return $fdate; } $lan = new Lan_events(); if (isset($_GET["id"])) { if ($lan->get($lan->escape($_GET["id"]))) { $lan->start = convertDateOut($lan->start); $lan->end = convertDateOut($lan->end); // Get attendees $attendees = new Lan_attendees(); $attendees->lan_id = $lan->id; $attendees->find(); $attendeeslist = array(); $Frontend = new FrontEnd(); $allusers = $Frontend->getAllUsers(); while ($attendees->fetch()) { // Get tickets for the attendee $sold = new Lan_addons_sold(); $sold->lan_id = $lan->id; $sold->user_id = $attendees->user_id; $sold->find(); $soldlists = array(); while ($sold->fetch()) { $g = new Lan_addons_groups(); $g->get($sold->addon_id);
$master->Smarty->assign("teams", $teams); //Admin: Find all attending players not currently in a team $addableusers = array(); $attendees = new Lan_attendees(); $users = new Lan_users(); $teams = new Lan_timetable_teams(); $signups = new Lan_timetable_signups(); $members = new Lan_timetable_team_members(); $attendees->query("SELECT DISTINCT ({$users->__table}.user_id), {$users->__table}.username " . "FROM {$attendees->__table} " . "LEFT JOIN {$users->__table} ON {$attendees->__table}.user_id = {$users->__table}.user_id " . "WHERE {$attendees->__table}.user_id NOT IN (" . "SELECT DISTINCT ( user_id) " . "FROM {$teams->__table} CENTER JOIN {$members->__table} " . "WHERE timetable_id = '{$biggame->id}' )" . "AND username IS NOT NULL"); while ($attendees->fetch()) { $addableusers[] = clone $attendees; } $master->Smarty->assign("addableusers", $addableusers); //Captain: Find all pug players $addableusers = array(); $attendees = new Lan_attendees(); $users = new Lan_users(); $teams = new Lan_timetable_teams(); $signups = new Lan_timetable_signups(); $members = new Lan_timetable_team_members(); $attendees->query("SELECT {$users->__table}.user_id, {$users->__table}.username " . "FROM {$signups->__table} " . "LEFT JOIN {$users->__table} ON {$signups->__table}.user_id = {$users->__table}.user_id " . "WHERE {$signups->__table}.user_id NOT IN (" . "SELECT DISTINCT ( user_id) " . "FROM {$teams->__table} CENTER JOIN {$members->__table} " . "WHERE timetable_id = '{$biggame->id}' )" . "AND username IS NOT NULL " . "AND {$signups->__table}.timetable_id = '{$biggame->id}'"); while ($attendees->fetch()) { $addableusers[] = clone $attendees; } $master->Smarty->assign("pugplayers", $addableusers); } $master->Smarty->assign("currentUserSignedUp", $currentUserSignedUp); $biggame->occurs = date("l jS H:i", strtotime($biggame->occurs)); $master->Smarty->assign("biggame", $biggame); //$master->Smarty->assign("signups",$list); return;
$seat = new lan_seats(); $seat->user_id = $user->user_id; $seat->lan_id = getCurrentLID(); $seat->find(); if ($seat->fetch()) { $master->Smarty->assign("seat", $seat); } } //Find if arrived $arrivals = new Lan_arrivals(); $arrivals->user_id = $user->user_id; $arrivals->lan_id = getCurrentLID(); $master->Smarty->assign("arrived", $arrivals->count() != 0); //List attended Lans $lans = array(); $attendance = new Lan_attendees(); $event = new Lan_events(); $attendance->joinAdd($event); $attendance->user_id = $user->user_id; $attendance->find(); while ($attendance->fetch()) { $attendance->start = date("jS F y", strtotime($attendance->start)); $lans[] = clone $attendance; } $master->Smarty->assign("attendance", $lans); } else { $master->AddError("Unknown user!"); } } else { $master->AddError("No user ID passed!"); }
break; case "addseat": if (isset($_GET["lan"])) { //return; $seats = new Lan_seats(); $seats->lan_id = $seats->escape($_GET["lan"]); $seats->x = 20; $seats->y = 20; $seats->seat_name = ""; $seats->type = 0; $seats->insert(); } break; case "getusers": if (isset($_GET["lan"])) { $users = new Lan_attendees(); $seats = new Lan_seats(); $lanid = $users->escape($_GET["lan"]); $user_id = $users->escape($_GET["user_id"]); $applicable = array(); $Frontend = new FrontEnd(); $users->query("SELECT * FROM {$users->__table} WHERE `lan_id` = " . $lanid . " AND `user_id` NOT IN (SELECT `user_id` FROM {$seats->__table} WHERE `lan_id` = '" . $lanid . "') "); echo "<option value=\"0\"></option>"; if ($user_id != '0') { $applicable[$user_id] = $Frontend->getName($user_id); } while ($users->fetch()) { $applicable[$users->user_id] = $Frontend->getName($users->user_id); } foreach ($applicable as $key => $val) { echo "<option value=\"" . $key . "\">" . $val . "</option>";
case 'remu': // Get tickets for the attendee $user = new Lan_attendees(); $success = $user->get($user->escape($_GET["tid"])); $lan = new Lan_events(); $lan->get($lan->escape($_GET["id"])); if ($success) { $Frontend = new FrontEnd(); logMessage($Frontend->getUserId(), 0, "Removed attendance for " . $Frontend->getName($user->user_id) . "' from " . $lan->name . " [" . $lan->id . "]"); $user->delete(); } break; } } if (isset($_POST["user"]) && isset($_POST["lan"])) { $newuser = new Lan_attendees(); $newuser->lan_id = $newuser->escape($_POST["lan"]); $newuser->user_id = $newuser->escape($_POST["user"]); $newuser->insert(); $Frontend = new FrontEnd(); $lan = new Lan_events(); $lan->get($lan->escape($_GET["id"])); logMessage($Frontend->getUserId(), 0, "Added attendee " . $Frontend->getName($newuser->user_id) . " at " . $lan->name); } if (isset($_POST["lanid"]) && isset($_POST["ticket"])) { $newticket = new Lan_addons_sold(); $newticket->lan_id = $newticket->escape($_POST["lanid"]); $newticket->user_id = $newticket->escape($_POST["user"]); $newticket->addon_id = $newticket->escape($_POST["ticket"]); $newticket->insert(); $lan = new Lan_events();
<?php if (isset($_GET["action"])) { switch ($_GET["action"]) { case 'sit': $lan = new Lan_events(); $lan->get(getCurrentLID()); $attendees = new Lan_attendees(); $attendees->lan_id = getCurrentLID(); $attendees->user_id = getCurrentUID(); if ($attendees->count() == 0) { $master->AddWarning("You are not signed up to this LAN."); break; } else { $allowSeating = false; $tickets = new Lan_addons_sold(); $tickets->user_id = getCurrentUID(); $tickets->lan_id = $lan->id; $ticktypes = new Lan_addons_groups(); $tickets->joinAdd($ticktypes, "LEFT"); $tickets->selectAs($ticktypes, 'type_%s'); $tickets->find(); $a = array(); while ($tickets->fetch()) { if (0 == strcmp($tickets->type_allowSeating, '1')) { $allowSeating = true; } } if ($allowSeating) { $exseat = new Lan_seats(); $exseat->user_id = getCurrentUID();