Changeset 636 for trunk

Timestamp:

Sep 14, 2009, 3:30:10 PM (15 years ago)

Author:

george

Message:

• Opraveno: Načítání RSS aktualit z nově upravené tabulky.

Location:

trunk

Files:

• rss.php (modified) (1 diff)
• sql/updates/635.sql (modified) (1 diff)

trunk/rss.php

@@ -18 +18 @@
   {
     $Config['Web']['Title'] .= ' - články';
-    $DbResult = $db->query('SELECT UNIX_TIMESTAMP(date), articles.* FROM articles ORDER BY date DESC LIMIT '.$NewsCount);
+    $DbResult = $db->query('SELECT UNIX_TIMESTAMP(Time), Article.* FROM Article ORDER BY Time DESC LIMIT '.$NewsCount);
     while($Row = $DbResult->fetch_assoc())
     {
       $Items[] = array(
-        'Title' => $Row['title'],
+        'Title' => $Row['Title'],
         'Link' => 'http://'.$_SERVER['SERVER_NAME'].$Config['Web']['BaseURL'],
-        'Description' => $Row['text'].' ('.$Row['autor'].')',
-        'Time' => $Row['UNIX_TIMESTAMP(date)'],
+        'Description' => $Row['Text'].' ('.$Row['Author'].')',
+        'Time' => $Row['UNIX_TIMESTAMP(Time)'],
       );
     }

trunk/sql/updates/635.sql

@@ -23 +23 @@
 (4, 'Články');
 
-ALTER TABLE `Article` ADD FOREIGN KEY ( `Category` ) REFERENCES `wow`.`ArticleCategory` (`Id`);
+ALTER TABLE `Article` ADD FOREIGN KEY ( `Category` ) REFERENCES `ArticleCategory` (`Id`);