📄 report.php
字号:
<?php
// $Id: report.php,v 1.1.2.8 2004/11/20 15:18:19 phppp Exp $
// ------------------------------------------------------------------------ //
// XOOPS - PHP Content Management System //
// Copyright (c) 2000 XOOPS.org //
// <http://www.xoops.org/> //
// ------------------------------------------------------------------------ //
// This program is free software; you can redistribute it and/or modify //
// it under the terms of the GNU General Public License as published by //
// the Free Software Foundation; either version 2 of the License, or //
// (at your option) any later version. //
// //
// You may not change or alter any portion of this comment or credits //
// of supporting developers from this source code or any supporting //
// source code which is considered copyrighted (c) material of the //
// original comment or credit authors. //
// //
// This program is distributed in the hope that it will be useful, //
// but WITHOUT ANY WARRANTY; without even the implied warranty of //
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the //
// GNU General Public License for more details. //
// //
// You should have received a copy of the GNU General Public License //
// along with this program; if not, write to the Free Software //
// Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA //
// ------------------------------------------------------------------------ //
class Report extends XoopsObject {
function Report()
{
$this->db = &Database::getInstance();
$this->table = $this->db->prefix("bb_report");
$this->initVar('report_id', XOBJ_DTYPE_INT);
$this->initVar('post_id', XOBJ_DTYPE_INT);
$this->initVar('reporter_uid', XOBJ_DTYPE_INT);
$this->initVar('reporter_ip', XOBJ_DTYPE_INT);
$this->initVar('report_time', XOBJ_DTYPE_INT);
$this->initVar('report_text', XOBJ_DTYPE_TXTAREA);
$this->initVar('report_result', XOBJ_DTYPE_TXTAREA);
$this->initVar('report_memo', XOBJ_DTYPE_TXTAREA);
}
function prepareVars()
{
foreach ($this->vars as $k => $v) {
$cleanv = $this->cleanVars[$k];
switch ($v['data_type']) {
case XOBJ_DTYPE_TXTBOX:
case XOBJ_DTYPE_TXTAREA:
case XOBJ_DTYPE_SOURCE:
case XOBJ_DTYPE_EMAIL:
$cleanv = ($v['changed'])?$cleanv:'';
if (!isset($v['not_gpc']) || !$v['not_gpc']) {
$cleanv = $this->db->quoteString($cleanv);
}
break;
case XOBJ_DTYPE_INT:
$cleanv = ($v['changed'])?$cleanv:0;
break;
case XOBJ_DTYPE_ARRAY:
$cleanv = ($v['changed'])?$cleanv:serialize(array());
break;
case XOBJ_DTYPE_STIME:
case XOBJ_DTYPE_MTIME:
case XOBJ_DTYPE_LTIME:
$cleanv = ($v['changed'])?$cleanv:0;
break;
default:
break;
}
$this->cleanVars[$k] = &$cleanv;
unset($cleanv);
}
return true;
}
}
class NewbbReportHandler extends XoopsObjectHandler {
function &get($id)
{
if (!$id) return false;
$sql = 'SELECT * FROM ' . $this->db->prefix('bb_report') . ' WHERE report_id=' . $id;
$array = $this->db->fetchArray($this->db->query($sql));
$report = &$this->create(false);
$report->assignVars($array);
return $report;
}
function &create($isNew = true)
{
$report = new Report();
if ($isNew) {
$report->setNew();
}
return $report;
}
function process($report_id, $report_memo)
{
$sql = "UPDATE " . $this->db->prefix("bb_report") . " SET report_result = 1, report_memo = " . $this->db->quoteString($report_memo) . " WHERE report_id = $report_id";
if (!$result = $this->db->queryF($sql)) {
echo "<br />process report error:" . $sql;
return false;
}
return true;
}
function &getByPost($posts)
{
if (!$posts) return false;
if (!is_array($posts)) $posts = array($posts);
$post_criteria = ' post_id IN (' . implode(',', $posts) . ')';
$sql = "SELECT * FROM " . $db->prefix('bb_report') . " WHERE " . $post_criteria;
$result = $this->db->queryF($sql);
while ($myrow = $this->db->fetchArray($result)) {
$report = &$post_handler->create(false);
$report->assignVars($myrow);
$ret[$myrow['report_id']] = $report;
unset($report);
}
return $ret;
}
function getReportCount($criteria, $forums = 0)
{
if (!$forums) {
$forum_criteria = '';
} else if (!is_array($forums)) {
$forums = array($forums);
$forum_criteria = ' r LEFT JOIN ' . $this->db->prefix("bb_posts") . ' p ON p.post_id= r.post_id WHERE p.forum_id IN (' . implode(',', $forums) . ')';
}
$tables_criteria = ' FROM ' . $this->db->prefix('bb_report');
$operator = (empty($forum_criteria))? ' WHERE ':' AND ';
$result_criteria = (isset($criteria))?$operator.' report_result = ' . intval($criteria):'';
$sql = "SELECT COUNT(*) as report_count " . $tables_criteria . $forum_criteria . $result_criteria;
$result = $this->db->query($sql);
if ($result) $row = $this->db->fetchArray($result);
return $row['report_count'];
}
function &getAllReports($forums = 0, $order = "ASC", $perpage = 0, &$start, $report_result = 0, $report_id = 0)
{
if ($order == "DESC") {
$operator_for_position = '>' ;
} else {
$order = "ASC" ;
$operator_for_position = '<' ;
}
$order_criteria = " ORDER BY r.report_id $order";
if ($perpage <= 0) {
$perpage = 10;
}
if (empty($start)) {
$start = 0;
}
$result_criteria = ' AND r.report_result = ' . $report_result;
if (!$forums) {
$forum_criteria = '';
} else if (!is_array($forums)) {
$forums = array($forums);
$forum_criteria = ' AND p.forum_id IN (' . implode(',', $forums) . ')';
}
$tables_criteria = ' FROM ' . $this->db->prefix('bb_report') . ' r, ' . $this->db->prefix('bb_posts') . ' p WHERE r.post_id= p.post_id';
if ($report_id) {
$result = $this->db->query("SELECT COUNT(*) as report_count" . $tables_criteria . $forum_criteria . $result_criteria . " AND report_id $operator_for_position $report_id" . $order_criteria);
if ($result) $row = $this->db->fetchArray($result);
$position = $row['report_count'];
$start = intval($position / $perpage) * $perpage;
}
$sql = "SELECT r.*, p.subject, p.topic_id, p.forum_id" . $tables_criteria . $forum_criteria . $result_criteria . $order_criteria;
$result = $this->db->query($sql, $perpage, $start);
$ret = array();
$report_handler = &xoops_getmodulehandler('report', 'newbb');
while ($myrow = $this->db->fetchArray($result)) {
$ret[] = $myrow; // return as array
}
return $ret;
}
function insert(&$report)
{
if (!$report->isDirty()) return true;
if (!$report->cleanVars())return false;
$report->prepareVars();
foreach ($report->cleanVars as $k => $v) {
${$k} = $v;
}
if ($report->isNew()) {
$report_id = $this->db->genId($this->db->prefix("bb_report") . "_report_id_seq");
$sql = "INSERT INTO " . $this->db->prefix("bb_report") . "
( report_id, post_id, reporter_uid, reporter_ip, report_time, report_text, report_result, report_memo )
VALUES
( $report_id, $post_id, $reporter_uid, $reporter_ip, $report_time, $report_text, $report_result, $report_memo )";
if (!$result = $this->db->queryF($sql)) {
echo "<br />Insert report error:" . $sql;
return false;
}
if ($report_id == 0) $report_id = $this->db->getInsertId();
$report->setVar('report_id', $report_id);
} else {
$sql = "UPDATE " . $this->db->prefix("bb_report") . " SET report_result = $report_result, report_memo = $report_memo WHERE report_id = " . $report->getVar('report_id');
$result = $this->db->queryF($sql);
if (!$result) {
echo "<br />Process report error:" . $sql;
return false;
}
}
return $report->getVar('report_id');
}
function delete($report)
{
if (is_object($report)) $report_id = $report->getVar('report_id');
else $report_id = $report;
$sql = "DELETE FROM " . $this->db->prefix("bb_report") . " WHERE report_id=" . $report_id . "";
if (! $result = $this->db->queryF($sql)) {
echo "<br />Delete report error:" . $sql;
return false;
}
return true;
}
}
?>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -