Página 1 de 1

Truncate table... y ahora no veo las pestañas-.

Publicado: 10 Sep 2009, 14:20
por alfredcan
Buenas. Tuve un inconveniente al instalar el sitemap generator, y decidí vaciar las tablas de mods, dado que la otra que me quedaba era reinstalar el foro.

Ahora bien. Los mods siguen estando, pero no puedo administrarlos desde el ACP dado que las pestañas no se encuentran. ¿Alguien tiene alguna idea para que se restauren las pestañas en el panel de la administración. (tenía las del portal, php seo y demás)

La consulta que ejecuté fué la siguiente:

Código: Seleccionar todo

    TRUNCATE TABLE `phpbb_modules`;

    REPLACE INTO `phpbb_modules` VALUES(1, 1, 1, '', 'acp', 0, 1, 60, 'ACP_CAT_GENERAL', '', '');
    REPLACE INTO `phpbb_modules` VALUES(2, 1, 1, '', 'acp', 1, 4, 17, 'ACP_QUICK_ACCESS', '', '');
    REPLACE INTO `phpbb_modules` VALUES(3, 1, 1, '', 'acp', 1, 18, 39, 'ACP_BOARD_CONFIGURATION', '', '');
    REPLACE INTO `phpbb_modules` VALUES(4, 1, 1, '', 'acp', 1, 40, 47, 'ACP_CLIENT_COMMUNICATION', '', '');
    REPLACE INTO `phpbb_modules` VALUES(5, 1, 1, '', 'acp', 1, 48, 59, 'ACP_SERVER_CONFIGURATION', '', '');
    REPLACE INTO `phpbb_modules` VALUES(6, 1, 1, '', 'acp', 0, 61, 78, 'ACP_CAT_FORUMS', '', '');
    REPLACE INTO `phpbb_modules` VALUES(7, 1, 1, '', 'acp', 6, 62, 67, 'ACP_MANAGE_FORUMS', '', '');
    REPLACE INTO `phpbb_modules` VALUES(8, 1, 1, '', 'acp', 6, 68, 77, 'ACP_FORUM_BASED_PERMISSIONS', '', '');
    REPLACE INTO `phpbb_modules` VALUES(9, 1, 1, '', 'acp', 0, 79, 102, 'ACP_CAT_POSTING', '', '');
    REPLACE INTO `phpbb_modules` VALUES(10, 1, 1, '', 'acp', 9, 80, 91, 'ACP_MESSAGES', '', '');
    REPLACE INTO `phpbb_modules` VALUES(11, 1, 1, '', 'acp', 9, 92, 101, 'ACP_ATTACHMENTS', '', '');
    REPLACE INTO `phpbb_modules` VALUES(12, 1, 1, '', 'acp', 0, 103, 156, 'ACP_CAT_USERGROUP', '', '');
    REPLACE INTO `phpbb_modules` VALUES(13, 1, 1, '', 'acp', 12, 104, 135, 'ACP_CAT_USERS', '', '');
    REPLACE INTO `phpbb_modules` VALUES(14, 1, 1, '', 'acp', 12, 136, 143, 'ACP_GROUPS', '', '');
    REPLACE INTO `phpbb_modules` VALUES(15, 1, 1, '', 'acp', 12, 144, 155, 'ACP_USER_SECURITY', '', '');
    REPLACE INTO `phpbb_modules` VALUES(16, 1, 1, '', 'acp', 0, 157, 204, 'ACP_CAT_PERMISSIONS', '', '');
    REPLACE INTO `phpbb_modules` VALUES(17, 1, 1, '', 'acp', 16, 160, 169, 'ACP_GLOBAL_PERMISSIONS', '', '');
    REPLACE INTO `phpbb_modules` VALUES(18, 1, 1, '', 'acp', 16, 170, 179, 'ACP_FORUM_BASED_PERMISSIONS', '', '');
    REPLACE INTO `phpbb_modules` VALUES(19, 1, 1, '', 'acp', 16, 180, 189, 'ACP_PERMISSION_ROLES', '', '');
    REPLACE INTO `phpbb_modules` VALUES(20, 1, 1, '', 'acp', 16, 190, 203, 'ACP_PERMISSION_MASKS', '', '');
    REPLACE INTO `phpbb_modules` VALUES(21, 1, 1, '', 'acp', 0, 205, 218, 'ACP_CAT_STYLES', '', '');
    REPLACE INTO `phpbb_modules` VALUES(22, 1, 1, '', 'acp', 21, 206, 209, 'ACP_STYLE_MANAGEMENT', '', '');
    REPLACE INTO `phpbb_modules` VALUES(23, 1, 1, '', 'acp', 21, 210, 217, 'ACP_STYLE_COMPONENTS', '', '');
    REPLACE INTO `phpbb_modules` VALUES(24, 1, 1, '', 'acp', 0, 219, 238, 'ACP_CAT_MAINTENANCE', '', '');
    REPLACE INTO `phpbb_modules` VALUES(25, 1, 1, '', 'acp', 24, 220, 229, 'ACP_FORUM_LOGS', '', '');
    REPLACE INTO `phpbb_modules` VALUES(26, 1, 1, '', 'acp', 24, 230, 237, 'ACP_CAT_DATABASE', '', '');
    REPLACE INTO `phpbb_modules` VALUES(27, 1, 1, '', 'acp', 0, 239, 264, 'ACP_CAT_SYSTEM', '', '');
    REPLACE INTO `phpbb_modules` VALUES(28, 1, 1, '', 'acp', 27, 240, 243, 'ACP_AUTOMATION', '', '');
    REPLACE INTO `phpbb_modules` VALUES(29, 1, 1, '', 'acp', 27, 244, 255, 'ACP_GENERAL_TASKS', '', '');
    REPLACE INTO `phpbb_modules` VALUES(30, 1, 1, '', 'acp', 27, 256, 263, 'ACP_MODULE_MANAGEMENT', '', '');
    REPLACE INTO `phpbb_modules` VALUES(31, 1, 1, '', 'acp', 0, 265, 266, 'ACP_CAT_DOT_MODS', '', '');
    REPLACE INTO `phpbb_modules` VALUES(32, 1, 1, 'attachments', 'acp', 3, 19, 20, 'ACP_ATTACHMENT_SETTINGS', 'attach', 'acl_a_attach');
    REPLACE INTO `phpbb_modules` VALUES(33, 1, 1, 'attachments', 'acp', 11, 93, 94, 'ACP_ATTACHMENT_SETTINGS', 'attach', 'acl_a_attach');
    REPLACE INTO `phpbb_modules` VALUES(34, 1, 1, 'attachments', 'acp', 11, 95, 96, 'ACP_MANAGE_EXTENSIONS', 'extensions', 'acl_a_attach');
    REPLACE INTO `phpbb_modules` VALUES(35, 1, 1, 'attachments', 'acp', 11, 97, 98, 'ACP_EXTENSION_GROUPS', 'ext_groups', 'acl_a_attach');
    REPLACE INTO `phpbb_modules` VALUES(36, 1, 1, 'attachments', 'acp', 11, 99, 100, 'ACP_ORPHAN_ATTACHMENTS', 'orphan', 'acl_a_attach');
    REPLACE INTO `phpbb_modules` VALUES(37, 1, 1, 'ban', 'acp', 15, 145, 146, 'ACP_BAN_EMAILS', 'email', 'acl_a_ban');
    REPLACE INTO `phpbb_modules` VALUES(38, 1, 1, 'ban', 'acp', 15, 147, 148, 'ACP_BAN_IPS', 'ip', 'acl_a_ban');
    REPLACE INTO `phpbb_modules` VALUES(39, 1, 1, 'ban', 'acp', 15, 149, 150, 'ACP_BAN_USERNAMES', 'user', 'acl_a_ban');
    REPLACE INTO `phpbb_modules` VALUES(40, 1, 1, 'bbcodes', 'acp', 10, 81, 82, 'ACP_BBCODES', 'bbcodes', 'acl_a_bbcode');
    REPLACE INTO `phpbb_modules` VALUES(41, 1, 1, 'board', 'acp', 3, 21, 22, 'ACP_BOARD_SETTINGS', 'settings', 'acl_a_board');
    REPLACE INTO `phpbb_modules` VALUES(42, 1, 1, 'board', 'acp', 3, 23, 24, 'ACP_BOARD_FEATURES', 'features', 'acl_a_board');
    REPLACE INTO `phpbb_modules` VALUES(43, 1, 1, 'board', 'acp', 3, 25, 26, 'ACP_AVATAR_SETTINGS', 'avatar', 'acl_a_board');
    REPLACE INTO `phpbb_modules` VALUES(44, 1, 1, 'board', 'acp', 3, 27, 28, 'ACP_MESSAGE_SETTINGS', 'message', 'acl_a_board');
    REPLACE INTO `phpbb_modules` VALUES(45, 1, 1, 'board', 'acp', 10, 83, 84, 'ACP_MESSAGE_SETTINGS', 'message', 'acl_a_board');
    REPLACE INTO `phpbb_modules` VALUES(46, 1, 1, 'board', 'acp', 3, 29, 30, 'ACP_POST_SETTINGS', 'post', 'acl_a_board');
    REPLACE INTO `phpbb_modules` VALUES(47, 1, 1, 'board', 'acp', 3, 31, 32, 'ACP_SIGNATURE_SETTINGS', 'signature', 'acl_a_board');
    REPLACE INTO `phpbb_modules` VALUES(48, 1, 1, 'board', 'acp', 3, 33, 34, 'ACP_REGISTER_SETTINGS', 'registration', 'acl_a_board');
    REPLACE INTO `phpbb_modules` VALUES(49, 1, 1, 'board', 'acp', 4, 41, 42, 'ACP_AUTH_SETTINGS', 'auth', 'acl_a_server');
    REPLACE INTO `phpbb_modules` VALUES(50, 1, 1, 'board', 'acp', 4, 43, 44, 'ACP_EMAIL_SETTINGS', 'email', 'acl_a_server');
    REPLACE INTO `phpbb_modules` VALUES(51, 1, 1, 'board', 'acp', 5, 49, 50, 'ACP_COOKIE_SETTINGS', 'cookie', 'acl_a_server');
    REPLACE INTO `phpbb_modules` VALUES(52, 1, 1, 'board', 'acp', 5, 51, 52, 'ACP_SERVER_SETTINGS', 'server', 'acl_a_server');
    REPLACE INTO `phpbb_modules` VALUES(53, 1, 1, 'board', 'acp', 5, 53, 54, 'ACP_SECURITY_SETTINGS', 'security', 'acl_a_server');
    REPLACE INTO `phpbb_modules` VALUES(54, 1, 1, 'board', 'acp', 5, 55, 56, 'ACP_LOAD_SETTINGS', 'load', 'acl_a_server');
    REPLACE INTO `phpbb_modules` VALUES(55, 1, 1, 'bots', 'acp', 29, 245, 246, 'ACP_BOTS', 'bots', 'acl_a_bots');
    REPLACE INTO `phpbb_modules` VALUES(56, 1, 1, 'captcha', 'acp', 3, 35, 36, 'ACP_VC_SETTINGS', 'visual', 'acl_a_board');
    REPLACE INTO `phpbb_modules` VALUES(57, 1, 0, 'captcha', 'acp', 3, 37, 38, 'ACP_VC_CAPTCHA_DISPLAY', 'img', 'acl_a_board');
    REPLACE INTO `phpbb_modules` VALUES(58, 1, 1, 'database', 'acp', 26, 231, 232, 'ACP_BACKUP', 'backup', 'acl_a_backup');
    REPLACE INTO `phpbb_modules` VALUES(59, 1, 1, 'database', 'acp', 26, 233, 234, 'ACP_RESTORE', 'restore', 'acl_a_backup');
    REPLACE INTO `phpbb_modules` VALUES(60, 1, 1, 'disallow', 'acp', 15, 151, 152, 'ACP_DISALLOW_USERNAMES', 'usernames', 'acl_a_names');
    REPLACE INTO `phpbb_modules` VALUES(61, 1, 1, 'email', 'acp', 29, 247, 248, 'ACP_MASS_EMAIL', 'email', 'acl_a_email');
    REPLACE INTO `phpbb_modules` VALUES(62, 1, 1, 'forums', 'acp', 7, 63, 64, 'ACP_MANAGE_FORUMS', 'manage', 'acl_a_forum');
    REPLACE INTO `phpbb_modules` VALUES(63, 1, 1, 'groups', 'acp', 14, 137, 138, 'ACP_GROUPS_MANAGE', 'manage', 'acl_a_group');
    REPLACE INTO `phpbb_modules` VALUES(64, 1, 1, 'icons', 'acp', 10, 85, 86, 'ACP_ICONS', 'icons', 'acl_a_icons');
    REPLACE INTO `phpbb_modules` VALUES(65, 1, 1, 'icons', 'acp', 10, 87, 88, 'ACP_SMILIES', 'smilies', 'acl_a_icons');
    REPLACE INTO `phpbb_modules` VALUES(66, 1, 1, 'inactive', 'acp', 13, 107, 108, 'ACP_INACTIVE_USERS', 'list', 'acl_a_user');
    REPLACE INTO `phpbb_modules` VALUES(67, 1, 1, 'jabber', 'acp', 4, 45, 46, 'ACP_JABBER_SETTINGS', 'settings', 'acl_a_jabber');
    REPLACE INTO `phpbb_modules` VALUES(68, 1, 1, 'language', 'acp', 29, 249, 250, 'ACP_LANGUAGE_PACKS', 'lang_packs', 'acl_a_language');
    REPLACE INTO `phpbb_modules` VALUES(69, 1, 1, 'logs', 'acp', 25, 221, 222, 'ACP_ADMIN_LOGS', 'admin', 'acl_a_viewlogs');
    REPLACE INTO `phpbb_modules` VALUES(70, 1, 1, 'logs', 'acp', 25, 223, 224, 'ACP_MOD_LOGS', 'mod', 'acl_a_viewlogs');
    REPLACE INTO `phpbb_modules` VALUES(71, 1, 1, 'logs', 'acp', 25, 225, 226, 'ACP_USERS_LOGS', 'users', 'acl_a_viewlogs');
    REPLACE INTO `phpbb_modules` VALUES(72, 1, 1, 'logs', 'acp', 25, 227, 228, 'ACP_CRITICAL_LOGS', 'critical', 'acl_a_viewlogs');
    REPLACE INTO `phpbb_modules` VALUES(73, 1, 1, 'main', 'acp', 1, 2, 3, 'ACP_INDEX', 'main', '');
    REPLACE INTO `phpbb_modules` VALUES(74, 1, 1, 'modules', 'acp', 30, 257, 258, 'ACP', 'acp', 'acl_a_modules');
    REPLACE INTO `phpbb_modules` VALUES(75, 1, 1, 'modules', 'acp', 30, 259, 260, 'UCP', 'ucp', 'acl_a_modules');
    REPLACE INTO `phpbb_modules` VALUES(76, 1, 1, 'modules', 'acp', 30, 261, 262, 'MCP', 'mcp', 'acl_a_modules');
    REPLACE INTO `phpbb_modules` VALUES(77, 1, 1, 'permission_roles', 'acp', 19, 181, 182, 'ACP_ADMIN_ROLES', 'admin_roles', 'acl_a_roles && acl_a_aauth');
    REPLACE INTO `phpbb_modules` VALUES(78, 1, 1, 'permission_roles', 'acp', 19, 183, 184, 'ACP_USER_ROLES', 'user_roles', 'acl_a_roles && acl_a_uauth');
    REPLACE INTO `phpbb_modules` VALUES(79, 1, 1, 'permission_roles', 'acp', 19, 185, 186, 'ACP_MOD_ROLES', 'mod_roles', 'acl_a_roles && acl_a_mauth');
    REPLACE INTO `phpbb_modules` VALUES(80, 1, 1, 'permission_roles', 'acp', 19, 187, 188, 'ACP_FORUM_ROLES', 'forum_roles', 'acl_a_roles && acl_a_fauth');
    REPLACE INTO `phpbb_modules` VALUES(81, 1, 1, 'permissions', 'acp', 16, 158, 159, 'ACP_PERMISSIONS', 'intro', 'acl_a_authusers || acl_a_authgroups || acl_a_viewauth');
    REPLACE INTO `phpbb_modules` VALUES(82, 1, 0, 'permissions', 'acp', 20, 191, 192, 'ACP_PERMISSION_TRACE', 'trace', 'acl_a_viewauth');
    REPLACE INTO `phpbb_modules` VALUES(83, 1, 1, 'permissions', 'acp', 18, 171, 172, 'ACP_FORUM_PERMISSIONS', 'setting_forum_local', 'acl_a_fauth && (acl_a_authusers || acl_a_authgroups)');
    REPLACE INTO `phpbb_modules` VALUES(84, 1, 1, 'permissions', 'acp', 18, 173, 174, 'ACP_FORUM_MODERATORS', 'setting_mod_local', 'acl_a_mauth && (acl_a_authusers || acl_a_authgroups)');
    REPLACE INTO `phpbb_modules` VALUES(85, 1, 1, 'permissions', 'acp', 17, 161, 162, 'ACP_USERS_PERMISSIONS', 'setting_user_global', 'acl_a_authusers && (acl_a_aauth || acl_a_mauth || acl_a_uauth)');
    REPLACE INTO `phpbb_modules` VALUES(86, 1, 1, 'permissions', 'acp', 13, 109, 110, 'ACP_USERS_PERMISSIONS', 'setting_user_global', 'acl_a_authusers && (acl_a_aauth || acl_a_mauth || acl_a_uauth)');
    REPLACE INTO `phpbb_modules` VALUES(87, 1, 1, 'permissions', 'acp', 18, 175, 176, 'ACP_USERS_FORUM_PERMISSIONS', 'setting_user_local', 'acl_a_authusers && (acl_a_mauth || acl_a_fauth)');
    REPLACE INTO `phpbb_modules` VALUES(88, 1, 1, 'permissions', 'acp', 13, 111, 112, 'ACP_USERS_FORUM_PERMISSIONS', 'setting_user_local', 'acl_a_authusers && (acl_a_mauth || acl_a_fauth)');
    REPLACE INTO `phpbb_modules` VALUES(89, 1, 1, 'permissions', 'acp', 17, 163, 164, 'ACP_GROUPS_PERMISSIONS', 'setting_group_global', 'acl_a_authgroups && (acl_a_aauth || acl_a_mauth || acl_a_uauth)');
    REPLACE INTO `phpbb_modules` VALUES(90, 1, 1, 'permissions', 'acp', 14, 139, 140, 'ACP_GROUPS_PERMISSIONS', 'setting_group_global', 'acl_a_authgroups && (acl_a_aauth || acl_a_mauth || acl_a_uauth)');
    REPLACE INTO `phpbb_modules` VALUES(91, 1, 1, 'permissions', 'acp', 18, 177, 178, 'ACP_GROUPS_FORUM_PERMISSIONS', 'setting_group_local', 'acl_a_authgroups && (acl_a_mauth || acl_a_fauth)');
    REPLACE INTO `phpbb_modules` VALUES(92, 1, 1, 'permissions', 'acp', 14, 141, 142, 'ACP_GROUPS_FORUM_PERMISSIONS', 'setting_group_local', 'acl_a_authgroups && (acl_a_mauth || acl_a_fauth)');
    REPLACE INTO `phpbb_modules` VALUES(93, 1, 1, 'permissions', 'acp', 17, 165, 166, 'ACP_ADMINISTRATORS', 'setting_admin_global', 'acl_a_aauth && (acl_a_authusers || acl_a_authgroups)');
    REPLACE INTO `phpbb_modules` VALUES(94, 1, 1, 'permissions', 'acp', 17, 167, 168, 'ACP_GLOBAL_MODERATORS', 'setting_mod_global', 'acl_a_mauth && (acl_a_authusers || acl_a_authgroups)');
    REPLACE INTO `phpbb_modules` VALUES(95, 1, 1, 'permissions', 'acp', 20, 193, 194, 'ACP_VIEW_ADMIN_PERMISSIONS', 'view_admin_global', 'acl_a_viewauth');
    REPLACE INTO `phpbb_modules` VALUES(96, 1, 1, 'permissions', 'acp', 20, 195, 196, 'ACP_VIEW_USER_PERMISSIONS', 'view_user_global', 'acl_a_viewauth');
    REPLACE INTO `phpbb_modules` VALUES(97, 1, 1, 'permissions', 'acp', 20, 197, 198, 'ACP_VIEW_GLOBAL_MOD_PERMISSIONS', 'view_mod_global', 'acl_a_viewauth');
    REPLACE INTO `phpbb_modules` VALUES(98, 1, 1, 'permissions', 'acp', 20, 199, 200, 'ACP_VIEW_FORUM_MOD_PERMISSIONS', 'view_mod_local', 'acl_a_viewauth');
    REPLACE INTO `phpbb_modules` VALUES(99, 1, 1, 'permissions', 'acp', 20, 201, 202, 'ACP_VIEW_FORUM_PERMISSIONS', 'view_forum_local', 'acl_a_viewauth');
    REPLACE INTO `phpbb_modules` VALUES(100, 1, 1, 'php_info', 'acp', 29, 251, 252, 'ACP_PHP_INFO', 'info', 'acl_a_phpinfo');
    REPLACE INTO `phpbb_modules` VALUES(101, 1, 1, 'profile', 'acp', 13, 113, 114, 'ACP_CUSTOM_PROFILE_FIELDS', 'profile', 'acl_a_profile');
    REPLACE INTO `phpbb_modules` VALUES(102, 1, 1, 'prune', 'acp', 7, 65, 66, 'ACP_PRUNE_FORUMS', 'forums', 'acl_a_prune');
    REPLACE INTO `phpbb_modules` VALUES(103, 1, 1, 'prune', 'acp', 15, 153, 154, 'ACP_PRUNE_USERS', 'users', 'acl_a_userdel');
    REPLACE INTO `phpbb_modules` VALUES(104, 1, 1, 'ranks', 'acp', 13, 115, 116, 'ACP_MANAGE_RANKS', 'ranks', 'acl_a_ranks');
    REPLACE INTO `phpbb_modules` VALUES(105, 1, 1, 'reasons', 'acp', 29, 253, 254, 'ACP_MANAGE_REASONS', 'main', 'acl_a_reasons');
    REPLACE INTO `phpbb_modules` VALUES(106, 1, 1, 'search', 'acp', 5, 57, 58, 'ACP_SEARCH_SETTINGS', 'settings', 'acl_a_search');
    REPLACE INTO `phpbb_modules` VALUES(107, 1, 1, 'search', 'acp', 26, 235, 236, 'ACP_SEARCH_INDEX', 'index', 'acl_a_search');
    REPLACE INTO `phpbb_modules` VALUES(108, 1, 1, 'styles', 'acp', 22, 207, 208, 'ACP_STYLES', 'style', 'acl_a_styles');
    REPLACE INTO `phpbb_modules` VALUES(109, 1, 1, 'styles', 'acp', 23, 211, 212, 'ACP_TEMPLATES', 'template', 'acl_a_styles');
    REPLACE INTO `phpbb_modules` VALUES(110, 1, 1, 'styles', 'acp', 23, 213, 214, 'ACP_THEMES', 'theme', 'acl_a_styles');
    REPLACE INTO `phpbb_modules` VALUES(111, 1, 1, 'styles', 'acp', 23, 215, 216, 'ACP_IMAGESETS', 'imageset', 'acl_a_styles');
    REPLACE INTO `phpbb_modules` VALUES(112, 1, 1, 'update', 'acp', 28, 241, 242, 'ACP_VERSION_CHECK', 'version_check', 'acl_a_board');
    REPLACE INTO `phpbb_modules` VALUES(113, 1, 1, 'users', 'acp', 13, 105, 106, 'ACP_MANAGE_USERS', 'overview', 'acl_a_user');
    REPLACE INTO `phpbb_modules` VALUES(114, 1, 0, 'users', 'acp', 13, 117, 118, 'ACP_USER_FEEDBACK', 'feedback', 'acl_a_user');
    REPLACE INTO `phpbb_modules` VALUES(115, 1, 0, 'users', 'acp', 13, 119, 120, 'ACP_USER_PROFILE', 'profile', 'acl_a_user');
    REPLACE INTO `phpbb_modules` VALUES(116, 1, 0, 'users', 'acp', 13, 121, 122, 'ACP_USER_PREFS', 'prefs', 'acl_a_user');
    REPLACE INTO `phpbb_modules` VALUES(117, 1, 0, 'users', 'acp', 13, 123, 124, 'ACP_USER_AVATAR', 'avatar', 'acl_a_user');
    REPLACE INTO `phpbb_modules` VALUES(118, 1, 0, 'users', 'acp', 13, 125, 126, 'ACP_USER_RANK', 'rank', 'acl_a_user');
    REPLACE INTO `phpbb_modules` VALUES(119, 1, 0, 'users', 'acp', 13, 127, 128, 'ACP_USER_SIG', 'sig', 'acl_a_user');
    REPLACE INTO `phpbb_modules` VALUES(120, 1, 0, 'users', 'acp', 13, 129, 130, 'ACP_USER_GROUPS', 'groups', 'acl_a_user && acl_a_group');
    REPLACE INTO `phpbb_modules` VALUES(121, 1, 0, 'users', 'acp', 13, 131, 132, 'ACP_USER_PERM', 'perm', 'acl_a_user && acl_a_viewauth');
    REPLACE INTO `phpbb_modules` VALUES(122, 1, 0, 'users', 'acp', 13, 133, 134, 'ACP_USER_ATTACH', 'attach', 'acl_a_user');
    REPLACE INTO `phpbb_modules` VALUES(123, 1, 1, 'words', 'acp', 10, 89, 90, 'ACP_WORDS', 'words', 'acl_a_words');
    REPLACE INTO `phpbb_modules` VALUES(124, 1, 1, 'users', 'acp', 2, 5, 6, 'ACP_MANAGE_USERS', 'overview', 'acl_a_user');
    REPLACE INTO `phpbb_modules` VALUES(125, 1, 1, 'groups', 'acp', 2, 7, 8, 'ACP_GROUPS_MANAGE', 'manage', 'acl_a_group');
    REPLACE INTO `phpbb_modules` VALUES(126, 1, 1, 'forums', 'acp', 2, 9, 10, 'ACP_MANAGE_FORUMS', 'manage', 'acl_a_forum');
    REPLACE INTO `phpbb_modules` VALUES(127, 1, 1, 'logs', 'acp', 2, 11, 12, 'ACP_MOD_LOGS', 'mod', 'acl_a_viewlogs');
    REPLACE INTO `phpbb_modules` VALUES(128, 1, 1, 'bots', 'acp', 2, 13, 14, 'ACP_BOTS', 'bots', 'acl_a_bots');
    REPLACE INTO `phpbb_modules` VALUES(129, 1, 1, 'php_info', 'acp', 2, 15, 16, 'ACP_PHP_INFO', 'info', 'acl_a_phpinfo');
    REPLACE INTO `phpbb_modules` VALUES(130, 1, 1, 'permissions', 'acp', 8, 69, 70, 'ACP_FORUM_PERMISSIONS', 'setting_forum_local', 'acl_a_fauth && (acl_a_authusers || acl_a_authgroups)');
    REPLACE INTO `phpbb_modules` VALUES(131, 1, 1, 'permissions', 'acp', 8, 71, 72, 'ACP_FORUM_MODERATORS', 'setting_mod_local', 'acl_a_mauth && (acl_a_authusers || acl_a_authgroups)');
    REPLACE INTO `phpbb_modules` VALUES(132, 1, 1, 'permissions', 'acp', 8, 73, 74, 'ACP_USERS_FORUM_PERMISSIONS', 'setting_user_local', 'acl_a_authusers && (acl_a_mauth || acl_a_fauth)');
    REPLACE INTO `phpbb_modules` VALUES(133, 1, 1, 'permissions', 'acp', 8, 75, 76, 'ACP_GROUPS_FORUM_PERMISSIONS', 'setting_group_local', 'acl_a_authgroups && (acl_a_mauth || acl_a_fauth)');
    REPLACE INTO `phpbb_modules` VALUES(134, 1, 1, '', 'mcp', 0, 1, 10, 'MCP_MAIN', '', '');
    REPLACE INTO `phpbb_modules` VALUES(135, 1, 1, '', 'mcp', 0, 11, 18, 'MCP_QUEUE', '', '');
    REPLACE INTO `phpbb_modules` VALUES(136, 1, 1, '', 'mcp', 0, 19, 26, 'MCP_REPORTS', '', '');
    REPLACE INTO `phpbb_modules` VALUES(137, 1, 1, '', 'mcp', 0, 27, 32, 'MCP_NOTES', '', '');
    REPLACE INTO `phpbb_modules` VALUES(138, 1, 1, '', 'mcp', 0, 33, 42, 'MCP_WARN', '', '');
    REPLACE INTO `phpbb_modules` VALUES(139, 1, 1, '', 'mcp', 0, 43, 50, 'MCP_LOGS', '', '');
    REPLACE INTO `phpbb_modules` VALUES(140, 1, 1, '', 'mcp', 0, 51, 58, 'MCP_BAN', '', '');
    REPLACE INTO `phpbb_modules` VALUES(141, 1, 1, 'ban', 'mcp', 140, 52, 53, 'MCP_BAN_USERNAMES', 'user', 'acl_m_ban');
    REPLACE INTO `phpbb_modules` VALUES(142, 1, 1, 'ban', 'mcp', 140, 54, 55, 'MCP_BAN_IPS', 'ip', 'acl_m_ban');
    REPLACE INTO `phpbb_modules` VALUES(143, 1, 1, 'ban', 'mcp', 140, 56, 57, 'MCP_BAN_EMAILS', 'email', 'acl_m_ban');
    REPLACE INTO `phpbb_modules` VALUES(144, 1, 1, 'logs', 'mcp', 139, 44, 45, 'MCP_LOGS_FRONT', 'front', 'acl_m_ || aclf_m_');
    REPLACE INTO `phpbb_modules` VALUES(145, 1, 1, 'logs', 'mcp', 139, 46, 47, 'MCP_LOGS_FORUM_VIEW', 'forum_logs', 'acl_m_,$id');
    REPLACE INTO `phpbb_modules` VALUES(146, 1, 1, 'logs', 'mcp', 139, 48, 49, 'MCP_LOGS_TOPIC_VIEW', 'topic_logs', 'acl_m_,$id');
    REPLACE INTO `phpbb_modules` VALUES(147, 1, 1, 'main', 'mcp', 134, 2, 3, 'MCP_MAIN_FRONT', 'front', '');
    REPLACE INTO `phpbb_modules` VALUES(148, 1, 1, 'main', 'mcp', 134, 4, 5, 'MCP_MAIN_FORUM_VIEW', 'forum_view', 'acl_m_,$id');
    REPLACE INTO `phpbb_modules` VALUES(149, 1, 1, 'main', 'mcp', 134, 6, 7, 'MCP_MAIN_TOPIC_VIEW', 'topic_view', 'acl_m_,$id');
    REPLACE INTO `phpbb_modules` VALUES(150, 1, 1, 'main', 'mcp', 134, 8, 9, 'MCP_MAIN_POST_DETAILS', 'post_details', 'acl_m_,$id || (!$id && aclf_m_)');
    REPLACE INTO `phpbb_modules` VALUES(151, 1, 1, 'notes', 'mcp', 137, 28, 29, 'MCP_NOTES_FRONT', 'front', '');
    REPLACE INTO `phpbb_modules` VALUES(152, 1, 1, 'notes', 'mcp', 137, 30, 31, 'MCP_NOTES_USER', 'user_notes', '');
    REPLACE INTO `phpbb_modules` VALUES(153, 1, 1, 'queue', 'mcp', 135, 12, 13, 'MCP_QUEUE_UNAPPROVED_TOPICS', 'unapproved_topics', 'aclf_m_approve');
    REPLACE INTO `phpbb_modules` VALUES(154, 1, 1, 'queue', 'mcp', 135, 14, 15, 'MCP_QUEUE_UNAPPROVED_POSTS', 'unapproved_posts', 'aclf_m_approve');
    REPLACE INTO `phpbb_modules` VALUES(155, 1, 1, 'queue', 'mcp', 135, 16, 17, 'MCP_QUEUE_APPROVE_DETAILS', 'approve_details', 'acl_m_approve,$id || (!$id && aclf_m_approve)');
    REPLACE INTO `phpbb_modules` VALUES(156, 1, 1, 'reports', 'mcp', 136, 20, 21, 'MCP_REPORTS_OPEN', 'reports', 'aclf_m_report');
    REPLACE INTO `phpbb_modules` VALUES(157, 1, 1, 'reports', 'mcp', 136, 22, 23, 'MCP_REPORTS_CLOSED', 'reports_closed', 'aclf_m_report');
    REPLACE INTO `phpbb_modules` VALUES(158, 1, 1, 'reports', 'mcp', 136, 24, 25, 'MCP_REPORT_DETAILS', 'report_details', 'acl_m_report,$id || (!$id && aclf_m_report)');
    REPLACE INTO `phpbb_modules` VALUES(159, 1, 1, 'warn', 'mcp', 138, 34, 35, 'MCP_WARN_FRONT', 'front', 'aclf_m_warn');
    REPLACE INTO `phpbb_modules` VALUES(160, 1, 1, 'warn', 'mcp', 138, 36, 37, 'MCP_WARN_LIST', 'list', 'aclf_m_warn');
    REPLACE INTO `phpbb_modules` VALUES(161, 1, 1, 'warn', 'mcp', 138, 38, 39, 'MCP_WARN_USER', 'warn_user', 'aclf_m_warn');
    REPLACE INTO `phpbb_modules` VALUES(162, 1, 1, 'warn', 'mcp', 138, 40, 41, 'MCP_WARN_POST', 'warn_post', 'acl_m_warn && acl_f_read,$id');
    REPLACE INTO `phpbb_modules` VALUES(163, 1, 1, '', 'ucp', 0, 1, 12, 'UCP_MAIN', '', '');
    REPLACE INTO `phpbb_modules` VALUES(164, 1, 1, '', 'ucp', 0, 13, 22, 'UCP_PROFILE', '', '');
    REPLACE INTO `phpbb_modules` VALUES(165, 1, 1, '', 'ucp', 0, 23, 30, 'UCP_PREFS', '', '');
    REPLACE INTO `phpbb_modules` VALUES(166, 1, 1, '', 'ucp', 0, 31, 42, 'UCP_PM', '', '');
    REPLACE INTO `phpbb_modules` VALUES(167, 1, 1, '', 'ucp', 0, 43, 48, 'UCP_USERGROUPS', '', '');
    REPLACE INTO `phpbb_modules` VALUES(168, 1, 1, '', 'ucp', 0, 49, 54, 'UCP_ZEBRA', '', '');
    REPLACE INTO `phpbb_modules` VALUES(169, 1, 1, 'attachments', 'ucp', 163, 10, 11, 'UCP_MAIN_ATTACHMENTS', 'attachments', 'acl_u_attach');
    REPLACE INTO `phpbb_modules` VALUES(170, 1, 1, 'groups', 'ucp', 167, 44, 45, 'UCP_USERGROUPS_MEMBER', 'membership', '');
    REPLACE INTO `phpbb_modules` VALUES(171, 1, 1, 'groups', 'ucp', 167, 46, 47, 'UCP_USERGROUPS_MANAGE', 'manage', '');
    REPLACE INTO `phpbb_modules` VALUES(172, 1, 1, 'main', 'ucp', 163, 2, 3, 'UCP_MAIN_FRONT', 'front', '');
    REPLACE INTO `phpbb_modules` VALUES(173, 1, 1, 'main', 'ucp', 163, 4, 5, 'UCP_MAIN_SUBSCRIBED', 'subscribed', '');
    REPLACE INTO `phpbb_modules` VALUES(174, 1, 1, 'main', 'ucp', 163, 6, 7, 'UCP_MAIN_BOOKMARKS', 'bookmarks', 'cfg_allow_bookmarks');
    REPLACE INTO `phpbb_modules` VALUES(175, 1, 1, 'main', 'ucp', 163, 8, 9, 'UCP_MAIN_DRAFTS', 'drafts', '');
    REPLACE INTO `phpbb_modules` VALUES(176, 1, 0, 'pm', 'ucp', 166, 32, 33, 'UCP_PM_VIEW', 'view', 'cfg_allow_privmsg');
    REPLACE INTO `phpbb_modules` VALUES(177, 1, 1, 'pm', 'ucp', 166, 34, 35, 'UCP_PM_COMPOSE', 'compose', 'cfg_allow_privmsg');
    REPLACE INTO `phpbb_modules` VALUES(178, 1, 1, 'pm', 'ucp', 166, 36, 37, 'UCP_PM_DRAFTS', 'drafts', 'cfg_allow_privmsg');
    REPLACE INTO `phpbb_modules` VALUES(179, 1, 1, 'pm', 'ucp', 166, 38, 39, 'UCP_PM_OPTIONS', 'options', 'cfg_allow_privmsg');
    REPLACE INTO `phpbb_modules` VALUES(180, 1, 0, 'pm', 'ucp', 166, 40, 41, 'UCP_PM_POPUP_TITLE', 'popup', 'cfg_allow_privmsg');
    REPLACE INTO `phpbb_modules` VALUES(181, 1, 1, 'prefs', 'ucp', 165, 24, 25, 'UCP_PREFS_PERSONAL', 'personal', '');
    REPLACE INTO `phpbb_modules` VALUES(182, 1, 1, 'prefs', 'ucp', 165, 26, 27, 'UCP_PREFS_POST', 'post', '');
    REPLACE INTO `phpbb_modules` VALUES(183, 1, 1, 'prefs', 'ucp', 165, 28, 29, 'UCP_PREFS_VIEW', 'view', '');
    REPLACE INTO `phpbb_modules` VALUES(184, 1, 1, 'profile', 'ucp', 164, 14, 15, 'UCP_PROFILE_PROFILE_INFO', 'profile_info', '');
    REPLACE INTO `phpbb_modules` VALUES(185, 1, 1, 'profile', 'ucp', 164, 16, 17, 'UCP_PROFILE_SIGNATURE', 'signature', '');
    REPLACE INTO `phpbb_modules` VALUES(186, 1, 1, 'profile', 'ucp', 164, 18, 19, 'UCP_PROFILE_AVATAR', 'avatar', '');
    REPLACE INTO `phpbb_modules` VALUES(187, 1, 1, 'profile', 'ucp', 164, 20, 21, 'UCP_PROFILE_REG_DETAILS', 'reg_details', '');
    REPLACE INTO `phpbb_modules` VALUES(188, 1, 1, 'zebra', 'ucp', 168, 50, 51, 'UCP_ZEBRA_FRIENDS', 'friends', '');
    REPLACE INTO `phpbb_modules` VALUES(189, 1, 1, 'zebra', 'ucp', 168, 52, 53, 'UCP_ZEBRA_FOES', 'foes', '');

Re: Truncate table... y ahora no veo las pestañas-.

Publicado: 10 Sep 2009, 15:59
por ahh72
creo que al vaciar las tablas eliminaste toda la informacion referente a los mods que tienes instalado, segun veo aunque no estoy seguro creo que fue un error fatal lo que hiciste :oops:

Re: Truncate table... y ahora no veo las pestañas-.

Publicado: 11 Sep 2009, 00:16
por alfredcan
ahh72 escribió:creo que al vaciar las tablas eliminaste toda la informacion referente a los mods que tienes instalado, segun veo aunque no estoy seguro creo que fue un error fatal lo que hiciste :oops:
Si si.... se el riesgo. El asunto que los mods siguen andando a la perfección. El problema es con el ACP que no me deja ver las pestañas de la administración de algunos mods.

Re: Truncate table... y ahora no veo las pestañas-.

Publicado: 11 Sep 2009, 02:08
por HuanManwe
De ahí que se diga que antes de tocar nada en el foro haya que hacer copia de seguridad de la base de datos y de los archivos.

Re: Truncate table... y ahora no veo las pestañas-.

Publicado: 11 Sep 2009, 13:06
por alfredcan
HuanManwe escribió:De ahí que se diga que antes de tocar nada en el foro haya que hacer copia de seguridad de la base de datos y de los archivos.
Tengo hecha la copia de seguridad. Puedo restaurar. El asunto es que me sigue sucediendo éste problema: http://www.phpbb-es.com/foro/error-gene ... 22993.html luego de instalar el sitemap generator.

Re: Truncate table... y ahora no veo las pestañas-.

Publicado: 11 Sep 2009, 14:58
por ahh72
pues mejor restaura tu copia de seguridad del foro y de la base de datos y ten en cuenta que siempre que desees instalar un mod hazlo en un foro de prueba hantes de hacerlo en tu foro real.

saludos