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>";
}
$Frontend->disconnect();
// 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();
$lan->get($lan->escape($_GET["id"]));
