Changeset 597 for trunk

Timestamp:

09/08/07 18:32:20 (15 months ago)

Author:

michiel

Message:

use authors array in object variables rather then fetching them again from db

Files:

• trunk/common/rss.php (modified) (3 diffs)

trunk/common/rss.php

@@ -28 +28 @@
 require("mvblog.php");
 $mvblog = new MvBlog();
-//get all the authors in an array
-$res =& $mvblog->db->query("SELECT * FROM authors");
-
-if (PEAR::isError($res)) {
-        die($res->getMessage());
-}
-
-while ($row = $res->fetchRow(MDB2_FETCHMODE_ASSOC)) {
-        $authors[$row["id"]]["fullname"] = $row["fullname"];
-        $authors[$row["id"]]["email"]    = $row["email"];
-}
 
 //generate url to the root of our website
@@ -108 +97 @@
                 echo "\t\t\t<category>asides</category>\n";
                 echo "\t\t\t<guid isPermaLink=\"false\">".$url."index.php?aside=".$row["id"]."</guid>\n";
-                echo "\t\t\t<author>".htmlspecialchars($authors[$row["authors_id"]]["email"])." (".htmlspecialchars($authors[$row["authors_id"]]["fullname"]).")</author>\n";
+                echo "\t\t\t<author>".htmlspecialchars($mvblog->authors[$row["authors_id"]]["email"])." (".htmlspecialchars($mvblog->authors[$row["authors_id"]]["fullname"]).")</author>\n";
         } else {
                 echo "\t\t\t<link>".$url."index.php?action=view&amp;id=".$row["id"]."$link</link>\n";
@@ -126 +115 @@
                 if (!$comments) {
                         echo "\t\t\t<comments>".$url."index.php?action=view&amp;id=".$row["id"]."#comments</comments>\n";
-                        echo "\t\t\t<author>".htmlspecialchars($authors[$row["authors_id"]]["email"])." (".htmlspecialchars($authors[$row["authors_id"]]["fullname"]).")</author>\n";
+                        echo "\t\t\t<author>".htmlspecialchars($mvblog->authors[$row["authors_id"]]["email"])." (".htmlspecialchars($mvblog->authors[$row["authors_id"]]["fullname"]).")</author>\n";
                 }
         }