Changeset 3308 for sandbox/blog/checkup/index.php

Timestamp:

05/21/07 18:11:33 (20 months ago)

Author:

inureyes

Message:

#408

• checkup 부분의 재작성.
  
• 기존의 checkup실행해서 오류난 경우에는 Teamblog, TeamEntryRelations 테이블을 지우고 다시 하세요~
  

Files:

• sandbox/blog/checkup/index.php (modified) (2 diffs)

sandbox/blog/checkup/index.php

@@ -514 +514 @@
     ";
     if (DBQuery::execute($query . ' DEFAULT CHARSET=utf8') || DBQuery::execute($query)) {
-        while($row = DBQuery::queryRow("SELECT * FROM `{$database['prefix']}Users` ORDER BY userid")){
-            DBQuery::execute("INSERT INTO `{$database['prefix']}Teamblog` VALUES('".$row['userid']."', '".$row['userid']."','0','1','1', '".$row['name']."', '', '0', '#000000', '10', '0', '".$row['created']."', '0')");
+        $query = new TableQuery($database['prefix'] . 'Users');
+        if($query->doesExist()) {
+            $changed = true;
+            if ($users = $query->getAll('userid, name, created')) {
+                foreach($users as $user) {
+                    DBQuery::execute("INSERT INTO `{$database['prefix']}Teamblog` VALUES('".$user['userid']."', '".$user['userid']."','0','1','1', '".$user['name']."', '', '0', '#000000', '10', '0', '".$user['created']."', '0')");
+                }
+            }
+            unset($users);
+            echo '<span style="color:#33CC33;">', _text('성공'), '</span></li>';
         }
-        echo '<span style="color:#33CC33;">', _text('성공'), '</span></li>';
     } else
         echo '<span style="color:#FF0066;">', _text('실패'), '</span></li>';
@@ -534 +541 @@
     ";
     if (DBQuery::execute($query . ' DEFAULT CHARSET=utf8') || DBQuery::execute($query)) {
-        while($row = DBQuery::queryRow("SELECT * FROM `{$database['prefix']}Entries` ORDER BY owner")){
-            DBQuery::execute("INSERT INTO   `{$database['prefix']}TeamEntryRelations`  VALUES('".$row['owner']."', '".$row['id']."','".$row['owner']."')");
+        $query = new TableQuery($database['prefix'] . 'Entries');
+        if($query->doesExist()) {
+            $changed = true;
+            if ($entries = $query->getAll('owner, id')) {
+                foreach($entries as $entry) {
+                    DBQuery::execute("INSERT INTO   `{$database['prefix']}TeamEntryRelations`  VALUES('".$entry['owner']."', '".$entry['id']."','".$entry['owner']."')");
+                
+                }
+            }
+            unset($entries);
+            echo '<span style="color:#33CC33;">', _text('성공'), '</span></li>';
         }
-        echo '<span style="color:#33CC33;">', _text('성공'), '</span></li>';
+        
     } else
         echo '<span style="color:#FF0066;">', _text('실패'), '</span></li>';