<?
/*
그누보드4, 그누보드DTD, 그누독스2012 버전 등의 데이터 베이스를 그누독스 2013 형태로 변환하는 프로그램입니다. 
수정,재배포는 자유입니다.  
이 프로그램은 GPL 라이센스를 따릅니다. 
제작자 모조키 mozoki@gmail.com  http://www.mozoki.com      
*/

// 사용법 - 아래 디비 설정부분에 내용을 기입한 후에 웹계정에 업로드하고 브라우저로 한번 실행해 주시면 됩니다.

// 이 프로그램을 실행하기 전에 반드시 DB 백업을 하십시오. 

//프로그램실행으로 인해 발생할 수도 있는 문제점은 모두 프로그램을 사용한 사람의 몫입니다.

// 한번만 실행하시면 됩니다.


// 아래는 디비 설정입니다. dbconfig.php 내용과 동일합니다. 내용 삽입해주세요.

$mysql_host = '';
$mysql_user = '';
$mysql_password = '';
$mysql_db = '';
$db_prefix = '';  // 테이블이름의 앞쪽 첨자입니다. 자신의 DB 확인하시고 반드시 넣으셔야합니다. 예: $db_prefix = 'g4_'; 


$connect = mysql_connect($mysql_host, $mysql_user, $mysql_password, $mysql_db); 
mysql_select_db($mysql_db); 

// 20130522 그누독스용 데이터베이스 업그레이드
// dtd 버전엔 없던 auth 테이블 추가.

function exist_table($table_name)
{
  $result = mysql_query("SHOW TABLES LIKE '$table_name'");
  $row = mysql_fetch_array($result, MYSQL_NUM);
  if($row == false)return false;
  return true;
}

$auth_table = $g4['table_prefix']."auth";

if(exist_table($auth_table)){
} else {
$sql = "CREATE TABLE `$auth_table` (
  `mb_id` varchar(255) NOT NULL default '',
  `au_menu` varchar(20) NOT NULL default '',
  `au_auth` set('r','w','d') NOT NULL default '',
  PRIMARY KEY  (`mb_id`,`au_menu`)
) DEFAULT CHARSET=utf8; ";
mysql_query($sql); 	
}


// g4_board 테이블 수정
$board_table = $g4['table_prefix']."board";

sql_query(" ALTER TABLE `{$board_table}`  ADD `bo_use_comment`  tinyint(4) NOT NULL default '0'  AFTER `bo_use_rss_view` ", FALSE);
sql_query(" ALTER TABLE `{$board_table}`  ADD `bo_theme` varchar(255) NOT NULL default 'default' AFTER `bo_subject` ", FALSE);
sql_query(" ALTER TABLE `{$board_table}`  ADD `bo_mtheme` varchar(255) NOT NULL default 'mobile' AFTER bo_theme ", FALSE);
sql_query(" ALTER TABLE `{$board_table}`  ADD `bo_mskin` varchar(255) NOT NULL default 'bootstrap_bbs' AFTER bo_skin ", FALSE);
sql_query(" ALTER TABLE `{$board_table}`  ADD `bo_image_mhead` varchar(255) NOT NULL default '' AFTER bo_image_head ", FALSE);
sql_query(" ALTER TABLE `{$board_table}`  ADD `bo_image_mtail` varchar(255) NOT NULL default '' AFTER bo_image_tail ", FALSE);
sql_query(" ALTER TABLE `{$board_table}`  ADD `bo_include_mhead` varchar(255) NOT NULL default '' AFTER bo_include_head ", FALSE);
sql_query(" ALTER TABLE `{$board_table}`  ADD `bo_include_mtail` varchar(255) NOT NULL default '' AFTER bo_include_tail ", FALSE);
sql_query(" ALTER TABLE `{$board_table}`  ADD `bo_content_mhead` varchar(255) NOT NULL default '' AFTER bo_content_head ", FALSE);
sql_query(" ALTER TABLE `{$board_table}`  ADD `bo_content_mtail` varchar(255) NOT NULL default '' AFTER bo_content_tail ", FALSE);
sql_query(" ALTER TABLE `{$board_table}`  ADD `bo_insert_mcontent` varchar(255) NOT NULL default '' AFTER bo_insert_content ", FALSE);

// g4_member 테이블 수정  
$member_table = $g4['table_prefix']."member";
sql_query(" ALTER TABLE `{$member_table}`  ADD `mb_lost_certify` varchar(255) NOT NULL AFTER mb_memo ", FALSE); //mb_memo 칼럼 뒤에 mb_lost_certify 칼럼생성
sql_query(" ALTER TABLE `{$member_table}`  ADD `mb_usercolor` varchar(255) NOT NULL default '#f3f3f3' AFTER mb_memo_call ", FALSE); // 회원색상 들어가는 칼럼 추가

//group  테이블 수정
$group_table = $g4['table_prefix']."group";
sql_query(" ALTER TABLE `{$group_table}`  ADD `gr_theme` varchar(255) NOT NULL default 'default' AFTER gr_subject ", FALSE);
sql_query(" ALTER TABLE `{$group_table}`  ADD `gr_mtheme` varchar(255) NOT NULL default 'mobile' AFTER gr_theme ", FALSE);
sql_query(" ALTER TABLE `{$group_table}`  ADD `gr_skin` varchar(255) NOT NULL default 'default' AFTER gr_mtheme ", FALSE);
sql_query(" ALTER TABLE `{$group_table}`  ADD `gr_mskin` varchar(255) NOT NULL default 'mobile' AFTER gr_skin ", FALSE);

//config  테이블 수정
$config_table = $g4['table_prefix']."config";
sql_query("ALTER TABLE {$config_table} ADD `cf_new_mskin` varchar(255) NOT NULL 'mobile' AFTER cf_new_skin", FALSE);
sql_query("ALTER TABLE {$config_table} ADD `cf_login_mskin` varchar(255) NOT NULL 'mobile' AFTER cf_login_skin ", FALSE);
sql_query("ALTER TABLE {$config_table} ADD `cf_search_mskin` varchar(255) NOT NULL 'mobile' AFTER cf_search_skin ", FALSE);
sql_query("ALTER TABLE {$config_table} ADD `cf_connect_mskin` varchar(255) NOT NULL 'mobile' AFTER cf_connect_skin ", FALSE);
sql_query("ALTER TABLE {$config_table} ADD `cf_register_mskin` varchar(255) NOT NULL 'mobile' AFTER cf_register_skin ", FALSE);
sql_query("ALTER TABLE {$config_table} ADD `cf_member_mskin` varchar(255) NOT NULL 'mobile' AFTER cf_member_skin ", FALSE);

sql_query("ALTER TABLE {$config_table} ADD `cf_user_color` text NOT NULL default '' AFTER cf_memo_send_point ", FALSE);
$sql6 = "update $config_table set cf_user_color=
'#FAFAFA|#F5F5F5|#E8E8E8|#E8E8E8|#DFDFDF|#D5D5D5|#CBCBCB|#BFBFBF|#FFF1F1|#F5E7E7|#E6D7D7|#D7C5C5|#CCB6B6|#FFCACA|#F4C1C1|#E9B4B4|#E3A9A9|#FF9C9C|#F69191|#EE8080|#E67272|#FF8080|#F56E6E|#EC5E5E|#E04F4F|#FFF4EF|#F4E5DF|#EAD9D2|#E1CBC2|#D8BDB2|#FFE7DD|#EDCBBC|#D8AA96|#C99179|#FFDACA|#EABCA8|#DAA38B|#C98D73|#FFC5AC|#EAAA8E|#DA9679|#C88364|#FFBEA2|#EDA88A|#DA9373|#C57B5A|#B36848|#FFAA85|#EE9873|#D88059|#C46B44|#FF9769|#EF8759|#DC7548|#CE683B|#FFF6E8|#EFE0CA|#DDCAAC|#CFB996|#FFEBCB|#E8D1AD|#D5B98E|#BE9F6F|#FFE5BC|#EACB9B|#D6B480|#C5A26A|#FFDCA6|#ECC78D|#D9B171|#C59B58|#FFD89A|#EFC684|#DCB16E|#CA9D56|#FFCC7B|#E8B25C|#D49A3F|#C0862C|#FFC05D|#EAAA44|#D6932A|#C48117|#FFFBE0|#EDE7C2|#E1D9A4|#CAC183|#BAB06D|#FFF8C9|#EDE4A5|#E1D68C|#D0C471|#FFF7BE|#EDE39E|#DCD081|#C5B862|#FFF4A9|#EEE28F|#DCCE72|#CCBE5C|#FFF18F|#EEDE75|#D8C859|#FFEE7F|#EFDD64|#DBC84C|#C7B434|#FFE954|#EAD43D|#D6C02B|#FEFFDE|#EAECB8|#DBDD9C|#C7CA7C|#FDFFC8|#E9EBA6|#D5D888|#C7CA6D|#FCFFAC|#E6E988|#D0D469|#BFC34E|#FBFF91|#E4E870|#CCD053|#BCC13C|#FAFF74|#E1E655|#D1D63C|#C1C729|#F9FF57|#E7ED3D|#D5DB28|#F7FFD8|#E3EEB5|#CCDA93|#B7C873|#F2FFBF|#DFEF9D|#CADC81|#B9CF60|#EFFFAE|#DCEF92|#CBDF79|#BDD364|#EBFF9D|#DAF083|#C4DC66|#B1CA4D|#E3FC7F|#D1EC67|#BCD84B|#D7F758|#C6E741|#EFFFD6|#D5EAB5|#BAD68D|#E1FDB6|#D0EF9F|#B8DA83|#A3C868|#DEFEAA|#CAEF8F|#B5DF73|#A2CF5C|#D4FF90|#C0F076|#AEE15D|#9ED546|#C4FF67|#ADEC49|#9ADA36|#EBFFE1|#CBEBBC|#AED59B|#97C581|#D7FFC3|#BEF0A5|#A3DB88|#8FCA71|#C5FCAA|#ADEB8F|#93D872|#81CA5D|#B6FB95|#99E673|#7ED155|#A6F87D|#90E765|#78D44B|#E4FBE2|#C9EFC7|#C9EFC7|#9BD798|#CBFBC9|#B1EDAE|#94DB90|#7DCC7A|#B4FFB0|#90E48C|#70CF6B|#54C04F|#94FA8F|#75E170|#5FCE5A|#E5FBED|#C3E6CF|#98CEAB|#CAFADB|#AAE7C0|#8DD5A7|#BCFCD2|#9FEAB9|#7BD69B|#55BA79|#9AFEBE|#78E29D|#5ACC82|#84F9AD|#66E292|#4ACA77|#39BA66|#DFFCF3|#C3ECDF|#A1D7C6|#86C1AE|#D1FFF0|#B3EBD9|#90D5BF|#76C5AC|#BEFDE9|#A4E8D2|#86D6BD|#68C1A5|#B1FDE5|#8FE7CB|#71D0B2|#53B999|#E1FFFB|#C1ECE6|#A2DCD5|#82C9C0|#D0FFF9|#AFE8E1|#8DD5CC|#72C6BB|#C0FFF7|#A0EDE3|#73D9CC|#5FCEC0|#A2FFF3|#81E9DC|#61D6C7|#4CC7B7|#82FFEF|#66EAD9|#4ED8C6|#39C3B1|#6BFEEB|#55EFDB|#E3FBFF|#BFE8EE|#9FD5DD|#83C2CB|#BCF6FF|#9DE1EB|#7FD0DC|#63BDCA|#A2F2FE|#83DDEA|#66C7D6|#50B4C3|#8AEEFD|#70DBEB|#58C9DA|#44B7C8|#6EE9FB|#53CCDE|#41BED1|#5EE7FB|#47D3E8|#DEF5FF|#BFE1EF|#A1CBDD|#8DBDD1|#CAEDFC|#B1DBED|#99CCE1|#82BBD2|#6EACC5|#B6E7FC|#A0D6ED|#87C4DE|#6AADC9|#ABE5FD|#8ECFEA|#74B9D6|#5FA9C8|#97DFFD|#81CDED|#67B9DC|#50A7CB|#7AD4F9|#5EBAE1|#DEE7FF|#BFCDF0|#9DB0E1|#8A9FD3|#C1D2FD|#A7BBEF|#90A7E1|#7790D1|#B8CBFC|#99B1ED|#7F98D9|#6E88CC|#93B1FF|#7E9EEF|#5F82DC|#799FFF|#6188ED|#E1E1FF|#BDBDE9|#A4A4D9|#9292CD|#C0C0FF|#A1A1EC|#8686DA|#B2B2FC|#9C9CF1|#8181DC|#A0A0FD|#8787ED|#6B6BDD|#7A7AF9|#6666EC|#E5DAFF|#CBBBEF|#B3A0DC|#9E89CE|#D7C6FF|#BBA5ED|#A28AD9|#8B73C4|#BEA2FB|#A88AEB|#9373DA|#8261CC|#AE8AFE|#9B76EF|#F2DFFF|#D3B8E6|#BD9CD4|#A984C3|#E8C8FF|#CBA3E6|#B589D3|#A273C4|#E2B8FF|#D0A2F1|#BC87E1|#AA71D3|#D69BFF|#BF80EB|#B16EE0|#A560D5|#F9D8FF|#E5BAED|#D29DDC|#C285CD|#F7C8FF|#E1A7EB|#CF8FDB|#BD71CB|#EE9EFD|#D781E6|#CA6FDA|#BD5ECE|#ED89FF|#DB74ED|#C65BD9|#B54BC8|#EA77FF|#D85CEE|#C74BDD|#FFE3FD|#EDC1EA|#DAA2D7|#FFC4FC|#EFA9EB|#D889D3|#FFC7FC|#EBA9E7|#DD92D9|#CA7BC5|#FFABFA|#EA8DE5|#D876D2|#CA64C4|#FFA1F9|#EA83E4|#DC6CD5|#FF87F8|#ED72E6|#DF5FD7|#FFE1F7|#EEC0E2|#DFA1CE|#FFC7F0|#EDA7DA|#D889C3|#C774B1|#FFADE9|#EF96D7|#DD7DC3|#FFA0E5|#F28CD6|#E678C8|#D461B5|#FF7FDC|#EF6BCB|#E35CBE|#FFE5F2|#EDC9DC|#DEAFC7|#FFD6EB|#F0BAD6|#DDA1C0|#D391B3|#FFB6DC|#E99FC5|#DD8BB5|#CF79A5|#FFA3D3|#EF94C3|#DD7EAF|#CD6A9D|#FF93CB|#F083BB|#DF6DA8|#CE5D97|#FE84C3|#ED71B1|#DC5C9E|#CF4E91|#FF6BB8|#F260AC|#FFDFE8|#F2CBD6|#E3B3C1|#FFD2DF|#EFBAC9|#E4A4B6|#FDBDCF|#F0A7BB|#E190A7|#D37D95|#FFA5BE|#EF8DA8|#DE7A96|#FF93B1|#EF84A2|#E57695|#D56786|#FD82A5|#F17195|#E26185|#FFE7EB|#F2CFD5|#E8BAC1|#DAA2AB|#FFD8DE|#F3C0C9|#E2A4AE|#D48B97|#C77784|#FFB9C5|#F2A3B0|#EA8F9E|#DD7A8A|#CE697A|#FFABB9|#EE94A3|#DA7989|#CC6475|#FF899C|#EC7387|#DC5E73|#CE5065|#FF788E|#EB5F76'  ";
@mysql_query($sql6);


 // 테마 테이블 추가 
$theme_table = $g4['table_prefix']."theme";
$sql = " DROP TABLE IF EXISTS `$theme_table`; "; 
mysql_query($sql); 	

$sql = "CREATE TABLE `$theme_table` (
  `theme_id` varchar(255) NOT NULL default '',
  `theme_index`  varchar(255) NOT NULL default '',
  `theme_calendar`  varchar(255) NOT NULL default '',
  `theme_current_connect`  varchar(255) NOT NULL default '',
  `theme_formmail`  varchar(255) NOT NULL default '',
  `theme_login`  varchar(255) NOT NULL default '',
  `theme_member_confirm`  varchar(255) NOT NULL default '',
  `theme_new`  varchar(255) NOT NULL default '',
  `theme_register`  varchar(255) NOT NULL default '',
  `theme_register_form`  varchar(255) NOT NULL default '',
  `theme_register_result`  varchar(255) NOT NULL default '',
  `theme_search`  varchar(255) NOT NULL default '',
  PRIMARY KEY  (`theme_id`)
) DEFAULT CHARSET=utf8 ";
@mysql_query($sql);


$sql8="INSERT INTO `$theme_table` (`theme_id`,`theme_index`, `theme_calendar`, `theme_current_connect`, `theme_formmail`, `theme_login`, `theme_member_confirm`, `theme_new`, `theme_register`, `theme_register_form`, `theme_register_result`, `theme_search`) VALUES 
('theme', 'default', 'default', 'default','default','default','default','default','default','default','default','default'),
('mtheme', 'mobile', 'mobile','mobile','mobile','mobile','mobile','mobile','mobile','mobile','mobile','mobile'),
('skin', 'default', 'default','default','default','default','default','default','default','default','default','default'),
('mskin', 'mobile', 'mobile','mobile','mobile','mobile','mobile','mobile','mobile','mobile','mobile','mobile');";

@mysql_query($sql8);


// write 게시판에 필드 추가

$sql = " select bo_table from $g4[board_table] ";
$result = sql_query($sql);
while($row=sql_fetch_array($result))
{
sql_query(" ALTER TABLE `{$g4[write_prefix]}{$row[bo_table]}` ADD `wr_file` tinyint(4) NOT NULL AFTER `wr_homepage` ", FALSE);
sql_query(" ALTER TABLE `{$g4[write_prefix]}{$row[bo_table]}` ADD `wr_last` varchar(19) NOT NULL AFTER `wr_datetime` ", FALSE);
}


echo "database upgrade complete";

?>