Changeset 425 for branches/CombinedTextTables/action.php
- Timestamp:
- Apr 8, 2010, 7:58:16 AM (15 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/CombinedTextTables/action.php
r376 r425 12 12 echo('<table class="BaseTable"><tr><th>Skupina</th><th>Výsledků</th></tr>'); 13 13 foreach($TranslationTree as $Group) 14 { 15 $Table = $Group['TablePrefix']; 16 17 $sql = 'SELECT COUNT(*) FROM `'.$Table.'` WHERE `ID` LIKE "%'.$Search.'%" 18 OR `Entry` LIKE "%'.$Search.'%" 19 OR `User` LIKE "%'.$Search.'%" 20 OR `Complete` LIKE "%'.$Search.'%"'; 21 foreach($Group['Items'] as $Item) 22 { 23 if($Item['Column'] != '') $sql .= ' OR `'.$Item['Column'].'` LIKE "%'.$Search.'%"'; 24 } 14 { 15 $sql = 'SELECT COUNT(*) FROM `Translation` WHERE (`ID` LIKE "%'.$Search.'%")'. 16 ' OR (`Entry` LIKE "%'.$Search.'%")'. 17 ' OR (`User` LIKE "%'.$Search.'%")'. 18 ' OR (`Complete` LIKE "%'.$Search.'%")'; 25 19 $Line = mysql_fetch_row($Database->SQLCommand($sql)); 26 20 echo('<tr><td><a href="TranslationList.php?group='.$Group['Id'].'&action=search&search='.$Search.'">'.$Group['Name'].'</a></td><td>'.$Line[0].'</td></tr>'); … … 256 250 257 251 $GroupId = LoadGroupIdParameter(); 258 $ Table = $TranslationTree[$GroupId]['TablePrefix'];252 $Group = $TranslationTree[$GroupId]; 259 253 if(array_key_exists('action', $_GET)) $Action = $_GET['action']; 260 254 else $Action = '';
Note:
See TracChangeset
for help on using the changeset viewer.