Code:# Sommaire Paramétrable v3.0 beta 1 DB tables
# Import this file in your DB, using PHPMyAdmin for example
CREATE TABLE `nuke_sommaire` (
`groupmenu` int(2) NOT NULL default '0',
`name` varchar(200) default NULL,
`image` varchar(99) default NULL,
`lien` text,
`hr` char(2) default NULL,
`center` char(2) default NULL,
`bgcolor` tinytext,
`invisible` int(1) default NULL,
`class` tinytext,
`bold` char(2) default NULL,
`new` char(2) default NULL,
`listbox` char(2) default NULL,
`dynamic` char(2) default NULL,
`date_debut` bigint(20) unsigned NOT NULL default '0',
`date_fin` bigint(20) unsigned NOT NULL default '0',
`days` varchar(8) default NULL,
PRIMARY KEY (`groupmenu`)
) ENGINE=MyISAM;
INSERT INTO `nuke_sommaire` (`groupmenu`, `name`, `image`, `lien`, `hr`, `center`, `bgcolor`, `invisible`, `class`, `bold`, `new`, `listbox`, `dynamic`, `date_debut`, `date_fin`, `days`) VALUES (0, 'Accueil', 'icon_home.gif', 'index.php', '', '', '', 4, 'storytitle', '', '', '', 'on', 0, 0, ''),
(1, 'Discussions', 'icon_community.gif', '', 'on', '', '', 4, 'storytitle', '', '', '', 'on', 0, 0, ''),
(2, 'News', 'favoritos.gif', '', '', '', '', 4, 'storytitle', '', '', '', 'on', 0, 0, ''),
(3, 'Downloads & Liens', 'som_downloads.gif', '', '', '', '', 4, 'storytitle', '', '', '', 'on', 0, 0, ''),
(4, 'Contenu', 'icon_poll.gif', '', '', '', '', 4, 'storytitle', '', '', '', 'on', 0, 0, ''),
(5, 'Infos', 'icon_members.gif', '', '', '', '', 4, 'storytitle', '', '', '', 'on', 0, 0, ''),
(99, '', NULL, NULL, NULL, NULL, NULL, 4, NULL, NULL, NULL, NULL, 'on', 0, 0, NULL);
CREATE TABLE `nuke_sommaire_categories` (
`id` int(11) NOT NULL auto_increment,
`groupmenu` int(2) NOT NULL default '0',
`module` varchar(50) NOT NULL default '',
`url` text NOT NULL,
`url_text` text NOT NULL,
`image` varchar(50) NOT NULL default '',
`new` char(2) default NULL,
`new_days` tinyint(4) NOT NULL default '-1',
`class` varchar(20) default NULL,
`bold` char(2) default NULL,
`sublevel` tinyint(3) NOT NULL default '0',
`date_debut` bigint(20) unsigned NOT NULL default '0',
`date_fin` bigint(20) unsigned NOT NULL default '0',
`days` varchar(8) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM ;
INSERT INTO `nuke_sommaire_categories` (`id`, `groupmenu`, `module`, `url`, `url_text`, `image`, `new`, `new_days`, `class`, `bold`, `sublevel`, `date_debut`, `date_fin`, `days`) VALUES (21, 1, 'Forums', '', '', 'tree-T.gif', '', 7, 'boxcontent', 'on', 0, 0, 0, ''),
(22, 1, 'Members_List', '', '', 'tree-L.gif', '', 7, 'boxcontent', '', 0, 0, 0, ''),
(23, 2, 'News', '', '', 'tree-T.gif', '', 7, 'boxcontent', '', 0, 0, 0, ''),
(24, 2, 'Topics', '', '', 'tree-T.gif', '', 7, 'boxcontent', '', 0, 0, 0, ''),
(25, 2, 'Submit_News', '', '', 'tree-L.gif', '', 7, 'boxcontent', '', 0, 0, 0, ''),
(26, 3, 'Downloads', '', '', 'tree-T.gif', '', 7, 'boxcontent', '', 0, 0, 0, ''),
(27, 3, 'Web_Links', '', '', 'tree-L.gif', '', 7, 'boxcontent', '', 0, 0, 0, ''),
(28, 4, 'Content', '', '', 'tree-T.gif', '', 7, 'boxcontent', '', 0, 0, 0, ''),
(29, 4, 'Encyclopedia', '', '', 'tree-T.gif', '', 7, 'boxcontent', '', 0, 0, 0, ''),
(30, 4, 'Reviews', '', '', 'tree-T.gif', '', 7, 'boxcontent', '', 0, 0, 0, ''),
(31, 4, 'Top', '', '', 'tree-L.gif', '', 7, 'boxcontent', '', 0, 0, 0, ''),
(32, 5, 'Feedback', '', '', 'tree-T.gif', '', 7, 'boxcontent', '', 0, 0, 0, ''),
(33, 5, 'Recommend_Us', '', '', 'tree-T.gif', '', 7, 'boxcontent', '', 0, 0, 0, ''),
(34, 5, 'Statistics', '', '', 'tree-T.gif', '', 7, 'boxcontent', '', 0, 0, 0, ''),
(35, 5, 'Search', '', '', 'tree-T.gif', '', 7, 'boxcontent', '', 0, 0, 0, ''),
(36, 5, 'Journal', '', '', 'tree-T.gif', '', 7, 'boxcontent', '', 0, 0, 0, ''),
(37, 5, 'Your_Account', '', '', 'tree-L.gif', '', 7, 'boxcontent', '', 0, 0, 0, '');
|