/** * **************************************************************************\ * 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; } }