织梦dede获取栏目当前文章方法

 

01

/**

02

 *  获取栏目当前文章

03

 *

04

 * @access    public

05

 * @param     string  $id  栏目id

06

 * @param     string  $state 状态默认值为0 

07

 * @return    string

08

 */

09

function arc_list($id,$state='0'){

10

global $dsql;

11

$csql = "Select 'crossid' FROM `dede_arctype` WHERE arcrank>-1 AND typeid='$id'";

12

$crossid = $dsql->getOne($csql);

13

//判断当前栏目是否存在手工指定交叉栏目ID 并查询相关栏目的文章

14

if(empty($crossid)){

15

       $sql = "Select * FROM `dede_archives` WHERE arcrank>-1 AND typeid='$id' ORDER BY id desc limit 0,10";

16

}else{

17

$sql = "Select * FROM `dede_archives` WHERE arcrank>-1 AND typeid='$crossid' ORDER BY id desc limit 0,10";

18

}

19

    $dsql->SetQuery($sql);

20

    $dsql->Execute('t');

21

    $result = '';

22

    while($row = $dsql->GetArray('t'))

23

    {

24

        $arcrow = GetOneArchive($row['id']);

25

        $row['arcurl'] = $arcrow['arcurl'];

26