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