digg_list.php

来自「phpcms2007很好的cms内容管理系统,操作方便」· PHP 代码 · 共 40 行

<?php
require_once './include/common.inc.php';
if ($digg_catid)
{
    $catid_where = " AND `digg_catid`='$digg_catid' ";
} 
if ($digg_mod && $list_num && $title_text)
{
    $digg_setting = cache_read('digg_setting.php');
    extract($digg_setting);
    unset($digg_setting);
    if ($digg_defind != 0)
    {
        $digg_defind = $digg_defind?$digg_defind:0;
        $digg_date = date("Ymd", mktime(0, 0, 0, date('m', $PHP_TIME), date('d', $PHP_TIME) - intval($digg_defind), date('Y', $PHP_TIME)));
        $digg_defind = "AND `digg_date`>'" . date("Ymd", mktime(0, 0, 0, date('m', $PHP_TIME), date('d', $PHP_TIME) - intval($digg_defind), date('Y', $PHP_TIME))) . "'";
    } 
    else
    {
        $digg_defind = '';
    } 
    // 鍒嗛〉
    if ($page_on == 1 && $page)
    {
        $url = "list.php?digg_mod=$digg_mod&digg_catid=$digg_catid";
        $sql = "SELECT COUNT(*) AS num FROM " . TABLE_DIGG_DATA . " WHERE `mod`='$digg_mod'" . $catid_where . $digg_defind;
        $res = $db->get_one($sql);
        $page = $page ? intval($page) : 1;
        $pageend = ($page-1) * $list_num;
        $pages = phppages($res['num'], $page, $list_num, $url);
    } 
    else
    {
        $pageend = 0;
    } 
    $sql = "SELECT * FROM " . TABLE_DIGG_DATA . " WHERE `mod`='$digg_mod' " . $catid_where . $digg_defind . " LIMIT $pageend ,$list_num";
    $res = $db->query($sql);
    while ($rows = $db->fetch_array($res))
    { 
        // 璇勮