"") { $MySqlConnection = mysqli_connect($datHost, $datUser, $datPass, $datName) or die("Page temporarely not available! Please try later."); $strProductSql = "SELECT `T1`.`KeywordID`,`T1`.`ProductName`,`T1`.`KeywordName`,`T1`.`FileCode`,"; $strProductSql .= "`T1`.`HtmlUrl`,`T1`.`TitleText`,`T1`.`DescriptionText`,`T1`.`Heading1Text`,"; $strProductSql .= "`T1`.`Heading2Text`,`T1`.`KeywordType` FROM `KeyPageDetails` `T1` "; $strProductSql .= "INNER JOIN `Products` ON (`T1`.`ProductName` = `Products`.`ProductName`) "; $strProductSql .= "WHERE (`T1`.`KeywordID` = $strID AND `T1`.`Enabled` = 1 AND `Products`.`Enabled` = 1)"; $ProductResult = mysqli_query($MySqlConnection, $strProductSql); if (mysqli_num_rows($ProductResult) == 1) { $strProductFound = "1"; $ProductData = mysqli_fetch_assoc($ProductResult); $strProdKeyID = $ProductData["KeywordID"]; $strProductName = $ProductData["ProductName"]; $strKeywordName = $ProductData["KeywordName"]; $strKeywordType = $ProductData["KeywordType"]; $strKeywordFileCode = $ProductData["FileCode"]; $strKeywordHtmlUrl = substr($ProductData["HtmlUrl"], 1); $strPageTitle = $ProductData["TitleText"]; $strPageDescription = $ProductData["DescriptionText"]; $strPageHeading1 = $ProductData["Heading1Text"]; $strPageHeading2 = $ProductData["Heading2Text"]; $strPageHeading3 = ""; } $strQuestionsSql = "SELECT `Question` FROM `KeyPageQuestions` WHERE `KeywordName` = '$strKeywordName' ORDER BY `MySortOrder`"; $QuestionsResult = mysqli_query($MySqlConnection, $strQuestionsSql); if (mysqli_num_rows($QuestionsResult) > 0) { $strQuestionsFound = "1"; } $strBackLinksSql = "SELECT LinkHTML FROM BackLinks "; $strBackLinksSql .= "WHERE (LinkingPageUrl = '" . $strWebsiteUrl . $strKeywordHtmlUrl . "' AND Enabled = 1 AND Hatched = 1) ORDER BY MySortOrder"; $BackLinksResult = mysqli_query($MySqlConnection, $strBackLinksSql); if (mysqli_num_rows($BackLinksResult) > 0) { $strBackLinksFound = "1"; } $strUnfollowBackLinksSql = "SELECT LinkHTML FROM UnfollowBackLinks "; $strUnfollowBackLinksSql .= "WHERE (LinkingPageUrl = '" . $strWebsiteUrl . $strKeywordHtmlUrl . "' AND Enabled = 1 AND Hatched = 1)"; $UnfollowBackLinksResult = mysqli_query($MySqlConnection, $strUnfollowBackLinksSql); if (mysqli_num_rows($UnfollowBackLinksResult) > 0) { $strUnfollowBackLinksFound = "1"; } $strInternalLinksSql = "SELECT LinkHTML FROM KeyPageLinks "; $strInternalLinksSql .= "WHERE (KeywordName = '$strKeywordName' AND Enabled = 1) ORDER BY MySortOrder"; $InternalLinksResult = mysqli_query($MySqlConnection, $strInternalLinksSql); if (mysqli_num_rows($InternalLinksResult) > 0) { $strInternalLinksFound = "1"; } } if ($strProductFound == "0") { // Product not found, redirect to home page header("HTTP/1.1 301 Moved Permanently"); header("Location: $strWebsiteUrl"); exit; } if ($strProductName != $strWebsiteMainProductName) { // Keyword is not from this website header("HTTP/1.1 301 Moved Permanently"); header("Location: $strWebsiteUrl"); exit; } header ("Content-Type: text/html; charset=utf-8"); header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); header ("Cache-Control: max-age=3600, public"); /* // Date in the past header('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // HTTP/1.1 header('Cache-Control: no-store, no-cache, must-revalidate'); header('Cache-Control: post-check=0, pre-check=0', FALSE); // HTTP/1.0 header('Pragma: no-cache'); */ ?> <?php echo $strPageTitle;?>

Other Popular Topics:

$intTurnBacklinksToNonFollowAfterCount) { $strBacklinkHTML = str_replace("title=","rel=\"nofollow\" title=",$strBacklinkHTML); } ?>

© All Rights Reserved

The products mentioned are trademarks of their respective owners and are not owned by or affiliated with or any of its affiliated companies.

".PHP_EOL; echo " ".PHP_EOL; echo " ".PHP_EOL; echo " ".PHP_EOL; echo "

Please come back later!

".PHP_EOL; } flush(); include("../common/visitor-tracking.php"); ?>