how to use milonic with php/mysql

[miner2049er]

So after running the above source data through street9009's code, this is what resulting Milonic Menu SQL table data comes out (see below.)

As you can see, there are no menu levels named

BELOW BELOW ABOUT US

BELOW BELOW BELOW ABOUT US

Only one sub-menu gets created.

Does anyone have some advice? If any more details are needed, please let me know.



-- phpMyAdmin SQL Dump
-- version 2.6.0-rc1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Mar 26, 2007 at 12:07 AM
-- Server version: 4.0.20
-- PHP Version: 4.3.8
--
-- Database: `milonic`
--

-- --------------------------------------------------------

--
-- Table structure for table `mm_items`
--

CREATE TABLE `mm_items` (
`itemid` int(11) NOT NULL auto_increment,
`menuid` int(11) NOT NULL default '0',
`text` text,
`url` varchar(255) default NULL,
`showmenu` varchar(40) default NULL,
PRIMARY KEY (`itemid`)
) TYPE=MyISAM AUTO_INCREMENT=10 ;

--
-- Dumping data for table `mm_items`
--

INSERT INTO `mm_items` VALUES (1, 1, 'HOME', 'index.php', NULL);
INSERT INTO `mm_items` VALUES (2, 1, 'ABOUT US', 'index.php?categoryID=2', 'ABOUT US');
INSERT INTO `mm_items` VALUES (3, 3, 'BELOW ABOUT US', 'index.php?categoryID=31', 'BELOW ABOUT US');
INSERT INTO `mm_items` VALUES (4, 1, 'JOIN US', 'index.php?categoryID=18', 'JOIN US');
INSERT INTO `mm_items` VALUES (5, 5, 'BELOW JOIN US', 'index.php?categoryID=32', NULL);
INSERT INTO `mm_items` VALUES (6, 1, 'CLASSES', 'index.php?categoryID=19', NULL);
INSERT INTO `mm_items` VALUES (7, 1, 'EVENTS', 'index.php?categoryID=30', NULL);
INSERT INTO `mm_items` VALUES (8, 1, 'LOCATIONS', 'index.php?categoryID=17', NULL);
INSERT INTO `mm_items` VALUES (9, 1, 'DONATE', 'index.php?categoryID=15', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mm_menus`
--

CREATE TABLE `mm_menus` (
`menuid` int(11) NOT NULL auto_increment,
`projectid` int(11) NOT NULL default '0',
`styleid` int(11) NOT NULL default '0',
`name` varchar(40) NOT NULL default '',
`alwaysvisible` tinyint(1) default NULL,
`orientation` tinyint(1) default NULL,
`overflow` varchar(20) default NULL,
PRIMARY KEY (`menuid`)
) TYPE=MyISAM AUTO_INCREMENT=10 ;

--
-- Dumping data for table `mm_menus`
--

INSERT INTO `mm_menus` VALUES (1, 1, 1, 'Main Menu', 1, 1, NULL);
INSERT INTO `mm_menus` VALUES (2, 1, 1, 'HOME', NULL, NULL, NULL);
INSERT INTO `mm_menus` VALUES (3, 1, 1, 'ABOUT US', NULL, NULL, NULL);
INSERT INTO `mm_menus` VALUES (4, 1, 1, 'BELOW ABOUT US', NULL, NULL, NULL);
INSERT INTO `mm_menus` VALUES (5, 1, 1, 'JOIN US', NULL, NULL, NULL);
INSERT INTO `mm_menus` VALUES (6, 1, 1, 'CLASSES', NULL, NULL, NULL);
INSERT INTO `mm_menus` VALUES (7, 1, 1, 'EVENTS', NULL, NULL, NULL);
INSERT INTO `mm_menus` VALUES (8, 1, 1, 'LOCATIONS', NULL, NULL, NULL);
INSERT INTO `mm_menus` VALUES (9, 1, 1, 'DONATE', NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `mm_projects`
--

CREATE TABLE `mm_projects` (
`projectid` int(11) NOT NULL auto_increment,
`menuCloseDelay` int(11) NOT NULL default '500',
`menuOpenDelay` int(11) NOT NULL default '150',
`subOffsetTop` tinyint(1) NOT NULL default '0',
`subOffsetLeft` tinyint(1) NOT NULL default '0',
`name` varchar(100) default NULL,
PRIMARY KEY (`projectid`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

--
-- Dumping data for table `mm_projects`
--

INSERT INTO `mm_projects` VALUES (1, 500, 150, 2, -3, 'Minimalist Menu');

-- --------------------------------------------------------

--
-- Table structure for table `mm_styles`
--

CREATE TABLE `mm_styles` (
`styleid` int(11) NOT NULL auto_increment,
`name` varchar(40) NOT NULL default '',
`oncolor` varchar(6) default NULL,
`onbgcolor` varchar(6) default NULL,
`offcolor` varchar(6) default NULL,
`offbgcolor` varchar(6) default NULL,
`padding` tinyint(4) default NULL,
`separatorsize` tinyint(4) default NULL,
`borderwidth` tinyint(4) default NULL,
`fontfamily` varchar(25) default NULL,
`fontsize` varchar(6) default NULL,
PRIMARY KEY (`styleid`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

--
-- Dumping data for table `mm_styles`
--

INSERT INTO `mm_styles` VALUES (1, 'miniStyle', 'FFFFFF', 'F67979', '000000', 'EEEEEE', 6, 1, 1, 'verdana', '12px');

[miner2049er]

I also noticed further down in this other thread...

viewtopic.php?t=7220

that people were having a similar problem with people getting deeper menu levels to display. Specifically member "jonjon" on page 2 of the thread.

Could this be related to the problem I am having?

[Ruth]

Hi,

I've posted to Milonic since I have no knowledge of the mysql/php menus. You did note that street said his 'code' was specific to that particular e-commerce software - Shop Script?

Ruth

[miner2049er]

In a post on March 7, the administrator Andy wrote "Hi, Send us your data and we'll take a look", which I have done now in this thread, and am hoping for any insights.

The code is earlier in this thread, plus the source and destination data.

As mentioned previously, the source data I use (and as used by the shop script earlier) is quite basic, and is...

categoryID - parent - name

1 - 0 - Top
2 - 1 - ABOUT US
18 - 1 - JOIN US
19 - 1 - CLASSES
30 - 1 - EVENTS
31 - 2 - BELOW ABOUT US
32 - 18 - BELOW JOIN US
17 - 1 - LOCATIONS
15 - 1 - DONATE
33 - 31 - BELOW BELOW ABOUT US
34 - 33 - BELOW BELOW BELOW ABOUT US

but somehow it doesn't get transformed into a correct Milonic menu.

Please assist.