Please make sure IN_MYBB is defined.");
}
$page->add_breadcrumb_item($lang->recount_rebuild, "index.php?module=tools-recount_rebuild");
$plugins->run_hooks("admin_tools_recount_rebuild");
function acp_rebuild_forum_counters()
{
global $db, $mybb, $lang;
$query = $db->simple_select("forums", "COUNT(*) as num_forums");
$num_forums = $db->fetch_field($query, 'num_forums');
$page = intval($mybb->input['page']);
$per_page = intval($mybb->input['forumcounters']);
$start = ($page-1) * $per_page;
$end = $start + $per_page;
$query = $db->simple_select("forums", "fid", '', array('order_by' => 'fid', 'order_dir' => 'asc', 'limit_start' => $start, 'limit' => $per_page));
while($forum = $db->fetch_array($query))
{
$update['parentlist'] = make_parent_list($forum['fid']);
$db->update_query("forums", $update, "fid='{$forum['fid']}'");
rebuild_forum_counters($forum['fid']);
}
check_proceed($num_forums, $end, ++$page, $per_page, "forumcounters", "do_rebuildforumcounters", $lang->success_rebuilt_forum_counters);
}
function acp_rebuild_thread_counters()
{
global $db, $mybb, $lang;
$query = $db->simple_select("threads", "COUNT(*) as num_threads");
$num_threads = $db->fetch_field($query, 'num_threads');
$page = intval($mybb->input['page']);
$per_page = intval($mybb->input['threadcounters']);
$start = ($page-1) * $per_page;
$end = $start + $per_page;
$query = $db->simple_select("threads", "tid", '', array('order_by' => 'tid', 'order_dir' => 'asc', 'limit_start' => $start, 'limit' => $per_page));
while($thread = $db->fetch_array($query))
{
rebuild_thread_counters($thread['tid']);
}
check_proceed($num_threads, $end, ++$page, $per_page, "threadcounters", "do_rebuildthreadcounters", $lang->success_rebuilt_thread_counters);
}
function acp_recount_user_posts()
{
global $db, $mybb, $lang;
$query = $db->simple_select("users", "COUNT(uid) as num_users");
$num_users = $db->fetch_field($query, 'num_users');
$page = intval($mybb->input['page']);
$per_page = intval($mybb->input['userposts']);
$start = ($page-1) * $per_page;
$end = $start + $per_page;
$query = $db->simple_select("forums", "fid", "usepostcounts = 0");
while($forum = $db->fetch_array($query))
{
$fids[] = $forum['fid'];
}
if(is_array($fids))
{
$fids = implode(',', $fids);
}
if($fids)
{
$fids = " AND p.fid NOT IN($fids)";
}
else
{
$fids = "";
}
$query = $db->simple_select("users", "uid", '', array('order_by' => 'uid', 'order_dir' => 'asc', 'limit_start' => $start, 'limit' => $per_page));
while($user = $db->fetch_array($query))
{
$query2 = $db->query("
SELECT COUNT(p.pid) AS post_count
FROM ".TABLE_PREFIX."posts p
LEFT JOIN ".TABLE_PREFIX."threads t ON (t.tid=p.tid)
WHERE p.uid='{$user['uid']}' AND t.visible > 0 AND p.visible > 0{$fids}
");
$num_posts = $db->fetch_field($query2, "post_count");
$db->update_query("users", array("postnum" => intval($num_posts)), "uid='{$user['uid']}'");
}
check_proceed($num_users, $end, ++$page, $per_page, "userposts", "do_recountuserposts", $lang->success_rebuilt_user_counters);
}
function acp_rebuild_attachment_thumbnails()
{
global $db, $mybb, $lang;
$query = $db->simple_select("attachments", "COUNT(aid) as num_attachments");
$num_attachments = $db->fetch_field($query, 'num_attachments');
$page = intval($mybb->input['page']);
$per_page = intval($mybb->input['attachmentthumbs']);
$start = ($page-1) * $per_page;
$end = $start + $per_page;
require_once MYBB_ROOT."inc/functions_image.php";
$query = $db->simple_select("attachments", "*", '', array('order_by' => 'aid', 'order_dir' => 'asc', 'limit_start' => $start, 'limit' => $per_page));
while($attachment = $db->fetch_array($query))
{
$ext = my_strtolower(my_substr(strrchr($attachment['filename'], "."), 1));
if($ext == "gif" || $ext == "png" || $ext == "jpg" || $ext == "jpeg" || $ext == "jpe")
{
$thumbname = str_replace(".attach", "_thumb.$ext", $attachment['attachname']);
$thumbnail = generate_thumbnail(MYBB_ROOT."uploads/".$attachment['attachname'], MYBB_ROOT."uploads/", $thumbname, $mybb->settings['attachthumbh'], $mybb->settings['attachthumbw']);
if($thumbnail['code'] == 4)
{
$thumbnail['filename'] = "SMALL";
}
$db->update_query("attachments", array("thumbnail" => $thumbnail['filename']), "aid='{$attachment['aid']}'");
}
}
check_proceed($num_attachments, $end, ++$page, $per_page, "attachmentthumbs", "do_rebuildattachmentthumbs", $lang->success_rebuilt_attachment_thumbnails);
}
function check_proceed($current, $finish, $next_page, $per_page, $name, $name2, $message)
{
global $page, $lang, $plugins;
if($finish >= $current)
{
flash_message($message, 'success');
admin_redirect("index.php?module=tools-recount_rebuild");
}
else
{
$page->output_header();
$form = new Form("index.php?module=tools-recount_rebuild", 'post');
echo $form->generate_hidden_field("page", $next_page);
echo $form->generate_hidden_field($name, $per_page);
echo $form->generate_hidden_field($name2, $lang->go);
echo "\n";
echo "
{$lang->confirm_proceed_rebuild}
\n";
echo "
\n";
echo "";
echo "
\n";
echo $form->generate_submit_button($lang->proceed, array('class' => 'button_yes', 'id' => 'proceed_button'));
echo "
\n";
echo "
{$lang->rebuild_forum_counters_desc}
");
$form_container->output_cell($form->generate_text_box("forumcounters", 50, array('style' => 'width: 150px;')));
$form_container->output_cell($form->generate_submit_button($lang->go, array("name" => "do_rebuildforumcounters")));
$form_container->construct_row();
$form_container->output_cell("{$lang->rebuild_thread_counters_desc}
");
$form_container->output_cell($form->generate_text_box("threadcounters", 500, array('style' => 'width: 150px;')));
$form_container->output_cell($form->generate_submit_button($lang->go, array("name" => "do_rebuildthreadcounters")));
$form_container->construct_row();
$form_container->output_cell("{$lang->recount_user_posts_desc}
");
$form_container->output_cell($form->generate_text_box("userposts", 500, array('style' => 'width: 150px;')));
$form_container->output_cell($form->generate_submit_button($lang->go, array("name" => "do_recountuserposts")));
$form_container->construct_row();
$form_container->output_cell("{$lang->rebuild_attachment_thumbs_desc}
");
$form_container->output_cell($form->generate_text_box("attachmentthumbs", 20, array('style' => 'width: 150px;')));
$form_container->output_cell($form->generate_submit_button($lang->go, array("name" => "do_rebuildattachmentthumbs")));
$form_container->construct_row();
$form_container->output_cell("{$lang->recount_stats_desc}
");
$form_container->output_cell($lang->na);
$form_container->output_cell($form->generate_submit_button($lang->go, array("name" => "do_recountstats")));
$form_container->construct_row();
$plugins->run_hooks("admin_tools_recount_rebuild_output_list");
$form_container->end();
$form->end();
$page->output_footer();
}
?>