Pages vues depuis 25/05/2001 : 108 403 044
Index du forum »» Version future »» NPDS 16
-- 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 */;
/*!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_INCREMENT=4 ;
--
-- Contenu de la table `access`
--
INSERT INTO `access` (`access_id`, `access_title`) VALUES
(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 '0000-00-00 00:00:00',
`al_uid` int(11) NOT NULL DEFAULT '0',
`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 '',
`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 '0',
`radmintopic` tinyint(2) NOT NULL DEFAULT '0',
`radminleft` tinyint(2) NOT NULL DEFAULT '0',
`radminright` tinyint(2) NOT NULL DEFAULT '0',
`radminuser` tinyint(2) NOT NULL DEFAULT '0',
`radminmain` tinyint(2) NOT NULL DEFAULT '0',
`radminsurvey` tinyint(2) NOT NULL DEFAULT '0',
`radminsection` tinyint(2) NOT NULL DEFAULT '0',
`radminlink` tinyint(2) NOT NULL DEFAULT '0',
`radminephem` tinyint(2) NOT NULL DEFAULT '0',
`radminfilem` tinyint(2) NOT NULL DEFAULT '0',
`radminhead` tinyint(2) NOT NULL DEFAULT '0',
`radminfaq` tinyint(2) NOT NULL DEFAULT '0',
`radmindownload` tinyint(2) NOT NULL DEFAULT '0',
`radminforum` tinyint(2) NOT NULL DEFAULT '0',
`radminreviews` tinyint(2) NOT NULL DEFAULT '0',
`radminsdv` tinyint(2) NOT NULL DEFAULT '0',
`radminlnl` tinyint(2) NOT NULL DEFAULT '0',
`radminsuper` tinyint(2) NOT NULL DEFAULT '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 '',
`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 ;
-- --------------------------------------------------------
--
-- 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',
`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 ;
-- --------------------------------------------------------
--
-- 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 ;
-- --------------------------------------------------------
--
-- 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',
`datestart` datetime DEFAULT NULL,
`dateend` datetime DEFAULT NULL,
PRIMARY KEY (`bid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- 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_INCREMENT=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 '',
`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 DEFAULT '0',
`upload_table` varchar(50) NOT NULL DEFAULT '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 DEFAULT '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`, `rank1`, `rank2`, `rank3`, `rank4`, `rank5`, `anti_flood`, `solved`) VALUES
(1, 1, 1, 10, 10, 10, 0, 0, 'forum_attachments', NULL, NULL, NULL, NULL, NULL, NULL, 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 '',
`count` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id_stat`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ;
--
-- Contenu de la table `counter`
--
INSERT INTO `counter` (`id_stat`, `type`, `var`, `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-00',
`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 ;
-- --------------------------------------------------------
--
-- 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 DEFAULT 'interne',
`nom` varchar(255) NOT NULL DEFAULT '',
`adresse` varchar(255) NOT NULL DEFAULT '',
`height` varchar(10) NOT NULL DEFAULT '800',
`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 DEFAULT 'http',
`display` char(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=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 ;
-- --------------------------------------------------------
--
-- 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_INCREMENT=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_INCREMENT=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 AUTO_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 COMMENT '1 ou 0 : la fonction dispose ou non d''une interface',
`fetat` tinyint(1) NOT NULL COMMENT '0 ou 1 9 : non active ou installé, installé',
`fretour` varchar(500) NOT NULL COMMENT 'utiliser par les fonctions de categorie Alerte : 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 '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`, `fdroits1_descr`, `finterface`, `fetat`, `fretour`, `fretour_h`, `fnom_affich`, `ficone`, `furlscript`, `fcategorie`, `fcategorie_nom`, `fordre`) VALUES
(1, 'edito', 1, '', 1, 1, '', '', 'Edito', 'edito', 'href="admin.php?op=Edito"', 1, 'Contenu', 0),
(2, 'adminStory', 1, '', 1, 1, '', '', '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, '', '', 'Gestion des Sujets', 'topicsman', 'href="admin.php?op=topicsmanager"', 1, 'Contenu', 3),
(5, 'links', 1, '', 1, 1, '', '', 'Liens Web', 'links', 'href="admin.php?op=links"', 1, 'Contenu', 5),
(6, 'FaqAdmin', 1, '', 1, 1, '1', '', 'FAQ', 'faq', 'href="admin.php?op=FaqAdmin"', 1, 'Contenu', 6),
(7, 'Ephemerids', 1, '', 1, 1, '1', '', 'Ephémérides', 'ephem', 'href="admin.php?op=Ephemerids"', 1, 'Contenu', 7),
(8, 'HeadlinesAdmin', 1, '', 1, 1, '', '', 'News externes', 'headlines', 'href="admin.php?op=HeadlinesAdmin"', 1, 'Contenu', 8),
(9, 'DownloadAdmin', 1, '', 1, 1, '', '', 'Téléchargements', 'download', 'href="admin.php?op=DownloadAdmin"', 1, 'Contenu', 9),
(10, 'mod_users', 1, '', 1, 1, '', '', 'Utilisateurs', 'users', 'href="admin.php?op=mod_users"', 2, 'Utilisateurs', 1),
(11, 'groupes', 1, '', 1, 1, '', '', 'Groupes', 'groupes', 'href="admin.php?op=groupes"', 2, 'Utilisateurs', 2),
(12, 'mod_authors', 1, '', 1, 1, '', '', 'Administrateurs', 'authors', 'href="admin.php?op=mod_authors"', 2, 'Utilisateurs', 3),
(13, 'MaintForumAdmin', 1, '', 1, 1, '', '', 'Maintenance Forums', 'forum', 'href="admin.php?op=MaintForumAdmin"', 3, 'Communication', 0),
(14, 'ForumConfigAdmin', 1, '', 1, 1, '', '', 'Configuration Forums', 'forum', 'href="admin.php?op=ForumConfigAdmin"', 3, 'Communication', 0),
(15, 'ForumAdmin', 1, '', 1, 1, '', '', 'Edition Forums', 'forum', 'href="admin.php?op=ForumAdmin"', 3, 'Communication', 0),
(16, 'lnl', 1, '', 1, 1, '', '', 'Lettre D''info', 'lnl', 'href="admin.php?op=lnl"', 3, 'Communication', 0),
(17, 'email_user', 1, '', 1, 1, '', '', 'Message Interne', 'email_user', 'href="admin.php?op=email_user"', 3, 'Communication', 0),
(18, 'BannersAdmin', 1, '', 1, 1, '', '', 'Bannières', 'banner', 'href="admin.php?op=BannersAdmin"', 3, 'Communication', 0),
(19, 'create', 1, '', 1, 1, '', '', 'Sondages', 'newpoll', 'href="admin.php?op=create"', 3, 'Communication', 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"', 3, 'Communication', 0),
(22, 'blocks', 1, '', 1, 1, '', '', 'Blocs', 'block', 'href="admin.php?op=blocks"', 4, 'Interface', 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"', 4, 'Interface', 0),
(25, 'Configure', 1, '', 1, 1, '', '', 'Préférences', 'preferences', 'href="admin.php?op=Configure"', 5, 'Système', 0),
(26, 'ConfigFiles', 1, '', 1, 1, '', '', 'Fichiers configurations', 'preferences', 'href="admin.php?op=ConfigFiles"', 5, 'Système', 0),
(27, 'FileManager', 1, '', 1, 1, '', '', 'Gestionnaire Fichiers', 'filemanager', 'href="admin.php?op=FileManager"', 5, 'Système', 0),
(28, 'supercache', 1, '', 1, 1, '', '', 'SuperCache', 'overload', 'href="admin.php?op=supercache"', 5, 'Système', 0),
(29, 'OptimySQL', 1, '', 1, 1, '', '', 'OptimySQL', 'optimysql', 'href="admin.php?op=OptimySQL"', 5, 'Système', 0),
(30, 'SavemySQL', 1, '', 1, 1, '', '', 'SavemySQL', 'savemysql', 'href="admin.php?op=SavemySQL"', 5, 'Système', 0),
(31, 'MetaTagAdmin', 1, '', 1, 1, '', '', '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"', 5, 'Système', 0),
(33, 'setban', 1, '', 1, 1, '', '', 'IP', 'ipban', 'href="admin.php?op=Extend-Admin-SubModule&ModPath=ipban&ModStart=setban"', 5, 'Système', 0),
(34, 'session_log', 1, '', 1, 1, '', '', 'Logs', 'logs', 'href="admin.php?op=Extend-Admin-SubModule&ModPath=session-log&ModStart=session-log"', 5, 'Système', 0),
(36, 'mes_npds_versus', 1, '', 1, 1, '', 'Une nouvelle version est disponible ! Cliquez pour accéder à la zone de téléchargement de NPDS.', '', 'message_npds', '', 9, 'Alerte', 0),
(37, 'autoStory', 1, '', 1, 0, '0', '', 'Auto-Articles', 'autonews', 'href="admin.php?op=autoStory"', 9, 'Alerte', 0),
(38, 'submissions', 1, '', 1, 0, '0', 'Article en attente de validation !', 'Articles', 'submissions', 'href="admin.php?op=submissions"', 9, 'Alerte', 0),
(39, 'hreferer_al', 1, '', 1, 0, '!!!', 'Limite des référants atteinte : pensez à archiver vos référants.', '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-SubModule&ModPath=npds_twi&ModStart=admin/npds_twi_set"', 6, 'Modules', 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 est une note d''information provenant de NPDS.', '', 'flag_red', '', 9, 'Alerte', 0),
(51, 'modules', 1, '', 1, 1, '', '', 'Gestion modules', 'modules', 'href="admin.php?op=modules"', 5, 'Système', 0),
(40, 'abla', 1, '', 1, 1, '', '', 'Blackboard', 'abla', 'href="abla.php"', 5, 'Système', 0),
(35, 'reviews', 1, '', 1, 0, '0', 'Critique en atttente de validation.', 'Critiques', 'reviews', 'href="admin.php?op=reviews"', 9, 'Alerte', 0),
(41, 'newlink', 1, '', 1, 0, '0', 'Lien à valider', 'Lien', 'links', 'href="admin.php?op=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/archive-stories_set"', 1, 'Contenu', 4),
(73, 'td-galerie', 1, '', 1, 1, '', '', 'TD-Galerie 3.0', 'td-galerie', 'href="admin.php?op=Extend-Admin-SubModule&ModPath=td-galerie&ModStart=admin/adm"', 6, 'Modules', 0),
(74, 'reseaux-sociaux', 1, '', 1, 1, '', '', 'Réseaux sociaux', 'reseaux-sociaux', 'href="admin.php?op=Extend-Admin-SubModule&ModPath=reseaux-sociaux&ModStart=admin/reseaux-sociaux_set"', 2, 'Utilisateurs', 4),
(75, 'mes_npds_1', 0, '', 1, 1, '', 'Migration des serveurs NPDS Ã partir du 15 mars 2016 !.', '', 'flag_red', '', 9, 'Alerte', 0);
-- --------------------------------------------------------
--
-- Structure de la table `forums`
--
CREATE TABLE IF NOT EXISTS `forums` (
`forum_id` int(10) NOT NULL AUTO_INCREMENT,
`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 DEFAULT '0',
`attachement` tinyint(1) unsigned NOT NULL DEFAULT '0',
`forum_index` int(2) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`forum_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=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,
`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 '1',
PRIMARY KEY (`topic_id`),
KEY `forum_id` (`forum_id`),
KEY `topic_first` (`topic_first`,`topic_time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=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_INCREMENT=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',
`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`,`status`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=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 '',
`groupe_description` varchar(255) NOT NULL DEFAULT '',
`groupe_forum` int(1) unsigned NOT NULL DEFAULT '0',
`groupe_mns` int(1) unsigned NOT NULL DEFAULT '0',
`groupe_chat` int(1) unsigned NOT NULL DEFAULT '0',
`groupe_blocnote` int(1) unsigned NOT NULL DEFAULT '0',
`groupe_pad` int(1) unsigned NOT NULL DEFAULT '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 '',
`status` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`hid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
--
-- Structure de la table `lblocks`
--
CREATE TABLE IF NOT EXISTS `lblocks` (
`id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
`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 DEFAULT '0',
`actif` smallint(5) unsigned NOT NULL DEFAULT '1',
`css` tinyint(1) NOT NULL DEFAULT '0',
`aide` mediumtext,
PRIMARY KEY (`id`),
KEY `Lindex` (`Lindex`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=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_INCREMENT=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',
`adminid` varchar(60) NOT NULL DEFAULT '',
`editorialtimestamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`editorialtext` text NOT NULL,
`editorialtitle` varchar(100) NOT NULL DEFAULT '',
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 DEFAULT '0.0000',
`totalvotes` int(11) NOT NULL DEFAULT '0',
`totalcomments` int(11) NOT NULL DEFAULT '0',
`topicid_card` tinyint(3) NOT NULL DEFAULT '0',
PRIMARY KEY (`lid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=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 DEFAULT '',
`brokenlink` int(3) NOT NULL DEFAULT '0',
`topicid_card` tinyint(3) NOT NULL DEFAULT '0',
PRIMARY KEY (`requestid`),
UNIQUE KEY `requestid` (`requestid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- 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 '0',
PRIMARY KEY (`lid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
-- --------------------------------------------------------
--
-- Structure de la table `links_subcategories`
--
CREATE TABLE IF NOT EXISTS `links_subcategories` (
`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 ;
-- --------------------------------------------------------
--
-- 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_INCREMENT=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_INCREMENT=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-00-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',
`body` int(11) NOT NULL DEFAULT '0',
`footer` int(11) NOT NULL DEFAULT '0',
`number_send` int(11) NOT NULL DEFAULT '0',
`type_send` char(3) NOT NULL DEFAULT 'ALL',
`date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`status` char(3) NOT NULL DEFAULT 'OK',
PRIMARY KEY (`ref`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=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=archive-stories&ModStart=archive-stories">Nouvelles</a></li><li><a href="forum.php">Forums</a></li><li><a href="sections.php">Rubriques</a></li><li><a href="topics.php">Sujets actifs</a></li><li><a href="modules.php?ModPath=links&ModStart=links">Liens Web</a></li><li><a href="download.php">Downloads</a></li><li><a href="faq.php">FAQ</a></li><li><a href="static.php?op=statik.txt&npds=1">Page statique</a></li><li><a href="reviews.php">Critiques</a></li><li><a href="memberslist.php">Annuaire</a></li><li><a href="map.php">Plan du site</a></li></ul><ul><li><a href="friend.php">Faire 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>');
-- --------------------------------------------------------
--
-- Structure de la table `metalang`
--
CREATE TABLE IF NOT EXISTS `metalang` (
`def` varchar(50) NOT NULL DEFAULT '',
`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`) VALUES
('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'),
('8-)', '$cmd=MM_img("forum/smilies/icon_cool.gif");', 'smil', '-', NULL, NULL, '1'),
('8-]', '$cmd=MM_img("forum/smilies/icon_cool.gif");', 'smil', '-', NULL, NULL, '1'),
(':-P', '$cmd=MM_img("forum/smilies/icon_razz.gif");', 'smil', '-', NULL, NULL, '1'),
(':-D', '$cmd=MM_img("forum/smilies/icon_biggrin.gif");', 'smil', '-', NULL, NULL, '1'),
(':=!', '$cmd=MM_img("forum/smilies/yaisse.gif");', 'smil', '-', NULL, NULL, '1'),
(':b', '$cmd=MM_img("forum/smilies/icon_tongue.gif");', 'smil', '-', NULL, NULL, '1'),
(':D', '$cmd=MM_img("forum/smilies/icon_grin.gif");', 'smil', '-', NULL, NULL, '1'),
(':#', '$cmd=MM_img("forum/smilies/icon_ohwell.gif");', 'smil', '-', NULL, NULL, '1'),
(':-o', '$cmd=MM_img("forum/smilies/icon_eek.gif");', 'smil', '-', NULL, NULL, '1'),
(':-?', '$cmd=MM_img("forum/smilies/icon_confused.gif");', 'smil', '-', NULL, NULL, '1'),
(':-|', '$cmd=MM_img("forum/smilies/icon_mad.gif");', 'smil', '-', NULL, NULL, '1'),
(':|', '$cmd=MM_img("forum/smilies/icon_mad2.gif");', 'smil', '-', NULL, NULL, '1'),
(':paf', '$cmd=MM_img("forum/smilies/pafmur.gif");', 'smil', '-', 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]anti-slash[/french]', '1'),
('!sc_infos_else!', ' ', 'meta', '-', NULL, '[french]affiche les informations de SuperCache[/french]', '1'),
('!sc_infos!', '$cmd=SC_infos();', 'meta', '-', NULL, '[french]affiche les informations de SuperCache[/french]', '1'),
('!slogan!', '$cmd=$GLOBALS[''slogan''];', 'meta', '-', NULL, '[french]variable global $slogan[/french]', '1'),
('!bargif!', '$cmd=$GLOBALS[''bargif''];', 'meta', '-', NULL, '[french]variable global $bargif[/french]', '1'),
('!theme!', '$cmd=$GLOBALS[''theme''];', 'meta', '-', NULL, '[french]variable global $theme[/french]', '1'),
('!sitename!', '$cmd=$GLOBALS[''sitename''];', 'meta', '-', NULL, '[french]variable global $sitename[/french]', '1'),
('!bgcolor1!', '$cmd=$GLOBALS[''bgcolor1''];', 'meta', '-', NULL, '[french]variable&nbs