Changeset 4654 for trunk/blog/checkup/index.php

Timestamp:

11/06/07 00:56:12 (3 years ago)

Author:

inureyes

Message:

#708

• Eliminate mysql_ functions from comment model.
• Delete auto_increment extra property from comment tables.
  • Is not compatible with other DBMS.

Files:

• trunk/blog/checkup/index.php (modified) (1 diff)

trunk/blog/checkup/index.php

@@ -877 +877 @@
 }
 
+// From 1.6
+if (DBQuery::queryCell("DESC {$database['prefix']}Comments id", 'Extra') == 'auto_increment') {
+    $changed = true;
+    echo '<li>', _text('데이터베이스 호환성을 위하여 댓글 테이블의 자동 증가 설정을 제거합니다.'), ': ';
+    if (DBQuery::execute("ALTER TABLE {$database['prefix']}Comments CHANGE id id int(11) NOT NULL")
+        && DBQuery::execute("ALTER TABLE {$database['prefix']}CommentsNotifiedQueue CHANGE id id int(11) NOT NULL")
+        && DBQuery::execute("ALTER TABLE {$database['prefix']}CommentsNotifiedSiteInfo CHANGE id id int(11) NOT NULL"))
+        echo '<span style="color:#33CC33;">', _text('성공'), '</span></li>';
+    else
+        echo '<span style="color:#FF0066;">', _text('실패'), '</span></li>';
+}
 
 // Common parts.