**/ // ensure this file is being included by a parent file defined( '_VALID_MOS' ) or die( 'Direct Access to this location is not allowed.' ); //global $database, $mainframe, $my, $Itemid; $now = date( "Y-m-d H:i:s", time()+$mosConfig_offset*60*60 ); $menu= new mosMenu( $database ); $menu->load( 1 ); $params = mosParseParams( $menu->params ); $count = isset( $params->count ) ? $params->count : 6; $orderby = @$params->orderby; switch (strtolower( $orderby )) { case 'latest': $orderby = "p.created DESC"; break; case 'hottest': $orderby = "p.hits DESC"; break; default: $orderby = "p.created DESC"; break; } $sql = "SELECT p.id, p.name, p.intro_text FROM #__hp_properties AS p" . "\nLEFT JOIN #__hp_prop_types AS t ON p.type = t.id" . "\nLEFT JOIN #__hp_featured AS f ON f.property = p.id" . "\nWHERE p.published='1' AND p.approved='1' AND t.published='1'" . "\n AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '$now')" . "\n AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '$now')" . "\nORDER BY ".$orderby . ($count ? " LIMIT $count" : ""); $database->setQuery( $sql ); $rows = $database->loadObjectList(); header('Content-type: application/xml'); $encoding = split("=", _ISO); echo ""; ?> http://www.direct2owner.co.uk com_hotproperty en-us Sun, 05 Sep 2010 15:00:13 +0100 http://www.direct2owner.co.uk/images/M_images/mos_rss.png http://www.direct2owner.co.uk 88