Changeset 155 for trunk/team.php

Timestamp:

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

Author:

maron

Message:

Globální hledání

File:

• trunk/team.php (modified) (2 diffs)

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)) 
 {