$extra = "";
require("beheer/db.php");
$tpl = file_get_contents("tpl.html");
$query =mysql_query("SELECT count(*) as aantal FROM edits WHERE type != 'etcetera'");
$get = mysql_Fetch_object($query);
$aantal = $get->aantal;
$linknext = "index.php?id=".rand(1,$get->aantal);
if (!isset($_GET['id']) && !isset($_GET['pagina'])) {
header("location:home.php");
exit();
} else if (!isset($_GET['id']) && isset($_GET['pagina']) && $_GET['pagina'] == 'edits') {
header("location:".$linknext."&pagina=edits");
exit();
}
if (!isset($_GET['pagina'])) {
if (isset($_GET['id'])) {
$query = mysql_query("SELECT * FROM edits WHERE id = ".intval($_GET['id']));
$get = mysql_fetch_object($query);
} else {
$query = mysql_Query("SELECT * FROM edits WHERE type='koren' ORDER BY rand()");
$get=mysql_fetch_object($query);
}
$right = nl2br(stripslashes($get->edit));
$links = "";
if (strlen($get->titel) > 0) {
$links .= "".stripslashes($get->titel)."
";
} else {
$links .= "
";
}
if (strlen($get->door) > 0) {
$links .= "door:
".nl2br(stripslashes($get->door));
} else {
$links .= "
";
}
if (strlen($get->link) > 0) {
$links .= "
link))."\">website";
} else {
$links .= "
";
}
$links .= "
[".$get->nummer."/".$aantal."]";
if ($get->type == 'koren')
$links .= " *";
}
else if ($_GET['pagina'] == 'wie') {
$links = "";
$right = "";
$query = mysql_Query("SELECT id,door,link FROM edits ORDER BY door ASC");
while ($get = mysql_Fetch_object($query)) {
//if (strlen($get->link) > 2) {
$links .= "id."\">".stripslashes($get->door)."
";
// } else {
// $links .= "".stripslashes($get->door)."
";
// }
}
if (isset($_GET['id'])) {
$query = mysql_query("SELECT * FROM edits WHERE id = ".intval($_GET['id']));
$get = mysql_fetch_object($query);
$right = nl2br(stripslashes($get->edit));
} else {
$right = substr(str_replace("
"," | ",$links),0,-2);;
$links = "";
}
} else if ($_GET['pagina'] == 'edits') {
$linknext = 'index.php?pagina=edits&id='.rand(1,$aantal);;
$query = mysql_Query("SELECT * FROM edits WHERE type!='etcetera' ORDER BY rand()");
$get=mysql_fetch_object($query);
$right = nl2br(stripslashes($get->edit));
$links = "";
if (strlen($get->titel) > 0) {
$links .= "".stripslashes($get->titel)."
";
} else {
$links .= "
";
}
if (strlen($get->door) > 0) {
$links .= "door:
".nl2br(stripslashes($get->door));
} else {
$links .= "
";
}
if (strlen($get->link) > 0) {
$links .= "
link))."\">website";
} else {
$links .= "
";
}
$links .= "
[".$get->nummer."/".$aantal."]";
if ($get->type == 'koren')
$links .= " *";
} else if ($_GET['pagina'] == 'uitleg') {
if (isset($_GET['id'])) {
$query = mysql_query("SELECT * FROM edits WHERE id = ".intval($_GET['id']));
$get = mysql_fetch_object($query);
$right = nl2br(stripslashes($get->edit));
} else {
$right = "
";
}
$right .= $get->nummer.". id.">".$get->titel." "; $i++; } $right .= " |