include "php/conexion.php" ?>
// Banners
if($query = $mysqli ->prepare("SELECT idbannerbajomenuresto, idbannerderechaopinion1, idbannerderechaopinion2, idbannerderechaopinion3 FROM configuracionbanners$_SESSION[idioma]")) {
$query->execute();
$query->bind_result($idbannerbajomenuresto, $idbannerderechaopinion1, $idbannerderechaopinion2, $idbannerderechaopinion3);
$query->fetch();
$query->close();
}
// Opinion
if($query = $mysqli ->prepare("SELECT idopinion, idredactor, fecha, titulo$_SESSION[idioma], titulo, tituloEN, resumen$_SESSION[idioma], texto$_SESSION[idioma] FROM opiniones WHERE idopinion = ?")) {
$query->bind_param('i', $_REQUEST["idopinion"]);
$query->execute();
$query->bind_result($idopinion, $idredactor, $fecha, $titulo, $tituloES, $tituloEN, $resumen, $texto);
$query->store_result();
$query->fetch();
$query->close();
}
if($_SESSION["idioma"] == "EN") $abrvmes = array ("", "JAN", "FEB", "MAR", "APR", "MAY", "JUN", "JUL", "AUG", "SEP", "OCT", "NOV", "DIC");
else $abrvmes = array ("", "ENE", "FEB", "MAR", "ABR", "MAY", "JUN", "JUL", "AGO", "SEP", "OCT", "NOV", "DIC");
// Redactores
if($query = $mysqli ->prepare("SELECT idredactor, redactor, twitter, facebook, linkedin, nombrecolumna, curriculum$_SESSION[idioma], fotoficha FROM redactores WHERE idredactor = ?")) {
$query->bind_param('i', $idredactor);
$query->execute();
$query->bind_result($idredactor, $redactor, $twitter, $facebook, $linkedin, $nombrecolumna, $curriculum, $fotoficha);
$query->store_result();
$query->fetch();
$query->close();
}
// Comentarios
if($_REQUEST["idestado"] ?? "" != "") {
if($query = $mysqli ->prepare("UPDATE comentarios SET idestado=? WHERE idcomentario=?")) {
$query->bind_param('ii', $_REQUEST["idestado"], $_REQUEST["idcomentario"]);
$query->execute();
$query->close();
}
}
if($query = $mysqli ->prepare("SELECT COUNT(idopinion) as totalcomentarios FROM comentarios WHERE idopinion=? AND idestado=2")) {
$query->bind_param('i', $_REQUEST["idopinion"]);
$query->execute();
$query->bind_result($totalcomentarios);
$query->store_result();
$query->fetch();
}
function sinacentos($texto) {
$reemplazar = array('á','é','í','ó','ú','ñ','Á','É','Í','Ó','Ú','ñ','Ñ');
$poresto = array('a','e','i','o','u','n','A','E','I','O','U','ñ','Ñ');
return $texto = str_replace($reemplazar,$poresto,$texto);
}
// SEO
if($tituloES ?? "" != "") $hreflangES=$fecha."/".friendly($tituloES).$idopinion."/".$lit_opinionES."/"; else $hreflangES=false;
if($tituloEN ?? "" != "") $hreflangEN=$fecha."/".friendly($tituloEN).$idopinion."/".$lit_opinionEN."/"; else $hreflangEN=false;
?>
echo strip_tags(str_replace('"','',$titulo."-".$redactor)) ?>
echo strip_tags(str_replace('"','',$resumen)) ?> } else { ?> echo strip_tags(str_replace('"','',$titulo)) ?> | echo $redactor ?> } ?>">
, echo $redactor ?>, Opinión InfoPlay">
include "includes/metas.php"; ?>
">
/ echo friendly(strip_tags($titulo)).$idopinion ?>/opinion/?v=1.1">
http://www.infoplay.info/fotos/opinion/ echo $fotoficha; ?>}else{?>http://www.infoplay.info/images/logo-info-play.png}?>">
">
">
">
http://www.infoplay.info/fotos/opinion/ echo $fotoficha; ?>}else{?>http://www.infoplay.info/images/logo-info-play.png}?>">
onload="alert('Comentario ACEPTADO')" } ?> if((isset($_REQUEST["idestado"])) && ($_REQUEST["idestado"] == 3)) { ?> onload="alert('Comentario DENEGADO')" } ?> if((isset($_REQUEST["error"])) && ($_REQUEST["error"] == 0)) { ?> onload="alert('Comentario enviado correctamente')" } ?> if((isset($_REQUEST["error"])) && ($_REQUEST["error"] == 1)) { ?> onload="alert('Ha ocurrido un error al enviar su comentario\n Por favor inténtelo más tarde')" } ?>>
include "includes/header.php"; ?>
muestrabanner("SELECT nombrebanner, banner, urlbanner, codigobanner, idprovincia FROM banners WHERE idbanner=?",$idbannerbajomenuresto,"fotos/banners"); ?>
if($nombrecolumna != ""){ ?>
echo $nombrecolumna ?>
} ?>
date("m", strtotime( $fecha ));?>
echo $titulo; ?>
echo $resumen; ?>
echo str_replace("></iframe>",">",str_replace("<iframe","
echo $totalcomentarios ?> translate(43) ?> if($totalcomentarios != 1) { ?>s } ?>
if($_SESSION["idioma"] == "EN") $meses=array("","january","february","march","april","may","june","july","august","september","october","november","december");
else $meses=array("","enero","febrero","marzo","abril","mayo","junio","julio","agosto","septiembre","octubre","noviembre","diciembre");
if($query = $mysqli ->prepare("SELECT nombre, comentario, fechacomentario FROM comentarios WHERE idopinion=? AND idestado=2 ORDER BY fechacomentario ASC")) {
$query->bind_param('i', $_REQUEST["idopinion"]);
$query->execute();
$query->bind_result($nombre, $comentario, $fechacomentario);
$query->store_result();
$i=0;
while($query->fetch()) {
$i++;
$mes=$meses[date("n", strtotime($fechacomentario))];
?>
echo $nombre ?>
echo date("j", strtotime($fechacomentario))." ".translate(85)." ".$mes." ".date("Y", strtotime($fechacomentario)); ?>
# echo $i ?>
echo $comentario ?>
}
} ?>
translate(88) ?>
include "includes/calendario.php"; ?>
if($fotoficha!=""){?>

}?>
echo $redactor; ?>
echo $curriculum; ?>
if($twitter != ""){?>
} ?>
if($facebook != ""){?>
} ?>
if($linkedin != ""){?>
} ?>
muestrabanner("SELECT nombrebanner, banner, urlbanner, codigobanner, idprovincia FROM banners WHERE idbanner=?",$idbannerderechaopinion1,"fotos/banners"); ?>
muestrabanner("SELECT nombrebanner, banner, urlbanner, codigobanner, idprovincia FROM banners WHERE idbanner=?",$idbannerderechaopinion2,"fotos/banners"); ?>
muestrabanner("SELECT nombrebanner, banner, urlbanner, codigobanner, idprovincia FROM banners WHERE idbanner=?",$idbannerderechaopinion3,"fotos/banners"); ?>

translate(32) ?>
$fechahoy=date("Y-m-d");
$indice=1;
$class = "par";
if($Qmasvisto = $mysqli ->prepare("SELECT n.idnoticia, n.titulo$_SESSION[idioma], n.fecha, nv.numvisitas FROM noticias n, noticias_visitas nv WHERE n.idnoticia=nv.idnoticia AND n.fecha >= '".date("Y-m-d", strtotime ("-7 day", strtotime($fechahoy)))."' AND titulo$_SESSION[idioma]!='' AND n.oculto=0 ORDER BY nv.numvisitas DESC, n.fecha DESC, n.idnoticia DESC LIMIT 10")){
$Qmasvisto->execute();
$Qmasvisto->bind_result($idnoticia, $titulo, $fecha, $numvisitas);
while( $Qmasvisto->fetch() ){ ?>
-
/ echo friendly(strip_tags($titulo)).$idnoticia ?>/
Warning: Undefined variable $lit_noticia in /home/playnfoi/public_html/opinion.php on line 274
/">
echo $indice ?>.
echo strip_tags ($titulo) ?>
if($class == "par"){$class = "impar";}
else{$class = "par";}
$indice++;
}
$Qmasvisto->close();
} ?>
include "includes/footer.php" ?>
include "php/desconexion.php" ?>