FIX:コメント取得のクエリに必要なスペースがないために発生するクエリエラーを修正

diff --git a/nucleus/libs/COMMENT.php b/nucleus/libs/COMMENT.php
index fb6bf88..71473fa 100644 (file)
--- a/nucleus/libs/COMMENT.php
+++ b/nucleus/libs/COMMENT.php
@@ -31,18 +31,18 @@ class Comment
        function getComment($commentid)\r
        {\r
                $query = 'SELECT cnumber AS commentid,'\r
-                             . 'cbody AS body,'\r
-                             . 'cuser AS user,'\r
-                             . 'cmail AS userid,'\r
-                             . 'cemail AS email,'\r
-                             . 'cmember AS memberid,'\r
-                             . 'ctime,'\r
-                             . 'chost AS host,'\r
-                             . 'mname AS member,'\r
-                             . 'cip AS ip,'\r
-                             . 'cblog AS blogid'\r
-                      . 'FROM %s LEFT OUTER JOIN %s ON cmember = mnumber'\r
-                      . 'WHERE cnumber = %d;';\r
+                             . ' cbody AS body,'\r
+                             . ' cuser AS user,'\r
+                             . ' cmail AS userid,'\r
+                             . ' cemail AS email,'\r
+                             . ' cmember AS memberid,'\r
+                             . ' ctime,'\r
+                             . ' chost AS host,'\r
+                             . ' mname AS member,'\r
+                             . ' cip AS ip,'\r
+                             . ' cblog AS blogid'\r
+                      . ' FROM %s LEFT OUTER JOIN %s ON cmember = mnumber'\r
+                      . ' WHERE cnumber = %d;';\r
                \r
                $query = sprintf($query, sql_table('comment'), sql_table('member'), (integer) $commentid);\r
                $comments = sql_query($query);