} 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;