<?php require 'includes/rss.class.php'; $rss = new RSS(TITLE, _u('fe'), DESCRIPTION); $query = "SELECT *"; $query .= " FROM `%p_entries`"; $query .= " WHERE `status` = 'v'"; $query .= " ORDER BY `date` DESC, `id` DESC"; $query .= " LIMIT "; $query .= P_LIMIT; $sql = $DB->query($query); // if(!$sql = mysql_query($query)) throw new Exception('mysql-no'); if (mysqli_num_rows($sql) != 0) { # Si hay entradas while ($row = mysqli_fetch_row($sql)) { $row[2] = htmlspecialchars($row[2]); $row[3] = format($row[3], 'e'); $tmp = _u('e', $row[0], $row[1]); $rss->item($row[2], $tmp, $row[3], $row[4]); } } $rss->result();
} else { # Si existe require 'includes/rss.class.php'; $tmp = mysqli_fetch_row($sql); $pid = $tmp[0]; $title = $tmp[1]; $title = htmlspecialchars($title); $tmp1 = sprintf('Comentarios en "%s" de %s', $title, TITLE); $tmp2 = $_GET['type'] == 'e' ? _u('ce', $id, $slug) : _u('cp', $p); $rss = new RSS($tmp1, $tmp2, DESCRIPTION); $queryC = "SELECT `order`,`nick`,`content`,`date`"; $queryC .= " FROM `%p_comments`"; $queryC .= " WHERE `parenttype` = '%s'"; $queryC .= " AND `parentid` = '%s'"; $queryC .= " AND `status` <> 'h'"; $queryC .= " ORDER BY `order` DESC"; $sqlC = $DB->query($queryC, $_GET['type'], $pid); //if (!$sqlC = mysql_query($queryC)) throw new Exception('mysql-no'); if (mysqli_num_rows($sqlC) != 0) { # Si hay comentarios while ($row = mysqli_fetch_row($sqlC)) { $row[1] = htmlspecialchars($row[1]); $row[2] = format($row[2], 'cf'); $tmp1 = sprintf('Comentario de %s', $row[1]); $tmp2 = $_GET['type'] == 'e' ? _u('e', $id, $slug) : _u('p', $p); $tmp2 .= sprintf('#comment-%s', $row[0]); $rss->item($tmp1, $tmp2, $row[2], $row[3]); } } $rss->result(); }
$query .= " INNER JOIN `%p_pages` p"; $query .= " ON c.`parenttype` = 'p' AND c.`parentid` = p.`id`"; $query .= " WHERE c.`status` <> 'h'"; $query .= " AND p.`comments` <> 'n'"; $query .= " AND p.`status` = 'v'"; $query .= ") UNION ALL ("; $query .= "SELECT c.`parentid`, c.`order`, c.`nick`, c.`content`, c.`date` AS sort, p.`slug`, p.`title`, c.`parenttype`"; $query .= " FROM `%p_comments` c"; $query .= " INNER JOIN `%p_entries` p"; $query .= " ON c.`parenttype` = 'e' AND c.`parentid` = p.`id`"; $query .= " WHERE c.`status` <> 'h'"; $query .= " AND p.`comments` <> 'n'"; $query .= " AND p.`status` = 'v'"; $query .= ")"; $query .= " ORDER BY `sort` DESC"; $query .= " LIMIT 10"; $sql = $DB->query($query); //if (!$sql = mysql_query($query)) throw new Exception('mysql-no'); if (mysqli_num_rows($sql) != 0) { # Si hay comentarios while ($row = mysqli_fetch_row($sql)) { $row[2] = htmlspecialchars($row[2]); $row[6] = htmlspecialchars($row[6]); $tmp1 = sprintf('Comentario de %s en "%s"', $row[2], $row[6]); $row[3] = format($row[3], 'cf'); $tmp2 = $row[7] == 'e' ? _u('e', $row[0], $row[5]) : _u('p', $row[5]); $tmp2 .= sprintf('#comment-%s', $row[1]); $rss->item($tmp1, $tmp2, $row[3], $row[4]); } } $rss->result();