decreaseLikeCounts()

Complexity

Conditions	10
Paths	34

Size

Total Lines	90
Code Lines	32

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	12
CRAP Score	25.6155

Importance

Changes

0

<?php
function decreaseLikeCounts($messages)
{
	$db = database();

	// Start off with no changes
	$update_given = [];
	$update_received = [];

	// Only a single message
	if (is_numeric($messages))
	{
		$messages = [$messages];
	}

	// Load the members who liked and who posted for this group of messages
	$posters = [];
	$likers = [];
	$db->fetchQuery('
		SELECT
			id_member, id_poster
		FROM {db_prefix}message_likes
		WHERE id_msg IN ({array_int:messages})',
		[
			'messages' => $messages,
		]
	)->fetch_callback(
		function ($row) use (&$posters, &$likers) {
			// Track how many likes each member gave and how many were received
			$posters[$row['id_poster']] = isset($posters[$row['id_poster']]) ? $posters[$row['id_poster']]++ : 1;
			$likers[$row['id_member']] = isset($likers[$row['id_member']]) ? $likers[$row['id_member']]++ : 1;
		}
	);

	// No one?
	if (empty($posters) && empty($likers))
	{
		return;
	}

	// Re-count the "likes given" totals for the likers
	if (!empty($likers))
	{
		$db->fetchQuery('
			SELECT
				COUNT(id_msg) AS likes, id_member
			FROM {db_prefix}message_likes
			WHERE id_member IN ({array_int:members})
			GROUP BY id_member',
			[
				'members' => array_keys($likers),
			]
		)->fetch_callback(
			function ($row) use (&$update_given, $likers) {
				// All who liked these messages have their "likes given" reduced
				$update_given[$row['id_member']] = $row['likes'] - $likers[$row['id_member']];
			}
		);
	}

	// Count the "likes received" totals for the message posters
	if (!empty($posters))
	{
		$db->fetchQuery('
			SELECT
				COUNT(id_msg) AS likes, id_poster
			FROM {db_prefix}message_likes
			WHERE id_poster IN ({array_int:members})
			GROUP BY id_poster',
			[
				'members' => array_keys($posters),
			]
		)->fetch_callback(
			function ($row) use (&$update_received, $posters) {
				// The message posters have their "likes received" reduced
				$update_received[$row['id_poster']] = $row['likes'] - $posters[$row['id_poster']];
			}
		);
	}

	// Update the totals for these members
	require_once(SUBSDIR . '/Members.subs.php');

	foreach ($update_given as $id_member => $total)
	{
		updateMemberData($id_member, ['likes_given' => (int) $total]);
	}

	foreach ($update_received as $id_member => $total)
	{
		updateMemberData($id_member, ['likes_received' => (int) $total]);
	}