'; // 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); // Now insert our unqiue key for action-what combination SQL_QUERY_ESC("ALTER TABLE `{?_MYSQL_PREFIX?}_%s_menu` DROP KEY `action_what`", array($menu), __FILE__, __LINE__); SQL_QUERY_ESC("ALTER TABLE `{?_MYSQL_PREFIX?}_%s_menu` ADD UNIQUE `action_what` (`action` , `what`)", array($menu), __FILE__, __LINE__); // Now insert our unqiue key for what SQL_QUERY_ESC("ALTER TABLE `{?_MYSQL_PREFIX?}_%s_menu` DROP KEY `what`", array($menu), __FILE__, __LINE__); SQL_QUERY_ESC("ALTER TABLE `{?_MYSQL_PREFIX?}_%s_menu` ADD UNIQUE `what` (`what`)", array($menu), __FILE__, __LINE__); } // END - foreach // [EOF] ?>