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