Changeset 105 for components/library.php

Timestamp:

01/09/06 00:25:34 (7 years ago)

Author:

dez

Message:

Lots of chckens changes
Database dump

Files:

• components/library.php (modified) (4 diffs)

components/library.php

@@ -2 +2 @@
 
 // this component is a mess. That's cause it's not finished yet :-)
+
+// don't try to convert existing html entities
+// this could be broken out someplace else
+function htmlentities2($myHTML) {
+   $translation_table=get_html_translation_table (HTML_ENTITIES,ENT_QUOTES);
+   $translation_table[chr(38)] = '&';
+   return preg_replace("/&(?![A-Za-z]{0,4}\w{2,3};|#[0-9]{2,3};)/","&" , strtr($myHTML, $translation_table));
+}
 
 $library_index = array_search("Library", $pathlist);
@@ -14 +22 @@
         $mode = "search";
         $search = $_REQUEST['search'];
-        $query = "SELECT * FROM books WHERE (title || ' ' || author || ' ' || keywords) ~* ? ORDER BY title ASC";
+        $query = "SELECT id, title, onloan FROM books WHERE (title || ' ' || author || ' ' || keywords) ~* ? ORDER BY title ASC";
         $results = $DB->GetAll($query,array($search));
+
+        foreach ($results as &$result) {
+                $result['title'] = htmlentities2($result['title']);
+                $result['onloan'] = ($result['onloan'] == 't') ? true : false;
+        }
+        
+        $pathlist[] = "Search";
         $smarty->assign("results", $results);
+
 } elseif (isset($pathlist[$library_index + 1]) && is_numeric($pathlist[$library_index + 1])) {
 // We're displaying a specific book
@@ -22 +38 @@
         $book_index = intval($pathlist[$library_index + 1]);
         $results = $DB->GetAll("SELECT * FROM books WHERE id=? LIMIT 1", array($book_index));
-        $smarty->assign("book", $results[0]);
-        // Edit the path list to make the breadcrumbs tastier
+
+// Clean up ready for output
+        $book = $results[0];
+        $book['title'] = htmlentities2($book['title']);
+        $book['author'] = htmlentities2($book['author']);
+        
+// Extract amazon data (maybe this should be stored in separate field in the db?)
+        $simple_xml = simplexml_load_string($book['amazon_data']);
+        $book['description'] = $simple_xml->Items->Item->EditorialReviews->EditorialReview->Content;
+        $smarty->assign("book", $book);
+
+// Edit the path list to make the breadcrumbs tastier
         $pathlist[$library_index + 1] = $results[0]['title'];
-        $smarty->assign("pathlist", $pathlist);
 } else {
-        $smarty->assign("randoms", $DB->GetAll("SELECT * FROM books WHERE image_url IS NOT NULL ORDER BY random() LIMIT 5"));
+//Nothing being requested, just find some random books to put on main page
+        $smarty->assign("randoms", $DB->GetAll("SELECT * FROM books WHERE image_url IS NOT NULL ORDER BY random() LIMIT 4"));
 }
 
@@ -33 +59 @@
 $smarty->assign("mode", $mode);
 $smarty->assign("search", $search);
+$smarty->assign("pathlist", $pathlist);
 $output = $smarty->fetch("library.tpl");
 $output2 = $smarty->fetch("library-search.tpl");