- _@csdkZdkZdkZdkZdkZdkZ dkZ dkT  dZdZ dZ 2dZ 7dZ DdZ GdZKd Z\d Zefeeid jogd GHheid nieieidZjeeidj o kedGHleid nmeiedZned Zpe Zrx:re e o(sdGHteidue ZqWwedZxedZyedZzedZ|ei eeeeZ!~xdoze Z"de"dZ#e!i$e#e!i%Z&e&i'd Z(ee(d j o de"dGdGeie)Z*e*djp e*djodZ#e!i$e#e!i%Z+e+i'd Z,dGHxFe-d ee,D],Z.de/e.dd e,e.d GHq3WdGHn(e*d!jp e*d"jo q!nnPq!Wd#e"Z0d$e"Z1d%e0d&GHd'e0Z#ye!i$e#Wne2j o nXd(e0d)Z#e!i$e#d*e0d&GHei3ed+Z4e4i5Z5e5i6xe5D]Z7eie7dZ8ei9eie8dd,d-Z:e:d.j o qnd/e0d0eie8d d1Z#ye!i$e#Wne2j o nXqWe4i;d2e0d&GHei3ed+Z4e4i5Z5e5i6xe5D]Z7eie7dZ8ei9eie8dd,d-Z:e:d3jo d4Z:nd5e0d6e:d7ee4e7d8eie8d Z#ye!i$e#Wne2j o nXqWe4i;d9e"d:Z#e!i$e#d;e"d<Z#e!i$e#d=e"d>e"d?Z#e!i$e#d@Z#e!i$e#e!i%Z&e&i'd Z(e(d d Z<dAe"dBe"dBe<dBe"dCe"dDZ#e!i$e#ei=dEe dFe"ei=dGe dHe dFe"ei=dGe dIe dFe"ei=dJe dFe"dKei=dJe dFe"dLei=dJe dMe"dNei=dOe dMe"dNei=dOe dFe"ei=dOe dFe"dPei=dOe dFe"dQdRe"dCe"dSZ#e!i$e#dTe0dUZ#e!i$e#e!i%Z&e&i'd Z(dVGHxe-d ee(D]Z.e(e.d Z>e(e.d Z?dWZ@dWZAe(e.dXZBe(e.dYZCe(e.d dZ d[e(e.d dZd\!d[e(e.d d\d]!ZDe(e.dZEe(e.d^ZFe(e.dZZGe(e.d_ZHd`ZId/e1dae>dbe?dbe@dbeAdbeeBdbeeCdbeDdbeEdbeeFdbeGdbeHdbeIdbe>dce/e.d1Z#e!i$e#q_ WddGHdeGHdTe0dfZ#e!i$e#e!i%Z&e&i'd Z(x-e-d ee(D]Z.e(e.d Z>dgZ@dgZAe(e.dXZBe(e.dYZCe(e.d dZ d[e(e.d dZd\!d[e(e.d d\d]!ZDe(e.dZEe(e.d^ZFe(e.dZZGe(e.d_ZHd`ZIe(e.dhZJdie1djeJdkZ#e!i$e#e!i%Z+e+i'd Z, y e,d Z?Wn eKj o  nX d/e1dae>dbe?d dbe@dbeAdbeeBdbeeCdbeDdbeEdbeeFdbeGdbeHdbeIdbe>dce/e.d1Z#e!i$e#qi WdlGHdmGHdne1doe1dpe1dqe0dre1dse0dte0duZ#e!i$e#e!i%Z&e&i'd Z(xe-d ee(D]Z.e(e.dZ?dve0dwe?dxZ#e!i$e#e!i%Z+e+i'd Z,xse-d ee,D]YZLd5e1dyedgeLdzedgeLd{e,eLd dZ#e!i$e#qWq!W d|GH"#d}GH$d~e0dZ#%e!i$e#&e!i%Z&'e&i'd Z((xve-d ee(D(]\Z.)de1de(e.d dZ#*e!i$e#+e!i%Z+,e+i'd Z,-ee,d jo -qpn.e,d d Z@/dve0dwe(e.d dZ#0e!i$e#1e!i%Z+2e+i'd Z,3x{e-d ee,D3]aZL4d5e1dyee@dWeLdzee@dWeLd{e,eLd dZ#5e!i$e#qgWqpW6dGH89eeidjoeiMiNeoh:y':ei=dede dWn;e2j o ;nX<de0dZ#=e!i$e#>e!i%Z&?e&i'd Z(@xe-d ee(D@]Z.Aeie(e.d Z>Beie(e.dZOCeOd,jo CqnDde"dbe>de/eOdbeOdkZ#Ee!i$e#Fd5e1de>dZ#Ge!i$e#qWnIJd'e0Z#Ke!i$e#MNdede"dGHOdGHPe!i;dS(N(s*csy ti|djo dSnti|d}t|djo dSnd|d}|SdS(NsNoness/isdata/i(sstringsstripsassplitsbslensfile(sasfilesb((scrazy.pysfile_mod s  csOti}ti|d}d|dd|d}|SdS(Ns/ii(sossgetcwdsasstringssplitsbsfile(sasbsfile((scrazy.pys document_rootscstiddGHhdd<dd<dd<dd<}dG tit}!|djo "d }n#||d<%d G&tit}'||d<)titid }*||d<,d G-tit}.d GH/||d<0|SdS(NsclearsA - ũ带 ƻ Խ Űִ α׷Դϴ. -sshostsuserspasswdsdbnames6 ͺ̽ ȣƮ ԷϽʽÿ. [localhost] : s localhosts5 ͺ̽ ̵ ԷϽʽÿ. ) mydomain : sS ͺ̽ ȣ ԷϽʽÿ. ԷϽ ȣ ʽϴ. ) hgd1234 : s0 ͺ̽ ԷϽʽÿ. ) mydomain : s ( sosssystemstsstringsstrips raw_inputshostsusersgetpassspasswdsdbname(shostsuserspasswdsdbnamest((scrazy.pys get_dbinfos$-     cs*23dG4tit}5|SdS(Ns? ƻ Խ ԷϽʽÿ. ) notice : (sstringsstrips raw_inputscode(scode((scrazy.pysgetCode2scs78t}9|d}:|d};|d}<|d}=y,>ti||||}?|i Wn@t j oAt }nXB|SdS(Nshostsuserspasswdsdbname( sTruesisOKstshostsuserspasswdsdbnames_mysqlsconnectsdbscloses ExceptionsFalse(stspasswdsisOKsdbshostsdbnamesuser((scrazy.pys test_connect7s     csDEti|ddSdS(Ns's\'(sstringsreplacesstr(sstr((scrazy.pysreplace_escapeDscs8GHtit|dd}Itt|SdS(Ns\'s'(sstringsreplacesstrstsreplace_escape(st((scrazy.pysstr_inGscs KLti|}M|t|d}Nti}Oxptdt|DO]V}P|||jo<QyR||d}WnSt j o TnXUPnqQWVd}Wx5tdt|dDW]}X|||}qWY||}Z|SdS(Niis( sstringsstripssslenslast_csascii_uppercaseslistsrangesisnext_cs IndexErrorsbuffer(sssisbufferslast_cslistsnext_c((scrazy.pys makedepthKs"      cs\]ti|}^ti}_d}`x5tdt|dD`]}a|||}qGWb|||}c|SdS(Nsii( sstringsstripsssascii_uppercaseslistsbuffersrangeslensisnum(sssnumsisbufferslist((scrazy.pys makedepth2\s   isIŰܿ ũ ϸ ԷϽʽÿ. )python crazy.pyc board.gdbmiis.s/ ʽϴ. ٽ ȮϽñ ٶϴ.sI ˼մϴ. ԷϽ ߸ Ǿϴ . Ȯ ٽ ԷϽʽÿ.shostsuserspasswdsdbnames4select alias from ASADAL_BOARD_ADMIN where alias = 's's s% ̹ ϴ Խ Դϴ.s2 ̹ Խ ðڽϱ?(y/n) sysYs$select alias from ASADAL_BOARD_ADMINsU -----------------------------------------------------------------------------------s s. Խ : snsNstbl_crazy2asapro_s ASADAL_BOARD_s create table s....s drop table s create table s8 ( num int unsigned not null auto_increment, access int, date varchar(20), domain varchar(100), email varchar(100), filename varchar(100), filesize varchar(100), ip varchar(100), nlines int, name varchar(100), password varchar(100), subject varchar(100), text text, thread int, primary key(num), index (thread));s make primary keys in srsssAccesss insert into s (num) values (s)s update sLinessnlinessupdate s set s = 's' where num = screate 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,'','')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+ where trim(thread) = '0' order by num descs STEP 1 ....sAi i is-iii is1st (pkid, fmlid, parent, parentcp, writer, subject, date, count, contents, email, ip, visible, pageUID, gmt) values ('s', 's', unix_timestamp() - s STEP 1 .... END.s STEP 2 ....s' where trim(thread) != '0' order by numsAAi sselect fmlid from s where trim(pkid) = trim('s')s STEP 2 .... END.s STEP 3 ....sselect s.pkid as pkid, s.fmlid as fmlid from s, s where s .fmlid = s.thread group by s.threadsselect num from s where thread = 's' order by nums set parent = 's', parentcp = 's' where pkid = 's STEP 3 .... END.s STEP 4 ....sselect thread, num from s/ where thread != 0 group by thread order by numsselect parent from s where pkid = 's STEP 4 .... END.scp -R s/* s/asapro/board/datasselect num, filename from s where trim(filename) != ''sginsert into ASADAL_BOARD_FILE (register_dt, boardName, pkid, filePath, fileInfomation) values (now(), 's ', 'data/s" set fileFlag = '1' where pkid = 's ũ Խ s ƻ sԽ Űϴs ϷǾϴ. մϴ.(Psosssyssstringstimesgetpasssgdbms_mysqlstypessfile_mods document_roots get_dbinfosgetCodes test_connectsreplace_escapesstr_ins makedepths makedepth2slensargvsexitsstripscrazyslistdirssplitscrazy_gcs crazy_dirsinfossleeps host_namesusr_namespasswdsdb_namesconnectsdbsaliasssqlsquerys store_resultsresults fetch_rowsrows raw_inputsshowCodesresult_tsrow_tsrangesisstrstbl_crazy2asaprostblname_asapros Exceptionsopensgdbskeysssortskeystempsreplacesfsclosesseqssystemspkidsfmlidsparentsparentcpswriterssubjectsdatescountscontentssemailsipsvisiblesthreads IndexErrorsjspathsisdirsfilename(8scrazyswritersseqsipsjsreplace_escapesresult_tsgetpasss_mysqlsgdbsusr_namesresultsgdbms makedepth2scontentssrows get_dbinfoskeyss makedepthsfile_mods crazy_dirsfilenamesshowCodes test_connectsemails document_rootscrazy_gcscountsgetCodesstringsparentspkidspasswdssubjectsdbsfmlidssyssparentcpsstr_instblname_asaproskeyssqlsdatestbl_crazy2asaprosinfosrow_tsthreadstempsfsisvisiblesaliassdb_names host_namestimesos((scrazy.pys?s                          *       % &    % <   1**######   C    C A  C ! ! K,'  /