= $min) && (ip2long($ip) <= $max)) return false;
}
return true;
} else {
return false;
}
}
function getip() {
if (validip($_SERVER["HTTP_CLIENT_IP"])) {
return $_SERVER["HTTP_CLIENT_IP"];
}
foreach (explode(",",$_SERVER["HTTP_X_FORWARDED_FOR"]) as $ip) {
if (validip(trim($ip))) {
return $ip;
}
}
if (validip($_SERVER["HTTP_X_FORWARDED"])) {
return $_SERVER["HTTP_X_FORWARDED"];
} elseif (validip($_SERVER["HTTP_FORWARDED_FOR"])) {
return $_SERVER["HTTP_FORWARDED_FOR"];
} elseif (validip($_SERVER["HTTP_FORWARDED"])) {
return $_SERVER["HTTP_FORWARDED"];
} elseif (validip($_SERVER["HTTP_X_FORWARDED"])) {
return $_SERVER["HTTP_X_FORWARDED"];
} else {
return $_SERVER["REMOTE_ADDR"];
}
}
$site_id=39;
$missing_url = str_replace("404;http://", "", $_SERVER['REDIRECT_URL']);
$missing_url = str_replace(":80", "", $missing_url);
$url_array = explode("/", $missing_url);
$params = array();
$categories = array();
foreach($url_array as $key=>$value) {
if($value != $_SERVER['HTTP_HOST']) {
if(strpos($value, "?") > 0) {
$temp=explode("?", $value);
$categories[]=$temp[0];
$parameters=$temp[1];
$parameters=explode("&", $parameters);
foreach($parameters as $pkey=>$pval) {
$paramval = explode("=", $pval);
$params[$paramval[0]] = $paramval[1];
}
} else {
if(trim($value) != "") {
$categories[] = $value;
}
}
}
}
//var_dump($params);
$current_cat = 0;
$current_sub = 0;
$category_name=str_replace("-", " ", $categories[0]);
if(count($categories) != 0) {
switch(count($categories)) {
case 1:
$sql = "SELECT * FROM scmscategories WHERE siteId=".$site_id." AND parentId IS NULL";
$cats = mysqli_query($link, $sql) or die(mysqli_error().": ". $sql);
while($cat_row=mysqli_fetch_array($cats)) {
$db_category=str_replace("?","", strtolower($cat_row['descript']));
if(strtolower($db_category) == strtolower($category_name)) {
$current_cat=$cat_row['categoryId'];
$current_sub = 0;
break;
}
}
break;
case 2:
$sql = "SELECT * FROM scmscategories WHERE siteId=".$site_id." AND parentId IS NULL";
$cats = mysqli_query($link, $sql) or die(mysqli_error().": ". $sql);
while($cat_row=mysqli_fetch_array($cats)) {
$db_category=str_replace("?","", strtolower($cat_row['descript']));
if($db_category == $category_name) {
$current_cat=$cat_row['categoryId'];
$current_sub = 0;
break;
}
}
$sql = "SELECT categoryId, descript FROM scmscategories WHERE parentID=".$current_cat." ORDER BY sort_order";
$result = mysqli_query($link, $sql) or die (mysqli_error());
while($item = mysqli_fetch_array($result)) {
if(strtolower($item['descript']) == $categories[1]) {
$current_sub = $item['categoryId'];
break;
}
}
break;
}
}
$sql = "SELECT * FROM scmscategories WHERE siteId=".$site_id." AND parentId IS NULL ORDER BY sort_order";
$cats = mysqli_query($link, $sql) or die(mysqli_error().": ". $sql);
$numitems=mysqli_num_rows($cats);
$itemcntr=0;
$strMenu = '\r\n";
$sql = "INSERT INTO scmsvisitors (siteId, visitorIp, page_name) SELECT ".$site_id.", '".getip()."', descript FROM scmscategories WHERE categoryId=".$current_cat."\n";
mysqli_query($link, $sql) or die (mysqli_error());
if(empty($current_sub) || $current_sub == 0) {
$content_sql = "SELECT c.descript, c.content, c.intro, cat.siteId FROM scmscontent c \n";
$content_sql .= "INNER JOIN scmspages p ON c.pageId=p.pageId AND p.activeFrom < NOW() AND p.activeTill > NOW() \n";
$content_sql .= "INNER JOIN scmscategories cat ON p.categoryId = cat.categoryId AND cat.categoryId = ".$current_cat." \n";
$content_sql .= "WHERE c.activeFrom < NOW() AND c.activeTill > NOW()";
$module_sql = "SELECT m.location, cat.siteId FROM scmsmodules m \n";
$module_sql .= "INNER JOIN scmspagemodules pm ON m.moduleId=pm.moduleId\n";
$module_sql .= "INNER JOIN scmspages p ON p.pageId=pm.pageId AND p.activeFrom < NOW() AND p.activeTill > NOW() \n";
$module_sql .= "INNER JOIN scmscategories cat ON p.categoryId = cat.categoryId AND cat.categoryId = ".$current_cat." \n";
} else {
$content_sql = "SELECT c.descript, c.content, c.intro, cat.siteId FROM scmscontent c \n";
$content_sql .= "INNER JOIN scmspages p ON c.pageId=p.pageId AND p.activeFrom < NOW() AND p.activeTill > NOW() \n";
$content_sql .= "INNER JOIN scmscategories cat ON p.categoryId = cat.categoryId AND cat.categoryId = ".$current_sub." \n";
$content_sql .= "WHERE c.activeFrom < NOW() AND c.activeTill > NOW()";
$module_sql = "SELECT m.location, cat.siteId FROM scmsmodules m \n";
$module_sql .= "INNER JOIN scmspagemodules pm ON m.moduleId=pm.moduleId\n";
$module_sql .= "INNER JOIN scmspages p ON p.pageId=pm.pageId AND p.activeFrom < NOW() AND p.activeTill > NOW() \n";
$module_sql .= "INNER JOIN scmscategories cat ON p.categoryId = cat.categoryId AND cat.categoryId = ".$current_sub." \n";
}
$result = mysqli_query($link, $content_sql) or die (mysqli_error());
if (mysqli_num_rows($result) == 0) {
//Could be a module...
mysqli_free_result($result);
$result = mysqli_query($link, $module_sql) or die (mysqli_error());
if (mysqli_num_rows($result) == 0) {
$actual_content.= "NO CONTENT";
} else {
$row = mysqli_fetch_array($result);
}
} else {
$actual_content = "";
$keywords = "";
while($row= mysqli_fetch_array($result)) {
$actual_content .= $row['content'];
$keywords .= $row['intro'];
$siteId = $row['siteId'];
}
mysqli_free_result($result);
}
?>
Villa Joep | Het fonds tegen neuroblastoomkanker
