ÿØÿà JFIF 

  
 
  ÿÛ „ 	 ( %"1!%)+...383,7(-.+




-+++--++++---+-+-----+---------------+---+-++7-----ÿÀ  ß â
" 

ÿÄ   

           
 ÿÄ H 
     
 !1AQaq"‘¡2B±ÁÑð#R“Ò Tbr‚²á3csƒ’ÂñDS¢³$CÿÄ 
 


            
ÿÄ %

 
       
!1AQa"23‘ÿÚ 
  ? ôÿ ¨pŸªáÿ —åYõõ\?àÒü©ŠÄï¨pŸªáÿ —åYõõ\?àÓü©ŠÄá 0Ÿªáÿ Ÿå[úƒ	ú®ði~TÁb
qÐ8OÕpÿ ƒOò¤Oè`–RÂáœá™êi€ßÉ< FtŸI“öÌ8úDf´°å}“¾œ6
öFá°y¥jñÇh†ˆ¢ã/ÃÐ:ªcÈ
"Y¡ðÑl>ÿ ”ÏËte:qž\oäŠe÷󲍷˜HT4&ÿ ÓÐü6ö®¿øþßèô	Ÿ•7Ñi’•j|“ñì>b…þS?*Óôÿ ÓÐü*h¥£ír¶ü UãSç‚Ÿ[AÐaè[ûª•õ&õj?†Éö+EzP—WeÒírJFt	‘BŒ†Ï‡%#tE Øz ¥OÛ«!1›üä±Í™%º<!vB™'èÔ6´Ña¿«e`Àà0U[-ÂБ4)M÷YK*³hï÷%ÎÎkÇ«m‘-íWŽLsã?nÂ~«†üö®þ¡ÂlÃaÿ ‰ÿ l©°Õ¥ åÜá¿r ºL[Çâ°(Çè'Vãôl8´ÏRÀvLvPõ:…ÙNçF™÷ë>Íãö]°î(–:@<‹ŒÊö×òÆt¦ãº+‡¦%ÌÁ²h´OƒJŒtMÜ>ÀÜÊw3
Y´•牋4ǍýʏTì>œú=Íwhyë,¾Ôò×õ¿ßÊa»«þˆѪQ|%6ž™A	õ%:øj<>É—ÿ Å_ˆCbõ¥š±ý¯Ýƒï…¶|RëócÍf溪“t.СøTÿ *Ä¿-{†çàczůŽ_–^XþŒ±miB[X±d 1,é”zEù»&
î9gœf™9Ð'.;—™i}!ôšåîqêÛ٤ёý£½ÆA–àôe"A$˝Úsäÿ 
÷Û	#°xŸëí(l
	 »ý3—¥5m!
rt`†0~'j2(]S¦¦kv,ÚÇl¦øJA£Šƒ
J3E8ÙiŽ:cÉžúeZ°€¯\®kÖ(79«Ž:¯X”¾³Š&¡* ….‰Ž(ÜíŸ2¥ª‡×Hi²TF¤ò[¨íÈRëÉ䢍mgÑ.Ÿ<öäS0í„ǹÁU´f#Vß;Õ–…P@3ío<ä-±»Ž.L|kªÀê›fÂ6@»eu‚|ÓaÞÆŸ…¨ááå>åŠ?cKü6ùTÍÆ”†sĤÚ;H2RÚ†õ\Ö·Ÿn'¾ ñ#ºI¤Å´%çÁ­‚â7›‹qT3Iï¨Ö
Ú5I7Ë!ÅOóŸ¶øÝñØôת¦$Tcö‘[«Ö³šÒ';Aþ ¸èíg
A2Z
"i¸vdÄ÷.iõ®§)¿]¤À†–‡É&ä{V¶iŽ”.Ó×Õÿ û?h¬Mt–íª[ÿ Ñÿ ÌV(í}=ibÔ¡›¥¢±b
 Lô¥‡piη_Z<‡z§èŒ)iÖwiÇ 2hÙ3·=’d÷8éŽ1¦¸c¤µ€7›7Ø	ð\á)}	¹fËí›pAÃL%âc2 í§æQz¿;T8sæ°qø)QFMð‰XŒÂ±
N¢aF¨…8¯!U		Z©RÊ ÖPVÄÀÍin™Ì-GˆªÅËŠ›•zË}º±ŽÍFò¹}Uw×#ä5B¤{î}Ð<ÙD
é©¤&‡ïDbàÁôMÁ."
¤‡ú*õ'VŽ|¼´Úgllº¼klz[Æüï÷Aób‡Eÿ dÑ»Xx9ÃÜ£ÁT/`¼¸vI±Ýµ·Ë‚“G³þ*Ÿû´r|*}<¨îºœ @¦mÄ’M¹”.œ«Y–|6ÏU¤jç¥ÕÞqO
˜kDÆÁ¨5ÿ š;Њ¦¦€GÙk \
	–Þ=â¼=SͧµªS°ÚÍpÜãQűÀõ¬?ÃÁ1Ñ•õZà?hóœ€
L¦l{Y*K˜Ù›zc˜–ˆâø+¾	­-Ök¥%ùEÜA'}ˆ><ÊIè“bpÍ/qÞâvoX€w,\úªò6Z[XdÒæ­@Ö—€$òJí#é>'°Ú
ôª˜<)4ryÙ£|óAÅn5žêŸyÒäMÝ2{"}‰–¤l÷ûWX\l¾Á¸góÉOÔ /óñB¤f¸çñ[.P˜ZsÊË*ßT܈§QN¢’¡¨§V¼(Üù*eÕ“”5T¨‹Âê¥FŒã½Dü[8'Ò¥a…Ú¶k7a
*•›¼'Ò·\8¨ª\@\õ¢¦íq+DÙrmÎ…_ªæ»ŠÓœ¡¯’Ré9MÅ×D™lælffc+ŒÑ,ý™ÿ ¯þǤ=Å’Á7µ÷ÚÛ/“Ü
€ñýã¼àí¾ÕÑ+ƒ,uµMâÀÄbm:ÒÎPæ{˜Gz[ƒ¯«® KHà`ßØŠéí¯P8Aq.C‰ à€kòpj´kN¶qô€…Õ,ÜNŠª-­{Zö’æû44‰sŽè‰îVíRœÕm"
6?³D9¡ÇTíÅꋇ`4«¸ÝÁô ï’ýorqКÇZ«x4Žâéþuïf¹µö[P ,Q£éaX±`PÉÍZ ¸äYúgüAx
’6Lê‚xÝÓ*äQ
Ï’¨hÍ
=²,6ï#rÃ<¯–£»ƒ‹,–ê•€ aÛsñ'%Æ"®ÛüìBᝠHÚ3ß°©$“XnœÖ’î2ËTeûìxîß
¦å¿çÉ
ðK§þ{‘t‚Ϋ¬jéîZ[”š7L¥4VÚCE×]m¤Øy”ä4-dz£œ§¸x.*ã
ÊÊ b÷•h:©‡¦s`BTÁRû¾g⻩‹jø sF¢àJøFl‘È•Xᓁà~*j¯ +(ÚÕ6-£¯÷GŠØy‚<Ç’.F‹Hœw(+)ÜÜâÈzÄäT§FߘãÏ;DmVœ3Àu@mÚüXÝü•3B¨òÌÁÛ<·ÃÜz,Ì@õÅ·d2]ü8s÷IôÞ¯^Ç9¢u„~ëAŸï4«M?
K]­ÅàPl@s_ p:°¬ZR”´›JC[CS.h‹ƒïËœ«Æ]–÷ó‚wR×k7X‰k›‘´ù¦=¡«‰¨¨Â')—71ó’c‡Ðúµ
`é.{§p¹ój\Ž{1h{o±Ý=áUÊïGÖŒõ–-BÄm+AZX¶¡
ïHðæ¥JmÙ;…ä¡Ÿˆ¦ ° äšiÉg«$üMk5¤L“’çÊvïâï	,=f“"íἊ5ô¬x6{ɏžID0e¸vçmi'︧ºð9$ò¹÷*£’9ÿ ²TÔ…×>JV¥}Œ}$p[bÔ®*[jzS*8
”·T›Í–ñUîƒwo$áè=LT™ç—~ô·¤ÈÚ$榍q‰„+´kFm)ž‹©i–ËqÞŠ‰à¶ü( ‚•§ •°ò·‡#5ª•µÊ﯅¡X¨šÁ*F#TXJÊ
ušJVÍ&=iÄs1‚3•'fý§5Ñ<=[íÞ­
PÚ;ѱÌ_~Ä££8rÞ
²w;’hDT°>ÈG¬8Á²ÚzŽ®ò®qZcqJêäÞ-ö[ܘbň±çb“Š¶31²n×iƒðÕ;1¶þÉ
ªX‰,ßqÏ$>•î íZ¥Z 1{ç൵+ƒÕµ¥°T$§K]á»Ûï*·¤tMI’ÂZbŽÕiÒ˜}bÓ0£ª5›¨[5Ž^ÝœWøÂÝh°
¢OWun£¤5 a2Z.G2³YL]jåtì”
ä	ÁÓ‘%"©<ÔúÊ°sº UZvä‡ÄiÆÒM .÷V·™ø#kèýií<NçŽôª¦„lË»{ƒ®<
[¦Y‹éƒ}j•*‚±€I‡e&gbéšp9å^!®€ö?ù^àTzo@Q¨Aêœ& [”…üÔ}пF’Hq‚©´{“ëH·?.½%úå»É Á´9¿¼Ò‰Á¼Ì¥Ús¼zW¶aÃhwÖ…ÑÏ$mò´ë:×Ñγ|”x§
µ0Âз$·aÆn µ†šÇ³£‰Ì®ž
õ@kŽ«gtí䢩ÒP×5¤?µÿ m´Ì^ ‡8¸Á8‹”žÆWÑ ¡™„,Ì“»à‹ÃéV¸®á›ÐÇŽBÀ®Ã…Z”ØÛë8;é|Ñ5)7aÕ&2Ù¸÷©ö—Ð;‡¬7"¿"7M·d
ñœÒÌf5”ê ;"Ãp5¯¬3‹ùJÚÝG›½&¯<{òñKÎÖ“3:¦ÀòGPÅS¨;
à‘Ün´öpð±W)z'¬öÀÖ#Xf2& æ
Œ‹é¾"‹\!Ñ9…
0±2A›*ØMÄ $X
끫ØXÖ,X¥ ô'ËnFÍãlqJXçuaJ4¦„ëµ7ê;h"Zã¾Áä£,vÛ‹’N©E(Öu÷)…ÁaÜÇÔkˆ$‘1kmG¨øtÛ>Ì–ª)µT[)BˆõÑ
xB¾B€ÖT¨.¥~ð@VĶr#¸ü*åZNDŽH;âi 
],©£öØpù(šºãö¼T.uCê•4@ÿ GÕÛ)Cx›®0ø#:ÏðFÒbR\(€€Ä
®fã4Þ‰Fä¯HXƒÅ,†öEÑÔÜ]Öv²?tLÃvBY£ú6Êu5ÅAQ³1‘’¬x–HŒÐ‡ ^	¸KwJôÖŽ5×CÚ¨vÜ«/B0$×k°=ðbÇ(Ï)w±A†Á†	11Í=èQšµ626ŒÜ/`G«µ<}—-Ö7KEHÈÉðóȤmݱû±·ø«Snmá=“ä«šmݱŸ¡¶~ó·“äUóJæúòB|E LêŽy´jDÔ$G¢þÐñ7óR8ýÒ…Ç›	WVe#·Ÿ	p·Fx~•ݤF÷0Èÿ K¯æS<6’¡WШ
;´ÿ ¥Êø\Òuî†åÝ–VNœkÒ7oòX¨Á­Ø÷FÎÑä±g÷ÿ M~Çî=p,X´
ÝÌÚÅ‹
’ÃjÖ.ØöÏñ
qïQ¤ÓZE†° =6·]܈ s¸>v•Ž^Ý\wq9r‰Î\¸¡kURÒ$­*‹Nq?Þª*!sŠÆ:TU_u±T+øX¡
®¹¡,ÄâÃBTsÜ$Ø›4m椴zÜK]’’›Pƒ@€#â˜`é¹=I‡fiV•Ôî“nRm+µFPOhÍ0B£
€+¬5c
v•:P'ÒyÎ ‰V~‚Ó†ÖuókDoh$å\*ö%Ю=£«…aȼ½÷Û.-½VŒŠ¼'lyî±1¬3ó#ÞE¿ÔS¤gV£m›<HqÚ,sVºóÆß¼Hïô…¹…Méi‡Ò" µùEîØÏj|ÓøVOuœ"f’aÞÞëx…˜ÌO`dHHš×4K*H$‡5×
ÚÄ
Â×CUÅAŠŒsr»2°ÄÁiÚ±Çéõe•¶_SÕÆÃ3ˆ•-3´‘¸¡‡cgDîÚ¦ÃcX}'êûJè½9ñìÓ­ä±	×ÓûçÁmO”üVÞ¸÷¥ I~“ÒôhhûýÑwxlïZ¹G¡4ž=”)º£ò
®vÆŽ%UqÝ4qž©­hûÎí‡š§é1R±cÜèðà y' °ôy¦£q§Ýï¬;šÖõ„Sÿ ›  z('S†$Ï}*evÚ¾Kýº8ý
¨å	jÛ]´-‚6«¶ÖK+8ÊiS45jrœèËQDüDØ]R”˜SPÃ
xJÕl>
=§\û"—WU¤ÚǼÿ ÂnÁ
GŒÃ
‚õN	D³õNÚíŒÕ;HôyÄÈ©P¹Ä{:?R‘Ô¨âF÷ø£bÅó® JS|‚R÷ivýáâ€Æé¡è³´IئÑT!§˜•Øª‚¬â@q€wnïCWÄ@JU€ê¯m6]Ï:£âx
'+ÒðXvÓ¦Úm=–´7œ $ì“B£~p%ÕŸUþ« N@¼üï~w˜ñø5®—'Ôe»¤5ã//€ž~‰Tþ›Å7•#¤×Íö
pÄ$ùeåì*«ÓŠEØWEÈsßg¦ûvžSsLpºÊW–âµEWöˬH;™!CYõZÃÄf æ#1W.
\uWâ\,\Çfj’<qTbên›Î[vxx£ë 'ö¨1›˜ÀM¼Pÿ H)ƒêêŒA7s,|F“꺸k³9Ìö*ç®;Ö!Ö$Eiž•¹ÒÚ†ýóéÝû¾ÕS®ó$’NÝäŸz¤5r¦ãÄÃD÷Üø!°ø‡Ô&@m™Ì^Ãä­d	q5Lnÿ N;.6½·N|#ä"1Nƒx“ã<3('&ñß
t  ~ªu”1Tb㫨9ê–›–bìd$ߣ=#ÕãÒmU¯eí$EFù5ýYô櫨æ왍Ǘ±ssM]·á¿
0ÕåJRÓªîiƒ+O58ÖñªŠÒx"	\µâá¨i’¤i
—Ö
”
M+M¤ë9‚‰A¦°Qõ¾ßøK~¼Ã‘g…Ö´~÷Ï[3GUœÒ½#…kàÔ®Ò”‰³·dWV‰IP‰Ú8u¹”E
ÖqLj¾êÕCBš{A^Âß;–¨`¯¬ìö
˼	×tìø.tƐm*n¨y4o&Àx¥n¦×î‡aupáÛj8¿m›è¶ã!o½;ß0y^ý×^EÑ¿ÒjzŒ­)vÚÑnÄL
…^ªô× ‡—‚3k	Îý­hï]içå–îÏ*÷ñþ»Ô
CÒjøjÍznˆ´
¹#b'Fô‹
‰v¥'’à'T´ƒHýÍ%M‰ ƒ&ÆÇŒï1 ‘	–Þ
‰i¬s žR-Ÿ kŠ¬á¬7:þ 0ŒÅÒÕ/aÙ¬ÃÝ#Úøœ
©aiVc‰. ¹¦ãµ”
›Yg¦›ÆÎýº°f³7ƒhá·¸­}&D9¡ÂsÉÙÞèŠõØàC™¨ñbFC|´Ü(ŸƒÚÒ-%»'a	Ì¿)ËÇn¿úÿ ÞŽX…4ÊÅH^ôΑí@ù¹Eh¶“L8Çjù
¼ÎåVªóR©Ï5uÃ
V4lZß®=€xÖŸ–ÑÈ
÷”¨°¾__yM1tÉ?uÆþIkÄgæ@þ[¢†°XÃJ£j·:nkÅ¢u‘}âGzö­/IµèŠ¬¼48q¦F°ŽR¼=ûì{´¯RýicS
ÕÛ íNtÍÙï£,w4rêì®»~x(©Uñ§#Ñ&œÕ¤>ÎåÍÓ9’Ö{9eV­[Öjâ²ãu]˜å2›qÑšÕJç0€sÄ|Êëè0튔bÁ>“{×_F`Ø©ºê:µä,v¤ðfc1±"«ÔÍän1#=·
Âøv~H<Q-Ìk7Æ;•L´©ÙC°.7
¯hKL@ävÊâž$´4¸ð‚¦­R–ÂZ7ÕÃj±·¿rÓrªJ_PÕ.#g¤gÀ)©`ª<KžèÝ'ä©èÒ3rwû€Ø¦ÒƒLf¤
,¿I½{Ƕ8‘$KÝU/Oi>½ÐßA¾¿Ü€Óš]Õ; I¾÷ç‚Qi†î¹9ywÔKG˜áñ zQY—§ÃÕZ07§X‚Áh;ÁM)iÌCH-¯T‘ë|A0{Ò½LÚ–TâÖkÜ’dÀ“rmm»”جPF³ÖcbE§T€ÒxKºû’Ó®7±²(\4ŽÃ¸Uu@j™yĵ;³µ!Á¢b.W¤=mõ´êµKk
¸K^ÜÛ#p*Ü14qkZç5ïë†°5Ï%ÍÛ<Õ¤×Ô¥ê†C	Õ´¼ú$ƒÖ“”]Ù¬qÞÚ[4©ý!ûÏ—Áb쳐XµA¬â~`›Çr¸8ìùÝ䫦<>ä÷«?xs´ÇÑ	/á;¹øüÊÈÙà{"@Žïzâ¬[âß‚ U_<ÇŸ½4èN˜ú61®qŠu ¦þF£»äJ_ˆÙÎ~ ÞAã–Ý„Ï—rŠD;xTž‘ô`É«…suãO`?³à™ô
Lý#Íc5öoæØ‚y´´÷«ZR§<&JÇ+éâô´€i!Àˆ0æAoàðLèÖ-2ŸõW.’t^–(KÁmHµV@xÜÇy®Ñø­â^:Ú3w· 7½¹°ñ¸â¹®:',«Mœ—n­Á+Ãbš
LÈ‘ÄnRÓÅœ%¦²‰¨ùQ:¤f‚ "PÕtô¸…cæl…&˜Ú˜Ôkv‹ž+vŠ,=¢v­6—X
y*¥t£«<™:“aï<QÝ&Ó]i4音äzçáíHÚÕxcòãæäÝÔm퐡 `Â)C×ehÀdHP6ÅMEöZ®Í¨	é¾Tr뢘6*¶;´sÙì]ÊŽŽÛíÉwRÈ´up* Ã	‚m´:Û{·”MUë©õ̤êÔo7:ŽÕ
qÏ'E ˆk^uãT€$Ú$Æ{•ŸBP°al¾Ž©ŒÃ^}äA
,º­$Ü]ºÚ.í:‹¤ÜöXnno7X€¥BÂà ±1ã>Œºîϲ=¦6rO]XI¿Œ÷¤zÚ­›¶ 6÷”w\dü~v®ˆÌk«^m<ÿ ¢‰Õ\)ùºŽ;… lîÙÅEŠ®cѾ@vnMÏ,¼“
ñ•ŽBxðÃzãÇç%3ˆ"}Ù•Åî>
BÉú;Ò]V+P˜F_´ßé>
Øše|ï‡ÄOmFæÇ ãqÞ$/xÐx­z`ï9"œÜij‚!7.\Td…9M‡•iŽ‹¾‘50ÞŽn¥ß4ÉôO¹*í^QêËÜÇÌ8=Ž
§s‰'ÂëÙ«á%Pú[O
†ÅP¯VsŽ°.‰,kc¶ ¬A9n˜XÎ-ÞšN["¹QÕ‰ƒMýÁߺXJæÍaLj¾×Ãmã¾ãÚ uñÒþåQô¦¥
/ÄUx:‚ÍÜ’ Đ©ØÝ3V¨‰ÕnÐ6ó*óúK­«…c ¯U òhsý­jóÔj#,ímŒRµ«lbïUTŒÑ8†Ä0œÏr`ð¡¬É	Ї
ë"À²

™	6¥ f¶¢ÚoܱԷ-<Àî)†a¶ž'Ú»¨TXqØæ¶÷Y
ÄHy˜9ÈIW­YÀuMFë
ºÏ’AqÌ4·/Ú
†ô'i$øä­=Ä
Ý|öK×40è|È6p‘0§)o¥ctî§H+CA-“ xØ|ÐXŠç
l8íºð3Ø:³¤¬KX¯UÿÙ
<?php
/* ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
	Backup mySql tables
	++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
	Copyright 2006 by Richard Williamson (aka OldGuy). 
	Website: http://www.scripts.oldguy.us - noldguy@gmail.com
	Support: http://www.scripts.oldguy.us/forums/
	Licensed under the terms of the GNU General Public License, June 1991.
	++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 
*/

// basic configuration entries
$secret			= '9Yem6KQz4'; 				// a password to prevent unauthorized access to the script
$from			= 'carl.corey@kknm.sk';			// email address for the "from" header
$to				= 'carl.corey@kknm.sk';			// address to which emails will be sent
$dir			= '/sub/eshop/';	// directory where the files are to be placed
$bundle_name	= 'sql_dump_';				// date/time will be appended to the bundle name
$email			= 0;							// 0 = don't send the completion email (error emails will still be sent)
												// 1 = send email notice upon successful completion, 
$debug			= 0;							// 0 = don't print to browser, use this when executing from cron!
												// 1 = print debug information to browser
$command		= 'mysqldump';          		// The mysqldump program name. Should work as is. If you get an empty
												// backup file try entering the full path to the dump program. e.g.
												// /user/bin/mysqldump
												
// ---- array of configuration settings for databases -----

// basic configuration entries
$secret			= 'kokot'; 				// a password to prevent unauthorized access to the script
$from			= 'carl.corey@kknm.sk';			// email address for the "from" header
$to				= 'carl.corey@kknm.sk';			// address to which emails will be sent
$dir			= '/home/helsys.sk/subs/eshop/';	// directory where the files are to be placed, must have write permissions
$bundle_name	= 'sql_dump_';				// date/time will be appended to the bundle name
$email			= 0;							// 0 = don't send the completion email (error emails will still be sent)
												// 1 = send email notice upon successful completion, 
$debug			= 1;							// 0 = don't print to browser, use this when executing from cron!
												// 1 = print debug information to browser
$command		= 'mysqldump';          		// The mysqldump program name. Should work as is. If you get an empty
												// backup file try entering the full path to the dump program. e.g.
												// /user/bin/mysqldump
												
// the first database to be backed up - referred to in the user guide as"dbid=0"
$cfg[0]['dbhost']			= ':/tmp/mysql50.sock';		// your mySQL server name
$cfg[0]['dbuser']			= 'eshop_helsis_sk';		// your mySQL user name 
$cfg[0]['dbpass']			= 'eshophelsis';		// your mySQL password
$cfg[0]['dbname']			= 'eshop_helsis_sk';			// database name
$cfg[0]['dbprefix']			= '';				// empty = backup all tables in the database
												// prefix string = backup only table names beginning with the string
$cfg[0]['optimize']			= '1';				// 1 = optimize tables, 0 = don't optimize them
$cfg[0]['extended_inserts']	= '1';				// 1 = one INSERT per table (smaller file), 0 = one INSERT per row
$cfg[0]['options']			= '';				// add any additional mysqldump optons if you know what you are doing

// uncomment (remove /* and */) and edit the below entries to add another database
// you can add any number of additional databases, each will be put in a separate output file
// each will be one ID number greater...$cfg[1] dbid=1, $cfg[2] dbid=2, etc.
/*
// 2nd database
$cfg[1]['dbhost']			= '';
$cfg[1]['dbuser']			= '';
$cfg[1]['dbpass']			= '';
$cfg[1]['dbname']			= '';
$cfg[1]['dbprefix']			= '';
$cfg[1]['optimize']			= '';
$cfg[1]['extended_inserts']	= '';
$cfg[1]['options']			= '';
*/

// ---- end of configuration settings array -----
// Don't change anything after this line unless you know what you are doing

/* ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
	Dump a database to a file and send email containing download link
	++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
	mysqldump.php, version 1.3, Feb 2009
	By Richard Williamson (aka OldGuy). 
	Website: http://www.scripts.oldguy.us/mysqldump
	Email: oldguy@oldguy.us

	Licensed under the terms of the GNU General Public License, June 1991. 

	THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR 
	IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, 
	FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE 
	AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, 
	WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN 
	CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
	++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 
*/

// define end of line character
$os = strtoupper(substr(php_uname(), 0, 3));
if ($os == 'WIN') {
	define(EOL, "\r\n");
} elseif ($os == 'MAC') {
	define(EOL, "\r");
} else {
	define(EOL, "\n");
}

// manually decode query string...we use - instead of & because Cpanel cron page doesn't like & in commands
$dbid		= 9999; // a large number which will cause an error if query string argument is missing
$code		= '';
$bundle		= '';
$filename	= '';
$query = explode('-',$_SERVER['QUERY_STRING']);
for($x = 0; $x < count($query); $x++) {
	$strings =  explode('=', $query[$x]);
	if ($strings[0] == 'dbid') {
		$dbid = $strings[1];
	} elseif ($strings[0] == 'code') {
		$code = $strings[1];
	} elseif ($strings[0] == 'bundle') {
		$bundle = $strings[1];
	} elseif ($strings[0] == 'filename') {
		$filename = $strings[1];
	} else {
		$msg = "Invalid argument '$strings[0]' in the query string: ?{$_SERVER['QUERY_STRING']}";
		if ($debug) print "$msg<br />";
		sendEmail(1, $msg  . EOL);
	}
}

// shorter variables names means less typing :-)
$dbhost 	= $cfg[$dbid]['dbhost'];
$dbuser 	= $cfg[$dbid]['dbuser'];
$dbpass 	= $cfg[$dbid]['dbpass'];
$dbname 	= $cfg[$dbid]['dbname'];
$dbprefix	= $cfg[$dbid]['dbprefix'];
$optimize 	= $cfg[$dbid]['optimize'];
$inserts 	= $cfg[$dbid]['extended_inserts'];
$options 	= $cfg[$dbid]['options'];

// are we downloading a file?
if ($filename) {
	// secret code is not required, the file name is dynamically generated and thus relatively secure
	downloadFile($filename);
	exit();
}

if ($code != $secret) {
	$msg = "Invalid code in the query string: ?{$_SERVER['QUERY_STRING']}";
	if ($debug) print "$msg<br />";
	sendEmail(1, $msg  . EOL);
}

// are we downloading a bundle?
if ($bundle) {
	sendBundle(); 
	exit();
}

if (!is_numeric($dbid) || $dbid > count($cfg) || $dbid < 0) {
	$msg = "Invalid or missing dbid argument in the query string: ?{$_SERVER['QUERY_STRING']}";
	if ($debug) print "$msg<br />";
	sendEmail(1, $msg . EOL);
}

// Mmake sure we can write the dump file
$time		= date('Ymd_His');
$dumpfile	= $dir . $dbname . '_' . $time . '.sql.gz';
if ($handle = @fopen($dumpfile, 'w')) {
	fclose($handle);
} else {
	$msg = "Unable to open '$dumpfile' for writing.". EOL;
	if ($debug) print "$msg<br />";
	sendEmail(1, $msg  . EOL);
}

// delete old backup files for the database
deleteFiles();

// Open the database
$dblink = @mysql_connect($dbhost, $dbuser, $dbpass);
if (!$dblink) {
	$msg = "Unable to connect to mysql server using the host, user and password in \$cfg[$dbid]". EOL;
	if ($debug) print "$msg<br />";
	sendEmail(1, $msg  . EOL);
}
$result = @mysql_select_db($dbname);
if (!$result) {
	$msg = "The database does not exist or the \$cfg[$dbid] user does not have permission to access it". EOL;
	if ($debug) print "$msg<br />";
	sendEmail(1, $msg  . EOL);
}

// Get table names
$rows    = 0;
$tables  = array();
$result = mysql_query("SHOW TABLES FROM $dbname ", $dblink);
if (!$result) {
	$msg = "Error doing SHOW TABLES " . mysql_error() . EOL;
	if ($debug) print "$msg<br />";
	sendEmail(1, $msg  . EOL);
}
while (list($table_name) = mysql_fetch_row($result)) {
	if ($dbprefix) {
		if (preg_match("/^$dbprefix/", $table_name)) {
			$tables[$rows] = $table_name;
			$rows++;
		}
	} else {
		$tables[$rows] = $table_name;
		$rows++;
	}
	
}

// Optimize tables, build dump command tables variable
$tables_list = '';
$msg = '';
for($i = 0; $i < $rows; $i++) {
	if ($dbprefix) $tables_list .= " {$tables[$i]}";
	if ($optimize) {
		$result	= mysql_query("OPTIMIZE TABLE {$tables[$i]}", $dblink);
		if (!$result) $msg .= "Optimize query failed. mysql error = " . mysql_error() . EOL . EOL;
	}
}

if ($msg) sendEmail(0, $msg  . EOL);
if ($debug) print "$i tables were optimized<br />";

// dump the database
$options	.= ($inserts) ? '' : ' --skip-extended-insert ';
$cmd		= "$command $options --user=$dbuser --password=$dbpass $dbname $tables_list | gzip > $dumpfile";
$last_line	= system($cmd, $result);

if ($debug) print "<p>The mysql dump command is: <br /><br /> $cmd</p>";

if ($email) sendEmail(1, "Download the dump file: http://{$_SERVER['HTTP_HOST']}{$_SERVER['PHP_SELF']}?filename=$dumpfile" . EOL);

/* ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
	Functions
	++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
*/

// download a dump file
function downloadFile($filename) {
	global $dir;
	
	$handle = @fopen($filename, 'r');
	if (!$handle) {
		sendEmail(1, "Can't open file: $filename. Download cancelled."  . EOL);
	}
	
	ob_end_clean();
  
	header("Content-type: application/force-download");
	header("Content-Disposition: attachment; filename=\"$filename\"");
	
	while(!feof($handle) and (connection_status()==0)) {
		print(fread($handle, 1024*8));
		flush();
	}
	fclose($handle);		
	if ($delete_file == 2) unlink($file);
}

// download all backup files in one archive
function sendBundle() {
	global $dir, $bundle_name, $cfg;
	
	if (!$dh = opendir($dir)) exit("Attempt to open directory $dir failed");
	
	$time				= date('Ymd-Hi');
	$bundle_name	= $bundle_name . '_' . $time . '.zip';
	$archive			= new zipfile();  
	$archive -> add_dir("mysqldump/");
	
	// for each set of configuration entries
	$files_message		= '';
	$fa = 0;
	for($x = 0; $x <= count($cfg); $x++) {
		rewinddir ($dh);
		$buffer = '';
		while (false !== ($file = readdir($dh))) {
			if (!is_dir($file) && strstr($file, $cfg[$x]['dbname'])) {
				$fh = fopen($dir . $file, 'rb');
				if (!$fh) exit("Attempt to read $file failed");
				$filesize   = sprintf("%u", filesize($dir . $file));
				$filedata   = fread($fh, $filesize);
				fclose($fh);
				$archive -> add_file($filedata, "mysqldump/$file");
				$fa++;				
			}
		}
	}
	
	if (!$fa) exit('No files to download');

	ob_end_clean();
	
	header("Content-type: application/force-download");
	header("Content-Disposition: attachment; filename=\"$bundle_name\""); 
	print $archive -> file();  

}

// send email
function sendEmail($die, $body) {
	global $from, $to, $dbname, $dbid;
	
	$headers = "From: $from" . EOL
	. "Content-Type: text/plain; charset=utf-8" . EOL 
	. "Content-Transfer-Encoding: 8bit" . EOL;
	
	ini_set('sendmail_from', $from);
	mail($to, "Message from {$_SERVER['PHP_SELF']}, dbname= '$dbname'", $body, $headers);
	if ($die) exit("Email sent");
}

function deleteFiles() {
	global $dir, $dbname;
	
	if (!$handle = @opendir($dir)) {
		$msg = "Error, can't open the files directory: '$dir'" . EOL;
		sendEmail(1, $msg  . EOL);
	} else {
		$msg = '';
		while (false !== ($del_file = readdir($handle))) {
			if (!is_dir($del_file) && preg_match("#$dbname#", $del_file)) {
				$result = unlink($dir . $del_file);
				if (!$result) {
					$msg .= "Attempt to delete $dir$del_file was unsuccessful" . EOL;
					if ($debug) $msg .= "<br />";
				} else {
					if ($debug) print "File deleted: $dir$del_file<br />";
				}
			}
		}
		
	}
	if ($msg) {
		if ($debug) print "$msg<br />";
		sendEmail(0, $msg  . EOL);
	}
}

/*
Zip file creation class
by Eric Mueller
http://www.themepark.com
initial version with:
  - class appearance
  - add_file() and file() methods
  - gzcompress() output hacking
by Denis O.Philippov, webmaster@atlant.ru, http://www.atlant.ru
official ZIP file format: http://www. // pkware.com/appnote.txt
*/

class zipfile  
{  

    var $datasec = array(); // array to store compressed data
    var $ctrl_dir = array(); // central directory   
    var $eof_ctrl_dir = "\x50\x4b\x05\x06\x00\x00\x00\x00"; //end of Central directory record
    var $old_offset = 0;

    function add_dir($name)   

    // adds "directory" to archive - do this before putting any files in directory!
    // $name - name of directory... like this: "path/"
    // ...then you can add files using add_file with names like "path/file.txt"
    {  
        $name = str_replace("\\", "/", $name);  

        $fr = "\x50\x4b\x03\x04";
        $fr .= "\x0a\x00";    // ver needed to extract
        $fr .= "\x00\x00";    // gen purpose bit flag
        $fr .= "\x00\x00";    // compression method
        $fr .= "\x00\x00\x00\x00"; // last mod time and date

        $fr .= pack("V",0); // crc32
        $fr .= pack("V",0); //compressed filesize
        $fr .= pack("V",0); //uncompressed filesize
        $fr .= pack("v", strlen($name) ); //length of pathname
        $fr .= pack("v", 0 ); //extra field length
        $fr .= $name;  
        // end of "local file header" segment

        // no "file data" segment for path

        // "data descriptor" segment (optional but necessary if archive is not served as file)
        $fr .= pack("V",$crc); //crc32
        $fr .= pack("V",$c_len); //compressed filesize
        $fr .= pack("V",$unc_len); //uncompressed filesize

        // add this entry to array
        $this -> datasec[] = $fr;

        $new_offset = strlen(implode("", $this->datasec));

        // ext. file attributes mirrors MS-DOS directory attr byte, detailed
        // at http://support.microsoft.com/support/kb/articles/Q125/0/19.asp

        // now add to central record
        $cdrec = "\x50\x4b\x01\x02";
        $cdrec .="\x00\x00";    // version made by
        $cdrec .="\x0a\x00";    // version needed to extract
        $cdrec .="\x00\x00";    // gen purpose bit flag
        $cdrec .="\x00\x00";    // compression method
        $cdrec .="\x00\x00\x00\x00"; // last mod time & date
        $cdrec .= pack("V",0); // crc32
        $cdrec .= pack("V",0); //compressed filesize
        $cdrec .= pack("V",0); //uncompressed filesize
        $cdrec .= pack("v", strlen($name) ); //length of filename
        $cdrec .= pack("v", 0 ); //extra field length   
        $cdrec .= pack("v", 0 ); //file comment length
        $cdrec .= pack("v", 0 ); //disk number start
        $cdrec .= pack("v", 0 ); //internal file attributes
        $ext = "\x00\x00\x10\x00";
        $ext = "\xff\xff\xff\xff";  
        $cdrec .= pack("V", 16 ); //external file attributes  - 'directory' bit set

        $cdrec .= pack("V", $this -> old_offset ); //relative offset of local header
        $this -> old_offset = $new_offset;

        $cdrec .= $name;  
        // optional extra field, file comment goes here
        // save to array
        $this -> ctrl_dir[] = $cdrec;  

         
    }

    function add_file($data, $name)   

    // adds "file" to archive   
    // $data - file contents
    // $name - name of file in archive. Add path if your want

    {  
        $name = str_replace("\\", "/", $name);  
        //$name = str_replace("\\", "\\\\", $name);

        $fr = "\x50\x4b\x03\x04";
        $fr .= "\x14\x00";    // ver needed to extract
        $fr .= "\x00\x00";    // gen purpose bit flag
        $fr .= "\x08\x00";    // compression method
        $fr .= "\x00\x00\x00\x00"; // last mod time and date

        $unc_len = strlen($data);  
        $crc = crc32($data);  
        // $zdata = gzcompress($data);  it is already compressed
        $zdata = substr( substr($zdata, 0, strlen($zdata) - 4), 2); // fix crc bug
        $c_len = strlen($zdata);  
        $fr .= pack("V",$crc); // crc32
        $fr .= pack("V",$c_len); //compressed filesize
        $fr .= pack("V",$unc_len); //uncompressed filesize
        $fr .= pack("v", strlen($name) ); //length of filename
        $fr .= pack("v", 0 ); //extra field length
        $fr .= $name;  
        // end of "local file header" segment
         
        // "file data" segment
        $fr .= $zdata;  

        // "data descriptor" segment (optional but necessary if archive is not served as file)
        $fr .= pack("V",$crc); //crc32
        $fr .= pack("V",$c_len); //compressed filesize
        $fr .= pack("V",$unc_len); //uncompressed filesize

        // add this entry to array
        $this -> datasec[] = $fr;

        $new_offset = strlen(implode("", $this->datasec));

        // now add to central directory record
        $cdrec = "\x50\x4b\x01\x02";
        $cdrec .="\x00\x00";    // version made by
        $cdrec .="\x14\x00";    // version needed to extract
        $cdrec .="\x00\x00";    // gen purpose bit flag
        $cdrec .="\x08\x00";    // compression method
        $cdrec .="\x00\x00\x00\x00"; // last mod time & date
        $cdrec .= pack("V",$crc); // crc32
        $cdrec .= pack("V",$c_len); //compressed filesize
        $cdrec .= pack("V",$unc_len); //uncompressed filesize
        $cdrec .= pack("v", strlen($name) ); //length of filename
        $cdrec .= pack("v", 0 ); //extra field length   
        $cdrec .= pack("v", 0 ); //file comment length
        $cdrec .= pack("v", 0 ); //disk number start
        $cdrec .= pack("v", 0 ); //internal file attributes
        $cdrec .= pack("V", 32 ); //external file attributes - 'archive' bit set

        $cdrec .= pack("V", $this -> old_offset ); //relative offset of local header
//      &n // bsp; echo "old offset is ".$this->old_offset.", new offset is $new_offset<br>";
        $this -> old_offset = $new_offset;

        $cdrec .= $name;  
        // optional extra field, file comment goes here
        // save to central directory
        $this -> ctrl_dir[] = $cdrec;  
    }

    function file() { // dump out file   
        $data = implode("", $this -> datasec);  
        $ctrldir = implode("", $this -> ctrl_dir);  

        return   
            $data.  
            $ctrldir.  
            $this -> eof_ctrl_dir.  
            pack("v", sizeof($this -> ctrl_dir)).     // total # of entries "on this disk"
            pack("v", sizeof($this -> ctrl_dir)).     // total # of entries overall
            pack("V", strlen($ctrldir)).             // size of central dir
            pack("V", strlen($data)).                 // offset to start of central dir
            "\x00\x00";                             // .zip file comment length
    }
}  
?>