- @cs6dkZdkZdkZdkZdkZdkZdkT  dZdZdZ /dZ =dZ @dZ DJKe Z Mx:Me e  o(NdGHOeid Pe Z qWQe d ZRe d ZSe d ZTe d ZVgZWgZXgZYgZ[eieeeeZ]dZ^eie_eiZ`eidZaxhede eDa]NZ!bei"ee!dcei"ee!d dei"ee!dqWmnx ede eDn] Z!oee!Z#pdZqeiereiZseidZtx8ede eDt]Z$uei"ee$dqWwe#ejo`xdZ%yxMye&oBze#e'e%Z#{e#ejo|e%d Z%}qnPqWnde#dZeiede#dZeiede#de#dZeiedZeieeiZeidZeddZ(de#de#de(de#de#dZeieei)dede#ei)d ed!ede#ei)d ed"ede#ei)d#ede#d$ei)d#ede#d%ei)d#ed&e#d'ei)d(ed&e#d'ei)d(ede#ei)d(ede#d)ei)d(ede#d*d+e#de#d,Zeied-ee!ZeieeiZeidZe edjo&d.ee!d/e#d0GHq#nxmede eD]SZ*d1e#d2e ee*dd3e ee*d d3e ee*dd3e ee*d4d3e ee*d5d3e ee*d6d3e ee*d7d3e ee*d8d3e ee*d9d3e ee*d:d3e ee*d;d3e ee*d<d3e ee*d=d3e ee*d>d3ee ee*d?d3e ee*d@d3e ee*dAd3e ee*dBd3e ee*dCd3e ee*dDd3e ee*dEd3e ee*dFd3e ee*dGd3e ee*dHd3e ee*dIdJZeieq<WdKee!ZeieeiZeidZe+Z,edddLjo e&Z,nydMee!ZeieeiZeidZe edjoxede eD]Z-dNe#dOe ee-dde ee-d d3e ee-dde ee-d4de ee-d5dJZeieq} WnWndPee!ZeieeiZeidZe edjoxede eD]Z-dNe#dQe ee-dde ee-d d3e ee-dde ee-d4dJZeieq WnnXdRe#dSZeiedTee!dUZeieeiZeidZe edjoxede eD]Z-dVe ee-d de ee-dd3e ee-d4d3e ee-d5d3e ee-d6d3e ee-d7d3e ee-d8d3e ee-d9d3e ee-d:d3e#dJZeieq WndWee!dUZeieeiZeidZe edjoxede eD]Z-dXe ee-d d3e#d3e ee-d4d3ee ee-d5d3e ee-d6dJZeieq) Wnd.ee!dYe#d0GHq#Wei.ei)dZed[ed\ei)d(ed]d^GHdS(_N(s*csy  ti|djo  dSn ti|d}t|djo dSnd|d}|SdS(NsNoness/isdata/i(sstringsstripsassplitsbslensfile(sasfilesb((s boarddb.pysfile_mod s  csOti}ti|d}d|dd|d}|SdS(Ns/ii(sossgetcwdsasstringssplitsbsfile(sasbsfile((s boarddb.pys document_rootscstiddGHhdd<dd<dd<dd<}dGtit}|djo d }n ||d<"d G#tit}$||d<&titid }'||d<)d G*tit}+d GH,||d<-|SdS(NsclearsH - ƻ纸 ͸ ƻ Խ Űִ α׷Դϴ. -sshostsuserspasswdsdbnames6 ͺ̽ ȣƮ ԷϽʽÿ. [localhost] : s localhosts5 ͺ̽ ̵ ԷϽʽÿ. ) mydomain : sS ͺ̽ ȣ ԷϽʽÿ. ԷϽ ȣ ʽϴ. ) hgd1234 : s0 ͺ̽ ԷϽʽÿ. ) mydomain : s ( sosssystemstsstringsstrips raw_inputshostsusersgetpassspasswdsdbname(shostsuserspasswdsdbnamest((s boarddb.pys get_dbinfos$-     cs/0t}1|d}2|d}3|d}4|d}6y,7ti||||}8|i Wn9t j o:t }nX;|SdS(Nshostsuserspasswdsdbname( sTruesisOKstshostsuserspasswdsdbnames_mysqlsconnectsdbscloses ExceptionsFalse(stspasswdsisOKsdbshostsdbnamesuser((s boarddb.pys test_connect/s     cs=>ti|ddSdS(Ns's\'(sstringsreplacesstr(sstr((s boarddb.pysreplace_escape=scs8@Atit|dd}Btt|SdS(Ns\'s'(sstringsreplacesstrstsreplace_escape(st((s boarddb.pysstr_in@ssI ˼մϴ. ԷϽ ߸ Ǿϴ . Ȯ ٽ ԷϽʽÿ.ishostsuserspasswdsdbnames@select alias, boardName, memoName from boardAdmin order by aliasiis3select alias from ASADAL_BOARD_ADMIN order by aliasscreate table ASADAL_BOARD_s< ( pkid int(11) NOT NULL auto_increment, fmlid int(5) NOT NULL default '0', parent varchar(50) NOT NULL default '', parentcp varchar(50) NOT NULL default '', writer varchar(100) NOT NULL default '', member_num varchar(32) default '0', subject varchar(100) NOT NULL default '', date date NOT NULL default '0000-00-00', count int(5) NOT NULL default '0', reCount int(5) NOT NULL default '0', contents text, email varchar(50) default NULL, pw varchar(100) default NULL, fileFlag int(1) default NULL, fileHost varchar(50) default '', filePath varchar(100) default NULL, level int(2) default NULL, ip varchar(50) NOT NULL default '', visible int(1) NOT NULL default '0', pageUID varchar(100) NOT NULL default '', time varchar(10) NOT NULL default '', gmt varchar(50) NOT NULL default '', asadal varchar(100) default NULL, whisper int(1) NOT NULL default '0', userHtml tinyint(1) NOT NULL default '0', category int(11) NOT NULL default '0', asadal2 varchar(100) default NULL, asadal3 varchar(100) default NULL, PRIMARY KEY (pkid), UNIQUE KEY pageUID (pageUID), KEY count (count), KEY reCount (reCount), KEY writer (writer), KEY subject (subject), KEY pkid (pkid), KEY parent (parent), KEY parentcp (parentcp), KEY pageUID_2 (pageUID), KEY gmt (gmt), KEY ip (ip), KEY fmlid (fmlid), KEY category (category))screate table ASADAL_BOARD_MEMO_s (pk int(11) NOT NULL auto_increment, fk varchar(50) default '', pw varchar(100) NOT NULL default '', writer varchar(50) NOT NULL default '', member_num varchar(32) default NULL, date datetime NOT NULL default '0000-00-00 00:00:00', memo varchar(255) NOT NULL default '', code varchar(50) NOT NULL default '', marks char(2) default '', recom char(2) default '', ip varchar(50) NOT NULL default '', id varchar(20) NOT NULL default '', PRIMARY KEY (pk), KEY memo_fk (fk), KEY memo_code (code))sinsert into ASADAL_AUTH_MENU(level, parent, child, title, name, info, root_seq, auto, link, yes_use, yes_show, ranking, img, img_over) values (2,5,0,'s','⺻','s',5,1,'',1,1,99,NULL,NULL)s,select max(seq) as seq from ASADAL_AUTH_MENUsinsert into ASADAL_BOARD_ADMIN(boardName, alias, auth_seq, boardTitle, memoName, backcolor, useSkin, settingDate, modifyDate, control, control_auth, boardPos ) values ('ASADAL_BOARD_s','s','ASADAL_BOARD_MEMO_s ','',1,now(),now(),'||','||','')smkdir s/asapro/board/bn/scp s/asapro/board/bn/text.php s /asapro/board/bn/board/env2.ini stouch s /begin.htms/end.htms/asapro/board/data/counts.txts chmod 777 s /text.phps /env2.inisMinsert into ASADAL_BOARD_CFG(boardName, memoName, rowsPerAPage,nPageNvgt,fieldbgColorOfList,fieldTextColorOfList,fieldTextFontSizeOfList,fieldTextFontFmlOfList,textbgColorOfList,textColorOfList,textFontSizeOfList,textFontFmlOfList,cellpaddingOfList,borderColorOfList,heightOfList,isReply,isHOTICON,cdtOfHOTICON,isNEWICON,isFILEICON,isLineNumSorting,isWriter,isDate,isCounter,isRecommend,isNO,fieldbgColorOfWrite,fieldTextColorOfWrite,fieldTextFontSizeOfWrite,fieldTextFontFmlOfWrite,textbgColorOfWrite,textColorOfWrite,textFontSizeOfWrite,textFontFmlOfWrite,cellpaddingOfWrite,borderColorOfWrite,heightOfWrite,isHTML,isEMAIL,isFileUpLoad,fileUpLoadSize,fieldbgColorOfRead,fieldTextColorOfRead,fieldTextFontSizeOfRead,fieldTextFontFmlOfRead,textColorOfRead,textbgColorOfRead,textFontSizeOfRead,textFontFmlOfRead,cellpaddingOfRead,borderColorOfRead,heightOfRead,isRelation,borderColorOfMEMO,bgColorOfMEMO,rstIP,rstWords,header,footer,email,ip,words,emailHeader,allPageWidth,isListAll,textIndent,skinName,isBegin,isEnd,isPub,pubName,nPubs,isPubBold,whereSkin,mouseOverColor,isShowBgImage,asadal,asadalName,isAsadal,antiSpam,heightOfField,dfFontColor,dfFontSize,dfFontFamily,dfFontHeight,isCheckview,tableType,isPw_r,fileUpLoadCnt,isFileInfo,commName,isStop,newIcon,hotIcon,whisperIcon,cutIcon,ip_hide,writer_edit_not,writerType,whisper_hide,asaedit_hide,search_hide,writebox_dtext,allcount_hide,count_hide,downFiles,adminimg_hide,boardPos,isCategory,categorySelectbox,categoryPos,loginType,loginPage,sorting,sort_order,new_date,isAsadal2,asadalName2,isAsadal3,asadalName3,adminPass,tableAlign) values ('ASADAL_BOARD_sA',30,10,'#E0EAFF','#1E3565','9','gulim','#FFFFFF','#545555','9','gulim',3,'#B9CCF3',20,1,1,100,1,0,1,1,1,1,0,1,'#E0EAFF','#1E3565','9','gulim','#FFFFFF','#545555','9','gulim',3,'#B9CCF3',20,1,0,0,1,'#E0EAFF','#1E3565','9','gulim','#545555','#FFFFFF','9','gulim',3,'#B9CCF3',20,1,'','',0,0,'','','','','','','100%',1,0,'hEmbossBlue',1,1,1,'',1,1,0,'#FFFFFF',1,NULL,'',0,0,NULL,'#000000',8,'',20,0,2,0,3,0,'',0,'','','','',1,1,1,0,0,1,'',1,1,'txt/gif/doc/hwp/jpg/ppt/pdf/htm/html/php/inc',1,'',0,1,1,2,1,'number','desc',1,0,'',0,'','8af640b8bcd775b096df1e1fb64b61fc','0')sselect * from s ƻ纸 s Խ ƻ sԽ Űϴ.sinsert into ASADAL_BOARD_s (pkid, fmlid, parent, parentcp, writer, member_num, subject, date, count, reCount, contents, email, pw, fileFlag, filePath, level, ip, visible, pageUID, time, gmt, asadal, whisper, userHtml, category) values ('s', 'iiiiiii i i i i iiiiiiiiiiis')sdesc spws#select fk,writer,date,memo,pw from sinsert into ASADAL_BOARD_MEMO_s' (fk, writer, date, memo, pw) values ('s select fk,writer,date,memo from s# (fk, writer, date, memo) values ('s"insert into ASADAL_MEMO_CFG(memoName, isMEMO, textColorOfMEMO, borderColorOfMEMO, textFontSizeOfMEMO, textFontFmlOfMEMO, bgColorOfMEMO, isMarkMEMO, writerMEMO, isBadMEMO, memoOrderby, isDateMemo, writerEditMemo, memoAdminEmail, isRecomGraph, graphGood, graphBad) values ('ASADAL_BOARD_MEMO_sY', '0', '#545555', '', '9', 'gulim', '', '0', '1', '0', '0', '1', '1', '', '0', '1', '2')s*select * from asaboard_pub where alias = 's'sjinsert into ASADAL_BOARD_PUB(writer, subject, date, count, contents, email, pw, ip, time, alias) values ('s/select * from asaboard_file where boardName = 's`insert into ASADAL_BOARD_FILE (register_dt, boardName, pkid, filePath, fileInfomation) values ('sԽ ƻ scp -rf s/AsaBoard/data s/asapro/board/s/asapro/board/data/*s ϷǾϴ. մϴ.(/s_mysqlsstringsgetpassssyssosstimestypessfile_mods document_roots get_dbinfos test_connectsreplace_escapesstr_insinfossleepshostsuserspasswdsdbnames alias_pros alias_asasbn_asasmm_asasconnectsdbssqlsquerys store_resultsresults fetch_rowsrowsrangeslensisappendsaliassjsdup_cntsTruesstrsseqssystemstempsFalses new_asaboardstsclose(!sresultsjsstringsseqs new_asaboardspasswds alias_asasreplace_escapessyss_mysqlshostsstr_insuserssqlsdbnamesrowsinfosgetpasss get_dbinfostempsisbn_asasfile_mods alias_prosaliasststimesmm_asasdbs test_connectsossdup_cnts document_root((s boarddb.pys?s(                               1**######  ?    i  o  &