YourWBB

DROP TABLE IF EXISTS bb1_acpmenuitemgroups;
CREATE TABLE bb1_acpmenuitemgroups (
  itemgroupid smallint(5) unsigned NOT NULL auto_increment,
  title varchar(255) NOT NULL default '',
  `condition` text,
  `conditiontype` enum('OR','AND') NOT NULL default 'OR',
  showorder smallint(5) unsigned NOT NULL default '0',
  acpmode tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (itemgroupid)
) TYPE=MyISAM;

INSERT INTO bb1_acpmenuitemgroups VALUES (1, 'board', 'a_can_boards_add;a_can_boards_edit;a_can_boards_del;a_can_boards_empty;a_can_boards_rights;a_can_boards_permissions;a_can_moderator_add;a_can_moderator_del;a_can_moderator_edit', 'OR', 1, 1),
(2, 'users', 'a_can_users_add;a_can_users_edit;a_can_users_delete;a_can_users_email;a_can_users_merge;a_can_users_access;a_can_users_other;a_can_users_activation', 'OR', 2, 1),
(3, 'threads', 'a_can_threads_mass_edit;a_can_threads_edit;a_can_threads_moderate;a_can_threads_moderate_posts', 'OR', 3, 1),
(4, 'group', 'a_can_groups_add;a_can_groups_edit;a_can_groups_edit_own;a_can_groups_del;a_can_groups_variablegroups_set_securitylevel;a_can_boards_permissions;a_can_users_email', 'OR', 4, 1),
(5, 'style', 'a_can_style_add;a_can_style_edit;a_can_style_del;a_can_style_export;a_can_style_import', 'OR', 5, 1),
(9, 'avatar', 'a_can_avatars_readfolder;a_can_avatars_edit;a_can_avatars_del;a_can_avatars_add', 'OR', 9, 1),
(10, 'ranks', 'a_can_ranks_add;a_can_ranks_edit;a_can_ranks_del', 'OR', 10, 2),
(6, 'designpack', 'a_can_designpack_add;a_can_designpack_edit;a_can_designpack_copy;a_can_designpack_del', 'OR', 6, 2),
(7, 'template', 'a_can_template_add;a_can_template_edit;a_can_template_copy;a_can_template_del;a_can_templatepack_add;a_can_templatepack_edit;a_can_templatepack_del;a_can_template_import;a_can_template_export;a_can_template_search;a_can_template_cache', 'OR', 7, 1),
(8, 'languagepack', 'a_can_languagepack_add;a_can_languagepack_edit;a_can_languagepack_del;a_can_languagepack_export;a_can_languagepack_import;a_can_languagepack_translate;a_can_languagepack_delitem;a_can_languagepack_additem;a_can_languagepack_addcategory;a_can_languagepack_delcategory;a_can_languagepack_search;a_can_languagepack_sync', 'OR', 8, 2),
(11, 'smilie', 'a_can_smilie_add;a_can_smilie_edit;a_can_smilie_del', 'OR', 11, 2),
(12, 'icon', 'a_can_icon_add;a_can_icon_edit;a_can_icon_del', 'OR', 12, 2),
(13, 'bbcodes', 'a_can_bbcodes_add;a_can_bbcodes_edit;a_can_bbcodes_del', 'OR', 13, 2),
(14, 'profilefield', 'a_can_profilefield_add;a_can_profilefield_edit;a_can_profilefield_del', 'OR', 14, 2),
(15, 'database', 'a_can_database_backup;a_can_database_query;a_can_database_extra', 'OR', 15, 1),
(16, 'other1', 'a_can_otherstuff_ranks;a_can_otherstuff_threads;a_can_otherstuff_reindex;a_can_otherstuff_delindex;a_can_otherstuff_userposts;a_can_memberslist;a_can_otherstuff_wordmatch;a_can_users_edit;a_can_users_email;a_can_otherstuff_thumbnails;a_can_otherstuff_pmcounters', 'OR', 16, 1),
(17, 'other2', '', 'OR', 17, 1);

DROP TABLE IF EXISTS bb1_acpmenuitems;
CREATE TABLE bb1_acpmenuitems (
  itemid smallint(5) unsigned NOT NULL auto_increment,
  itemgroupid smallint(5) unsigned NOT NULL default '0',
  link varchar(255) NOT NULL default '',
  languageitem varchar(255) NOT NULL default '',
  linkformat varchar(20) NOT NULL default '',
  `condition` varchar(255) NOT NULL default '',
  `conditiontype` enum('OR','AND') NOT NULL default 'OR',
  showorder smallint(5) unsigned NOT NULL default '0',
  acpmode tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (itemid)
) TYPE=MyISAM;

INSERT INTO bb1_acpmenuitems VALUES (1, 1, 'board.php?action=add', 'BOARD_ADD', '', 'a_can_boards_add', 'OR', 1, 1),
(2, 1, 'board.php?action=view', 'BOARD_EDIT', '<b>%s</b>', 'a_can_boards_edit;a_can_boards_del;a_can_boards_empty;a_can_boards_rights;a_can_boards_permissions;a_can_moderator_add;a_can_moderator_del;a_can_moderator_edit', 'OR', 2, 1),
(3, 2, 'users.php?action=add', 'USERS_ADD', '', 'a_can_users_add', 'OR', 1, 2),
(4, 2, 'users.php?action=find', 'USERS_FIND', '<b>%s</b>', 'a_can_users_edit;a_can_users_delete;a_can_users_merge;a_can_users_access;a_can_users_other;a_can_users_activation', 'OR', 2, 1),
(5, 2, 'users.php?action=email&amp;userid=all', 'USERS_EMAIL_ALL', '', 'a_can_users_email', 'OR', 3, 2),
(6, 2, 'users.php?action=rate', 'USERS_RESET_RATING', '', 'a_can_users_other', 'OR', 4, 2),
(7, 3, 'threads.php?action=spinning', 'THREADS_EDIT', '<b>%s</b>', 'a_can_threads_edit', 'OR', 1, 1),
(8, 3, 'threads.php?action=moderate', 'THREADS_MODERATE', '', 'a_can_threads_moderate', 'OR', 2, 2),
(9, 3, 'threads.php?action=moderateposts', 'THREADS_MODERATE_POST', '', 'a_can_threads_moderate_posts', 'OR', 3, 2),
(10, 4, 'group.php?action=add', 'GROUP_ADD', '', 'a_can_groups_add', 'OR', 1, 2),
(11, 4, 'group.php?action=view', 'GROUP_EDIT', '<b>%s</b>', 'a_can_groups_edit;a_can_groups_edit_own;a_can_groups_del;a_can_groups_add;a_can_boards_permissions;a_can_users_email', 'OR', 2, 1),
(12, 4, 'group.php?action=variablegroups_set_securitylevel', 'GROUP_SECURITYLEVEL', '', 'a_can_groups_variablegroups_set_securitylevel', 'OR', 3, 2),
(13, 5, 'style.php?action=add', 'STYLE_ADD', '', 'a_can_style_add', 'OR', 1, 2),
(14, 5, 'style.php?action=view', 'STYLE_EDIT', '', 'a_can_style_edit;a_can_style_del;a_can_style_export', 'OR', 2, 2),
(15, 5, 'style.php?action=import%2Fexport', 'STYLE_IMPORT_EXPORT', '<b>%s</b>', 'a_can_style_import;a_can_style_export', 'OR', 3, 2),
(16, 6, 'designpack.php?action=add', 'DESIGNPACK_ADD', '', 'a_can_designpack_add', 'OR', 1, 2),
(17, 6, 'designpack.php?action=view', 'DESIGNPACK_EDIT', '<b>%s</b>', 'a_can_designpack_edit;a_can_designpack_copy;a_can_designpack_del', 'OR', 2, 2),
(18, 7, 'template.php?action=add', 'TEMPLATE_ADD', '', 'a_can_template_add', 'OR', 1, 2),
(19, 7, 'template.php?action=view', 'TEMPLATE_EDIT', '<b>%s</b>', 'a_can_template_add;a_can_template_edit;a_can_template_copy;a_can_template_del', 'OR', 2, 1),
(20, 7, 'template.php?action=addpack', 'TEMPLATEPACK_ADD', '', 'a_can_templatepack_add', 'OR', 3, 2),
(21, 7, 'template.php?action=viewpack', 'TEMPLATEPACK_EDIT', '', 'a_can_templatepack_edit;a_can_templatepack_del', 'OR', 4, 2),
(22, 7, 'template.php?action=import%2Fexport', 'TEMPLATE_IMPORT_EXPORT', '<b>%s</b>', 'a_can_template_import;a_can_template_export', 'OR', 5, 1),
(23, 7, 'template.php?action=search', 'TEMPLATE_SEARCH_REPLACE', '', 'a_can_template_search', 'OR', 6, 2),
(24, 9, 'avatar.php?action=readfolder', 'AVATAR_READ', '', 'a_can_avatars_readfolder', 'OR', 1, 2),
(25, 9, 'avatar.php?action=add', 'AVATAR_ADD', '', 'a_can_avatars_add', 'OR', 2, 2),
(26, 9, 'avatar.php?action=view', 'AVATAR_EDIT', '', 'a_can_avatars_edit;a_can_avatars_del', 'OR', 3, 2),
(27, 9, 'avatar.php?action=backup', 'AVATAR_BACKUP', '', 'a_can_avatars_edit;a_can_avatars_del', 'OR', 3, 1),
(28, 10, 'ranks.php?action=add', 'RANKS_ADD', '', 'a_can_ranks_add', 'OR', 1, 2),
(29, 10, 'ranks.php?action=view', 'RANKS_EDIT', '', 'a_can_ranks_edit;a_can_ranks_del', 'OR', 2, 2),
(30, 11, 'smilie.php?action=add', 'SMILIE_ADD', '', 'a_can_smilie_add', 'OR', 1, 2),
(31, 11, 'smilie.php?action=view', 'SMILIE_EDIT', '', 'a_can_smilie_edit;a_can_smilie_del', 'OR', 2, 2),
(32, 12, 'icon.php?action=add', 'ICON_ADD', '', 'a_can_icon_add', 'OR', 1, 2),
(33, 12, 'icon.php?action=view', 'ICON_EDIT', '', 'a_can_icon_edit;a_can_icon_del', 'OR', 2, 2),
(34, 13, 'bbcodes.php?action=add', 'BBCODES_ADD', '', 'a_can_bbcodes_add', 'OR', 1, 2),
(35, 13, 'bbcodes.php?action=view', 'BBCODES_EDIT', '', 'a_can_bbcodes_edit;a_can_bbcodes_del', 'OR', 2, 2),
(36, 14, 'profilefield.php?action=add', 'PROFILEFIELD_ADD', '', 'a_can_profilefield_add', 'OR', 1, 2),
(37, 14, 'profilefield.php?action=view', 'PROFILEFIELD_EDIT', '', 'a_can_profilefield_edit;a_can_profilefield_del', 'OR', 2, 2),
(38, 15, 'database.php?action=backup', 'DATABASE_BACKUP', '<b>%s</b>', 'a_can_database_backup', 'OR', 1, 1),
(39, 15, 'database.php?action=query', 'DATABASE_QUERY', '', 'a_can_database_query;a_can_database_extra', 'OR', 2, 2),
(40, 16, 'otherstuff.php', 'OTHERSTUFF_UPDATEVIEW', '<b>%s</b>', 'a_can_otherstuff_ranks;a_can_otherstuff_threads;a_can_otherstuff_reindex;a_can_otherstuff_delindex;a_can_otherstuff_userposts;a_can_users_edit;a_can_otherstuff_thumbnails;a_can_otherstuff_pmcounters', 'OR', 1, 1),
(41, 16, 'memberslist.php', 'MEMBERSLIST', '', 'a_can_memberslist', 'OR', 2, 2),
(42, 16, 'otherstuff.php?action=wordmatch', 'OTHERSTUFF_WORDMATCH', '', 'a_can_otherstuff_wordmatch', 'OR', 3, 2),
(43, 17, 'otherstuff.php?action=adminsessions', 'OTHERSTUFF_ADMINSESSIONS', '', 'a_can_otherstuff_adminsessions', 'OR', 1, 2),
(44, 17, 'otherstuff.php?action=selectstats', 'OTHERSTUFF_STATS', '', 'a_can_otherstuff_stats', 'OR', 2, 2),
(45, 17, 'otherstuff.php?action=acpsettings', 'OTHERSTUFF_ACPSETTINGS', '<b>%s</b>', '', 'OR', 3, 1),
(46, 8, 'languagepack.php?action=add', 'LANGUAGEPACK_ADD', '', 'a_can_languagepack_add', 'OR', 1, 2),
(47, 8, 'languagepack.php?action=view', 'LANGUAGEPACK_EDIT', '<b>%s</b>', 'a_can_languagepack_add;a_can_languagepack_edit;a_can_languagepack_del;a_can_languagepack_export;a_can_languagepack_translate', 'OR', 2, 0),
(48, 8, 'languagepack.php?action=additem', 'LANGUAGEITEM_ADD', '', 'a_can_languagepack_additem', 'OR', 3, 2),
(49, 8, 'languagepack.php?action=addcategory', 'LANGUAGECAT_ADD', '', 'a_can_languagepack_addcategory', 'OR', 4, 2),
(50, 8, 'languagepack.php?action=import', 'LANGUAGEPACK_IMPORT', '<b>%s</b>', 'a_can_languagepack_import', 'OR', 6, 2),
(51, 8, 'languagepack.php?action=search', 'LANGUAGEPACK_SEARCH', '', 'a_can_languagepack_search', 'OR', 7, 2),
(52, 8, 'languagepack.php?action=sync', 'LANGUAGEPACK_SYNC', '', 'a_can_languagepack_sync', 'OR', 8, 2),
(53, 7, 'template.php?action=cache', 'TEMPLATE_CACHE', '', 'a_can_template_cache', 'OR', 7, 2),
(54, 3, 'threads.php?action=threads_mass_edit', 'THREADS_MASS_EDIT', '', 'a_can_threads_mass_edit', 'OR', 1, 2),
(55, 8, 'languagepack.php?action=delcategory', 'LANGUAGECAT_DEL', '', 'a_can_languagepack_delcategory', 'OR', 5, 2),
(56, 16, 'otherstuff.php?action=mailqueue', 'OTHERSTUFF_MAILQUEUE', '%s', 'a_can_users_email', 'OR', 4, 1);