-í ‰ŸdAcsCdkZdkZdkZdkZdkZdkZ d„Zd„Z-/eƒZ1x:1eeƒ o(2dGH3ei dƒ4eƒZquW6edZ 7edZ 8edZ 9edZ ;y.<eie e e e ƒZ=eiƒZWn>ej o ?nXABd ZCeieƒDeiƒZEeid ƒZFeeƒZHIx¥ed eƒDI]‘ZRSeed d jo Td Zn Vd ZXYeeddjo Zd Zn \d Z^deed deeddeeddeeddeeddeeddedeeddeeddeeddeeddeeddeeddeeddeeddeeddeed deed!deed"deed#deed$deed%ded&eed'd(eed)deed*deed+deed,deed-deed.deed/d0Z_y`eieƒabd1ZceieƒdeiƒZeeid ƒZ fe d d Z!gd2Z"hd3Z#ie"Z$jeed4djo ke#Z$nld5e!d6e$d7Z%neie%ƒopd8eed d9Z&qeie&ƒreiƒZ'se'id ƒZ(tee(ƒZ)uxñed e)ƒDu]ÝZ*vd:e!d;eed de(e*d de(e*dde(e*dde(e*dde(e*dde(e*dde(e*dde(e*dd0Z+wyxeie+ƒWnyej o zq"nXq"WWn{ej o |q’nXq’W}ei,ƒ~d<GHdS(=Ncs  tidƒ dGH hdd<dd<dd<dd<} dGtitƒƒ}|djo d }n||d<d Gtitƒƒ}||d<titid ƒƒ}||d<d Gtitƒƒ}||d<|SdS( NsclearsV - ¾Æ»ç¸â¹öÀÇ È¸¿øµ¥ÀÌÅ͸¦ ¾Æ»çÇÁ·ÎÀÇ È¸¿ø°ü¸®ÇÁ·Î±×·¥À¸·Î ¿Å°ÜÁÖ´Â ÇÁ·Î±×·¥ÀÔ´Ï´Ù. -sshostsuserspasswdsdbnames6 µ¥ÀÌÅͺ£À̽º È£½ºÆ®¸íÀ» ÀÔ·ÂÇϽʽÿÀ. [localhost] : s localhosts5 µ¥ÀÌÅͺ£À̽º ¾ÆÀ̵𸦠ÀÔ·ÂÇϽʽÿÀ. ¿¹) mydomain : sS µ¥ÀÌÅͺ£À̽º ¾ÏÈ£¸¦ ÀÔ·ÂÇϽʽÿÀ. ÀÔ·ÂÇϽŠ¾ÏÈ£´Â º¸ÀÌÁö ¾Ê½À´Ï´Ù. ¿¹) hgd1234 : s0 µ¥ÀÌÅͺ£À̽º¸íÀ» ÀÔ·ÂÇϽʽÿÀ. ¿¹) mydomain : ( sosssystemstsstringsstrips raw_inputshostsusersgetpassspasswdsdbname(shostsuserspasswdsdbnamest((s ./memberdb.pys get_dbinfo s"-     csœ t}!|d}"|d}#|d}$|d}&y,'ti||||ƒ}(|i ƒWn)t j o*t }nX+|SdS(Nshostsuserspasswdsdbname( sTruesisOKstshostsuserspasswdsdbnames_mysqlsconnectsdbscloses ExceptionsFalse(stspasswdsisOKsdbshostsdbnamesuser((s ./memberdb.pys test_connects     sI Á˼ÛÇÕ´Ï´Ù. ÀÔ·ÂÇϽŠÁ¤º¸°¡ À߸ø µÇ¾ú½À´Ï´Ù . Á¤È®È÷ ´Ù½Ã ÀÔ·ÂÇϽʽÿÀ.ishostsuserspasswdsdbnamesËselect userID, userPW, ifnull(email,'') as email, ifnull(name,'') as name, ifnull(sNO,'') as sNO, ifnull(birthday,'') as birthday, ifnull(gender,'') as gender, ifnull(homeZipCode,'') as homeZipCode, ifnull(homeAdrs,'') as homeAdrs, ifnull(companyZipCode,'') as companyZipCode, ifnull(companyName,'') as companyName, ifnull(companyAdrs,'') as companyAdrs, ifnull(companyDept,'') as companyDept, ifnull(homeTel,'') as homeTel, ifnull(companyTel,'') as companyTel, ifnull(hp,'') as hp, ifnull(fax,'') as fax, ifnull(job,'') as job, ifnull(education,'') as education, ifnull(income,'') as income, ifnull(wedding,'') as wedding, ifnull(hobby,'') as hobby, ifnull(mailFrom,'') as mailFrom, ifnull(rgstDate,'') as rgstDate, ifnull(lastLogTime,'') as lastLogTime, ifnull(udf01,'') as udf01, ifnull(udf02,'') as udf02, ifnull(udf03,'') as udf03, ifnull(visible,'') as visible, ifnull(sunlu,'') as sunlu, ifnull(mileage,'') as mileage,ifnull(level,'') as level from asa_memberDatumiis1s0is2s/insert into ASADAL_MEMBER_MEMBER(id, pw, email, name, jumin, birthday, sex, zipcode, addr1, comzipcode, company, comaddr1, post, home_tel, office_tel, phone, fax, job, education, income, wedding, hobby, mail_chk, level, reg_date, last_login, udf01, udf02 ,udf03, visible, birthday_type,mileage) values('s', 's' ,'iiiiiii i i i i iiiiiiiis', '0', unix_timestamp('is'), 'iiiiiiis')s.select max(num) as n from ASADAL_MEMBER_MEMBERs10::24::27::34::13s10::24::27::34::14isWinsert into ASADAL_MEMBER_SOLUTIONAUTH (num, kind, kindCode, auth, community) values ('s ', 'auth', 's ', '1', 'n')siselect name, service, service_contents, mileage, type, status, refer, regdate from mileage_log where id='s'sinsert into ASADAL_MEMBER_MILEAGE_LOG(Mkey, id, name, service, service_contents, mileage, type, status, refer, regdate) values(s, 's" ȸ¿øÀÌ ¼º°øÀûÀ¸·Î ¿Å°ÜÁ³½À´Ï´Ù.(-s_mysqlsstringsgetpassssyssosstimes get_dbinfos test_connectsinfossleepshostsuserspasswdsdbnamesconnectsdbscursorscurs Exceptionssqlsquerys store_resultsresults fetch_rowsrowslensnRowssrangesis member_mails member_sexssql2srow_maxs member_numsmember1smember2s member_levelssql3ssql4sresult4srow4snRows4sjssql5sclose(#ssql3sstringssql4spasswds member_sexssql2s member_mailsdbssql5ssyss_mysqlshostsmember1sresultssqlsrow_maxsdbnamesrowsinfosgetpasss get_dbinfosrow4scursisjsnRows4s member_numsnRowss member_levelstimesmember2s test_connectsossresult4suser((s ./memberdb.pys?s’               ÿê      ¡