wishlist
Hi,
I am glad that version 2.10 is working now as expected. What I always miss is the administration of menus for websites. We often have one or two, sometimes even three levels of menus which need to have proper administration. I solve it with a query like:
mysql_select_db($database_mydatabase, $mydatabase);
$query_rsCatselect = "SELECT main.header AS mainheader, main.categories_id AS main_id, main.sort AS mainsorter, sub.header AS subheader, sub.categories_id AS sub_id, sub.sort AS subsorter, main.online AS mainonline, sub.online AS subonline FROM categories AS main, categories AS sub WHERE sub.parent=main.categories_id AND main.online = 'Y' ORDER BY mainsorter, subsorter";
$rsCatselect = mysql_query($query_rsCatselect, $sob) or die(mysql_error());
$row_rsCatselect = mysql_fetch_assoc($rsCatselect);
$totalRows_rsCatselect = mysql_num_rows($rsCatselect);
For the main categories I need another query where parent = 0.
I really would like to have something more clever than doing it by hand.
Fortunately there is this great extension called Menuwriter which is built and made to deal exactly with this kind of structure (dynamic menu - nested)
I would like to have an administrative tool to setup a menu more quickly. Also the menu structure from Data Assist for categories needs modification:
CREATE TABLE `productcategories` (
`CategoryID` int(11) NOT NULL auto_increment,
`CategoryName` varchar(50) NOT NULL,
PRIMARY KEY (`CategoryID`)
) ;
to something like:
CREATE TABLE `productcategories` (
`CategoryID` int(11) NOT NULL AUTO_INCREMENT,
`CategoryParent` int(8) NOT NULL,
`CategoryName` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`CategoryID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
Do you think this idea could be included in version 3 of DA?