users_postboarder.inc.php

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

<?php
/*
* Copyright (c) 2007,ZOL
* All Rights Reserved.
*
* 文件名称: users_postboarder.inc.php
* 摘    要: group论坛 后台 用户管理==》通过版主申请
* 文件说明: /admin/script_inc/users_postboarder.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('pass' == $_REQUEST['ACT']){
    $id= (int)$_REQUEST['id'];
    if($id){
        $sql = "update apply_boarder set z_status = 1 where id={$id}";
        $check = $DB_Write->query($sql);
        if($check){
            $sql = "select subcatid,boardid,board_name,board_type,userid from apply_boarder where id={$id}";
            $apply_info = $DB_Read->get_row($sql,'O');
            
            // 判断是不是已经是版主
            $sql = "select 'x' from z_board_user where z_userid='$apply_info->userid'";
            $check_boarder = $DB_Read->get_var($sql);
            if($check_boarder){
                echo "<script language=JavaScript>alert('已经是版主');location.href='control.php?action=users_boarders';</script>";
                exit();
            }else{
                if($apply_info){
                    $sql = "select z_cateid,z_type from z_board where z_subcatid=$apply_info->subcatid";
                    $sub_info  = $DB_Read->get_row($sql,'O');
                    if (1==$sub_info->z_type)
                    {
                        $sql = "insert into z_board_user (z_cateid,z_subcatid,z_subsubid,z_userid,z_board_type,z_user_type) values ($sub_info->z_cateid,$apply_info->subcatid,$apply_info->boardid,'$apply_info->userid',$sub_info->z_type,1)";
                    }
                    elseif (2==$sub_info->z_type)
                    {
                        $sql = "insert into z_board_user (z_cateid,z_subcatid,z_subsubid,z_userid,z_board_type,z_user_type) values ($sub_info->z_cateid,$apply_info->subcatid,$apply_info->boardid,'$apply_info->userid',$sub_info->z_type,2)";
                    }
                    $check = $DB_Write->query($sql);
                    if($check){
                        //加入版主QQ群:37108128。
                        $message = "恭喜您申请{$apply_info->board_name}版主以被管理员审核通过，特此奖励经验50分。希望版{$apply_info->board_name}在您的带领下人气越来越旺！";
                        $message = addslashes($message);

                        $sql = "update userinfo set score = score +50 where userid='{$apply_info->userid}'";
                        $DB_Discussion->query($sql);

                        $sql = "INSERT INTO message (sender, reciever, message,title,senddate) VALUES ('zol123zol','{$apply_info->userid}','{$message}','申请版主被批准','$current_time')";
                        $DB_User->query($sql);

                        echo "<script language=JavaScript>alert('已经通过并发送了消息');</script>";
                    }
                }
            }
        }
    }
}elseif('del' == $_REQUEST['ACT']){
    $id= (int)$_REQUEST['id'];
    if($id){
        $sql = "select subcatid,boardid,board_name,board_type,userid from apply_boarder where id={$id}";
        $apply_info = $DB_Write->get_row($sql,'O');
        if($apply_info){
            $message = "您申请{$apply_info->board_name}版主未被通过，请再接再励！";
            $message = addslashes($message);

            $sql = "INSERT INTO message (sender, reciever, message,title,senddate) VALUES ('zol123zol','{$apply_info->userid}','{$message}','申请版主未被批准','$current_time')";
            $DB_User->query($sql);

            echo "<script language=JavaScript>alert('已经删除并发送了消息');</script>";
        }
        $sql = "delete from apply_boarder where id={$id}";
        $DB_Write->query($sql);

    }
}

$sql = "select * from apply_boarder where z_status=0 order by id";
$results = $DB_Read->get_results($sql,'O');
if (is_array($results))
{
    foreach($results as $row)
    {
        switch($row->board_type){
            case 1: $url ="/subcate_list_{$row->subcatid}.html";break;
            case 2: $url ="/manu_index_{$row->subcatid}_{$row->boardid}.html";break;
            case 2: $url ="/comment.php?productid={$row->boardid}";break;
            default:$url ="/comment.php?productid={$row->boardid}";
        }
        $nickname = get_nickname($row->userid);
        $results_arr[] = array('id'=>$row->id,'userid'=>$row->userid,'board_name'=>$row->board_name,'email'=>$row->email,'qq'=>$row->qq,'phone'=>$row->phone,'net_hour'=>$row->net_hour,'plan'=>$row->plan,'url'=>$url,'nickname'=>$nickname);
    }
}

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