마카로닉스

1877 No

카테고리 목록

2022-07-28 17:56:38 By 라이트 0 1237 댓글수 4 포스트 하기

11월 2024
일	월	화	수	목	금	토
					1	2
3	4	5	6	7	8	9
10	11	12	13	14	15	16
17	18	19	20	21	22	23
24	25	26	27	28	29	30

유저 생성

INSERT INTO GATHERHERE79.G5_MEMBER 
(MB_ID,MB_PASSWORD,MB_NAME,MB_NICK,MB_NICK_DATE,MB_EMAIL,MB_HOMEPAGE,MB_LEVEL,MB_SEX,MB_BIRTH,MB_TEL,MB_HP,MB_CERTIFY,MB_ADULT,MB_DUPINFO,MB_ZIP1,MB_ZIP2,MB_ADDR1,MB_ADDR2,MB_ADDR3,MB_ADDR_JIBEON,MB_SIGNATURE,MB_RECOMMEND,MB_POINT,MB_TODAY_LOGIN,MB_LOGIN_IP,MB_DATETIME,MB_IP,MB_LEAVE_DATE,MB_INTERCEPT_DATE,MB_EMAIL_CERTIFY,MB_EMAIL_CERTIFY2,MB_MEMO,MB_LOST_CERTIFY,MB_MAILLING,MB_SMS,MB_OPEN,MB_OPEN_DATE,MB_PROFILE,MB_MEMO_CALL,MB_MEMO_CNT,MB_SCRAP_CNT,MB_1,MB_2,MB_3,MB_4,MB_5,MB_6,MB_7,MB_8,MB_9,MB_10) VALUES	
	 ('fmkorea','sha256:12000:s1oCTFHv4srx/e6wzR0oGV9D6a6kx1/M:ctiwBSFU775CRv1zpwzqHcLIlfbFYX8L','에펨코리아','에펨코리아','2022-07-29','fmkorea@macaronics.net','',9,'','','','','1',1,'','','','','','','','','',1021,'2022-07-29 01:15:11','127.0.0.1','2022-07-29 01:15:11','185.54.229.35','','','2022-07-29 01:15:11','','','',1,0,1,'2022-07-29','','',0,0,'','','','','','','','','','');

게시판 그룹생성

ALTER TABLE g5_group MODIFY COLUMN gr_id varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' NOT NULL;

INSERT INTO G5_GROUP (GR_ID,GR_SUBJECT,GR_DEVICE,GR_ADMIN,GR_USE_ACCESS,GR_ORDER,GR_1_SUBJ,GR_2_SUBJ,GR_3_SUBJ,GR_4_SUBJ,GR_5_SUBJ,GR_6_SUBJ,GR_7_SUBJ,GR_8_SUBJ,GR_9_SUBJ,GR_10_SUBJ,GR_1,GR_2,GR_3,GR_4,GR_5,GR_6,GR_7,GR_8,GR_9,GR_10) VALUES
('information','정보/이슈/유머','both','',0,0,'','','','','','','','','','','','','','','','','','','','');

INSERT INTO G5_GROUP (GR_ID,GR_SUBJECT,GR_DEVICE,GR_ADMIN,GR_USE_ACCESS,GR_ORDER,GR_1_SUBJ,GR_2_SUBJ,GR_3_SUBJ,GR_4_SUBJ,GR_5_SUBJ,GR_6_SUBJ,GR_7_SUBJ,GR_8_SUBJ,GR_9_SUBJ,GR_10_SUBJ,GR_1,GR_2,GR_3,GR_4,GR_5,GR_6,GR_7,GR_8,GR_9,GR_10) VALUES
('beauty','뷰티/패션/운동','both','',0,0,'','','','','','','','','','','','','','','','','','','','');

INSERT INTO G5_GROUP (GR_ID,GR_SUBJECT,GR_DEVICE,GR_ADMIN,GR_USE_ACCESS,GR_ORDER,GR_1_SUBJ,GR_2_SUBJ,GR_3_SUBJ,GR_4_SUBJ,GR_5_SUBJ,GR_6_SUBJ,GR_7_SUBJ,GR_8_SUBJ,GR_9_SUBJ,GR_10_SUBJ,GR_1,GR_2,GR_3,GR_4,GR_5,GR_6,GR_7,GR_8,GR_9,GR_10) VALUES
('sports','스포츠','both','',0,0,'','','','','','','','','','','','','','','','','','','','');

INSERT INTO G5_GROUP (GR_ID,GR_SUBJECT,GR_DEVICE,GR_ADMIN,GR_USE_ACCESS,GR_ORDER,GR_1_SUBJ,GR_2_SUBJ,GR_3_SUBJ,GR_4_SUBJ,GR_5_SUBJ,GR_6_SUBJ,GR_7_SUBJ,GR_8_SUBJ,GR_9_SUBJ,GR_10_SUBJ,GR_1,GR_2,GR_3,GR_4,GR_5,GR_6,GR_7,GR_8,GR_9,GR_10) VALUES
('education','교육/금융/IT','both','',0,0,'','','','','','','','','','','','','','','','','','','','');

INSERT INTO G5_GROUP (GR_ID,GR_SUBJECT,GR_DEVICE,GR_ADMIN,GR_USE_ACCESS,GR_ORDER,GR_1_SUBJ,GR_2_SUBJ,GR_3_SUBJ,GR_4_SUBJ,GR_5_SUBJ,GR_6_SUBJ,GR_7_SUBJ,GR_8_SUBJ,GR_9_SUBJ,GR_10_SUBJ,GR_1,GR_2,GR_3,GR_4,GR_5,GR_6,GR_7,GR_8,GR_9,GR_10) VALUES
('broadcast','영화/방송/만화','both','',0,0,'','','','','','','','','','','','','','','','','','','','');

INSERT INTO G5_GROUP (GR_ID,GR_SUBJECT,GR_DEVICE,GR_ADMIN,GR_USE_ACCESS,GR_ORDER,GR_1_SUBJ,GR_2_SUBJ,GR_3_SUBJ,GR_4_SUBJ,GR_5_SUBJ,GR_6_SUBJ,GR_7_SUBJ,GR_8_SUBJ,GR_9_SUBJ,GR_10_SUBJ,GR_1,GR_2,GR_3,GR_4,GR_5,GR_6,GR_7,GR_8,GR_9,GR_10) VALUES
('games','게임','both','',0,0,'','','','','','','','','','','','','','','','','','','','');


INSERT INTO G5_GROUP (GR_ID,GR_SUBJECT,GR_DEVICE,GR_ADMIN,GR_USE_ACCESS,GR_ORDER,GR_1_SUBJ,GR_2_SUBJ,GR_3_SUBJ,GR_4_SUBJ,GR_5_SUBJ,GR_6_SUBJ,GR_7_SUBJ,GR_8_SUBJ,GR_9_SUBJ,GR_10_SUBJ,GR_1,GR_2,GR_3,GR_4,GR_5,GR_6,GR_7,GR_8,GR_9,GR_10) VALUES
('gallery','갤러리','both','',0,0,'','','','','','','','','','','','','','','','','','','','');

INSERT INTO G5_GROUP (GR_ID,GR_SUBJECT,GR_DEVICE,GR_ADMIN,GR_USE_ACCESS,GR_ORDER,GR_1_SUBJ,GR_2_SUBJ,GR_3_SUBJ,GR_4_SUBJ,GR_5_SUBJ,GR_6_SUBJ,GR_7_SUBJ,GR_8_SUBJ,GR_9_SUBJ,GR_10_SUBJ,GR_1,GR_2,GR_3,GR_4,GR_5,GR_6,GR_7,GR_8,GR_9,GR_10) VALUES
('general','일반','both','',0,0,'','','','','','','','','','','','','','','','','','','','');

게시판 생성

<?php 

error_reporting(E_ALL);
ini_set("display_errors", 1);
include_once ("../common.php");

include_once ("./CrawlingBoard.php");

$sql="
INSERT INTO G5_BOARD (BO_TABLE,GR_ID,BO_SUBJECT,BO_MOBILE_SUBJECT,BO_DEVICE,BO_ADMIN,BO_LIST_LEVEL,BO_READ_LEVEL,BO_WRITE_LEVEL,BO_REPLY_LEVEL,BO_COMMENT_LEVEL,BO_UPLOAD_LEVEL,BO_DOWNLOAD_LEVEL,BO_HTML_LEVEL,BO_LINK_LEVEL,BO_COUNT_DELETE,BO_COUNT_MODIFY,BO_READ_POINT,BO_WRITE_POINT,BO_COMMENT_POINT,BO_DOWNLOAD_POINT,BO_USE_CATEGORY,BO_CATEGORY_LIST,BO_USE_SIDEVIEW,BO_USE_FILE_CONTENT,BO_USE_SECRET,BO_USE_DHTML_EDITOR,BO_SELECT_EDITOR,BO_USE_RSS_VIEW,BO_USE_GOOD,BO_USE_NOGOOD,BO_USE_NAME,BO_USE_SIGNATURE,BO_USE_IP_VIEW,BO_USE_LIST_VIEW,BO_USE_LIST_FILE,BO_USE_LIST_CONTENT,BO_TABLE_WIDTH,BO_SUBJECT_LEN,BO_MOBILE_SUBJECT_LEN,BO_PAGE_ROWS,BO_MOBILE_PAGE_ROWS,BO_NEW,BO_HOT,BO_IMAGE_WIDTH,BO_SKIN,BO_MOBILE_SKIN,BO_INCLUDE_HEAD,BO_INCLUDE_TAIL,BO_CONTENT_HEAD,BO_MOBILE_CONTENT_HEAD,BO_CONTENT_TAIL,BO_MOBILE_CONTENT_TAIL,BO_INSERT_CONTENT,BO_GALLERY_COLS,BO_GALLERY_WIDTH,BO_GALLERY_HEIGHT,BO_MOBILE_GALLERY_WIDTH,BO_MOBILE_GALLERY_HEIGHT,BO_UPLOAD_SIZE,BO_REPLY_ORDER,BO_USE_SEARCH,BO_ORDER,BO_COUNT_WRITE,BO_COUNT_COMMENT,BO_WRITE_MIN,BO_WRITE_MAX,BO_COMMENT_MIN,BO_COMMENT_MAX,BO_NOTICE,BO_UPLOAD_COUNT,BO_USE_EMAIL,BO_USE_CERT,BO_USE_SNS,BO_USE_CAPTCHA,BO_SORT_FIELD,BO_1_SUBJ,BO_2_SUBJ,BO_3_SUBJ,BO_4_SUBJ,BO_5_SUBJ,BO_6_SUBJ,BO_7_SUBJ,BO_8_SUBJ,BO_9_SUBJ,BO_10_SUBJ,BO_1,BO_2,BO_3,BO_4,BO_5,BO_6,BO_7,BO_8,BO_9,BO_10) VALUES
('humor','information','유머','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('issue','information','이슈','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('politics','information','정치','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('affairs','information','시사','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('mystery','information','미스터리/공포','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('computer','information','디지털/컴퓨터','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),

('beauty','beauty','뷰티','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('fashion','beauty','패션','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('diet','beauty','다이어트','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('molding','beauty','성형','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('exercise','beauty','운동','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('health','beauty','건강','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),

('soccer','sports','축구','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('baseball','sports','야구','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('basketball','sports','농구','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('othersports','sports','기타스포츠','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),


('education','education','교육','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('stock','education','금융/주식','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('it','education','IT','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('virtualcurrency','education','가상화폐','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('realestate','education','부동산','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('freeshopping','education','자유쇼핑','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),


('boadcasting','broadcast','인터넷방송','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('drama','broadcast','드라마TV','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('movie','broadcast','영화TV','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('youtube','broadcast','유튜브','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('comic','broadcast','웹툰/웹소설/만화','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),


('starcraft','games','스타크래프트','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('maple','games','메이플','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('battleground','games','배틀그라운드','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('blizzard','games','블리자드','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('lineage','games','리니지','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('mobilegame','games','모바일게임','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('othergames','games','기타게임','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),


('counseling','community','연애상담','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('car','community','자동차','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('work','community','직장/알바/사업','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('study','community','공부','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('hobbies','community','취미/생활','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('inquiry','community','문의/신고','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('notice','community','공지','','both','',1,1,2,2,2,2,2,2,2,1,1,0,5,1,0,0,'',0,0,0,1,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'theme/gallery','theme/gallery','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,2,0,0,0,0,0,'',1,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('qa','community','질문답변','','both','',1,1,2,2,2,1,2,2,1,1,1,0,5,1,-20,0,'',0,0,0,0,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'basic','basic','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,0,0,0,0,0,0,'',2,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('free','community','자유게시판','','both','',1,1,2,2,2,1,2,2,1,1,1,0,5,1,-20,0,'',0,0,0,0,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'basic','basic','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,0,0,0,0,0,0,'',2,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),

('travel','gallery','여행/음식/생물','','both','',1,1,2,2,2,1,2,2,1,1,1,0,5,1,-20,0,'',0,0,0,0,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'basic','basic','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,0,0,0,0,0,0,'',2,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('entertainer','gallery','연예인','','both','',1,1,2,2,2,1,2,2,1,1,1,0,5,1,-20,0,'',0,0,0,0,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'basic','basic','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,0,0,0,0,0,0,'',2,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('idols','gallery','아이돌','','both','',1,1,2,2,2,1,2,2,1,1,1,0,5,1,-20,0,'',0,0,0,0,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'basic','basic','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,0,0,0,0,0,0,'',2,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('animal','gallery','동물/식물','','both','',1,1,2,2,2,1,2,2,1,1,1,0,5,1,-20,0,'',0,0,0,0,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'basic','basic','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,0,0,0,0,0,0,'',2,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),

('news','general','뉴스','','both','',1,1,2,2,2,1,2,2,1,1,1,0,5,1,-20,0,'',0,0,0,0,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'basic','basic','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,0,0,0,0,0,0,'',2,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('fishing','general','낚시','','both','',1,1,2,2,2,1,2,2,1,1,1,0,5,1,-20,0,'',0,0,0,0,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'basic','basic','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,0,0,0,0,0,0,'',2,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('cooking','general','요리','','both','',1,1,2,2,2,1,2,2,1,1,1,0,5,1,-20,0,'',0,0,0,0,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'basic','basic','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,0,0,0,0,0,0,'',2,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('books','general','도서','','both','',1,1,2,2,2,1,2,2,1,1,1,0,5,1,-20,0,'',0,0,0,0,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'basic','basic','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,0,0,0,0,0,0,'',2,0,'',0,0,'','','','','','','','','','','','','','','','','','','','',''),
('music','general','음악','','both','',1,1,2,2,2,1,2,2,1,1,1,0,5,1,-20,0,'',0,0,0,0,'',1,1,1,0,0,0,0,0,0,100,60,30,15,15,24,100,835,'basic','basic','_head.php','_tail.php','','','','','',4,202,150,125,100,1048576,1,0,0,0,0,0,0,0,0,'',2,0,'',0,0,'','','','','','','','','','','','','','','','','','','','','');
"; 

   sql_query($sql);
    
   $engBoardTable =[
                'humor','issue','politics','affairs','mystery','computer', 
                'beauty','fashion','diet','molding','exercise','health',
                'soccer','baseball','basketball','othersports',
                'education','stock','it','virtualcurrency','realestate','freeshopping',
                'boadcasting','drama','movie','youtube','comic',
                'starcraft','maple','battleground','blizzard','lineage','mobilegame','othergames',
                'counseling','car','work','study','hobbies','inquiry','notice','qa','free',
                'travel','entertainer','idols','animal',
                'news','fishing','cooking','books','music'             
                ];
       
   for($i=0; $i<count($engBoardTable); $i++){
       //echo   $creatTable[$i];
       createBoardTable($engBoardTable[$i]);
   };
   

   
?>

1.정보/이슈/유머 information -------------------- (humor/issue/information)
1)유머(humor)
2)이슈(issue)
3)정치(politics)
4)시사(current affairs)
5)미스터리/공포 mystery ------(mystery) horror)
6)디지털/컴퓨터 -computer ----------(digital/computer)

2.뷰티/패션/운동 - beauty (beauty/fashion/workout)
1)뷰티 (beauty)
2)패션 (fashion)
3)다이어트 (diet)
4)성형 (molding)
5)운동 (exercise)
6)건강 (health)

3.스포츠 (sports)
1)축구 (soccer)
2)야구 (baseball)
3)농구 (basketball)
4)기타스포츠 (othersports)

4.교육/금융/IT education - (education/finance/it)
1)교육 (education)
2)금융/주식 stock - (finance/stock)
3)IT (it)
4)가상화폐 (virtual currency)
5)부동산 (realestate)
6)자유쇼핑 (freeshopping)

5.영화/방송/만화 broadcast - (movie/broadcast/comic)
1)인터넷방송 (boadcasting)
2)드라마TV (drama)
3)영화TV (movie )
4)유튜브( youtube)
5)웹툰/웹소설/만화 comic -- (webtoon/web novel/comic)

6.게임 (games)
1)스타크래프트 (starcraft)
2)메이플 (maple)
3)배틀그라운드 (battleground)
4)블리자드 (blizzard)
5)리니지 (lineage)
6)모바일게임 (mobileGame)
7)기타게임 (otherGames)

7.커뮤니티 (community)
1)연애상담 (counseling)
2)자동차 (car)
3)직장/알바/사업 work (work/part-time/business)
4)공부 (study)
5)취미/생활 hobbies (hobbies--------/life)
6)문의/신고 inquiry (inquiry/report)
7)공지 (notice)

8.갤러리 (gallery)
1)여행/음식/생물 travel - (travel / food / creatures)
2)연예인 entertainer --- (celebrities)
3)아이돌 Idols group - (girl group)
4)동물/식물 animal ----------(animal/plant)

9.일반 (general)
1)뉴스 (news)
2)낚시 (fishing)
3)자동차 (car)
4)요리 (cooking)
5)도서 (books)
6)음악 (music)
7)잡담/자유 free chat/freedom)

게시판 보드 생성
1. humor/issue/information
1) humor/issue
2) politics / current affairs
3) mystery/horror
4) digital/computer

2.beauty/fashion/workout
1) beauty
2) fashion
3) diet
4) molding
5) exercise/health

3.sports
1) soccer
2) baseball
3) basketball
4) other sports

4.education/finance/it
1) education
2) finance/stock
3) it
4) virtual currency
5) real estate
6) free shopping

5.movie/broadcast/comic
1) internet broadcasting
2) afreeca tv
3) movie tv
4) vertube
5) webtoon/web novel/comic

6. games
1) starcraft
2) maple
3) battleground
4)blizzard
5) mobile game
6) other games

7.community
1) romance counseling
2) car
3) work/part-time/business
4) study
5) hobbies/life
6) inquiry/report
7) notice

8.gallery
1) travel / food / creatures
2) celebrities
3) odeok training center
4) girl group
5) animal/plant

9. general
1) news
2) fishing
3) car
4) cooking
5) books
6) music
7) chat/freedom

사는얘기

카테고리 목록

PHRASE

Level 60 라이트

댓글 ( 4)

댓글 남기기

Categories

사는얘기 Recent List more

Tags Widget

Welcome

사는얘기 목록 more

11월 2024
일	월	화	수	목	금	토
					1	2
3	4	5	6	7	8	9
10	11	12	13	14	15	16
17	18	19	20	21	22	23
24	25	26	27	28	29	30

11월 2024
일	월	화	수	목	금	토
					1	2
3	4	5	6	7	8	9
10	11	12	13	14	15	16
17	18	19	20	21	22	23
24	25	26	27	28	29	30

11월 2024
일	월	화	수	목	금	토
					1	2
3	4	5	6	7	8	9
10	11	12	13	14	15	16
17	18	19	20	21	22	23
24	25	26	27	28	29	30