$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; } }