Changeset 155

Timestamp:

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

Author:

maron

Message:

Globální hledání

Location:

trunk

Files:

• action.php (modified) (1 diff)
• includes/global.php (modified) (2 diffs)
• team.php (modified) (2 diffs)
• userlist.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>');
+}
 
 

trunk/includes/global.php

@@ -66 +66 @@
   </form>');
   }
+}
+
+function ShowSearchBox()
+{
+    echo('<strong>Hledání:</strong>
+  <form action="action.php" method="get"><input type="hidden" name="action" value="search" />
+  <table>
+    <tr>
+      <td><input type="text" name="search" size="13" /></td>
+    </tr>
+    <tr>
+      <th><input type="submit" value="Hledat" /></th>
+    </tr>
+  </table>
+  </form>');
 }
 
@@ -220 +235 @@
   ShowMainMenu();
       
-  echo('<br />');    
+ // echo('<br />');    
   ShowLoginBox();
   echo('<br />');
   ShowOnlineUserList();
+  echo('<br />');
+  ShowSearchBox();
   echo('</td><td id="border-left"></td><td class="content">');
 }

trunk/team.php

@@ -75 +75 @@
 echo('<table class="BaseTable">');
 
+if(array_key_exists('search', $_GET))  $_SESSION['Where'] = ' WHERE `name` LIKE "%'.$_GET['search'].'%" OR `description` LIKE "%'.$_GET['search'].'%"'; 
+if(array_key_exists('Where', $_GET)) {
+         $_SESSION['Where'] = ' WHERE '.$_GET['Where']; 
+     if($_GET['Where'] == '') $_SESSION['Where'] = '';     
+ }
+else if(!array_key_exists('Where', $_SESSION)) $_SESSION['Where'] = '';
+
+if ($_SESSION['Where'] <> '') echo (' <a href="?Where">Zrušit filtr týmů</a><br />');
+
+
 $desc = $_SESSION['Desc']; 
 if($desc == '') $desc = 'DESC'; else $desc = '';
@@ -91 +101 @@
 echo ('</tr>');
 
-$ID = $Database->SQLCommand('SELECT *,(SELECT count(*) FROM user WHERE team = team.ID) as numberuser FROM team ORDER BY '.$_SESSION['Order'].' '.$_SESSION['Desc'].' LIMIT '.($_SESSION['Page'] - 1) * $Config['Web']['ItemsPerPage'].','.$Config['Web']['ItemsPerPage']);
+$ID = $Database->SQLCommand('SELECT *,(SELECT count(*) FROM user WHERE team = team.ID) as numberuser FROM team '.$_SESSION['Where'].' ORDER BY '.$_SESSION['Order'].' '.$_SESSION['Desc'].' LIMIT '.($_SESSION['Page'] - 1) * $Config['Web']['ItemsPerPage'].','.$Config['Web']['ItemsPerPage']);
 while($Line = mysql_fetch_assoc($ID)) 
 {

trunk/userlist.php

@@ -15 +15 @@
 else if(!array_key_exists('Desc', $_SESSION)) $_SESSION['Desc'] = 'DESC';
 
+if(array_key_exists('search', $_GET)) {
+         $_SESSION['Where'] = ' WHERE `user`.`user` LIKE "%'.$_GET['search'].'%"'; 
+ }
 if(array_key_exists('Where', $_GET)) {
          $_SESSION['Where'] = ' WHERE '.$_GET['Where']; 
-     if($_GET['Where'] == '') $_SESSION['Where'] = '';
+     if($_GET['Where'] == '') $_SESSION['Where'] = '';     
  }
 else if(!array_key_exists('Where', $_SESSION)) $_SESSION['Where'] = '';