function google_cars() { echo '<rss version ="2.0" xmlns:g="http://base.google.com/ns/1.0"> <channel> <title>' . osc_page_title() . '</title> <description>' . osc_page_description() . '</description> <link>' . osc_base_url() . '</link>'; if (osc_count_items()) { while (osc_has_items()) { $item = feed_get_car_data(osc_item()); $date = date('d/m/Y'); $time = date('H:i'); if (preg_match('|([0-9]{4})-([0-9]{2})-([0-9]{2})|', osc_item_pub_date(), $tmp)) { $date = $tmp[3] . "/" . $tmp[2] . "/" . $tmp[1]; } echo '<item> <title>' . osc_item_title() . '</title> <description>' . osc_item_description() . '</description> <g:id>' . osc_item_id() . '</g:id> <link>' . osc_item_url() . '</link> <g:location>' . (osc_item_address() != '' ? osc_item_address() : '') . ', ' . (osc_item_city() != '' ? osc_item_city() : '') . ', ' . (osc_item_region() != '' ? osc_item_region() : '') . ', ' . (osc_item_zip() != '' ? osc_item_zip() : '') . ' ' . (osc_item_country() != '' ? osc_item_country() : '') . '</g:location> <g:publish_date>' . $date . '</g:publish_date> <g:color>' . (isset($item['s_color']) ? $item['s_color'] : '') . '</g:color> <g:condition>' . (isset($item['b_new']) && $item['b_new'] == 1 ? 'new' : 'used') . '</g:condition>'; if (osc_count_item_resources() > 0) { while (osc_has_item_resources()) { if (strpos(osc_resource_type(), 'image') !== FALSE) { echo '<g:image_link>' . osc_resource_path() . '</g:image_link>'; } } } echo '<g:make>' . (isset($item['s_make']) ? $item['s_make'] : '') . '</g:make> <g:mileage>' . (isset($item['i_mileage']) ? $item['i_mileage'] : '') . '</g:mileage> <g:model>' . (isset($item['s_model']) ? $item['s_model'] : '') . '</g:model> <g:price>' . (osc_item_price() != '' ? osc_item_price() : '') . '</g:price> <g:vehicle_type>' . (isset($item['s_name']) ? $item['s_name'] : '') . '</g:vehicle_type> <g:year>' . (isset($item['i_year']) ? $item['i_year'] : '') . '</g:year> </item>'; } } echo '</channel> </rss>'; }
function item_detail_location() { $location = array(); if (osc_item_address() != '') { $location[] = osc_item_address(); } if (osc_item_city_area() != '') { $location[] = osc_item_city_area(); } if (osc_item_city() != '') { $location[] = osc_item_city(); } if (osc_item_region() != '') { $location[] = osc_item_region(); } if (osc_item_country() != '') { $location[] = osc_item_country(); } return $location; }
function trovit_cars() { echo '<?xml version="1.0" encoding="utf-8"?> <trovit>'; if (osc_count_items()) { while (osc_has_items()) { $item = feed_get_car_data(osc_item()); $date = date('d/m/Y'); $time = date('H:i'); if (preg_match('|([0-9]{4})-([0-9]{2})-([0-9]{2}) ([0-9]{2}):([0-9]{2})|', osc_item_pub_date(), $tmp)) { $date = $tmp[3] . "/" . $tmp[2] . "/" . $tmp[1]; $time = $tmp[4] . ":" . $tmp[5]; } echo '<ad> <id><![CDATA[' . osc_item_id() . ']]></id> <url><![CDATA[' . osc_item_url() . ']]></url> <title><![CDATA[' . osc_item_title() . ']]></title> <content><![CDATA[' . osc_item_description() . ']]></content> <price><![CDATA[' . osc_item_price() . ']]></price> <make><![CDATA[' . (isset($item['s_make']) ? $item['s_make'] : '') . ']]></make> <model><![CDATA[' . (isset($item['s_model']) ? $item['s_model'] : '') . ']]></model> <color><![CDATA[' . (isset($item['s_color']) ? $item['s_color'] : '') . ']]></color> <mileage><![CDATA[' . (isset($item['i_mileage']) ? $item['i_mileage'] : '') . ']]></mileage> <doors><![CDATA[' . (isset($item['i_doors']) ? $item['i_doors'] : '') . ']]></doors> <fuel><![CDATA[' . (isset($item['e_fuel']) ? $item['e_fuel'] : '') . ']]></fuel> <transmission><![CDATA[' . (isset($item['e_transmission']) ? $item['e_transmission'] : '') . ']]></transmission> <engine_size><![CDATA[' . (isset($item['i_engine_size']) ? $item['i_engine_size'] : '') . ']]></engine_size> <cylinders><![CDATA[' . (isset($item['i_cylinders']) ? $item['i_cylinders'] : '') . ']]></cylinders> <power unit="' . (isset($item['e_power_unit']) ? $item['e_power_unit'] : '') . '"><![CDATA[' . (isset($item['i_power']) ? $item['i_power'] : '') . ']]></power> <seats><![CDATA[' . (isset($item['i_seats']) ? $item['i_seats'] : '') . ']]></seats> <gears><![CDATA[' . (isset($item['i_gears']) ? $item['i_gears'] : '') . ']]></gears> <address><![CDATA[' . (osc_item_address() != '' ? osc_item_address() : '') . ']]></address> <city><![CDATA[' . (osc_item_city() != '' ? osc_item_city() : '') . ']]></city> <city_area><![CDATA[' . (osc_item_city_area() != '' ? osc_item_city_area() : '') . ']]></city_area> <postcode><![CDATA[' . (osc_item_zip() != '' ? osc_item_zip() : '') . ']]></postcode> <region><![CDATA[' . (osc_item_region() != '' ? osc_item_region() : '') . ']]></region> <latitude><![CDATA[' . (osc_item_latitude() != '' ? osc_item_latitude() : '') . ']]></latitude> <longitude><![CDATA[' . (osc_item_longitude() != '' ? osc_item_longitude() : '') . ']]></longitude>'; $res_string = ''; if (osc_count_item_resources() > 0) { while (osc_has_item_resources()) { if (strpos(osc_resource_type(), 'image') !== FALSE) { $res_string .= '<picture> <picture_url><![CDATA[' . osc_resource_path() . ']]></picture_url> <picture_title><![CDATA[' . osc_resource_name() . ']]></picture_title> </picture>'; } } } if ($res_string != '') { echo '<pictures>' . $res_string . '</pictures>'; } echo ' <date><![CDATA[' . $date . ']]></date> <time><![CDATA[' . $time . ']]></time> </ad>'; } } echo '</trovit>'; }
function oodle_realstate() { echo '<?xml version="1.0" encoding="utf-8"?><listings>'; if (osc_count_items()) { while (osc_has_items()) { $item = feed_get_house_data(osc_item()); $time = explode(" ", osc_item_pub_date()); if (isset($item['s_square_meters'])) { $lot_size = $item['s_square_meters'] * 10.7639104; } else { $lot_size = 0; } $amenities = array(); if (isset($item['b_heating']) && $item['b_heating']) { $amenities[] = __('Heating', 'extra_feeds'); } if (isset($item['b_air_condition']) && $item['b_air_condition']) { $amenities[] = __('Air condition', 'extra_feeds'); } if (isset($item['b_elevator']) && $item['b_elevator']) { $amenities[] = __('Elevator', 'extra_feeds'); } if (isset($item['b_terrace']) && $item['b_terrace']) { $amenities[] = __('Terrace', 'extra_feeds'); } if (isset($item['b_parking']) && $item['b_parking']) { $amenities[] = __('Parking', 'extra_feeds'); } echo '<listing> <category>' . osc_item_category() . '</category> <description><![CDATA[' . osc_item_description() . ']]></description> <id>' . osc_item_id() . '</id> <title><![CDATA[' . osc_item_title() . ']]></title> <url>' . osc_item_url() . '</url> <address>' . osc_item_address() . '</address> <city>' . osc_item_city() . '</city> <country>' . osc_item_country_code() . '</country> <neighborhood>' . osc_item_city_area() . '</neighborhood> <state>' . osc_item_region() . '</state> <zip_code>' . osc_item_zip() . '</zip_code> <longitude>' . osc_item_longitude() . '</longitude> <latitude>' . osc_item_latitude() . '</latitude> <amenities>' . implode(", ", $amenities) . '</amenities> <bathrooms>' . @$item['i_num_bathrooms'] . '</bathrooms> <bedrooms>' . @$item['i_num_rooms'] . '</bedrooms> <condition>' . @$item['e_status'] . '</condition> <create_time>' . $time[0] . '</create_time> <currency>' . osc_item_currency() . '</currency> <furnished>' . (@$item['b_furnished'] ? 'Furnished' : '') . '</furnished>'; if (osc_count_item_resources() > 0) { if (strpos(osc_resource_type(), 'image') !== FALSE) { echo '<image_url><![CDATA[' . osc_resource_path() . ']]></image_url>'; } } echo '<lot_size>' . $lot_size . '</lot_size> <lot_size_units>square feet</lot_size_units> <price>' . osc_item_price() . '</price> <seller_email>' . osc_item_contact_email() . '</seller_email> <seller_name><![CDATA[' . osc_item_contact_name() . ']]></seller_name> <year>' . @$item['i_year'] . '</year> </listing>'; } } echo '</listings>'; }
function logbee_header() { $location = Rewrite::newInstance()->get_location(); $section = Rewrite::newInstance()->get_section(); if ($location == 'item' && $section == '') { echo ' <style type="text/css"> .logbee ul { margin: 10px 0; list-style: none; } .logbee ul li { float: left; } .logbee .clear { clear:both; } </style>'; // meta-tags $address_array = array(); if (osc_item_address() != "") { $address_array[] = osc_item_address(); } if (osc_item_city_area() != "") { $address_array[] = osc_item_city_area(); } if (osc_item_zip() != "") { $address_array[] = osc_item_zip(); } if (osc_item_city() != "") { $address_array[] = osc_item_city(); } if (osc_item_region() != "") { $address_array[] = osc_item_region(); } if (osc_item_country() != "") { $address_array[] = osc_item_country(); } $address = implode(", ", $address_array); $price = ''; if (osc_item_formated_price() != "") { $price = osc_item_formated_price(); } $email = ''; if (osc_item_show_email()) { $email = osc_item_contact_email(); } echo ' <meta property="logbee:title" content="' . osc_esc_html(osc_item_title()) . '"/> <meta property="logbee:url" content="' . osc_esc_html(osc_item_url()) . '"/> <meta property="logbee:desc" content="' . osc_esc_html(osc_item_description()) . '"/> <meta property="logbee:addr" content="' . osc_esc_html($address) . '"/> <meta property="logbee:email" content="' . osc_esc_html($email) . '"/> <meta property="logbee:price" content="' . osc_esc_html($price) . '"/>'; // do we have the cars_plugin enabled? if (osc_plugin_is_enabled('cars_attributes/index.php')) { require_once osc_plugin_path('') . '/cars_attributes/ModelCars.php'; if (osc_is_this_category('cars_plugin', osc_item_category_id())) { $detail = ModelCars::newInstance()->getCarAttr(osc_item_id()); echo ' <meta property="logbee:type" content="car"/> <meta property="logbee:mileage" content="' . osc_esc_html(@$detail['i_mileage']) . '"/> <meta property="logbee:firstreg" content="' . osc_esc_html(@$detail['i_year']) . '"/>'; } } // do we have the realestate_plugin enabled? if (osc_plugin_is_enabled('realestate_attributes/index.php')) { require_once osc_plugin_path('') . '/realestate_attributes/ModelRealEstate.php'; if (osc_is_this_category('realestate_plugin', osc_item_category_id())) { $detail = ModelRealEstate::newInstance()->getAttributes(osc_item_id()); echo ' <meta property="logbee:type" content="realty"/> <meta property="logbee:rooms" content="' . osc_esc_html(@$detail['i_num_rooms']) . '"/> <meta property="logbee:size" content="' . osc_esc_html(@$detail['s_square_meters']) . ' sqm"/>'; } } // images osc_reset_resources(); $images_array = array(); for ($i = 0; osc_has_item_resources(); $i++) { $images_array[] = osc_esc_html(osc_resource_url()); } $images = implode("|", $images_array); echo ' <meta property="logbee:imgurl" content="' . $images . '"/> '; osc_reset_resources(); echo "\n"; } }
function indeed() { echo '<?xml version="1.0" encoding="utf-8"?> <source> <publisher>' . osc_page_title() . '</publisher> <publisherurl>' . osc_base_url() . '</publisherurl> <lastBuildDate>' . date("D, j M Y G:i:s T") . '</lastBuildDate>'; if (osc_count_items()) { while (osc_has_items()) { $item = feed_get_job_data(osc_item()); $salary = ""; if (isset($item['i_salary_min']) && $item['i_salary_min'] != '') { $salary = $item['i_salary_min']; } if (isset($item['i_salary_max']) && $item['i_salary_max'] != '') { if ($salary != "") { $salary .= ' - '; } $salary .= $item['i_salary_max']; } if (isset($item['e_salary_period']) && $item['e_slary_period'] != '') { if ($salary != "") { $salary .= ' '; $salary .= $item['e_salary_period']; } } $locale = current($item['locale']); if (isset($locale['s_desired_exp']) && $locale['s_desired_exp'] != '') { $experience = $locale['s_desired_exp']; } else { $experience = ''; } if (isset($locale['s_studies']) && $locale['s_studies'] != '') { $education = $locale['s_studies']; } else { $education = ''; } echo '<job> <title><![CDATA[' . osc_item_title() . ']]></title> <date><![CDATA[' . osc_item_pub_date() . ']]></date> <referencenumber><![CDATA[' . osc_item_id() . ']]></referencenumber> <url><![CDATA[' . osc_item_url() . ']]></url> <company><![CDATA[' . (isset($item['s_company_name']) && $item['s_company_name'] != NULL ? $item['s_company_name'] : '') . ']]></company> <city><![CDATA[' . (osc_item_city() != NULL ? osc_item_city() : '') . ']]></city> <state><![CDATA[' . (osc_item_region() != NULL ? osc_item_region() : '') . ']]></state> <country><![CDATA[' . (osc_item_country() != NULL ? osc_item_country() : '') . ']]></country> <postalcode><![CDATA[' . (osc_item_zip() != NULL ? osc_item_zip() : '') . ']]></postalcode> <description><![CDATA[' . (osc_item_description() != NULL ? osc_item_description() : '') . ']]></description> <salary><![CDATA[' . $salary . ']]></salary> <education><![CDATA[' . $education . ']]></education> <jobtype><![CDATA[' . (isset($item['e_position_type']) && $item['e_position_type'] != NULL ? $item['e_position_type'] : '') . ']]></jobtype> <category><![CDATA[]]></category> <experience><![CDATA[' . $experience . ']]></experience> </job>'; } } echo '</source>'; }
?> </span><?php } ?> </h3> <p><?php printf(__('<strong>Publish date</strong>: %s', 'twitter'), osc_format_date(osc_item_pub_date())); ?> </p> <?php $location = array(); if (osc_item_country() != '') { $location[] = sprintf(__('<strong>Country</strong>: %s', 'twitter'), osc_item_country()); } if (osc_item_region() != '') { $location[] = sprintf(__('<strong>Region</strong>: %s', 'twitter'), osc_item_region()); } if (osc_item_city() != '') { $location[] = sprintf(__('<strong>City</strong>: %s', 'twitter'), osc_item_city()); } if (count($location) > 0) { ?> <p><?php echo implode(' · ', $location); ?> </p> <?php } ?> <p><?php echo osc_highlight(strip_tags(osc_item_description()));
function doModel() { osc_run_hook('before_search'); if (osc_rewrite_enabled()) { // IF rewrite is not enabled, skip this part, preg_match is always time&resources consuming task $p_sParams = "/" . Params::getParam('sParams', false, false); if (preg_match_all('|\\/([^,]+),([^\\/]*)|', $p_sParams, $m)) { $l = count($m[0]); for ($k = 0; $k < $l; $k++) { switch ($m[1][$k]) { case osc_get_preference('rewrite_search_country'): $m[1][$k] = 'sCountry'; break; case osc_get_preference('rewrite_search_region'): $m[1][$k] = 'sRegion'; break; case osc_get_preference('rewrite_search_city'): $m[1][$k] = 'sCity'; break; case osc_get_preference('rewrite_search_city_area'): $m[1][$k] = 'sCityArea'; break; case osc_get_preference('rewrite_search_category'): $m[1][$k] = 'sCategory'; break; case osc_get_preference('rewrite_search_user'): $m[1][$k] = 'sUser'; break; case osc_get_preference('rewrite_search_pattern'): $m[1][$k] = 'sPattern'; break; default: // custom fields if (preg_match("/meta(\\d+)-?(.*)?/", $m[1][$k], $results)) { $meta_key = $m[1][$k]; $meta_value = $m[2][$k]; $array_r = array(); if (Params::existParam('meta')) { $array_r = Params::getParam('meta'); } if ($results[2] == '') { // meta[meta_id] = meta_value $meta_key = $results[1]; $array_r[$meta_key] = $meta_value; } else { // meta[meta_id][meta_key] = meta_value $meta_key = $results[1]; $meta_key2 = $results[2]; $array_r[$meta_key][$meta_key2] = $meta_value; } $m[1][$k] = 'meta'; $m[2][$k] = $array_r; } break; } Params::setParam($m[1][$k], $m[2][$k]); } Params::unsetParam('sParams'); } } $uriParams = Params::getParamsAsArray(); $searchUri = osc_search_url($uriParams); if ($this->uri != 'feed') { if (str_replace("%20", '+', $searchUri) != str_replace("%20", '+', WEB_PATH . $this->uri)) { $this->redirectTo($searchUri, 301); } } //////////////////////////////// //GETTING AND FIXING SENT DATA// //////////////////////////////// $p_sCategory = Params::getParam('sCategory'); if (!is_array($p_sCategory)) { if ($p_sCategory == '') { $p_sCategory = array(); } else { $p_sCategory = explode(",", $p_sCategory); } } $p_sCityArea = Params::getParam('sCityArea'); if (!is_array($p_sCityArea)) { if ($p_sCityArea == '') { $p_sCityArea = array(); } else { $p_sCityArea = explode(",", $p_sCityArea); } } $p_sCity = Params::getParam('sCity'); if (!is_array($p_sCity)) { if ($p_sCity == '') { $p_sCity = array(); } else { $p_sCity = explode(",", $p_sCity); } } $p_sRegion = Params::getParam('sRegion'); if (!is_array($p_sRegion)) { if ($p_sRegion == '') { $p_sRegion = array(); } else { $p_sRegion = explode(",", $p_sRegion); } } $p_sCountry = Params::getParam('sCountry'); if (!is_array($p_sCountry)) { if ($p_sCountry == '') { $p_sCountry = array(); } else { $p_sCountry = explode(",", $p_sCountry); } } $p_sUser = Params::getParam('sUser'); if (!is_array($p_sUser)) { if ($p_sUser == '') { $p_sUser = ''; } else { $p_sUser = explode(",", $p_sUser); } } $p_sLocale = Params::getParam('sLocale'); if (!is_array($p_sLocale)) { if ($p_sLocale == '') { $p_sLocale = ''; } else { $p_sLocale = explode(",", $p_sLocale); } } $p_sPattern = trim(strip_tags(Params::getParam('sPattern'))); // ADD TO THE LIST OF LAST SEARCHES if (osc_save_latest_searches() && (!Params::existParam('iPage') || Params::getParam('iPage') == 1)) { $savePattern = osc_apply_filter('save_latest_searches_pattern', $p_sPattern); if ($savePattern != '') { LatestSearches::newInstance()->insert(array('s_search' => $savePattern, 'd_date' => date('Y-m-d H:i:s'))); } } $p_bPic = Params::getParam('bPic'); $p_bPic = $p_bPic == 1 ? 1 : 0; $p_bPremium = Params::getParam('bPremium'); $p_bPremium = $p_bPremium == 1 ? 1 : 0; $p_sPriceMin = Params::getParam('sPriceMin'); $p_sPriceMax = Params::getParam('sPriceMax'); //WE CAN ONLY USE THE FIELDS RETURNED BY Search::getAllowedColumnsForSorting() $p_sOrder = Params::getParam('sOrder'); if (!in_array($p_sOrder, Search::getAllowedColumnsForSorting())) { $p_sOrder = osc_default_order_field_at_search(); } $old_order = $p_sOrder; //ONLY 0 ( => 'asc' ), 1 ( => 'desc' ) AS ALLOWED VALUES $p_iOrderType = Params::getParam('iOrderType'); $allowedTypesForSorting = Search::getAllowedTypesForSorting(); $orderType = osc_default_order_type_at_search(); foreach ($allowedTypesForSorting as $k => $v) { if ($p_iOrderType == $v) { $orderType = $k; break; } } $p_iOrderType = $orderType; $p_sFeed = Params::getParam('sFeed'); $p_iPage = 0; if (is_numeric(Params::getParam('iPage')) && Params::getParam('iPage') > 0) { $p_iPage = intval(Params::getParam('iPage')) - 1; } if ($p_sFeed != '') { $p_sPageSize = 1000; } $p_sShowAs = Params::getParam('sShowAs'); $aValidShowAsValues = array('list', 'gallery'); if (!in_array($p_sShowAs, $aValidShowAsValues)) { $p_sShowAs = osc_default_show_as_at_search(); } // search results: it's blocked with the maxResultsPerPage@search defined in t_preferences $p_iPageSize = intval(Params::getParam('iPagesize')); if ($p_iPageSize > 0) { if ($p_iPageSize > osc_max_results_per_page_at_search()) { $p_iPageSize = osc_max_results_per_page_at_search(); } } else { $p_iPageSize = osc_default_results_per_page_at_search(); } //FILTERING CATEGORY $bAllCategoriesChecked = false; $successCat = false; if (count($p_sCategory) > 0) { foreach ($p_sCategory as $category) { $successCat = $this->mSearch->addCategory($category) || $successCat; } } else { $bAllCategoriesChecked = true; } //FILTERING CITY_AREA foreach ($p_sCityArea as $city_area) { $this->mSearch->addCityArea($city_area); } $p_sCityArea = implode(", ", $p_sCityArea); //FILTERING CITY foreach ($p_sCity as $city) { $this->mSearch->addCity($city); } $p_sCity = implode(", ", $p_sCity); //FILTERING REGION foreach ($p_sRegion as $region) { $this->mSearch->addRegion($region); } $p_sRegion = implode(", ", $p_sRegion); //FILTERING COUNTRY foreach ($p_sCountry as $country) { $this->mSearch->addCountry($country); } $p_sCountry = implode(", ", $p_sCountry); // FILTERING PATTERN if ($p_sPattern != '') { $this->mSearch->addPattern($p_sPattern); $osc_request['sPattern'] = $p_sPattern; } else { // hardcoded - if there isn't a search pattern, order by dt_pub_date desc if ($p_sOrder == 'relevance') { $p_sOrder = 'dt_pub_date'; foreach ($allowedTypesForSorting as $k => $v) { if ($p_iOrderType == 'desc') { $orderType = $k; break; } } $p_iOrderType = $orderType; } } // FILTERING USER if ($p_sUser != '') { $this->mSearch->fromUser($p_sUser); } // FILTERING LOCALE $this->mSearch->addLocale($p_sLocale); // FILTERING IF WE ONLY WANT ITEMS WITH PICS if ($p_bPic) { $this->mSearch->withPicture(true); } // FILTERING IF WE ONLY WANT PREMIUM ITEMS if ($p_bPremium) { $this->mSearch->onlyPremium(true); } //FILTERING BY RANGE PRICE $this->mSearch->priceRange($p_sPriceMin, $p_sPriceMax); //ORDERING THE SEARCH RESULTS $this->mSearch->order($p_sOrder, $allowedTypesForSorting[$p_iOrderType]); //SET PAGE if ($p_sFeed == 'rss') { // If param sFeed=rss, just output last 'osc_num_rss_items()' $this->mSearch->page(0, osc_num_rss_items()); } else { $this->mSearch->page($p_iPage, $p_iPageSize); } // CUSTOM FIELDS $custom_fields = Params::getParam('meta'); $fields = Field::newInstance()->findIDSearchableByCategories($p_sCategory); $table = DB_TABLE_PREFIX . 't_item_meta'; if (is_array($custom_fields)) { foreach ($custom_fields as $key => $aux) { if (in_array($key, $fields)) { $field = Field::newInstance()->findByPrimaryKey($key); switch ($field['e_type']) { case 'TEXTAREA': case 'TEXT': case 'URL': if ($aux != '') { $aux = "%{$aux}%"; $sql = "SELECT fk_i_item_id FROM {$table} WHERE "; $str_escaped = Search::newInstance()->dao->escape($aux); $sql .= $table . '.fk_i_field_id = ' . $key . ' AND '; $sql .= $table . ".s_value LIKE " . $str_escaped; $this->mSearch->addConditions(DB_TABLE_PREFIX . 't_item.pk_i_id IN (' . $sql . ')'); } break; case 'DROPDOWN': case 'RADIO': if ($aux != '') { $sql = "SELECT fk_i_item_id FROM {$table} WHERE "; $str_escaped = Search::newInstance()->dao->escape($aux); $sql .= $table . '.fk_i_field_id = ' . $key . ' AND '; $sql .= $table . ".s_value = " . $str_escaped; $this->mSearch->addConditions(DB_TABLE_PREFIX . 't_item.pk_i_id IN (' . $sql . ')'); } break; case 'CHECKBOX': if ($aux != '') { $sql = "SELECT fk_i_item_id FROM {$table} WHERE "; $sql .= $table . '.fk_i_field_id = ' . $key . ' AND '; $sql .= $table . ".s_value = 1"; $this->mSearch->addConditions(DB_TABLE_PREFIX . 't_item.pk_i_id IN (' . $sql . ')'); } break; case 'DATE': if ($aux != '') { $y = (int) date('Y', $aux); $m = (int) date('n', $aux); $d = (int) date('j', $aux); $start = mktime('0', '0', '0', $m, $d, $y); $end = mktime('23', '59', '59', $m, $d, $y); $sql = "SELECT fk_i_item_id FROM {$table} WHERE "; $sql .= $table . '.fk_i_field_id = ' . $key . ' AND '; $sql .= $table . ".s_value >= " . $start . " AND "; $sql .= $table . ".s_value <= " . $end; $this->mSearch->addConditions(DB_TABLE_PREFIX . 't_item.pk_i_id IN (' . $sql . ')'); } break; case 'DATEINTERVAL': if (is_array($aux) && (!empty($aux['from']) && !empty($aux['to']))) { $from = $aux['from']; $to = $aux['to']; $start = $from; $end = $to; $sql = "SELECT fk_i_item_id FROM {$table} WHERE "; $sql .= $table . '.fk_i_field_id = ' . $key . ' AND '; $sql .= $start . " >= " . $table . ".s_value AND s_multi = 'from'"; $sql1 = "SELECT fk_i_item_id FROM {$table} WHERE "; $sql1 .= $table . ".fk_i_field_id = " . $key . " AND "; $sql1 .= $end . " <= " . $table . ".s_value AND s_multi = 'to'"; $sql_interval = "select a.fk_i_item_id from (" . $sql . ") a where a.fk_i_item_id IN (" . $sql1 . ")"; $this->mSearch->addConditions(DB_TABLE_PREFIX . 't_item.pk_i_id IN (' . $sql_interval . ')'); } break; default: break; } } } } osc_run_hook('search_conditions', Params::getParamsAsArray()); // RETRIEVE ITEMS AND TOTAL $key = md5(osc_base_url() . $this->mSearch->toJson()); $found = null; $cache = osc_cache_get($key, $found); $aItems = null; $iTotalItems = null; if ($cache) { $aItems = $cache['aItems']; $iTotalItems = $cache['iTotalItems']; } else { $aItems = $this->mSearch->doSearch(); $iTotalItems = $this->mSearch->count(); $_cache['aItems'] = $aItems; $_cache['iTotalItems'] = $iTotalItems; osc_cache_set($key, $_cache, OSC_CACHE_TTL); } $iStart = $p_iPage * $p_iPageSize; $iEnd = min(($p_iPage + 1) * $p_iPageSize, $iTotalItems); $iNumPages = ceil($iTotalItems / $p_iPageSize); // works with cache enabled ? osc_run_hook('search', $this->mSearch); //preparing variables... $countryName = $p_sCountry; if (strlen($p_sCountry) == 2) { $c = Country::newInstance()->findByCode($p_sCountry); if ($c) { $countryName = $c['s_name']; } } $regionName = $p_sRegion; if (is_numeric($p_sRegion)) { $r = Region::newInstance()->findByPrimaryKey($p_sRegion); if ($r) { $regionName = $r['s_name']; } } $cityName = $p_sCity; if (is_numeric($p_sCity)) { $c = City::newInstance()->findByPrimaryKey($p_sCity); if ($c) { $cityName = $c['s_name']; } } $this->_exportVariableToView('search_start', $iStart); $this->_exportVariableToView('search_end', $iEnd); $this->_exportVariableToView('search_category', $p_sCategory); // hardcoded - non pattern and order by relevance $p_sOrder = $old_order; $this->_exportVariableToView('search_order_type', $p_iOrderType); $this->_exportVariableToView('search_order', $p_sOrder); $this->_exportVariableToView('search_pattern', $p_sPattern); $this->_exportVariableToView('search_from_user', $p_sUser); $this->_exportVariableToView('search_total_pages', $iNumPages); $this->_exportVariableToView('search_page', $p_iPage); $this->_exportVariableToView('search_has_pic', $p_bPic); $this->_exportVariableToView('search_only_premium', $p_bPremium); $this->_exportVariableToView('search_country', $countryName); $this->_exportVariableToView('search_region', $regionName); $this->_exportVariableToView('search_city', $cityName); $this->_exportVariableToView('search_price_min', $p_sPriceMin); $this->_exportVariableToView('search_price_max', $p_sPriceMax); $this->_exportVariableToView('search_total_items', $iTotalItems); $this->_exportVariableToView('items', $aItems); $this->_exportVariableToView('search_show_as', $p_sShowAs); $this->_exportVariableToView('search', $this->mSearch); // json $json = $this->mSearch->toJson(); $encoded_alert = base64_encode(osc_encrypt_alert($json)); // Create the HMAC signature and convert the resulting hex hash into base64 $stringToSign = osc_get_alert_public_key() . $encoded_alert; $signature = hex2b64(hmacsha1(osc_get_alert_private_key(), $stringToSign)); $server_signature = Session::newInstance()->_set('alert_signature', $signature); $this->_exportVariableToView('search_alert', $encoded_alert); // calling the view... if (count($aItems) === 0) { header('HTTP/1.1 404 Not Found'); } osc_run_hook("after_search"); if (!Params::existParam('sFeed')) { $this->doView('search.php'); } else { if ($p_sFeed == '' || $p_sFeed == 'rss') { // FEED REQUESTED! header('Content-type: text/xml; charset=utf-8'); $feed = new RSSFeed(); $feed->setTitle(__('Latest listings added') . ' - ' . osc_page_title()); $feed->setLink(osc_base_url()); $feed->setDescription(__('Latest listings added in') . ' ' . osc_page_title()); if (osc_count_items() > 0) { while (osc_has_items()) { if (osc_count_item_resources() > 0) { osc_has_item_resources(); $feed->addItem(array('title' => osc_item_title(), 'link' => htmlentities(osc_item_url(), ENT_COMPAT, "UTF-8"), 'description' => osc_item_description(), 'country' => osc_item_country(), 'region' => osc_item_region(), 'city' => osc_item_city(), 'city_area' => osc_item_city_area(), 'category' => osc_item_category(), 'dt_pub_date' => osc_item_pub_date(), 'image' => array('url' => htmlentities(osc_resource_thumbnail_url(), ENT_COMPAT, "UTF-8"), 'title' => osc_item_title(), 'link' => htmlentities(osc_item_url(), ENT_COMPAT, "UTF-8")))); } else { $feed->addItem(array('title' => osc_item_title(), 'link' => htmlentities(osc_item_url(), ENT_COMPAT, "UTF-8"), 'description' => osc_item_description(), 'country' => osc_item_country(), 'region' => osc_item_region(), 'city' => osc_item_city(), 'city_area' => osc_item_city_area(), 'category' => osc_item_category(), 'dt_pub_date' => osc_item_pub_date())); } } } osc_run_hook('feed', $feed); $feed->dumpXML(); } else { osc_run_hook('feed_' . $p_sFeed, $aItems); } } }
function related_listings() { View::newInstance()->_exportVariableToView('items', array()); $mSearch = new Search(); $mSearch->addCategory(osc_item_category_id()); $mSearch->addRegion(osc_item_region()); $mSearch->addItemConditions(sprintf("%st_item.pk_i_id < %s ", DB_TABLE_PREFIX, osc_item_id())); $mSearch->limit('0', '6'); $aItems = $mSearch->doSearch(); $iTotalItems = count($aItems); if ($iTotalItems == 6) { View::newInstance()->_exportVariableToView('items', $aItems); return $iTotalItems; } unset($mSearch); $mSearch = new Search(); $mSearch->addCategory(osc_item_category_id()); $mSearch->addItemConditions(sprintf("%st_item.pk_i_id != %s ", DB_TABLE_PREFIX, osc_item_id())); $mSearch->limit('0', '5'); $aItems = $mSearch->doSearch(); $iTotalItems = count($aItems); if ($iTotalItems > 0) { View::newInstance()->_exportVariableToView('items', $aItems); return $iTotalItems; } unset($mSearch); return 0; }
function SeoGenerateTitleListing() { $sort_order = array(); $elements = array(); $del = Delimiter(); if (osc_get_preference('allSeo_city_show', 'plugin-all_in_one') == 1) { if (osc_item_city() != '') { $elements[] = osc_item_city(); $sort_order[] = osc_get_preference('allSeo_city_order', 'plugin-all_in_one'); } } if (osc_get_preference('allSeo_region_show', 'plugin-all_in_one') == 1) { if (osc_item_region() != '') { $elements[] = osc_item_region(); $sort_order[] = osc_get_preference('allSeo_region_order', 'plugin-all_in_one'); } } if (osc_get_preference('allSeo_country_show', 'plugin-all_in_one') == 1) { if (osc_item_country() != '') { $elements[] = osc_item_country(); $sort_order[] = osc_get_preference('allSeo_country_order', 'plugin-all_in_one'); } } if (osc_get_preference('allSeo_title_show', 'plugin-all_in_one') == 1) { if (osc_get_preference('allSeo_page_title', 'plugin-all_in_one') == '') { $elements[] = osc_page_title(); } else { $elements[] = osc_get_preference('allSeo_page_title', 'plugin-all_in_one'); } $sort_order[] = osc_get_preference('allSeo_title_order', 'plugin-all_in_one'); } if (osc_get_preference('allSeo_category_show', 'plugin-all_in_one') == 1) { $elements[] = osc_item_category(); $sort_order[] = osc_get_preference('allSeo_category_order', 'plugin-all_in_one'); } if (GetItemTitle(osc_item_id()) == '') { $elements[] = osc_item_title(); } else { $elements[] = GetItemTitle(osc_item_id()); } $sort_order[] = osc_get_preference('allSeo_body_order', 'plugin-all_in_one'); array_multisort($sort_order, $elements); $elements = array_filter($elements); return implode($del, $elements); }
function meta_keywords() { $text = ''; // search if (osc_is_search_page()) { if (osc_has_items()) { $keywords = array(); $keywords[] = osc_item_category(); if (osc_item_city() != '') { $keywords[] = osc_item_city(); $keywords[] = sprintf('%s %s', osc_item_category(), osc_item_city()); } if (osc_item_region() != '') { $keywords[] = osc_item_region(); $keywords[] = sprintf('%s %s', osc_item_category(), osc_item_region()); } if (osc_item_city() != '' && osc_item_region() != '') { $keywords[] = sprintf('%s %s %s', osc_item_category(), osc_item_region(), osc_item_city()); $keywords[] = sprintf('%s %s', osc_item_region(), osc_item_city()); } $text = implode(', ', $keywords); } osc_reset_items(); } // listing if (osc_is_ad_page()) { $keywords = array(); $keywords[] = osc_item_category(); if (osc_item_city() != '') { $keywords[] = osc_item_city(); $keywords[] = sprintf('%s %s', osc_item_category(), osc_item_city()); } if (osc_item_region() != '') { $keywords[] = osc_item_region(); $keywords[] = sprintf('%s %s', osc_item_category(), osc_item_region()); } if (osc_item_city() != '' && osc_item_region() != '') { $keywords[] = sprintf('%s %s %s', osc_item_category(), osc_item_region(), osc_item_city()); $keywords[] = sprintf('%s %s', osc_item_region(), osc_item_city()); } $text = implode(', ', $keywords); } return osc_apply_filter('meta_keywords_filter', $text); }
/** * Get the location separated by commas of a row * * @since 3.2 * * @return string Location separated by commas */ private function get_row_location() { $location = array(); if( osc_item_city() !== '' ) { $location[] = osc_item_city(); } if( osc_item_region() !== '' ) { $location[] = osc_item_region(); } if( osc_item_country() !== '' ) { $location[] = osc_item_country(); } return implode(', ', $location); }
function seo_meta_keywords_filter() { $text = ''; //home page if (osc_is_home_page()) { if (osc_get_preference('seo_metakeywords_home', 'seo_plugin')) { $text = osc_get_preference('seo_metakeywords_home', 'seo_plugin'); } } // static page if (osc_is_static_page()) { if (osc_get_preference('seo_metakeywords_page_' . osc_static_page_id(), 'seo_plugin')) { $text = osc_get_preference('seo_metakeywords_page_' . osc_static_page_id(), 'seo_plugin'); } } //contact page if (osc_is_contact_page()) { if (osc_get_preference('seo_metakeywords_page_contact', 'seo_plugin')) { $text = osc_get_preference('seo_metakeywords_page_contact', 'seo_plugin'); } } // search if (osc_is_search_page()) { if (osc_has_items()) { $keywords = array(); $keywords[] = osc_item_category(); if (osc_item_city() != '') { $keywords[] = osc_item_city(); $keywords[] = sprintf('%s %s', osc_item_category(), osc_item_city()); } if (osc_item_region() != '') { $keywords[] = osc_item_region(); $keywords[] = sprintf('%s %s', osc_item_category(), osc_item_region()); } if (osc_item_city() != '' && osc_item_region() != '') { $keywords[] = sprintf('%s %s %s', osc_item_category(), osc_item_region(), osc_item_city()); $keywords[] = sprintf('%s %s', osc_item_region(), osc_item_city()); } $text = implode(', ', $keywords); } osc_reset_items(); } // listing if (osc_is_ad_page()) { $detail = seo_get_row(osc_item_id()); if (empty($detail['seo_item_meta_keywords'])) { $keywords = array(); $keywords[] = osc_item_category(); if (osc_item_city() != '') { $keywords[] = osc_item_city(); $keywords[] = sprintf('%s %s', osc_item_category(), osc_item_city()); } if (osc_item_region() != '') { $keywords[] = osc_item_region(); $keywords[] = sprintf('%s %s', osc_item_category(), osc_item_region()); } if (osc_item_city() != '' && osc_item_region() != '') { $keywords[] = sprintf('%s %s %s', osc_item_category(), osc_item_region(), osc_item_city()); $keywords[] = sprintf('%s %s', osc_item_region(), osc_item_city()); } $text = implode(', ', $keywords); } else { $text = $detail['seo_item_meta_keywords']; } } return $text; }
?> </span> <!-- <span class="listing-category"><a href="<?php echo $category_url; ?> "><?php echo osc_item_category(); ?> </a></span> --> <?php if (osc_item_city() !== '') { $location = osc_item_city(); } if (osc_item_region() !== '') { $location .= ' (' . osc_item_region() . ')'; } ?> <?php if ($location && Params::getParam('page') != 'user' && Params::getParam('_page') != 'user') { ?> <div class="listing-location"> <i class="fa fa-map-marker"></i> <?php echo $location; ?> </div> <?php } ?> <?php
function pop_get_listing_location_string($aItem) { $aux_item = View::newInstance()->_get('item'); View::newInstance()->_exportVariableToView('item', $aItem); $location = array(); if (osc_item_city_area() !== '') { $location[] = osc_item_city_area(); } if (osc_item_city() !== '') { $location[] = osc_item_city(); } if (osc_item_region() !== '') { $location[] = osc_item_region(); } if (osc_item_country() !== '') { $location[] = osc_item_country(); } View::newInstance()->_exportVariableToView('item', $aux_item); return implode(', ', $location); }
<?php $location = array(); if (osc_item_region() !== '') { $location[] = osc_item_region(); } if (osc_item_city() !== '') { $location[] = osc_item_city(); } if (osc_item_city_area() !== '') { $location[] = osc_item_city_area(); } // meta tag robots osc_add_hook('header', 'pop_follow_construct'); pop_add_body_class('item'); osc_enqueue_script('jquery-validate'); osc_enqueue_script('jquery-bxslider'); osc_enqueue_style('jquery-bxslider-css', osc_current_web_theme_url('css/jquery.bxslider.css')); osc_enqueue_script('imgLiquid-js'); View::newInstance()->_exportVariableToView('user', User::newInstance()->findByPrimaryKey(osc_item_user_id())); ?> <?php osc_current_web_theme_path('header.php'); $class = ''; if (osc_count_item_resources() == 0) { $class = "no-image"; } ?> <div class="container"> <div class="row">
" rel="nofollow"><?php _e('offensive', 'realestate'); ?> </a> </div> <div class="ui-content-box details-box"> <?php if (osc_price_enabled_at_items()) { echo '<div class="price">' . osc_item_formated_price() . '</div>'; } if (osc_item_country() != "" || osc_item_region() != '') { echo '<div class="has-icon"><div class="ico-location ico"></div>'; if (osc_item_region() != "") { $tempData = osc_item_region(); if (osc_item_field("fk_i_region_id") != "") { $tempData = '<a href="' . osc_search_url(array('sRegion' => osc_item_field("fk_i_region_id"))) . '">' . osc_item_region() . '</a>'; } echo $tempData; } echo '<div class="mini">'; if (osc_item_city() != "") { $tempData = osc_item_city(); if (osc_item_field("fk_i_city_id") != "") { $tempData = '<a href="' . osc_search_url(array('sCity' => osc_item_field("fk_i_city_id"))) . '">' . osc_item_city() . '</a>'; } echo $tempData; } echo '</div>'; echo '</div>'; } //echo join(', ',$regionData);
<?php if (osc_price_enabled_at_items()) { ?> <span><?php echo osc_format_price(osc_item_price()); ?> </span><?php } ?> </div> <div class="col-md-7 col-sm-7 col-xs-7 location"> <i class="glyphicon glyphicon-map-marker"></i><?php if (osc_item_region()) { ?> <?php echo osc_item_region(); } else { ?> <?php echo osc_item_country(); } ?> </div> </div> </div> </div> </div> <?php } ?> <?php
function seo_format_value($value) { switch ($value) { case 'country': return osc_item_country(); break; case 'region': return osc_item_region(); break; case 'city': return osc_item_city(); break; default: return $value; break; } }