[MODDB]MOD Version Check 1.0.2

Converters for phpBB2 MODs to phpBB3, MOD Tools, Automatic MOD installers, Tools for MOD Developers and programmers.

How would you rate this mod?

Excellent!
18
82%
Very Good
3
14%
Good
1
5%
Fair
0
No votes
Poor
0
No votes
 
Total votes : 22

Re: [MODDB]MOD Version Check 1.0.2

Postby Handyman » 28 Jul 2011, 12:57

It could also be that the modules got out of sync. I wonder if there's a resync somewhere… I don't remember :think:
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.
Please contact me if you have any news to submit to SCOFF News.
SCOFFing at the candidates while you sleep.
My Mods || My Mod Queue
Image
User avatar
Handyman    
Rear Fleet Admiral
Rear Fleet Admiral
 
Posts: 7459
Joined: 08 May 2006, 04:45
Location: Where no man has gone before!
Favorite Team: Seattle Seahawks
Gender: Male


Re: [MODDB]MOD Version Check 1.0.2

Postby Boardtalknet » 28 Jul 2011, 17:34

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

Handyman wrote:..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.
Image
User avatar
Boardtalknet
Cadet III
Cadet III
 
Posts: 33
Joined: 06 Jun 2009, 12:36
Gender: Female
phpBB Knowledge: 4

Re: [MODDB]MOD Version Check 1.0.2

Postby Handyman » 28 Jul 2011, 17:50

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 :grin:
Please contact me if you have any news to submit to SCOFF News.
SCOFFing at the candidates while you sleep.
My Mods || My Mod Queue
Image
User avatar
Handyman    
Rear Fleet Admiral
Rear Fleet Admiral
 
Posts: 7459
Joined: 08 May 2006, 04:45
Location: Where no man has gone before!
Favorite Team: Seattle Seahawks
Gender: Male

Re: [MODDB]MOD Version Check 1.0.2

Postby Boardtalknet » 28 Jul 2011, 18:05

Handyman wrote:Hopefully that makes some resemblance of sense :grin:

Unfortunately it does… :blink:
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 :cray:

Thanks for your help ;) .
Image
User avatar
Boardtalknet
Cadet III
Cadet III
 
Posts: 33
Joined: 06 Jun 2009, 12:36
Gender: Female
phpBB Knowledge: 4

Re: [MODDB]MOD Version Check 1.0.2

Postby Handyman » 29 Jul 2011, 12:20

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.
Please contact me if you have any news to submit to SCOFF News.
SCOFFing at the candidates while you sleep.
My Mods || My Mod Queue
Image
User avatar
Handyman    
Rear Fleet Admiral
Rear Fleet Admiral
 
Posts: 7459
Joined: 08 May 2006, 04:45
Location: Where no man has gone before!
Favorite Team: Seattle Seahawks
Gender: Male

Re: [MODDB]MOD Version Check 1.0.2

Postby topdown » 29 Jul 2011, 12:51

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.
Do not PM me for Support unless I give permission in a post......PM's only help one, posts help everyone !
User avatar
topdown    
STG Styles Leader
STG Styles Leader
 
Posts: 3030
Joined: 01 Oct 2007, 22:56
Location: Handyman's harddrive
Favorite Team: STG Teams
Gender: Male
phpBB Knowledge: 9

Re: [MODDB]MOD Version Check 1.0.2

Postby WileCoyote » 28 Sep 2011, 06:57

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
WileCoyote
Crewman
Crewman
 
Posts: 6
Joined: 28 Sep 2011, 06:42
Location: Austria
Gender: Male
phpBB Knowledge: 6

Previous

Return to MOD, MODX - MOD Developer Tools and Converters

Who is online

Users browsing this forum: MSNbot Media and 2 guests

cron