Changeset 626 for trunk/Modules/ShoutBox/ShoutBox.php

Timestamp:

Dec 4, 2013, 9:50:16 PM (11 years ago)

Author:

chronos

Message:

• Modified: Search page generalized as dynamic configurable list. Other modules can register their search ability.
• Modified: If sarch is invoked on some module then filter is added to table. Filter have to be disabled to view all items again.
• Added: Shoutbox can be searched.

File:

• trunk/Modules/ShoutBox/ShoutBox.php (modified) (2 diffs)

trunk/Modules/ShoutBox/ShoutBox.php

@@ -20 +20 @@
           'Title' => 'Kecátko', 'Channel' => 'shoutbox', 'Callback' => array('PageShoutBox', 'ShowRSS'), 
           'Permission' => LICENCE_ANONYMOUS));           
+    if(array_key_exists('Search', $this->System->ModuleManager->Modules))
+      $this->System->ModuleManager->Modules['Search']->RegisterSearch('shoutbox',
+      T('Shoutbox'), array('UserName', 'Text'), '`ShoutBox`', $this->System->Link('/shoutbox/?search='));
   }
   
   function ShowBox()
   {
-        $Output = '<strong><a href="'.$this->System->Link('/shoutbox/').'">'.T('Chatbox').':</a></strong>';
+        $Output = '<strong><a href="'.$this->System->Link('/shoutbox/').'">'.T('Shoutbox').':</a></strong>';
          
         if($this->System->User->Licence(LICENCE_USER))
@@ -52 +55 @@
         function ShowList()
         {
-        $DbResult = $this->System->Database->query('SELECT COUNT(*) FROM `ShoutBox`');
+                $Output = '';
+                if(array_key_exists('search', $_GET)) $_SESSION['search'] = $_GET['search'];
+                else if(!array_key_exists('search', $_SESSION)) $_SESSION['search'] = '';
+                if(array_key_exists('search', $_GET) and ($_GET['search'] == '')) $_SESSION['search'] = '';
+                if($_SESSION['search'] != '')
+                {
+                        $SearchQuery = ' AND (`Text` LIKE "%'.$_SESSION['search'].'%")';
+                        $Output .= '<div><a href="?search=">'.sprintf(T('Disable filter "%s"'), $_SESSION['search']).'</a></div>';
+                } else $SearchQuery = '';                       
+
+        $DbResult = $this->System->Database->query('SELECT COUNT(*) FROM `ShoutBox` WHERE 1'.$SearchQuery);
                 $DbRow = $DbResult->fetch_row();
-                $PageList = GetPageList($DbRow[0]);
-                
-                $Output = '<h3>Kecátko</h3>'.$PageList['Output'];
+                $PageList = GetPageList($DbRow[0]);     
+
+                $Output .= '<h3>'.T('Shoutbox').'</h3>'.$PageList['Output'];
                 if($this->System->User->Licence(LICENCE_USER)) 
                         $Output .= ' <a href="'.$this->System->Link('/shoutbox/?a=add').'">'.T('Add').'</a>';
                 $Output .= '<div class="shoutbox">';
-                $DbResult = $this->System->Database->query('SELECT * FROM `ShoutBox` ORDER BY `ID` DESC '.$PageList['SQLLimit']);
+                $DbResult = $this->System->Database->query('SELECT * FROM `ShoutBox`  WHERE 1'.$SearchQuery.' ORDER BY `ID` DESC '.$PageList['SQLLimit']);
                 while($Line = $DbResult->fetch_assoc())
                         $Output .= '<div><strong>'.$Line['UserName'].'</strong>: '.MakeActiveLinks($Line['Text']).'</div>';