Changeset 750 for trunk/app/controllers

Timestamp:

09/02/08 21:40:55 (3 months ago)

Author:

aarkerio

Message:

backups scripts

Files:

• trunk/app/controllers/entries_controller.php (modified) (2 diffs)

trunk/app/controllers/entries_controller.php

@@ -106 +106 @@
   $this->layout = 'portal';
       
-  $this->pageTitle = 'Search Results :: Karamelo E-learning on Web 2.0';
+  $this->pageTitle = __('Search Results',true). ' :: Karamelo E-learning on Web 2.0';
       
   $this->Portal->statics(); // Charge Portal components aka Sidebars
@@ -112 +112 @@
   $this->Sanitize = new Sanitize;
       
-  $this->Sanitize->paranoid($this->data["Entry"]["terms"]); 
-      
-  $this->set('data', $this->Search->getRows($this->data["Entry"]["terms"]));
+  $this->Sanitize->paranoid($this->data['Entry']['terms']); 
+  $q  = 'SELECT id, title FROM entries WHERE ';
+  $q .= '  to_tsvector(title || body) @@ to_tsquery(\''.$this->data['Entry']['terms'].'\') ';
+  $q .= '  ORDER BY created DESC LIMIT 10';
+     
+  $this->set('data', $this->Search->getRows($this->data['Entry']['terms']));
  }