phpbbgallery\core\acp\permissions_module::permissions_v_mask()

Complexity

Conditions	31
Paths	> 20000

Size

Total Lines	243
Code Lines	147

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	992

Importance

Changes

0

<?php
	private function permissions_v_mask()
	{
		global $cache, $db, $template, $user, $table_prefix, $phpbb_container;
		global $request, $gallery_auth, $gallery_url;

		// Init auth
		$this->language = $phpbb_container->get('language');

		$this->language->add_lang('acp/permissions');

		$submit = (isset($_POST['submit'])) ? true : false;

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

		$delete = (isset($_POST['delete'])) ? true : false;
		$album_id = $request->variable('album_id', array(0));
		$group_id = $request->variable('group_id', array(0));
		$user_id = $request->variable('user_id', array(0));
		$p_system = $request->variable('p_system', 0);

		if (!$p_system && !sizeof($album_id))
		{
			trigger_error('NO_PERMISSIONS_SELECTED', E_USER_WARNING);
		}

		// Delete permissions
		if ($delete)
		{
			// Delete group permissions
			if (!empty($group_id))
			{
				// Get the possible outdated p_masks
				$sql = 'SELECT perm_role_id
					FROM ' . $table_prefix . 'gallery_permissions
					WHERE ' . ((!$p_system) ? $db->sql_in_set('perm_album_id', $album_id) : $db->sql_in_set('perm_system', $p_system)) . '
						AND ' . $db->sql_in_set('perm_group_id', $group_id);
				$result = $db->sql_query($sql);

				$outdated_p_masks = array();
				while ($row = $db->sql_fetchrow($result))
				{
					$outdated_p_masks[] = $row['perm_role_id'];
				}
				$db->sql_freeresult($result);

				// Delete the permissions and moderators
				$sql = 'DELETE FROM ' . $table_prefix . 'gallery_permissions
					WHERE ' . ((!$p_system) ? $db->sql_in_set('perm_album_id', $album_id) : $db->sql_in_set('perm_system', $p_system)) . '
						AND ' . $db->sql_in_set('perm_group_id', $group_id);
				$db->sql_query($sql);
				if (!$p_system)
				{
					// We do not display the moderators on personals so, just on albums
					$sql = 'DELETE FROM ' . $table_prefix . 'gallery_modscache
						WHERE ' . $db->sql_in_set('album_id', $album_id) . '
							AND ' . $db->sql_in_set('group_id', $group_id);
					$db->sql_query($sql);
				}

				// Check for further usage
				$sql = 'SELECT perm_role_id
					FROM ' . $table_prefix . 'gallery_permissions
					WHERE ' . $db->sql_in_set('perm_role_id', $outdated_p_masks, false, true);
				$result = $db->sql_query($sql);

				$still_used_p_masks = array();
				while ($row = $db->sql_fetchrow($result))
				{
					$still_used_p_masks[] = $row['perm_role_id'];
				}
				$db->sql_freeresult($result);

				// Delete the p_masks, which are no longer used
				$sql = 'DELETE FROM ' . $table_prefix . 'gallery_roles
					WHERE ' . $db->sql_in_set('role_id', $outdated_p_masks, false, true) . '
						AND ' . $db->sql_in_set('role_id', $still_used_p_masks, true, true);
				$db->sql_query($sql);
			}

			// Delete user permissions
			if (!empty($user_id))
			{
				// Get the possible outdated p_masks
				$sql = 'SELECT perm_role_id
					FROM ' . $table_prefix . 'gallery_permissions
					WHERE ' . ((!$p_system) ? $db->sql_in_set('perm_album_id', $album_id) : $db->sql_in_set('perm_system', $p_system)) . '
						AND ' . $db->sql_in_set('perm_user_id', $user_id);
				$result = $db->sql_query($sql);

				$outdated_p_masks = array();
				while ($row = $db->sql_fetchrow($result))
				{
					$outdated_p_masks[] = $row['perm_role_id'];
				}
				$db->sql_freeresult($result);

				// Delete the permissions and moderators
				$sql = 'DELETE FROM ' . $table_prefix . 'gallery_permissions
					WHERE ' . ((!$p_system) ? $db->sql_in_set('perm_album_id', $album_id) : $db->sql_in_set('perm_system', $p_system)) . '
						AND ' . $db->sql_in_set('perm_user_id', $user_id);
				$db->sql_query($sql);
				if (!$p_system)
				{
					// We do not display the moderators on personals so, just on albums
					$sql = 'DELETE FROM ' . $table_prefix . 'gallery_modscache
						WHERE ' . $db->sql_in_set('album_id', $album_id) . '
							AND ' . $db->sql_in_set('user_id', $user_id);
					$db->sql_query($sql);
				}

				// Check for further usage
				$sql = 'SELECT perm_role_id
					FROM ' . $table_prefix . 'gallery_permissions
					WHERE ' . $db->sql_in_set('perm_role_id', $outdated_p_masks, false, true);
				$result = $db->sql_query($sql);

				$still_used_p_masks = array();
				while ($row = $db->sql_fetchrow($result))
				{
					$still_used_p_masks[] = $row['perm_role_id'];
				}
				$db->sql_freeresult($result);

				// Delete the p_masks, which are no longer used
				$sql = 'DELETE FROM ' . $table_prefix . 'gallery_roles
					WHERE ' . $db->sql_in_set('role_id', $outdated_p_masks, false, true) . '
						AND ' . $db->sql_in_set('role_id', $still_used_p_masks, true, true);
				$db->sql_query($sql);
			}

			// Only clear if we did something
			if (!empty($group_id) || !empty($user_id))
			{
				$cache->destroy('sql', $table_prefix . 'gallery_permissions');
				$cache->destroy('sql', $table_prefix . 'gallery_roles');
				$cache->destroy('sql', $table_prefix . 'gallery_modscache');
				$gallery_auth->set_user_permissions('all', '');
			}
		}

		if (!$p_system)
		{
			// Get the album names of the selected albums
			$sql = 'SELECT album_name
				FROM ' . $table_prefix . 'gallery_albums
				WHERE ' . $db->sql_in_set('album_id', $album_id, false, true) . '
				ORDER BY left_id';
			$result = $db->sql_query($sql);

			$a_names = array();
			while ($row = $db->sql_fetchrow($result))
			{
				$a_names[] = $row['album_name'];
			}
			$db->sql_freeresult($result);
		}

		// Get the groups for selected album/p_system
		$sql_array = array(
			'SELECT'		=> 'g.group_name, g.group_id, g.group_type',
			'FROM'			=> array(GROUPS_TABLE => 'g'),

The constant phpbbgallery\core\acp\GROUPS_TABLE was not found. Maybe you did not declare it correctly or list all dependencies?

			'LEFT_JOIN'		=> array(
				array(
					'FROM'		=> array($table_prefix . 'gallery_permissions' => 'p'),
					'ON'		=> 'p.perm_group_id = g.group_id',
				),
			),

			'WHERE'			=> ((!$p_system) ? $db->sql_in_set('p.perm_album_id', $album_id, false, true) : $db->sql_in_set('p.perm_system', $p_system, false, true)),
			'GROUP_BY'		=> 'g.group_id, g.group_type, g.group_name',
		);
		$sql = $db->sql_build_query('SELECT', $sql_array);
		$result = $db->sql_query($sql);

		$set_groups = array();
		$s_defined_group_options = '';
		while ($row = $db->sql_fetchrow($result))
		{
			$set_groups[] = $row['group_id'];
			$s_defined_group_options .= '<option value="' . $row['group_id'] . '">' . (($row['group_type'] == GROUP_SPECIAL) ? $this->language->lang('G_' . $row['group_name']) : $row['group_name']) . '</option>';

The constant phpbbgallery\core\acp\GROUP_SPECIAL was not found. Maybe you did not declare it correctly or list all dependencies?

		}
		$db->sql_freeresult($result);

		// Get the other groups, so that the user can add them
		$sql = 'SELECT group_name, group_id, group_type
			FROM ' . GROUPS_TABLE . '
			WHERE ' . $db->sql_in_set('group_id', $set_groups, true, true);
		$result = $db->sql_query($sql);

		$s_add_group_options = '';
		while ($row = $db->sql_fetchrow($result))
		{
			$s_add_group_options .= '<option value="' . $row['group_id'] . '">' . (($row['group_type'] == GROUP_SPECIAL) ? $this->language->lang('G_' . $row['group_name']) : $row['group_name']) . '</option>';
		}
		$db->sql_freeresult($result);

		// Get the users for selected album/p_system
		$sql_array = array(
			'SELECT'		=> 'u.username, u.user_id',
			'FROM'			=> array(USERS_TABLE => 'u'),

The constant phpbbgallery\core\acp\USERS_TABLE was not found. Maybe you did not declare it correctly or list all dependencies?

			'LEFT_JOIN'		=> array(
				array(
					'FROM'		=> array($table_prefix . 'gallery_permissions' => 'p'),
					'ON'		=> 'p.perm_user_id = u.user_id',
				),
			),

			'WHERE'			=> ((!$p_system) ? $db->sql_in_set('p.perm_album_id', $album_id, false, true) : $db->sql_in_set('p.perm_system', $p_system, false, true)),
			'GROUP_BY'		=> 'u.user_id, u.username',
		);
		$sql = $db->sql_build_query('SELECT', $sql_array);
		$result = $db->sql_query($sql);

		$set_users = array();
		$s_defined_user_options = '';
		while ($row = $db->sql_fetchrow($result))
		{
			$set_users[] = $row['user_id'];
			$s_defined_user_options .= '<option value="' . $row['user_id'] . '">' . $row['username'] . '</option>';
		}
		$db->sql_freeresult($result);

		// Setting permissions screen
		$s_hidden_fields = build_hidden_fields(array(

The function build_hidden_fields was not found. Maybe you did not declare it correctly or list all dependencies?

			'album_id'		=> $album_id,
			'p_system'		=> $p_system,
		));

		$template->assign_vars(array(
			'S_HIDDEN_FIELDS'			=> $s_hidden_fields,
			'U_ACTION'					=> $this->u_action . '&action=v_mask',
			'S_PERMISSION_V_MASK'		=> true,

			'C_MASKS_NAMES'				=> (!$p_system) ? implode(', ', $a_names) : (($p_system == $gallery_auth::OWN_ALBUM) ? $this->language->lang('OWN_PERSONAL_ALBUMS') : $this->language->lang('PERSONAL_ALBUMS')),

The variable $a_names does not seem to be defined for all execution paths leading up to this point.

			'L_C_MASKS'					=> $this->language->lang('ALBUMS'),

			'S_CAN_SELECT_GROUP'		=> true,
			'S_DEFINED_GROUP_OPTIONS'	=> $s_defined_group_options,
			'S_ADD_GROUP_OPTIONS'		=> $s_add_group_options,

			'S_CAN_SELECT_USER'			=> true,
			'S_DEFINED_USER_OPTIONS'	=> $s_defined_user_options,
			'U_FIND_USERNAME'			=> $gallery_url->append_sid('phpbb', 'memberlist', 'mode=searchuser&form=add_user&field=username&select_single=true'),
			'ANONYMOUS_USER_ID'			=> ANONYMOUS,

The constant phpbbgallery\core\acp\ANONYMOUS was not found. Maybe you did not declare it correctly or list all dependencies?

		));