// website doen we niet meer
header("HTTP/1.1 301 Moved Permanently");
header("Location: https://www.electroworld.nl/?storeref=8714231246640");
exit();
/* SESSION */
session_start();
/* SPLASH */
//$access_ips = array();
//$access_ips[] = gethostbyname("pc.djgerben.net");
//$access_ips[] = "80.101.239.212"; // ip van nessstraat
//if(in_array($_SERVER['REMOTE_ADDR'],$access_ips) == 0)
//{
//include("./splash.html");
//exit();
//}
/* DEBUG */
/*if ($_SERVER['REMOTE_ADDR'] == gethostbyname("pc.djgerben.net"))
{
error_reporting(E_ALL);
ini_set("display_errors","On");
}*/
/* REDIR */
// Alles moet naar https
if ($_SERVER['HTTP_HOST'] != "www.fikst.nl" OR $_SERVER['SERVER_PORT'] != 443)
{
header("HTTP/1.1 301 Moved Permanently");
header("Location: https://www.fikst.nl".$_SERVER['REQUEST_URI']);
exit();
}
if (isset($_GET['p']) AND $_GET['p']=="contact")
{
header("HTTP/1.1 301 Moved Permanently");
header("Location: https://www.electroworld.nl/store/electro-world-hoogendoorn-euromarkt");
exit();
}
/* BUFFER */
ob_start();
ob_implicit_flush(0);
/* DATABASE CONNECTIE + ESCAPE INPUT */
$site_directory = realpath(__DIR__);
require($site_directory."/common/database.class.php");
require($site_directory."/common/escape.variables.php");
/* VARS */
$javascript_alert = "";
$form_velden_opengelaten = FALSE;
$dagen_kort = array("ZO","MA","DI","WO","DO","VR","ZA");
$maanden = array("","Januari","Februari","Maart","April","Mei","Juni","Juli", "Augustus","September","Oktober","November","December");
/* CMS */
$cms_website = "fikst.nl";
/* TEKST INKORTEN NAAR x AANTAL KARAKTERS */
function inkorten($input,$lengte,$return=false)
{
if($return)
{
if(strlen($input) > $lengte)
return substr($input,0,$lengte)."...";
else
return $input;
}
else
{
if(strlen($input) > $lengte)
echo substr($input,0,$lengte)."...";
else
echo $input;
}
}
/* SEO */
function SEO($string, $seperator='-')
{
$string = strtolower($string);
$from = array('&','"','\'','/','\\','(',')','?','é','è','ë','ï','ö','ä');
$to = array('en','','','','','','','','e','e','e','i','o','a');
$string = str_replace($from, $to, $string);
$string = preg_replace("/[^a-z0-9_\s-]/", $seperator, $string);
$string = preg_replace("/[\s-]+/", " ", $string);
$string = preg_replace("/[\s_]/", $seperator, $string);
return $string;
}
/* PAGINA SCRIPT */
$huidigepagina = 2046; // Home
$voorpagina_slider = 2047;
$voorpagina_lidworden = 2048;
$sitemap = 2049;
$voorpagina_itemsrechts = 2060;
$huidigepagina_default = $huidigepagina; // Home
$subpagina = FALSE;
$subsubpagina = FALSE;
if(isset($_GET['subsubp']))
{
$query = $database->query("SELECT * FROM `webpaginas` WHERE `website`='".$cms_website."' AND `actief`='1' ORDER BY `subpagina` DESC, `volgorde` ASC");
$numrows = mysqli_num_rows($query);
while($row = mysqli_fetch_array($query,MYSQLI_ASSOC))
{
$query2 = $database->query("SELECT * FROM `webpaginas` WHERE `website`='".$cms_website."' AND `subpagina`='".$row['id']."' AND `actief`='1' ORDER BY `subpagina` DESC, `volgorde` ASC");
$numrows2 = mysqli_num_rows($query2);
while($row2 = mysqli_fetch_array($query2,MYSQLI_ASSOC))
{
if(SEO($row['titel']) == $_GET['subp'] AND SEO($row2['titel']) == $_GET['subsubp'])
{
$subsubpagina = $row2['id'];
$subpagina = $row['id'];
$huidigepagina = $row['subpagina'];
break;
}
}
}
}
else if(isset($_GET['subp']))
{
$query = $database->query("SELECT * FROM `webpaginas` WHERE `website`='".$cms_website."' AND `actief`='1' ORDER BY `subpagina` DESC, `volgorde` ASC");
$numrows = mysqli_num_rows($query);
while($row = mysqli_fetch_array($query,MYSQLI_ASSOC))
{
if(SEO($row['titel']) == $_GET['subp'] AND $row['subpagina'] != "0")
{
$subpagina = $row['id'];
$huidigepagina = $row['subpagina'];
break;
}
}
}
else if(isset($_GET['p']))
{
$query = $database->query("SELECT * FROM `webpaginas` WHERE `website`='".$cms_website."' AND `actief`='1' ORDER BY `subpagina` DESC, `volgorde` ASC");
$numrows = mysqli_num_rows($query);
while($row = mysqli_fetch_array($query,MYSQLI_ASSOC))
{
if(SEO($row['titel']) == $_GET['p'])
{
$huidigepagina = $row['id'];
break;
}
}
}
/* MAIL */
if(file_exists("./phpmailer/class.phpmailer.php")) include("./phpmailer/class.phpmailer.php");
function verstuur_mail($emailadres,$onderwerp,$bericht,$bijlage,$cc)
{
global $debug;
global $debug_mailadres;
$html_mail = "";
$handle = fopen("./template_mail.html", "r");
if ($handle)
{
while (!feof($handle)) $html_mail .= fgets($handle, 4096);
fclose($handle);
}
$html_mail = str_replace("%tekst%",$bericht,$html_mail);
$html_mail = str_replace("%onderwerp%",$onderwerp,$html_mail);
$mail = new PHPMailer();
$mail->CharSet = "UTF-8";
// Set to sendmail en strip command line parameters from path as these will be added by PHPMailer
$mail->isSendmail();
$sendmailpath = explode(" ", $mail->Sendmail);
$mail->Sendmail = $sendmailpath[0];
//$mail->IsSMTP(); // set mailer to use SMTP
//$mail->Host = "alphen-lb01.net.argeweb.nl"; // specify main and backup server
//$mail->SMTPAuth = false; // turn on SMTP authentication
//$mail->Username = "hoi"; // SMTP username
//$mail->Password = "hey"; // SMTP password
$mail->Sender = $mail->From = "info@fikst.nl";
$mail->FromName = "fikst.nl";
$mail->AddAddress($emailadres);
if($cc) $mail->AddCC("info@fikst.nl");
if($bijlage AND file_exists($bijlage)) $mail->AddAttachment($bijlage); // add attachment
$mail->IsHTML(true); // set email format to HTML
$mail->Subject = $onderwerp;
$mail->Body = $html_mail;
$mail->AltBody = "Deze e-mail kan alleen gelezen worden in een browser of e-mailprogramma die HTML mails ondersteunt.";
if($mail->Send()) return true;
else return false;
}
/* CONTACTFORM */
if($_POST['contactformulier'] == "1")
{
if(
!empty($_POST['naam'])
AND !empty($_POST['emailadres'])
AND !empty($_POST['bericht'])
){
$mail_bericht = "Beste ".$cms_website.",
Via het contactformulier op www.".$cms_website." is het volgende bericht ingestuurd:
Naam
".$_POST['naam']."
E-mailadres
".$_POST['emailadres']."
Bericht
".nl2br($_POST['bericht'])."
";
verstuur_mail("info@fikst.nl","Contactformulier op ".$cms_website." is ingevuld!",$mail_bericht,FALSE,FALSE);
//verstuur_mail("gerben@fedon.nl","Contactformulier op ".$cms_website." is ingevuld!",$mail_bericht,FALSE,FALSE);
$date = time();
$ip = $_SERVER["REMOTE_ADDR"];
$cms_bericht = "Alle velden:
\n\n
Naam: ".($_POST['naam'])."\n
E-mailadres: ".($_POST['emailadres'])."\n
Bericht:\n
\n
".($_POST['bericht'])."
\n\n";
$sql = "INSERT INTO `contactformulier`
(
`website`,
`naam`,
`onderwerp`,
`emailadres`,
`bericht`,
`datum`,
`ip`,
`telefoonnummer`
)
VALUES
(
'".$cms_website."',
'".($_POST['naam'])."',
'".($_POST['onderwerp'])."',
'".($_POST['emailadres'])."',
'".$cms_bericht."',
'$date',
'$ip',
''
)";
$database->query( $sql ) or die( mysqli_error() );
header("Location: ./contact.html?succes=1");
exit();
}
}
/* IS EMAIL? */
function isemail($email)
{
return filter_var($email, FILTER_VALIDATE_EMAIL);
//return ereg("[A-Za-z0-9_-]+([\.]{1}[A-Za-z0-9_-]+)*@[A-Za-z0-9-]+([\.]{1}[A-Za-z0-9-]+)+", $email);
}
/* NIEUWSBRIEF */
if($_POST['nieuwsbrief'] == "1")
{
if(isemail($_POST['email']))
{
$query = $database->query("SELECT * FROM `nieuwsbrief_emailadressen` WHERE `website`='".$cms_website."' AND `emailadres`='".$_POST['email']."' LIMIT 1");
$numrows = mysqli_num_rows($query);
if(!$numrows)
{
$database->query("INSERT INTO `nieuwsbrief_emailadressen` (`website`,`emailadres`) VALUES ('".$cms_website."','".$_POST['email']."')");
}
$javascript_alert = "Bedankt voor het aanmelden voor onze nieuwsbrief.";
}
else
{
$javascript_alert = "Wij konden uw e-mailadres niet toevoegen, omdat dit geen correct e-mailadres is. Probeer het aub nogmaals.";
}
}
/* ZOEKMACHINE */
$query = $database->query("SELECT `keyword` FROM `zoekmachine` WHERE `website`='".$cms_website."' AND `omschrijving`='1'");
$row = mysqli_fetch_array($query,MYSQLI_ASSOC);
$omschrijving = $row[keyword];
$keywords = "";
$query = $database->query("SELECT `keyword` FROM `zoekmachine` WHERE `website`='".$cms_website."' AND `omschrijving`='0' ORDER BY `keyword`");
while($row = mysqli_fetch_array($query,MYSQLI_ASSOC))
{
if($keywords == "") $keywords .= $row[keyword];
else $keywords .= ",".$row[keyword];
}
/* MOOIE INLEIDINGEN */
function kortetitel($string)
{
$string = strip_tags($string, 'strong span' );
return $string;
}
/* WEERGEEF TEKST AAN DE HAND VAN EEN ID */
function weergeeftekstbijid($id)
{
global $cms_website; global $database;
$query = $database->query("SELECT `tekst` FROM `webpaginas` WHERE `website`='".$cms_website."' AND `id`='".$id."' AND `actief`='1' LIMIT 1");
$numrows = mysqli_num_rows($query);
if($numrows)
{
$row = mysqli_fetch_array($query,MYSQLI_ASSOC);
echo stripslashes($row[tekst]);
}
else
{
echo "De pagina kon niet worden gevonden.";
}
}
/* WEERGEEF TEKST AAN DE HAND VAN EEN SEO TITEL */
function weergeeftekstbijseotitel($seotitel)
{
global $cms_website; global $database;
$gevonden = FALSE;
$query = $database->query("SELECT `titel`,`tekst` FROM `webpaginas` WHERE `website`='".$cms_website."' AND `actief`='1'");
while ($row = mysqli_fetch_array($query,MYSQLI_ASSOC))
{
if (SEO($row['titel']) == $seotitel)
{
echo stripslashes($row[tekst]);
$gevonden = TRUE;
}
}
if (!$gevonden)
{
echo "De pagina kon niet worden gevonden.";
}
}
/* BANNER OUT */
if(isset($_GET['bannerout']))
{
$query = $database->query("SELECT
*
FROM
`banners`
WHERE
(
`website`='".$cms_website."'
)
AND
(
`id`='".$_GET['bannerout']."'
AND `actief`='1'
AND
(
(
`begindatum`='0'
OR
`begindatum`<='".time()."'
)
AND
(
`einddatum`='0'
OR
`einddatum`>='".time()."'
)
)
)
LIMIT
1")or die(mysqli_error());
while($row = mysqli_fetch_array($query,MYSQLI_ASSOC))
{
$database->query("UPDATE `banners` SET `hits`=`hits`+1 WHERE ( `website`='".$cms_website."' ) AND ( `id`='".$row['id']."' ) LIMIT 1")or die(mysqli_error());
if (trim($row['link']) != "" AND $row['link'] != "#")
{
header("Location: ".$row['link']);
exit();
}
}
}
/* BANNER WEERGEVEN */
function bannersweergeven($plek)
{
global $cms_website; global $database;
$query = $database->query("SELECT
*
FROM
`banners`
WHERE
(
`website`='".$cms_website."'
)
AND
(
`plek`='".$plek."'
AND `actief`='1'
AND
(
(
`begindatum`='0'
OR
`begindatum`<='".time()."'
)
AND
(
`einddatum`='0'
OR
`einddatum`>='".time()."'
)
)
)
ORDER BY
`volgorde` ASC")or die(mysqli_error());
while($row = mysqli_fetch_array($query,MYSQLI_ASSOC))
{
$database->query("UPDATE `banners` SET `bekeken`=`bekeken`+1 WHERE ( `website`='".$cms_website."' ) AND ( `id`='".$row['id']."' ) LIMIT 1")or die(mysqli_error());
$teller++;
echo "
$query_hoofdpaginas = $database->query("SELECT * FROM `webpaginas` WHERE `website`='".$cms_website."' AND `subpagina`='0' AND `actief`='1' AND `id`!='".$sitemap."' AND `volgorde`<10 ORDER BY `volgorde` ASC");
$numrows_hoofdpaginas = mysqli_num_rows($query_hoofdpaginas);
while($row_hoofdpaginas = mysqli_fetch_array($query_hoofdpaginas,MYSQLI_ASSOC))
{
$class = "";
if($row_hoofdpaginas['id'] == $huidigepagina)
$class = 'class="active"';
if($row_hoofdpaginas['id'] == $huidigepagina_default)
$url = "./";
else
$url = "./".SEO($row_hoofdpaginas['titel']).".html";
echo '
';
echo ''.$row_hoofdpaginas['titel'].'';
$query_subpaginas = $database->query("SELECT * FROM `webpaginas` WHERE `website`='".$cms_website."' AND `subpagina`='".$row_hoofdpaginas['id']."' AND `actief`='1' ORDER BY `volgorde` ASC");
$numrows_subpaginas = mysqli_num_rows($query_subpaginas);
// Geen submenu's bij home!
if ($numrows_subpaginas AND $row_hoofdpaginas['id'] != $huidigepagina_default)
{
echo '
';
echo ''.$sub_hoofdpaginas['titel'].'';
$query_subsubpaginas = $database->query("SELECT * FROM `webpaginas` WHERE `website`='".$cms_website."' AND `subpagina`='".$sub_hoofdpaginas['id']."' AND `actief`='1' ORDER BY `volgorde` ASC");
$numrows_subsubpaginas = mysqli_num_rows($query_subsubpaginas);
if ($numrows_subsubpaginas)
{
echo '
// Check wat voor een type pagina de hoofdpagina is
$query_hoofdpagina = $database->query("SELECT * FROM `webpaginas` WHERE `website`='".$cms_website."' AND `id`='".$huidigepagina."' AND `actief`='1' LIMIT 1");
$row_hoofdpagina = mysqli_fetch_array($query_hoofdpagina,MYSQLI_ASSOC);
if ($_GET['p'] == "nieuws")
{
?>
Nieuws
if (isset($_GET['itemid']))
$query = $database->query("SELECT * FROM `nieuws` WHERE `website`='".$cms_website."' AND `actief`='1' AND `id`='".$_GET['itemid']."' ORDER BY `datum` DESC LIMIT 1");
else
$query = $database->query("SELECT * FROM `nieuws` WHERE `website`='".$cms_website."' AND `actief`='1' ORDER BY `datum` DESC");
while($row = mysqli_fetch_array($query,MYSQLI_ASSOC))
{
?>
if (isset($_GET['itemid']))
echo $row['tekst'];
else
{
echo inkorten(kortetitel($row['tekst']),250);
?>
Lees meer >>
}
?>
}
?>
}
elseif ($row_hoofdpagina['type'] == "home")
{
$query = $database->query("SELECT * FROM `webpaginas` WHERE `website`='".$cms_website."' AND `subpagina`='".$voorpagina_slider."' AND `actief`='1' ORDER BY `volgorde` ASC");
$numrows = mysqli_num_rows($query);
if ($numrows)
{
?>
}
?>
$query = $database->query("SELECT * FROM `webpaginas` WHERE `website`='".$cms_website."' AND `subpagina`='".$huidigepagina_default."' AND `volgorde`='4' AND `actief`='1' LIMIT 1");
$row = mysqli_fetch_array($query,MYSQLI_ASSOC);
?>
echo $row['titel']; ?>
echo $row['tekst']; ?>
?>
Fiks't
$query = $database->query("SELECT * FROM `webpaginas` WHERE `website`='".$cms_website."' AND `subpagina`='".$voorpagina_itemsrechts."' AND `actief`='1' ORDER BY `volgorde` ASC");
while($row = mysqli_fetch_array($query,MYSQLI_ASSOC))
{
?>
bannersweergeven("Voorpagina_onderin 211x95");
/*
$teller = 0;
$query = $database->query("SELECT * FROM `webpaginas` WHERE `website`='".$cms_website."' AND `subpagina`='".$voorpagina_banners."' AND `actief`='1' ORDER BY `volgorde` ASC");
while($row = mysqli_fetch_array($query,MYSQLI_ASSOC))
{
$url = "#";
if (trim($row['url']) != "")
$url = $row['url'];
$teller++;
if ($teller == 5)
{
$teller = 1;
echo '
';
echo '
';
}
?>
}
*/
?>
} // End type pagina home
else if ($row_hoofdpagina['type'] == "content")
{
// Haal content op
if ($subsubpagina)
$query_content = $database->query("SELECT * FROM `webpaginas` WHERE `website`='".$cms_website."' AND `id`='".$subsubpagina."' AND `actief`='1' LIMIT 1");
else if ($subpagina)
$query_content = $database->query("SELECT * FROM `webpaginas` WHERE `website`='".$cms_website."' AND `id`='".$subpagina."' AND `actief`='1' LIMIT 1");
else
$query_content = $database->query("SELECT * FROM `webpaginas` WHERE `website`='".$cms_website."' AND `id`='".$huidigepagina."' AND `actief`='1' LIMIT 1");
$row_content = mysqli_fetch_array($query_content,MYSQLI_ASSOC);
?>
$paginanaam_fotoalbums = "";
$query_subpaginas = $database->query("SELECT * FROM `webpaginas` WHERE `website`='".$cms_website."' AND `subpagina`='".$row_hoofdpagina['id']."' AND `actief`='1' ORDER BY `volgorde` ASC");
$numrows_subpaginas = mysqli_num_rows($query_subpaginas);
if ($numrows_subpaginas)
{
echo '
';
if ($sub_hoofdpaginas['id'] == $subpagina)
{
$query_subsubpaginas = $database->query("SELECT * FROM `webpaginas` WHERE `website`='".$cms_website."' AND `subpagina`='".$sub_hoofdpaginas['id']."' AND `actief`='1' ORDER BY `volgorde` ASC");
while($subsub_hoofdpaginas = mysqli_fetch_array($query_subsubpaginas,MYSQLI_ASSOC))
{
$url = "./".SEO($row_hoofdpagina['titel'])."/".SEO($sub_hoofdpaginas['titel'])."/".SEO($subsub_hoofdpaginas['titel']).".html";
echo '
if (isset($_GET['itemid']))
$query = $database->query("SELECT * FROM `nieuws` WHERE `website`='".$cms_website."' AND `actief`='1' AND `id`='".$_GET['itemid']."' ORDER BY `datum` DESC LIMIT 1");
else
$query = $database->query("SELECT * FROM `nieuws` WHERE `website`='".$cms_website."' AND `actief`='1' ORDER BY `datum` DESC");
while($row = mysqli_fetch_array($query,MYSQLI_ASSOC))
{
?>
U ontvangt zo spoedig mogelijk een bevestiging van ons.
}
else
{
echo $row_content['tekst'];
}
}
?>
} // End type pagina content
else if ($row_hoofdpagina['type'] == "contact")
{
// Haal content op
$query_content = $database->query("SELECT * FROM `webpaginas` WHERE `website`='".$cms_website."' AND `id`='".$huidigepagina."' AND `actief`='1' LIMIT 1");
$row_content = mysqli_fetch_array($query_content,MYSQLI_ASSOC);
?>