Changeset 500 for trunk/index.php
- Timestamp:
- Jan 31, 2013, 11:20:59 PM (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/index.php
r472 r500 39 39 { 40 40 //echo($DbRow['Name'].', '); 41 $UnionItems[] = 'SELECT * FROM(SELECT `T`.`User`, `T`.`ID`, `T`.`ModifyTime`, '.$DbRow['Id'].' AS `Group`, "'.addslashes($DbRow['Name']).'" AS `GroupName`, `T`.`Take` FROM `'.$DbRow['TablePrefix'].'` AS `T`'. 42 ' WHERE (`T`.`Complete` = 1) AND (`T`.`Language` != 0) ORDER BY `T`.`ModifyTime` DESC LIMIT '.$Count.') AS `T`'; 41 $UnionItems[] = 'SELECT `T`.`ID`, `T`.`Take`, `T`.`User`, `T`.`ModifyTime`, `T`.`Group`, `T`.`GroupName` '. 42 'FROM (SELECT `T`.`User`, `T`.`ID`, `T`.`ModifyTime`, '. 43 $DbRow['Id'].' AS `Group`, "'.addslashes($DbRow['Name']).'" AS `GroupName`, `T`.`Take` FROM `'. 44 $DbRow['TablePrefix'].'` AS `T`'. 45 ' WHERE (`T`.`Complete` = 1) AND (`T`.`Language` != 0) ORDER BY `T`.`ModifyTime` DESC LIMIT '. 46 $Count.') AS `T`'; 43 47 } 44 48 $Query = 'SELECT `TT`.*, `User`.`Name` AS `UserName` FROM ('.implode(' UNION ', $UnionItems).') AS `TT`'. … … 63 67 function ShowRSSChannel() 64 68 { 65 global $System, $Config , $System;69 global $System, $Config; 66 70 67 71 $Items = array(); … … 135 139 'Items' => $Items, 136 140 ))); 137 } 141 } else echo('Žádný kanál'); 138 142 } 139 143
Note:
See TracChangeset
for help on using the changeset viewer.