EstateAgent Improved актуальные вопросы и их решения - страница 2 - EstateAgent

$order = $mainframe->getUserStateFromRequest( 'com_estateagent.order','order','value' );

$order = $mainframe->getUserStateFromRequest( 'com_estateagent.order','order','created' );

$poisk = JRequest::getInt( 'poisk', 0 );
$district='';
	switch( $poisk ) {
		case 1:	$district=" AND district='first'";
		break;
		case 2: $district="AND district='second'";
		break;
		case 3: $district="AND district='third'";
		break;
		default:$district="";
		break;	}

.$district." "

$query = "SELECT COUNT(*) FROM #__estateagent WHERE ("
				. "\n ((publish_up >= '$nullDate' AND publish_up <= '$today') AND publish_down >= '$today')"
. "\n OR ((publish_up >= '$nullDate' AND publish_up <= '$today' ) AND (publish_down = '$nullDate' OR publish_down >= '$today'))"
. "\n OR (publish_up = '$nullDate' AND publish_down = '$nullDate')"
				. "\n )"
. "\n AND access<=$gid AND published='1' ".$cselecttype;

	$query  = "SELECT COUNT(*) FROM #__estateagent WHERE ("
				. "\n ((publish_up >= '$nullDate' AND publish_up <= '$today') AND publish_down >= '$today')"
       			. "\n OR ((publish_up >= '$nullDate' AND publish_up <= '$today' ) AND (publish_down = '$nullDate' OR publish_down >= '$today'))"
       			. "\n OR (publish_up = '$nullDate' AND publish_down = '$nullDate')"
				. "\n )"
       			. "\n AND access<=$gid AND published='1' ".$district." ".$cselecttype; 

.$district." "