Changeset 1898 in ExiteCMS

Timestamp:

10/20/08 22:08:39 (3 years ago)

Author:

hverton

Message:

fixed frontpage news item not selected correctly

File:

• trunk/administration/frontpage.php (modified) (2 diffs)

trunk/administration/frontpage.php

@@ -99 +99 @@
 }
 
-// build the list of available news cards
+// build the list of available news cats
 $newslist = array();
-// and an empty first entry
+// add an empty first entry
 $newslist[] = array('news_id' => 0, 'news_subject' => "", 'news_cat_name' => "", 'news_new_cat' => 1, 'selected' => 0);
 $result = dbquery("SELECT n.news_id, n.news_subject, c.news_cat_name FROM ".$db_prefix."news n LEFT JOIN ".$db_prefix."news_cats c ON n.news_cat = c.news_cat_id ORDER BY c.news_cat_name, n.news_datestamp DESC");
@@ -121 +121 @@
 $headlines = array();
 for ($i = 1; $i <= $settings['news_headline']; $i++) {
-    $result = dbquery("SELECT news_id FROM ".$db_prefix."news_frontpage INNER JOIN ".$db_prefix."news ON frontpage_news_id WHERE frontpage_headline=1 AND frontpage_order=".$i);
+    $result = dbquery("SELECT frontpage_news_id FROM ".$db_prefix."news_frontpage WHERE frontpage_headline=1 AND frontpage_order=".$i);
     if ($data = dbarray($result)) {
-        $news_id = $data['news_id'];
+        $news_id = $data['frontpage_news_id'];
     } else {
         $news_id = 0;