You are unauthorised to enter this site.\n"; exit; } else { if (($PHP_AUTH_USER != "rupert") || ($PHP_AUTH_PW != "ximian")) { Header("HTTP/1.0 401 Unauthorized"); echo "

You are unauthorised to enter this site.

\n"; exit; } } ?> Error - Problem deleting data in"; echo " helper table

"; echo "Please click "; echo "here"; echo " to reload this page, or your browser's Bacl key to try again."; } closedbconn(); } else { if (isset($delete_installee) and ereg("^[0-9]+$", $delete_installee)) { $sql = "DELETE FROM installees WHERE id = $delete_installee;"; # Now put this in the database @$connection = getdbconn(); if (!$connection) { echo "Whoops! an error occured connecting to the "; echo "LinuxSA database (for table installees). Sorry.\n"; closedbconn(); exit; } @$result = pg_exec ($connection, $sql); if (!$result) { echo "

Error - Cannot delete data in"; echo " installees table

"; echo "Please click "; echo "here"; echo " to reload this page, or your browser's Back key to try again."; } closedbconn(); } else { if (isset($delete_todo) and ereg("^[0-9]+$", $delete_todo)) { $sql = "DELETE FROM todo WHERE id = $delete_todo;"; # Now put this in the database @$connection = getdbconn(); if (!$connection) { echo "Whoops! an error occured connecting to the "; echo "LinuxSA database (for table todo). Sorry.\n"; closedbconn(); exit; } @$result = pg_exec ($connection, $sql); if (!$result) { echo "

Error - Cannot delete data in"; echo " todo table

"; echo "Please click "; echo "here"; echo " to reload this page, or your browser's Back key to try again."; } closedbconn(); } else { if ((isset($completed_todo) and ereg("^[0-9]+$", $completed_todo)) or (isset($uncompleted_todo) and ereg("^[0-9]+$", $uncompleted_todo))) { if (isset($completed_todo)) { $sql = "UPDATE todo SET completed = 'TRUE' where id = $completed_todo"; } else { $sql = "UPDATE todo SET completed = 'FALSE' where id = $uncompleted_todo"; } # Now put this in the database @$connection = getdbconn(); if (!$connection) { echo "Whoops! an error occured connecting to the "; echo "LinuxSA database (for table todo). Sorry.\n"; closedbconn(); exit; } @$result = pg_exec ($connection, $sql); if (!$result) { echo "

Error - Cannot delete data in"; echo " todo table

"; echo "Please click "; echo "here"; echo " to reload this page, or your browser's Back key to try again."; } closedbconn(); } else { if (isset($delete_minutes) and ereg("^[0-9]+$", $delete_minutes)) { $sql = "DELETE FROM minutes WHERE id = $delete_minutes;"; @$connection = getdbconn(); if (!$connection) { echo "Whoops! an error occured connecting to the "; echo "LinuxSA database (for table minutes). Sorry.\n"; closedbconn(); exit; } @$result = pg_exec ($connection, $sql); if (!$result) { echo "

Error - Cannot delete data in"; echo " minutes table

"; echo "Please click "; echo "here"; echo " to reload this page, or your browser's Back key to try again."; } closedbconn(); } else { if (isset($addtodo) || isset($addminutes)) { global $name; global $email; global $text; global $info; global $title; echo "

Adding todo or minutes item

\n"; if (((!$name) || (!$email) || (!$text)) && ((!$title) || (!$info))) { echo "

Sorry Unacceptable -

\n"; echo "
\n"; if (!$name) echo "You need to supply your name
\n"; if (!$email) echo "You need to supply your email
\n"; if (!$text) echo "You need to supply your todo item
\n"; if (!$title) echo "You need to supply your title item
\n"; if (!$info) echo "You need to supply your info item
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "Hit back on your browser window to re-enter data.\n"; } else { # Now put this in the database @$connection = getdbconn(); if (!$connection) { echo "Whoops! an error occured. Sorry.\n"; closedbconn(); } if (isset($addtodo)) { $name = addslashes($name); $email = addslashes($email); $text = addslashes($text); $sql = "INSERT INTO todo (name, email, text, completed) VALUES ('$name', '$email', '$text', 'FALSE')"; } else { if (isset($addminutes)) { $title = addslashes($title); $info = addslashes($info); $sql = "INSERT INTO minutes (title, info) VALUES ('$title', '$info')"; } } @$result = pg_exec ($connection, $sql); if (!$result) { echo "

Error - Could not add ToDo/Minutes item"; echo " - data lost.

"; echo "Please click "; echo "here"; echo " to reload this page, or your browser's Back key to try again."; } closedbconn(); } } } } } } } } function dumpInstalleeDB() { $connection = getdbconn(); if (!$connection) { echo "Whoops! an error occured. Sorry.\n"; } $sql = "select * from installees"; @$result = pg_exec ($connection, $sql); @$rows = pg_NumRows($result); echo "

Installees Database ($rows"; if ($rows == 1) { echo " person registered).

\n"; } else { echo " people registered).\n"; } if (!$result) { echo "

Error - no installees registered!?!

\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "
\n"; echo "

\n"; echo "\n"; echo "\n"; echo "\n"; closedbconn(); exit; } if ($rows > 0) { if (!isset($dumptext)) { echo "\n"; echo ""; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; } else { echo "Id\n"; echo " "; echo "First Name\n"; echo " "; echo "Last Name\n"; echo " "; echo "Email\n"; echo " "; echo "E-Waiver\n"; echo " "; echo "Paper Waiver
\n"; } for ($i=0; $i < $rows; $i++) { if (!isset($dumptext)) { echo "\n"; $id = pg_result($result, $i, "id"); echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; } else { echo pg_result($result, $i, "id"); echo " "; echo pg_result($result, $i, "firstname"); echo " "; echo pg_result($result, $i, "lastname"); echo " "; echo pg_result($result, $i, "email"); echo " "; echo pg_result($result, $i, "ewaiver"); echo " "; echo pg_result($result, $i, "paperwaiver"); echo "
\n"; } } closedbconn(); echo "

Delete?	Id	First Name	Last Name	Email	E-Waiver	Paper Waiver	Description
\n"; echo "\n"; echo "	\n"; echo $id; echo "	\n"; echo pg_result($result, $i, "firstname"); echo "	\n"; echo pg_result($result, $i, "lastname"); echo "	\n"; echo ""; echo pg_result($result, $i, "email"); echo "\n"; echo "	\n"; echo pg_result($result, $i, "ewaiver"); echo "	\n"; echo pg_result($result, $i, "paperwaiver"); echo "	\n"; echo pg_result($result, $i, "description"); echo "

\n"; echo "\n"; } } function dumpMinutes() { $connection = getdbconn(); if (!$connection) { echo "Whoops! an error occured. Sorry.\n"; closedbconn(); } $sql = "select * from minutes"; $result = pg_exec ($connection, $sql); $rows = pg_NumRows($result); echo "

Minutes Database ($rows"; if ($rows == 1) { echo " item registered).

\n"; } else { echo " items registered).\n"; } if (!$result) { echo "

Error - no minutes registered!?!

\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "
\n"; echo "

\n"; echo "\n"; echo "\n"; echo "\n"; exit; } if ($rows > 0) { if (!isset($dumptext)) { echo "\n"; echo ""; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; } else { echo "Id\n"; echo " "; echo "Title\n"; echo " "; echo "Info\n"; echo "
\n"; } for ($i=0; $i < $rows; $i++) { if (!isset($dumptext)) { echo "\n"; $id = pg_result($result, $i, "id"); echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; } else { echo pg_result($result, $i, "id"); echo " "; echo pg_result($result, $i, "title"); echo " "; echo pg_result($result, $i, "info"); echo "
"; } } closedbconn(); echo "

Delete?	Id	Title	Info
\n"; echo "\n"; echo "	\n"; echo $id; echo "	\n"; echo pg_result($result, $i, "title"); echo "	\n"; echo pg_result($result, $i, "info"); echo "

\n"; echo "\n"; } } function dumpHelpersDB() { $connection = getdbconn(); if (!$connection) { echo "Whoops! an error occured. Sorry.\n"; closedbconn(); } $sql = "select * from helpers"; @$result = pg_exec ($connection, $sql); @$rows = pg_NumRows($result); echo "

Helpers Database ($rows"; if ($rows == 1) { echo " person registered).

\n"; } else { echo " people registered).\n"; } if (!$result) { echo "

Error - no helpers registered!?!

\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "
\n"; echo "

\n"; echo "\n"; echo "\n"; echo "\n"; exit; } if ($rows > 0) { if (!isset($dumptext)) { echo "\n"; echo ""; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; } else { echo "Id\n"; echo " "; echo "First Name\n"; echo " "; echo "Last Name\n"; echo " "; echo "Email\n"; echo " "; echo "Offering\n"; echo "
\n"; } for ($i=0; $i < $rows; $i++) { if (!isset($dumptext)) { echo "\n"; $id = pg_result($result, $i, "id"); echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; } else { echo pg_result($result, $i, "id"); echo " "; echo pg_result($result, $i, "firstname"); echo " "; echo pg_result($result, $i, "lastname"); echo " "; echo pg_result($result, $i, "email"); echo " "; echo pg_result($result, $i, "offering"); echo "
"; } } closedbconn(); echo "

Delete?	Id	First Name	Last Name	Email	Offering	Install	Configure
\n"; echo "\n"; echo "	\n"; echo $id; echo "	\n"; echo pg_result($result, $i, "firstname"); echo "	\n"; echo pg_result($result, $i, "lastname"); echo "	\n"; echo ""; echo pg_result($result, $i, "email"); echo "\n"; echo "	\n"; echo pg_result($result, $i, "offering"); echo "	\n"; $temp = pg_result($result, $i, "install"); if ($temp == "") { echo "none\n"; } else { echo $temp; } echo "	\n"; $temp = pg_result($result, $i, "configure"); if ($temp == "") { echo "none\n"; } else { echo $temp; } echo "

\n"; echo "\n"; } } function dumpToDoDB() { $connection = getdbconn(); if (!$connection) { echo "Whoops! an error occured. Sorry.\n"; closedbconn(); } $sql = "select * from todo"; @$result = pg_exec ($connection, $sql); @$rows = pg_NumRows($result); echo "

ToDo Database ($rows"; if ($rows==1){ echo " item).

"; } else { echo " items)."; } if (!$result) { echo "

Error - no todo items registered!?!

\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "
\n"; echo "

\n"; echo "\n"; echo "\n"; echo "\n"; exit; } if ($rows > 0) { if (!isset($dumptext)) { echo "\n"; echo ""; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; } else { echo "Id\n"; echo " "; echo "Name\n"; echo " "; echo "Email\n"; echo " "; echo "Text\n"; echo " "; echo "Completed\n"; echo "
\n"; } for ($i=0; $i < $rows; $i++) { if (!isset($dumptext)) { echo "\n"; $id = pg_result($result, $i, "id"); echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; } else { echo pg_result($result, $i, "id"); echo " "; echo pg_result($result, $i, "name"); echo " "; echo pg_result($result, $i, "email"); echo " "; echo pg_result($result, $i, "text"); echo " "; echo pg_result($result, $i, "completed"); echo "
"; } } closedbconn(); echo "

Delete?	Id	Submitter	Submitter Email	Text	Completed
\n"; echo "\n"; echo "	\n"; echo $id; echo "	\n"; echo pg_result($result, $i, "name"); echo "	\n"; echo ""; echo pg_result($result, $i, "email"); echo "\n"; echo "	\n"; echo pg_result($result, $i, "text"); echo "	\n"; $completed = pg_result($result, $i, "completed"); if ($completed == "f") { $completed = "uncompleted"; echo "Currently $completed, toggle \n"; } else { $completed = "completed"; echo "Currently $completed, toggle \n"; } echo "

\n"; echo "\n"; } } function minutesEntry() { echo "

Minutes Entry

\n"; echo "\n"; } function actionEntry() { echo "

ToDo Action Entry

\n"; echo "\n"; } function adminpage() { echo "

This is the Installfest Administration page...

\n"; processAdminRequests(); echo "\n"; } actionEntry(); minutesEntry(); } display("sidebar", "adminpage"); ?>

\n"; echo " Title:\n"; echo "	\n"; echo " \n"; echo " (compulsory)
\n"; echo " Info:\n"; echo "	\n"; echo " \n"; echo " (compulsory)
\n"; echo " \n"; echo "

\n"; echo " Submitter:\n"; echo "	\n"; echo " \n"; echo " (compulsory)
\n"; echo " Submitter Email:\n"; echo "	\n"; echo " \n"; echo " (compulsory)
\n"; echo " Text:\n"; echo "	\n"; echo " \n"; echo " (compulsory)
\n"; echo " \n"; echo "