<?php
  $sPagina = $_SERVER['PHP_SELF'];
  $sDirectoryFromRoot = "\\";
  $sDocumentRoot = $_SERVER['DOCUMENT_ROOT'] . $sDirectoryFromRoot;
  require_once($sDocumentRoot . "includes\\incl_connect_mysql.php");
  require_once($sDocumentRoot . "includes\\maintekst.php");
  require_once($sDocumentRoot . "includes\\sitestructure.php");

  session_start();

  $cDBConnection = fnCreateDatabaseConnectie();
  $arWaardes = fnGetTekst($sPagina, $cDBConnection);
  $sMainTekst     = $arWaardes[0];
  $iTypeId        = $arWaardes[1];
  $iAantalRegels  = $arWaardes[2];
  $sTypeTekst     = $arWaardes[3];

  if($_SESSION['bToonPagina']) {
    $sPaginaSource = str_replace("<p>", "", $_POST['FCKeditor1']);
    $sPaginaSource = str_replace("&nbsp;</p>", "", $sPaginaSource);
    $sPaginaSource = str_replace("</p>", "", $sPaginaSource);
    $sPaginaSource = str_replace("\'", "&#39;", $sPaginaSource);
    $sPaginaSource = $cDBConnection->real_escape_string($sPaginaSource);
    $iAantalRegels = intval($_POST['iAantalRegels']);
    $sSQL  = " UPDATE ";
    $sSQL .= "   tbl_paginas ";
    $sSQL .= " SET ";
    $sSQL .= "   pa_tekst = '" . $sPaginaSource . "', ";
    $sSQL .= "   pa_aantal_regels = '" . $iAantalRegels . "' ";
    $sSQL .= " WHERE pa_bestandsnaam = '" . $_POST['sPagina'] . "';";
    $cDBConnection->query($sSQL);
    $sMainTekst = str_replace("\\\"", "\"", $sPaginaSource);
    $sMainTekst = str_replace("\\r\\n", "", $sMainTekst);
  }
  include($sDocumentRoot . "templates/template.html");
?>