"0" && $type < "999999999"):
$istype = "WHERE sort2id='$type'";
else:
$istype = "";
endif;
if ($action == "hot"):
$isaction = "ORDER BY downnum DESC";
else:
$isaction = "ORDER BY id DESC";
endif;
if (empty($setid)):
$setid = 0;
endif;
$sql = "SELECT COUNT(*) FROM $down_table $istype $isaction";
$result = mysql_db_query($dbname, $sql);
$row = mysql_fetch_array($result);
//查询结果
$sql = "SELECT * FROM $down_table $istype $isaction LIMIT $setid, $shownum";
$result = mysql_db_query($dbname, $sql);
while ($row=mysql_fetch_array($result)){
// 判断标题长度
$len = strlen($row[name]);
if ($len <= $namelen):
$name = $row[name];
else:
$name = substr($row[name],"0","$namelen");
$parity= 0;
for($i=0;$i<$namelen;$i++){
$temp_str=substr($name,$i,1);
if(Ord($temp_str)>127) $parity+=1;
}
if($parity%2==1) $name=substr($name,0,($namelen-1))."...";
else $name=substr($name,0,$namelen)."...";
endif;
// 取出分类名称
$sort2_sql = "SELECT * FROM $down_sort2_table WHERE id='$row[sort2id]'";
$sort2_result = mysql_db_query($dbname, $sort2_sql);
$objresult = mysql_fetch_object($sort2_result);
$type2 = $objresult->sort2;
$sort1id = $objresult->sort1id;
$sort1_sql = "SELECT * FROM $down_sort1_table WHERE id='$sort1id'";
$sort1_result = mysql_db_query($dbname, $sort1_sql);
$objresult = mysql_fetch_object($sort1_result);
$type1 = $objresult->sort1;
$date = date($datetxt,$row[updatetime]);
// 显示
echo "document.write(\"[$type2] $name $row[downnum]/$row[viewnum]
\");\n";
}
mysql_close();
?>