$event = new Lan_timetable();
$event->lan_id = getCurrentLID();
$event->orderBy('"when" ASC');
$game = new Lan_games();
$event->selectAs($game, "game_%s");
$event->joinAdd($game, "LEFT");
$event->find();
while ($event->fetch()) {
$event->diff = getDiffDateTime(strtotime($event->occurs));
//Remove old events
if (strlen($event->diff) == 0) {
continue;
}
$users = new Lan_timetable_signups();
$users->timetable_id = $event->id;
$event->signups = $users->count();
$users->user_id = getCurrentUID();
if (getCurrentUID() == 0) {
$event->currentUserSignedUp = false;
} else {
$event->currentUserSignedUp = $users->count() != 0;
}
if (streq("1", $event->teambased)) {
$event->PopulateTeams();
}
$event->datetime = strtotime($event->occurs);
//Pull additional info based on type
switch ($event->type) {
// case 'start':
//case 'end':
// $event->when = date("D jS M G:i", strtotime($event->when));
$signup = new Lan_timetable_signups();
$signup->timetable_id = $biggame->id;
$signup->user_id = getCurrentUID();
if ($signup->count() == 0) {
$signup->insert();
} else {
$error = "You are already signed up to this event!";
}
} else {
$error = "Unknown big game?";
}
} else {
$error = "No event id set?";
}
}
break;
case "remsignup":
if (isset($_GET["tid"])) {
$signup = new Lan_timetable_signups();
$signup->timetable_id = $signup->escape($_GET["tid"]);
$signup->user_id = getCurrentUID();
$signup->find();
if ($signup->count() != 0) {
$signup->delete();
}
} else {
$error = "No event id set?";
}
break;
}
}
