Zau4man

Warning: Invalid argument supplied for foreach() in Z:\home\instant2test2\www\templates\default\controllers\search\index.tpl.php on line 67

<?php
 
class onAfishaFulltextSearch extends cmsAction {
 
    public function run($data){
 
	list($model, $ctype) = $data;
 
 
	$sql_fields = array('event', 'info');
	$default_fields=array('id','id','date');
	$results_count = $model->getSearchResultsCount('afisha_events', $sql_fields, $default_fields);
 
	if ($results_count){
 
	    $result = $model->getSearchResults('afisha_events', $sql_fields, $default_fields);
 
	}
 
	$results[] = array(
                    'title' => 'Афиша',
                    'name' => 'afisha',
                    'items' => $result,
                    'count' => $results_count
                );
 
	return $results;
 
    }
 
}
 

$sql = "SELECT {$select_fields}
                FROM cms_{$table_name}
                WHERE is_pub = 1 AND MATCH({$sql_fields}) AGAINST ('{$query}' IN BOOLEAN MODE)
                ";

if ($this->date_interval != 'all'){
 
            switch ($this->date_interval){
                case 'w':
                    $sql .= "AND DATEDIFF(NOW(), date_pub) <= 7 \n";
                    break;
                case 'm':
                    $sql .= "AND DATE_SUB(NOW(), INTERVAL 1 MONTH) < date_pub \n";
                    break;
                case 'y':
                    $sql .= "AND DATE_SUB(NOW(), INTERVAL 1 YEAR) < date_pub \n";
                    break;
            }
 
        }