- if ($row = $db->sql_fetchrow($result))

- do

- {

- $selected = ($group_rank && $row['rank_id'] == $group_rank) ? ' selected="selected"' : '';

- $rank_options .= '<option value="' . $row['rank_id'] . '"' . $selected . '>' . $row['rank_title'] . '</option>';

- }

- while ($row = $db->sql_fetchrow($result));

- 'U_EDIT_ACTION' => $u_action,

- $forms_ary = array('overview', 'feedback', 'profile', 'prefs', 'avatar', 'sig', 'groups', 'perm', 'attach');

- foreach ($forms_ary as $value)

- 'groups' => array('title' => 'ACP_USER_GROUPS', 'auth' => 'acl_a_user', 'display' => false),

- $db->sql_query('INSERT INTO ' . FORUMS_TRACK_TABLE . ' ' . $db->sql_build_array('MULTI_INSERT', $sql_ary));

- /**

- * @package phpBB3

- * Extension of auth class for changing permissions

- */

-

- // NOTE: this function is not in use atm

- // Add a new option to the list ... $options is a hash of form ->

- // $options = array(

- // 'local' => array('option1', 'option2', ...),

- // 'global' => array('optionA', 'optionB', ...)

- //);

- function acl_add_option($options)

- {

- global $db, $cache;

-

- if (!is_array($options))

- {

- trigger_error('Incorrect parameter for acl_add_option', E_USER_ERROR);

- }

-

- $cur_options = array();

-

- $sql = "SELECT auth_option, is_global, is_local

- FROM " . ACL_OPTIONS_TABLE . "

- ORDER BY auth_option_id";

- $result = $db->sql_query($sql);

-

- while ($row = $db->sql_fetchrow($result))

- {

- if (!empty($row['is_global']))

- {

- $cur_options['global'][] = $row['auth_option'];

- }

-

- if (!empty($row['is_local']))

- {

- $cur_options['local'][] = $row['auth_option'];

- }

- }

- $db->sql_freeresult($result);

-

- // Here we need to insert new options ... this requires discovering whether

- // an options is global, local or both and whether we need to add an option

- // type flag (x_)

- $new_options = array('local' => array(), 'global' => array());

- foreach ($options as $type => $option_ary)

- {

- $option_ary = array_unique($option_ary);

- foreach ($option_ary as $option_value)

- {

- if (!in_array($option_value, $cur_options[$type]))

- {

- $new_options[$type][] = $option_value;

- }

-

- $flag = substr($option_value, 0, strpos($option_value, '_') + 1);

- if (!in_array($flag, $cur_options[$type]) && !in_array($flag, $new_options[$type]))

- {

- $new_options[$type][] = $flag;

- }

- }

- }

- unset($options);

-

- $options = array();

- $options['local'] = array_diff($new_options['local'], $new_options['global']);

- $options['global'] = array_diff($new_options['global'], $new_options['local']);

- $options['local_global'] = array_intersect($new_options['local'], $new_options['global']);

-

- $type_sql = array('local' => '0, 1', 'global' => '1, 0', 'local_global' => '1, 1');

-

- $sql = '';

- foreach ($options as $type => $option_ary)

- {

- foreach ($option_ary as $option)

- {

- switch (SQL_LAYER)

- {

- case 'mysql':

- $sql .= (($sql != '') ? ', ' : '') . "('$option', " . $type_sql[$type] . ")";

- break;

-

- case 'mysql4':

- case 'mysqli':

- case 'mssql':

- case 'mssql_odbc':

- case 'sqlite':

- $sql .= (($sql != '') ? ' UNION ALL ' : '') . " SELECT '$option', " . $type_sql[$type];

- break;

-

- default:

- $sql = 'INSERT INTO ' . ACL_OPTIONS_TABLE . " (auth_option, is_global, is_local)

- VALUES ($option, " . $type_sql[$type] . ")";

- $db->sql_query($sql);

- $sql = '';

- }

- }

- }

-

- if ($sql != '')

- {

- $sql = 'INSERT INTO ' . ACL_OPTIONS_TABLE . " (auth_option, is_global, is_local)

- VALUES $sql";

- $db->sql_query($sql);

- }

-

- $cache->destroy('acl_options');

- }

- }

- $sql = $db->sql_build_array('MULTI_INSERT', $sql_ary);

-

- if ($sql)

- $sql = 'INSERT INTO ' . BANLIST_TABLE . ' ' . $sql;

- $db->sql_query($sql);

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (2, 1, '', 'acp', 1, 0, 167, 202, 'ACP_CAT_GENERAL', '', '');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (74, 1, 'attachments', 'acp', 1, 42, 177, 178, 'ACP_ATTACHMENT_SETTINGS', 'attach', 'acl_a_attach');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (7, 1, 'modules', 'acp', 1, 67, 323, 324, 'ACP', 'acp', '');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (72, 1, 'board', 'acp', 1, 42, 173, 174, 'ACP_BOARD_DEFAULTS', 'default', 'acl_a_defaults');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (11, 1, '', 'acp', 1, 0, 237, 278, 'ACP_CAT_USERGROUP', '', '');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (41, 1, 'main', 'acp', 1, 2, 168, 169, 'ACP_MAIN', 'main', '');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (73, 1, 'board', 'acp', 1, 42, 175, 176, 'ACP_AVATAR_SETTINGS', 'avatar', 'acl_a_board');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (42, 1, '', 'acp', 1, 2, 170, 181, 'ACP_GENERAL_CONFIGURATION', '', '');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (43, 1, '', 'acp', 1, 2, 182, 189, 'ACP_CLIENT_COMMUNICATION', '', '');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (44, 1, '', 'acp', 1, 2, 190, 201, 'ACP_SERVER_CONFIGURATION', '', '');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (69, 1, 'modules', 'acp', 1, 67, 325, 326, 'UCP', 'ucp', '');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (46, 1, '', 'acp', 1, 0, 203, 212, 'ACP_CAT_FORUMS', '', '');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (47, 1, '', 'acp', 1, 0, 213, 236, 'ACP_CAT_POSTING', '', '');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (48, 1, '', 'acp', 1, 0, 279, 284, 'ACP_CAT_PERMISSIONS', '', '');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (49, 1, '', 'acp', 1, 0, 285, 298, 'ACP_CAT_STYLES', '', '');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (50, 1, '', 'acp', 1, 0, 299, 310, 'ACP_CAT_MAINTANENCE', '', '');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (51, 1, '', 'acp', 1, 0, 311, 330, 'ACP_CAT_SYSTEM', '', '');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (52, 1, '', 'acp', 1, 0, 331, 332, 'ACP_CAT_DOT_MODS', '', '');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (71, 1, 'board', 'acp', 1, 42, 171, 172, 'ACP_BOARD_SETTINGS', 'settings', 'acl_a_board');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (53, 1, '', 'acp', 1, 46, 204, 209, 'ACP_CAT_FORUMS', '', '');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (54, 1, '', 'acp', 1, 46, 210, 211, 'ACP_CAT_PERMISSIONS', '', '');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (75, 1, '', 'acp', 1, 47, 214, 225, 'ACP_MESSAGES', '', '');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (56, 1, '', 'acp', 1, 47, 226, 235, 'ACP_ATTACHMENTS', '', '');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (57, 1, '', 'acp', 1, 11, 238, 261, 'ACP_CAT_USERS', '', '');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (58, 1, '', 'acp', 1, 11, 262, 265, 'ACP_GROUPS', '', '');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (59, 0, '', 'acp', 1, 11, 266, 277, 'ACP_USER_SECURITY', '', '');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (60, 1, '', 'acp', 1, 48, 280, 281, 'ACP_CAT_GENERAL', '', '');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (61, 1, '', 'acp', 1, 48, 282, 283, 'ACP_PERMISSION_SETTINGS', '', '');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (62, 1, '', 'acp', 1, 49, 286, 289, 'ACP_STYLE_MANAGEMENT', '', '');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (63, 1, '', 'acp', 1, 50, 300, 307, 'ACP_FORUM_LOGS', '', '');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (64, 1, '', 'acp', 1, 50, 308, 309, 'ACP_CAT_DATABASE', '', '');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (65, 1, '', 'acp', 1, 51, 312, 313, 'ACP_AUTOMATION', '', '');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (66, 1, '', 'acp', 1, 51, 314, 321, 'ACP_GENERAL_TASKS', '', '');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (67, 1, '', 'acp', 1, 51, 322, 329, 'ACP_MODULE_MANAGEMENT', '', '');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (93, 1, 'board', 'acp', 1, 75, 215, 216, 'ACP_MESSAGE_SETTINGS', 'message', 'acl_a_defaults');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (76, 1, 'attachments', 'acp', 1, 56, 227, 228, 'ACP_ATTACHMENT_SETTINGS', 'attach', 'acl_a_attach');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (77, 1, 'attachments', 'acp', 1, 56, 229, 230, 'ACP_EXTENSION_GROUPS', 'ext_groups', 'acl_a_attach');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (78, 1, 'attachments', 'acp', 1, 56, 231, 232, 'ACP_MANAGE_EXTENSIONS', 'extensions', 'acl_a_attach');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (80, 1, 'attachments', 'acp', 1, 56, 233, 234, 'ACP_ORPHAN_ATTACHMENTS', 'orphan', 'acl_a_attach');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (81, 1, 'board', 'acp', 1, 42, 179, 180, 'ACP_MESSAGE_SETTINGS', 'message', 'acl_a_defaults');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (82, 1, 'board', 'acp', 1, 43, 183, 184, 'ACP_AUTH_SETTINGS', 'auth', 'acl_a_server');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (83, 1, 'board', 'acp', 1, 43, 185, 186, 'ACP_EMAIL_SETTINGS', 'email', 'acl_a_server');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (84, 1, 'jabber', 'acp', 1, 43, 187, 188, 'ACP_JABBER_SETTINGS', 'settings', 'acl_a_server');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (85, 1, 'board', 'acp', 1, 44, 191, 192, 'ACP_COOKIE_SETTINGS', 'cookie', 'acl_a_cookies');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (86, 1, 'board', 'acp', 1, 44, 193, 194, 'ACP_SERVER_SETTINGS', 'server', 'acl_a_server');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (87, 1, 'board', 'acp', 1, 44, 195, 196, 'ACP_LOAD_SETTINGS', 'load', 'acl_a_server');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (89, 1, 'php_info', 'acp', 1, 44, 197, 198, 'ACP_PHP_INFO', 'info', 'acl_a_server');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (91, 1, 'bots', 'acp', 1, 44, 199, 200, 'ACP_BOTS', 'bots', 'acl_a_server');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (92, 1, 'modules', 'acp', 1, 67, 327, 328, 'MCP', 'mcp', '');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (94, 1, 'bbcodes', 'acp', 1, 75, 217, 218, 'ACP_BBCODES', 'bbcodes', 'acl_a_bbcode');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (95, 1, 'icons', 'acp', 1, 75, 219, 220, 'ACP_ICONS', 'icons', 'acl_a_icons');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (96, 1, 'icons', 'acp', 1, 75, 221, 222, 'ACP_SMILIES', 'smilies', 'acl_a_icons');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (97, 1, 'words', 'acp', 1, 75, 223, 224, 'ACP_WORDS', 'words', 'acl_a_words');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (98, 1, 'logs', 'acp', 1, 63, 301, 302, 'ACP_ADMIN_LOGS', 'admin', 'acl_a_');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (99, 1, 'logs', 'acp', 1, 63, 303, 304, 'ACP_MOD_LOGS', 'mod', 'acl_a_');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (100, 1, 'logs', 'acp', 1, 63, 305, 306, 'ACP_CRITICAL_LOGS', 'critical', 'acl_a_');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (101, 1, 'language', 'acp', 1, 66, 315, 316, 'ACP_LANGUAGE_PACKS', 'lang_packs', 'acl_a_server');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (102, 1, 'bots', 'acp', 1, 66, 317, 318, 'ACP_BOTS', 'bots', 'acl_a_server');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (103, 1, 'groups', 'acp', 1, 58, 263, 264, 'ACP_GROUPS_MANAGE', 'manage', 'acl_a_group');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (105, 1, 'email', 'acp', 1, 66, 319, 320, 'ACP_MASS_EMAIL', 'email', 'acl_a_email');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (106, 1, 'ranks', 'acp', 1, 57, 243, 244, 'ACP_MANAGE_RANKS', 'ranks', 'acl_a_ranks');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (107, 1, 'ban', 'acp', 1, 59, 271, 272, 'ACP_BAN_EMAILS', 'email', 'acl_a_ban');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (108, 1, 'ban', 'acp', 1, 59, 273, 274, 'ACP_BAN_IPS', 'ip', 'acl_a_ban');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (109, 1, 'ban', 'acp', 1, 59, 275, 276, 'ACP_BAN_USERNAMES', 'user', 'acl_a_ban');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (110, 1, 'disallow', 'acp', 1, 59, 269, 270, 'ACP_DISALLOW_USERNAMES', 'usernames', 'acl_a_names');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (111, 1, 'prune', 'acp', 1, 59, 267, 268, 'ACP_PRUNE_USERS', 'users', 'acl_a_userdel');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (112, 1, 'prune', 'acp', 1, 53, 207, 208, 'ACP_PRUNE_FORUMS', 'forums', 'acl_a_prune');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (113, 1, 'profile', 'acp', 1, 57, 241, 242, 'ACP_CUSTOM_PROFILE_FIELDS', 'profile', 'acl_a_user');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (114, 1, 'forums', 'acp', 1, 53, 205, 206, 'ACP_MANAGE_FORUMS', 'manage', 'acl_a_forum');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (115, 1, 'users', 'acp', 1, 57, 239, 240, 'ACP_MANAGE_USERS', 'overview', 'acl_a_user');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (116, 1, 'users', 'acp', 0, 57, 245, 246, 'ACP_USER_FEEDBACK', 'feedback', 'acl_a_user');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (117, 1, 'users', 'acp', 0, 57, 247, 248, 'ACP_USER_PROFILE', 'profile', 'acl_a_user');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (118, 1, 'users', 'acp', 0, 57, 249, 250, 'ACP_USER_PREFS', 'prefs', 'acl_a_user');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (119, 1, 'users', 'acp', 0, 57, 251, 252, 'ACP_USER_AVATAR', 'avatar', 'acl_a_user');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (120, 1, 'users', 'acp', 0, 57, 253, 254, 'ACP_USER_SIG', 'sig', 'acl_a_user');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (121, 1, 'users', 'acp', 0, 57, 255, 256, 'ACP_USER_GROUPS', 'groups', 'acl_a_user');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (122, 1, 'users', 'acp', 0, 57, 257, 258, 'ACP_USER_PERM', 'perm', 'acl_a_user');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (123, 1, 'users', 'acp', 0, 57, 259, 260, 'ACP_USER_ATTACH', 'attach', 'acl_a_user');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (141, 1, '', 'acp', 1, 49, 290, 297, 'ACP_STYLE_COMPONENTS', '', '');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (142, 1, 'styles', 'acp', 1, 62, 287, 288, 'ACP_STYLES', 'style', 'acl_a_styles');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (143, 1, 'styles', 'acp', 1, 141, 291, 292, 'ACP_TEMPLATES', 'template', 'acl_a_styles');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (144, 1, 'styles', 'acp', 1, 141, 293, 294, 'ACP_THEMES', 'theme', 'acl_a_styles');

-INSERT INTO phpbb_modules (module_id, module_enabled, module_name, module_class, module_display, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (145, 1, 'styles', 'acp', 1, 141, 295, 296, 'ACP_IMAGESETS', 'imageset', 'acl_a_styles');

- $db->sql_query('INSERT INTO ' . PRIVMSGS_TO_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_insert_ary));