function replace_listing_field_tags($listing_id, $tempate_section = '', $utf8HTML = false) { global $lang; if (is_numeric($listing_id)) { global $config, $conn, $or_replace_listing_id, $or_replace_listing_owner; $or_replace_listing_id = $listing_id; require_once $config['basepath'] . '/include/listing.inc.php'; require_once $config['basepath'] . '/include/vtour.inc.php'; require_once $config['basepath'] . '/include/misc.inc.php'; $misc = new misc(); if ($tempate_section != '') { $tsection = true; } else { $tempate_section = $this->page; $tsection = false; } if ($utf8HTML) { //Deal with listing field blocks $lf_blocks = array(); preg_match_all('/{listing_field_([^{}]*?)_block}/', $tempate_section, $lf_blocks); require_once $config['basepath'] . '/include/user.inc.php'; global $or_replace_listing_owner; if (count($lf_blocks) > 1) { foreach ($lf_blocks[1] as $block) { require_once $config['basepath'] . '/include/listing.inc.php'; $value = listing_pages::renderSingleListingItem($or_replace_listing_id, $block, 'rawvalue'); if ($value == '') { $tempate_section = preg_replace('/{listing_field_' . $block . '_block}(.*?){\\/listing_field_' . $block . '_block}/is', '', $tempate_section); } else { $tempate_section = str_replace('{listing_field_' . $block . '_block}', '', $tempate_section); $tempate_section = str_replace('{/listing_field_' . $block . '_block}', '', $tempate_section); } } } // Handle Caption Only $tempate_section = preg_replace_callback('/{listing_field_([^{}]*?)_caption}/', create_function('$matches', 'global $config,$or_replace_listing_id,$lang;require_once($config[\'basepath\'].\'/include/listing.inc.php\'); return htmlentities(utf8_encode(listing_pages::renderSingleListingItem($or_replace_listing_id, $matches[1],\'caption\')), ENT_QUOTES, \'UTF-8\');'), $tempate_section); // Hanle Value Only $tempate_section = preg_replace_callback('/{listing_field_([^{}]*?)_value}/', create_function('$matches', 'global $config,$or_replace_listing_id,$lang;require_once($config[\'basepath\'].\'/include/listing.inc.php\'); return htmlentities(utf8_encode(listing_pages::renderSingleListingItem($or_replace_listing_id, $matches[1],\'value\')), ENT_QUOTES, \'UTF-8\');'), $tempate_section); // Handle Raw Value $tempate_section = preg_replace_callback('/{listing_field_([^{}]*?)_rawvalue}/', create_function('$matches', 'global $config,$or_replace_listing_id,$lang;require_once($config[\'basepath\'].\'/include/listing.inc.php\'); return htmlentities(utf8_encode(listing_pages::renderSingleListingItem($or_replace_listing_id, $matches[1],\'rawvalue\')), ENT_QUOTES, \'UTF-8\');'), $tempate_section); // Handle Both Caption and Value $tempate_section = preg_replace_callback('/{listing_field_([^{}]*?)}/', create_function('$matches', 'global $config,$or_replace_listing_id,$lang;require_once($config[\'basepath\'].\'/include/listing.inc.php\'); return htmlentities(utf8_encode(listing_pages::renderSingleListingItem($or_replace_listing_id, $matches[1])), ENT_QUOTES, \'UTF-8\');'), $tempate_section); $value = htmlentities(utf8_encode(listing_pages::get_title($listing_id)), ENT_QUOTES, 'UTF-8'); $tempate_section = str_replace('{listing_title}', $value, $tempate_section); $value = listing_pages::get_title($listing_id); if ($config["controlpanel_mbstring_enabled"] == 1) { if (mb_detect_encoding($value) != 'UTF-8') { $value = utf8_encode($value); } } $tempate_section = str_replace('{rss_listing_title}', $value, $tempate_section); $value = htmlentities(utf8_encode(listing_pages::getListingAgent($listing_id)), ENT_QUOTES, 'UTF-8'); $tempate_section = str_replace('{listing_agent_name}', $value, $tempate_section); $value = htmlentities(utf8_encode(listing_pages::getListingAgentFirstName($listing_id)), ENT_QUOTES, 'UTF-8'); $tempate_section = str_replace('{listing_agent_first_name}', $value, $tempate_section); $value = htmlentities(utf8_encode(listing_pages::getListingAgentLastName($listing_id)), ENT_QUOTES, 'UTF-8'); $tempate_section = str_replace('{listing_agent_last_name}', $value, $tempate_section); $value = htmlentities(utf8_encode(listing_pages::getListingAgentLink($listing_id)), ENT_QUOTES, 'UTF-8'); $tempate_section = str_replace('{listing_agent_link}', $value, $tempate_section); $value = htmlentities(utf8_encode(listing_pages::get_pclass($listing_id)), ENT_QUOTES, 'UTF-8'); $tempate_section = str_replace('{listing_pclass}', $value, $tempate_section); $value = htmlentities(utf8_encode(listing_pages::getAgentListingsLink($listing_id)), ENT_QUOTES, 'UTF-8'); $tempate_section = str_replace('{listing_agent_listings}', $value, $tempate_section); $value = htmlentities(utf8_encode(listing_pages::getListingAgentID($listing_id)), ENT_QUOTES, 'UTF-8'); $tempate_section = str_replace('{listing_agent_id}', $value, $tempate_section); // Get listing owner $owner_sql = 'SELECT userdb_id FROM ' . $config['table_prefix'] . 'listingsdb WHERE (listingsdb_id = ' . $or_replace_listing_id . ')'; $recordSet = $conn->execute($owner_sql); $or_replace_listing_owner = $recordSet->fields['userdb_id']; //New listing_agent_field_****_block tag handler for 2.4.1 $laf_blocks = array(); preg_match_all('/{listing_agent_field_([^{}]*?)_block}/', $tempate_section, $laf_blocks); require_once $config['basepath'] . '/include/user.inc.php'; global $or_replace_listing_owner; if (count($laf_blocks) > 1) { foreach ($laf_blocks[1] as $block) { $value = user::renderSingleListingItem($or_replace_listing_owner, $block, 'rawvalue'); if ($value == '') { $tempate_section = preg_replace('/{listing_agent_field_' . $block . '_block}(.*?){\\/listing_agent_field_' . $block . '_block}/is', '', $tempate_section); } else { $tempate_section = str_replace('{listing_agent_field_' . $block . '_block}', '', $tempate_section); $tempate_section = str_replace('{/listing_agent_field_' . $block . '_block}', '', $tempate_section); } } } // Replace listing_agent tags // Handle Caption Only $tempate_section = preg_replace_callback('/{listing_agent_field_([^{}]*?)_caption}/', create_function('$matches', 'global $config,$or_replace_listing_owner,$lang;require_once($config[\'basepath\'].\'/include/user.inc.php\'); return htmlentities(utf8_encode(user::renderSingleListingItem($or_replace_listing_owner, $matches[1],\'caption\')), ENT_QUOTES, \'UTF-8\');'), $tempate_section); // Hanle Value Only $tempate_section = preg_replace_callback('/{listing_agent_field_([^{}]*?)_value}/', create_function('$matches', 'global $config,$or_replace_listing_owner,$lang;require_once($config[\'basepath\'].\'/include/user.inc.php\'); return htmlentities(utf8_encode(user::renderSingleListingItem($or_replace_listing_owner, $matches[1],\'value\')), ENT_QUOTES, \'UTF-8\');'), $tempate_section); // Handle Raw Value $tempate_section = preg_replace_callback('/{listing_agent_field_([^{}]*?)_rawvalue}/', create_function('$matches', 'global $config,$or_replace_listing_owner,$lang;require_once($config[\'basepath\'].\'/include/user.inc.php\'); return htmlentities(utf8_encode(user::renderSingleListingItem($or_replace_listing_owner, $matches[1],\'rawvalue\')), ENT_QUOTES, \'UTF-8\');'), $tempate_section); // Handle Both Caption and Value $tempate_section = preg_replace_callback('/{listing_agent_field_([^{}]*?)}/', create_function('$matches', 'global $config,$or_replace_listing_owner,$lang;require_once($config[\'basepath\'].\'/include/user.inc.php\'); return htmlentities(utf8_encode(user::renderSingleListingItem($or_replace_listing_owner, $matches[1])), ENT_QUOTES, \'UTF-8\');'), $tempate_section); } else { //Deal with listing field blocks $lf_blocks = array(); preg_match_all('/{listing_field_([^{}]*?)_block}/', $tempate_section, $lf_blocks); require_once $config['basepath'] . '/include/user.inc.php'; global $or_replace_listing_owner; if (count($lf_blocks) > 1) { foreach ($lf_blocks[1] as $block) { require_once $config['basepath'] . '/include/listing.inc.php'; $value = listing_pages::renderSingleListingItem($or_replace_listing_id, $block, 'rawvalue'); if ($value == '') { $tempate_section = preg_replace('/{listing_field_' . $block . '_block}(.*?){\\/listing_field_' . $block . '_block}/is', '', $tempate_section); } else { $tempate_section = str_replace('{listing_field_' . $block . '_block}', '', $tempate_section); $tempate_section = str_replace('{/listing_field_' . $block . '_block}', '', $tempate_section); } } } // Handle Caption Only $tempate_section = preg_replace_callback('/{listing_field_([^{}]*?)_caption}/', create_function('$matches', 'global $config,$or_replace_listing_id,$lang;require_once($config[\'basepath\'].\'/include/listing.inc.php\'); return listing_pages::renderSingleListingItem($or_replace_listing_id, $matches[1],\'caption\');'), $tempate_section); // Hanle Value Only $tempate_section = preg_replace_callback('/{listing_field_([^{}]*?)_value}/', create_function('$matches', 'global $config,$or_replace_listing_id,$lang;require_once($config[\'basepath\'].\'/include/listing.inc.php\'); return listing_pages::renderSingleListingItem($or_replace_listing_id, $matches[1],\'value\');'), $tempate_section); // Handle Raw Value $tempate_section = preg_replace_callback('/{listing_field_([^{}]*?)_rawvalue}/', create_function('$matches', 'global $config,$or_replace_listing_id,$lang;require_once($config[\'basepath\'].\'/include/listing.inc.php\'); return listing_pages::renderSingleListingItem($or_replace_listing_id, $matches[1],\'rawvalue\');'), $tempate_section); // Handle Both Caption and Value $tempate_section = preg_replace_callback('/{listing_field_([^{}]*?)}/', create_function('$matches', 'global $config,$or_replace_listing_id,$lang;require_once($config[\'basepath\'].\'/include/listing.inc.php\'); return listing_pages::renderSingleListingItem($or_replace_listing_id, $matches[1]);'), $tempate_section); $value = listing_pages::get_title($listing_id); $tempate_section = str_replace('{listing_title}', $value, $tempate_section); $value = listing_pages::getListingAgent($listing_id); $tempate_section = str_replace('{listing_agent_name}', $value, $tempate_section); $value = listing_pages::getListingAgentFirstName($listing_id); $tempate_section = str_replace('{listing_agent_first_name}', $value, $tempate_section); $value = listing_pages::getListingAgentLastName($listing_id); $tempate_section = str_replace('{listing_agent_last_name}', $value, $tempate_section); $value = listing_pages::getListingAgentLink($listing_id); $tempate_section = str_replace('{listing_agent_link}', $value, $tempate_section); $value = listing_pages::get_pclass($listing_id); $tempate_section = str_replace('{listing_pclass}', $value, $tempate_section); $value = listing_pages::getAgentListingsLink($listing_id); $tempate_section = str_replace('{listing_agent_listings}', $value, $tempate_section); $value = listing_pages::getListingAgentID($listing_id); $tempate_section = str_replace('{listing_agent_id}', $value, $tempate_section); // Get listing owner $owner_sql = 'SELECT userdb_id FROM ' . $config['table_prefix'] . 'listingsdb WHERE (listingsdb_id = ' . $or_replace_listing_id . ')'; $recordSet = $conn->execute($owner_sql); $or_replace_listing_owner = $recordSet->fields['userdb_id']; $laf_blocks = array(); preg_match_all('/{listing_agent_field_([^{}]*?)_block}/', $tempate_section, $laf_blocks); require_once $config['basepath'] . '/include/user.inc.php'; global $or_replace_listing_owner; if (count($laf_blocks) > 1) { foreach ($laf_blocks[1] as $block) { $value = user::renderSingleListingItem($or_replace_listing_owner, $block, 'rawvalue'); if ($value == '') { $tempate_section = preg_replace('/{listing_agent_field_' . $block . '_block}(.*?){\\/listing_agent_field_' . $block . '_block}/is', '', $tempate_section); } else { $tempate_section = str_replace('{listing_agent_field_' . $block . '_block}', '', $tempate_section); $tempate_section = str_replace('{/listing_agent_field_' . $block . '_block}', '', $tempate_section); } } } // Replace listing_agent tags // Handle Caption Only $tempate_section = preg_replace_callback('/{listing_agent_field_([^{}]*?)_caption}/', create_function('$matches', 'global $config,$or_replace_listing_owner,$lang;require_once($config[\'basepath\'].\'/include/user.inc.php\'); return user::renderSingleListingItem($or_replace_listing_owner, $matches[1],\'caption\');'), $tempate_section); // Hanle Value Only $tempate_section = preg_replace_callback('/{listing_agent_field_([^{}]*?)_value}/', create_function('$matches', 'global $config,$or_replace_listing_owner,$lang;require_once($config[\'basepath\'].\'/include/user.inc.php\'); return user::renderSingleListingItem($or_replace_listing_owner, $matches[1],\'value\');'), $tempate_section); // Handle Raw Value $tempate_section = preg_replace_callback('/{listing_agent_field_([^{}]*?)_rawvalue}/', create_function('$matches', 'global $config,$or_replace_listing_owner,$lang;require_once($config[\'basepath\'].\'/include/user.inc.php\'); return user::renderSingleListingItem($or_replace_listing_owner, $matches[1],\'rawvalue\');'), $tempate_section); // Handle Both Caption and Value $tempate_section = preg_replace_callback('/{listing_agent_field_([^{}]*?)}/', create_function('$matches', 'global $config,$or_replace_listing_owner,$lang;require_once($config[\'basepath\'].\'/include/user.inc.php\'); return user::renderSingleListingItem($or_replace_listing_owner, $matches[1]);'), $tempate_section); } // Listing Images $sql2 = "SELECT listingsdb_title FROM " . $config['table_prefix'] . "listingsdb WHERE listingsdb_id = {$listing_id}"; $recordSet2 = $conn->Execute($sql2); if (!$recordSet2) { $misc->log_error($sql2); } $Title = $misc->make_db_unsafe($recordSet2->fields['listingsdb_title']); if ($config['url_style'] == '1') { $url = '<a href="index.php?action=listingview&listingID=' . $listing_id . '">'; $fullurl = '<a href="' . $config["baseurl"] . '/index.php?action=listingview&listingID=' . $listing_id . '">'; // Listing Link $tempate_section = str_replace('{link_to_listing}', 'index.php?action=listingview&listingID=' . $listing_id, $tempate_section); $tempate_section = str_replace('{fulllink_to_listing}', $config['baseurl'] . '/index.php?action=listingview&listingID=' . $listing_id, $tempate_section); } else { $url_title = str_replace("/", "", $Title); $url_title = strtolower(str_replace(" ", $config['seo_url_seperator'], $url_title)); $url = '<a href="listing-' . misc::urlencode_to_sef($url_title) . '-' . $listing_id . '.html">'; $fullurl = '<a href="' . $config["baseurl"] . '/listing-' . misc::urlencode_to_sef($url_title) . '-' . $listing_id . '.html">'; // Listing Link $tempate_section = str_replace('{link_to_listing}', 'listing-' . misc::urlencode_to_sef($url_title) . '-' . $listing_id . '.html', $tempate_section); $tempate_section = str_replace('{fulllink_to_listing}', '' . $config["baseurl"] . '/listing-' . misc::urlencode_to_sef($url_title) . '-' . $listing_id . '.html', $tempate_section); } // grab the listing's image $sql2 = "SELECT listingsimages_id, listingsimages_caption, listingsimages_thumb_file_name, listingsimages_file_name FROM " . $config['table_prefix'] . "listingsimages WHERE listingsdb_id = {$listing_id} ORDER BY listingsimages_rank"; $recordSet2 = $conn->Execute($sql2); if (!$recordSet2) { $misc->log_error($sql2); } $num_images = $recordSet2->RecordCount(); if ($num_images == 0) { if ($config['show_no_photo'] == 1) { $listing_image = $url . '<img src="' . $config["baseurl"] . '/images/nophoto.gif" alt="' . $lang['no_photo'] . '" /></a>'; $listing_image_full = $fullurl . '<img src="' . $config["baseurl"] . '/images/nophoto.gif" alt="' . $lang['no_photo'] . '" /></a>'; if ($_GET['action'] == 'listingview') { $listing_image = '<img src="' . $config["baseurl"] . '/images/nophoto.gif" alt="' . $lang['no_photo'] . '" />'; $listing_image_full = '<img src="' . $config["baseurl"] . '/images/nophoto.gif" alt="' . $lang['no_photo'] . '" />'; } $tempate_section = str_replace('{raw_image_thumb_1}', $config['baseurl'] . '/images/nophoto.gif', $tempate_section); } else { $listing_image = ''; $tempate_section = str_replace('{raw_image_thumb_1}', '', $tempate_section); } $tempate_section = str_replace('{image_thumb_1}', $listing_image, $tempate_section); $tempate_section = str_replace('{image_thumb_fullurl_1}', $listing_image, $tempate_section); } $x = 1; while (!$recordSet2->EOF) { //if we're already on the listing then make the urls goto the view image $listingsimages_id = $misc->make_db_unsafe($recordSet2->fields['listingsimages_id']); $image_caption = $misc->make_db_unsafe($recordSet2->fields['listingsimages_caption']); $thumb_file_name = $misc->make_db_unsafe($recordSet2->fields['listingsimages_thumb_file_name']); $full_file_name = $misc->make_db_unsafe($recordSet2->fields['listingsimages_file_name']); if ($_GET['action'] == 'listingview') { if ($config['url_style'] == '1') { $url = '<a href="index.php?action=view_listing_image&image_id=' . $listingsimages_id . '">'; $fullurl = '<a href="' . $config["baseurl"] . '/index.php?action=view_listing_image&image_id=' . $listingsimages_id . '">'; } else { $url = '<a href="listing_image_' . $listingsimages_id . '.html">'; $fullurl = '<a href="' . $config["baseurl"] . '/listing_image_' . $listingsimages_id . '.html">'; } } if ($thumb_file_name != "" && file_exists("{$config['listings_upload_path']}/{$thumb_file_name}")) { // Full Image Sizes $imagedata = GetImageSize("{$config['listings_upload_path']}/{$full_file_name}"); $imagewidth = $imagedata[0]; $imageheight = $imagedata[1]; $max_width = $config['main_image_width']; $max_height = $config['main_image_height']; $resize_by = $config['resize_by']; $shrinkage = 1; if ($max_width == $imagewidth || $max_height == $imageheight) { $display_width = $imagewidth; $display_height = $imageheight; } else { if ($resize_by == 'width') { $shrinkage = $imagewidth / $max_width; $display_width = $max_width; $display_height = round($imageheight / $shrinkage); } elseif ($resize_by == 'height') { $shrinkage = $imageheight / $max_height; $display_height = $max_height; $display_width = round($imagewidth / $shrinkage); } elseif ($resize_by == 'both') { $display_width = $max_width; $display_height = $max_height; } elseif ($resize_by == 'bestfit') { $shrinkage_width = $imagewidth / $max_width; $shrinkage_height = $imageheight / $max_height; $shrinkage = max($shrinkage_width, $shrinkage_height); $display_height = round($imageheight / $shrinkage); $display_width = round($imagewidth / $shrinkage); } } // Thumbnail Image Sizes $thumb_imagedata = GetImageSize("{$config['listings_upload_path']}/{$thumb_file_name}"); $thumb_imagewidth = $thumb_imagedata[0]; $thumb_imageheight = $thumb_imagedata[1]; $thumb_max_width = $config['thumbnail_width']; $thumb_max_height = $config['thumbnail_height']; $resize_thumb_by = $config['resize_thumb_by']; $shrinkage = 1; if ($thumb_max_width == $thumb_imagewidth || $thumb_max_height == $thumb_imageheight) { $thumb_displaywidth = $thumb_imagewidth; $thumb_displayheight = $thumb_imageheight; } else { if ($resize_thumb_by == 'width') { $shrinkage = $thumb_imagewidth / $thumb_max_width; $thumb_displaywidth = $thumb_max_width; $thumb_displayheight = round($thumb_imageheight / $shrinkage); } elseif ($resize_thumb_by == 'height') { $shrinkage = $thumb_imageheight / $thumb_max_height; $thumb_displayheight = $thumb_max_height; $thumb_displaywidth = round($thumb_imagewidth / $shrinkage); } elseif ($resize_thumb_by == 'both') { $thumb_displayheight = $thumb_max_height; $thumb_displaywidth = $thumb_max_width; } } $listing_image = $url . '<img src="' . $config['listings_view_images_path'] . '/' . $thumb_file_name . '" height="' . $thumb_displayheight . '" width="' . $thumb_displaywidth . '" alt="' . $image_caption . '" /></a>'; $listing_image_full = $url . '<img src="' . $config['listings_view_images_path'] . '/' . $full_file_name . '" height="' . $display_height . '" width="' . $display_width . '" alt="' . $image_caption . '" /></a>'; $listing_image_fullurl = $fullurl . '<img src="' . $config['listings_view_images_path'] . '/' . $thumb_file_name . '" height="' . $thumb_displayheight . '" width="' . $thumb_displaywidth . '" alt="' . $image_caption . '" /></a>'; $listing_image_full_fullurl = $fullurl . '<img src="' . $config['listings_view_images_path'] . '/' . $full_file_name . '" height="' . $display_height . '" width="' . $display_width . '" alt="' . $image_caption . '" /></a>'; $tempate_section = str_replace('{image_thumb_' . $x . '}', $listing_image, $tempate_section); $tempate_section = str_replace('{raw_image_thumb_' . $x . '}', $config['listings_view_images_path'] . '/' . $thumb_file_name, $tempate_section); $tempate_section = str_replace('{image_thumb_fullurl_' . $x . '}', $listing_image_fullurl, $tempate_section); //Full Image tags $tempate_section = str_replace('{image_full_' . $x . '}', $listing_image_full, $tempate_section); $tempate_section = str_replace('{raw_image_full_' . $x . '}', $config['listings_view_images_path'] . '/' . $full_file_name, $tempate_section); $tempate_section = str_replace('{image_full_fullurl_' . $x . '}', $listing_image_full_fullurl, $tempate_section); } else { if ($config['show_no_photo'] == 1) { $listing_image = $url . '<img src="' . $config["baseurl"] . '/images/nophoto.gif" alt="' . $lang['no_photo'] . '" /></a>'; $listing_image_fullurl = $fullurl . '<img src="' . $config["baseurl"] . '/images/nophoto.gif" alt="' . $lang['no_photo'] . '" /></a>'; $tempate_section = str_replace('{raw_image_thumb_' . $x . '}', $config['baseurl'] . '/images/nophoto.gif', $tempate_section); } else { $listing_image = ''; $tempate_section = str_replace('{raw_image_thumb_' . $x . '}', '', $tempate_section); } $tempate_section = str_replace('{image_thumb_' . $x . '}', $listing_image, $tempate_section); $tempate_section = str_replace('{image_thumb_fullurl_' . $x . '}', $listing_image_fullurl, $tempate_section); $tempate_section = str_replace('{image_full_' . $x . '}', '', $tempate_section); $tempate_section = str_replace('{raw_image_full_' . $x . '}', '', $tempate_section); $tempate_section = str_replace('{image_full_fullurl_' . $x . '}', '', $tempate_section); } // We have the image so insert it into the section. $x++; $recordSet2->MoveNext(); } // end while // End Listing Images $value = array(); $value = listing_pages::getListingAgentThumbnail($listing_id); $x = 0; foreach ($value as $y) { $tempate_section = str_replace('{listing_agent_thumbnail_' . $x . '}', $y, $tempate_section); $x++; } $tempate_section = preg_replace('/{listing_agent_thumbnail_([^{}]*?)}/', '', $tempate_section); // End of Listing Tag Replacement if ($tsection === true) { return $tempate_section; } else { $this->page = $tempate_section; } } }
public static function listing_next_prev() { global $config, $lang; $display = ''; $listingID = intval($_GET['listingID']); if (isset($_SERVER['HTTP_REFERER'])) { $pos = strpos($_SERVER['HTTP_REFERER'], 'search'); $pos1 = strpos($_SERVER['HTTP_REFERER'], 'listingview'); $pos2 = strpos($_SERVER['HTTP_REFERER'], 'view_listing_image'); $pos3 = strpos($_SERVER['HTTP_REFERER'], 'listing-'); $pos4 = strpos($_SERVER['HTTP_REFERER'], 'listing_image_'); if ($pos == "" && $pos1 == "" && $pos2 == "" && $pos3 == "" && $pos4 == "") { unset($_SESSION['results']); } if (isset($_SESSION['results'])) { $url = $_SESSION['searchstring']; $cur_page = $_SESSION['cur_page']; $url_with_page = $url . '&cur_page=' . $cur_page; $np_listings = $_SESSION['results']; $np_titles = $_SESSION['titles']; $i = 1; $array = ''; foreach ($np_listings as $np_listing) { $myarray[$i] = $np_listing; $i++; } $i = 1; $array = ''; foreach ($np_titles as $np_title) { $myarray2[$i] = misc::urlencode_to_sef($np_title); $i++; } if ($_SESSION['count'] > 1) { $display .= '<div class="next_prev_listing"><div class="count">' . $lang['there_are_currently'] . ' ' . $_SESSION['count'] . ' ' . $lang['that_match_search'] . '<br />' . $lang['navigate'] . '</div><ul>'; foreach ($myarray as $i => $item) { if ($item == $listingID) { //Show First and Previous Buttons if we are not on the first listing. if ($i != 1) { if ($config['url_style'] == '1') { $display .= '<li><a href="index.php?action=listingview&listingID=' . $myarray[1] . '" ><img src="' . $config["template_url"] . '/images/nextprev/first.png" alt="' . $lang['first'] . '" title="' . $lang['first'] . '" /></a></li><li><a href="index.php?action=listingview&listingID=' . $myarray[$i - 1] . '" ><img src="' . $config["template_url"] . '/images/nextprev/previous.png" alt="' . $lang['previous'] . '" title="' . $lang['previous'] . '" /></a></li>'; } else { $display .= '<li><a href="listing-' . $myarray2[1] . '-' . $myarray[1] . '.html" ><img src="' . $config["template_url"] . '/images/nextprev/first.png" alt="' . $lang['first'] . '" title="' . $lang['first'] . '" /></a></li><li><a href="listing-' . $myarray2[$i - 1] . '-' . $myarray[$i - 1] . '.html" ><img src="' . $config["template_url"] . '/images/nextprev/previous.png" alt="' . $lang['previous'] . '" title="' . $lang['previous'] . '" /></a></li>'; } } //Show Disabled Previous Button if we are on the first listing if ($i == 1) { $display .= '<li><img src="' . $config["template_url"] . '/images/nextprev/first_n.png" alt="' . $lang['first'] . '" title="' . $lang['first'] . '" /></li><li><img src="' . $config["template_url"] . '/images/nextprev/previous_n.png" alt="' . $lang['previous'] . '" title="' . $lang['previous'] . '" /></li>'; } //Show Refine Search and Save Search Buttons if the search string was not empty if (!empty($url)) { $display .= '<li><a href="index.php?action=searchresults' . $url_with_page . '" > <img src="' . $config["template_url"] . '/images/nextprev/search.png" alt="' . $lang['return_to_search'] . '" title="' . $lang['return_to_search'] . '" /></a></li><li><a href="index.php?action=save_search' . $url . '" ><img src="' . $config["template_url"] . '/images/nextprev/save.png" alt="' . $lang['save_this_search'] . '" title="' . $lang['save_this_search'] . '" /></a></li>'; } if (empty($url)) { $display .= '<li><a href="index.php?action=searchpage" ><img src="' . $config["template_url"] . '/images/nextprev/search.png" alt="' . $lang['refine_search'] . '" title="' . $lang['refine_search'] . '" /></a></li><li><a href="index.php?action=save_search' . $url . '" ><img src="' . $config["template_url"] . '/images/nextprev/save.png" alt="' . $lang['save_this_search'] . '" title="' . $lang['save_this_search'] . '" /></a></li>'; } //Show Next Last Buttons if we are not on the last Listing if ($i != $_SESSION['count']) { if ($config['url_style'] == '1') { $display .= '<li><a href="index.php?action=listingview&listingID=' . $myarray[$i + 1] . '" ><img src="' . $config["template_url"] . '/images/nextprev/next.png" alt="' . $lang['next'] . '" title="' . $lang['next'] . '" /></a></li><li><a href="index.php?action=listingview&listingID=' . $myarray[$_SESSION['count']] . '" ><img src="' . $config["template_url"] . '/images/nextprev/last.png" alt="' . $lang['last'] . '" title="' . $lang['last'] . '" /></a></li></ul><div class="listing_xy">' . $lang['next_prev_listing'] . ' ' . $i . ' ' . $lang['next_prev_of'] . ' ' . $_SESSION['count'] . '</div>'; } else { $display .= '<li><a href="listing-' . $myarray2[$i + 1] . '-' . $myarray[$i + 1] . '.html" ><img src="' . $config["template_url"] . '/images/nextprev/next.png" alt="' . $lang['next'] . '" title="' . $lang['next'] . '" /></a></li><li><a href="listing-' . $myarray2[$_SESSION['count']] . '-' . $myarray[$_SESSION['count']] . '.html" ><img src="' . $config["template_url"] . '/images/nextprev/last.png" alt="' . $lang['last'] . '" title="' . $lang['last'] . '" /></a></li></ul><div class="listing_xy">' . $lang['next_prev_listing'] . ' ' . $i . ' ' . $lang['next_prev_of'] . ' ' . $_SESSION['count'] . '</div>'; } } if ($i == $_SESSION['count']) { $display .= '<li><img src="' . $config["template_url"] . '/images/nextprev/next_n.png" alt="' . $lang['next'] . '" title="' . $lang['next'] . '" /></li><li><img src="' . $config["template_url"] . '/images/nextprev/last_n.png" alt="' . $lang['last'] . '" title="' . $lang['last'] . '" /></li></ul><div class="listing_xy">' . $lang['next_prev_listing'] . ' ' . $i . ' ' . $lang['next_prev_of'] . ' ' . $_SESSION['count'] . '</div>'; } } } $display .= '</div>'; } } } return $display; }
function userListings($user) { // produces the rest of the listings for users global $conn, $config, $lang; require_once $config['basepath'] . '/include/misc.inc.php'; $misc = new misc(); $display = ''; $user = $misc->make_db_extra_safe($user); $display .= '<strong>' . $lang['users_other_listings'] . '</strong>'; $sql = "SELECT listingsdb_id, listingsdb_title FROM " . $config['table_prefix'] . "listingsdb WHERE userdb_id = {$user} AND listingsdb_active = 'yes'"; $recordSet = $conn->SelectLimit($sql, 50, 0); if ($recordSet === false) { $misc->log_error($sql); } if ($recordSet->RecordCount() > 0) { $display .= '<ul>'; while (!$recordSet->EOF) { $ID = $misc->make_db_unsafe($recordSet->fields['listingsdb_id']); $Title = $misc->make_db_unsafe($recordSet->fields['listingsdb_title']); if ($config['url_style'] == '1') { $url = '<a href="index.php?action=listingview&listingID=' . $ID . '">'; } else { $url_title = str_replace("/", "", $Title); $url_title = strtolower(str_replace(" ", $config['seo_url_seperator'], $url_title)); $url = '<a href="listing-' . misc::urlencode_to_sef($url_title) . '-' . $ID . '.html">'; } $display .= '<li> ' . $url . $Title . '</a></li>'; $recordSet->MoveNext(); } $display .= '</ul>'; } return $display; }
/** * **************************************************************************\ * Open-Realty - search_results Function * * -------------------------------------------- * * This is the search_results function. The listing_browse page is called is* * also now a funciton called search_results_old * * \************************************************************************** */ function search_results($return_ids_only = false) { $DEBUG_SQL = FALSE; global $config, $conn, $lang, $current_ID, $db_type; require_once $config['basepath'] . '/include/misc.inc.php'; require_once $config['basepath'] . '/include/class/template/core.inc.php'; $misc = new misc(); $page = new page(); // Load any addons $addons = $page->load_addons(); $guidestring = ""; $guidestring_with_sort = ""; // Save GET // Deal with & still being in the URL foreach ($_GET as $k => $v) { if (strpos($k, 'amp;') !== false) { $new_k = str_replace('amp;', '', $k); $_GET[$new_k] = $v; unset($_GET[$k]); } } //Deal with googlebot double encoding URLS. foreach ($_GET as $k => $v) { if (strpos($k, '%5B%5D') !== false) { $new_k = str_replace('%5B%5D', '', $k); $_GET[$new_k][] = $v; unset($_GET[$k]); } } foreach ($_GET as $k => $v) { if ($v != '' && $k != 'listingID' && $k != 'cur_page' && $k != 'action' && $k != 'PHPSESSID' && $k != 'sortby' && $k != 'sorttype' && $k != 'printer_friendly' && $k != 'template') { if (is_array($v)) { foreach ($v as $vitem) { $guidestring .= '&' . urlencode("{$k}") . '[]=' . urlencode("{$vitem}"); } } else { $guidestring .= '&' . urlencode("{$k}") . '=' . urlencode("{$v}"); } } } $display = ''; // Now we get the GET and build our WHERE CLAUSE $searchresultSQL = ''; // Set ImageONly to False $imageonly = false; $vtoursonly = false; $tablelist = array(); $tablelist_fullname = array(); $postalcode_dist_lat = ''; $postalcode_dist_long = ''; $postalcode_dist_dist = ''; $latlong_dist_lat = ''; $latlong_dist_long = ''; $latlong_dist_dist = ''; $city_dist_lat = ''; $city_dist_long = ''; $city_dist_dist = ''; foreach ($_GET as $k => $v) { if ($k == "sortby") { $guidestring_with_sort = "{$k}={$v}"; } elseif ($k == "sorttype") { $guidestring_with_sort = "{$k}={$v}&"; } elseif ($k == 'PageID') { $searchresultSQL .= ''; } elseif ($k == "user_ID") { if ($v != '' && $v != 'Any Agent') { if (is_array($v)) { $sstring = ''; foreach ($v as $u) { $u = $misc->make_db_safe($u); if (empty($sstring)) { $sstring .= $config['table_prefix'] . 'listingsdb.userdb_id = ' . $u; } else { $sstring .= ' OR ' . $config['table_prefix'] . 'listingsdb.userdb_id = ' . $u; } } if ($searchresultSQL != '') { $searchresultSQL .= ' AND '; } $searchresultSQL .= '(' . $sstring . ')'; } else { $sql_v = $misc->make_db_safe($v); if ($searchresultSQL != '') { $searchresultSQL .= ' AND '; } $searchresultSQL .= '(' . $config['table_prefix'] . 'listingsdb.userdb_id = ' . $sql_v . ')'; } } } elseif ($k == "featuredOnly") { // $guidestring .= "&$k=$v"; if ($v == "yes") { if ($searchresultSQL != '') { $searchresultSQL .= ' AND '; } $searchresultSQL = $searchresultSQL . '(' . $config['table_prefix'] . 'listingsdb.listingsdb_featured = \'yes\')'; } } elseif ($k == 'pclass') { $class_sql = ''; foreach ($v as $class) { // Ignore non numberic values if (is_numeric($class)) { if (!empty($class_sql)) { $class_sql .= ' OR '; } $class_sql .= $config['table_prefix_no_lang'] . "classlistingsdb.class_id = {$class}"; } } if (!empty($class_sql)) { if ($searchresultSQL != '') { $searchresultSQL .= ' AND '; } $searchresultSQL = $searchresultSQL . '(' . $class_sql . ') AND ' . $config['table_prefix_no_lang'] . 'classlistingsdb.listingsdb_id = ' . $config['table_prefix'] . 'listingsdb.listingsdb_id'; $tablelist_fullname[] = $config['table_prefix_no_lang'] . "classlistingsdb"; } } elseif ($k == "listing_id") { $listing_id = explode(',', $v); $i = 0; if ($searchresultSQL != '') { $searchresultSQL .= ' AND '; } foreach ($listing_id as $id) { $id = $misc->make_db_safe($id); if ($i == 0) { $searchresultSQL .= '((' . $config['table_prefix'] . 'listingsdb.listingsdb_id = ' . $id . ')'; } else { $searchresultSQL .= ' OR (' . $config['table_prefix'] . 'listingsdb.listingsdb_id = ' . $id . ')'; } $i++; } $searchresultSQL .= ')'; } elseif ($k == "imagesOnly") { // Grab only listings with images if that is what we need. if ($v == "yes") { $imageonly = true; } } elseif ($k == "vtoursOnly") { // Grab only listings with images if that is what we need. if ($v == "yes") { $vtoursonly = true; } } elseif ($k == 'listing_last_modified_equal') { if ($searchresultSQL != '') { $searchresultSQL .= ' AND '; } $safe_v = $conn->DBTimeStamp($v); $searchresultSQL .= " listingsdb_last_modified = {$safe_v}"; //listingsdb_last_modified } elseif ($k == 'listing_last_modified_greater') { if ($searchresultSQL != '') { $searchresultSQL .= ' AND '; } $safe_v = $conn->DBTimeStamp($v); $searchresultSQL .= " listingsdb_last_modified > {$safe_v}"; //listingsdb_last_modified } elseif ($k == 'listing_last_modified_less') { if ($searchresultSQL != '') { $searchresultSQL .= ' AND '; } $safe_v = $conn->DBTimeStamp($v); $searchresultSQL .= " listingsdb_last_modified < {$safe_v}"; //listingsdb_last_modified } elseif ($k == 'latlong_dist_lat' || $k == 'latlong_dist_long' || $k == 'latlong_dist_dist' && $v != '') { switch ($k) { case 'latlong_dist_lat': $latlong_dist_lat = $v; break; case 'latlong_dist_long': $latlong_dist_long = $v; break; case 'latlong_dist_dist': $latlong_dist_dist = $v; break; } } elseif ($k == 'postalcode_dist_code' && $v != '') { $postalcode = $misc->make_db_safe($v); $sql = 'SELECT zipdist_latitude, zipdist_longitude FROM ' . $config['table_prefix_no_lang'] . 'zipdist WHERE zipdist_zipcode =' . $postalcode; $postalcode_recordSet = $conn->Execute($sql); if ($postalcode_recordSet === false) { $misc->log_error($sql); } $postalcode_dist_lat = $misc->make_db_unsafe($postalcode_recordSet->fields['zipdist_latitude']); $postalcode_dist_long = $misc->make_db_unsafe($postalcode_recordSet->fields['zipdist_longitude']); } elseif ($k == 'postalcode_dist_dist' && $v != '') { $postalcode_dist_dist = $v; } elseif ($k == 'city_dist_code' && $v != '') { $city = $misc->make_db_safe($v); $sql = 'SELECT zipdist_latitude, zipdist_longitude FROM ' . $config['table_prefix_no_lang'] . 'zipdist WHERE zipdist_cityname =' . $city; $city_recordSet = $conn->Execute($sql); if ($city_recordSet === false) { $misc->log_error($sql); } $city_dist_lat = $misc->make_db_unsafe($city_recordSet->fields['zipdist_latitude']); $city_dist_long = $misc->make_db_unsafe($city_recordSet->fields['zipdist_longitude']); } elseif ($k == 'city_dist_dist' && $v != '') { $city_dist_dist = $v; } elseif ($v != '' && $k != 'listingID' && $k != 'postalcode_dist_code' && $k != 'postalcode_dist_dist' && $k != 'city_dist_code' && $k != 'city_dist_dist' && $k != 'latlong_dist_lat' && $k != 'latlong_dist_long' && $k != 'latlong_dist_dist' && $k != 'cur_page' && $k != 'action' && $k != 'PHPSESSID' && $k != 'sortby' && $k != 'sorttype' && $k != 'printer_friendly' && $k != 'template' && $k != 'pclass' && $k != 'listing_last_modified_less' && $k != 'listing_last_modified_equal' && $k != 'listing_last_modified_greater') { if (!is_array($v)) { if ($searchresultSQL != '') { $searchresultSQL .= ' AND '; } //Handle NULL/NOTNULL Searches if (substr($k, -5) == '-NULL' && $v == '1') { $subk = substr($k, 0, -5); $searchresultSQL .= "(`{$subk}`.listingsdbelements_field_name = '{$subk}' AND (`{$subk}`.listingsdbelements_field_value IS NULL OR `{$subk}`.listingsdbelements_field_value = ''))"; if (!in_array($subk, $tablelist)) { $tablelist[] = $subk; } } elseif (substr($k, -8) == '-NOTNULL' && $v == '1') { $subk = substr($k, 0, -8); $searchresultSQL .= "(`{$subk}`.listingsdbelements_field_name = '{$subk}' AND (`{$subk}`.listingsdbelements_field_value IS NOT NULL AND `{$subk}`.listingsdbelements_field_value <> ''))"; if (!in_array($subk, $tablelist)) { $tablelist[] = $subk; } } elseif (substr($k, -4) == '-max') { $subk = substr($k, 0, -4); if ($db_type == 'mysql') { $searchresultSQL .= "(`{$subk}`.listingsdbelements_field_name = '{$subk}' AND CAST(`{$subk}`.listingsdbelements_field_value as signed) <= '{$v}')"; } else { $searchresultSQL .= "(`{$subk}`.listingsdbelements_field_name = '{$subk}' AND CAST(`{$subk}`.listingsdbelements_field_value as int4) <= '{$v}')"; } if (!in_array($subk, $tablelist)) { $tablelist[] = $subk; } } else { if (substr($k, -4) == '-min') { $subk = substr($k, 0, -4); if ($db_type == 'mysql') { $searchresultSQL .= "(`{$subk}`.listingsdbelements_field_name = '{$subk}' AND CAST(`{$subk}`.listingsdbelements_field_value as signed) >= '{$v}')"; } else { $searchresultSQL .= "(`{$subk}`.listingsdbelements_field_name = '{$subk}' AND CAST(`{$subk}`.listingsdbelements_field_value as int4) >= '{$v}')"; } if (!in_array($subk, $tablelist)) { $tablelist[] = $subk; } } elseif (substr($k, -8) == '-maxdate') { if ($config['date_format'] == 1) { $format = "%m/%d/%Y"; } elseif ($config['date_format'] == 2) { $format = "%Y/%d/%m"; } elseif ($config['date_format'] == 3) { $format = "%d/%m/%Y"; } $v = $misc->parseDate($v, $format); $subk = urldecode(substr($k, 0, -8)); $searchresultSQL .= "(`{$subk}`.listingsdbelements_field_name = '{$subk}' AND `{$subk}`.listingsdbelements_field_value <= '{$v}')"; if (!in_array($subk, $tablelist)) { $tablelist[] = $subk; } } else { if (substr($k, -8) == '-mindate') { if ($config['date_format'] == 1) { $format = "%m/%d/%Y"; } elseif ($config['date_format'] == 2) { $format = "%Y/%d/%m"; } elseif ($config['date_format'] == 3) { $format = "%d/%m/%Y"; } $v = $misc->parseDate($v, $format); $subk = urldecode(substr($k, 0, -8)); $searchresultSQL .= "(`{$subk}`.listingsdbelements_field_name = '{$subk}' AND `{$subk}`.listingsdbelements_field_value >= '{$v}')"; if (!in_array($subk, $tablelist)) { $tablelist[] = $subk; } } else { if (substr($k, -5) == '-date') { if ($config['date_format'] == 1) { $format = "%m/%d/%Y"; } elseif ($config['date_format'] == 2) { $format = "%Y/%d/%m"; } elseif ($config['date_format'] == 3) { $format = "%d/%m/%Y"; } $v = $misc->parseDate($v, $format); $subk = urldecode(substr($k, 0, -5)); $searchresultSQL .= "(`{$subk}`.listingsdbelements_field_name = '{$subk}' AND `{$subk}`.listingsdbelements_field_value = '{$v}')"; if (!in_array($subk, $tablelist)) { $tablelist[] = $subk; } } elseif ($k == 'searchtext') { $safe_v = addslashes($v); $searchresultSQL .= "((`{$k}`.listingsdbelements_field_value like '%{$safe_v}%') OR (listingsdb_title like '%{$safe_v}%'))"; $tablelist[] = $k; } else { $safe_v = $misc->make_db_safe($v); $searchresultSQL .= "(`{$k}`.listingsdbelements_field_name = '{$k}' AND `{$k}`.listingsdbelements_field_value = {$safe_v})"; $tablelist[] = $k; } } } } } else { // Make Sure Array is not empty $use = false; $comma_separated = implode(" ", $v); if (trim($comma_separated) != '') { $use = true; if ($searchresultSQL != '') { $searchresultSQL .= ' AND '; } } if ($use === true) { if (substr($k, -3) == '_or') { $k = substr($k, 0, strlen($k) - 3); $safe_k = addslashes($k); $searchresultSQL .= "(`{$safe_k}`.listingsdbelements_field_name = '{$safe_k}' AND ("; $vitem_count = 0; foreach ($v as $vitem) { $safe_vitem = addslashes($vitem); if ($vitem != '') { if ($vitem_count != 0) { $searchresultSQL .= " OR `{$safe_k}`.listingsdbelements_field_value LIKE '%{$safe_vitem}%'"; } else { $searchresultSQL .= " `{$safe_k}`.listingsdbelements_field_value LIKE '%{$safe_vitem}%'"; } $vitem_count++; } } $searchresultSQL .= "))"; $tablelist[] = $safe_k; } else { $safe_k = addslashes($k); $searchresultSQL .= "(`{$safe_k}`.listingsdbelements_field_name = '{$safe_k}' AND ("; $vitem_count = 0; foreach ($v as $vitem) { $safe_vitem = addslashes($vitem); if ($vitem != '') { if ($vitem_count != 0) { $searchresultSQL .= " AND `{$safe_k}`.listingsdbelements_field_value LIKE '%{$safe_vitem}%'"; } else { $searchresultSQL .= " `{$safe_k}`.listingsdbelements_field_value LIKE '%{$safe_vitem}%'"; } $vitem_count++; } } $searchresultSQL .= "))"; $tablelist[] = $safe_k; } } } } } if ($postalcode_dist_lat != '' && $postalcode_dist_long != '' && $postalcode_dist_dist != '') { $sql = "SELECT zipdist_zipcode FROM {$config['table_prefix_no_lang']}zipdist WHERE (POW((69.1*(zipdist_longitude-\"{$postalcode_dist_long}\")*cos({$postalcode_dist_lat}/57.3)),\"2\")+POW((69.1*(zipdist_latitude-\"{$postalcode_dist_lat}\")),\"2\"))<({$postalcode_dist_dist}*{$postalcode_dist_dist}) "; $recordSet = $conn->Execute($sql); if (!$recordSet) { $misc->log_error($sql); } $zipcodes = array(); while (!$recordSet->EOF) { $zipcodes[] = $recordSet->fields['zipdist_zipcode']; $recordSet->MoveNext(); } $pc_field_name = $config["map_zip"]; // Build Search Query // Make Sure Array is not empty $use = false; $comma_separated = implode(" ", $zipcodes); if (trim($comma_separated) != '') { $use = true; if ($searchresultSQL != '') { $searchresultSQL .= ' AND '; } } if ($use === true) { $searchresultSQL .= "(`{$pc_field_name}`.listingsdbelements_field_name = '{$pc_field_name}' AND ("; $vitem_count = 0; foreach ($zipcodes as $vitem) { $safe_vitem = addslashes($vitem); if ($vitem != '') { if ($vitem_count != 0) { $searchresultSQL .= " OR `{$pc_field_name}`.listingsdbelements_field_value = '{$save_vitem}'"; } else { $searchresultSQL .= " `{$pc_field_name}`.listingsdbelements_field_value = '{$safe_vitem}'"; } $vitem_count++; } } $searchresultSQL .= "))"; $tablelist[] = $pc_field_name; } } if ($city_dist_lat != '' && $city_dist_long != '' && $city_dist_dist != '') { $sql = "SELECT zipdist_zipcode FROM {$config['table_prefix_no_lang']}zipdist WHERE (POW((69.1*(zipdist_longitude-\"{$city_dist_long}\")*cos({$city_dist_lat}/57.3)),\"2\")+POW((69.1*(zipdist_latitude-\"{$city_dist_lat}\")),\"2\"))<({$city_dist_dist}*{$city_dist_dist}) "; $recordSet = $conn->Execute($sql); if (!$recordSet) { $misc->log_error($sql); } $zipcodes = array(); while (!$recordSet->EOF) { $zipcodes[] = $recordSet->fields['zipdist_zipcode']; $recordSet->MoveNext(); } $pc_field_name = $config["map_zip"]; // Build Search Query // Make Sure Array is not empty $use = false; $comma_separated = implode(" ", $zipcodes); if (trim($comma_separated) != '') { $use = true; if ($searchresultSQL != '') { $searchresultSQL .= ' AND '; } } if ($use === true) { $searchresultSQL .= "(`{$pc_field_name}`.listingsdbelements_field_name = '{$pc_field_name}' AND ("; $vitem_count = 0; foreach ($zipcodes as $vitem) { $safe_vitem = addslashes($vitem); if ($vitem != '') { if ($vitem_count != 0) { $searchresultSQL .= " OR `{$pc_field_name}`.listingsdbelements_field_value = '{$safe_vitem}'"; } else { $searchresultSQL .= " `{$pc_field_name}`.listingsdbelements_field_value = '{$safe_vitem}'"; } $vitem_count++; } } $searchresultSQL .= "))"; $tablelist[] = $pc_field_name; } } //Lat Long Distance if ($latlong_dist_lat != '' && $latlong_dist_long != '' && $latlong_dist_dist != '') { /* max_lon = lon1 + arcsin(sin(D/R)/cos(lat1)) min_lon = lon1 - arcsin(sin(D/R)/cos(lat1)) max_lat = lat1 + (180/pi)(D/R) min_lat = lat1 - (180/pi)(D/R) */ //$max_long = $latlong_dist_long + asin(sin($latlong_dist_dist/3956)/cos($latlong_dist_lat)); //$min_long = $latlong_dist_long - asin(sin($latlong_dist_dist/3956)/cos($latlong_dist_lat)); //$max_lat = $latlong_dist_lat + (180/pi())*($latlong_dist_dist/3956); //$min_lat = $latlong_dist_lat - (180/pi())*($latlong_dist_dist/3956); /* Latitude: Apparently a degree of latitude expressed in miles does vary slighty by latitude (http://www.ncgia.ucsb.edu/education/curricula/giscc/units/u014/tables/table01.html) but for our purposes, I suggest we use 1 degree latitude = 69 miles. Longitude: This is more tricky one since it varies by latitude (http://www.ncgia.ucsb.edu/education/curricula/giscc/units/u014/tables/table02.html). The simplest formula seems to be: 1 degree longitude expressed in miles = cos (latitude) * 69.17 miles */ //Get Correct Milage for ong based on lat. $cos_long = 69.17; if ($latlong_dist_lat >= 10) { $cos_long = 68.13; } if ($latlong_dist_lat >= 20) { $cos_long = 65.03; } if ($latlong_dist_lat >= 30) { $cos_long = 59.95; } if ($latlong_dist_lat >= 40) { $cos_long = 53.06; } if ($latlong_dist_lat >= 50) { $cos_long = 44.55; } if ($latlong_dist_lat >= 60) { $cos_long = 34.67; } if ($latlong_dist_lat >= 70) { $cos_long = 23.73; } if ($latlong_dist_lat >= 80) { $cos_long = 12.05; } if ($latlong_dist_lat >= 90) { $cos_long = 0; } $max_long = $latlong_dist_long + $latlong_dist_dist / (cos(deg2rad($latlong_dist_lat)) * $cos_long); $min_long = $latlong_dist_long - $latlong_dist_dist / (cos(deg2rad($latlong_dist_lat)) * $cos_long); $max_lat = $latlong_dist_lat + $latlong_dist_dist / 69; $min_lat = $latlong_dist_lat - $latlong_dist_dist / 69; // if ($max_lat < $min_lat) { $max_lat2 = $min_lat; $min_lat = $max_lat; $max_lat = $max_lat2; } if ($max_long < $min_long) { $max_long2 = $min_long; $min_long = $max_long; $max_long = $max_long2; } // Lat and Long Fields $sql = "SELECT listingsformelements_field_name FROM " . $config['table_prefix'] . "listingsformelements WHERE listingsformelements_field_type = 'lat'"; $recordSet = $conn->Execute($sql); if (!$recordSet) { $misc->log_error($sql); } $lat_field = $recordSet->fields['listingsformelements_field_name']; $sql = "SELECT listingsformelements_field_name FROM " . $config['table_prefix'] . "listingsformelements WHERE listingsformelements_field_type = 'long'"; $recordSet = $conn->Execute($sql); if (!$recordSet) { $misc->log_error($sql); } $long_field = $recordSet->fields['listingsformelements_field_name']; if ($lat_field != '' & $long_field != '') { $tablelist[] = $lat_field; $tablelist[] = $long_field; if ($searchresultSQL != '') { $searchresultSQL .= ' AND '; } $searchresultSQL .= "(`{$lat_field}`.listingsdbelements_field_name = '{$lat_field}' AND `{$lat_field}`.listingsdbelements_field_value+0 <= '{$max_lat}')"; if ($searchresultSQL != '') { $searchresultSQL .= ' AND '; } $searchresultSQL .= "(`{$lat_field}`.listingsdbelements_field_name = '{$lat_field}' AND `{$lat_field}`.listingsdbelements_field_value+0 >= '{$min_lat}')"; if ($searchresultSQL != '') { $searchresultSQL .= ' AND '; } $searchresultSQL .= "(`{$long_field}`.listingsdbelements_field_name = '{$long_field}' AND `{$long_field}`.listingsdbelements_field_value+0 <= '{$max_long}')"; if ($searchresultSQL != '') { $searchresultSQL .= ' AND '; } $searchresultSQL .= "(`{$long_field}`.listingsdbelements_field_name = '{$long_field}' AND `{$long_field}`.listingsdbelements_field_value+0 >= '{$min_long}')"; } } // Handle Sorting // sort the listings // this is the main SQL that grabs the listings // basic sort by title.. $group_order_text = ''; $sortby = ''; $sorttype = ''; if ($config["special_sortby"] != 'none') { $sortby = $config["special_sortby"] . ','; $sorttype = $config["special_sorttype"] . ','; } if (!isset($_GET['sortby'])) { $_GET['sortby'] = $config["sortby"]; } if (!isset($_GET['sorttype'])) { $_GET['sorttype'] = $config["sorttype"]; } $sortby .= $_GET['sortby']; $sorttype .= $_GET['sorttype']; $sql_sort_type = ''; $sortby_array = explode(',', $sortby); $sorttype_array = explode(',', $sorttype); $sort_text = ''; $order_text = ''; $group_order_text = ''; $tablelist_nosort = $tablelist; $sort_count = count($sortby_array); for ($x = 0; $x < $sort_count; $x++) { //make sure user input is sanitized before adding to query string $sortby_array[$x] = $misc->sanitize($sortby_array[$x]); $sorttype_array[$x] = $misc->sanitize($sorttype_array[$x], 4); //limit length to 4 characters as sorttype can only be ASC or DESC if ($sorttype_array[$x] != 'ASC' && $sorttype_array[$x] != 'DESC') { $sorttype_array[$x] = ''; } if ($sortby_array[$x] == 'listingsdb_id') { if ($x == 0) { $order_text .= 'ORDER BY listingsdb_id ' . $sorttype_array[$x]; } else { $order_text .= ',listingsdb_id ' . $sorttype_array[$x]; } } elseif ($sortby_array[$x] == 'listingsdb_title') { if ($x == 0) { $order_text .= 'ORDER BY listingsdb_title ' . $sorttype_array[$x]; } else { $order_text .= ',listingsdb_title ' . $sorttype_array[$x]; } } elseif ($sortby_array[$x] == 'random') { if ($x == 0) { $order_text .= 'ORDER BY rand() ' . $sorttype_array[$x]; } else { $order_text .= ',rand() ' . $sorttype_array[$x]; } } elseif ($sortby_array[$x] == 'listingsdb_featured') { if ($x == 0) { $order_text .= 'ORDER BY listingsdb_featured ' . $sorttype_array[$x]; } else { $order_text .= ',listingsdb_featured ' . $sorttype_array[$x]; } } elseif ($sortby_array[$x] == 'listingsdb_last_modified') { if ($x == 0) { $order_text .= 'ORDER BY listingsdb_last_modified ' . $sorttype_array[$x]; } else { $order_text .= ',listingsdb_last_modified ' . $sorttype_array[$x]; } } elseif ($sortby_array[$x] == 'pclass') { if ($searchresultSQL != '') { $searchresultSQL .= ' AND '; } $searchresultSQL .= $config['table_prefix_no_lang'] . 'classlistingsdb.listingsdb_id = ' . $config['table_prefix'] . 'listingsdb.listingsdb_id AND ' . $config['table_prefix_no_lang'] . 'classlistingsdb.class_id = ' . $config['table_prefix'] . 'class.class_id '; $tablelist_fullname[] = $config['table_prefix_no_lang'] . "classlistingsdb"; $tablelist_fullname[] = $config['table_prefix'] . 'class'; if ($x == 0) { $order_text .= 'ORDER BY ' . $config['table_prefix'] . 'class.class_name ' . $sorttype_array[$x]; } else { $order_text .= ',' . $config['table_prefix'] . 'class.class_name ' . $sorttype_array[$x]; } } else { // Check if field is a number or price field and cast the order. $sort_by_field = $misc->make_db_extra_safe($sortby_array[$x]); $sql_sort_type = 'SELECT listingsformelements_field_type FROM ' . $config['table_prefix'] . 'listingsformelements WHERE listingsformelements_field_name = ' . $sort_by_field; $recordSet_sort_type = $conn->Execute($sql_sort_type); if (!$recordSet_sort_type) { $misc->log_error($sql_sort_type); } $field_type = $recordSet_sort_type->fields['listingsformelements_field_type']; if ($field_type == 'price' || $field_type == 'number' || $field_type == 'decimal') { $tablelist[] = 'sort' . $x; $sort_text .= 'AND (sort' . $x . '.listingsdbelements_field_name = ' . $sort_by_field . ') '; global $db_type; if ($db_type == 'mysql') { if ($x == 0) { $order_text .= ' ORDER BY CAST(sort' . $x . '.listingsdbelements_field_value as signed) ' . $sorttype_array[$x]; $group_order_text .= ',sort' . $x . '.listingsdbelements_field_value'; } else { $order_text .= ',CAST(sort' . $x . '.listingsdbelements_field_value as signed) ' . $sorttype_array[$x]; $group_order_text .= ',sort' . $x . '.listingsdbelements_field_value'; } } else { if ($x == 0) { $order_text .= ' ORDER BY CAST(sort' . $x . '.listingsdbelements_field_value as int4) ' . $sorttype_array[$x]; $group_order_text .= ',sort' . $x . '.listingsdbelements_field_value'; } else { $order_text .= ',CAST(sort' . $x . '.listingsdbelements_field_value as int4) ' . $sorttype_array[$x]; $group_order_text .= ',sort' . $x . '.listingsdbelements_field_value'; } } } else { $tablelist[] = 'sort' . $x; $sort_text .= 'AND (sort' . $x . '.listingsdbelements_field_name = ' . $sort_by_field . ') '; if ($x == 0) { $order_text .= ' ORDER BY sort' . $x . '.listingsdbelements_field_value ' . $sorttype_array[$x]; } else { $order_text .= ', sort' . $x . '.listingsdbelements_field_value ' . $sorttype_array[$x]; } $group_order_text .= ',sort' . $x . '.listingsdbelements_field_value'; } } } $group_order_text = $group_order_text . ' ' . $order_text; if ($imageonly == true || $vtoursonly == true) { $order_text = "GROUP BY " . $config['table_prefix'] . "listingsdb.listingsdb_id, " . $config['table_prefix'] . "listingsdb.listingsdb_title " . $group_order_text; } if ($DEBUG_SQL) { echo '<strong>Sort Type SQL:</strong> ' . $sql_sort_type . '<br />'; echo '<strong>Sort Text:</strong> ' . $sort_text . '<br />'; echo '<strong>Order Text:</strong> ' . $order_text . '<br />'; } $guidestring_with_sort = $guidestring_with_sort . $guidestring; // End of Sort $arrayLength = count($tablelist); if ($DEBUG_SQL) { echo '<strong>Table List Array Length:</strong> ' . $arrayLength . '<br />'; } $string_table_list = ''; for ($i = 0; $i < $arrayLength; $i++) { $string_table_list .= ' ,' . $config['table_prefix'] . 'listingsdbelements `' . $tablelist[$i] . '`'; } $arrayLength = count($tablelist_nosort); $string_table_list_no_sort = ''; for ($i = 0; $i < $arrayLength; $i++) { $string_table_list_no_sort .= ' ,' . $config['table_prefix'] . 'listingsdbelements `' . $tablelist[$i] . '`'; } $arrayLength = count($tablelist_fullname); if ($DEBUG_SQL) { echo '<strong>Table List Array Length:</strong> ' . $arrayLength . '<br />'; } for ($i = 0; $i < $arrayLength; $i++) { $string_table_list .= ' ,' . $tablelist_fullname[$i]; $string_table_list_no_sort .= ' ,' . $tablelist_fullname[$i]; } if ($DEBUG_SQL) { echo '<strong>Table List String:</strong> ' . $string_table_list . '<br />'; } $arrayLength = count($tablelist); $string_where_clause = ''; for ($i = 0; $i < $arrayLength; $i++) { $string_where_clause .= ' AND (' . $config['table_prefix'] . 'listingsdb.listingsdb_id = `' . $tablelist[$i] . '`.listingsdb_id)'; } $arrayLength = count($tablelist_nosort); $string_where_clause_nosort = ''; for ($i = 0; $i < $arrayLength; $i++) { $string_where_clause_nosort .= ' AND (' . $config['table_prefix'] . 'listingsdb.listingsdb_id = `' . $tablelist[$i] . '`.listingsdb_id)'; } if ($imageonly) { $searchSQL = "SELECT distinct(" . $config['table_prefix'] . "listingsdb.listingsdb_id), " . $config['table_prefix'] . "listingsdb.userdb_id, " . $config['table_prefix'] . "listingsdb.listingsdb_title FROM " . $config['table_prefix'] . "listingsdb, " . $config['table_prefix'] . "listingsimages " . $string_table_list . " WHERE (listingsdb_active = 'yes') " . $string_where_clause . " AND (" . $config['table_prefix'] . "listingsimages.listingsdb_id = " . $config['table_prefix'] . "listingsdb.listingsdb_id) "; $searchSQLCount = "SELECT COUNT(distinct(" . $config['table_prefix'] . "listingsdb.listingsdb_id)) as total_listings FROM " . $config['table_prefix'] . "listingsdb, " . $config['table_prefix'] . "listingsimages " . $string_table_list_no_sort . " WHERE (listingsdb_active = 'yes') " . $string_where_clause_nosort . " AND (" . $config['table_prefix'] . "listingsimages.listingsdb_id = " . $config['table_prefix'] . "listingsdb.listingsdb_id) "; } elseif ($vtoursonly) { $searchSQL = "SELECT distinct(" . $config['table_prefix'] . "listingsdb.listingsdb_id), " . $config['table_prefix'] . "listingsdb.userdb_id, " . $config['table_prefix'] . "listingsdb.listingsdb_title FROM " . $config['table_prefix'] . "listingsdb, " . $config['table_prefix'] . "vtourimages " . $string_table_list . " WHERE (listingsdb_active = 'yes') " . $string_where_clause . " AND (" . $config['table_prefix'] . "vtourimages.listingsdb_id = " . $config['table_prefix'] . "listingsdb.listingsdb_id) "; $searchSQLCount = "SELECT COUNT(distinct(" . $config['table_prefix'] . "listingsdb.listingsdb_id)) as total_listings FROM " . $config['table_prefix'] . "listingsdb, " . $config['table_prefix'] . "vtourimages " . $string_table_list_no_sort . " WHERE (listingsdb_active = 'yes') " . $string_where_clause_nosort . " AND (" . $config['table_prefix'] . "vtourimages.listingsdb_id = " . $config['table_prefix'] . "listingsdb.listingsdb_id) "; } else { $searchSQL = "SELECT distinct(" . $config['table_prefix'] . "listingsdb.listingsdb_id), " . $config['table_prefix'] . "listingsdb.userdb_id, " . $config['table_prefix'] . "listingsdb.listingsdb_title FROM " . $config['table_prefix'] . "listingsdb " . $string_table_list . " WHERE (listingsdb_active = 'yes') " . $string_where_clause; $searchSQLCount = "SELECT COUNT(distinct(" . $config['table_prefix'] . "listingsdb.listingsdb_id)) as total_listings FROM " . $config['table_prefix'] . "listingsdb " . $string_table_list_no_sort . " WHERE (listingsdb_active = 'yes') " . $string_where_clause_nosort; } if ($searchresultSQL != '') { $searchSQL .= " AND " . $searchresultSQL; $searchSQLCount .= " AND " . $searchresultSQL; } if ($config['use_expiration'] == 1) { $searchSQL .= " AND (listingsdb_expiration > " . $conn->DBDate(time()) . ")"; $searchSQLCount .= " AND (listingsdb_expiration > " . $conn->DBDate(time()) . ")"; } $sql = $searchSQL . " {$sort_text} {$order_text}"; $searchSQLCount = $searchSQLCount; // We now have a complete SQL Query. Now grab the results $recordSet = $conn->Execute($searchSQLCount); if ($DEBUG_SQL) { echo '<strong>Listing Count:</strong> ' . $searchSQLCount . '<br />'; } if (!$recordSet) { $misc->log_error($searchSQLCount); } // We have the results so now we need to stack them in arrays to use with the search_result.html template file // Load the templste require_once $config['basepath'] . '/include/class/template/core.inc.php'; $page = new page_user(); if (count($_GET['pclass']) == 1 && file_exists($config['template_path'] . '/search_results_class_' . $_GET['pclass'][0] . '.html')) { $page->load_page($config['template_path'] . '/search_results_class_' . $_GET['pclass'][0] . '.html'); } else { $page->load_page($config['template_path'] . '/' . $config['search_result_template']); } // Get header section $header_section = $page->get_template_section('search_result_header'); $search_result = ''; // Ok we have the header section now get the result section $search_result_section = $page->get_template_section('search_result_dataset'); // Get the number of rows(records) we have. // $num_rows = $recordSet->RecordCount(); $num_rows = $recordSet->fields['total_listings']; if ($return_ids_only === true) { // If we are returning IDs only for the notify listing then get the id and move on. $id = array(); $resultRecordSet = $conn->Execute($sql); if (!$resultRecordSet) { $misc->log_error($sql); } if ($DEBUG_SQL) { echo '<strong>Search SQL:</strong> ' . $sql . '<br />'; } while (!$resultRecordSet->EOF) { $id[] = $resultRecordSet->fields['listingsdb_id']; $resultRecordSet->MoveNext(); } // while return $id; } elseif ($return_ids_only === 'perpage') { $id = array(); if (!isset($_GET['cur_page'])) { $_GET['cur_page'] = 0; } $limit_str = intval($_GET['cur_page']) * $config['listings_per_page']; $resultRecordSet = $conn->SelectLimit($sql, $config['listings_per_page'], $limit_str); if (!$resultRecordSet) { $misc->log_error($sql); } if ($DEBUG_SQL) { echo '<strong>Search SQL:</strong> ' . $sql . '<br />'; } while (!$resultRecordSet->EOF) { $id[] = $resultRecordSet->fields['listingsdb_id']; $resultRecordSet->MoveNext(); } // while return $id; } else { if ($num_rows > 0) { if (!isset($_GET['cur_page'])) { $_GET['cur_page'] = 0; } // build the string to select a certain number of listings per page $limit_str = intval($_GET['cur_page']) * $config['listings_per_page']; $num_records = $config['listings_per_page']; $some_num = intval($_GET['cur_page']) + 1; $this_page_max = $some_num * $config['listings_per_page']; // Check if we're setting a maximum number of search results if ($config["max_search_results"] > 0) { // Check if we've reached the max number of listings setting. if ($this_page_max > $config["max_search_results"]) { $num_records = $this_page_max - $config["max_search_results"]; } // Failsafe check in case the max search results was set lower than the listings per page setting. if ($config["max_search_results"] < $config['listings_per_page']) { $num_records = $config["max_search_results"]; } // Adjust the $num_rows for the next_prev function to show at the max the max results setting if ($num_rows > $config["max_search_results"]) { $num_rows = $config["max_search_results"]; } } if ($config['show_next_prev_listing_page'] == 1) { // ************added for next prev navigation*********** $newurl = ''; foreach ($_GET as $k => $v) { if ($v && $k != 'cur_page' && $k != 'PHPSESSID' && $k != 'action') { if (is_array($v)) { foreach ($v as $vitem) { $newurl .= '&' . urlencode("{$k}") . '[]=' . urlencode("{$vitem}"); } } else { $newurl .= '&' . urlencode("{$k}") . '=' . urlencode("{$v}"); } } } $rtest = $conn->Execute($sql); if (!$rtest) { $misc->log_error($sql); } $_SESSION['results'] = array(); $_SESSION['titles'] = array(); while (!$rtest->EOF) { $ID = $rtest->fields['listingsdb_id']; $url_title = $rtest->fields['listingsdb_title']; $url_title = str_replace("/", "", $url_title); $url_title = strtolower(str_replace(" ", $config['seo_url_seperator'], $url_title)); $url_title = str_replace(" ", "+", $url_title); $_SESSION['results'][] = $ID; $_SESSION['titles'][] = $url_title; $rtest->MoveNext(); } $_SESSION['cur_page'] = intval($_GET['cur_page']); $_SESSION['searchstring'] = $newurl; $_SESSION['count'] = $num_rows; // ************added for next prev navigation*********** } // Store the next_prev code as a variable to place in the template $next_prev = $misc->next_prev($num_rows, intval($_GET['cur_page']), $guidestring_with_sort); $next_prev_bottom = $misc->next_prev($num_rows, intval($_GET['cur_page']), $guidestring_with_sort, 'bottom'); $resultRecordSet = $conn->SelectLimit($sql, $num_records, $limit_str); if (!$resultRecordSet) { $misc->log_error($sql); } if ($DEBUG_SQL) { echo '<strong>Search SQL:</strong> ' . $sql . '<br />'; } // Get the the fields marked as browseable. $sql = "SELECT listingsformelements_id, listingsformelements_field_caption, listingsformelements_field_name, listingsformelements_display_priv, listingsformelements_search_result_rank FROM " . $config['table_prefix'] . "listingsformelements WHERE (listingsformelements_display_on_browse = 'Yes') AND (listingsformelements_field_type <> 'textarea') ORDER BY listingsformelements_search_result_rank"; $recordSet = $conn->Execute($sql); $num_columns = $recordSet->RecordCount(); // Get header_title $field_caption = $lang['title']; $field_name = "listingsdb_title"; $sorttypestring = ''; $sort_type_count = 0; foreach ($sortby_array as $sortby) { if ($sortby == $field_name) { if (!isset($sorttype_array[$sort_type_count]) || $sorttype_array[$sort_type_count] == 'DESC') { $reverse_sort = 'ASC'; } else { $reverse_sort = 'DESC'; } $sorttypestring = 'sorttype=' . $reverse_sort; } $sort_type_count++; } if ($sorttypestring == '') { $sorttypestring = "sorttype=ASC"; } // This is header_title it is the lang variable for title $header_title = '<a href="index.php?action=searchresults&sortby=' . $field_name . '&' . $sorttypestring . $guidestring . '">' . $field_caption . '</a>'; $header_title_no_sort = $field_caption; // Get header_title $field_caption = $lang['header_pclass']; $field_name = "pclass"; $sorttypestring = ''; $sort_type_count = 0; foreach ($sortby_array as $sortby) { if ($sortby == $field_name) { if (!isset($sorttype_array[$sort_type_count]) || $sorttype_array[$sort_type_count] == 'DESC') { $reverse_sort = 'ASC'; } else { $reverse_sort = 'DESC'; } $sorttypestring = 'sorttype=' . $reverse_sort; } $sort_type_count++; } if ($sorttypestring == '') { $sorttypestring = "sorttype=ASC"; } // This is header_title it is the lang variable for title $header_pclass = '<a href="index.php?action=searchresults&sortby=' . $field_name . '&' . $sorttypestring . $guidestring . '">' . $field_caption . '</a>'; $header_pclass_no_sort = $field_caption; $field = array(); $field_no_sort = array(); while (!$recordSet->EOF) { $x = $misc->make_db_unsafe($recordSet->fields['listingsformelements_search_result_rank']); // Check for Translations if needed if (!isset($_SESSION["users_lang"])) { $field_caption = $misc->make_db_unsafe($recordSet->fields['listingsformelements_field_caption']); } else { $listingsformelements_id = $recordSet->fields['listingsformelements_id']; $lang_sql = "SELECT listingsformelements_field_caption FROM " . $config['lang_table_prefix'] . "listingsformelements WHERE listingsformelements_id = {$listingsformelements_id}"; $lang_recordSet = $conn->Execute($lang_sql); if (!$lang_recordSet) { $misc->log_error($lang_sql); } if ($DEBUG_SQL) { echo '<strong>ML: Field Caption SQL:</strong> ' . $lang_sql . '<br />'; } $field_caption = $misc->masearch_result_datasetke_db_unsafe($lang_recordSet->fields['listingsformelements_field_caption']); } $field_name = $misc->make_db_unsafe($recordSet->fields['listingsformelements_field_name']); $display_priv = $misc->make_db_unsafe($recordSet->fields['listingsformelements_display_priv']); $display_status = false; if ($display_priv == 1) { $display_status = login::loginCheck('Member', true); } elseif ($display_priv == 2) { $display_status = login::loginCheck('Agent', true); } else { $display_status = true; } if ($display_status === true) { $sorttypestring = ''; $sort_type_count = 0; foreach ($sortby_array as $sortby) { if ($sortby == $field_name) { if (!isset($sorttype_array[$sort_type_count]) || $sorttype_array[$sort_type_count] == 'DESC') { $reverse_sort = 'ASC'; } else { $reverse_sort = 'DESC'; } $sorttypestring = 'sorttype=' . $reverse_sort; } $sort_type_count++; } if ($sorttypestring == '') { $sorttypestring = "sorttype=ASC"; } $field[$x] = '<a href="index.php?action=searchresults&sortby=' . $field_name . '&' . $sorttypestring . $guidestring . '">' . $field_caption . '</a>'; $field_no_sort[$x] = $field_caption; } $recordSet->MoveNext(); } // end while // We have all the header information so we can now parse that section $header_section = $page->parse_template_section($header_section, 'header_title', $header_title); $header_section = $page->parse_template_section($header_section, 'header_title_no_sort', $header_title_no_sort); $header_section = $page->parse_template_section($header_section, 'header_pclass', $header_pclass); $header_section = $page->parse_template_section($header_section, 'header_pclass_no_sort', $header_pclass_no_sort); foreach ($field as $x => $f) { $header_section = $page->parse_template_section($header_section, 'header_' . $x, $f); } foreach ($field_no_sort as $x => $f) { $header_section = $page->parse_template_section($header_section, 'header_' . $x . '_no_sort', $f); } // We have the title now we need the image $num_columns = $num_columns + 1; // add one for the image $count = 0; while (!$resultRecordSet->EOF) { // Start a new section for each listing. $search_result .= $search_result_section; // alternate the colors if ($count == 0) { $count = $count + 1; } else { $count = 0; } $Title = $misc->make_db_unsafe($resultRecordSet->fields['listingsdb_title']); $current_ID = $resultRecordSet->fields['listingsdb_id']; $or_owner = $resultRecordSet->fields['userdb_id']; if ($config['url_style'] == '1') { $url = '<a href="index.php?action=listingview&listingID=' . $current_ID . '">'; } else { $url_title = str_replace("/", "", $Title); $url_title = strtolower(str_replace(" ", $config['seo_url_seperator'], $url_title)); $url = '<a href="listing-' . misc::urlencode_to_sef($url_title) . '-' . $current_ID . '.html">'; } $field_title = $url . $Title . '</a>'; // Insert the title as we grabbed it earlier $search_result = $page->parse_template_section($search_result, 'field_title', $field_title); $search_result = $page->parse_template_section($search_result, 'listingid', $current_ID); $search_result = $page->replace_listing_field_tags($current_ID, $search_result); //get distance for postal code distance searches if (isset($_GET['postalcode_dist_dist'])) { $sql3 = "SELECT listingsdbelements_field_value FROM " . $config['table_prefix'] . "listingsdbelements WHERE ((listingsdb_id = {$current_ID}) AND (listingsdbelements_field_name = '" . $config['map_zip'] . "'))"; $recordSet3 = $conn->Execute($sql3); $sql4 = 'SELECT zipdist_latitude, zipdist_longitude FROM ' . $config['table_prefix_no_lang'] . 'zipdist WHERE zipdist_zipcode =' . $recordSet3->fields['listingsdbelements_field_value']; $recordSet4 = $conn->Execute($sql4); $postalcode_distance = round($this->calculate_mileage($postalcode_dist_lat, $recordSet4->fields['zipdist_latitude'], $postalcode_dist_long, $recordSet4->fields['zipdist_longitude']), 2) . ' ' . $lang['postalcode_miles_away']; $search_result = $page->parse_template_section($search_result, 'postalcode_search_distance', $postalcode_distance); } // grab the rest of the listing's data $sql2 = "SELECT listingsdbelements_field_name, listingsdbelements_field_value, listingsformelements_field_type, listingsformelements_display_priv, listingsformelements_search_result_rank FROM " . $config['table_prefix'] . "listingsdbelements, " . $config['table_prefix'] . "listingsformelements WHERE ((listingsdb_id = {$current_ID}) AND (listingsformelements_display_on_browse = 'Yes') " . "AND (listingsdbelements_field_name = listingsformelements_field_name)) ORDER BY listingsformelements_search_result_rank"; $recordSet2 = $conn->Execute($sql2); if ($DEBUG_SQL) { echo '<strong>Listing Data:</strong> ' . $sql2 . '<br />'; } if (!$recordSet2) { $misc->log_error($sql2); } $field = array(); $textarea = array(); while (!$recordSet2->EOF) { $field_name = $misc->make_db_unsafe($recordSet2->fields['listingsdbelements_field_name']); $field_value = $misc->make_db_unsafe($recordSet2->fields['listingsdbelements_field_value']); $field_type = $misc->make_db_unsafe($recordSet2->fields['listingsformelements_field_type']); $display_priv = $misc->make_db_unsafe($recordSet2->fields['listingsformelements_display_priv']); $x = $misc->make_db_unsafe($recordSet2->fields['listingsformelements_search_result_rank']); $display_status = false; if ($display_priv == 1) { $display_status = login::loginCheck('Member', true); } elseif ($display_priv == 2) { $display_status = login::loginCheck('Agent', true); } else { $display_status = true; } if ($display_status === true) { switch ($field_type) { case 'textarea': if ($config['add_linefeeds'] === "1") { $textarea[$x] = nl2br($field_value); } else { $textarea[$x] = $field_value; } break; case "select-multiple": case "option": case "checkbox": // handle field types with multiple options $feature_index_list = explode("||", $field_value); $field[$x] = ''; foreach ($feature_index_list as $feature_list_item) { $field[$x] .= $feature_list_item; $field[$x] .= $config['feature_list_separator']; } break; case "price": $sql3 = "SELECT listingsdbelements_field_value FROM " . $config['table_prefix'] . "listingsdbelements WHERE ((listingsdb_id = {$current_ID}) AND (listingsdbelements_field_name = 'status'))"; $recordSet3 = $conn->Execute($sql3); if (!$recordSet3) { $misc->log_error($sql3); } if ($DEBUG_SQL) { echo '<strong>Status Lookup for price field:</strong> ' . $sql3 . '<br />'; } $status = $misc->make_db_unsafe($recordSet3->fields['listingsdbelements_field_value']); $recordSet3->Close(); if ($field_value == "" && $config["zero_price"] == "1") { $money_amount = $misc->international_num_format($field_value, $config['number_decimals_price_fields']); if ($status == 'Sold') { $field[$x] = "<span style=\"text-decoration: line-through\">"; $field[$x] .= "</span><br /><span style=\"color:red;\"><strong>{$lang['mark_as_sold']}</strong></span>"; } elseif ($status == 'Pending') { $field[$x] .= "<br /><span style=\"color:green;\"><strong>{$lang['mark_as_pending']}</strong></span>"; } else { $field[$x] = $lang['call_for_price']; } } else { $money_amount = $misc->international_num_format($field_value, $config['number_decimals_price_fields']); if ($status == 'Sold') { $field[$x] = "<span style=\"text-decoration: line-through\">"; $field[$x] .= $misc->money_formats($money_amount); $field[$x] .= "</span><br /><span style=\"color:red;\"><strong>{$lang['mark_as_sold']}</strong></span>"; } elseif ($status == 'Pending') { $field[$x] = $misc->money_formats($money_amount); $field[$x] .= "<br /><span style=\"color:green;\"><strong>{$lang['mark_as_pending']}</strong></span>"; } else { $field[$x] = $misc->money_formats($money_amount); } } // end else break; case "select": if ($field_name == "Mi_business") { $sql4 = "SELECT listingsdbelements_field_value FROM " . $config['table_prefix'] . "listingsdbelements WHERE ((listingsdb_id = {$current_ID}) AND (listingsdbelements_field_name = 'Mi_business'))"; $recordSet4 = $conn->Execute($sql4); if (!$recordSet4) { $misc->log_error($sql4); } else { $requiredMigration = $misc->make_db_unsafe($recordSet4->fields['listingsdbelements_field_value']); $recordSet4->Close(); if ($requiredMigration == 'Yes') { $field[$x] = '<strong style="color:red">Business Migration Ready 能用作投资移民申请</strong>'; } else { $field[$x] = ''; } } } else { $field[$x] = "{$field_value}"; } break; case "number": $field[$x] = $misc->international_num_format($field_value, $config['number_decimals_number_fields']); break; case "url": $field[$x] = "<a href=\"{$field_value}\" target=\"_blank\">{$field_value}</a>"; break; case "email": $field[$x] = "<a href=\"mailto:{$field_value}\">{$field_value}</a>"; break; case "date": if ($config['date_format'] == 1) { $format = "m/d/Y"; } elseif ($config['date_format'] == 2) { $format = "Y/d/m"; } elseif ($config['date_format'] == 3) { $format = "d/m/Y"; } if ($field_value > 0) { $field_value = date($format, "{$field_value}"); } $field[$x] = "{$field_value}"; break; default: $field[$x] = "{$field_value}"; break; } // end switch } $recordSet2->MoveNext(); } // end while foreach ($field as $x => $f) { $search_result = $page->parse_template_section($search_result, 'field_' . $x, $f); } //Form URLS for TextArea if ($config['url_style'] == '1') { $preview = '... <a href="index.php?action=listingview&listingID=' . $current_ID . '">' . $lang['more_info'] . '</a>'; } else { $url_title = str_replace("/", "", $Title); $url_title = strtolower(str_replace(" ", $config['seo_url_seperator'], $url_title)); $preview = '... <a href="listing-' . misc::urlencode_to_sef($url_title) . '-' . $current_ID . '.html">' . $lang['more_info'] . '</a>'; } foreach ($textarea as $x => $f) { // Normal Textarea $search_result = $page->parse_template_section($search_result, 'textarea_' . $x, $f); // Short textarea of first number of characters defined in site config with link to the listing $p = substr(strip_tags($f), 0, $config['textarea_short_chars']); $p = substr($p, 0, strrpos($p, ' ')); $search_result = $page->parse_template_section($search_result, 'textarea_' . $x . '_short', $p . '' . $preview); } //Cleanup Textareas $search_result = preg_replace('/{textarea_(.*?)_short}/', $preview, $search_result); $search_result = preg_replace('/{textarea_(.*?)}/', '', $search_result); // Show Vtour indicator Image if vtour exists require_once $config['basepath'] . '/include/vtour.inc.php'; $vtour_link = vtours::rendervtourlink($current_ID, true); $search_result = $page->parse_template_section($search_result, 'vtour_button', $vtour_link); // Show Creation Date require_once $config['basepath'] . '/include/listing.inc.php'; $get_creation_date = listing_pages::get_creation_date($current_ID); $search_result = $page->parse_template_section($search_result, 'get_creation_date', $get_creation_date); // Show Featured require_once $config['basepath'] . '/include/listing.inc.php'; $get_featured = listing_pages::get_featured($current_ID, 'no'); $search_result = $page->parse_template_section($search_result, 'get_featured', $get_featured); // Show Featured Raw require_once $config['basepath'] . '/include/listing.inc.php'; $get_featured_raw = listing_pages::get_featured($current_ID, 'yes'); $search_result = $page->parse_template_section($search_result, 'get_featured_raw', $get_featured_raw); // Show Modified Date require_once $config['basepath'] . '/include/listing.inc.php'; $get_modified_date = listing_pages::get_modified_date($current_ID); $search_result = $page->parse_template_section($search_result, 'get_modified_date', $get_modified_date); // Start {isfavorite} search result template section tag if (isset($_SESSION['userID'])) { $userID = $misc->make_db_safe($_SESSION['userID']); $sql1 = "SELECT listingsdb_id FROM " . $config['table_prefix'] . "userfavoritelistings WHERE ((listingsdb_id = {$current_ID}) AND (userdb_id={$userID}))"; $recordSet1 = $conn->Execute($sql1); if ($recordSet1 === false) { $misc->log_error($sql1); } $favorite_listingsdb_id = $misc->make_db_unsafe($recordSet1->fields['listingsdb_id']); if ($favorite_listingsdb_id !== $current_ID) { $isfavorite = "no"; $search_result = $page->parse_template_section($search_result, 'isfavorite', $isfavorite); } else { $isfavorite = "yes"; $search_result = $page->parse_template_section($search_result, 'isfavorite', $isfavorite); } } // End {isfavorite} search result template section tag // Show Delete From Favorites Link if needed $delete_from_fav = ''; if (isset($_SESSION['userID'])) { $userID = $misc->make_db_safe($_SESSION['userID']); $sql = "SELECT listingsdb_id FROM " . $config['table_prefix'] . "userfavoritelistings WHERE ((listingsdb_id = {$current_ID}) AND (userdb_id={$userID}))"; $recordSet = $conn->Execute($sql); if (!$recordSet) { $misc->log_error($sql); } if ($DEBUG_SQL) { echo '<strong>Delete Favorite Lookup:</strong> ' . $sql . '<br />'; } $num_rows = $recordSet->RecordCount(); if ($num_rows > 0) { $delete_from_fav = '<a href="index.php?action=delete_favorites&listingID=' . $current_ID . '" onclick="return confirmDelete()">' . $lang['delete_from_favorites'] . '</a>'; } } // Instert link into section $search_result = $page->parse_template_section($search_result, 'delete_from_favorite', $delete_from_fav); //Show Add To Favorites $link_add_favorites = ''; if (isset($_SESSION['userID'])) { $userID = $misc->make_db_safe($_SESSION['userID']); $sql = "SELECT listingsdb_id FROM " . $config['table_prefix'] . "userfavoritelistings WHERE ((listingsdb_id = {$current_ID}) AND (userdb_id={$userID}))"; $recordSet = $conn->Execute($sql); if (!$recordSet) { $misc->log_error($sql); } if ($DEBUG_SQL) { echo '<strong>Add Favorite Lookup:</strong> ' . $sql . '<br />'; } $num_rows = $recordSet->RecordCount(); if ($num_rows == 0) { $link_add_favorites = listing_pages::create_add_favorite_link(); } } else { $link_add_favorites = listing_pages::create_add_favorite_link(); } // Instert link into section $search_result = $page->parse_template_section($search_result, 'link_add_favorites', $link_add_favorites); // Insert row number $search_result = $page->parse_template_section($search_result, 'row_num_even_odd', $count); $resultRecordSet->MoveNext(); // Replace Edit Listing links require_once $config['basepath'] . '/include/listing.inc.php'; $edit_link = listing_pages::edit_listing_link(); $search_result = $page->parse_template_section($search_result, 'link_edit_listing', $edit_link); $edit_link = listing_pages::edit_listing_link('yes'); $search_result = $page->parse_template_section($search_result, 'link_edit_listing_url', $edit_link); // Replace addon fields. $addon_fields = $page->get_addon_template_field_list($addons); $search_result = $page->parse_addon_tags($search_result, $addon_fields); $search_result = $page->cleanup_fields($search_result); $search_result = $page->cleanup_images($search_result); } // end while $page->replace_template_section('search_result_header', $header_section); $page->replace_template_section('search_result_dataset', $search_result); $page->replace_permission_tags(); $page->cleanup_template_sections($next_prev, $next_prev_bottom); $display = $page->return_page(); } else { if (!isset($_GET['cur_page'])) { $_GET['cur_page'] = 0; } // This search has no results. Display an error message and the search page again. $display .= search_page::create_searchpage(false, true); } return $display; } }
function renderNotifyListings($listingIDArray, $search_title, $user_name, $email) { global $conn, $lang, $config, $db_type, $current_ID; //Load the Core Template class and the Misc Class require_once $config['basepath'] . '/include/class/template/core.inc.php'; $page = new page_user(); require_once $config['basepath'] . '/include/misc.inc.php'; $misc = new misc(); require_once $config['basepath'] . '/include/listing.inc.php'; $listingclass = new listing_pages(); //Declare an empty display variable to hold all output from function. $display = ''; //If We have a $current_ID save it $old_current_ID = ''; if ($current_ID != '') { $old_current_ID = $current_ID; } //Load the Notify Listing Template specified in the Site Config $page->load_page($config['template_path'] . '/' . $config['notify_listings_template']); // Determine if the template uses rows. // First item in array is the row conent second item is the number of block per block row $notify_template_row = $page->get_template_section_row('notify_listing_block_row'); if (is_array($notify_template_row)) { $row = $notify_template_row[0]; $col_count = $notify_template_row[1]; $user_rows = true; $x = 1; //Create an empty array to hold the row conents $new_row_data = array(); } else { $user_rows = false; } $notify_template_section = ''; foreach ($listingIDArray as $current_ID) { if ($user_rows == true && $x > $col_count) { //We are at then end of a row. Save the template section as a new row. $new_row_data[] = $page->replace_template_section('notify_listing_block', $notify_template_section, $row); //$new_row_data[] = $notify_template_section; $notify_template_section = $page->get_template_section('notify_listing_block'); $x = 1; } else { $notify_template_section .= $page->get_template_section('notify_listing_block'); } $listing_title = $listingclass->get_title($current_ID); if ($config['url_style'] == '1') { $notify_url = $config['baseurl'] . '/index.php?action=listingview&listingID=' . $current_ID; // ##### } else { $url_title = str_replace("/", "", $listing_title); $url_title = strtolower(str_replace(" ", $config['seo_url_seperator'], $url_title)); $notify_url = $config['baseurl'] . '/listing-' . misc::urlencode_to_sef($url_title) . '-' . $current_ID . '.html'; // ##### } $notify_template_section = $page->replace_listing_field_tags($current_ID, $notify_template_section); $notify_template_section = $page->replace_listing_field_tags($current_ID, $notify_template_section); $notify_template_section = $page->parse_template_section($notify_template_section, 'notify_url', $notify_url); $notify_template_section = $page->parse_template_section($notify_template_section, 'listingid', $current_ID); // Setup Image Tags $sql2 = "SELECT listingsimages_thumb_file_name,listingsimages_file_name\n\t\t\t\t\tFROM " . $config['table_prefix'] . "listingsimages\n\t\t\t\t\tWHERE (listingsdb_id = {$current_ID})\n\t\t\t\t\tORDER BY listingsimages_rank"; $recordSet2 = $conn->SelectLimit($sql2, 1, 0); if ($recordSet2 === false) { $misc->log_error($sql2); } if ($recordSet2->RecordCount() > 0) { $thumb_file_name = $misc->make_db_unsafe($recordSet2->fields['listingsimages_thumb_file_name']); $file_name = $misc->make_db_unsafe($recordSet2->fields['listingsimages_file_name']); if ($thumb_file_name != "" && file_exists("{$config['listings_upload_path']}/{$thumb_file_name}")) { // gotta grab the thumbnail image size $imagedata = GetImageSize("{$config['listings_upload_path']}/{$thumb_file_name}"); $imagewidth = $imagedata[0]; $imageheight = $imagedata[1]; $shrinkage = $config['thumbnail_width'] / $imagewidth; $notify_thumb_width = $imagewidth * $shrinkage; $notify_thumb_height = $imageheight * $shrinkage; $notify_thumb_src = $config['listings_view_images_path'] . '/' . $thumb_file_name; // gotta grab the thumbnail image size $imagedata = GetImageSize("{$config['listings_upload_path']}/{$file_name}"); $imagewidth = $imagedata[0]; $imageheight = $imagedata[1]; $notify_width = $imagewidth; $notify_height = $imageheight; $notify_src = $config['listings_view_images_path'] . '/' . $file_name; } } else { if ($config['show_no_photo'] == 1) { $imagedata = GetImageSize($config['basepath'] . "/images/nophoto.gif"); $imagewidth = $imagedata[0]; $imageheight = $imagedata[1]; $shrinkage = $config['thumbnail_width'] / $imagewidth; $notify_thumb_width = $imagewidth * $shrinkage; $notify_thumb_height = $imageheight * $shrinkage; $notify_thumb_src = $config['baseurl'] . '/images/nophoto.gif'; $notify_width = $notify_thumb_width; $notify_height = $notify_thumb_height; $notify_src = $config['baseurl'] . '/images/nophoto.gif'; } else { $notify_thumb_width = ''; $notify_thumb_height = ''; $notify_thumb_src = ''; $notify_width = ''; $notify_height = ''; $notify_src = ''; } } if (!empty($notify_thumb_src)) { $notify_template_section = $page->parse_template_section($notify_template_section, 'notify_thumb_src', $notify_thumb_src); $notify_template_section = $page->parse_template_section($notify_template_section, 'notify_thumb_height', $notify_thumb_height); $notify_template_section = $page->parse_template_section($notify_template_section, 'notify_thumb_width', $notify_thumb_width); $notify_template_section = $page->cleanup_template_block('notify_img', $notify_template_section); } else { $notify_template_section = $page->remove_template_block('notify_img', $notify_template_section); } if (!empty($notify_src)) { $notify_template_section = $page->parse_template_section($notify_template_section, 'notify_large_src', $notify_src); $notify_template_section = $page->parse_template_section($notify_template_section, 'notify_large_height', $notify_height); $notify_template_section = $page->parse_template_section($notify_template_section, 'notify_large_width', $notify_width); $notify_template_section = $page->cleanup_template_block('notify_img_large', $notify_template_section); } else { $notify_template_section = $page->remove_template_block('notify_img_large', $notify_template_section); } if ($user_rows == true) { $x++; } } if ($user_rows == true) { $notify_template_section = $page->cleanup_template_block('notify_listing', $notify_template_section); $new_row_data[] = $page->replace_template_section('notify_listing_block', $notify_template_section, $row); $replace_row = ''; foreach ($new_row_data as $rows) { $replace_row .= $rows; } $page->replace_template_section_row('notify_listing_block_row', $replace_row); } else { $page->replace_template_section('notify_listing_block', $notify_template_section); } $page->replace_permission_tags(); $page->replace_urls(); $page->auto_replace_tags(); $page->replace_lang_template_tags(); $display .= $page->return_page(); $current_ID = ''; if ($old_current_ID != '') { $current_ID = $old_current_ID; } return $display; }
function view_image($type) { global $conn, $config, $lang; require_once $config['basepath'] . '/include/misc.inc.php'; require_once $config['basepath'] . '/include/listing.inc.php'; $misc = new misc(); $display = ''; if (!isset($_GET['image_id'])) { return $lang['image_not_found']; } $sql_imageID = $misc->make_db_safe($_GET['image_id']); if ($type == "listing") { // get the image data $sql = "SELECT listingsimages_caption, listingsimages_file_name, listingsimages_description, listingsdb_id FROM " . $config['table_prefix'] . "listingsimages WHERE (listingsimages_id = {$sql_imageID})"; $recordSet = $conn->Execute($sql); if ($recordSet === false) { $misc->log_error($sql); } while (!$recordSet->EOF) { $caption = $misc->make_db_unsafe($recordSet->fields['listingsimages_caption']); $file_name = $misc->make_db_unsafe($recordSet->fields['listingsimages_file_name']); $description = $misc->make_db_unsafe($recordSet->fields['listingsimages_description']); $listing_id = $misc->make_db_unsafe($recordSet->fields['listingsdb_id']); $recordSet->MoveNext(); } $display .= '<div class="view_image">'; $display .= '<span class="image_caption">'; if ($caption != "") { $display .= "{$caption} - "; } //SEO Friendly Links $Title = listing_pages::get_title($listing_id); if ($config['url_style'] == '1') { $url = '<a href="index.php?action=listingview&listingID=' . $listing_id . '">'; } else { $url_title = str_replace("/", "", $Title); $url_title = strtolower(str_replace(" ", $config['seo_url_seperator'], $url_title)); $url = '<a href="listing-' . misc::urlencode_to_sef($url_title) . '-' . $listing_id . '.html">'; } $display .= $url . $lang['return_to_listing'] . '</a></span><br />'; $display .= '<img src="' . $config['listings_view_images_path'] . '/' . $file_name . '" alt="' . $caption . '" />'; $display .= '<br />'; $display .= $description; $display .= '</div>'; } elseif ($type == "userimage") { // get the image data $sql = "SELECT userimages_caption, userimages_file_name, userimages_description, userdb_id FROM " . $config['table_prefix'] . "userimages WHERE (userimages_id = {$sql_imageID})"; $recordSet = $conn->Execute($sql); if ($recordSet === false) { $misc->log_error($sql); } while (!$recordSet->EOF) { $caption = $misc->make_db_unsafe($recordSet->fields['userimages_caption']); $file_name = $misc->make_db_unsafe($recordSet->fields['userimages_file_name']); $description = $misc->make_db_unsafe($recordSet->fields['userimages_description']); $user_id = $recordSet->fields['userdb_id']; $recordSet->MoveNext(); } $display .= '<table class="form_" align="center">'; $display .= '<tr>'; $display .= ' <td class="row_main">'; $display .= ' <h3>'; if ($caption != "") { $display .= "{$caption} - "; } $display .= '<a href="index.php?action=view_user&user='******'">' . $lang['return_to_user'] . '</a></h3>'; $display .= ' <center>'; $display .= ' <img src="' . $config['user_view_images_path'] . '/' . $file_name . '" alt="' . $caption . '" border="1">'; $display .= ' </center>'; $display .= ' <br />'; $display .= $description; $display .= ' </td>'; $display .= '</tr>'; $display .= '</table>'; } // end if ($type == "listing") return $display; }