Changeset 155 for trunk/action.php

Timestamp:

Mar 12, 2009, 1:27:34 PM (16 years ago)

Author:

maron

Message:

Globální hledání

File:

• trunk/action.php (modified) (1 diff)

trunk/action.php

@@ -8 +8 @@
 $Table = $TranslationTree[$GroupId]['TablePrefix'];
 if(array_key_exists('action', $_GET)) $Action = $_GET['action']; else $Action = '';
+
+if(($Action == 'search')) 
+{
+  if(array_key_exists('search', $_GET)) $Search = $_GET['search'];
+  else $Search = $_POST['search'];
+
+  echo('<table class="BaseTable"><tr><th>Skupina</th><th>Výsledků</th></tr>');
+  foreach($TranslationTree as $Group) {
+        $Table = $Group['TablePrefix'];
+  
+        $sql = 'SELECT count(*) FROM `'.$Table.'` WHERE `ID` LIKE "%'.$Search.'%"
+        OR `entry` LIKE "%'.$Search.'%"
+        OR `User` LIKE "%'.$Search.'%"
+        OR `Complete` LIKE "%'.$Search.'%"';
+        foreach($Group['Items'] as $Item) {
+                if($Item['Column'] != '') $sql .= ' OR `'.$Item['Column'].'` LIKE "%'.$Search.'%"';
+        }
+        $Line = mysql_fetch_row($Database->SQLCommand($sql));
+        echo('<tr><td><a href="TranslationList?group='.$Group['Id'].'&amp;action=search&amp;search='.$Search.'">'.$Group['Name'].'</a></td><td>'.$Line[0].'</td></tr>');
+  }
+  
+        $Line = mysql_fetch_row($Database->SQLCommand('SELECT count(*) FROM `user` WHERE `user` LIKE "%'.$Search.'%"'));
+        echo('<tr><td><a href="userlist?search='.$Search.'">Uživatelé</a></td><td>'.$Line[0].'</td></tr>');
+        $Line = mysql_fetch_row($Database->SQLCommand('SELECT count(*) FROM `team` WHERE `name` LIKE "%'.$Search.'%" OR `description` LIKE "%'.$Search.'%"'));
+        echo('<tr><td><a href="team?search='.$Search.'">Týmy</a></td><td>'.$Line[0].'</td></tr>');
+        $Line = mysql_fetch_row($Database->SQLCommand('SELECT count(*) FROM `verseclient` WHERE `text` LIKE "%'.$Search.'%"'));
+        echo('<tr><td><a href="download.php?addon">Čeština pro klienta</a></td><td>'.$Line[0].'</td></tr>');
+  
+  echo('</table>');
+}