<?php

 //////////////////////////////////////////////////////////////
 // Hostreview.com index file
 // index.php
 //
 // @param page_id - id in navigation
 // @param category_id - cat_id in navigation
 // @param id - id in: articles, categories, interviews, ...
 //////////////////////////////////////////////////////////////

 include "common.php";
 include "classes.php";

 $db = new sql_db($dbhost, $dbuser, $dbpass, $dbname, true);
 if(!$db->db_connect_id)  die($lang['Wrong_Db']);

 // Define global constants from database
 //
 $res = $db->sql_query("select name, value from hostrev_globals");
 while( $row = $db->sql_fetchrow( $res ) ){
   $_constants_code .= "define($row[name],\"$row[value]\");\n";
 }
 eval( $_constants_code );

 eval( GET_GLOBALS_CODE );

 // Begin Extracting Navigations
 //

   // Initializations
 $page_id = $page_id ? $page_id : 1;
 $cat_id = $cat_id ? $cat_id : 1;
 $id = $id ? $id :  1;
 $meta_id = 1;
 $printbuf = array();

 if( $table and $filename ){
   eval("\$table_name = $table;");
   $result = $db->sql_query("select id, meta_id from $table_name where filename = '$filename'");
   $row = $db->sql_fetchrow( $result );
   if( !$row[id] ) {
    $page_id = 1;
    $cat_id = 1;
    $id = 1;
    $meta_id = 1;
    include "includes/link_errors.inc.php";
   } else {
    $id = $row[id];
    $meta_id = $row[meta_id] ? $row[meta_id] : 1;
   }
 }

 switch( $page_id ) {
  case 3: $id = 0;
  case 2: $art = new article();
	  $art->init(ARTICLES_TABLE, $id);
	  break;

  case 5: $id = 0;
  case 4:
	  if( $action == "single_press"){
	    $press = new press();
	    $press->init(PRESS_TABLE, $id);
	  } else {
	    $news = new news();
	    $news->init(NEWS_TABLE, $id);
	  }
	  break;
  case 7: $id = 0;
  case 6: $interviews = new interviews();
	  $interviews->init(INTERVIEWS_TABLE, $id);
	  break;
  case 22: $editors_desk = new editors_desk();
	  $editors_desk->init(EDITORS_DESK_TABLE, $id);
	  break;
 }

 $result = $db->sql_query("SELECT
   n.id, n.name, n.table_name, n.left_id, n.right_id, n.head_id, c.filename as contents, c.head_contents,
   m.id as meta_id, m.title, m.description, m.keywords
   FROM        ".NAVIGATION_TABLE." n
   INNER JOIN  ".CONTENTS_TABLE." c on n.contents_id = c.id
   INNER JOIN  ".METAPAGES_TABLE." m on n.meta_id = m.id
   WHERE n.id = '$page_id' AND n.category = '$cat_id'") or die( mysql_error() );

 $rows = $db->sql_numrows($result);

 if( !$rows ){ $navig = array("left_id" => 1, "right_id" => 1, "contents" => "main_contents.php" ); }
 else { $navig = $db->sql_fetchassoc($result); if( $navig[meta_id] and $meta_id == 1 ){ $meta_id = $navig[meta_id]; }   }

 $row = $db->sql_single_row("select filename from ".T_FRAMES_TABLE. " where id = '$navig[head_id]'");
 $head_inner  = $row[filename] ? $row[filename] : SSI_TOP;
 if($navig[left_id]==='0'){
  $left_inner = FALSE;
 }else{
  $row = $db->sql_single_row("select filename from ".L_FRAMES_TABLE. " where id = '$navig[left_id]'");
  $left_inner  = $row[filename] ? $row[filename] : SSI_LEFT;
 }
 if($navig[right_id]==='0'){
  $right_inner = FALSE;
 }else{
  $row = $db->sql_single_row("select filename from ".R_FRAMES_TABLE. " where id = '$navig[right_id]'");
  $right_inner = $row[filename] ? $row[filename] : SSI_RIGHT;
 }

 $banner_change_res = $db->sql_query("select * from ".BANNER_CHANGE_TABLE." where nav_id='$page_id' and ('$filename' like filename or filename='all') and enabled='y' limit 1");
 $banner_change_row=$db->sql_fetchrow($banner_change_res);

 $result = $db->sql_query("select m.title, m.description, m.keywords from ".METATAGS_TABLE." m where m.id = $meta_id") or die( mysql_error() );
 $meta_tags = $db->sql_fetchrow( $result );
 if(stripos($meta_tags[title],$defmeta['site'])===false){
  $meta_tags[title].=$defmeta['prefix'].$defmeta['site'];
 }

  // Check for Prestitial (commersial)
  //

 $c_prestitial=$_COOKIE[prestitial];
 if( preg_match( "/Mozilla/", $_SERVER[HTTP_USER_AGENT] )&&!preg_match( "/google/i", $_SERVER[HTTP_USER_AGENT] ) ){  // Show prestitial advert only if browser detected and not google - Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)		66.249.65.19
   if(preg_match("/$_SERVER[SERVER_NAME]/",$_SERVER['HTTP_REFERER'])){
      $c_prestitial=1;
   }elseif(!$c_prestitial&&$banner_prestitial=get_phpAdsNew_banners(110,1)){
     $_prestitial[display_period]=24;
     $_prestitial[refresh_interval]=10;
   }
 }

 if( !$_COOKIE[order_by] ) $_COOKIE[order_by]='date';
 if( !$_COOKIE[order_direction] ) $_COOKIE[order_direction]='desc';
 $_COOKIE[prestitial]=(($_COOKIE[prestitial]||$banner_prestitial)?1:0);
 setcookie("order_by", $_COOKIE[order_by], time()+ 24*60*60,"/" );
 setcookie("order_direction", $_COOKIE[order_direction], time()+ 24*60*60,"/" );
 setcookie("prestitial", (($_COOKIE[prestitial]||$banner_prestitial)?1:0), time()+ 24*60*60,"/" );
 
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<?php

 echo "<title>$meta_tags[title]</title>
 <meta name=\"description\" content=\"$meta_tags[description]\">
 <meta name=\"keywords\" content=\"$meta_tags[keywords]\">\n";

 if( $_prestitial and !$c_prestitial ){
  echo "<meta http-equiv=\"refresh\" content=\"$_prestitial[refresh_interval];url=$_SERVER[REQUEST_URI]\">\n";
 }


 require("contents/count.php");

?>

<script language="javascript" type="text/javascript" src="/js/functions.js"></script>
<base href = "http://<?php echo $_SERVER[HTTP_HOST]; ?>/">
<link href="/css/<?php
 if($right_inner&&$left_inner){echo "2col_struct.css";}
 elseif($left_inner){echo "2col_struct_without_rf.css";}
 elseif($right_inner){echo "1col_struct_with_rf.css";}
 else{echo "1col_struct.css";}
?>" rel="stylesheet" type="text/css">
<LINK REL="alternate" TITLE="Hostreview RSS" HREF="http://www.hostreview.com/rss_xmls/3_rss.xml" TYPE="application/rss+xml">
<link rel="shortcut icon" href="/images/hr_icon.ico">
</head>
<body class="background" onLoad=" MM_preloadImages('/images/field_background_onfocus.gif','/images/nav/fillmenuover.gif','/images/nav/startmenucornover.gif','/images/nav/leftmenucornactiveover.gif','/images/nav/rightmenucornactiveover.gif','/images/nav/rightmenucornover.gif','/images/nav/rightmenucornpreover.gif','/images/nav/finalmenucornover.gif');">

<?php

if(!($_prestitial and !$c_prestitial)) {
  echo "
  <div id=\"all\">
  <div id=\"site\">
  ";
}
echo "
<div id=\"head\">
";

	  if( ( $_prestitial and !$c_prestitial) ) {
	    $string_inner =  file_get_contents( "ssi3/top_index_ad.htm" );
            echo str_replace( "<!--DATE-->", "<span style=\"color: white\">".date('m-d-Y')."</span>&nbsp;", $string_inner );
          } else {
	    $string_inner =  file_get_contents( $head_inner );
	    $string_inner = str_replace( "<!--DATE-->", "<span style=\"color: white\">".date('m-d-Y')."</span>&nbsp;", $string_inner );
	    if($banner_change_row[leaderboard_banner]&&$banner_change_row[leaderboard_n_param]){
	     $string_inner = preg_replace("#(<\!--\s*Leaderboard\s*Banner\s*Start\s*-->.*what=zone:)\d+(\D.*<noscript>.*adclick\.php\?n=)\w+('.*adview\.php\?what=zone:)\d+(&amp;n=)\w+('.*<\!--\s*Leaderboard\s*Banner\s*End\s*-->)#siU","\${1}$banner_change_row[leaderboard_banner]\${2}$banner_change_row[leaderboard_n_param]\${3}$banner_change_row[leaderboard_banner]\${4}$banner_change_row[leaderboard_n_param]\${5}<!--!!changed!!-->",$string_inner);
	    }
	    echo $string_inner;
	  }

echo "</div>";
 if( $_prestitial and !$c_prestitial ) {  // If prestitial

   echo "<div id=\"prest\">Advertisement - <a href=\"$_SERVER[REQUEST_URI]\" id=\"click_continue\">Click here</a> to continue to HostReview<br>"; 

	?> 
	<script language="JavaScript">

	function doLoad()
	{
	    setTimeout( "refresh()", <?=$_prestitial[refresh_interval]?>*1000 );
	}

	function refresh()
	{
	  try{
	       document.getElementById('click_continue').click();
	     }catch(err){
                 	  try{
                               top.location = '<?=$_SERVER[REQUEST_URI]?>';
	                     }catch(err2){}
            }
	}

	</script>
	<script language="JavaScript" for="window" event="onload">

	doLoad();
	
	</script>
	<?php
   
echo $banner_prestitial[0];
    
   echo "</div>";

 } else {  // Usual site view

echo "
<div id=\"page\">
";
	if($left_inner){
echo "
<div id=\"leftcol\">
";
         $left_file = file_get_contents( $left_inner );
         if($banner_change_row[button_banner]&&$banner_change_row[button_n_param]){
	  $left_file = preg_replace("#(<\!--\s*Button\s*Banner\s*Start\s*-->.*what=zone:)\d+(\D.*<noscript>.*adclick\.php\?n=)\w+('.*adview\.php\?what=zone:)\d+(&amp;n=)\w+('.*<\!--\s*Button\s*Banner\s*End\s*-->)#siU","\${1}$banner_change_row[button_banner]\${2}$banner_change_row[button_n_param]\${3}$banner_change_row[button_banner]\${4}$banner_change_row[button_n_param]\${5}<!--!!changed!!-->",$left_file);
	 }
         echo $left_file;
echo "
</div>
";
  }

echo "
<div id=\"centralcol\">
";
  include "contents/$navig[contents]";
echo "
</div>
</div>
";

 } // End usual site view

echo "
<div id=\"feedb\">
";

 readfile( 'ssi3/feedb2_inner.html' );

echo "
</div>
<div id=\"foot\">
";

 readfile(SSI_BOTTOM);

echo "
</div>
";

if(!($_prestitial and !$c_prestitial)) {
  echo "
  </div>
  <div id=\"outside\">";

	if($right_inner){
echo "
<div id=\"rightcol\">
";
         $pos = strpos($right_inner,'.');
         $file_type = substr($right_inner,$pos+1);

         if($file_type == "htm" || $file_type == "html" )
         {
	   $right_file = file_get_contents( $right_inner );
	   if($banner_change_row[skyscraper_banner]&&$banner_change_row[skyscraper_n_param])
           {
	      $right_file = preg_replace("#(<\!--\s*Skyscraper\s*Banner\s*Start\s*-->.*what=zone:)\d+(\D.*<noscript>.*adclick\.php\?n=)\w+('.*adview\.php\?what=zone:)\d+(&amp;n=)\w+('.*<\!--\s*Skyscraper\s*Banner\s*End\s*-->)#siU","\${1}$banner_change_row[skyscraper_banner]\${2}$banner_change_row[skyscraper_n_param]\${3}$banner_change_row[skyscraper_banner]\${4}$banner_change_row[skyscraper_n_param]\${5}<!--!!changed!!-->",$right_file);
           }
	   echo $right_file;
         }
         else
         {
           include  $right_inner;
         }

echo "
</div>
";
	}

echo "
  </div>
  </div>
  ";
}

?>

<!-- /left col outside structure -->


<script src="http://www.google-analytics.com/urchin.js" type="text/javascript">  
</script> 
<script type="text/javascript"> 
_uacct = "UA-230221-1"; 
urchinTracker(); 
</script>
</body>
</html>