US to UK

[musheg]

Hi Everybody, im trying to customize open realty to work in London, but im having trouble customizing some fields.

I managed to create the template as I need it, but i cant modify the listing_browse.php file. I want to change the way the listings show up. Also I want to change some of the fields that come up in the search results. Because they wont be needing a lot of the fields included like mls, zip code, state, etc.

Has anybody done this? or seen it somewere?

I would appreciate any help I can get.

Here is the url
http://www.justgota.com/~blixprop

I need to make it look like the attached pic

[AWT]

just delete out the code that shows the mls info both on the display and admin back end

you need to hack the code so you need abit of understanding of php to do this

[keystrokes247]

Here is one I have customised, if you need some pointers let me know, I have not hacked much of the code though, just changed the field titles in the amdin panel and linked it to a post code finder, have a play from the user aspect.

This site is LIVE Ashfield Properties so cannot give you access to admin.

Regards

Lloyd

[musheg]

Thanks Lloyd, your site looks good. I would like to use your mapping technique, and i'll try to modify those fields. Did you modify the search results look also?? can you help me a little further please?

a few more pointers would be great.

thanks,
MuSh

[awddesign]

Hi

Just let us know what you need to do and will post the codes
up for you.

Al

[keystrokes247]

Hi Mush

Here is the code for creating the link to Mapquest. The field name it uses for the post code is "Pcode", ewither rename the zip code field or create a new one, either way, ensure it is in this format or it will not work. Of course, you could alway amend the code below to reflect you field name.

<a href="http://www.mapquest.co.uk/cgi-bin/ia_find?link=btwn%2Ftwn-map_results&amp;random=1167&amp;event=find_search&amp;uid=u8na  _7e2slm3sapa%3A25lrt29y80&amp;country=Great+Britain&amp;SN  VData=&amp;address=&amp;city=&amp;Zip=<?php renderSingleListingItemNoCaption($listingID, "Pcode")  ?>&amp;Find+Map.x=35&amp;Find+Map.y=6" target="_blank"><strong>Look at a map of the area</strong></a>

I cannot take credit for the whole site, it is based upon a template found here and ALL of the features/mods have also come from this forum. I have done is used the code freely abvailable and put it together.

regards

Lloyd

[musheg]

Hi Al, what I cant to, which nobody has adressed yet is to change the colors of the table in the search results, i also want to show the picture in the right side. I found the code for the table properties, but the changes wouldnt show up. Im guessing that it is the style.php file which controls it.

Can somebody post this type of a code? or tell me where to find it.


thanks
MuSh

[awddesign]

Hi

most of the colours are at the fare bottom of the page..

$num_images = $recordSet2->RecordCount();
if ($num_images == 0)
{
echo "<center><table class=\"search_row_$count\" border=\"3\" cellspacing=\"0\" cellpadding=\"0\" width=\"580\" bordercolorlight=\"#C0C0C0\" bordercolordark=\"#808080\" bordercolor=\"#FFFFFF\" style=\"border-collapse: collapse\"><tr><td>";
echo "<table border=\"0\" cellspacing=\"0\" cellpadding=\"3\" width=\"580\" class=\"form_main\" style=\"border-collapse: collapse\"><tr><td rowspan=\"2\" align=\"left\" width=\"104\">";
echo "<a href=\"listingview.php?listingID=$current_ID\"><im g src=\"images/nophoto.gif\" border=\"1\" alt=\"Sorry, No Photo Available\"></a></td>";
}
while (!$recordSet2->EOF)
{
$thumb_file_name = make_db_unsafe ($recordSet2->fields[thumb_file_name]);
if ($thumb_file_name != "")
{
// gotta grab the image size
$imagedata = GetImageSize("$config[listings_upload_path]/$thumb_file_name");
$imagewidth = $imagedata[0];
$imageheight = $imagedata[1];
$shrinkage = $config[thumbnail_width]/$imagewidth;
$displaywidth = $imagewidth * $shrinkage;
$displayheight = $imageheight * $shrinkage;
echo "<center><table class=\"search_row_$count\" border=\"3\" cellspacing=\"0\" cellpadding=\"0\" width=\"580\" bordercolorlight=\"#C0C0C0\" bordercolordark=\"#808080\" bordercolor=\"#FFFFFF\" style=\"border-collapse: collapse\"><tr><td>";
echo "<table class=\"search_row_$count\" border=\"0\" cellspacing=\"0\" cellpadding=\"3\" width=\"580\" style=\"border-collapse: collapse\"><tr><td class=\"search_row_$count\" rowspan=\"2\" align=\"left\" width=\"5%\">";
echo "<a href=\"listingview.php?listingID=$current_ID\"><im g src=\"$config[listings_view_images_path]/$thumb_file_name\" height=\"$displayheight\" width=\"$displaywidth\" border=\"1\" alt=\"$thumb_file_name\"></a></td>";
} // end if ($thumb_file_name != "")
$recordSet2->MoveNext();
} // end while

// grab the rest of the listing's data
$sql2 = "SELECT " . $config[table_prefix] . "listingsDBElements.field_value, " . $config[table_prefix] . "listingsFormElements.field_name FROM " . $config[table_prefix] . "listingsDBElements, " . $config[table_prefix] . "listingsFormElements WHERE ((" . $config[table_prefix] . "listingsDBElements.listing_id = $current_ID) AND (" . $config[table_prefix] . "listingsDBElements.field_name = " . $config[table_prefix] . "listingsFormElements.field_name)) ORDER BY " . $config[table_prefix] . "listingsFormElements.rank";
$recordSet2 = $conn->Execute($sql2);
if ($recordSet2 === false)
{
log_error($sql2);
}
while (!$recordSet2->EOF)
{
if ($recordSet2->fields[field_name] == "price") { $price = $recordSet2->fields[field_value]; };
if ($recordSet2->fields[field_name] == "baths") { $baths = $recordSet2->fields[field_value]; };
if ($recordSet2->fields[field_name] == "beds") { $beds = $recordSet2->fields[field_value]; };
if ($recordSet2->fields[field_name] == "address") { $address = $recordSet2->fields[field_value]; };
if ($recordSet2->fields[field_name] == "city") { $city = $recordSet2->fields[field_value]; };
if ($recordSet2->fields[field_name] == "state") { $state = $recordSet2->fields[field_value]; };
if ($recordSet2->fields[field_name] == "zip") { $zip = $recordSet2->fields[field_value]; };
if ($recordSet2->fields[field_name] == "sq_feet") { $sq_feet = $recordSet2->fields[field_value]; };
if ($recordSet2->fields[field_name] == "full_desc") { $full_desc = $recordSet2->fields[field_value]; };
$priceformatted = international_num_format($price);
$preview = substr($full_desc, 0, 100);
$recordSet2->MoveNext();
} // end while

echo "<td class=\"search_row_$count\" align=\"left\" width=\"50%\" bordercolorlight=\"#FFFFFF\" bordercolordark=\"#FFFFFF\" valign=\"top\"><p align=\"left\"><a href=\"listingview.php?listingID=$current_ID\"><fo nt face=\"Arial,Helvetica,sans-serif\" size=\"2\"><b>$address</b></font></a><br><font face=\"Arial,Helvetica,sans-serif\" size=\"2\">$city, $state $zip</font>";
echo "<td class=\"search_row_$count\" rowspan=\"2\" align=\"right\" width=\"45%\" valign=\"top\"><p align=\"right\"><font face=\"Arial,Helvetica,sans-serif\" size=\"4\">";
Print("<b>".money_formats($priceformatted)."</b></font><br>");
echo "<font face=\"Arial,Helvetica,sans-serif\" size=\"2\">$beds Beds, $baths Baths<br>$sq_feet Sq. Ft.</font>";
echo "<br></tr>";
echo "<tr><td class=\"search_row_$count\" align=\"left\" width=\"50%\" bordercolorlight=\"#FFFFFF\" bordercolordark=\"#FFFFFF\" valign=\"top\">";
//Space for additional information in cell that appears below the Address, City & State
echo "</td></tr>";
echo "<tr><td class=\"search_row_$count\" align=\"left\" width=\"580\" colspan=\"3\"><font size=\"1\">$preview";

echo "... </font><b><font size=\"1\"><a href=\"listingview.php?listingID=$current_ID\">Mor e Info.</a></font></b></td></tr>";
echo "</table>";
echo "</td></tr></table><br>";
$resultRecordSet->MoveNext();
} // end while

echo "</center></center></td></tr></table>";
echo "<center>";
next_prev($num_rows, $cur_page, $guidestring_with_sort); // put in the next/previous stuff
echo "</center>";


$sql = "drop table IF EXISTS " . $config[table_prefix] . $SESSION_ID . "temp";
$recordSet = $conn->Execute($sql);
if (!$recordSet) log_error($sql);
?>


///////


Like this

bordercolorlight=\"#FFFFFF\" bordercolordark=\"#FFFFFF\"

just change them to what you want them too.
style.php is not setup for this , as it is a mod. My the Man Mick
################################################## #################
## MOD Title: New Listing Browse Layout for Open-Realty (http://www.open-realty.org)
## MOD Author: Mick G. <mick.73@sbcglobal.net>
## MOD Version: 032804
##
################################################## #################




The pic is on the left:: you want to move it to the right ??
http://www.justgota.com/~blixprop/li...Fitness+Center


Al

[musheg]

Hi Al, sorry it took me so long to reply, I was away for a while.

I implemented the the mod you suggested, and changed the border colors, but i am having trouble with the background color. Also i want to put the image on the right side, the address on a top left cell, and the description under the adress(title) and to the left of the image. I need to make it look exactly as the attached image i included in the first post.

here is the bg color i need to use: #7c1317


Please post the code if it is not too much trouble.

Thanks
MuSh