<?php include 'foodrun.logic.php'; $biggame = new Lan_timetable(); $biggame->type = "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);
$lan = new Lan_events(); $lanid = $lan->escape(getCurrentLID()); $success = $lan->get($lanid); if ($success) { $start = new Lan_timetable(); $start->when = date("D jS M H:i", strtotime($lan->start)); $start->type = 'start'; $start->diff = getDiffDateTime(strtotime($lan->start)); $start->datetime = strtotime($lan->start); $events[] = $start; $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;