users_boarders.inc.php

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

<?php
/*
* Copyright (c) 2007,ZOL
* All Rights Reserved.
*
* 文件名称: users_boarders.inc.php
* 摘    要: group论坛 后台 用户管理==》版主管理
* 文件说明: /admin/script_inc/users_boarders.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');
$current_time = date('Y-m-d H:i:s');

//添加版主
if("insert"==$_REQUEST['insert_user']){
	$userid=$_REQUEST['userid'];
	$cateid=(int)$_REQUEST['cateid'];
	$subcatid=(int)$_REQUEST['subcatid'];
	$reason="管理员设置";

	$sql="select 'x' from z_board_user where z_userid='$userid'";
	$check_big=$DB_Read->get_var($sql);
	if($check_big){
		echo '<script language="javascript">alert("要设置的用户已经是版主了!");location.href="control.php?action=users_boarders";</script>';
		exit();
	}
	//都不是 则插入一个新的记录
	if($subcatid && $userid){
        $sql = "select z_type from z_board where z_subcatid=$subcatid";
        $board_type = $DB_Read->get_var($sql);

		$sql="insert into z_board_user(z_cateid,z_subcatid,z_userid,z_board_type,z_user_type) values($cateid,$subcatid,'$userid',$board_type,1)";
		$check_true=$DB_Write->query($sql);

		if($check_true){
			echo '<script language="javascript">alert("您的设置已经成功!");location.href="control.php?action=users_boarders";</script>';
			exit();
		}else{
			echo '<script language="javascript">alert("您的设置已经失败!");location.href="control.php?action=users_boarders";</script>';
			exit();
		}
	}
}

//操作  撤职
if('del'==$_REQUEST['act']){
	$ch=$_REQUEST['ch'];
	foreach($ch as $key=>$value){
		$id_list.=$value.",";
	}
	$id_list=substr($id_list,0,-1);
	$sql="delete from z_board_user where z_id in ($id_list)";
	$check=$DB_Write->query($sql);
	if($check){
		echo "<script language=javascript>alert('你所选的都被删除了!');location.href='control.php?action=users_boarders';</script>";
		exit();
	}
}

//大版设置 单独设置
if('big'==$_REQUEST['set']){
	$sid=(int)$_REQUEST['id'];
	if(!$sid){
		echo "##参数错误###";
		exit();
	}
	$sql="update z_board_user set z_user_type=0 where z_id=$sid";
	$check1=$DB_Write->query($sql);
	if($check1){
		echo "<script language=javascirpt>alert('设置大版主成功!');location.href='control.php?action=users_boarders';</script>";
		exit();
	}
}

//小版设置 单独设置
if('small'==$_REQUEST['set']){
	$sid=(int)$_REQUEST['id'];
	if(!$sid){
		echo "##参数错误###";
		exit();
	}
	$sql="update z_board_user set z_user_type=1 where z_id=$sid";
	$check1=$DB_Write->query($sql);
	if($check1){
		echo "<script language=javascirpt>alert('设置小版主成功!');location.href='control.php?action=users_boarders';</script>";
		exit();
	}
}

//撤职 单独设置
if('cancel'==$_REQUEST['set']){
	$sid=(int)$_REQUEST['id'];
	if(!$sid){
		echo "##参数错误###";
		exit();
	}
	$sql="delete from z_board_user where z_id=$sid";
	$check1=$DB_Write->query($sql);
    echo "<script language=javascirpt>alert('撤职设置成功!');location.href='control.php?action=users_boarders';</script>";
    exit();
}

//添加品牌版主
if('manu'==$_REQUEST['addboarder']){
    $subcatid = (int)$_REQUEST['subcatid'];
    $manuid   = (int)$_REQUEST['manuid'];
    $userid   = $_REQUEST['userid'];
    $sql = "select z_cateid,z_type from z_board where z_subcatid=$subcatid";
    $sub_row   = $DB_Read->get_row($sql,'O');
    if($subcatid && $manuid && $userid){
        if (1==$sub_row->z_type)
        {
            $user_type = 1;
        }
        else
        {
            $user_type = 2;
        }
        $sql = "insert into boarder(cateid,subcatid,manuid,userid,user_type) values($sub_row->z_cateid,$subcatid,$manuid,'$userid',$user_type)";
        $check = $DB_Write->query($sql);
        if($check){
            echo "<script>alert('添加品牌版主成功!');location.href='control.php?action=users_boarders';</script>";
            exit();
        }
    }
}

//发消息
if('fb'==$_REQUEST['fb_m']){
    $fb_type = (int)$_REQUEST['fb_type'];
    $fb_content = addslashes(trim($_REQUEST['fb_content']));
    switch($fb_type){
        case 1: $sql = "select userid from boarder where user_type=0"; $str='大版消息'; break;
        case 2: $sql = "select userid from boarder where user_type=1"; $str='小版消息'; break;
        case 3: $sql = "select userid from boarder where user_type=2"; $str='子子版主消息'; break;
    }
    $arr = $DB_Read->get_results($sql,'O');
    if(is_array($arr)){
        foreach($arr as $row){
            $sql = "insert into message(sender,reciever,message,title,senddate) values('$zol_userid','$row->userid','$fb_content','$str','$current_time')";
            $DB_User->query($sql);
        }
    }
    echo "<script>alert('发信成功!');location.href='control.php?action=users_boarders';</script>";
    exit();
}


$per_page=20;
$p    = (int)$_REQUEST['page'];
$type = (int)$_REQUEST['type'];

switch ($type) {
	case 1: $sql="select count(*) from z_board_user"; break;
	case 2: $sql="select count(*) from z_board_user where z_user_type=0"; break; //大版
	case 3: $sql="select count(*) from z_board_user where z_user_type=1"; break; //子版
	case 4: $sql="select count(*) from z_board_user where z_user_type=2"; break; //子子版
	default: $sql="select count(*) from z_board_user"; break;
}
$total=(int)$DB_Read->get_var($sql);
$num = ceil($total/$per_page);
if($p>=0){
	$start=$p*$per_page;
}else{
	$start=0;
}
switch ($type) {
	case 1: $sql="select * from z_board_user"; break;
	case 2: $sql="select * from z_board_user where z_user_type=0"; break; 
	case 3: $sql="select * from z_board_user where z_user_type=1"; break;
	case 4: $sql="select * from z_board_user where z_user_type=2"; break;
	default: $sql="select * from z_board_user"; break;
}
$sql.=" limit {$start},{$per_page}";
$arr=$DB_Read->get_results($sql,'O');
$mpurl = "control.php?action=users_boarders";
if($type){
    $mpurl = "control.php?action=users_boarders&type={$type}";
}
$page_list = multi_page($total,$per_page,$p,$mpurl,10,'');

if('find'==$_REQUEST['search']){
    $uid = $_REQUEST['uid'];
    $sql = "select * from z_board_user where z_userid='$uid'";
    $arr = $DB_Read->get_results($sql,'O');
    $page_list = "";
}

if (is_array($arr))
{
    foreach ($arr as $row)
    {
        $u_name = get_nickname($row->z_userid);

        $sql="select z_name from z_board where z_subcatid=$row->z_subcatid";
	    $board_name=$DB_Read->get_var($sql);
        
        $sql = "select z_name from z_cate where z_id=$row->z_cateid";
        $cate_name = $DB_Read->get_var($sql);

        switch ($row->z_user_type){
            case 0: $type_status="大版主"; break;
            case 1: $type_status="子版主"; break;
            case 2: $type_status="子子版主"; break;
            default: break;
        }
        if (0==$row->z_user_type)
        {
            if (1<>$row->z_board_type)
            {
                $board_name=$cate_name;
            }
        }

        $result_arr[] = array('id'=>$row->z_id,'cateid'=>$row->z_cateid,'subcatid'=>$row->z_subcatid,'subsubid'=>$row->z_subsubid,'userid'=>$row->z_userid,'user_type'=>$row->z_user_type,'board_type'=>$row->z_board_type,'u_name'=>$u_name,'board_name'=>$board_name,'type_status'=>$type_status);
    }
}

//版块信息
$subcate_ajax_url = $base_admin_url."admin/ajax/post_get_subcate.php";

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

include template('users_boarders','users/');
?>