OSDN Git Service

[NEW] データベースをハンドルする新しいDBクラスを追加。関連する修正を反映。
[nucleus-jp/nucleus-next.git] / nucleus / xmlrpc / api_nucleus.inc.php
index 0f4702f..06219a4 100644 (file)
                           ." WHERE iblog=$blogid"
                           ." ORDER BY itime DESC"
                           ." LIMIT $amount";
-               $r = sql_query($query);
-               while ($obj = sql_fetch_object($r)) {
+               $r = DB::getResult($query);
+               foreach ( $r as $row ) {
                        $newstruct = new xmlrpcval(array(
-                               "publishDate" => new xmlrpcval(iso8601_encode(strtotime($obj->itime)),"dateTime.iso8601"),
-                               "userid" => new xmlrpcval($obj->iauthor,"string"),
+                               "publishDate" => new xmlrpcval(iso8601_encode(strtotime($row['itime'])),"dateTime.iso8601"),
+                               "userid" => new xmlrpcval($row['iauthor'],"string"),
                                "blogid" => new xmlrpcval($blogid,"string"),
-                               "title" => new xmlrpcval($obj->ititle,"string"),
-                               "body" => new xmlrpcval($obj->ibody,"string"),
-                               "more" => new xmlrpcval($obj->imore,"string"),
-                               "draft" => new xmlrpcval($obj->idraft,"boolean"),
-                               "closed" => new xmlrpcval($obj->iclosed,"boolean"),
+                               "title" => new xmlrpcval($row['ititle'],"string"),
+                               "body" => new xmlrpcval($row['ibody'],"string"),
+                               "more" => new xmlrpcval($row['imore'],"string"),
+                               "draft" => new xmlrpcval($row['idraft'],"boolean"),
+                               "closed" => new xmlrpcval($row['iclosed'],"boolean"),
                        ),'struct');
                        array_push($structarray, $newstruct);
                }