'top-downloads','free-name'=>'free-top-downloads','weekly-downloads'=>'top-downloads','free-weekly-downloads'=>'free-top-downloads','most-popular-download'=>'total-top-downloads','latest-update-software'=>'new-releases','weekly-hot-software'=>'top-downloads','freeware-download'=>'free-top-downloads','editor-pick-software'=>'new-picks');
if($sort&&(!array_key_exists($sort,$defined_sort_options)))
{
if(array_key_exists($sort,$deprecated_sort_options))
{
$redirect_url=1;
}
else
{
require(EDOWN_PATH."info/page-not-found/index.php");
exit;
}
}
//Check if classpath needs redirection
$_classpath=$_GET['platform'];
$_classpath.=$_GET['categorypath']?'/'.$_GET['categorypath']:'';
$_classpath.=$_GET['subcategorypath']?'/'.$_GET['subcategorypath']:'';
if($_classpath!=$classpath)
{
$redirect_url=1;
}
//Check if page needs redirection
if($page=='') //No page string
{
$page=1;
}
else
{
$page=CheckInt($page);
if($page<2)
{
$redirect_url=1;
}
}
//Defined Variable
$lencord=$add[lencord]?$add[lencord]:10;
$offset=($page-1)*$lencord;
$maxcord=$page*$lencord;
if($maxcord>$sphinx_max_matches)
{
require(EDOWN_PATH."info/page-not-found/index.php");
exit;
}
//Redirecting
if($redirect_url)
{
$actual_url=EDReturnClassUrl($classpath_r[$classpath][classid]);
if($sort)
{
$actual_url.=array_key_exists($sort,$deprecated_sort_options)?$deprecated_sort_options[$sort].'/':$sort.'/';
}
$actual_url.=($page>1)?$page.'/':'';
Header("HTTP/1.1 301 Moved Permanently");
Header("Location: ".$actual_url);
exit;
}
//Query Class Info
$link=db_connect();
$empire=new mysqlquery();
$add=$empire->fetch1("select * from {$dbtbpre}class where classid='".$classpath_r[$classpath][classid]."' and showclass=1");
db_close();
$empire=null;
if(!$add['classid'])
{
require(EDOWN_PATH."info/page-not-found/index.php");
exit;
}
if(!$sort)//生成分类封面文件
{
$GLOBALS['nav_class_id']=$add[classid];
$navadd['page_header_meta']='';
$navadd['page_header_link']='';
$navadd['page_title']=$add['classalias']." Download";
$navadd['page_keywords']=$add['classkey'];
$navadd['page_description']=$add['classintro'];
$navadd['page_span']="".$add['classalias']." Download
";
$navadd['page_login_status']=GetPageLoginStatus();
$navadd['nav_menu']='';
$navadd['nav_link']=ReturnClassNavLink($add['classid']).' '.$public_r[navfh].' '.$add[classname].'';
$add['category_subject']=''.$add[classalias].'';
$sphinx=new SphinxClient();
$sphinx=InitSphinx();
@include(EDOWN_PATH."data/template/cover_temp_".$add[covertempid].".php");
exit;
}
//Defined Variable
$GLOBALS['nav_class_id']=$add[classid];
$is_license_filter_free=(strpos($sort,'free')===false)?false:true;
$sort_free_prefix=$is_license_filter_free?'free-':'';
$page_string=($page==1)?"":" - Page ".$page;
if($add[islast])//终极分类
{
$filter_classid="classid";
}
elseif($add[bclassid]==0) //根分类
{
$filter_classid="platformid";
}
else//大分类
{
$filter_classid="categoryid";
}
$filtervals_classid = array($add[classid]);
//Loading Sort Options
$base_class_url=EDReturnClassUrl($add[classid]);
$defined_sort_options['new-releases']=array('sort_string'=>'Date Released','display_string'=>'- New Releases','sort_by'=>'release_date desc, downloads_last_week desc, @id desc','link_url'=>$base_class_url.'new-releases/');
$defined_sort_options['free-new-releases']=array('sort_string'=>'Date Released','display_string'=>'For Free - New Releases','sort_by'=>'release_date desc, downloads_last_week desc, @id desc','link_url'=>$base_class_url.'free-new-releases/');
$defined_sort_options['new-updates']=array('sort_string'=>'Date Updated','display_string'=>'- New Updates','sort_by'=>'release_date desc, downloads_last_week desc, @id desc','link_url'=>$base_class_url.'new-updates/');
$defined_sort_options['free-new-updates']=array('sort_string'=>'Date Updated','display_string'=>'For Free - New Updates','sort_by'=>'release_date desc, downloads_last_week desc, @id desc','link_url'=>$base_class_url.'free-new-updates/');
$defined_sort_options['new-picks']=array('sort_string'=>'Date Picked','display_string'=>'- New Picks','sort_by'=>'release_date desc, downloads_last_week desc, @id desc','link_url'=>$base_class_url.'new-picks/');
$defined_sort_options['free-new-picks']=array('sort_string'=>'Date Picked','display_string'=>'For Free - New Picks','sort_by'=>'release_date desc, downloads_last_week desc, @id desc','link_url'=>$base_class_url.'free-new-picks/');
$defined_sort_options['top-downloads']=array('sort_string'=>'Last Week Downloads','display_string'=>'- Top Downloads','sort_by'=>'downloads_last_week desc, release_date desc, @id desc','link_url'=>$base_class_url.'top-downloads/');
$defined_sort_options['free-top-downloads']=array('sort_string'=>'Last Week Downloads','display_string'=>'For Free - Top Downloads','sort_by'=>'downloads_last_week desc, release_date desc, @id desc','link_url'=>$base_class_url.'free-top-downloads/');
$defined_sort_options['total-top-downloads']=array('sort_string'=>'Total Downloads','display_string'=>'- Total Top Downloads','sort_by'=>'downloads_total desc, downloads_last_week desc, release_date desc, @id desc','link_url'=>$base_class_url.'total-top-downloads/');
$defined_sort_options['free-total-top-downloads']=array('sort_string'=>'Total Downloads','display_string'=>'For Free - Total Top Downloads','sort_by'=>'downloads_total desc, downloads_last_week desc, release_date desc, @id desc','link_url'=>$base_class_url.'free-total-top-downloads/');
$defined_sort_options['top-editor-rating']=array('sort_string'=>'Editor Rating','display_string'=>'- Top Editor Rating','sort_by'=>'editor_rating desc, downloads_last_week desc, release_date desc, @id desc','link_url'=>$base_class_url.'top-editor-rating/');
$defined_sort_options['free-top-editor-rating']=array('sort_string'=>'Editor Rating','display_string'=>'For Free - Top Editor Rating','sort_by'=>'editor_rating desc, downloads_last_week desc, release_date desc, @id desc','link_url'=>$base_class_url.'free-top-editor-rating/');
$defined_sort_options['top-user-rating']=array('sort_string'=>'User Rating','display_string'=>'- Top User Rating','sort_by'=>'user_rating_average desc, downloads_last_week desc, release_date desc, @id desc','link_url'=>$base_class_url.'top-user-rating/');
$defined_sort_options['free-top-user-rating']=array('sort_string'=>'User Rating','display_string'=>'For Free - Top User Rating','sort_by'=>'user_rating_average desc, downloads_last_week desc, release_date desc, @id desc','link_url'=>$base_class_url.'free-top-user-rating/');
//Define Sort Link LI
$defined_sort_options[$sort_free_prefix.'new-releases']['sort_link_li']='Date Released';
$defined_sort_options[$sort_free_prefix.'new-updates']['sort_link_li']='Date Updated';
$defined_sort_options[$sort_free_prefix.'top-downloads']['sort_link_li']='Last Week Downloads';
$defined_sort_options[$sort_free_prefix.'total-top-downloads']['sort_link_li']='Total Downloads';
$defined_sort_options[$sort_free_prefix.'top-editor-rating']['sort_link_li']='Editor Rating';
$defined_sort_options[$sort_free_prefix.'top-user-rating']['sort_link_li']='User Rating';
$defined_sort_options[$sort]['sort_link_li']='';
//生成查询语句
$index="index_apponic_download_software";
$select="id,title,version,icon,short_desc,publisher_id,publisher_name,classid,license_id,release_date,editor_rating,filename,title_former,titleurl,user_rating_average,downloads_total,downloads_last_week";
$sphinx=new SphinxClient();
$sphinx=InitSphinx();
//Main Search Query 0
$sphinx->SetFilter($filter_classid,$filtervals_classid);
if($is_license_filter_free)
{
$sphinx->SetFilter("isfree",array(1));
}
if(strpos($sort,'new-picks')!==false)
{
$sphinx->SetFilter("ispicked",array(1));
}
if(strpos($sort,'new-updates')!==false)
{
$sphinx->SetFilter("isupdated",array(1));
}
$sphinx->SetFilter("ischecked",array(1));
$sphinx->SetSortMode(SPH_SORT_EXTENDED,$defined_sort_options[$sort]['sort_by']);
$sphinx->SetSelect($select);
$sphinx->SetLimits($offset,$lencord,$maxcord);
$sphinx->AddQuery("",$index);
//All license types - Search Query 1
$sphinx=ResetSphinx();
$sphinx->SetFilter($filter_classid,$filtervals_classid);
if(strpos($sort,'new-picks')!==false)
{
$sphinx->SetFilter("ispicked",array(1));
}
if(strpos($sort,'new-updates')!==false)
{
$sphinx->SetFilter("isupdated",array(1));
}
$sphinx->SetFilter("ischecked",array(1));
$sphinx->SetSortMode(SPH_SORT_EXTENDED,"@id desc");
$sphinx->SetSelect("id");
$sphinx->SetLimits(0,1,1);
$sphinx->AddQuery("",$index);
//Only free software - Search Query 2
$sphinx=ResetSphinx();
$sphinx->SetFilter($filter_classid,$filtervals_classid);
$sphinx->SetFilter("isfree",array(1));
if(strpos($sort,'new-picks')!==false)
{
$sphinx->SetFilter("ispicked",array(1));
}
if(strpos($sort,'new-updates')!==false)
{
$sphinx->SetFilter("isupdated",array(1));
}
$sphinx->SetFilter("ischecked",array(1));
$sphinx->SetSortMode(SPH_SORT_EXTENDED,"@id desc");
$sphinx->SetSelect("id");
$sphinx->SetLimits(0,1,1);
$sphinx->AddQuery("",$index);
$results=$sphinx->RunQueries();
if(($results===false)||($sphinx->GetLastError())||($sphinx->GetLastWarning()))
{
//echo $sphinx->GetLastError();exit;
printerror("Oops! The server is under the routine maintenance !","history.go(-1)",1);
}
for($i=0;$i<3;$i++)
{
if($results[$i][error]||$results[$i][warning])
{
//echo $results[$i][error];exit;
printerror("Oops! The server is under the routine maintenance !","history.go(-1)",1);
}
}
//Check $num and $page
$num=$results[0]['total_found']?(int)$results[0]['total_found']:0;
if(empty($num)&&$page>1)
{
require(EDOWN_PATH."info/page-not-found/index.php");
exit;
}
$num=$num>$sphinx_max_matches?$sphinx_max_matches:$num;
if($add[maxnum]&&$add[maxnum]<$num)
{
$num=$add[maxnum];
}
$total_page=ceil($num/$lencord);
if($total_page>0&&$page>$total_page)
{
require(EDOWN_PATH."info/page-not-found/index.php");
exit;
}
//Page parameters
if($num>0)
{
$list_page_r=sys_ShowListMorePage($num,$page,$defined_sort_options[$sort]['link_url'],'/',$total_page,$lencord,$page,$myoptions);
$add['list_page']=$list_page_r['showpage'];
}
$page_desc_including_string="";
if(is_array($results[0]["matches"]))
{
$page_desc_including_string.=$results[0]["matches"][0]["attrs"]["title"]?", including ".$results[0]["matches"][0]["attrs"]["title"]:"";
$page_desc_including_string.=$results[0]["matches"][1]["attrs"]["title"]?", ".$results[0]["matches"][1]["attrs"]["title"]:"";
$page_desc_including_string.=$results[0]["matches"][2]["attrs"]["title"]?", ".$results[0]["matches"][2]["attrs"]["title"]." and more.":"";
}
//页面头部参数值
$navadd['page_title']=$add['classalias'].' Download '.$defined_sort_options[$sort]['display_string'].$page_string;
$navadd['page_header_meta']='';
$navadd['page_header_link']=$add['bclassid']?'':'';
$navadd['page_keywords']=$add['classkey'];
$navadd['page_description']=$add['classalias'].' Download '.$defined_sort_options[$sort]['display_string'].$page_string.$page_desc_including_string;
$navadd['nav_menu']='';
$navadd['page_span']="".$add[classalias]." Download
";
$navadd['page_login_status']=GetPageLoginStatus();
$navadd['nav_class_id']=$add['classid'];
$navadd['nav_link']=ReturnClassNavLink($add['classid']).' '.$public_r[navfh].' '.$add[classname].'';
$add['list_subject']=''.$add[classalias].'';
$add['compare_link']=$num?'( up to 3 software )
':'';
$add['sort_link']='Sort by :
'.$defined_sort_options[$sort]['sort_string'].'';
$add['sort_link'].=$defined_sort_options[$sort_free_prefix.'new-releases']['sort_link_li'];
$add['sort_link'].=$defined_sort_options[$sort_free_prefix.'new-updates']['sort_link_li'];
$add['sort_link'].=$defined_sort_options[$sort_free_prefix.'top-downloads']['sort_link_li'];
$add['sort_link'].=$defined_sort_options[$sort_free_prefix.'total-top-downloads']['sort_link_li'];
$add['sort_link'].=$defined_sort_options[$sort_free_prefix.'top-editor-rating']['sort_link_li'];
$add['sort_link'].=$defined_sort_options[$sort_free_prefix.'top-user-rating']['sort_link_li'];
$add['sort_link'].='
No Software !
';
}
else
{
if(is_array($results[0]["matches"]))
{
foreach($results[0]["matches"] as $key => $info)
{
//数据处理
foreach ( $results[0]["attrs"] as $attrname => $attrtype )
{
$value = $info["attrs"][$attrname];
if ( $attrtype & SPH_ATTR_MULTI )
{
$value = "(" . join ( ",", $value ) .")";
}
else
{
if ( ( $attrtype==SPH_ATTR_TIMESTAMP ) && $value )
$value = date ( "Y-m-d H:i:s", $value );
if ( $attrtype==SPH_ATTR_FLOAT )
$value = number_format($value ,2,'.','');
}
$info["attrs"][$attrname]=$value;
}
$r=$info["attrs"];
$r["id"]=$info["id"];
$r['info_title']=$r['title'];
$r['info_title'].=$r['title_former']?' ('.$r['title_former'].')':'';
$r['info_title'].=$r['version']?' '.$r['version']:'';
$r['info_title_tag']=$r['title'];
$r['info_title_tag'].=$r['title_former']?' ('.$r['title_former'].')':'';
$r['info_title_tag'].=$r['version']?' '.$r['version'].'':'';
$r['license_style_class']='license';
$r['license_style_class'].=$class_sqr[$r['license_id']]['isfree']?' free':'';
$r['license']=$class_sqr[$r['license_id']]['isfree']?'Free':$class_sqr[$r['license_id']]['license_name'];
$r['row_style']=($key%2==1)?'':' class="row_odd"';
@include(EDOWN_PATH."data/template/list_temp_".$add[listtempid]."_center.php");
}
}
}
//Filter License
$sort_license_filter_all=$is_license_filter_free?str_replace('free-','',$sort):$sort;
$sort_license_filter_free=$is_license_filter_free?$sort:'free-'.$sort;
$license_filter_link_all=$defined_sort_options[$sort_license_filter_all]['link_url'];
$license_filter_link_free=$defined_sort_options[$sort_license_filter_free]['link_url'];
if($results[1][total_found])
{
$selected_license_all=stristr($sort,'free')?'':'class="selected"';
$add['filter_license']='- All('.$results[1][total_found].')
';
}
else
{
$add['filter_license']='- All('.$results[1][total_found].')
';
}
if($results[2][total_found])
{
$selected_license_free=stristr($sort,'free')?'class="selected"':'';
$add['filter_license'].='- Only Free('.$results[2][total_found].')
';
}
else
{
$add['filter_license'].='- Only Free('.$results[2][total_found].')
';
}
@include(EDOWN_PATH."data/template/list_temp_".$add[listtempid]."_footer.php");
exit;
}
elseif($category_type==2)//分类Essential Downloads
{
$platform=preg_replace('/[^a-z\-]/','',$_GET['platform']);
$categorypath=preg_replace('/[^a-z\-]/','',$_GET['categorypath']);
$subcategorypath=preg_replace('/[^a-z\-]/','',$_GET['subcategorypath']);
//Check ClassID
$classpath=$platform;
$classpath.=$categorypath?'/'.$categorypath:'';
$classpath.=$subcategorypath?'/'.$subcategorypath:'';
if(!$classpath_r[$classpath][classid])
{
require(EDOWN_PATH."info/page-not-found/index.php");
exit;
}
$link=db_connect();
$empire=new mysqlquery();
$add=$empire->fetch1("select * from {$dbtbpre}class where classid='".$classpath_r[$classpath][classid]."' and showclass=1");
db_close();
$empire=null;
if(!$add[classid])
{
require(EDOWN_PATH."info/page-not-found/index.php");
exit;
}
//Check if classpath needs redirection
$_classpath=$_GET['platform'];
$_classpath.=$_GET['categorypath']?'/'.$_GET['categorypath']:'';
$_classpath.=$_GET['subcategorypath']?'/'.$_GET['subcategorypath']:'';
if($_classpath!=$classpath)
{
$redirect_url=1;
}
//Redirecting
if($redirect_url)
{
$actual_url=EDReturnClassEssentialDownloadsUrl($add[classid]);
Header("HTTP/1.1 301 Moved Permanently");
Header("Location: ".$actual_url);
exit;
}
//Defined Variable
$GLOBALS['nav_class_id']=$add['classid'];
$app_essential_info=array();
//Query Sphinx
$sphinx=new SphinxClient();
$sphinx=InitSphinx();
$sphinx->SetSortMode(SPH_SORT_EXTENDED,"downloads_last_week desc, release_date desc, @id desc");
$sphinx->SetSelect("id,title,icon,classid,filename,titleurl,short_desc");
if($add['islast'])
{
$sphinx->SetFilter("isessential",array(1));
$sphinx->SetFilter("ischecked",array(1));
$sphinx->SetFilter("classid",array($add['classid']));
$sphinx->SetLimits(0,10,10);
$sphinx->AddQuery("","index_apponic_download_software");
$query_results=$sphinx->RunQueries();
if(($query_results===false)||($sphinx->GetLastError())||($sphinx->GetLastWarning()))
{
//echo $sphinx->GetLastError();exit;
printerror("Oops! The server is under the routine maintenance !","history.go(-1)",1);
}
for($i=0;$i<1;$i++)
{
if($query_results[$i][error]||$query_results[$i][warning])
{
//echo $query_results[$i][error];exit;
printerror("Oops! The server is under the routine maintenance !","history.go(-1)",1);
}
}
//Parse query results
if(is_array($query_results[0]["matches"]))
{
foreach($query_results[0]["matches"] as $info)
{
$info["attrs"]["id"]=$info["id"];
$app_essential_info[]=$info["attrs"];
}
}
$query_results=null;
}
else
{
$sub_class_r=explode('|',trim($class_r[$add['classid']]['subclass'],'|'));
$sub_class_r=array_filter($sub_class_r);
$sub_class_r=array_values($sub_class_r);
$query_index=0;
$query_count=count($sub_class_r);
foreach ($sub_class_r as $subclassid)
{
$sphinx->ResetFilters();
$sphinx->SetFilter("isessential",array(1));
$sphinx->SetFilter("ischecked",array(1));
if($add['bclassid']==0)
{
$sphinx->SetFilter("categoryid",array($subclassid));
}
else
{
$sphinx->SetFilter("classid",array($subclassid));
}
$sphinx->SetLimits(0,6,6);
$sphinx->AddQuery("","index_apponic_download_software");
$query_index++;
if((($query_index%32)==0)||($query_index==$query_count)) //Max 32 Queries
{
$query_results=$sphinx->RunQueries();
if(($query_results===false)||($sphinx->GetLastError())||($sphinx->GetLastWarning()))
{
//echo $sphinx->GetLastError();exit;
printerror("Oops! The server is under the routine maintenance !","history.go(-1)",1);
}
$query_batch_count=(($query_index%32)==0)?32:($query_index%32);
for($i=0;$i<$query_batch_count;$i++)
{
if($query_results[$i][error]||$query_results[$i][warning])
{
//echo $query_results[$i][error];exit;
printerror("Oops! The server is under the routine maintenance !","history.go(-1)",1);
}
}
//Parse query results
if(is_array($query_results))
{
foreach($query_results as $key => $value)
{
if(is_array($value["matches"]))
{
foreach($value["matches"] as $info)
{
$info["attrs"]["id"]=$info["id"];
$app_essential_info[$key][]=$info["attrs"];
}
}
}
}
$query_results=null;
}
}
}
//Display Essential Info
$navadd['page_header_meta']='';
$navadd['page_header_link']='';
$navadd['page_title']=$add['classalias']." Essential Downloads";
$navadd['page_keywords']=$add['classkey'];
$navadd['page_description']=$add['classintro'].' - '.$add['classalias'].' Essential Downloads';
$navadd['page_span']="".$add['classalias']." Essential Downloads
";
$navadd['page_login_status']=GetPageLoginStatus();
$navadd['nav_menu']='';
$navadd['nav_link']=ReturnClassNavLink($add['classid']).' '.$public_r[navfh].' '.$add[classname].' '.$public_r[navfh].' Essential Downloads';
$add['list_subject']=''.$add[classalias].' Essential Downloads';
@include(EDOWN_PATH."data/template/list_temp_".$add['essential_listtempid']."_top.php");
if($add['islast'])
{
echo '- '.$add['classname'].'
- More
';
foreach($app_essential_info as $r)
{
@include(EDOWN_PATH."data/template/list_temp_".$add['essential_listtempid']."_center.php");
}
}
else
{
foreach($app_essential_info as $key => $value)
{
echo '- '.$class_r[$sub_class_r[$key]]['classname'].'
- More
';
foreach($value as $r)
{
@include(EDOWN_PATH."data/template/list_temp_".$add['essential_listtempid']."_center.php");
}
}
}
@include(EDOWN_PATH."data/template/list_temp_".$add['essential_listtempid']."_footer.php");
exit;
}
elseif($category_type==4)//自定义列表
{
$platform=preg_replace('/[^a-zA-Z0-9\-]/','',$_GET['platform']);
$filename=preg_replace('/[^a-zA-Z0-9\-]/','',$_GET['filename']);
$page=$_GET['page'];
//判断platform是否存在
$add[classid]=$classpath_r[$platform][classid];
if(!$add[classid])
{
require(EDOWN_PATH."info/page-not-found/index.php");
exit;
}
$add[classname]=$class_r[$add[classid]][classname];
$add[classalias]=$class_r[$add[classid]][classalias];
$add[classpath]=$class_r[$add[classid]][classpath];
$link=db_connect();
$empire=new mysqlquery();
//判断filename是否存在
$userlist_r=$empire->fetch1("select * from {$dbtbpre}downuserlist where filename='".$filename."'");
if(!$userlist_r[id])
{
db_close();
$empire=null;
require(EDOWN_PATH."info/page-not-found/index.php");
exit;
}
//判断page是否需要跳转
if($page=='') //Get no page
{
$page=CheckInt($page);
$page=1;
}
else //Get page value
{
$page=CheckInt($page);
if($page<2)
{
$redirect_url=1;
}
}
//跳转
if($redirect_url)
{
$actual_url=$public_r['siteurl'].$platform.'/'.$filename.'/';
$actual_url.=($page>1)?$page.'/':'';
db_close();
$empire=null;
Header("HTTP/1.1 301 Moved Permanently");
Header("Location: ".$actual_url);
exit;
}
//定义变量
$GLOBALS['nav_class_id']=$add[classid];
$lencord=$userlist_r[lencord]?$userlist_r[lencord]:100;
$offset=($page-1)*$lencord;
$page_string=($page==1)?"":" - Page ".$page;
//定义显示的URL
$dolink=$public_r['siteurl'].$platform.'/'.$filename.'/';
$list_page_link=$dolink;
//生成查询语句
$userlist_r['listsql']=RepSqlTbpre($userlist_r['listsql']);
$userlist_r['totalsql']=RepSqlTbpre($userlist_r['totalsql']);
$query=stripSlashes($userlist_r['listsql']);
$query=str_replace("[!--platformid--]",$add[classid],$query);
$query=str_replace("[!--platform_id--]",$add[classid],$query);
if(stristr($query,'limit'))
{
$query=str_replace("[!--offset--]",$offset,$query);
$query=str_replace("[!--lencord--]",$lencord,$query);
}
else
{
$query.=" limit ".$offset.",".$lencord;
}
$totalquery=stripSlashes($userlist_r['totalsql']);
$totalquery=str_replace("[!--platformid--]",$add[classid],$totalquery);
$totalquery=str_replace("[!--platform_id--]",$add[classid],$totalquery);
//对page参数进行判断
$num=$empire->gettotal($totalquery);
if(empty($num)&&$page>1)
{
db_close();
$empire=null;
require(EDOWN_PATH."info/page-not-found/index.php");
exit;
}
if($userlist_r[maxnum]&&$userlist_r[maxnum]<$num)
{
$num=$userlist_r[maxnum];
}
$total_page=ceil($num/$lencord);
if($total_page>0&&$page>$total_page)
{
db_close();
$empire=null;
require(EDOWN_PATH."info/page-not-found/index.php");
exit;
}
//Page parameters
if($num>0)
{
$list_page_r=sys_ShowListMorePage($num,$page,$list_page_link,'/',$total_page,$lencord,$page,$myoptions);
$add['list_page']=$list_page_r['showpage'];
}
//页面头部参数值
$navadd['page_title']=str_replace("[!--platform_name--]",$add[classname],$userlist_r['pagetitle']).$page_string;
$navadd['page_keywords']=str_replace("[!--platform_name--]",$add[classname],$userlist_r['pagekey']);
$navadd['page_description']=str_replace("[!--platform_name--]",$add[classname],$userlist_r['pagedes']).$page_string;
$navadd['page_span']="".str_replace("[!--platform_name--]",$add[classname],$userlist_r['pagetitle'])."
";
$navadd['page_login_status']=GetPageLoginStatus();
$navadd['nav_menu']='';
$navadd[nav_link]=ReturnUserlistNavLink().' '.$public_r[navfh].' '.$add['classname'].'';
$add['list_subject']=str_replace("[!--platform_name--]",$add[classname],$userlist_r['pagetitle']);
if($num)
{
$navadd['page_header_meta']='';
$canonical_link=$public_r['siteurl'].$platform.'/'.$filename.'/';
$canonical_link.=($page>1)?$page.'/':'';
$navadd['page_header_link']='';
}
else
{
$navadd['page_header_meta']='';
}
$sphinx=new SphinxClient();
$sphinx=InitSphinx();
@include(EDOWN_PATH."data/template/list_temp_".$userlist_r['listtempid']."_top.php");
//无内容
if(empty($num))
{
echo 'No Searches !
';
}
else
{
$sql=$empire->query($query);
$i=0;
while($r=$empire->fetch($sql))
{
if(strpos($userlist_r['listname'],'Searches')!==false)
{
$i++;
$order_level=ceil($i/10);
$style=$order_level<11?' class="order_'.$order_level.'"':'';
$r['keyword_link']=''.$r['keyword'].' | ';
}
@include(EDOWN_PATH."data/template/list_temp_".$userlist_r['listtempid']."_center.php");
}
$empire->free($sql);
}
@include(EDOWN_PATH."data/template/list_temp_".$userlist_r['listtempid']."_footer.php");
db_close();
$empire=null;
}
elseif($category_type==10)//分类导航
{
$platform=preg_replace('/[^a-z\-]/','',$_GET['platform']);
@include(EDOWN_PATH."data/template/".$platform."_categories_temp.php");
exit;
}
else
{
require(EDOWN_PATH."info/page-not-found/index.php");
exit;
}
?>