MySQL -> MySQLi

Fixed memory leaks after Fetching arrays
Removed all while loops that interfaced with $db->Fetch()
Rewrote RSS module
Fixed syntax error in donations module
Fixed link structure for news module
Reverting to old page display method



git-svn-id: http://svn.3rd-infantry-division.org/testing/branches/Bayonet CMS v2@402 c5b2fb0a-d05d-0410-98c8-828840a80ff6

1 files changed, 3 insertions, 9 deletions

diff --git a/admin/blocks/functions.php b/admin/blocks/functions.php
index ad7daa0..aaa7f36 100644
--- a/admin/blocks/functions.php
+++ b/admin/blocks/functions.php
@@ -21,10 +21,8 @@ function ListBlocks()
 {
   global $db;
   $result = $db->Query("SELECT * FROM `bayonet_blocks` ORDER BY `active` DESC, `weight` ASC, `position`");
-  while(($rows = $db->fetch($result))!=false)
-  {
-    $blocks[] = $rows;
-  }
+  $blocks = $db->Fetch($result);
+  
   
   echo "<table align=\"center\"><tr><th colspan=\"3\">Existing Blocks</th></tr>";
   foreach($blocks as $block)
@@ -121,11 +119,7 @@ function EditBlock($block_id)
   
   //Grab the page from the database according to the $page_id passed to the function.
   $result = $db->Query("SELECT weight,dir_name,position,active,title FROM bayonet_blocks WHERE block_id = '$block_id'");
-  while(($row = $db->Fetch($result))!=false)
-  {
-    //We only want one row, so we don't have to $block[]...  No foreach necessary.
-    $block = $row; 
-  }    
+  $block = $db->FetchRow($result);    
 
   ?>
   <form action="<?php $_SERVER['PHP_SELF']?>" method="post">