Changeset 3308

Show
Ignore:
Timestamp:
05/21/07 18:11:33 (18 months ago)
Author:
inureyes
Message:

#408

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

Legend:

Unmodified
Added
Removed

  • sandbox/blog/checkup/index.php

    r3299 r3308  
    514514    "; 
    515515    if (DBQuery::execute($query . ' DEFAULT CHARSET=utf8') || DBQuery::execute($query)) { 
    516         while($row = DBQuery::queryRow("SELECT * FROM `{$database['prefix']}Users` ORDER BY userid")){ 
    517             DBQuery::execute("INSERT INTO `{$database['prefix']}Teamblog` VALUES('".$row['userid']."', '".$row['userid']."','0','1','1', '".$row['name']."', '', '0', '#000000', '10', '0', '".$row['created']."', '0')"); 
     516        $query = new TableQuery($database['prefix'] . 'Users'); 
     517        if($query->doesExist()) { 
     518            $changed = true; 
     519            if ($users = $query->getAll('userid, name, created')) { 
     520                foreach($users as $user) { 
     521                    DBQuery::execute("INSERT INTO `{$database['prefix']}Teamblog` VALUES('".$user['userid']."', '".$user['userid']."','0','1','1', '".$user['name']."', '', '0', '#000000', '10', '0', '".$user['created']."', '0')"); 
     522                } 
     523            } 
     524            unset($users); 
     525            echo '<span style="color:#33CC33;">', _text('성공'), '</span></li>'; 
    518526        } 
    519         echo '<span style="color:#33CC33;">', _text('성공'), '</span></li>'; 
    520527    } else 
    521528        echo '<span style="color:#FF0066;">', _text('실패'), '</span></li>'; 
    … …  
    534541    "; 
    535542    if (DBQuery::execute($query . ' DEFAULT CHARSET=utf8') || DBQuery::execute($query)) { 
    536         while($row = DBQuery::queryRow("SELECT * FROM `{$database['prefix']}Entries` ORDER BY owner")){ 
    537             DBQuery::execute("INSERT INTO   `{$database['prefix']}TeamEntryRelations`  VALUES('".$row['owner']."', '".$row['id']."','".$row['owner']."')"); 
     543        $query = new TableQuery($database['prefix'] . 'Entries'); 
     544        if($query->doesExist()) { 
     545            $changed = true; 
     546            if ($entries = $query->getAll('owner, id')) { 
     547                foreach($entries as $entry) { 
     548                    DBQuery::execute("INSERT INTO   `{$database['prefix']}TeamEntryRelations`  VALUES('".$entry['owner']."', '".$entry['id']."','".$entry['owner']."')"); 
     549                 
     550                } 
     551            } 
     552            unset($entries); 
     553            echo '<span style="color:#33CC33;">', _text('성공'), '</span></li>'; 
    538554        } 
    539         echo '<span style="color:#33CC33;">', _text('성공'), '</span></li>'; 
     555         
    540556    } else 
    541557        echo '<span style="color:#FF0066;">', _text('실패'), '</span></li>';