Danyx 220
| Posté : 06-04-2016 06:34
Fichier sql de la V16, modifié suivant mon prérequis.
vous y trouverez des tables ne servant qu'a la V16, d'autre qu'a la Rev13 et efin certaines aux deux...
----------------
----------------
-- phpMyAdmin SQL Dump
-- version 4.0.10.7
-- <a href="http://www.phpmyadmin.net" target="_blank" class="noir">http://www.phpmyadmin.net</a>
--
-- Client: localhost:3306
-- Généré le: Mar 05 Avril 2016 à 08: 00
-- Version du serveur: 10.0.24-MariaDB
-- Version de PHP: 5.4.31
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS&nbs p;*/;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Base de données: `nom_de-votre bdd`
--
-- --------------------------------------------------------
--
-- Structure de la table `access`
--
CREATE TABLE IF NOT EXISTS `access` (
`access_id` int(10) NOT NULL AUTO_INCREMENT,
`access_title` varchar(20) DEFAULT NULL,
PRIMARY KEY (`access_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREME NT=4 ;
--
-- Contenu de la table `access`
--
INSERT INTO `access` (`access_id`, `access_title`) V ALUES
(1, 'User'),
(2, 'Moderator'),
(3, 'Super Moderator');
-- --------------------------------------------------------
--
-- Structure de la table `adminblock`
--
CREATE TABLE IF NOT EXISTS `adminblock` (
`title` varchar(250) DEFAULT NULL,
`content` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Contenu de la table `adminblock`
--
INSERT INTO `adminblock` (`title`, `content`) VALUES
('Administration', '<ul><li><a href="admin.php"><i class="fa fa-sign-in fa-2x"></i> Administration</a></li><li><a href="admin.php?op=logout" class=" text-danger"><i class="fa fa-sign-out fa-2x"></i> Logout</a></li><li><a href="http://labo.infocapagde.com/manuels/french/men_gen.html"><i class="fa fa-question-circle fa-2x text-primary"></i> Documentation</a></li></ul>');
-- --------------------------------------------------------
--
-- Structure de la table `appli_log`
--
CREATE TABLE IF NOT EXISTS `appli_log` (
`al_id` int(11) NOT NULL DEFAULT '0',
`al_name` varchar(255) DEFAULT NULL,
`al_subid` int(11) NOT NULL DEFAULT '0',
`al_date` datetime NOT NULL DEFAULT '000 0-00-00 00:00:00',
`al_uid` int(11) NOT NULL DEFAULT '0',
< br /> `al_data` text,
`al_ip` varchar(19) NOT NULL DEFAULT '',
`al_hostname` varchar(255) DEFAULT NULL,
KEY `al_id` (`al_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Contenu de la table `appli_log`
--
-- --------------------------------------------------------
--
-- Structure de la table `authors`
--
CREATE TABLE IF NOT EXISTS `authors` (
`aid` varchar(30) NOT NULL DEFAULT '',
< br /> `name` varchar(50) DEFAULT NULL,
`url` varchar(60) DEFAULT NULL,
`email` varchar(60) DEFAULT NULL,
`pwd` varchar(40) DEFAULT NULL,
`counter` int(11) NOT NULL DEFAULT '0',
`radminarticle` tinyint(2) NOT NULL DEFAULT&n bsp;'0',
`radmintopic` tinyint(2) NOT NULL DEFAULT&nbs p;'0',
`radminleft` tinyint(2) NOT NULL DEFAULT  ;'0',
`radminright` tinyint(2) NOT NULL DEFAULT&nbs p;'0',
`radminuser` tinyint(2) NOT NULL DEFAULT  ;'0',
`radminmain` tinyint(2) NOT NULL DEFAULT  ;'0',
`radminsurvey` tinyint(2) NOT NULL DEFAULT&nb sp;'0',
`radminsection` tinyint(2) NOT NULL DEFAULT&n bsp;'0',
`radminlink` tinyint(2) NOT NULL DEFAULT  ;'0',
`radminephem` tinyint(2) NOT NULL DEFAULT&nbs p;'0',
`radminfilem` tinyint(2) NOT NULL DEFAULT&nbs p;'0',
`radminhead` tinyint(2) NOT NULL DEFAULT  ;'0',
`radminfaq` tinyint(2) NOT NULL DEFAULT '0',
`radmindownload` tinyint(2) NOT NULL DEFAULT& nbsp;'0',
`radminforum` tinyint(2) NOT NULL DEFAULT&nbs p;'0',
`radminreviews` tinyint(2) NOT NULL DEFAULT&n bsp;'0',
`radminsdv` tinyint(2) NOT NULL DEFAULT '0',
`radminlnl` tinyint(2) NOT NULL DEFAULT '0',
`radminsuper` tinyint(2) NOT NULL DEFAULT&nbs p;'1',
PRIMARY KEY (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Contenu de la table `authors`
--
-- --------------------------------------------------------
--
-- Structure de la table `autonews`
--
CREATE TABLE IF NOT EXISTS `autonews` (
`anid` int(11) NOT NULL AUTO_INCREMENT,
`catid` int(11) NOT NULL DEFAULT '0',
`aid` varchar(30) NOT NULL DEFAULT '',
< br /> `title` varchar(255) DEFAULT NULL,
`time` varchar(19) NOT NULL DEFAULT '',
`hometext` text NOT NULL,
`bodytext` mediumtext,
`topic` int(3) NOT NULL DEFAULT '1',
`informant` varchar(20) NOT NULL DEFAULT  ;'',
`notes` text NOT NULL,
`ihome` int(1) NOT NULL DEFAULT '0',
`date_debval` datetime DEFAULT NULL,
`date_finval` datetime DEFAULT NULL,
`auto_epur` tinyint(1) unsigned NOT NULL  ;DEFAULT '0',
PRIMARY KEY (`anid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1&n bsp;;
-- --------------------------------------------------------
--
-- Structure de la table `banner`
--
CREATE TABLE IF NOT EXISTS `banner` (
`bid` int(11) NOT NULL AUTO_INCREMENT,
`cid` int(11) NOT NULL DEFAULT '0',
`imptotal` int(11) NOT NULL DEFAULT '0',
`impmade` int(11) NOT NULL DEFAULT '0',
`clicks` int(11) NOT NULL DEFAULT '0',
< br /> `imageurl` varchar(200) NOT NULL DEFAULT  ;'',
`clickurl` varchar(200) NOT NULL DEFAULT  ;'',
`userlevel` int(1) NOT NULL DEFAULT '0',
`date` datetime DEFAULT NULL,
PRIMARY KEY (`bid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1&n bsp;;
-- --------------------------------------------------------
--
-- Structure de la table `bannerclient`
--
CREATE TABLE IF NOT EXISTS `bannerclient` (
`cid` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(60) NOT NULL DEFAULT '',
`contact` varchar(60) NOT NULL DEFAULT ' ',
`email` varchar(60) NOT NULL DEFAULT '',
`login` varchar(10) NOT NULL DEFAULT '',
`passwd` varchar(10) NOT NULL DEFAULT '' ,
`extrainfo` text NOT NULL,
PRIMARY KEY (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1&n bsp;;
-- --------------------------------------------------------
--
-- Structure de la table `bannerfinish`
--
CREATE TABLE IF NOT EXISTS `bannerfinish` (
`bid` int(11) NOT NULL AUTO_INCREMENT,
`cid` int(11) NOT NULL DEFAULT '0',
`impressions` int(11) NOT NULL DEFAULT ' 0',
`clicks` int(11) NOT NULL DEFAULT '0',
< br /> `datestart` datetime DEFAULT NULL,
`dateend` datetime DEFAULT NULL,
PRIMARY KEY (`bid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1&n bsp;;
-- --------------------------------------------------------
--
-- Structure de la table `blocnotes`
--
CREATE TABLE IF NOT EXISTS `blocnotes` (
`bnid` tinytext NOT NULL,
`texte` text,
PRIMARY KEY (`bnid`(32))
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `catagories`
--
CREATE TABLE IF NOT EXISTS `catagories` (
`cat_id` int(10) NOT NULL AUTO_INCREMENT,
`cat_title` text,
PRIMARY KEY (`cat_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREME NT=93 ;
--
-- Contenu de la table `catagories`
--
-- --------------------------------------------------------
--
-- Structure de la table `chatbox`
--
CREATE TABLE IF NOT EXISTS `chatbox` (
`username` text,
`ip` varchar(20) NOT NULL DEFAULT '',
`message` text,
`date` int(15) NOT NULL DEFAULT '0',
`id` int(10) DEFAULT '0',
`dbname` tinyint(4) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Contenu de la table `chatbox`
--
-- --------------------------------------------------------
--
-- Structure de la table `compatsujet`
--
CREATE TABLE IF NOT EXISTS `compatsujet` (
`id1` varchar(30) NOT NULL DEFAULT '',
< br /> `id2` int(30) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Structure de la table `config`
--
CREATE TABLE IF NOT EXISTS `config` (
`allow_html` int(2) DEFAULT NULL,
`allow_bbcode` int(2) DEFAULT NULL,
`allow_sig` int(2) DEFAULT NULL,
`posts_per_page` int(10) DEFAULT NULL,
`hot_threshold` int(10) DEFAULT NULL,
`topics_per_page` int(10) DEFAULT NULL,
`allow_upload_forum` int(2) unsigned NOT NULL DEFAULT '0',
`allow_forum_hide` int(2) unsigned NOT NULL&n bsp;DEFAULT '0',
`upload_table` varchar(50) NOT NULL DEFAULT&n bsp;'forum_attachments',
`rank1` varchar(255) DEFAULT NULL,
`rank2` varchar(255) DEFAULT NULL,
`rank3` varchar(255) DEFAULT NULL,
`rank4` varchar(255) DEFAULT NULL,
`rank5` varchar(255) DEFAULT NULL,
`anti_flood` char(3) DEFAULT NULL,
`solved` int(2) unsigned NOT NULL DEFAUL T '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Contenu de la table `config`
--
INSERT INTO `config` (`allow_html`, `allow_bbcode`, `allow_sig`, `posts_per_page`, `hot_threshold`, `topics_per_page `, `allow_upload_forum`, `allow_forum_hide`, `upload_table`,&nbs p;`rank1`, `rank2`, `rank3`, `rank4`, `rank5`, `anti_f lood`, `solved`) VALUES
(1, 1, 1, 10, 10, 10, 0, 0, 'forum_at tachments', NULL, NULL, NULL, NULL, NULL, NULL,&n bsp;0);
-- --------------------------------------------------------
--
-- Structure de la table `counter`
--
CREATE TABLE IF NOT EXISTS `counter` (
`id_stat` int(10) unsigned NOT NULL AUTO _INCREMENT,
`type` varchar(80) NOT NULL DEFAULT '',
`var` varchar(80) NOT NULL DEFAULT '',
< br /> `count` int(10) unsigned NOT NULL DEFAUL T '0',
PRIMARY KEY (`id_stat`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREME NT=26 ;
--
-- Contenu de la table `counter`
--
INSERT INTO `counter` (`id_stat`, `type`, `var`,&nbs p;`count`) VALUES
(1, 'total', 'hits', 533),
(2, 'browser', 'WebTV', 0),
(3, 'browser', 'Lynx', 0),
(4, 'browser', 'MSIE', 0),
(5, 'browser', 'Opera', 0),
(6, 'browser', 'Konqueror', 0),
(7, 'browser', 'Netscape', 464),
(8, 'browser', 'Chrome', 63),
(9, 'browser', 'Safari', 6),
(10, 'browser', 'Bot', 0),
(11, 'browser', 'Other', 0),
(12, 'os', 'Windows', 56),
(13, 'os', 'Linux', 9),
(14, 'os', 'Mac', 6),
(15, 'os', 'FreeBSD', 0),
(16, 'os', 'SunOS', 0),
(17, 'os', 'IRIX', 0),
(18, 'os', 'BeOS', 0),
(19, 'os', 'OS/2', 0),
(20, 'os', 'AIX', 0),
(21, 'os', 'Other', 462),
(25, 'os', 'Android', 0),
(22, 'os', 'iOS', 0);
-- --------------------------------------------------------
--
-- Structure de la table `downloads`
--
CREATE TABLE IF NOT EXISTS `downloads` (
`did` int(10) NOT NULL AUTO_INCREMENT,
`dcounter` int(10) NOT NULL DEFAULT '0',
`durl` varchar(255) DEFAULT NULL,
`dfilename` varchar(255) DEFAULT NULL,
`dfilesize` bigint(15) unsigned DEFAULT NULL,
`ddate` date NOT NULL DEFAULT '0000-00-0 0',
`dweb` varchar(255) DEFAULT NULL,
`duser` varchar(30) DEFAULT NULL,
`dver` varchar(6) DEFAULT NULL,
`dcategory` varchar(250) DEFAULT NULL,
`ddescription` text,
`perms` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`did`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1&n bsp;;
-- --------------------------------------------------------
--
-- Structure de la table `droits`
--
CREATE TABLE IF NOT EXISTS `droits` (
`d_aut_aid` varchar(40) NOT NULL COMMENT  ;'id administrateur',
`d_fon_fid` tinyint(3) unsigned NOT NULL  ;COMMENT 'id fonction',
`d_droits` varchar(5) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Dune_proto' ;
-- --------------------------------------------------------
--
-- Structure de la table `encapsulation`
--
CREATE TABLE IF NOT EXISTS `encapsulation` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`type` enum('interne','externe') NOT NULL DEF AULT 'interne',
`nom` varchar(255) NOT NULL DEFAULT '',
`adresse` varchar(255) NOT NULL DEFAULT '',
`height` varchar(10) NOT NULL DEFAULT '8 00',
`scroll` varchar(4) NOT NULL DEFAULT 'No ',
`block` char(2) NOT NULL DEFAULT '1',
`tit` char(1) NOT NULL DEFAULT '1',
`titre` varchar(50) NOT NULL DEFAULT '',
`form` enum('http','https','ftp') NOT NULL DE FAULT 'http',
`display` char(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREME NT=12 ;
--
-- Contenu de la table `encapsulation`
--
-- --------------------------------------------------------
--
-- Structure de la table `ephem`
--
CREATE TABLE IF NOT EXISTS `ephem` (
`eid` int(11) NOT NULL AUTO_INCREMENT,
`did` int(2) NOT NULL DEFAULT '0',
`mid` int(2) NOT NULL DEFAULT '0',
`yid` int(4) NOT NULL DEFAULT '0',
`content` text NOT NULL,
PRIMARY KEY (`eid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1&n bsp;;
-- --------------------------------------------------------
--
-- Structure de la table `faqanswer`
--
CREATE TABLE IF NOT EXISTS `faqanswer` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_cat` tinyint(4) DEFAULT NULL,
`question` varchar(255) DEFAULT NULL,
`answer` text,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREME NT=10 ;
--
-- Contenu de la table `faqanswer`
--
-- --------------------------------------------------------
--
-- Structure de la table `faqcategories`
--
CREATE TABLE IF NOT EXISTS `faqcategories` (
`id_cat` tinyint(3) NOT NULL AUTO_INCREMENT,
`categories` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id_cat`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREME NT=6 ;
--
-- Contenu de la table `faqcategories`
--
INSERT INTO `faqcategories` (`id_cat`, `categories`)  ;VALUES
(1, 'Les articles, le journal...'),
(2, 'Sécurité'),
(3, 'Le Chat'),
(4, 'Mon Compte'),
(5, 'Mes Messages');
-- --------------------------------------------------------
--
-- Structure de la table `fonctions`
--
CREATE TABLE IF NOT EXISTS `fonctions` (
`fid` mediumint(8) unsigned NOT NULL AUT O_INCREMENT COMMENT 'id unique auto incrémenté',
`fnom` varchar(40) NOT NULL,
`fdroits1` tinyint(3) unsigned NOT NULL,
`fdroits1_descr` varchar(40) NOT NULL,
`finterface` tinyint(1) unsigned NOT NULL&nbs p;COMMENT '1 ou 0 : la fonction dispose  ;ou non d''une interface',
`fetat` tinyint(1) NOT NULL COMMENT '0&n bsp;ou 1 9 : non active ou installé,&n bsp;installé',
`fretour` varchar(500) NOT NULL COMMENT 'utiliser par les fonctions de categorie Alerte&n bsp;: nombre, ou ',
`fretour_h` varchar(500) NOT NULL,
`fnom_affich` varchar(200) NOT NULL,
`ficone` varchar(40) NOT NULL,
`furlscript` varchar(4000) NOT NULL COMMENT&n bsp;'attribut et contenu de balise A :  ;href="xxx", !onclick!="xxx" etc',
`fcategorie` tinyint(3) unsigned NOT NULL,
`fcategorie_nom` varchar(200) NOT NULL,
`fordre` tinyint(2) unsigned NOT NULL,
PRIMARY KEY (`fid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Dune_ proto' AUTO_INCREMENT=76 ;
--
-- Contenu de la table `fonctions`
--
INSERT INTO `fonctions` (`fid`, `fnom`, `fdroits1`,& nbsp;`fdroits1_descr`, `finterface`, `fetat`, `fretour`, `f retour_h`, `fnom_affich`, `ficone`, `furlscript`, `fcategor ie`, `fcategorie_nom`, `fordre`) VALUES
(1, 'edito', 1, '', 1, 1, '', '', 'Ed ito', 'edito', 'href="admin.php?op=Edito"', 1, 'Contenu',&n bsp;0),
(2, 'adminStory', 1, '', 1, 1, '', '',&nbs p;'Nouvel Article', 'postnew', 'href="admin.php?op=adminStory"', 1, 'Contenu', 1),
(3, 'sections', 1, '', 1, 1, '', '', 'Rubriques', 'sections', 'href="admin.php?op=sections"', 1,  ;'Contenu', 2),
(4, 'topicsmanager', 1, '', 1, 1, '', '',& nbsp;'Gestion des Sujets', 'topicsman', 'href="admin.php?op =topicsmanager"', 1, 'Contenu', 3),
(5, 'links', 1, '', 1, 1, '', '', 'Li ens Web', 'links', 'href="admin.php?op=links"', 1, 'Co ntenu', 5),
(6, 'FaqAdmin', 1, '', 1, 1, '1', '',  ;'FAQ', 'faq', 'href="admin.php?op=FaqAdmin"', 1, 'Contenu' , 6),
(7, 'Ephemerids', 1, '', 1, 1, '1', '',&nb sp;'Ephémérides', 'ephem', 'href="admin.php?op=Ephemerids"', 1,& nbsp;'Contenu', 7),
(8, 'HeadlinesAdmin', 1, '', 1, 1, '', '', 'News externes', 'headlines', 'href="admin.php?op=Headline sAdmin"', 1, 'Contenu', 8),
(9, 'DownloadAdmin', 1, '', 1, 1, '', '',& nbsp;'Téléchargements', 'download', 'href="admin.php?op=DownloadAdmin "', 1, 'Contenu', 9),
(10, 'mod_users', 1, '', 1, 1, '', '',&nbs p;'Utilisateurs', 'users', 'href="admin.php?op=mod_users"', 2,&n bsp;'Utilisateurs', 1),
(11, 'groupes', 1, '', 1, 1, '', '', 'Groupes', 'groupes', 'href="admin.php?op=groupes"', 2, 'Ut ilisateurs', 2),
(12, 'mod_authors', 1, '', 1, 1, '', '',&n bsp;'Administrateurs', 'authors', 'href="admin.php?op=mod_authors"',& nbsp;2, 'Utilisateurs', 3),
(13, 'MaintForumAdmin', 1, '', 1, 1, '', ' ', 'Maintenance Forums', 'forum', 'href="admin.php?op=Maint ForumAdmin"', 3, 'Communication', 0),
(14, 'ForumConfigAdmin', 1, '', 1, 1, '', '', 'Configuration Forums', 'forum', 'href="admin.php?op=Fo rumConfigAdmin"', 3, 'Communication', 0),
(15, 'ForumAdmin', 1, '', 1, 1, '', '',&nb sp;'Edition Forums', 'forum', 'href="admin.php?op=ForumAdmin"',& nbsp;3, 'Communication', 0),
(16, 'lnl', 1, '', 1, 1, '', '', 'Let tre D''info', 'lnl', 'href="admin.php?op=lnl"', 3, 'Co mmunication', 0),
(17, 'email_user', 1, '', 1, 1, '', '',&nb sp;'Message Interne', 'email_user', 'href="admin.php?op=email_us er"', 3, 'Communication', 0),
(18, 'BannersAdmin', 1, '', 1, 1, '', '',& nbsp;'Bannières', 'banner', 'href="admin.php?op=BannersAdmin"', 3, 'Communication', 0),
(19, 'create', 1, '', 1, 1, '', '', ' Sondages', 'newpoll', 'href="admin.php?op=create"', 3, 'Com munication', 0),
(20, 'reviews', 1, '', 1, 1, '', '', 'Critiques', 'reviews', 'href="admin.php?op=reviews"', 3, ' Communication', 0),
(21, 'hreferer', 1, '', 1, 1, '', '',  ;'Sites Référents', 'referer', 'href="admin.php?op=hreferer"',&n bsp;3, 'Communication', 0),
(22, 'blocks', 1, '', 1, 1, '', '', ' Blocs', 'block', 'href="admin.php?op=blocks"', 4, 'Interfac e', 0),
(23, 'mblock', 1, '', 1, 1, '', '', ' Bloc Principal', 'blockmain', 'href="admin.php?op=mblock"',  ;4, 'Interface', 0),
(24, 'ablock', 1, '', 1, 1, '', '', ' Bloc Administration', 'blockadm', 'href="admin.php?op=ablock"',& nbsp;4, 'Interface', 0),
(25, 'Configure', 1, '', 1, 1, '', '',&nbs p;'Préférences', 'preferences', 'href="admin.php?op=Configure"',  ;5, 'Système', 0),
(26, 'ConfigFiles', 1, '', 1, 1, '', '',&n bsp;'Fichiers configurations', 'preferences', 'href="admin.php?o p=ConfigFiles"', 5, 'Système', 0),
(27, 'FileManager', 1, '', 1, 1, '', '',&n bsp;'Gestionnaire Fichiers', 'filemanager', 'href="admin.php?op= FileManager"', 5, 'Système', 0),
(28, 'supercache', 1, '', 1, 1, '', '',&nb sp;'SuperCache', 'overload', 'href="admin.php?op=supercache"', 5 , 'Système', 0),
(29, 'OptimySQL', 1, '', 1, 1, '', '',&nbs p;'OptimySQL', 'optimysql', 'href="admin.php?op=OptimySQL"', 5,& nbsp;'Système', 0),
(30, 'SavemySQL', 1, '', 1, 1, '', '',&nbs p;'SavemySQL', 'savemysql', 'href="admin.php?op=SavemySQL"', 5,& nbsp;'Système', 0),
(31, 'MetaTagAdmin', 1, '', 1, 1, '', '',& nbsp;'MétaTAGs', 'metatags', 'href="admin.php?op=MetaTagAdmin"',  ;5, 'Système', 0),
(32, 'MetaLangAdmin', 1, '', 1, 1, '', '', 'META-LANG', 'metalang', 'href="admin.php?op=Meta-LangAdmin"',& nbsp;5, 'Système', 0),
(33, 'setban', 1, '', 1, 1, '', '', ' IP', 'ipban', 'href="admin.php?op=Extend-Admin-SubModule&ModP ath=ipban&ModStart=setban"', 5, 'Système', 0),
(34, 'session_log', 1, '', 1, 1, '', '',&n bsp;'Logs', 'logs', 'href="admin.php?op=Extend-Admin-SubModule&Mo dPath=session-log&ModStart=session-log"', 5, 'Système',& nbsp;0),
(36, 'mes_npds_versus', 1, '', 1, 1, '', ' Une nouvelle version est disponible ! Cliquez&nbs p;pour accéder à la zone de t&a mp;#xE9;léchargement de NPDS.', '', 'message_npds' , '', 9, 'Alerte', 0),
(37, 'autoStory', 1, '', 1, 0, '0', '',&nb sp;'Auto-Articles', 'autonews', 'href="admin.php?op=autoStory"',  ;9, 'Alerte', 0),
(38, 'submissions', 1, '', 1, 0, '0', 'Art icle en attente de validation !', 'Articles',&nbs p;'submissions', 'href="admin.php?op=submissions"', 9, 'Alerte', 0),
(39, 'hreferer_al', 1, '', 1, 0, '!!!', 'L imite des référants atteinte : pense z à archiver vos référants.',&nb sp;'Sites Référents', 'referer', 'href="admin.php?op=hreferer"', 9, 'Alerte', 0),
(49, 'npds_twi', 0, '', 1, 1, '', '',  ;'Npds_Twitter', 'npds_twi', 'href="admin.php?op=Extend-Admin-SubModu le&ModPath=npds_twi&ModStart=admin/npds_twi_set"', 6, 'Module s', 0),
(62, 'mes_npds_3', 0, '', 1, 1, '', '  ;Alerte rouge ça bug ..', '', 'flag_red', ' ', 9, 'Alerte', 0),
(59, 'mes_npds_2', 0, '', 1, 1, '', 'Ceci& nbsp;est une note d''information provenant de NPD S.', '', 'flag_red', '', 9, 'Alerte', 0),
(51, 'modules', 1, '', 1, 1, '', '', 'Gestion modules', 'modules', 'href="admin.php?op=modules"',&nbs p;5, 'Système', 0),
(40, 'abla', 1, '', 1, 1, '', '', 'Bl ackboard', 'abla', 'href="abla.php"', 5, 'Système' , 0),
(35, 'reviews', 1, '', 1, 0, '0', 'Critiqu e en atttente de validation.', 'Critiques', 'revi ews', 'href="admin.php?op=reviews"', 9, 'Alerte', 0),
(41, 'newlink', 1, '', 1, 0, '0', 'Lien&nb sp;à valider', 'Lien', 'links', 'href="admin.php?o p=links"', 9, 'Alerte', 0),
(42, 'brokenlink', 1, '', 1, 0, '0', 'Lien rompu à valider', 'Lien rompu', 'links' , 'href="admin.php?op=LinksListBrokenLinks"', 9, 'Alerte', 0),
(43, 'archive-stories', 1, '', 1, 1, '', ' ', 'Archives articles', 'archive-stories', 'href="admin.php ?op=Extend-Admin-SubModule&ModPath=archive-stories&ModStart=admin/archi ve-stories_set"', 1, 'Contenu', 4),
(73, 'td-galerie', 1, '', 1, 1, '', '',&nb sp;'TD-Galerie 3.0', 'td-galerie', 'href="admin.php?op=Extend-Ad min-SubModule&ModPath=td-galerie&ModStart=admin/adm"', 6, 'Mo dules', 0),
(74, 'reseaux-sociaux', 1, '', 1, 1, '', ' ', 'Réseaux sociaux', 'reseaux-sociaux', 'href="admin.php?o p=Extend-Admin-SubModule&ModPath=reseaux-sociaux&ModStart=admin/reseaux -sociaux_set"', 2, 'Utilisateurs', 4),
(75, 'mes_npds_1', 0, '', 1, 1, '', 'Migra tion des serveurs NPDS Ã partir du 15 mars 2016 !.', '', 'flag_red', '', 9, 'Alert e', 0);
-- --------------------------------------------------------
--
-- Structure de la table `forums`
--
CREATE TABLE IF NOT EXISTS `forums` (
`forum_id` int(10) NOT NULL AUTO_INCREMENT,
< br /> `forum_name` varchar(150) DEFAULT NULL,
`forum_desc` text,
`forum_access` int(10) DEFAULT '1',
`forum_moderator` text,
`cat_id` int(10) DEFAULT NULL,
`forum_type` int(10) DEFAULT '0',
`forum_pass` varchar(60) DEFAULT NULL,
`arbre` tinyint(1) unsigned NOT NULL DEF AULT '0',
`attachement` tinyint(1) unsigned NOT NULL&nb sp;DEFAULT '0',
`forum_index` int(2) unsigned NOT NULL D EFAULT '0',
PRIMARY KEY (`forum_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREME NT=37 ;
--
-- Contenu de la table `forums`
--
-- --------------------------------------------------------
--
-- Structure de la table `forumtopics`
--
CREATE TABLE IF NOT EXISTS `forumtopics` (
`topic_id` int(10) NOT NULL AUTO_INCREMENT,
< br /> `topic_title` varchar(100) DEFAULT NULL,
`topic_poster` int(10) DEFAULT NULL,
`topic_time` datetime DEFAULT NULL,
`topic_views` int(10) NOT NULL DEFAULT ' 0',
`forum_id` int(10) DEFAULT NULL,
`topic_status` int(10) NOT NULL DEFAULT '0',
`topic_notify` int(2) DEFAULT '0',
`current_poster` int(10) DEFAULT NULL,
`topic_first` tinyint(1) NOT NULL DEFAULT&nbs p;'1',
PRIMARY KEY (`topic_id`),
KEY `forum_id` (`forum_id`),
KEY `topic_first` (`topic_first`,`topic_time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREME NT=3963 ;
--
-- Contenu de la table `forumtopics`
--
-- --------------------------------------------------------
--
-- Structure de la table `forum_attachments`
--
CREATE TABLE IF NOT EXISTS `forum_attachments` (
`att_id` int(11) NOT NULL AUTO_INCREMENT,
`post_id` int(11) NOT NULL DEFAULT '0',
`topic_id` int(11) NOT NULL DEFAULT '0',
`forum_id` int(11) NOT NULL DEFAULT '0',
`unixdate` int(11) NOT NULL DEFAULT '0',
`att_name` varchar(255) NOT NULL DEFAULT  ;'',
`att_type` varchar(64) NOT NULL DEFAULT '',
`att_size` int(11) NOT NULL DEFAULT '0',
`att_path` varchar(255) NOT NULL DEFAULT  ;'',
`inline` char(1) NOT NULL DEFAULT '',
`apli` varchar(10) NOT NULL DEFAULT '',
`compteur` int(11) NOT NULL DEFAULT '0',
`visible` tinyint(1) NOT NULL DEFAULT '0 ',
KEY `att_id` (`att_id`),
KEY `post_id` (`post_id`),
KEY `topic_id` (`topic_id`),
KEY `apli` (`apli`),
KEY `visible` (`visible`),
KEY `forum_id` (`forum_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREME NT=36 ;
--
-- Contenu de la table `forum_attachments`
--
-- --------------------------------------------------------
--
-- Structure de la table `forum_read`
--
CREATE TABLE IF NOT EXISTS `forum_read` (
`rid` int(11) NOT NULL AUTO_INCREMENT,
`forum_id` int(10) NOT NULL DEFAULT '0',
`topicid` int(3) NOT NULL DEFAULT '0',
< br /> `uid` int(11) NOT NULL DEFAULT '0',
`last_read` int(15) NOT NULL DEFAULT '0' ,
`status` tinyint(1) NOT NULL DEFAULT '1' ,
PRIMARY KEY (`rid`),
KEY `topicid` (`topicid`),
KEY `forum_id` (`forum_id`),
KEY `uid` (`uid`),
KEY `forum_read_mcl` (`forum_id`,`uid`,`topicid`,`statu s`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREME NT=288023 ;
--
-- Contenu de la table `forum_read`
--
-- --------------------------------------------------------
--
-- Structure de la table `groupes`
--
CREATE TABLE IF NOT EXISTS `groupes` (
`groupe_id` int(3) DEFAULT NULL,
`groupe_name` varchar(30) NOT NULL DEFAULT&nb sp;'',
`groupe_description` varchar(255) NOT NULL DE FAULT '',
`groupe_forum` int(1) unsigned NOT NULL DEFAULT '0',
`groupe_mns` int(1) unsigned NOT NULL DE FAULT '0',
`groupe_chat` int(1) unsigned NOT NULL D EFAULT '0',
`groupe_blocnote` int(1) unsigned NOT NULL&nb sp;DEFAULT '0',
`groupe_pad` int(1) unsigned NOT NULL DE FAULT '0',
UNIQUE KEY `groupe_id` (`groupe_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Contenu de la table `groupes`
--
-- --------------------------------------------------------
--
-- Structure de la table `headlines`
--
CREATE TABLE IF NOT EXISTS `headlines` (
`hid` int(11) NOT NULL AUTO_INCREMENT,
`sitename` varchar(30) NOT NULL DEFAULT '',
`url` varchar(100) NOT NULL DEFAULT '',
`headlinesurl` varchar(200) NOT NULL DEFAULT& nbsp;'',
`status` tinyint(1) NOT NULL DEFAULT '0' ,
PRIMARY KEY (`hid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREME NT=2 ;
-- --------------------------------------------------------
--
-- Structure de la table `lblocks`
--
CREATE TABLE IF NOT EXISTS `lblocks` (
`id` tinyint(3) unsigned NOT NULL AUTO_I NCREMENT,
`title` varchar(255) DEFAULT NULL,
`content` text,
`member` varchar(60) NOT NULL DEFAULT '0 ',
`Lindex` tinyint(4) NOT NULL DEFAULT '0' ,
`cache` mediumint(8) unsigned NOT NULL D EFAULT '0',
`actif` smallint(5) unsigned NOT NULL DE FAULT '1',
`css` tinyint(1) NOT NULL DEFAULT '0',
< br /> `aide` mediumtext,
PRIMARY KEY (`id`),
KEY `Lindex` (`Lindex`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREME NT=40 ;
--
-- Contenu de la table `lblocks`
--
-- --------------------------------------------------------
--
-- Structure de la table `links_categories`
--
CREATE TABLE IF NOT EXISTS `links_categories` (
`cid` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(250) DEFAULT NULL,
`cdescription` text NOT NULL,
PRIMARY KEY (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREME NT=5 ;
--
-- Contenu de la table `links_categories`
--
-- --------------------------------------------------------
--
-- Structure de la table `links_editorials`
--
CREATE TABLE IF NOT EXISTS `links_editorials` (
`linkid` int(11) NOT NULL DEFAULT '0',
< br /> `adminid` varchar(60) NOT NULL DEFAULT ' ',
`editorialtimestamp` datetime NOT NULL DEFAUL T '0000-00-00 00:00:00',
`editorialtext` text NOT NULL,
`editorialtitle` varchar(100) NOT NULL DEFAUL T '',
PRIMARY KEY (`linkid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Contenu de la table `links_editorials`
--
-- --------------------------------------------------------
--
-- Structure de la table `links_links`
--
CREATE TABLE IF NOT EXISTS `links_links` (
`lid` int(11) NOT NULL AUTO_INCREMENT,
`cid` int(11) NOT NULL DEFAULT '0',
`sid` int(11) NOT NULL DEFAULT '0',
`title` varchar(100) NOT NULL DEFAULT '' ,
`url` varchar(100) NOT NULL DEFAULT '',
`description` text NOT NULL,
`date` datetime DEFAULT NULL,
`name` varchar(60) NOT NULL DEFAULT '',
`email` varchar(60) NOT NULL DEFAULT '',
`hits` int(11) NOT NULL DEFAULT '0',
`submitter` varchar(60) NOT NULL DEFAULT  ;'',
`linkratingsummary` double(6,4) NOT NULL DEFA ULT '0.0000',
`totalvotes` int(11) NOT NULL DEFAULT '0 ',
`totalcomments` int(11) NOT NULL DEFAULT  ;'0',
`topicid_card` tinyint(3) NOT NULL DEFAULT&nb sp;'0',
PRIMARY KEY (`lid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREME NT=6 ;
--
-- Contenu de la table `links_links`
--
-- --------------------------------------------------------
--
-- Structure de la table `links_modrequest`
--
CREATE TABLE IF NOT EXISTS `links_modrequest` (
`requestid` int(11) NOT NULL AUTO_INCREMENT,
`lid` int(11) NOT NULL DEFAULT '0',
`cid` int(11) NOT NULL DEFAULT '0',
`sid` int(11) NOT NULL DEFAULT '0',
`title` varchar(100) NOT NULL DEFAULT '' ,
`url` varchar(100) NOT NULL DEFAULT '',
`description` text NOT NULL,
`modifysubmitter` varchar(60) NOT NULL DEFAUL T '',
`brokenlink` int(3) NOT NULL DEFAULT '0' ,
`topicid_card` tinyint(3) NOT NULL DEFAULT&nb sp;'0',
PRIMARY KEY (`requestid`),
UNIQUE KEY `requestid` (`requestid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1&n bsp;;
-- --------------------------------------------------------
--
-- Structure de la table `links_newlink`
--
CREATE TABLE IF NOT EXISTS `links_newlink` (
`lid` int(11) NOT NULL AUTO_INCREMENT,
`cid` int(11) NOT NULL DEFAULT '0',
`sid` int(11) NOT NULL DEFAULT '0',
`title` varchar(100) NOT NULL DEFAULT '' ,
`url` varchar(100) NOT NULL DEFAULT '',
`description` text NOT NULL,
`name` varchar(60) NOT NULL DEFAULT '',
`email` varchar(60) NOT NULL DEFAULT '',
`submitter` varchar(60) NOT NULL DEFAULT  ;'',
`topicid_card` tinyint(3) NOT NULL DEFAULT&nb sp;'0',
PRIMARY KEY (`lid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREME NT=5 ;
-- --------------------------------------------------------
--
-- Structure de la table `links_subcategories`
--
CREATE TABLE IF NOT EXISTS `links_subcategories`&nbs p;(
`sid` int(11) NOT NULL AUTO_INCREMENT,
`cid` int(11) NOT NULL DEFAULT '0',
`title` varchar(250) DEFAULT NULL,
PRIMARY KEY (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1&n bsp;;
-- --------------------------------------------------------
--
-- Structure de la table `lnl_body`
--
CREATE TABLE IF NOT EXISTS `lnl_body` (
`ref` int(11) NOT NULL AUTO_INCREMENT,
`html` char(1) NOT NULL DEFAULT '1',
`text` text,
`status` char(3) NOT NULL DEFAULT 'stb',
PRIMARY KEY (`ref`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREME NT=2 ;
--
-- Contenu de la table `lnl_body`
--
-- --------------------------------------------------------
--
-- Structure de la table `lnl_head_foot`
--
CREATE TABLE IF NOT EXISTS `lnl_head_foot` (
`ref` int(11) NOT NULL AUTO_INCREMENT,
`type` char(3) NOT NULL DEFAULT '',
`html` char(1) NOT NULL DEFAULT '1',
`text` text,
`status` char(3) NOT NULL DEFAULT 'OK',
PRIMARY KEY (`ref`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREME NT=3 ;
--
-- Contenu de la table `lnl_head_foot`
--
-- --------------------------------------------------------
--
-- Structure de la table `lnl_outside_users`
--
CREATE TABLE IF NOT EXISTS `lnl_outside_users` (
`email` varchar(60) NOT NULL DEFAULT '',
`host_name` varchar(60) DEFAULT NULL,
`date` datetime NOT NULL DEFAULT '0000-0 0-00 00:00:00',
`status` char(3) NOT NULL DEFAULT 'OK',
PRIMARY KEY (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Contenu de la table `lnl_outside_users`
--
-- --------------------------------------------------------
--
-- Structure de la table `lnl_send`
--
CREATE TABLE IF NOT EXISTS `lnl_send` (
`ref` int(11) NOT NULL AUTO_INCREMENT,
`header` int(11) NOT NULL DEFAULT '0',
< br /> `body` int(11) NOT NULL DEFAULT '0',
`footer` int(11) NOT NULL DEFAULT '0',
< br /> `number_send` int(11) NOT NULL DEFAULT ' 0',
`type_send` char(3) NOT NULL DEFAULT 'AL L',
`date` datetime NOT NULL DEFAULT '0000-0 0-00 00:00:00',
`status` char(3) NOT NULL DEFAULT 'OK',
PRIMARY KEY (`ref`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREME NT=2 ;
--
-- Contenu de la table `lnl_send`
-
-- --------------------------------------------------------
--
-- Structure de la table `mainblock`
--
CREATE TABLE IF NOT EXISTS `mainblock` (
`title` varchar(255) DEFAULT NULL,
`content` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Contenu de la table `mainblock`
--
INSERT INTO `mainblock` (`title`, `content`) VALUES
('Menu', '<ul><li><a href="modules.php?ModPath=archi ve-stories&ModStart=archive-stories">Nouvelles</a></li><l i><a href="forum.php">Forums</a></li><li><a& nbsp;href="sections.php">Rubriques</a></li><li><a href="topics.php">Sujets actifs</a></li><li><a&nbs p;href="modules.php?ModPath=links&ModStart=links">Liens Web</a&g t;</li><li><a href="download.php">Downloads</a>< ;/li><li><a href="faq.php">FAQ</a></li><li&g t;<a href="static.php?op=statik.txt&npds=1">Page statique&l t;/a></li><li><a href="reviews.php">Critiques</a&g t;</li><li><a href="memberslist.php">Annuaire</a>& lt;/li><li><a href="map.php">Plan du site</a&g t;</li></ul><ul><li><a href="friend.php">Fai re notre pub</a></li><li><a href="user.php" >Votre compte</a></li><li><a href="submit.php ">Nouvel article</a></li></ul><ul><li>< ;a href="admin.php">Administration</a></li></ul>');
< br />
-- --------------------------------------------------------
--
-- Structure de la table `metalang`
--
CREATE TABLE IF NOT EXISTS `metalang` (
`def` varchar(50) NOT NULL DEFAULT '',
< br /> `content` text NOT NULL,
`type_meta` varchar(4) NOT NULL DEFAULT 'mot',
`type_uri` char(1) NOT NULL DEFAULT '-',
`uri` varchar(255) DEFAULT NULL,
`description` text,
`obligatoire` char(3) NOT NULL DEFAULT ' 0',
PRIMARY KEY (`def`),
KEY `type_meta` (`type_meta`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Contenu de la table `metalang`
--
INSERT INTO `metalang` (`def`, `content`, `type_meta `, `type_uri`, `uri`, `description`, `obligatoire`) VA LUES
('Dev', 'Developpeur', 'mot', '-', NULL, NULL, '0'),
('NPDS', '<a href="http://www.npds.org" target="_blank" title="www.npds.org">NPDS</a>', 'mot', '-', NULL, NULL, '1'),
('', '$cmd=MM_img("forum/smilies/icon_smile.gif");', 'smil', '-' , NULL, NULL, '1'),
('', '$cmd=MM_img("forum/smilies/icon_smile.gif");', 'smil', '-' , NULL, NULL, '1'),
('', '$cmd=MM_img("forum/smilies/icon_wink.gif");', 'smil', '-', NULL, NULL, '1'),
('', '$cmd=MM_img("forum/smilies/icon_wink.gif");', 'smil', '-', NULL, NULL, '1'),
('', '$cmd=MM_img("forum/smilies/icon_frown.gif");', 'smil', '-' , NULL, NULL, '1'),
('', '$cmd=MM_img("forum/smilies/icon_frown.gif");', 'smil', '-' , NULL, NULL, '1'),
('', '$cmd=MM_img("forum/smilies/icon_cool.gif");', 'smil', '-', NULL, NULL, '1'),
('', '$cmd=MM_img("forum/smilies/icon_cool.gif");', 'smil', '-', NULL, NULL, '1'),
('', '$cmd=MM_img("forum/smilies/icon_razz.gif");', 'smil', '-', NULL, NULL, '1'),
('', '$cmd=MM_img("forum/smilies/icon_biggrin.gif");', 'smil', ' -', NULL, NULL, '1'),
('', '$cmd=MM_img("forum/smilies/yaisse.gif");', 'smil', '-',&nb sp;NULL, NULL, '1'),
('', '$cmd=MM_img("forum/smilies/icon_tongue.gif");', 'smil', '- ', NULL, NULL, '1'),
('', '$cmd=MM_img("forum/smilies/icon_grin.gif");', 'smil', '-', NULL, NULL, '1'),
('', '$cmd=MM_img("forum/smilies/icon_ohwell.gif");', 'smil', '- ', NULL, NULL, '1'),
('', '$cmd=MM_img("forum/smilies/icon_eek.gif");', 'smil', '-',& nbsp;NULL, NULL, '1'),
('', '$cmd=MM_img("forum/smilies/icon_confused.gif");', 'smil', '-', NULL, NULL, '1'),
('', '$cmd=MM_img("forum/smilies/icon_mad.gif");', 'smil', '-',& nbsp;NULL, NULL, '1'),
('', '$cmd=MM_img("forum/smilies/icon_mad2.gif");', 'smil', '-', NULL, NULL, '1'),
('', '$cmd=MM_img("forum/smilies/pafmur.gif");', 'smil', '-',&nb sp;NULL, NULL, '1'),
('dateL', '$cmd=date("d/m/Y");', 'meta', '-', NULL, '[french]Date longue JJ/MM/YYYY[/french]', '1'),
('heureC', '$cmd=date("H:i");', 'meta', '-', NULL, ' [french]Heure courte HH:MM[/french]', '1'),
('heureL', '$cmd=date("H:i:s");', 'meta', '-', NULL,  ;'[french]Heure longue HH:MM:SS[/french]', '1'),
('dateC', '$cmd=date("d/m/y");', 'meta', '-', NULL, '[french]Date longue JJ/MM[/french]', '1'),
('!a/!', '\', 'meta', '-', NULL, '[french]an ti-slash[/french]', '1'),
('!sc_infos_else!', ' ', 'meta', '-', NULL,  ;'[french]affiche les informations de SuperCache[/french]', '1'),
('!sc_infos!', '$cmd=SC_infos();', 'meta', '-', NULL,&nbs p;'[french]affiche les informations de SuperCache[/french]' , '1'),
('!slogan!', '$cmd=$GLOBALS[''slogan''];', 'meta', '-', N ULL, '[french]variable global $slogan[/french]', '1'),
('!bargif!', '$cmd=$GLOBALS[''bargif''];', 'meta', '-', N ULL, '[french]variable global $bargif[/french]', '1'),
('!theme!', '$cmd=$GLOBALS[''theme''];', 'meta', '-', NUL L, '[french]variable global $theme[/french]', '1'),
('!sitename!', '$cmd=$GLOBALS[''sitename''];', 'meta', '-',&nb sp;NULL, '[french]variable global $sitename[/french]', '1') ,
('!bgcolor1!', '$cmd=$GLOBALS[''bgcolor1''];', 'meta', '-',&nb sp;NULL, '[french]variable&nbs
|