| Zeile 30 | Zeile 30 |
|---|
$page = $mybb->get_input('page', MyBB::INPUT_INT);
$per_page = $mybb->get_input('forumcounters', MyBB::INPUT_INT);
|
$page = $mybb->get_input('page', MyBB::INPUT_INT);
$per_page = $mybb->get_input('forumcounters', MyBB::INPUT_INT);
|
if($per_page <= 0)
{
$per_page = 50;
}
|
|
$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))
|
$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);
|
$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);
|
}
| }
|
/**
* Rebuild thread counters
*/
function acp_rebuild_thread_counters()
|
/**
* Rebuild thread counters
*/
function acp_rebuild_thread_counters()
|
{
| {
|
global $db, $mybb, $lang;
$query = $db->simple_select("threads", "COUNT(*) as num_threads");
| global $db, $mybb, $lang;
$query = $db->simple_select("threads", "COUNT(*) as num_threads");
|
| Zeile 60 | Zeile 57 |
|---|
$page = $mybb->get_input('page', MyBB::INPUT_INT);
$per_page = $mybb->get_input('threadcounters', MyBB::INPUT_INT);
|
$page = $mybb->get_input('page', MyBB::INPUT_INT);
$per_page = $mybb->get_input('threadcounters', MyBB::INPUT_INT);
|
if($per_page <= 0)
{
$per_page = 500;
}
|
|
$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))
|
$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']);
}
|
rebuild_thread_counters($thread['tid']);
}
|
|
|
check_proceed($num_threads, $end, ++$page, $per_page, "threadcounters", "do_rebuildthreadcounters", $lang->success_rebuilt_thread_counters);
}
|
check_proceed($num_threads, $end, ++$page, $per_page, "threadcounters", "do_rebuildthreadcounters", $lang->success_rebuilt_thread_counters);
}
|
|
|
/**
* Rebuild poll counters
*/
function acp_rebuild_poll_counters()
{
global $db, $mybb, $lang;
|
/**
* Rebuild poll counters
*/
function acp_rebuild_poll_counters()
{
global $db, $mybb, $lang;
|
|
|
$query = $db->simple_select("polls", "COUNT(*) as num_polls");
$num_polls = $db->fetch_field($query, 'num_polls');
$page = $mybb->get_input('page', MyBB::INPUT_INT);
$per_page = $mybb->get_input('pollcounters', MyBB::INPUT_INT);
|
$query = $db->simple_select("polls", "COUNT(*) as num_polls");
$num_polls = $db->fetch_field($query, 'num_polls');
$page = $mybb->get_input('page', MyBB::INPUT_INT);
$per_page = $mybb->get_input('pollcounters', MyBB::INPUT_INT);
|
if($per_page <= 0)
{
$per_page = 500;
}
|
|
$start = ($page-1) * $per_page;
$end = $start + $per_page;
| $start = ($page-1) * $per_page;
$end = $start + $per_page;
|
| Zeile 116 | Zeile 107 |
|---|
$page = $mybb->get_input('page', MyBB::INPUT_INT);
$per_page = $mybb->get_input('userposts', MyBB::INPUT_INT);
|
$page = $mybb->get_input('page', MyBB::INPUT_INT);
$per_page = $mybb->get_input('userposts', MyBB::INPUT_INT);
|
if($per_page <= 0)
{
$per_page = 500;
}
|
|
$start = ($page-1) * $per_page;
$end = $start + $per_page;
| $start = ($page-1) * $per_page;
$end = $start + $per_page;
|
| Zeile 170 | Zeile 158 |
|---|
$page = $mybb->get_input('page', MyBB::INPUT_INT);
$per_page = $mybb->get_input('userthreads', MyBB::INPUT_INT);
|
$page = $mybb->get_input('page', MyBB::INPUT_INT);
$per_page = $mybb->get_input('userthreads', MyBB::INPUT_INT);
|
if($per_page <= 0)
{
$per_page = 500;
}
|
|
$start = ($page-1) * $per_page;
$end = $start + $per_page;
| $start = ($page-1) * $per_page;
$end = $start + $per_page;
|
| Zeile 191 | Zeile 176 |
|---|
$fids = " AND t.fid NOT IN($fids)";
}
else
|
$fids = " AND t.fid NOT IN($fids)";
}
else
|
{
| {
|
$fids = "";
}
| $fids = "";
}
|
| Zeile 210 | Zeile 195 |
|---|
check_proceed($num_users, $end, ++$page, $per_page, "userthreads", "do_recountuserthreads", $lang->success_rebuilt_user_thread_counters);
}
|
check_proceed($num_users, $end, ++$page, $per_page, "userthreads", "do_recountuserthreads", $lang->success_rebuilt_user_thread_counters);
}
|
|
|
/**
* Recount reputation values
*/
| /**
* Recount reputation values
*/
|
| Zeile 223 | Zeile 208 |
|---|
$page = $mybb->get_input('page', MyBB::INPUT_INT);
$per_page = $mybb->get_input('reputation', MyBB::INPUT_INT);
|
$page = $mybb->get_input('page', MyBB::INPUT_INT);
$per_page = $mybb->get_input('reputation', MyBB::INPUT_INT);
|
if($per_page <= 0)
{
$per_page = 500;
}
$start = ($page-1) * $per_page;
$end = $start + $per_page;
$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))
{
|
$start = ($page-1) * $per_page;
$end = $start + $per_page;
$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 SUM(reputation) as total_rep
FROM ".TABLE_PREFIX."reputation
|
$query2 = $db->query("
SELECT SUM(reputation) as total_rep
FROM ".TABLE_PREFIX."reputation
|
WHERE `uid`='{$user['uid']}'
| WHERE uid='{$user['uid']}'
|
");
$total_rep = $db->fetch_field($query2, "total_rep");
| ");
$total_rep = $db->fetch_field($query2, "total_rep");
|
| Zeile 250 | Zeile 232 |
|---|
* Recount warnings for users
*/
function acp_recount_warning()
|
* Recount warnings for users
*/
function acp_recount_warning()
|
{
global $db, $mybb, $lang;
$query = $db->simple_select("users", "COUNT(uid) as num_users");
$num_users = $db->fetch_field($query, 'num_users');
| {
global $db, $mybb, $lang;
$query = $db->simple_select("users", "COUNT(uid) as num_users");
$num_users = $db->fetch_field($query, 'num_users');
|
$page = $mybb->get_input('page', MyBB::INPUT_INT);
$per_page = $mybb->get_input('warning', MyBB::INPUT_INT);
|
$page = $mybb->get_input('page', MyBB::INPUT_INT);
$per_page = $mybb->get_input('warning', MyBB::INPUT_INT);
|
if($per_page <= 0)
{
$per_page = 500;
}
|
|
$start = ($page-1) * $per_page;
|
$start = ($page-1) * $per_page;
|
$end = $start + $per_page;
| $end = $start + $per_page;
|
$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))
|
$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))
|
| Zeile 277 | Zeile 256 |
|---|
$db->update_query("users", array("warningpoints" => (int)$warn_lev), "uid='{$user['uid']}'");
}
|
$db->update_query("users", array("warningpoints" => (int)$warn_lev), "uid='{$user['uid']}'");
}
|
|
|
check_proceed($num_users, $end, ++$page, $per_page, "warning", "do_recountwarning", $lang->success_rebuilt_warning);
}
|
check_proceed($num_users, $end, ++$page, $per_page, "warning", "do_recountwarning", $lang->success_rebuilt_warning);
}
|
|
|
/**
* Recount private messages (total and unread) for users
*/
function acp_recount_private_messages()
|
/**
* Recount private messages (total and unread) for users
*/
function acp_recount_private_messages()
|
{
global $db, $mybb, $lang;
$query = $db->simple_select("users", "COUNT(uid) as num_users");
$num_users = $db->fetch_field($query, 'num_users');
| {
global $db, $mybb, $lang;
$query = $db->simple_select("users", "COUNT(uid) as num_users");
$num_users = $db->fetch_field($query, 'num_users');
|
$page = $mybb->get_input('page', MyBB::INPUT_INT);
$per_page = $mybb->get_input('privatemessages', MyBB::INPUT_INT);
|
$page = $mybb->get_input('page', MyBB::INPUT_INT);
$per_page = $mybb->get_input('privatemessages', MyBB::INPUT_INT);
|
if($per_page <= 0)
{
$per_page = 500;
}
|
|
$start = ($page-1) * $per_page;
$end = $start + $per_page;
| $start = ($page-1) * $per_page;
$end = $start + $per_page;
|
| Zeile 354 | Zeile 330 |
|---|
$page = $mybb->get_input('page', MyBB::INPUT_INT);
$per_page = $mybb->get_input('threadrating', MyBB::INPUT_INT);
|
$page = $mybb->get_input('page', MyBB::INPUT_INT);
$per_page = $mybb->get_input('threadrating', MyBB::INPUT_INT);
|
if($per_page <= 0)
{
$per_page = 500;
}
|
|
$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))
|
$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))
|
{
| {
|
$query2 = $db->query("
SELECT COUNT(tid) as num_ratings, SUM(rating) as total_rating
FROM ".TABLE_PREFIX."threadratings
WHERE tid='{$thread['tid']}'
");
$recount = $db->fetch_array($query2);
|
$query2 = $db->query("
SELECT COUNT(tid) as num_ratings, SUM(rating) as total_rating
FROM ".TABLE_PREFIX."threadratings
WHERE tid='{$thread['tid']}'
");
$recount = $db->fetch_array($query2);
|
|
|
$db->update_query("threads", array("numratings" => (int)$recount['num_ratings'], "totalratings" => (int)$recount['total_rating']), "tid='{$thread['tid']}'");
}
| $db->update_query("threads", array("numratings" => (int)$recount['num_ratings'], "totalratings" => (int)$recount['total_rating']), "tid='{$thread['tid']}'");
}
|
| Zeile 389 | Zeile 362 |
|---|
$page = $mybb->get_input('page', MyBB::INPUT_INT);
$per_page = $mybb->get_input('attachmentthumbs', MyBB::INPUT_INT);
|
$page = $mybb->get_input('page', MyBB::INPUT_INT);
$per_page = $mybb->get_input('attachmentthumbs', MyBB::INPUT_INT);
|
if($per_page <= 0)
{
$per_page = 20;
}
|
|
$start = ($page-1) * $per_page;
$end = $start + $per_page;
| $start = ($page-1) * $per_page;
$end = $start + $per_page;
|
| Zeile 417 | Zeile 387 |
|---|
$thumbnail['filename'] = "SMALL";
}
$db->update_query("attachments", array("thumbnail" => $thumbnail['filename']), "aid='{$attachment['aid']}'");
|
$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);
}
|
check_proceed($num_attachments, $end, ++$page, $per_page, "attachmentthumbs", "do_rebuildattachmentthumbs", $lang->success_rebuilt_attachment_thumbnails);
}
|
| Zeile 446 | Zeile 416 |
|---|
$page->output_header();
$form = new Form("index.php?module=tools-recount_rebuild", 'post');
|
$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 "<div class=\"confirm_action\">\n";
echo "<p>{$lang->confirm_proceed_rebuild}</p>\n";
echo "<br />\n";
|
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 "<div class=\"confirm_action\">\n";
echo "<p>{$lang->confirm_proceed_rebuild}</p>\n";
echo "<br />\n";
|
echo "<script type=\"text/javascript\">$(function() { var button = $(\"#proceed_button\"); if(button.length > 0) { button.val(\"{$lang->automatically_redirecting}\"); button.attr(\"disabled\", true); button.css(\"color\", \"#aaa\"); button.css(\"borderColor\", \"#aaa\"); document.forms[0].submit(); }})</script>";
| echo "<script type=\"text/javascript\">
$(function() {
var button = $(\"#proceed_button\");
if(button.length > 0) {
button.val(\"{$lang->automatically_redirecting}\");
button.attr(\"disabled\", true);
button.css(\"color\", \"#aaa\");
button.css(\"borderColor\", \"#aaa\");
var parent_form = button.closest('form');
if (parent_form.length > 0) {
parent_form.submit();
}
}
});
</script>";
|
echo "<p class=\"buttons\">\n";
echo $form->generate_submit_button($lang->proceed, array('class' => 'button_yes', 'id' => 'proceed_button'));
echo "</p>\n";
| echo "<p class=\"buttons\">\n";
echo $form->generate_submit_button($lang->proceed, array('class' => 'button_yes', 'id' => 'proceed_button'));
echo "</p>\n";
|
| Zeile 469 | Zeile 455 |
|---|
if(!$mybb->input['action'])
{
$plugins->run_hooks("admin_tools_recount_rebuild_start");
|
if(!$mybb->input['action'])
{
$plugins->run_hooks("admin_tools_recount_rebuild_start");
|
|
|
if($mybb->request_method == "post")
{
require_once MYBB_ROOT."inc/functions_rebuild.php";
|
if($mybb->request_method == "post")
{
require_once MYBB_ROOT."inc/functions_rebuild.php";
|
|
|
if(!isset($mybb->input['page']) || $mybb->get_input('page', MyBB::INPUT_INT) < 1)
{
$mybb->input['page'] = 1;
|
if(!isset($mybb->input['page']) || $mybb->get_input('page', MyBB::INPUT_INT) < 1)
{
$mybb->input['page'] = 1;
|
}
| }
$plugins->run_hooks("admin_tools_do_recount_rebuild");
|
if(isset($mybb->input['do_rebuildforumcounters']))
{
$plugins->run_hooks("admin_tools_recount_rebuild_forum_counters");
|
if(isset($mybb->input['do_rebuildforumcounters']))
{
$plugins->run_hooks("admin_tools_recount_rebuild_forum_counters");
|
if($mybb->input['page'] == 1)
{
|
if($mybb->input['page'] == 1)
{
|
// Log admin action
log_admin_action("forum");
|
// Log admin action
log_admin_action("forum");
|
}
if(!$mybb->get_input('forumcounters', MyBB::INPUT_INT))
{
$mybb->input['forumcounters'] = 50;
}
| }
$per_page = $mybb->get_input('forumcounters', MyBB::INPUT_INT);
if(!$per_page || $per_page <= 0)
{
$mybb->input['forumcounters'] = 50;
}
|
acp_rebuild_forum_counters();
}
elseif(isset($mybb->input['do_rebuildthreadcounters']))
|
acp_rebuild_forum_counters();
}
elseif(isset($mybb->input['do_rebuildthreadcounters']))
|
{
$plugins->run_hooks("admin_tools_recount_rebuild_thread_counters");
| {
$plugins->run_hooks("admin_tools_recount_rebuild_thread_counters");
|
if($mybb->input['page'] == 1)
{
// Log admin action
log_admin_action("thread");
|
if($mybb->input['page'] == 1)
{
// Log admin action
log_admin_action("thread");
|
}
if(!$mybb->get_input('threadcounters', MyBB::INPUT_INT))
{
$mybb->input['threadcounters'] = 500;
| }
$per_page = $mybb->get_input('threadcounters', MyBB::INPUT_INT);
if(!$per_page || $per_page <= 0)
{
$mybb->input['threadcounters'] = 500;
|
}
acp_rebuild_thread_counters();
}
elseif(isset($mybb->input['do_recountuserposts']))
|
}
acp_rebuild_thread_counters();
}
elseif(isset($mybb->input['do_recountuserposts']))
|
{
$plugins->run_hooks("admin_tools_recount_rebuild_user_posts");
| {
$plugins->run_hooks("admin_tools_recount_rebuild_user_posts");
|
if($mybb->input['page'] == 1)
{
// Log admin action
log_admin_action("userposts");
}
|
if($mybb->input['page'] == 1)
{
// Log admin action
log_admin_action("userposts");
}
|
if(!$mybb->get_input('userposts', MyBB::INPUT_INT))
|
$per_page = $mybb->get_input('userposts', MyBB::INPUT_INT);
if(!$per_page || $per_page <= 0)
|
{
$mybb->input['userposts'] = 500;
}
| {
$mybb->input['userposts'] = 500;
}
|
| Zeile 536 | Zeile 530 |
|---|
// Log admin action
log_admin_action("userthreads");
}
|
// Log admin action
log_admin_action("userthreads");
}
|
if(!$mybb->get_input('userthreads', MyBB::INPUT_INT))
|
$per_page = $mybb->get_input('userthreads', MyBB::INPUT_INT);
if(!$per_page || $per_page <= 0)
|
{
$mybb->input['userthreads'] = 500;
}
| {
$mybb->input['userthreads'] = 500;
}
|
| Zeile 553 | Zeile 549 |
|---|
log_admin_action("attachmentthumbs");
}
|
log_admin_action("attachmentthumbs");
}
|
if(!$mybb->get_input('attachmentthumbs', MyBB::INPUT_INT))
| $per_page = $mybb->get_input('attachmentthumbs', MyBB::INPUT_INT);
if(!$per_page || $per_page <= 0)
|
{
$mybb->input['attachmentthumbs'] = 500;
}
| {
$mybb->input['attachmentthumbs'] = 500;
}
|
| Zeile 570 | Zeile 567 |
|---|
log_admin_action("reputation");
}
|
log_admin_action("reputation");
}
|
if(!$mybb->get_input('reputation', MyBB::INPUT_INT))
| $per_page = $mybb->get_input('reputation', MyBB::INPUT_INT);
if(!$per_page || $per_page <= 0)
|
{
$mybb->input['reputation'] = 500;
}
| {
$mybb->input['reputation'] = 500;
}
|
| Zeile 587 | Zeile 585 |
|---|
log_admin_action("warning");
}
|
log_admin_action("warning");
}
|
if(!$mybb->get_input('warning', MyBB::INPUT_INT))
| $per_page = $mybb->get_input('warning', MyBB::INPUT_INT);
if(!$per_page || $per_page <= 0)
|
{
$mybb->input['warning'] = 500;
}
| {
$mybb->input['warning'] = 500;
}
|
| Zeile 604 | Zeile 603 |
|---|
log_admin_action("privatemessages");
}
|
log_admin_action("privatemessages");
}
|
if(!$mybb->get_input('privatemessages', MyBB::INPUT_INT))
| $per_page = $mybb->get_input('privatemessages', MyBB::INPUT_INT);
if(!$per_page || $per_page <= 0)
|
{
$mybb->input['privatemessages'] = 500;
}
| {
$mybb->input['privatemessages'] = 500;
}
|
| Zeile 621 | Zeile 621 |
|---|
log_admin_action("referral");
}
|
log_admin_action("referral");
}
|
if(!$mybb->get_input('referral', MyBB::INPUT_INT))
| $per_page = $mybb->get_input('referral', MyBB::INPUT_INT);
if(!$per_page || $per_page <= 0)
|
{
$mybb->input['referral'] = 500;
}
| {
$mybb->input['referral'] = 500;
}
|
| Zeile 638 | Zeile 639 |
|---|
log_admin_action("threadrating");
}
|
log_admin_action("threadrating");
}
|
if(!$mybb->get_input('threadrating', MyBB::INPUT_INT))
| $per_page = $mybb->get_input('threadrating', MyBB::INPUT_INT);
if(!$per_page || $per_page <= 0)
|
{
$mybb->input['threadrating'] = 500;
}
| {
$mybb->input['threadrating'] = 500;
}
|
| Zeile 655 | Zeile 657 |
|---|
log_admin_action("poll");
}
|
log_admin_action("poll");
}
|
if(!$mybb->get_input('pollcounters', MyBB::INPUT_INT))
| $per_page = $mybb->get_input('pollcounters', MyBB::INPUT_INT);
if(!$per_page || $per_page <= 0)
|
{
$mybb->input['pollcounters'] = 500;
}
| {
$mybb->input['pollcounters'] = 500;
}
|