<?php
	session_start(); 
	include('scripts/bbdd.mysql.php');
	include('scripts/bbdd.funciones.php');
	//include('scripts/autopublish.php');
	
	// REGISTRO DE WEBSITE _________________________________________________________________________________________________________________
	$this_web_dominio = str_replace('www.', "", strtolower($_SERVER['SERVER_NAME']));;
	$this_web_sql_query = "SELECT * FROM websites WHERE visible=1 AND dominio='" . $this_web_dominio . "' ORDER BY id DESC";
	$this_web_sql_rs = mysql_query($this_web_sql_query, $mysql_connect);
	$this_web_sql_row_rs = mysql_fetch_assoc($this_web_sql_rs);
	$this_web_sql_totalrows_rs = mysql_num_rows($this_web_sql_rs);
	if ($this_web_sql_totalrows_rs<1) {
		$end = 'No Web found!';
		echo end($end);
	}

	// REGISTRO DE CONTENIDO/CATEGORIA _____________________________________________________________________________________________________
	// Rutas de archivos ficticios -------------------------------------------------------------------------------
	// Corrección ante errores HTTP
	if ($errorHTTP!="") {
		$file = "index.php";
	} else { 
		$file = strtolower($REQUEST_URI); // Guardo la ruta del archivo solicitado, en minúsculas
	}
	// Archivo solicitado
	while (ereg ("/", $file)) {
		// Hay barras
		$file = strrchr ( $file, "/"); // Capturo texto desde la barra
		$file = substr($file, 1); // Elimino el primer carácter del texto, que es la barra
	}
	if (ereg ("\?",$file)) {
		$file = substr($file, 0, strpos($file, "?"));
	}
	// Variable de carro
	if (ereg ("\?",$REQUEST_URI)) {
		$requestvar = strrchr ($REQUEST_URI,"?");
		$requestvar = substr($requestvar, 1);
	} else {
		$requestvar = "";
	}
	
	// Asignación de contenido referente a la ruta ---------------------------------------------------------------
	$is_home = false;
	$is_post = false;
	$is_cat = false;

	$is_full_about = false;
	$is_full_search = false;
	$is_full_contact = false;
	$is_full_advertising = false;
	$is_full_banners = false;
	$is_full_sitemap = false;
	$is_full_privacy = false;
	$is_full_legal = false;
	
	$this_cat = 0;
	if ( ($file=="") || (ereg ("index.", $file)) || (ereg ("index-.", $file)) || (ereg ("default.", $file)) || (ereg ("indice.", $file)) ) {
		// El usuario esta solicitando la página principal
		$is_home = true;
		$errorHTTP = "";
	} else {
		if ( ($file=="about.php") || ($file=="search.php") || ($file=="contact.php") || ($file=="advertising.php") || ($file=="banners.php") || ($file=="sitemap.php") || ($file=="privacy.php") || ($file=="legal.php") ) {
			// El usuario busca una página estática, no post.
			if ($file=="about.php") $is_full_about = true;
			if ($file=="search.php") $is_full_search = true;
			if ($file=="contact.php") $is_full_contact = true;
			if ($file=="advertising.php") $is_full_advertising = true;
			if ($file=="banners.php") $is_full_banners = true;
			if ($file=="sitemap.php") $is_full_sitemap = true;
			if ($file=="privacy.php") $is_full_privacy = true;
			if ($file=="legal.php") $is_full_legal = true;
		} else {
			// El usuario solicita una página Web, la buscamos en 'contenidos' con el nombre exacto
			//$this_cntcat_sql_query = "SELECT * FROM cnt_to_cat WHERE visible=1 AND id_web=". intval($this_web_sql_row_rs['id']) ." AND url='" . $file . "' ORDER BY id DESC";
			$this_cntcat_sql_query = "SELECT *, cnt_to_cat.id AS id FROM cnt_to_cat,contenidos WHERE cnt_to_cat.visible=1 AND cnt_to_cat.id_web=". intval($this_web_sql_row_rs['id']) ." AND cnt_to_cat.url='" . $file . "' AND contenidos.id=cnt_to_cat.id_cnt ORDER BY cnt_to_cat.id DESC";
			$this_cntcat_sql_rs = mysql_query($this_cntcat_sql_query, $mysql_connect);
			$this_cntcat_sql_row_rs = mysql_fetch_assoc($this_cntcat_sql_rs);
			$this_cntcat_sql_totalrows_rs = mysql_num_rows($this_cntcat_sql_rs);
			if ($this_cntcat_sql_totalrows_rs < 1) {
				// No se encuentra en 'contenidos' -> Buscamos en 'categorias'
				mysql_free_result($this_cntcat_sql_rs);
				
				$this_cat_sql_query = "SELECT * FROM categorias WHERE visible=1 AND id_web=". intval($this_web_sql_row_rs['id']) ." AND url<>'' AND url='" . $file . "' ORDER BY id DESC";
				$this_cat_sql_rs = mysql_query($this_cat_sql_query, $mysql_connect);
				$this_cat_sql_row_rs = mysql_fetch_assoc($this_cat_sql_rs);
				$this_cat_sql_totalrows_rs = mysql_num_rows($this_cat_sql_rs);
				if ($this_cat_sql_totalrows_rs >= 1) {
					// Se encontró categoria
					$is_cat = true;
					$this_cat = intval($this_cat_sql_row_rs['id']);
				} else {
					// No se encontró categoria -> Abrimos homepage
					$is_home = true;
				}
			} else {
				// Se encuentra en 'contenidos'
				$is_post = true;
				$this_cat = intval($this_cntcat_sql_row_rs['id_cat']);
			}
		}
	}
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
    "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
	<?php
	$META_title = $META_description = $META_keywords = "";
	if ($this_web_sql_row_rs['idioma']=='es') {
		$txt_tmp1 = 'en';
	} else {
		$txt_tmp1 = 'in';
	}
	if ($is_cat) {
		// Categorias
		$META_title = trim($this_cat_sql_row_rs['meta_title']);
		$META_description = trim($this_cat_sql_row_rs['meta_desc']);
		$META_keywords = trim($this_cat_sql_row_rs['meta_keys']);
	} else {
		if ($is_post) {
			// Contenido
			$categoria_sql_query = "SELECT * FROM categorias WHERE id=". intval($this_cntcat_sql_row_rs['id_cat']) ." ORDER BY id DESC";
			$categoria_sql_rs = mysql_query($categoria_sql_query, $mysql_connect);
			$categoria_sql_row_rs = mysql_fetch_assoc($categoria_sql_rs);

			$META_title = trim(trim($this_cntcat_sql_row_rs['meta_title_prefijo']) .' '. $txt_tmp1 .' '. trim($categoria_sql_row_rs['meta_title_sufijo']));
			$META_description = trim(trim($this_cntcat_sql_row_rs['meta_desc_prefijo']) .'. '. trim($categoria_sql_row_rs['meta_desc_sufijo']));
			$META_keywords = trim(trim($this_cntcat_sql_row_rs['meta_keys_prefijo']) .' '. trim($categoria_sql_row_rs['meta_keys_sufijo']));

			mysql_free_result($categoria_sql_rs);
		} else {
			// Página principal
			$META_title = trim($this_web_sql_row_rs['meta_title']);
			$META_description = trim($this_web_sql_row_rs['meta_desc']);
			$META_keywords = trim($this_web_sql_row_rs['meta_keys']);
		}
	}
	?><title><?php echo $META_title; ?></title>
	<meta name="title" content="<?php echo $META_title; ?>">
	<meta name="description" content="<?php echo $META_description; ?>">
	<link rel="image_src" href="<?php
    	if ($is_post) {
			echo 'http://www.'. $this_web_dominio .'/images/'. str_replace('.php', '.jpg', $this_cntcat_sql_row_rs['url']);
		} else {
			echo 'http://www.'. $this_web_dominio .'/imgs/img-facebook.jpg';
		}
	?>">
	<meta name="keywords" content="<?php echo $META_keywords; ?>">
	<meta name="robots" content="index,follow">
	<meta name="language" content="<?php echo $this_web_sql_row_rs['idioma']; ?>">
	<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
    <meta property="fb:admins" content="100002017063181,543841872">
    <meta property="fb:app_id" content="<?php echo $this_web_sql_row_rs['facebook_commentsbox']; ?>">
	<link href="_css.php?w=<?php echo str_replace($dominio_ext, "", $this_web_dominio); ?>" rel="stylesheet" type="text/css">
    <script type="text/javascript" src="http://code.jquery.com/jquery-latest.min.js"></script>
	<script type="text/javascript" src="_js.php"></script>
	<link rel="alternate" type="application/rss+xml" title="<?php echo str_replace("oh", "oh!", str_replace($dominio_ext, "", $this_web_dominio)); ?> RSS" href="http://www.<?php echo $this_web_dominio; ?>/rss.php">
</head>
<body>
	<div align="center" class="center">
		<div id="head">
			<div id="webs">
			  	<?php
				$web_sql_query = "SELECT * FROM websites WHERE visible=1 AND idioma='". $this_web_sql_row_rs['idioma'] ."' AND orden<>8 AND orden<>9 AND orden<>10 ORDER BY orden ASC, id ASC";
				$web_sql_rs = mysql_query($web_sql_query, $mysql_connect);
				$web_sql_row_rs = mysql_fetch_assoc($web_sql_rs);
				$web_sql_totalrows_rs = mysql_num_rows($web_sql_rs);
				if ($web_sql_totalrows_rs<1) {
					//echo "Error listing websites.";
				} else {
					$dominio_ext = array(".com", ".net", ".es", ".info", ".org");
					echo '<ul>' ."\n";
					do {
						if ($web_sql_row_rs['dominio']==$this_web_sql_row_rs['dominio']) {
							echo '<li class="selected">';
							echo '<img src="_imgs/ohwebs/'. str_replace($dominio_ext, "", $web_sql_row_rs['dominio']) .'-.png" alt="'. $web_sql_row_rs['meta_desc']  .'">';
							echo '</li>' ."\n";
						} else {
							// No es el dominio actual
							echo '<li>';
							echo '<a href="http://www.'. $web_sql_row_rs['dominio']  .'" target="_blank">';
							echo '<img src="_imgs/ohwebs/'. str_replace($dominio_ext, "", $web_sql_row_rs['dominio']) .'.png" alt="'. $web_sql_row_rs['meta_desc']  .'">';
							echo '</a>';
							echo '</li>' ."\n";
						}
					} while ($web_sql_row_rs = mysql_fetch_assoc($web_sql_rs)); 
					echo '</ul>';
				}
				mysql_free_result($web_sql_rs);
			  ?> 
		    </div>
			<div id="logo">
				<?php
				echo '<a href="http://www.'. $this_web_sql_row_rs['dominio']  .'/index.php">';
				$dominio_ext = array(".com", ".net", ".es", ".info", ".org");
				echo '<img src="imgs/'. str_replace($dominio_ext, "", $this_web_sql_row_rs['dominio'])  .'.gif" alt="'. $this_web_sql_row_rs['meta_desc']  .'" border="0">';
				echo '</a>';
				?> 
			</div>
			<div id="supmenu">
				<?php
					if ($this_web_sql_row_rs['idioma']=='es') {
						$supmenu_txt1 = 'Historial';
						$supmenu_txt2 = 'Contacto';
						$supmenu_txt3 = 'English';
					} else {
						$supmenu_txt1 = 'History';
						$supmenu_txt2 = 'Contact';
						$supmenu_txt3 = 'Español';
					}
					
					echo '<a href="sitemap.php">'. $supmenu_txt1 .'</a>';
					echo ' | ';
					echo '<a href="contact.php">'. $supmenu_txt2 .'</a>';
					echo ' | ';
					
					$this_web_idi_sql_query = "SELECT * FROM websites WHERE visible=1 AND id='" . $this_web_sql_row_rs['id_web_idi'] . "' ORDER BY id DESC";
					$this_web_idi_sql_rs = mysql_query($this_web_idi_sql_query, $mysql_connect);
					$this_web_idi_sql_row_rs = mysql_fetch_assoc($this_web_idi_sql_rs);
					$this_web_idi_sql_totalrows_rs = mysql_num_rows($this_web_idi_sql_rs);
					if ($this_web_idi_sql_totalrows_rs<1) {
						echo 'No Web found!';
					} else {
						echo '<a href="http://www.'. $this_web_idi_sql_row_rs['dominio']  .'" class="lang" target="_blank" title="'. $this_web_idi_sql_row_rs['meta_desc']  .'">'. $supmenu_txt3 .'</a>';
					}
					mysql_free_result($this_web_idi_sql_rs);
				?> 
			</div>
		  	<div id="search">
				<?php 
				echo '<form name="searchform" id="searchform" method="post" action="search.php" onsubmit="return validarsearch(this,\''. $this_web_sql_row_rs['idioma'] .'\')">' ."\n"; 
				if ($this_web_sql_row_rs['idioma']=='es') {
					$field_value = 'Quiero buscar...';
				} else {
					$field_value = 'I want to search...';
				}
				echo '<input name="searchtext" id="searchtext" type="text" value="'. $field_value .'" onClick="this.value=\'\'" onFocus="this.value=\'\'">' ."\n";
				echo '<a href="javascript: document.searchform.submit()"><img src="_imgs/search-button.gif" width="9" height="9" border="0"></a>' ."\n";
				echo '</form>'; 
				?> 
			</div>
			<div id="social">
				<?php
				$social_temp = str_replace("oh", "oh!", $this_web_sql_row_rs['dominio']);
				if ($this_web_sql_row_rs['idioma']=='es') {
					$social_txt1 = 'S&iacute;guenos en:';
					$social_txt2 = $social_temp .' en Facebook';
					$social_txt3 = $social_temp .' en Twitter';
					$social_txt4 = 'Feed RSS de '. $social_temp;
					$social_txt5 = 'Comparte la Web de '. $social_temp;
					$social_txt6 = 'Sugiérenos un enlace Web';
				} else {
					$social_txt1 = 'Follow us:';
					$social_txt2 = $social_temp .' in Facebook';
					$social_txt3 = $social_temp .' in Twitter';
					$social_txt4 = 'Feed RSS of '. $social_temp;
					$social_txt5 = 'Share Website of '. $social_temp;
					$social_txt6 = 'Suggest us a Website link';
				}
				
				echo $social_txt1 ."\n";
				echo '<a href="'. $this_web_sql_row_rs['url_facebook']  .'" target="_blank"><img src="_imgs/facebook.gif" width="16" height="16" border="0" alt="'. $social_txt2 .'"></a> ' ."\n";
				echo '<a href="'. $this_web_sql_row_rs['url_twitter']  .'" target="_blank"><img src="_imgs/twitter.gif" width="14" height="16" border="0" alt="'. $social_txt3 .'"></a> ' ."\n";
				echo '<a href="http://www.'. $this_web_sql_row_rs['dominio']  .'/rss.php" target="_blank"><img src="_imgs/feed-rss.gif" width="16" height="16" border="0" alt="'. $social_txt4 .'"></a> ' ."\n";

				// Addthis button
				echo '<a class="addthis_button spaced" href="http://www.addthis.com/bookmark.php?v=250&amp;username=ohpromotions">';
				echo '<img src="imgs/share-this.png" border="0" alt="'. $social_txt5 .'">';
				echo '</a>' ."\n";
				?>
				<script type="text/javascript" src="http://s7.addthis.com/js/250/addthis_widget.js#username=ohpromotions"></script>
				<script type="text/javascript">
					var addthis_config = {
						ui_cobrand: "<?php echo $this_web_dominio; ?>",
						ui_language: "<?php echo $this_web_sql_row_rs['idioma']; ?>",
						ui_header_color: "#ffffff",
						ui_header_background: "#3b3b3b",
						ui_offset_top: 0,
						ui_offset_left: 0,
						services_compact: 'facebook, twitter, email, favorites,digg,meneame,delicious,technorati,linkedin, bitly, google, more',
						services_exclude: 'print'
					}
				</script>
				<?php
				
				echo ' <a href="contact.php?subject=3"><img src="imgs/suggest-link.png" width="126" height="24" border="0" alt="'. $social_txt6 .'"></a>';
				?> 
			</div>
		  	<div id="menu">
				<?php
				$cat_sql_query = "SELECT * FROM categorias WHERE visible=1 AND url<>'' AND id_web=". $this_web_sql_row_rs['id'] ." ORDER BY orden ASC, id DESC";
				$cat_sql_rs = mysql_query($cat_sql_query, $mysql_connect);
				$cat_sql_row_rs = mysql_fetch_assoc($cat_sql_rs);
				$cat_sql_totalrows_rs = mysql_num_rows($cat_sql_rs);
				if ($cat_sql_totalrows_rs<1) {
					echo "Error listing categories.";
				} else {
					switch ($cat_sql_totalrows_rs) {
						case 5:
						case 6:
							$tabla_fil = 2;
							$tabla_col = 3;
							break;
						case 7:
						case 8:
							$tabla_fil = 2;
							$tabla_col = 4;
							break;
						case 9:
							$tabla_fil = 3;
							$tabla_col = 3;
							break;
						case 10:
						case 11:
						case 12:
							$tabla_fil = 3;
							$tabla_col = 4;
							break;
						default:
							$tabla_fil = 2;
							$tabla_col = 2;
					}				
				
					echo '<table border="0" cellspacing="0" cellpadding="0">' ."\n";
					$table_this_fil = 1;
					$table_this_col = 0;
					do {
						$table_this_col ++;
						// Creo el TR inicial
						if ($table_this_col == 1) { 
							echo '<tr>' ."\n"; 
						}
						// Controlo el cerrar y abrir TR
						if ($table_this_col > $tabla_col) {
							$table_this_col = 1;
							$table_this_fil ++;
							echo '</tr>' ."\n";
							echo '<tr>' ."\n";
						}
						// Abro TD teniendo en cuenta lo especial del primero
						if ($table_this_col == 1) {
							echo '<td class="nopadding">';
						} else {
							echo '<td>';
						}
		
						echo '<a href="'. $cat_sql_row_rs['url']  .'" title="'. $cat_sql_row_rs['meta_title']  .'"';
						if (intval($cat_sql_row_rs['id'])==$this_cat) echo ' class="selected"';
						echo '>';
						
						echo $cat_sql_row_rs['nombre'];
						echo '</a>';
						echo '</td>' ."\n";
					} while ($cat_sql_row_rs = mysql_fetch_assoc($cat_sql_rs)); 
					
					for ($i = $table_this_col + 1; $i <= $tabla_col; $i++) {
						echo '<td>&nbsp;</td>' ."\n";
					}					
					echo '</tr>' ."\n";
					echo '</table>';
				}
				mysql_free_result($cat_sql_rs);
				?>
			</div>
		</div>
		<?php
			$include_file='';
			
			if ($is_cat) $include_file='_index.category.php';
			if ($is_post) $include_file='_index.post.php';
			if ($is_full_contact) $include_file='_index.contact.php';
			if ($is_full_sitemap) $include_file='_index.sitemap.php';
			if ($is_full_about) $include_file='_index.about.php';
			if ($is_full_legal) $include_file='_index.legal.php';
			if ($is_full_privacy) $include_file='_index.privacy.php';
			if ($is_full_contact) $include_file='_index.contact.php';
			if ($is_full_search) $include_file='_index.search.php';
			if ($is_full_banners) $include_file='_index.banners.php';
				
			if (($include_file=='') || ($is_home)) $include_file='_index.homepage.php';
			
			include ($include_file);
		?> 
		<div id="footer"> 
			<?php
			echo '<p class="menu">';
			echo '<b>Copyright 2009-'. date('Y') .' '. $this_web_sql_row_rs['dominio'] .'</b>';
			
			if ($this_web_sql_row_rs['idioma']=='es') {
				$supmenu_txt1 = 'Quiénes somos';
				$supmenu_txt2 = 'Política de privacidad';
				$supmenu_txt3 = 'Contacta con nosotros';
				$supmenu_txt4 = 'Aviso legal';
			} else {
				$supmenu_txt1 = 'About us';
				$supmenu_txt2 = 'Privacy policy';
				$supmenu_txt3 = 'Contact us';
				$supmenu_txt4 = 'Legal note';
			}
			
			echo ' <i>*</i> ';
			echo '<a href="about.php">'. $supmenu_txt1 .'</a>';
			echo ' <i>*</i> ';
			echo '<a href="legal.php">'. $supmenu_txt4 .'</a>';
			echo ' <i>*</i> ';
			echo '<a href="privacy.php">'. $supmenu_txt2 .'</a>';
			echo ' <i>*</i> ';
			echo '<a href="contact.php">'. $supmenu_txt3 .'</a>';

			echo '</p>' ."\n";
			
			echo '<p class="desc">';
			echo $META_description;
			echo '</p>' ."\n";
			?>
	  	</div> 
		<div class="break">&nbsp;</div> 
	</div> 
<?php
	// CÓDIGO ANALYTICS
	echo $this_web_sql_row_rs['code_analytics'];
?>
</body>
</html>