<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
 <title>EtchiBBS Spiral DB Update for Spiral-2</title>
 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>

<body>
<p>
<?php
if (!file_exists('lib/common.php')) {
    die('ERROR:: EtchiBBS Sprial 1.2 이상을 설치한 후에 실행해주세요.</p></body></html>');
}

require 'lib/common.php';

echo 'DB 업데이트를 시작합니다.</p>';

$DB->query("UPDATE hboard_db_admin SET width_max=0");
echo '<p>이미지 최대크기 초기화 완료.</p>';

if (file_exists('db/img/dbinfo')) {
    $read = file('db/img/dbinfo');
    $size = trim($read[1]);
    $DB->query("UPDATE hboard_db_admin SET article_max=article_max+{$size}");
    unlink('db/img/dbinfo');
    echo '<p>이미지 용량 변환 완료.</p>';
}

if ($admin_data['app'] < 100) {
    $deleted_count = $DB->iquery("SELECT count(*) FROM hboard_db_article WHERE deleted='t'");
    $deleted_count *= 100;
    $DB->query("UPDATE hboard_db_admin SET app=app+{$deleted_count}");
    echo '<p>삭제된 글 수 변환 완료.</p>';
}

echo '<p>변환을 완료하였습니다.</p>';
?>
</body>
</html>

