/moderation.php
PHP | 1073 lines | 534 code | 126 blank | 413 comment | 84 complexity | 9c8c05c499811ee8e035c92576476ed5 MD5 | raw file
Possible License(s): LGPL-2.1
- <?php
- ////////////////////////////////////////////////////////////////////////////////
- // //
- // Copyright (C) 2010 Phorum Development Team //
- // http://www.phorum.org //
- // //
- // This program is free software. You can redistribute it and/or modify //
- // it under the terms of either the current Phorum License (viewable at //
- // phorum.org) or the Phorum License that was distributed with this file //
- // //
- // 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. //
- // //
- // You should have received a copy of the Phorum License //
- // along with this program. //
- // //
- ////////////////////////////////////////////////////////////////////////////////
- define('phorum_page','moderation');
- include_once("./common.php");
- include_once("./include/moderation_functions.php");
- include_once("./include/thread_info.php");
- include_once("./include/email_functions.php");
- if(!phorum_check_read_common()) {
- return;
- }
- // CSRF protection: we do not accept posting to this script,
- // when the browser does not include a Phorum signed token
- // in the request.
- phorum_check_posting_token();
- $PHORUM["DATA"]["MODERATOR"] =
- phorum_api_user_check_access(PHORUM_USER_ALLOW_MODERATE_MESSAGES);
- if(isset($_POST["thread"])) {
- $msgthd_id = (int)$_POST["thread"];
- } elseif(isset($PHORUM['args'][2])) {
- $msgthd_id = (int)$PHORUM['args'][2];
- } else {
- $msgthd_id = 0;
- }
- if(isset($_POST["mod_step"])) {
- $mod_step = (int)$_POST["mod_step"];
- } elseif(isset($PHORUM['args'][1])) {
- $mod_step = (int)$PHORUM['args'][1];
- } else {
- $mod_step = 0;
- }
- if(empty($msgthd_id) || !$PHORUM["DATA"]["MODERATOR"]) {
- phorum_return_to_list();
- }
- // If the user is not fully logged in, send him to the login page.
- // because moderation action can vary so much, the only safe bet is to send them
- // to the referrer if they are not fully logged in
- if(!$PHORUM["DATA"]["FULLY_LOGGEDIN"]){
- phorum_redirect_by_url(phorum_get_url(PHORUM_LOGIN_URL, "redir=".$_SERVER["HTTP_REFERER"]));
- exit();
- }
- // if we gave the user a confirmation form and they clicked No, send them back to the message
- if(isset($_POST["confirmation"]) && $_POST["confirmation"]==$PHORUM["DATA"]["LANG"]["No"]){
- if(isset($_POST["prepost"])) {
- // add some additional args
- $addcode = "";
- if(isset($_POST['moddays']) && is_numeric($_POST['moddays'])) {
- $addcode.="moddays=".$_POST['moddays'];
- }
- if(isset($_POST['onlyunapproved']) && is_numeric($_POST['onlyunapproved'])) {
- if(!empty($addcode))
- $addcode.=",";
- $addcode.="onlyunapproved=".$_POST['onlyunapproved'];
- }
- $url = phorum_get_url(PHORUM_CONTROLCENTER_URL,"panel=".PHORUM_CC_UNAPPROVED,$addcode);
- } else {
- $message = phorum_db_get_message($msgthd_id);
- $url = phorum_get_url(PHORUM_READ_URL, $message["thread"], $message["message_id"]);
- }
- phorum_redirect_by_url($url);
- exit();
- }
- $template="message";
- // set all our URL's
- phorum_build_common_urls();
- // make it possible to override this var in a hook
- $is_admin_user=$PHORUM["user"]["admin"];
- /*
- * [hook]
- * moderation
- *
- * [description]
- * This hook can be used for logging moderator actions. You can
- * use the <literal>$PHORUM</literal> array to retrieve additional info
- * like the moderating user's id and similar.<sbr/>
- * <sbr/>
- * The moderation step id is the variable <literal>$mod_step</literal>
- * that is used in <filename>moderation.php</filename>. Please read that
- * script to see what moderation steps are available and for what moderation
- * actions they stand.<sbr/>
- * <sbr/>
- * When checking the moderation step id for a certain step, always use
- * the contstants that are defined for this in
- * <filename>include/constants.php</filename>. The numerical value of this
- * id can change between Phorum releases.
- *
- * [category]
- * Moderation
- *
- * [when]
- * At the start of <filename>moderation.php</filename>
- *
- * [input]
- * The id of the moderation step which is run (read-only).
- *
- * [output]
- * Same as input.
- *
- * [example]
- * <hookcode>
- * function phorum_mod_foo_moderation ($mod_step)
- * {
- * global $PHORUM;
- *
- * // Update the last timestamp for the moderation step
- * $PHORUM["mod_foo"]["moderation_step_timestamps"][$mod_step] = time();
- * phorum_db_update_settings(array("mod_foo" => $PHORUM["mod_foo"]));
- *
- * return $mod_step;
- * }
- * </hookcode>
- */
- if (isset($PHORUM["hooks"]["moderation"]))
- phorum_hook("moderation", $mod_step);
- $invalidate_message_cache = array();
- switch ($mod_step) {
- case PHORUM_DELETE_MESSAGE: // this is a message delete
- if(count($_GET) && empty($_POST["thread"])){
- $args = array(
- "mod_step" => PHORUM_DELETE_MESSAGE,
- "thread" => $msgthd_id
- );
- foreach($PHORUM["args"] as $k=>$v){
- if(!is_numeric($k)){
- $args[$k] = $v;
- }
- }
- return phorum_show_confirmation_form(
- $PHORUM["DATA"]["LANG"]["ConfirmDeleteMessage"],
- phorum_get_url(PHORUM_MODERATION_ACTION_URL),
- $args
- );
- }
- $message = phorum_db_get_message($msgthd_id);
- /*
- * [hook]
- * before_delete
- *
- * [description]
- * This hook allows modules to implement extra or different delete
- * functionality.<sbr/>
- * <sbr/>
- * The primary use of this hook would be for moving the messages
- * to some archive-area instead of really deleting them.
- *
- * [category]
- * Moderation
- *
- * [when]
- * In <filename>moderation.php</filename>, just before deleting
- * the message(s)
- *
- * [input]
- * An array containing the following 5 parameters:
- * <ul>
- * <li><literal>$delete_handled</literal>:
- * default = <literal>false</literal>, set it to true to avoid
- * the real delete afterwards</li>
- * <li><literal>$msg_ids</literal>:
- * an array containing all deleted message ids</li>
- * <li><literal>$msgthd_id</literal>:
- * the msg-id or thread-id to be deleted</li>
- * <li><literal>$message</literal>:
- * an array of the data for the message retrieved with
- * <literal>$msgthd_id</literal></li>
- * <li><literal>$delete_mode</literal>:
- * mode of deletion, either
- * <literal>PHORUM_DELETE_MESSAGE</literal> or
- * <literal>PHORUM_DELETE_TREE</literal></li>
- * </ul>
- *
- * [output]
- * Same as input.<sbr/>
- * <literal>$delete_handled</literal> and
- * <literal>$msg_ids</literal> are used as return data for the hook.
- *
- * [example]
- * <hookcode>
- * function phorum_mod_foo_before_delete($data)
- * {
- * global $PHORUM;
- *
- * // Store the message data in the module's settings for
- * // future use.
- * $PHORUM["mod_foo"]["deleted_messages"][$msgthd_id] = $message;
- * phorum_db_update_settings(array("mod_foo" => $PHORUM["mod_foo"]));
- *
- * return $data;
- * }
- * </hookcode>
- */
- $delete_handled = 0;
- if (isset($PHORUM["hooks"]["before_delete"]))
- list($delete_handled,$msg_ids,$msgthd_id,$message,$delete_mode) = phorum_hook("before_delete", array(0,0,$msgthd_id,$message,PHORUM_DELETE_MESSAGE));
- // Handle the delete action, unless a module already handled it.
- if (!$delete_handled) {
- // Delete the message from the database.
- phorum_db_delete_message($msgthd_id, PHORUM_DELETE_MESSAGE);
- // Delete the message attachments from the database.
- require_once('./include/api/file_storage.php');
- $files=phorum_db_get_message_file_list($msgthd_id);
- foreach($files as $file_id=>$data) {
- phorum_api_file_delete($file_id);
- }
- }
- /*
- * [hook]
- * delete
- *
- * [description]
- * This hook can be used for cleaning up anything you may have
- * created with the post_post hook or any other hook that stored
- * data tied to messages.
- *
- * [category]
- * Moderation
- *
- * [when]
- * In <filename>moderation.php</filename>, right after deleting a
- * message from the database.
- *
- * [input]
- * An array of ids for messages that have been deleted (read-only).
- *
- * [output]
- * Same as input.
- *
- * [example]
- * <hookcode>
- * function phorum_mod_foo_delete($msgthd_ids)
- * {
- * global $PHORUM;
- *
- * // Log the deleted message ids
- * foreach ($msgthd_ids as $msgthd_id) {
- * $PHORUM["mod_foo"]["deleted_messages"][] = $msgthd_id;
- * }
- * phorum_db_update_settings(array("mod_foo" => $PHORUM["mod_foo"]));
- *
- * return $msgthd_ids;
- * }
- * </hookcode>
- */
- if (isset($PHORUM["hooks"]["delete"]))
- phorum_hook("delete", array($msgthd_id));
- $PHORUM['DATA']['OKMSG']="1 ".$PHORUM["DATA"]['LANG']['MsgDeletedOk'];
- if(isset($PHORUM['args']['old_forum']) && !empty($PHORUM['args']['old_forum'])) {
- $PHORUM['forum_id']=(int)$PHORUM['args']['old_forum'];
- }
- if(isset($PHORUM['args']["prepost"])) {
- $PHORUM['DATA']["URL"]["REDIRECT"]=phorum_get_url(PHORUM_CONTROLCENTER_URL,"panel=".PHORUM_CC_UNAPPROVED);
- } else {
- $PHORUM['DATA']["URL"]["REDIRECT"]=$PHORUM["DATA"]["URL"]["LIST"];
- }
- break;
- case PHORUM_DELETE_TREE: // this is a message delete
- if(count($_GET) && empty($_POST["thread"])){
- $args = array(
- "mod_step" => PHORUM_DELETE_TREE,
- "thread" => $msgthd_id
- );
- foreach($PHORUM["args"] as $k=>$v){
- if(!is_numeric($k)){
- $args[$k] = $v;
- }
- }
- return phorum_show_confirmation_form(
- $PHORUM["DATA"]["LANG"]["ConfirmDeleteThread"],
- phorum_get_url(PHORUM_MODERATION_ACTION_URL),
- $args
- );
- }
- $message = phorum_db_get_message($msgthd_id);
- $nummsgs = 0;
- // A hook to allow modules to implement extra or different
- // delete functionality.
- $delete_handled = 0;
- if (isset($PHORUM["hooks"]["before_delete"]))
- list($delete_handled,$msg_ids,$msgthd_id,$message,$delete_mode) = phorum_hook("before_delete", array(0,array(),$msgthd_id,$message,PHORUM_DELETE_TREE));
- if(!$delete_handled) {
- // Delete the message and all its replies.
- $msg_ids = phorum_db_delete_message($msgthd_id, PHORUM_DELETE_TREE);
- // Cleanup the attachments for all deleted messages.
- require_once('./include/api/file_storage.php');
- foreach($msg_ids as $id){
- $files=phorum_db_get_message_file_list($id);
- foreach($files as $file_id=>$data){
- phorum_api_file_delete($file_id);
- }
- }
- // Check if we have moved threads to delete.
- // We unset the forum id, so phorum_db_get_messages()
- // will return messages with the same thread id in
- // other forums as well (those are the move notifications).
- $forum_id = $PHORUM["forum_id"];
- $PHORUM["forum_id"] = 0;
- $moved = phorum_db_get_messages($msgthd_id);
- $PHORUM["forum_id"] = $forum_id;
- foreach ($moved as $id => $data) {
- if (!empty($data["moved"])) {
- phorum_db_delete_message($id, PHORUM_DELETE_MESSAGE);
- }
- }
- }
- $nummsgs=count($msg_ids);
- // Run a hook for performing custom actions after cleanup.
- if (isset($PHORUM["hooks"]["delete"]))
- phorum_hook("delete", $msg_ids);
- $PHORUM['DATA']['OKMSG']=$nummsgs." ".$PHORUM["DATA"]["LANG"]['MsgDeletedOk'];
- if(isset($PHORUM['args']['old_forum']) && !empty($PHORUM['args']['old_forum'])) {
- $PHORUM['forum_id']=(int)$PHORUM['args']['old_forum'];
- }
- if(isset($PHORUM['args']["prepost"])) {
- // add some additional args
- $addcode = "";
- if(isset($PHORUM['args']['moddays']) && is_numeric($PHORUM['args']['moddays'])) {
- $addcode.="moddays=".$PHORUM['args']['moddays'];
- }
- if(isset($PHORUM['args']['onlyunapproved']) && is_numeric($PHORUM['args']['onlyunapproved'])) {
- if(!empty($addcode))
- $addcode.=",";
- $addcode.="onlyunapproved=".$PHORUM['args']['onlyunapproved'];
- }
- $PHORUM['DATA']["URL"]["REDIRECT"]=phorum_get_url(PHORUM_CONTROLCENTER_URL,"panel=".PHORUM_CC_UNAPPROVED,$addcode);
- } else {
- $PHORUM['DATA']["URL"]["REDIRECT"]=$PHORUM["DATA"]["URL"]["LIST"];
- }
- break;
- case PHORUM_MOVE_THREAD: // this is the first step of a message move
- include_once './include/forum_functions.php';
- $message = phorum_db_get_message($msgthd_id);
- $PHORUM['DATA']['URL']["ACTION"]=phorum_get_url(PHORUM_MODERATION_ACTION_URL);
- $PHORUM['DATA']["FORM"]["forum_id"]=$PHORUM["forum_id"];
- $PHORUM['DATA']["FORM"]["thread_id"]=$msgthd_id;
- $PHORUM['DATA']["FORM"]["mod_step"]=PHORUM_DO_THREAD_MOVE;
- $PHORUM['DATA']["FORM"]["subject"] =htmlspecialchars($message["subject"], ENT_COMPAT, $PHORUM["DATA"]["HCHARSET"]);
- // get all the forums the moderator may move to
- $PHORUM['DATA']["MoveForumsOption"]="";
- // TODO: this does not match the check at the start of the read
- // TODO: and list scripts, where we check if this user has perms
- // TODO: for moderation of two or more forums, before we
- // TODO: enable the move feature. We should either check
- // TODO: for 2 or more moderated forums and check that moving
- // TODO: is only done between moderated forums or check for
- // TODO: 1 or more moderated forums and allow moving between
- // TODO: any two forums. Now we have a mix of those two.
- // add && phorum_api_user_check_access(PHORUM_USER_ALLOW_MODERATE_MESSAGES, $id) if the
- // mod should only be able to move to forums he also moderates
- // get the forumlist
- $forums=phorum_build_forum_list();
- // ignore the current forum
- unset($forums[$PHORUM["forum_id"]]);
- $PHORUM['DATA']['FORUMS']=$forums;
- $PHORUM['DATA']['FRM']=1;
- $output=true;
- $template="move_form";
- break;
- case PHORUM_DO_THREAD_MOVE: // this is the last step of a message move
- $movetoid=(int)$_POST['moveto'];
- // only do something if a forum was selected
- if(empty($movetoid)) {
- $PHORUM['DATA']['MESSAGE']=$PHORUM["DATA"]['LANG']['MsgMoveSelectForum'];
- } else {
- $PHORUM['DATA']['OKMSG']=$PHORUM["DATA"]['LANG']['MsgMoveOk'];
- $PHORUM['DATA']["URL"]["REDIRECT"]=$PHORUM["DATA"]["URL"]["LIST"];
- $message = phorum_db_get_message($msgthd_id);
- // find out if we have a notification-message already in this
- // target-forum for this thread ... it doesn't make sense to keep this
- // message any longer as the thread has reappeared on its original location
- $temp_forum_id=$PHORUM['forum_id'];
- $PHORUM['forum_id']=$movetoid;
- $check_messages=phorum_db_get_messages($msgthd_id);
- unset($check_messages['users']);
- // ok, we found exactly one message of this thread in the target forum
- if(is_array($check_messages) && count($check_messages) == 1) {
- // ... going to delete it
- $tmp_message=array_shift($check_messages);
- $retval=phorum_db_delete_message($tmp_message['message_id']);
- }
- $PHORUM['forum_id']=$temp_forum_id;
- // Move the thread to another forum.
- phorum_db_move_thread($msgthd_id, $movetoid);
- // Create a new message in place of the old one to notify
- // visitors that the thread was moved.
- if(isset($_POST['create_notification']) && $_POST['create_notification']) {
- $newmessage = $message;
- $newmessage['body']=" -- moved topic -- ";
- $newmessage['moved']=1;
- $newmessage['sort']=PHORUM_SORT_DEFAULT;
- unset($newmessage['message_id']);
- phorum_db_post_message($newmessage);
- }
- /*
- * [hook]
- * move_thread
- *
- * [description]
- * This hook can be used for performing actions like sending
- * notifications or for making log entries after moving a
- * thread.
- *
- * [category]
- * Moderation
- *
- * [when]
- * In <filename>moderation.php</filename>, right after a thread
- * has been moved by a moderator.
- *
- * [input]
- * The id of the thread that has been moved (read-only).
- *
- * [output]
- * Same as input.
- *
- * [example]
- * <hookcode>
- * function phorum_mod_foo_move_thread($msgthd_id)
- * {
- * global $PHORUM;
- *
- * // Log the moved thread id
- * $PHORUM["mod_foo"]["moved_threads"][] = $msgthd_id;
- * phorum_db_update_settings(array("mod_foo" => $PHORUM["mod_foo"]));
- *
- * return $msgthd_ids;
- * }
- * </hookcode>
- */
- if (isset($PHORUM["hooks"]["move_thread"]))
- phorum_hook("move_thread", $msgthd_id);
- foreach ($message['meta']['message_ids'] as $message_id) {
- $invalidate_message_cache[] = array(
- "message_id" => $message_id,
- "forum_id" => $message['forum_id']
- );
- }
- }
- break;
- case PHORUM_CLOSE_THREAD: // we have to close a thread
- $PHORUM['DATA']['OKMSG']=$PHORUM["DATA"]['LANG']['ThreadClosedOk'];
- $PHORUM['DATA']["URL"]["REDIRECT"]=$PHORUM["DATA"]["URL"]["LIST"];
- phorum_db_close_thread($msgthd_id);
- /*
- * [hook]
- * close_thread
- *
- * [description]
- * This hook can be used for performing actions like sending
- * notifications or making log entries after closing threads.
- *
- * [category]
- * Moderation
- *
- * [when]
- * In <filename>moderation.php</filename>, right after a thread has
- * been closed by a moderator.
- *
- * [input]
- * The id of the thread that has been closed (read-only).
- *
- * [output]
- * Same as input.
- *
- * [example]
- * <hookcode>
- * function phorum_mod_foo_close_thread($msgthd_id)
- * {
- * global $PHORUM;
- *
- * // Log the closed thread id
- * $PHORUM["mod_foo"]["closed_threads"][] = $msgthd_id;
- * phorum_db_update_settings(array("mod_foo" => $PHORUM["mod_foo"]));
- *
- * return $msgthd_ids;
- * }
- * </hookcode>
- */
- if (isset($PHORUM["hooks"]["close_thread"]))
- phorum_hook("close_thread", $msgthd_id);
- $invalidate_message_cache[] = array(
- "message_id" => $msgthd_id,
- "forum_id" => $PHORUM["forum_id"]
- );
- break;
- case PHORUM_REOPEN_THREAD: // we have to reopen a thread
- $PHORUM['DATA']['OKMSG']=$PHORUM["DATA"]['LANG']['ThreadReopenedOk'];
- $PHORUM['DATA']["URL"]["REDIRECT"]=$PHORUM["DATA"]["URL"]["LIST"];
- phorum_db_reopen_thread($msgthd_id);
- /*
- * [hook]
- * reopen_thread
- *
- * [description]
- * This hook can be used for performing actions like sending
- * notifications or making log entries after reopening threads.
- *
- * [category]
- * Moderation
- *
- * [when]
- * In <filename>moderation.php</filename>, right after a thread has
- * been reopened by a moderator.
- *
- * [input]
- * The id of the thread that has been reopened (read-only).
- *
- * [output]
- * Same as input.
- *
- * [example]
- * <hookcode>
- * function phorum_mod_foo_reopen_thread($msgthd_id)
- * {
- * global $PHORUM;
- *
- * // Log the reopened thread id
- * $PHORUM["mod_foo"]["reopened_threads"][] = $msgthd_id;
- * phorum_db_update_settings(array("mod_foo" => $PHORUM["mod_foo"]));
- *
- * return $msgthd_id;
- * }
- * </hookcode>
- */
- if (isset($PHORUM["hooks"]["reopen_thread"]))
- phorum_hook("reopen_thread", $msgthd_id);
- $invalidate_message_cache[] = array(
- "message_id" => $msgthd_id,
- "forum_id" => $PHORUM["forum_id"]
- );
- break;
- case PHORUM_APPROVE_MESSAGE: // approving a message
- $PHORUM['DATA']['OKMSG']="1 ".$PHORUM["DATA"]['LANG']['MsgApprovedOk'];
- $old_message = phorum_db_get_message($msgthd_id);
- $newpost=array("status"=>PHORUM_STATUS_APPROVED);
- // setting the new status
- phorum_db_update_message($msgthd_id, $newpost);
- // updating the thread-info
- phorum_update_thread_info($old_message['thread']);
- // updating the forum-stats
- phorum_db_update_forum_stats(false, 1, $old_message["datestamp"]);
- /*
- * [hook]
- * after_approve
- *
- * [description]
- * This hook can be used for performing extra actions after a
- * message has been approved.
- *
- * [category]
- * Moderation
- *
- * [when]
- * In <filename>moderation.php</filename>, right approving a message
- * and possibly its replies.
- *
- * [input]
- * An array containing two elements:
- * <ul>
- * <li>The message data</li>
- * <li>The type of approval (either
- * <literal>PHORUM_APPROVE_MESSAGE</literal> or
- * <literal>PHORUM_APPROVE_MESSAGE_TREE</literal>)</li>
- * </ul>
- *
- * [output]
- * Same as input.
- *
- * [example]
- * <hookcode>
- * function phorum_mod_foo_after_approve($data)
- * {
- * global $PHORUM;
- *
- * // alert the message author that their message has been
- * // approved
- * $pm_message = preg_replace(
- * "%message_subject%",
- * $data[0]["subject"],
- * $PHORUM["DATA"]["LANG"]["mod_foo"]["MessageApprovedBody"]
- * );
- * phorum_db_pm_send(
- * $PHORUM["DATA"]["LANG"]["mod_foo"]["MessageApprovedSubject"],
- * $pm_message,
- * $data[0]["user_id"]
- * );
- *
- * return $data;
- *
- * }
- * </hookcode>
- */
- if (isset($PHORUM["hooks"]["after_approve"]))
- phorum_hook("after_approve", array($old_message, PHORUM_APPROVE_MESSAGE));
- if($old_message['status'] != PHORUM_STATUS_HIDDEN ) {
- phorum_email_notice($old_message);
- }
- if(isset($PHORUM['args']['old_forum']) && is_numeric($PHORUM['args']['old_forum'])) {
- $PHORUM['forum_id']=(int)$PHORUM['args']['old_forum'];
- }
- if(isset($PHORUM['args']["prepost"])) {
- // add some additional args
- $addcode = "";
- if(isset($PHORUM['args']['moddays']) && is_numeric($PHORUM['args']['moddays'])) {
- $addcode.="moddays=".$PHORUM['args']['moddays'];
- }
- if(isset($PHORUM['args']['onlyunapproved']) && is_numeric($PHORUM['args']['onlyunapproved'])) {
- if(!empty($addcode))
- $addcode.=",";
- $addcode.="onlyunapproved=".$PHORUM['args']['onlyunapproved'];
- }
- $PHORUM['DATA']["URL"]["REDIRECT"]=phorum_get_url(PHORUM_CONTROLCENTER_URL,"panel=".PHORUM_CC_UNAPPROVED,$addcode);
- } else {
- $PHORUM['DATA']["URL"]["REDIRECT"]=$PHORUM["DATA"]["URL"]["LIST"];
- }
- $invalidate_message_cache[] = array(
- "message_id" => $msgthd_id,
- "forum_id" => $PHORUM["forum_id"]
- );
-
- break;
- case PHORUM_APPROVE_MESSAGE_TREE: // approve a message and all answers to it
- $old_message = phorum_db_get_message($msgthd_id);
- $newpost=array("status"=>PHORUM_STATUS_APPROVED);
- $mids = phorum_db_get_messagetree($msgthd_id, $old_message["forum_id"]);
- // make an array from the string
- $mids_arr=explode(",",$mids);
- // count the entries for later use
- $num_approved=count($mids_arr);
- foreach($mids_arr as $key => $mid) {
- // setting the new status
- phorum_db_update_message($mid, $newpost);
-
- $invalidate_message_cache[] = array(
- "message_id" => $mid,
- "forum_id" => $PHORUM["forum_id"]
- );
- }
- // updating the thread-info
- phorum_update_thread_info($old_message['thread']);
- // updating the forum-stats
- phorum_db_update_forum_stats(false, "+$num_approved", $old_message["datestamp"]);
- if (isset($PHORUM["hooks"]["after_approve"]))
- phorum_hook("after_approve", array($old_message, PHORUM_APPROVE_MESSAGE_TREE));
- $PHORUM['DATA']['OKMSG']="$num_approved ".$PHORUM['DATA']['LANG']['MsgApprovedOk'];
- if(isset($PHORUM['args']["prepost"])) {
- // add some additional args
- $addcode = "";
- if(isset($PHORUM['args']['moddays']) && is_numeric($PHORUM['args']['moddays'])) {
- $addcode.="moddays=".$PHORUM['args']['moddays'];
- }
- if(isset($PHORUM['args']['onlyunapproved']) && is_numeric($PHORUM['args']['onlyunapproved'])) {
- if(!empty($addcode))
- $addcode.=",";
- $addcode.="onlyunapproved=".$PHORUM['args']['onlyunapproved'];
- }
- $PHORUM['DATA']["URL"]["REDIRECT"]=phorum_get_url(PHORUM_CONTROLCENTER_URL,"panel=".PHORUM_CC_UNAPPROVED,$addcode);
- } else {
- $PHORUM['DATA']["URL"]["REDIRECT"]=$PHORUM["DATA"]["URL"]["LIST"];
- }
-
-
- break;
- case PHORUM_HIDE_POST: // hiding a message (and its replies)
- $old_message = phorum_db_get_message($msgthd_id);
- $newpost=array("status"=>PHORUM_STATUS_HIDDEN);
- $mids = phorum_db_get_messagetree($msgthd_id, $old_message["forum_id"]);
- // make an array from the string
- $mids_arr=explode(",",$mids);
- // count the entries for later use
- $num_hidden=count($mids_arr);
- foreach($mids_arr as $key => $mid) {
- // setting the new status
- phorum_db_update_message($mid, $newpost);
- }
- /*
- * [hook]
- * hide_thread
- *
- * [description]
- * This hook can be used for performing actions like sending
- * notifications or making log entries after hiding a message.
- *
- * [category]
- * Moderation
- *
- * [when]
- * In <filename>moderation.php</filename>, right after a message has
- * been hidden by a moderator.
- *
- * [input]
- * The id of the thread that has been hidden (read-only).
- *
- * [output]
- * Same as input.
- *
- * [example]
- * <hookcode>
- * function phorum_mod_foo_hide_thread($msgthd_id)
- * {
- * global $PHORUM;
- *
- * // Log the hidden thread id
- * $PHORUM["mod_foo"]["hidden_threads"][] = $msgthd_id;
- * phorum_db_update_settings(array("mod_foo" => $PHORUM["mod_foo"]));
- *
- * return $msgthd_id;
- * }
- * </hookcode>
- */
- if (isset($PHORUM["hooks"]["hide_thread"]))
- phorum_hook("hide_thread", $msgthd_id);
- // updating the thread-info
- phorum_update_thread_info($old_message['thread']);
- // updating the forum-stats
- phorum_db_update_forum_stats(false, "-$num_hidden");
- $PHORUM['DATA']['OKMSG']="$num_hidden ".$PHORUM['DATA']['LANG']['MsgHiddenOk'];
- if(isset($PHORUM['args']["prepost"])) {
- $PHORUM['DATA']["URL"]["REDIRECT"]=phorum_get_url(PHORUM_CONTROLCENTER_URL,"panel=".PHORUM_CC_UNAPPROVED);
- } else {
- $PHORUM['DATA']["URL"]["REDIRECT"]=$PHORUM["DATA"]["URL"]["LIST"];
- }
- break;
- case PHORUM_MERGE_THREAD: // this is the first step of a thread merge
- $template="merge_form";
- $PHORUM['DATA']['URL']["ACTION"] = phorum_get_url(PHORUM_MODERATION_ACTION_URL);
- $PHORUM['DATA']["FORM"]["forum_id"] = $PHORUM["forum_id"];
- $PHORUM['DATA']["FORM"]["thread_id"] = $msgthd_id;
- $PHORUM['DATA']["FORM"]["mod_step"] = PHORUM_DO_THREAD_MERGE;
- // the moderator selects the target thread to merge to
- $merge_t1 = phorum_moderator_data_get('merge_t1');
- if( !$merge_t1 || $merge_t1==$msgthd_id ) {
- phorum_moderator_data_put('merge_t1', $msgthd_id);
- $PHORUM['DATA']["FORM"]["merge_none"] =true;
- $message = phorum_db_get_message($msgthd_id, "message_id", true);
- $PHORUM['DATA']["FORM"]["merge_subject1"] =htmlspecialchars($message["subject"], ENT_COMPAT, $PHORUM["DATA"]["HCHARSET"]);
- }
- // the moderator selects the source thread to merge from
- else {
- $PHORUM['DATA']["FORM"]["merge_t1"] =$merge_t1;
- $message = phorum_db_get_message($merge_t1, "message_id", true);
- $PHORUM['DATA']["FORM"]["merge_subject1"] =htmlspecialchars($message["subject"], ENT_COMPAT, $PHORUM["DATA"]["HCHARSET"]);
- $message = phorum_db_get_message($msgthd_id);
- $PHORUM['DATA']["FORM"]["thread_subject"] =htmlspecialchars($message["subject"], ENT_COMPAT, $PHORUM["DATA"]["HCHARSET"]);
- }
- break;
- case PHORUM_DO_THREAD_MERGE: // this is the last step of a thread merge
- if( isset($_POST['thread1']) && $_POST['thread1']) {
- // Commit Thread Merge
- settype($_POST['thread1'], "int");
- settype($_POST['thread'], "int"); // Thread 2
- $PHORUM['DATA']['OKMSG'] = $PHORUM["DATA"]['LANG']['MsgMergeOk'];
- $PHORUM['DATA']["URL"]["REDIRECT"] = $PHORUM["DATA"]["URL"]["LIST"];
- $PHORUM["reverse_threading"] = 0;
- // Get the target thread.
- $target =phorum_db_get_message($_POST['thread1'], "message_id", true);
- if (!$target) trigger_error(
- "Can't retrieve target thread " . $_POST['thread1'],
- E_USER_ERROR
- );
- // Get all messages from the thread that we have to merge.
- $merge_messages=phorum_db_get_messages($_POST['thread']);
- unset($merge_messages['users']);
- // Create new messages in the target thread for
- // all messages that have to be merged.
- $msgid_translation=array();
- foreach($merge_messages as $msg)
- {
- $oldid=$msg['message_id'];
- $msg['thread'] = $target['thread']; // the thread we merge with
- $msg['forum_id'] = $target['forum_id']; // the forum_id of the new thread
- $msg['sort'] = $target['sort']; // the sort type of the new thread
- if($msg['message_id'] == $msg['thread']) {
- $msg['parent_id']=$target['thread'];
- } elseif(isset($msgid_translation[$msg['parent_id']])) {
- $msg['parent_id']=$msgid_translation[$msg['parent_id']];
- } else {
- $msg['parent_id']=$msg['thread'];
- }
- unset($msg['message_id']);
- unset($msg['modifystamp']);
- phorum_db_post_message($msg,true);
- // Link attached files to the new message id.
- $linked_files = phorum_db_get_message_file_list($oldid);
- foreach ($linked_files as $linked_file) {
- phorum_db_file_link($linked_file["file_id"], $msg["message_id"], PHORUM_LINK_MESSAGE);
- }
- // save the new message-id for later use
- $msgid_translation[$oldid]=$msg['message_id'];
- }
- // deleting messages which are now doubled
- phorum_db_delete_message($_POST['thread'], PHORUM_DELETE_TREE);
- // update message count / stats
- phorum_db_update_forum_stats(true);
- // change forum_id for the following calls to update the right forum
- $PHORUM["forum_id"] =$target['forum_id'];
- // update message count / stats
- phorum_update_thread_info($target['thread']);
- phorum_db_update_forum_stats(true);
- /*
- * [hook]
- * after_merge
- *
- * [description]
- * This hook can be used for performing actions on
- * merging threads
- *
- * [category]
- * Moderation
- *
- * [when]
- * In <filename>moderation.php</filename>, right after two threads have
- * been merged by a moderator.
- *
- * [input]
- * An array with the translated message-ids; old-message_id -> new-message_id
- *
- * [output]
- * Same as input.
- */
- phorum_hook('after_merge', $msgid_translation);
- } else {
- // Cancel Thread Merge
- $PHORUM['DATA']['OKMSG']=$PHORUM["DATA"]['LANG']['MsgMergeCancel'];
- $PHORUM['DATA']["URL"]["REDIRECT"]=$PHORUM["DATA"]["URL"]["LIST"];
- }
- // unset temporary moderator_data
- phorum_moderator_data_remove('merge_t1');
- break;
- case PHORUM_SPLIT_THREAD: // this is the first step of a thread split
- $PHORUM['DATA']['URL']["ACTION"]=phorum_get_url(PHORUM_MODERATION_ACTION_URL);
- $PHORUM['DATA']["FORM"]["forum_id"]=$PHORUM["forum_id"];
- $message =phorum_db_get_message($msgthd_id);
- $PHORUM['DATA']["FORM"]["thread_id"]=$message["thread"];
- $PHORUM['DATA']["FORM"]["message_id"]=$msgthd_id;
- $PHORUM['DATA']["FORM"]["message_subject"]=htmlspecialchars($message["subject"], ENT_COMPAT, $PHORUM["DATA"]["HCHARSET"]);
- $PHORUM['DATA']["FORM"]["mod_step"]=PHORUM_DO_THREAD_SPLIT;
- $template="split_form";
- break;
- case PHORUM_DO_THREAD_SPLIT: // this is the last step of a thread split
- $PHORUM['DATA']['OKMSG']=$PHORUM["DATA"]['LANG']['MsgSplitOk'];
- $PHORUM['DATA']["URL"]["REDIRECT"]=$PHORUM["DATA"]["URL"]["LIST"];
- settype($_POST['forum_id'], "int");
- settype($_POST['message'], "int");
- settype($_POST['thread'], "int");
- phorum_db_split_thread($_POST['message'],$_POST['forum_id']);
- if ($PHORUM['cache_messages']) {
- $message = phorum_db_get_message($_POST['thread']);
- foreach ($message['meta']['message_ids'] as $message_id) {
- phorum_cache_remove('message', $message_id);
- }
- }
- // update message count / stats
- phorum_update_thread_info($_POST['thread']);
- phorum_update_thread_info($_POST['message']);
- phorum_db_update_forum_stats(true);
- /*
- * [hook]
- * after_split
- *
- * [description]
- * This hook can be used for performing actions on
- * splitting threads
- *
- * [category]
- * Moderation
- *
- * [when]
- * In <filename>moderation.php</filename>, right after a thread has
- * been split by a moderator.
- *
- * [input]
- * The id of the newly created thread
- *
- * [output]
- * Same as input.
- */
- phorum_hook('after_split', $_POST['message']);
- break;
- default:
- if(!isset($PHORUM['DATA']['OKMSG'])) $PHORUM['DATA']['OKMSG']="";
- $PHORUM['DATA']["URL"]["REDIRECT"]=$PHORUM["DATA"]["URL"]["LIST"];
- }
- // remove the affected messages from the cache if caching is enabled.
- if ($PHORUM['cache_messages']) {
- $invalidate_forums = array();
- foreach($invalidate_message_cache as $message) {
- phorum_cache_remove('message', $message["message_id"]);
- $invalidate_forums[$message['forum_id']]=$message['forum_id'];
- }
-
- if(is_array($invalidate_forums) && count($invalidate_forums)) {
- // retrieve the data for all involved forums to get the correct cache version
- $forums_data = phorum_api_forums_get($invalidate_forums);
-
- // increment the cache version for all involved forums once
- foreach($invalidate_forums as $forum_id) {
- phorum_db_update_forum(array('forum_id'=>$forum_id,'cache_version'=>($forums_data[$forum_id]['cache_version']+1)));
- }
- }
- }
- if(!isset($PHORUM['DATA']['BACKMSG'])) {
- $PHORUM['DATA']["BACKMSG"]=$PHORUM['DATA']["LANG"]["BackToList"];
- }
- phorum_output($template);
- ?>