0){
echo 'Deze key bestaat al!';
}else{
mysql_query("INSERT INTO external_texts (extkey, extvalue) VALUES ('".beveilig($_POST['exkey'])."', '".beveilig($_POST['exvalue'])."')");
echo mysql_error();
echo 'De external key: '.$_POST['exkey'].' is succsesvol toegevoegd!';
logboek("external text toegevoegd (".$_POST['exkey'].")", $username);
}
}else{
echo '';
}
}else{
echo 'Deze ID bestaat niet.';
}
}else{
echo 'Geen ID?';
}
}elseif($_GET['do'] == "update"){
echo 'Een moment.. bezig met external texts updaten...
';
$fh = fopen("../external_texts.txt", 'w') or die("can't open file");
$update_a = mysql_query("SELECT * FROM external_texts");
$stringData = '# GENERATED BY '.$web_name.' HOUSEKEEPING
';
fwrite($fh, $stringData);
while($update_b = mysql_fetch_array($update_a)){
$stringData = $update_b['extkey'].'='.$update_b['extvalue'].'
';
fwrite($fh, $stringData);
}
$stringData = '# GENERATED BY '.$web_name.' HOUSEKEEPING';
fwrite($fh, $stringData);
fclose($fh);
echo 'Klaar
Er is een nieuwe external text geschreven.';
logboek("updated the external texts", $username);
}else{
echo '
';
echo 'Voeg nieuwe external text toe
Update external texts(voor loader)
';
$rowsPerPage = 30;
$pageNum = 1;
if(isset($_GET['page'])){
$pageNum = $_GET['page'];
}
$offset = ($pageNum - 1) * $rowsPerPage;
if($_GET['findsearch']){
$a = mysql_query("SELECT * FROM external_texts WHERE extkey LIKE '%".beveilig($_GET['findsearch'])."%' ORDER by extkey LIMIT ".$offset.", ".$rowsPerPage."");
$aa = mysql_query("SELECT * FROM external_texts WHERE extkey LIKE '%".beveilig($_GET['findsearch'])."%'");
}else{
$a = mysql_query("SELECT * FROM external_texts ORDER by extkey LIMIT ".$offset.", ".$rowsPerPage."");
$aa = mysql_query("SELECT * FROM external_texts");
}
echo '';
echo '';
echo '| Key | ';
echo 'Value | ';
echo 'Bewerk | ';
echo '
';
while($b = mysql_fetch_assoc($a)){
echo '';
echo '| '.$b['extkey'].' | ';
echo ''.$b['extvalue'].' | ';
echo ' | ';
echo '
';
}
echo '
';
$numrows = mysql_num_rows($aa);
$maxPage = ceil($numrows/$rowsPerPage);
$nav = '';
$eenbr = 1;
$page = 1;
while($page <= $maxPage){
if ($page == $pageNum){
$nav .= " ".$page." ";
}else{
if($_GET['findsearch']){
$nav .= " ".$page." ";
}else{
$nav .= " ".$page." ";
}
}
if($eenbr == 20){
//$nav .= '
';
$eenbr = 1;
}else{
$eenbr++;
}
$page++;
}
echo $nav;
}
}else{
echo $acc_denied;
}
include('inc/footer.php');
?>