[MODDB]MOD Version Check 1.0.2

[Handyman]

It could also be that the modules got out of sync. I wonder if there's a resync somewhere… I don't remember
You could have a look in the database -> modules table and make sure all the left and right id's match up. If they don't, that would be the problem.

[Boardtalknet]

I went on a search for a module resync over on phpbb.com and came across this topic but its going back to 2008. In it the user made a mistake when adding a new module (maybe I did something similar?) and Highway of Life links to a script that resync’s the modules. I haven’t run the script because its going back a bit and its in a different mod topic… is this the one your thinking about and would it be usefull in this case? Topic link: http://www.phpbb.com/community/viewtopic.php?f=69&t=580108&start=555#p7278455

..look in the database -> modules table....

I feel silly now for asking where it would be in the DB - the modules table < I’m always learning and thanks.
Below is the modules table but unfortunately my abilities are limited to only finding the MOD_VERSION_CHECK is there, as for the left and right id's matching up I'm afraid I don't understand it enough yet.

Code: Select all

#
# phpBB Backup Script
# Dump of tables for phpbb_
# DATE : 28-07-2011 22:43:58 GMT
#
# Table: phpbb_modules
DROP TABLE IF EXISTS phpbb_modules;
CREATE TABLE `phpbb_modules` (
  `module_id` mediumint(8) unsigned NOT NULL auto_increment,
  `module_enabled` tinyint(1) unsigned NOT NULL default '1',
  `module_display` tinyint(1) unsigned NOT NULL default '1',
  `module_basename` varchar(255) NOT NULL default '',
  `module_class` varchar(10) NOT NULL default '',
  `parent_id` mediumint(8) unsigned NOT NULL default '0',
  `left_id` mediumint(8) unsigned NOT NULL default '0',
  `right_id` mediumint(8) unsigned NOT NULL default '0',
  `module_langname` varchar(255) NOT NULL default '',
  `module_mode` varchar(255) NOT NULL default '',
  `module_auth` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`module_id`),
  KEY `left_right_id` (`left_id`,`right_id`),
  KEY `module_enabled` (`module_enabled`),
  KEY `class_left_id` (`module_class`,`left_id`)
) ENGINE=MyISAM AUTO_INCREMENT=261 DEFAULT CHARSET=utf8;

INSERT INTO phpbb_modules (module_id, module_enabled, module_display, module_basename, module_class, parent_id, left_id, right_id, module_langname, module_mode, module_auth) VALUES (1, 1, 1, '', 'acp', 0, 1, 66, 'ACP_CAT_GENERAL', '', ''),(2, 1, 1, '', 'acp', 1, 4, 17, 'ACP_QUICK_ACCESS', '', ''),(3, 1, 1, '', 'acp', 1, 18, 43, 'ACP_BOARD_CONFIGURATION', '', ''),(4, 1, 1, '', 'acp', 1, 44, 51, 'ACP_CLIENT_COMMUNICATION', '', ''),(5, 1, 1, '', 'acp', 1, 52, 65, 'ACP_SERVER_CONFIGURATION', '', ''),(6, 1, 1, '', 'acp', 0, 67, 86, 'ACP_CAT_FORUMS', '', ''),(7, 1, 1, '', 'acp', 6, 68, 73, 'ACP_MANAGE_FORUMS', '', ''),(8, 1, 1, '', 'acp', 6, 74, 85, 'ACP_FORUM_BASED_PERMISSIONS', '', ''),(9, 1, 1, '', 'acp', 0, 87, 112, 'ACP_CAT_POSTING', '', ''),(10, 1, 1, '', 'acp', 9, 88, 101, 'ACP_MESSAGES', '', ''),(11, 1, 1, '', 'acp', 9, 102, 111, 'ACP_ATTACHMENTS', '', ''),(12, 1, 1, '', 'acp', 0, 113, 168, 'ACP_CAT_USERGROUP', '', ''),(13, 1, 1, '', 'acp', 12, 114, 147, 'ACP_CAT_USERS', '', ''),(14, 1, 1, '', 'acp', 12, 148, 155, 'ACP_GROUPS', '', ''),(15, 1, 1, '', 'acp', 12, 156, 167, 'ACP_USER_SECURITY', '', ''),(16, 1, 1, '', 'acp', 0, 169, 218, 'ACP_CAT_PERMISSIONS', '', ''),(17, 1, 1, '', 'acp', 16, 172, 181, 'ACP_GLOBAL_PERMISSIONS', '', ''),(18, 1, 1, '', 'acp', 16, 182, 193, 'ACP_FORUM_BASED_PERMISSIONS', '', ''),(19, 1, 1, '', 'acp', 16, 194, 203, 'ACP_PERMISSION_ROLES', '', ''),(20, 1, 1, '', 'acp', 16, 204, 217, 'ACP_PERMISSION_MASKS', '', ''),(21, 1, 1, '', 'acp', 0, 219, 232, 'ACP_CAT_STYLES', '', ''),(22, 1, 1, '', 'acp', 21, 220, 223, 'ACP_STYLE_MANAGEMENT', '', ''),(23, 1, 1, '', 'acp', 21, 224, 231, 'ACP_STYLE_COMPONENTS', '', ''),(24, 1, 1, '', 'acp', 0, 233, 254, 'ACP_CAT_MAINTENANCE', '', ''),(25, 1, 1, '', 'acp', 24, 234, 243, 'ACP_FORUM_LOGS', '', ''),(26, 1, 1, '', 'acp', 24, 244, 253, 'ACP_CAT_DATABASE', '', ''),(27, 1, 1, '', 'acp', 0, 255, 282, 'ACP_CAT_SYSTEM', '', ''),(28, 1, 1, '', 'acp', 27, 256, 259, 'ACP_AUTOMATION', '', ''),(29, 1, 1, '', 'acp', 27, 260, 271, 'ACP_GENERAL_TASKS', '', ''),(30, 1, 1, '', 'acp', 27, 272, 281, 'ACP_MODULE_MANAGEMENT', '', ''),(31, 1, 1, '', 'acp', 0, 283, 358, 'ACP_CAT_DOT_MODS', '', ''),(32, 1, 1, 'attachments', 'acp', 3, 19, 20, 'ACP_ATTACHMENT_SETTINGS', 'attach', 'acl_a_attach'),(33, 1, 1, 'attachments', 'acp', 11, 103, 104, 'ACP_ATTACHMENT_SETTINGS', 'attach', 'acl_a_attach'),(34, 1, 1, 'attachments', 'acp', 11, 105, 106, 'ACP_MANAGE_EXTENSIONS', 'extensions', 'acl_a_attach'),(35, 1, 1, 'attachments', 'acp', 11, 107, 108, 'ACP_EXTENSION_GROUPS', 'ext_groups', 'acl_a_attach'),(36, 1, 1, 'attachments', 'acp', 11, 109, 110, 'ACP_ORPHAN_ATTACHMENTS', 'orphan', 'acl_a_attach'),(37, 1, 1, 'ban', 'acp', 15, 157, 158, 'ACP_BAN_EMAILS', 'email', 'acl_a_ban'),(38, 1, 1, 'ban', 'acp', 15, 159, 160, 'ACP_BAN_IPS', 'ip', 'acl_a_ban'),(39, 1, 1, 'ban', 'acp', 15, 161, 162, 'ACP_BAN_USERNAMES', 'user', 'acl_a_ban'),(40, 1, 1, 'bbcodes', 'acp', 10, 89, 90, 'ACP_BBCODES', 'bbcodes', 'acl_a_bbcode'),(41, 1, 1, 'board', 'acp', 3, 21, 22, 'ACP_BOARD_SETTINGS', 'settings', 'acl_a_board'),(42, 1, 1, 'board', 'acp', 3, 23, 24, 'ACP_BOARD_FEATURES', 'features', 'acl_a_board'),(43, 1, 1, 'board', 'acp', 3, 25, 26, 'ACP_AVATAR_SETTINGS', 'avatar', 'acl_a_board'),(44, 1, 1, 'board', 'acp', 3, 27, 28, 'ACP_MESSAGE_SETTINGS', 'message', 'acl_a_board'),(45, 1, 1, 'board', 'acp', 10, 91, 92, 'ACP_MESSAGE_SETTINGS', 'message', 'acl_a_board'),(46, 1, 1, 'board', 'acp', 3, 29, 30, 'ACP_POST_SETTINGS', 'post', 'acl_a_board'),(47, 1, 1, 'board', 'acp', 10, 93, 94, 'ACP_POST_SETTINGS', 'post', 'acl_a_board'),(48, 1, 1, 'board', 'acp', 3, 31, 32, 'ACP_SIGNATURE_SETTINGS', 'signature', 'acl_a_board'),(49, 1, 1, 'board', 'acp', 3, 33, 34, 'ACP_FEED_SETTINGS', 'feed', 'acl_a_board'),(50, 1, 1, 'board', 'acp', 3, 35, 36, 'ACP_REGISTER_SETTINGS', 'registration', 'acl_a_board'),(51, 1, 1, 'board', 'acp', 4, 45, 46, 'ACP_AUTH_SETTINGS', 'auth', 'acl_a_server'),(52, 1, 1, 'board', 'acp', 4, 47, 48, 'ACP_EMAIL_SETTINGS', 'email', 'acl_a_server'),(53, 1, 1, 'board', 'acp', 5, 53, 54, 'ACP_COOKIE_SETTINGS', 'cookie', 'acl_a_server'),(54, 1, 1, 'board', 'acp', 5, 55, 56, 'ACP_SERVER_SETTINGS', 'server', 'acl_a_server'),(55, 1, 1, 'board', 'acp', 5, 57, 58, 'ACP_SECURITY_SETTINGS', 'security', 'acl_a_server'),(56, 1, 1, 'board', 'acp', 5, 59, 60, 'ACP_LOAD_SETTINGS', 'load', 'acl_a_server'),(57, 1, 1, 'bots', 'acp', 29, 261, 262, 'ACP_BOTS', 'bots', 'acl_a_bots'),(58, 1, 1, 'captcha', 'acp', 3, 37, 38, 'ACP_VC_SETTINGS', 'visual', 'acl_a_board'),(59, 1, 0, 'captcha', 'acp', 3, 39, 40, 'ACP_VC_CAPTCHA_DISPLAY', 'img', 'acl_a_board'),(60, 1, 1, 'database', 'acp', 26, 245, 246, 'ACP_BACKUP', 'backup', 'acl_a_backup'),(61, 1, 1, 'database', 'acp', 26, 247, 248, 'ACP_RESTORE', 'restore', 'acl_a_backup'),(62, 1, 1, 'disallow', 'acp', 15, 163, 164, 'ACP_DISALLOW_USERNAMES', 'usernames', 'acl_a_names'),(63, 1, 1, 'email', 'acp', 29, 263, 264, 'ACP_MASS_EMAIL', 'email', 'acl_a_email && cfg_email_enable'),(64, 1, 1, 'forums', 'acp', 7, 69, 70, 'ACP_MANAGE_FORUMS', 'manage', 'acl_a_forum'),(65, 1, 1, 'groups', 'acp', 14, 149, 150, 'ACP_GROUPS_MANAGE', 'manage', 'acl_a_group'),(66, 1, 1, 'icons', 'acp', 10, 95, 96, 'ACP_ICONS', 'icons', 'acl_a_icons'),(67, 1, 1, 'icons', 'acp', 10, 97, 98, 'ACP_SMILIES', 'smilies', 'acl_a_icons'),(68, 1, 1, 'inactive', 'acp', 13, 117, 118, 'ACP_INACTIVE_USERS', 'list', 'acl_a_user'),(69, 1, 1, 'jabber', 'acp', 4, 49, 50, 'ACP_JABBER_SETTINGS', 'settings', 'acl_a_jabber'),(70, 1, 1, 'language', 'acp', 29, 265, 266, 'ACP_LANGUAGE_PACKS', 'lang_packs', 'acl_a_language'),(71, 1, 1, 'logs', 'acp', 25, 235, 236, 'ACP_ADMIN_LOGS', 'admin', 'acl_a_viewlogs'),(72, 1, 1, 'logs', 'acp', 25, 237, 238, 'ACP_MOD_LOGS', 'mod', 'acl_a_viewlogs'),(73, 1, 1, 'logs', 'acp', 25, 239, 240, 'ACP_USERS_LOGS', 'users', 'acl_a_viewlogs'),(74, 1, 1, 'logs', 'acp', 25, 241, 242, 'ACP_CRITICAL_LOGS', 'critical', 'acl_a_viewlogs'),(75, 1, 1, 'main', 'acp', 1, 2, 3, 'ACP_INDEX', 'main', ''),(76, 1, 1, 'modules', 'acp', 30, 273, 276, 'ACP', 'acp', 'acl_a_modules'),(77, 1, 1, 'modules', 'acp', 30, 277, 278, 'UCP', 'ucp', 'acl_a_modules'),(78, 1, 1, 'modules', 'acp', 30, 279, 280, 'MCP', 'mcp', 'acl_a_modules'),(79, 1, 1, 'permission_roles', 'acp', 19, 195, 196, 'ACP_ADMIN_ROLES', 'admin_roles', 'acl_a_roles && acl_a_aauth'),(80, 1, 1, 'permission_roles', 'acp', 19, 197, 198, 'ACP_USER_ROLES', 'user_roles', 'acl_a_roles && acl_a_uauth'),(81, 1, 1, 'permission_roles', 'acp', 19, 199, 200, 'ACP_MOD_ROLES', 'mod_roles', 'acl_a_roles && acl_a_mauth'),(82, 1, 1, 'permission_roles', 'acp', 19, 201, 202, 'ACP_FORUM_ROLES', 'forum_roles', 'acl_a_roles && acl_a_fauth'),(83, 1, 1, 'permissions', 'acp', 16, 170, 171, 'ACP_PERMISSIONS', 'intro', 'acl_a_authusers || acl_a_authgroups || acl_a_viewauth'),(84, 1, 0, 'permissions', 'acp', 20, 205, 206, 'ACP_PERMISSION_TRACE', 'trace', 'acl_a_viewauth'),(85, 1, 1, 'permissions', 'acp', 18, 183, 184, 'ACP_FORUM_PERMISSIONS', 'setting_forum_local', 'acl_a_fauth && (acl_a_authusers || acl_a_authgroups)'),(86, 1, 1, 'permissions', 'acp', 18, 185, 186, 'ACP_FORUM_PERMISSIONS_COPY', 'setting_forum_copy', 'acl_a_fauth && acl_a_authusers && acl_a_authgroups && acl_a_mauth'),(87, 1, 1, 'permissions', 'acp', 18, 187, 188, 'ACP_FORUM_MODERATORS', 'setting_mod_local', 'acl_a_mauth && (acl_a_authusers || acl_a_authgroups)'),(88, 1, 1, 'permissions', 'acp', 17, 173, 174, 'ACP_USERS_PERMISSIONS', 'setting_user_global', 'acl_a_authusers && (acl_a_aauth || acl_a_mauth || acl_a_uauth)'),(89, 1, 1, 'permissions', 'acp', 13, 119, 120, 'ACP_USERS_PERMISSIONS', 'setting_user_global', 'acl_a_authusers && (acl_a_aauth || acl_a_mauth || acl_a_uauth)'),(90, 1, 1, 'permissions', 'acp', 18, 189, 190, 'ACP_USERS_FORUM_PERMISSIONS', 'setting_user_local', 'acl_a_authusers && (acl_a_mauth || acl_a_fauth)'),(91, 1, 1, 'permissions', 'acp', 13, 121, 122, 'ACP_USERS_FORUM_PERMISSIONS', 'setting_user_local', 'acl_a_authusers && (acl_a_mauth || acl_a_fauth)'),(92, 1, 1, 'permissions', 'acp', 17, 175, 176, 'ACP_GROUPS_PERMISSIONS', 'setting_group_global', 'acl_a_authgroups && (acl_a_aauth || acl_a_mauth || acl_a_uauth)'),(93, 1, 1, 'permissions', 'acp', 14, 151, 152, 'ACP_GROUPS_PERMISSIONS', 'setting_group_global', 'acl_a_authgroups && (acl_a_aauth || acl_a_mauth || acl_a_uauth)'),(94, 1, 1, 'permissions', 'acp', 18, 191, 192, 'ACP_GROUPS_FORUM_PERMISSIONS', 'setting_group_local', 'acl_a_authgroups && (acl_a_mauth || acl_a_fauth)'),(95, 1, 1, 'permissions', 'acp', 14, 153, 154, 'ACP_GROUPS_FORUM_PERMISSIONS', 'setting_group_local', 'acl_a_authgroups && (acl_a_mauth || acl_a_fauth)'),(96, 1, 1, 'permissions', 'acp', 17, 177, 178, 'ACP_ADMINISTRATORS', 'setting_admin_global', 'acl_a_aauth && (acl_a_authusers || acl_a_authgroups)'),(97, 1, 1, 'permissions', 'acp', 17, 179, 180, 'ACP_GLOBAL_MODERATORS', 'setting_mod_global', 'acl_a_mauth && (acl_a_authusers || acl_a_authgroups)'),(98, 1, 1, 'permissions', 'acp', 20, 207, 208, 'ACP_VIEW_ADMIN_PERMISSIONS', 'view_admin_global', 'acl_a_viewauth'),(99, 1, 1, 'permissions', 'acp', 20, 209, 210, 'ACP_VIEW_USER_PERMISSIONS', 'view_user_global', 'acl_a_viewauth'),(100, 1, 1, 'permissions', 'acp', 20, 211, 212, 'ACP_VIEW_GLOBAL_MOD_PERMISSIONS', 'view_mod_global', 'acl_a_viewauth'),(101, 1, 1, 'permissions', 'acp', 20, 213, 214, 'ACP_VIEW_FORUM_MOD_PERMISSIONS', 'view_mod_local', 'acl_a_viewauth'),(102, 1, 1, 'permissions', 'acp', 20, 215, 216, 'ACP_VIEW_FORUM_PERMISSIONS', 'view_forum_local', 'acl_a_viewauth'),(103, 1, 1, 'php_info', 'acp', 29, 267, 268, 'ACP_PHP_INFO', 'info', 'acl_a_phpinfo'),(104, 1, 1, 'profile', 'acp', 13, 123, 124, 'ACP_CUSTOM_PROFILE_FIELDS', 'profile', 'acl_a_profile'),(105, 1, 1, 'prune', 'acp', 7, 71, 72, 'ACP_PRUNE_FORUMS', 'forums', 'acl_a_prune'),(106, 1, 1, 'prune', 'acp', 15, 165, 166, 'ACP_PRUNE_USERS', 'users', 'acl_a_userdel'),(107, 1, 1, 'ranks', 'acp', 13, 125, 126, 'ACP_MANAGE_RANKS', 'ranks', 'acl_a_ranks'),(108, 1, 1, 'reasons', 'acp', 29, 269, 270, 'ACP_MANAGE_REASONS', 'main', 'acl_a_reasons'),(109, 1, 1, 'search', 'acp', 5, 61, 62, 'ACP_SEARCH_SETTINGS', 'settings', 'acl_a_search'),(110, 1, 1, 'search', 'acp', 26, 251, 252, 'ACP_SEARCH_INDEX', 'index', 'acl_a_search'),(111, 1, 1, 'send_statistics', 'acp', 5, 63, 64, 'ACP_SEND_STATISTICS', 'send_statistics', 'acl_a_server'),(112, 1, 1, 'styles', 'acp', 22, 221, 222, 'ACP_STYLES', 'style', 'acl_a_styles'),(113, 1, 1, 'styles', 'acp', 23, 225, 226, 'ACP_TEMPLATES', 'template', 'acl_a_styles'),(114, 1, 1, 'styles', 'acp', 23, 227, 228, 'ACP_THEMES', 'theme', 'acl_a_styles'),(115, 1, 1, 'styles', 'acp', 23, 229, 230, 'ACP_IMAGESETS', 'imageset', 'acl_a_styles'),(116, 1, 1, 'update', 'acp', 28, 257, 258, 'ACP_VERSION_CHECK', 'version_check', 'acl_a_board'),(117, 1, 1, 'users', 'acp', 13, 115, 116, 'ACP_MANAGE_USERS', 'overview', 'acl_a_user'),(118, 1, 0, 'users', 'acp', 13, 127, 128, 'ACP_USER_FEEDBACK', 'feedback', 'acl_a_user'),(119, 1, 0, 'users', 'acp', 13, 129, 130, 'ACP_USER_WARNINGS', 'warnings', 'acl_a_user'),(120, 1, 0, 'users', 'acp', 13, 131, 132, 'ACP_USER_PROFILE', 'profile', 'acl_a_user'),(121, 1, 0, 'users', 'acp', 13, 133, 134, 'ACP_USER_PREFS', 'prefs', 'acl_a_user'),(122, 1, 0, 'users', 'acp', 13, 135, 136, 'ACP_USER_AVATAR', 'avatar', 'acl_a_user'),(123, 1, 0, 'users', 'acp', 13, 137, 138, 'ACP_USER_RANK', 'rank', 'acl_a_user'),(124, 1, 0, 'users', 'acp', 13, 139, 140, 'ACP_USER_SIG', 'sig', 'acl_a_user'),(125, 1, 0, 'users', 'acp', 13, 141, 142, 'ACP_USER_GROUPS', 'groups', 'acl_a_user && acl_a_group'),(126, 1, 0, 'users', 'acp', 13, 143, 144, 'ACP_USER_PERM', 'perm', 'acl_a_user && acl_a_viewauth'),(127, 1, 0, 'users', 'acp', 13, 145, 146, 'ACP_USER_ATTACH', 'attach', 'acl_a_user'),(128, 1, 1, 'words', 'acp', 10, 99, 100, 'ACP_WORDS', 'words', 'acl_a_words'),(129, 1, 1, 'users', 'acp', 2, 5, 6, 'ACP_MANAGE_USERS', 'overview', 'acl_a_user'),(130, 1, 1, 'groups', 'acp', 2, 7, 8, 'ACP_GROUPS_MANAGE', 'manage', 'acl_a_group'),(131, 1, 1, 'forums', 'acp', 2, 9, 10, 'ACP_MANAGE_FORUMS', 'manage', 'acl_a_forum'),(132, 1, 1, 'logs', 'acp', 2, 11, 12, 'ACP_MOD_LOGS', 'mod', 'acl_a_viewlogs'),(133, 1, 1, 'bots', 'acp', 2, 13, 14, 'ACP_BOTS', 'bots', 'acl_a_bots'),(134, 1, 1, 'php_info', 'acp', 2, 15, 16, 'ACP_PHP_INFO', 'info', 'acl_a_phpinfo'),(135, 1, 1, 'permissions', 'acp', 8, 75, 76, 'ACP_FORUM_PERMISSIONS', 'setting_forum_local', 'acl_a_fauth && (acl_a_authusers || acl_a_authgroups)'),(136, 1, 1, 'permissions', 'acp', 8, 77, 78, 'ACP_FORUM_PERMISSIONS_COPY', 'setting_forum_copy', 'acl_a_fauth && acl_a_authusers && acl_a_authgroups && acl_a_mauth'),(137, 1, 1, 'permissions', 'acp', 8, 79, 80, 'ACP_FORUM_MODERATORS', 'setting_mod_local', 'acl_a_mauth && (acl_a_authusers || acl_a_authgroups)'),(138, 1, 1, 'permissions', 'acp', 8, 81, 82, 'ACP_USERS_FORUM_PERMISSIONS', 'setting_user_local', 'acl_a_authusers && (acl_a_mauth || acl_a_fauth)'),(139, 1, 1, 'permissions', 'acp', 8, 83, 84, 'ACP_GROUPS_FORUM_PERMISSIONS', 'setting_group_local', 'acl_a_authgroups && (acl_a_mauth || acl_a_fauth)'),(140, 1, 1, '', 'mcp', 0, 1, 10, 'MCP_MAIN', '', ''),(141, 1, 1, '', 'mcp', 0, 11, 18, 'MCP_QUEUE', '', ''),(142, 1, 1, '', 'mcp', 0, 19, 32, 'MCP_REPORTS', '', ''),(143, 1, 1, '', 'mcp', 0, 33, 38, 'MCP_NOTES', '', ''),(144, 1, 1, '', 'mcp', 0, 39, 48, 'MCP_WARN', '', ''),(145, 1, 1, '', 'mcp', 0, 49, 56, 'MCP_LOGS', '', ''),(146, 1, 1, '', 'mcp', 0, 57, 64, 'MCP_BAN', '', ''),(147, 1, 1, 'ban', 'mcp', 146, 58, 59, 'MCP_BAN_USERNAMES', 'user', 'acl_m_ban'),(148, 1, 1, 'ban', 'mcp', 146, 60, 61, 'MCP_BAN_IPS', 'ip', 'acl_m_ban'),(149, 1, 1, 'ban', 'mcp', 146, 62, 63, 'MCP_BAN_EMAILS', 'email', 'acl_m_ban'),(150, 1, 1, 'logs', 'mcp', 145, 50, 51, 'MCP_LOGS_FRONT', 'front', 'acl_m_ || aclf_m_'),(151, 1, 1, 'logs', 'mcp', 145, 52, 53, 'MCP_LOGS_FORUM_VIEW', 'forum_logs', 'acl_m_,$id'),(152, 1, 1, 'logs', 'mcp', 145, 54, 55, 'MCP_LOGS_TOPIC_VIEW', 'topic_logs', 'acl_m_,$id'),(153, 1, 1, 'main', 'mcp', 140, 2, 3, 'MCP_MAIN_FRONT', 'front', ''),(154, 1, 1, 'main', 'mcp', 140, 4, 5, 'MCP_MAIN_FORUM_VIEW', 'forum_view', 'acl_m_,$id'),(155, 1, 1, 'main', 'mcp', 140, 6, 7, 'MCP_MAIN_TOPIC_VIEW', 'topic_view', 'acl_m_,$id'),(156, 1, 1, 'main', 'mcp', 140, 8, 9, 'MCP_MAIN_POST_DETAILS', 'post_details', 'acl_m_,$id || (!$id && aclf_m_)'),(157, 1, 1, 'notes', 'mcp', 143, 34, 35, 'MCP_NOTES_FRONT', 'front', ''),(158, 1, 1, 'notes', 'mcp', 143, 36, 37, 'MCP_NOTES_USER', 'user_notes', ''),(159, 1, 1, 'pm_reports', 'mcp', 142, 20, 21, 'MCP_PM_REPORTS_OPEN', 'pm_reports', 'aclf_m_report'),(160, 1, 1, 'pm_reports', 'mcp', 142, 22, 23, 'MCP_PM_REPORTS_CLOSED', 'pm_reports_closed', 'aclf_m_report'),(161, 1, 1, 'pm_reports', 'mcp', 142, 24, 25, 'MCP_PM_REPORT_DETAILS', 'pm_report_details', 'aclf_m_report'),(162, 1, 1, 'queue', 'mcp', 141, 12, 13, 'MCP_QUEUE_UNAPPROVED_TOPICS', 'unapproved_topics', 'aclf_m_approve'),(163, 1, 1, 'queue', 'mcp', 141, 14, 15, 'MCP_QUEUE_UNAPPROVED_POSTS', 'unapproved_posts', 'aclf_m_approve'),(164, 1, 1, 'queue', 'mcp', 141, 16, 17, 'MCP_QUEUE_APPROVE_DETAILS', 'approve_details', 'acl_m_approve,$id || (!$id && aclf_m_approve)'),(165, 1, 1, 'reports', 'mcp', 142, 26, 27, 'MCP_REPORTS_OPEN', 'reports', 'aclf_m_report'),(166, 1, 1, 'reports', 'mcp', 142, 28, 29, 'MCP_REPORTS_CLOSED', 'reports_closed', 'aclf_m_report'),(167, 1, 1, 'reports', 'mcp', 142, 30, 31, 'MCP_REPORT_DETAILS', 'report_details', 'acl_m_report,$id || (!$id && aclf_m_report)'),(168, 1, 1, 'warn', 'mcp', 144, 40, 41, 'MCP_WARN_FRONT', 'front', 'aclf_m_warn'),(169, 1, 1, 'warn', 'mcp', 144, 42, 43, 'MCP_WARN_LIST', 'list', 'aclf_m_warn'),(170, 1, 1, 'warn', 'mcp', 144, 44, 45, 'MCP_WARN_USER', 'warn_user', 'aclf_m_warn'),(171, 1, 1, 'warn', 'mcp', 144, 46, 47, 'MCP_WARN_POST', 'warn_post', 'acl_m_warn && acl_f_read,$id'),(172, 1, 1, '', 'ucp', 0, 1, 12, 'UCP_MAIN', '', ''),(173, 1, 1, '', 'ucp', 0, 13, 22, 'UCP_PROFILE', '', ''),(174, 1, 1, '', 'ucp', 0, 23, 30, 'UCP_PREFS', '', ''),(175, 1, 1, '', 'ucp', 0, 31, 42, 'UCP_PM', '', ''),(176, 1, 1, '', 'ucp', 0, 43, 48, 'UCP_USERGROUPS', '', ''),(177, 1, 1, '', 'ucp', 0, 49, 54, 'UCP_ZEBRA', '', ''),(178, 1, 1, 'attachments', 'ucp', 172, 10, 11, 'UCP_MAIN_ATTACHMENTS', 'attachments', 'acl_u_attach'),(179, 1, 1, 'groups', 'ucp', 176, 44, 45, 'UCP_USERGROUPS_MEMBER', 'membership', ''),(180, 1, 1, 'groups', 'ucp', 176, 46, 47, 'UCP_USERGROUPS_MANAGE', 'manage', ''),(181, 1, 1, 'main', 'ucp', 172, 2, 3, 'UCP_MAIN_FRONT', 'front', ''),(182, 1, 1, 'main', 'ucp', 172, 4, 5, 'UCP_MAIN_SUBSCRIBED', 'subscribed', ''),(183, 1, 1, 'main', 'ucp', 172, 6, 7, 'UCP_MAIN_BOOKMARKS', 'bookmarks', 'cfg_allow_bookmarks'),(184, 1, 1, 'main', 'ucp', 172, 8, 9, 'UCP_MAIN_DRAFTS', 'drafts', ''),(185, 1, 0, 'pm', 'ucp', 175, 32, 33, 'UCP_PM_VIEW', 'view', 'cfg_allow_privmsg'),(186, 1, 1, 'pm', 'ucp', 175, 34, 35, 'UCP_PM_COMPOSE', 'compose', 'cfg_allow_privmsg'),(187, 1, 1, 'pm', 'ucp', 175, 36, 37, 'UCP_PM_DRAFTS', 'drafts', 'cfg_allow_privmsg'),(188, 1, 1, 'pm', 'ucp', 175, 38, 39, 'UCP_PM_OPTIONS', 'options', 'cfg_allow_privmsg'),(189, 1, 0, 'pm', 'ucp', 175, 40, 41, 'UCP_PM_POPUP_TITLE', 'popup', 'cfg_allow_privmsg'),(190, 1, 1, 'prefs', 'ucp', 174, 24, 25, 'UCP_PREFS_PERSONAL', 'personal', ''),(191, 1, 1, 'prefs', 'ucp', 174, 26, 27, 'UCP_PREFS_POST', 'post', ''),(192, 1, 1, 'prefs', 'ucp', 174, 28, 29, 'UCP_PREFS_VIEW', 'view', ''),(193, 1, 1, 'profile', 'ucp', 173, 14, 15, 'UCP_PROFILE_PROFILE_INFO', 'profile_info', ''),(194, 1, 1, 'profile', 'ucp', 173, 16, 17, 'UCP_PROFILE_SIGNATURE', 'signature', ''),(195, 1, 1, 'profile', 'ucp', 173, 18, 19, 'UCP_PROFILE_AVATAR', 'avatar', 'cfg_allow_avatar && (cfg_allow_avatar_local || cfg_allow_avatar_remote || cfg_allow_avatar_upload || cfg_allow_avatar_remote_upload)'),(196, 1, 1, 'profile', 'ucp', 173, 20, 21, 'UCP_PROFILE_REG_DETAILS', 'reg_details', ''),(197, 1, 1, 'zebra', 'ucp', 177, 50, 51, 'UCP_ZEBRA_FRIENDS', 'friends', ''),(198, 1, 1, 'zebra', 'ucp', 177, 52, 53, 'UCP_ZEBRA_FOES', 'foes', ''),(258, 1, 1, '', 'acp', 31, 354, 357, 'ALTT_TITLE', '', ''),(259, 1, 1, 'altt', 'acp', 258, 355, 356, 'ALTT_CONFIG', 'overview', 'acl_a_board'),(260, 0, 1, 'version_check', 'acp', 76, 274, 275, 'ACP_MOD_VERSION_CHECK', 'version_check', 'acl_a_board'),(207, 1, 1, '', 'acp', 0, 359, 366, 'ACP_CAT_MODS', '', 'acl_a_mods'),(208, 1, 1, '', 'acp', 207, 360, 365, 'ACP_MODS', '', 'acl_a_mods'),(209, 1, 1, 'mods', 'acp', 208, 361, 362, 'ACP_AUTOMOD', 'frontend', 'acl_a_mods'),(210, 1, 1, 'mods', 'acp', 208, 363, 364, 'ACP_AUTOMOD_CONFIG', 'config', 'acl_a_mods'),(237, 1, 1, 'announce', 'mcp', 236, 66, 67, 'MCP_ANNOUNCE_FRONT', 'front', 'acl_m_announcement_centre'),(236, 1, 1, '', 'mcp', 0, 65, 68, 'MCP_ANNOUNCEMENTS_CENTRE', '', 'acl_m_announcement_centre'),(235, 1, 1, 'announcements_centre', 'acp', 233, 315, 316, 'ACP_ANNOUNCEMENTS_CENTRE_CONFIG', 'config', 'acl_a_announcement_centre'),(234, 1, 1, 'announcements_centre', 'acp', 233, 313, 314, 'ACP_ANNOUNCEMENTS_CENTRE', 'announcements', 'acl_a_announcement_centre'),(233, 1, 1, '', 'acp', 31, 312, 317, 'ACP_ANNOUNCEMENTS_CENTRE', '', 'acl_a_announcement_centre'),(227, 1, 1, '', 'acp', 31, 302, 311, 'ACP_THANKS', '', ''),(228, 1, 1, 'thanks', 'acp', 227, 303, 304, 'ACP_THANKS_SETTINGS', 'thanks', 'acl_a_board'),(229, 1, 1, 'thanks_refresh', 'acp', 227, 305, 306, 'ACP_THANKS_REFRESH', 'thanks', 'acl_a_board'),(230, 1, 1, 'thanks_truncate', 'acp', 227, 307, 308, 'ACP_THANKS_TRUNCATE', 'thanks', 'acl_a_board'),(231, 1, 1, 'thanks_reput', 'acp', 227, 309, 310, 'ACP_THANKS_REPUT_SETTINGS', 'thanks', 'acl_a_board'),(238, 1, 1, 'ads', 'acp', 3, 41, 42, 'ACP_ADVERTISEMENT_MANAGEMENT', 'default', 'acl_a_ads'),(239, 1, 1, 'database_or', 'acp', 26, 249, 250, 'ACP_DATABASE_OR', 'view', 'acl_a_backup'),(240, 0, 1, '', 'acp', 31, 318, 353, 'ACP_PORTAL_INFO', '', ''),(241, 1, 1, 'portal', 'acp', 240, 319, 320, 'ACP_PORTAL_GENERAL_INFO', 'general', 'acl_a_portal_manage'),(242, 1, 1, 'portal', 'acp', 240, 321, 322, 'ACP_PORTAL_NEWS_INFO', 'news', 'acl_a_portal_manage'),(243, 1, 1, 'portal', 'acp', 240, 323, 324, 'ACP_PORTAL_ANNOUNCEMENTS_INFO', 'announcements', 'acl_a_portal_manage'),(244, 1, 1, 'portal', 'acp', 240, 325, 326, 'ACP_PORTAL_WELCOME_INFO', 'welcome', 'acl_a_portal_manage'),(245, 1, 1, 'portal', 'acp', 240, 327, 328, 'ACP_PORTAL_RECENT_INFO', 'recent', 'acl_a_portal_manage'),(246, 1, 1, 'portal', 'acp', 240, 329, 330, 'ACP_PORTAL_WORDGRAPH_INFO', 'wordgraph', 'acl_a_portal_manage'),(247, 1, 1, 'portal', 'acp', 240, 331, 332, 'ACP_PORTAL_PAYPAL_INFO', 'paypal', 'acl_a_portal_manage'),(248, 1, 1, 'portal', 'acp', 240, 333, 334, 'ACP_PORTAL_ATTACHMENTS_INFO', 'attachments', 'acl_a_portal_manage'),(249, 1, 1, 'portal', 'acp', 240, 335, 336, 'ACP_PORTAL_MEMBERS_INFO', 'members', 'acl_a_portal_manage'),(250, 1, 1, 'portal', 'acp', 240, 337, 338, 'ACP_PORTAL_POLLS_INFO', 'polls', 'acl_a_portal_manage'),(251, 1, 1, 'portal', 'acp', 240, 339, 340, 'ACP_PORTAL_BOTS_INFO', 'bots', 'acl_a_portal_manage'),(252, 1, 1, 'portal', 'acp', 240, 341, 342, 'ACP_PORTAL_POSTER_INFO', 'poster', 'acl_a_portal_manage'),(253, 1, 1, 'portal', 'acp', 240, 343, 344, 'ACP_PORTAL_MINICALENDAR_INFO', 'minicalendar', 'acl_a_portal_manage'),(254, 1, 1, 'portal', 'acp', 240, 345, 346, 'ACP_PORTAL_CUSTOMBLOCK_INFO', 'customblock', 'acl_a_portal_manage'),(255, 1, 1, 'portal', 'acp', 240, 347, 348, 'ACP_PORTAL_LINKS_INFO', 'links', 'acl_a_portal_manage'),(256, 1, 1, 'portal', 'acp', 240, 349, 350, 'ACP_PORTAL_FRIENDS_INFO', 'friends', 'acl_a_portal_manage'),(257, 1, 1, 'portal', 'acp', 240, 351, 352, 'ACP_PORTAL_BIRTHDAYS_INFO', 'birthdays', 'acl_a_portal_manage');



Many thanks for your assistance and apologies for tying up your time.

[Handyman]

It's impossible for me to tell if the left and right id's are matching up just looking at a database dump in that format. If you use a good database tool, it should be easy to tell.

Left and right id's should always start at 1 (for the top most module) and count up in something like this:
left_id, right_id
1, 10
- 2, 3
- 4, 7
--- 5, 6
- 8, 9

See how you can follow the order: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10?
1, 10 indicates this is a parent module containing sub-modules 2-9 (10 - 1 = 9, there are 4 sub-modules under this parent module).
2, 3 indicates this is a module with no sub modules (3 - 2 = 1)
4, 7 indicates that there is 1 sub module under this parent module (7 - 4 = 3, 1 sub module under this parent module)
5, 6 (6-5 = 1, no sub modules under this module)
8, 9 (9-8 = 1, no sub modules under this module)
If the modules are out of sync, when you try to count them like that, something won't match up.

Easiest way to count them is to view the data in the modules table and order it by left_id.
Hopefully that makes some resemblance of sense

[Boardtalknet]

Hopefully that makes some resemblance of sense

Unfortunately it does…
I’m going to search for a database tool that can check left and right id’s
It could be a day or two before I get back to you

Thanks for your help .

[Handyman]

MySQL workbench and Navicat are 2 tools I know would do it.
MySQL workbench is free and Navicat has a free version that should work great. Navicat has a tunnel file that you would upload to your server so your database could still remain local access only.

I also thought phpMyAdmin had sortable columns? It's been so long since I've used it, that I don't know for sure.

[topdown]

Yes, you can sort columns in phpMyAdmin.
Just click on the field name and it will order by it.

http://www.phpbb.com/support/stk/

Is also suppose to re-order Left and Right ids.

Fix Left/Right ID's: Repairs the tree structure of the forums and modules.

I have never tried it though.

Just make a backup of your database first.

[WileCoyote]

Is it possible to adapt the mod (only the php 5 part) so that it can handle versions like this: 1.0.1.1 ? At the moment such a numbering would be cut to 1.0.11. See also the discussion here

Regards
WileCoyote