<?
include_once("./_common.php");

if ($is_admin != "super")
    alert("최고관리자만 변환 가능합니다", "$g4[bbs_path]/login.php?url=".urlencode($_SERVER[PHP_SELF]));

$g4[title] = "그룹 변환 : 그누보드3 -> 포에버";
include_once("$g4[path]/head.sub.php");



$sql = " select * from gb_board order by gr_id "; 
$result = sql_query($sql); 
for ($i=0; $row=sql_fetch_array($result); $i++) {

  $sql2 = " insert into g4_board
                         set gr_id = '$row[gr_id]',
							 bo_table = '$row[bo_table]',
							 bo_subject = '".addslashes($row[bo_subject ])."',
							 bo_admin  = '".addslashes($row[bo_admin])."',
							 bo_list_level = '$row[bo_list_level]', 
							   bo_read_level  = '$row[bo_read_level]', 
							   bo_write_level = '$row[bo_write_level]',
							   bo_reply_level = '$row[bo_reply_level]',
							   bo_comment_level = '$row[bo_comment_level]',
							   bo_upload_level = '$row[bo_upload_level]',
							   bo_download_level = '$row[bo_download_level]',
							   bo_notice = '$row[bo_notice_level]',
							   bo_html_level = '$row[bo_html_level]',
							   bo_link_level = '$row[bo_link_level]', 
							   bo_use_category = '$row[bo_use_category]',
							   bo_use_secret = '$row[bo_use_secret]',
							   bo_use_comment = '$row[bo_use_comment]',
							   bo_use_good = '$row[bo_use_good]',
							   bo_use_nogood = '$row[bo_use_nogood]',
							   bo_use_signature = '$row[bo_use_signature]',
							   bo_use_list_view = '$row[bo_use_listview]',
							   bo_use_list_content = '$row[bo_use_listcontent]',
							   bo_table_width = '$row[bo_table_width]',
							   bo_subject_len = '$row[bo_subject_len]',
							   bo_page_rows  = '$row[bo_page_rows]',
							   bo_new = '$row[bo_new]',
							   bo_hot  = '$row[bo_hot]',
							   bo_skin = '$row[bo_skin]',
							   bo_include_head = '$row[bo_include_head]',
							   bo_include_tail = '$row[bo_include_tail]',
							   bo_content_head = '".addslashes($row[bo_content_head])."',
							   bo_content_tail = '".addslashes($row[bo_content_tail])."',
							   bo_insert_content = '".addslashes($row[bo_insert_content])."',
							   bo_count_write = '$row[bo_total_count]',
							   bo_gallery_cols = '$row[bo_gallery_width]',
							   bo_upload_size = '$row[bo_upload_size ]',
							   bo_use_search  = '$row[bo_use_search]',
							   bo_order_search = '$row[bo_order_search]',
							   bo_1 = '$row[bo_1]',
							   bo_2 = '$row[bo_2]',
							   bo_3 = '$row[bo_3]',
							   bo_4 = '$row[bo_4]',
							   bo_5   = '$row[bo_5 ]' ";

	sql_query($sql2);

$tmp_target = $g4[write_prefix] . $row[bo_table];

 $sql3 = "CREATE TABLE $tmp_target (
  wr_id int(11) NOT NULL auto_increment,
  wr_num int(11) NOT NULL default '0',
  wr_reply varchar(10) NOT NULL default '',
  wr_parent int(11) NOT NULL default '0',
  wr_is_comment tinyint(4) NOT NULL default '0',
  wr_comment int(11) NOT NULL default '0',
  wr_comment_reply varchar(5) NOT NULL default '',
  ca_name varchar(255) NOT NULL default '',
  wr_option set('html1','html2','secret','mail') NOT NULL default '',
  wr_subject varchar(255) NOT NULL default '',
  wr_content text NOT NULL,
  wr_link1 text NOT NULL,
  wr_link2 text NOT NULL,
  wr_link1_hit int(11) NOT NULL default '0',
  wr_link2_hit int(11) NOT NULL default '0',
  wr_trackback varchar(255) NOT NULL default '',
  wr_hit int(11) NOT NULL default '0',
  wr_good int(11) NOT NULL default '0',
  wr_nogood int(11) NOT NULL default '0',
  mb_id varchar(255) NOT NULL default '',
  wr_password varchar(255) NOT NULL default '',
  wr_name varchar(255) NOT NULL default '',
  wr_email varchar(255) NOT NULL default '',
  wr_homepage varchar(255) NOT NULL default '',
  wr_datetime datetime NOT NULL default '0000-00-00 00:00:00',
  wr_ip varchar(255) NOT NULL default '',
  wr_1 varchar(255) NOT NULL default '',
  wr_2 varchar(255) NOT NULL default '',
  wr_3 varchar(255) NOT NULL default '',
  wr_4 varchar(255) NOT NULL default '',
  wr_5 varchar(255) NOT NULL default '',
  wr_6 varchar(255) NOT NULL default '',
  wr_7 varchar(255) NOT NULL default '',
  wr_8 varchar(255) NOT NULL default '',
  wr_9 varchar(255) NOT NULL default '',
  wr_10 varchar(255) NOT NULL default '',
  PRIMARY KEY  (wr_id),
  KEY wr_comment_num (wr_comment,wr_num,wr_reply),
  KEY wr_num_reply_parent (wr_num,wr_reply,wr_parent),
  KEY wr_parent_comment (wr_parent,wr_comment)
) TYPE=MyISAM;";

  sql_query($sql3);

}



    echo <<<HEREDOC
    <script language="JavaScript">
        alert("변환 하였습니다.");
    </script>
HEREDOC;

?>

<?
include_once("$g4[path]/tail.sub.php");
?>