Changeset 199 for trunk/dictionary.php
- Timestamp:
- Jun 5, 2009, 7:08:55 PM (15 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/dictionary.php
r198 r199 211 211 } 212 212 echo('</td></tr>'); 213 echo('<tr><td> 214 <div style="overflow: auto; width: 100%; height: 100%;">');213 echo('<tr><td>'); 214 //<div style="overflow: auto; width: 100%; height: 100%;">'); 215 215 216 216 if($Search <> '') … … 218 218 $sql = 'SELECT `user`.`user` AS `UserName`, `user`. `ID` AS `UserID`, `T3`.`Entry`, `T3`.`Original`, `T3`.`Translated`, `T3`.`Description` FROM (SELECT T2.User, `T1`.Language, `T1`.`Text` AS Original, `T2`.`Text` AS `Translated`, `T2`.`Description`, `T1`.`Entry` AS `Entry` FROM `dictionary` AS `T1` JOIN `dictionary` AS `T2` ON `T2`.`Entry` = `T1`.`Entry` AND `T2`.`Language` = '.$_SESSION['language'].' WHERE LOWER(T1.Text) LIKE LOWER("%'.$Search.'%") OR LOWER(T1.Description) LIKE LOWER("%'.$Search.'%") ) AS T3 JOIN `user` ON `user`.`ID` = `T3`.`User` WHERE `T3`.`Language` = 0'; 219 219 } else $sql = 'SELECT `user`.`user` AS `UserName`, `ID` AS `UserID`, `T3`.`Entry`, `T3`.`Original`, `T3`.`Translated`, `T3`.`Description` FROM (SELECT T2.User, `T1`.Language, `T1`.`Text` AS Original, `T2`.`Text` AS `Translated`, `T2`.`Description`, `T1`.`Entry` AS `Entry` FROM `dictionary` AS `T1` JOIN `dictionary` AS `T2` ON `T2`.`Entry` = `T1`.`Entry` AND `T2`.`Language` = '.$_SESSION['language'].') AS T3 JOIN `user` ON `user`.`ID` = `T3`.`User` WHERE `T3`.`Language` = 0'; 220 $sql .=' LIMIT '.($_SESSION['Page'] - 1) * $Config['Web']['ItemsPerPage'].','.$Config['Web']['ItemsPerPage'];220 $sql_page = $sql.' LIMIT '.($_SESSION['Page'] - 1) * $Config['Web']['ItemsPerPage'].','.$Config['Web']['ItemsPerPage']; 221 221 222 222 ListPaging('?Page=', '('.$sql.') AS T1', '', $Config['Web']['ItemsPerPage'], $_SESSION['Page']); … … 227 227 if(Licence(LICENCE_USER)) echo('<th>Akce</th>'); 228 228 echo('</tr>'); 229 $ID = $Database->SQLCommand($sql );229 $ID = $Database->SQLCommand($sql_page); 230 230 while ($Line = mysql_fetch_assoc($ID)) 231 231 { … … 245 245 echo('</table>'); 246 246 ListPaging('?Page=', '('.$sql.') AS T1', '', $Config['Web']['ItemsPerPage'], $_SESSION['Page']); 247 echo('</ div></td></tr>');247 echo('</td></tr>'); 248 248 echo('</table></form>'); 249 249 }
Note:
See TracChangeset
for help on using the changeset viewer.