| Zeile 6 | Zeile 6 |
|---|
* Website: http://www.mybboard.net
* License: http://www.mybboard.net/eula.html
*
|
* Website: http://www.mybboard.net
* License: http://www.mybboard.net/eula.html
*
|
* $Id: class_moderation.php 3051 2007-05-12 12:07:29Z chris $
| * $Id: class_moderation.php 3592 2008-01-09 00:01:41Z Tikitiki $
|
*/
class Moderation
| */
class Moderation
|
| Zeile 19 | Zeile 19 |
|---|
*/
function close_threads($tids)
{
|
*/
function close_threads($tids)
{
|
global $db;
| global $db, $plugins;
|
if(!is_array($tids))
{
$tids = array($tids);
}
$tid_list = implode(",", $tids);
|
if(!is_array($tids))
{
$tids = array($tids);
}
$tid_list = implode(",", $tids);
|
| |
$plugins->run_hooks("class_moderation_close_threads", $tids);
|
$openthread = array(
"closed" => "yes",
|
$openthread = array(
"closed" => "yes",
|
| Zeile 44 | Zeile 46 |
|---|
function open_threads($tids)
{
|
function open_threads($tids)
{
|
global $db;
| global $db, $plugins;
|
if(!is_array($tids))
{
$tids = array($tids);
}
$tid_list = implode(",", $tids);
|
if(!is_array($tids))
{
$tids = array($tids);
}
$tid_list = implode(",", $tids);
|
| |
$plugins->run_hooks("class_moderation_open_threads", $tids);
|
$closethread = array(
"closed" => "no",
|
$closethread = array(
"closed" => "no",
|
);
| );
|
$db->update_query(TABLE_PREFIX."threads", $closethread, "tid IN ($tid_list)");
return true;
| $db->update_query(TABLE_PREFIX."threads", $closethread, "tid IN ($tid_list)");
return true;
|
| Zeile 67 | Zeile 71 |
|---|
* @return boolean true
*/
function stick_threads($tids)
|
* @return boolean true
*/
function stick_threads($tids)
|
{
global $db;
if(!is_array($tids))
{
$tids = array($tids);
}
$tid_list = implode(",", $tids);
| {
global $db, $plugins;
if(!is_array($tids))
{
$tids = array($tids);
}
$tid_list = implode(",", $tids);
$plugins->run_hooks("class_moderation_stick_threads", $tids);
|
$stickthread = array(
"sticky" => 1,
);
$db->update_query(TABLE_PREFIX."threads", $stickthread, "tid IN ($tid_list)");
|
$stickthread = array(
"sticky" => 1,
);
$db->update_query(TABLE_PREFIX."threads", $stickthread, "tid IN ($tid_list)");
|
|
|
return true;
}
| return true;
}
|
| Zeile 91 | Zeile 97 |
|---|
* @return boolean true
*/
function unstick_threads($tids)
|
* @return boolean true
*/
function unstick_threads($tids)
|
{
global $db;
| {
global $db, $plugins;
|
if(!is_array($tids))
{
$tids = array($tids);
}
$tid_list = implode(",", $tids);
|
if(!is_array($tids))
{
$tids = array($tids);
}
$tid_list = implode(",", $tids);
|
| |
$plugins->run_hooks("class_moderation_unstick_threads", $tids);
|
$unstickthread = array(
"sticky" => 0,
|
$unstickthread = array(
"sticky" => 0,
|
| Zeile 116 | Zeile 124 |
|---|
*/
function remove_redirects($tid)
{
|
*/
function remove_redirects($tid)
{
|
global $db;
| global $db, $plugins;
$plugins->run_hooks("class_moderation_remove_redirects", $tid);
|
|
|
// Update forum counters
$query = $db->simple_select(TABLE_PREFIX."threads", "fid,visible", "closed='moved|$tid'");
while($thread = $db->fetch_array($query))
{
if($thread['visible'] == 1)
{
if($counters[$thread['fid']]['threads'])
{
--$counters[$thread['fid']]['threads'];
}
else
{
$counters[$thread['fid']]['threads'] = -1;
}
}
else if($thread['visible'] == 0)
{
if($counters[$thread['fid']]['unapprovedthreads'])
{
--$counters[$thread['fid']]['unapprovedthreads'];
}
else
{
$counters[$thread['fid']]['unapprovedthreads'] = -1;
}
}
}
| |
// Delete the redirects
$db->delete_query(TABLE_PREFIX."threads", "closed='moved|$tid'");
|
// Delete the redirects
$db->delete_query(TABLE_PREFIX."threads", "closed='moved|$tid'");
|
// Update the forum stats of the fids found above
if(is_array($counters))
{
foreach($counters as $fid => $values)
{
$update_array = array();
if($values['threads'])
{
$update_array['threads'] = $values['threads'];
}
if($values['unapprovedthreads'])
{
$update_array['unapprovedthreads'] = $values['unapprovedthreads'];
}
update_forum_counters($fid, $update_array);
}
}
| |
return true;
}
| return true;
}
|
| Zeile 179 | Zeile 144 |
|---|
global $db, $cache, $plugins;
$thread = get_thread($tid);
|
global $db, $cache, $plugins;
$thread = get_thread($tid);
|
| |
$userposts = array();
|
// Find the pid, uid, visibility, and forum post count status
$query = $db->query("
|
// Find the pid, uid, visibility, and forum post count status
$query = $db->query("
|
| Zeile 210 | Zeile 177 |
|---|
if($userposts[$post['uid']])
{
$userposts[$post['uid']]--;
|
if($userposts[$post['uid']])
{
$userposts[$post['uid']]--;
|
}
else
{
| }
else
{
|
$userposts[$post['uid']] = -1;
}
}
| $userposts[$post['uid']] = -1;
}
}
|
| Zeile 238 | Zeile 205 |
|---|
// Get thread info
$query = $db->simple_select(TABLE_PREFIX."threads", "*", "tid='$tid'");
$thread = $db->fetch_array($query);
|
// Get thread info
$query = $db->simple_select(TABLE_PREFIX."threads", "*", "tid='$tid'");
$thread = $db->fetch_array($query);
|
| |
// Implied counters for unapproved thread
if($thread['visible'] == 0)
{
$num_unapproved_posts += $thread['replies'];
}
|
// Delete threads, redirects, favorites, polls, and poll votes
$db->delete_query(TABLE_PREFIX."threads", "tid='$tid'");
|
// Delete threads, redirects, favorites, polls, and poll votes
$db->delete_query(TABLE_PREFIX."threads", "tid='$tid'");
|
| Zeile 245 | Zeile 218 |
|---|
$db->delete_query(TABLE_PREFIX."favorites", "tid='$tid'");
$db->delete_query(TABLE_PREFIX."polls", "tid='$tid'");
$db->delete_query(TABLE_PREFIX."pollvotes", "pid='".$thread['poll']."'");
|
$db->delete_query(TABLE_PREFIX."favorites", "tid='$tid'");
$db->delete_query(TABLE_PREFIX."polls", "tid='$tid'");
$db->delete_query(TABLE_PREFIX."pollvotes", "pid='".$thread['poll']."'");
|
$updated_counters = array(
| $updated_counters = array(
|
"posts" => "-{$num_approved_posts}",
"unapprovedposts" => "-{$num_unapproved_posts}"
|
"posts" => "-{$num_approved_posts}",
"unapprovedposts" => "-{$num_unapproved_posts}"
|
);
if($thread['visible'] == 1)
{
$updated_counters['threads'] = -1;
}
else
{
$updated_counters['unapprovedthreads'] = -1;
}
| );
if($thread['visible'] == 1)
{
$updated_counters['threads'] = -1;
}
else
{
$updated_counters['unapprovedthreads'] = -1;
}
|
if(substr($thread['closed'], 0, 5) != "moved")
|
if(substr($thread['closed'], 0, 5) != "moved")
|
{
| {
|
// Update forum count
update_forum_counters($thread['fid'], $updated_counters);
|
// Update forum count
update_forum_counters($thread['fid'], $updated_counters);
|
}
$plugins->run_hooks("delete_thread", $tid);
| }
$plugins->run_hooks("class_moderation_delete_thread", $tid);
|
return true;
}
|
return true;
}
|
| Zeile 277 | Zeile 251 |
|---|
*/
function delete_poll($pid)
{
|
*/
function delete_poll($pid)
{
|
global $db;
| global $db, $plugins;
$plugins->run_hooks("class_moderation_delete_poll", $pid);
|
$db->delete_query(TABLE_PREFIX."polls", "pid='$pid'");
$db->delete_query(TABLE_PREFIX."pollvotes", "pid='$pid'");
$pollarray = array(
|
$db->delete_query(TABLE_PREFIX."polls", "pid='$pid'");
$db->delete_query(TABLE_PREFIX."pollvotes", "pid='$pid'");
$pollarray = array(
|
"poll" => '',
| 'poll' => '0',
|
);
$db->update_query(TABLE_PREFIX."threads", $pollarray, "poll='$pid'");
| );
$db->update_query(TABLE_PREFIX."threads", $pollarray, "poll='$pid'");
|
| Zeile 297 | Zeile 273 |
|---|
* @return boolean true
*/
function approve_threads($tids, $fid)
|
* @return boolean true
*/
function approve_threads($tids, $fid)
|
{
global $db, $cache;
| {
global $db, $cache, $plugins;
if(!is_array($tids))
{
$tids = array($tids);
}
$num_threads = $num_posts = 0;
foreach($tids as $tid)
{
$thread = get_thread($tid);
if($thread['visible'] == 1 || !$thread['tid'])
{
continue;
}
$tid_list[] = $thread['tid'];
|
|
|
if(!is_array($tids))
{
$tids = array($tids);
}
$tid_list = implode(",", $tids);
$num_threads = $num_posts = 0;
foreach($tids as $tid)
{
$thread = get_thread($tid);
| $forum = get_forum($thread['tid']);
|
|
|
if($thread['visible'] == 0)
{
$num_approved_threads++;
$num_unapproved_threads--;
}
$query = $db->query("
SELECT p.tid, f.usepostcounts, p.uid, p.visible
FROM ".TABLE_PREFIX."posts p
LEFT JOIN ".TABLE_PREFIX."forums f ON (f.fid=p.fid)
WHERE p.tid='$tid' AND p.visible = '0'
");
while($post = $db->fetch_array($query))
| $num_threads++;
$num_posts += $thread['replies']+1; // Remove implied visible from count
if($forum['usepostcounts'] != "no")
|
{
|
{
|
// If post counts enabled in this forum and the post hasn't already been approved, remove 1
if($post['usepostcounts'] != "no")
{
$db->query("UPDATE ".TABLE_PREFIX."users SET postnum=postnum+1 WHERE uid='".$post['uid']."'");
}
if($post['visible'] == 1)
| // On approving thread restore user post counts
$query = $db->simple_select(TABLE_PREFIX."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))
|
{
|
{
|
$num_posts++;
| $db->query("UPDATE ".TABLE_PREFIX."users SET postnum=postnum+{$counter['posts']} WHERE uid='".$counter['uid']."'");
|
}
}
|
}
}
|
| | $posts_to_approve[] = $thread['firstpost'];
|
}
|
}
|
$approve = array(
"visible" => 1,
);
$db->update_query(TABLE_PREFIX."threads", $approve, "tid IN ($tid_list)");
$db->update_query(TABLE_PREFIX."posts", $approve, "tid IN ($tid_list)", 1);
// Update stats
$update_array = array(
"threads" => "+{$num_threads}",
"unapprovedthreads" => "-{$num_threads}",
"posts" => "+{$num_posts}",
"unapprovedposts" => "-{$num_posts}"
);
update_forum_counters($fid, $update_array);
| if(is_array($tid_list))
{
$tid_list = implode(",", $tid_list);
$approve = array(
"visible" => 1,
);
$db->update_query(TABLE_PREFIX."threads", $approve, "tid IN ($tid_list)");
$db->update_query(TABLE_PREFIX."posts", $approve, "pid IN (".implode(",", $posts_to_approve).")");
|
|
|
| | $plugins->run_hooks("class_moderation_approve_threads", $tids);
// Update stats
$update_array = array(
"threads" => "+{$num_threads}",
"unapprovedthreads" => "-{$num_threads}",
"posts" => "+{$num_posts}",
"unapprovedposts" => "-{$num_posts}"
);
update_forum_counters($fid, $update_array);
}
|
return true;
}
| return true;
}
|
| Zeile 364 | Zeile 342 |
|---|
*/
function unapprove_threads($tids, $fid)
{
|
*/
function unapprove_threads($tids, $fid)
{
|
global $db, $cache;
| global $db, $cache, $plugins;
|
if(!is_array($tids))
{
|
if(!is_array($tids))
{
|
| Zeile 380 | Zeile 358 |
|---|
if($thread['visible'] == 1)
{
$num_threads++;
|
if($thread['visible'] == 1)
{
$num_threads++;
|
| | $num_posts += $thread['replies']+1; // Add implied invisible to count
|
}
$query = $db->query("
SELECT p.tid, f.usepostcounts, p.uid, p.visible
| }
$query = $db->query("
SELECT p.tid, f.usepostcounts, p.uid, p.visible
|
| Zeile 393 | Zeile 372 |
|---|
if($post['usepostcounts'] != "no")
{
$db->query("UPDATE ".TABLE_PREFIX."users SET postnum=postnum-1 WHERE uid='".$post['uid']."'");
|
if($post['usepostcounts'] != "no")
{
$db->query("UPDATE ".TABLE_PREFIX."users SET postnum=postnum-1 WHERE uid='".$post['uid']."'");
|
}
if($post['visible'] == 1)
{
$num_posts++;
}
}
}
$approve = array(
"visible" => 0,
);
| }
}
$posts_to_unapprove[] = $thread['firstpost'];
}
$approve = array(
"visible" => 0,
);
|
$db->update_query(TABLE_PREFIX."threads", $approve, "tid IN ($tid_list)");
|
$db->update_query(TABLE_PREFIX."threads", $approve, "tid IN ($tid_list)");
|
$db->update_query(TABLE_PREFIX."posts", $approve, "tid IN ($tid_list) AND replyto='0'", 1);
| $db->update_query(TABLE_PREFIX."posts", $approve, "pid IN (".implode(",", $posts_to_unapprove).")");
$plugins->run_hooks("class_moderation_unapprove_threads", $tids);
|
// Update stats
$update_array = array(
"threads" => "-{$num_threads}",
| // Update stats
$update_array = array(
"threads" => "-{$num_threads}",
|
| Zeile 415 | Zeile 393 |
|---|
"unapprovedposts" => "+{$num_posts}"
);
update_forum_counters($fid, $update_array);
|
"unapprovedposts" => "+{$num_posts}"
);
update_forum_counters($fid, $update_array);
|
|
|
return true;
}
| return true;
}
|
| Zeile 426 | Zeile 404 |
|---|
* @return boolean true
*/
function delete_post($pid)
|
* @return boolean true
*/
function delete_post($pid)
|
{
| {
|
global $db, $cache, $plugins;
// Get pid, uid, fid, tid, visibility, forum post count status of post
| global $db, $cache, $plugins;
// Get pid, uid, fid, tid, visibility, forum post count status of post
|
| Zeile 459 | Zeile 437 |
|---|
{
$num_approved_posts++;
}
|
{
$num_approved_posts++;
}
|
$plugins->run_hooks("delete_post", $post['pid']);
// Update stats
$update_array = array(
| $plugins->run_hooks("class_moderation_delete_post", $post['pid']);
// Update stats
$update_array = array(
|
"replies" => "-{$num_approved_posts}",
|
"replies" => "-{$num_approved_posts}",
|
"unapprovedposts" => "-{$num_unapproved_posts}"
);
| "unapprovedposts" => "-{$num_unapproved_posts}"
);
|
update_thread_counters($post['tid'], $update_array);
| update_thread_counters($post['tid'], $update_array);
|
| Zeile 472 | Zeile 451 |
|---|
$update_array = array(
"posts" => "-{$num_approved_posts}",
"unapprovedposts" => "-{$num_unapproved_posts}"
|
$update_array = array(
"posts" => "-{$num_approved_posts}",
"unapprovedposts" => "-{$num_unapproved_posts}"
|
);
| );
|
update_forum_counters($post['fid'], $update_array);
|
update_forum_counters($post['fid'], $update_array);
|
|
|
return true;
}
| return true;
}
|
| Zeile 488 | Zeile 467 |
|---|
*/
function merge_posts($pids, $tid, $sep="new_line")
{
|
*/
function merge_posts($pids, $tid, $sep="new_line")
{
|
global $db;
| global $db, $plugins;
|
|
|
$pidin = implode(",", $pids);
| $pidin = implode(",", array_map("intval", $pids));
|
$first = 1;
// Get the messages to be merged
$query = $db->query("
| $first = 1;
// Get the messages to be merged
$query = $db->query("
|
| Zeile 554 | Zeile 533 |
|---|
);
$db->update_query(TABLE_PREFIX."posts", $mergepost2, "pid IN($pidin)");
$db->update_query(TABLE_PREFIX."attachments", $mergepost2, "pid IN($pidin)");
|
);
$db->update_query(TABLE_PREFIX."posts", $mergepost2, "pid IN($pidin)");
$db->update_query(TABLE_PREFIX."attachments", $mergepost2, "pid IN($pidin)");
|
| |
$plugins->run_hooks("class_moderation_merge_posts", array("pids" => $pids, "tid" => $tid));
|
// Update stats
$update_array = array(
"replies" => "-{$num_approved_posts}",
"unapprovedposts" => "-{$num_unapproved_posts}"
|
// Update stats
$update_array = array(
"replies" => "-{$num_approved_posts}",
"unapprovedposts" => "-{$num_unapproved_posts}"
|
);
| );
|
update_thread_counters($tid, $update_array);
// Update stats
| update_thread_counters($tid, $update_array);
// Update stats
|
| Zeile 580 | Zeile 561 |
|---|
* @param string Method of movement (redirect, copy, move)
* @param int Expiry timestamp for redirect
* @return int Thread ID
|
* @param string Method of movement (redirect, copy, move)
* @param int Expiry timestamp for redirect
* @return int Thread ID
|
*/
| */
|
function move_thread($tid, $new_fid, $method="redirect", $redirect_expire=0)
{
global $db, $plugins;
| function move_thread($tid, $new_fid, $method="redirect", $redirect_expire=0)
{
global $db, $plugins;
|
| Zeile 594 | Zeile 575 |
|---|
switch($method)
{
case "redirect": // move (and leave redirect) thread
|
switch($method)
{
case "redirect": // move (and leave redirect) thread
|
$plugins->run_hooks("moderation_do_move_redirect");
| $plugins->run_hooks("class_moderation_move_thread_redirect", array("tid" => $tid, "new_fid" => $new_fid));
|
if($thread['visible'] == 1)
{
$num_threads++;
|
if($thread['visible'] == 1)
{
$num_threads++;
|
}
| }
|
else
{
|
else
{
|
$num_unapproved_threads++;
| $num_unapproved_threads++;
// Implied forum unapproved count for unapproved threads
$num_unapproved_posts = $thread['replies']+1;
|
}
$num_posts = $thread['replies']+1;
|
}
$num_posts = $thread['replies']+1;
|
$num_unapproved_posts = $thread['unapprovedposts'];
| $num_unapproved_posts += $thread['unapprovedposts'];
|
|
|
$db->delete_query(TABLE_PREFIX."threads", "closed='moved|$tid' AND fid='$moveto'");
| $db->delete_query(TABLE_PREFIX."threads", "closed='moved|$tid' AND fid='{$new_fid}'");
|
$changefid = array(
"fid" => $new_fid,
);
| $changefid = array(
"fid" => $new_fid,
);
|
| Zeile 616 | Zeile 599 |
|---|
$db->update_query(TABLE_PREFIX."posts", $changefid, "tid='$tid'");
$threadarray = array(
"fid" => $thread['fid'],
|
$db->update_query(TABLE_PREFIX."posts", $changefid, "tid='$tid'");
$threadarray = array(
"fid" => $thread['fid'],
|
"subject" => $db->escape_string($thread['subject']),
"icon" => $thread['icon'],
| "subject" => $db->escape_string($thread['subject']),
"icon" => $thread['icon'],
|
"uid" => $thread['uid'],
"username" => $db->escape_string($thread['username']),
"dateline" => $thread['dateline'],
| "uid" => $thread['uid'],
"username" => $db->escape_string($thread['username']),
"dateline" => $thread['dateline'],
|
| Zeile 656 | Zeile 639 |
|---|
"sticky" => $thread['sticky'],
"visible" => $thread['visible'],
"unapprovedposts" => $thread['unapprovedposts'],
|
"sticky" => $thread['sticky'],
"visible" => $thread['visible'],
"unapprovedposts" => $thread['unapprovedposts'],
|
| | "attachmentcount" => $thread['attachmentcount'],
|
"notes" => ''
);
|
"notes" => ''
);
|
| |
if($thread['visible'] == 1)
{
++$num_threads;
$num_posts = $thread['replies']+1;
// Fetch count of unapproved posts in this thread
$query = $db->simple_select(TABLE_PREFIX."posts", "COUNT(pid) AS unapproved", "tid='{$thread['tid']}' AND visible=0");
$num_unapproved_posts = $db->fetch_field($query, "unapproved");
}
else
{
$num_unapproved_threads++;
$num_unapproved_posts = $thread['replies']+1;
}
|
|
|
++$num_threads;
$plugins->run_hooks("moderation_do_move_copy");
| $plugins->run_hooks("class_moderation_copy_thread", array("tid" => $tid, "new_fid" => $new_fid));
|
$db->insert_query(TABLE_PREFIX."threads", $threadarray);
$newtid = $db->insert_id();
| $db->insert_query(TABLE_PREFIX."threads", $threadarray);
$newtid = $db->insert_id();
|
| Zeile 722 | Zeile 721 |
|---|
);
$db->insert_query(TABLE_PREFIX."posts", $post_array);
$pid = $db->insert_id();
|
);
$db->insert_query(TABLE_PREFIX."posts", $post_array);
$pid = $db->insert_id();
|
if($post['visible'] == 0)
{
$num_unapproved_posts++;
}
else if($post['visible'] == 1)
{
$num_posts++;
}
|
|
// Insert attachments for this post
$query2 = $db->simple_select(TABLE_PREFIX."attachments", "*", "pid = '{$post['pid']}'");
while($attachment = $db->fetch_array($query2))
| // Insert attachments for this post
$query2 = $db->simple_select(TABLE_PREFIX."attachments", "*", "pid = '{$post['pid']}'");
while($attachment = $db->fetch_array($query2))
|
| Zeile 758 | Zeile 748 |
|---|
break;
default:
case "move": // plain move thread
|
break;
default:
case "move": // plain move thread
|
$plugins->run_hooks("moderation_do_move_simple");
| $plugins->run_hooks("class_moderation_move_simple", array("tid" => $tid, "new_fid" => $new_fid));
|
if($thread['visible'] == 1)
{
|
if($thread['visible'] == 1)
{
|
| Zeile 767 | Zeile 757 |
|---|
else
{
$num_unapproved_threads++;
|
else
{
$num_unapproved_threads++;
|
| | // Implied forum unapproved count for unapproved threads
$num_unapproved_posts = $thread['replies']+1;
|
}
$num_posts = $thread['replies']+1;
| }
$num_posts = $thread['replies']+1;
|
| Zeile 852 | Zeile 844 |
|---|
*/
function merge_threads($mergetid, $tid, $subject)
{
|
*/
function merge_threads($mergetid, $tid, $subject)
{
|
global $db, $mybb, $mergethread, $thread;
| global $db, $mybb, $mergethread, $thread, $plugins;
$mergetid = intval($mergetid);
$tid = intval($tid);
|
if(!isset($mergethread['tid']) || $mergethread['tid'] != $mergetid)
|
if(!isset($mergethread['tid']) || $mergethread['tid'] != $mergetid)
|
{
$mergetid = intval($mergetid);
$query = $db->simple_select(TABLE_PREFIX."threads", "*", "tid='".intval($mergetid)."'");
$mergethread = $db->fetch_array($query);
}
| {
$mergethread = get_thread($mergetid);
}
|
if(!isset($thread['tid']) || $thread['tid'] != $tid)
|
if(!isset($thread['tid']) || $thread['tid'] != $tid)
|
{
$tid = intval($tid);
$query = $db->simple_select(TABLE_PREFIX."threads", "*", "tid='".intval($tid)."'");
$thread = $db->fetch_array($query);
| {
$thread = get_thread($tid);
|
}
$pollsql = '';
if($mergethread['poll'])
|
}
$pollsql = '';
if($mergethread['poll'])
|
{
$pollsql = ", poll='{$mergethread['poll']}'";
| {
$pollsql['poll'] = $mergethread['poll'];
|
$sqlarray = array(
"tid" => $tid,
);
| $sqlarray = array(
"tid" => $tid,
);
|
| Zeile 877 | Zeile 868 |
|---|
}
else
{
|
}
else
{
|
$query = $db->simple_select(TABLE_PREFIX."threads", "*", "poll='{$mergethread['poll']}' AND tid != '".intval($mergetid)."'");
| $query = $db->simple_select(TABLE_PREFIX."threads", "*", "poll='{$mergethread['poll']}' AND tid != '{$mergetid}'");
|
$pollcheck = $db->fetch_array($query);
if(!$pollcheck['poll'])
{
| $pollcheck = $db->fetch_array($query);
if(!$pollcheck['poll'])
{
|
| Zeile 894 | Zeile 885 |
|---|
"replyto" => 0
);
$db->update_query(TABLE_PREFIX."posts", $sqlarray, "tid='$mergetid'");
|
"replyto" => 0
);
$db->update_query(TABLE_PREFIX."posts", $sqlarray, "tid='$mergetid'");
|
$db->query("UPDATE ".TABLE_PREFIX."threads SET subject='$subject' $pollsql WHERE tid='$tid'");
$sqlarray = array(
|
$pollsql['subject'] = $subject;
$db->update_query(TABLE_PREFIX."threads", $pollsql, "tid='$tid'");
$sqlarray = array(
|
"closed" => "moved|$tid",
|
"closed" => "moved|$tid",
|
);
| );
|
$db->update_query(TABLE_PREFIX."threads", $sqlarray, "closed='moved|$mergetid'");
$sqlarray = array(
"tid" => $tid,
);
$db->update_query(TABLE_PREFIX."favorites", $sqlarray, "tid='$mergetid'");
update_first_post($tid);
|
$db->update_query(TABLE_PREFIX."threads", $sqlarray, "closed='moved|$mergetid'");
$sqlarray = array(
"tid" => $tid,
);
$db->update_query(TABLE_PREFIX."favorites", $sqlarray, "tid='$mergetid'");
update_first_post($tid);
|
|
$plugins->run_hooks("class_moderation_merge_threads", array("mergetid" => $tid, "tid" => $tid, "subject" => $subject));
|
$this->delete_thread($mergetid);
|
$this->delete_thread($mergetid);
|
$updated_stats = array(
"replies" => "+".($mergethread['replies']+1),
"unapprovedposts" => "+{$mergethread['unapprovedposts']}"
);
update_thread_counters($tid, $updated_stats);
$updated_stats = array(
"posts" => "+".($mergethread['replies']+1),
"unapprovedposts" => "+{$mergethread['unapprovedposts']}"
);
update_forum_counters($fid, $updated_stats);
| |
|
|
| | $updated_stats = array(
"replies" => '+'.($mergethread['replies']+1),
"unapprovedposts" => "+{$mergethread['unapprovedposts']}"
);
update_thread_counters($tid, $updated_stats);
// 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(
"unapprovedposts" => '+'.($mergethread['replies']+$mergethread['unapprovedposts'])
);
}
else
{
$updated_stats = array(
"posts" => '+'.($mergethread['replies']+1),
"unapprovedposts" => "+{$mergethread['unapprovedposts']}"
);
}
update_forum_counters($thread['fid'], $updated_stats);
}
|
return true;
}
| return true;
}
|
| Zeile 934 | Zeile 942 |
|---|
*/
function split_posts($pids, $tid, $moveto, $newsubject, $destination_tid=0)
{
|
*/
function split_posts($pids, $tid, $moveto, $newsubject, $destination_tid=0)
{
|
global $db, $thread;
| global $db, $thread, $plugins;
|
if(!isset($thread['tid']) || $thread['tid'] != $tid)
{
|
if(!isset($thread['tid']) || $thread['tid'] != $tid)
{
|
| Zeile 946 | Zeile 954 |
|---|
// Create the new thread
$newsubject = $db->escape_string($newsubject);
$query = array(
|
// Create the new thread
$newsubject = $db->escape_string($newsubject);
$query = array(
|
"fid" => $moveto,
| "fid" => intval($moveto),
|
"subject" => $newsubject,
|
"subject" => $newsubject,
|
"icon" => $thread['icon'],
"uid" => $thread['uid'],
"username" => $thread['username'],
"dateline" => $thread['dateline'],
"lastpost" => $thread['lastpost'],
"lastposter" => $thread['lastposter'],
| "icon" => intval($thread['icon']),
"uid" => intval($thread['uid']),
"username" => $db->escape_string($thread['username']),
"dateline" => intval($thread['dateline']),
"lastpost" => intval($thread['lastpost']),
"lastposter" => $db->escape_string($thread['lastposter']),
|
"replies" => count($pids)-1,
|
"replies" => count($pids)-1,
|
"visible" => "1",
| "visible" => 1,
|
"notes" => ''
);
$db->insert_query(TABLE_PREFIX."threads", $query);
| "notes" => ''
);
$db->insert_query(TABLE_PREFIX."threads", $query);
|
| Zeile 965 | Zeile 973 |
|---|
$pids_list = implode(",", $pids);
$sqlarray = array(
"tid" => $newtid,
|
$pids_list = implode(",", $pids);
$sqlarray = array(
"tid" => $newtid,
|
"fid" => $moveto,
"replyto" => 0
| "fid" => $moveto,
"replyto" => 0
|
);
$db->update_query(TABLE_PREFIX."posts", $sqlarray, "pid IN ($pids_list)");
| );
$db->update_query(TABLE_PREFIX."posts", $sqlarray, "pid IN ($pids_list)");
|
| Zeile 988 | Zeile 996 |
|---|
if($oldusepcounts == "yes" && $newusepcounts == "no")
{
$pcount = "-{$posters['posts']}";
|
if($oldusepcounts == "yes" && $newusepcounts == "no")
{
$pcount = "-{$posters['posts']}";
|
}
| }
|
elseif($oldusepcounts == "no" && $newusepcounts == "yes")
{
$pcount = "+{$posters['posts']}";
| elseif($oldusepcounts == "no" && $newusepcounts == "yes")
{
$pcount = "+{$posters['posts']}";
|
| Zeile 998 | Zeile 1006 |
|---|
{
$db->query("UPDATE ".TABLE_PREFIX."users SET postnum=postnum$pcount WHERE uid='{$posters['uid']}'");
}
|
{
$db->query("UPDATE ".TABLE_PREFIX."users SET postnum=postnum$pcount WHERE uid='{$posters['uid']}'");
}
|
}
$num_visible = $num_unnaproved = 0;
$query = $db->query("SELECT visible FROM ".TABLE_PREFIX."posts WHERE tid='{$newtid}'");
while($post = $db->fetch_array($query))
{
if($post['visible'] == 1)
{
$num_visible++;
}
else if($post['visible'] == 0)
{
$num_unapproved++;
}
| }
$num_visible = $num_unnaproved = $num_attachments = 0;
$query = $db->query("
SELECT p.visible, a.aid
FROM ".TABLE_PREFIX."posts p
LEFT JOIN ".TABLE_PREFIX."attachments a ON (a.pid=p.pid AND a.visible=1)
WHERE p.tid='{$newtid}'
");
while($post = $db->fetch_array($query))
{
if($post['visible'] == 1)
{
$num_visible++;
if($post['aid'])
{
$num_attachments++;
}
}
else if($post['visible'] == 0)
{
$num_unapproved++;
}
|
}
// Update the subject of the first post in the new thread
$query = $db->simple_select(TABLE_PREFIX."posts", "pid", "tid='$newtid'", array('order_by' => 'dateline', 'limit' => 1));
$newthread = $db->fetch_array($query);
|
}
// Update the subject of the first post in the new thread
$query = $db->simple_select(TABLE_PREFIX."posts", "pid", "tid='$newtid'", array('order_by' => 'dateline', 'limit' => 1));
$newthread = $db->fetch_array($query);
|
$sqlarray = array(
| $sqlarray = array(
|
"subject" => $newsubject,
|
"subject" => $newsubject,
|
"replyto" => 0
| "replyto" => 0
|
);
$db->update_query(TABLE_PREFIX."posts", $sqlarray, "pid='{$newthread['pid']}'");
|
);
$db->update_query(TABLE_PREFIX."posts", $sqlarray, "pid='{$newthread['pid']}'");
|
|
|
// Update the subject of the first post in the old thread
$query = $db->simple_select(TABLE_PREFIX."posts", "pid", "tid='$tid'", array('order_by' => 'dateline', 'limit' => 1));
$oldthread = $db->fetch_array($query);
| // Update the subject of the first post in the old thread
$query = $db->simple_select(TABLE_PREFIX."posts", "pid", "tid='$tid'", array('order_by' => 'dateline', 'limit' => 1));
$oldthread = $db->fetch_array($query);
|
| Zeile 1031 | Zeile 1048 |
|---|
"replyto" => 0
);
$db->update_query(TABLE_PREFIX."posts", $sqlarray, "pid='{$oldthread['pid']}'");
|
"replyto" => 0
);
$db->update_query(TABLE_PREFIX."posts", $sqlarray, "pid='{$oldthread['pid']}'");
|
| |
$plugins->run_hooks("class_moderation_split_posts", array("pids" => $pids, "tid" => $tid, "moveto" => $moveto, "newsubject" => $newsubject, "destination_tid" => $destination_tid));
|
// Update old thread stats
$update_array = array(
"replies" => "-{$num_visible}",
|
// Update old thread stats
$update_array = array(
"replies" => "-{$num_visible}",
|
"unapprovedposts" => "-{$num_unapproved}"
| "unapprovedposts" => "-{$num_unapproved}",
"attachmentcount" => "-{$num_attachments}"
|
);
update_thread_counters($thread['tid'], $update_array);
// Update new thread stats
$update_array = array(
"replies" => $num_visible-1,
|
);
update_thread_counters($thread['tid'], $update_array);
// Update new thread stats
$update_array = array(
"replies" => $num_visible-1,
|
"unapprovedposts" => $num_unapproved
| "unapprovedposts" => $num_unapproved,
"attachmentcount" => $num_attachments
|
);
update_thread_counters($newtid, $update_array);
| );
update_thread_counters($newtid, $update_array);
|
| Zeile 1062 | Zeile 1083 |
|---|
);
}
else
|
);
}
else
|
{
| {
|
$update_array = array();
}
| $update_array = array();
}
|
| Zeile 1098 | Zeile 1119 |
|---|
*/
function move_threads($tids, $moveto)
{
|
*/
function move_threads($tids, $moveto)
{
|
global $db;
| global $db, $plugins;
|
$tid_list = implode(",", $tids);
|
$tid_list = implode(",", $tids);
|
| Zeile 1111 | Zeile 1132 |
|---|
$forum = get_forum($thread['fid']);
$total_posts += $thread['replies']+1;
|
$forum = get_forum($thread['fid']);
$total_posts += $thread['replies']+1;
|
$total_unapproved_posts += $thread['unapproved_posts'];
$forum_counters[$thread['fid']] = array(
"posts" => $forum_counters[$thread['fid']]['posts']+$thread['replies']+1,
"unapprovedposts" => $forum_counters[$thread['fid']]['posts']+$thread['unapprovedposts']
);
| $total_unapproved_posts += $thread['unapprovedposts'];
$forum_counters[$thread['fid']]['posts'] += $thread['replies']+1;
$forum_counters[$thread['fid']]['unapprovedposts'] += $thread['unapprovedposts'];
|
if($thread['visible'] == 1)
|
if($thread['visible'] == 1)
|
{
| {
|
$forum_counters[$thread['fid']]['threads']++;
++$total_threads;
}
else
{
$forum_counters[$thread['fid']]['unapprovedthreads']++;
|
$forum_counters[$thread['fid']]['threads']++;
++$total_threads;
}
else
{
$forum_counters[$thread['fid']]['unapprovedthreads']++;
|
| | $forum_counters[$thread['fid']]['unapprovedposts'] += $thread['replies']; // Implied unapproved posts counter for unapproved threads
|
++$total_unapproved_threads;
}
|
++$total_unapproved_threads;
}
|
$query = $db->query("
| $query1 = $db->query("
|
SELECT COUNT(p.pid) AS posts, u.uid
FROM ".TABLE_PREFIX."posts p
LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=p.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)
|
| Zeile 1136 | Zeile 1157 |
|---|
GROUP BY u.uid
ORDER BY posts DESC
");
|
GROUP BY u.uid
ORDER BY posts DESC
");
|
while($posters = $db->fetch_array($query))
| while($posters = $db->fetch_array($query1))
|
{
if($method == "copy" && $newforum['usepostcounts'] != "no" && $posters['visible'] != "no")
{
| {
if($method == "copy" && $newforum['usepostcounts'] != "no" && $posters['visible'] != "no")
{
|
| Zeile 1154 | Zeile 1175 |
|---|
if(!empty($pcount))
{
$db->query("UPDATE ".TABLE_PREFIX."users SET postnum=postnum$pcount WHERE uid='{$posters['uid']}'");
|
if(!empty($pcount))
{
$db->query("UPDATE ".TABLE_PREFIX."users SET postnum=postnum$pcount WHERE uid='{$posters['uid']}'");
|
}
| }
|
}
}
|
}
}
|
|
|
$sqlarray = array(
"fid" => $moveto,
);
$db->update_query(TABLE_PREFIX."threads", $sqlarray, "tid IN ($tid_list)");
$db->update_query(TABLE_PREFIX."posts", $sqlarray, "tid IN ($tid_list)");
|
$sqlarray = array(
"fid" => $moveto,
);
$db->update_query(TABLE_PREFIX."threads", $sqlarray, "tid IN ($tid_list)");
$db->update_query(TABLE_PREFIX."posts", $sqlarray, "tid IN ($tid_list)");
|
| |
$plugins->run_hooks("class_moderation_move_threads", array("tids" => $tids, "moveto" => $moveto));
|
foreach($forum_counters as $fid => $counter)
{
$updated_count = array(
"posts" => "-{$counter['posts']}",
|
foreach($forum_counters as $fid => $counter)
{
$updated_count = array(
"posts" => "-{$counter['posts']}",
|
"unapprovedposts" => "-{$counter['unapproved_posts']}"
| "unapprovedposts" => "-{$counter['unapprovedposts']}"
|
);
if($counter['threads'])
{
| );
if($counter['threads'])
{
|
| Zeile 1194 | Zeile 1217 |
|---|
// Remove thread subscriptions for the users who no longer have permission to view the thread
$this->remove_thread_subscriptions($tid_list, false, $moveto);
|
// Remove thread subscriptions for the users who no longer have permission to view the thread
$this->remove_thread_subscriptions($tid_list, false, $moveto);
|
return true;
}
| return true;
}
|
/**
* Approve multiple posts
*
* @param array PIDs
|
/**
* Approve multiple posts
*
* @param array PIDs
|
* @param int Thread ID
* @param int Forum ID
| |
* @return boolean true
*/
|
* @return boolean true
*/
|
function approve_posts($pids, $tid, $fid)
| function approve_posts($pids)
|
{
global $db, $cache;
|
{
global $db, $cache;
|
$thread = get_thread($tid);
| |
$num_posts = 0;
|
$num_posts = 0;
|
foreach($pids as $pid)
{
$query = $db->query("
SELECT p.tid, f.usepostcounts, p.uid, p.visible
FROM ".TABLE_PREFIX."posts p
LEFT JOIN ".TABLE_PREFIX."forums f ON (f.fid=p.fid)
WHERE p.pid='{$pid}' AND p.visible = '0'
");
while($post = $db->fetch_array($query))
{
// If post counts enabled in this forum and the post hasn't already been approved, add 1
if($post['usepostcounts'] != "no")
{
$db->query("UPDATE ".TABLE_PREFIX."users SET postnum=postnum+1 WHERE uid='".$post['uid']."'");
}
++$num_posts;
}
}
$where = "pid IN (".implode(",", $pids).")";
| $pid_list = implode(",", $pids);
$pids = array();
|
// Make visible
$approve = array(
"visible" => 1,
|
// Make visible
$approve = array(
"visible" => 1,
|
);
$db->update_query(TABLE_PREFIX."posts", $approve, $where);
$is_first = false;
// If this is the first post of the thread, also approve the thread
$query = $db->simple_select(TABLE_PREFIX."posts", "tid, pid", "pid='{$thread['firstpost']}' AND visible='1'");
$first_post = $db->fetch_array($query);
if($first_post['tid'])
{
if(in_array($first_post['pid'], $pids))
{
$is_first = true;
$db->update_query(TABLE_PREFIX."threads", $approve, "tid='{$first_post['tid']}'");
}
}
if($is_first)
{
$updated_thread_stats['replies'] = "+".($num_posts-1);
}
else
{
$updated_thread_stats['replies'] = "+{$num_posts}";
| );
$query = $db->query("
SELECT p.pid, p.tid, f.fid, f.usepostcounts, p.uid, p.visible, t.visible AS threadvisible, t.replies AS threadreplies, t.firstpost AS threadfirstpost, t.unapprovedposts AS threadunapprovedposts
FROM ".TABLE_PREFIX."posts p
LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=p.tid)
LEFT JOIN ".TABLE_PREFIX."forums f ON (f.fid=p.fid)
WHERE p.pid IN ($pid_list) AND p.visible = '0'
");
while($post = $db->fetch_array($query))
{
// If post counts enabled in this forum and the post hasn't already been approved, add 1
if($post['usepostcounts'] != "no" && $thread['visible'] == 1)
{
$db->query("UPDATE ".TABLE_PREFIX."users SET postnum=postnum+1 WHERE uid='".$post['uid']."'");
}
$pids[] = $post['pid'];
if(!$thread_counters[$post['tid']]['unapprovedposts'])
{
$thread_counters[$post['tid']]['unapprovedposts'] = $post['threadunapprovedposts'];
}
--$thread_counters[$post['tid']]['unapprovedposts'];
if($post['threadfirstpost'] != $post['pid'])
{
if(!$thread_counters[$post['tid']]['replies'])
{
$thread_counters[$post['tid']]['replies'] = $post['threadreplies'];
}
++$thread_counters[$post['tid']]['replies'];
}
// Only add to the forum count if the thread is invisible
if($post['threadvisible'] == 0)
{
++$forum_counters[$post['fid']]['num_posts'];
}
// If the first post here matches and thread is invisible, we approve the thread too
if($post['threadfirstpost'] == $post['pid'] && $post['threadvisible'] == 0)
{
$thread_counters[$post['tid']]['visible'] = 1;
$thread_counters[$post['tid']]['unapprovedposts'] += 1;
$forum_counters[$post['fid']]['num_posts'] += $post['threadreplies'];
$forum_counters[$post['fid']]['num_threads']++;
}
}
if(!count($pids)) return false;
$where = "pid IN (".implode(",", $pids).")";
$db->update_query(TABLE_PREFIX."posts", $approve, $where);
if(is_array($thread_counters))
{
foreach($thread_counters as $tid => $counters)
{
$db->update_query(TABLE_PREFIX."threads", $counters, "tid='{$tid}'");
}
}
if(is_array($forum_counters))
{
foreach($forum_counters as $fid => $counters)
{
$updated_forum_stats = array(
"posts" => "+{$counters['num_posts']}",
"unapprovedposts" => "-{$counters['num_posts']}",
"threads" => "+{$counters['num_threads']}",
"unapprovedthreads" => "-{$counters['num_threads']}"
);
update_forum_counters($fid, $updated_forum_stats);
}
|
}
|
}
|
$updated_thread_stats['unapprovedposts'] = "-".$num_posts;
update_thread_counters($tid, $updated_thread_stats);
$updated_forum_stats = array(
"posts" => "+{$num_posts}",
"unapprovedposts" => "-{$num_posts}"
);
if($is_first)
{
$updated_forum_stats['threads'] = "+1";
$updated_forum_stats['unapprovedthreads'] = "-1";
}
update_forum_counters($fid, $updated_forum_stats);
| |
return true;
}
| return true;
}
|
| Zeile 1281 | Zeile 1321 |
|---|
* Unapprove multiple posts
*
* @param array PIDs
|
* Unapprove multiple posts
*
* @param array PIDs
|
* @param int Thread ID
* @param int Forum ID
| |
* @return boolean true
*/
|
* @return boolean true
*/
|
function unapprove_posts($pids, $tid, $fid)
| function unapprove_posts($pids)
|
{
global $db, $cache;
|
{
global $db, $cache;
|
| |
$pid_list = implode(",", $pids);
$pids = array();
// Make invisible
$approve = array(
"visible" => 0,
);
|
|
|
$thread = get_thread($tid);
$num_posts = 0;
foreach($pids as $pid)
| $query = $db->query("
SELECT p.pid, p.tid, f.fid, f.usepostcounts, p.uid, p.visible, t.visible AS threadvisible, t.replies AS threadreplies, t.firstpost AS threadfirstpost, t.unapprovedposts AS threadunapprovedposts
FROM ".TABLE_PREFIX."posts p
LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=p.tid)
LEFT JOIN ".TABLE_PREFIX."forums f ON (f.fid=p.fid)
WHERE p.pid IN ($pid_list) AND p.visible = '1'
");
while($post = $db->fetch_array($query))
|
{
|
{
|
$query = $db->query("
SELECT p.tid, f.usepostcounts, p.uid
FROM ".TABLE_PREFIX."posts p
LEFT JOIN ".TABLE_PREFIX."forums f ON (f.fid=p.fid)
WHERE p.pid='{$pid}' AND p.visible = '1'
");
while($post = $db->fetch_array($query))
| // If post counts enabled in this forum and the post hasn't already been unapproved, subtract 1
if($post['usepostcounts'] != "no" && $thread['visible'] == 1)
|
{
|
{
|
// If post counts enabled in this forum and the post hasn't already been unapproved, remove 1
if($post['usepostcounts'] != "no")
| $db->query("UPDATE ".TABLE_PREFIX."users SET postnum=postnum-1 WHERE uid='".$post['uid']."'");
}
$pids[] = $post['pid'];
if(!$thread_counters[$post['tid']]['unapprovedposts'])
{
$thread_counters[$post['tid']]['unapprovedposts'] = $post['threadunapprovedposts'];
}
++$thread_counters[$post['tid']]['unapprovedposts'];
if($post['threadfirstpost'] != $post['pid'])
{
if(!$thread_counters[$post['tid']]['replies'])
|
{
|
{
|
$db->query("UPDATE ".TABLE_PREFIX."users SET postnum=postnum-1 WHERE uid='".$post['uid']."'");
| $thread_counters[$post['tid']]['replies'] = $post['threadreplies'];
|
}
|
}
|
$num_posts++;
| $thread_counters[$post['tid']]['replies'] = $thread_counters[$post['tid']]['replies']-1;
}
if($post['threadvisible'] == 1)
{
++$forum_counters[$post['fid']]['num_posts'];
}
// If the first post here matches and thread is visible, we unapprove the thread too
if($post['threadfirstpost'] == $post['pid'] && $post['threadvisible'] == 1)
{
$thread_counters[$post['tid']]['visible'] = 0;
$thread_counters[$post['tid']]['unapprovedposts'] -= 1;
$forum_counters[$post['fid']]['num_posts'] += $post['threadreplies'];
$forum_counters[$post['fid']]['num_threads']++;
|
}
}
|
}
}
|
$where = "pid IN (".implode(",", $pids).")";
| if(!count($pids)) return false;
|
|
|
// Make visible
$unapprove = array(
"visible" => 0,
);
$db->update_query(TABLE_PREFIX."posts", $unapprove, $where);
| $where = "pid IN (".implode(",", $pids).")";
$db->update_query(TABLE_PREFIX."posts", $approve, $where);
|
|
|
$is_first = false;
// If this is the first post of the thread, also approve the thread
$query = $db->simple_select(TABLE_PREFIX."posts", "tid,pid", "pid='{$thread['firstpost']}' AND visible='0'");
$first_post = $db->fetch_array($query);
if($first_post['tid'])
| if(is_array($thread_counters))
{
foreach($thread_counters as $tid => $counters)
{
$db->update_query(TABLE_PREFIX."threads", $counters, "tid='{$tid}'");
}
}
if(is_array($forum_counters))
|
{
|
{
|
if(in_array($first_post['pid'], $pids))
{
$is_first = true;
$db->update_query(TABLE_PREFIX."threads", $unapprove, "tid='{$first_post['tid']}'");
| foreach($forum_counters as $fid => $counters)
{
$updated_forum_stats = array(
"posts" => "-{$counters['num_posts']}",
"unapprovedposts" => "+{$counters['num_posts']}",
"threads" => "-{$counters['num_threads']}",
"unapprovedthreads" => "+{$counters['num_threads']}"
);
update_forum_counters($fid, $updated_forum_stats);
|
}
}
|
}
}
|
$updated_thread_stats = array(
"unapprovedposts" => "+{$num_posts}"
);
if($is_first)
{
$updated_thread_stats['replies'] = "-".($num_posts-1);
}
else
{
$updated_thread_stats['replies'] = "-{$num_posts}";
}
update_thread_counters($tid, $updated_thread_stats);
$updated_forum_stats = array(
"posts" => "-{$num_posts}",
"unapprovedposts" => "+{$num_posts}"
);
if($is_first)
{
$updated_forum_stats['threads'] = "-1";
$updated_forum_stats['unapprovedthreads'] = "+1";
}
update_forum_counters($fid, $updated_forum_stats);
| |
return true;
}
| return true;
}
|
| Zeile 1368 | Zeile 1420 |
|---|
*/
function change_thread_subject($tids, $format)
{
|
*/
function change_thread_subject($tids, $format)
{
|
global $db;
| global $db, $plugins;
|
// Get tids into list
if(!is_array($tids))
|
// Get tids into list
if(!is_array($tids))
|
| Zeile 1387 | Zeile 1439 |
|---|
);
$db->update_query(TABLE_PREFIX."threads", $new_subject, "tid='{$thread['tid']}'", 1);
$db->update_query(TABLE_PREFIX."posts", $new_subject, "tid='{$thread['tid']}' AND replyto='0'", 1);
|
);
$db->update_query(TABLE_PREFIX."threads", $new_subject, "tid='{$thread['tid']}'", 1);
$db->update_query(TABLE_PREFIX."posts", $new_subject, "tid='{$thread['tid']}' AND replyto='0'", 1);
|
| |
$lastpost_subject = array(
"lastpostsubject" => $new_subject['subject']
);
$db->update_query(TABLE_PREFIX."forums", $lastpost_subject, "lastposttid='{$thread['tid']}'");
|
}
|
}
|
|
$plugins->run_hooks("class_moderation_change_thread_subject", array("tids" => $tids, "format" => $format));
|
return true;
}
| return true;
}
|
| Zeile 1401 | Zeile 1461 |
|---|
*/
function expire_thread($tid, $deletetime)
{
|
*/
function expire_thread($tid, $deletetime)
{
|
global $db;
| global $db, $plugins;
|
$update_thread = array(
"deletetime" => intval($deletetime)
);
$db->update_query(TABLE_PREFIX."threads", $update_thread, "tid='{$tid}'");
|
$update_thread = array(
"deletetime" => intval($deletetime)
);
$db->update_query(TABLE_PREFIX."threads", $update_thread, "tid='{$tid}'");
|
return true;
|
$plugins->run_hooks("class_moderation_expire_thread", array("tid" => $tid, "deletetime" => $deletetime));
return true;
|
}
/**
* Toggle post visibility (approved/unapproved)
*
* @param array Post IDs
|
}
/**
* Toggle post visibility (approved/unapproved)
*
* @param array Post IDs
|
* @param int Thread ID
* @param int Forum ID
| |
* @return boolean true
*/
|
* @return boolean true
*/
|
function toggle_post_visibility($pids, $tid, $fid)
| function toggle_post_visibility($pids)
|
{
global $db;
$pid_list = implode(',', $pids);
| {
global $db;
$pid_list = implode(',', $pids);
|
| Zeile 1429 | Zeile 1489 |
|---|
if($post['visible'] == 1)
{
$unapprove[] = $post['pid'];
|
if($post['visible'] == 1)
{
$unapprove[] = $post['pid'];
|
}
else
| }
else
|
{
$approve[] = $post['pid'];
}
}
if(is_array($unapprove))
{
|
{
$approve[] = $post['pid'];
}
}
if(is_array($unapprove))
{
|
$this->unapprove_posts($unapprove, $tid, $fid);
| $this->unapprove_posts($unapprove);
|
}
if(is_array($approve))
{
|
}
if(is_array($approve))
{
|
$this->approve_posts($approve, $tid, $fid);
| $this->approve_posts($approve);
|
}
return true;
}
| }
return true;
}
|
| Zeile 1472 | Zeile 1532 |
|---|
if(is_array($unapprove))
{
$this->unapprove_threads($unapprove, $fid);
|
if(is_array($unapprove))
{
$this->unapprove_threads($unapprove, $fid);
|
}
if(is_array($approve))
{
| }
if(is_array($approve))
{
|
$this->approve_threads($approve, $fid);
}
return true;
| $this->approve_threads($approve, $fid);
}
return true;
|
| Zeile 1520 | Zeile 1580 |
|---|
* @param int $fid (Only applies if $all is false) The forum ID of the thread (if 0, will query database)
* @return boolean true
*/
|
* @param int $fid (Only applies if $all is false) The forum ID of the thread (if 0, will query database)
* @return boolean true
*/
|
function remove_thread_subscriptions($tids,$all = true, $fid = 0)
| function remove_thread_subscriptions($tids, $all = true, $fid = 0)
|
{
|
{
|
global $db;
| global $db, $plugins;
|
// Format thread IDs
if(!is_array($tids))
{
| // Format thread IDs
if(!is_array($tids))
{
|
| Zeile 1538 | Zeile 1598 |
|---|
if(!$fid)
{
$query = $db->simple_select(TABLE_PREFIX."threads", "fid", "tid='{$tid[0]}'");
|
if(!$fid)
{
$query = $db->simple_select(TABLE_PREFIX."threads", "fid", "tid='{$tid[0]}'");
|
}
| }
|
// Get groups that cannot view the forum or its threads
$forum_parentlist = get_parent_list($fid);
|
// Get groups that cannot view the forum or its threads
$forum_parentlist = get_parent_list($fid);
|
| Zeile 1553 | Zeile 1613 |
|---|
if(count($groups) > 0)
{
$groups_csv = implode(',', $groups);
|
if(count($groups) > 0)
{
$groups_csv = implode(',', $groups);
|
$db->query("DELETE s FROM (".TABLE_PREFIX."favorites s, ".TABLE_PREFIX."users u) WHERE s.type='s' AND s.tid IN ({$tids_csv}) AND s.uid=u.uid AND (u.usergroup IN ({$groups_csv}){$additional_groups})");
| $query = $db->query("
SELECT s.tid, u.uid
FROM ".TABLE_PREFIX."favorites s
LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=s.uid)
WHERE s.type='s' AND s.tid IN ({$tids_csv})
AND (u.usergroup IN ({$groups_csv}){$additional_groups})
");
while($favorites = $db->fetch_array($query))
{
$db->query("DELETE FROM ".TABLE_PREFIX."favorites WHERE uid='{$favorites['uid']}' AND tid='{$favorites['tid']}'");
}
|
}
|
}
|
}
| }
|
// Delete all subscriptions of this thread
else
{
$db->delete_query(TABLE_PREFIX."favorites", "tid IN ({$tids_csv}) AND type='s'");
}
|
// Delete all subscriptions of this thread
else
{
$db->delete_query(TABLE_PREFIX."favorites", "tid IN ({$tids_csv}) AND type='s'");
}
|
| |
$plugins->run_hooks("class_moderation_remove_thread_subscriptions", array("tids" => $tids, "all" => $all, "fid" => $fid));
|
return true;
}
|
return true;
}
|