$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));
// break;
case 'food':
if (isset($_GET["tid"])) {
$user = new Lan_users();
$biggame->joinAdd($user, "LEFT");
if ($biggame->get($biggame->escape($_GET["tid"]))) {
$biggame->fetch();
//Find sign ups
$tts = new Lan_timetable_signups();
$user = new Lan_users();
$tts->joinAdd($user);
$tts->timetable_id = $biggame->id;
$list = array();
$tts->find();
$currentUserSignedUp = false;
$signups = 0;
while ($tts->fetch()) {
if (streq($tts->user_id, getCurrentUID())) {
$currentUserSignedUp = true;
}
$list[] = clone $tts;
$signups++;
}
$biggame->signups = $signups;
$game = new Lan_games();
if (1 == $game->get($biggame->game)) {
$master->Smarty->assign("image", "images/games/" . $game->picture);
$master->Smarty->assign("gamename", $game->name);
}
$biggame->occurs = date("l jS H:i", strtotime($biggame->occurs));
$master->Smarty->assign("currentUserSignedUp", $currentUserSignedUp);
$master->Smarty->assign("foodrun", $biggame);
$master->Smarty->assign("signups", $list);
$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;
}
}
<?php
include_once 'core.php';
include 'skins/' . Config::$theme . '/setup.php';
include_once 'integration/integration.php';
//Pull through user ID
$frontend = new FrontEnd();
setCurrentUser($frontend->getUserId());
startSession(getCurrentUID(), $frontend->getName(getCurrentUID()));
//Check user is in db and run checks.
$frontend->pullUserInfo(getCurrentUID());
$frontend->checkGroups(getCurrentUID(), getCurrentLID());
$frontend->disconnect();
$page = new Lan_pages();
$page->name = GETSafe('page');
$page->find();
if ($page->fetch()) {
$file = 'modules/' . $page->module . '/' . $page->file . '.php';
if (file_exists($file)) {
include $file;
$master->RenderPage($page->module . '.' . $page->file . '.htm');
} else {
$master->AddError("The file for this page does not exist!");
}
} else {
$master->AddError("Unknown page!");
}
if ($master->HasFatalError()) {
$master->RenderPage('error.htm');
}
$master->RenderSite('master.integration.htm');
function parseForm($id = null)
{
global $master;
$titem = new Lan_timetable();
if ($id != null) {
$titem->get($titem->escape($id));
}
if (isset($_POST["game"])) {
$titem->game = $titem->escape($_POST["game"]);
if (strlen($_POST["othergame"]) != 0) {
$titem->game = 0;
}
}
$titem->lan_id = getCurrentLID();
//$titem->owner
$titem->type = $titem->escape($_POST["eventtype"]);
$titem->occurs = strftime("%Y-%m-%d %H:%M:00", getLanTime("when"));
// "2010-06-05 19:41:54";//$titem->escape($_POST["when"]);
//var_dump($titem->occurs);
//die();
if (isset($_POST["eventname"])) {
$titem->eventname = $titem->escape($_POST["eventname"]);
}
if (isset($_POST["othergame"])) {
$titem->othergame = $titem->escape($_POST["othergame"]);
}
if (isset($_POST["maxplayers"])) {
$titem->maxplayers = $titem->escape($_POST["maxplayers"]);
}
if (isset($_POST["minplayers"])) {
$titem->minplayers = $titem->escape($_POST["minplayers"]);
}
if (isset($_POST["details"])) {
$titem->details = addslashes($_POST["details"]);
}
if ($master->checkUserIsAdmin() && isset($_POST["official"])) {
$titem->userevent = 0;
} else {
$titem->userevent = 1;
}
if (isset($_POST["usesignups"])) {
$titem->allowsignups = 1;
} else {
$titem->allowsignups = 0;
}
if (isset($_POST["maxmembers"])) {
$titem->teamsize = $titem->escape($_POST["maxmembers"]);
} else {
$titem->teamsize = 0;
}
if (isset($_POST["teams"]) && streq("yes", $_POST["teams"])) {
$titem->teambased = 1;
} else {
$titem->teambased = 0;
}
if ($master->checkUserIsAdmin() && isset($_POST["organiser"])) {
$titem->owner = $titem->escape($_POST["organiser"]);
} else {
$titem->owner = getCurrentUID();
}
return $titem;
}
$tickets = new Lan_addons_events();
$tickets->lan_id = getCurrentLID();
$tickets->find();
$ticketlists = array();
while ($tickets->fetch()) {
$group = new Lan_addons_groups();
$group->get($tickets->addon_id);
$tickets->name = $group->name;
$tickets->price = $group->price;
if ($group->availible == 1) {
$ticketlists[] = clone $tickets;
}
}
$master->Smarty->assign("ticketlists", $ticketlists);
} else {
$master->AddError("Unknown LAN?");
return;
}
$master->Smarty->assign("id", $lan->id);
if (0 == strcmp($state, "hasticket")) {
$seat = new Lan_seats();
$seat->lan_id = getCurrentLID();
$seat->user_id = getCurrentUID();
if (0 != $seat->count()) {
$state = "hasseat";
}
}
if (streq(getCurrentLID(), '0')) {
$state = "anon";
}
$master->Smarty->assign("state", $state);
$userlist[] = clone $user;
}
$master->Smarty->assign("userlist", $userlist);
$tt->details = stripslashes($tt->details);
$master->Smarty->assign("event", $tt);
$game = new Lan_games();
if (!$logoAssigned && 1 == $game->get($tt->game)) {
$master->Smarty->assign("image", "images/games/" . $game->picture);
}
setupLanTime("when", $tt->occurs, $master->Smarty);
} else {
$error = "Unknown event.";
}
} else {
if (!isset($_POST["submitBtn"])) {
$event = new Lan_timetable();
$event->owner = getCurrentUID();
$master->Smarty->assign("event", $event);
setupLanTime("when", null, $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);
}
}
//$master->Smarty->assign("_page",file_get_contents("skins/" . Config::$theme . "/lantime.htm"));
if (!streq($biggame->game, "0")) {
$link = "http://apps.metacritic.com/search/process?ty=3&ts=" . $game->name . "&tfs=game_title&sb=0&game_platform=PC&x=11&y=6&release_date_s=";
$link = str_replace(" ", "+", $link);
$master->Smarty->assign("gameinfolink", $link);
}
}
if (streq("1", $biggame->teambased)) {
$teams = array();
$team = new Lan_timetable_teams();
$team->timetable_id = $biggame->id;
$team->find();
while ($team->fetch()) {
$team->PopulateMembers();
$team->userinteam = false;
foreach ($team->members as $member) {
if (streq($member->user_id, getCurrentUID())) {
$currentUserSignedUp = "team";
$team->userinteam = true;
}
}
$teams[] = clone $team;
}
$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");
<?php
if (isset($_POST["Update"])) {
$frontend = new FrontEnd();
$user = new Lan_users();
$id = POSTSafe("userid");
if ($user->get($id)) {
$currentpassword = $frontend->encryptPassword(POSTSafe("currentpass"));
if (streq($currentpassword, $user->password)) {
if (strlen(POSTSafe("newpass")) > 0) {
$user->password = $frontend->encryptPassword(POSTSafe("newpass"));
}
$user->steamprofile = POSTSafe("steamprofile");
$user->updateSteamData();
$user->update();
//Reset session if we are changing the current user, so we make sure the session has the latest data.
if (streq(getCurrentUID(), $user->user_id)) {
startSession($user->user_id, $user->username);
}
} else {
$master->AddWarning("Incorrect current password!");
}
}
}
<?php
include 'editprofile.logic.php';
$userid = getCurrentUID();
if (isset($_GET["uid"])) {
$userid = GETSafe("uid");
}
if (streq("0", $userid)) {
$master->AddError("You must login to edit your profile!");
} else {
$user = new Lan_users();
if ($user->get($userid)) {
$master->Smarty->assign("theuser", $user);
} else {
$master->AddError("Unknown user!");
}
}
$master->Smarty->Assign("qport", $qport);
$server = new Lan_servers();
$server->protocol = $protocol;
$server->address = $address;
$server->cport = $cport;
$server->qport = $qport;
if (strlen($cport) == 0) {
$master->Smarty->Assign("valerror", "You must enter a port!");
} else {
if (0 == $server->count()) {
$q = new GameServerQuery();
$server = $q->CheckPorts($server);
$server = $q->QueryServer($server);
if (streq($server->ping, "-1")) {
$master->Smarty->Assign("valerror", "Please check the information entered, I could not find a server at that location!");
} else {
$server->user_id = getCurrentUID();
$server->type = 0;
$server->lastupdated = strftime("%Y-%m-%d %H:%M:00", strtotime("yesterday"));
$key = $server->insert();
header("Location: ?page=editserver&sid=" . $key);
die;
}
} else {
$master->Smarty->Assign("valerror", "A server at this location already exists!");
}
}
} catch (Exception $e) {
$master->Smarty->Assign("valerror", $e->getMessage());
}
}
function SetupGroups()
{
//Get groups
$groups = array();
$group = new Lan_permission_groups();
//Setup system groups
//Anonymous == everyone
$groups[] = $group->FindGroupID("Anonymous");
//Are we logged in?
if (!streq(getCurrentUID(), "0")) {
$groups[] = $group->FindGroupID("Registered");
}
//Attending this lan?
$attendee = new lan_attendees();
$attendee->user_id = getCurrentUID();
$attendee->lan_id = getCurrentLID();
if ($attendee->count() != 0) {
$groups[] = $group->FindGroupID("Attending");
}
//Booked a place at this lan?
$booked = false;
$sold = new Lan_addons_sold();
$addon = new Lan_addons_groups();
$sold->joinAdd($addon);
$sold->user_id = getCurrentUID();
$sold->lan_id = getCurrentLID();
$sold->find();
while ($sold->fetch()) {
if (streq($sold->allowSeating, "1")) {
$groups[] = $group->FindGroupID("Booked");
break;
}
}
//Integration mode flag group.
//if(defined("_LANMAN_INTEGRATION"))
//$groups[] = $group->FindGroupID("Integration");
//Membership based groups
if (!streq(getCurrentUID(), "0")) {
$group = new lan_permission_groups();
$membership = new lan_permission_membership();
$group->user_group = 1;
$membership->user_id = getCurrentUID();
$group->joinAdd($membership);
$group->find();
while ($group->fetch()) {
$groups[] = $group->permgroup_id;
}
}
$_SESSION['groups'] = $groups;
}
break;
case 'quitteam':
$member = new Lan_timetable_team_members();
$member->user_id = getCurrentUID();
$member->team_id = $member->escape($_GET["team"]);
$error = $member->RemoveMember($member->escape($_GET["tid"]));
break;
case 'addmember':
$member = new Lan_timetable_team_members();
$member->user_id = $member->escape($_POST["user"]);
$member->team_id = $member->escape($_GET["team"]);
$error = $member->JoinTeam($member->escape($_GET["tid"]));
break;
case 'jointeam':
$member = new Lan_timetable_team_members();
$member->user_id = getCurrentUID();
$member->team_id = $member->escape($_GET["team"]);
$error = $member->JoinTeam($member->escape($_GET["tid"]));
break;
break;
case 'kick':
$member = new Lan_timetable_team_members();
$member->user_id = $member->escape($_GET["user"]);
$member->team_id = $member->escape($_GET["team"]);
$error = $member->RemoveMember($member->escape($_GET["tid"]));
break;
case 'promote':
$team = new Lan_timetable_teams();
if (0 == $team->get($team->escape($_GET["team"]))) {
$error = "Unknown team!";
}
$attendeeslist = array();
while ($attendees->fetch()) {
if ($attendees->user_id == null) {
$attendees->user_id = "0";
}
$attendeeslist[] = clone $attendees;
}
$master->Smarty->assign("attendees", $attendeeslist);
if (!streq('0', getCurrentUID())) {
$exseat = new Lan_seats();
$exseat->user_id = getCurrentUID();
$exseat->lan_id = getCurrentLID();
if (0 == $exseat->count()) {
$allowSeating = false;
$tickets = new Lan_addons_sold();
$tickets->user_id = getCurrentUID();
$tickets->lan_id = getCurrentLID();
$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) {
$master->Smarty->assign("state", "noseat");
}
} else {
logMessage(getCurrentUID(), 0, "User took seat " . $seat->seat_name . " at LAN " . $lan->name . " [" . $lan->id . "]");
}
}
} else {
$master->AddWarning("Invalid seat!");
}
} else {
$master->AddWarning("Invalid seat");
}
} else {
$master->AddWarning("You have no tickets which allow you to take a seat!");
}
break;
}
break;
case 'unsit':
$seat = new lan_seats();
$seat->lan_id = getCurrentLID();
$seat->user_id = getCurrentUID();
$seat->find();
if ($seat->fetch()) {
$seat->user_id = 0;
$seat->update();
$master->AddWarning("Removed your seat selection.");
logMessage(getCurrentUID(), 0, "User removed reservation on seat " . $seat->seat_name . " at LAN " . $lan->name . " [" . $lan->id . "]");
} else {
$master->AddWarning("There was a problem removing your seat selection.");
}
break;
}
}
