WooYun.org

admin/favourable.php





if ($_REQUEST['act'] == 'list')


{


    admin_priv('favourable');








function favourable_list()


{echo 22222222222222;


    $result = get_filter();


    if ($result === false)


    {


        /* 过滤条件 */


        $filter['keyword']    = empty($_REQUEST['keyword']) ? '' : trim($_REQUEST['keyword']);


        if (isset($_REQUEST['is_ajax']) && $_REQUEST['is_ajax'] == 1)


        {


            $filter['keyword'] = json_str_iconv($filter['keyword']);


        }


        $filter['is_going']   = empty($_REQUEST['is_going']) ? 0 : 1;


        $filter['sort_by']    = empty($_REQUEST['sort_by']) ? 'act_id' : trim($_REQUEST['sort_by']);//参数没过滤


        $filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'DESC' : trim($_REQUEST['sort_order']);





        $where = "";


        if (!empty($filter['keyword']))


        {


            $where .= " AND act_name LIKE '%" . mysql_like_quote($filter['keyword']) . "%'";


        }


        if ($filter['is_going'])


        {


            $now = gmtime();


            $where .= " AND start_time <= '$now' AND end_time >= '$now' ";


        }





        $sql = "SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('favourable_activity') .


                " WHERE 1 $where";


        $filter['record_count'] = $GLOBALS['db']->getOne($sql);





        /* 分页大小 */


        $filter = page_and_size($filter);





        /* 查询 */


        $sql = "SELECT * ".


                "FROM " . $GLOBALS['ecs']->table('favourable_activity') .


                " WHERE 1 $where ".


                " ORDER BY $filter[sort_by] $filter[sort_order] ".//直接带入查询


                " LIMIT ". $filter['start'] .", $filter[page_size]";