jaeSdiyC

· 10 years ago · May 08, 2016, 12:45 AM
1-- phpMyAdmin SQL Dump
2-- version 4.4.15.5
3-- http://www.phpmyadmin.net
4--
5-- Client :  sql3.cluster1.easy-hebergement.net
6-- GÃ©nÃ©rÃ© le :  Dim 08 Mai 2016 Ã  02:43
7-- Version du serveur :  5.5.49-0+deb7u1-log
8-- Version de PHP :  5.4.45
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8mb4 */;
18
19--
20-- Base de donnÃ©es :  `rustyfrance`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Structure de la table `nf_access`
27--
28
29CREATE TABLE IF NOT EXISTS `nf_access` (
30  `access_id` int(11) unsigned NOT NULL,
31  `id` int(11) unsigned NOT NULL,
32  `module` varchar(100) NOT NULL,
33  `action` varchar(100) NOT NULL
34) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8;
35
36--
37-- Contenu de la table `nf_access`
38--
39
40INSERT INTO `nf_access` (`access_id`, `id`, `module`, `action`) VALUES
41(49, 1, 'forum', 'category_announce'),
42(48, 1, 'forum', 'category_delete'),
43(50, 1, 'forum', 'category_lock'),
44(47, 1, 'forum', 'category_modify'),
45(51, 1, 'forum', 'category_move'),
46(45, 1, 'forum', 'category_read'),
47(46, 1, 'forum', 'category_write'),
48(44, 4, 'talks', 'delete'),
49(42, 4, 'talks', 'read'),
50(43, 4, 'talks', 'write'),
51(63, 5, 'forum', 'category_announce'),
52(62, 5, 'forum', 'category_delete'),
53(64, 5, 'forum', 'category_lock'),
54(61, 5, 'forum', 'category_modify'),
55(65, 5, 'forum', 'category_move'),
56(59, 5, 'forum', 'category_read'),
57(60, 5, 'forum', 'category_write'),
58(70, 6, 'forum', 'category_announce'),
59(69, 6, 'forum', 'category_delete'),
60(71, 6, 'forum', 'category_lock'),
61(68, 6, 'forum', 'category_modify'),
62(72, 6, 'forum', 'category_move'),
63(66, 6, 'forum', 'category_read'),
64(67, 6, 'forum', 'category_write'),
65(77, 7, 'forum', 'category_announce'),
66(76, 7, 'forum', 'category_delete'),
67(78, 7, 'forum', 'category_lock'),
68(75, 7, 'forum', 'category_modify'),
69(79, 7, 'forum', 'category_move'),
70(73, 7, 'forum', 'category_read'),
71(74, 7, 'forum', 'category_write'),
72(84, 8, 'forum', 'category_announce'),
73(83, 8, 'forum', 'category_delete'),
74(85, 8, 'forum', 'category_lock'),
75(82, 8, 'forum', 'category_modify'),
76(86, 8, 'forum', 'category_move'),
77(80, 8, 'forum', 'category_read'),
78(81, 8, 'forum', 'category_write');
79
80-- --------------------------------------------------------
81
82--
83-- Structure de la table `nf_access_details`
84--
85
86CREATE TABLE IF NOT EXISTS `nf_access_details` (
87  `access_id` int(11) unsigned NOT NULL,
88  `entity` varchar(100) NOT NULL,
89  `type` enum('group','user') NOT NULL DEFAULT 'group',
90  `authorized` enum('0','1') NOT NULL DEFAULT '0'
91) ENGINE=InnoDB DEFAULT CHARSET=utf8;
92
93--
94-- Contenu de la table `nf_access_details`
95--
96
97INSERT INTO `nf_access_details` (`access_id`, `entity`, `type`, `authorized`) VALUES
98(42, 'visitors', 'group', '0'),
99(43, 'visitors', 'group', '0'),
100(44, '6', 'group', '1'),
101(44, 'admins', 'group', '1'),
102(46, 'visitors', 'group', '0'),
103(47, '6', 'group', '1'),
104(47, 'admins', 'group', '1'),
105(48, 'admins', 'group', '1'),
106(49, 'admins', 'group', '1'),
107(50, '6', 'group', '1'),
108(50, 'admins', 'group', '1'),
109(51, '6', 'group', '1'),
110(51, 'admins', 'group', '1'),
111(60, 'visitors', 'group', '0'),
112(61, '6', 'group', '1'),
113(61, 'admins', 'group', '1'),
114(62, 'admins', 'group', '1'),
115(63, 'admins', 'group', '1'),
116(64, '6', 'group', '1'),
117(64, 'admins', 'group', '1'),
118(65, '6', 'group', '1'),
119(65, 'admins', 'group', '1'),
120(67, 'visitors', 'group', '0'),
121(68, '6', 'group', '1'),
122(68, 'admins', 'group', '1'),
123(69, 'admins', 'group', '1'),
124(70, 'admins', 'group', '1'),
125(71, '6', 'group', '1'),
126(71, 'admins', 'group', '1'),
127(72, '6', 'group', '1'),
128(72, 'admins', 'group', '1'),
129(74, 'visitors', 'group', '0'),
130(75, '6', 'group', '1'),
131(75, 'admins', 'group', '1'),
132(76, 'admins', 'group', '1'),
133(77, 'admins', 'group', '1'),
134(78, '6', 'group', '1'),
135(78, 'admins', 'group', '1'),
136(79, '6', 'group', '1'),
137(79, 'admins', 'group', '1'),
138(81, 'visitors', 'group', '0'),
139(82, '6', 'group', '1'),
140(82, 'admins', 'group', '1'),
141(83, 'admins', 'group', '1'),
142(84, 'admins', 'group', '1'),
143(85, '6', 'group', '1'),
144(85, 'admins', 'group', '1'),
145(86, '6', 'group', '1'),
146(86, 'admins', 'group', '1');
147
148-- --------------------------------------------------------
149
150--
151-- Structure de la table `nf_comments`
152--
153
154CREATE TABLE IF NOT EXISTS `nf_comments` (
155  `comment_id` int(11) unsigned NOT NULL,
156  `parent_id` int(11) unsigned DEFAULT NULL,
157  `user_id` int(11) unsigned NOT NULL,
158  `module_id` int(11) unsigned NOT NULL,
159  `module` varchar(100) NOT NULL,
160  `content` text,
161  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
162) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
163
164--
165-- Contenu de la table `nf_comments`
166--
167
168INSERT INTO `nf_comments` (`comment_id`, `parent_id`, `user_id`, `module_id`, `module`, `content`, `date`) VALUES
169(1, NULL, 4, 2, 'news', 'Oh ouiiiiiiiiii Battlefield', '2016-05-02 15:59:58');
170
171-- --------------------------------------------------------
172
173--
174-- Structure de la table `nf_crawlers`
175--
176
177CREATE TABLE IF NOT EXISTS `nf_crawlers` (
178  `name` varchar(100) NOT NULL,
179  `path` varchar(100) NOT NULL,
180  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
181) ENGINE=InnoDB DEFAULT CHARSET=utf8;
182
183--
184-- Contenu de la table `nf_crawlers`
185--
186
187INSERT INTO `nf_crawlers` (`name`, `path`, `date`) VALUES
188('facebookexternalhit', 'index.html', '2016-05-02 09:52:20'),
189('facebookexternalhit', 'index.html', '2016-05-02 09:52:26'),
190('facebookexternalhit', 'index.html', '2016-05-02 09:52:27'),
191('facebookexternalhit', 'index.html', '2016-05-02 09:52:27'),
192('facebookexternalhit', 'index.html', '2016-05-02 09:52:28'),
193('curl', 'index.html', '2016-05-04 01:58:08'),
194('NetSeer crawler', 'index.html', '2016-05-04 17:42:41'),
195('Googlebot', 'index.html', '2016-05-04 19:28:37'),
196('Googlebot', 'index.html', '2016-05-04 20:13:05'),
197('Yahoo! Slurp', 'index.html', '2016-05-05 02:19:23'),
198('Googlebot', 'index.html', '2016-05-05 07:45:53'),
199('Googlebot', 'news/category/1/actualites-du-site.html', '2016-05-05 07:49:27'),
200('Googlebot', 'members/1/fouzii.html', '2016-05-05 07:49:39'),
201('Googlebot', 'user.html', '2016-05-05 07:51:00'),
202('Googlebot', 'user/lost-password.html', '2016-05-05 07:52:39'),
203('Googlebot', 'index.html', '2016-05-05 07:55:03'),
204('Googlebot', 'members/group/teams-1/rust.html', '2016-05-05 07:58:03'),
205('Googlebot', 'contact.html', '2016-05-05 12:35:57'),
206('Googlebot', 'gallery/image/2/bolt-action-rifle-iconpng.html', '2016-05-05 12:42:41'),
207('bingbot', 'index.html', '2016-05-05 13:20:07'),
208('Googlebot', 'news/category/1/actualites-du-site.html', '2016-05-06 04:12:20'),
209('Googlebot', 'news/category/2/actualites-du-serveur.html', '2016-05-06 05:53:35'),
210('Googlebot', 'gallery/image/22/supply-signal-iconpng.html', '2016-05-06 06:23:22'),
211('Googlebot', 'news/category/2/actualites-du-serveur.html', '2016-05-06 07:49:35'),
212('Googlebot', 'gallery/image/16/stone-pick-axe-icon-1png.html', '2016-05-06 08:13:51'),
213('Googlebot', 'gallery/album/1/set-icones.html', '2016-05-06 08:14:33'),
214('Googlebot', 'forum.html', '2016-05-06 08:28:24'),
215('Googlebot', 'gallery/image/8/hatchet-iconpng.html', '2016-05-06 08:42:18'),
216('Googlebot', 'gallery/album/1/set-icones.html', '2016-05-06 08:55:22'),
217('Googlebot', 'members.html', '2016-05-06 08:56:15'),
218('Googlebot', 'members/page/3/10.html', '2016-05-06 09:38:20'),
219('Googlebot', 'members/1/fouzii.html', '2016-05-06 15:24:28'),
220('Googlebot', 'news/tag/siteweb.html', '2016-05-06 15:31:04'),
221('Googlebot', 'news/tag/siteweb.html', '2016-05-06 16:59:58'),
222('Googlebot', 'user/lost-password.html', '2016-05-06 17:29:47'),
223('Googlebot', 'index.html', '2016-05-06 17:33:31'),
224('Googlebot', 'members/3/virus-gamers.html', '2016-05-06 19:05:44'),
225('Googlebot', 'index.html', '2016-05-06 19:07:47'),
226('Googlebot', 'gallery/image/7/bone-club-iconpng.html', '2016-05-06 19:14:01'),
227('Googlebot', 'forum/1/discussions-generales.html', '2016-05-06 19:34:02'),
228('Googlebot', 'news.html', '2016-05-06 19:37:58'),
229('Googlebot', 'gallery/image/13/deer-skull-iconpng.html', '2016-05-06 19:42:16'),
230('Googlebot', 'news/category/2/actualites-du-serveur.html', '2016-05-06 19:50:30'),
231('Googlebot', 'forum/topic/16/quest-ce-que-le-grief.html', '2016-05-06 21:20:59'),
232('Googlebot', 'forum/34/jeux-video.html', '2016-05-06 21:22:25'),
233('Googlebot', 'members/page/2/10.html', '2016-05-06 21:23:03'),
234('Googlebot', 'members/18/hytek.html', '2016-05-06 21:34:05'),
235('Googlebot', 'forum/topic/13/map-du-0505.html', '2016-05-06 22:21:58'),
236('bingbot', 'index.html', '2016-05-06 22:28:24'),
237('Googlebot', 'forum/topic/2/reglement-du-forum.html', '2016-05-06 22:43:51'),
238('Googlebot', 'members/4/hocine.html', '2016-05-06 22:44:04'),
239('Googlebot', 'forum/32/coin-pc.html', '2016-05-06 22:57:04'),
240('Googlebot', 'index.html', '2016-05-06 23:00:01'),
241('Googlebot', 'news/category/1/actualites-du-site.html', '2016-05-06 23:17:56'),
242('Googlebot', 'members/12/choka.html', '2016-05-06 23:45:49'),
243('Googlebot', 'news/category/1/actualites-du-site.html', '2016-05-06 23:49:51'),
244('Googlebot', 'members/10/everbbq.html', '2016-05-06 23:59:54'),
245('Googlebot', 'forum/topic/15/rejoindre-le-teamspeak.html', '2016-05-07 00:09:39'),
246('Googlebot', 'forum/topic/3/a-propos-des-presentations.html', '2016-05-07 00:40:09'),
247('Googlebot', 'members/21/davidrise.html', '2016-05-07 00:48:19'),
248('Googlebot', 'forum/topic/14/signaler-un-crash-serveur.html', '2016-05-07 01:06:12'),
249('Googlebot', 'forum/7/presentation.html', '2016-05-07 01:16:23'),
250('Googlebot', 'members.html', '2016-05-07 01:23:19'),
251('Googlebot', 'forum/62/plaintedeban.html', '2016-05-07 01:47:35'),
252('Googlebot', 'index.html', '2016-05-07 02:13:42'),
253('Googlebot', 'gallery/image/13/deer-skull-iconpng.html', '2016-05-07 02:23:09'),
254('Googlebot', 'user/lost-password.html', '2016-05-07 03:09:16'),
255('Googlebot', 'gallery/image/22/supply-signal-iconpng.html', '2016-05-07 04:46:00'),
256('Googlebot', 'forum/61/plaintedeban.html', '2016-05-07 05:04:32'),
257('Googlebot', 'gallery/image/16/stone-pick-axe-icon-1png.html', '2016-05-07 05:10:32'),
258('Googlebot', 'members/25/evilsensei.html', '2016-05-07 05:35:44'),
259('Googlebot', 'teams.html', '2016-05-07 06:00:47'),
260('Googlebot', 'user.html', '2016-05-07 06:01:05'),
261('Googlebot', 'forum/5/information-reglement.html', '2016-05-07 06:01:09'),
262('Googlebot', 'teams/1/rust.html', '2016-05-07 06:07:56'),
263('Googlebot', 'forum/50/infos-serveur.html', '2016-05-07 06:26:20'),
264('Googlebot', 'members/group/teams-1/rust.html', '2016-05-07 07:27:05'),
265('Googlebot', 'mentions-legales.html', '2016-05-07 07:38:09'),
266('Googlebot', 'gallery/image/8/hatchet-iconpng.html', '2016-05-07 07:42:05'),
267('Googlebot', 'gallery/image/6/bone-knife-iconpng.html', '2016-05-07 07:54:53'),
268('Googlebot', 'members/9/lesreglesfdp.html', '2016-05-07 07:58:29'),
269('Googlebot', 'members/5/blasteur9600.html', '2016-05-07 08:09:54'),
270('Googlebot', 'gallery/image/3/flame-thrower-iconpng.html', '2016-05-07 08:16:35'),
271('Googlebot', 'forum/51/infos-serveur.html', '2016-05-07 08:35:11'),
272('Googlebot', 'gallery/image/15/pookie-bear-iconpng.html', '2016-05-07 09:47:17'),
273('Googlebot', 'news/2/ouverture-prochaine-rustyfrance-battlefield.html', '2016-05-07 10:32:04'),
274('Googlebot', 'news/1/bienvenue-sur-notre-nouveau-site-rustyfrance.html', '2016-05-07 11:06:44'),
275('Googlebot', 'news/tag/siteweb.html', '2016-05-07 11:15:32'),
276('Googlebot', 'forum/34/jeux-video.html', '2016-05-07 11:52:14'),
277('Googlebot', 'user/lost-password.html', '2016-05-07 12:01:17'),
278('Googlebot', 'forum/topic/16/quest-ce-que-le-grief.html', '2016-05-07 12:35:22'),
279('Googlebot', 'forum/32/coin-pc.html', '2016-05-07 12:47:38'),
280('Googlebot', 'members/3/virus-gamers.html', '2016-05-07 13:19:02'),
281('Googlebot', 'forum/7/presentation.html', '2016-05-07 14:57:16'),
282('Googlebot', 'forum/20/rapport-de-bug.html', '2016-05-07 15:51:19'),
283('Googlebot', 'index.html', '2016-05-07 16:30:04'),
284('Googlebot', 'index.html', '2016-05-07 16:51:52'),
285('Googlebot', 'gallery/image/6/bone-knife-iconpng.html', '2016-05-07 17:13:15'),
286('Googlebot', 'forum/58/rapporter-un-bug.html', '2016-05-07 17:46:52'),
287('Googlebot', 'forum/topic/2/reglement-du-forum.html', '2016-05-07 17:47:50'),
288('Googlebot', 'index.html', '2016-05-07 20:59:58'),
289('Googlebot', 'forum/61/plaintedeban.html', '2016-05-07 21:05:21'),
290('Googlebot', 'teams.html', '2016-05-07 22:01:53'),
291('Googlebot', 'mentions-legales.html', '2016-05-07 22:32:17'),
292('Googlebot', 'forum/51/infos-serveur.html', '2016-05-07 22:32:36'),
293('Googlebot', 'forum/topic/3/a-propos-des-presentations.html', '2016-05-07 22:34:40'),
294('Googlebot', 'members/1/fouzii.html', '2016-05-07 23:16:08'),
295('Googlebot', 'forum/topic/14/signaler-un-crash-serveur.html', '2016-05-07 23:31:02'),
296('Googlebot', 'forum/50/infos-serveur.html', '2016-05-07 23:32:26'),
297('Googlebot', 'members/15/florentincraft.html', '2016-05-08 00:05:45');
298
299-- --------------------------------------------------------
300
301--
302-- Structure de la table `nf_dispositions`
303--
304
305CREATE TABLE IF NOT EXISTS `nf_dispositions` (
306  `disposition_id` int(11) unsigned NOT NULL,
307  `theme` varchar(100) NOT NULL,
308  `page` varchar(100) NOT NULL,
309  `zone` int(11) unsigned NOT NULL,
310  `disposition` text NOT NULL
311) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;
312
313--
314-- Contenu de la table `nf_dispositions`
315--
316
317INSERT INTO `nf_dispositions` (`disposition_id`, `theme`, `page`, `zone`, `disposition`) VALUES
318(12, 'default', '*', 0, 'a:1:{i:1;O:3:"Row":2:{s:5:"style";s:9:"row-light";s:4:"cols";a:2:{i:0;O:3:"Col":2:{s:10:"\0Col\0_size";s:8:"col-md-8";s:7:"widgets";a:1:{i:0;O:11:"Widget_View":1:{s:9:"widget_id";i:53;}}}i:1;O:3:"Col":2:{s:10:"\0Col\0_size";s:8:"col-md-4";s:7:"widgets";a:3:{i:1;O:11:"Widget_View":1:{s:9:"widget_id";i:101;}i:2;O:11:"Widget_View":1:{s:9:"widget_id";i:102;}i:3;O:11:"Widget_View":1:{s:9:"widget_id";i:155;}}}}}}'),
319(13, 'default', '*', 1, 'a:1:{i:0;O:3:"Row":2:{s:5:"style";s:9:"row-white";s:4:"cols";a:1:{i:0;O:3:"Col":2:{s:10:"\0Col\0_size";s:9:"col-md-12";s:7:"widgets";a:1:{i:0;O:11:"Widget_View":1:{s:9:"widget_id";i:133;}}}}}}'),
320(14, 'default', '*', 2, 'a:1:{i:0;O:3:"Row":2:{s:5:"style";s:8:"row-dark";s:4:"cols";a:3:{i:3;O:3:"Col":2:{s:10:"\0Col\0_size";s:8:"col-md-4";s:7:"widgets";a:1:{i:3;O:11:"Widget_View":1:{s:9:"widget_id";i:157;}}}i:2;O:3:"Col":2:{s:10:"\0Col\0_size";s:8:"col-md-4";s:7:"widgets";a:1:{i:0;O:11:"Widget_View":1:{s:9:"widget_id";i:149;}}}i:1;O:3:"Col":2:{s:10:"\0Col\0_size";s:8:"col-md-4";s:7:"widgets";a:1:{i:0;O:11:"Widget_View":1:{s:9:"widget_id";i:148;}}}}}}'),
321(15, 'default', '*', 3, 'a:2:{i:0;O:3:"Row":2:{s:5:"style";s:11:"row-default";s:4:"cols";a:1:{i:0;O:3:"Col":2:{s:10:"\0Col\0_size";s:9:"col-md-12";s:7:"widgets";a:1:{i:0;O:11:"Widget_View":1:{s:9:"widget_id";i:61;}}}}}i:1;O:3:"Row":2:{s:5:"style";s:9:"row-light";s:4:"cols";a:2:{i:0;O:3:"Col":2:{s:10:"\0Col\0_size";s:8:"col-md-8";s:7:"widgets";a:1:{i:0;O:11:"Widget_View":1:{s:9:"widget_id";i:62;}}}i:1;O:3:"Col":2:{s:10:"\0Col\0_size";s:8:"col-md-4";s:7:"widgets";a:1:{i:0;O:11:"Widget_View":1:{s:9:"widget_id";i:63;}}}}}}'),
322(16, 'default', '*', 4, 'a:1:{i:0;O:3:"Row":2:{s:5:"style";s:11:"row-default";s:4:"cols";a:2:{i:0;O:3:"Col":2:{s:10:"\0Col\0_size";s:8:"col-md-8";s:7:"widgets";a:1:{i:0;O:11:"Widget_View":1:{s:9:"widget_id";i:64;}}}i:1;O:3:"Col":2:{s:10:"\0Col\0_size";s:8:"col-md-4";s:7:"widgets";a:1:{i:0;O:11:"Widget_View":1:{s:9:"widget_id";i:65;}}}}}}'),
323(17, 'default', '*', 5, 'a:1:{i:0;O:3:"Row":2:{s:5:"style";s:11:"row-default";s:4:"cols";a:1:{i:0;O:3:"Col":2:{s:10:"\0Col\0_size";s:9:"col-md-12";s:7:"widgets";a:1:{i:0;O:11:"Widget_View":2:{s:9:"widget_id";i:66;s:5:"style";s:10:"panel-dark";}}}}}}'),
324(18, 'default', '/', 3, 'a:3:{i:0;O:3:"Row":2:{s:5:"style";s:11:"row-default";s:4:"cols";a:1:{i:0;O:3:"Col":2:{s:10:"\0Col\0_size";s:9:"col-md-12";s:7:"widgets";a:1:{i:0;O:11:"Widget_View":1:{s:9:"widget_id";i:67;}}}}}i:1;O:3:"Row":2:{s:5:"style";s:9:"row-light";s:4:"cols";a:2:{i:0;O:3:"Col":2:{s:10:"\0Col\0_size";s:8:"col-md-8";s:7:"widgets";a:1:{i:0;O:11:"Widget_View":1:{s:9:"widget_id";i:68;}}}i:1;O:3:"Col":2:{s:10:"\0Col\0_size";s:8:"col-md-4";s:7:"widgets";a:1:{i:0;O:11:"Widget_View":1:{s:9:"widget_id";i:69;}}}}}i:2;O:3:"Row":2:{s:5:"style";s:11:"row-default";s:4:"cols";a:1:{i:0;O:3:"Col":2:{s:10:"\0Col\0_size";s:9:"col-md-12";s:7:"widgets";a:1:{i:0;O:11:"Widget_View":1:{s:9:"widget_id";i:70;}}}}}}'),
325(19, 'default', 'forum/*', 0, 'a:2:{i:0;O:3:"Row":2:{s:5:"style";s:9:"row-light";s:4:"cols";a:1:{i:1;O:3:"Col":2:{s:10:"\0Col\0_size";s:9:"col-md-12";s:7:"widgets";a:1:{i:0;O:11:"Widget_View":2:{s:9:"widget_id";i:90;s:5:"style";s:13:"panel-default";}}}}}i:1;O:3:"Row":2:{s:5:"style";s:9:"row-light";s:4:"cols";a:1:{i:0;O:3:"Col":2:{s:10:"\0Col\0_size";s:9:"col-md-12";s:7:"widgets";a:1:{i:0;O:11:"Widget_View":1:{s:9:"widget_id";i:72;}}}}}}'),
326(20, 'default', 'forum/*', 2, 'a:1:{i:0;O:3:"Row":2:{s:5:"style";s:9:"row-light";s:4:"cols";a:2:{i:0;O:3:"Col":2:{s:10:"\0Col\0_size";s:8:"col-md-4";s:7:"widgets";a:1:{i:0;O:11:"Widget_View":2:{s:9:"widget_id";i:77;s:5:"style";s:9:"panel-red";}}}i:1;O:3:"Col":2:{s:10:"\0Col\0_size";s:8:"col-md-8";s:7:"widgets";a:1:{i:0;O:11:"Widget_View":2:{s:9:"widget_id";i:78;s:5:"style";s:10:"panel-dark";}}}}}}'),
327(21, 'default', 'news/_news/*', 0, 'a:1:{i:1;O:3:"Row":2:{s:5:"style";s:9:"row-light";s:4:"cols";a:1:{i:0;O:3:"Col":2:{s:10:"\0Col\0_size";s:9:"col-md-12";s:7:"widgets";a:1:{i:0;O:11:"Widget_View":1:{s:9:"widget_id";i:74;}}}}}}'),
328(23, 'default', 'rust-io/*', 0, 'a:1:{i:1;O:3:"Row":2:{s:5:"style";s:9:"row-light";s:4:"cols";a:2:{i:0;O:3:"Col":2:{s:10:"\0Col\0_size";s:8:"col-md-9";s:7:"widgets";a:1:{i:0;O:11:"Widget_View":1:{s:9:"widget_id";i:95;}}}i:1;O:3:"Col":2:{s:10:"\0Col\0_size";s:8:"col-md-3";s:7:"widgets";a:3:{i:2;O:11:"Widget_View":2:{s:9:"widget_id";i:96;s:5:"style";s:13:"panel-default";}i:1;O:11:"Widget_View":2:{s:9:"widget_id";i:97;s:5:"style";s:13:"panel-default";}i:0;O:11:"Widget_View":2:{s:9:"widget_id";i:98;s:5:"style";s:13:"panel-default";}}}}}}'),
329(29, 'default', 'contact/*', 0, 'a:1:{i:1;O:3:"Row":2:{s:5:"style";s:9:"row-light";s:4:"cols";a:2:{i:0;O:3:"Col":2:{s:10:"\0Col\0_size";s:8:"col-md-8";s:7:"widgets";a:2:{i:1;O:11:"Widget_View":1:{s:9:"widget_id";i:123;}i:0;O:11:"Widget_View":1:{s:9:"widget_id";i:119;}}}i:1;O:3:"Col":2:{s:10:"\0Col\0_size";s:8:"col-md-4";s:7:"widgets";a:2:{i:0;O:11:"Widget_View":1:{s:9:"widget_id";i:124;}i:2;O:11:"Widget_View":1:{s:9:"widget_id";i:126;}}}}}}'),
330(31, 'default', 'useredit/*', 0, 'a:2:{i:0;O:3:"Row":2:{s:5:"style";s:9:"row-white";s:4:"cols";a:1:{i:0;O:3:"Col":2:{s:10:"\0Col\0_size";s:9:"col-md-12";s:7:"widgets";a:1:{i:0;O:11:"Widget_View":1:{s:9:"widget_id";i:131;}}}}}i:1;O:3:"Row":2:{s:5:"style";s:9:"row-light";s:4:"cols";a:1:{i:0;O:3:"Col":2:{s:10:"\0Col\0_size";s:9:"col-md-12";s:7:"widgets";a:1:{i:0;O:11:"Widget_View":1:{s:9:"widget_id";i:132;}}}}}}');
331
332-- --------------------------------------------------------
333
334--
335-- Structure de la table `nf_donation_config`
336--
337
338CREATE TABLE IF NOT EXISTS `nf_donation_config` (
339  `title` text NOT NULL,
340  `paypalemail` text NOT NULL,
341  `imglink` text NOT NULL,
342  `objectif` int(11) NOT NULL,
343  `message` text NOT NULL,
344  `total` varchar(11) NOT NULL DEFAULT '0'
345) ENGINE=InnoDB DEFAULT CHARSET=latin1;
346
347--
348-- Contenu de la table `nf_donation_config`
349--
350
351INSERT INTO `nf_donation_config` (`title`, `paypalemail`, `imglink`, `objectif`, `message`, `total`) VALUES
352('Rusty''Donation', 'email@mon-email.fr', 'http://dummyimage.com/240x100/006a78/1d98eb&amp;text=votre+image+en+240+x+100', 50, 'Merci', '1');
353
354-- --------------------------------------------------------
355
356--
357-- Structure de la table `nf_files`
358--
359
360CREATE TABLE IF NOT EXISTS `nf_files` (
361  `file_id` int(11) unsigned NOT NULL,
362  `user_id` int(10) unsigned DEFAULT NULL,
363  `name` varchar(100) NOT NULL,
364  `path` varchar(100) NOT NULL,
365  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
366) ENGINE=InnoDB AUTO_INCREMENT=94 DEFAULT CHARSET=utf8;
367
368--
369-- Contenu de la table `nf_files`
370--
371
372INSERT INTO `nf_files` (`file_id`, `user_id`, `name`, `path`, `date`) VALUES
373(2, 1, 'photo.jpg.png', './upload/members/7drgm9b4yzypil7tpoligvbedu7sneyz.png', '2016-04-28 23:49:46'),
374(5, 3, 'rust (1).png', './upload/games/icons/zoygrfdj9ys40bkvlbdzoppfedfojias.png', '2016-04-30 11:10:24'),
375(9, 3, 'rust (1).png', './upload/teams/icons/4weezwbbzxgdovwsquijo3be4gdhyr7n.png', '2016-04-30 11:12:23'),
376(10, 3, 'rust_dark_skinned.0.jpg', './upload/teams/icvoqtr6utfvhaogolick9ba1ggju5bn.jpg', '2016-04-30 11:40:16'),
377(14, 3, '0a85b4e7a8d1969b3f513bba33fe22b0c2598e51.jpg', './upload/maintenance/bkf6i0mouqvpwtujbiwxsbpoghrqlsy5.jpg', '2016-04-30 12:40:19'),
378(18, 3, 'U8721VM9p9C2v1o6cKJ4qEnGqnE7IoTQgZI-VTdwyTBeimAcIoxXpgK8bPeslY9pPJIvB5IWW2-452kaM8heLSRgleGBo7dNyO94', './upload/themes/default/backgrounds/tol1usdwwskecmh0xijyjce1ehoj4vw6.jpg', '2016-04-30 15:24:39'),
379(19, 3, 'lopdua7bc7c.png', './upload/maintenance/pige0rpzbfsyyyfx2jve379f80giytre.png', '2016-04-30 18:28:08'),
380(20, 3, 'Pookie_Bear_icon.png', './upload/news/categories/x2fwbc0mwxhsh6jzmrne3qzdbvxfzbtz.png', '2016-05-01 19:11:48'),
381(22, 3, '994383334.png', './upload/members/m9xj8ksndd491jhmiwo6ngvc2b1fpysy.png', '2016-05-01 18:04:04'),
382(23, 3, 'ubfuejdfooirqya0pyltfeklja4ew4sn.jpg', './upload/news/categories/wann7gyyq7fonshdpvhwx3dsxycefubj.jpg', '2016-05-01 19:05:12'),
383(24, 3, 'newsserveur.jpg', './upload/news/categories/blfxygfxpgwu8wnr4cljulxgb5uvhize.jpg', '2016-05-01 19:12:28'),
384(25, 3, 'High_Quality_Metal_icon.png', './upload/news/categories/gdvc9mgv2hgicm49whkt4pcskyo8l0z6.png', '2016-05-01 19:12:28'),
385(26, 3, 'Acoustic_Guitar_icon.png', './upload/gallery/hklx9gkbuki6soxaylfwi1kxqqyeqxh0.png', '2016-05-01 21:33:57'),
386(27, 3, 'Acoustic_Guitar_icon.png', './upload/gallery/thumbnails/hklx9gkbuki6soxaylfwi1kxqqyeqxh0.png', '2016-05-01 21:33:57'),
387(28, 3, 'Acoustic_Guitar_icon.png', './upload/gallery/originals/hklx9gkbuki6soxaylfwi1kxqqyeqxh0.png', '2016-05-01 21:33:57'),
388(29, 3, 'Bolt_Action_Rifle_icon.png', './upload/gallery/dgogtdi3mdep6zgpmcgy5llp2cv0y4zm.png', '2016-05-01 21:33:59'),
389(30, 3, 'Bolt_Action_Rifle_icon.png', './upload/gallery/thumbnails/dgogtdi3mdep6zgpmcgy5llp2cv0y4zm.png', '2016-05-01 21:33:59'),
390(31, 3, 'Bolt_Action_Rifle_icon.png', './upload/gallery/originals/dgogtdi3mdep6zgpmcgy5llp2cv0y4zm.png', '2016-05-01 21:33:59'),
391(32, 3, 'Flame_Thrower_icon.png', './upload/gallery/uelja7rvb5nyycszk4o2xwsmmm56ukdu.png', '2016-05-01 21:33:59'),
392(33, 3, 'Flame_Thrower_icon.png', './upload/gallery/thumbnails/uelja7rvb5nyycszk4o2xwsmmm56ukdu.png', '2016-05-01 21:33:59'),
393(34, 3, 'Flame_Thrower_icon.png', './upload/gallery/originals/uelja7rvb5nyycszk4o2xwsmmm56ukdu.png', '2016-05-01 21:33:59'),
394(35, 3, 'High_Quality_Metal_icon.png', './upload/gallery/fjyi0v9nems5emjqoxwq5527v8nijrx2.png', '2016-05-01 21:34:00'),
395(36, 3, 'High_Quality_Metal_icon.png', './upload/gallery/thumbnails/fjyi0v9nems5emjqoxwq5527v8nijrx2.png', '2016-05-01 21:34:00'),
396(37, 3, 'High_Quality_Metal_icon.png', './upload/gallery/originals/fjyi0v9nems5emjqoxwq5527v8nijrx2.png', '2016-05-01 21:34:00'),
397(38, 3, 'Assault_Rifle_icon.png', './upload/gallery/euoydr8ek0jx3vinx4eyqr9uyv5shgnh.png', '2016-05-01 21:34:00'),
398(39, 3, 'Assault_Rifle_icon.png', './upload/gallery/thumbnails/euoydr8ek0jx3vinx4eyqr9uyv5shgnh.png', '2016-05-01 21:34:00'),
399(40, 3, 'Assault_Rifle_icon.png', './upload/gallery/originals/euoydr8ek0jx3vinx4eyqr9uyv5shgnh.png', '2016-05-01 21:34:00'),
400(41, 3, 'Bone_Club_icon.png', './upload/gallery/wdjlg4lrwe2qfv8zc07fajiyjfaomudi.png', '2016-05-01 21:34:00'),
401(42, 3, 'Bone_Knife_icon.png', './upload/gallery/lpokmnndgwjuqiaz7f7lhi6zsy0umiqy.png', '2016-05-01 21:34:00'),
402(43, 3, 'Bone_Club_icon.png', './upload/gallery/thumbnails/wdjlg4lrwe2qfv8zc07fajiyjfaomudi.png', '2016-05-01 21:34:00'),
403(44, 3, 'Bone_Knife_icon.png', './upload/gallery/thumbnails/lpokmnndgwjuqiaz7f7lhi6zsy0umiqy.png', '2016-05-01 21:34:00'),
404(45, 3, 'Bone_Club_icon.png', './upload/gallery/originals/wdjlg4lrwe2qfv8zc07fajiyjfaomudi.png', '2016-05-01 21:34:00'),
405(46, 3, 'Bone_Knife_icon.png', './upload/gallery/originals/lpokmnndgwjuqiaz7f7lhi6zsy0umiqy.png', '2016-05-01 21:34:00'),
406(47, 3, 'Hatchet_icon.png', './upload/gallery/erazl9fbqpzdl8szkwlxbtwpessdox39.png', '2016-05-01 21:34:01'),
407(48, 3, 'Hatchet_icon.png', './upload/gallery/thumbnails/erazl9fbqpzdl8szkwlxbtwpessdox39.png', '2016-05-01 21:34:01'),
408(49, 3, 'Hatchet_icon.png', './upload/gallery/originals/erazl9fbqpzdl8szkwlxbtwpessdox39.png', '2016-05-01 21:34:01'),
409(50, 3, 'Metal_Barricade_icon.png', './upload/gallery/wnamvrr7eqhdt0gwfcdgetbdplpa1oy9.png', '2016-05-01 21:34:02'),
410(51, 3, 'Metal_Barricade_icon.png', './upload/gallery/thumbnails/wnamvrr7eqhdt0gwfcdgetbdplpa1oy9.png', '2016-05-01 21:34:02'),
411(52, 3, 'Metal_Barricade_icon.png', './upload/gallery/originals/wnamvrr7eqhdt0gwfcdgetbdplpa1oy9.png', '2016-05-01 21:34:02'),
412(53, 3, 'Pick_Axe_icon.png', './upload/gallery/cxdqohmtfhsnbsjesvxbz09eshfzencg.png', '2016-05-01 21:34:02'),
413(54, 3, 'Pick_Axe_icon.png', './upload/gallery/thumbnails/cxdqohmtfhsnbsjesvxbz09eshfzencg.png', '2016-05-01 21:34:02'),
414(55, 3, 'Pick_Axe_icon.png', './upload/gallery/originals/cxdqohmtfhsnbsjesvxbz09eshfzencg.png', '2016-05-01 21:34:02'),
415(56, 3, 'Revolver_icon.png', './upload/gallery/unwn23bnlyroafz3o1ilivqa6dafbdue.png', '2016-05-01 21:34:02'),
416(57, 3, 'Revolver_icon.png', './upload/gallery/thumbnails/unwn23bnlyroafz3o1ilivqa6dafbdue.png', '2016-05-01 21:34:02'),
417(58, 3, 'Revolver_icon.png', './upload/gallery/originals/unwn23bnlyroafz3o1ilivqa6dafbdue.png', '2016-05-01 21:34:02'),
418(59, 3, 'Stone_Hatchet_icon.png', './upload/gallery/uweefzsynbawaiw1xjmhykwww7b4r9nz.png', '2016-05-01 21:34:05'),
419(60, 3, 'Stone_Hatchet_icon.png', './upload/gallery/thumbnails/uweefzsynbawaiw1xjmhykwww7b4r9nz.png', '2016-05-01 21:34:05'),
420(61, 3, 'Stone_Hatchet_icon.png', './upload/gallery/originals/uweefzsynbawaiw1xjmhykwww7b4r9nz.png', '2016-05-01 21:34:05'),
421(62, 3, 'Deer_Skull_icon.png', './upload/gallery/8w1rcv0vs2mjnjmbzpwttxaerxbvejxs.png', '2016-05-01 21:34:05'),
422(63, 3, 'Deer_Skull_icon.png', './upload/gallery/thumbnails/8w1rcv0vs2mjnjmbzpwttxaerxbvejxs.png', '2016-05-01 21:34:05'),
423(64, 3, 'Deer_Skull_icon.png', './upload/gallery/originals/8w1rcv0vs2mjnjmbzpwttxaerxbvejxs.png', '2016-05-01 21:34:05'),
424(65, 3, 'Thompson_icon.png', './upload/gallery/tcpz8hz9jqoacqqdamizkgfimp9mknpw.png', '2016-05-01 21:34:06'),
425(66, 3, 'Thompson_icon.png', './upload/gallery/thumbnails/tcpz8hz9jqoacqqdamizkgfimp9mknpw.png', '2016-05-01 21:34:06'),
426(67, 3, 'Thompson_icon.png', './upload/gallery/originals/tcpz8hz9jqoacqqdamizkgfimp9mknpw.png', '2016-05-01 21:34:06'),
427(68, 3, 'Pookie_Bear_icon.png', './upload/gallery/vfiimfiabm0wydc1mqzneytrhjuuj6iw.png', '2016-05-01 21:34:07'),
428(69, 3, 'Pookie_Bear_icon.png', './upload/gallery/thumbnails/vfiimfiabm0wydc1mqzneytrhjuuj6iw.png', '2016-05-01 21:34:07'),
429(70, 3, 'Pookie_Bear_icon.png', './upload/gallery/originals/vfiimfiabm0wydc1mqzneytrhjuuj6iw.png', '2016-05-01 21:34:07'),
430(71, 3, 'Stone_Pick_Axe_icon (1).png', './upload/gallery/dzapzeolam36qew6vfx3fworddx3mclk.png', '2016-05-01 21:34:08'),
431(72, 3, 'Stone_Pick_Axe_icon (1).png', './upload/gallery/thumbnails/dzapzeolam36qew6vfx3fworddx3mclk.png', '2016-05-01 21:34:08'),
432(73, 3, 'Stone_Pick_Axe_icon (1).png', './upload/gallery/originals/dzapzeolam36qew6vfx3fworddx3mclk.png', '2016-05-01 21:34:08'),
433(74, 3, 'Waterpipe_Shotgun_icon.png', './upload/gallery/1561ys4ujlspvtogh0juspm7xnrx79iz.png', '2016-05-01 21:34:09'),
434(75, 3, 'Waterpipe_Shotgun_icon.png', './upload/gallery/thumbnails/1561ys4ujlspvtogh0juspm7xnrx79iz.png', '2016-05-01 21:34:09'),
435(76, 3, 'Waterpipe_Shotgun_icon.png', './upload/gallery/originals/1561ys4ujlspvtogh0juspm7xnrx79iz.png', '2016-05-01 21:34:09'),
436(77, 3, 'Stone_Pick_Axe_icon.png', './upload/gallery/znorbw23ql81ro2a6ge39nvm3wjoc5fv.png', '2016-05-01 21:34:09'),
437(78, 3, 'Stone_Pick_Axe_icon.png', './upload/gallery/thumbnails/znorbw23ql81ro2a6ge39nvm3wjoc5fv.png', '2016-05-01 21:34:09'),
438(79, 3, 'Stone_Pick_Axe_icon.png', './upload/gallery/originals/znorbw23ql81ro2a6ge39nvm3wjoc5fv.png', '2016-05-01 21:34:09'),
439(80, 3, 'Timed_Explosive_Charge_icon.png', './upload/gallery/0aev4z9lfuetnp6uo9uihduxgifqarxj.png', '2016-05-01 21:34:10'),
440(81, 3, 'Timed_Explosive_Charge_icon.png', './upload/gallery/thumbnails/0aev4z9lfuetnp6uo9uihduxgifqarxj.png', '2016-05-01 21:34:10'),
441(82, 3, 'Timed_Explosive_Charge_icon.png', './upload/gallery/originals/0aev4z9lfuetnp6uo9uihduxgifqarxj.png', '2016-05-01 21:34:10'),
442(83, 3, 'Pump_Shotgun_icon.png', './upload/gallery/pm2bykqcszfzc6zw4qi52hlrpymbyfis.png', '2016-05-01 21:34:11'),
443(84, 3, 'Pump_Shotgun_icon.png', './upload/gallery/thumbnails/pm2bykqcszfzc6zw4qi52hlrpymbyfis.png', '2016-05-01 21:34:11'),
444(85, 3, 'Pump_Shotgun_icon.png', './upload/gallery/originals/pm2bykqcszfzc6zw4qi52hlrpymbyfis.png', '2016-05-01 21:34:11'),
445(86, 3, 'Wooden_Ladder_icon.png', './upload/gallery/4urxsomqgbr4h50qndfmhk3grp3hrhgy.png', '2016-05-01 21:34:11'),
446(87, 3, 'Wooden_Ladder_icon.png', './upload/gallery/thumbnails/4urxsomqgbr4h50qndfmhk3grp3hrhgy.png', '2016-05-01 21:34:11'),
447(88, 3, 'Wooden_Ladder_icon.png', './upload/gallery/originals/4urxsomqgbr4h50qndfmhk3grp3hrhgy.png', '2016-05-01 21:34:11'),
448(89, 3, 'Supply_Signal_icon.png', './upload/gallery/yhxwx5ph2ymunjgawbohaf14onfgfhdh.png', '2016-05-01 21:34:11'),
449(90, 3, 'Supply_Signal_icon.png', './upload/gallery/thumbnails/yhxwx5ph2ymunjgawbohaf14onfgfhdh.png', '2016-05-01 21:34:11'),
450(91, 3, 'Supply_Signal_icon.png', './upload/gallery/originals/yhxwx5ph2ymunjgawbohaf14onfgfhdh.png', '2016-05-01 21:34:11'),
451(92, 4, '13090199_1598237943826222_1964655488_n.jpg', './upload/members/d95uzadepbttjtwfb1gsg1wlrz33ltnr.jpg', '2016-05-01 22:24:14'),
452(93, 3, 'Sans titre 1.png', './upload/news/jbukrku58kqhutujbzfnkemyomh64qsq.png', '2016-05-02 14:55:04');
453
454-- --------------------------------------------------------
455
456--
457-- Structure de la table `nf_forum`
458--
459
460CREATE TABLE IF NOT EXISTS `nf_forum` (
461  `forum_id` int(11) unsigned NOT NULL,
462  `parent_id` int(11) unsigned NOT NULL,
463  `is_subforum` enum('0','1') NOT NULL DEFAULT '0',
464  `title` varchar(100) NOT NULL,
465  `description` varchar(100) NOT NULL,
466  `order` smallint(6) unsigned NOT NULL,
467  `count_topics` int(11) unsigned NOT NULL DEFAULT '0',
468  `count_messages` int(11) unsigned NOT NULL DEFAULT '0',
469  `last_message_id` int(11) unsigned DEFAULT NULL
470) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8;
471
472--
473-- Contenu de la table `nf_forum`
474--
475
476INSERT INTO `nf_forum` (`forum_id`, `parent_id`, `is_subforum`, `title`, `description`, `order`, `count_topics`, `count_messages`, `last_message_id`) VALUES
477(1, 1, '0', 'Discussions g&eacute;n&eacute;rales', 'Aucune cat&eacute;gorie pour votre sujet ? C''est par ici que &ccedil;a se passe !', 2, 0, 0, NULL),
478(5, 1, '0', 'Information / R&eacute;glement', 'Ici retrouver toutes les infos et r&egrave;gles du Forum.', 0, 1, 0, 2),
479(7, 1, '0', 'Pr&eacute;sentation', 'Vous-&ecirc;tes nouveau sur RustyFrance ? Bienvenue ! &Eacute;crivez votre pr&eacute;sentation.', 1, 1, 0, 3),
480(20, 1, '0', 'Rapport de Bug', 'Signaler un probl&egrave;me au niveau du site.', 4, 0, 0, NULL),
481(32, 5, '0', 'Coin PC', '', 0, 0, 0, NULL),
482(34, 5, '0', 'Jeux vid&eacute;o', '', 0, 0, 0, NULL),
483(48, 6, '0', 'R&egrave;gles du serveur', '', 0, 2, 0, 16),
484(49, 7, '0', 'R&egrave;gles du serveur', '', 0, 0, 0, NULL),
485(50, 7, '0', 'Infos serveur', '', 0, 1, 0, 18),
486(51, 6, '0', 'Infos serveur', '', 0, 0, 0, NULL),
487(52, 7, '0', 'Voir la map en cours', '', 0, 0, 0, NULL),
488(53, 6, '0', 'Voir la map en cours', '', 0, 2, 0, 13),
489(54, 6, '0', 'Discussions g&eacute;n&eacute;rales', '', 0, 0, 0, NULL),
490(55, 7, '0', 'Discussions g&eacute;n&eacute;rales', '', 0, 0, 0, NULL),
491(58, 6, '0', 'Rapporter un bug', '', 0, 1, 0, 14),
492(60, 7, '0', 'Rapporter un bug', '', 0, 0, 0, NULL),
493(61, 7, '0', 'Plainte/D&eacute;ban', '', 0, 0, 0, NULL),
494(62, 6, '0', 'Plainte/D&eacute;ban', '', 0, 0, 0, NULL),
495(63, 8, '0', 'Comment rejoindre le Teamspeak ?', '', 0, 1, 0, 15),
496(64, 1, '0', 'Tutoriels', '', 3, 1, 0, 17);
497
498-- --------------------------------------------------------
499
500--
501-- Structure de la table `nf_forum_categories`
502--
503
504CREATE TABLE IF NOT EXISTS `nf_forum_categories` (
505  `category_id` int(11) unsigned NOT NULL,
506  `title` varchar(100) NOT NULL,
507  `order` smallint(6) unsigned NOT NULL
508) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
509
510--
511-- Contenu de la table `nf_forum_categories`
512--
513
514INSERT INTO `nf_forum_categories` (`category_id`, `title`, `order`) VALUES
515(1, 'Forums g&eacute;n&eacute;raux', 0),
516(5, 'Communaut&eacute;', 4),
517(6, 'RustyFrance - Vanilla [ON]', 1),
518(7, 'RustyFrance - Battlefield [OFF]', 2),
519(8, 'Teamspeak RustyFrance', 3);
520
521-- --------------------------------------------------------
522
523--
524-- Structure de la table `nf_forum_messages`
525--
526
527CREATE TABLE IF NOT EXISTS `nf_forum_messages` (
528  `message_id` int(11) unsigned NOT NULL,
529  `topic_id` int(11) unsigned NOT NULL,
530  `user_id` int(11) unsigned DEFAULT NULL,
531  `message` text,
532  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
533) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;
534
535--
536-- Contenu de la table `nf_forum_messages`
537--
538
539INSERT INTO `nf_forum_messages` (`message_id`, `topic_id`, `user_id`, `message`, `date`) VALUES
540(2, 2, 1, '[b]Bonjour &agrave; tous ![/b]\r\n\r\n[i][i]Pour entretenir une bonne entente ainsi qu''une bonne ambiance au sein du forum un r&egrave;glement devra &ecirc;tre scrupuleusement respect&eacute;, le voici\r\n:[/i][/i]\r\n\r\n[color=#ff0000][u][b]Il vous est interdit :[/b][/u][/color]\r\n\r\n- De divulguer des propos racistes envers un membre.\r\n- D''usurper l'' identit&eacute; d''une personne &agrave; son insu.\r\n- D''avoir un langage inappropri&eacute;.\r\n- De faire de la publicit&eacute;. (Seul les publicit&eacute;s pour les cha&icirc;nes YouTube seront accept&eacute;es)\r\n- De partager des photos ou des liens &agrave; caract&egrave;re pornographique/hardcore.\r\n- De partager son compte.\r\n- De distribuer des virus.\r\n- Interdiction de post&eacute; des vid&eacute;os, photos ou autres a caract&egrave;re pornographique, choquant ou religieux.\r\n\r\n[color=#ff0000][u][b]Il vous est obligatoire :[/b][/u][/color]\r\n\r\n- D''accompagner chaque lien de t&eacute;l&eacute;chargement de fichier .exe et .com d''un virus scan[url=https://www.virustotal.com/fr/] Virus Total [/url](Si l''application est compress&eacute;e en un archive .zip ou .rar vous devrez imp&eacute;rativement scanner l''application d&eacute;compress&eacute;e et non l''archive).\r\n- D''accompagner chaque logiciel de quelques screens de celui-ci.\r\n\r\n[i]Si ces r&egrave;gles ne sont pas respect&eacute;es et que nous consid&eacute;rons que vous essayez de nuire au bon fonctionnement du forum vous serez sanctionn&eacute; de la fa&ccedil;on la plus appropri&eacute;e qu''il soit.[/i]\r\n\r\n[color=#ff0000][u][b]Vous &ecirc;tes en droit :[/b][/u][/color]\r\n\r\n- De demander un changement de pseudo.\r\n- De cr&eacute;er des discussions.\r\n- De particip&eacute; au bon d&eacute;veloppement du forum en effectuant des dons.\r\n- D''exprimer vos opinions, accord(s) ou d&eacute;saccord(s).\r\n- De modifier et/ou masquer vos informations personnelles.\r\n- De commenter tout les topics qui sont cr&eacute;es.\r\n- De demander des justificatifs de vos sanctions.\r\n- De poster votre candidature pour int&eacute;grer le staff.\r\n\r\n[color=#ff0000][u][b]Il vous est conseill&eacute; :[/b][/u][/color]\r\n\r\n- De vous pr&eacute;sentez sur le forum [url=http://rustyfrance.cluster1.easy-hebergement.net/forum/7/presentation.html]Ici[/url].\r\n- D''utiliser un avatar personnalis&eacute;.\r\n\r\n\r\n[color=#ff0000][u][b][center]RustyFrance[/center][/b][/u][/color]', '2016-04-29 23:55:46'),
541(3, 3, 1, 'Vous &ecirc;tes nouveau sur RustyFrance ? N''h&eacute;sitez pas &agrave; vous pr&eacute;senter, afin que nous puissions mieux vous conna&icirc;tre, id&eacute;alement en respectant \r\nle mod&egrave;le suivant :\r\n\r\n[b][u][color=#ff0000]Mod&egrave;le de pr&eacute;sentation :[/color][/u]\r\n[/b][center]\r\nï»¿ï»¿[i]Salut la communaut&eacute; RustyFrance, je viens de m''inscrire et voici ma pr&eacute;sentation ! [/i]\r\n\r\n[i]Pr&eacute;sentation IRL (R&eacute;alit&eacute;) :[/i]\r\n\r\n[i]- Pr&eacute;nom [/i]: ...\r\n-[i] Surnom / pseudonyme [/i]: ...\r\n[i]- &Acirc;ge[/i] : ...\r\n[i]- Ma ville/r&eacute;gion[/i] : ...\r\n[i]- Vos centres d''int&eacute;r&ecirc;ts (occupations, &eacute;tudes..) [/i]: ...\r\n[i]\r\nPr&eacute;sentation IG (In-Game) [/i]:\r\n\r\n[i]- Pourquoi avoir rejoint la communaut&eacute; [color=#444444]RustyFrance[/color][/i]? : ...\r\n[i]- Avez-vous une/plusieurs console(s) [b]Sony[/b][/i] ? : ...\r\n[i]- Avez-vous une/plusieurs console(s) [b]Microsoft[/b][/i] ? : ...\r\n[i]- Avez-vous une/plusieurs console(s) [b]Nintendo[/b][/i] ? : ...\r\n[i]- Poss&eacute;dez-vous un/plusieurs compte(s) [b]Steam[/b][/i] ? : ...\r\n-[i] Poss&eacute;dez-vous un/plusieurs compte(s) [/i][b][i]Origins[/i] [/b]? : ...\r\n[i]- Poss&eacute;dez-vous un/plusieurs compte(s) [b]Uplay[/b][/i] ? : &hellip;\r\n[i]- Si vous avez autre chose &agrave; rajouter[/i] : ...\r\n\r\n[i]Comment me contacter ? [/i] :\r\n\r\n- A[i]vez-vous un compte sur les r&eacute;seaux sociaux ? (Twitter, Facebook, Google +...)[/i] : ...\r\n[i]- Avez-vous un compte [b]Skype[/b][/i] ? : ...\r\n[i]- Avez-vous une chaine [b]YouTube[/b][/i] ? : ...\r\n[i]- Autres moyens (TeamSpeack, Discord&hellip;)[/i] : &hellip;\r\n\r\n[i]Cordialement, votre pseudo\r\n[/i][/center][i]\r\n[b][center]\r\n[b]\r\n[u][color=#ff0000]Bienvenue sur RustyFrance! [url=http://realitygaming.fr/threads/bienvenue-sur-realitygaming.507/][img]https://realitygaming.fr/styles/default/xenforo/clear.png[/img][/url][/color][/u][/b][/center][url=http://realitygaming.fr/threads/bienvenue-sur-realitygaming.507/][img]https://realitygaming.fr/styles/default/xenforo/clear.png[/img][/url][/b]\r\n\r\n[/i]', '2016-04-30 00:06:21'),
542(11, 11, 1, '[size=150][b][center][color=#ff0000]R&egrave;gles du serveur &quot;RustyFrance&quot;.[/color][/center]\r\n\r\n[/b][/size][size=150][b]1 : le jeu\r\n[/b][/size][size=150]- Le cheat qui est proprement interdit et r&eacute;compens&eacute; d&rsquo;une sanction sans appel sur le serveur et appuy&eacute; d&rsquo;une missive a Facepunch .[/size][size=150]\r\n[/size][size=150]- Streamstalk interdit, toute personne regardant un live pour avoir des informations sur un streamer et le rejoindre sera bannie. [/size][size=150]\r\n[/size][size=150]- Trahison d&rsquo;alliance ? Ceci est formellement interdit suite &agrave; de nombreux probl&egrave;mes sur le serveur.[/size][size=150]\r\n[/size][size=150]- Interdiction de depop du stuf durant un raid, un minimum de fairplay.[/size][size=150]\r\n- Tout signe religieux et contre n&rsquo;importe qu''elle religion est interdit. \r\n[/size][size=150]\r\n[/size][size=150][b]2 : la communaut&eacute;[/b][/size][size=150]\r\n[/size][size=150]Si le Fair Play ne peut &ecirc;tre totalement impos&eacute;, la politesse, elle, est de mise. Les insultes sont de ce fait interdites et susceptibles de sanctions.[/size][size=150]\r\n[/size][size=150]Le taunt (provocation, chambrage) est autoris&eacute;, car consid&eacute;r&eacute; comme partie int&eacute;grante du jeu, mais chacun se doit de veiller &agrave; ne pas en [/size][size=150]abuser. M&eacute;fiez-vous, s&rsquo;exprimer par &eacute;crit ne permet pas toujours de d&eacute;tecter humour ou ironie, et vos propos peuvent ainsi vexer ou &ecirc;tre mal prit.[/size][size=150][b]\r\n\r\n3 : Les admins\r\n[/b][/size][size=150]L&rsquo;admin ne joue pas , afin de ne pas se faire accuser de &laquo; give &raquo; ou &laquo; abus &raquo;.[/size][size=150]\r\n[/size][size=150]Ils ont la pour veiller le plus passivement possible, vanilla oblige, au bon d&eacute;roulement du jeu. [/size][size=150]\r\n[/size][size=150]Ils ne sont pas l&agrave; pour d&eacute;truire les constructions rat&eacute;es sauf en cas de Grief.[/size][size=150]\r\n[/size][size=150]Rust est une alpha et les admins ne peuvent corriger / compenser les injustices dues au jeu et ses bugs.[/size][size=150]\r\n[/size][size=150]\r\n[/size][size=150][b][center][color=#ff0000]ï»¿RustyFrance.[/color][/center][/b][/size]', '2016-05-05 21:56:41'),
543(12, 12, 1, '[center][color=#ff0000][size=200]Map du 23/04[/size]\r\n[/color][/center][img]http://i.imgur.com/LUDXqCI.jpg[/img]', '2016-05-05 21:58:54'),
544(13, 13, 1, '[color=#ff0000][size=200][center]MAP DU 05/05\r\nLa map sera bient&ocirc;t upload ici, merci de patienter.[/center][/size][/color]', '2016-05-05 22:00:28'),
545(14, 14, 1, 'Bonjour/Bonsoir &agrave; tous,\r\n\r\nSi le serveur vient &agrave; crash (en gros: pas moyen de se reconnecter au \r\ndel&agrave; de 5-10 minutes et que cette d&eacute;connexion reste permanente), je vous\r\ninvite grandement &agrave; le signaler par divers moyens.\r\n\r\n[list][*]Le signaler &agrave; un Admin pr&eacute;sent sur Teamspeak (n''h&eacute;sitez pas &agrave; envoyer un MP).[/*][/list][list][*]Ou le signaler en message Steam &agrave; [url=http://steamcommunity.com/id/Fouzii/]Fouzii[/url]ï»¿ ou [url=http://steamcommunity.com/profiles/76561198094775389]Hocine[/url]ï»¿\r\n\r\n[/*][/list]\r\n---\r\nAussi, n''h&eacute;sitez pas &agrave; cr&eacute;er un topic dans l''onglet &quot;[url=http://rustyfrance.fr/forum/58/rapporter-un-bug.html]Rapporter un bug&quot; [/url]pour signaler par exemple des probl&egrave;mes qui surviennent ingame comme des lags ou des minis-roleback par exemple. Essayez d''&ecirc;tre le plus complet possible en d&eacute;taillant vos soucis afin que nous puissions trouver des solutions!\r\n\r\n\r\n[b][color=#ff0000][center]Merci ![/center][/color][/b]', '2016-05-05 22:06:22'),
546(15, 15, 1, '[center][size=150][b][/b][/size][/center][center][img]http://14frs1589.fr/public/icons/.icon-ts3_t.png[/img]\r\n\r\n[size=150][b]1-[/b] [url=https://www.teamspeak.com/downloads]T&eacute;l&eacute;charg&eacute; TeamSpeak 3[/url]ï»¿ ï»¿\r\n\r\n[b]2-[/b] Une fois l''installation faite, cliquez sur &quot;[b]Connexion[/b]&quot; puis sur &quot;[b]Se connecter[/b]&quot;\r\n\r\n[b]3- [/b]Suivez ensuite l''exemple comme sur l''image ci-dessous:\r\n[img]http://img15.hostingpics.net/pics/303034Sanstitre1.png[/img]ï»¿\r\n\r\n[b]L''adresse du TS:[/b] TS13.verygames.net:53589\r\n\r\nIl est aussi possible de rejoindre notre TS via le widget en bas de la page d''accueil.[/size][/center]', '2016-05-05 22:24:26'),
547(16, 16, 3, '[size=100]Qu''est-ce que le [b]grief[/b] ?\r\n\r\nLe [b]grief [/b]c''est lorsqu''on bloque une construction par les moyens suivants:\r\n- Enferm&eacute; l''armoire afin de ne pas pouvoir construire\r\n- Enferm&eacute; la base &agrave; l''aide de mur et/ou de porte\r\nLe fait de bloqu&eacute; une base via les moyen ci-dessus sans y habit&eacute; les lieu, le [b]grief [/b]est constat&eacute;.\r\n\r\nComment s''emparer d''une base sans que le [b]grief[/b] soit constat&eacute; ?\r\n- Le grief ne peut &ecirc;tre constat&eacute; d&egrave;s lors que la personnes qui c''est emparer des lieu a d&eacute;poser un sac de couchage et/ou lit &agrave; l''int&eacute;rieur de la base ainsi qu''un minimum de ressources afin de survivre.\r\n\r\n[b][u]EN CLAIRE:[/u][/b] \r\n- Le vol d''une base est autoris&eacute; si le voleur en prend possession dans ce cas ce n''est pas du grief.\r\n- Le vol d''une base est interdit si le voleur bloque l''armoire et condamne tout acc&egrave;s possible et ne pas l''habit&eacute; par la suite ( tel une maison abandonn&eacute; ) dans ce cas, le grief est constat&eacute;. [/size]', '2016-05-06 02:20:06'),
548(17, 17, 3, '[size=100]On ce rejoint aujourd''hui pour un nouveau tutoriel sur la cr&eacute;ation d''un serveur en local. Id&eacute;al pour construire sans limite, test&eacute; les plugin avant la mise en ligne sur le vrai serveur etc.[/size]\r\n\r\n[size=100]Ce tutoriel sera bref et simple avec des i[/size]llustrations afin d''apport&eacute; un maximum de compr&eacute;hension pour chaque &eacute;tape.\r\n\r\n[b]1-[/b][size=100] T&eacute;l&eacute;chargement de [/size][url=https://playrust.com/dedicated-server/]Rust_Server.zip[/url][size=100]ï»¿ ( Directement sur le site officiel ).[/size]\r\n\r\n[b]2- [/b][size=100]D&eacute;-zipp&eacute; le dossier Rust_Server.zip &agrave; l''emplacement souhait&eacute; cela n''a pas d''importance[/size]\r\n\r\n[b]3-[/b][size=100] Lancer le fichier [/size][b]Run_DS.bat.\r\n[img]http://img15.hostingpics.net/pics/804788Sanstitre1.png[/img]ï»¿\r\n\r\n[/b][size=100]Une fois le [/size][b]Run_DS.bat[/b][size=100] lanc&eacute;, celui-ci ouvrira l''invite de commande ( cmd ) qui l''invite de commande lancera une r&eacute;cup&eacute;ration de fichier afin de les copier sur votre ordinateur et ensuite les mettre &agrave; jour. Ses fichier sont essentiel pour la cr&eacute;ation de votre serveur. Laissez la fen&ecirc;tre ouvert sinon nous &eacute;teignez votre serveur.[/size]\r\n[img]http://img15.hostingpics.net/pics/589368Sanstitre2.png[/img]ï»¿\r\n[size=100]NB: La copie des fichiers, la validation ainsi que la mise &agrave; jour des fichiers peuvent dur&eacute;e assez longtemps.[/size]\r\n\r\n[b]4- [/b][size=100]Pour &ecirc;tre admin de votre propre serveur il vous faudra tapez la commande suivante dans le cmd:[/size]\r\n[code]ownerid &lt;VOTRE_STEAM_ID_64&gt; &quot;VOTRE_PSEUDO&quot; &quot;ADMIN&quot;\r\n[/code][size=100]Votre Steam id 64 est visible sur [/size][url=https://steamid.io/]Steamid.io[/url]\r\n\r\n[b]5- [/b][size=100]Votre serveur et maintenant installer avec votre privil&egrave;ge d''administrateur.[/size]\r\n[b]Lanc&eacute; Rust[/b][size=100] et appuyer sur [/size][b]F1 [/b][size=100]puis tapez la commande suivante:[/size]\r\n[code]Client.connect\r\n[/code][size=100]Celle-ci vous permettra de vous connect&eacute; &agrave; votre serveur en local.[/size]\r\n\r\n[size=100]Afin de savoir si vous &ecirc;tes admin sur votre serveur, ouvrez le t''chat et tapez un texte au hasard, celui-ci devrais appara&icirc;tre en vert.\r\n\r\nJe reste &agrave; votre disposition pour tout bugs que vous rencontrerai afin d''optimis&eacute; / am&eacute;liorer ce tutoriel :'').\r\n\r\n[right]@Virus_Gamers[/right][/size]', '2016-05-06 15:04:16'),
549(18, 18, 3, '[size=100]C''est avec joie que je vous informe que la machine pour le serveur RustyFrance Battlefield arriv&eacute; !\r\nC''est un plaisir de vous offrir ce serveur en plus afin de vous d&eacute;tendre d''avantage aupr&egrave;s de notre communaut&eacute; et ainsi pouvoir augment&eacute; votre exp&eacute;rience de jeu PVP.\r\nA titre d''information: Le serveur d&eacute;di&eacute; nous co&ucirc;te environs 25&euro; par mois sans compt&eacute; les frais de licence Windows.\r\n\r\nVoici les caract&eacute;ristique du serveur d&eacute;di&eacute;:\r\n[b]- Processeur:[/b] Intel Xeon 6 vCore - @ 3.099Ghz\r\n[b]- M&eacute;moire:[/b] 6 Go de ram\r\n[b]- Disque dur:[/b] 50Go\r\n[b]- Connexion:[/b] 200 Mbp/s\r\n\r\nDe quoi faire tourn&eacute;e le serveur avec 150 personnes dessus sans probl&egrave;me ! :)\r\n\r\n[/size][right]Bon jeu &agrave; tous @Virus_Gamers[/right]', '2016-05-06 17:06:30');
550
551-- --------------------------------------------------------
552
553--
554-- Structure de la table `nf_forum_polls`
555--
556
557CREATE TABLE IF NOT EXISTS `nf_forum_polls` (
558  `topic_id` int(11) unsigned NOT NULL,
559  `question` varchar(100) NOT NULL,
560  `answers` text NOT NULL,
561  `is_multiple_choice` enum('0','1') NOT NULL DEFAULT '0'
562) ENGINE=InnoDB DEFAULT CHARSET=utf8;
563
564-- --------------------------------------------------------
565
566--
567-- Structure de la table `nf_forum_read`
568--
569
570CREATE TABLE IF NOT EXISTS `nf_forum_read` (
571  `user_id` int(11) unsigned NOT NULL,
572  `forum_id` int(11) unsigned NOT NULL DEFAULT '0',
573  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
574) ENGINE=InnoDB DEFAULT CHARSET=utf8;
575
576--
577-- Contenu de la table `nf_forum_read`
578--
579
580INSERT INTO `nf_forum_read` (`user_id`, `forum_id`, `date`) VALUES
581(1, 0, '2016-05-05 22:55:49'),
582(1, 53, '2016-05-06 13:09:59'),
583(1, 64, '2016-05-06 15:10:48'),
584(3, 0, '2016-05-07 20:50:38'),
585(4, 0, '2016-05-02 16:06:34'),
586(4, 5, '2016-05-02 16:06:38'),
587(6, 0, '2016-05-01 22:27:41'),
588(7, 0, '2016-05-02 08:45:09'),
589(7, 7, '2016-05-02 08:45:12'),
590(9, 0, '2016-05-04 19:22:21'),
591(9, 5, '2016-05-04 19:22:23'),
592(10, 0, '2016-05-04 20:20:31'),
593(10, 5, '2016-05-04 20:20:33'),
594(11, 0, '2016-05-05 08:18:47'),
595(11, 32, '2016-05-05 08:18:57'),
596(12, 0, '2016-05-05 11:00:57'),
597(13, 0, '2016-05-05 13:17:11'),
598(14, 0, '2016-05-05 21:17:38'),
599(14, 5, '2016-05-05 22:50:16'),
600(14, 48, '2016-05-05 22:50:37'),
601(15, 0, '2016-05-05 16:12:27'),
602(16, 0, '2016-05-05 16:22:18'),
603(17, 0, '2016-05-05 16:24:33'),
604(18, 0, '2016-05-05 19:12:09'),
605(19, 0, '2016-05-05 19:51:46'),
606(19, 48, '2016-05-06 00:11:57'),
607(20, 0, '2016-05-05 19:32:44'),
608(21, 0, '2016-05-05 20:16:53'),
609(23, 0, '2016-05-05 21:09:58'),
610(24, 0, '2016-05-05 21:30:07'),
611(25, 0, '2016-05-05 21:37:18'),
612(26, 0, '2016-05-06 22:29:54'),
613(26, 48, '2016-05-06 22:30:07');
614
615-- --------------------------------------------------------
616
617--
618-- Structure de la table `nf_forum_topics`
619--
620
621CREATE TABLE IF NOT EXISTS `nf_forum_topics` (
622  `topic_id` int(11) unsigned NOT NULL,
623  `forum_id` int(11) unsigned NOT NULL,
624  `message_id` int(11) unsigned NOT NULL,
625  `title` varchar(100) NOT NULL,
626  `status` enum('-2','-1','0','1') NOT NULL DEFAULT '0',
627  `views` int(11) unsigned NOT NULL,
628  `count_messages` int(11) unsigned NOT NULL,
629  `last_message_id` int(11) unsigned DEFAULT NULL
630) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;
631
632--
633-- Contenu de la table `nf_forum_topics`
634--
635
636INSERT INTO `nf_forum_topics` (`topic_id`, `forum_id`, `message_id`, `title`, `status`, `views`, `count_messages`, `last_message_id`) VALUES
637(2, 5, 2, 'R&egrave;glement du forum', '-2', 1, 0, NULL),
638(3, 7, 3, 'A propos des pr&eacute;sentations', '-2', 1, 0, NULL),
639(11, 48, 11, 'R&egrave;gles du serveur &quot;RustyFrance&quot;', '-2', 3, 0, NULL),
640(12, 53, 12, 'MAP DU 23/04', '-1', 1, 0, NULL),
641(13, 53, 13, 'Map du 05/05', '-2', 4, 0, NULL),
642(14, 58, 14, 'Signaler un crash serveur', '1', 1, 0, NULL),
643(15, 63, 15, 'Comment rejoindre notre serveur TeamSpeak 3', '1', 1, 0, NULL),
644(16, 48, 16, 'Qu''est-ce que le grief ?', '0', 0, 0, NULL),
645(17, 64, 17, '[TUTO] Installer un serveur Rust en local', '0', 1, 0, NULL),
646(18, 50, 18, 'H&eacute;bergement RustyFrance Battlefield', '0', 0, 0, NULL);
647
648-- --------------------------------------------------------
649
650--
651-- Structure de la table `nf_forum_topics_read`
652--
653
654CREATE TABLE IF NOT EXISTS `nf_forum_topics_read` (
655  `topic_id` int(11) unsigned NOT NULL,
656  `user_id` int(11) unsigned NOT NULL,
657  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
658) ENGINE=InnoDB DEFAULT CHARSET=utf8;
659
660--
661-- Contenu de la table `nf_forum_topics_read`
662--
663
664INSERT INTO `nf_forum_topics_read` (`topic_id`, `user_id`, `date`) VALUES
665(13, 13, '2016-05-05 22:00:28'),
666(13, 14, '2016-05-05 22:00:28'),
667(13, 25, '2016-05-05 22:00:28');
668
669-- --------------------------------------------------------
670
671--
672-- Structure de la table `nf_forum_track`
673--
674
675CREATE TABLE IF NOT EXISTS `nf_forum_track` (
676  `topic_id` int(11) unsigned NOT NULL,
677  `user_id` int(11) unsigned NOT NULL
678) ENGINE=InnoDB DEFAULT CHARSET=utf8;
679
680-- --------------------------------------------------------
681
682--
683-- Structure de la table `nf_forum_url`
684--
685
686CREATE TABLE IF NOT EXISTS `nf_forum_url` (
687  `forum_id` int(11) unsigned NOT NULL,
688  `url` varchar(100) NOT NULL,
689  `redirects` int(11) unsigned NOT NULL
690) ENGINE=InnoDB DEFAULT CHARSET=utf8;
691
692-- --------------------------------------------------------
693
694--
695-- Structure de la table `nf_gallery`
696--
697
698CREATE TABLE IF NOT EXISTS `nf_gallery` (
699  `gallery_id` int(11) unsigned NOT NULL,
700  `category_id` int(11) unsigned NOT NULL,
701  `image_id` int(11) unsigned DEFAULT NULL,
702  `name` varchar(100) NOT NULL,
703  `published` enum('0','1') NOT NULL DEFAULT '0'
704) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
705
706--
707-- Contenu de la table `nf_gallery`
708--
709
710INSERT INTO `nf_gallery` (`gallery_id`, `category_id`, `image_id`, `name`, `published`) VALUES
711(1, 1, NULL, 'set-icones', '0');
712
713-- --------------------------------------------------------
714
715--
716-- Structure de la table `nf_gallery_categories`
717--
718
719CREATE TABLE IF NOT EXISTS `nf_gallery_categories` (
720  `category_id` int(11) unsigned NOT NULL,
721  `image_id` int(11) unsigned DEFAULT NULL,
722  `icon_id` int(11) unsigned DEFAULT NULL,
723  `name` varchar(100) NOT NULL
724) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
725
726--
727-- Contenu de la table `nf_gallery_categories`
728--
729
730INSERT INTO `nf_gallery_categories` (`category_id`, `image_id`, `icon_id`, `name`) VALUES
731(1, NULL, NULL, 'rust');
732
733-- --------------------------------------------------------
734
735--
736-- Structure de la table `nf_gallery_categories_lang`
737--
738
739CREATE TABLE IF NOT EXISTS `nf_gallery_categories_lang` (
740  `category_id` int(11) unsigned NOT NULL,
741  `lang` varchar(5) NOT NULL,
742  `title` varchar(100) NOT NULL
743) ENGINE=InnoDB DEFAULT CHARSET=utf8;
744
745--
746-- Contenu de la table `nf_gallery_categories_lang`
747--
748
749INSERT INTO `nf_gallery_categories_lang` (`category_id`, `lang`, `title`) VALUES
750(1, 'fr', 'Rust');
751
752-- --------------------------------------------------------
753
754--
755-- Structure de la table `nf_gallery_images`
756--
757
758CREATE TABLE IF NOT EXISTS `nf_gallery_images` (
759  `image_id` int(11) unsigned NOT NULL,
760  `thumbnail_file_id` int(11) unsigned NOT NULL,
761  `original_file_id` int(11) unsigned NOT NULL,
762  `file_id` int(11) unsigned NOT NULL,
763  `gallery_id` int(11) unsigned NOT NULL,
764  `title` varchar(100) NOT NULL,
765  `description` text,
766  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
767  `views` int(11) unsigned NOT NULL
768) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;
769
770--
771-- Contenu de la table `nf_gallery_images`
772--
773
774INSERT INTO `nf_gallery_images` (`image_id`, `thumbnail_file_id`, `original_file_id`, `file_id`, `gallery_id`, `title`, `description`, `date`, `views`) VALUES
775(1, 27, 28, 26, 1, 'Acoustic_Guitar_icon.png', '', '2016-05-01 21:33:57', 0),
776(2, 30, 31, 29, 1, 'Bolt_Action_Rifle_icon.png', '', '2016-05-01 21:33:59', 0),
777(3, 33, 34, 32, 1, 'Flame_Thrower_icon.png', '', '2016-05-01 21:33:59', 0),
778(4, 36, 37, 35, 1, 'High_Quality_Metal_icon.png', '', '2016-05-01 21:34:00', 0),
779(5, 39, 40, 38, 1, 'Assault_Rifle_icon.png', '', '2016-05-01 21:34:00', 0),
780(6, 44, 46, 42, 1, 'Bone_Knife_icon.png', '', '2016-05-01 21:34:00', 0),
781(7, 43, 45, 41, 1, 'Bone_Club_icon.png', '', '2016-05-01 21:34:00', 0),
782(8, 48, 49, 47, 1, 'Hatchet_icon.png', '', '2016-05-01 21:34:01', 0),
783(9, 51, 52, 50, 1, 'Metal_Barricade_icon.png', '', '2016-05-01 21:34:02', 0),
784(10, 54, 55, 53, 1, 'Pick_Axe_icon.png', '', '2016-05-01 21:34:02', 0),
785(11, 57, 58, 56, 1, 'Revolver_icon.png', '', '2016-05-01 21:34:02', 0),
786(12, 60, 61, 59, 1, 'Stone_Hatchet_icon.png', '', '2016-05-01 21:34:05', 0),
787(13, 63, 64, 62, 1, 'Deer_Skull_icon.png', '', '2016-05-01 21:34:05', 0),
788(14, 66, 67, 65, 1, 'Thompson_icon.png', '', '2016-05-01 21:34:06', 0),
789(15, 69, 70, 68, 1, 'Pookie_Bear_icon.png', '', '2016-05-01 21:34:07', 0),
790(16, 72, 73, 71, 1, 'Stone_Pick_Axe_icon (1).png', '', '2016-05-01 21:34:08', 0),
791(17, 75, 76, 74, 1, 'Waterpipe_Shotgun_icon.png', '', '2016-05-01 21:34:09', 0),
792(18, 78, 79, 77, 1, 'Stone_Pick_Axe_icon.png', '', '2016-05-01 21:34:09', 0),
793(19, 81, 82, 80, 1, 'Timed_Explosive_Charge_icon.png', '', '2016-05-01 21:34:10', 0),
794(20, 84, 85, 83, 1, 'Pump_Shotgun_icon.png', '', '2016-05-01 21:34:11', 0),
795(21, 87, 88, 86, 1, 'Wooden_Ladder_icon.png', '', '2016-05-01 21:34:11', 0),
796(22, 90, 91, 89, 1, 'Supply_Signal_icon.png', '', '2016-05-01 21:34:11', 0);
797
798-- --------------------------------------------------------
799
800--
801-- Structure de la table `nf_gallery_lang`
802--
803
804CREATE TABLE IF NOT EXISTS `nf_gallery_lang` (
805  `gallery_id` int(11) unsigned NOT NULL,
806  `lang` varchar(5) NOT NULL,
807  `title` varchar(100) NOT NULL,
808  `description` text NOT NULL
809) ENGINE=InnoDB DEFAULT CHARSET=utf8;
810
811--
812-- Contenu de la table `nf_gallery_lang`
813--
814
815INSERT INTO `nf_gallery_lang` (`gallery_id`, `lang`, `title`, `description`) VALUES
816(1, 'fr', 'Set icones', '');
817
818-- --------------------------------------------------------
819
820--
821-- Structure de la table `nf_games`
822--
823
824CREATE TABLE IF NOT EXISTS `nf_games` (
825  `game_id` int(11) unsigned NOT NULL,
826  `parent_id` int(11) unsigned DEFAULT NULL,
827  `image_id` int(11) unsigned DEFAULT NULL,
828  `icon_id` int(11) unsigned DEFAULT NULL,
829  `name` varchar(100) NOT NULL
830) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
831
832--
833-- Contenu de la table `nf_games`
834--
835
836INSERT INTO `nf_games` (`game_id`, `parent_id`, `image_id`, `icon_id`, `name`) VALUES
837(2, NULL, NULL, 5, 'rust');
838
839-- --------------------------------------------------------
840
841--
842-- Structure de la table `nf_games_lang`
843--
844
845CREATE TABLE IF NOT EXISTS `nf_games_lang` (
846  `game_id` int(11) unsigned NOT NULL,
847  `lang` varchar(5) NOT NULL,
848  `title` varchar(100) NOT NULL
849) ENGINE=InnoDB DEFAULT CHARSET=utf8;
850
851--
852-- Contenu de la table `nf_games_lang`
853--
854
855INSERT INTO `nf_games_lang` (`game_id`, `lang`, `title`) VALUES
856(2, 'fr', 'Rust');
857
858-- --------------------------------------------------------
859
860--
861-- Structure de la table `nf_groups`
862--
863
864CREATE TABLE IF NOT EXISTS `nf_groups` (
865  `group_id` int(11) unsigned NOT NULL,
866  `name` varchar(100) NOT NULL,
867  `color` varchar(20) NOT NULL,
868  `icon` varchar(20) NOT NULL,
869  `auto` enum('0','1') NOT NULL DEFAULT '0'
870) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
871
872--
873-- Contenu de la table `nf_groups`
874--
875
876INSERT INTO `nf_groups` (`group_id`, `name`, `color`, `icon`, `auto`) VALUES
877(1, 'admins', 'danger', 'fa-users', '1'),
878(2, 'members', 'success', 'fa-user', '1'),
879(3, 'visitors', 'info', '', '1'),
880(5, 'graphiste', '#ff8fed', 'fa-beer', '0'),
881(6, 'moderateur', '#f78b28', 'fa-shield', '0'),
882(7, 'donateur', '#ece01c', 'fa-money', '0');
883
884-- --------------------------------------------------------
885
886--
887-- Structure de la table `nf_groups_lang`
888--
889
890CREATE TABLE IF NOT EXISTS `nf_groups_lang` (
891  `group_id` int(11) unsigned NOT NULL,
892  `lang` varchar(5) NOT NULL,
893  `title` varchar(100) NOT NULL
894) ENGINE=InnoDB DEFAULT CHARSET=utf8;
895
896--
897-- Contenu de la table `nf_groups_lang`
898--
899
900INSERT INTO `nf_groups_lang` (`group_id`, `lang`, `title`) VALUES
901(5, 'fr', 'Graphiste'),
902(6, 'fr', 'Mod&eacute;rateur'),
903(7, 'fr', 'Donateur');
904
905-- --------------------------------------------------------
906
907--
908-- Structure de la table `nf_news`
909--
910
911CREATE TABLE IF NOT EXISTS `nf_news` (
912  `news_id` int(11) unsigned NOT NULL,
913  `category_id` int(11) unsigned NOT NULL,
914  `user_id` int(11) unsigned NOT NULL,
915  `image_id` int(11) unsigned DEFAULT NULL,
916  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
917  `published` enum('0','1') NOT NULL DEFAULT '0',
918  `views` int(11) unsigned NOT NULL,
919  `vote` enum('0','1') NOT NULL DEFAULT '0'
920) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
921
922--
923-- Contenu de la table `nf_news`
924--
925
926INSERT INTO `nf_news` (`news_id`, `category_id`, `user_id`, `image_id`, `date`, `published`, `views`, `vote`) VALUES
927(1, 1, 1, NULL, '2016-04-28 22:16:28', '1', 0, '0'),
928(2, 2, 3, 93, '2016-05-02 14:52:49', '1', 0, '0');
929
930-- --------------------------------------------------------
931
932--
933-- Structure de la table `nf_news_categories`
934--
935
936CREATE TABLE IF NOT EXISTS `nf_news_categories` (
937  `category_id` int(11) unsigned NOT NULL,
938  `image_id` int(11) unsigned DEFAULT NULL,
939  `icon_id` int(11) unsigned DEFAULT NULL,
940  `name` varchar(100) NOT NULL
941) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
942
943--
944-- Contenu de la table `nf_news_categories`
945--
946
947INSERT INTO `nf_news_categories` (`category_id`, `image_id`, `icon_id`, `name`) VALUES
948(1, 23, 20, 'actualites-du-site'),
949(2, 24, 25, 'actualites-du-serveur');
950
951-- --------------------------------------------------------
952
953--
954-- Structure de la table `nf_news_categories_lang`
955--
956
957CREATE TABLE IF NOT EXISTS `nf_news_categories_lang` (
958  `category_id` int(11) unsigned NOT NULL,
959  `lang` varchar(5) NOT NULL,
960  `title` varchar(100) NOT NULL
961) ENGINE=InnoDB DEFAULT CHARSET=utf8;
962
963--
964-- Contenu de la table `nf_news_categories_lang`
965--
966
967INSERT INTO `nf_news_categories_lang` (`category_id`, `lang`, `title`) VALUES
968(1, 'fr', 'Actualit&eacute;s du site'),
969(2, 'fr', 'Actualit&eacute;s du serveur');
970
971-- --------------------------------------------------------
972
973--
974-- Structure de la table `nf_news_lang`
975--
976
977CREATE TABLE IF NOT EXISTS `nf_news_lang` (
978  `news_id` int(11) unsigned NOT NULL,
979  `lang` varchar(5) NOT NULL,
980  `title` varchar(100) NOT NULL,
981  `introduction` text NOT NULL,
982  `content` text NOT NULL,
983  `tags` text NOT NULL
984) ENGINE=InnoDB DEFAULT CHARSET=utf8;
985
986--
987-- Contenu de la table `nf_news_lang`
988--
989
990INSERT INTO `nf_news_lang` (`news_id`, `lang`, `title`, `introduction`, `content`, `tags`) VALUES
991(1, 'fr', 'Bienvenue sur notre nouveau site RustyFrance', 'Bienvenue &agrave; tous ! \r\nNous avons ouvert se site web suite &agrave; l''ouverture du serveur Rust &quot;RustyFrance&quot; , ici vous pourrez trouver toute les infos et les r&egrave;gles du serveur Rust.\r\nCe site n''est pas r&eacute;server &agrave; la communaut&eacute; des joueurs Rust ou m&ecirc;me au serveur Rust, Ici nous pouvons parler de tout dans l''onglet &quot;Forum&quot;.', '', 'SiteWeb'),
992(2, 'fr', 'Ouverture prochaine RustyFrance Battlefield !', '[size=100]C''est avec grand plaisir que je vous annonce l''ouverture prochaine d''un serveur Battlefield ![/size]\r\n[size=100]La date d''ouverture du serveur devrais &ecirc;tre pour le Samedi 7 mai 2016.[/size]\r\n[size=100]Nous sommes en cours de modification afin d''apport&eacute; un maximum de contenu pour le PVP principalement sans pour autant nuire au performance de la machine.\r\n\r\n[right]Bon jeu &agrave; vous et &agrave; bient&ocirc;t in game.[/right][/size]', '', '');
993
994-- --------------------------------------------------------
995
996--
997-- Structure de la table `nf_pages`
998--
999
1000CREATE TABLE IF NOT EXISTS `nf_pages` (
1001  `page_id` int(11) unsigned NOT NULL,
1002  `name` varchar(100) NOT NULL,
1003  `published` enum('0','1') NOT NULL DEFAULT '0'
1004) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
1005
1006--
1007-- Contenu de la table `nf_pages`
1008--
1009
1010INSERT INTO `nf_pages` (`page_id`, `name`, `published`) VALUES
1011(3, 'mentions-legales', '1'),
1012(5, 'donation-valide', '1'),
1013(6, 'avertissement', '1');
1014
1015-- --------------------------------------------------------
1016
1017--
1018-- Structure de la table `nf_pages_lang`
1019--
1020
1021CREATE TABLE IF NOT EXISTS `nf_pages_lang` (
1022  `page_id` int(11) unsigned NOT NULL,
1023  `lang` varchar(5) NOT NULL,
1024  `title` varchar(100) NOT NULL,
1025  `subtitle` varchar(100) NOT NULL,
1026  `content` text NOT NULL
1027) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1028
1029--
1030-- Contenu de la table `nf_pages_lang`
1031--
1032
1033INSERT INTO `nf_pages_lang` (`page_id`, `lang`, `title`, `subtitle`, `content`) VALUES
1034(3, 'fr', 'Mentions l&eacute;gales', '', '[u][b][size=150]Donn&eacute;es personnelles[/size][/b][/u]\r\n\r\n[size=100]Conform&eacute;ment &agrave; la loi &laquo; informatique et libert&eacute;s &raquo; du 6 janvier 1978 modifi&eacute;e en 2004, vous b&eacute;n&eacute;ficiez d&rsquo;un droit d&rsquo;acc&egrave;s et de rectification aux informations qui vous concernent, que vous pouvez exercer en vous adressant &agrave; @Virus_Gamers ou @Fouzii depuis la page de contact.\r\n\r\nVous pouvez &eacute;galement, pour des motifs l&eacute;gitimes, vous opposer au traitement des donn&eacute;es vous concernant.[/size]\r\n\r\n[u][b][size=150]Responsables du site[/size][/b][/u]\r\n\r\n[size=100]Fondateur: [url=http://steamcommunity.com/id/Fouzii/]@Fouzii[/url]\r\n[/size][size=100]Webmaster: [url=http://steamcommunity.com/id/Virus_Gamers]@Virus_Gamers[/url][/size]\r\n[u][b][size=150]\r\nCookies[/size][/b][/u]\r\n\r\n[size=100]Les cookies sont des petits fichiers que l''administrateur d&rsquo;un serveur installe sur votre ordinateur et qui permettent de m&eacute;moriser des donn&eacute;es relatives &agrave; l&rsquo;internaute lorsque celui-ci se connecte au site.\r\nNous utilisons le syst&egrave;me des cookies uniquement afin de m&eacute;moriser des informations destin&eacute;es &agrave; faciliter votre navigation.\r\nIl ne s''agit en aucun cas de m&eacute;moriser des donn&eacute;es personnelles vous concernant.\r\nIl vous est par ailleurs possible &agrave; tout moment de refuser l''installation de ces cookies voire de les supprimer.\r\nDans ce cas, nous veillons &agrave; ce que votre navigation n''en soit nullement emp&ecirc;ch&eacute;e.[/size]\r\n\r\n[u][b][size=150]H&eacute;bergement web[/size][/b][/u]\r\n\r\n[size=100]Fi&egrave;rement assur&eacute; par la [url=http://www.easy-hebergement.fr/]Soci&eacute;t&eacute; Easy-H&eacute;bergement[/url]\r\nSi&egrave;ge social :[b]SWIIPTEL SAS [/b]\r\nZONE INDUSTRIELLE VIDAILHAN \r\n10 RUE DES FRERES PEUGEOT \r\n31130 BALMA - FRANCE[/size]'),
1035(5, 'fr', 'Merci pour votre donation', '', '[size=100]Merci &agrave; vous pour votre donation. Vous contribuez directement &agrave; l&rsquo;&eacute;volution de notre serveur et cela nous touche beaucoup de voir que l&rsquo;on peut compter sur vous pour avancer !\r\n\r\nGr&acirc;ce &agrave; vous et &agrave; votre action, [url=http://rustyfrance.fr/]RustyFrance [/url]va pouvoir &agrave; la fois amortir les frais de gestion du serveur et de l''h&eacute;bergement mais aussi pouvoir au fur et &agrave; mesure s&rsquo;&eacute;quiper de nouvelles fonctionnalit&eacute;s pour le site afin de toujours vous proposer le meilleur de la qualit&eacute; !\r\n\r\nJe vous remercie encore une fois pour votre fid&eacute;lit&eacute; au fil du temps, votre soutien et le geste que vous venez de faire !\r\n\r\nLe statut &quot;Donateur&quot; vous sera attribuer dans les plus bref d&eacute;lais. \r\n\r\nJe vous dis &agrave; tr&egrave;s bient&ocirc;t sur notre serveur [url=http://rustyfrance.fr/]RustyFrance[/url]ï»¿.\r\n\r\n[/size]@Fouzii @Virus_Gamers'),
1036(6, 'fr', 'Avertissement', '', '[size=100]Il est regrettable d''en arriv&eacute; &agrave; ce point mais je pense que c''est la meilleurs solution afin d''instaur&eacute; un minimum de respect aupr&egrave;s de la communaut&eacute;.\r\n[/size]\r\n[size=100](1) Mmany - 07/05 - Insulte[/size]');
1037
1038-- --------------------------------------------------------
1039
1040--
1041-- Structure de la table `nf_search_keywords`
1042--
1043
1044CREATE TABLE IF NOT EXISTS `nf_search_keywords` (
1045  `keyword` varchar(100) NOT NULL,
1046  `count` int(11) unsigned NOT NULL
1047) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1048
1049-- --------------------------------------------------------
1050
1051--
1052-- Structure de la table `nf_sessions`
1053--
1054
1055CREATE TABLE IF NOT EXISTS `nf_sessions` (
1056  `session_id` varchar(32) NOT NULL,
1057  `ip_address` varchar(39) NOT NULL,
1058  `host_name` varchar(100) NOT NULL,
1059  `user_id` int(11) unsigned DEFAULT NULL,
1060  `is_crawler` enum('0','1') NOT NULL DEFAULT '0',
1061  `last_activity` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1062  `user_data` text NOT NULL,
1063  `remember_me` enum('0','1') NOT NULL DEFAULT '0'
1064) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1065
1066--
1067-- Contenu de la table `nf_sessions`
1068--
1069
1070INSERT INTO `nf_sessions` (`session_id`, `ip_address`, `host_name`, `user_id`, `is_crawler`, `last_activity`, `user_data`, `remember_me`) VALUES
1071('2jakoylcuq8ugualcxas48prplpykcq7', '82.237.134.75', 'eys33-2-82-237-134-75.fbx.proxad.net', NULL, '0', '2016-05-08 00:00:57', 'a:1:{s:7:"session";a:5:{s:4:"date";i:1462665657;s:10:"javascript";b:0;s:7:"referer";s:0:"";s:10:"user_agent";s:108:"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safari/537.36";s:7:"history";a:1:{i:0;s:10:"index.html";}}}', '0'),
1072('4uyuyn8rmevaf1lfiruyjf47nkxi7k7k', '90.8.224.247', 'AMarseille-653-1-261-247.w90-8.abo.wanadoo.fr', NULL, '0', '2016-05-08 00:13:49', 'a:1:{s:7:"session";a:5:{s:4:"date";i:1462662461;s:10:"javascript";b:0;s:7:"referer";s:0:"";s:10:"user_agent";s:27:"TeamSpeak3-ImageFetcher-1.0";s:7:"history";a:1:{i:0;s:10:"index.html";}}}', '0'),
1073('5fqmkyk6wx5gy3k7chmnxixdjthkwoyt', '88.183.13.22', 'dra83-2-88-183-13-22.fbx.proxad.net', NULL, '0', '2016-05-08 00:27:08', 'a:1:{s:7:"session";a:6:{s:4:"date";i:1462666656;s:10:"javascript";b:1;s:7:"referer";s:53:"http://rustyfrance.fr/forum/48/regles-du-serveur.html";s:10:"user_agent";s:109:"Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safari/537.36";s:7:"history";a:1:{i:0;s:10:"index.html";}s:9:"time_zone";s:6:"+02:00";}}', '0'),
1074('62pdveqhcpyw3i6g8c7pf42bz1vral29', '90.7.156.110', 'ALille-653-1-500-110.w90-7.abo.wanadoo.fr', NULL, '0', '2016-05-07 23:57:15', 'a:1:{s:7:"session";a:5:{s:4:"date";i:1462665435;s:10:"javascript";b:0;s:7:"referer";s:0:"";s:10:"user_agent";s:27:"TeamSpeak3-ImageFetcher-1.0";s:7:"history";a:1:{i:0;s:10:"index.html";}}}', '0'),
1075('7iau0fvc230kwaw5cd0kvx2lsgbt7r9v', '176.151.109.159', 'elb76-h02-176-151-109-159.dsl.sta.abo.bbox.fr', NULL, '0', '2016-05-08 00:38:17', 'a:1:{s:7:"session";a:6:{s:4:"date";i:1462666524;s:10:"javascript";b:1;s:7:"referer";s:0:"";s:10:"user_agent";s:108:"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safari/537.36";s:7:"history";a:3:{i:0;s:10:"index.html";i:1;s:10:"forum.html";i:2;s:31:"forum/48/regles-du-serveur.html";}s:9:"time_zone";s:6:"+02:00";}}', '0'),
1076('alcbo9dmawaryiws4ftrc0b9skqasjs7', '176.151.109.159', 'elb76-h02-176-151-109-159.dsl.sta.abo.bbox.fr', 3, '0', '2016-05-07 01:02:14', 'a:3:{s:7:"session";a:6:{s:4:"date";i:1462490434;s:10:"javascript";b:1;s:7:"referer";s:0:"";s:10:"user_agent";s:108:"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safari/537.36";s:7:"history";a:2:{i:0;s:10:"index.html";i:1;s:10:"forum.html";}s:9:"time_zone";s:6:"+02:00";}s:6:"alerts";a:3:{i:0;a:2:{s:7:"message";s:50:"<h4 class="alert-heading">Succes</h4>Sujet ajoutÃ©";s:4:"type";s:5:"error";}i:1;a:2:{s:7:"message";s:50:"<h4 class="alert-heading">Succes</h4>Sujet ajoutÃ©";s:4:"type";s:5:"error";}i:2;a:2:{s:7:"message";s:50:"<h4 class="alert-heading">Succes</h4>Sujet ajoutÃ©";s:4:"type";s:5:"error";}}s:11:"live_editor";s:2:"31";}', '1'),
1077('b766vzh0tiodzd8pm0orwwmy3iyhvrpv', '213.111.19.105', '105-19.111.213.ozone.net', NULL, '0', '2016-05-08 00:34:59', 'a:1:{s:7:"session";a:6:{s:4:"date";i:1462667488;s:10:"javascript";b:1;s:7:"referer";s:22:"https://www.google.fr/";s:10:"user_agent";s:159:"Mozilla/5.0 (Windows; U; Windows NT 6.2; en-US; Valve Steam GameOverlay/1461972496; ) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.110 Safari/537.36";s:7:"history";a:2:{i:0;s:39:"news/category/1/actualites-du-site.html";i:1;s:10:"forum.html";}s:9:"time_zone";s:6:"+02:00";}}', '0'),
1078('cnlm5lo4jpomfxpbcvgxctqh5hii2wbm', '78.231.0.110', 'gue23-1-78-231-0-110.fbx.proxad.net', 1, '0', '2016-05-07 20:55:40', 'a:1:{s:7:"session";a:6:{s:4:"date";i:1462275526;s:10:"javascript";b:1;s:7:"referer";s:0:"";s:10:"user_agent";s:73:"Mozilla/5.0 (Windows NT 10.0; WOW64; rv:46.0) Gecko/20100101 Firefox/46.0";s:7:"history";a:1:{i:0;s:10:"index.html";}s:9:"time_zone";s:6:"+02:00";}}', '1'),
1079('dsmckpqkkurnonazzhbdagmab2yzwooo', '109.222.57.2', 'APoitiers-655-1-473-2.w109-222.abo.wanadoo.fr', 4, '0', '2016-05-03 17:53:50', 'a:1:{s:7:"session";a:6:{s:4:"date";i:1462297985;s:10:"javascript";b:1;s:7:"referer";s:0:"";s:10:"user_agent";s:72:"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:45.0) Gecko/20100101 Firefox/45.0";s:7:"history";a:1:{i:0;s:10:"index.html";}s:9:"time_zone";s:6:"+02:00";}}', '1'),
1080('eajlpweggpmxiuewtcvt9dvkauurokun', '86.205.14.45', 'ANice-651-1-342-45.w86-205.abo.wanadoo.fr', NULL, '0', '2016-05-07 23:47:07', 'a:1:{s:7:"session";a:5:{s:4:"date";i:1462664827;s:10:"javascript";b:0;s:7:"referer";s:0:"";s:10:"user_agent";s:27:"TeamSpeak3-ImageFetcher-1.0";s:7:"history";a:1:{i:0;s:10:"index.html";}}}', '0'),
1081('iilcpon8lta3yjubxfyfvzf1l5kgivym', '90.108.155.106', 'LFbn-1-5696-106.w90-108.abo.wanadoo.fr', NULL, '0', '2016-05-08 00:28:51', 'a:1:{s:7:"session";a:5:{s:4:"date";i:1462667331;s:10:"javascript";b:0;s:7:"referer";s:0:"";s:10:"user_agent";s:27:"TeamSpeak3-ImageFetcher-1.0";s:7:"history";a:1:{i:0;s:10:"index.html";}}}', '0'),
1082('ikji0nhjbwbdwc7gxd0ch8tabcgomlq0', '82.248.40.173', 'lns-bzn-27-82-248-40-173.adsl.proxad.net', NULL, '0', '2016-05-08 00:39:50', 'a:1:{s:7:"session";a:6:{s:4:"date";i:1462667858;s:10:"javascript";b:1;s:7:"referer";s:0:"";s:10:"user_agent";s:109:"Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safari/537.36";s:7:"history";a:9:{i:0;s:10:"index.html";i:1;s:18:"avertissement.html";i:2;s:10:"teams.html";i:3;s:10:"forum.html";i:4;s:34:"forum/5/information-reglement.html";i:5;s:37:"forum/topic/2/reglement-du-forum.html";i:6;s:31:"forum/48/regles-du-serveur.html";i:7;s:41:"forum/topic/16/quest-ce-que-le-grief.html";i:8;s:49:"forum/topic/11/regles-du-serveur-rustyfrance.html";}s:9:"time_zone";s:6:"+02:00";}}', '0'),
1083('ipx2hiyrtobgfl8ihdwnp8l73fsilfag', '78.247.165.178', 'blw68-1-78-247-165-178.fbx.proxad.net', 8, '0', '2016-05-06 14:56:10', 'a:1:{s:7:"session";a:6:{s:4:"date";i:1462546554;s:10:"javascript";b:1;s:7:"referer";s:0:"";s:10:"user_agent";s:109:"Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safari/537.36";s:7:"history";a:1:{i:0;s:10:"index.html";}s:9:"time_zone";s:6:"+02:00";}}', '1'),
1084('izlfzl6dealhmfssjy0g70qa8kjouvn6', '84.98.221.238', '238.221.98.84.rev.sfr.net', 14, '0', '2016-05-05 22:51:38', 'a:1:{s:7:"session";a:6:{s:4:"date";i:1462478502;s:10:"javascript";b:1;s:7:"referer";s:22:"https://www.google.fr/";s:10:"user_agent";s:109:"Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safari/537.36";s:7:"history";a:6:{i:0;s:10:"index.html";i:1;s:10:"forum.html";i:2;s:34:"forum/5/information-reglement.html";i:3;s:37:"forum/topic/2/reglement-du-forum.html";i:4;s:31:"forum/48/regles-du-serveur.html";i:5;s:49:"forum/topic/11/regles-du-serveur-rustyfrance.html";}s:9:"time_zone";s:6:"+02:00";}}', '1'),
1085('j0pnux72rqgcfmcgbwlvau3t22psme75', '176.151.109.159', 'elb76-h02-176-151-109-159.dsl.sta.abo.bbox.fr', 3, '0', '2016-05-02 22:25:28', 'a:1:{s:7:"session";a:6:{s:4:"date";i:1462200338;s:10:"javascript";b:1;s:7:"referer";s:0:"";s:10:"user_agent";s:108:"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safari/537.36";s:7:"history";a:2:{i:0;s:10:"index.html";i:1;s:10:"forum.html";}s:9:"time_zone";s:6:"+02:00";}}', '1'),
1086('jhhmdsitznkgytjcf05qmihatkp4egyn', '176.151.109.159', 'elb76-h02-176-151-109-159.dsl.sta.abo.bbox.fr', 3, '0', '2016-05-04 20:51:59', 'a:2:{s:7:"session";a:6:{s:4:"date";i:1462271689;s:10:"javascript";b:1;s:7:"referer";s:0:"";s:10:"user_agent";s:108:"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safari/537.36";s:7:"history";a:1:{i:0;s:61:"admin/news/2/ouverture-prochaine-rustyfrance-battlefield.html";}s:9:"time_zone";s:6:"+02:00";}s:6:"alerts";a:1:{i:0;a:2:{s:7:"message";s:50:"<h4 class="alert-heading">Succes</h4>Sujet ajoutÃ©";s:4:"type";s:5:"error";}}}', '1'),
1087('k8bu0kbzhfrtmu3aktc5r8ycqgrwftt6', '109.88.216.45', 'host-109-88-216-45.dynamic.voo.be', 13, '0', '2016-05-07 02:00:45', 'a:1:{s:7:"session";a:6:{s:4:"date";i:1462464335;s:10:"javascript";b:1;s:7:"referer";s:56:"http://rustyfrance.fr/forum/26/voir-la-map-en-cours.html";s:10:"user_agent";s:73:"Mozilla/5.0 (Windows NT 10.0; WOW64; rv:45.0) Gecko/20100101 Firefox/45.0";s:7:"history";a:4:{i:0;s:10:"index.html";i:1;s:10:"forum.html";i:2;s:34:"forum/53/voir-la-map-en-cours.html";i:3;s:31:"forum/topic/13/map-du-0505.html";}s:9:"time_zone";s:6:"+02:00";}}', '1'),
1088('kf0rm2lihcvyhrmdd3vcf4wixlarssza', '37.167.119.227', '37.167.119.227', NULL, '0', '2016-05-08 00:25:45', 'a:1:{s:7:"session";a:5:{s:4:"date";i:1462663854;s:10:"javascript";b:0;s:7:"referer";s:0:"";s:10:"user_agent";s:27:"TeamSpeak3-ImageFetcher-1.0";s:7:"history";a:1:{i:0;s:10:"index.html";}}}', '0'),
1089('l2k2x42ollvh4bmcjyradzuigvat7bhj', '78.231.0.110', 'gue23-1-78-231-0-110.fbx.proxad.net', 1, '0', '2016-05-08 00:41:47', 'a:3:{s:7:"session";a:6:{s:4:"date";i:1462201240;s:10:"javascript";b:1;s:7:"referer";s:0:"";s:10:"user_agent";s:73:"Mozilla/5.0 (Windows NT 10.0; WOW64; rv:46.0) Gecko/20100101 Firefox/46.0";s:7:"history";a:8:{i:0;s:10:"index.html";i:1;s:10:"forum.html";i:2;s:31:"forum/48/regles-du-serveur.html";i:3;s:49:"forum/topic/11/regles-du-serveur-rustyfrance.html";i:4;s:18:"avertissement.html";i:5;s:10:"forum.html";i:6;s:31:"forum/48/regles-du-serveur.html";i:7;s:49:"forum/topic/11/regles-du-serveur-rustyfrance.html";}s:9:"time_zone";s:6:"+02:00";}s:6:"alerts";a:6:{i:0;a:2:{s:7:"message";s:50:"<h4 class="alert-heading">Succes</h4>Sujet ajoutÃ©";s:4:"type";s:5:"error";}i:1;a:2:{s:7:"message";s:50:"<h4 class="alert-heading">Succes</h4>Sujet ajoutÃ©";s:4:"type";s:5:"error";}i:2;a:2:{s:7:"message";s:50:"<h4 class="alert-heading">Succes</h4>Sujet ajoutÃ©";s:4:"type";s:5:"error";}i:3;a:2:{s:7:"message";s:50:"<h4 class="alert-heading">Succes</h4>Sujet ajoutÃ©";s:4:"type";s:5:"error";}i:4;a:2:{s:7:"message";s:50:"<h4 class="alert-heading">Succes</h4>Sujet ajoutÃ©";s:4:"type";s:5:"error";}i:5;a:2:{s:7:"message";s:50:"<h4 class="alert-heading">Succes</h4>Sujet ajoutÃ©";s:4:"type";s:5:"error";}}s:11:"live_editor";s:2:"17";}', '1'),
1090('mhl5mq8jgfktxjztlcwbqeqsgygxmbry', '176.156.69.77', '176.156.69.77', 5, '0', '2016-05-01 23:13:28', 'a:1:{s:7:"session";a:6:{s:4:"date";i:1462142806;s:10:"javascript";b:1;s:7:"referer";s:0:"";s:10:"user_agent";s:127:"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/46.0.2486.0 Safari/537.36 Edge/13.10586";s:7:"history";a:2:{i:0;s:10:"index.html";i:1;s:14:"user/edit.html";}s:9:"time_zone";s:6:"+02:00";}}', '1'),
1091('n21ctnrjwbucf6gsltjjlxk7jqw3bvy2', '176.151.109.159', 'elb76-h02-176-151-109-159.dsl.sta.abo.bbox.fr', 3, '0', '2016-05-05 21:09:31', 'a:2:{s:7:"session";a:6:{s:4:"date";i:1462441934;s:10:"javascript";b:1;s:7:"referer";s:0:"";s:10:"user_agent";s:108:"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safari/537.36";s:7:"history";a:1:{i:0;s:10:"index.html";}s:9:"time_zone";s:6:"+02:00";}s:11:"live_editor";s:2:"17";}', '1'),
1092('o47pksbiu0mot7c648isqnm9yxe7jukq', '90.1.142.33', 'ALille-651-1-143-33.w90-1.abo.wanadoo.fr', NULL, '0', '2016-05-08 00:11:28', 'a:1:{s:7:"session";a:5:{s:4:"date";i:1462666288;s:10:"javascript";b:0;s:7:"referer";s:0:"";s:10:"user_agent";s:27:"TeamSpeak3-ImageFetcher-1.0";s:7:"history";a:1:{i:0;s:10:"index.html";}}}', '0'),
1093('q0kvhj7y039wvpi6o4p5hbr66s5dqpuc', '176.151.109.159', 'elb76-h02-176-151-109-159.dsl.sta.abo.bbox.fr', 3, '0', '2016-05-01 23:07:04', 'a:1:{s:7:"session";a:6:{s:4:"date";i:1462102254;s:10:"javascript";b:1;s:7:"referer";s:0:"";s:10:"user_agent";s:108:"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safari/537.36";s:7:"history";a:1:{i:0;s:10:"index.html";}s:9:"time_zone";s:6:"+02:00";}}', '1'),
1094('rfukgeifjw4q4wgfvk0tpo0n6sw4oyt8', '80.12.58.30', '80.12.58.30', 4, '0', '2016-05-02 09:43:39', 'a:1:{s:7:"session";a:6:{s:4:"date";i:1462178513;s:10:"javascript";b:1;s:7:"referer";s:0:"";s:10:"user_agent";s:143:"Mozilla/5.0 (iPhone; CPU iPhone OS 9_3_1 like Mac OS X) AppleWebKit/600.1.4 (KHTML, like Gecko) GSA/14.1.119979954 Mobile/13E238 Safari/600.1.4";s:7:"history";a:2:{i:0;s:10:"index.html";i:1;s:10:"teams.html";}s:9:"time_zone";s:6:"+02:00";}}', '1'),
1095('rjd48ihfm6sy6siyyb71mlhfxx5gmpjw', '109.222.57.2', 'APoitiers-655-1-473-2.w109-222.abo.wanadoo.fr', 4, '0', '2016-05-05 15:24:26', 'a:1:{s:7:"session";a:6:{s:4:"date";i:1462436171;s:10:"javascript";b:1;s:7:"referer";s:0:"";s:10:"user_agent";s:72:"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:45.0) Gecko/20100101 Firefox/45.0";s:7:"history";a:1:{i:0;s:10:"index.html";}s:9:"time_zone";s:6:"+02:00";}}', '1'),
1096('ry3vhyybakpmv8zua5d4wz00wsfhlduf', '86.205.14.45', 'ANice-651-1-342-45.w86-205.abo.wanadoo.fr', NULL, '0', '2016-05-08 00:01:42', 'a:1:{s:7:"session";a:5:{s:4:"date";i:1462665255;s:10:"javascript";b:0;s:7:"referer";s:0:"";s:10:"user_agent";s:27:"TeamSpeak3-ImageFetcher-1.0";s:7:"history";a:1:{i:0;s:10:"index.html";}}}', '0'),
1097('su601gnajdgi6y820widmrjczdk7rtwa', '109.222.57.2', 'APoitiers-655-1-473-2.w109-222.abo.wanadoo.fr', 4, '0', '2016-05-02 16:09:35', 'a:1:{s:7:"session";a:6:{s:4:"date";i:1462204651;s:10:"javascript";b:1;s:7:"referer";s:0:"";s:10:"user_agent";s:72:"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:45.0) Gecko/20100101 Firefox/45.0";s:7:"history";a:1:{i:0;s:10:"index.html";}s:9:"time_zone";s:6:"+02:00";}}', '1'),
1098('vxyqzodtnzu1cvq205km3rftvmq9fjdm', '66.249.64.48', 'crawl-66-249-64-48.googlebot.com', NULL, '1', '2016-05-08 00:07:10', 'a:1:{s:7:"session";a:6:{s:4:"date";i:1462665945;s:10:"javascript";b:1;s:7:"referer";s:0:"";s:10:"user_agent";s:72:"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)";s:7:"history";a:1:{i:0;s:30:"members/15/florentincraft.html";}s:9:"time_zone";s:6:"-07:00";}}', '0'),
1099('yjzfge1jsbp0nguwumnvcb4kjchgnmuz', '37.167.119.227', '37.167.119.227', NULL, '0', '2016-05-08 00:26:49', 'a:1:{s:7:"session";a:6:{s:4:"date";i:1462667188;s:10:"javascript";b:1;s:7:"referer";s:0:"";s:10:"user_agent";s:108:"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safari/537.36";s:7:"history";a:3:{i:0;s:10:"index.html";i:1;s:10:"forum.html";i:2;s:31:"forum/48/regles-du-serveur.html";}s:9:"time_zone";s:6:"+02:00";}}', '0'),
1100('yzxw2fzk7cvgzc0afo3tjozyoi7jnhdy', '82.237.134.75', 'eys33-2-82-237-134-75.fbx.proxad.net', NULL, '0', '2016-05-08 00:01:19', 'a:1:{s:7:"session";a:5:{s:4:"date";i:1462665679;s:10:"javascript";b:0;s:7:"referer";s:0:"";s:10:"user_agent";s:27:"TeamSpeak3-ImageFetcher-1.0";s:7:"history";a:1:{i:0;s:10:"index.html";}}}', '0'),
1101('zdc3o9ifg44iuttyimzgzamkp1kmlc70', '85.68.251.176', 'abo-176-251-68.guy.modulonet.fr', NULL, '0', '2016-05-07 23:42:17', 'a:1:{s:7:"session";a:5:{s:4:"date";i:1462661402;s:10:"javascript";b:0;s:7:"referer";s:0:"";s:10:"user_agent";s:27:"TeamSpeak3-ImageFetcher-1.0";s:7:"history";a:1:{i:0;s:10:"index.html";}}}', '0');
1102
1103-- --------------------------------------------------------
1104
1105--
1106-- Structure de la table `nf_sessions_history`
1107--
1108
1109CREATE TABLE IF NOT EXISTS `nf_sessions_history` (
1110  `id` int(10) unsigned NOT NULL,
1111  `session_id` varchar(32) DEFAULT NULL,
1112  `user_id` int(11) unsigned NOT NULL,
1113  `ip_address` varchar(39) NOT NULL,
1114  `host_name` varchar(100) NOT NULL,
1115  `referer` varchar(100) NOT NULL,
1116  `user_agent` varchar(100) NOT NULL,
1117  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
1118) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=utf8;
1119
1120--
1121-- Contenu de la table `nf_sessions_history`
1122--
1123
1124INSERT INTO `nf_sessions_history` (`id`, `session_id`, `user_id`, `ip_address`, `host_name`, `referer`, `user_agent`, `date`) VALUES
1125(7, NULL, 1, '78.231.0.110', 'gue23-1-78-231-0-110.fbx.proxad.net', '', 'Mozilla/5.0 (Windows NT 10.0; WOW64; rv:46.0) Gecko/20100101 Firefox/46.0', '2016-04-30 11:51:25'),
1126(11, NULL, 1, '78.231.0.110', 'gue23-1-78-231-0-110.fbx.proxad.net', '', 'Mozilla/5.0 (Windows NT 10.0; WOW64; rv:46.0) Gecko/20100101 Firefox/46.0', '2016-04-30 13:28:55'),
1127(18, NULL, 1, '78.231.0.110', 'gue23-1-78-231-0-110.fbx.proxad.net', '', 'Mozilla/5.0 (Windows NT 10.0; WOW64; rv:46.0) Gecko/20100101 Firefox/46.0', '2016-04-30 18:30:02'),
1128(20, NULL, 1, '78.231.0.110', 'gue23-1-78-231-0-110.fbx.proxad.net', '', 'Mozilla/5.0 (Windows NT 10.0; WOW64; rv:46.0) Gecko/20100101 Firefox/46.0', '2016-04-30 18:49:21'),
1129(21, NULL, 1, '78.231.0.110', 'gue23-1-78-231-0-110.fbx.proxad.net', '', 'Mozilla/5.0 (Windows NT 10.0; WOW64; rv:46.0) Gecko/20100101 Firefox/46.0', '2016-04-30 21:14:05'),
1130(23, NULL, 1, '78.231.0.110', 'gue23-1-78-231-0-110.fbx.proxad.net', '', 'Mozilla/5.0 (Windows NT 10.0; WOW64; rv:46.0) Gecko/20100101 Firefox/46.0', '2016-04-30 22:19:46'),
1131(24, NULL, 1, '78.231.0.110', 'gue23-1-78-231-0-110.fbx.proxad.net', '', 'Mozilla/5.0 (Windows NT 10.0; WOW64; rv:46.0) Gecko/20100101 Firefox/46.0', '2016-05-01 00:04:41'),
1132(26, NULL, 1, '78.231.0.110', 'gue23-1-78-231-0-110.fbx.proxad.net', '', 'Mozilla/5.0 (Windows NT 10.0; WOW64; rv:46.0) Gecko/20100101 Firefox/46.0', '2016-05-01 13:01:33'),
1133(27, NULL, 1, '78.231.0.110', 'gue23-1-78-231-0-110.fbx.proxad.net', '', 'Mozilla/5.0 (Windows NT 10.0; WOW64; rv:46.0) Gecko/20100101 Firefox/46.0', '2016-05-01 15:16:18'),
1134(28, NULL, 1, '78.231.0.110', 'gue23-1-78-231-0-110.fbx.proxad.net', '', 'Mozilla/5.0 (Windows NT 10.0; WOW64; rv:46.0) Gecko/20100101 Firefox/46.0', '2016-05-01 16:23:05'),
1135(29, NULL, 1, '78.231.0.110', 'gue23-1-78-231-0-110.fbx.proxad.net', '', 'Mozilla/5.0 (Windows NT 10.0; WOW64; rv:46.0) Gecko/20100101 Firefox/46.0', '2016-05-01 16:41:51'),
1136(38, NULL, 1, '78.231.0.110', 'gue23-1-78-231-0-110.fbx.proxad.net', '', 'Mozilla/5.0 (Windows NT 10.0; WOW64; rv:46.0) Gecko/20100101 Firefox/46.0', '2016-05-02 15:00:54'),
1137(42, NULL, 1, '78.231.0.110', 'gue23-1-78-231-0-110.fbx.proxad.net', '', 'Mozilla/5.0 (Windows NT 10.0; WOW64; rv:46.0) Gecko/20100101 Firefox/46.0', '2016-05-03 11:39:22'),
1138(12, NULL, 1, '78.231.0.110', 'gue23-1-78-231-0-110.fbx.proxad.net', 'http://rustyfrance.cluster1.easy-hebergement.net/forum.html', 'Mozilla/5.0 (Windows NT 10.0; WOW64; rv:46.0) Gecko/20100101 Firefox/46.0', '2016-04-30 14:02:22'),
1139(13, NULL, 1, '78.231.0.110', 'gue23-1-78-231-0-110.fbx.proxad.net', 'http://rustyfrance.cluster1.easy-hebergement.net/forum.html', 'Mozilla/5.0 (Windows NT 10.0; WOW64; rv:46.0) Gecko/20100101 Firefox/46.0', '2016-04-30 17:48:08'),
1140(15, NULL, 1, '78.231.0.110', 'gue23-1-78-231-0-110.fbx.proxad.net', 'http://rustyfrance.cluster1.easy-hebergement.net/forum.html', 'Mozilla/5.0 (Windows NT 10.0; WOW64; rv:46.0) Gecko/20100101 Firefox/46.0', '2016-04-30 18:27:24'),
1141(16, NULL, 1, '78.231.0.110', 'gue23-1-78-231-0-110.fbx.proxad.net', 'http://rustyfrance.cluster1.easy-hebergement.net/members.html', 'Mozilla/5.0 (Windows NT 10.0; WOW64; rv:46.0) Gecko/20100101 Firefox/46.0', '2016-04-30 18:28:43'),
1142(1, NULL, 1, '78.231.1.52', 'gue23-1-78-231-1-52.fbx.proxad.net', '', 'Mozilla/5.0 (Windows NT 10.0; WOW64; rv:46.0) Gecko/20100101 Firefox/46.0', '2016-04-28 22:43:54'),
1143(3, NULL, 1, '78.231.1.52', 'gue23-1-78-231-1-52.fbx.proxad.net', '', 'Mozilla/5.0 (Windows NT 10.0; WOW64; rv:46.0) Gecko/20100101 Firefox/46.0', '2016-04-28 23:46:08'),
1144(4, NULL, 3, '176.151.109.159', 'elb76-h02-176-151-109-159.dsl.sta.abo.bbox.fr', '', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safar', '2016-04-29 21:05:37'),
1145(5, NULL, 3, '176.151.109.159', 'elb76-h02-176-151-109-159.dsl.sta.abo.bbox.fr', '', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safar', '2016-04-30 10:18:17'),
1146(6, NULL, 3, '176.151.109.159', 'elb76-h02-176-151-109-159.dsl.sta.abo.bbox.fr', '', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safar', '2016-04-30 11:51:08'),
1147(8, NULL, 3, '176.151.109.159', 'elb76-h02-176-151-109-159.dsl.sta.abo.bbox.fr', '', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safar', '2016-04-30 12:40:45'),
1148(9, NULL, 3, '176.151.109.159', 'elb76-h02-176-151-109-159.dsl.sta.abo.bbox.fr', '', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safar', '2016-04-30 12:45:39'),
1149(10, NULL, 3, '176.151.109.159', 'elb76-h02-176-151-109-159.dsl.sta.abo.bbox.fr', '', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safar', '2016-04-30 12:46:53'),
1150(14, NULL, 3, '176.151.109.159', 'elb76-h02-176-151-109-159.dsl.sta.abo.bbox.fr', '', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safar', '2016-04-30 18:26:41'),
1151(17, NULL, 3, '176.151.109.159', 'elb76-h02-176-151-109-159.dsl.sta.abo.bbox.fr', '', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safar', '2016-04-30 18:28:44'),
1152(19, NULL, 3, '176.151.109.159', 'elb76-h02-176-151-109-159.dsl.sta.abo.bbox.fr', '', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safar', '2016-04-30 18:38:16'),
1153(22, NULL, 3, '176.151.109.159', 'elb76-h02-176-151-109-159.dsl.sta.abo.bbox.fr', '', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safar', '2016-04-30 22:12:42'),
1154(37, NULL, 3, '176.151.109.159', 'elb76-h02-176-151-109-159.dsl.sta.abo.bbox.fr', '', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safar', '2016-05-02 14:45:44'),
1155(41, NULL, 3, '176.151.109.159', 'elb76-h02-176-151-109-159.dsl.sta.abo.bbox.fr', '', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safar', '2016-05-03 10:35:07'),
1156(48, NULL, 3, '176.151.109.159', 'elb76-h02-176-151-109-159.dsl.sta.abo.bbox.fr', '', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safar', '2016-05-05 09:52:26'),
1157(52, NULL, 3, '176.151.109.159', 'elb76-h02-176-151-109-159.dsl.sta.abo.bbox.fr', '', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safar', '2016-05-05 15:17:48'),
1158(66, NULL, 3, '176.151.109.159', 'elb76-h02-176-151-109-159.dsl.sta.abo.bbox.fr', '', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safar', '2016-05-05 21:34:44'),
1159(67, NULL, 3, '176.151.109.159', 'elb76-h02-176-151-109-159.dsl.sta.abo.bbox.fr', '', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safar', '2016-05-05 21:42:43'),
1160(68, NULL, 3, '176.151.109.159', 'elb76-h02-176-151-109-159.dsl.sta.abo.bbox.fr', '', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safar', '2016-05-05 21:43:18'),
1161(69, NULL, 3, '176.151.109.159', 'elb76-h02-176-151-109-159.dsl.sta.abo.bbox.fr', '', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safar', '2016-05-05 23:20:42'),
1162(70, NULL, 3, '176.151.109.159', 'elb76-h02-176-151-109-159.dsl.sta.abo.bbox.fr', '', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safar', '2016-05-06 01:33:53'),
1163(71, NULL, 3, '176.151.109.159', 'elb76-h02-176-151-109-159.dsl.sta.abo.bbox.fr', '', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safar', '2016-05-06 01:34:19'),
1164(72, NULL, 3, '176.151.109.159', 'elb76-h02-176-151-109-159.dsl.sta.abo.bbox.fr', '', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safar', '2016-05-06 01:34:29'),
1165(75, NULL, 3, '176.151.109.159', 'elb76-h02-176-151-109-159.dsl.sta.abo.bbox.fr', '', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safar', '2016-05-07 11:20:41'),
1166(30, NULL, 4, '109.222.57.2', 'APoitiers-655-1-473-2.w109-222.abo.wanadoo.fr', '', 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:45.0) Gecko/20100101 Firefox/45.0', '2016-05-01 22:23:01'),
1167(47, NULL, 4, '109.222.57.2', 'APoitiers-655-1-473-2.w109-222.abo.wanadoo.fr', '', 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:45.0) Gecko/20100101 Firefox/45.0', '2016-05-05 08:16:54'),
1168(31, NULL, 5, '176.156.69.77', '176.156.69.77', '', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/46.0.2486.0 ', '2016-05-01 22:24:34'),
1169(33, NULL, 6, '109.219.112.3', 'AAmiens-651-1-73-3.w109-219.abo.wanadoo.fr', '', 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_2 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Versi', '2016-05-01 22:27:28'),
1170(35, NULL, 7, '90.54.75.205', 'ANantes-159-1-36-205.w90-54.abo.wanadoo.fr', '', 'Mozilla/5.0 (Windows NT 10.0; WOW64; rv:46.0) Gecko/20100101 Firefox/46.0', '2016-05-02 08:44:37'),
1171(40, NULL, 8, '78.247.165.178', 'blw68-1-78-247-165-178.fbx.proxad.net', '', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safa', '2016-05-02 17:14:26'),
1172(44, NULL, 9, '91.180.49.6', '6.49-180-91.adsl-dyn.isp.belgacom.be', '', 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:45.0) Gecko/20100101 Firefox/45.0', '2016-05-04 19:22:13'),
1173(45, NULL, 10, '88.140.159.241', '241.159.140.88.rev.sfr.net', '', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.75 Safa', '2016-05-04 20:20:26'),
1174(46, NULL, 11, '92.153.112.233', 'AMarseille-653-1-25-233.w92-153.abo.wanadoo.fr', '', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safa', '2016-05-05 08:11:17'),
1175(49, NULL, 12, '92.106.65.157', '157.65.106.92.dynamic.wline.res.cust.swisscom.ch', '', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safa', '2016-05-05 11:00:54'),
1176(50, NULL, 13, '109.88.216.45', 'host-109-88-216-45.dynamic.voo.be', '', 'Mozilla/5.0 (Windows NT 10.0; WOW64; rv:45.0) Gecko/20100101 Firefox/45.0', '2016-05-05 13:17:07'),
1177(53, NULL, 13, '109.88.216.45', 'host-109-88-216-45.dynamic.voo.be', 'http://rustyfrance.fr/forum/26/voir-la-map-en-cours.html', 'Mozilla/5.0 (Windows NT 10.0; WOW64; rv:45.0) Gecko/20100101 Firefox/45.0', '2016-05-05 16:05:46'),
1178(51, NULL, 14, '86.71.171.79', '79.171.71.86.rev.sfr.net', '', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safa', '2016-05-05 13:17:11'),
1179(60, NULL, 14, '86.71.171.79', '79.171.71.86.rev.sfr.net', 'https://www.google.fr/', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safa', '2016-05-05 20:02:18'),
1180(54, NULL, 15, '89.170.0.28', '28.0.170.89.rev.sfr.net', '', 'Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safar', '2016-05-05 16:12:20'),
1181(55, NULL, 16, '92.133.169.59', 'AMontpellier-653-1-441-59.w92-133.abo.wanadoo.fr', '', 'Mozilla/5.0 (Windows NT 10.0; WOW64; rv:45.0) Gecko/20100101 Firefox/45.0', '2016-05-05 16:21:29'),
1182(56, NULL, 17, '92.155.138.102', 'ALille-656-1-205-102.w92-155.abo.wanadoo.fr', 'http://r.search.yahoo.com/_ylt=A9mSs2JOcytXNR8AeWBjAQx.;_ylu=X3oDMTByMnE1MzMwBGNvbG8DaXIyBHBvcwMzBHZ', 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:45.0) Gecko/20100101 Firefox/45.0', '2016-05-05 16:24:26'),
1183(57, NULL, 18, '85.2.244.217', '217.244.2.85.dynamic.wline.res.cust.swisscom.ch', '', 'Mozilla/5.0 (Windows NT 10.0; WOW64; rv:45.0) Gecko/20100101 Firefox/45.0', '2016-05-05 19:08:17'),
1184(58, NULL, 19, '93.24.58.71', '71.58.24.93.rev.sfr.net', '', 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:45.0) Gecko/20100101 Firefox/45.0', '2016-05-05 19:11:43'),
1185(59, NULL, 20, '85.0.117.212', '212.117.0.85.dynamic.wline.res.cust.swisscom.ch', 'https://www.bing.com/', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/46.0.2486.0 ', '2016-05-05 19:11:59'),
1186(61, NULL, 21, '109.215.214.242', 'APoitiers-652-1-295-242.w109-215.abo.wanadoo.fr', 'https://www.google.fr/', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safa', '2016-05-05 20:16:08'),
1187(62, NULL, 22, '90.120.131.179', 'LFbn-1-6694-179.w90-120.abo.wanadoo.fr', 'https://www.google.fr/', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safar', '2016-05-05 20:57:07'),
1188(63, NULL, 23, '88.125.17.85', 'chn25-1-88-125-17-85.fbx.proxad.net', '', 'Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safar', '2016-05-05 21:09:31'),
1189(64, NULL, 24, '90.28.211.236', 'AMontpellier-656-1-339-236.w90-28.abo.wanadoo.fr', 'https://www.google.fr/', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safar', '2016-05-05 21:29:55'),
1190(65, NULL, 25, '82.237.134.75', 'eys33-2-82-237-134-75.fbx.proxad.net', '', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safar', '2016-05-05 21:34:06'),
1191(74, NULL, 26, '109.129.47.250', '109.129.47.250', '', 'Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safar', '2016-05-06 22:26:39'),
1192(43, 'dsmckpqkkurnonazzhbdagmab2yzwooo', 4, '109.222.57.2', 'APoitiers-655-1-473-2.w109-222.abo.wanadoo.fr', '', 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:45.0) Gecko/20100101 Firefox/45.0', '2016-05-03 17:53:44'),
1193(73, 'ipx2hiyrtobgfl8ihdwnp8l73fsilfag', 8, '78.247.165.178', 'blw68-1-78-247-165-178.fbx.proxad.net', '', 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safa', '2016-05-06 14:56:09'),
1194(34, 'mhl5mq8jgfktxjztlcwbqeqsgygxmbry', 5, '176.156.69.77', '176.156.69.77', '', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/46.0.2486.0 ', '2016-05-01 22:50:27'),
1195(25, 'q0kvhj7y039wvpi6o4p5hbr66s5dqpuc', 3, '176.151.109.159', 'elb76-h02-176-151-109-159.dsl.sta.abo.bbox.fr', '', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safar', '2016-05-01 11:31:18'),
1196(32, 'q0kvhj7y039wvpi6o4p5hbr66s5dqpuc', 3, '176.151.109.159', 'elb76-h02-176-151-109-159.dsl.sta.abo.bbox.fr', '', 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/50.0.2661.94 Safar', '2016-05-01 22:26:49'),
1197(36, 'rfukgeifjw4q4wgfvk0tpo0n6sw4oyt8', 4, '80.12.58.30', '80.12.58.30', '', 'Mozilla/5.0 (iPhone; CPU iPhone OS 9_3_1 like Mac OS X) AppleWebKit/600.1.4 (KHTML, like Gecko) GSA/', '2016-05-02 09:41:24'),
1198(39, 'su601gnajdgi6y820widmrjczdk7rtwa', 4, '109.222.57.2', 'APoitiers-655-1-473-2.w109-222.abo.wanadoo.fr', '', 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:45.0) Gecko/20100101 Firefox/45.0', '2016-05-02 15:58:43');
1199
1200-- --------------------------------------------------------
1201
1202--
1203-- Structure de la table `nf_settings`
1204--
1205
1206CREATE TABLE IF NOT EXISTS `nf_settings` (
1207  `name` varchar(100) NOT NULL,
1208  `site` varchar(100) NOT NULL DEFAULT '',
1209  `lang` varchar(5) NOT NULL DEFAULT '',
1210  `value` text NOT NULL,
1211  `type` enum('string','bool','int','list','array','float') NOT NULL DEFAULT 'string'
1212) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1213
1214--
1215-- Contenu de la table `nf_settings`
1216--
1217
1218INSERT INTO `nf_settings` (`name`, `site`, `lang`, `value`, `type`) VALUES
1219('default_background', '', '', '18', 'int'),
1220('default_background_attachment', '', '', 'scroll', 'string'),
1221('default_background_color', '', '', '#000000', 'string'),
1222('default_background_position', '', '', 'left top', 'string'),
1223('default_background_repeat', '', '', 'no-repeat', 'string'),
1224('forum_messages_per_page', '', '', '15', 'int'),
1225('forum_topics_per_page', '', '', '20', 'int'),
1226('news_per_page', '', '', '5', 'int'),
1227('nf_analytics', '', '', '', 'string'),
1228('nf_contact', '', '', 'rustyfrance@outlook.fr', 'string'),
1229('nf_cookie_expire', '', '', '1 hour', 'string'),
1230('nf_cookie_name', '', '', 'nf_session', 'string'),
1231('nf_debug', '', '', '0', 'int'),
1232('nf_default_language', '', '', 'fr', 'string'),
1233('nf_default_page', 'default', '', 'news', 'string'),
1234('nf_default_theme', 'default', '', 'default', 'string'),
1235('nf_description', 'default', '', 'Bienvenue sur notre site web !', 'string'),
1236('nf_humans_txt', '', '', 'NeoFrag CMS for RustyFrance\r\n	Contact: rustyfrance@outlook.fr\r\n	From: France', 'string'),
1237('nf_maintenance', '', '', '0', 'bool'),
1238('nf_maintenance_background', '', '', '14', 'int'),
1239('nf_maintenance_background_color', '', '', '#ffffff', 'string'),
1240('nf_maintenance_background_position', '', '', 'center center', 'string'),
1241('nf_maintenance_background_repeat', '', '', 'no-repeat', 'string'),
1242('nf_maintenance_content', '', '', '[center][size=150]\r\nR&eacute;-ouverture du site d''ici quelques minutes.\r\n- R&eacute;-organisation des droits du forum ainsi que sa disposition\r\n\r\nd&eacute;sol&eacute; pour la gene occasionn&eacute;e[/size][/center]', 'string'),
1243('nf_maintenance_facebook', '', '', '', 'string'),
1244('nf_maintenance_google-plus', '', '', '', 'string'),
1245('nf_maintenance_logo', '', '', '19', 'int'),
1246('nf_maintenance_opening', '', '', '', 'string'),
1247('nf_maintenance_steam', '', '', 'http://steamcommunity.com/id/Fouzii/', 'string'),
1248('nf_maintenance_text_color', '', '', '', 'string'),
1249('nf_maintenance_title', '', '', 'SITE EN COURS DE MAINTENANCE', 'string'),
1250('nf_maintenance_twitch', '', '', '', 'string'),
1251('nf_maintenance_twitter', '', '', '', 'string'),
1252('nf_name', 'default', '', 'RustyFrance', 'string'),
1253('nf_robots_txt', '', '', 'User-Agent: *    \r\nDisallow:', 'string');
1254
1255-- --------------------------------------------------------
1256
1257--
1258-- Structure de la table `nf_settings_addons`
1259--
1260
1261CREATE TABLE IF NOT EXISTS `nf_settings_addons` (
1262  `name` varchar(100) NOT NULL,
1263  `type` enum('module','theme','widget') NOT NULL,
1264  `enable` enum('0','1') NOT NULL DEFAULT '0'
1265) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1266
1267--
1268-- Contenu de la table `nf_settings_addons`
1269--
1270
1271INSERT INTO `nf_settings_addons` (`name`, `type`, `enable`) VALUES
1272('access', 'module', '1'),
1273('admin', 'module', '1'),
1274('breadcrumb', 'widget', '1'),
1275('comments', 'module', '1'),
1276('contact', 'module', '1'),
1277('default', 'theme', '1'),
1278('donation', 'module', '1'),
1279('donation', 'widget', '1'),
1280('error', 'module', '1'),
1281('forum', 'module', '1'),
1282('forum', 'widget', '1'),
1283('gallery', 'module', '1'),
1284('gallery', 'widget', '1'),
1285('games', 'module', '1'),
1286('header', 'widget', '1'),
1287('html', 'widget', '1'),
1288('live_editor', 'module', '1'),
1289('members', 'module', '1'),
1290('members', 'widget', '1'),
1291('module', 'widget', '1'),
1292('navigation', 'widget', '1'),
1293('news', 'module', '1'),
1294('news', 'widget', '1'),
1295('nserv', 'widget', '1'),
1296('pages', 'module', '1'),
1297('search', 'module', '1'),
1298('settings', 'module', '1'),
1299('slider', 'widget', '1'),
1300('steam', 'widget', '1'),
1301('talks', 'module', '1'),
1302('talks', 'widget', '1'),
1303('teams', 'module', '1'),
1304('teams', 'widget', '1'),
1305('ts3viewerv2', 'widget', '1'),
1306('user', 'module', '1'),
1307('user', 'widget', '1');
1308
1309-- --------------------------------------------------------
1310
1311--
1312-- Structure de la table `nf_settings_languages`
1313--
1314
1315CREATE TABLE IF NOT EXISTS `nf_settings_languages` (
1316  `language_id` int(11) unsigned NOT NULL,
1317  `code` varchar(5) NOT NULL,
1318  `domain_extension` varchar(6) NOT NULL,
1319  `name` varchar(100) NOT NULL,
1320  `flag` varchar(100) NOT NULL,
1321  `order` smallint(6) unsigned NOT NULL
1322) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
1323
1324--
1325-- Contenu de la table `nf_settings_languages`
1326--
1327
1328INSERT INTO `nf_settings_languages` (`language_id`, `code`, `domain_extension`, `name`, `flag`, `order`) VALUES
1329(1, 'fr', '.fr', 'FranÃ§ais', 'fr.png', 1),
1330(2, 'en', '.com', 'English', 'gb.png', 2),
1331(3, 'de', '.de', 'Deutsch', 'de.png', 3),
1332(4, 'es', '.es', 'EspaÃ±ol', 'es.png', 4),
1333(5, 'it', '.it', 'Italiano', 'it.png', 5),
1334(6, 'pt', '.pt', 'PortuguÃªs', 'pt.png', 6);
1335
1336-- --------------------------------------------------------
1337
1338--
1339-- Structure de la table `nf_settings_smileys`
1340--
1341
1342CREATE TABLE IF NOT EXISTS `nf_settings_smileys` (
1343  `smiley_id` int(11) unsigned NOT NULL,
1344  `file_id` int(11) unsigned NOT NULL,
1345  `code` varchar(15) NOT NULL
1346) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1347
1348-- --------------------------------------------------------
1349
1350--
1351-- Structure de la table `nf_statistics`
1352--
1353
1354CREATE TABLE IF NOT EXISTS `nf_statistics` (
1355  `name` varchar(100) NOT NULL,
1356  `value` text NOT NULL
1357) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1358
1359--
1360-- Contenu de la table `nf_statistics`
1361--
1362
1363INSERT INTO `nf_statistics` (`name`, `value`) VALUES
1364('nf_sessions_max_simultaneous', '17');
1365
1366-- --------------------------------------------------------
1367
1368--
1369-- Structure de la table `nf_talks`
1370--
1371
1372CREATE TABLE IF NOT EXISTS `nf_talks` (
1373  `talk_id` int(11) unsigned NOT NULL,
1374  `name` varchar(50) NOT NULL
1375) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
1376
1377--
1378-- Contenu de la table `nf_talks`
1379--
1380
1381INSERT INTO `nf_talks` (`talk_id`, `name`) VALUES
1382(1, 'admin'),
1383(4, 'Membres');
1384
1385-- --------------------------------------------------------
1386
1387--
1388-- Structure de la table `nf_talks_messages`
1389--
1390
1391CREATE TABLE IF NOT EXISTS `nf_talks_messages` (
1392  `message_id` int(10) unsigned NOT NULL,
1393  `talk_id` int(10) unsigned NOT NULL,
1394  `user_id` int(10) unsigned DEFAULT NULL,
1395  `message` text,
1396  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
1397) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
1398
1399--
1400-- Contenu de la table `nf_talks_messages`
1401--
1402
1403INSERT INTO `nf_talks_messages` (`message_id`, `talk_id`, `user_id`, `message`, `date`) VALUES
1404(7, 2, 3, NULL, '2016-04-30 13:33:18'),
1405(8, 2, 3, NULL, '2016-04-30 13:42:56'),
1406(9, 2, 1, NULL, '2016-04-30 14:09:52'),
1407(10, 2, 1, NULL, '2016-04-30 14:10:14'),
1408(11, 2, 3, 'yo', '2016-04-30 14:10:22'),
1409(12, 2, 1, 'ddd', '2016-04-30 14:10:48');
1410
1411-- --------------------------------------------------------
1412
1413--
1414-- Structure de la table `nf_teams`
1415--
1416
1417CREATE TABLE IF NOT EXISTS `nf_teams` (
1418  `team_id` int(11) unsigned NOT NULL,
1419  `game_id` int(11) unsigned NOT NULL,
1420  `image_id` int(11) unsigned DEFAULT NULL,
1421  `icon_id` int(11) unsigned DEFAULT NULL,
1422  `name` varchar(100) NOT NULL,
1423  `order` smallint(6) unsigned NOT NULL
1424) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
1425
1426--
1427-- Contenu de la table `nf_teams`
1428--
1429
1430INSERT INTO `nf_teams` (`team_id`, `game_id`, `image_id`, `icon_id`, `name`, `order`) VALUES
1431(1, 2, 10, 9, 'rust', 0);
1432
1433-- --------------------------------------------------------
1434
1435--
1436-- Structure de la table `nf_teams_lang`
1437--
1438
1439CREATE TABLE IF NOT EXISTS `nf_teams_lang` (
1440  `team_id` int(11) unsigned NOT NULL,
1441  `lang` varchar(5) NOT NULL,
1442  `title` varchar(100) NOT NULL,
1443  `description` text NOT NULL
1444) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1445
1446--
1447-- Contenu de la table `nf_teams_lang`
1448--
1449
1450INSERT INTO `nf_teams_lang` (`team_id`, `lang`, `title`, `description`) VALUES
1451(1, 'fr', 'Rust', '');
1452
1453-- --------------------------------------------------------
1454
1455--
1456-- Structure de la table `nf_teams_roles`
1457--
1458
1459CREATE TABLE IF NOT EXISTS `nf_teams_roles` (
1460  `role_id` int(10) unsigned NOT NULL,
1461  `title` varchar(100) NOT NULL,
1462  `order` smallint(6) unsigned NOT NULL
1463) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
1464
1465--
1466-- Contenu de la table `nf_teams_roles`
1467--
1468
1469INSERT INTO `nf_teams_roles` (`role_id`, `title`, `order`) VALUES
1470(1, 'Administrateur', 0),
1471(2, 'Joueur', 0);
1472
1473-- --------------------------------------------------------
1474
1475--
1476-- Structure de la table `nf_teams_users`
1477--
1478
1479CREATE TABLE IF NOT EXISTS `nf_teams_users` (
1480  `team_id` int(11) unsigned NOT NULL,
1481  `user_id` int(11) unsigned NOT NULL,
1482  `role_id` int(10) unsigned DEFAULT NULL
1483) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1484
1485--
1486-- Contenu de la table `nf_teams_users`
1487--
1488
1489INSERT INTO `nf_teams_users` (`team_id`, `user_id`, `role_id`) VALUES
1490(1, 1, 1),
1491(1, 3, 1),
1492(1, 4, 1),
1493(1, 5, 2),
1494(1, 6, 2),
1495(1, 7, 2),
1496(1, 8, 2),
1497(1, 9, 2),
1498(1, 10, 2),
1499(1, 11, 2),
1500(1, 12, 2),
1501(1, 13, 2),
1502(1, 14, 2),
1503(1, 15, 2),
1504(1, 16, 2),
1505(1, 17, 2),
1506(1, 18, 2),
1507(1, 19, 2),
1508(1, 20, 2),
1509(1, 21, 2),
1510(1, 22, 2),
1511(1, 23, 2),
1512(1, 24, 2),
1513(1, 25, 2);
1514
1515-- --------------------------------------------------------
1516
1517--
1518-- Structure de la table `nf_users`
1519--
1520
1521CREATE TABLE IF NOT EXISTS `nf_users` (
1522  `user_id` int(11) unsigned NOT NULL,
1523  `username` varchar(100) NOT NULL,
1524  `password` varchar(34) NOT NULL,
1525  `salt` varchar(32) NOT NULL,
1526  `email` varchar(100) NOT NULL,
1527  `registration_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1528  `last_activity_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
1529  `admin` enum('0','1') NOT NULL DEFAULT '0',
1530  `theme` varchar(100) DEFAULT NULL,
1531  `language` varchar(5) DEFAULT NULL,
1532  `deleted` enum('0','1') NOT NULL DEFAULT '0'
1533) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;
1534
1535--
1536-- Contenu de la table `nf_users`
1537--
1538
1539INSERT INTO `nf_users` (`user_id`, `username`, `password`, `salt`, `email`, `registration_date`, `last_activity_date`, `admin`, `theme`, `language`, `deleted`) VALUES
1540(1, 'Fouzii', '$P$BJG/.ZDVCVEXwoKFWn6sx/FxeGoJ6S/', 'eg5wovuk2ypwdonjgru9j2sptmusdly5', 'Gabriel.GDO@hotmail.fr', '2016-04-28 22:16:28', '2016-05-08 00:41:47', '1', NULL, NULL, '0'),
1541(3, 'Virus_Gamers', '$P$BVrHe/M7AvW3WEd8k8E/KkVIYvyWrl.', 'ecdd9o0mtczig4owltxxl011ilf4j130', 'doudouledu76320@hotmail.fr', '2016-04-29 21:05:37', '2016-05-07 21:22:49', '1', NULL, NULL, '0'),
1542(4, 'Hocine', '$P$Bqj5iUWCvFPIE6cuIapO.ANdNVMzUS0', 'gnr0bvzekqktavgyfklpinwpeky2vru9', 'tarmaz872@gmail.com', '2016-05-01 22:23:01', '2016-05-05 15:24:26', '1', NULL, NULL, '0'),
1543(5, 'blasteur9600', '$P$BeF5iMOyI0SwbUMuLMCoc0ynr2i5DF1', 'vezchvyo2prbpcdsvl6rbnubydc8rkkg', 'elodienoa9609@gmail.com', '2016-05-01 22:24:33', '2016-05-01 23:13:28', '0', NULL, NULL, '0'),
1544(6, 'zRiskinz', '$P$BL6O2rJ2EY8Jdbpe9tzfi1l6cf38.z0', 'wuenyhditcqhk76bvn8l68ouzbr6dif0', 'tytgatliam53@gmail.com', '2016-05-01 22:27:28', '2016-05-01 22:48:41', '0', NULL, NULL, '0'),
1545(7, 'ToXiiK', '$P$BaOyVK8J1.utbqVEFZmIHdgbpBf8fo0', 'dnbeeovgzal8xyze2r6npuomowd00eqq', 'thetoxiik72@gmail.com', '2016-05-02 08:44:37', '2016-05-02 08:45:29', '0', NULL, NULL, '0'),
1546(8, 'youtube florian Mul68', '$P$B.jdfPXfXNjX5KHGQaIgRIoUt4mnNF0', '9lvxcpbbm0qm9uxg0zmrggx9uor2w9ci', 'florian.mul@free.fr', '2016-05-02 17:14:26', '2016-05-06 14:56:10', '0', NULL, NULL, '0'),
1547(9, 'lesreglesfdp', '$P$BtjOmIbSGP8og774MmvcGMfoQWr3At.', 'tvik8jug1b9f7rksedfxfdt86joktwm7', 'fraise@yopmail.com', '2016-05-04 19:22:13', '2016-05-04 19:23:18', '0', NULL, NULL, '0'),
1548(10, 'Everbbq', '$P$B/Kd30KyDjmCNDeo3Iqi0wnifQ2adb0', '3sw3o30daayjwwcespgsu2xddzdldc7f', 'antonin240@live.fr', '2016-05-04 20:20:26', '2016-05-04 20:22:06', '0', NULL, NULL, '0'),
1549(11, 'M0RBH0UCK', '$P$Bn83qjT4kQuttPycYr8.4XSdauWEDo0', 'qwmlhkzlwgytjtbzhda92zf0ppdawset', 'Jasondu84@netcourrier.com', '2016-05-05 08:11:17', '2016-05-05 08:18:59', '0', NULL, NULL, '0'),
1550(12, 'Choka', '$P$BHxo.Bh6fXXaRCZNH17fy0W9U7YArV.', 'hpb39ug7kndixby00e0zps6rweelvf1s', 'marekhoffmeyer@hotmail.com', '2016-05-05 11:00:54', '2016-05-05 11:01:25', '0', NULL, NULL, '0'),
1551(13, 'yannce1400', '$P$BmlacYe.CfmitnFNl2CbuYL5zzYytw0', 'uo9aowd0hdlns7anobuusupnsj0a7apt', 'yannceline10@hotmail.com', '2016-05-05 13:17:07', '2016-05-07 02:00:45', '0', NULL, NULL, '0'),
1552(14, 'Razen', '$P$Bq0He9ll2bBH.X4H06mxj6kQNesXv80', 'h3cocvatuffbwdvyywqe3h0mjbehckhy', 'julienclainbousquet@gmail.com', '2016-05-05 13:17:11', '2016-05-05 22:51:38', '0', NULL, NULL, '0'),
1553(15, 'FlorentinCraft', '$P$BsJVyfmCf3zHEK2j0m/nUCvmlusMNL0', 'jq0jdh6z8iwxv30twq6lbgwiyjyldsmo', 'florentincraft@gmail.com', '2016-05-05 16:12:20', '2016-05-05 16:13:28', '0', NULL, NULL, '0'),
1554(16, 'MAKINACORE', '$P$BhHaM4rxrtcdjhYFxEb96T/f8cax2p/', 'l3tdhs3ovrvo2f5jh8jy2ob4rgvdmmdl', 'MAKINACORE@ORANGE.FR', '2016-05-05 16:21:29', '2016-05-05 16:22:39', '0', NULL, NULL, '0'),
1555(17, 'sonryan59', '$P$BFCSBZhizdsyAp10s/EJB4IpBQctdw/', 'w0v7niqrhdepmgxdmbsnaaofhdvdrxs2', 'sunryan59@gmail.com', '2016-05-05 16:24:26', '2016-05-05 16:24:43', '0', NULL, NULL, '0'),
1556(18, 'hytek', '$P$B8pb2vZJKGdrdbzBT2gsOyeSoK6yqR0', '2j3uytc4duagifwe43kusdjtgdhapdrh', 'toan.mendes@gmail.com', '2016-05-05 19:08:17', '2016-05-06 01:30:05', '0', NULL, NULL, '0'),
1557(19, 'tahmer', '$P$BfVIQQJyOcvXV743Etk2M2Op2Giquv.', 'h8xcnfimymw10eylryipvuflehzekcui', 'lotharinass@hotmail.com', '2016-05-05 19:11:43', '2016-05-06 00:12:49', '0', NULL, NULL, '0'),
1558(20, 'RomainRust', '$P$BP99AyzYpNBtI8V/wY.BQwgWl7l0r11', 'fesekydbg9dbvnj9aa51xy3bzup8sx6r', 'humair.romain@outlook.com', '2016-05-05 19:11:59', '2016-05-05 19:50:47', '0', NULL, NULL, '0'),
1559(21, 'davidrise', '$P$BtZPlMwOSd6lUsbjcFhvkYtHrK0N270', '3cdzotrgmqfeci0ssz8lkkxxotcj3m62', 'gardien987@orange.fr', '2016-05-05 20:16:08', '2016-05-05 20:16:59', '0', NULL, NULL, '0'),
1560(22, 'LSDsushi', '$P$ByTZWQ44Zb09VHm6NrFzt5qZJpmaSf1', '2rovcouivuhchfiumouvzur6wzze5ukh', 'vince-soad@hotmail.fr', '2016-05-05 20:57:07', '2016-05-05 20:57:37', '0', NULL, NULL, '0'),
1561(23, 'thomece', '$P$BLvP/c9p6s7/jN8BOdcxcno.0OC35y0', 'lrbg6geg33zbqd4nhxgengqglwsgdqb6', 'thomece@hotmail.fr', '2016-05-05 21:09:31', '2016-05-05 21:10:11', '0', NULL, NULL, '0'),
1562(24, 'Xquette', '$P$BatJPpbk9NPVFv87ri.lsLgUjR7inG1', 'utppycgcpxo4kwtwjghrj3dq608ikbyn', 'Aldaril66@hotmail.fr', '2016-05-05 21:29:55', '2016-05-05 21:31:03', '0', NULL, NULL, '0'),
1563(25, 'evilsensei', '$P$BjRyXq.kxpw1ooh3VTWyY8EEbjztUT0', '5a4ikcuck085qbbhztmtaruhshlriipy', 'henry31150@hotmail.fr', '2016-05-05 21:34:06', '2016-05-06 01:18:57', '0', NULL, NULL, '0'),
1564(26, 'Zoid', '$P$B5NT/4AOqSyrt3Sx09ie0tUIWgUXra1', 'm0njdugzeotijyzndgxcdfhmh3ozq2n2', 'bertha.002@hotmail.fr', '2016-05-06 22:26:39', '2016-05-06 22:36:47', '0', NULL, NULL, '0');
1565
1566-- --------------------------------------------------------
1567
1568--
1569-- Structure de la table `nf_users_groups`
1570--
1571
1572CREATE TABLE IF NOT EXISTS `nf_users_groups` (
1573  `user_id` int(11) unsigned NOT NULL,
1574  `group_id` int(11) unsigned NOT NULL
1575) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1576
1577-- --------------------------------------------------------
1578
1579--
1580-- Structure de la table `nf_users_keys`
1581--
1582
1583CREATE TABLE IF NOT EXISTS `nf_users_keys` (
1584  `key_id` varchar(32) NOT NULL,
1585  `user_id` int(11) unsigned NOT NULL,
1586  `session_id` varchar(32) NOT NULL,
1587  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
1588) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1589
1590-- --------------------------------------------------------
1591
1592--
1593-- Structure de la table `nf_users_messages`
1594--
1595
1596CREATE TABLE IF NOT EXISTS `nf_users_messages` (
1597  `message_id` int(11) unsigned NOT NULL,
1598  `user_id` int(11) unsigned NOT NULL,
1599  `title` varchar(100) NOT NULL,
1600  `content` text NOT NULL,
1601  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
1602) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1603
1604-- --------------------------------------------------------
1605
1606--
1607-- Structure de la table `nf_users_messages_recipients`
1608--
1609
1610CREATE TABLE IF NOT EXISTS `nf_users_messages_recipients` (
1611  `user_id` int(11) unsigned NOT NULL,
1612  `message_id` int(11) unsigned NOT NULL,
1613  `read` enum('0','1') NOT NULL DEFAULT '0'
1614) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1615
1616-- --------------------------------------------------------
1617
1618--
1619-- Structure de la table `nf_users_messages_replies`
1620--
1621
1622CREATE TABLE IF NOT EXISTS `nf_users_messages_replies` (
1623  `reply_id` int(11) unsigned NOT NULL,
1624  `message_id` int(11) unsigned NOT NULL,
1625  `user_id` int(11) unsigned NOT NULL,
1626  `content` text NOT NULL,
1627  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1628  `read` enum('0','1') NOT NULL DEFAULT '0'
1629) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1630
1631-- --------------------------------------------------------
1632
1633--
1634-- Structure de la table `nf_users_profiles`
1635--
1636
1637CREATE TABLE IF NOT EXISTS `nf_users_profiles` (
1638  `user_id` int(11) unsigned NOT NULL,
1639  `first_name` varchar(100) NOT NULL,
1640  `last_name` varchar(100) NOT NULL,
1641  `avatar` int(11) unsigned DEFAULT NULL,
1642  `signature` text NOT NULL,
1643  `date_of_birth` date NOT NULL,
1644  `sex` enum('male','female') DEFAULT NULL,
1645  `location` varchar(100) NOT NULL,
1646  `quote` varchar(100) NOT NULL,
1647  `website` varchar(100) NOT NULL
1648) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1649
1650--
1651-- Contenu de la table `nf_users_profiles`
1652--
1653
1654INSERT INTO `nf_users_profiles` (`user_id`, `first_name`, `last_name`, `avatar`, `signature`, `date_of_birth`, `sex`, `location`, `quote`, `website`) VALUES
1655(1, '', '', 2, '', '1998-12-16', 'male', 'France', '', ''),
1656(3, '', '', 22, '', '1970-01-01', 'male', '', 'Sa roxe du poney !', 'http://steamcommunity.com/id/Virus_Gamers'),
1657(4, '', '', 92, '', '1998-05-10', 'male', 'Limoges', '', ''),
1658(5, 'theo', 'parfait', NULL, '', '2000-09-06', 'male', 'boue', '', ''),
1659(8, 'florian', 'muller', NULL, '', '1999-09-26', 'male', 'alsace', '', 'https://www.youtube.com/channel/UCDrPEn4Vs_8QEbNN8PmRYYA');
1660
1661-- --------------------------------------------------------
1662
1663--
1664-- Structure de la table `nf_votes`
1665--
1666
1667CREATE TABLE IF NOT EXISTS `nf_votes` (
1668  `module_id` int(11) unsigned NOT NULL,
1669  `module` varchar(100) NOT NULL,
1670  `user_id` int(11) unsigned NOT NULL,
1671  `note` tinyint(4) NOT NULL
1672) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1673
1674-- --------------------------------------------------------
1675
1676--
1677-- Structure de la table `nf_widgets`
1678--
1679
1680CREATE TABLE IF NOT EXISTS `nf_widgets` (
1681  `widget_id` int(11) unsigned NOT NULL,
1682  `widget` varchar(100) NOT NULL,
1683  `type` varchar(100) NOT NULL,
1684  `title` varchar(100) DEFAULT NULL,
1685  `settings` text
1686) ENGINE=InnoDB AUTO_INCREMENT=158 DEFAULT CHARSET=utf8;
1687
1688--
1689-- Contenu de la table `nf_widgets`
1690--
1691
1692INSERT INTO `nf_widgets` (`widget_id`, `widget`, `type`, `title`, `settings`) VALUES
1693(1, 'talks', 'index', NULL, 'a:1:{s:7:"talk_id";s:1:"1";}'),
1694(53, 'module', 'index', NULL, NULL),
1695(61, 'header', 'index', NULL, 'a:5:{s:5:"align";s:11:"text-center";s:5:"title";s:0:"";s:11:"description";s:0:"";s:11:"color-title";s:0:"";s:17:"color-description";s:7:"#DC351E";}'),
1696(62, 'navigation', 'index', NULL, 'a:2:{s:5:"links";a:5:{i:0;a:2:{s:5:"title";s:7:"Accueil";s:3:"url";s:10:"index.html";}i:1;a:2:{s:5:"title";s:5:"Forum";s:3:"url";s:10:"forum.html";}i:2;a:2:{s:5:"title";s:14:"&Eacute;quipes";s:3:"url";s:10:"teams.html";}i:3;a:2:{s:5:"title";s:7:"Membres";s:3:"url";s:12:"members.html";}i:4;a:2:{s:5:"title";s:7:"Contact";s:3:"url";s:12:"contact.html";}}s:7:"display";b:1;}'),
1697(63, 'user', 'index_mini', NULL, NULL),
1698(64, 'navigation', 'index', NULL, 'a:2:{s:5:"links";a:2:{i:0;a:2:{s:5:"title";s:12:"Groupe Steam";s:3:"url";s:45:"http://steamcommunity.com/groups/RustyFrance1";}i:1;a:2:{s:5:"title";s:13:"Avertissement";s:3:"url";s:18:"avertissement.html";}}s:7:"display";b:1;}'),
1699(65, 'members', 'online_mini', NULL, NULL),
1700(66, 'html', 'html', NULL, 'a:1:{s:7:"content";s:311:"<div style="text-align: center;">\r\nPropulsÃ© par <a href="http://www.neofrag.fr">NeoFrag CMS</a> | <a href="http://rustyfrance.fr/mentions-legales.html">Mentions lÃ©gales</a> | <a target="_blank" href="https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=EX6C4JKZFANPC">Nous soutenir</a>\r\n</div>";}'),
1701(67, 'header', 'index', NULL, 'a:5:{s:5:"align";s:11:"text-center";s:5:"title";s:0:"";s:11:"description";s:0:"";s:11:"color-title";s:0:"";s:17:"color-description";s:7:"#DC351E";}'),
1702(68, 'navigation', 'index', NULL, 'a:2:{s:5:"links";a:5:{i:0;a:2:{s:5:"title";s:7:"Accueil";s:3:"url";s:10:"index.html";}i:1;a:2:{s:5:"title";s:5:"Forum";s:3:"url";s:10:"forum.html";}i:2;a:2:{s:5:"title";s:14:"&Eacute;quipes";s:3:"url";s:10:"teams.html";}i:3;a:2:{s:5:"title";s:7:"Membres";s:3:"url";s:12:"members.html";}i:4;a:2:{s:5:"title";s:7:"Contact";s:3:"url";s:12:"contact.html";}}s:7:"display";b:1;}'),
1703(69, 'user', 'index_mini', NULL, NULL),
1704(70, 'slider', 'index', NULL, NULL),
1705(72, 'module', 'index', NULL, NULL),
1706(74, 'module', 'index', NULL, NULL),
1707(77, 'forum', 'statistics', NULL, NULL),
1708(78, 'forum', 'activity', NULL, NULL),
1709(90, 'talks', 'index', NULL, 'a:1:{s:7:"talk_id";s:1:"4";}'),
1710(95, 'module', 'index', NULL, NULL),
1711(96, 'nserv', 'index', NULL, 'a:3:{s:4:"addr";s:13:"13.94.210.247";s:4:"port";s:5:"28015";s:7:"display";N;}'),
1712(97, 'user', 'index', NULL, NULL),
1713(98, 'members', 'online', NULL, NULL),
1714(101, 'members', 'online', NULL, NULL),
1715(102, 'steam', 'index', NULL, 'a:4:{s:5:"group";s:8:"24617109";s:9:"show_knob";s:1:"1";s:12:"show_summary";s:1:"0";s:7:"display";s:7:"compact";}'),
1716(103, 'module', 'index', NULL, NULL),
1717(104, 'members', 'online', NULL, NULL),
1718(105, 'nserv', 'index', NULL, 'a:3:{s:4:"addr";s:13:"13.94.210.247";s:4:"port";s:5:"28015";s:7:"display";N;}'),
1719(106, 'user', 'index', NULL, NULL),
1720(107, 'module', 'index', NULL, NULL),
1721(108, 'members', 'online', NULL, NULL),
1722(109, 'nserv', 'index', NULL, 'a:3:{s:4:"addr";s:13:"13.94.210.247";s:4:"port";s:5:"28015";s:7:"display";N;}'),
1723(110, 'user', 'index', NULL, NULL),
1724(111, 'module', 'index', NULL, NULL),
1725(112, 'members', 'online', NULL, NULL),
1726(113, 'nserv', 'index', NULL, 'a:3:{s:4:"addr";s:13:"13.94.210.247";s:4:"port";s:5:"28015";s:7:"display";N;}'),
1727(114, 'user', 'index', NULL, NULL),
1728(115, 'module', 'index', NULL, NULL),
1729(116, 'members', 'online', NULL, NULL),
1730(117, 'nserv', 'index', NULL, 'a:3:{s:4:"addr";s:13:"13.94.210.247";s:4:"port";s:5:"28015";s:7:"display";N;}'),
1731(118, 'user', 'index', NULL, NULL),
1732(119, 'module', 'index', NULL, NULL),
1733(123, 'html', 'html', NULL, 'a:1:{s:7:"content";s:211:"<p style="text-align:center; font-weight: bold; padding: 10px;" class="bg-info">\r\nMerci d''utiliser le formulaire de contact Ã  des fins de partenariat et/ou signalement d''erreur urgente concernant le site.\r\n</p>";}'),
1734(124, 'members', 'online', NULL, NULL),
1735(126, 'user', 'index', NULL, NULL),
1736(127, 'module', 'index', NULL, NULL),
1737(128, 'members', 'online', NULL, NULL),
1738(129, 'nserv', 'index', NULL, 'a:3:{s:4:"addr";s:13:"13.94.210.247";s:4:"port";s:5:"28015";s:7:"display";N;}'),
1739(130, 'user', 'index', NULL, NULL),
1740(131, 'breadcrumb', 'index', NULL, NULL),
1741(132, 'module', 'index', NULL, NULL),
1742(133, 'breadcrumb', 'index', NULL, NULL),
1743(148, 'nserv', 'index', NULL, 'a:3:{s:4:"addr";s:13:"13.94.210.247";s:4:"port";s:5:"28015";s:7:"display";N;}'),
1744(149, 'ts3viewerv2', 'index', NULL, 'a:9:{s:4:"addr";s:13:"164.132.93.40";s:4:"port";s:5:"53589";s:5:"qport";s:4:"2017";s:4:"skin";s:6:"defaut";s:7:"display";b:1;s:12:"displayicons";s:1:"1";s:10:"vieweronly";s:1:"0";s:11:"tabinfoshow";s:1:"1";s:12:"tabadminshow";s:1:"0";}'),
1745(155, 'forum', 'topics', NULL, NULL),
1746(157, 'html', 'html', NULL, 'a:1:{s:7:"content";s:505:"<form align="center" action="https://www.paypal.com/cgi-bin/webscr" method="post" target="_top">\r\n<input type="hidden" name="cmd" value="_s-xclick">\r\n<input type="hidden" name="hosted_button_id" value="RG6D7TBUEQDK2">\r\n<input type="image" src="https://www.paypalobjects.com/fr_FR/FR/i/btn/btn_donateCC_LG.gif" border="0" name="submit" alt="PayPal, le rÃ©flexe sÃ©curitÃ© pour payer en ligne">\r\n<img alt="" border="0" src="https://www.paypalobjects.com/fr_FR/i/scr/pixel.gif" width="1" height="1">\r\n</form>";}');
1747
1748--
1749-- Index pour les tables exportÃ©es
1750--
1751
1752--
1753-- Index pour la table `nf_access`
1754--
1755ALTER TABLE `nf_access`
1756  ADD PRIMARY KEY (`access_id`),
1757  ADD UNIQUE KEY `module_id` (`id`,`module`,`action`),
1758  ADD KEY `module` (`module`);
1759
1760--
1761-- Index pour la table `nf_access_details`
1762--
1763ALTER TABLE `nf_access_details`
1764  ADD PRIMARY KEY (`access_id`,`entity`,`type`);
1765
1766--
1767-- Index pour la table `nf_comments`
1768--
1769ALTER TABLE `nf_comments`
1770  ADD PRIMARY KEY (`comment_id`),
1771  ADD KEY `parent_id` (`parent_id`),
1772  ADD KEY `user_id` (`user_id`),
1773  ADD KEY `module` (`module`);
1774
1775--
1776-- Index pour la table `nf_dispositions`
1777--
1778ALTER TABLE `nf_dispositions`
1779  ADD PRIMARY KEY (`disposition_id`),
1780  ADD UNIQUE KEY `theme` (`theme`,`page`,`zone`);
1781
1782--
1783-- Index pour la table `nf_files`
1784--
1785ALTER TABLE `nf_files`
1786  ADD PRIMARY KEY (`file_id`),
1787  ADD UNIQUE KEY `path` (`path`),
1788  ADD KEY `user_id` (`user_id`);
1789
1790--
1791-- Index pour la table `nf_forum`
1792--
1793ALTER TABLE `nf_forum`
1794  ADD PRIMARY KEY (`forum_id`),
1795  ADD KEY `last_message_id` (`last_message_id`);
1796
1797--
1798-- Index pour la table `nf_forum_categories`
1799--
1800ALTER TABLE `nf_forum_categories`
1801  ADD PRIMARY KEY (`category_id`);
1802
1803--
1804-- Index pour la table `nf_forum_messages`
1805--
1806ALTER TABLE `nf_forum_messages`
1807  ADD PRIMARY KEY (`message_id`),
1808  ADD KEY `topic_id` (`topic_id`),
1809  ADD KEY `user_id` (`user_id`);
1810
1811--
1812-- Index pour la table `nf_forum_read`
1813--
1814ALTER TABLE `nf_forum_read`
1815  ADD PRIMARY KEY (`user_id`,`forum_id`);
1816
1817--
1818-- Index pour la table `nf_forum_topics`
1819--
1820ALTER TABLE `nf_forum_topics`
1821  ADD PRIMARY KEY (`topic_id`),
1822  ADD UNIQUE KEY `last_message_id` (`last_message_id`),
1823  ADD KEY `forum_id` (`forum_id`),
1824  ADD KEY `message_id` (`message_id`);
1825
1826--
1827-- Index pour la table `nf_forum_topics_read`
1828--
1829ALTER TABLE `nf_forum_topics_read`
1830  ADD PRIMARY KEY (`topic_id`,`user_id`),
1831  ADD KEY `user_id` (`user_id`);
1832
1833--
1834-- Index pour la table `nf_forum_track`
1835--
1836ALTER TABLE `nf_forum_track`
1837  ADD PRIMARY KEY (`topic_id`,`user_id`),
1838  ADD KEY `user_id` (`user_id`);
1839
1840--
1841-- Index pour la table `nf_forum_url`
1842--
1843ALTER TABLE `nf_forum_url`
1844  ADD PRIMARY KEY (`forum_id`);
1845
1846--
1847-- Index pour la table `nf_gallery`
1848--
1849ALTER TABLE `nf_gallery`
1850  ADD PRIMARY KEY (`gallery_id`),
1851  ADD KEY `category_id` (`category_id`),
1852  ADD KEY `image_id` (`image_id`);
1853
1854--
1855-- Index pour la table `nf_gallery_categories`
1856--
1857ALTER TABLE `nf_gallery_categories`
1858  ADD PRIMARY KEY (`category_id`),
1859  ADD KEY `image_id` (`image_id`),
1860  ADD KEY `icon_id` (`icon_id`);
1861
1862--
1863-- Index pour la table `nf_gallery_categories_lang`
1864--
1865ALTER TABLE `nf_gallery_categories_lang`
1866  ADD PRIMARY KEY (`category_id`,`lang`),
1867  ADD KEY `lang` (`lang`);
1868
1869--
1870-- Index pour la table `nf_gallery_images`
1871--
1872ALTER TABLE `nf_gallery_images`
1873  ADD PRIMARY KEY (`image_id`),
1874  ADD KEY `file_id` (`file_id`),
1875  ADD KEY `gallery_id` (`gallery_id`),
1876  ADD KEY `original_file_id` (`original_file_id`),
1877  ADD KEY `thumbnail_file_id` (`thumbnail_file_id`);
1878
1879--
1880-- Index pour la table `nf_gallery_lang`
1881--
1882ALTER TABLE `nf_gallery_lang`
1883  ADD PRIMARY KEY (`gallery_id`,`lang`),
1884  ADD KEY `lang` (`lang`);
1885
1886--
1887-- Index pour la table `nf_games`
1888--
1889ALTER TABLE `nf_games`
1890  ADD PRIMARY KEY (`game_id`),
1891  ADD KEY `image_id` (`image_id`),
1892  ADD KEY `icon_id` (`icon_id`),
1893  ADD KEY `parent_id` (`parent_id`);
1894
1895--
1896-- Index pour la table `nf_games_lang`
1897--
1898ALTER TABLE `nf_games_lang`
1899  ADD PRIMARY KEY (`game_id`,`lang`),
1900  ADD KEY `lang` (`lang`);
1901
1902--
1903-- Index pour la table `nf_groups`
1904--
1905ALTER TABLE `nf_groups`
1906  ADD PRIMARY KEY (`group_id`);
1907
1908--
1909-- Index pour la table `nf_groups_lang`
1910--
1911ALTER TABLE `nf_groups_lang`
1912  ADD PRIMARY KEY (`group_id`,`lang`),
1913  ADD KEY `lang` (`lang`);
1914
1915--
1916-- Index pour la table `nf_news`
1917--
1918ALTER TABLE `nf_news`
1919  ADD PRIMARY KEY (`news_id`),
1920  ADD KEY `category_id` (`category_id`),
1921  ADD KEY `user_id` (`user_id`),
1922  ADD KEY `image_id` (`image_id`);
1923
1924--
1925-- Index pour la table `nf_news_categories`
1926--
1927ALTER TABLE `nf_news_categories`
1928  ADD PRIMARY KEY (`category_id`),
1929  ADD KEY `image_id` (`image_id`),
1930  ADD KEY `icon_id` (`icon_id`);
1931
1932--
1933-- Index pour la table `nf_news_categories_lang`
1934--
1935ALTER TABLE `nf_news_categories_lang`
1936  ADD PRIMARY KEY (`category_id`,`lang`),
1937  ADD KEY `lang` (`lang`);
1938
1939--
1940-- Index pour la table `nf_news_lang`
1941--
1942ALTER TABLE `nf_news_lang`
1943  ADD PRIMARY KEY (`news_id`,`lang`),
1944  ADD KEY `lang` (`lang`);
1945
1946--
1947-- Index pour la table `nf_pages`
1948--
1949ALTER TABLE `nf_pages`
1950  ADD PRIMARY KEY (`page_id`),
1951  ADD UNIQUE KEY `page` (`name`);
1952
1953--
1954-- Index pour la table `nf_pages_lang`
1955--
1956ALTER TABLE `nf_pages_lang`
1957  ADD PRIMARY KEY (`page_id`,`lang`),
1958  ADD KEY `lang` (`lang`);
1959
1960--
1961-- Index pour la table `nf_search_keywords`
1962--
1963ALTER TABLE `nf_search_keywords`
1964  ADD PRIMARY KEY (`keyword`);
1965
1966--
1967-- Index pour la table `nf_sessions`
1968--
1969ALTER TABLE `nf_sessions`
1970  ADD UNIQUE KEY `session_id` (`session_id`),
1971  ADD KEY `user_id` (`user_id`);
1972
1973--
1974-- Index pour la table `nf_sessions_history`
1975--
1976ALTER TABLE `nf_sessions_history`
1977  ADD PRIMARY KEY (`id`),
1978  ADD UNIQUE KEY `session_id` (`session_id`,`user_id`,`ip_address`,`host_name`,`referer`,`user_agent`,`date`),
1979  ADD KEY `user_id` (`user_id`);
1980
1981--
1982-- Index pour la table `nf_settings`
1983--
1984ALTER TABLE `nf_settings`
1985  ADD PRIMARY KEY (`name`,`site`,`lang`);
1986
1987--
1988-- Index pour la table `nf_settings_addons`
1989--
1990ALTER TABLE `nf_settings_addons`
1991  ADD PRIMARY KEY (`name`,`type`);
1992
1993--
1994-- Index pour la table `nf_settings_languages`
1995--
1996ALTER TABLE `nf_settings_languages`
1997  ADD PRIMARY KEY (`language_id`),
1998  ADD UNIQUE KEY `code` (`code`);
1999
2000--
2001-- Index pour la table `nf_settings_smileys`
2002--
2003ALTER TABLE `nf_settings_smileys`
2004  ADD PRIMARY KEY (`smiley_id`),
2005  ADD UNIQUE KEY `code` (`code`);
2006
2007--
2008-- Index pour la table `nf_statistics`
2009--
2010ALTER TABLE `nf_statistics`
2011  ADD PRIMARY KEY (`name`);
2012
2013--
2014-- Index pour la table `nf_talks`
2015--
2016ALTER TABLE `nf_talks`
2017  ADD PRIMARY KEY (`talk_id`);
2018
2019--
2020-- Index pour la table `nf_talks_messages`
2021--
2022ALTER TABLE `nf_talks_messages`
2023  ADD PRIMARY KEY (`message_id`);
2024
2025--
2026-- Index pour la table `nf_teams`
2027--
2028ALTER TABLE `nf_teams`
2029  ADD PRIMARY KEY (`team_id`),
2030  ADD KEY `activity_id` (`game_id`),
2031  ADD KEY `image_id` (`image_id`),
2032  ADD KEY `icon_id` (`icon_id`);
2033
2034--
2035-- Index pour la table `nf_teams_lang`
2036--
2037ALTER TABLE `nf_teams_lang`
2038  ADD PRIMARY KEY (`team_id`,`lang`),
2039  ADD KEY `lang` (`lang`);
2040
2041--
2042-- Index pour la table `nf_teams_roles`
2043--
2044ALTER TABLE `nf_teams_roles`
2045  ADD PRIMARY KEY (`role_id`);
2046
2047--
2048-- Index pour la table `nf_teams_users`
2049--
2050ALTER TABLE `nf_teams_users`
2051  ADD PRIMARY KEY (`team_id`,`user_id`),
2052  ADD KEY `user_id` (`user_id`),
2053  ADD KEY `role_id` (`role_id`);
2054
2055--
2056-- Index pour la table `nf_users`
2057--
2058ALTER TABLE `nf_users`
2059  ADD PRIMARY KEY (`user_id`),
2060  ADD UNIQUE KEY `username` (`username`),
2061  ADD UNIQUE KEY `email` (`email`),
2062  ADD KEY `language` (`language`),
2063  ADD KEY `deleted` (`deleted`);
2064
2065--
2066-- Index pour la table `nf_users_groups`
2067--
2068ALTER TABLE `nf_users_groups`
2069  ADD PRIMARY KEY (`user_id`,`group_id`),
2070  ADD KEY `group_id` (`group_id`);
2071
2072--
2073-- Index pour la table `nf_users_keys`
2074--
2075ALTER TABLE `nf_users_keys`
2076  ADD PRIMARY KEY (`key_id`),
2077  ADD KEY `user_id` (`user_id`),
2078  ADD KEY `session_id` (`session_id`);
2079
2080--
2081-- Index pour la table `nf_users_messages`
2082--
2083ALTER TABLE `nf_users_messages`
2084  ADD PRIMARY KEY (`message_id`),
2085  ADD KEY `user_id` (`user_id`);
2086
2087--
2088-- Index pour la table `nf_users_messages_recipients`
2089--
2090ALTER TABLE `nf_users_messages_recipients`
2091  ADD PRIMARY KEY (`user_id`,`message_id`),
2092  ADD KEY `message_id` (`message_id`);
2093
2094--
2095-- Index pour la table `nf_users_messages_replies`
2096--
2097ALTER TABLE `nf_users_messages_replies`
2098  ADD PRIMARY KEY (`reply_id`),
2099  ADD KEY `message_id` (`message_id`,`user_id`),
2100  ADD KEY `user_id` (`user_id`);
2101
2102--
2103-- Index pour la table `nf_users_profiles`
2104--
2105ALTER TABLE `nf_users_profiles`
2106  ADD PRIMARY KEY (`user_id`),
2107  ADD KEY `avatar` (`avatar`);
2108
2109--
2110-- Index pour la table `nf_votes`
2111--
2112ALTER TABLE `nf_votes`
2113  ADD PRIMARY KEY (`module_id`,`module`,`user_id`),
2114  ADD KEY `module` (`module`),
2115  ADD KEY `user_id` (`user_id`);
2116
2117--
2118-- Index pour la table `nf_widgets`
2119--
2120ALTER TABLE `nf_widgets`
2121  ADD PRIMARY KEY (`widget_id`),
2122  ADD KEY `widget_name` (`widget`);
2123
2124--
2125-- AUTO_INCREMENT pour les tables exportÃ©es
2126--
2127
2128--
2129-- AUTO_INCREMENT pour la table `nf_access`
2130--
2131ALTER TABLE `nf_access`
2132  MODIFY `access_id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=87;
2133--
2134-- AUTO_INCREMENT pour la table `nf_comments`
2135--
2136ALTER TABLE `nf_comments`
2137  MODIFY `comment_id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
2138--
2139-- AUTO_INCREMENT pour la table `nf_dispositions`
2140--
2141ALTER TABLE `nf_dispositions`
2142  MODIFY `disposition_id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=32;
2143--
2144-- AUTO_INCREMENT pour la table `nf_files`
2145--
2146ALTER TABLE `nf_files`
2147  MODIFY `file_id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=94;
2148--
2149-- AUTO_INCREMENT pour la table `nf_forum`
2150--
2151ALTER TABLE `nf_forum`
2152  MODIFY `forum_id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=65;
2153--
2154-- AUTO_INCREMENT pour la table `nf_forum_categories`
2155--
2156ALTER TABLE `nf_forum_categories`
2157  MODIFY `category_id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9;
2158--
2159-- AUTO_INCREMENT pour la table `nf_forum_messages`
2160--
2161ALTER TABLE `nf_forum_messages`
2162  MODIFY `message_id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=19;
2163--
2164-- AUTO_INCREMENT pour la table `nf_forum_topics`
2165--
2166ALTER TABLE `nf_forum_topics`
2167  MODIFY `topic_id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=19;
2168--
2169-- AUTO_INCREMENT pour la table `nf_gallery`
2170--
2171ALTER TABLE `nf_gallery`
2172  MODIFY `gallery_id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
2173--
2174-- AUTO_INCREMENT pour la table `nf_gallery_categories`
2175--
2176ALTER TABLE `nf_gallery_categories`
2177  MODIFY `category_id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
2178--
2179-- AUTO_INCREMENT pour la table `nf_gallery_images`
2180--
2181ALTER TABLE `nf_gallery_images`
2182  MODIFY `image_id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=23;
2183--
2184-- AUTO_INCREMENT pour la table `nf_games`
2185--
2186ALTER TABLE `nf_games`
2187  MODIFY `game_id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
2188--
2189-- AUTO_INCREMENT pour la table `nf_groups`
2190--
2191ALTER TABLE `nf_groups`
2192  MODIFY `group_id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
2193--
2194-- AUTO_INCREMENT pour la table `nf_news`
2195--
2196ALTER TABLE `nf_news`
2197  MODIFY `news_id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
2198--
2199-- AUTO_INCREMENT pour la table `nf_news_categories`
2200--
2201ALTER TABLE `nf_news_categories`
2202  MODIFY `category_id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
2203--
2204-- AUTO_INCREMENT pour la table `nf_pages`
2205--
2206ALTER TABLE `nf_pages`
2207  MODIFY `page_id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
2208--
2209-- AUTO_INCREMENT pour la table `nf_sessions_history`
2210--
2211ALTER TABLE `nf_sessions_history`
2212  MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=76;
2213--
2214-- AUTO_INCREMENT pour la table `nf_settings_languages`
2215--
2216ALTER TABLE `nf_settings_languages`
2217  MODIFY `language_id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
2218--
2219-- AUTO_INCREMENT pour la table `nf_settings_smileys`
2220--
2221ALTER TABLE `nf_settings_smileys`
2222  MODIFY `smiley_id` int(11) unsigned NOT NULL AUTO_INCREMENT;
2223--
2224-- AUTO_INCREMENT pour la table `nf_talks`
2225--
2226ALTER TABLE `nf_talks`
2227  MODIFY `talk_id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
2228--
2229-- AUTO_INCREMENT pour la table `nf_talks_messages`
2230--
2231ALTER TABLE `nf_talks_messages`
2232  MODIFY `message_id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=13;
2233--
2234-- AUTO_INCREMENT pour la table `nf_teams`
2235--
2236ALTER TABLE `nf_teams`
2237  MODIFY `team_id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
2238--
2239-- AUTO_INCREMENT pour la table `nf_teams_roles`
2240--
2241ALTER TABLE `nf_teams_roles`
2242  MODIFY `role_id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
2243--
2244-- AUTO_INCREMENT pour la table `nf_users`
2245--
2246ALTER TABLE `nf_users`
2247  MODIFY `user_id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=27;
2248--
2249-- AUTO_INCREMENT pour la table `nf_users_messages`
2250--
2251ALTER TABLE `nf_users_messages`
2252  MODIFY `message_id` int(11) unsigned NOT NULL AUTO_INCREMENT;
2253--
2254-- AUTO_INCREMENT pour la table `nf_users_messages_replies`
2255--
2256ALTER TABLE `nf_users_messages_replies`
2257  MODIFY `reply_id` int(11) unsigned NOT NULL AUTO_INCREMENT;
2258--
2259-- AUTO_INCREMENT pour la table `nf_widgets`
2260--
2261ALTER TABLE `nf_widgets`
2262  MODIFY `widget_id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=158;
2263--
2264-- Contraintes pour les tables exportÃ©es
2265--
2266
2267--
2268-- Contraintes pour la table `nf_access`
2269--
2270ALTER TABLE `nf_access`
2271  ADD CONSTRAINT `nf_access_ibfk_1` FOREIGN KEY (`module`) REFERENCES `nf_settings_addons` (`name`) ON DELETE CASCADE ON UPDATE CASCADE;
2272
2273--
2274-- Contraintes pour la table `nf_access_details`
2275--
2276ALTER TABLE `nf_access_details`
2277  ADD CONSTRAINT `nf_access_details_ibfk_1` FOREIGN KEY (`access_id`) REFERENCES `nf_access` (`access_id`) ON DELETE CASCADE ON UPDATE CASCADE;
2278
2279--
2280-- Contraintes pour la table `nf_comments`
2281--
2282ALTER TABLE `nf_comments`
2283  ADD CONSTRAINT `nf_comments_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `nf_comments` (`comment_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2284  ADD CONSTRAINT `nf_comments_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `nf_users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2285  ADD CONSTRAINT `nf_comments_ibfk_3` FOREIGN KEY (`module`) REFERENCES `nf_settings_addons` (`name`) ON DELETE CASCADE ON UPDATE CASCADE;
2286
2287--
2288-- Contraintes pour la table `nf_files`
2289--
2290ALTER TABLE `nf_files`
2291  ADD CONSTRAINT `nf_files_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `nf_users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;
2292
2293--
2294-- Contraintes pour la table `nf_forum`
2295--
2296ALTER TABLE `nf_forum`
2297  ADD CONSTRAINT `nf_forum_ibfk_1` FOREIGN KEY (`last_message_id`) REFERENCES `nf_forum_messages` (`message_id`) ON DELETE SET NULL ON UPDATE SET NULL;
2298
2299--
2300-- Contraintes pour la table `nf_forum_messages`
2301--
2302ALTER TABLE `nf_forum_messages`
2303  ADD CONSTRAINT `nf_forum_messages_ibfk_1` FOREIGN KEY (`topic_id`) REFERENCES `nf_forum_topics` (`topic_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2304  ADD CONSTRAINT `nf_forum_messages_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `nf_users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;
2305
2306--
2307-- Contraintes pour la table `nf_forum_read`
2308--
2309ALTER TABLE `nf_forum_read`
2310  ADD CONSTRAINT `nf_forum_read_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `nf_users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;
2311
2312--
2313-- Contraintes pour la table `nf_forum_topics`
2314--
2315ALTER TABLE `nf_forum_topics`
2316  ADD CONSTRAINT `nf_forum_topics_ibfk_1` FOREIGN KEY (`forum_id`) REFERENCES `nf_forum` (`forum_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2317  ADD CONSTRAINT `nf_forum_topics_ibfk_2` FOREIGN KEY (`message_id`) REFERENCES `nf_forum_messages` (`message_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2318  ADD CONSTRAINT `nf_forum_topics_ibfk_3` FOREIGN KEY (`last_message_id`) REFERENCES `nf_forum_messages` (`message_id`) ON DELETE SET NULL ON UPDATE SET NULL;
2319
2320--
2321-- Contraintes pour la table `nf_forum_topics_read`
2322--
2323ALTER TABLE `nf_forum_topics_read`
2324  ADD CONSTRAINT `nf_forum_topics_read_ibfk_1` FOREIGN KEY (`topic_id`) REFERENCES `nf_forum_topics` (`topic_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2325  ADD CONSTRAINT `nf_forum_topics_read_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `nf_users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;
2326
2327--
2328-- Contraintes pour la table `nf_forum_track`
2329--
2330ALTER TABLE `nf_forum_track`
2331  ADD CONSTRAINT `nf_forum_track_ibfk_1` FOREIGN KEY (`topic_id`) REFERENCES `nf_forum_topics` (`topic_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2332  ADD CONSTRAINT `nf_forum_track_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `nf_users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;
2333
2334--
2335-- Contraintes pour la table `nf_forum_url`
2336--
2337ALTER TABLE `nf_forum_url`
2338  ADD CONSTRAINT `nf_forum_url_ibfk_1` FOREIGN KEY (`forum_id`) REFERENCES `nf_forum` (`forum_id`) ON DELETE CASCADE ON UPDATE CASCADE;
2339
2340--
2341-- Contraintes pour la table `nf_gallery`
2342--
2343ALTER TABLE `nf_gallery`
2344  ADD CONSTRAINT `nf_gallery_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `nf_gallery_categories` (`category_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2345  ADD CONSTRAINT `nf_gallery_ibfk_2` FOREIGN KEY (`image_id`) REFERENCES `nf_files` (`file_id`) ON DELETE SET NULL ON UPDATE CASCADE;
2346
2347--
2348-- Contraintes pour la table `nf_gallery_categories`
2349--
2350ALTER TABLE `nf_gallery_categories`
2351  ADD CONSTRAINT `nf_gallery_categories_ibfk_1` FOREIGN KEY (`image_id`) REFERENCES `nf_files` (`file_id`) ON DELETE SET NULL ON UPDATE CASCADE,
2352  ADD CONSTRAINT `nf_gallery_categories_ibfk_2` FOREIGN KEY (`icon_id`) REFERENCES `nf_files` (`file_id`) ON DELETE SET NULL ON UPDATE CASCADE;
2353
2354--
2355-- Contraintes pour la table `nf_gallery_categories_lang`
2356--
2357ALTER TABLE `nf_gallery_categories_lang`
2358  ADD CONSTRAINT `nf_gallery_categories_lang_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `nf_gallery_categories` (`category_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2359  ADD CONSTRAINT `nf_gallery_categories_lang_ibfk_2` FOREIGN KEY (`lang`) REFERENCES `nf_settings_languages` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;
2360
2361--
2362-- Contraintes pour la table `nf_gallery_images`
2363--
2364ALTER TABLE `nf_gallery_images`
2365  ADD CONSTRAINT `nf_gallery_images_ibfk_1` FOREIGN KEY (`file_id`) REFERENCES `nf_files` (`file_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2366  ADD CONSTRAINT `nf_gallery_images_ibfk_2` FOREIGN KEY (`gallery_id`) REFERENCES `nf_gallery` (`gallery_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2367  ADD CONSTRAINT `nf_gallery_images_ibfk_3` FOREIGN KEY (`thumbnail_file_id`) REFERENCES `nf_files` (`file_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2368  ADD CONSTRAINT `nf_gallery_images_ibfk_4` FOREIGN KEY (`original_file_id`) REFERENCES `nf_files` (`file_id`) ON DELETE CASCADE ON UPDATE CASCADE;
2369
2370--
2371-- Contraintes pour la table `nf_gallery_lang`
2372--
2373ALTER TABLE `nf_gallery_lang`
2374  ADD CONSTRAINT `nf_gallery_lang_ibfk_1` FOREIGN KEY (`gallery_id`) REFERENCES `nf_gallery` (`gallery_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2375  ADD CONSTRAINT `nf_gallery_lang_ibfk_2` FOREIGN KEY (`lang`) REFERENCES `nf_settings_languages` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;
2376
2377--
2378-- Contraintes pour la table `nf_games`
2379--
2380ALTER TABLE `nf_games`
2381  ADD CONSTRAINT `nf_games_ibfk_1` FOREIGN KEY (`image_id`) REFERENCES `nf_files` (`file_id`) ON DELETE SET NULL ON UPDATE CASCADE,
2382  ADD CONSTRAINT `nf_games_ibfk_2` FOREIGN KEY (`icon_id`) REFERENCES `nf_files` (`file_id`) ON DELETE SET NULL ON UPDATE CASCADE,
2383  ADD CONSTRAINT `nf_games_ibfk_3` FOREIGN KEY (`parent_id`) REFERENCES `nf_games` (`game_id`) ON DELETE CASCADE ON UPDATE CASCADE;
2384
2385--
2386-- Contraintes pour la table `nf_games_lang`
2387--
2388ALTER TABLE `nf_games_lang`
2389  ADD CONSTRAINT `nf_games_lang_ibfk_1` FOREIGN KEY (`game_id`) REFERENCES `nf_games` (`game_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2390  ADD CONSTRAINT `nf_games_lang_ibfk_2` FOREIGN KEY (`lang`) REFERENCES `nf_settings_languages` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;
2391
2392--
2393-- Contraintes pour la table `nf_groups_lang`
2394--
2395ALTER TABLE `nf_groups_lang`
2396  ADD CONSTRAINT `nf_groups_lang_ibfk_1` FOREIGN KEY (`group_id`) REFERENCES `nf_groups` (`group_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2397  ADD CONSTRAINT `nf_groups_lang_ibfk_2` FOREIGN KEY (`lang`) REFERENCES `nf_settings_languages` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;
2398
2399--
2400-- Contraintes pour la table `nf_news`
2401--
2402ALTER TABLE `nf_news`
2403  ADD CONSTRAINT `nf_news_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `nf_users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2404  ADD CONSTRAINT `nf_news_ibfk_2` FOREIGN KEY (`image_id`) REFERENCES `nf_files` (`file_id`) ON DELETE SET NULL ON UPDATE CASCADE,
2405  ADD CONSTRAINT `nf_news_ibfk_4` FOREIGN KEY (`category_id`) REFERENCES `nf_news_categories` (`category_id`) ON DELETE CASCADE ON UPDATE CASCADE;
2406
2407--
2408-- Contraintes pour la table `nf_news_categories`
2409--
2410ALTER TABLE `nf_news_categories`
2411  ADD CONSTRAINT `nf_news_categories_ibfk_1` FOREIGN KEY (`image_id`) REFERENCES `nf_files` (`file_id`) ON DELETE SET NULL ON UPDATE CASCADE,
2412  ADD CONSTRAINT `nf_news_categories_ibfk_2` FOREIGN KEY (`icon_id`) REFERENCES `nf_files` (`file_id`) ON DELETE SET NULL ON UPDATE CASCADE;
2413
2414--
2415-- Contraintes pour la table `nf_news_categories_lang`
2416--
2417ALTER TABLE `nf_news_categories_lang`
2418  ADD CONSTRAINT `nf_news_categories_lang_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `nf_news_categories` (`category_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2419  ADD CONSTRAINT `nf_news_categories_lang_ibfk_2` FOREIGN KEY (`lang`) REFERENCES `nf_settings_languages` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;
2420
2421--
2422-- Contraintes pour la table `nf_news_lang`
2423--
2424ALTER TABLE `nf_news_lang`
2425  ADD CONSTRAINT `nf_news_lang_ibfk_1` FOREIGN KEY (`news_id`) REFERENCES `nf_news` (`news_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2426  ADD CONSTRAINT `nf_news_lang_ibfk_2` FOREIGN KEY (`lang`) REFERENCES `nf_settings_languages` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;
2427
2428--
2429-- Contraintes pour la table `nf_pages_lang`
2430--
2431ALTER TABLE `nf_pages_lang`
2432  ADD CONSTRAINT `nf_pages_lang_ibfk_1` FOREIGN KEY (`page_id`) REFERENCES `nf_pages` (`page_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2433  ADD CONSTRAINT `nf_pages_lang_ibfk_2` FOREIGN KEY (`lang`) REFERENCES `nf_settings_languages` (`code`) ON DELETE CASCADE ON UPDATE CASCADE;
2434
2435--
2436-- Contraintes pour la table `nf_sessions`
2437--
2438ALTER TABLE `nf_sessions`
2439  ADD CONSTRAINT `nf_sessions_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `nf_users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;
2440
2441--
2442-- Contraintes pour la table `nf_sessions_history`
2443--
2444ALTER TABLE `nf_sessions_history`
2445  ADD CONSTRAINT `nf_sessions_history_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `nf_users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2446  ADD CONSTRAINT `nf_sessions_history_ibfk_2` FOREIGN KEY (`session_id`) REFERENCES `nf_sessions` (`session_id`) ON DELETE SET NULL ON UPDATE SET NULL;
2447
2448--
2449-- Contraintes pour la table `nf_teams`
2450--
2451ALTER TABLE `nf_teams`
2452  ADD CONSTRAINT `nf_teams_ibfk_1` FOREIGN KEY (`image_id`) REFERENCES `nf_files` (`file_id`) ON DELETE SET NULL ON UPDATE CASCADE,
2453  ADD CONSTRAINT `nf_teams_ibfk_2` FOREIGN KEY (`icon_id`) REFERENCES `nf_files` (`file_id`) ON DELETE SET NULL ON UPDATE CASCADE,
2454  ADD CONSTRAINT `nf_teams_ibfk_3` FOREIGN KEY (`game_id`) REFERENCES `nf_games` (`game_id`) ON DELETE CASCADE ON UPDATE CASCADE;
2455
2456--
2457-- Contraintes pour la table `nf_teams_lang`
2458--
2459ALTER TABLE `nf_teams_lang`
2460  ADD CONSTRAINT `nf_teams_lang_ibfk_1` FOREIGN KEY (`lang`) REFERENCES `nf_settings_languages` (`code`) ON DELETE CASCADE ON UPDATE CASCADE,
2461  ADD CONSTRAINT `nf_teams_lang_ibfk_2` FOREIGN KEY (`team_id`) REFERENCES `nf_teams` (`team_id`) ON DELETE CASCADE ON UPDATE CASCADE;
2462
2463--
2464-- Contraintes pour la table `nf_teams_users`
2465--
2466ALTER TABLE `nf_teams_users`
2467  ADD CONSTRAINT `nf_teams_users_ibfk_1` FOREIGN KEY (`team_id`) REFERENCES `nf_teams` (`team_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2468  ADD CONSTRAINT `nf_teams_users_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `nf_users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2469  ADD CONSTRAINT `nf_teams_users_ibfk_3` FOREIGN KEY (`role_id`) REFERENCES `nf_teams_roles` (`role_id`) ON DELETE SET NULL ON UPDATE CASCADE;
2470
2471--
2472-- Contraintes pour la table `nf_users`
2473--
2474ALTER TABLE `nf_users`
2475  ADD CONSTRAINT `nf_users_ibfk_1` FOREIGN KEY (`language`) REFERENCES `nf_settings_languages` (`code`) ON DELETE SET NULL ON UPDATE SET NULL;
2476
2477--
2478-- Contraintes pour la table `nf_users_groups`
2479--
2480ALTER TABLE `nf_users_groups`
2481  ADD CONSTRAINT `nf_users_groups_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `nf_users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2482  ADD CONSTRAINT `nf_users_groups_ibfk_2` FOREIGN KEY (`group_id`) REFERENCES `nf_groups` (`group_id`) ON DELETE CASCADE ON UPDATE CASCADE;
2483
2484--
2485-- Contraintes pour la table `nf_users_keys`
2486--
2487ALTER TABLE `nf_users_keys`
2488  ADD CONSTRAINT `nf_users_keys_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `nf_users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2489  ADD CONSTRAINT `nf_users_keys_ibfk_2` FOREIGN KEY (`session_id`) REFERENCES `nf_sessions` (`session_id`) ON DELETE CASCADE ON UPDATE CASCADE;
2490
2491--
2492-- Contraintes pour la table `nf_users_messages`
2493--
2494ALTER TABLE `nf_users_messages`
2495  ADD CONSTRAINT `nf_users_messages_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `nf_users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;
2496
2497--
2498-- Contraintes pour la table `nf_users_messages_recipients`
2499--
2500ALTER TABLE `nf_users_messages_recipients`
2501  ADD CONSTRAINT `nf_users_messages_recipients_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `nf_users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2502  ADD CONSTRAINT `nf_users_messages_recipients_ibfk_2` FOREIGN KEY (`message_id`) REFERENCES `nf_users_messages` (`message_id`) ON DELETE CASCADE ON UPDATE CASCADE;
2503
2504--
2505-- Contraintes pour la table `nf_users_messages_replies`
2506--
2507ALTER TABLE `nf_users_messages_replies`
2508  ADD CONSTRAINT `nf_users_messages_replies_ibfk_1` FOREIGN KEY (`message_id`) REFERENCES `nf_users_messages` (`message_id`) ON DELETE CASCADE ON UPDATE CASCADE,
2509  ADD CONSTRAINT `nf_users_messages_replies_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `nf_users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;
2510
2511--
2512-- Contraintes pour la table `nf_users_profiles`
2513--
2514ALTER TABLE `nf_users_profiles`
2515  ADD CONSTRAINT `nf_users_profiles_ibfk_2` FOREIGN KEY (`avatar`) REFERENCES `nf_files` (`file_id`) ON DELETE SET NULL ON UPDATE CASCADE,
2516  ADD CONSTRAINT `nf_users_profiles_ibfk_3` FOREIGN KEY (`user_id`) REFERENCES `nf_users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;
2517
2518--
2519-- Contraintes pour la table `nf_votes`
2520--
2521ALTER TABLE `nf_votes`
2522  ADD CONSTRAINT `nf_votes_ibfk_1` FOREIGN KEY (`module`) REFERENCES `nf_settings_addons` (`name`) ON DELETE CASCADE ON UPDATE CASCADE,
2523  ADD CONSTRAINT `nf_votes_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `nf_users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE;
2524
2525--
2526-- Contraintes pour la table `nf_widgets`
2527--
2528ALTER TABLE `nf_widgets`
2529  ADD CONSTRAINT `nf_widgets_ibfk_1` FOREIGN KEY (`widget`) REFERENCES `nf_settings_addons` (`name`) ON DELETE CASCADE ON UPDATE CASCADE;
2530
2531/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
2532/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
2533/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;