📄 posts_huifu.inc.php
字号:
<?php
/*
* Copyright (c) 2007,ZOL
* All Rights Reserved.
*
* 文件名称: posts_huifu.inc.php
* 摘 要: group论坛 后台 帖子管理 ==》恢复帖子
* 文件说明: /admin/script_inc/posts_huifu.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');
//读取版块信息
$sql = "select z_id,z_subcatid,z_name,z_sequence from z_board where z_cateid=0 and z_forbid=0 order by z_sequence,z_id";
$subcate_arr = $DB_Read->get_results($sql,'O');
if (is_array($subcate_arr))
{
$cate_result_arr[] = array('id'=>0,'cateid'=>0,'name'=>'其他','seq'=>0);
foreach ($subcate_arr as $subcate_row)
{
//子类数组
$subcate_result_arr[0][] = array('id'=>$subcate_row->z_id,'cateid'=>0,'subcatid'=>$subcate_row->z_subcatid,'name'=>$subcate_row->z_name,'seq'=>$subcate_row->z_sequence);
}
}
$sql = "select z_id,z_name,z_sequence from z_cate order by z_sequence,z_id";
$cate_arr = $DB_Read->get_results($sql,'O');
if (is_array($cate_arr))
{
foreach ($cate_arr as $cate_row)
{
//大类数组
$cate_result_arr[] = array('id'=>$cate_row->z_id,'cateid'=>$cate_row->z_id,'name'=>$cate_row->z_name,'seq'=>$cate_row->z_sequence);
$sql = "select z_id,z_subcatid,z_name,z_sequence from z_board where z_cateid=$cate_row->z_id and z_forbid=0 order by z_sequence,z_id";
$subcate_arr = $DB_Read->get_results($sql,'O');
if (is_array($subcate_arr))
{
foreach ($subcate_arr as $subcate_row)
{
//子类数组
$subcate_result_arr[$cate_row->z_id][] = array('id'=>$subcate_row->z_id,'cateid'=>$cate_row->z_id,'subcatid'=>$subcate_row->z_subcatid,'name'=>$subcate_row->z_name,'seq'=>$subcate_row->z_sequence);
}
}
}
}
//起始时间
$start_date = date('Y-m-d',mktime(0,0,0,date('m'),date('d')-7,date('Y')));
$end_date = date('Y-m-d');
$page = (int)$_REQUEST['page'];
if (!$page) {$page = 1;}
$per_page = 300;
$start = ($page-1)*$per_page;
$search = 0;
if ('search' == $_REQUEST['edit'])
{
$search = 1;
$forums = (int)$_REQUEST['forums'];
$starttime = addslashes(strip_tags(trim($_REQUEST['starttime'])));
$endtime = addslashes(strip_tags(trim($_REQUEST['endtime'])));
$users = addslashes(strip_tags(trim($_REQUEST['users'])));
$useip = addslashes(strip_tags(trim($_REQUEST['useip'])));
$keywords = addslashes(strip_tags(trim($_REQUEST['keywords'])));
$type = (int)$_REQUEST['type'];
$book_table_name = "zbook_".$forums;
$book_reply_name = "zreply_".$forums;
if (1==$type) //del book
{
$book_name = $book_table_name;
$select_title = "title";
$countsql = "select count(*) from $book_name where Forbid=1";
$strsql = "select * from $book_name where Forbid=1";
$sql = '';
if ($starttime && $endtime)
{
$s_time = $starttime." 00:00:00";
$e_time = $endtime." 23:59:59";
$sql .= " and wdate>'$s_time' and wdate<'$e_time'";
}
if ($users)
{
$user_arr = explode(',',$users);
if (is_array($user_arr))
{
$u_list = '';
foreach ($user_arr as $u_row)
{
$u_list .= "'".$u_row."',";
}
$u_list = substr($u_list,0,-1);
$sql .= " and userid in ($u_list)";
}
else
{
$sql.= " and userid = '$users'";
}
}
if ($userip)
{
$sql .= " and ip = '$userip'";
}
if ($keywords)
{
$sql .= " and {$select_title} like '%$keywords%'";
}
$countsql .= $sql;
if ($keywords)
{
$total = (int)$DB_Read->get_var($countsql);
}
else
{
$total = (int)$DB_Read->get_var($countsql);
}
$mpurl = "control.php?action=posts_huifu&edit=search&forums=$forums&type=$type&starttime=$starttime&endtime=$endtime&users=$users&useip=$useip&keywords=$keywords";
$page_list = multi_page($total,$per_page,$page,$mpurl,10,'');
$strsql .= $sql;
$strsql .= " limit $start,$per_page";
if ($keywords)
{
$result = $DB_Read->get_results($strsql,'O');
}
else
{
$result = $DB_Read->get_results($strsql,'O');
}
if (is_array($result))
{
foreach ($result as $row)
{
$sql = "select z_name from z_board where z_subcatid=$forums";
$subname = $DB_Read->get_var($sql);
$url = "/".ceil($row->id/10000)."/{$forums}_{$row->id}.html";
$nickname = get_nickname($row->userid);
$search_arr[] = array('id'=>$row->id,'bookid'=>$row->bookid,'sid'=>$forums,'title'=>$row->$select_title,'userid'=>$row->userid,'wdate'=>$row->wdate,'url'=>$url,'subname'=>$subname,'nickname'=>$nickname);
}
}
}
else //del post
{
$book_name = $book_reply_name;
if ($keywords)
{
// $sql = "select id from $book_reply_name order by id desc limit 0,1";
// $max_id = (int)$DB_Read->get_var($sql);
//
// $p_num = ceil($max_id/1000000);
// foreach ($i=1;$i<=$p_num;$i++)
// {
// $content_table = "zreply_content{$forums}_{$i}";
// $sql = "select id from $content_table where content like '%$keywords%'";
// }
}
else
{
$countsql = "select count(*) from $book_name where Forbid=1";
$strsql = "select * from $book_name where Forbid=1";
$sql = '';
if ($starttime && $endtime)
{
$s_time = $starttime." 00:00:00";
$e_time = $endtime." 23:59:59";
$sql .= " and wdate>'$s_time' and wdate<'$e_time'";
}
if ($users)
{
$user_arr = explode(',',$users);
if (is_array($user_arr))
{
$u_list = '';
foreach ($user_arr as $u_row)
{
$u_list .= "'".$u_row."',";
}
$u_list = substr($u_list,0,-1);
$sql .= " and userid in ($u_list)";
}
else
{
$sql.= " and userid = '$users'";
}
}
if ($userip)
{
$sql .= " and ip = '$userip'";
}
$total = (int)$DB_Read->get_var($countsql);
$mpurl = "control.php?action=posts_huifu&edit=search&forums=$forums&type=$type&starttime=$starttime&endtime=$endtime&users=$users&useip=$useip&keywords=$keywords";
$page_list = multi_page($total,$per_page,$page,$mpurl,10,'');
$strsql .= $sql;
$strsql .= " limit $start,$per_page";
$result = $DB_Read->get_results($strsql,'O');
if (is_array($result))
{
foreach ($result as $row)
{
//回复内容
$reply_content_table = "zreply_content{$forums}_".ceil($row->id/1000000);
$sql = "select content from $reply_content_table where id=$row->id";
$content = $DB_Read->get_var($sql);
$content = perfect_sentence($content,34);
$sql = "select z_name from z_board where z_subcatid=$forums";
$subname = $DB_Read->get_var($sql);
$url = "/".ceil($row->bookid/10000)."/{$forums}_{$row->bookid}.html";
$nickname = get_nickname($row->userid);
$search_arr[] = array('id'=>$row->id,'bookid'=>$row->bookid,'sid'=>$forums,'title'=>$content,'userid'=>$row->userid,'wdate'=>$row->wdate,'url'=>$url,'subname'=>$subname,'nickname'=>$nickname);
}
}
}
}
}
if ('huihu' == $_REQUEST['edit'])
{
$donotupdatemember = (int)$_REQUEST['donotupdatemember'];
$pids = (int)$_REQUEST['pids'];
$ptype = (int)$_REQUEST['ptype'];
$pidarray = $_REQUEST['pidarray'];
$starttime = addslashes(strip_tags(trim($_REQUEST['starttime1'])));
$endtime = addslashes(strip_tags(trim($_REQUEST['endtime1'])));
$users = addslashes(strip_tags(trim($_REQUEST['users1'])));
$useip = addslashes(strip_tags(trim($_REQUEST['useip1'])));
$keywords = addslashes(strip_tags(trim($_REQUEST['keywords1'])));
$ip = get_real_ip();
if (1==$ptype)
{
$book_name = "zbook_".$pids;
if (is_array($pidarray))
{
foreach ($pidarray as $pidrow)
{
$sql = "update $book_name set Forbid=0 where id=$pidrow";
$DB_Write->query($sql);
$sql = "select userid,title from $book_name where id=$pidrow";
$book_info = $DB_Read->get_row($sql,'O');
$book_title = $book_info->title;
$uid = $book_info->userid;
$sql = "update z_user set z_books=z_books+1";
if ($donotupdatemember)
{
$sql.=",z_score1=z_score1+20";
}
$sql .= " where z_userid='$uid'";
$DB_Write->query($sql);
}
}
}
else
{
$book_name = "zreply_".$pids;
if (is_array($pidarray))
{
foreach ($pidarray as $pidrow)
{
$sql = "update $book_name set Forbid=0 where id=$pidrow";
$DB_Write->query($sql);
$sql = "select bookid,userid from $book_name where id=$pidrow";
$book_info = $DB_Read->get_row($sql,'O');
$bookid = $book_info->bookid;
$uid = $book_info->userid;
$sql = "update z_user set z_replys=z_replys+1";
if ($donotupdatemember)
{
$sql.=",z_score1=z_score1+20";
}
$sql .= " where z_userid='$uid'";
$DB_Write->query($sql);
}
}
}
$url = "control.php?action=posts_huifu&edit=search&forums=$pids&type=$ptype&starttime=$starttime&endtime=$endtime&users=$users&useip=$useip&keywords=$keywords";
echo "<script>location.href='$url';</script>";
exit();
}
include template('posts_huifu','posts/');
?>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -