wr_subject COLUMN_TYPE varchar(255) => TEXT
wr_content COLUMN_TYPE text => LONGTEXT
if($is_admin){
$result = sql_query(" SELECT COLUMN_TYPE FROM information_schema.COLUMNS WHERE TABLE_NAME='{$write_table}' AND COLUMN_NAME='wr_subject' AND TABLE_SCHEMA='".G5_MYSQL_DB."' ");
$row = mysqli_fetch_assoc($result);
if($row['COLUMN_TYPE']=='varchar(255)'){sql_query(" ALTER TABLE `{$write_table}` CHANGE `wr_subject` `wr_subject` TEXT NOT NULL ");echo '<script>alert("wr_subject varchar(255) => TEXT")</script>';}
$result = sql_query(" SELECT COLUMN_TYPE FROM information_schema.COLUMNS WHERE TABLE_NAME='{$write_table}' AND COLUMN_NAME='wr_content' AND TABLE_SCHEMA='".G5_MYSQL_DB."' ");
$row = mysqli_fetch_assoc($result);
if($row['COLUMN_TYPE']=='text'){sql_query(" ALTER TABLE `{$write_table}` CHANGE `wr_content` `wr_content` LONGTEXT NOT NULL ");echo '<script>alert("wr_content TEXT => LONGTEXT")</script>';}
}
위 내용을 게시판 폴더의 write.head.skin.php 또는 write.skin.php의 상단에 넣어주면 자동으로 변경됨.