Changeset 510 for trunk/rss.php

Timestamp:

Feb 15, 2013, 11:02:13 PM (11 years ago)

Author:

chronos

Message:

• Přidáno: Novinky na webu nyní mají titulek. U starých novinek se nastaví jako titulek jméno uživatele, jako to bylo dříve.

File:

• trunk/rss.php (modified) (1 diff)

trunk/rss.php

@@ -6 +6 @@
   if($_GET['channel'] == 'news')
   {
-    $DbResult = $System->Database->query('SELECT UNIX_TIMESTAMP(`News`.`Time`) AS `UnixTime`, `News`.`Time`, `User`.`Name`, `News`.`Text` FROM `News` JOIN `User` ON `User`.`ID` = `News`.`User` ORDER BY `Time` DESC LIMIT 10');
+    $DbResult = $System->Database->query('SELECT UNIX_TIMESTAMP(`News`.`Time`) AS `UnixTime`, '.
+      '`News`.`Title`, `News`.`Time`, `User`.`Name`, `News`.`Text` '.
+      'FROM `News` JOIN `User` ON `User`.`ID` = `News`.`User` ORDER BY `Time` DESC LIMIT 10');
     while($DbRow = $DbResult->fetch_assoc()) 
     {
       $Items[] = array
     (
-        'Title' => $DbRow['Name'].'('.date('d.m.Y', MysqlDateTimeToTime($DbRow['Time'])).')',
+        'Title' => $DbRow['Title'],
         'Link' =>  'http://'.$Config['Web']['Host'].$System->Link('/'),
-        'Description' => $DbRow['Text'],
+        'Description' => $DbRow['Text'].' ('.$DbRow['Name'].')',
         'Time' => $DbRow['UnixTime'],
       );