$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}"); }