Vergleich admin/modules/tools/recount_rebuild.php - 1.8.16 - 1.8.21

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
Zeile 30Zeile 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 60Zeile 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 116Zeile 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 170Zeile 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 191Zeile 176
		$fids = " AND t.fid NOT IN($fids)";
}
else

		$fids = " AND t.fid NOT IN($fids)";
}
else

	{

	{

		$fids = "";
}


		$fids = "";
}


Zeile 210Zeile 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 223Zeile 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
WHERE uid='{$user['uid']}'
");
$total_rep = $db->fetch_field($query2, "total_rep");

		$query2 = $db->query("
SELECT SUM(reputation) as total_rep
FROM ".TABLE_PREFIX."reputation
WHERE uid='{$user['uid']}'
");
$total_rep = $db->fetch_field($query2, "total_rep");





		$db->update_query("users", array("reputation" => (int)$total_rep), "uid='{$user['uid']}'");
}

		$db->update_query("users", array("reputation" => (int)$total_rep), "uid='{$user['uid']}'");
}





	check_proceed($num_users, $end, ++$page, $per_page, "reputation", "do_recountreputation", $lang->success_rebuilt_reputation);

	check_proceed($num_users, $end, ++$page, $per_page, "reputation", "do_recountreputation", $lang->success_rebuilt_reputation);

}

/**

}

/**

 * 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");

{
global $db, $mybb, $lang;

$query = $db->simple_select("users", "COUNT(uid) as num_users");

	$num_users = $db->fetch_field($query, '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 277Zeile 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;

require_once MYBB_ROOT."inc/functions_user.php";


$start = ($page-1) * $per_page;
$end = $start + $per_page;

require_once MYBB_ROOT."inc/functions_user.php";





$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))
{
update_pm_count($user['uid']);


$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))
{
update_pm_count($user['uid']);

	}


	}


	check_proceed($num_users, $end, ++$page, $per_page, "privatemessages", "do_recountprivatemessages", $lang->success_rebuilt_private_messages);
}


	check_proceed($num_users, $end, ++$page, $per_page, "privatemessages", "do_recountprivatemessages", $lang->success_rebuilt_private_messages);
}


Zeile 315Zeile 291
 * Recount referrals for users
*/
function acp_recount_referrals()

 * Recount referrals for users
*/
function acp_recount_referrals()

{

{

	global $db, $mybb, $lang;

$query = $db->simple_select("users", "COUNT(uid) as num_users");

	global $db, $mybb, $lang;

$query = $db->simple_select("users", "COUNT(uid) as num_users");

Zeile 351Zeile 327

$query = $db->simple_select("threads", "COUNT(*) as num_threads");
$num_threads = $db->fetch_field($query, 'num_threads');


$query = $db->simple_select("threads", "COUNT(*) as num_threads");
$num_threads = $db->fetch_field($query, 'num_threads');


$page = $mybb->get_input('page', MyBB::INPUT_INT);


$page = $mybb->get_input('page', MyBB::INPUT_INT);

	$per_page = $mybb->get_input('threadrating', 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 389Zeile 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 417Zeile 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 446Zeile 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 469Zeile 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 536Zeile 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 553Zeile 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 570Zeile 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 587Zeile 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 604Zeile 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 621Zeile 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 638Zeile 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 655Zeile 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;
}