dbconn.php 변환중...
'; $fp = fopen('db/dbconn.php', 'w') or die('ERROR!! dbconn.php 생성 실패.'); fwrite($fp, "'); fclose($fp); echo 'UTF-8 변환을 시작합니다.
'; /* {{{ article */ echo 'article 테이블 변환중...
';
mysql_query('LOCK TABLES hboard_db_article WRITE');
$auto_num = mysql_result(mysql_query('SELECT max(idx) FROM hboard_db_article'), 0, 0);
mysql_query('ALTER TABLE hboard_db_article CHANGE COLUMN idx idx INTEGER NOT NULL AUTO_INCREMENT');
mysql_query('ALTER TABLE hboard_db_article AUTO_INCREMENT=' . $auto_num);
mysql_query('ALTER TABLE hboard_db_article ADD INDEX (md5)');
$result = mysql_query('SELECT idx, name, subject, ment FROM hboard_db_article');
while ( ($data = mysql_fetch_assoc($result))) {
if ( ($name = iconv('CP949', 'UTF-8', $data['name'])) === FALSE ||
($subject = iconv('CP949', 'UTF-8', $data['subject'])) === FALSE ||
($ment = iconv('CP949', 'UTF-8', $data['ment'])) === FALSE) {
echo "
{$data['idx']}번 변환 실패.
";
continue;
} else {
$name = addslashes($name);
$subject = addslashes($subject);
$ment = addslashes($ment);
mysql_query("UPDATE hboard_db_article
SET name='{$name}', subject='{$subject}', ment='{$ment}'
WHERE idx='{$data['idx']}'");
echo '.';
}
}
mysql_query('UNLOCK TABLES');
echo '
article 테이블 변환 완료.
comment 테이블 변환중...
';
mysql_query('LOCK TABLES hboard_db_comment WRITE');
mysql_query('ALTER TABLE hboard_db_comment ADD INDEX (article, idx)');
$result = mysql_query('SELECT idx, article, name, ment, icon FROM hboard_db_comment');
while ( ($data = mysql_fetch_assoc($result))) {
if ( ($name = iconv('CP949', 'UTF-8', $data['name'])) === FALSE ||
($ment = iconv('CP949', 'UTF-8', $data['ment'])) === FALSE ||
($icon = iconv('CP949', 'UTF-8', $data['icon'])) === FALSE) {
echo "
{$data['article']} / {$data['idx']}번 변환 실패.
";
continue;
} else {
$name = addslashes($name);
$ment = addslashes($ment);
$icon = addslashes($icon);
mysql_query("UPDATE hboard_db_comment
SET name='{$name}', ment='{$ment}', icon='{$icon}'
WHERE idx='{$data['idx']}' AND article='{$data['article']}'");
echo '.';
}
}
mysql_query('UNLOCK TABLES');
echo '
comment 테이블 변환 완료.
변환을 완료하였습니다.
'; ?>