<?php require_once('Connections/postage.php'); ?>
<?php  
// $full_realestate = false;
$seo_page = true;  // for SEO tags etc...
require('includes/application_top.php');
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}
  $varpagename_rsGeneratedPages = curPageName() ;

mysql_select_db($database_postage, $postage);
$query_rsGeneratedPages = sprintf("select 	pagedata_id, pagename, meta_title, 
		meta_keywords, meta_description, template_filename, h1, 
		paragraph1_use_folder, paragraph1_folder, paragraph1, 
		paragraph2_use_folder, paragraph2_folder, paragraph2, 
		paragraph3_use_folder, paragraph3_folder, paragraph3, 
		paragraph4_use_folder, 	paragraph4_folder, 	paragraph4, 
	paragraph5_use_folder, 	paragraph5_folder, 	paragraph5, 
	paragraph6_use_folder, 	paragraph6_folder, 	paragraph6, 
	paragraph7_use_folder, 	paragraph7_folder, 	paragraph7, 
	paragraph8_use_folder, 	paragraph8_folder, 	paragraph8, 
	paragraph9_use_folder, 	paragraph9_folder, 	paragraph9, 
	paragraph10_use_folder, 	paragraph10_folder, 	paragraph10, 
	sitemap_main, 	sitemap_eur, 	sitemap_int, 
	sitemap_general, 	use_marquee, 	marquee_folder
	from 
	seo_pages 
where  pagename  = %s", GetSQLValueString($varpagename_rsGeneratedPages, "text"));
$rsGeneratedPages = mysql_query($query_rsGeneratedPages, $postage) or die(mysql_error());
$row_rsGeneratedPages = mysql_fetch_assoc($rsGeneratedPages);
$totalRows_rsGeneratedPages = mysql_num_rows($rsGeneratedPages);


// set the marquee folder if required
if ($row_rsGeneratedPages['use_marquee'] == 'Y'){
$marqueefolder = DIR_FS_SEO_MARQUEES . $row_rsGeneratedPages['marquee_folder'] . '/';
}


//echo 'XXX' . $gen_collection_country . ' XXX ' . $gen_delivery_country . ' XXX ' . $totalRows_rsGeneratedPages;
  $breadcrumb->add(NAVBAR_TITLE, tep_href_link("test_pricing.php"));

  $content = str_replace('.php', '' , $_SERVER['PHP_SELF']);

  require(DIR_WS_TEMPLATES . TEMPLATE_NAME . '/' . TEMPLATENAME_MAIN_PAGE);

  require(DIR_WS_INCLUDES . 'application_bottom.php');


mysql_free_result($rsGeneratedPages);
?>