namespace phpbbstudio\mnote\migrations;
class install_permissions extends \phpbb\db\migration\migration
{
public function effectively_installed()
{
$sql = 'SELECT * FROM ' . $this->table_prefix . "acl_options
WHERE auth_option = '" . $this->db->sql_escape('a_phpbbstudio_mnote') . "'";
$result = $this->db->sql_query_limit($sql, 1);
$row = $this->db->sql_fetchrow($result);
$this->db->sql_freeresult($result);
return $row !== false;
}
public static function depends_on()
{
return ['\phpbb\db\migration\data\v33x\v334'];
}
public function update_data()
{
return [
// Add permissions not set
['permission.add', ['a_phpbbstudio_mnote']],
['permission.add', ['m_phpbbstudio_mnote']],
// Set permission on role if it exists
['if', [
['permission.role_exists', ['ROLE_ADMIN_FULL']],
['permission.permission_set', ['ROLE_ADMIN_FULL', 'a_phpbbstudio_mnote']],
]],
['if', [
['permission.role_exists', ['ROLE_MOD_FULL']],
['permission.permission_set', ['ROLE_MOD_FULL', 'm_phpbbstudio_mnote']],
]],
];
}
}