'.
''.
' Online Games > Search > '.$search.' ('.$maxrec.')
| ');
$rcnt=1;
/*
if( ($result = mysql_query("select d.data_id,d.title,d.des,d.picture,d.filesize,d.cat_id,d.created_dt,d.member_id".
",(TO_DAYS(now())-TO_DAYS(d.hit_dt)+1) numdays".
",(d.hit_cnt+hit_quick) as total".
",((d.hit_cnt+hit_quick)/(TO_DAYS(now())-TO_DAYS(d.hit_dt)+1)) as avgcnt".
",CONCAT(m.name_first,' ',m.name_last) as name,website,cp_name,cp_website".
",cat_string,f.format_name,d.rate_avg,rate_cnt".
" from ap_game_data d,ap_members m,ap_game_cat c,ref_format f".
" where d.url<>'' and d.status=1 and d.member_id=m.member_id and d.cat_id=c.cat_id and d.format_id=f.format_id".$sqlfilter.
" order by (d.rate_avg*(rate_cnt/2)) desc,rate_cnt desc LIMIT ".($recstart-1).",".$maxshown,$db)) ){
//*/
if( ($result = mysql_query("select d.data_id,d.title,d.des,d.picture,d.filesize,d.cat_id,d.created_dt,d.member_id".
",author_name as name,author_url as website,author_cp_name as cp_name,author_cp_url as cp_website".
",cat_string,f.format_name,d.rate_avg,rate_cnt".
" from ap_game_data d,ap_game_cat c,ref_format f".
" where d.url<>'' and d.status=1 and d.cat_id=c.cat_id and d.format_id=f.format_id".$sqlfilter.
" order by (d.rate_avg*(rate_cnt/2)) desc,rate_cnt desc LIMIT ".($recstart-1).",".$maxshown,$db)) ){
while( ($row = mysql_fetch_array($result))){
if(++$rcnt>1){if($grandtotal>0)print('');print('');$rcnt=0;}
print(addrow($row,$totalcnt));
$grandtotal++;
$totalcnt++;
}
mysql_free_result($result);
if($grandtotal==0)print('
No Results Found.
| ');
else{
if(++$rcnt==1)print('
|
| ');
if($grandtotal>0)print('');
}
}
else{
print('
We are currently updating our database. Please use our search feature at a later time.
| ');
}
mysql_close($db);
print(' |