Vergleich inc/class_moderation.php - 1.8.0 - 1.8.33

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);	$tid_list = implode(',', $tids);
Zeile 114	Zeile 114
/** * 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 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)
{ global $db, $plugins;	{ global $db, $plugins;
$plugins->run_hooks("class_moderation_remove_redirects", $tid); // Delete the redirects $tid = (int)$tid; if(empty($tid))	$plugins->run_hooks("class_moderation_remove_redirects", $tid); // Delete the redirects $tid = (int)$tid; if(empty($tid))
{	{
return false;	return false;
}	}
$query = $db->simple_select('threads', 'tid', "closed='moved\|$tid'"); while($redirect_tid = $db->fetch_field($query, 'tid'))	$query = $db->simple_select('threads', 'tid', "closed='moved\|$tid'"); while($redirect_tid = $db->fetch_field($query, '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);
} }	} }
} // Delete posts and their attachments if(!empty($pids))	} // Delete posts and their attachments if(!empty($pids))
Zeile 307	Zeile 315
{ // Redirect if($thread['visible'] == 1)	{ // Redirect if($thread['visible'] == 1)
{	{
$updated_counters['posts'] = -1;	$updated_counters['posts'] = -1;
}	}
elseif($thread['visible'] == -1) { $updated_counters['deletedposts'] = -1;	elseif($thread['visible'] == -1) { $updated_counters['deletedposts'] = -1;
}	}
else { $updated_counters['unapprovedposts'] = -1;	else { $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 354	Zeile 363
'poll' => '0', ); $db->update_query("threads", $pollarray, "poll='$pid'");	'poll' => '0', ); $db->update_query("threads", $pollarray, "poll='$pid'");

return true; } /** * Approve one or more threads *	return true; } /** * 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) { global $db, $cache, $plugins; if(!is_array($tids))	*/ function approve_threads($tids) { global $db, $cache, $plugins; if(!is_array($tids))
{	{
$tids = array($tids); }	$tids = array($tids); }
Zeile 383	Zeile 392
$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;
}	}
$tid_list[] = $thread['tid'];	$tid_list[] = $thread['tid'];

$forum = get_forum($thread['fid']); if(!isset($forum_counters[$forum['fid']]))	$forum = get_forum($thread['fid']); if(!isset($forum_counters[$forum['fid']]))
{	{
$forum_counters[$forum['fid']] = array( 'num_posts' => 0, 'num_threads' => 0, 'num_deleted_posts' => 0, 'num_unapproved_posts' => 0	$forum_counters[$forum['fid']] = array( 'num_posts' => 0, 'num_threads' => 0, 'num_deleted_posts' => 0, 'num_unapproved_posts' => 0
); }	); }
if(!isset($user_counters[$thread['uid']])) {	if(!isset($user_counters[$thread['uid']])) {
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))
{ $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 474
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 489
"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); } } if(!empty($user_counters))	); update_forum_counters($fid, $update_array); update_forum_lastpost($fid); } } if(!empty($user_counters))
{ foreach($user_counters as $uid => $counters) {	{ foreach($user_counters as $uid => $counters) {
Zeile 498	Zeile 509
} return true; }	} return true; }

/** * 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) {	*/ function unapprove_threads($tids) {
Zeile 512	Zeile 523
if(!is_array($tids)) { $tids = array($tids);	if(!is_array($tids)) { $tids = array($tids);
}	}
if(empty($tids)) {	if(empty($tids)) {
Zeile 526	Zeile 537
$tid_moved_list = ""; $comma = ""; foreach($tids as $tid)	$tid_moved_list = ""; $comma = ""; foreach($tids as $tid)
{	{
$tid_moved_list .= "{$comma}'moved\|{$tid}'"; $comma = ","; }	$tid_moved_list .= "{$comma}'moved\|{$tid}'"; $comma = ","; }

$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)
{	{
if(!isset($forum_counters[$forum['fid']])) { $forum_counters[$forum['fid']] = array(	if(!isset($forum_counters[$forum['fid']])) { $forum_counters[$forum['fid']] = array(
Zeile 579	Zeile 592
// 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))
{ $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 644	Zeile 657
"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 684
"); $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 700	Zeile 713
if($post['visible'] == 0) { $update_array = array(	if($post['visible'] == 0) { $update_array = array(
"unapprovedposts" => "-1" ); } elseif($post['visible'] == -1) { $update_array = array( "deletedposts" => "-1"	"unapprovedposts" => "-1"
); }	); }
else	elseif($post['visible'] == -1)
{ $update_array = array(	{ $update_array = array(
"replies" => "-1"	"deletedposts" => "-1"
); }	); }
$plugins->run_hooks("class_moderation_delete_post", $post['pid']);	else { $update_array = array( "replies" => "-1" ); } $plugins->run_hooks("class_moderation_delete_post", $post['pid']);
update_thread_counters($post['tid'], $update_array); update_last_post($post['tid']);	update_thread_counters($post['tid'], $update_array); update_last_post($post['tid']);
Zeile 725	Zeile 738
if(($post['visible'] == 0 && $post['threadvisible'] != -1) \|\| $post['threadvisible'] == 0) { $update_array = array(	if(($post['visible'] == 0 && $post['threadvisible'] != -1) \|\| $post['threadvisible'] == 0) { $update_array = array(
"unapprovedposts" => "-1" ); } elseif($post['visible'] == -1 \|\| $post['threadvisible'] == 0) { $update_array = array(	"unapprovedposts" => "-1" ); } elseif($post['visible'] == -1 \|\| $post['threadvisible'] == -1) { $update_array = array(
"deletedposts" => "-1" ); }	"deletedposts" => "-1" ); }
Zeile 750	Zeile 763
/** * 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; // Make sure we only have valid values $pids = array_map('intval', $pids);	{ global $db, $plugins; // Make sure we only have valid values $pids = array_map('intval', $pids);

if(empty($pids) \|\| count($pids) < 2) { return false;	if(empty($pids) \|\| count($pids) < 2) { return false;
Zeile 779	Zeile 791
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 814
$fid = $post['fid']; $mastertid = $post['tid']; $first = 0;	$fid = $post['fid']; $mastertid = $post['tid']; $first = 0;
	$visible = $post['visible'];
} else {	} else {
Zeile 828	Zeile 841
{ --$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 870
// 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 857	Zeile 877
--$forum_counters[$post['fid']]['num_posts']; } elseif($post['threadvisible'] == 0 \|\| ($post['visible'] == 0 && $post['threadvisible'] != -1))	--$forum_counters[$post['fid']]['num_posts']; } elseif($post['threadvisible'] == 0 \|\| ($post['visible'] == 0 && $post['threadvisible'] != -1))
{	{
--$forum_counters[$post['fid']]['unapprovedposts']; } else { --$forum_counters[$post['fid']]['deletedposts'];	--$forum_counters[$post['fid']]['unapprovedposts']; } else { --$forum_counters[$post['fid']]['deletedposts'];
	} // Add attachment count to thread if($visible == 1) { $thread_counters[$mastertid]['attachmentcount'] += $post['attachmentcount'];
} } }	} } }
Zeile 870	Zeile 896
// 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 909
$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 901	Zeile 927
elseif($new_firstpost['visible'] == -1) { --$thread_counters[$thread['tid']]['deletedposts'];	elseif($new_firstpost['visible'] == -1) { --$thread_counters[$thread['tid']]['deletedposts'];
}	}
else { --$thread_counters[$thread['tid']]['unapprovedposts'];	else { --$thread_counters[$thread['tid']]['unapprovedposts'];
Zeile 918	Zeile 944
{ ++$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)) { foreach($thread_counters as $tid => $counters)	$plugins->run_hooks("class_moderation_merge_posts", $arguments); if(!empty($thread_counters)) { foreach($thread_counters as $tid => $counters)
{ $counters = array( 'replies' => signed($counters['replies']), 'unapprovedposts' => signed($counters['unapprovedposts']), 'deletedposts' => signed($counters['deletedposts']), 'attachmentcount' => signed($counters['attachmentcount'])	{ $counters = array( 'replies' => signed($counters['replies']), 'unapprovedposts' => signed($counters['unapprovedposts']), 'deletedposts' => signed($counters['deletedposts']), 'attachmentcount' => signed($counters['attachmentcount'])
);	);
update_thread_counters($tid, $counters); update_last_post($tid); } } if(!empty($forum_counters))	update_thread_counters($tid, $counters); update_last_post($tid); } } if(!empty($forum_counters))
{	{
foreach($forum_counters as $fid => $counters) { $updated_forum_stats = array(	foreach($forum_counters as $fid => $counters) { $updated_forum_stats = array(
Zeile 956	Zeile 994
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);
} }	} }

return $masterpid; } /** * Move/copy thread *	return $masterpid; } /** * 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 1026
$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 1043
$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 1073
); $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 1183
'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 1243
'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 1295
); $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 1308
// 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 1337
} }	} }
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 1365	Zeile 1407
/** * 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 1427
{ $thread = get_thread($tid); }	{ $thread = get_thread($tid); }

if(!$mergethread \|\| !$thread) { return false;	if(!$mergethread \|\| !$thread) { return false;
}	} $forum_cache = $cache->read('forums');
$threadarray = array(); if(!$thread['poll'] && $mergethread['poll']) {	$threadarray = array(); if(!$thread['poll'] && $mergethread['poll']) {
Zeile 1402	Zeile 1446
} // Both the old and the new thread have polls? Remove one elseif($mergethread['poll'])	} // Both the old and the new thread have polls? Remove one elseif($mergethread['poll'])
{	{
$db->delete_query("polls", "pid='{$mergethread['poll']}'"); $db->delete_query("pollvotes", "pid='{$mergethread['poll']}'"); }	$db->delete_query("polls", "pid='{$mergethread['poll']}'"); $db->delete_query("pollvotes", "pid='{$mergethread['poll']}'"); }

$subject = $db->escape_string($subject); $threadarray['subject'] = $subject; $user_posts = array();	$subject = $db->escape_string($subject); $threadarray['subject'] = $subject; $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(	} $sqlarray = array(
Zeile 1464	Zeile 1519
$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 1561
// 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']); }
// 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']; } // Thread is not in current forum if($mergethread['fid'] != $thread['fid'])	++$user_posts[$new_firstpost['uid']]['threadnum']; } // Thread is not in current forum if($mergethread['fid'] != $thread['fid'])
{ // If new thread is unapproved, implied counter comes in to effect if($thread['visible'] == 0) { $updated_stats = array(	{ // If new thread is unapproved, implied counter comes in to effect if($thread['visible'] == 0) { $updated_stats = array(
"unapprovedposts" => '+'.($mergethread['replies']+$mergethread['unapprovedposts']+$mergethread['deletedposts']) ); }	"unapprovedposts" => '+'.($mergethread['replies']+$mergethread['unapprovedposts']+$mergethread['deletedposts']) ); }
Zeile 1553	Zeile 1621
); } 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 1649	Zeile 1716
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 1685	Zeile 1747
} }	} }
if($thread['visible'] != $mergethread['visible'])	// Update user counters foreach($user_posts as $uid => $counters)
{	{
// 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_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) { global $db, $thread, $plugins, $cache;	*/ function split_posts($pids, $tid, $moveto, $newsubject, $destination_tid=0) { global $db, $thread, $plugins, $cache;

$tid = (int)$tid; $moveto = (int)$moveto; $newtid = (int)$destination_tid;	$tid = (int)$tid; $moveto = (int)$moveto; $newtid = (int)$destination_tid;

// 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 1758	Zeile 1805
} // 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 1819
'unapprovedposts' => 0, 'deletedposts' => 0 );	'unapprovedposts' => 0, 'deletedposts' => 0 );
	$user_counters = array();
if($destination_tid == 0) {	if($destination_tid == 0) {
Zeile 1782	Zeile 1834
"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 1845
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 1876
// 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 1917
'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) { // Unapproved post // Subtract 1 from the old thread's unapproved posts --$thread_counters[$post['tid']]['unapprovedposts'];	} elseif($post['visible'] == 0) { // 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) {
Zeile 1924	Zeile 1963
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 1973
{ // 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 2005
{ --$thread_counters[$post['tid']]['unapprovedposts']; }	{ --$thread_counters[$post['tid']]['unapprovedposts']; }
if($post['threadvisible'] == 1)	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'];	{ ++$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	else
{	{
++$thread_counters[$post['tid']]['unapprovedposts'];	++$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']); } // 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($post['tid']);	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'];
} }	} }

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 2025	Zeile 2160
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 2176
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 2087	Zeile 2222
/** * 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 2099	Zeile 2236
$tids = array_map('intval', $tids); $tid_list = implode(',', $tids);	$tids = array_map('intval', $tids); $tid_list = implode(',', $tids);

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

if(empty($tids) \|\| !$newforum) { return false;	if(empty($tids) \|\| !$newforum) { return false;
Zeile 2117	Zeile 2254
$forum = get_forum($thread['fid']); if(!isset($forum_counters[$thread['fid']]))	$forum = get_forum($thread['fid']); if(!isset($forum_counters[$thread['fid']]))
{	{
$forum_counters[$thread['fid']] = array( 'posts' => 0, 'threads' => 0,	$forum_counters[$thread['fid']] = array( 'posts' => 0, 'threads' => 0,
Zeile 2128	Zeile 2265
); }	); }
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 2146	Zeile 2286
++$total_threads; if($newforum['usethreadcounts'] == 1 && $forum['usethreadcounts'] == 0)	++$total_threads; if($newforum['usethreadcounts'] == 1 && $forum['usethreadcounts'] == 0)
{	{
++$user_counters[$thread['uid']]['num_threads']; } else if($newforum['usethreadcounts'] == 0 && $forum['usethreadcounts'] == 1)	++$user_counters[$thread['uid']]['num_threads']; } else if($newforum['usethreadcounts'] == 0 && $forum['usethreadcounts'] == 1)
Zeile 2155	Zeile 2295
} $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 2224	Zeile 2367
break; default: $query = $db->simple_select("threadprefixes", "COUNT(*) as num_prefixes", "(CONCAT(',',forums,',') LIKE '%,$moveto,%' OR forums='-1') AND pid='".$thread['prefix']."'");	break; default: $query = $db->simple_select("threadprefixes", "COUNT(*) as num_prefixes", "(CONCAT(',',forums,',') LIKE '%,$moveto,%' OR forums='-1') AND pid='".$thread['prefix']."'");
}	}
if($db->fetch_field($query, "num_prefixes") == 0) { $sqlarray = array( "prefix" => 0, ); $db->update_query("threads", $sqlarray, "tid = '{$thread['tid']}'");	if($db->fetch_field($query, "num_prefixes") == 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);	$arguments = array("tids" => $tids, "moveto" => $moveto); $plugins->run_hooks("class_moderation_move_threads", $arguments);

if(!empty($user_counters))	if(!empty($user_counters))
{	{
foreach($user_counters as $uid => $counters) { $update_array = array( "postnum" => "+{$counters['num_posts']}", "threadnum" => "+{$counters['num_threads']}",	foreach($user_counters as $uid => $counters) { $update_array = array( "postnum" => "+{$counters['num_posts']}", "threadnum" => "+{$counters['num_threads']}",
);	);
update_user_counters($uid, $update_array); } }	update_user_counters($uid, $update_array); } }
Zeile 2260	Zeile 2403
'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 2274	Zeile 2417
"unapprovedposts" => "+{$total_unapproved_posts}", 'deletedposts' => "+{$total_deleted_posts}", "deletedthreads" => "+{$total_deleted_threads}"	"unapprovedposts" => "+{$total_unapproved_posts}", 'deletedposts' => "+{$total_deleted_posts}", "deletedthreads" => "+{$total_deleted_threads}"
);	);
update_forum_counters($moveto, $updated_count); update_forum_lastpost($moveto);	update_forum_counters($moveto, $updated_count); update_forum_lastpost($moveto);
Zeile 2288	Zeile 2431
/** * Approve multiple posts *	/** * Approve multiple posts *
* @param array PIDs * @return boolean true	* @param array $pids PIDs * @return boolean
*/ function approve_posts($pids) {	*/ function approve_posts($pids) {
Zeile 2300	Zeile 2443
if(empty($pids)) { return false;	if(empty($pids)) { 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 2328	Zeile 2471
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']; }	$threads_to_update[] = $post['tid']; }
if(!empty($threads_to_update)) { $this->approve_threads($threads_to_update);	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 2347	Zeile 2490
while($post = $db->fetch_array($query)) { $pids[] = $post['pid'];	while($post = $db->fetch_array($query)) { $pids[] = $post['pid'];

if(!isset($thread_counters[$post['tid']])) { $thread_counters[$post['tid']] = array( 'replies' => 0 );	if(!isset($thread_counters[$post['tid']])) { $thread_counters[$post['tid']] = array( 'replies' => 0 );
}	}
++$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	++$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($post['threadvisible'] != 0) {	if($post['threadvisible'] == 1) {
if(!isset($forum_counters[$post['fid']])) { $forum_counters[$post['fid']] = array( 'num_posts' => 0 );	if(!isset($forum_counters[$post['fid']])) { $forum_counters[$post['fid']] = array( 'num_posts' => 0 );
}	}
++$forum_counters[$post['fid']]['num_posts']; }	++$forum_counters[$post['fid']]['num_posts']; }
Zeile 2380	Zeile 2523
$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))	} } if(empty($pids) && empty($threads_to_update))
{ return false; }	{ return false; }
Zeile 2397	Zeile 2540
$plugins->run_hooks("class_moderation_approve_posts", $pids); if(!empty($thread_counters))	$plugins->run_hooks("class_moderation_approve_posts", $pids); if(!empty($thread_counters))
{	{
foreach($thread_counters as $tid => $counters) { $counters_update = array( "unapprovedposts" => "-".$counters['replies'], "replies" => "+".$counters['replies']	foreach($thread_counters as $tid => $counters) { $counters_update = array( "unapprovedposts" => "-".$counters['replies'], "replies" => "+".$counters['replies']
);	);
update_thread_counters($tid, $counters_update); update_last_post($tid); } } if(!empty($forum_counters))	update_thread_counters($tid, $counters_update); update_last_post($tid); } } if(!empty($forum_counters))
{	{
foreach($forum_counters as $fid => $counters) { $updated_forum_stats = array(	foreach($forum_counters as $fid => $counters) { $updated_forum_stats = array(
Zeile 2435	Zeile 2578
/** * Unapprove multiple posts	/** * Unapprove multiple posts
* * @param array PIDs * @return boolean true	* * @param array $pids PIDs * @return boolean
*/ function unapprove_posts($pids) { global $db, $cache, $plugins; if(empty($pids))	*/ function unapprove_posts($pids) { global $db, $cache, $plugins; if(empty($pids))
{	{
return false; }	return false; }
Zeile 2476	Zeile 2619
{ // This is the first post in the thread so we're unapproving the whole thread. $threads_to_update[] = $post['tid'];	{ // This is the first post in the thread so we're unapproving the whole thread. $threads_to_update[] = $post['tid'];
}	}
if(!empty($threads_to_update)) { $this->unapprove_threads($threads_to_update);	if(!empty($threads_to_update)) { $this->unapprove_threads($threads_to_update);
Zeile 2490	Zeile 2633
FROM ".TABLE_PREFIX."posts p LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=p.tid) WHERE p.pid IN ($pid_list) AND p.visible IN (-1,1) AND t.firstpost != p.pid	FROM ".TABLE_PREFIX."posts p LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=p.tid) WHERE p.pid IN ($pid_list) AND p.visible IN (-1,1) AND t.firstpost != p.pid
");	");
while($post = $db->fetch_array($query)) { $pids[] = $post['pid'];	while($post = $db->fetch_array($query)) { $pids[] = $post['pid'];
Zeile 2607	Zeile 2750
/** * 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;	return false;
} $tid_list = implode(',', $tids);	} $tid_list = implode(',', $tids);
// Get original subject	// 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 2811
/** * 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) { global $db, $plugins;	*/ function expire_thread($tid, $deletetime) { global $db, $plugins;

$tid = (int)$tid; if(empty($tid)) { return false;	$tid = (int)$tid; if(empty($tid)) { return false;
}	}
$update_thread = array( "deletetime" => (int)$deletetime ); $db->update_query("threads", $update_thread, "tid='{$tid}'");	$update_thread = array( "deletetime" => (int)$deletetime ); $db->update_query("threads", $update_thread, "tid='{$tid}'");

$arguments = array("tid" => $tid, "deletetime" => $deletetime); $plugins->run_hooks("class_moderation_expire_thread", $arguments);	$arguments = array("tid" => $tid, "deletetime" => $deletetime); $plugins->run_hooks("class_moderation_expire_thread", $arguments);
Zeile 2683	Zeile 2840
/** * 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 2700	Zeile 2857
if($post['visible'] != 0) { $unapprove[] = $post['pid'];	if($post['visible'] != 0) { $unapprove[] = $post['pid'];
}	}
else { $approve[] = $post['pid'];	else { $approve[] = $post['pid'];
Zeile 2713	Zeile 2870
if(is_array($approve)) { $this->approve_posts($approve);	if(is_array($approve)) { $this->approve_posts($approve);
} return true; }	} return true; }
/** * Toggle post visibility (deleted/restored)	/** * Toggle post visibility (deleted/restored)
* * @param array Post IDs * @return boolean true */	* * @param array $pids Post IDs * @return boolean true */
function toggle_post_softdelete($pids)	function toggle_post_softdelete($pids)
{ global $db; // Make sure we only have valid values	{ global $db; // Make sure we only have valid values
$pids = array_map('intval', $pids); $pid_list = implode(',', $pids); $query = $db->simple_select("posts", 'pid, visible', "pid IN ($pid_list)"); while($post = $db->fetch_array($query))	$pids = array_map('intval', $pids); $pid_list = implode(',', $pids); $query = $db->simple_select("posts", 'pid, visible', "pid IN ($pid_list)"); while($post = $db->fetch_array($query))
{	{
if($post['visible'] != -1) { $delete[] = $post['pid'];	if($post['visible'] != -1) { $delete[] = $post['pid'];
Zeile 2757	Zeile 2914
/** * 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)
{ 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);	$fid = (int)$fid; $tid_list = implode(',', $tids);
Zeile 2796	Zeile 2953
/** * 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 2978
} 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 2990
/** * 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 3027
/** * 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)
{	{
global $db;	global $db;

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

$stick = array(); $unstick = array();	$stick = array(); $unstick = array();
Zeile 2901	Zeile 3056
if(!empty($stick)) { $this->stick_threads($stick);	if(!empty($stick)) { $this->stick_threads($stick);
}	}
if(!empty($unstick)) { $this->unstick_threads($unstick);	if(!empty($unstick)) { $this->unstick_threads($unstick);
Zeile 2912	Zeile 3067
/** * 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;	{ 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	} // Make sure we only have valid values
Zeile 2945	Zeile 3100
$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']; switch($db->type)	while($group = $db->fetch_array($query)) { $groups[] = $group['gid']; switch($db->type)
{	{
case "pgsql": case "sqlite": $additional_groups .= " OR ','\|\|u.additionalgroups\|\|',' LIKE ',{$group['gid']},'";	case "pgsql": case "sqlite": $additional_groups .= " OR ','\|\|u.additionalgroups\|\|',' LIKE ',{$group['gid']},'";
Zeile 2979	Zeile 3135
else { $db->delete_query("threadsubscriptions", "tid IN ({$tids_csv})");	else { $db->delete_query("threadsubscriptions", "tid IN ({$tids_csv})");
}	}
$arguments = array("tids" => $tids, "all" => $all, "fid" => $fid); $plugins->run_hooks("class_moderation_remove_thread_subscriptions", $arguments);	$arguments = array("tids" => $tids, "all" => $all, "fid" => $fid); $plugins->run_hooks("class_moderation_remove_thread_subscriptions", $arguments);
return true; } /**	return true; } /**
* 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)
{	{
global $db, $plugins; // Format thread IDs if(!is_array($tids)) { $tids = array($tids);	global $db, $plugins; // Format thread IDs 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); $tids_csv = implode(',', $tids);	// Make sure we only have valid values $tids = array_map('intval', $tids); $tids_csv = implode(',', $tids);
Zeile 3025	Zeile 3182
/** * 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) { global $db, $cache, $plugins; if(empty($pids))	*/ function soft_delete_posts($pids) { global $db, $cache, $plugins; if(empty($pids))
{ return false;	{ return false;
} // Make sure we only have valid values	} // Make sure we only have valid values
Zeile 3136	Zeile 3293
$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(is_array($thread_counters)) { foreach($thread_counters as $tid => $counters)	} } 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)
{ $counters_update = array( "unapprovedposts" => "-".$counters['unapprovedposts'], "replies" => "-".$counters['replies'], "deletedposts" => "+".$counters['deletedposts']	{ $counters_update = array( "unapprovedposts" => "-".$counters['unapprovedposts'], "replies" => "-".$counters['replies'], "deletedposts" => "+".$counters['deletedposts']
);	);
update_thread_counters($tid, $counters_update); update_last_post($tid); } } if(is_array($forum_counters))	update_thread_counters($tid, $counters_update); update_last_post($tid); } } if(is_array($forum_counters))
{	{
foreach($forum_counters as $fid => $counters) { $updated_forum_stats = array(	foreach($forum_counters as $fid => $counters) { $updated_forum_stats = array(
Zeile 3188	Zeile 3346
update_user_counters($uid, array('postnum' => "{$counter}")); } }	update_user_counters($uid, array('postnum' => "{$counter}")); } }

return true; } /** * Restore multiple posts *	return true; } /** * 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 3363
$num_posts = 0; if(empty($pids))	$num_posts = 0; if(empty($pids))
{ return false; } // Make sure we only have valid values	{ return false; } // Make sure we only have valid values
$pids = array_map('intval', $pids); $pid_list = implode(',', $pids);	$pids = array_map('intval', $pids); $pid_list = implode(',', $pids);
Zeile 3228	Zeile 3386
// 3) We're doing both 1 and 2 $query = $db->query(" SELECT p.tid	// 3) We're doing both 1 and 2 $query = $db->query(" SELECT p.tid
FROM ".TABLE_PREFIX."posts p LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=p.tid)	FROM ".TABLE_PREFIX."posts p LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=p.tid)
WHERE p.pid IN ($pid_list) AND p.visible = '-1' AND t.firstpost = p.pid AND t.visible = -1 "); 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'];	WHERE p.pid IN ($pid_list) AND p.visible = '-1' AND t.firstpost = p.pid AND t.visible = -1 "); 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)) {	if(!empty($threads_to_update)) {
Zeile 3260	Zeile 3418
{ $thread_counters[$post['tid']] = array( 'replies' => 0	{ $thread_counters[$post['tid']] = array( 'replies' => 0
); }	); }
++$thread_counters[$post['tid']]['replies']; // If the thread of this post is deleted then we've already taken into account this counter as implied.	++$thread_counters[$post['tid']]['replies']; // If the thread of this post is deleted then we've already taken into account this counter as implied.
Zeile 3276	Zeile 3434
); } ++$forum_counters[$post['fid']]['num_posts'];	); } ++$forum_counters[$post['fid']]['num_posts'];
}	}
// If post counts enabled in this forum and the thread is approved, add 1 if($post['usepostcounts'] != 0 && $post['threadvisible'] == 1)	// If post counts enabled in this forum and the thread is approved, add 1 if($post['usepostcounts'] != 0 && $post['threadvisible'] == 1)
Zeile 3288	Zeile 3446
++$user_counters[$post['uid']]; }	++$user_counters[$post['uid']]; }
}	}
if(empty($pids) && empty($threads_to_update)) { return false; } if(!empty($pids))	if(empty($pids) && empty($threads_to_update)) { return false; } if(!empty($pids))
{	{
$where = "pid IN (".implode(',', $pids).")"; $db->update_query("posts", $update, $where); }	$where = "pid IN (".implode(',', $pids).")"; $db->update_query("posts", $update, $where); }
Zeile 3313	Zeile 3471
); 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)) { foreach($forum_counters as $fid => $counters)	if(is_array($forum_counters)) { foreach($forum_counters as $fid => $counters)
Zeile 3326	Zeile 3484
); 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)) { foreach($user_counters as $uid => $counter) { update_user_counters($uid, array('postnum' => "+{$counter}")); }	if(!empty($user_counters)) { foreach($user_counters as $uid => $counter) { update_user_counters($uid, array('postnum' => "+{$counter}")); }
}	}
return true; }	return true; }
Zeile 3343	Zeile 3501
/** * 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)
Zeile 3365	Zeile 3523
$tid_list = $forum_counters = $user_counters = $posts_to_restore = array();	$tid_list = $forum_counters = $user_counters = $posts_to_restore = 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)	if($thread['visible'] != -1)
{ continue; }	{ continue; }
Zeile 3402	Zeile 3562
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']]['num_posts'])) {
Zeile 3413	Zeile 3573
} }	} }
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 3479	Zeile 3639
"threadnum" => "+{$counters['num_threads']}", ); update_user_counters($uid, $update_array);	"threadnum" => "+{$counters['num_threads']}", ); update_user_counters($uid, $update_array);
} }	} }
} return true; }	} return true; }
Zeile 3488	Zeile 3648
/** * 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) { global $db, $cache, $plugins; if(!is_array($tids))	*/ function soft_delete_threads($tids) { global $db, $cache, $plugins; if(!is_array($tids))
{	{
$tids = array($tids); } if(empty($tids))	$tids = array($tids); } if(empty($tids))
{	{
return false; }	return false; }
Zeile 3516	Zeile 3676
$tid_moved_list .= "{$comma}'moved\|{$tid}'"; $comma = ","; }	$tid_moved_list .= "{$comma}'moved\|{$tid}'"; $comma = ","; }

$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 3727
// 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']]['num_posts'])) {
Zeile 3576	Zeile 3738
} }	} }
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 3753
// 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;