ernadoo\qte\migrations\v200\convert_old_permissions::convert_permissions()

Complexity

Conditions	13
Paths	384

Size

Total Lines	73
Code Lines	35

Duplication

Lines	0
Ratio	0 %

Importance

Changes	2
Bugs	0	Features	0

<?php
	public function convert_permissions()
	{
		$attr_permissions_array = $groups_array = array();

		$migrator_tool_permission = $this->container->get('migrator.tool.permission');

		$sql = 'SELECT * FROM ' . $this->table_prefix . 'topics_attr';
		$result = $this->db->sql_query($sql);

		while ($row = $this->db->sql_fetchrow($result))
		{
			$auth_option = 'f_qte_attr_'.$row['attr_id'];
			$migrator_tool_permission->add($auth_option, false);
			$attr_permissions_array[$auth_option] = json_decode($row['attr_auths'], true);
		}

		if (!class_exists('auth_admin'))
		{
			include($this->phpbb_root_path . 'includes/acp/auth.' . $this->php_ext);
		}
		$auth_admin = new \auth_admin();

		$hold_ary = array();

		foreach ($attr_permissions_array as $auth_option => $attr_permissions)
		{
			foreach ($attr_permissions as $attr_permission)
			{
				foreach ($attr_permission['forums_ids'] as $forum_id)
				{
					foreach ($attr_permission['groups_ids'] as $group_id)
					{
						if (!isset($hold_ary[$group_id][$forum_id]))
						{
							$hold_ary = $auth_admin->get_mask('set', false, $group_id, $forum_id, 'f_', 'local', ACL_NO);
						}

						$hold_ary[$group_id][$forum_id][$auth_option] = ACL_YES;

						$auth_admin->acl_set('group', $forum_id, $group_id, $hold_ary[$group_id][$forum_id]);
					}
				}
			}
		}

		$sql = 'SELECT group_id FROM ' . GROUPS_TABLE .
			(!$this->config['coppa_enable'] ? " WHERE group_name <> 'REGISTERED_COPPA'" : '');
		$result = $this->db->sql_query($sql);

		while ($row = $this->db->sql_fetchrow($result))
		{
			$groups_array[] = $row['group_id'];
		}

		$sql = 'SELECT forum_id, hide_attr FROM ' . FORUMS_TABLE . '
			WHERE hide_attr <> ""';
		$result = $this->db->sql_query($sql);

		while ($row = $this->db->sql_fetchrow($result))
		{
			$result_diff = array_diff($groups_array, unserialize($row['hide_attr']));

			if (sizeof($result_diff))
			{
				foreach ($result_diff as $group_id)
				{
					$hold_ary = $auth_admin->get_mask('set', false, $group_id, $row['forum_id'], 'm_', 'local', ACL_NO);
					$hold_ary[$group_id][$row['forum_id']]['m_qte_attr_del'] = ACL_YES;
					$auth_admin->acl_set('group', $row['forum_id'], $group_id, $hold_ary[$group_id][$row['forum_id']]);
				}
			}
		}
	}