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

Complexity

Conditions	6
Paths	14

Size

Total Lines	95
Code Lines	56

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	42

Importance

Changes

0

<?php
	public function move_album($from_id, $to_id)
	{
		$to_data = $moved_ids = $errors = array();

The assignment to $moved_ids is dead and can be removed.

The assignment to $to_data is dead and can be removed.

		// Get the parent data
		if ($to_id > 0)
		{
			$to_data = $this->gallery_album->get_info($to_id);
		}

		$moved_albums = $this->gallery_display->get_branch($this->user_id, $from_id, 'children', 'descending');
	//	var_dump($moved_albums);
		$from_data = $moved_albums[0];

		$diff = sizeof($moved_albums) * 2;

		$moved_ids = array();
		for ($i = 0, $end = sizeof($moved_albums); $i < $end; ++$i)
		{
			// Can not select child as parent
			if ($moved_albums[$i]['album_id'] == $to_id)
			{
				return array($this->language->lang('ALBUM_PARENT_INVALID'));
			}
			$moved_ids[] = $moved_albums[$i]['album_id'];
		}

		// Resync parents
		$sql = 'UPDATE ' . $this->albums_table . " 
			SET right_id = right_id - $diff, album_parents = ''
			WHERE album_user_id = " . (int) $this->user_id . '
				AND left_id < ' . (int) $from_data['right_id'] . "
				AND right_id > " . (int) $from_data['right_id'];
		$this->db->sql_query($sql);

		// Resync right-hand side of tree
		$sql = 'UPDATE ' . $this->albums_table . " 
			SET left_id = left_id - $diff, right_id = right_id - $diff, album_parents = ''
			WHERE album_user_id = " . (int) $this->user_id . '
				AND left_id > ' . (int) $from_data['right_id'];
		$this->db->sql_query($sql);

		if ($to_id > 0)
		{
			// Retrieve $to_data again, it may have been changed...
			$to_data = $this->gallery_album->get_info($to_id);

			// Resync new parents
			$sql = 'UPDATE ' . $this->albums_table . " 
				SET right_id = right_id + $diff, album_parents = ''
				WHERE album_user_id = " . (int) $this->user_id . '
					AND ' . (int) $to_data['right_id'] . ' BETWEEN left_id AND right_id
					AND ' . $this->db->sql_in_set('album_id', $moved_ids, true);
			$this->db->sql_query($sql);

			// Resync the right-hand side of the tree
			$sql = 'UPDATE ' . $this->albums_table . ' 
				SET left_id = left_id + ' . (int) $diff . ', right_id = right_id + ' . (int) $diff . ', album_parents = \'\'
				WHERE album_user_id = ' . (int) $this->user_id . '
					AND left_id > ' . (int) $to_data['right_id'] . '
					AND ' . $this->db->sql_in_set('album_id', $moved_ids, true);
			$this->db->sql_query($sql);

			// Resync moved branch
			$to_data['right_id'] += $diff;

			if ($to_data['right_id'] > $from_data['right_id'])
			{
				$diff = '+ ' . ($to_data['right_id'] - $from_data['right_id'] - 1);
			}
			else
			{
				$diff = '- ' . abs($to_data['right_id'] - $from_data['right_id'] - 1);
			}
		}
		else
		{
			$sql = 'SELECT MAX(right_id) AS right_id
				FROM ' . $this->albums_table . ' 
				WHERE album_user_id = ' . (int) $this->user_id . '
					AND ' . $this->db->sql_in_set('album_id', $moved_ids, true);
			$result = $this->db->sql_query($sql);
			$row = $this->db->sql_fetchrow($result);
			$this->db->sql_freeresult($result);

			$diff = '+ ' . ($row['right_id'] - $from_data['left_id'] + 1);
		}

		$sql = 'UPDATE ' . $this->albums_table . " 
			SET left_id = left_id $diff, right_id = right_id $diff, album_parents = ''
			WHERE album_user_id = " . (int) $this->user_id . '
				AND ' . $this->db->sql_in_set('album_id', $moved_ids);
		$this->db->sql_query($sql);

		return $errors;
	}