convert,upgrades内のコードも含めてDBクラスを使用するコードに修正（未テスト）

[nucleus-jp/nucleus-next.git] / nucleus / upgrades / upgrade1.1.php

diff --git a/nucleus/upgrades/upgrade1.1.php b/nucleus/upgrades/upgrade1.1.php
index 5a56f82..6403ab4 100644 (file)
--- a/nucleus/upgrades/upgrade1.1.php
+++ b/nucleus/upgrades/upgrade1.1.php
@@ -71,9 +71,9 @@ function upgrade_do110() {
                // 4. add 'general' categories for all blogs, and update nucleus_item
                $catid = 1;     // generate catids ourself
                $query = 'SELECT bnumber FROM '.sql_table('blog');
-               $res = mysql_query($query);
-               while ($current = mysql_fetch_object($res)) {
-                       $blogid = $current->bnumber;
+               $res = DB::getResult($query);
+               foreach ( $res as $current ) {
+                       $blogid = $current['bnumber'];
                        
                        $query = 'INSERT INTO '.sql_table('category')." (catid, cblog, cname, cdesc) VALUES ($catid, $blogid, 'General', 'Items that do not fit in other categories')";
                        $r = upgrade_query("Adding category 'general' for blog " . $blogid, $query);
@@ -93,7 +93,7 @@ function upgrade_do110() {
                // 5. add template parts for category lists to all templates
                $query = 'SELECT tdnumber FROM '.sql_table('template_desc');
                $res = DB::getResult($query);   // get all template ids
-               foreach ( $res as $row) {
+               foreach ( $res as $row ) {
                        $tid = $row['tdnumber'];        // template id
                
                        $query = 'INSERT INTO '.sql_table('template')." VALUES ($tid, 'CATLIST_HEADER', '<ul><li><a href=\"<%blogurl%>\">All</a></li>');";