0 ? (int)($_REQUEST['pagina'] - 1) * $limit2 : 0; $sql = "SELECT /*blogueras index.php*/ rss.titulo, rss.titulo_url, rss.imagen, rss.resumen, rss.fecha_insercion, subcategoria, cat_url FROM rss INNER JOIN site_rss AS sr ON sr.id_site_rss = rss.id_rss_site INNER JOIN site AS s ON sr.id_site = s.id_site INNER JOIN subcategoria AS sc ON sr.id_subcategoria = sc.id_subcategoria WHERE sc.id_categoria='" . _CAT . "' AND s.idioma='" . _IDIOMA . "' AND mes='" . $_REQUEST['mes'] . "' ORDER BY rss.fecha_date DESC LIMIT $limit1, $limit2"; $result = mysqli_query($connection,$sql); $i=1; while ($row = mysqli_fetch_array($result)) { $url_articulo = "/" . $row['cat_url'] . "/" . $row['titulo_url'] ; ?>
0 ? (int)($_REQUEST['pagina'] - 1) * $limit2 : 0; $sql = "SELECT /*blogueras index.php*/ rss.titulo, rss.titulo_url, rss.imagen, rss.resumen, rss.fecha_insercion, subcategoria, cat_url, sr.tipo_rss FROM rss INNER JOIN site_rss AS sr ON sr.id_site_rss = rss.id_rss_site INNER JOIN site AS s ON sr.id_site = s.id_site INNER JOIN subcategoria AS sc ON sr.id_subcategoria = sc.id_subcategoria WHERE (sc.id_categoria='" . _CAT . "' OR sc.id_categoria='" . _CATVIDEO . "') AND s.idioma='" . _IDIOMA . "' AND mes='" . $_REQUEST['mes'] . "' ORDER BY rss.fecha_date DESC LIMIT $limit1, $limit2"; } else { $limit2 = 100; $sql = "SELECT /*blogueras index.php*/ rss.titulo, rss.titulo_url, rss.imagen, rss.resumen, rss.fecha_insercion, subcategoria, cat_url, sr.tipo_rss FROM rss INNER JOIN site_rss AS sr ON sr.id_site_rss = rss.id_rss_site INNER JOIN site AS s ON sr.id_site = s.id_site INNER JOIN subcategoria AS sc ON sr.id_subcategoria = sc.id_subcategoria WHERE (sc.id_categoria='" . _CAT . "' OR sc.id_categoria='" . _CATVIDEO . "') AND s.idioma='" . _IDIOMA . "' AND dia = '" . date("Ymd", strtotime($_REQUEST["fecha_paginacion"])) . "' ORDER BY rss.fecha_date DESC "; } $result = mysqli_query($connection,$sql); $i=0; $color = "#EBEBEB"; while ($row = mysqli_fetch_array($result)) { $i++; $hayContenido = true; if ($row["tipo_rss"] == "VIDEO") { $titulo="[Video] -". $row['titulo']; $url_articulo = "/tv/" . $row['cat_url'] . "/" . $row['titulo_url'] ; } else { $titulo=$row['titulo']; $url_articulo = "/" . $row['cat_url'] . "/" . $row['titulo_url'] ; } $resumen = substr($row['resumen'],0,150); $patron = "/(http:\/\/|https:\/\/|www)(.*)(\s|$)/"; $resumen = preg_replace($patron,"",$resumen); $d = rand(1,3); ?> "; $color = $color == "#EBEBEB" ? "#b6b2b2" : "#EBEBEB"; } } ?>
" width="170" height="124">


...