function show_page()
{
// If the Registration page does not exist, add it
if (DB::queryFirstField('SELECT COUNT(*) FROM pages WHERE page_id="-1"') == 0) {
$new_order_num = DB::queryFirstField('SELECT (MIN(order_num) - 1) AS new_order FROM pages');
DB::insert('pages', array('page_id' => '-1', 'name' => 'Registration', 'content' => '', 'order_num' => $new_order_num));
}
lmt_page_header('Page List');
$delete_alert = fetch_alert('deletePage');
echo <<<HEREDOC
<h1>Page List</h1>
{$delete_alert}
<a href="Add"><img src="../../../res/icons/add.png" alt="+" /> Add a Page</a><br />
<a href="Add_Separator?xsrf_token={$_SESSION['xsrf_token']}"><img src="../../../res/icons/add.png" alt="+" /> Add a Separator</a><br />
<br />
<h4 class="smbottom">Pages</h4>
HEREDOC;
$table = lmt_db_table('SELECT page_id, name, order_num FROM pages ORDER BY order_num', array('name' => ''), array('<img src="../../../res/icons/eye.png" alt="View" />' => 'View?ID={page_id}', '<img src="../../../res/icons/edit.png" alt="Edit" />' => 'Edit?ID={page_id}', '<img src="../../../res/icons/delete.png" alt="Delete" />' => 'Delete?ID={page_id}'), 'No Pages', 'contrasting indented', array('page' => 'Order', 'field' => 'page_id'));
//Make the Separators come out nicely
$search = '#<td></td>(\\s+)<td><a href="View\\?ID=(\\d+)"><img src="../../../res/icons/eye.png" alt="View" /></a></td>(\\s+)<td><a href="Edit\\?ID=(\\d+)"><img src="../../../res/icons/edit.png" alt="Edit" /></a></td>(\\s+)<td><a href="Delete\\?ID=(\\d+)"><img src="../../../res/icons/delete.png" alt="Delete" /></a></td>(\\s+)</tr>#';
$replace = '<td>[Separator]</td>${1}<td></td>${1}<td></td>${1}<td><a href="Delete_Separator?ID=${2}&xsrf_token=' . $_SESSION['xsrf_token'] . '"><img src="../../../res/icons/delete.png" alt="Delete" /></a></td>${1}</tr>';
$table = preg_replace($search, $replace, $table);
// Make Registration uneditable
$search = '#<td><a href="View\\?ID=-1"><img src="../../../res/icons/eye.png" alt="View" /></a></td>(\\s+)<td><a href="Edit\\?ID=-1"><img src="../../../res/icons/edit.png" alt="Edit" /></a></td>(\\s+)<td><a href="Delete\\?ID=-1"><img src="../../../res/icons/delete.png" alt="Delete" /></a></td>(\\s+)</tr>#';
$replace = '<td></td>${1}<td></td>${1}<td></td>${1}</tr>';
$table = preg_replace($search, $replace, $table);
echo $table;
}
function show_logged_in_page()
{
//If there's no such school, we're in the middle of adding it or something.
if (DB::queryFirstField('SELECT COUNT(*) FROM teams WHERE school=%i', $_SESSION['LMT_user_id']) == 0) {
header('Location: Team?Add');
die;
}
lmt_page_header('Team Registration');
$lmt_year = htmlentities(map_value('year'));
$school_name = htmlentities($_SESSION['LMT_school_name']);
$table = lmt_db_table('SELECT team_id, name, school, (SELECT COUNT(*) FROM individuals WHERE individuals.team = teams.team_id AND individuals.deleted="0")' . ' AS size FROM teams WHERE school="' . mysqli_real_escape_string(DB::get(), $_SESSION['LMT_user_id']) . '" AND deleted="0" ORDER BY size, name', array('name' => 'Name', 'size' => 'Size'), array('<img src="../../res/icons/edit.png" alt="Edit" />' => 'Team?Edit={team_id}', '<img src="../../res/icons/delete.png" alt="Delete" />' => 'Team?Delete={team_id}'), 'No Teams', 'contrasting indented');
echo <<<HEREDOC
<h1>Team Registration</h1>
<h3 class="smbottom">Teams for {$school_name}</h3>
<span class="small"> <a href="Team?Add">Add a Team</a> | <a href="Signout">Sign Out</a></span><br /><br />
{$table}
HEREDOC;
}
function show_delete_page()
{
lmt_page_header('Remove Team');
$team_name = htmlentities(DB::queryFirstField('SELECT name FROM teams WHERE team_id=%i AND school=%i', $_GET['Delete'], $_SESSION['LMT_user_id']));
$school_name = htmlentities($_SESSION['LMT_school_name']);
$members = lmt_db_table('SELECT name, grade FROM individuals WHERE team="' . mysqli_real_escape_string(DB::get(), $_GET['Delete']) . '" ORDER BY name', null, null, 'None', 'contrasting');
echo <<<HEREDOC
<h1>Remove a Team</h1>
<form method="post" action="{$_SERVER['REQUEST_URI']}">
<div>
Are you sure that you want to remove this team?
<div class="halfbreak"></div>
<input type="hidden" name="xsrf_token" value="{$_SESSION['xsrf_token']}" />
<input type="submit" name="lmt_do_reg_delete" value="Remove" />
<a href="Home">Cancel</a>
</div>
</form>
<br /><br />
<table class="smbottom">
<tr>
<td>School:</td>
<td><span class="b">{$school_name}</span></td>
</tr><tr>
<td>Team Name: </td>
<td><span class="b">{$team_name}</span></td>
</tr><tr>
<td>Members:</td>
<td>{$members}</td>
</tr>
</table>
HEREDOC;
die;
}
