'; // Only remove if we have at least 2 entries from same menu if ($entries > 1) { // Remove all except one if (is_null($entry['what'])) { // Main menu is double SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_%s_menu` WHERE `action`='%s' AND `what` IS NULL LIMIT %s", array($menu, $entry['action'], ($entries - 1)), __FILE__, __LINE__); } else { // Sub menu is double SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_%s_menu` WHERE `action`='%s' AND `what`='%s' LIMIT %s", array($menu, $entry['action'], $entry['what'], ($entries - 1)), __FILE__, __LINE__); } } // END - if } } // END - while // Free result SQL_FREERESULT($result); // Init sqls initSqls(); // Now insert our unqiue key for action-what combination addSql(sprintf("ALTER TABLE `{?_MYSQL_PREFIX?}_%s_menu` DROP KEY `action_what`", $menu)); addSql(sprintf("ALTER TABLE `{?_MYSQL_PREFIX?}_%s_menu` ADD UNIQUE `action_what` (`action` , `what`)", $menu)); // Now insert our unqiue key for what addSql(sprintf("ALTER TABLE `{?_MYSQL_PREFIX?}_%s_menu` DROP KEY `what`", $menu)); addSql(sprintf("ALTER TABLE `{?_MYSQL_PREFIX?}_%s_menu` ADD UNIQUE `what` (`what`)", $menu)); // And run all runFilterChain('run_sqls'); } // END - foreach // [EOF] ?>