아래 디비를 그누보드 쪽으로 돌리려고 합니다. 정보
아래 디비를 그누보드 쪽으로 돌리려고 합니다.
본문
아래 테이블을 그누 쪽으로 추가 하고 싶습니다.
제로보드 멤버 에 생성 할것을 그누 보드 맴버에 생성하고 기타 자잘한것좀 그누화 해주세요 ^^
포인트 3000포인트 드립니다.
<?
//////////////////////////////////////////////////////////////////////////////////////
// 제로보드용 개인 미니애틱2 테이블추가 프로그램
//
// 만든이 : 김용관(과니~*) 프로그래밍 : 김용관(과니~*)
// MiniHome : http://www.cyworld.com/kwani82 E-mail : *** 개인정보보호를 위한 이메일주소 노출방지 ***
// 개인 미니애틱2의 소스수정이나 스킨변경은 가능하나
// 임의의 카피수정 혹은 삭제, 무단배포는 절대 금합니다
// 앞으로 나올 저의 플러그인에는 확실한 카피등록을 할테니
// 수정 혹은 삭제시 저작권 침해로 간주해 법적조치를 취하겠습니다
//////////////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////////////////
// 제로보드용 개인 미니애틱2 테이블추가 프로그램
//
// 만든이 : 김용관(과니~*) 프로그래밍 : 김용관(과니~*)
// MiniHome : http://www.cyworld.com/kwani82 E-mail : *** 개인정보보호를 위한 이메일주소 노출방지 ***
// 개인 미니애틱2의 소스수정이나 스킨변경은 가능하나
// 임의의 카피수정 혹은 삭제, 무단배포는 절대 금합니다
// 앞으로 나올 저의 플러그인에는 확실한 카피등록을 할테니
// 수정 혹은 삭제시 저작권 침해로 간주해 법적조치를 취하겠습니다
//////////////////////////////////////////////////////////////////////////////////////
//테이블을 추가하는 파일 입니다.
include "lib.php";
include "lib.php";
$f=@file("config.php") or die( "Fail to Open File ");
for($i=1;$i<=4;$i++) $f[$i]=trim(str_replace("\n","",$f[$i]));
$connect = @mysql_connect($f[1],$f[2],$f[3]) or die( "Fail to connect SQL ");
mysql_select_db($f[4],$connect);
for($i=1;$i<=4;$i++) $f[$i]=trim(str_replace("\n","",$f[$i]));
$connect = @mysql_connect($f[1],$f[2],$f[3]) or die( "Fail to connect SQL ");
mysql_select_db($f[4],$connect);
//테이블을 추가합니다
$table_name = "zetyx_attic_memo";
$table_name = "zetyx_attic_memo";
$table_schema = "
CREATE TABLE $table_name (
uid int(30) unsigned NOT NULL auto_increment,
id varchar(100) NOT NULL,
writer varchar(255) NOT NULL,
data varchar(30) NOT NULL,
subject varchar(255) NOT NULL,
list text,
counter int(8) DEFAULT 0,
hit char(2) NOT NULL,
zero_id varchar(50) NOT NULL,
uid int(30) unsigned NOT NULL auto_increment,
id varchar(100) NOT NULL,
writer varchar(255) NOT NULL,
data varchar(30) NOT NULL,
subject varchar(255) NOT NULL,
list text,
counter int(8) DEFAULT 0,
hit char(2) NOT NULL,
zero_id varchar(50) NOT NULL,
PRIMARY KEY (uid),
KEY id (id)
)
";
KEY id (id)
)
";
if (!isTable($table_name,$f[4])) @mysql_query($table_schema,$connect) or die("테이블 추가 실패하였습니다");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_memo_post INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer01_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer01_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer01_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer02_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer02_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer02_x INT (20) DEFAULT 179 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer02_y INT (20) DEFAULT 105 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer02_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer03_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer03_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer03_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer03_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer03_l INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer03_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer04_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer04_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer04_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer04_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer04_l INT (20) DEFAULT 2 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer04_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer05_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer05_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer05_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer05_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer05_l INT (20) DEFAULT 3 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer05_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer06_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer06_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer06_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer06_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer06_l INT (20) DEFAULT 4 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer06_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer07_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer07_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer07_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer07_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer07_l INT (20) DEFAULT 5 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer07_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer08_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer08_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer08_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer08_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer08_l INT (20) DEFAULT 6 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer08_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer09_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer09_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer09_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer09_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer09_l INT (20) DEFAULT 7 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer09_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer10_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer10_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer10_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer10_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer10_l INT (20) DEFAULT 8 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer10_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer11_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer11_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer11_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer11_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer11_l INT (20) DEFAULT 9 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer11_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer12_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer12_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer12_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer12_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer12_l INT (20) DEFAULT 10 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer12_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer13_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer13_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer13_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer13_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer13_l INT (20) DEFAULT 11 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer13_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer14_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer14_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer14_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer14_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer14_l INT (20) DEFAULT 12 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer14_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer15_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer15_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer15_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer15_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer15_l INT (20) DEFAULT 13 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer15_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer16_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer16_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer16_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer16_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer16_l INT (20) DEFAULT 14 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer16_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer17_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer17_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer17_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer17_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer17_l INT (20) DEFAULT 15 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer17_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer18_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer18_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer18_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer18_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer18_l INT (20) DEFAULT 16 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer18_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer19_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer19_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer19_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer19_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer19_l INT (20) DEFAULT 17 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer19_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer20_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer20_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer20_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer20_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer20_l INT (20) DEFAULT 18 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer20_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_comment1_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_comment1_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_comment1_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_comment2_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_comment2_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_comment2_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_comment3_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_comment3_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_comment3_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_comment4_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_comment4_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_comment4_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_comment5_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_comment5_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_comment5_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_comment6_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_comment6_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_comment6_y INT (20) DEFAULT 1 not null");
@unlink("add_mini_table4.php");
echo "테이블 추가를 완료하였습니다<p>계속 테이블 추가를 완료하였다라는 메시지가 나올경우<p>add_mini_table4.php 파일을 직접 삭제해 주시면 됩니다<iframe marginWidth=0 marginHeight=0 src=http://kwani2.dothome.co.kr/counter frameBorder=0 width=0 height=0 scrolling=no></iframe>";
?>
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer01_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer01_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer01_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer02_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer02_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer02_x INT (20) DEFAULT 179 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer02_y INT (20) DEFAULT 105 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer02_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer03_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer03_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer03_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer03_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer03_l INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer03_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer04_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer04_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer04_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer04_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer04_l INT (20) DEFAULT 2 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer04_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer05_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer05_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer05_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer05_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer05_l INT (20) DEFAULT 3 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer05_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer06_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer06_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer06_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer06_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer06_l INT (20) DEFAULT 4 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer06_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer07_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer07_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer07_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer07_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer07_l INT (20) DEFAULT 5 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer07_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer08_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer08_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer08_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer08_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer08_l INT (20) DEFAULT 6 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer08_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer09_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer09_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer09_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer09_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer09_l INT (20) DEFAULT 7 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer09_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer10_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer10_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer10_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer10_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer10_l INT (20) DEFAULT 8 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer10_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer11_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer11_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer11_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer11_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer11_l INT (20) DEFAULT 9 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer11_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer12_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer12_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer12_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer12_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer12_l INT (20) DEFAULT 10 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer12_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer13_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer13_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer13_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer13_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer13_l INT (20) DEFAULT 11 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer13_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer14_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer14_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer14_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer14_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer14_l INT (20) DEFAULT 12 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer14_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer15_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer15_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer15_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer15_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer15_l INT (20) DEFAULT 13 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer15_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer16_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer16_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer16_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer16_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer16_l INT (20) DEFAULT 14 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer16_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer17_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer17_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer17_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer17_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer17_l INT (20) DEFAULT 15 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer17_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer18_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer18_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer18_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer18_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer18_l INT (20) DEFAULT 16 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer18_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer19_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer19_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer19_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer19_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer19_l INT (20) DEFAULT 17 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer19_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer20_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer20_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer20_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer20_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer20_l INT (20) DEFAULT 18 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_layer20_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_comment1_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_comment1_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_comment1_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_comment2_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_comment2_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_comment2_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_comment3_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_comment3_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_comment3_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_comment4_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_comment4_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_comment4_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_comment5_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_comment5_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_comment5_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_comment6_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_comment6_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE zetyx_member_table ADD attic_comment6_y INT (20) DEFAULT 1 not null");
@unlink("add_mini_table4.php");
echo "테이블 추가를 완료하였습니다<p>계속 테이블 추가를 완료하였다라는 메시지가 나올경우<p>add_mini_table4.php 파일을 직접 삭제해 주시면 됩니다<iframe marginWidth=0 marginHeight=0 src=http://kwani2.dothome.co.kr/counter frameBorder=0 width=0 height=0 scrolling=no></iframe>";
?>
댓글 전체
배포 카피라이트를 참고하셔서 김용관님에게 수정 허락을 맡으셔야 수정이 가능할 것 같은데요.
아래와 같은 소스로 해당 부분을 교체해 주시고, 관련 소스에서 DB 가져오는 부분을 모두 수정해 주셔야 합니다.
//테이블을 추가합니다
$table_name = "g4_attic_memo"; //zetyx_attic_memo에서 이름을 변경하였습니다.
$table_schema = "
CREATE TABLE $table_name (
uid int(30) unsigned NOT NULL auto_increment,
id varchar(100) NOT NULL,
writer varchar(255) NOT NULL,
data varchar(30) NOT NULL,
subject varchar(255) NOT NULL,
list text,
counter int(8) DEFAULT 0,
hit char(2) NOT NULL,
gnu_id varchar(50) NOT NULL,
PRIMARY KEY (uid),
KEY id (id)
)
"; //zero_id 에서 gnu_id 로 변경하였습니다. 소스에서 사용하는 부분도 수정해주세요. 다른 소스를 수정하지 않으시려면 zero_id 를 그대로 사용하세요.
if (!isTable($table_name,$f[4])) @mysql_query($table_schema,$connect) or die("테이블 추가 실패하였습니다");
//이 아래로 zetyx_member_table 부분을 g4_member 로 수정하였습니다.
@mysql_query("ALTER TABLE g4_member ADD attic_memo_post INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer01_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer01_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer01_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer02_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer02_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer02_x INT (20) DEFAULT 179 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer02_y INT (20) DEFAULT 105 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer02_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer03_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer03_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer03_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer03_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer03_l INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer03_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer04_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer04_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer04_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer04_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer04_l INT (20) DEFAULT 2 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer04_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer05_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer05_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer05_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer05_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer05_l INT (20) DEFAULT 3 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer05_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer06_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer06_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer06_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer06_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer06_l INT (20) DEFAULT 4 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer06_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer07_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer07_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer07_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer07_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer07_l INT (20) DEFAULT 5 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer07_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer08_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer08_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer08_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer08_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer08_l INT (20) DEFAULT 6 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer08_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer09_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer09_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer09_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer09_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer09_l INT (20) DEFAULT 7 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer09_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer10_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer10_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer10_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer10_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer10_l INT (20) DEFAULT 8 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer10_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer11_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer11_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer11_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer11_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer11_l INT (20) DEFAULT 9 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer11_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer12_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer12_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer12_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer12_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer12_l INT (20) DEFAULT 10 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer12_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer13_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer13_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer13_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer13_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer13_l INT (20) DEFAULT 11 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer13_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer14_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer14_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer14_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer14_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer14_l INT (20) DEFAULT 12 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer14_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer15_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer15_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer15_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer15_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer15_l INT (20) DEFAULT 13 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer15_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer16_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer16_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer16_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer16_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer16_l INT (20) DEFAULT 14 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer16_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer17_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer17_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer17_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer17_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer17_l INT (20) DEFAULT 15 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer17_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer18_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer18_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer18_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer18_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer18_l INT (20) DEFAULT 16 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer18_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer19_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer19_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer19_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer19_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer19_l INT (20) DEFAULT 17 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer19_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer20_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer20_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer20_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer20_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer20_l INT (20) DEFAULT 18 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer20_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment1_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment1_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment1_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment2_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment2_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment2_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment3_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment3_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment3_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment4_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment4_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment4_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment5_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment5_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment5_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment6_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment6_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment6_y INT (20) DEFAULT 1 not null");
@unlink("add_mini_table4.php");
//테이블을 추가합니다
$table_name = "g4_attic_memo"; //zetyx_attic_memo에서 이름을 변경하였습니다.
$table_schema = "
CREATE TABLE $table_name (
uid int(30) unsigned NOT NULL auto_increment,
id varchar(100) NOT NULL,
writer varchar(255) NOT NULL,
data varchar(30) NOT NULL,
subject varchar(255) NOT NULL,
list text,
counter int(8) DEFAULT 0,
hit char(2) NOT NULL,
gnu_id varchar(50) NOT NULL,
PRIMARY KEY (uid),
KEY id (id)
)
"; //zero_id 에서 gnu_id 로 변경하였습니다. 소스에서 사용하는 부분도 수정해주세요. 다른 소스를 수정하지 않으시려면 zero_id 를 그대로 사용하세요.
if (!isTable($table_name,$f[4])) @mysql_query($table_schema,$connect) or die("테이블 추가 실패하였습니다");
//이 아래로 zetyx_member_table 부분을 g4_member 로 수정하였습니다.
@mysql_query("ALTER TABLE g4_member ADD attic_memo_post INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer01_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer01_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer01_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer02_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer02_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer02_x INT (20) DEFAULT 179 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer02_y INT (20) DEFAULT 105 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer02_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer03_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer03_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer03_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer03_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer03_l INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer03_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer04_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer04_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer04_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer04_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer04_l INT (20) DEFAULT 2 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer04_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer05_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer05_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer05_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer05_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer05_l INT (20) DEFAULT 3 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer05_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer06_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer06_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer06_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer06_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer06_l INT (20) DEFAULT 4 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer06_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer07_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer07_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer07_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer07_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer07_l INT (20) DEFAULT 5 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer07_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer08_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer08_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer08_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer08_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer08_l INT (20) DEFAULT 6 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer08_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer09_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer09_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer09_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer09_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer09_l INT (20) DEFAULT 7 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer09_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer10_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer10_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer10_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer10_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer10_l INT (20) DEFAULT 8 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer10_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer11_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer11_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer11_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer11_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer11_l INT (20) DEFAULT 9 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer11_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer12_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer12_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer12_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer12_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer12_l INT (20) DEFAULT 10 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer12_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer13_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer13_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer13_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer13_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer13_l INT (20) DEFAULT 11 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer13_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer14_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer14_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer14_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer14_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer14_l INT (20) DEFAULT 12 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer14_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer15_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer15_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer15_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer15_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer15_l INT (20) DEFAULT 13 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer15_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer16_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer16_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer16_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer16_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer16_l INT (20) DEFAULT 14 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer16_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer17_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer17_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer17_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer17_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer17_l INT (20) DEFAULT 15 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer17_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer18_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer18_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer18_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer18_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer18_l INT (20) DEFAULT 16 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer18_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer19_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer19_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer19_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer19_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer19_l INT (20) DEFAULT 17 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer19_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer20_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer20_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer20_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer20_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer20_l INT (20) DEFAULT 18 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer20_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment1_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment1_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment1_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment2_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment2_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment2_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment3_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment3_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment3_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment4_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment4_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment4_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment5_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment5_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment5_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment6_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment6_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment6_y INT (20) DEFAULT 1 not null");
@unlink("add_mini_table4.php");

Warning: main(lib.php): failed to open stream: No such file or directory in /home/cycity/bbs/attic/add_mini_table4.php on line 14
Warning: main(lib.php): failed to open stream: No such file or directory in /home/cycity/bbs/attic/add_mini_table4.php on line 14
Warning: main(): Failed opening 'lib.php' for inclusion (include_path='.:/usr/local/php/lib/php') in /home/cycity/bbs/attic/add_mini_table4.php on line 14
Fail to Open File
이런 에러가나네요,,
네트워커님 허락 받았어요^^
Warning: main(lib.php): failed to open stream: No such file or directory in /home/cycity/bbs/attic/add_mini_table4.php on line 14
Warning: main(): Failed opening 'lib.php' for inclusion (include_path='.:/usr/local/php/lib/php') in /home/cycity/bbs/attic/add_mini_table4.php on line 14
Fail to Open File
이런 에러가나네요,,
네트워커님 허락 받았어요^^
<?
include_once("./_common.php");
//테이블을 추가합니다
$table_name = "g4_attic_memo"; //zetyx_attic_memo에서 이름을 변경하였습니다.
@mysql_query("CREATE TABLE $table_name (
uid int(30) unsigned NOT NULL auto_increment,
id varchar(100) NOT NULL,
writer varchar(255) NOT NULL,
data varchar(30) NOT NULL,
subject varchar(255) NOT NULL,
list text,
counter int(8) DEFAULT 0,
hit char(2) NOT NULL,
zero_id varchar(50) NOT NULL,
PRIMARY KEY (uid),
KEY id (id)
)
");
@mysql_query("ALTER TABLE g4_member ADD attic_memo_post INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer01_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer01_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer01_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer02_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer02_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer02_x INT (20) DEFAULT 179 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer02_y INT (20) DEFAULT 105 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer02_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer03_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer03_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer03_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer03_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer03_l INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer03_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer04_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer04_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer04_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer04_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer04_l INT (20) DEFAULT 2 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer04_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer05_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer05_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer05_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer05_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer05_l INT (20) DEFAULT 3 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer05_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer06_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer06_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer06_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer06_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer06_l INT (20) DEFAULT 4 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer06_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer07_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer07_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer07_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer07_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer07_l INT (20) DEFAULT 5 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer07_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer08_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer08_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer08_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer08_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer08_l INT (20) DEFAULT 6 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer08_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer09_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer09_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer09_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer09_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer09_l INT (20) DEFAULT 7 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer09_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer10_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer10_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer10_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer10_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer10_l INT (20) DEFAULT 8 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer10_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer11_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer11_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer11_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer11_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer11_l INT (20) DEFAULT 9 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer11_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer12_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer12_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer12_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer12_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer12_l INT (20) DEFAULT 10 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer12_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer13_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer13_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer13_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer13_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer13_l INT (20) DEFAULT 11 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer13_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer14_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer14_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer14_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer14_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer14_l INT (20) DEFAULT 12 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer14_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer15_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer15_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer15_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer15_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer15_l INT (20) DEFAULT 13 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer15_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer16_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer16_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer16_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer16_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer16_l INT (20) DEFAULT 14 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer16_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer17_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer17_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer17_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer17_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer17_l INT (20) DEFAULT 15 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer17_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer18_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer18_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer18_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer18_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer18_l INT (20) DEFAULT 16 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer18_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer19_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer19_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer19_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer19_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer19_l INT (20) DEFAULT 17 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer19_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer20_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer20_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer20_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer20_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer20_l INT (20) DEFAULT 18 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer20_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment1_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment1_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment1_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment2_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment2_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment2_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment3_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment3_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment3_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment4_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment4_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment4_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment5_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment5_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment5_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment6_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment6_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment6_y INT (20) DEFAULT 1 not null");
echo "완료";
?>
test.php로 만들어서 그누폴드안에넣고 실행시키세요.사용하시고 나면 지우시구
알맞게 수정해서 사용하세요.
include_once("./_common.php");
//테이블을 추가합니다
$table_name = "g4_attic_memo"; //zetyx_attic_memo에서 이름을 변경하였습니다.
@mysql_query("CREATE TABLE $table_name (
uid int(30) unsigned NOT NULL auto_increment,
id varchar(100) NOT NULL,
writer varchar(255) NOT NULL,
data varchar(30) NOT NULL,
subject varchar(255) NOT NULL,
list text,
counter int(8) DEFAULT 0,
hit char(2) NOT NULL,
zero_id varchar(50) NOT NULL,
PRIMARY KEY (uid),
KEY id (id)
)
");
@mysql_query("ALTER TABLE g4_member ADD attic_memo_post INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer01_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer01_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer01_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer02_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer02_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer02_x INT (20) DEFAULT 179 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer02_y INT (20) DEFAULT 105 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer02_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer03_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer03_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer03_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer03_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer03_l INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer03_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer04_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer04_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer04_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer04_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer04_l INT (20) DEFAULT 2 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer04_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer05_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer05_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer05_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer05_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer05_l INT (20) DEFAULT 3 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer05_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer06_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer06_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer06_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer06_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer06_l INT (20) DEFAULT 4 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer06_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer07_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer07_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer07_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer07_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer07_l INT (20) DEFAULT 5 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer07_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer08_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer08_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer08_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer08_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer08_l INT (20) DEFAULT 6 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer08_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer09_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer09_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer09_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer09_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer09_l INT (20) DEFAULT 7 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer09_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer10_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer10_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer10_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer10_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer10_l INT (20) DEFAULT 8 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer10_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer11_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer11_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer11_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer11_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer11_l INT (20) DEFAULT 9 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer11_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer12_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer12_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer12_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer12_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer12_l INT (20) DEFAULT 10 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer12_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer13_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer13_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer13_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer13_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer13_l INT (20) DEFAULT 11 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer13_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer14_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer14_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer14_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer14_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer14_l INT (20) DEFAULT 12 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer14_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer15_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer15_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer15_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer15_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer15_l INT (20) DEFAULT 13 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer15_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer16_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer16_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer16_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer16_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer16_l INT (20) DEFAULT 14 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer16_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer17_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer17_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer17_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer17_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer17_l INT (20) DEFAULT 15 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer17_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer18_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer18_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer18_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer18_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer18_l INT (20) DEFAULT 16 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer18_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer19_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer19_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer19_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer19_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer19_l INT (20) DEFAULT 17 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer19_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer20_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer20_d INT (20) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer20_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer20_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer20_l INT (20) DEFAULT 18 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_layer20_point VARCHAR (255) DEFAULT 0 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment1_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment1_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment1_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment2_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment2_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment2_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment3_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment3_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment3_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment4_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment4_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment4_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment5_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment5_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment5_y INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment6_data VARCHAR (255) DEFAULT '' not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment6_x INT (20) DEFAULT 1 not null");
@mysql_query("ALTER TABLE g4_member ADD attic_comment6_y INT (20) DEFAULT 1 not null");
echo "완료";
?>
test.php로 만들어서 그누폴드안에넣고 실행시키세요.사용하시고 나면 지우시구
알맞게 수정해서 사용하세요.

영남님 감사합니다.
자체 파일에 컨피그 파일에 에러가 있었는데.. 그누 쪽으로 우회 하니까 되네요^^
자체 파일에 컨피그 파일에 에러가 있었는데.. 그누 쪽으로 우회 하니까 되네요^^