Vergleich inc/class_moderation.php - 1.8.0 - 1.8.38

Keine Änderungen Hinzugefügt Modifiziert Entfernt
Zeile 13	Zeile 13
/** * Close one or more threads *	/** * Close one or more threads *
* @param array Thread IDs	* @param array\|int $tids Thread ID(s)
* @return boolean true */ function close_threads($tids)	* @return boolean true */ function close_threads($tids)
Zeile 43	Zeile 43
/** * Open one or more threads *	/** * Open one or more threads *
* @param int Thread IDs * @return boolean true	* @param array\|int $tids Thread ID(s) * @return boolean
*/ function open_threads($tids)	*/ function open_threads($tids)
{ global $db, $plugins; if(!is_array($tids)) { $tids = array($tids); } if(empty($tids)) { return false; } // Make sure we only have valid values $tids = array_map('intval', $tids);	{ global $db, $plugins; if(!is_array($tids)) { $tids = array($tids); } if(empty($tids)) { return false; } // Make sure we only have valid values $tids = array_map('intval', $tids);
$plugins->run_hooks("class_moderation_open_threads", $tids); $tid_list = implode(',', $tids);	$plugins->run_hooks("class_moderation_open_threads", $tids); $tid_list = implode(',', $tids);

$closethread = array( "closed" => 0, );	$closethread = array( "closed" => 0, );
$db->update_query("threads", $closethread, "tid IN ($tid_list)");	$db->update_query("threads", $closethread, "tid IN ($tid_list)");
return true; } /** * Stick one or more threads *	return true; } /** * Stick one or more threads *
* @param int Thread IDs * @return boolean true	* @param array\|int $tids Thread ID(s) * @return boolean
*/ function stick_threads($tids)	*/ function stick_threads($tids)
{ global $db, $plugins; if(!is_array($tids)) { $tids = array($tids); } if(empty($tids)) { return false; } // Make sure we only have valid values $tids = array_map('intval', $tids); $plugins->run_hooks("class_moderation_stick_threads", $tids);	{ global $db, $plugins; if(!is_array($tids)) { $tids = array($tids); } if(empty($tids)) { return false; } // Make sure we only have valid values $tids = array_map('intval', $tids); $plugins->run_hooks("class_moderation_stick_threads", $tids);
$tid_list = implode(',', $tids); $stickthread = array( "sticky" => 1,	$tid_list = implode(',', $tids); $stickthread = array( "sticky" => 1,
);	);
$db->update_query("threads", $stickthread, "tid IN ($tid_list)");	$db->update_query("threads", $stickthread, "tid IN ($tid_list)");
return true; } /**	return true; } /**
* Unstick one or more thread *	* Unstick one or more thread *
* @param int Thread IDs * @return boolean true	* @param array\|int $tids Thread ID(s) * @return boolean
*/ function unstick_threads($tids) {	*/ function unstick_threads($tids) {
Zeile 124	Zeile 124
if(!is_array($tids)) { $tids = array($tids);	if(!is_array($tids)) { $tids = array($tids);
}	}
if(empty($tids)) { return false;	if(empty($tids)) { return false;
Zeile 137	Zeile 137
$plugins->run_hooks("class_moderation_unstick_threads", $tids); $tid_list = implode(',', $tids);	$plugins->run_hooks("class_moderation_unstick_threads", $tids); $tid_list = implode(',', $tids);

$unstickthread = array( "sticky" => 0, );	$unstickthread = array( "sticky" => 0, );
Zeile 149	Zeile 149
/** * Remove redirects that redirect to the specified thread *	/** * Remove redirects that redirect to the specified thread *
* @param int Thread ID of the thread * @return boolean true	* @param int $tid Thread ID of the thread * @return boolean
*/ function remove_redirects($tid) {	*/ function remove_redirects($tid) {
Zeile 177	Zeile 177
/** * Delete a thread *	/** * Delete a thread *
* @param int Thread ID of the thread * @return boolean true	* @param int $tid Thread ID of the thread * @return boolean
*/ function delete_thread($tid) {	*/ function delete_thread($tid) {
Zeile 238	Zeile 238
} }	} }
if($forum['usethreadcounts'] != 0)	if($forum['usethreadcounts'] != 0 && substr($thread['closed'], 0, 6) != 'moved\|')
{ if(!isset($userposts[$thread['uid']]['num_threads'])) {	{ if(!isset($userposts[$thread['uid']]['num_threads'])) {
Zeile 254	Zeile 254
{ foreach($userposts as $uid => $subtract) {	{ foreach($userposts as $uid => $subtract) {
$update_array = array( "postnum" => "-{$subtract['num_posts']}", "threadnum" => "-{$subtract['num_threads']}", );	$update_array = array(); if(isset($subtract['num_posts'])) { $update_array['postnum'] = "-{$subtract['num_posts']}"; } if(isset($subtract['num_threads'])) { $update_array['threadnum'] = "-{$subtract['num_threads']}"; }
update_user_counters($uid, $update_array); } }	update_user_counters($uid, $update_array); } }
Zeile 315	Zeile 323
$updated_counters['deletedposts'] = -1; } else	$updated_counters['deletedposts'] = -1; } else
{	{
$updated_counters['unapprovedposts'] = -1; } }	$updated_counters['unapprovedposts'] = -1; } }
Zeile 323	Zeile 331
// Update forum count update_forum_counters($thread['fid'], $updated_counters); update_forum_lastpost($thread['fid']);	// Update forum count update_forum_counters($thread['fid'], $updated_counters); update_forum_lastpost($thread['fid']);
	mark_reports($tid, 'thread');
$plugins->run_hooks("class_moderation_delete_thread", $tid);	$plugins->run_hooks("class_moderation_delete_thread", $tid);
return true; } /**	return true; } /**
* Delete a poll *	* Delete a poll *
* @param int Poll id * @return boolean true	* @param int $pid Poll id * @return boolean
*/ function delete_poll($pid) {	*/ function delete_poll($pid) {
Zeile 357	Zeile 366
return true; }	return true; }

/** * Approve one or more threads *	/** * Approve one or more threads *
* @param array Thread IDs * @return boolean true	* @param array\|int $tids Thread ID(s) * @return boolean
*/ function approve_threads($tids) {	*/ function approve_threads($tids) {
Zeile 371	Zeile 380
if(!is_array($tids)) { $tids = array($tids);	if(!is_array($tids)) { $tids = array($tids);
}	}
if(empty($tids)) { return false; }	if(empty($tids)) { return false; }

// Make sure we only have valid values $tids = array_map('intval', $tids);	// Make sure we only have valid values $tids = array_map('intval', $tids);

$tid_list = $forum_counters = $user_counters = $posts_to_approve = array();	$tid_list = $forum_counters = $user_counters = $posts_to_approve = array();
foreach($tids as $tid)	$tids_list = implode(",", $tids); $query = $db->simple_select("threads", "*", "tid IN ($tids_list)"); while($thread = $db->fetch_array($query))
{	{
$thread = get_thread($tid); if(!$thread \|\| $thread['visible'] == 1 \|\| $thread['visible'] == -1)	if($thread['visible'] == 1 \|\| $thread['visible'] == -1)
{ continue; }	{ continue; }
Zeile 401	Zeile 412
'num_threads' => 0, 'num_deleted_posts' => 0, 'num_unapproved_posts' => 0	'num_threads' => 0, 'num_deleted_posts' => 0, 'num_unapproved_posts' => 0
); }	); }
if(!isset($user_counters[$thread['uid']])) { $user_counters[$thread['uid']] = array(	if(!isset($user_counters[$thread['uid']])) { $user_counters[$thread['uid']] = array(
Zeile 420	Zeile 431
if($forum['usepostcounts'] != 0) { // On approving thread restore user post counts	if($forum['usepostcounts'] != 0) { // On approving thread restore user post counts
$query = $db->simple_select("posts", "COUNT(pid) as posts, uid", "tid='{$tid}' AND (visible='1' OR pid='{$thread['firstpost']}') AND uid > 0 GROUP BY uid"); while($counter = $db->fetch_array($query))	$query2 = $db->simple_select("posts", "COUNT(pid) as posts, uid", "tid='{$thread['tid']}' AND (visible='1' OR pid='{$thread['firstpost']}') AND uid > 0 GROUP BY uid"); while($counter = $db->fetch_array($query2))
{	{
	if(!isset($user_counters[$counter['uid']])) { $user_counters[$counter['uid']] = array( 'num_posts' => 0, 'num_threads' => 0 ); }
$user_counters[$counter['uid']]['num_posts'] += $counter['posts'];	$user_counters[$counter['uid']]['num_posts'] += $counter['posts'];
}	}
}	}
if($forum['usethreadcounts'] != 0)	if($forum['usethreadcounts'] != 0 && substr($thread['closed'], 0, 6) != 'moved\|')
{ ++$user_counters[$thread['uid']]['num_threads']; }	{ ++$user_counters[$thread['uid']]['num_threads']; }
Zeile 463	Zeile 481
if(!empty($posts_to_approve)) { $db->update_query("posts", $approve, "pid IN (".implode(',', $posts_to_approve).")");	if(!empty($posts_to_approve)) { $db->update_query("posts", $approve, "pid IN (".implode(',', $posts_to_approve).")");
}	}
$plugins->run_hooks("class_moderation_approve_threads", $tids); if(!empty($forum_counters))	$plugins->run_hooks("class_moderation_approve_threads", $tids); if(!empty($forum_counters))
Zeile 478	Zeile 496
"posts" => "+{$counters['num_posts']}", "unapprovedposts" => "-{$counters['num_unapproved_posts']}", "deletedposts" => "+{$counters['num_deleted_posts']}"	"posts" => "+{$counters['num_posts']}", "unapprovedposts" => "-{$counters['num_unapproved_posts']}", "deletedposts" => "+{$counters['num_deleted_posts']}"
); update_forum_counters($fid, $update_array); update_forum_lastpost($fid); } }	); update_forum_counters($fid, $update_array); update_forum_lastpost($fid); } }
if(!empty($user_counters)) { foreach($user_counters as $uid => $counters)	if(!empty($user_counters)) { foreach($user_counters as $uid => $counters)
Zeile 502	Zeile 520
/** * Unapprove one or more threads *	/** * Unapprove one or more threads *
* @param array Thread IDs * @return boolean true	* @param array\|int $tids Thread ID(s) * @return boolean
*/ function unapprove_threads($tids) { global $db, $cache, $plugins; if(!is_array($tids))	*/ function unapprove_threads($tids) { global $db, $cache, $plugins; if(!is_array($tids))
{	{
$tids = array($tids); }	$tids = array($tids); }
Zeile 533	Zeile 551
$forum_counters = $user_counters = $posts_to_unapprove = array();	$forum_counters = $user_counters = $posts_to_unapprove = array();
foreach($tids as $tid)	$tids_list = implode(",", $tids); $query = $db->simple_select("threads", "*", "tid IN ($tids_list)"); while($thread = $db->fetch_array($query))
{	{
$thread = get_thread($tid);
$forum = get_forum($thread['fid']); if($thread['visible'] == 1 \|\| $thread['visible'] == -1)	$forum = get_forum($thread['fid']); if($thread['visible'] == 1 \|\| $thread['visible'] == -1)
Zeile 579	Zeile 599
// On unapproving thread update user post counts if($thread['visible'] == 1 && $forum['usepostcounts'] != 0) {	// On unapproving thread update user post counts if($thread['visible'] == 1 && $forum['usepostcounts'] != 0) {
$query = $db->simple_select("posts", "COUNT(pid) AS posts, uid", "tid='{$tid}' AND (visible='1' OR pid='{$thread['firstpost']}') AND uid > 0 GROUP BY uid"); while($counter = $db->fetch_array($query))	$query2 = $db->simple_select("posts", "COUNT(pid) AS posts, uid", "tid='{$thread['tid']}' AND (visible='1' OR pid='{$thread['firstpost']}') AND uid > 0 GROUP BY uid"); while($counter = $db->fetch_array($query2))
{	{
	if(!isset($user_counters[$counter['uid']])) { $user_counters[$counter['uid']] = array( 'num_posts' => 0, 'num_threads' => 0 ); }
$user_counters[$counter['uid']]['num_posts'] += $counter['posts']; }	$user_counters[$counter['uid']]['num_posts'] += $counter['posts']; }
}	}

if($thread['visible'] == 1 && $forum['usethreadcounts'] != 0)	if($thread['visible'] == 1 && $forum['usethreadcounts'] != 0 && substr($thread['closed'], 0, 6) != 'moved\|')
{ ++$user_counters[$thread['uid']]['num_threads']; } } $posts_to_unapprove[] = $thread['firstpost'];	{ ++$user_counters[$thread['uid']]['num_threads']; } } $posts_to_unapprove[] = $thread['firstpost'];
}	}
$approve = array( "visible" => 0 );	$approve = array( "visible" => 0 );
Zeile 605	Zeile 632
while($redirect_tid = $db->fetch_field($query, 'tid')) { $redirect_tids[] = $redirect_tid;	while($redirect_tid = $db->fetch_field($query, 'tid')) { $redirect_tids[] = $redirect_tid;
}	}
if(!empty($redirect_tids)) { $this->unapprove_threads($redirect_tids);	if(!empty($redirect_tids)) { $this->unapprove_threads($redirect_tids);
Zeile 618	Zeile 645
$plugins->run_hooks("class_moderation_unapprove_threads", $tids); if(!empty($forum_counters))	$plugins->run_hooks("class_moderation_unapprove_threads", $tids); if(!empty($forum_counters))
{	{
foreach($forum_counters as $fid => $counters) { // Update stats	foreach($forum_counters as $fid => $counters) { // Update stats
Zeile 644	Zeile 671
"threadnum" => "-{$counters['num_threads']}", ); update_user_counters($uid, $update_array);	"threadnum" => "-{$counters['num_threads']}", ); update_user_counters($uid, $update_array);
} } return true;	} } return true;
} /** * Delete a specific post *	} /** * Delete a specific post *
* @param int Post ID * @return boolean true	* @param int $pid Post ID * @return boolean
*/ function delete_post($pid) {	*/ function delete_post($pid) {
Zeile 671	Zeile 698
"); $post = $db->fetch_array($query); if(!$post)	"); $post = $db->fetch_array($query); if(!$post)
{	{
return false; } $forum = get_forum($post['fid']); // If post counts enabled in this forum and it hasn't already been unapproved, remove 1 if($forum['usepostcounts'] != 0 && $post['visible'] != -1 && $post['visible'] != 0 && $post['threadvisible'] != 0 && $post['threadvisible'] != -1)	return false; } $forum = get_forum($post['fid']); // If post counts enabled in this forum and it hasn't already been unapproved, remove 1 if($forum['usepostcounts'] != 0 && $post['visible'] != -1 && $post['visible'] != 0 && $post['threadvisible'] != 0 && $post['threadvisible'] != -1)
{	{
update_user_counters($post['uid'], array('postnum' => "-1")); }	update_user_counters($post['uid'], array('postnum' => "-1")); }
Zeile 698	Zeile 725
// Update unapproved post count if($post['visible'] == 0)	// Update unapproved post count if($post['visible'] == 0)
{ $update_array = array( "unapprovedposts" => "-1" );	{ $update_array = array( "unapprovedposts" => "-1" );
} elseif($post['visible'] == -1) {	} elseif($post['visible'] == -1) {
Zeile 728	Zeile 755
"unapprovedposts" => "-1" ); }	"unapprovedposts" => "-1" ); }
elseif($post['visible'] == -1 \|\| $post['threadvisible'] == 0)	elseif($post['visible'] == -1 \|\| $post['threadvisible'] == -1)
{ $update_array = array( "deletedposts" => "-1"	{ $update_array = array( "deletedposts" => "-1"
Zeile 750	Zeile 777
/** * Merge posts within thread *	/** * Merge posts within thread *
* @param array Post IDs to be merged * @param int Thread ID (Set to 0 if posts from multiple threads are * selected)	* @param array $pids Post IDs to be merged * @param int $tid Thread ID (Set to 0 if posts from multiple threads are selected)
* @return int ID of the post into which all other posts are merged */	* @return int ID of the post into which all other posts are merged */
function merge_posts($pids, $tid=0, $sep="new_line")	function merge_posts($pids=array(), $tid=0, $sep="new_line")
{ global $db, $plugins;	{ global $db, $plugins;
Zeile 779	Zeile 805
LEFT JOIN ".TABLE_PREFIX."attachments a ON (a.pid=p.pid AND a.visible=1) WHERE p.pid IN($pidin) GROUP BY p.pid	LEFT JOIN ".TABLE_PREFIX."attachments a ON (a.pid=p.pid AND a.visible=1) WHERE p.pid IN($pidin) GROUP BY p.pid
ORDER BY p.dateline ASC	ORDER BY p.dateline ASC, p.pid ASC
"); $message = ''; $threads = $forum_counters = $thread_counters = $user_counters = array();	"); $message = ''; $threads = $forum_counters = $thread_counters = $user_counters = array();
Zeile 802	Zeile 828
$fid = $post['fid']; $mastertid = $post['tid']; $first = 0;	$fid = $post['fid']; $mastertid = $post['tid']; $first = 0;
	$visible = $post['visible'];
} else {	} else {
Zeile 813	Zeile 840
else { $message .= "[hr]{$post['message']}";	else { $message .= "[hr]{$post['message']}";
}	}
if(!isset($forum_counters[$post['fid']])) { $forum_counters[$post['fid']] = array(	if(!isset($forum_counters[$post['fid']])) { $forum_counters[$post['fid']] = array(
Zeile 828	Zeile 855
{ --$thread_counters[$post['tid']]['replies']; $forum = get_forum($post['fid']);	{ --$thread_counters[$post['tid']]['replies']; $forum = get_forum($post['fid']);
	if(!isset($user_counters[$post['uid']])) { $user_counters[$post['uid']] = array( 'num_posts' => 0, 'num_threads' => 0 ); }
// Subtract 1 from user's post count if($forum['usepostcounts'] != 0 && $post['threadvisible'] == 1) {	// Subtract 1 from user's post count if($forum['usepostcounts'] != 0 && $post['threadvisible'] == 1) {
if(!isset($user_counters[$post['uid']])) { $user_counters[$post['uid']] = 0; }
// Update post count of the user of the merged posts	// Update post count of the user of the merged posts
--$user_counters[$post['uid']];	--$user_counters[$post['uid']]['num_posts']; } if($post['threadfirstpost'] == $post['pid'] && $forum['usethreadcounts'] != 0 && $post['threadvisible'] == 1) { --$user_counters[$post['uid']]['num_threads'];
}	}
	$thread_counters[$post['tid']]['attachmentcount'] -= $post['attachmentcount'];
} elseif($post['visible'] == 0) {	} elseif($post['visible'] == 0) {
Zeile 849	Zeile 884
// Subtract 1 deleted post from post's thread --$thread_counters[$post['tid']]['deletedposts']; }	// Subtract 1 deleted post from post's thread --$thread_counters[$post['tid']]['deletedposts']; }
$thread_counters[$post['tid']]['attachmentcount'] -= $post['attachmentcount'];
// Subtract 1 post from post's forum if($post['threadvisible'] == 1 && $post['visible'] == 1)	// Subtract 1 post from post's forum if($post['threadvisible'] == 1 && $post['visible'] == 1)
Zeile 863	Zeile 897
else { --$forum_counters[$post['fid']]['deletedposts'];	else { --$forum_counters[$post['fid']]['deletedposts'];
	} // Add attachment count to thread if($visible == 1) { $thread_counters[$mastertid]['attachmentcount'] += $post['attachmentcount'];
} } }	} } }
Zeile 870	Zeile 910
// Update the message $mergepost = array( "message" => $db->escape_string($message),	// Update the message $mergepost = array( "message" => $db->escape_string($message),
); $db->update_query("posts", $mergepost, "pid = '{$masterpid}'");	); $db->update_query("posts", $mergepost, "pid = '{$masterpid}'");
// Delete the extra posts $db->delete_query("posts", "pid IN({$pidin}) AND pid != '{$masterpid}'");	// Delete the extra posts $db->delete_query("posts", "pid IN({$pidin}) AND pid != '{$masterpid}'");
Zeile 883	Zeile 923
$db->update_query("attachments", $mergepost2, "pid IN({$pidin})"); // If the first post of a thread is merged out, the first should be updated	$db->update_query("attachments", $mergepost2, "pid IN({$pidin})"); // If the first post of a thread is merged out, the first should be updated
$query = $db->simple_select("threads", "tid, fid, visible", "firstpost IN({$pidin}) AND firstpost != '{$masterpid}'");	$query = $db->simple_select("threads", "tid, uid, fid, visible", "firstpost IN({$pidin}) AND firstpost != '{$masterpid}'");
while($thread = $db->fetch_array($query)) { // In some cases the first post of a thread changes // Therefore resync the visible field to make sure they're the same if they're not	while($thread = $db->fetch_array($query)) { // In some cases the first post of a thread changes // Therefore resync the visible field to make sure they're the same if they're not
$query = $db->simple_select("posts", "pid, visible", "tid='{$thread['tid']}'", array('order_by' => 'dateline', 'order_dir' => 'asc', 'limit' => 1));	$query = $db->simple_select("posts", "pid, uid, visible", "tid='{$thread['tid']}'", array('order_by' => 'dateline, pid', 'limit' => 1));
$new_firstpost = $db->fetch_array($query); if($thread['visible'] != $new_firstpost['visible']) {	$new_firstpost = $db->fetch_array($query); if($thread['visible'] != $new_firstpost['visible']) {
Zeile 907	Zeile 947
--$thread_counters[$thread['tid']]['unapprovedposts']; } if($thread['visible'] == 1)	--$thread_counters[$thread['tid']]['unapprovedposts']; } if($thread['visible'] == 1)
{	{
++$thread_counters[$thread['tid']]['replies']; } elseif($thread['visible'] == -1) { ++$thread_counters[$thread['tid']]['deletedposts'];	++$thread_counters[$thread['tid']]['replies']; } elseif($thread['visible'] == -1) { ++$thread_counters[$thread['tid']]['deletedposts'];
}	}
else	else
{	{
++$thread_counters[$thread['tid']]['unapprovedposts']; }	++$thread_counters[$thread['tid']]['unapprovedposts']; }
	} if($new_firstpost['uid'] != $thread['uid'] && $forum['usethreadcounts'] != 0 && $thread['visible'] == 1) { if(!isset($user_counters[$new_firstpost['uid']])) { $user_counters[$new_firstpost['uid']] = array( 'num_posts' => 0, 'num_threads' => 0 ); } ++$user_counters[$new_firstpost['uid']]['num_threads'];
} update_first_post($thread['tid']); } $arguments = array("pids" => $pids, "tid" => $tid);	} update_first_post($thread['tid']); } $arguments = array("pids" => $pids, "tid" => $tid);
$plugins->run_hooks("class_moderation_merge_posts", $arguments); if(!empty($thread_counters)) {	$plugins->run_hooks("class_moderation_merge_posts", $arguments); if(!empty($thread_counters)) {
foreach($thread_counters as $tid => $counters) { $counters = array(	foreach($thread_counters as $tid => $counters) { $counters = array(
Zeile 951	Zeile 1003
); update_forum_counters($fid, $updated_forum_stats); update_forum_lastpost($fid);	); update_forum_counters($fid, $updated_forum_stats); update_forum_lastpost($fid);
} }	} }
if(!empty($user_counters)) {	if(!empty($user_counters)) {
foreach($user_counters as $uid => $counter)	foreach($user_counters as $uid => $counters)
{	{
update_user_counters($uid, array('postnum' => "{$counter}"));	$update_array = array( "postnum" => "+{$counters['num_posts']}", "threadnum" => "+{$counters['num_threads']}" ); update_user_counters($uid, $update_array);
} }	} }
Zeile 968	Zeile 1024
/** * Move/copy thread *	/** * Move/copy thread *
* @param int Thread to be moved * @param int Destination forum * @param string Method of movement (redirect, copy, move) * @param int Expiry timestamp for redirect	* @param int $tid Thread to be moved * @param int $new_fid Destination forum * @param string $method Method of movement (redirect, copy, move) * @param int $redirect_expire Expiry timestamp for redirect
* @return int Thread ID */ function move_thread($tid, $new_fid, $method="redirect", $redirect_expire=0)	* @return int Thread ID */ function move_thread($tid, $new_fid, $method="redirect", $redirect_expire=0)
Zeile 984	Zeile 1040
$redirect_expire = (int)$redirect_expire; $thread = get_thread($tid, true);	$redirect_expire = (int)$redirect_expire; $thread = get_thread($tid, true);

$newforum = get_forum($new_fid); if(!$thread \|\| !$newforum) { return false;	$newforum = get_forum($new_fid); if(!$thread \|\| !$newforum) { return false;
}	}
$fid = $thread['fid']; $forum = get_forum($fid);	$fid = $thread['fid']; $forum = get_forum($fid);
Zeile 1001	Zeile 1057
$num_posts = $thread['replies']+1; $num_unapproved_posts = $thread['unapprovedposts']; $num_deleted_posts = $thread['deletedposts'];	$num_posts = $thread['replies']+1; $num_unapproved_posts = $thread['unapprovedposts']; $num_deleted_posts = $thread['deletedposts'];
}	}
elseif($thread['visible'] == -1) { $num_deleted_threads++; // Implied forum deleted count for deleted threads $num_deleted_posts = $thread['replies']+$thread['deletedposts']+$thread['unapprovedposts']+1;	elseif($thread['visible'] == -1) { $num_deleted_threads++; // Implied forum deleted count for deleted threads $num_deleted_posts = $thread['replies']+$thread['deletedposts']+$thread['unapprovedposts']+1;
}	}
else { $num_unapproved_threads++;	else { $num_unapproved_threads++;
Zeile 1031	Zeile 1087
); $db->update_query("threads", $changefid, "tid='$tid'"); $db->update_query("posts", $changefid, "tid='$tid'");	); $db->update_query("threads", $changefid, "tid='$tid'"); $db->update_query("posts", $changefid, "tid='$tid'");
// If the thread has a prefix and the destination forum doesn't accept that prefix, remove the prefix if($thread['prefix'] != 0) { switch($db->type) { case "pgsql":	// If the thread has a prefix and the destination forum doesn't accept that prefix, remove the prefix if($thread['prefix'] != 0) { switch($db->type) { case "pgsql":
case "sqlite": $query = $db->simple_select("threadprefixes", "COUNT(*) as num_prefixes", "(','\|\|forums\|\|',' LIKE '%,$new_fid,%' OR forums='-1') AND pid='".$thread['prefix']."'"); break;	case "sqlite": $query = $db->simple_select("threadprefixes", "COUNT(*) as num_prefixes", "(','\|\|forums\|\|',' LIKE '%,$new_fid,%' OR forums='-1') AND pid='".$thread['prefix']."'"); break;
Zeile 1141	Zeile 1197
'question' => $db->escape_string($poll['question']), 'dateline' => $poll['dateline'], 'options' => $db->escape_string($poll['options']),	'question' => $db->escape_string($poll['question']), 'dateline' => $poll['dateline'], 'options' => $db->escape_string($poll['options']),
'votes' => $poll['votes'],	'votes' => $db->escape_string($poll['votes']),
'numoptions' => $poll['numoptions'], 'numvotes' => $poll['numvotes'], 'timeout' => $poll['timeout'],	'numoptions' => $poll['numoptions'], 'numvotes' => $poll['numvotes'], 'timeout' => $poll['timeout'],
Zeile 1201	Zeile 1257
'pid' => $pid, 'uid' => $attachment['uid'], 'filename' => $db->escape_string($attachment['filename']),	'pid' => $pid, 'uid' => $attachment['uid'], 'filename' => $db->escape_string($attachment['filename']),
'filetype' => $attachment['filetype'],	'filetype' => $db->escape_string($attachment['filetype']),
'filesize' => $attachment['filesize'],	'filesize' => $attachment['filesize'],
'attachname' => $attachment['attachname'],	'attachname' => $db->escape_string($attachment['attachname']),
'downloads' => $attachment['downloads'], 'visible' => $attachment['visible'],	'downloads' => $attachment['downloads'], 'visible' => $attachment['visible'],
'thumbnail' => $attachment['thumbnail']	'thumbnail' => $db->escape_string($attachment['thumbnail'])
); $new_aid = $db->insert_query("attachments", $attachment_array);	); $new_aid = $db->insert_query("attachments", $attachment_array);
Zeile 1253	Zeile 1309
); $db->update_query("threads", $sqlarray, "tid='$tid'"); }	); $db->update_query("threads", $sqlarray, "tid='$tid'"); }
}	}
// If we're moving back to a forum where we left a redirect, delete the rediect $query = $db->simple_select("threads", "tid", "closed LIKE 'moved\|".(int)$tid."' AND fid='".(int)$new_fid."'");	// If we're moving back to a forum where we left a redirect, delete the rediect $query = $db->simple_select("threads", "tid", "closed LIKE 'moved\|".(int)$tid."' AND fid='".(int)$new_fid."'");
Zeile 1266	Zeile 1322
// Do post and thread count changes if changing between countable and non-countable forums $query = $db->query("	// Do post and thread count changes if changing between countable and non-countable forums $query = $db->query("
SELECT COUNT(p.pid) AS posts, u.uid, p.visible	SELECT COUNT(p.pid) AS posts, u.uid
FROM ".TABLE_PREFIX."posts p LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=p.uid)	FROM ".TABLE_PREFIX."posts p LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=p.uid)
WHERE tid='$tid' GROUP BY u.uid, p.visible	WHERE p.tid='$tid' AND p.visible=1 GROUP BY u.uid
ORDER BY posts DESC "); while($posters = $db->fetch_array($query)) { $pcount = 0;	ORDER BY posts DESC "); while($posters = $db->fetch_array($query)) { $pcount = 0;
if($forum['usepostcounts'] == 1 && $newforum['usepostcounts'] == 0 && $posters['visible'] == 1 && $thread['visible'] == 1)	if($forum['usepostcounts'] == 1 && $method != 'copy' && $newforum['usepostcounts'] == 0 && $thread['visible'] == 1)
{ $pcount -= $posters['posts']; }	{ $pcount -= $posters['posts']; }
if(($forum['usepostcounts'] == 0 \|\| $method == 'copy') && $newforum['usepostcounts'] == 1 && $posters['visible'] == 1 && $thread['visible'] == 1)	if(($forum['usepostcounts'] == 0 \|\| $method == 'copy') && $newforum['usepostcounts'] == 1 && $thread['visible'] == 1)
{ $pcount += $posters['posts']; }	{ $pcount += $posters['posts']; }
Zeile 1295	Zeile 1351
} }	} }
if($forum['usethreadcounts'] == 1 && $newforum['usethreadcounts'] == 0 && $thread['visible'] == 1)	if($forum['usethreadcounts'] == 1 && $method != 'copy' && $newforum['usethreadcounts'] == 0 && $thread['visible'] == 1)
{ update_user_counters($thread['uid'], array('threadnum' => "-1")); }	{ update_user_counters($thread['uid'], array('threadnum' => "-1")); }
Zeile 1364	Zeile 1420
/** * Merge one thread into another	/** * Merge one thread into another
* * @param int Thread that will be merged into destination * @param int Destination thread * @param string New thread subject * @return boolean true	* * @param int $mergetid Thread that will be merged into destination * @param int $tid Destination thread * @param string $subject New thread subject * @return boolean
*/ function merge_threads($mergetid, $tid, $subject) {	*/ function merge_threads($mergetid, $tid, $subject) {
global $db, $mybb, $mergethread, $thread, $plugins;	global $db, $mybb, $mergethread, $thread, $plugins, $cache;
$mergetid = (int)$mergetid; $tid = (int)$tid;	$mergetid = (int)$mergetid; $tid = (int)$tid;
Zeile 1385	Zeile 1441
{ $thread = get_thread($tid); }	{ $thread = get_thread($tid); }

if(!$mergethread \|\| !$thread)	if(!$mergethread \|\| !$thread)
{	{
return false; }	return false; }
	$forum_cache = $cache->read('forums');
$threadarray = array(); if(!$thread['poll'] && $mergethread['poll'])	$threadarray = array(); if(!$thread['poll'] && $mergethread['poll'])
Zeile 1409	Zeile 1467
$subject = $db->escape_string($subject); $threadarray['subject'] = $subject;	$subject = $db->escape_string($subject); $threadarray['subject'] = $subject;

$user_posts = array();	$user_posts = array();
$query = $db->query("	if($thread['visible'] != $mergethread['visible'] \|\| $forum_cache[$thread['fid']]['usepostcounts'] != $forum_cache[$mergethread['fid']]['usepostcounts']) { $query = $db->query("
SELECT uid, COUNT(pid) AS postnum FROM ".TABLE_PREFIX."posts WHERE tid='{$mergetid}' AND visible=1 GROUP BY uid	SELECT uid, COUNT(pid) AS postnum FROM ".TABLE_PREFIX."posts WHERE tid='{$mergetid}' AND visible=1 GROUP BY uid
"); while($post = $db->fetch_array($query)) { $user_posts[$post['uid']]['postnum'] = $post['postnum']; }	"); while($post = $db->fetch_array($query)) { // Update user counters if($mergethread['visible'] == 1 && $forum_cache[$mergethread['fid']]['usepostcounts'] == 1) { $user_posts[$post['uid']]['postnum'] -= $post['postnum']; } elseif($thread['visible'] == 1 && $forum_cache[$thread['fid']]['usepostcounts'] == 1) { $user_posts[$post['uid']]['postnum'] += $post['postnum']; } } }
$sqlarray = array( "tid" => $tid, "fid" => $thread['fid'],	$sqlarray = array( "tid" => $tid, "fid" => $thread['fid'],
Zeile 1464	Zeile 1533
$update_users = array(); foreach($subscriptions[$mergetid] as $user) {	$update_users = array(); foreach($subscriptions[$mergetid] as $user) {
if(!in_array($user, $subscriptions[$tid]))	if(!isset($subscriptions[$tid]) \|\| !in_array($user, $subscriptions[$tid]))
{ // User doesn't have a $tid subscription $update_users[] = $user;	{ // User doesn't have a $tid subscription $update_users[] = $user;
Zeile 1506	Zeile 1575
// In some cases the thread we may be merging with may cause us to have a new firstpost if it is an older thread // Therefore resync the visible field to make sure they're the same if they're not	// In some cases the thread we may be merging with may cause us to have a new firstpost if it is an older thread // Therefore resync the visible field to make sure they're the same if they're not
$query = $db->simple_select("posts", "pid, uid, visible", "tid='{$tid}'", array('order_by' => 'dateline', 'order_dir' => 'asc', 'limit' => 1));	$query = $db->simple_select("posts", "pid, uid, visible", "tid='{$tid}'", array('order_by' => 'dateline, pid', 'limit' => 1));
$new_firstpost = $db->fetch_array($query); if($thread['visible'] != $new_firstpost['visible']) { $db->update_query("posts", array('visible' => $thread['visible']), "pid='{$new_firstpost['pid']}'");	$new_firstpost = $db->fetch_array($query); if($thread['visible'] != $new_firstpost['visible']) { $db->update_query("posts", array('visible' => $thread['visible']), "pid='{$new_firstpost['pid']}'");
if($new_firstpost['visible'] == 1) {	if($new_firstpost['visible'] == 1 && $forum_cache[$thread['fid']]['usepostcounts'] == 1) {
--$user_posts[$post['uid']]['postnum'];	--$user_posts[$post['uid']]['postnum'];
} elseif($thread['visible'] == 1) {	} elseif($thread['visible'] == 1 && $forum_cache[$thread['fid']]['usepostcounts'] == 1) {
++$user_posts[$post['uid']]['postnum'];	++$user_posts[$post['uid']]['postnum'];
}	} } // Update first post if needed if($new_firstpost['pid'] != $thread['firstpost']) { update_first_post($thread['tid']);
}	}
	// Attach moved posts to the first post $db->update_query("posts", array('replyto' => $new_firstpost['pid']), "tid='{$tid}' AND replyto = 0 AND pid != '{$new_firstpost['pid']}'");
// Update thread count if thread has a new firstpost and is visible	// Update thread count if thread has a new firstpost and is visible
++$user_posts[$mergethread['uid']]['threadnum']; if($thread['uid'] != $new_firstpost['uid'] && $new_firstpost['visible'] == 1)	if($thread['uid'] != $new_firstpost['uid'] && $thread['visible'] == 1 && $forum_cache[$thread['fid']]['usethreadcounts'] == 1)
{	{
	if(!isset($user_posts[$thread['uid']]['threadnum'])) { $user_posts[$thread['uid']]['threadnum'] = 0; } --$user_posts[$thread['uid']]['threadnum']; if(!isset($user_posts[$new_firstpost['uid']]['threadnum'])) { $user_posts[$new_firstpost['uid']]['threadnum'] = 0; }
++$user_posts[$new_firstpost['uid']]['threadnum']; }	++$user_posts[$new_firstpost['uid']]['threadnum']; }
Zeile 1553	Zeile 1638
); } update_forum_counters($thread['fid'], $updated_stats);	); } update_forum_counters($thread['fid'], $updated_stats);
update_forum_lastpost($thread['fid']);
// If old thread is unapproved, implied counter comes in to effect if($mergethread['visible'] == 0)	// If old thread is unapproved, implied counter comes in to effect if($mergethread['visible'] == 0)
Zeile 1575	Zeile 1659
"unapprovedposts" => "-{$mergethread['unapprovedposts']}", "deletedposts" => "-{$mergethread['deletedposts']}" );	"unapprovedposts" => "-{$mergethread['unapprovedposts']}", "deletedposts" => "-{$mergethread['deletedposts']}" );
}	}
update_forum_counters($mergethread['fid'], $updated_stats); update_forum_lastpost($mergethread['fid']); }	update_forum_counters($mergethread['fid'], $updated_stats); update_forum_lastpost($mergethread['fid']); }
Zeile 1594	Zeile 1678
$updated_stats['unapprovedposts'] -= $mergethread['replies']+$mergethread['deletedposts']; $updated_stats['posts'] += $mergethread['replies']; $updated_stats['deletedposts'] += $mergethread['deletedposts'];	$updated_stats['unapprovedposts'] -= $mergethread['replies']+$mergethread['deletedposts']; $updated_stats['posts'] += $mergethread['replies']; $updated_stats['deletedposts'] += $mergethread['deletedposts'];
}	}
elseif($mergethread['visible'] == -1) { $updated_stats['deletedposts'] -= $mergethread['replies']+$mergethread['unapprovedposts']; $updated_stats['posts'] += $mergethread['replies']; $updated_stats['unapprovedposts'] += $mergethread['unapprovedposts'];	elseif($mergethread['visible'] == -1) { $updated_stats['deletedposts'] -= $mergethread['replies']+$mergethread['unapprovedposts']; $updated_stats['posts'] += $mergethread['replies']; $updated_stats['unapprovedposts'] += $mergethread['unapprovedposts'];
}	}
// If new thread is unapproved, implied counter comes in to effect if($thread['visible'] == 0) { $updated_stats['unapprovedposts'] += $mergethread['replies']+$mergethread['deletedposts'];	// If new thread is unapproved, implied counter comes in to effect if($thread['visible'] == 0) { $updated_stats['unapprovedposts'] += $mergethread['replies']+$mergethread['deletedposts'];
$updated_stats['posts'] -= $mergethread['replies'];	$updated_stats['posts'] -= $mergethread['replies'];
$updated_stats['deletedposts'] -= $mergethread['deletedposts']; } elseif($thread['visible'] == -1)	$updated_stats['deletedposts'] -= $mergethread['deletedposts']; } elseif($thread['visible'] == -1)
Zeile 1618	Zeile 1702
$new_stats = array(); if($updated_stats['posts'] < 0)	$new_stats = array(); if($updated_stats['posts'] < 0)
{	{
$new_stats['posts'] = $updated_stats['posts']; } elseif($updated_stats['posts'] > 0) { $new_stats['posts'] = "+{$updated_stats['posts']}";	$new_stats['posts'] = $updated_stats['posts']; } elseif($updated_stats['posts'] > 0) { $new_stats['posts'] = "+{$updated_stats['posts']}";
}	}
if($updated_stats['unapprovedposts'] < 0) { $new_stats['unapprovedposts'] = $updated_stats['unapprovedposts'];	if($updated_stats['unapprovedposts'] < 0) { $new_stats['unapprovedposts'] = $updated_stats['unapprovedposts'];
}	}
elseif($updated_stats['unapprovedposts'] > 0) { $new_stats['unapprovedposts'] = "+{$updated_stats['unapprovedposts']}";	elseif($updated_stats['unapprovedposts'] > 0) { $new_stats['unapprovedposts'] = "+{$updated_stats['unapprovedposts']}";
Zeile 1649	Zeile 1733
update_forum_counters($mergethread['fid'], $new_stats); update_forum_lastpost($mergethread['fid']); }	update_forum_counters($mergethread['fid'], $new_stats); update_forum_lastpost($mergethread['fid']); }
} // If we're in the same forum we need to at least update the last post information else { update_forum_lastpost($thread['fid']);
} if($thread['visible'] != $new_firstpost['visible'])	} if($thread['visible'] != $new_firstpost['visible'])
Zeile 1664	Zeile 1743
--$mergethread['replies']; } elseif($new_firstpost['visible'] == -1)	--$mergethread['replies']; } elseif($new_firstpost['visible'] == -1)
{	{
--$mergethread['deletedposts'];	--$mergethread['deletedposts'];
}	}
else { --$mergethread['unapprovedposts'];	else { --$mergethread['unapprovedposts'];
}	}
if($thread['visible'] == 1)	if($thread['visible'] == 1)
{	{
++$mergethread['replies']; } elseif($thread['visible'] == -1)	++$mergethread['replies']; } elseif($thread['visible'] == -1)
{	{
++$mergethread['deletedposts'];	++$mergethread['deletedposts'];
}	}
else { ++$mergethread['unapprovedposts']; } }	else { ++$mergethread['unapprovedposts']; } }
if($thread['visible'] != $mergethread['visible']) { // Update user counters if($thread['visible'] == 1) { foreach($user_posts as $uid => $user_counter) { update_user_counters($uid, array('postnum' => "+{$user_counter['postnum']}")); } } elseif($mergethread['visible'] == 1) { foreach($user_posts as $uid => $user_counter) { update_user_counters($uid, array('postnum' => "-{$user_counter['postnum']}")); } } } if($mergethread['visible'] == 1) { foreach($user_posts as $uid => $user_counter) { update_user_counters($uid, array('threadnum' => "-{$user_counter['threadnum']}")); } }	// Update user counters foreach($user_posts as $uid => $counters) { $update_array = array( "postnum" => "+{$counters['postnum']}", "threadnum" => "+{$counters['threadnum']}", ); update_user_counters($uid, $update_array); }
$updated_stats = array( "replies" => "+{$mergethread['replies']}", "attachmentcount" => "+{$mergethread['attachmentcount']}", "unapprovedposts" => "+{$mergethread['unapprovedposts']}",	$updated_stats = array( "replies" => "+{$mergethread['replies']}", "attachmentcount" => "+{$mergethread['attachmentcount']}", "unapprovedposts" => "+{$mergethread['unapprovedposts']}",
"deletedposts" => "+{$mergethread['unapprovedposts']}",
"deletedposts" => "+{$mergethread['deletedposts']}" ); update_thread_counters($tid, $updated_stats); update_last_post($tid);	"deletedposts" => "+{$mergethread['deletedposts']}" ); update_thread_counters($tid, $updated_stats); update_last_post($tid);
	// Forum last post has to be updated after thread update_forum_lastpost($thread['fid']);
return true; } /** * Split posts into a new/existing thread *	return true; } /** * Split posts into a new/existing thread *
* @param array PIDs of posts to split * @param int Original thread ID (this is only used as a base for the new	* @param array $pids PIDs of posts to split * @param int $tid Original thread ID (this is only used as a base for the new
* thread; it can be set to 0 when the posts specified are coming from more * than 1 thread)	* thread; it can be set to 0 when the posts specified are coming from more * than 1 thread)
* @param int Destination forum * @param string New thread subject * @param int TID if moving into existing thread * @return int New thread ID	* @param int $moveto Destination forum * @param string $newsubject New thread subject * @param int $destination_tid TID if moving into existing thread * @return int\|bool New thread ID or false on failure
*/ function split_posts($pids, $tid, $moveto, $newsubject, $destination_tid=0) {	*/ function split_posts($pids, $tid, $moveto, $newsubject, $destination_tid=0) {
Zeile 1758	Zeile 1822
} // Get the first split post	} // Get the first split post
$post_info = get_post($pids[0]);	$query = $db->simple_select('posts', 'pid,uid,visible,icon,username,dateline', 'pid IN ('.$pids_list.')', array('order_by' => 'dateline, pid', 'limit' => 1)); $post_info = $db->fetch_array($query);
$visible = $post_info['visible']; $forum_counters[$moveto] = array(	$visible = $post_info['visible']; $forum_counters[$moveto] = array(
Zeile 1769	Zeile 1836
'unapprovedposts' => 0, 'deletedposts' => 0 );	'unapprovedposts' => 0, 'deletedposts' => 0 );
	$user_counters = array();
if($destination_tid == 0) {	if($destination_tid == 0) {
Zeile 1782	Zeile 1851
"uid" => (int)$post_info['uid'], "username" => $db->escape_string($post_info['username']), "dateline" => (int)$post_info['dateline'],	"uid" => (int)$post_info['uid'], "username" => $db->escape_string($post_info['username']), "dateline" => (int)$post_info['dateline'],
	"firstpost" => $post_info['pid'],
"lastpost" => 0, "lastposter" => '', "visible" => (int)$visible,	"lastpost" => 0, "lastposter" => '', "visible" => (int)$visible,
Zeile 1792	Zeile 1862
if($visible == 1) { ++$forum_counters[$moveto]['threads'];	if($visible == 1) { ++$forum_counters[$moveto]['threads'];
	if(!isset($user_counters[$newthread['uid']])) { $user_counters[$newthread['uid']] = array( 'postnum' => 0, 'threadnum' => 0 ); } ++$user_counters[$newthread['uid']]['threadnum'];
} elseif($visible == -1) {	} elseif($visible == -1) {
Zeile 1815	Zeile 1893
// Get selected posts before moving forums to keep old fid $original_posts_query = $db->query("	// Get selected posts before moving forums to keep old fid $original_posts_query = $db->query("
SELECT p.pid, p.tid, p.fid, p.visible, p.uid, t.visible as threadvisible, t.firstpost, COUNT(a.aid) as postattachmentcount	SELECT p.pid, p.tid, p.fid, p.visible, p.uid, p.dateline, t.visible as threadvisible, t.firstpost, COUNT(a.aid) as postattachmentcount
FROM ".TABLE_PREFIX."posts p LEFT JOIN ".TABLE_PREFIX."threads t ON (p.tid=t.tid) LEFT JOIN ".TABLE_PREFIX."attachments a ON (a.pid=p.pid AND a.visible=1)	FROM ".TABLE_PREFIX."posts p LEFT JOIN ".TABLE_PREFIX."threads t ON (p.tid=t.tid) LEFT JOIN ".TABLE_PREFIX."attachments a ON (a.pid=p.pid AND a.visible=1)
Zeile 1856	Zeile 1934
'posts' => 0, 'unapprovedposts' => 0, 'deletedposts' => 0	'posts' => 0, 'unapprovedposts' => 0, 'deletedposts' => 0
	); } if(!isset($user_counters[$post['uid']])) { $user_counters[$post['uid']] = array( 'postnum' => 0, 'threadnum' => 0
); } if($post['visible'] == 1) {	); } if($post['visible'] == 1) {
if(!isset($user_counters[$post['uid']])) { $user_counters[$post['uid']] = array( 'postnum' => 0, 'threadnum' => 0 ); }
// Modify users' post counts if($post['threadvisible'] == 1 && $forum_cache[$post['fid']]['usepostcounts'] == 1 && ($forum_cache[$moveto]['usepostcounts'] == 0 \|\| $newthread['visible'] != 1)) { // Moving into a forum that doesn't count post counts --$user_counters[$post['uid']]['postnum'];	// Modify users' post counts if($post['threadvisible'] == 1 && $forum_cache[$post['fid']]['usepostcounts'] == 1 && ($forum_cache[$moveto]['usepostcounts'] == 0 \|\| $newthread['visible'] != 1)) { // Moving into a forum that doesn't count post counts --$user_counters[$post['uid']]['postnum'];
} elseif($newthread['visible'] == 1 && ($forum_cache[$post['fid']]['usepostcounts'] == 0 \|\| $post['threadvisible'] != 1) && $forum_cache[$moveto]['usepostcounts'] == 1) { // Moving into a forum that does count post counts ++$user_counters[$post['uid']]['postnum']; } // Modify users' thread counts if($post_info['uid'] == $post['uid'] && $forum_cache[$moveto]['usethreadcounts'] == 1 && $newthread['visible'] == 1) { // Moving into a forum that does count thread counts ++$user_counters[$post['uid']]['threadnum'];
} // Subtract 1 from the old thread's replies --$thread_counters[$post['tid']]['replies'];	} // Subtract 1 from the old thread's replies --$thread_counters[$post['tid']]['replies'];
// Add 1 to the new thread's replies ++$thread_counters[$newtid]['replies'];
} elseif($post['visible'] == 0)	} elseif($post['visible'] == 0)
{	{
// Unapproved post // Subtract 1 from the old thread's unapproved posts --$thread_counters[$post['tid']]['unapprovedposts'];	// Unapproved post // Subtract 1 from the old thread's unapproved posts --$thread_counters[$post['tid']]['unapprovedposts'];
// Add 1 to the new thread's unapproved posts ++$thread_counters[$newtid]['unapprovedposts'];
} elseif($post['visible'] == -1) { // Soft deleted post // Subtract 1 from the old thread's deleted posts --$thread_counters[$post['tid']]['deletedposts'];	} elseif($post['visible'] == -1) { // Soft deleted post // Subtract 1 from the old thread's deleted posts --$thread_counters[$post['tid']]['deletedposts'];
// Add 1 to the new thread's deleted posts ++$thread_counters[$newtid]['deletedposts']; }	}
// Subtract 1 from the old forum's posts if($post['threadvisible'] == 1 && $post['visible'] == 1)	// Subtract 1 from the old forum's posts if($post['threadvisible'] == 1 && $post['visible'] == 1)
{	{
--$forum_counters[$post['fid']]['posts']; } elseif($post['threadvisible'] == 0 \|\| ($post['visible'] == 0 && $post['threadvisible'] == 1))	--$forum_counters[$post['fid']]['posts']; } elseif($post['threadvisible'] == 0 \|\| ($post['visible'] == 0 && $post['threadvisible'] == 1))
Zeile 1924	Zeile 1980
else { --$forum_counters[$post['fid']]['deletedposts'];	else { --$forum_counters[$post['fid']]['deletedposts'];
} // Add 1 to the new forum's posts if($newthread['visible'] == 1 && $post['visible'] == 1) { ++$forum_counters[$moveto]['posts']; } elseif($newthread['visible'] == 0 \|\| ($post['visible'] == 0 && $newthread['visible'] == 1)) { ++$forum_counters[$moveto]['unapprovedposts']; } else { ++$forum_counters[$moveto]['deletedposts'];
} // Subtract attachment counts from old thread and add to new thread (which are counted regardless of post or attachment unapproval at time of coding)	} // Subtract attachment counts from old thread and add to new thread (which are counted regardless of post or attachment unapproval at time of coding)
Zeile 1948	Zeile 1990
{ // In some cases the first post of a thread changes // Therefore resync the visible field to make sure they're the same if they're not	{ // In some cases the first post of a thread changes // Therefore resync the visible field to make sure they're the same if they're not
$query = $db->simple_select("posts", "pid, visible", "tid='{$post['tid']}'", array('order_by' => 'dateline', 'order_dir' => 'asc', 'limit' => 1));	$query = $db->simple_select("posts", "pid, visible, uid", "tid='{$post['tid']}'", array('order_by' => 'dateline, pid', 'limit' => 1));
$new_firstpost = $db->fetch_array($query);	$new_firstpost = $db->fetch_array($query);
	if(!isset($user_counters[$new_firstpost['uid']])) { $user_counters[$new_firstpost['uid']] = array( 'postnum' => 0, 'threadnum' => 0 ); } // Update post counters if visibility changes
if($post['threadvisible'] != $new_firstpost['visible']) { $db->update_query("posts", array('visible' => $post['threadvisible']), "pid='{$new_firstpost['pid']}'");	if($post['threadvisible'] != $new_firstpost['visible']) { $db->update_query("posts", array('visible' => $post['threadvisible']), "pid='{$new_firstpost['pid']}'");
// Correct counters	// Subtract new first post
if($new_firstpost['visible'] == 1) { --$thread_counters[$post['tid']]['replies'];	if($new_firstpost['visible'] == 1) { --$thread_counters[$post['tid']]['replies'];
	if($post['threadvisible'] == 1 && $forum_cache[$post['fid']]['usepostcounts'] == 1) { --$user_counters[$new_firstpost['uid']]['postnum']; }
} elseif($new_firstpost['visible'] == -1) {	} elseif($new_firstpost['visible'] == -1) {
Zeile 1966	Zeile 2022
{ --$thread_counters[$post['tid']]['unapprovedposts']; }	{ --$thread_counters[$post['tid']]['unapprovedposts']; }
	if($post['threadvisible'] == 0 \|\| ($new_firstpost['visible'] == 0 && $post['threadvisible'] == 1)) { --$forum_counters[$post['fid']]['unapprovedposts']; } else { --$forum_counters[$post['fid']]['deletedposts']; } // Add old first post
if($post['threadvisible'] == 1) { ++$thread_counters[$post['tid']]['replies'];	if($post['threadvisible'] == 1) { ++$thread_counters[$post['tid']]['replies'];
	++$forum_counters[$post['fid']]['posts']; if($forum_cache[$post['fid']]['usepostcounts'] == 1) { ++$user_counters[$new_firstpost['uid']]['postnum']; }
} elseif($post['threadvisible'] == -1)	} elseif($post['threadvisible'] == -1)
{	{
++$thread_counters[$post['tid']]['deletedposts'];	++$thread_counters[$post['tid']]['deletedposts'];
	++$forum_counters[$post['fid']]['deletedposts'];
} else { ++$thread_counters[$post['tid']]['unapprovedposts'];	} else { ++$thread_counters[$post['tid']]['unapprovedposts'];
	++$forum_counters[$post['fid']]['unapprovedposts'];
}	}
	} // Update user thread counter if thread opener changes if($post['threadvisible'] == 1 && $forum_cache[$post['fid']]['usethreadcounts'] == 1 && $post['uid'] != $new_firstpost['uid']) { // Subtract thread from old thread opener --$user_counters[$post['uid']]['threadnum']; // Add thread to new thread opener ++$user_counters[$new_firstpost['uid']]['threadnum'];
} update_first_post($post['tid']);	} update_first_post($post['tid']);
	} // This is the new first post of an existing thread? if($post['pid'] == $post_info['pid'] && $post['dateline'] < $newthread['dateline']) { // Update post counters if visibility changes if($post['visible'] != $newthread['visible']) { $db->update_query("posts", array('visible' => $newthread['visible']), "pid='{$post['pid']}'"); // This is needed to update the forum counters correctly $post['visible'] = $newthread['visible']; } // Update user thread counter if thread opener changes if($newthread['visible'] == 1 && $forum_cache[$newthread['fid']]['usethreadcounts'] == 1 && $post['uid'] != $newthread['uid']) { // Add thread to new thread opener ++$user_counters[$post['uid']]['threadnum']; if(!isset($user_counters[$newthread['uid']])) { $user_counters[$newthread['uid']] = array( 'postnum' => 0, 'threadnum' => 0 ); } // Subtract thread from old thread opener --$user_counters[$newthread['uid']]['threadnum']; } update_first_post($newtid); } if($post['visible'] == 1) { // Modify users' post counts if($newthread['visible'] == 1 && ($forum_cache[$post['fid']]['usepostcounts'] == 0 \|\| $post['threadvisible'] != 1) && $forum_cache[$moveto]['usepostcounts'] == 1) { // Moving into a forum that does count post counts ++$user_counters[$post['uid']]['postnum']; } // Add 1 to the new thread's replies ++$thread_counters[$newtid]['replies']; } elseif($post['visible'] == 0) { // Unapproved post // Add 1 to the new thread's unapproved posts ++$thread_counters[$newtid]['unapprovedposts']; } elseif($post['visible'] == -1) { // Soft deleted post // Add 1 to the new thread's deleted posts ++$thread_counters[$newtid]['deletedposts']; } // Add 1 to the new forum's posts if($newthread['visible'] == 1 && $post['visible'] == 1) { ++$forum_counters[$moveto]['posts']; } elseif($newthread['visible'] == 0 \|\| ($post['visible'] == 0 && $newthread['visible'] == 1)) { ++$forum_counters[$moveto]['unapprovedposts']; } else { ++$forum_counters[$moveto]['deletedposts'];
} }	} }
	// Attach moved posts to the first post $db->update_query("posts", array('replyto' => $post_info['pid']), "tid='{$newtid}' AND replyto = 0 AND pid != '{$post_info['pid']}'");
if($destination_tid == 0 && $newthread['visible'] == 1) { // If splitting into a new thread, subtract one from the thread's reply count to compensate for the original post	if($destination_tid == 0 && $newthread['visible'] == 1) { // If splitting into a new thread, subtract one from the thread's reply count to compensate for the original post
Zeile 2002	Zeile 2157
$plugins->run_hooks("class_moderation_split_posts", $arguments); // Update user post counts	$plugins->run_hooks("class_moderation_split_posts", $arguments); // Update user post counts
if(!empty($user_counters)) { foreach($user_counters as $uid => $counters) { foreach($counters as $key => $counter) { if($counter >= 0)	if(!empty($user_counters)) { foreach($user_counters as $uid => $counters) { foreach($counters as $key => $counter) { if($counter >= 0)
{ $counters[$key] = "+{$counter}"; // add the addition operator for query }	{ $counters[$key] = "+{$counter}"; // add the addition operator for query }
Zeile 2025	Zeile 2180
if($tid == $newtid) { // Update the subject of the first post in the new thread	if($tid == $newtid) { // Update the subject of the first post in the new thread
$query = $db->simple_select("posts", "pid", "tid='$newtid'", array('order_by' => 'dateline', 'limit' => 1));	$query = $db->simple_select("posts", "pid", "tid='$newtid'", array('order_by' => 'dateline, pid', 'limit' => 1));
$newthread = $db->fetch_array($query); $sqlarray = array( "subject" => $newsubject,	$newthread = $db->fetch_array($query); $sqlarray = array( "subject" => $newsubject,
Zeile 2041	Zeile 2196
FROM ".TABLE_PREFIX."posts p LEFT JOIN ".TABLE_PREFIX."threads t ON (p.tid=t.tid) WHERE p.tid='{$tid}'	FROM ".TABLE_PREFIX."posts p LEFT JOIN ".TABLE_PREFIX."threads t ON (p.tid=t.tid) WHERE p.tid='{$tid}'
ORDER BY p.dateline ASC	ORDER BY p.dateline ASC, p.pid ASC
LIMIT 1 "); $oldthread = $db->fetch_array($query);	LIMIT 1 "); $oldthread = $db->fetch_array($query);
Zeile 2051	Zeile 2206
); $db->update_query("posts", $sqlarray, "pid='{$oldthread['pid']}'"); }	); $db->update_query("posts", $sqlarray, "pid='{$oldthread['pid']}'"); }
foreach($counters as $key => $counter) { if($counter >= 0) { $counters[$key] = "+{$counter}"; } }	foreach($counters as $key => $counter) { if($counter >= 0) { $counters[$key] = "+{$counter}"; } }
update_thread_counters($tid, $counters); update_last_post($tid); }	update_thread_counters($tid, $counters); update_last_post($tid); }
Zeile 2087	Zeile 2242
/** * Move multiple threads to new forum *	/** * Move multiple threads to new forum *
* @param array Thread IDs * @param int Destination forum * @return boolean true	* @param array $tids Thread IDs * @param int $moveto Destination forum * @return boolean * * @deprecated Iterate over move_thread instead
*/ function move_threads($tids, $moveto) {	*/ function move_threads($tids, $moveto) {
Zeile 2101	Zeile 2258
$tid_list = implode(',', $tids); $moveto = (int)$moveto;	$tid_list = implode(',', $tids); $moveto = (int)$moveto;

$newforum = get_forum($moveto);	$newforum = get_forum($moveto);

if(empty($tids) \|\| !$newforum) { return false;	if(empty($tids) \|\| !$newforum) { return false;
}	}
$total_posts = $total_unapproved_posts = $total_deleted_posts = $total_threads = $total_unapproved_threads = $total_deleted_threads = 0; $forum_counters = $user_counters = array();	$total_posts = $total_unapproved_posts = $total_deleted_posts = $total_threads = $total_unapproved_threads = $total_deleted_threads = 0; $forum_counters = $user_counters = array();
Zeile 2115	Zeile 2272
while($thread = $db->fetch_array($query)) { $forum = get_forum($thread['fid']);	while($thread = $db->fetch_array($query)) { $forum = get_forum($thread['fid']);

if(!isset($forum_counters[$thread['fid']])) { $forum_counters[$thread['fid']] = array(	if(!isset($forum_counters[$thread['fid']])) { $forum_counters[$thread['fid']] = array(
Zeile 2128	Zeile 2285
); }	); }
if(!isset($user_counters[$thread['uid']]['num_threads']))	if(!isset($user_counters[$thread['uid']]))
{	{
$user_counters[$thread['uid']]['num_threads'] = 0;	$user_counters[$thread['uid']] = array( 'num_posts' => 0, 'num_threads' => 0 );
} if($thread['visible'] == 1)	} if($thread['visible'] == 1)
Zeile 2155	Zeile 2315
} $query1 = $db->query("	} $query1 = $db->query("
SELECT COUNT(p.pid) AS posts, p.visible, u.uid	SELECT COUNT(p.pid) AS posts, u.uid
FROM ".TABLE_PREFIX."posts p LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=p.uid)	FROM ".TABLE_PREFIX."posts p LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=p.uid)
WHERE p.tid = '{$thread['tid']}' GROUP BY p.visible, u.uid	WHERE p.tid = '{$thread['tid']}' AND p.visible=1 GROUP BY u.uid
ORDER BY posts DESC "); while($posters = $db->fetch_array($query1)) {	ORDER BY posts DESC "); while($posters = $db->fetch_array($query1)) {
if(!isset($user_counters[$posters['uid']]['num_posts']))	if(!isset($user_counters[$posters['uid']]))
{	{
$user_counters[$posters['uid']]['num_posts'] = 0;	$user_counters[$posters['uid']] = array( 'num_posts' => 0, 'num_threads' => 0 );
}	}
if($newforum['usepostcounts'] != 0 && $forum['usepostcounts'] == 0 && $posters['visible'] == 1)	if($newforum['usepostcounts'] != 0 && $forum['usepostcounts'] == 0)
{ $user_counters[$posters['uid']]['num_posts'] += $posters['posts']; }	{ $user_counters[$posters['uid']]['num_posts'] += $posters['posts']; }
else if($newforum['usepostcounts'] == 0 && $forum['usepostcounts'] != 0 && $posters['visible'] == 1)	else if($newforum['usepostcounts'] == 0 && $forum['usepostcounts'] != 0)
{ $user_counters[$posters['uid']]['num_posts'] -= $posters['posts']; }	{ $user_counters[$posters['uid']]['num_posts'] -= $posters['posts']; }
Zeile 2211	Zeile 2374
); $db->update_query("threads", $sqlarray, "tid IN ($tid_list)"); $db->update_query("posts", $sqlarray, "tid IN ($tid_list)");	); $db->update_query("threads", $sqlarray, "tid IN ($tid_list)"); $db->update_query("posts", $sqlarray, "tid IN ($tid_list)");

// If any of the thread has a prefix and the destination forum doesn't accept that prefix, remove the prefix $query = $db->simple_select("threads", "tid, prefix", "tid IN ($tid_list) AND prefix != 0"); while($thread = $db->fetch_array($query)) { switch($db->type)	// If any of the thread has a prefix and the destination forum doesn't accept that prefix, remove the prefix $query = $db->simple_select("threads", "tid, prefix", "tid IN ($tid_list) AND prefix != 0"); while($thread = $db->fetch_array($query)) { switch($db->type)
{	{
case "pgsql": case "sqlite": $query = $db->simple_select("threadprefixes", "COUNT(*) as num_prefixes", "(','\|\|forums\|\|',' LIKE '%,$moveto,%' OR forums='-1') AND pid='".$thread['prefix']."'");	case "pgsql": case "sqlite": $query = $db->simple_select("threadprefixes", "COUNT(*) as num_prefixes", "(','\|\|forums\|\|',' LIKE '%,$moveto,%' OR forums='-1') AND pid='".$thread['prefix']."'");
Zeile 2229	Zeile 2392
{ $sqlarray = array( "prefix" => 0,	{ $sqlarray = array( "prefix" => 0,
);	);
$db->update_query("threads", $sqlarray, "tid = '{$thread['tid']}'"); } } $arguments = array("tids" => $tids, "moveto" => $moveto); $plugins->run_hooks("class_moderation_move_threads", $arguments);	$db->update_query("threads", $sqlarray, "tid = '{$thread['tid']}'"); } } $arguments = array("tids" => $tids, "moveto" => $moveto); $plugins->run_hooks("class_moderation_move_threads", $arguments);

if(!empty($user_counters)) { foreach($user_counters as $uid => $counters)	if(!empty($user_counters)) { foreach($user_counters as $uid => $counters)
Zeile 2248	Zeile 2411
update_user_counters($uid, $update_array); } }	update_user_counters($uid, $update_array); } }

if(is_array($forum_counters)) { foreach($forum_counters as $fid => $counter)	if(is_array($forum_counters)) { foreach($forum_counters as $fid => $counter)
Zeile 2260	Zeile 2423
'unapprovedthreads' => "-{$counter['unapprovedthreads']}", 'deletedposts' => "-{$counter['deletedposts']}", 'deletedthreads' => "-{$counter['deletedthreads']}"	'unapprovedthreads' => "-{$counter['unapprovedthreads']}", 'deletedposts' => "-{$counter['deletedposts']}", 'deletedthreads' => "-{$counter['deletedthreads']}"

); update_forum_counters($fid, $updated_count); update_forum_lastpost($fid);	); update_forum_counters($fid, $updated_count); update_forum_lastpost($fid);
Zeile 2288	Zeile 2451
/** * Approve multiple posts *	/** * Approve multiple posts *
* @param array PIDs * @return boolean true	* @param array $pids PIDs * @return boolean
*/ function approve_posts($pids) { global $db, $cache, $plugins;	*/ function approve_posts($pids) { global $db, $cache, $plugins;

$num_posts = 0; if(empty($pids))	$num_posts = 0; if(empty($pids))
Zeile 2304	Zeile 2467
// Make sure we only have valid values $pids = array_map('intval', $pids);	// Make sure we only have valid values $pids = array_map('intval', $pids);

$pid_list = implode(',', $pids); $pids = $threads_to_update = array();	$pid_list = implode(',', $pids); $pids = $threads_to_update = array();
Zeile 2328	Zeile 2491
while($post = $db->fetch_array($query)) { // This is the first post in the thread so we're approving the whole thread.	while($post = $db->fetch_array($query)) { // This is the first post in the thread so we're approving the whole thread.
$threads_to_update[] = $post['tid']; } if(!empty($threads_to_update)) { $this->approve_threads($threads_to_update);	$threads_to_update[] = $post['tid']; } if(!empty($threads_to_update)) { $this->approve_threads($threads_to_update);
} $thread_counters = $forum_counters = $user_counters = array();	} $thread_counters = $forum_counters = $user_counters = array();
Zeile 2353	Zeile 2516
$thread_counters[$post['tid']] = array( 'replies' => 0 );	$thread_counters[$post['tid']] = array( 'replies' => 0 );
} ++$thread_counters[$post['tid']]['replies'];	} ++$thread_counters[$post['tid']]['replies'];
// If the thread of this post is unapproved then we've already taken into account this counter as implied. // Updating it again would cause it to double count	// If the thread of this post is unapproved then we've already taken into account this counter as implied. // Updating it again would cause it to double count
if($post['threadvisible'] != 0)	if($post['threadvisible'] == 1)
{ if(!isset($forum_counters[$post['fid']])) {	{ if(!isset($forum_counters[$post['fid']])) {
Zeile 2374	Zeile 2537
// If post counts enabled in this forum and the thread is approved, add 1 if($forum['usepostcounts'] != 0 && $post['threadvisible'] == 1)	// If post counts enabled in this forum and the thread is approved, add 1 if($forum['usepostcounts'] != 0 && $post['threadvisible'] == 1)
{ if(!isset($user_counters[$post['uid']])) { $user_counters[$post['uid']] = 0;	{ if(!isset($user_counters[$post['uid']])) { $user_counters[$post['uid']] = 0;
} ++$user_counters[$post['uid']]; } } if(empty($pids) && empty($threads_to_update))	} ++$user_counters[$post['uid']]; } } if(empty($pids) && empty($threads_to_update))
{	{
return false; } if(!empty($pids))	return false; } if(!empty($pids))
{	{
$where = "pid IN (".implode(',', $pids).")"; $db->update_query("posts", $approve, $where);	$where = "pid IN (".implode(',', $pids).")"; $db->update_query("posts", $approve, $where);
} $plugins->run_hooks("class_moderation_approve_posts", $pids);	} $plugins->run_hooks("class_moderation_approve_posts", $pids);
if(!empty($thread_counters)) {	if(!empty($thread_counters)) {
Zeile 2416	Zeile 2579
$updated_forum_stats = array( 'posts' => "+{$counters['num_posts']}", 'unapprovedposts' => "-{$counters['num_posts']}",	$updated_forum_stats = array( 'posts' => "+{$counters['num_posts']}", 'unapprovedposts' => "-{$counters['num_posts']}",
); update_forum_counters($fid, $updated_forum_stats); update_forum_lastpost($fid); } } if(!empty($user_counters))	); update_forum_counters($fid, $updated_forum_stats); update_forum_lastpost($fid); } } if(!empty($user_counters))
{ foreach($user_counters as $uid => $counter) { update_user_counters($uid, array('postnum' => "+{$counter}")); } }	{ foreach($user_counters as $uid => $counter) { update_user_counters($uid, array('postnum' => "+{$counter}")); } }

return true; } /** * Unapprove multiple posts *	return true; } /** * Unapprove multiple posts *
* @param array PIDs * @return boolean true	* @param array $pids PIDs * @return boolean
*/ function unapprove_posts($pids) {	*/ function unapprove_posts($pids) {
Zeile 2512	Zeile 2675
else { ++$thread_counters[$post['tid']]['deletedposts'];	else { ++$thread_counters[$post['tid']]['deletedposts'];
}	}
if(!isset($forum_counters[$post['fid']])) {	if(!isset($forum_counters[$post['fid']])) {
Zeile 2599	Zeile 2762
{ update_user_counters($uid, array('postnum' => "{$counter}")); }	{ update_user_counters($uid, array('postnum' => "{$counter}")); }
} return true;	} return true;
} /** * Change thread subject	} /** * Change thread subject
* * @param mixed Thread ID(s) * @param string Format of new subject (with {subject}) * @return boolean true	* * @param int\|array $tids Thread ID(s) * @param string $format Format of new subject (with {subject}) * @return boolean
*/ function change_thread_subject($tids, $format) { global $db, $mybb, $plugins;	*/ function change_thread_subject($tids, $format) { global $db, $mybb, $plugins;

// Get tids into list if(!is_array($tids)) { $tids = array($tids);	// Get tids into list if(!is_array($tids)) { $tids = array($tids);
}	}
// Make sure we only have valid values $tids = array_map('intval', $tids); if(empty($tids))	// Make sure we only have valid values $tids = array_map('intval', $tids); if(empty($tids))
{	{
return false; } $tid_list = implode(',', $tids); // Get original subject	return false; } $tid_list = implode(',', $tids); // Get original subject
$query = $db->simple_select("threads", "subject, tid", "tid IN ($tid_list)");	$query = $db->query(" SELECT u.uid, u.username, t.tid, t.subject FROM ".TABLE_PREFIX."threads t LEFT JOIN ".TABLE_PREFIX."users u ON t.uid=u.uid WHERE tid IN ($tid_list) ");
while($thread = $db->fetch_array($query)) { // Update threads and first posts with new subject	while($thread = $db->fetch_array($query)) { // Update threads and first posts with new subject
$subject = str_replace('{username}', $mybb->user['username'], $format); $subject = str_replace('{subject}', $thread['subject'], $subject); $new_subject = array( "subject" => $db->escape_string($subject)	$find = array('{username}', 'author', '{subject}'); $replace = array($mybb->user['username'], $thread['username'], $thread['subject']); $new_subject = str_ireplace($find, $replace, $format); $args = array( 'thread' => &$thread, 'new_subject' => &$new_subject, ); $plugins->run_hooks("class_moderation_change_thread_subject_newsubject", $args); $update_subject = array( "subject" => $db->escape_string($new_subject)
);	);
$db->update_query("threads", $new_subject, "tid='{$thread['tid']}'"); $db->update_query("posts", $new_subject, "tid='{$thread['tid']}' AND replyto='0'");	$db->update_query("threads", $update_subject, "tid='{$thread['tid']}'"); $db->update_query("posts", $update_subject, "tid='{$thread['tid']}' AND replyto='0'");
} $arguments = array("tids" => $tids, "format" => $format);	} $arguments = array("tids" => $tids, "format" => $format);
Zeile 2654	Zeile 2831
/** * Add thread expiry *	/** * Add thread expiry *
* @param int Thread ID * @param int Timestamp when the thread is deleted * @return boolean true	* @param int $tid Thread ID * @param int $deletetime Timestamp when the thread is deleted * @return boolean
*/ function expire_thread($tid, $deletetime) {	*/ function expire_thread($tid, $deletetime) {
Zeile 2683	Zeile 2860
/** * Toggle post visibility (approved/unapproved) *	/** * Toggle post visibility (approved/unapproved) *
* @param array Post IDs	* @param array $pids Post IDs
* @return boolean true */ function toggle_post_visibility($pids)	* @return boolean true */ function toggle_post_visibility($pids)
Zeile 2720	Zeile 2897
/** * Toggle post visibility (deleted/restored) *	/** * Toggle post visibility (deleted/restored) *
* @param array Post IDs	* @param array $pids Post IDs
* @return boolean true */ function toggle_post_softdelete($pids)	* @return boolean true */ function toggle_post_softdelete($pids)
Zeile 2757	Zeile 2934
/** * Toggle thread visibility (approved/unapproved) *	/** * Toggle thread visibility (approved/unapproved) *
* @param array Thread IDs * @param int Forum ID	* @param array $tids Thread IDs * @param int $fid Forum ID
* @return boolean true */ function toggle_thread_visibility($tids, $fid)	* @return boolean true */ function toggle_thread_visibility($tids, $fid)
Zeile 2796	Zeile 2973
/** * Toggle thread visibility (deleted/restored) *	/** * Toggle thread visibility (deleted/restored) *
* @param array Thread IDs * @param int Forum ID	* @param array $tids Thread IDs
* @return boolean true */	* @return boolean true */
function toggle_thread_softdelete($tids, $fid)	function toggle_thread_softdelete($tids)
{ global $db; // Make sure we only have valid values $tids = array_map('intval', $tids);	{ global $db; // Make sure we only have valid values $tids = array_map('intval', $tids);
$fid = (int)$fid;
$tid_list = implode(',', $tids); $query = $db->simple_select("threads", 'tid, visible', "tid IN ($tid_list)");	$tid_list = implode(',', $tids); $query = $db->simple_select("threads", 'tid, visible', "tid IN ($tid_list)");
Zeile 2823	Zeile 2998
} if(is_array($delete)) {	} if(is_array($delete)) {
$this->soft_delete_threads($delete, $fid);	$this->soft_delete_threads($delete);
} if(is_array($restore)) {	} if(is_array($restore)) {
$this->restore_threads($restore, $fid);	$this->restore_threads($restore);
} return true; }	} return true; }
Zeile 2835	Zeile 3010
/** * Toggle threads open/closed *	/** * Toggle threads open/closed *
* @param array Thread IDs	* @param array $tids Thread IDs
* @return boolean true */ function toggle_thread_status($tids)	* @return boolean true */ function toggle_thread_status($tids)
Zeile 2872	Zeile 3047
/** * Toggle threads stick/unstick *	/** * Toggle threads stick/unstick *
* @param array Thread IDs	* @param array $tids Thread IDs
* @return boolean true */ function toggle_thread_importance($tids)	* @return boolean true */ function toggle_thread_importance($tids)
Zeile 2890	Zeile 3065
while($thread = $db->fetch_array($query)) { if($thread['sticky'] == 0)	while($thread = $db->fetch_array($query)) { if($thread['sticky'] == 0)
{	{
$stick[] = $thread['tid']; } elseif($thread['sticky'] == 1)	$stick[] = $thread['tid']; } elseif($thread['sticky'] == 1)
Zeile 2903	Zeile 3078
$this->stick_threads($stick); } if(!empty($unstick))	$this->stick_threads($stick); } if(!empty($unstick))
{	{
$this->unstick_threads($unstick); } return true;	$this->unstick_threads($unstick); } return true;
Zeile 2912	Zeile 3087
/** * Remove thread subscriptions (from one or multiple threads in the same forum) *	/** * Remove thread subscriptions (from one or multiple threads in the same forum) *
* @param int $tids Thread ID, or an array of thread IDs from the same forum.	* @param int\|array $tids Thread ID, or an array of thread IDs from the same forum.
* @param boolean $all True (default) to delete all subscriptions, false to only delete subscriptions from users with no permission to read the thread * @param int $fid (Only applies if $all is false) The forum ID of the thread	* @param boolean $all True (default) to delete all subscriptions, false to only delete subscriptions from users with no permission to read the thread * @param int $fid (Only applies if $all is false) The forum ID of the thread
* @return boolean true	* @return boolean
*/ function remove_thread_subscriptions($tids, $all = true, $fid = 0)	*/ function remove_thread_subscriptions($tids, $all = true, $fid = 0)
{ global $db, $plugins; // Format thread IDs if(!is_array($tids)) { $tids = array($tids); } if(empty($tids)) { return false; } // Make sure we only have valid values	{ global $db, $plugins; // Format thread IDs if(!is_array($tids)) { $tids = array($tids); } if(empty($tids)) { return false; } // Make sure we only have valid values
$tids = array_map('intval', $tids); $fid = (int)$fid;	$tids = array_map('intval', $tids); $fid = (int)$fid;
Zeile 2945	Zeile 3120
$forum_parentlist = get_parent_list($fid); $query = $db->simple_select("forumpermissions", "gid", "fid IN ({$forum_parentlist}) AND (canview=0 OR canviewthreads=0)"); $groups = array();	$forum_parentlist = get_parent_list($fid); $query = $db->simple_select("forumpermissions", "gid", "fid IN ({$forum_parentlist}) AND (canview=0 OR canviewthreads=0)"); $groups = array();
	$additional_groups = '';
while($group = $db->fetch_array($query)) { $groups[] = $group['gid'];	while($group = $db->fetch_array($query)) { $groups[] = $group['gid'];
Zeile 2972	Zeile 3148
while($subscription = $db->fetch_array($query)) { $db->delete_query("threadsubscriptions", "uid='{$subscription['uid']}' AND tid='{$subscription['tid']}'");	while($subscription = $db->fetch_array($query)) { $db->delete_query("threadsubscriptions", "uid='{$subscription['uid']}' AND tid='{$subscription['tid']}'");
}	}
} } // Delete all subscriptions of this thread	} } // Delete all subscriptions of this thread
Zeile 2990	Zeile 3166
/** * Apply a thread prefix (to one or multiple threads in the same forum) *	/** * Apply a thread prefix (to one or multiple threads in the same forum) *
* @param int $tids Thread ID, or an array of thread IDs from the same forum.	* @param int\|array $tids Thread ID, or an array of thread IDs from the same forum.
* @param int $prefix Prefix ID to apply to the threads	* @param int $prefix Prefix ID to apply to the threads
	* @return bool
*/ function apply_thread_prefix($tids, $prefix = 0) {	*/ function apply_thread_prefix($tids, $prefix = 0) {
Zeile 3025	Zeile 3202
/** * Soft delete multiple posts *	/** * Soft delete multiple posts *
* @param array PIDs * @return boolean true	* @param array $pids PIDs * @return boolean
*/ function soft_delete_posts($pids) {	*/ function soft_delete_posts($pids) {
Zeile 3036	Zeile 3213
{ return false; }	{ return false; }

// Make sure we only have valid values $pids = array_map('intval', $pids);	// Make sure we only have valid values $pids = array_map('intval', $pids);
Zeile 3055	Zeile 3232
// 1.3) if the thread is deleted // 2) We're deleting the firstpost of the thread, therefore deleting the thread itself // 3) We're doing both 1 and 2	// 1.3) if the thread is deleted // 2) We're deleting the firstpost of the thread, therefore deleting the thread itself // 3) We're doing both 1 and 2
$query = $db->query("	$query = $db->query("
SELECT p.tid FROM ".TABLE_PREFIX."posts p LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=p.tid)	SELECT p.tid FROM ".TABLE_PREFIX."posts p LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=p.tid)
Zeile 3136	Zeile 3313
$user_counters[$post['uid']] = 0; } --$user_counters[$post['uid']];	$user_counters[$post['uid']] = 0; } --$user_counters[$post['uid']];
} } if(empty($pids) && empty($threads_to_update)) { return false; } if(!empty($pids)) { $where = "pid IN (".implode(',', $pids).")"; $db->update_query("posts", $update, $where); } $plugins->run_hooks("class_moderation_soft_delete_posts", $pids);	} } if(empty($pids) && empty($threads_to_update)) { return false; } if(!empty($pids)) { $where = "pid IN (".implode(',', $pids).")"; $db->update_query("posts", $update, $where); mark_reports($pids, "posts"); } $plugins->run_hooks("class_moderation_soft_delete_posts", $pids);
if(is_array($thread_counters)) { foreach($thread_counters as $tid => $counters)	if(is_array($thread_counters)) { foreach($thread_counters as $tid => $counters)
Zeile 3164	Zeile 3342
update_thread_counters($tid, $counters_update); update_last_post($tid);	update_thread_counters($tid, $counters_update); update_last_post($tid);
} }	} }
if(is_array($forum_counters)) {	if(is_array($forum_counters)) {
Zeile 3178	Zeile 3356
); update_forum_counters($fid, $updated_forum_stats); update_forum_lastpost($fid);	); update_forum_counters($fid, $updated_forum_stats); update_forum_lastpost($fid);
}	}
} if(!empty($user_counters))	} if(!empty($user_counters))
Zeile 3195	Zeile 3373
/** * Restore multiple posts *	/** * Restore multiple posts *
* @param array PIDs * @return boolean true	* @param array $pids PIDs * @return boolean
*/ function restore_posts($pids) {	*/ function restore_posts($pids) {
Zeile 3205	Zeile 3383
$num_posts = 0; if(empty($pids))	$num_posts = 0; if(empty($pids))
{ return false;	{ return false;
} // Make sure we only have valid values	} // Make sure we only have valid values
Zeile 3343	Zeile 3521
/** * Restore one or more threads *	/** * Restore one or more threads *
* @param array Thread IDs	* @param array\|int $tids Thread ID(s)
* @return boolean true */ function restore_threads($tids)	* @return boolean true */ function restore_threads($tids)
{ global $db, $cache, $plugins; if(!is_array($tids)) { $tids = array($tids); } if(empty($tids)) { return false; } // Make sure we only have valid values $tids = array_map('intval', $tids); $tid_list = $forum_counters = $user_counters = $posts_to_restore = array(); foreach($tids as $tid) { $thread = get_thread($tid); if(!$thread \|\| $thread['visible'] != -1)	{ global $db, $cache, $plugins; if(!is_array($tids)) { $tids = array($tids); } if(empty($tids)) { return false; } // Make sure we only have valid values $tids = array_map('intval', $tids); $tid_list = $forum_counters = $user_counters = $posts_to_restore = array(); $tids_list = implode(",", $tids); $query = $db->simple_select("threads", "*", "tid IN ($tids_list)"); while($thread = $db->fetch_array($query)) { if($thread['visible'] != -1)
{ continue; }	{ continue; }
Zeile 3383	Zeile 3563
'num_threads' => 0, 'num_deleted_posts' => 0, 'num_unapproved_posts' => 0	'num_threads' => 0, 'num_deleted_posts' => 0, 'num_unapproved_posts' => 0
); }	); }
if(!isset($user_counters[$thread['uid']])) { $user_counters[$thread['uid']] = array(	if(!isset($user_counters[$thread['uid']])) { $user_counters[$thread['uid']] = array(
Zeile 3402	Zeile 3582
if($forum['usepostcounts'] != 0) { // On approving thread restore user post counts	if($forum['usepostcounts'] != 0) { // On approving thread restore user post counts
$query = $db->simple_select("posts", "COUNT(pid) as posts, uid", "tid='{$tid}' AND (visible='1' OR pid='{$thread['firstpost']}') AND uid > 0 GROUP BY uid"); while($counter = $db->fetch_array($query))	$query2 = $db->simple_select("posts", "COUNT(pid) as posts, uid", "tid='{$thread['tid']}' AND (visible='1' OR pid='{$thread['firstpost']}') AND uid > 0 GROUP BY uid"); while($counter = $db->fetch_array($query2))
{	{
if(!isset($user_counters[$counter['uid']]['num_posts']))	if(!isset($user_counters[$counter['uid']]))
{	{
$user_counters[$counter['uid']]['num_posts'] = 0;	$user_counters[$counter['uid']] = array( 'num_posts' => 0, 'num_threads' => 0 );
} $user_counters[$counter['uid']]['num_posts'] += $counter['posts']; } }	} $user_counters[$counter['uid']]['num_posts'] += $counter['posts']; } }
if($forum['usethreadcounts'] != 0)	if($forum['usethreadcounts'] != 0 && substr($thread['closed'], 0, 6) != 'moved\|')
{ ++$user_counters[$thread['uid']]['num_threads']; }	{ ++$user_counters[$thread['uid']]['num_threads']; }
Zeile 3488	Zeile 3671
/** * Soft delete one or more threads *	/** * Soft delete one or more threads *
* @param array Thread IDs * @return boolean true	* @param array\|int Thread ID(s) * @return boolean
*/ function soft_delete_threads($tids) {	*/ function soft_delete_threads($tids) {
Zeile 3501	Zeile 3684
} if(empty($tids))	} if(empty($tids))
{	{
return false; }	return false; }
Zeile 3519	Zeile 3702
$forum_counters = $user_counters = $posts_to_delete = array();	$forum_counters = $user_counters = $posts_to_delete = array();
foreach($tids as $tid)	$tids_list = implode(",", $tids); $query = $db->simple_select("threads", "*", "tid IN ($tids_list)"); while($thread = $db->fetch_array($query))
{	{
$thread = get_thread($tid);
$forum = get_forum($thread['fid']); if($thread['visible'] == 1 \|\| $thread['visible'] == 0)	$forum = get_forum($thread['fid']); if($thread['visible'] == 1 \|\| $thread['visible'] == 0)
Zeile 3565	Zeile 3750
// On unapproving thread update user post counts if($thread['visible'] == 1 && $forum['usepostcounts'] != 0) {	// On unapproving thread update user post counts if($thread['visible'] == 1 && $forum['usepostcounts'] != 0) {
$query = $db->simple_select("posts", "COUNT(pid) AS posts, uid", "tid='{$tid}' AND (visible='1' OR pid='{$thread['firstpost']}') AND uid > 0 GROUP BY uid"); while($counter = $db->fetch_array($query))	$query2 = $db->simple_select("posts", "COUNT(pid) AS posts, uid", "tid='{$thread['tid']}' AND (visible='1' OR pid='{$thread['firstpost']}') AND uid > 0 GROUP BY uid"); while($counter = $db->fetch_array($query2))
{	{
if(!isset($user_counters[$counter['uid']]['num_posts']))	if(!isset($user_counters[$counter['uid']]))
{	{
$user_counters[$counter['uid']]['num_posts'] = 0;	$user_counters[$counter['uid']] = array( 'num_posts' => 0, 'num_threads' => 0 );
} $user_counters[$counter['uid']]['num_posts'] += $counter['posts']; } }	} $user_counters[$counter['uid']]['num_posts'] += $counter['posts']; } }
if($thread['visible'] == 1 && $forum['usethreadcounts'] != 0)	if($thread['visible'] == 1 && $forum['usethreadcounts'] != 0 && substr($thread['closed'], 0, 6) != 'moved\|')
{ ++$user_counters[$thread['uid']]['num_threads']; }	{ ++$user_counters[$thread['uid']]['num_threads']; }
Zeile 3591	Zeile 3779
// Soft delete redirects, too $redirect_tids = array(); $query = $db->simple_select('threads', 'tid', "closed IN ({$tid_moved_list})");	// Soft delete redirects, too $redirect_tids = array(); $query = $db->simple_select('threads', 'tid', "closed IN ({$tid_moved_list})");
	mark_reports($tids, "threads");
while($redirect_tid = $db->fetch_field($query, 'tid')) { $redirect_tids[] = $redirect_tid;	while($redirect_tid = $db->fetch_field($query, 'tid')) { $redirect_tids[] = $redirect_tid;