Edit - nuked.sql

Edit: nuked.sql

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 */;

--
-- Database: `nuked`
--

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

--
-- Table structure for table `[[dbprefix]]_action`
--

CREATE TABLE `[[dbprefix]]_action` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` varchar(30) COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `pseudo` text COLLATE latin1_general_ci NOT NULL,
  `action` text COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]_banned`
--

CREATE TABLE `[[dbprefix]]_banned` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip` varchar(40) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `pseudo` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `email` varchar(80) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `date` varchar(20) COLLATE latin1_general_ci DEFAULT NULL,
  `dure` varchar(20) COLLATE latin1_general_ci DEFAULT NULL,
  `texte` text COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]_block`
--

CREATE TABLE `[[dbprefix]]_block` (
  `bid` int(10) NOT NULL AUTO_INCREMENT,
  `active` int(1) NOT NULL DEFAULT '0',
  `position` int(2) NOT NULL DEFAULT '0',
  `module` varchar(100) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `titre` text COLLATE latin1_general_ci NOT NULL,
  `content` text COLLATE latin1_general_ci NOT NULL,
  `type` varchar(30) COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `nivo` int(1) NOT NULL DEFAULT '0',
  `page` text COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`bid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=12 ;

--
-- Dumping data for table `[[dbprefix]]_block`
--

INSERT INTO `[[dbprefix]]_block` VALUES
(1, 2, 1, '', 'Login', '', 'login', 0, 'Tous'),
(2, 1, 1, '', 'Menu', '[News]|News||0|NEWLINE[Archives]|Archives||0|NEWLINE[Forum]|Forum||0|NEWLINE[Download]|Downloads||0|NEWLINE[Members]|Members||0|NEWLINE[Team]|Team||0|NEWLINE[Defy]|Challenge Us||0|NEWLINE[Recruit]|Recruitement||0|NEWLINE[Sections]|Articles||0|NEWLINE[Server]|Servers||0|NEWLINE[Links]|Links||0|NEWLINE[Calendar]|Calendar||0|NEWLINE[Gallery]|Gallery||0|NEWLINE[Wars]|Wars||0|NEWLINE[Irc]|Irc||0|NEWLINE[Guestbook]|Guestbook||0|NEWLINE[Search]|Search||0|NEWLINE|<b>Member</b>||1|NEWLINE[User]|Account||1|NEWLINE|<b>Admin</b>||2|NEWLINE[Admin]|Administration||2|', 'menu', 0, 'Tous'),
(3, 1, 2, 'Search', 'Search', '', 'module', 0, 'Tous'),
(4, 2, 2, '', 'Surveys', '', 'survey', 0, 'Tous'),
(5, 2, 3, 'Wars', 'Wars', '', 'module', 0, 'Tous'),
(6, 1, 3, 'Stats', 'Stats', '', 'module', 0, 'Tous'),
(7, 0, 0, 'Irc', 'Irc Awards', '', 'module', 0, 'Tous'),
(8, 0, 0, 'Server', 'Server monitor', '', 'module', 0, 'Tous'),
(9, 0, 0, '', 'Suggest', '', 'suggest', 1, 'Tous'),
(10, 0, 0, 'Textbox', 'Shoutbox', '', 'module', 0, 'Tous'),
(11, 1, 4, '', 'Partners', '<div style="text-align: center;padding: 10px;"><a href="http://www.nuked-klan.org" onclick="window.open(this.href); return false;"><img style="border: 0;" src="images/ban.png" alt="" title="Nuked-klaN CMS" /></a></div><div style="text-align: center;padding: 10px;"><a href="http://www.nitroserv.fr" onclick="window.open(this.href); return false;"><img style="border: 0;" src="images/nitroserv.png" alt="" title="GAME_SERVER_RENTING" /></a></div>', 'html', 0, 'Tous');

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

--
-- Table structure for table `[[dbprefix]]_calendar`
--

CREATE TABLE `[[dbprefix]]_calendar` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `titre` text COLLATE latin1_general_ci NOT NULL,
  `description` text COLLATE latin1_general_ci NOT NULL,
  `date_jour` int(2) DEFAULT NULL,
  `date_mois` int(2) DEFAULT NULL,
  `date_an` int(4) DEFAULT NULL,
  `heure` varchar(5) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `auteur` text COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]_comment`
--

CREATE TABLE `[[dbprefix]]_comment` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `module` varchar(30) COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `im_id` int(100) DEFAULT NULL,
  `autor` text COLLATE latin1_general_ci,
  `autor_id` varchar(20) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `titre` text COLLATE latin1_general_ci NOT NULL,
  `comment` text COLLATE latin1_general_ci,
  `date` varchar(12) COLLATE latin1_general_ci DEFAULT NULL,
  `autor_ip` varchar(40) COLLATE latin1_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `im_id` (`im_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]_comment_mod`
--

CREATE TABLE `[[dbprefix]]_comment_mod` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `module` text COLLATE latin1_general_ci NOT NULL,
  `active` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=8 ;

--
-- Dumping data for table `[[dbprefix]]_comment_mod`
--

INSERT INTO `[[dbprefix]]_comment_mod` VALUES
(1, 'news', 1),
(2, 'download', 1),
(3, 'links', 1),
(4, 'survey', 1),
(5, 'wars', 1),
(6, 'gallery', 1),
(7, 'sections', 1);

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

--
-- Table structure for table `[[dbprefix]]_config`
--

CREATE TABLE `[[dbprefix]]_config` (
  `name` varchar(255) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `value` text COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `[[dbprefix]]_config`
--

INSERT INTO `[[dbprefix]]_config` VALUES
('time_generate', 'on'),
('dateformat', '%m/%d/%Y'),
('datezone', '+0000'),
('version', '1.7.15'),
('date_install', '[[timestamp]]'),
('langue', 'english'),
('stats_share', '1'),
('stats_timestamp', '0'),
('name', 'Nuked-klaN 1.7.15'),
('slogan', 'PHP 4 Gamers'),
('tag_pre', ''),
('tag_suf', ''),
('url', '[[softurl]]'),
('mail', '[[admin_email]]'),
('footmessage', ''),
('nk_status', 'open'),
('index_site', 'News'),
('theme', 'Impact_Nk'),
('keyword', ''),
('description', ''),
('inscription', 'on'),
('inscription_mail', ''),
('inscription_avert', ''),
('inscription_charte', ''),
('validation', 'auto'),
('user_delete', 'on'),
('video_editeur', 'on'),
('scayt_editeur', 'on'),
('suggest_avert', ''),
('irc_chan', 'nuked-klan'),
('irc_serv', 'noxether.net'),
('server_ip', ''),
('server_port', ''),
('server_pass', ''),
('server_game', ''),
('forum_title', ''),
('forum_desc', ''),
('forum_rank_team', 'off'),
('forum_field_max', '10'),
('forum_file', 'on'),
('forum_file_level', '1'),
('forum_file_maxsize', '1000'),
('thread_forum_page', '20'),
('mess_forum_page', '10'),
('hot_topic', '20'),
('post_flood', '10'),
('gallery_title', ''),
('max_img_line', '2'),
('max_img', '6'),
('max_news', '5'),
('max_download', '10'),
('hide_download', 'on'),
('max_liens', '10'),
('max_sections', '10'),
('max_wars', '30'),
('max_archives', '30'),
('max_members', '30'),
('max_shout', '20'),
('mess_guest_page', '10'),
('sond_delay', '24'),
('level_analys', '-1'),
('visit_delay', '10'),
('recrute', '1'),
('recrute_charte', ''),
('recrute_mail', ''),
('recrute_inbox', ''),
('defie_charte', ''),
('defie_mail', ''),
('defie_inbox', ''),
('birthday', 'all'),
('avatar_upload', 'on'),
('avatar_url', 'on'),
('cookiename', 'nuked'),
('sess_inactivemins', '5'),
('sess_days_limit', '365'),
('nbc_timeout', '300'),
('screen', 'on'),
('contact_mail', '[[admin_email]]'),
('contact_flood', '60');

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

--
-- Table structure for table `[[dbprefix]]_contact`
--

CREATE TABLE `[[dbprefix]]_contact` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `titre` varchar(200) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `message` text COLLATE latin1_general_ci NOT NULL,
  `email` varchar(80) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `nom` varchar(200) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `ip` varchar(40) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `date` varchar(30) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `titre` (`titre`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]_defie`
--

CREATE TABLE `[[dbprefix]]_defie` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `send` varchar(12) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `pseudo` text COLLATE latin1_general_ci NOT NULL,
  `clan` text COLLATE latin1_general_ci NOT NULL,
  `mail` varchar(80) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `icq` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `irc` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `url` varchar(200) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `pays` text COLLATE latin1_general_ci NOT NULL,
  `date` varchar(20) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `heure` varchar(10) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `serveur` text COLLATE latin1_general_ci NOT NULL,
  `game` int(11) NOT NULL DEFAULT '0',
  `type` text COLLATE latin1_general_ci NOT NULL,
  `map` text COLLATE latin1_general_ci NOT NULL,
  `comment` text COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]_discussion`
--

CREATE TABLE `[[dbprefix]]_discussion` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` varchar(30) COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `pseudo` text COLLATE latin1_general_ci NOT NULL,
  `texte` text COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]_downloads`
--

CREATE TABLE `[[dbprefix]]_downloads` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` varchar(12) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `taille` varchar(6) COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `titre` text COLLATE latin1_general_ci NOT NULL,
  `description` text COLLATE latin1_general_ci NOT NULL,
  `type` int(11) NOT NULL DEFAULT '0',
  `count` int(10) NOT NULL DEFAULT '0',
  `url` varchar(200) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `url2` varchar(200) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `broke` int(11) NOT NULL DEFAULT '0',
  `url3` varchar(200) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `level` int(1) NOT NULL DEFAULT '0',
  `hit` int(11) NOT NULL DEFAULT '0',
  `edit` varchar(12) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `screen` varchar(200) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `autor` text COLLATE latin1_general_ci NOT NULL,
  `url_autor` varchar(200) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `comp` text COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `type` (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]_downloads_cat`
--

CREATE TABLE `[[dbprefix]]_downloads_cat` (
  `cid` int(11) NOT NULL AUTO_INCREMENT,
  `parentid` int(11) NOT NULL DEFAULT '0',
  `titre` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `description` text COLLATE latin1_general_ci NOT NULL,
  `level` int(1) NOT NULL DEFAULT '0',
  `position` int(2) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`cid`),
  KEY `parentid` (`parentid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]_erreursql`
--

CREATE TABLE `[[dbprefix]]_erreursql` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` varchar(30) COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `lien` text COLLATE latin1_general_ci NOT NULL,
  `texte` text COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]_forums`
--

CREATE TABLE `[[dbprefix]]_forums` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `cat` int(11) NOT NULL DEFAULT '0',
  `nom` text COLLATE latin1_general_ci NOT NULL,
  `comment` text COLLATE latin1_general_ci NOT NULL,
  `moderateurs` text COLLATE latin1_general_ci NOT NULL,
  `niveau` int(1) NOT NULL DEFAULT '0',
  `level` int(1) NOT NULL DEFAULT '0',
  `ordre` int(5) NOT NULL DEFAULT '0',
  `level_poll` int(1) NOT NULL DEFAULT '0',
  `level_vote` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `cat` (`cat`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `[[dbprefix]]_forums`
--

INSERT INTO `[[dbprefix]]_forums` VALUES
(1, 1, 'Forum', 'Test Forum', '', 0, 0, 0, 1, 1);

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

--
-- Table structure for table `[[dbprefix]]_forums_cat`
--

CREATE TABLE `[[dbprefix]]_forums_cat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(100) COLLATE latin1_general_ci DEFAULT NULL,
  `ordre` int(5) NOT NULL DEFAULT '0',
  `niveau` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `[[dbprefix]]_forums_cat`
--

INSERT INTO `[[dbprefix]]_forums_cat` VALUES
(1, 'Category 1', 0, 0);

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

--
-- Table structure for table `[[dbprefix]]_forums_messages`
--

CREATE TABLE `[[dbprefix]]_forums_messages` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `titre` text COLLATE latin1_general_ci NOT NULL,
  `txt` text COLLATE latin1_general_ci NOT NULL,
  `date` varchar(12) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `edition` text COLLATE latin1_general_ci NOT NULL,
  `auteur` text COLLATE latin1_general_ci NOT NULL,
  `auteur_id` varchar(20) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `auteur_ip` varchar(40) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `bbcodeoff` int(1) NOT NULL DEFAULT '0',
  `smileyoff` int(1) NOT NULL DEFAULT '0',
  `cssoff` int(1) NOT NULL DEFAULT '0',
  `usersig` int(1) NOT NULL DEFAULT '0',
  `emailnotify` int(1) NOT NULL DEFAULT '0',
  `thread_id` int(5) NOT NULL DEFAULT '0',
  `forum_id` mediumint(10) NOT NULL DEFAULT '0',
  `file` varchar(200) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `auteur_id` (`auteur_id`),
  KEY `thread_id` (`thread_id`),
  KEY `forum_id` (`forum_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]_forums_options`
--

CREATE TABLE `[[dbprefix]]_forums_options` (
  `id` int(11) NOT NULL DEFAULT '0',
  `poll_id` int(11) NOT NULL DEFAULT '0',
  `option_text` varchar(255) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `option_vote` int(11) NOT NULL DEFAULT '0',
  KEY `poll_id` (`poll_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- Table structure for table `[[dbprefix]]_forums_poll`
--

CREATE TABLE `[[dbprefix]]_forums_poll` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `thread_id` int(11) NOT NULL DEFAULT '0',
  `titre` varchar(255) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `thread_id` (`thread_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]_forums_rank`
--

CREATE TABLE `[[dbprefix]]_forums_rank` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `nom` varchar(100) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `type` int(1) NOT NULL DEFAULT '0',
  `post` int(4) NOT NULL DEFAULT '0',
  `image` varchar(200) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=8 ;

--
-- Dumping data for table `[[dbprefix]]_forums_rank`
--

INSERT INTO `[[dbprefix]]_forums_rank` VALUES
(1, 'Newbie', 0, 0, 'modules/Forum/images/rank/star1.gif'),
(2, 'Junior member', 0, 10, 'modules/Forum/images/rank/star2.gif'),
(3, 'Member', 0, 100, 'modules/Forum/images/rank/star3.gif'),
(4, 'Senior member', 0, 500, 'modules/Forum/images/rank/star4.gif'),
(5, 'Posting Freak', 0, 1000, 'modules/Forum/images/rank/star5.gif'),
(6, 'Moderator', 1, 0, 'modules/Forum/images/rank/mod.gif'),
(7, 'Administrator', 2, 0, 'modules/Forum/images/rank/mod.gif');

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

--
-- Table structure for table `[[dbprefix]]_forums_read`
--

CREATE TABLE `[[dbprefix]]_forums_read` (
  `user_id` varchar(20) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `thread_id` text COLLATE latin1_general_ci NOT NULL,
  `forum_id` text COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- Table structure for table `[[dbprefix]]_forums_threads`
--

CREATE TABLE `[[dbprefix]]_forums_threads` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `titre` text COLLATE latin1_general_ci NOT NULL,
  `date` varchar(10) COLLATE latin1_general_ci DEFAULT NULL,
  `closed` int(1) NOT NULL DEFAULT '0',
  `auteur` text COLLATE latin1_general_ci NOT NULL,
  `auteur_id` varchar(20) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `forum_id` int(5) NOT NULL DEFAULT '0',
  `last_post` varchar(20) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `view` int(10) NOT NULL DEFAULT '0',
  `annonce` int(1) NOT NULL DEFAULT '0',
  `sondage` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `auteur_id` (`auteur_id`),
  KEY `forum_id` (`forum_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]_forums_vote`
--

CREATE TABLE `[[dbprefix]]_forums_vote` (
  `poll_id` int(11) NOT NULL DEFAULT '0',
  `auteur_id` varchar(20) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `auteur_ip` varchar(40) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  KEY `poll_id` (`poll_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- Table structure for table `[[dbprefix]]_gallery`
--

CREATE TABLE `[[dbprefix]]_gallery` (
  `sid` int(11) NOT NULL AUTO_INCREMENT,
  `titre` text COLLATE latin1_general_ci NOT NULL,
  `description` text COLLATE latin1_general_ci NOT NULL,
  `url` varchar(200) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `url2` varchar(200) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `url_file` varchar(200) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `cat` int(11) NOT NULL DEFAULT '0',
  `date` varchar(12) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `count` int(10) NOT NULL DEFAULT '0',
  `autor` text COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`sid`),
  KEY `cat` (`cat`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]_gallery_cat`
--

CREATE TABLE `[[dbprefix]]_gallery_cat` (
  `cid` int(11) NOT NULL AUTO_INCREMENT,
  `parentid` int(11) NOT NULL DEFAULT '0',
  `titre` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `description` text COLLATE latin1_general_ci NOT NULL,
  `position` int(2) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`cid`),
  KEY `parentid` (`parentid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]_games`
--

CREATE TABLE `[[dbprefix]]_games` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `titre` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `icon` varchar(150) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `pref_1` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `pref_2` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `pref_3` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `pref_4` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `pref_5` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `map` text COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `[[dbprefix]]_games`
--

INSERT INTO `[[dbprefix]]_games` VALUES
(1, 'Counter Strike Source', 'CS Preferences', 'images/games/cs.gif', 'Other Nick', 'Favorite Map', 'Favorite Weapon', 'Terro Skin', 'CT Skin', 'de_dust2|de_inferno');

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

--
-- Table structure for table `[[dbprefix]]_games_prefs`
--

CREATE TABLE `[[dbprefix]]_games_prefs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `game` int(11) NOT NULL DEFAULT '0',
  `user_id` varchar(20) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `pref_1` text COLLATE latin1_general_ci NOT NULL,
  `pref_2` text COLLATE latin1_general_ci NOT NULL,
  `pref_3` text COLLATE latin1_general_ci NOT NULL,
  `pref_4` text COLLATE latin1_general_ci NOT NULL,
  `pref_5` text COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]_guestbook`
--

CREATE TABLE `[[dbprefix]]_guestbook` (
  `id` int(9) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `email` varchar(60) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `url` varchar(70) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `date` int(11) NOT NULL DEFAULT '0',
  `host` varchar(60) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `comment` text COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]_irc_awards`
--

CREATE TABLE `[[dbprefix]]_irc_awards` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `text` text COLLATE latin1_general_ci NOT NULL,
  `date` varchar(30) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]_liens`
--

CREATE TABLE `[[dbprefix]]_liens` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `date` varchar(12) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `titre` text COLLATE latin1_general_ci NOT NULL,
  `description` text COLLATE latin1_general_ci NOT NULL,
  `url` varchar(200) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `cat` int(11) NOT NULL DEFAULT '0',
  `webmaster` text COLLATE latin1_general_ci NOT NULL,
  `country` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `count` int(11) NOT NULL DEFAULT '0',
  `broke` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `cat` (`cat`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]_liens_cat`
--

CREATE TABLE `[[dbprefix]]_liens_cat` (
  `cid` int(11) NOT NULL AUTO_INCREMENT,
  `parentid` int(11) NOT NULL DEFAULT '0',
  `titre` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `description` text COLLATE latin1_general_ci NOT NULL,
  `position` int(2) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`cid`),
  KEY `parentid` (`parentid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]_match`
--

CREATE TABLE `[[dbprefix]]_match` (
  `warid` int(10) NOT NULL AUTO_INCREMENT,
  `etat` int(1) NOT NULL DEFAULT '0',
  `team` int(11) NOT NULL DEFAULT '0',
  `game` int(11) NOT NULL DEFAULT '0',
  `adversaire` text COLLATE latin1_general_ci,
  `url_adv` varchar(60) COLLATE latin1_general_ci DEFAULT NULL,
  `pays_adv` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `type` varchar(100) COLLATE latin1_general_ci DEFAULT NULL,
  `style` varchar(100) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `date_jour` int(2) DEFAULT NULL,
  `date_mois` int(2) DEFAULT NULL,
  `date_an` int(4) DEFAULT NULL,
  `heure` varchar(10) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `map` text COLLATE latin1_general_ci,
  `tscore_team` float DEFAULT NULL,
  `tscore_adv` float DEFAULT NULL,
  `score_team` text COLLATE latin1_general_ci NOT NULL,
  `score_adv` text COLLATE latin1_general_ci NOT NULL,
  `report` text COLLATE latin1_general_ci,
  `auteur` varchar(50) COLLATE latin1_general_ci DEFAULT NULL,
  `url_league` varchar(100) COLLATE latin1_general_ci DEFAULT NULL,
  `dispo` text COLLATE latin1_general_ci,
  `pas_dispo` text COLLATE latin1_general_ci,
  PRIMARY KEY (`warid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]_match_files`
--

CREATE TABLE `[[dbprefix]]_match_files` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `module` varchar(30) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `im_id` int(10) NOT NULL DEFAULT '0',
  `type` varchar(30) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `url` varchar(200) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `im_id` (`im_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]_modules`
--

CREATE TABLE `[[dbprefix]]_modules` (
  `id` int(2) NOT NULL AUTO_INCREMENT,
  `nom` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `niveau` int(1) NOT NULL DEFAULT '0',
  `admin` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=23 ;

--
-- Dumping data for table `[[dbprefix]]_modules`
--

INSERT INTO `[[dbprefix]]_modules` VALUES
(1, 'News', 0, 2),
(2, 'Forum', 0, 2),
(3, 'Wars', 0, 2),
(4, 'Irc', 0, 2),
(5, 'Survey', 0, 3),
(6, 'Links', 0, 3),
(7, 'Sections', 0, 3),
(8, 'Server', 0, 3),
(9, 'Download', 0, 3),
(10, 'Gallery', 0, 3),
(11, 'Guestbook', 0, 3),
(12, 'Suggest', 0, 3),
(13, 'Textbox', 0, 9),
(14, 'Calendar', 0, 2),
(15, 'Members', 0, 9),
(16, 'Team', 0, 9),
(17, 'Defy', 0, 3),
(18, 'Recruit', 0, 3),
(19, 'Comment', 0, 9),
(20, 'Vote', 0, 9),
(21, 'Stats', 0, 2),
(22, 'Contact', 0, 3);

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

--
-- Table structure for table `[[dbprefix]]_nbconnecte`
--

CREATE TABLE `[[dbprefix]]_nbconnecte` (
  `IP` varchar(40) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `type` int(10) NOT NULL DEFAULT '0',
  `date` int(14) NOT NULL DEFAULT '0',
  `user_id` varchar(20) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `username` varchar(40) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`IP`,`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- Table structure for table `[[dbprefix]]_news`
--

CREATE TABLE `[[dbprefix]]_news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cat` varchar(30) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `titre` text COLLATE latin1_general_ci,
  `auteur` text COLLATE latin1_general_ci,
  `auteur_id` varchar(20) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `texte` text COLLATE latin1_general_ci,
  `suite` text COLLATE latin1_general_ci,
  `date` varchar(30) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `bbcodeoff` int(1) NOT NULL DEFAULT '0',
  `smileyoff` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `cat` (`cat`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `[[dbprefix]]_news`
--

INSERT INTO `[[dbprefix]]_news` VALUES
(1, '1', 'Welcome to your NuKed-KlaN website 1.7.15', '[[admin_username]]', '[[auteur_id]]', 'Welcome to your NuKed-KlaN website, the installation stage has ended, go to the administration to configure and use your website. You can login with the name and the password you indicated at the installation. If any problems occur, please inform us of it in the appropriate forum of <a href="http://www.nuked-klan.org">http://www.nuked-klan.org</a>.', NULL, '[[timestamp]]', 0, 0);

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

--
-- Table structure for table `[[dbprefix]]_news_cat`
--

CREATE TABLE `[[dbprefix]]_news_cat` (
  `nid` int(11) NOT NULL AUTO_INCREMENT,
  `titre` text COLLATE latin1_general_ci,
  `description` text COLLATE latin1_general_ci,
  `image` text COLLATE latin1_general_ci,
  PRIMARY KEY (`nid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `[[dbprefix]]_news_cat`
--

INSERT INTO `[[dbprefix]]_news_cat` VALUES
(1, 'Counter Strike Source', 'The best MOD for Half-Life', 'modules/News/images/cs.gif');

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

--
-- Table structure for table `[[dbprefix]]_notification`
--

CREATE TABLE `[[dbprefix]]_notification` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` varchar(30) COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `type` text COLLATE latin1_general_ci NOT NULL,
  `texte` text COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]_recrute`
--

CREATE TABLE `[[dbprefix]]_recrute` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` varchar(12) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `pseudo` text COLLATE latin1_general_ci NOT NULL,
  `prenom` text COLLATE latin1_general_ci NOT NULL,
  `age` int(3) NOT NULL DEFAULT '0',
  `mail` varchar(80) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `icq` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `country` text COLLATE latin1_general_ci NOT NULL,
  `game` int(11) NOT NULL DEFAULT '0',
  `connection` text COLLATE latin1_general_ci NOT NULL,
  `experience` text COLLATE latin1_general_ci NOT NULL,
  `dispo` text COLLATE latin1_general_ci NOT NULL,
  `comment` text COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `game` (`game`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]_sections`
--

CREATE TABLE `[[dbprefix]]_sections` (
  `artid` int(11) NOT NULL AUTO_INCREMENT,
  `secid` int(11) NOT NULL DEFAULT '0',
  `title` text COLLATE latin1_general_ci NOT NULL,
  `content` text COLLATE latin1_general_ci NOT NULL,
  `autor` text COLLATE latin1_general_ci NOT NULL,
  `autor_id` varchar(20) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `counter` int(11) NOT NULL DEFAULT '0',
  `bbcodeoff` int(1) NOT NULL DEFAULT '0',
  `smileyoff` int(1) NOT NULL DEFAULT '0',
  `date` varchar(12) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`artid`),
  KEY `secid` (`secid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]_sections_cat`
--

CREATE TABLE `[[dbprefix]]_sections_cat` (
  `secid` int(11) NOT NULL AUTO_INCREMENT,
  `parentid` int(11) NOT NULL DEFAULT '0',
  `secname` varchar(40) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `description` text COLLATE latin1_general_ci NOT NULL,
  `position` int(2) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`secid`),
  KEY `parentid` (`parentid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]_serveur`
--

CREATE TABLE `[[dbprefix]]_serveur` (
  `sid` int(30) NOT NULL AUTO_INCREMENT,
  `game` varchar(30) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `ip` varchar(40) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `port` varchar(10) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `pass` varchar(10) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `cat` varchar(30) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`sid`),
  KEY `game` (`game`),
  KEY `cat` (`cat`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]_serveur_cat`
--

CREATE TABLE `[[dbprefix]]_serveur_cat` (
  `cid` int(30) NOT NULL AUTO_INCREMENT,
  `titre` varchar(30) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `description` text COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]_sessions`
--

CREATE TABLE `[[dbprefix]]_sessions` (
  `id` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `user_id` varchar(20) COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `date` varchar(30) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `last_used` varchar(30) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `ip` varchar(40) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `vars` blob NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- Table structure for table `[[dbprefix]]_shoutbox`
--

CREATE TABLE `[[dbprefix]]_shoutbox` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `auteur` text COLLATE latin1_general_ci,
  `ip` varchar(40) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `texte` text COLLATE latin1_general_ci,
  `date` varchar(30) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `[[dbprefix]]_shoutbox`
--

INSERT INTO `[[dbprefix]]_shoutbox` VALUES
(1, '[[admin_username]]', '[[clientip]]', 'Welcome to your NuKed-KlaN website 1.7.15', '[[timestamp]]');

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

--
-- Table structure for table `[[dbprefix]]_smilies`
--

CREATE TABLE `[[dbprefix]]_smilies` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `code` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `url` varchar(100) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `name` varchar(100) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=12 ;

--
-- Dumping data for table `[[dbprefix]]_smilies`
--

INSERT INTO `[[dbprefix]]_smilies` VALUES
(1, ':D', 'biggrin.gif', 'Very Happy'),
(2, ':)', 'smile.gif', 'Smile'),
(3, ':(', 'frown.gif', 'Sad'),
(4, ':o', 'eek.gif', 'Surprised'),
(5, ':?', 'confused.gif', 'Confused'),
(6, '8)', 'cool.gif', 'Cool'),
(7, ':P', 'tongue.gif', 'Razz'),
(8, ':x', 'mad.gif', 'Mad'),
(9, ';)', 'wink.gif', 'Wink'),
(10, ':red:', 'redface.gif', 'Embarassed'),
(11, ':roll:', 'rolleyes.gif', 'Rolling Eyes');

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

--
-- Table structure for table `[[dbprefix]]_sondage`
--

CREATE TABLE `[[dbprefix]]_sondage` (
  `sid` int(11) NOT NULL AUTO_INCREMENT,
  `titre` varchar(100) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `date` varchar(15) COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `niveau` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`sid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `[[dbprefix]]_sondage`
--

INSERT INTO `[[dbprefix]]_sondage` VALUES
(1, 'Do you like Nuked-klan ?', '[[timestamp]]', 0);

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

--
-- Table structure for table `[[dbprefix]]_sondage_check`
--

CREATE TABLE `[[dbprefix]]_sondage_check` (
  `ip` varchar(40) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `pseudo` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `heurelimite` int(14) NOT NULL DEFAULT '0',
  `sid` varchar(30) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  KEY `sid` (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- Table structure for table `[[dbprefix]]_sondage_data`
--

CREATE TABLE `[[dbprefix]]_sondage_data` (
  `sid` int(11) NOT NULL DEFAULT '0',
  `optionText` char(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `optionCount` int(11) NOT NULL DEFAULT '0',
  `voteID` int(11) NOT NULL DEFAULT '0',
  KEY `sid` (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `[[dbprefix]]_sondage_data`
--

INSERT INTO `[[dbprefix]]_sondage_data` VALUES
(1, 'it''s great, carry on!', 0, 1),
(1, 'I guess it''s alright', 0, 2),
(1, 'it sucks, stop it!', 0, 3),
(1, 'What''s nuked-klan?', 0, 4);

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

--
-- Table structure for table `[[dbprefix]]_stats`
--

CREATE TABLE `[[dbprefix]]_stats` (
  `nom` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `type` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `count` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`nom`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `[[dbprefix]]_stats`
--

INSERT INTO `[[dbprefix]]_stats` VALUES
('Gallery', 'pages', 0),
('Archives', 'pages', 0),
('Calendar', 'pages', 0),
('Defy', 'pages', 0),
('Download', 'pages', 0),
('Guestbook', 'pages', 0),
('Irc', 'pages', 0),
('Links', 'pages', 0),
('Wars', 'pages', 0),
('News', 'pages', 0),
('Search', 'pages', 0),
('Recruit', 'pages', 0),
('Sections', 'pages', 0),
('Server', 'pages', 0),
('Members', 'pages', 0),
('Team', 'pages', 0),
('Forum', 'pages', 0);

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

--
-- Table structure for table `[[dbprefix]]_stats_visitor`
--

CREATE TABLE `[[dbprefix]]_stats_visitor` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(20) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `ip` varchar(40) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `host` varchar(100) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `browser` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `os` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `referer` varchar(200) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `day` int(2) NOT NULL DEFAULT '0',
  `month` int(2) NOT NULL DEFAULT '0',
  `year` int(4) NOT NULL DEFAULT '0',
  `hour` int(2) NOT NULL DEFAULT '0',
  `date` varchar(30) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `host` (`host`),
  KEY `browser` (`browser`),
  KEY `os` (`os`),
  KEY `referer` (`referer`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]_suggest`
--

CREATE TABLE `[[dbprefix]]_suggest` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `module` mediumtext COLLATE latin1_general_ci NOT NULL,
  `user_id` varchar(20) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `proposition` longtext COLLATE latin1_general_ci NOT NULL,
  `date` varchar(14) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]_team`
--

CREATE TABLE `[[dbprefix]]_team` (
  `cid` int(11) NOT NULL AUTO_INCREMENT,
  `titre` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `tag` text COLLATE latin1_general_ci NOT NULL,
  `tag2` text COLLATE latin1_general_ci NOT NULL,
  `ordre` int(5) NOT NULL DEFAULT '0',
  `game` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]_team_rank`
--

CREATE TABLE `[[dbprefix]]_team_rank` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `titre` varchar(80) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `ordre` int(5) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]_tmpses`
--

CREATE TABLE `[[dbprefix]]_tmpses` (
  `session_id` varchar(64) COLLATE latin1_general_ci NOT NULL,
  `session_vars` text COLLATE latin1_general_ci NOT NULL,
  `session_start` bigint(20) NOT NULL,
  PRIMARY KEY (`session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- Table structure for table `[[dbprefix]]_userbox`
--

CREATE TABLE `[[dbprefix]]_userbox` (
  `mid` int(50) NOT NULL AUTO_INCREMENT,
  `user_from` varchar(30) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `user_for` varchar(30) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `titre` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `message` text COLLATE latin1_general_ci NOT NULL,
  `date` varchar(30) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `status` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`mid`),
  KEY `user_from` (`user_from`),
  KEY `user_for` (`user_for`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]_users`
--

CREATE TABLE `[[dbprefix]]_users` (
  `id` varchar(20) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `team` varchar(80) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `team2` varchar(80) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `team3` varchar(80) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `rang` int(11) NOT NULL DEFAULT '0',
  `ordre` int(5) NOT NULL DEFAULT '0',
  `pseudo` text COLLATE latin1_general_ci NOT NULL,
  `mail` varchar(80) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `email` varchar(80) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `icq` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `msn` varchar(80) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `aim` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `yim` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `url` varchar(150) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `pass` varchar(80) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `niveau` int(1) NOT NULL DEFAULT '0',
  `date` varchar(30) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `avatar` varchar(100) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `signature` text COLLATE latin1_general_ci NOT NULL,
  `user_theme` varchar(30) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `user_langue` varchar(30) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `game` int(11) NOT NULL DEFAULT '0',
  `country` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `count` int(10) NOT NULL DEFAULT '0',
  `erreur` int(10) NOT NULL DEFAULT '0',
  `token` varchar(13) COLLATE latin1_general_ci DEFAULT NULL,
  `token_time` varchar(10) COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `team` (`team`),
  KEY `team2` (`team2`),
  KEY `team3` (`team3`),
  KEY `rang` (`rang`),
  KEY `game` (`game`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `[[dbprefix]]_users`
--

INSERT INTO `[[dbprefix]]_users` VALUES
('[[auteur_id]]', '', '', '', 0, 0, '[[admin_username]]', '[[admin_email]]', '', '', '', '', '', '', '[[admin_pass]]', 9, '[[timestamp]]', '', '', '', '', 1, 'France.gif', 0, 0, NULL, '0');

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

--
-- Table structure for table `[[dbprefix]]_users_detail`
--

CREATE TABLE `[[dbprefix]]_users_detail` (
  `user_id` varchar(20) COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `prenom` text COLLATE latin1_general_ci,
  `age` varchar(10) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `sexe` varchar(20) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `ville` text COLLATE latin1_general_ci,
  `photo` varchar(150) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `motherboard` text COLLATE latin1_general_ci,
  `cpu` varchar(50) COLLATE latin1_general_ci DEFAULT NULL,
  `ram` varchar(10) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `video` text COLLATE latin1_general_ci,
  `resolution` text COLLATE latin1_general_ci,
  `son` text COLLATE latin1_general_ci,
  `ecran` text COLLATE latin1_general_ci,
  `souris` text COLLATE latin1_general_ci,
  `clavier` text COLLATE latin1_general_ci,
  `connexion` text COLLATE latin1_general_ci,
  `system` text COLLATE latin1_general_ci,
  `pref_1` text COLLATE latin1_general_ci NOT NULL,
  `pref_2` text COLLATE latin1_general_ci NOT NULL,
  `pref_3` text COLLATE latin1_general_ci NOT NULL,
  `pref_4` text COLLATE latin1_general_ci NOT NULL,
  `pref_5` text COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

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

--
-- Table structure for table `[[dbprefix]]_vote`
--

CREATE TABLE `[[dbprefix]]_vote` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `module` varchar(30) COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `vid` int(100) DEFAULT NULL,
  `ip` varchar(40) COLLATE latin1_general_ci NOT NULL DEFAULT '',
  `vote` int(2) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `vid` (`vid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]_vote_modules`
--

CREATE TABLE `[[dbprefix]]_vote_modules` (
  `id` tinyint(2) unsigned NOT NULL AUTO_INCREMENT,
  `module` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `active` tinyint(1) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=5 ;

--
-- Dumping data for table `[[dbprefix]]_vote_modules`
--

INSERT INTO `[[dbprefix]]_vote_modules` VALUES
(1, 'Download', 1),
(2, 'Links', 1),
(3, 'Gallery', 1),
(4, 'Sections', 1);

/*!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 */;

Cancel