Example #1
0
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;
 }