Code Duplication    Length = 14-19 lines in 2 locations

Sources/Subs-Post.php 1 location

@@ 2428-2441 (lines=14) @@
2425
		);
2426
2427
	// ... finally the boards...
2428
	foreach ($board_changes as $id => $changes)
2429
		$smcFunc['db_query']('', '
2430
			UPDATE {db_prefix}boards
2431
			SET num_posts = num_posts + {int:num_posts}, unapproved_posts = unapproved_posts + {int:unapproved_posts},
2432
				num_topics = num_topics + {int:num_topics}, unapproved_topics = unapproved_topics + {int:unapproved_topics}
2433
			WHERE id_board = {int:id_board}',
2434
			array(
2435
				'num_posts' => $changes['posts'],
2436
				'unapproved_posts' => $changes['unapproved_posts'],
2437
				'num_topics' => $changes['topics'],
2438
				'unapproved_topics' => $changes['unapproved_topics'],
2439
				'id_board' => $id,
2440
			)
2441
		);
2442
2443
	// Finally, least importantly, notifications!
2444
	if ($approve)

Sources/SplitTopics.php 1 location

@@ 1604-1622 (lines=19) @@
1601
	}
1602
1603
	// Cycle through each board...
1604
	foreach ($boardTotals as $id_board => $stats)
1605
	{
1606
		$smcFunc['db_query']('', '
1607
			UPDATE {db_prefix}boards
1608
			SET
1609
				num_topics = CASE WHEN {int:topics} > num_topics THEN 0 ELSE num_topics - {int:topics} END,
1610
				unapproved_topics = CASE WHEN {int:unapproved_topics} > unapproved_topics THEN 0 ELSE unapproved_topics - {int:unapproved_topics} END,
1611
				num_posts = CASE WHEN {int:posts} > num_posts THEN 0 ELSE num_posts - {int:posts} END,
1612
				unapproved_posts = CASE WHEN {int:unapproved_posts} > unapproved_posts THEN 0 ELSE unapproved_posts - {int:unapproved_posts} END
1613
			WHERE id_board = {int:id_board}',
1614
			array(
1615
				'id_board' => $id_board,
1616
				'topics' => $stats['topics'],
1617
				'unapproved_topics' => $stats['unapproved_topics'],
1618
				'posts' => $stats['posts'],
1619
				'unapproved_posts' => $stats['unapproved_posts'],
1620
			)
1621
		);
1622
	}
1623
1624
	// Determine the board the final topic resides in
1625
	$request = $smcFunc['db_query']('', '