CHANGE:クエリ生成時のdate関数をDB::formatDateTimeに変更

[nucleus-jp/nucleus-next.git] / nucleus / libs / BLOG.php

diff --git a/nucleus/libs/BLOG.php b/nucleus/libs/BLOG.php
index f813eba..a14052d 100644 (file)
--- a/nucleus/libs/BLOG.php
+++ b/nucleus/libs/BLOG.php
@@ -342,8 +342,9 @@ class Blog
                $ititle = DB::quoteValue($title);\r
                $ibody = DB::quoteValue($body);\r
                $imore = DB::quoteValue($more);\r
+               $timestamp = DB::formatDateTime(strtotime($timestamp));\r
                \r
-               $query = "INSERT INTO %s (ITITLE, IBODY, IMORE, IBLOG, IAUTHOR, ITIME, ICLOSED, IDRAFT, ICAT, IPOSTED) VALUES (%s, %s, %s, %d, %d, '%s', %s, %s, %s, %s)";\r
+               $query = "INSERT INTO %s (ITITLE, IBODY, IMORE, IBLOG, IAUTHOR, ITIME, ICLOSED, IDRAFT, ICAT, IPOSTED) VALUES (%s, %s, %s, %d, %d, %s, %s, %s, %s, %s)";\r
                $query = sprintf($query, sql_table('item'), $ititle, $ibody, $imore, $blogid, $authorid, $timestamp, $closed, $draft, $catid, $posted);\r
                DB::execute($query);\r
                $itemid = DB::getInsertId();\r