<?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();
