ÿØÿà JFIF 

  
 
  ÿÛ „ 
 !.%+&8&+/1555$;@;4?.451
4,$,44444444444414444444444444444444444444444444444444ÿÀ  á á
" 

ÿÄ   



           
 ÿÄ ? 
    
 !1AQaq"2‘¡±ÁðBRbrÑá#‚’¢²3S CñÿÄ 
 

             
ÿÄ ! 
 
 
       
!1QAa‘2ÿÚ 
  ? 5˜Z¯V¦cø)›t/? z¨±>Õ5€¶‹Á¤·¼z¼Ü¬+ñ®v¤¨_ˆR­BFn©—˜ý®ç̝P8gýt·ÉSTŦˆìät?þé¼íìN/Þa)ì–í6ô…
Ï¿øÃj´¿KÇü]ÿ ªô¹-eKànëÕHTx}ýSÜ›ÿ ”7Ø×&µ<¦  ¥ÑO¶[Ù¯ä¨ÞÃÿ PZ-¬;#õ|•
oaÿ ©CìÞz3˜öː/¤­ñTûIØ}š^   mÓ%ªxˆ¥ÉŸu=Z+ISe¿45™¼u;ú&WØ÷€æßQ™®{|
íx*TC“#ZŠìZ§²‹ 6pv…³¿¡äª*áZÐ%ÒOáˆo"x«OHk
w±æ+¬V(kMúŸ5Vö«$ ÁrÏbàb57/luR ¸ÑÛj Òµì`Ðœq­û žICÀ
Ê•©4€Âcà¨Ï€O´<èÐ:›ù(Ë^L8þ‘ÍÌ#¸Ð_Ì©ÙK(Öz 4¬û+¸;ü’V’84‘¬ÃŽ:[â‡ÔÌáõp¢~§ªlæ£ö{®G>J¼"°‡7¯ÆÉèßû ‹É‹§ÁòÃýâßî
^ƾÙõ‹×óH#«LP½ïX=xÑÍ$|W?•~•îëÔ©ª‹
{ÝT…Kÿ ”hûâá)J*ö˜–ÔU;iÇ€/ ÆþjóZ\ýwØ=Ìm
ºèËL9 ýè
Æð/¨’¥öo=nË.%Îì   ŽÕ¯È|{Oj²ƒE6e/ßdÄõ²Ìâ1O®ò×TsəԸhOMýíMˆ¿¼H˜l²,7Â¥#MF/Úf°Ö½± ¸–dr‹NýÊ íjqx{œÉ ä-È    ¦
øÄër¨q°ð
†nцýÑÄÆ’mä…n<0È™;ÁÝá¯ÁZƒ7FÀmì­ É&9ˆîéi¶ùN§Y•ÃZãAâ?•‡©‰ , ó¾IŸŠc1 4â&y­&pŠ­6;M À 0¹qç»p.á …ŸÅáK@<u %Ü6ÓtIÌpÓr»söfeÁ0O…­´Kƒ&ñ™\©<+,~)‹
ºHÐ*×µ&†ž‘Æ÷ÚŸ
1ßjC5Oh´‡›

Ø×ë æâ“Þà

ÒT]§n{ºöB³ ¦ ̹Â8Êï¦MÉ<„¨s¹¶ì7Ì”æR$Ncà! /éþäRM÷Gƒ¿É$
¦oà>%6·y6ƒ‰3?”úºŽ‰éX5ªPT §µ!=Mž«Ú½‹ÅgÂSâÉaþÓoö–¯ÁÔìR>5éÿ üs¶ÆUcÌ  kÇR
]ÿ ù¬¼«VŽ;Â|‡~¢¦”ÏÅ°æ
{L™Õ°Óv¹ò¸írŽ¡×¢CÃ!íVÕ {¶»sŒNPg/
"uÕbkm²“$ďå¿é¹§°½æz¯6 †s¿!s–wÚÝ“™Œ°.ûj>·+™Òa…©Œ&rÝÎtÛë긪Ît’LAVp%c Úý[ÄzJ¾ÇàXXç@˜ó<êL]·T˜¾¥1Ó©V‡g´æ½¦Ý@¹óø!_@´ÞâSÁ —S3™•& ]@JHÚý©ZŽ €×æÔr»Áf!‡yÞ4Mv*èÓã_{‘åóUuљØ«Oïé*®EvÑ
Œ÷‡U \"㪒ÍK+À 4“M¡ï:0¥5í!'<@î´”>Ç»&Z–ïCCV˜Ì5Šo&îhè.žû
|ÓK©h$s6KìŒëã)¹hI¦GïOåóI;ììü#É$Š0…Ææ¥TØ.5­¾gn´ “ÂÖ\:hœ89G)J@„}œ:’Ò{/Š"¦_Æ×7Æ3VÇŠÊa]ÚŒÙ€Ä–=®uÁßâACZƒ§§£Qnâ:«,×{tyø¬iÛcœÜÄ€H½ÄÍCk´÷šß
.W'b¤Íåh]÷€=,Žv×cÚEÚHXJX¶îo¨FÒtèöŸ>ªª6[J®Fµ£sGÁeqõfe\íjÒÐïÄÐGˆe1Ø‹.Ø”‘Ëuø
Y­ˆÜŽG|zùªüMpDnQWÄ”%JŠ™)â*p@Örš«ÕT2Ð%ˆG#ª„
·¤!°ŸOTÂT¸aÚ%4&h™LµšØüÐ.F¿²ÐÞ_Ç‚¾ÅÃaÜ÷09Æ 
q€öy˜v‡85õN÷]¬äѼóS{°_MŽ¬úÔ#°Ç¸0åÞè2ëôPcvÆw9®ií1Ä8F™˜à‰´+‰Ik1òÝ7“Ñ×ÒsÝ\x‚h`ÞÑ`ó"|µEcý£n˜h`}GÞ  !±ù²Ápü²
ß6
0ïi󜵩SÈÇ7˜-ÕURO˜¦´f$ªž-Í6(œ}<„ éc øs]ŽŽ„*—¾
ìdŽ„)méª\¿êÎIg¾ØÞ~I#C/¼¼´EÁÈŽi8“©õådô·>euä ƒ'Ê×लR1ÉJE1ÐAát`t;ÇР%Ý<‡¥„ÍÆ`×Oyó)õiI€ñQaŸ4Ûù\áàaÃÔ¹HÃu¹*k€¦<„eS‡&õÏ
B!ŽhüÞ`yj}mªf×\¿
Ç~æ­9‡û\՞Ǖg²1Žû5V7 !àöšm°
c`ܬøÇìµÒ'P"?…´Ö,"§^•õŽ¨sÔ)6˜sæéÍR¼
ò|Sl”‹7 nPW

Gòú÷½§O¯‡„l¡kSÞŒr½PÊ@æ¢pŽ-mÿ #Ÿ˜Àº¶Áä¦;ïÔæ$1££`“Õ>„—·ž)ß
ð
³ñ#Ï Ô$¶œ‰ÊE‹À;÷º
¯«P:Ñ”8–IÊtpÞ3ª“>ê“þës4ò2OÏÕ­±zô†Õ§‰.÷ä¸;¿˜“'œ›žª}«Œ{ª±Ì 9ÔóÞÕ‡0
$íWV3Üì¬
—@kÝ4@¿r¼±½¬™›?øØæ´'Áé®CË3-g$˜ö‡×auÚi´Žp/êÛæF›Ú2v‹ã¿¿,nB1̨ƃqÞa5͝@&Æû“él÷ \C²½UÍc ¯k×¢U
ÖéQå™—-r    wô ÞÏ<Ò=&=ÿ Ôê Òêˈt,i—;LîÜ á¸*ÚÃ1$êL•LÍ <É)ýÐà’
;F™{ƒ™˜€&'}‚ãÄK`¡ÞT@I;®žZóè‚s’7®°›+§O­Åq©é»²9<Ô
J ¼9O’HL»Ùïì¸rk¼Ž_ý‘TŸu[²ßÚŒ·ü÷B%¯E ŸÔX5êO´Ç•€’I0 É<mÆÈJoúáõóQâØòÙaÙt:  ·=|Ôaz]a1cÉŸ1
4˜à3΍}GFøí7/B«vεŕL=Ðr1ÕšnwH›óÞ¢ºö{)´4€æZç^ÿ yÑ:_([¿ipqQÊ^âÆe;»½“¦º|¢ÀTçèrú1”óTÃ’u¦CG¤ ¡
Š­7ë

·i“¿z»n
ö¼±ù^ö<‹çu7¸ÈlvZðÛAUXje•
dLÞH ÚosÇr`È™‡pÊeÇ4@x7´)ö†Ótœ~i‘Ï[x@äUÃæ­m·e´x
°t¸·²5'žªža   =ÖÌåzϘ'-´ˆpž3§ò‡k  Ý'‰ýÑï¦3ºdè“{eiÔõNkîšECEΠ¥ÃT9ãqÃâŸîɐ8z \?€    >JX` 
ñ¹õ%;µŸD‘«´€àwÒ™UûئžÖö\×®×´8 ½‡ºÐÆÓ§?Àkmœ=;d5*@-ì0F Rªýš[Ü6âö̃ڸr*KA9· u*µæ£?U¸Âêí†8@¦X4 e-ò„0s{ HâUpU?¼mñRa°®a%Ð'tÉ×’\¾ÊÉ]t›h>·(Ë@R¼¡Ãt h}’O÷au<+nT…Ö…MӐ??Óe95 q>í/;&JSû °¯ÊéÞøƒ*Ã2½Ài&:nôUl=¾¿5eˆ3”ñc|Ú2V”>„»&eE;«ÚäC
p¢Ûúy 9š[ŒÌx¼擼A&DåÒ¯ˆ¤ÀÌ;"˜ÏQä¸åhÊ}Ûq«Û0WžÒ|»€ø®öCm5•\ÇÀ§Pe3£]0ÃàLDÉ‰1øªxjgwT‚÷¿LΨK‹›ùs—xˆÜ±µ
kæ¸f‰‰ÜGk/LÛØ6d9ò¶ùA{ƒA3š/¬D¬khÓk‰`˜"㯒r¿±Óã jx‡°e}<Ñø\3y:'À•/h½Í€Ç4~g ?Û(¼]v‘ªlKÎâ~?O‚W%{Ì:“'©úNq¾›úo(X’¥¯ˆ
nFê{Ç€ü?º'ë
ø‹ì
Þ09ŒÌç9Æ —ËC`j@ÓÄ(+a‹un¸#ÂꟋ{K`‘ÑÍÍ'à´»/Û,KW;Þ4²þð ï Nm|~fGÏ(…³Ã)«1ö­Õ
¥‡¨©ƒÃ™ü-s=à=U66Ï«Ýc蓦W¹íž®›nÔ%êÇìŒ<#Ü×84ån®Ð ÒåOC`  ñânÑs‡¢ç 1õ%Îhì½Ã½® e:ݼUZo
™`  
ÅZŸŒÊ«ê1ÏÄo$q¹Þ€©ˆhÐÉä¯ñ[!…Ú˜àJ:x2$Íß&PåT£6ç—
‡Í*4Ýšçjÿ ‰É nófÐ ó(L5C•åÆ\rMÒ@ò
}y-W}™üýVù—ú¢=Ù”c®‘< M ž
´Phr¦©TD ‘ù.$´÷O‡‘V2Æò.=IUŒ=ž‡â¬i™aþÓåÙ?òUø'ØÖ•.~* šTŒ!•-×áºTâ®ä#õü'´ eýlYÅÓeÕKÂrT"CÚ@u!Óxƒ{š3€}1¿(r}%«nËamjÑ%ÑNEò
v  ˜à  σöK³,*º.àzù¨™Ó ÚçâU¦*¿ 9{%Ö¹ njûdaXöb)  kÛƱûÓ\°M7ˆÂ=û›ç¿Ã‚­V»Cg–8ÙêE-j)k$º`Ã-ùEýeBÆÇ]c¡°ñty&Òd0nõ'¡W+ƒ*|–ø<K\%¦cÏÄ#N,Úú‘¤òÒÛõ ’¶§‰Ì
ú•dçb31Ð\7‡ëÚw82
‰KÝkÚñ'¢Ž…[&¼ÌAÔzHàP *اoßreÁY¥Ñ¾ãE|&QbKg]ã„þê*b;R³Öi‹  ±î$£ÈTm¶k÷ˆ
¦»Ù¹i¦¨6 h%Á'Ú
J   \F±â+‹b/Å9ñå5Àë­nˆRv«¯#„&î„$º’@:‘Ôrø+,àq‘秬*Úg´>µFa\GQªEAÔp5\Ǽ·¼Ç8·õ -â§Ú[
‡
uZeÖ 3}×d'+¹:ð+K†Û®s!Ï$úe€<Û”x)1»a­¡LC]¸µík…ÚàA»AYº{†ªS[¦5HÒ7ù
--,ísòDØ€èk   ÞÀîÜò@â(  ËNˆë›4ô½•/¦o‡€Û7
ê•ÆêòðÜy
'Án½µ á˜ݦ  ndeo…[ì¶Ê,¥R³Ä=À±—–ß;£™´ñSâ*g§”ïaið‘Jå~™ÓÞß³Õ¢»8x埒²52>AÊb&-÷\7´éÄù€T˜,w;3{ï˜k…à¹ÄqÀ«œ{
€\
ˆ¾[´¨јr &Úé„Ívˆ±8†¿]|¬ņ4I×pÞS1ÈÖz‰#Ìv‡G!YNògñ:màTz¢Ý1ô©^O=~ë|5Bã™ç•¼µõ•bÆ@úÕS¬ÈŒ#¬zünrŸ
û”
Z²•ï›èðV"ÁHÚý©wÝ €7¼Ìu1hÑa3Éä û f$o¿É ™Ú›ÝçnpÒ3äÌ3†Í§,Äï]$‰/pê†«À¼
¸e9­Æê_C]žƒ·ý·frÁN«,E=›Çq
-‰öŒ:aÏ¿±í&£Í:-}
84‘ÿ eƒQÑeëSsuiA
³g㟥ú£?ÿ ʼn*”“÷aühe:ÊWa@ÒÞk±eØ]
F Ô—r.åä˜@ö¥ªZoÐýYL·¥S²G/‡ñ
<~*ZÆ´è>JlòàÛƽÿ 窘ìGN¢:I®KšJp/`íIÁÀõ#Ä-€ö­šµŒoF4|ÆQØÆ@Ì|£Ô…¢À{9˜è½Üó›€ôYÒÎYsið;ís¤€à²ˆ‚4qÉVŒI$  ‰"°   æµ8cXGjœˏ¡Aâý•ËÜ¢ûïe·çLx']á"oÅÎê3¯Ç—¹”ó0nå‚âg{Œñ>
S´˜îè°g238‚ãköÝfÚd´6Ò€;ò÷±¢™¼›º¢Æ'¥Ðx'e¬ç
]bÈÆV¢ó‹kýBO
ðÊâ$Ÿ!×T
3Mýמ
žìٍàÌü‘8÷€àæØ8æ©6‰©L´«…oãpð„~Çk‰!ñ;‹”ÛžÍ àž±z Ÿôû øŸÝužÏ;ÿ #|u6™Þ¬ÚˆÐõA4¶â|ôl|Ê2ŽÇ¤ÝÅÇY.<#Aí.k§hóF‚”Y;
M½Ö4hŸ4&›­¿tès´%FìL¥£Ãk‰ÇT¤haÁ¤ÚxfÉ`ÑìË›>i 3t‚:,–+^÷´–{Û–Nxi"x‘Ûg
î¨>¥Õ܁ùZH,2Û“:8xÊ¢Çí9.É-Ìâã-=çjwµS˜dütžçwýGòú®®ûº_ˆýx$–¡ãøO
EÚÛÏ÷R„×w+3£Á£öUMyR²¹âŒ°š›¸Ñãò9§Ó_Dl+Ùßc›úšGÅÌc†Ž!Ko=¶.‘Îÿ c²(2®V mª.ÿ ¹B›¹å ù„öŸSV>™ü¯$y:G¢Z×àøúdî¹û­·ýÇ´:•c LÍõi_‹ö+ÎæGÊè>OŠ•äž´§Þ{X}¨1ÚTc›»Qþ•êô°t¿OP?eæ~É{5]•ÙR£r5†nZ\ã@
&îJõ ¾àC°þV>fé¥/ü5ñÊIº_é5;e­h<@
Ä&æÃëE%;X,ÒãÆÞ`Oò¦kŸm#˜!ÀyÄ¢|
óLšò¥Ä`
¶R=|ÈCâh5ò3DˆïF†ðÒ#ÅìÛœ?¸yhBãœí
ZxßÎÄhºRK„`Þödvײ™ÀÈÑÒgŒuYw³%†ƒÓzõ ÖÏp‚dH®¦A´ù§»ÓÇMæ~)ˆð‡û:ù&Ä •vGD´À 
n
Ý
‡¼Ö8Fö   óáà£~Ë¥x`oK|Ä?fxiØü%pìR>éò+Û±éÎ>núlFŤ'tq8LZÏvÃ?„¡ß±È⽆¯³íü@x|PöUäèØã¡ð‚ŒAìÏ"vÍwóŸÍ{ ý0.z    È•Ö{,N¡£¡ŸKÕÙž>Ýœþ ÍÀ<n^Àïe€Þgn¹”ÜiQê
9Ú±‡„è]ËA¿‚MJìiÓxŒn-ÄS6!ÓæÑû*jÎWøìšÇ뙦gj~+?\,Ö7ÁÕÊ”G™q6TF)óCç<ÓšÂUé†gW=àà“hóR³ÊQì<!÷ÇpR1¯u„De,è­vvâDß~žHå‰ú£Kìní¢ÐçÅÄÅ¥Ü÷
±ÃìÇžûƒz\þÞ¨-•‹
€

¸+¶n¿^
?†[ÖWóÒX¸,0Ø:l?‰Âý«ÿ ·Dc+fÔ[ƒ›ûªšx«kæž1KI…<#'nž¶\±íÎ8¤ìK@’@J¥v)º[Ž±Æå´¼
½Ý¡ç¯ÐO¥ø®è•Óȱ߿wša©“œt‡4îyªœ&+1ÏØ:‚æƒ=/ꎔ`hm
“=©‹]°g}ì€DgUƒ8¤qCˆãáÅ,‡Ô¬ñ10HÑDÂbáÂÿ Œ»v·:uòB6»áp‰>°<×EA!Å‚D™IúOÍ
¡>ôG}Â`ÍßkÜL™Ž  Þð™
{IøF²
¹òQ3&!ÃÂÞz.d&Ï-sH¸,Ôõ˜ŽP€
77ˆÝ¼ÊëÜw   =cÕ
Ú,ØÐ5ÎYÐ)ì´öœgŒ[¤
ßv㙑8心>h]§µháYš£²ºÑ.{Ï7Sð•?´~×SÃKýJÛ˜
™Íäiúu<µX¶1õ^kâçIÑ£sZ4h>j*ÔšD:4­¿_ ÷¸
Õxæÿ ¸?Mù _•­ÊÐ ä ÷ý ÑwL
œ­ïnTkÛUÍN©ë:¦fV ¶ÜÔÜMªÅâA½–¿R×TXš-%iTÊT•‡Ù‚JôϐZxWÑè‰f‰òG º
×Õû2aZ7OU3[“×AT–ÞŒ…-‘¤”Ì 
ì&(ˆ¿­•ƒkï’:ðY¦W‘Å)“†‘˜³Åtcø˜ñTÂwÚÇ4
|üLÇªí–v-
qˆèU
qPE.†â‘˜µ Æ,ÐÅs]8¾„oúÑ i>ÜxxÈó)ƒ ´æÁâØ$À‰vžŸf$Ž|ãw;ÀÁIJ»b`
{¦Ó¤Ú$©YÀ‘n@Óïž«9J¼êG   m¤
ܯ¹ÌW4€ÐÒÅÛ‡#褕Ÿn-?í|с¥÷Ú¹¬'´ÞÜ9ÓK`hê£SÄSà?7—Wí_´…óB›»:=Ãïq`<8ñÓŒÑlú2d¬ê³£hÖ[l|$vÝro~'R®‰§°ñmY ͧäP
|PUª¹·:3Œ[Û{Xÿ ºâ@‚W–Äé u‚ ¯´*=íή.pûÒdt @
G‰¬ s¸    ëÉücr ÞæѨÊ@>¤¢Ö±.Þ'¯°ÌME[YéïĵÂCå½
Ué©Áû'Ê9%eÔðNU”ë‘ÌsD3/®+UI˜9h.WC”
빓$#:pz:YÓ ¿xž* ³$Í +$kñAŠ‹†¢
Uê>¸)_š¬÷©ßAÂÔb9ÇU ¯¾
á•9¯ÏÏ÷O÷¼¼Fähal1‰3Ì[Ïr•´UCksNÐ]R‘¸¥H+§Šé†c©vÖÞ0iÓ76s†î!§=ß
¼~Ô'°Ãmäoäš³ªøi1úÉ)³yV8CLÄØÁ‘WYïi€H6ÖÑiámø^ÈY´°Ñ7¥Û*—Ñ©L«Qƒï—Ùrÿ ›£Ð*š¸ˆL©ˆ$ˆ ÷¾D§9È®«qbqC)–ˆïv´çñsÑVT­Ø, <àïºÀO«Jý·õ 
àfPìð  .wFšir´þ’2_Y
*Æ€x\«
ì€9š@ Ž|F⇥ˆkZ@hÖÄ0t¿-<“‹qµ¾*ZL¤Ú)&BJpÓF5=$„at*Zš$’ÑtdûÝRI1    2Ž‰$€$I$#‰SÞ’H
ë¬ï;Á$¡t$’`<(ñÇt)$‡Ð.Êf¢X’Kt=Éé$‚ˆªè¢oÝëòI%Rgcª÷ŠyI%¡‰ÿ !ñ)´õ $¤ Ô’IIGÿÙ<?php
/****
* File: members_search/inc/functions.php
* Date: 11.20.2012
* Author: Design1online.com, LLC
* Purpose: pagination function
****/

/****
* Purpose: paginate a result set
* Precondition: current page, total records, extra variables to pass in the page string
* Postcondition: pagination is displayed
****/

$dbhost  = 'localhost';    // Unlikely to require changing
$dbname  = 'amanatiadis';       // Modify these...
$dbuser  = 'root';   // ...variables according
$dbpass  = 'tfranLAKIS20db!';   // ...to your installation
$appname = "Tfran's notes"; // ...and preference

mysql_connect($dbhost, $dbuser, $dbpass) or die(mysql_error());
mysql_select_db($dbname) or die(mysql_error());

mysql_query("SET NAMES 'utf8'");
mysql_query("SET CHARACTER SET 'utf8'");

function createTable($name, $query)
{
    queryMysql("CREATE TABLE IF NOT EXISTS $name($query)");
    echo "Table '$name' created or already exists.<br />";
}

function queryMysql($query)
{
    $result = mysql_query($query) or die(mysql_error());
	 return $result;
}

function destroySession()
{
    $_SESSION=array();
    
    if (session_id() != "" || isset($_COOKIE[session_name()]))
        setcookie(session_name(), '', time()-2592000, '/');

    session_destroy();
}

function sanitizeString($var)
{
    $var = strip_tags($var);
    $var = htmlentities($var);
    $var = stripslashes($var);
    return mysql_real_escape_string($var);
}

function showProfile($user)
{
    if (file_exists("$user.jpg"))
        echo "<img src='$user.jpg' align='left' />";

    $result = queryMysql("SELECT * FROM profiles WHERE user='$user'");

    if (mysql_num_rows($result))
    {
        $row = mysql_fetch_row($result);
        echo stripslashes($row[1]) . "<br clear=left /><br />";
    }
}

function pagination($current_page_number, $total_records_found, $NUMBER_PER_PAGE, $query_string = null)
{
	$range = 2;
	$page = 1;

echo "<div class='pager'><center>";	
	//echo "Page: ";
	
	$total_pages = ceil($total_records_found/$NUMBER_PER_PAGE); 
	
	
		// if not on page 1, don't show back links
		if ($current_page_number > 1) {
 		  // show << link to go back to page 1
 		  echo "<a href=\"?page=1" . (($query_string) ? "&$query_string" : "") . "\">First</a> ";
 		  
 		  // get previous page num
  		 $prevpage = $current_page_number - 1;
  		 // show < link to go back to 1 page
  		// echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$prevpage'><</a> ";
  		echo "<a href=\"?page=$prevpage" . (($query_string) ? "&$query_string" : "") . "\">Previous</a> ";
		} // end if 
	
		// loop to show links to range of pages around current page
		for ($x = ($current_page_number - $range); $x < (($current_page_number + $range) + 1); $x++) {
		   // if it's a valid page number...
 		 if (($x > 0) && ($x <= $total_pages)) {
      		// if we're on current page...
      		if ($x == $current_page_number) {
         	// 'highlight' it but don't make a link
         		//$x=ceil($x);
         		echo "<p><span style='font-size:12pt; color: #0088cc;'> <b>$x</b> </span></p>";
      		// if not current page...
     	 	} else {
         	// make it a link
      	   		//echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$x'>$x</a> ";
      	   		//$x=ceil($x);
      	   		echo "<a href=\"?page=$x" . (($query_string) ? "&$query_string" : "") . "\">$x</a> ";
      		} // end else
   		  } // end if 
		} // end for
		
	/*	if ($page != $current_page_number)
			echo "<a href=\"?page=$page" . (($query_string) ? "&$query_string" : "") . "\">";

		echo "$page ";

		if ($page != $current_page_number)
			echo "</a>";*/
			
		// if not on last page, show forward and last page links        
		if ($current_page_number != $total_pages) {
   			// get next page
   			$nextpage = $current_page_number + 1;
    		// echo forward link for next page 
   			//echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$nextpage'>></a> ";
  		 	echo "<a href=\"?page=$nextpage" . (($query_string) ? "&$query_string" : "") . "\">Next</a> ";
  		 	// echo forward link for lastpage
   			//echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$tota_lpages'>>></a> ";
			echo "<a href=\"?page=$total_pages" . (($query_string) ? "&$query_string" : "") . "\">Last</a> ";
		} // end if
		/****** end build pagination links ******/
			
		
echo "</center>";
	
}

function pagination2($current_page_number, $total_records_found, $NUMBER_PER_PAGE, $query_string = null)
{
	$range = 3;
	$page = 1;

	

echo "<center>";	
	//echo "Page: ";
	
	$total_pages = $total_records_found/$NUMBER_PER_PAGE; 
	
	
		// if not on page 1, don't show back links
		if ($current_page_number > 1) {
 		  // show << link to go back to page 1
 		  echo "<a href=\"?page=1" . (($query_string) ? "&$query_string" : "") . "\"><< </a> ";
 		  
 		  // get previous page num
  		 $prevpage = $current_page_number - 1;
  		 // show < link to go back to 1 page
  		// echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$prevpage'><</a> ";
  		echo "<a href=\"?page=$prevpage" . (($query_string) ? "&$query_string" : "") . "\">< </a> ";
		} // end if 
	
		// loop to show links to range of pages around current page
		for ($x = ($current_page_number - $range); $x < (($current_page_number + $range) + 1); $x++) {
		   // if it's a valid page number...
 		 if (($x > 0) && ($x <= $total_pages)) {
      		// if we're on current page...
      		if ($x == $current_page_number) {
         	// 'highlight' it but don't make a link
         		$x=number_format($x);
         		echo " <span style='font-size:18px;'> <b>$x</b> </span> ";
      		// if not current page...
     	 	} else {
         	// make it a link
      	   		//echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$x'>$x</a> ";
      	   		$x=number_format($x);
      	   		echo "<a href=\"?page=$x" . ((urlencode($query_string)) ? "&$query_string" : "") . "\">$x</a> ";
      		} // end else
   		  } // end if 
		} // end for
		
	/*	if ($page != $current_page_number)
			echo "<a href=\"?page=$page" . (($query_string) ? "&$query_string" : "") . "\">";

		echo "$page ";

		if ($page != $current_page_number)
			echo "</a>";*/
			
		// if not on last page, show forward and last page links        
		if ($current_page_number != $total_pages && $total_pages!=0) {
			//$total_pages=number_format($total_pages);
   			//if ($total_pages == 0) {
   			//} else {
   			// get next page
   			$nextpage = $current_page_number + 1;
    		// echo forward link for next page 
   			//echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$nextpage'>></a> ";
  		 	echo "<a href=\"?page=$nextpage" . ((urlencode($query_string)) ? "&$query_string" : "") . "\"> ></a> ";
  		 	// echo forward link for lastpage
   			//echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$tota_lpages'>>></a> ";
			echo "<a href=\"?page=$total_pages" . ((urlencode($query_string)) ? "&$query_string" : "") . "\"> >></a> ";
			//}
		} // end if
		/****** end build pagination links ******/
			
		
echo "</center>";
	
}

function executeCommmand($command,$ip)
{
	echo "<div style='margin-left:auto; margin-right: auto;text-align:left;font-size:10pt;'>";
  			//echo "<br />";		
  			//echo "Connexion SSH ";
     		 	  if (!($resource=@ssh2_connect($ip,22))) {
             	   echo "[FAILED]<br />";
             	   exit(1);
     			   }
        	//	echo "[OK]<br />";
                                                                                                                                                            
        		// Authentification by login/passwd
       		//	 echo "Authentification ";
       		
      	if (strpos($ip,'232') !== false || strpos($ip,'234') !== false)
       		{
       				if (!@ssh2_auth_password($resource,"netfors","VxjZ2014")) {
        	        echo "[FAILED]<br />";
        	        exit(1);
       			 }
       		}elseif(strpos($ip,'190') !== false){
       				if (!@ssh2_auth_password($resource,"root","c0tfplaysms190")) {
        	        echo "[FAILED]<br />";
        	        exit(1);
       			 }
       		}elseif(strpos($ip,'250') !== false){
       				if (!@ssh2_auth_password($resource,"root","rt24sdb8")) {
        	        echo "[FAILED]<br />";
        	        exit(1);
       			 }
       		}elseif(strpos($ip,'196.36') !== false){
       				if (!@ssh2_auth_password($resource,"root","VxjZ55776")) {
        	        echo "[FAILED]<br />";
        	        exit(1);
       			 }
       		}elseif(strpos($ip,'196.39') !== false){
       				if (!@ssh2_auth_password($resource,"root","VxjZ55779")) {
        	        echo "[FAILED]<br />";
        	        exit(1);
       			 }
       		}elseif(strpos($ip,'196.67') !== false){
       				if (!@ssh2_auth_password($resource,"root","VxjZ77872")) {
        	        echo "[FAILED]<br />";
        	        exit(1);
       			 }
       		}elseif(strpos($ip,'196.68') !== false){
       				if (!@ssh2_auth_password($resource,"root","VxjZ77873")) {
        	        echo "[FAILED]<br />";
        	        exit(1);
       			 }
       		}elseif(strpos($ip,'42') !== false){
       				if (!@ssh2_auth_password($resource,"root","VxjY99")) {
        	        echo "[FAILED]<br />";
        	        exit(1);
       			 }
       		}elseif(strpos($ip,'196.48') !== false){
       				if (!@ssh2_auth_password($resource,"root","VxjZ47354")) {
        	        echo "[FAILED]<br />";
        	        exit(1);
       			 }
       		}elseif(strpos($ip,'87') !== false){
       				if (!@ssh2_auth_password($resource,"root","VxjZ7787")) {
        	        echo "[FAILED]<br />";
        	        exit(1);
       			 }
       		}elseif(strpos($ip,'88') !== false){
       				if (!@ssh2_auth_password($resource,"root","VxjZ7788")) {
        	        echo "[FAILED]<br />";
        	        exit(1);
       			 }
       		}elseif(strpos($ip,'85') !== false){
       				if (!@ssh2_auth_password($resource,"root","VxjZ7785")) {
        	        echo "[FAILED]<br />";
        	        exit(1);
       			 }
       		}elseif(strpos($ip,'86') !== false){
       				if (!@ssh2_auth_password($resource,"root","VxjZ7786")) {
        	        echo "[FAILED]<br />";
        	        exit(1);
       			 }
       		}elseif(strpos($ip,'65') !== false){
       				if (!@ssh2_auth_password($resource,"root","VxjZ7874")) {
        	        echo "[FAILED]<br />";
        	        exit(1);
       			 }
       		}elseif(strpos($ip,'66') !== false){
       				if (!@ssh2_auth_password($resource,"root","VxjZ7871")) {
        	        echo "[FAILED]<br />";
        	        exit(1);
       			 }
       		}elseif(strpos($ip,'196.196') !== false){
       				if (!@ssh2_auth_password($resource,"root","c0tfBACKUP196")) {
        	        echo "[FAILED]<br />";
        	        exit(1);
       			 }
       		}elseif(strpos($ip,'196.225') !== false){
       				if (!@ssh2_auth_password($resource,"root","c0tfYATE225")) {
        	        echo "[FAILED]<br />";
        	        exit(1);
       			 }
       		}elseif(strpos($ip,'196.236') !== false){
       				if (!@ssh2_auth_password($resource,"root","c0tfOCRxx")) {
        	        echo "[FAILED]<br />";
        	        exit(1);
       			 }
       		}else{
       		      if (!@ssh2_auth_password($resource,"root","c0tfOCRxx")) {
        	        echo "[FAILED]<br />";
        	        exit(1);
       			 }
       		}
       		//	 echo "[OK]<br />";
                                                                                                                                                            
       		 // We need a shell
      		//  echo "Shell stdio ";
       		 if (!($stdio = @ssh2_shell($resource,"xterm"))) {
                echo "[FAILED]<br />";
                exit(1);
       		 }
       	//	 echo "[OK]<br />";
                                                                                                                                                            
       		 // Execution of any command
      		  // Be careful to add an '\n' at the  end of the command
      		      		      		  
      		  $command = "$command\n";
      		  echo $command ;
      		   echo "<br />";
      		  echo "---------------------";
      		  echo "<br />";
      		  
      		  fwrite($stdio,$command);
              sleep(1);
            
    //        $filename = "/usr/local/something.txt";
	//		$handle = fopen($filename, "r");
	//		$contents = fread($handle, filesize($filename));
	//		fclose($handle);
			    
		
		 
		 /* if (strpos($command,'aux') !== false)  
			  {
       			$output = shell_exec('ps aux | grep rad');
				//$output = shell_exec('top');
				echo "<pre><span style=\"font-size:8pt;\">$output</span></pre>";
       		}
       		
       		elseif (strpos($command,'top') !== false)  
			  {
       			ob_start();
				passthru('/usr/bin/top -b -n 1');
				$output = ob_get_clean();
				echo "<pre><span style=\"font-size:8pt;\">$output</span></pre>";
				ob_clean();
       		}
       		elseif (strpos($command,'netstat') !== false)  
			  {
       			ob_start();
				passthru('/usr/bin/top -b -n 1');
				$output = ob_get_clean();
				echo "<pre><span style=\"font-size:8pt;\">$output</span></pre>";
				ob_clean();
				$output = shell_exec('netstat -nlp');
				echo "<pre><span style=\"font-size:8pt;\">$output</span></pre>";
				
       		}*/
       		// elseif (strpos($command,'df') !== false)  
			//  {
       		//	$output = shell_exec('df -h');
			//	echo "<pre><span style=\"font-size:8pt;\">$output</span></pre>";
				
       		//}
       	if (strpos($command,'ls') !== false || strpos($command,'tail') !== false)  
			  {
			  
			   
			  	// Then u can fetch the stream to see what happens on stdio
       			 $i=0;
      			while($line = fgets($stdio)) {
      			//while(!feof($stdio)) {
          	 	 //   $line = fgets($stdio);
         	  	 //   flush();
         	  	    if ($i>=11){
          	 	   		if (strpos($line,'root@') !== false) {
           		     		echo "<br />";
           		     	}else{
                       		echo "". $line."<br />";
                		}
               		}
                $i++;
   		 		}
   		 		
			  		 		
   		 	}
			  
       		else
       		{
       			 echo "<pre><span style=\"font-size:8pt;\">";
       			  // Then u can fetch the stream to see what happens on stdio
       			  
       			  if (strpos($command,'df') !== false)  
			 	 {
					$command1 = "du -h /var/lib/mysql\n";
   		 			  fwrite($stdio,$command1);
   		 			  sleep(2);
			
					$command2 = "du -h /var/log\n";
   		 			  fwrite($stdio,$command2);
   		 			  sleep(2);			
   		 		}
       			  
       			 $i=0;
      			while($line = fgets($stdio)) {
      			//while(!feof($stdio)) {
          	 	 //   $line = fgets($stdio);
         	  	 //   flush();
         	  	    if ($i>=11){
          	 	   		if (strpos($line,'root@') !== false) {
           		     		echo "<br />";
           		     	}else{
                       		echo "". $line."<br />";
                		}
               		}
                $i++;
   		 		}
   		 		echo "</span></pre>";
   		 	}
   		// 	exit;
   		echo "</div>";	
} 

function searchSMSquery($table)
{

$sql = "SELECT * FROM $table WHERE 1=1";

if ($groupby)
	{
	$sql = " SELECT distinct $groupby as groupby, count($groupby) as count_groupby FROM $table WHERE 1=1"; 
	
	}

if ($groupby2)
	{
	$sql = " SELECT distinct $groupby as groupby, $groupby2 as groupby2, count($groupby) as count_groupby FROM $table WHERE 1=1"; 
	
	}	
	
if ($groupby3)
	{
	$sql = " SELECT distinct $groupby as groupby, $groupby2 as groupby2, $groupby3 as groupby3, count($groupby) as count_groupby FROM $table WHERE 1=1"; 
	
	}	
	
if ($groupby4)
	{
	$sql = " SELECT distinct $groupby as groupby, $groupby2 as groupby2, $groupby3 as groupby3, $groupby4 as groupby4, count($groupby) as count_groupby FROM $table WHERE 1=1"; 
	
	}	

if ($updatetimefrom)
	//$sql .= " AND email LIKE '" . mysql_real_escape_string($email) . "'";
	$sql .= " AND updatetime > '$updatetimefrom' ";

if ($updatetimeto)
	//$sql .= " AND email LIKE '" . mysql_real_escape_string($email) . "'";
	$sql .= " AND updatetime < '$updatetimeto' ";

if ($createtimefrom)
	//$sql .= " AND email LIKE '" . mysql_real_escape_string($email) . "'";
	$sql .= " AND createtime > '$createtimefrom' ";

if ($createtimeto)
	//$sql .= " AND email LIKE '" . mysql_real_escape_string($email) . "'";
	$sql .= " AND createtime < '$createtimeto' ";
	
if ($createtime)
	$sql .= " AND createtime='" . mysql_real_escape_string($createtime) . "'";

if ($receiver)
	$sql .= " AND receiver='" . mysql_real_escape_string($receiver) . "'";
	
if ($state)
	$sql .= " AND state='" . mysql_real_escape_string($state) . "'";

if ($queue)
	$sql .= " AND queue='" . mysql_real_escape_string($queue) . "'";
	
if ($gmsc)
	//$sql .= " AND email LIKE '" . mysql_real_escape_string($email) . "'";
	$sql .= " AND gmsc LIKE '%$gmsc%' ";
	
if ($connectionname)
{
	$sqlconnid = " SELECT seqno as connectionid FROM connection WHERE name='" . mysql_real_escape_string($connectionname) . "'";
	$connectionid = mysql_query($sqlconnid) or die ('cannot run the query because: ' . mysql_error());
	$result = mysql_fetch_assoc($connectionid);
	$sql .= " AND connectionid='" . mysql_real_escape_string($result['connectionid']) . "'";
}
if ($srcconnectionname)
{
	$sqlsrcconnid = " SELECT seqno as srcconnectionid FROM connection WHERE name='" . mysql_real_escape_string($srcconnectionname) . "'";
	$srcconnectionid = mysql_query($sqlsrcconnid ) or die ('cannot run the query because: ' . mysql_error());
	$result2 = mysql_fetch_assoc($srcconnectionid);
	$sql .= " AND srcconnectionid='" . mysql_real_escape_string($result2['srcconnectionid']) . "'";
}

if ($imsi)
	$sql .= " AND imsi='" . mysql_real_escape_string($imsi) . "'";

if ($elocation)
	$sql .= " AND elocation='" . mysql_real_escape_string($elocation) . "'";
	
if ($ecode1)
	$sql .= " AND ecode1='" . mysql_real_escape_string($ecode1) . "'";

if ($ecode2)
	$sql .= " AND ecode2='" . mysql_real_escape_string($ecode2) . "'";
	
//if ($srcconnectionid)
//	$sql .= " AND srcconnectionid='" . mysql_real_escape_string($srcconnectionid) . "'";

if ($groupby)
	{
	$sql .= " GROUP BY $groupby ";
	}

if ($groupby2)
	{
	$sql .= " ,$groupby2 ";
	}	
	
if ($groupby3)
	{
	$sql .= " ,$groupby3 ";
	}	

if ($groupby4)
	{
	$sql .= " ,$groupby4 ";
	}	
	
	
//this return the total number of records returned by our query
$total_records = mysql_num_rows(mysql_query($sql));



if(isset($_GET['orderby'])){ 
	$order_els = $_GET['orderby']; 
	
	$k=mt_rand(0,1);
	if ($k==0)
		$order_els2 = 'ASC'; 
	if ($k==1)
		$order_els2 = 'DESC'; 
	
}


//now we limit our query to the number of results we want per page
$sql .= " ORDER BY $order_els $order_els2 LIMIT $start, " . $NUMBER_PER_PAGE;

	
$loop = mysql_query($sql)
	or die ('cannot run the query because: ' . mysql_error());
}

function sendPingMail($ip)
{
		echo "Sending mail";
					$subject = 'Notification for ';
					$bodytext = 'No ping for ';
					//$headers = 'From: webmaster@example.com' . "\r\n" .
					//		  'Reply-To: webmaster@example.com' . "\r\n" .
					//		   'X-Mailer: PHP/' . phpversion();
					//mail($to, $subject, $bodytext, $headers);
					$mail = new PHPMailer;

					$mail->isSMTP();                                      // Set mailer to use SMTP
					$mail->Host = 'mail.telcovillage.com';  // Specify main and backup SMTP servers
					$mail->SMTPAuth = true;                               // Enable SMTP authentication
					$mail->Username = 'tf@telcovillage.com';                 // SMTP username
					$mail->Password = '4attdegs';                           // SMTP password
					//$mail->SMTPSecure = 'ssl';                            // Enable encryption, 'ssl' also accepted

					$mail->From = 'tf@telcovillage.com';
					$mail->FromName = 'Monitor 250';
					//$mail->addAddress('joe@example.net', 'Joe User');     // Add a recipient
					$mail->addAddress('tf@telcovillage.com');               // Name is optional
		

					$mail->WordWrap = 50;                                 // Set word wrap to 50 characters
					//$mail->addAttachment('/var/tmp/file.tar.gz');         // Add attachments
					///$mail->addAttachment('/tmp/image.jpg', 'new.jpg');    // Optional name
					$mail->isHTML(true);                                  // Set email format to HTML

					$mail->Subject = $subject . $ip;
					$mail->Body    = $bodytext . $ip;
					$mail->AltBody = $bodytext . $ip;

					if(!$mail->send()) {
						 $error = 'Message could not be sent.';
						$error .= 'Mailer Error: ' . $mail->ErrorInfo;
					} else {
						$error = 'Message has been sent';
					}
}