ttuu wrote:i didit. and its not work for me.
Well, first of all delete entries from older versions of this mod:
Code: Select all
--
-- Change the prefix if required!
--
DELETE FROM `phpbb_acl_groups` WHERE `group_id` =6 AND `forum_id` =0 AND `auth_option_id` =(SELECT `auth_option_id` FROM `phpbb_acl_options` WHERE `auth_option` = 'u_send_iaf') AND `auth_role_id` =0 AND `auth_setting` =0 LIMIT 1 ;
DELETE FROM `phpbb_acl_groups` WHERE `group_id` =5 AND `forum_id` =0 AND `auth_option_id` =(SELECT `auth_option_id` FROM `phpbb_acl_options` WHERE `auth_option` = 'u_send_iaf') AND `auth_role_id` =0 AND `auth_setting` =1 LIMIT 1 ;
DELETE FROM `phpbb_acl_groups` WHERE `group_id` =4 AND `forum_id` =0 AND `auth_option_id` =(SELECT `auth_option_id` FROM `phpbb_acl_options` WHERE `auth_option` = 'u_send_iaf') AND `auth_role_id` =0 AND `auth_setting` =1 LIMIT 1 ;
DELETE FROM `phpbb_acl_groups` WHERE `group_id` =3 AND `forum_id` =0 AND `auth_option_id` =(SELECT `auth_option_id` FROM `phpbb_acl_options` WHERE `auth_option` = 'u_send_iaf') AND `auth_role_id` =0 AND `auth_setting` =1 LIMIT 1 ;
DELETE FROM `phpbb_acl_groups` WHERE `group_id` =2 AND `forum_id` =0 AND `auth_option_id` =(SELECT `auth_option_id` FROM `phpbb_acl_options` WHERE `auth_option` = 'u_send_iaf') AND `auth_role_id` =0 AND `auth_setting` =1 LIMIT 1 ;
DELETE FROM `phpbb_acl_groups` WHERE `group_id` =1 AND `forum_id` =0 AND `auth_option_id` =(SELECT `auth_option_id` FROM `phpbb_acl_options` WHERE `auth_option` = 'u_send_iaf') AND `auth_role_id` =0 AND `auth_setting` =0 LIMIT 1 ;
DELETE FROM `phpbb_acl_options` WHERE `auth_option` ='u_send_iaf' ;
INSERT INTO phpbb_acl_options (auth_option, is_global, is_local, founder_only) VALUES ('u_send_iaf', 1, 0, 0);
Then assign the permissions (Permissions->Groups' permissions->Registered users->User permissions->Misc).