Das wäre dann die ursprüngliche Tabelle.
Code: Alles auswählen
CREATE TABLE IF NOT EXISTS `phpbb_menu_colors` (
`color_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`color_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`color_text` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT 'FFFFFF',
`color_text_hover` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT 'FFFFFF',
`color_text_hover_decor` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT 'none',
`color_text_weight` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT 'bold',
`color_display_search` tinyint(1) unsigned NOT NULL DEFAULT '1',
`color_text_transform` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT 'none',
`color_align` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT 'left',
`color_style_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`color_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=6 ;
INSERT IGNORE INTO `phpbb_menu_colors` (`color_id`, `color_name`, `color_text`, `color_text_hover`, `color_text_hover_decor`, `color_text_weight`, `color_display_search`, `color_text_transform`, `color_align`, `color_style_id`) VALUES
(1, 'blue', 'FFFFFF', 'FFFFFF', 'none', 'bold', 1, 'none', 'left', 1),
(2, 'black', 'FFFFFF', 'FFFFFF', 'none', 'bold', 1, 'none', 'left', 0),
(3, 'brown', 'FFFFFF', 'FFFFFF', 'none', 'bold', 1, 'none', 'left', 0),
(4, 'gray', 'FFFFFF', 'FFFFFF', 'none', 'bold', 1, 'none', 'left', 0),
(5, 'orange', 'FFFFFF', 'FFFFFF', 'none', 'bold', 1, 'none', 'left', 0);
9 .. das geht nur bis 1. Also scheint es doch schonmal funktioniert zu haben. Wo sollte sonst die "Idee" des Skripts herkommen, nach der ID 9 zu suchen?