elkarte / Elkarte

 * @param int $id_msg

 * @param bool $include_count = true if true, it also returns the attachments count

 */

function attachmentsSizeForMessage($id_msg, $include_count = true)

{

	$db = database();

	if ($include_count)

	{

		$request = $db->query('', '

			SELECT COUNT(*), SUM(size)

			FROM {db_prefix}attachments

			WHERE id_msg = {int:id_msg}

				AND attachment_type = {int:attachment_type}',

			array(

				'id_msg' => $id_msg,

				'attachment_type' => 0,

			)

		);

	}

	else

	{

		$request = $db->query('', '

			SELECT COUNT(*)

			FROM {db_prefix}attachments

			WHERE id_msg = {int:id_msg}

				AND attachment_type = {int:attachment_type}',

			array(

				'id_msg' => $id_msg,

				'attachment_type' => 0,

			)

		);

	}

	$size = $db->fetch_row($request);

	$db->free_result($request);

	return $size;

}

/**

 * This loads an attachment's contextual data including, most importantly, its size if it is an image.

 * @param int $board_id

 * @param int|null $topic_id

 */

function boardInfo($board_id, $topic_id = null)

{

	$db = database();

	if (!empty($topic_id))

	{

		$request = $db->query('', '

			SELECT b.count_posts, b.name, m.subject

			FROM {db_prefix}boards AS b

				INNER JOIN {db_prefix}topics AS t ON (t.id_topic = {int:current_topic})

				INNER JOIN {db_prefix}messages AS m ON (m.id_msg = t.id_first_msg)

			WHERE {query_see_board}

				AND b.id_board = {int:board}

				AND b.redirect = {string:blank_redirect}

			LIMIT 1',

			array(

				'current_topic' => $topic_id,

				'board' => $board_id,

				'blank_redirect' => '',

			)

		);

	}

	else

	{

		$request = $db->query('', '

			SELECT b.count_posts, b.name

			FROM {db_prefix}boards AS b

			WHERE {query_see_board}

				AND b.id_board = {int:board}

				AND b.redirect = {string:blank_redirect}

			LIMIT 1',

			array(

				'board' => $board_id,

				'blank_redirect' => '',

			)

		);

	}

	$returns = $db->fetch_assoc($request);

	$db->free_result($request);

	return $returns;

}

/**

 * Loads properties from non-standard groups