} else {
$SQL .= " AND 0 ";
}
}
} else {
$SQL .= " AND 0 ";
}
$ORDER = ' A.list ';
}
if (!$webdb[viewNoPassArticle]) {
$SQL .= ' AND A.yz=1 ';
}
$SQL = "A LEFT JOIN {$pre}fu_article FA ON A.aid=FA.aid WHERE {$SQL} GROUP BY A.aid ORDER BY {$ORDER} DESC LIMIT {$rows}";
$which = 'A.*';
$listdb = '';
$array = list_article($SQL, $which, $leng, $erp);
foreach ($array as $key => $r) {
$listdb[$r[aid]] = $r;
}
if (is_file(ROOT_PATH . "template/default/{$webdb['SideTitleStyle']}.htm")) {
$tplcode = read_file(ROOT_PATH . "template/default/{$webdb['SideTitleStyle']}.htm");
} else {
$tplcode = read_file(ROOT_PATH . "template/default/side_tpl/0.htm");
}
$tplcode = addslashes($tplcode);
foreach ($listdb as $key => $rs) {
//$target=$rs[target]?'_blank':'_self';
$target = '_blank';
if ($type == 'pic') {
$show .= "<div class='p' style='float:left;width:130px;padding-left:5px;padding-top:5px;'> <a href='bencandy.php?fid={$rs['fid']}&id={$rs['aid']}' style='display:block;width:120px;height:90px;border:1px solid #ccc;' target='{$target}'><img style='border:2px solid #fff;' width='120' height='90' src='{$rs['picurl']}' border='0'></a> <A HREF='{$webdb['www_url']}/bencandy.php?fid={$rs['fid']}&id={$rs['aid']}' title='{$rs['full_title']}' target='{$target}'>{$rs['title']}</A> </div>";
} else {
/**
*大分类的子栏目
**/
function ListMoreSort()
{
global $db, $pre, $fid, $webdb, $fidDB, $Fid_db;
//排序
if ($fidDB[config][sonListorder] == 1) {
$order = 'A.list';
} elseif ($fidDB[config][sonListorder] == 2) {
$order = 'A.hits';
} elseif ($fidDB[config][sonListorder] == 3) {
$order = 'A.lastview';
} elseif ($fidDB[config][sonListorder] == 4) {
$order = 'rand()';
} else {
$order = 'A.list';
}
$_order = " ORDER BY {$order} DESC ";
//显示几行
if ($fidDB[config][sonTitleRow] > 0) {
$rows = $fidDB[config][sonTitleRow];
} elseif ($webdb[ListSonRows] > 0) {
$rows = $webdb[ListSonRows];
} else {
$rows = 10;
}
//每个标题显示几个字
if ($fidDB[config][sonTitleLeng] > 0) {
$leng = $fidDB[config][sonTitleLeng];
} elseif ($webdb[ListSonLeng] > 0) {
$leng = $webdb[ListSonLeng];
} else {
$leng = 30;
}
if (!$webdb[viewNoPassArticle]) {
$SQL_yz = ' AND A.yz=1 ';
}
$query = $db->query("SELECT * FROM {$pre}sort WHERE fup={$fid} AND forbidshow!=1 ORDER BY list DESC LIMIT 50");
while ($rs = $db->fetch_array($query)) {
$erp = $Fid_db[iftable][$rs[fid]] ? $Fid_db[iftable][$rs[fid]] : '';
$SQL = "A LEFT JOIN {$pre}reply{$erp} R ON A.aid=R.aid WHERE R.topic=1 AND A.fid={$rs['fid']} {$SQL_yz} {$_order} LIMIT {$rows}";
$which = 'A.*,R.content';
$rs[article] = list_article($SQL, $which, $leng, $erp);
//如果本栏目不能获取到文章,将获取其所有子栏目的文章
if (!$rs[article]) {
$array_fid = Get_SonFid("{$pre}sort", $rs[fid]);
if ($array_fid && count($array_fid) < 50) {
//分表后,如果子栏目不是同一模型的话.将不能获取资料
$SQL = "A LEFT JOIN {$pre}reply{$erp} R ON A.aid=R.aid WHERE R.topic=1 AND A.fid IN (" . implode(',', $array_fid) . ") {$SQL_yz} {$_order} LIMIT {$rows}";
$rs[article] = list_article($SQL, $which, $leng, $erp);
}
}
$rs[logo] && ($rs[logo] = tempdir($rs[logo]));
$listdb[] = $rs;
}
return $listdb;
}
if ($fid > 0) {
$_sql = " AND fid='{$fid}' ";
$erp = $Fid_db[iftable][$fid];
} elseif ($mid > 0) {
$_sql = " AND mid='{$mid}' ";
$erp = $article_moduleDB[$mid][iftable] ? $article_moduleDB[$mid][iftable] : '';
} elseif ($mid == -1) {
$_sql = " AND mid='0' ";
}
if ($only) {
$_sql .= " AND mid='{$mid}' ";
}
$SQL = "WHERE uid={$lfjuid} AND yz!=2 {$_sql} ORDER BY aid DESC LIMIT {$min},{$rows}";
$which = '*';
$showpage = getpage("{$pre}article{$erp}", "WHERE uid={$lfjuid} AND yz!=2 {$_sql}", "?job={$job}&fid={$fid}&mid={$mid}&only={$only}", $rows);
$listdb = list_article($SQL, $which, 50, $erp);
$listdb || ($listdb = array());
foreach ($listdb as $key => $rs) {
if ($rs[pages] < 1) {
$rs[pages] = 1;
$erp = get_id_table($rs[aid]);
$db->query("UPDATE {$pre}article{$erp} SET pages=1 WHERE aid='{$rs['aid']}'");
}
$rs[state] = "";
if ($rs[yz] == 2) {
$rs[state] = "×÷·Ï";
} elseif ($rs[yz] == 1) {
$rs[state] = "<A style='color:red;'>ÒÑÉó</A>";
} elseif (!$rs[yz]) {
$rs[state] = "<A style='color:blue;'>´ýÉó</A>";
}
if ($page < 1) {
$page = 1;
}
$rows = 50;
$min = ($page - 1) * $rows;
$_sql = "";
if ($fid > 0) {
$_sql = " AND fid='{$fid}' ";
}
if ($only) {
$_sql .= " AND mid='{$mid}' ";
}
$SQL = "WHERE uid={$lfjuid} AND yz!=2 {$_sql} ORDER BY aid DESC LIMIT {$min},{$rows}";
$which = '*';
$showpage = getpage("{$pre}article", "WHERE uid={$lfjuid} AND yz!=2 {$_sql}", "?lfj={$lfj}&job={$job}&fid={$fid}&only={$only}&mid={$mid}", $rows);
$listdb = list_article($SQL, $which, 36);
$listdb || ($listdb = array());
foreach ($listdb as $key => $rs) {
if ($rs[pages] < 1) {
$rs[pages] = 1;
$erp = get_id_table($rs[aid]);
$db->query("UPDATE {$pre}article{$erp} SET pages=1 WHERE aid='{$rs['aid']}'");
}
if ($rs[yz] == 2) {
$rs[state] = "作废";
} elseif ($rs[yz] == 1) {
$rs[state] = "<A style='color:red;'>已审</A>";
} elseif (!$rs[yz]) {
$rs[state] = "<A style='color:blue;'>待审</A>";
}
if ($rs[levels]) {
function fuListThisSort($rows, $leng = 50)
{
global $page, $fid, $fidDB, $webdb, $pre, $Fid_db;
if ($page < 1) {
$page = 1;
}
$min = ($page - 1) * $rows;
if ($fidDB[listorder] == 1) {
$DESC = 'DESC';
$ORDER = 'A.posttime';
} elseif ($fidDB[listorder] == 2) {
$DESC = 'ASC';
$ORDER = 'A.posttime';
} elseif ($fidDB[listorder] == 3) {
$DESC = 'DESC';
$ORDER = 'A.hits';
} elseif ($fidDB[listorder] == 4) {
$DESC = 'ASC';
$ORDER = 'A.hits';
} elseif ($fidDB[listorder] == 5) {
$DESC = 'DESC';
$ORDER = 'A.lastview';
} elseif ($fidDB[listorder] == 7) {
$DESC = 'DESC';
$ORDER = 'A.digg_num';
} elseif ($fidDB[listorder] == 8) {
$DESC = 'DESC';
$ORDER = 'A.digg_time';
} elseif ($fidDB[listorder] == 6) {
$DESC = 'DESC';
$ORDER = 'rand()';
} else {
$DESC = 'DESC';
$ORDER = 'A.list';
}
if (!$webdb[viewNoPassArticle]) {
$SQL_yz = ' AND A.yz=1 ';
}
if ($fid) {
$_fid_sql = " AND F.fid={$fid} ";
} else {
$_fid_sql = " AND 1 ";
}
$erp = "";
$SQL = "A LEFT JOIN {$pre}fu_article F ON A.aid=F.aid LEFT JOIN {$pre}reply{$erp} R ON F.aid=R.aid WHERE R.topic=1 {$_fid_sql} {$SQL_yz} ORDER BY {$ORDER} {$DESC} LIMIT {$min},{$rows}";
$which = 'A.*,R.content';
$listdb = list_article($SQL, $which, $leng, $erp);
return $listdb;
}
$rows = 20;
$min = ($page - 1) * $rows;
if ($Type == "yz") {
$_SQL .= " AND yz=1 ";
} elseif ($Type == "unyz") {
$_SQL .= " AND yz=0 ";
} elseif ($Type == "rubbish") {
$_SQL .= " AND yz=2 ";
} elseif ($Type == "levels") {
$_SQL .= " AND levels=1 ";
} elseif ($Type == "pic") {
$_SQL .= " AND ispic=1 ";
}
$SQL = "{$_SQL} ORDER BY list DESC LIMIT {$min},{$rows}";
$which = '*';
$listdb = list_article($SQL, $which, 40);
$showpage = getpage("{$pre}article", "{$_SQL}", "?fid={$fid}", $rows);
foreach ($listdb as $key => $rs) {
if ($rs[yz] == 2) {
$rs[state] = "<A style='color:red;' onclick=\"return confirm('你确认要从回收站取回它吗?')\" href='?Type=return&aidDB[]={$rs['aid']}&step=2'>回收站</A>";
} elseif ($rs[yz] == 1) {
$rs[state] = "<A style='color:;' onclick=\"return confirm('你确认要取消验证吗?')\" href='?Type=unyz&aidDB[]={$rs['aid']}&step=2'>已审</a>";
} elseif (!$rs[yz]) {
$rs[state] = "<A style='color:blue;' href='?Type=yz&aidDB[]={$rs['aid']}&step=2'>待审</A>";
}
if ($rs[levels]) {
$rs[levels] = "<A style='color:red;' onclick=\"return confirm('你确认要取消推荐吗?')\" href='?Type=uncom&aidDB[]={$rs['aid']}&step=2'>已推荐</A>";
} else {
$rs[levels] = "<A style='color:blue;' href='?Type=com&aidDB[]={$rs['aid']}&step=2'>未推荐</a>";
}
$listdb[$key] = $rs;
