-- phpMyAdmin SQL Dump
-- version 4.1.14
-- http://www.phpmyadmin.net
--
-- Client :  127.0.0.1
-- Généré le :  Dim 29 Octobre 2017 à 12:53
-- Version du serveur :  5.6.17
-- Version de PHP :  5.5.12

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 :  `nano`
--

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

--
-- Structure de la table `pluscms_administration`
--

CREATE TABLE IF NOT EXISTS `pluscms_administration` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rank_min` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Contenu de la table `pluscms_administration`
--

INSERT INTO `pluscms_administration` (`id`, `rank_min`) VALUES
(1, 5);

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

--
-- Structure de la table `pluscms_administration_page`
--

CREATE TABLE IF NOT EXISTS `pluscms_administration_page` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `config_site` int(11) NOT NULL DEFAULT '9',
  `config_hotel` int(11) NOT NULL DEFAULT '9',
  `uti_recherche` int(11) NOT NULL DEFAULT '5',
  `uti_bannir` int(11) NOT NULL DEFAULT '5',
  `uti_tribunal` int(11) NOT NULL DEFAULT '6',
  `articles_creer` int(11) NOT NULL DEFAULT '4',
  `articles_enligne` int(11) NOT NULL DEFAULT '4',
  `boutique` int(9) NOT NULL DEFAULT '9',
  `badge` int(9) NOT NULL DEFAULT '9',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Contenu de la table `pluscms_administration_page`
--

INSERT INTO `pluscms_administration_page` (`id`, `config_site`, `config_hotel`, `uti_recherche`, `uti_bannir`, `uti_tribunal`, `articles_creer`, `articles_enligne`, `boutique`, `badge`) VALUES
(1, 9, 9, 5, 5, 6, 4, 4, 9, 9);

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

--
-- Structure de la table `pluscms_articles`
--

CREATE TABLE IF NOT EXISTS `pluscms_articles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `titre` varchar(50) NOT NULL,
  `soustitre` varchar(50) NOT NULL,
  `contenu` varchar(1500) NOT NULL,
  `date` int(11) NOT NULL,
  `image` varchar(500) NOT NULL,
  `categorie` enum('information','jeux','concours') NOT NULL,
  `par` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Contenu de la table `pluscms_articles`
--

INSERT INTO `pluscms_articles` (`id`, `titre`, `soustitre`, `contenu`, `date`, `image`, `categorie`, `par`) VALUES
(3, 'TestÃ© 22', 'testÃ© 2', '&lt;p&gt;test&amp;eacute; 1&lt;br /&gt;\r\notvgrc&lt;/p&gt;\r\n\r\n&lt;p&gt;test&amp;eacute;2&lt;br /&gt;\r\n&amp;nbsp;&lt;/p&gt;', 1508877684, 'http://ekladata.com/TNN29A3F1wyhx6TP62hPUUP2eSI.png', 'information', 'Dodone');

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

--
-- Structure de la table `pluscms_boutique`
--

CREATE TABLE IF NOT EXISTS `pluscms_boutique` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `data_dedipass` varchar(200) NOT NULL,
  `public_key` varchar(200) NOT NULL,
  `private_key` varchar(200) NOT NULL,
  `nombre_diamants` int(11) NOT NULL,
  `prix_vip` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Contenu de la table `pluscms_boutique`
--

INSERT INTO `pluscms_boutique` (`id`, `data_dedipass`, `public_key`, `private_key`, `nombre_diamants`, `prix_vip`) VALUES
(1, '79f8179dbd9c1e26a64177ba3aea5ff9', '79f8179dbd9c1e26a64177ba3aea5ff9', '5dcaaac45cf75d04e007fc4a28469b3cfac3049b', 100, 15);

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

--
-- Structure de la table `pluscms_boutique_badges`
--

CREATE TABLE IF NOT EXISTS `pluscms_boutique_badges` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(20) NOT NULL,
  `type` enum('BASIC','RARE') NOT NULL DEFAULT 'BASIC',
  `prix` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Contenu de la table `pluscms_boutique_badges`
--

INSERT INTO `pluscms_boutique_badges` (`id`, `code`, `type`, `prix`) VALUES
(2, 'FR053', 'BASIC', 25),
(3, 'FR054', 'RARE', 25),
(4, 'FR105', 'BASIC', 6);

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

--
-- Structure de la table `pluscms_configuration`
--

CREATE TABLE IF NOT EXISTS `pluscms_configuration` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lien` varchar(30) NOT NULL,
  `nom_hotel` varchar(20) NOT NULL,
  `themes` enum('default','halloween','noel','stvalentin','banzai','paque') NOT NULL,
  `motto` varchar(100) NOT NULL DEFAULT 'Je suis nouveau !',
  `rank` int(11) NOT NULL DEFAULT '1',
  `credits` int(11) NOT NULL DEFAULT '100000',
  `activity_points` int(11) NOT NULL DEFAULT '50000',
  `look` varchar(100) NOT NULL DEFAULT 'ch-255-73.sh-290-62.lg-280-82.hr-165-34.hd-190-3',
  `room` int(11) NOT NULL DEFAULT '0',
  `maintenance` enum('activer','desactiver') NOT NULL DEFAULT 'desactiver',
  `maintenance_raison` varchar(250) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Contenu de la table `pluscms_configuration`
--

INSERT INTO `pluscms_configuration` (`id`, `lien`, `nom_hotel`, `themes`, `motto`, `rank`, `credits`, `activity_points`, `look`, `room`, `maintenance`, `maintenance_raison`) VALUES
(1, 'http://localhost/xx', 'Habbo', 'default', 'Je suis nouveau !', 1, 100000, 50000, 'ch-255-73.sh-290-62.lg-280-82.hr-165-34.hd-190-3', 0, 'desactiver', 'Les techniciens met Ã  jour le serveur repasse plus tard !');

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

--
-- Structure de la table `pluscms_couples`
--

CREATE TABLE IF NOT EXISTS `pluscms_couples` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `membres_1_id` int(11) NOT NULL,
  `membres_2_id` int(11) NOT NULL,
  `date` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Contenu de la table `pluscms_couples`
--

INSERT INTO `pluscms_couples` (`id`, `membres_1_id`, `membres_2_id`, `date`) VALUES
(6, 1, 7, 1508685299);

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

--
-- Structure de la table `pluscms_couples_demandes`
--

CREATE TABLE IF NOT EXISTS `pluscms_couples_demandes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `demandeur_id` int(11) NOT NULL,
  `receveur_id` int(11) NOT NULL,
  `date` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

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

--
-- Structure de la table `pluscms_hotel`
--

CREATE TABLE IF NOT EXISTS `pluscms_hotel` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip` varchar(50) NOT NULL,
  `port` int(11) NOT NULL,
  `variable` varchar(250) NOT NULL,
  `text` varchar(250) NOT NULL,
  `override` varchar(250) NOT NULL,
  `producdata` varchar(250) NOT NULL,
  `figuredata` varchar(250) NOT NULL,
  `furnidata` varchar(250) NOT NULL,
  `base` varchar(250) NOT NULL,
  `habbo_base` varchar(250) NOT NULL,
  `hotel` enum('ouvert','fermer') NOT NULL DEFAULT 'ouvert',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Contenu de la table `pluscms_hotel`
--

INSERT INTO `pluscms_hotel` (`id`, `ip`, `port`, `variable`, `text`, `override`, `producdata`, `figuredata`, `furnidata`, `base`, `habbo_base`, `hotel`) VALUES
(1, '127.0.0.1', 3000, 'http://localhost/game/gamedata/external_variables.txt', 'http://localhost/game/gamedata/external_flash_texts.txt', 'http://localhost/game/gamedata/override/external_override_variables.txt', 'http://localhost/game/gamedata/productdata.txt', 'http://localhost/game/gamedata/figuredata.xml', 'http://localhost/game/gamedata/furnidata.xml', 'http://localhost/game/gordon/PRODUCTION-201601012205-226667486/', 'http://localhost/game/gordon/PRODUCTION-201601012205-226667486/Habbo.swf', 'ouvert');

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

--
-- Structure de la table `pluscms_logstaff`
--

CREATE TABLE IF NOT EXISTS `pluscms_logstaff` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pseudo` varchar(50) NOT NULL,
  `date` varchar(20) NOT NULL,
  `action` varchar(150) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=96 ;

--
-- Contenu de la table `pluscms_logstaff`
--

INSERT INTO `pluscms_logstaff` (`id`, `pseudo`, `date`, `action`) VALUES
(1, 'Dodone', '1487272183', 'CrÃ©ation de l''article "Salut je teste"'),
(2, 'Dodone', '1508877685', 'CrÃ©ation de l''article TestÃ©'),
(3, 'Dodone', '1508883624', 'Mise Ã  jours Configuration > Site.'),
(4, 'Dodone', '1508883652', 'Mise Ã  jours Configuration > Site.'),
(5, 'Dodone', '1508883663', 'Mise Ã  jours Configuration > Site.'),
(6, 'Dodone', '1508883670', 'Mise Ã  jours Configuration > Site.'),
(7, 'Dodone', '1508883678', 'Mise Ã  jours Configuration > Site.'),
(8, 'Dodone', '1508883684', 'Mise Ã  jours Configuration > Site.'),
(9, 'Dodone', '1508883690', 'Mise Ã  jours Configuration > Site.'),
(10, 'Dodone', '1508883698', 'Mise Ã  jours Configuration > Site.'),
(11, 'Dodone', '1508883707', 'Mise Ã  jours Configuration > Site.'),
(12, 'Dodone', '1508883796', 'Mise Ã  jours Configuration > Site.'),
(13, 'Dodone', '1508883818', 'Mise Ã  jours Configuration > Site.'),
(14, 'Dodone', '1508883827', 'Mise Ã  jours Configuration > Site.'),
(15, 'Dodone', '1508884361', 'Mise Ã  jours Configuration > Inscription.'),
(16, 'Dodone', '1508884368', 'Mise Ã  jours Configuration > Inscription.'),
(17, 'Dodone', '1508884393', 'Mise Ã  jours Configuration > Inscription.'),
(18, 'Dodone', '1508884421', 'Mise Ã  jours Configuration > Inscription.'),
(19, 'Dodone', '1508884428', 'Mise Ã  jours Configuration > Inscription.'),
(20, 'Dodone', '1508884437', 'Mise Ã  jours Configuration > Inscription.'),
(21, 'Dodone', '1508884445', 'Mise Ã  jours Configuration > Inscription.'),
(22, 'Dodone', '1508884452', 'Mise Ã  jours Configuration > Inscription.'),
(23, 'Dodone', '1508884543', 'Mise Ã  jours Configuration > Inscription.'),
(24, 'Dodone', '1508884587', 'Mise Ã  jours Configuration > Inscription.'),
(25, 'Dodone', '1508884656', 'Mise Ã  jours Configuration > Inscription.'),
(26, 'Dodone', '1508884693', 'Mise Ã  jours Configuration > Inscription.'),
(27, 'Dodone', '1508885335', 'Mise Ã  jours Configuration > Maintenance.'),
(28, 'Dodone', '1508885379', 'Mise Ã  jours Configuration > Maintenance.'),
(29, 'Dodone', '1508885467', 'Mise Ã  jours Configuration > Maintenance.'),
(30, 'Dodone', '1508885522', 'Mise Ã  jours Configuration > Site.'),
(31, 'Dodone', '1508887307', 'Mise Ã  jour Configuration > HÃ´tel.'),
(32, 'Dodone', '1508887325', 'Mise Ã  jour Configuration > HÃ´tel.'),
(33, 'Dodone', '1508887332', 'Mise Ã  jour Configuration > HÃ´tel.'),
(34, 'Dodone', '1508887339', 'Mise Ã  jour Configuration > HÃ´tel.'),
(35, 'Dodone', '1508887345', 'Mise Ã  jour Configuration > HÃ´tel.'),
(36, 'Dodone', '1508887352', 'Mise Ã  jour Configuration > HÃ´tel.'),
(37, 'Dodone', '1508887359', 'Mise Ã  jour Configuration > HÃ´tel.'),
(38, 'Dodone', '1508887365', 'Mise Ã  jour Configuration > HÃ´tel.'),
(39, 'Dodone', '1508887371', 'Mise Ã  jour Configuration > HÃ´tel.'),
(40, 'Dodone', '1508887377', 'Mise Ã  jour Configuration > HÃ´tel.'),
(41, 'Dodone', '1508887419', 'Mise Ã  jour Configuration > HÃ´tel.'),
(42, 'Dodone', '1508887483', 'Mise Ã  jour Configuration > HÃ´tel.'),
(43, 'Dodone', '1508887514', 'Mise Ã  jour Configuration > HÃ´tel.'),
(44, 'Dodone', '1508887535', 'Mise Ã  jour Configuration > HÃ´tel.'),
(45, 'Dodone', '1508887579', 'Mise Ã  jour Configuration > HÃ´tel.'),
(46, 'Dodone', '1508887587', 'Mise Ã  jour Configuration > HÃ´tel.'),
(47, 'Dodone', '1508887614', 'Mise Ã  jour Configuration > HÃ´tel.'),
(48, 'Dodone', '1508887748', 'Mise Ã  jour Configuration > HÃ´tel.'),
(49, 'Dodone', '1508888004', 'Mise Ã  jour Configuration > HÃ´tel.'),
(50, 'Dodone', '1508934092', 'Supprimer un article.'),
(51, 'Dodone', '1508935245', 'Edition de l''articleTestÃ©'),
(52, 'Dodone', '1508935287', 'Edition de l''articleTestÃ©'),
(53, 'Dodone', '1508935338', 'Edition de l''articleTestÃ©'),
(54, 'Dodone', '1508935347', 'Edition de l''articleTestÃ© 22'),
(55, 'Dodone', '1508935380', 'Edition de l''articleTestÃ©'),
(56, 'Dodone', '1508935389', 'Edition de l''articleTestÃ© 22'),
(57, 'Dodone', '1508935396', 'Edition de l''articleTestÃ© 22'),
(58, 'Dodone', '1508935447', 'Edition de l''articleTestÃ© 22'),
(59, 'Dodone', '1508935463', 'Edition de l''articleTestÃ© 22'),
(60, 'Dodone', '1508935699', 'Edition de l''articleTestÃ© 22'),
(61, 'Dodone', '1508935718', 'Edition de l''article TestÃ© 22'),
(62, 'Dodone', '1508938867', 'Edition du membre Dodone'),
(63, 'Dodone', '1508938892', 'Edition du membre Dodone'),
(64, 'Dodone', '1508938925', 'Edition du membre Dodone'),
(65, 'Dodone', '1508938931', 'Edition du membre Dodone2'),
(66, 'Dodone2', '1508938940', 'Edition du membre Dodone'),
(67, 'Dodone', '1508938950', 'Edition du membre Dodone'),
(68, 'Dodone', '1508938955', 'Edition du membre Dodone'),
(69, 'Dodone', '1508938961', 'Edition du membre Dodone'),
(70, 'Dodone', '1508938967', 'Edition du membre Dodone'),
(71, 'Dodone', '1508938972', 'Edition du membre Dodone'),
(72, 'Dodone', '1508941504', 'Edition de l''article '),
(73, 'Dodone', '1508941504', 'Edition de l''article '),
(74, 'Dodone', '1508941728', 'bannissement de l''ip 127.0.0.1'),
(75, 'Dodone', '1508942105', 'bannissement du membre Banana'),
(76, 'Dodone', '1508942147', 'bannissement de l''ip 127.0.0.2'),
(77, 'Dodone', '1508969625', 'Bannissement du membre banana'),
(78, 'Dodone', '1508969910', 'DÃ©bannissement de banana'),
(79, 'Dodone', '1508969928', 'DÃ©bannissement de banana'),
(80, 'Dodone', '1508970599', 'Bannissement de l''ip 127.0.0.1'),
(81, 'Dodone', '1508970617', 'Bannissement du membre Banana'),
(82, 'Dodone', '1508972145', 'Mise Ã  jours Configuration > Site.'),
(83, 'Dodone', '1508972152', 'Mise Ã  jours Configuration > Site.'),
(84, 'Dodone', '1509201827', 'Mise Ã  jour Boutique > Configuration.'),
(85, 'Dodone', '1509201842', 'Mise Ã  jour Boutique > Configuration.'),
(86, 'Dodone', '1509201894', 'Mise Ã  jour Boutique > Configuration.'),
(87, 'Dodone', '1509203200', 'Supprime un badge de la boutique.'),
(88, 'Dodone', '1509204199', 'Ajout d''un badge dans boutique.'),
(89, 'Dodone', '1509205930', 'Ajout d''un badge dans boutique.'),
(90, 'Dodone', '1509276483', 'Mise Ã  jour Boutique > Configuration.'),
(91, 'Dodone', '1509277141', 'Mise Ã  jour Boutique > Configuration.'),
(92, 'Dodone', '1509277311', 'Mise Ã  jour Boutique > Configuration.'),
(93, 'Dodone', '1509277423', 'Mise Ã  jour Boutique > Configuration.'),
(94, 'Dodone', '1509277431', 'Mise Ã  jour Boutique > Configuration.'),
(95, 'Dodone', '1509277448', 'Mise Ã  jour Boutique > Configuration.');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
