// Get 50 newest poems
$cPoem = new CPoem($db, $_SESSION);
$cUsers = new CUsers($db, $_SESSION);
$poems = $cPoem->getNewestPoems($_GET['num_poems']);
echo '<table>';
echo '<tr>';
echo '<td><b>Runoilija</b></td>';
echo '<td><b>Runon nimi</b></td>';
echo '<td><b>Lisätty</b></td>';
echo '</tr>';
$poems_per_page = $cPoem->getPoemsPerPage();
foreach ($poems as $poem) {
echo '<tr>';
echo '<td>';
echo '<a href="poet.php?id=' . $poem['user_id'] . '">';
echo $cUsers->getUsername($poem['user_id']);
echo '</a>';
echo '</td>';
echo '<td><a href="poet.php?id=' . $poem['user_id'];
// Count how many poems this writer has written
// since this poem. This is necessary so we can
// create link to correct poem even if that poem
// is on another page than the first one.
$q = 'SELECT COUNT(*) FROM rs_poem WHERE added > "' . $poem['added'] . '" AND user_id=' . $poem['user_id'];
try {
$ret = $db->query($q);
if ($db->numRows($ret) > 0) {
$ret = $db->fetchAssoc($ret);
$num_after = $ret[0]['COUNT(*)'];
// In which page poem will be
$correct_page = ceil(($num_after + 1) / $poems_per_page);
$cPoem = new CPoem($db, $_SESSION);
if ($type == 'newest') {
$poems = $cPoem->getNewestPoems(10);
create_rss($poems, 'Uusimmat runot', 'http://www.runosydan.net/rss.php?special=newest');
}
}
require 'general_functions.php';
// We must get poet ID OR special-action, so we have something to show.
if (!isset($_GET['poet_id']) && !isset($_GET['special'])) {
header('Location: index.php');
}
// In special feeds (newest poems) call function which will create
// correct RSS-feed for this.
if (isset($_GET['special'])) {
create_special_feed($db, $_GET['special']);
} else {
// Get poet username
$cUsers = new CUsers($db);
$poet_username = $cUsers->getUsername($_GET['poet_id']);
if ($poet_username == '') {
header('Location: index.php');
}
// Get poet poems on first page
require 'CPoem.php';
$cPoems = new CPoem($db, $_SESSION);
$poems = $cPoems->getPoems($_GET['poet_id'], 1, false);
// Feed title
$RSS_feed_title = 'Runoilijan ' . $poet_username . ' uusimmat runot';
$RSS_feed_url = 'http://www.runosydan.net/rss.php?poet_id=' . $_GET['poet_id'];
create_rss($poems, $RSS_feed_title, $url);
}
