Vergleich install/resources/upgrade5.php - 1.8.1 - 1.8.37

  Keine Änderungen   Hinzugefügt   Modifiziert   Entfernt
Zeile 531Zeile 531
	}
else
{

	}
else
{

		require_once MYBB_ROOT."inc/functions_rebuild.php";


 
		$query = $db->simple_select("threads", "COUNT(*) as num_threads", "closed NOT LIKE 'moved|%'");
$num_threads = $db->fetch_field($query, 'num_threads');
$tpp = (int)$_POST['tpp'];
$start = (int)$_POST['start'];
$end = $start+$tpp;
if($end > $num_threads)

		$query = $db->simple_select("threads", "COUNT(*) as num_threads", "closed NOT LIKE 'moved|%'");
$num_threads = $db->fetch_field($query, 'num_threads');
$tpp = (int)$_POST['tpp'];
$start = (int)$_POST['start'];
$end = $start+$tpp;
if($end > $num_threads)

		{

		{

			$end = $num_threads;
}
echo "<p>Updating {$start} to {$end} of {$num_threads}...</p>";


			$end = $num_threads;
}
echo "<p>Updating {$start} to {$end} of {$num_threads}...</p>";


		$query = $db->simple_select("threads", "tid, firstpost", "closed NOT LIKE 'moved|%'", array("order_by" => "tid", "order_dir" => "asc", "limit" => $tpp, "limit_start" => $start));


		$query = $db->simple_select("threads", "tid, firstpost", "closed NOT LIKE 'moved|%'", array("order_by" => "tid", "order_dir" => "asc", "limit" => $tpp, "limit_start" => $start));


		while($thread = $db->fetch_array($query))
{

		while($thread = $db->fetch_array($query))
{

			rebuild_thread_counters($thread['tid']);






















			$recount_thread = get_thread($thread['tid']);
$count = array();

$query = $db->simple_select("posts", "COUNT(pid) AS replies", "tid='{$thread['tid']}' AND pid!='{$recount_thread['firstpost']}' AND visible='1'");
$count['replies'] = $db->fetch_field($query, "replies");

// Unapproved posts
$query = $db->simple_select("posts", "COUNT(pid) AS unapprovedposts", "tid='{$thread['tid']}' AND pid != '{$recount_thread['firstpost']}' AND visible='0'");
$count['unapprovedposts'] = $db->fetch_field($query, "unapprovedposts");

// Attachment count
$query = $db->query("
SELECT COUNT(aid) AS attachment_count
FROM ".TABLE_PREFIX."attachments a
LEFT JOIN ".TABLE_PREFIX."posts p ON (a.pid=p.pid)
WHERE p.tid='{$thread['tid']}' AND a.visible=1
");
$count['attachmentcount'] = $db->fetch_field($query, "attachment_count");

$db->update_query("threads", $count, "tid='{$thread['tid']}'");
update_thread_data($thread['tid']);


			if($thread['firstpost'] == 0)
{
update_first_post($thread['tid']);

			if($thread['firstpost'] == 0)
{
update_first_post($thread['tid']);