Changeset 196 for trunk/aktuality/rss.php

Timestamp:

Apr 27, 2009, 8:00:50 AM (16 years ago)

Author:

george

Message:

• Upraveno: Názvy tabulek a sloupců aktualit pozměněny na názvy se slovy začínající velkými písmeny.

File:

• trunk/aktuality/rss.php (modified) (5 diffs)

trunk/aktuality/rss.php

@@ -1 +1 @@
 <?php
 
-Header("Content-Type: text/xml");
+Header('Content-Type: text/xml');
 
 include_once('../global.php');
@@ -28 +28 @@
 // Get category names
 $Categories = array();
-$DbResult = $Database->select('news_category', '*');
+$DbResult = $Database->select('NewsCategory', '*');
 while($Category = $DbResult->fetch_array())
 {
-  $Categories[$Category['id']] = $Category['caption'];
+  $Categories[$Category['Id']] = $Category['Caption'];
 }
 
@@ -61 +61 @@
   $Database->select_db('forum');
 }
+$Database->select_db('is');
 */
-$Database->select_db('is');
 
 // Get news from database by selected categories
 $UploadedFilesFolder = 'uploads/';
-$DbResult = $Database->query('SELECT enclosure,category,title,content,UNIX_TIMESTAMP(date),author FROM news WHERE '.$Where.' ORDER BY date DESC LIMIT 0,'.$NewsCount);
-while($Row = $DbResult->fetch_array())
+$DbResult = $Database->query('SELECT *, UNIX_TIMESTAMP(Date) FROM News LEFT JOIN `User` ON `User`.`Id`=`News`.`User` WHERE '.$Where.' ORDER BY News.Date DESC LIMIT 0,'.$NewsCount);
+while($Row = $DbResult->fetch_assoc())
 {
   $EnclosuresText = '';
-  if($Row['enclosure'] != '')
+  if($Row['Enclosure'] != '')
   { 
     $EnclosuresText .= '<br />Přílohy: ';
-    $Enclosures = explode(';', $Row['enclosure']);
+    $Enclosures = explode(';', $Row['Enclosure']);
     foreach($Enclosures as $Enclosure)
     {
@@ -79 +79 @@
     }
   }
+  if($Row['Name'] == '') $Author = $Row['Author'];
+    else $Author = $Row['Name'];
   $Items[] = array(
-    'Title' => $Categories[$Row['category']].' - '.$Row['title'],
-    'Link' => 'http://centrala.zdechov.net/aktuality/index.php?category='.$Row['category'],
-    'Description' => $Row['content']." (".$Row['author'].")".$EnclosuresText,
-    'Time' => $Row['UNIX_TIMESTAMP(date)'],
+    'Title' => $Categories[$Row['Category']].' - '.$Row['Title'],
+    'Link' => 'http://centrala.zdechov.net/aktuality/index.php?category='.$Row['Category'],
+    'Description' => $Row['Content'].' ('.$Author.')'.$EnclosuresText,
+    'Time' => $Row['UNIX_TIMESTAMP(Date)'],
   );
 }
@@ -93 +95 @@
   'WebmasterEmail' => $Config['Web']['AdminEmail'],
   'Items' => $Items)));
+  
 ?>