require("../../include/headers.inc.php");
headers();
if (isset($_GET["jeugdtoernooiaction"])) {
$jeugdtoernooiaction=$_GET["jeugdtoernooiaction"];
if ((strcmp($jeugdtoernooiaction,"addtoernooi")===0) && hasPrivilege("jtoern")) {
$title=$_POST['tournamenttitle'];
createJeugdTournament($title);
}
if ((strcmp($jeugdtoernooiaction,"deletetoernooi")===0) && hasPrivilege("jtoern")) {
$tournamentId=$_GET["toernooiid"];
deleteJeugdTournament($tournamentId);
}
}
$toern = isset($_GET['toernooiid']);
echo "
";
if ($toern) {
preLay("Jeugdtoernooien");
if (hasPrivilege("jtoern")) { makeNewJeugdToernooiForm(); }
showJeugdToernooien();
postLay();
}
render_left(false,false);
if ($toern) {
render_right(false);
}
echo "
";
if ($toern) {
echo "";
} else {
echo "
";
}
if ($toern) {
showDynamicPage($_GET['toernooiid']);
}
if (!$toern) {
preLay("Jeugdtoernooien");
echo "
";
if (hasPrivilege("jtoern")) { makeNewJeugdToernooiForm(); }
showJeugdToernooien();
echo "";
postLay();
}
echo "";
if (!$toern) {
render_right();
}
footers();
function createJeugdTournament($newTitle) {
if (get_magic_quotes_gpc()) {
$newTitle = stripslashes($newTitle);
}
$createQuery="INSERT INTO dynamic_page VALUES (NULL, 'jeugd,toernooi',NOW()," . $_SESSION['user_id']
. ", '" . mysql_real_escape_string($newTitle) . "', '', 'bpagina,jtoern')";
$createResult=mysql_query($createQuery);
if (testSqlError($createQuery,$createResult,"Create jeugd tournament")) { return false; }
return true;
}
function deleteJeugdTournament($tournamentId) {
$deleteQuery="DELETE FROM dynamic_page WHERE FIND_IN_SET('jeugd',pageType) AND FIND_IN_SET('toernooi',pageType) AND id=".$tournamentId;
$deleteResult=mysql_query($deleteQuery);
if (testSqlError($deleteQuery,$deleteResult,"Verwijder jeugdtoernooi")) { return false; }
return true;
}
function makeNewJeugdToernooiForm() {
global $basepage;
?>
}
function showJeugdToernooien() {
global $basepage,$basepagejs;
$tournamentQuery = "SELECT *, UNIX_TIMESTAMP(date) AS unixDate FROM dynamic_page"
. " WHERE FIND_IN_SET('jeugd',pageType) AND FIND_IN_SET('toernooi',pageType)"
. " ORDER BY date DESC";
$tournamentResult = mysql_query($tournamentQuery);
if (testSqlError($tournamentQuery,$tournamentResult)) { return; }
?>
echo "
\n";
while ($tournamentLine = mysql_fetch_assoc($tournamentResult)) {
echo "\t\n";
if (hasPrivilege("jtoern")) {
echo "" . "del" . " | ";
}
echo "" . strftime("%d-%m", $tournamentLine['unixDate']) . " | ";
echo ""
. "" . bb_bericht($tournamentLine['title']) . ""
. " | ";
echo "\t
\n";
}
echo "
\n";
/*/
while ($tournamentLine = mysql_fetch_assoc($tournamentResult)) {
if (hasPrivilege("jtoern")) {
echo "
del";
}
echo " " . strftime("%d-%m", $tournamentLine['unixDate']);
echo " " . "
" . bb_bericht($tournamentLine['title']) . "";
echo "
";
}
*/
}
?>