<? 
$connection = mysqli_connect('127.0.0.1', '230417_sabado', 'UrwECyZEsiSHngJI', '230417_sabado');
mysqli_set_charset($connection,"utf8");
?><?	function str_lreplace($search, $replace, $subject) {
		while(($offset = strpos($subject, $search)) !== false) {
			$subject = substr_replace($subject, $replace, $offset, strlen($search));
			
		}
		$subject_apostrofe = str_replace("'", "&#39;", $subject);
		$final = str_replace('"', "&#34;", $subject_apostrofe);
		return $subject;
	}
	function sanitize($data) {
		include("admin/conexion.php");
		$data = trim($data);
		$data = stripslashes($data);
		$data = htmlspecialchars($data);
		mysqli_real_escape_string($connection,$data);
		return $data;
	}
	
	
	function replace_width_height($content,$newWidth,$newHeight) {
// 		if ($newWidth == '100%') { }
	$content = preg_replace(
		array('/width="\d+"/i', '/height="\d+"/i'),
		array(sprintf('width="%s"', $newWidth), sprintf('height="%s"', $newHeight)),
  		$content);
  		return $content;
	}
	
?><? function admin_counter($cat,$id,$lang,$url) {
	include ( dirname(__DIR__).'/admin/conexion.php');
	date_default_timezone_set('America/Argentina/Buenos_Aires');
	if ($cat) {
		$b = mysqli_query($connection,"select * from admin_stats where categoria='".$cat."' and id_content='".$id."' and lang='".$lang."' and url='".$url."'");
		If ( mysqli_num_rows($b) == 0) {

			$today = date_create();
			mysqli_query($connection,"INSERT into admin_stats (`categoria`, `id_content`, `lang`,`visits`,`datetime`,`url`) values ('".$cat."', '".$id."', '".$lang."', '1','".date_format($today,"Y-m-d H:i:s")."', '".$url."')");
		} else {
			mysqli_query($connection,"update admin_stats set visits= visits+1 where categoria='".$cat."' and id_content='".$id."' and lang='".$lang."' and url='".$url."'");
		}
	}
  } 
date_default_timezone_set('America/Argentina/Buenos_Aires');
$c = mysqli_query($connection,"select * from admin_stats_time where DATE_FORMAT(admin_stats_time.datetime, '%Y-%m-%d') = CURDATE()");
If ( mysqli_num_rows($c) == 0) {
	mysqli_query($connection,"INSERT into admin_stats_time (`datetime`,`count`,`count_unique`) values (NOW(), '1','1')");
} else {
	if (isset($_SESSION['macxoom_counter_unique']) && (time() - $_SESSION['macxoom_counter_unique'] > 1800)) {
		unset($_SESSION['macxoom_counter_unique']);
	}
	if (!isset($_SESSION["macxoom_counter_unique"])) { $unique_count = "count_unique= IFNULL(count_unique, 0)+1,"; }
	mysqli_query($connection,"update admin_stats_time set count= IFNULL(count, 0) + 1, $unique_count datetime=NOW() where DATE_FORMAT(admin_stats_time.datetime, '%Y-%m-%d') = CURDATE()");

 	$_SESSION["macxoom_counter_unique"] = time();
}
admin_counter($_POST['stat_cat'],$_POST['stat_id'],$_POST['stat_lang'],$_POST['stat_url']);  

?><? function admin_seosem($cat,$id,$lang) {
	include ( dirname(__DIR__).'/admin/conexion.php');
	if ($cat) {
		if ($lang == NULL) { $l = " and lang IS NULL";} else { $l =  " and lang='".$lang."'"; $idioma_q ="_".$lang; }
		$select_site_info = mysqli_query($connection,"select * from admin_seo where categoria='".$cat."' and id_content='".$id."'".$l);
		$info_site=mysqli_fetch_object($select_site_info);
		$item_titulo = $info_site->titulo;		
		if ($info_site->titulo =="" && $info_site->descripcion =="" && $info_site->keywords =="") {
			$select_site_info2 = mysqli_query($connection,"select * from admin_seo where categoria='".$cat."' and id_content='0'".$l);
			$info_site=mysqli_fetch_object($select_site_info2);
			$item_titulo = $info_site->titulo;
			if ($info_site->def ==1) {
				$select_item = mysqli_query($connection,"select * from ".$cat." where id='".$id."'");
				$f_titulo=mysqli_fetch_object($select_item);
				$nombre_field = mysqli_query($connection,"SHOW COLUMNS FROM ".$cat." LIKE 'nombre".$idioma_q."'");
				$titulo_field = mysqli_query($connection,"SHOW COLUMNS FROM ".$cat." LIKE 'titulo".$idioma_q."'");
				$subtitulo_field = mysqli_query($connection,"SHOW COLUMNS FROM ".$cat." LIKE 'subtitulo".$idioma_q."'");
				$descripcion_breve_field = mysqli_query($connection,"SHOW COLUMNS FROM ".$cat." LIKE 'descripcion_breve".$idioma_q."'");
				if (mysqli_num_rows($nombre_field)) { $item_titulo = $f_titulo->{"nombre".$idioma_q}; }
				else if (mysqli_num_rows($titulo_field)) { $item_titulo = $f_titulo->{"titulo".$idioma_q}; $item_subtitulo = $f_titulo->{"subtitulo".$idioma_q}; }
				else  { $item_titulo = $info_site->titulo; $item_subtitulo = $info_site->subtitulo;  }
			}
		}

				$select_img_item = mysqli_query($connection,"select * from imagenes where categoria='".$cat."' and id_content='".$id."' order by listorder asc limit 1");
				$num_img = mysqli_num_rows($select_img_item);
				if ($num_img > 0) { 
					$img_redes = mysqli_fetch_object($select_img_item); 
				} else {
					$select_img_item = mysqli_query($connection,"select * from imagenes where categoria='general_sitio' limit 1");
					$img_redes = mysqli_fetch_object($select_img_item);
				}
		If ( mysqli_num_rows($select_site_info) != 0 ||  mysqli_num_rows($select_site_info2) != 0) { 
			$s_t = $item_titulo;
			$s_d = str_replace('"',"",$item_subtitulo);
			$s_k = $info_site->keywords;
			$actual_link = (isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] === 'on' ? "https" : "http") . "://$_SERVER[HTTP_HOST]$_SERVER[REQUEST_URI]";
		} else {
			$select_site_info = mysqli_query($connection,"select * from admin_siteconf");
			$info_site=mysqli_fetch_object($select_site_info);
				$s_t = $info_site->siteconf_name;
				$s_d = $info_site->siteconf_description;
				$s_k = $info_site->siteconf_keywords;
		}
			
	} else {
		$select_site_info = mysqli_query($connection,"select * from admin_siteconf");
		$info_site=mysqli_fetch_object($select_site_info);
			$s_t = $info_site->siteconf_name;
			$s_d = $info_site->siteconf_description;
			$s_k = $info_site->siteconf_keywords;

		$select_img_item = mysqli_query($connection,"select * from imagenes where categoria='general_sitio' limit 1");
		$img_redes = mysqli_fetch_object($select_img_item);

	} ?>
			<title><? echo $s_t; ?></title>
			<META NAME="keywords" CONTENT="<? echo $s_k; ?>">
			<META NAME="description" CONTENT="<? echo $s_d; ?>">
			<META NAME="revisit-after" CONTENT="45 days">
			<META NAME="distribution" CONTENT="Global">
			<META NAME="robots" CONTENT="All">
			<META NAME="rating" CONTENT="General">
			<META HTTP-EQUIV="content-language" CONTENT="ES">
			<META NAME="dc.title" CONTENT="<? echo $s_t; ?>">
			<META NAME="dc.description" CONTENT="<? echo $s_d; ?>">
			<META NAME="dc.subject" CONTENT="<? echo $s_k; ?>">
			
			<meta property="og:type" content="article" />
			<meta property="og:title" content="<? echo $s_t; ?>" />
			<meta property="og:url" content="<? echo $actual_link; ?>" />
			<meta property="og:description" content="<? echo $s_d; ?>" />
			<meta property="og:site_name" content="SABADOGOL" />
			<meta property="og:image" content="<? echo "https://".$_SERVER['HTTP_HOST']."/img_tmp/". $img_redes->nombre_archivo; ?>" />
			<meta property="og:image:url" content="<? echo "https://".$_SERVER['HTTP_HOST']."/img_tmp/". $img_redes->nombre_archivo; ?>" />
			<meta property="og:image:secure_url" content="<? echo "https://".$_SERVER['HTTP_HOST']."/img_tmp/". $img_redes->nombre_archivo; ?>" />
			<meta property="og:image:width" content="1200" />
			<meta property="og:image:height" content="800" />
			<meta property="og:locale" content="es_ES" />
			<meta name="twitter:card" content="summary_large_image">
			<meta name="twitter:creator" content="@SABADOGOL">
			<meta name="twitter:site" content="@SABADOGOL">
			<meta name="twitter:title" content="<? echo $s_t; ?>">
			<meta name="twitter:description" content="<? echo $s_d; ?>">
			<meta name="twitter:image" content="<? echo "http://".$_SERVER['HTTP_HOST']."/img_tmp/". $img_redes->nombre_archivo; ?>">
			
			<link rel="apple-touch-icon" sizes="16x16" href="../favicons/favicon16.ico">
			<link rel="apple-touch-icon" sizes="32x32" href="../favicons/favicon32.ico">
			<link rel="apple-touch-icon" sizes="48x48" href="../favicons/favicon48.ico">
			<link rel="apple-touch-icon" sizes="64x64" href="../favicons/favicon64.ico">
			<link rel="apple-touch-icon" sizes="128x128" href="../favicons/favicon128.ico">
			<link rel="icon" type="image/ico" sizes="16x16" href="favicons/favicon16.ico">
			<link rel="icon" type="image/ico" sizes="32x32" href="favicons/favicon32.ico">
			<link rel="icon" type="image/ico" sizes="48x48" href="favicons/favicon48.ico">
			<link rel="icon" type="image/ico" sizes="64x64" href="favicons/favicon64.ico">
			<link rel="icon" type="image/ico" sizes="128x128" href="favicons/favicon128.ico">
			<link rel="icon" type="image/x-icon" href="../favicons/favicon128.ico" />
			<link rel="shortcut icon" type="image/x-icon" href="../favicons/favicon128.ico" />
			<link rel="icon" type="image/x-icon" href="../favicons/favicon128.ico?v=2"  />

<?  } 

// admin_seosem($_POST['stat_cat'],$_POST['stat_id'],$_POST['stat_lang']);  

?><? function banner($cual){ 
		if (!empty($cual)) { ?> 
		<div class="container">
			<div class="row">
				<div class="col-12 mt-4 text-center">
					<div class=" d-inline-block overflow-hidden" style="max-width:900px">			
						<div class="flexislider_banners mh-100px mw-100">	
							<ul class="slides">
							<? foreach ($cual as $banner1) { ?>
								<li> 
								<?	if ($banner1['links']) { ?><a href="<? echo $banner1['links']; ?>" target=_blank><? } ?>
									<img src="img_tmp/<? echo $banner1['imagen']; ?>" class="mw-100" border="0"></li>
									<? if ($banner1['links']) { ?></a><? } ?>
								</li>
							<? } ?>
						</div>
					</div>
				</div>
			</div>
		</div>
<? } } ?>
<? function banner_secundarios($cual){ 
		if (!empty($cual)) { ?> 
		<div class="container">
			<div class="row">
				<div class="col-12 my-2 text-center">
					<div class=" overflow-hidden">			
						<div class="flexislider_banners_secundarios carousel">	
							<ul class="slides">
							<? foreach ($cual as $banner1) { ?>
								<li> 
								<?	if ($banner1['links']) { ?><a href="<? echo $banner1['links']; ?>" target=_blank><? } ?>
									<img src="img_tmp/<? echo $banner1['imagen']; ?>"  border="0"></li>
									<? if ($banner1['links']) { ?></a><? } ?>
								</li>
							<? } ?>
						</div>
					</div>
				</div>
			</div>
		</div>
<? } } ?><!DOCTYPE html>
	<meta charset="utf-8">
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<? if (substr($_SERVER["SCRIPT_NAME"],strrpos($_SERVER["SCRIPT_NAME"],"/")+1) =="noticia.php"){ 
		$seo_pagina= "noticias";
		$seo_id = sanitize($_GET['id']);
	} else if (substr($_SERVER["SCRIPT_NAME"],strrpos($_SERVER["SCRIPT_NAME"],"/")+1) =='historia.php'){
		admin_counter('historia',0,'es','historia.php');
		admin_seosem('','','');	
	} else if (substr($_SERVER["SCRIPT_NAME"],strrpos($_SERVER["SCRIPT_NAME"],"/")+1) =='notas.php'){
		admin_counter('noticias',0,'es','notas.php');
		admin_seosem('noticias',sanitize($_GET['id']),'');	
	} else if (substr($_SERVER["SCRIPT_NAME"],strrpos($_SERVER["SCRIPT_NAME"],"/")+1) =='canchas.php'){
		admin_counter('canchas',0,'es','canchas.php');
		admin_seosem('','','');	
	} else if (substr($_SERVER["SCRIPT_NAME"],strrpos($_SERVER["SCRIPT_NAME"],"/")+1) =='fecha.php'){
		admin_counter('tablas',sanitize($_GET['id']),'es','fecha.php');
		admin_seosem('tablas',sanitize($_GET['id']),'');	
	} else if (substr($_SERVER["SCRIPT_NAME"],strrpos($_SERVER["SCRIPT_NAME"],"/")+1) =='categoria.php'){
		if (isset($_GET['id'])) {
			admin_counter('categorias',sanitize($_GET['id']),'es','categorias.php');
			admin_seosem('','','');		
		}{
			admin_counter('categorias',0,'es','categorias.php');
			admin_seosem('','','');		
		}
	}
	
	admin_seosem($seo_pagina,$seo_id,''); ?>
	<link rel="preconnect" href="https://fonts.googleapis.com">
	<link rel="preconnect" href="https://fonts.gstatic.com" crossorigin>
	<link href="https://fonts.googleapis.com/css2?family=Roboto+Condensed:wght@300;500;700&family=Roboto:wght@300;500;700&display=swap" rel="stylesheet">
	<link rel="stylesheet" href="css/bootstrap_custom.min.css">
	<link rel="stylesheet" href="css/flexslider.css">
	<link rel="stylesheet" href="css/jquery.fancybox.css">
	<link rel="stylesheet" href="css/jquery.bxslider.css">
	<link rel="stylesheet" href="css/slick.css">
	<link rel="stylesheet" href="css/animate.css">
	<link rel="stylesheet" href="css/style.css">
	<link rel="stylesheet" href="css/all.css">
  </head>
  <style type="text/css">
		.bk_celeste { background: <? echo $general_sitio->color1; ?>;}
		.bk_azul { background: <? echo $general_sitio->color2; ?>;}
		.bk3 { background: <? echo $general_sitio->color3; ?>; }
		.txt_color { color: #fff !important;}
		.txt_color_principal { color: <? echo $general_sitio->color1; ?> !important;}
		.accordion-button:not(.collapsed) { background: <? echo $general_sitio->color1; ?>; color: <? echo $general_sitio->color2; ?>; }
		.nav-link.cat_btn.active {background: <? echo $general_sitio->color3; ?>;}
		.bk_celeste_azul {
			background				: <? echo $general_sitio->color1; ?>;
			background				: -moz-linear-gradient(top, <? echo $general_sitio->color1; ?> 1%, <? echo $general_sitio->color2; ?> 100%);
			background				: -webkit-linear-gradient(top, <? echo $general_sitio->color1; ?> 1%,<? echo $general_sitio->color2; ?> 100%);
			background				: linear-gradient(to bottom, <? echo $general_sitio->color1; ?> 1%,<? echo $general_sitio->color2; ?> 100%);
			filter					: progid:DXImageTransform.Microsoft.gradient( startColorstr='#428cd5', endColorstr='#1e1739',GradientType=0 );
		}
		.bk_gradient {
			background-image				: <? echo $general_sitio->color1; ?>;
			background-image				: -moz-linear-gradient(top, <? echo $general_sitio->color1; ?> 50%, rgba(0,0,0,0) 100%);
			background-image				: -webkit-linear-gradient(top, <? echo $general_sitio->color1; ?> 50%,rgba(0,0,0,0) 100%);
			background-image				: linear-gradient(to bottom, <? echo $general_sitio->color1; ?> 50%, rgba(0,0,0,0) 100%);
			filter					: progid:DXImageTransform.Microsoft.gradient( startColorstr='#428cd5', endColorstr='#1e1739',GradientType=0 );
		}
		.container_noticias_home .card:hover {
			background				: <? echo $general_sitio->color1; ?> !important;
			color					: white
		}
		
		.accordion-button:not(.collapsed) { background: <? echo $general_sitio->color3; ?>; border:0px !important;box-shadow: 0 0 0 0rem rgba(0,0,0,0); }
		.accordion-button:focus {; border:0px !important;box-shadow: 0 0 0 0rem rgba(0,0,0,0);}
		.header_barra {
			background: <? echo $general_sitio->color1; ?>;
			background: -moz-linear-gradient(top,  <? echo $general_sitio->color1; ?> 0%, <? echo $general_sitio->color2; ?> 100%);
			background: -webkit-linear-gradient(top,  <? echo $general_sitio->color1; ?> 0%,<? echo $general_sitio->color2; ?> 100%);
			background: linear-gradient(to bottom,  <? echo $general_sitio->color1; ?> 0%,<? echo $general_sitio->color2; ?> 100%);
			filter: progid:DXImageTransform.Microsoft.gradient( startColorstr='#1e1739', endColorstr='#428cd5',GradientType=0 );
		}
  </style>
  
<body>
<div class="container">
<? include("includes/menu.php"); ?>
</div>