posts_sitetop.inc.php

中观在线zol的后台管理代码

<?php
/*
* Copyright (c) 2007,ZOL
* All Rights Reserved.
*
* 文件名称: posts_sitetop.inc.php
* 摘    要: group论坛 后台 帖子管理 ==》全站置顶
* 文件说明: /admin/script_inc/posts_sitetop.inc.php
*
* 当前版本: 1.0
* 作    者: 和银龙 tech_zol
* 完成日期: 2007-11-21
*/

if (!defined('IN_GROUP') || !isset($PHP_SELF) || !preg_match("/[\/\\\\]control\.php$/", $PHP_SELF)) {
	exit('错误来源');
}

require_once(ADMIN_ROOT.'/common.inc.php');

$subcate_ajax_url = $base_admin_url."admin/ajax/post_get_subcate.php";

if ('yes' == $_REQUEST['edit'])
{
    $cateid1   = (int)$_REQUEST['cateid'];
    $subcatid1 = (int)$_REQUEST['subcatid'];
    $title     = addslashes(strip_tags(trim($_REQUEST['title'])));
    $link      = addslashes(strip_tags(trim($_REQUEST['link'])));
    $starttime = addslashes(strip_tags(trim($_REQUEST['starttime'])));
    $endtime   = addslashes(strip_tags(trim($_REQUEST['endtime'])));
    $toptype   = (int)$_REQUEST['toptype'];

    $sql = "insert into z_site_top (z_cateid,z_subcatid,z_title,z_url,z_type,z_starttime,z_endtime) values($cateid1,$subcatid1,'$title','$link',$toptype,'$starttime','$endtime')";
    $DB_Write->query($sql);
    echo "<script>location.href='?action=posts_sitetop&cateid={$cateid1}&subcatid={$subcatid1}';</script>";
    exit();
}

if ('del' == $_REQUEST['edit'])
{
    $sitearr   = $_REQUEST['sitearr'];
    $cateid2   = (int)$_REQUEST['cateid'];
    $subcatid2 = (int)$_REQUEST['subcatid'];

    if (is_array($sitearr))
    {
        foreach ($sitearr as $siterow)
        {
            $sql = "delete from z_site_top where z_id=$siterow";
            $DB_Write->query($sql);
        }
    }
    echo "<script>location.href='?action=posts_sitetop&cateid={$cateid2}&subcatid={$subcatid2}';</script>";
    exit();
}

//$sql = "select z_cateid,z_name from z_board where z_level=0 order by z_sequence,z_id";
//$user_cate_arr = $DB_Read->get_results($sql,'O');
//if (is_array($user_cate_arr)){
//    foreach ($user_cate_arr as $user_cate_row)
//    {
//        $user_cate[] = array('id'=>$user_cate_row->z_cateid,'name'=>$user_cate_row->z_name);
//    }
//}

$cateid   = (int)$_REQUEST['cateid'];
$subcatid = (int)$_REQUEST['subcatid'];

if ($cateid  && $subcatid)
{
    $sql = "select z_id,z_cateid,z_subcatid,z_title,z_url,z_type,z_starttime,z_endtime from z_site_top where z_cateid=$cateid and z_subcatid=$subcatid order by z_id desc limit 0,20";
}
else
{
    $sql = "select z_id,z_cateid,z_subcatid,z_title,z_url,z_type,z_starttime,z_endtime from z_site_top order by z_id desc limit 0,20";
}
$arr = $DB_Read->get_results($sql,'O');
if (is_array($arr))
{
    foreach($arr as $row)
    {
        switch ($row->z_type)
        {
            case 1: $type = '广告'; break;
            case 2: $type = '活动'; break;
            case 3: $type = '自身'; break;
            default: $type = '全站'; break;
        }
        $result[] = array('id'=>$row->z_id,'cateid'=>$row->z_cateid,'subcatid'=>$row->z_subcatid,'title'=>$row->z_title,'url'=>$row->z_url,'type'=>$type,'starttime'=>$row->z_starttime,'endtime'=>$row->z_endtime);
    }
}

$nowdate = date('Y-m-d');

include template('posts_sitetop','posts/');
?>