Пример #1
0
        $pg = 1;
    }
    $engine = new SearchEngine($i);
    if (!empty($_GET['count'])) {
        if (preg_match("/^\\d+\$/", $_GET['count'])) {
            $engine->criteria->resultsperpage = $_GET['count'];
        } elseif ($_GET['count'] == -1) {
            $engine->criteria->resultsperpage = 999999999;
        }
        if ($hardlimit) {
            $engine->criteria->resultsperpage = min($engine->criteria->resultsperpage, $hardlimit);
        }
    }
    //return a recordset
    //if want en then we HAVE to use the non cached version!
    $recordSet = $engine->ReturnRecordset($pg, isset($_GET['en']));
} elseif (!empty($_GET['en']) || !empty($_GET['ppos'])) {
    if (!empty($_GET['ftf'])) {
        $mod_sql .= " and ftf = 1";
    }
    $recordSet =& $db->Execute("select gridimage_id,title,title2,grid_reference,gi.realname as credit_realname,if(gi.realname!='',gi.realname,user.realname) as realname,imageclass,nateastings,natnorthings,if(use6fig=1,6,natgrlen) as natgrlen,gi.user_id {$sql_from} \r\n\tfrom user \r\n\tinner join gridimage gi using(user_id) \r\n\tinner join gridsquare using(gridsquare_id) \r\n\twhere {$mod_sql} {$sql_crit}");
} else {
    if (!empty($_GET['supp'])) {
        $mod_sql = 1;
        //no point checking what will always be 1 ;-)
    }
    if (!empty($_GET['ftf'])) {
        $mod_sql .= " and ftf = 1";
    }
    $recordSet =& $db->Execute("select gridimage_id,title,title2,grid_reference,credit_realname,realname,imageclass,user_id {$sql_from} \r\n\tfrom gridimage_search gi \r\n\twhere {$mod_sql} {$sql_crit}");
}