phpbbgallery\core\album\manage::delete_album_content()

Complexity

Conditions	7
Paths	24

Size

Total Lines	92
Code Lines	49

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	56

Importance

Changes	1
Bugs	0	Features	0

<?php
	public function delete_album_content($album_id)
	{
		$album_id = (int) $album_id;

		// Before we remove anything we make sure we are able to adjust the image counts later. ;)
		$sql = 'SELECT image_user_id
			FROM ' . $this->images_table . ' 
			WHERE image_album_id = ' . (int) $album_id . '
				AND image_status <> ' . (int) \phpbbgallery\core\block::STATUS_UNAPPROVED . '
				AND image_status <> ' . (int) \phpbbgallery\core\block::STATUS_ORPHAN;
		$result = $this->db->sql_query($sql);

		$image_counts = array();
		while ($row = $this->db->sql_fetchrow($result))
		{
			$image_counts[$row['image_user_id']] = (!empty($image_counts[$row['image_user_id']])) ? $image_counts[$row['image_user_id']] + 1 : 1;
		}
		$this->db->sql_freeresult($result);

		$sql = 'SELECT image_id, image_filename, image_album_id
			FROM ' . $this->images_table . ' 
			WHERE image_album_id = ' . (int) $album_id;
		$result = $this->db->sql_query($sql);

		$filenames = $deleted_images = array();
		while ($row = $this->db->sql_fetchrow($result))
		{
			$deleted_images[] = $row['image_id'];
			$filenames[(int) $row['image_id']] = $row['image_filename'];
		}
		$this->db->sql_freeresult($result);

		if (!empty($deleted_images))
		{
			$this->gallery_image->delete_images($deleted_images, $filenames);
		}

		// Lucifer TODO: Log Gallery deletion from log
		//$sql = 'DELETE FROM ' . LOG_TABLE . "
		//	WHERE album_id = $album_id
		//		AND log_type = " . LOG_GALLERY;
		//$db->sql_query($sql);

		//@todo: merge queries into loop
		$sql = 'DELETE FROM ' . $this->permissions_table . ' 
			WHERE perm_album_id = ' . (int) $album_id;
		$this->db->sql_query($sql);
		$sql = 'DELETE FROM ' . $this->contests_table . ' 
			WHERE contest_album_id = ' . (int) $album_id;
		$this->db->sql_query($sql);

		$sql = 'DELETE FROM ' . $this->moderators_table . ' 
			WHERE album_id = ' . (int) $album_id;
		$this->db->sql_query($sql);

		$this->gallery_notification->delete_albums($album_id);

		// Adjust users image counts
		if (!empty($image_counts))
		{
			foreach ($image_counts as $image_user_id => $subtract)
			{
				$this->gallery_user->set_user_id($image_user_id);
				$this->gallery_user->update_images((0 - $subtract));
			}
		}

		// Make sure the overall image & comment count is correct...
		$sql = 'SELECT COUNT(image_id) AS num_images, SUM(image_comments) AS num_comments
			FROM ' . $this->images_table . '  
			WHERE image_status <> ' . (int) \phpbbgallery\core\block::STATUS_UNAPPROVED . '
				AND image_status <> ' . (int) \phpbbgallery\core\block::STATUS_ORPHAN;
		$result = $this->db->sql_query($sql);
		$row = $this->db->sql_fetchrow($result);
		$this->db->sql_freeresult($result);

		$this->gallery_config->set('num_images', $row['num_images']);
		$this->gallery_config->set('num_comments', (int) $row['num_comments']);

		/**
		* Event delete album content
		*
		* @event phpbbgallery.core.album.manage.delete_album_content
		* @var	int	album_id		Album we are deleting
		* @since 1.2.0
		*/
		$vars = array('album_id');
		extract($this->dispatcher->trigger_event('phpbbgallery.core.album.manage.delete_album_content', compact($vars)));

		$this->gallery_cache->destroy_albums();

		return array();
	}