function create_rss($search, $limit)
{
$title = 'uBook';
if ($search) {
$title .= ' - Suche nach "' . $search . '"';
}
$link = WEBDIR;
$desc = 'Neue Angebote bei uBook.';
$lang = 'de-de';
$copyright = 'uBook';
$rss = new RssChannel($title, $link, $desc, $lang, $copyright);
$imageUrl = 'http://ubook.asta-bielefeld.de/ubook_small.gif';
$rss->addImage($imageUrl, $title, $link);
$query = BookQuery::searchQuery($search);
$query .= ' order by created desc';
if ($limit > 0) {
$query .= ' limit ' . $limit;
}
$mysqlResult = mysql_query($query);
while ($book = Book::fromMySql($mysqlResult)) {
$title = $book->get('title');
$desc = 'Neues Buchangebot:' . "\n" . $book->asText();
$desc = nl2br(Parser::text2html($desc));
$id = $link = WEBDIR . 'book.php?id=' . $book->get('id');
$author = 'ubook@asta-bielefeld.de (uBook-Team)';
$date = $book->get('created');
$rss->addItem($id, $title, $desc, $link, $author, $date);
}
return $rss;
}
/**
* Generates a MySQL select statement.
*
* @param string $searchKey user given search key
* @return MySQL select statement
*/
protected function createMysqlQuery()
{
$searchKey = $this->key->asText();
$option = $this->key->getOption();
$query = BookQuery::searchQuery($searchKey);
if ($option == 'new') {
$query .= ' order by created desc limit 7';
} else {
if ($option == 'random') {
$query .= ' order by rand() limit 7';
} else {
$query .= ' order by author, title, price';
}
}
return $query;
}
