Andy

Andy

Yes, good idea.

However the problem is that the images in the upload folder are taking up a lot of space on my server, I therefore need to reduce the "source" files in the /upload/ folder to an acceptable size (something like 1200 x 800 to reduce the file size (kb).

This is the feature I want/need and any help how to do this would be great.

Hope that makes sense

Andy

I know I can recreate the thumbnails, but my Website also uses the original uploaded files. It is these that I want to resize.

I attach an image which I hope explains better.

Thanks

Andy

I have a property Website with thousands of images in the /uploads folder (not the /thumb folders)

I want to resize these images without having to re-upload them

With the /thumb folders I can change dimensions and then regenerate the thumbnails via the cmsAdmin login but there is no feature to do this on the /uploads folder.

Is there a way I can do this without having to re-upload all the images again?

Thanks

Andy

I think I have answered my own question after a bit of delving into the support forum.

I changed my "where" statement by adding one more "AND" statement to exclude current property. For you and those that may be looking for the same thing, my "where" statement is as follows:-

    'where' => "property_type ='".mysql_escape($listingsRecord['property_type'])."' AND town='".mysql_escape($listingsRecord['town'])."' AND num!='".mysql_escape($listingsRecord['num'])."'", 

Thanks again for pointing me in the right direction.

Kind regards

Andy

changing intval to mysql_escape did the trick - fantastic!

One last question on this please?

My "where" statement now reads

    'where' => "property_type ='".mysql_escape($listingsRecord['property_type'])."' AND town='".mysql_escape($listingsRecord['town'])."'", 

This now produces all similar properties based on "property_type" and "town" but it also includes the currently displayed property.

Is there a line I can to the "where" statement that excludes the current listing that is being displayed.?

Thanks again for your great suport.

Andy

I have a property website where I have a search form, search results page and search details page, all working fine.

What I would like to do on the details page is also list similar properties based on the field “property_type” and maybe others but just "property_type" for now

Currently my "Details Page" header is as follows:-

<?php header('Content-type: text/html; charset=utf-8'); ?>
<?php
  // load viewer library
  $libraryPath = 'cmsb/lib/viewer_functions.php';
  $dirsToCheck = array('/home/aplacein/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 record from 'listings'
  list($listingsRecords, $listingsMetaData) = getRecords(array(
    'tableName'   => 'listings',
    'where'       => whereRecordNumberInUrl(0),
    'loadUploads' => true,
    'allowSearch' => false,
    'limit'       => '1',
  ));
  $listingsRecord = @$listingsRecords[0]; // get first record
  if (!$listingsRecord) { dieWith404("Record not found!"); } // show error message if no record found

I presume to also list my listings as well I need to add more code

I have tried to add the following :-

<?php header('Content-type: text/html; charset=utf-8'); ?>
<?php
  // load viewer library
  $libraryPath = 'cmsb/lib/viewer_functions.php';
  $dirsToCheck = array('/home/aplacein/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 record from 'listings'
  list($listingsRecords, $listingsMetaData) = getRecords(array(
    'tableName'   => 'listings',
    'where'       => whereRecordNumberInUrl(0),
    'loadUploads' => true,
    'allowSearch' => false,
    'limit'       => '1',
  ));
  $listingsRecord = @$listingsRecords[0]; // get first record
  if (!$listingsRecord) { dieWith404("Record not found!"); } // show error message if no record found

  list($likeRecords, $likeMetaData) = getRecords(array(
    'tableName' => 'listings', 
    'where' => "property_type ='".intval($listingsRecord['property_type'])."'", 
    'limit'       => '3',
    'loadUploads' => true,
    'allowSearch' => true,
));
?>

However this does not work and I can't seem to display any records.

I know the problem is with my "where" statement

    'where' => "property_type ='".intval($listingsRecord['property_type'])."'", 

If I take the "where" statement out I get 3 listings displayed on the page but with different "property_type" (as one would expect)

Please could you tell me how to write a "where" statement that will select the "property_type" value in the details page.

Thanks
Andy

I am running Program Version 3.02 (Build 2060)

Whilst in cmsAdmin I go to modify one of my listings and click the blue "Preview" at the top right of page. In Chrome I get the following error

---

This page isn’t working

Chrome detected unusual code on this page and blocked it to protect your personal information (for example, passwords, phone numbers and credit cards).

• Try visiting the site's homepage.

ERR_BLOCKED_BY_XSS_AUDITOR

---

However if I use Firefox, IE or Edge it works fine so I know my paths are OK. It looks like a Chrome issue on preview, have you come across this and is there a workaround?

Thanks

Andy

Fantastic thanks!

That worked, I am now able to output all three languages for Features - great news.

You can see a demo at http://www.sunsetjavea.com/property/listingDetail_test_esp.php?248 

Scroll down to features and you will see all 3 languages outputted (English, Spanish, French)

Thanks for your help with this Ross, this opens up many more possibilities for me and will make the Admin side far easier to update now I have Features in a separate table

Cheers

Andy

Thanks for this

I put the code in and changed the red to the correct values, however I am getting an error on the first line of your code:-

Warning: Invalid argument supplied for foreach() in /home/sunsetjavea/public_html/property/listingDetail_test_esp.php on line 299

If I put the :labels option in, it passes line 229 (first line of your code) and I get this error

mysql_get: second argument must be numeric or null, not 'BBQ area'!

This is what I would expect as we are looking for a "num" value here and we are picking up a label.

So what I deduce from this, is the first line of your code is not picking up the num value when I omit the :labels option.

Could you check your first line of code for me please.

Thanks

Andy

That would be great, look forward to hearing from you.

Kind regards

Andy

Yes I have details pages setup and attach for your reference.

listingDetail_test.php
listingDetail_test_esp.php
listingDetail_test_fra.php

You can view a property by going to:

http://www.sunsetjavea.com/property/listingDetail_test.php?248 
http://www.sunsetjavea.com/property/listingDetail_test_esp.php?248
http://www.sunsetjavea.com/property/listingDetail_test_fra.php?248

I have 2 fields setup for features

features (old list)
property_features (new list pulling data from Section Tablename features that I created as instructed)

The code on the page for features is on line 297

I have translated the features in the features table but not the rest of the page at this moment. However for testing purposes we should have enough to prove the features are working in the different languages.

I look forward to hearing from you and thanks again for your help with this.

Andy

Excellent! That worked perfectly! 

Please let me know the next steps.

Thanks for your help.

Andy

Thanks for your reply.

I think I understand where you are coming from and am keen to get this working so in answer to your question, yes I am happy for the features to be only listed in English.

So my questions are

1) I have created a new section as suggested called Features, and set it up with 3 fields called english, spanish, french as suggested. This has been set as a Multi Record is that correct?

2) I have created several records in the features section for each feature in the 3 languages. When I create a new list field in my listings section, how do I pull the values from the "Features" section?

3) On my details page, how do I do a lookup for each feature selected to get its name in the appropriate language? at the moment I display features as 

<?php echo join(', ', $listingsRecord['features:values']); ?>

Thanks for your help with this.

If I can get it working, it will open up new possibilities for me as I will be able to do the same for other list fields such as "Property Type", "Views", "Banner Status" etc.

I look forward to hearing from you.

Andy

I have a multilingual Website (3 languages) for a property Website and I use one section editor and create separate fileds for the languages for example for description I have 3 text boxes as follows

Field Label                                Field Name
Full Descriptiom (ENG)              description
Full Description (ESP)               esp_description
Full Description (FRA)               fra_descriprion

I then have 3 different HTML templates that I use depending on which country is selected.

However I also have a  features section that uses checkboxes (Multi Value) and I have 42 different options to select from as below.

Air-conditioning
Alarm system
BBQ area
BBQ
Central heating
Close to amenities
Communal garden
Covered parking
Double glazing
En-suite bathroom
Electric shutters
Fenced property
Fireplace
Furnished
Garage
Gated complex
Golf course views
Heating
Internet
Jacuzzi
Lift
No Community Fees
No Pets
Unfurnished
Off-road parking
Part furnished
Pets allowed
Pool view
Private driveway
Private garden
Roof terrace
Satellite TV
Sea view
Solar water heater
South facing
Storeroom
Summer Kitchen
Underfloor heating
Walking distance to beach
Window security grills
Window shutters
Wood burner

The problem is it is very time consuming for my client to enter features 3 times (for each language) as the list fields for each checkbox is one below the other.

Now I have the translations for all the features so ideally I want to be able to select the features on the English check boxes and this automatically pulls in the translation on the other checkboxes for the other 2 languages. Is there a way I can do that?

Alternatively, is there a way I can display the Features checkboxes side by side for each language so the client can just select each one on the same row without having to know the translation for the English word?

Any help or suggestions would be much appreciated.

Thanks
Andy

That looks pretty straight forward and could be exactly what I was looking for. I will give it a go.

As always great support!

Thanks again

Andy

I have a client that imports XML feeds into their listings database from 20 + other Agents.

The problem they are having is that there are a number of duplications on properties and it is possible to have listings showing several properties all the same but with different agent reference numbers.

We have written a dedupe type program that looks at 9 fields in the listings table (Town, Property Type, Price, Description, Bedrooms, Bathrooms, Sq Meters Build, Plot size, Pool) and produces a spreadsheet with a worksheet for each number of matches (9 matches, 8 matches etc.). This works well and we have a link in the spreadsheet so the client can view each property to see if it is definite duplication. (It is possible to have 9 matches and still be different as well as have 7 matches and be a duplication so there has to be a manual element involved for final checking)

We run this automatically after the weekly XML import, and  the system sends the client an email with the spreadsheet duplications ready for checking.

We want to increase the number of options on the spreadsheet so the client can not only use a link to view the property but also provide a link to delete the property. We have also added  functions so that we do not re import deleted properties the next time we import the XML feed (stored in a new Exclude database) and we also have a function to clean up the exclude database so that once a property no longer appears on the XML import we can remove from the exclude database.

All of this is working great except for the delete option. I have 2 questions:-

1) Is there a way we can use the functionality of the erase function in the CMS Admin/listings screen to erase/delete the record from outside the admin using a link on the spreadsheet?

2) Please confirm that the erase function in CMS Admin/listings screen, not only erases the record, but also erases any uploads associated with that record and erases any Permalinks associated with that record.

Thank you for your help.

Kind regards

Andy

I put the code in and tested with an invalid URL and the 404 page came up AND there was no error in the error log file in Admin.

All good - thanks for your excellent support!

Kind regards

Andy

Please find the file attached.

Kind regards

Andy

I have a listings Real Estate site using CMSB.

If a user enters a link such as http://www.comparedirect.eu/property/listingDetail.php?19435 they get the listing detail page up - good

However if they key in an invalid URL such as http://www.comparedirect.eu/property/listingDetail.php?194355 they get the 404 page not found which is correct - good

However I notice this produces an error in the CMS Admin error log - the error says:-

E_WARNING: Invalid argument supplied for foreach()
/home/comparedirect/public_html/property/listingDetail.php (line 163)
http://www.comparedirect.eu/property/listingDetail.php?194355

Should this happen? How can I prevent this showing up in the error log as it is a 404 page not found.

Kind regards

Andy

Fantastic, that did the trick!

Thanks for the great support and help.

Kind regards
Andy

I have a property website with the Permalinks plugin installed (I do not think this is relevant but thought it worth mentioning)

Some of my old listings are still indexed by Google, but the property in question has since been deleted. However when someone clicks on the link Google has -  http://www.comparedirect.eu/property/listingDetail.php?DO1615338-25479   they get a "Record not found!" error code.

My SEO person has said it would be better to handle this differently and asked could this not show a "404 page not found" error page instead (I have a custom 404 page setup and this works when going to a page not recognised but not when clicking the link from Google)

Thanks for your help.

Kind regards

Andy

Thanks for your reply, but when I pasted your code in I was getting a syntax error.

I removed the code marked in red below

<?php echo number_format($listing['price'], 2, ',', '.');) ?>

So I then had

<?php echo number_format($listing['price'], 2, ',', '.') ?>

and this worked as you indicated with 2 places after the decimal and a comma as the decimal separator and a period as the thousands separator, like this: 150.000,00

However I do not want the decimal places, I just want this to be displayed as 150.000

I therefore changed the code to

<?php echo number_format($listing['price'], 0, ',', '.') ?>

This seems to work great - can you see any problems with what I have done?

Thanks for your help Claire

Kind regards

Andy

I have a "price" field in my property listings section.

I enter values in in the cmsb admin like 150000 which then displays on my website as 150,000 which is what I want, so far so good.

I display the price using the following code:-

<?php echo number_format($listing['price']) ?>

However I have some French pages which uses the same "price" field from the listings section.

I want to be able to display the "price" field on these pages like 150.000 (European format)

Is there a different syntax I can use which would display the "price" field in this European Format.

Your help would be appreciated.

Thanks

Andy