API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 7th, 2016
173
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 147.64 KB | None | 0 0
raw download clone embed print report
  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.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET 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.  
  29. CREATE 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.  
  40. INSERT 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.  
  86. CREATE 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.  
  97. INSERT 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.  
  154. CREATE 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.  
  168. INSERT 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.  
  177. CREATE 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.  
  187. INSERT 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.  
  305. CREATE 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.  
  317. INSERT 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.  
  338. CREATE 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.  
  351. INSERT INTO `nf_donation_config` (`title`, `paypalemail`, `imglink`, `objectif`, `message`, `total`) VALUES
  352. ('Rusty''Donation', 'email@mon-email.fr', 'http://dummyimage.com/240x100/006a78/1d98eb&text=votre+image+en+240+x+100', 50, 'Merci', '1');
  353.  
  354. -- --------------------------------------------------------
  355.  
  356. --
  357. -- Structure de la table `nf_files`
  358. --
  359.  
  360. CREATE 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.  
  372. INSERT 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.  
  460. CREATE 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.  
  476. INSERT 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énérales', 'Aucune catégorie pour votre sujet ? C''est par ici que ça se passe !', 2, 0, 0, NULL),
  478. (5, 1, '0', 'Information / Réglement', 'Ici retrouver toutes les infos et règles du Forum.', 0, 1, 0, 2),
  479. (7, 1, '0', 'Présentation', 'Vous-êtes nouveau sur RustyFrance ? Bienvenue ! Écrivez votre présentation.', 1, 1, 0, 3),
  480. (20, 1, '0', 'Rapport de Bug', 'Signaler un problè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éo', '', 0, 0, 0, NULL),
  483. (48, 6, '0', 'Règles du serveur', '', 0, 2, 0, 16),
  484. (49, 7, '0', 'Rè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énérales', '', 0, 0, 0, NULL),
  490. (55, 7, '0', 'Discussions géné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éban', '', 0, 0, 0, NULL),
  494. (62, 6, '0', 'Plainte/Dé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.  
  504. CREATE 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.  
  514. INSERT INTO `nf_forum_categories` (`category_id`, `title`, `order`) VALUES
  515. (1, 'Forums généraux', 0),
  516. (5, 'Communauté', 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.  
  527. CREATE 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.  
  539. INSERT INTO `nf_forum_messages` (`message_id`, `topic_id`, `user_id`, `message`, `date`) VALUES
  540. (2, 2, 1, '[b]Bonjour à tous ![/b]\r\n\r\n[i][i]Pour entretenir une bonne entente ainsi qu''une bonne ambiance au sein du forum un règlement devra être scrupuleusement respecté, 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é d''une personne à son insu.\r\n- D''avoir un langage inapproprié.\r\n- De faire de la publicité. (Seul les publicités pour les chaînes YouTube seront acceptées)\r\n- De partager des photos ou des liens à caractère pornographique/hardcore.\r\n- De partager son compte.\r\n- De distribuer des virus.\r\n- Interdiction de posté des vidéos, photos ou autres a caractè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éléchargement de fichier .exe et .com d''un virus scan[url=https://www.virustotal.com/fr/] Virus Total [/url](Si l''application est compressée en un archive .zip ou .rar vous devrez impérativement scanner l''application décompressé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ègles ne sont pas respectées et que nous considérons que vous essayez de nuire au bon fonctionnement du forum vous serez sanctionné de la façon la plus appropriée qu''il soit.[/i]\r\n\r\n[color=#ff0000][u][b]Vous êtes en droit :[/b][/u][/color]\r\n\r\n- De demander un changement de pseudo.\r\n- De créer des discussions.\r\n- De participé au bon développement du forum en effectuant des dons.\r\n- D''exprimer vos opinions, accord(s) ou désaccord(s).\r\n- De modifier et/ou masquer vos informations personnelles.\r\n- De commenter tout les topics qui sont crées.\r\n- De demander des justificatifs de vos sanctions.\r\n- De poster votre candidature pour intégrer le staff.\r\n\r\n[color=#ff0000][u][b]Il vous est conseillé :[/b][/u][/color]\r\n\r\n- De vous présentez sur le forum [url=http://rustyfrance.cluster1.easy-hebergement.net/forum/7/presentation.html]Ici[/url].\r\n- D''utiliser un avatar personnalisé.\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 êtes nouveau sur RustyFrance ? N''hésitez pas à vous présenter, afin que nous puissions mieux vous connaître, idéalement en respectant \r\nle modèle suivant :\r\n\r\n[b][u][color=#ff0000]Modèle de présentation :[/color][/u]\r\n[/b][center]\r\n[i]Salut la communauté RustyFrance, je viens de m''inscrire et voici ma présentation ! [/i]\r\n\r\n[i]Présentation IRL (Réalité) :[/i]\r\n\r\n[i]- Prénom [/i]: ...\r\n-[i] Surnom / pseudonyme [/i]: ...\r\n[i]- Âge[/i] : ...\r\n[i]- Ma ville/région[/i] : ...\r\n[i]- Vos centres d''intérêts (occupations, études..) [/i]: ...\r\n[i]\r\nPrésentation IG (In-Game) [/i]:\r\n\r\n[i]- Pourquoi avoir rejoint la communauté [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édez-vous un/plusieurs compte(s) [b]Steam[/b][/i] ? : ...\r\n-[i] Possédez-vous un/plusieurs compte(s) [/i][b][i]Origins[/i] [/b]? : ...\r\n[i]- Possédez-vous un/plusieurs compte(s) [b]Uplay[/b][/i] ? : …\r\n[i]- Si vous avez autre chose à rajouter[/i] : ...\r\n\r\n[i]Comment me contacter ? [/i] :\r\n\r\n- A[i]vez-vous un compte sur les ré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…)[/i] : …\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ègles du serveur "RustyFrance".[/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écompensé d’une sanction sans appel sur le serveur et appuyé d’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’alliance ? Ceci est formellement interdit suite à de nombreux problè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’importe qu''elle religion est interdit. \r\n[/size][size=150]\r\n[/size][size=150][b]2 : la communauté[/b][/size][size=150]\r\n[/size][size=150]Si le Fair Play ne peut être totalement imposé, 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é, car considéré comme partie intégrante du jeu, mais chacun se doit de veiller à ne pas en [/size][size=150]abuser. Méfiez-vous, s’exprimer par écrit ne permet pas toujours de détecter humour ou ironie, et vos propos peuvent ainsi vexer ou être mal prit.[/size][size=150][b]\r\n\r\n3 : Les admins\r\n[/b][/size][size=150]L’admin ne joue pas , afin de ne pas se faire accuser de « give » ou « abus ».[/size][size=150]\r\n[/size][size=150]Ils ont la pour veiller le plus passivement possible, vanilla oblige, au bon déroulement du jeu. [/size][size=150]\r\n[/size][size=150]Ils ne sont pas là pour détruire les constructions raté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ôt upload ici, merci de patienter.[/center][/size][/color]', '2016-05-05 22:00:28'),
  545. (14, 14, 1, 'Bonjour/Bonsoir à tous,\r\n\r\nSi le serveur vient à crash (en gros: pas moyen de se reconnecter au \r\ndelà de 5-10 minutes et que cette déconnexion reste permanente), je vous\r\ninvite grandement à le signaler par divers moyens.\r\n\r\n[list][*]Le signaler à un Admin présent sur Teamspeak (n''hésitez pas à envoyer un MP).[/*][/list][list][*]Ou le signaler en message Steam à [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ésitez pas à créer un topic dans l''onglet "[url=http://rustyfrance.fr/forum/58/rapporter-un-bug.html]Rapporter un bug" [/url]pour signaler par exemple des problèmes qui surviennent ingame comme des lags ou des minis-roleback par exemple. Essayez d''être le plus complet possible en dé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éléchargé TeamSpeak 3[/url] \r\n\r\n[b]2-[/b] Une fois l''installation faite, cliquez sur "[b]Connexion[/b]" puis sur "[b]Se connecter[/b]"\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é l''armoire afin de ne pas pouvoir construire\r\n- Enfermé la base à l''aide de mur et/ou de porte\r\nLe fait de bloqué une base via les moyen ci-dessus sans y habité les lieu, le [b]grief [/b]est constaté.\r\n\r\nComment s''emparer d''une base sans que le [b]grief[/b] soit constaté ?\r\n- Le grief ne peut être constaté dès lors que la personnes qui c''est emparer des lieu a déposer un sac de couchage et/ou lit à l''inté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é 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ès possible et ne pas l''habité par la suite ( tel une maison abandonné ) dans ce cas, le grief est constaté. [/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éation d''un serveur en local. Idéal pour construire sans limite, testé 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é un maximum de compréhension pour chaque étape.\r\n\r\n[b]1-[/b][size=100] Télé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é-zippé le dossier Rust_Server.zip à l''emplacement souhaité 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é, celui-ci ouvrira l''invite de commande ( cmd ) qui l''invite de commande lancera une récupération de fichier afin de les copier sur votre ordinateur et ensuite les mettre à jour. Ses fichier sont essentiel pour la création de votre serveur. Laissez la fenêtre ouvert sinon nous é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 à jour des fichiers peuvent durée assez longtemps.[/size]\r\n\r\n[b]4- [/b][size=100]Pour être admin de votre propre serveur il vous faudra tapez la commande suivante dans le cmd:[/size]\r\n[code]ownerid <VOTRE_STEAM_ID_64> "VOTRE_PSEUDO" "ADMIN"\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ège d''administrateur.[/size]\r\n[b]Lancé 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é à votre serveur en local.[/size]\r\n\r\n[size=100]Afin de savoir si vous êtes admin sur votre serveur, ouvrez le t''chat et tapez un texte au hasard, celui-ci devrais apparaître en vert.\r\n\r\nJe reste à votre disposition pour tout bugs que vous rencontrerai afin d''optimisé / amé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é !\r\nC''est un plaisir de vous offrir ce serveur en plus afin de vous détendre d''avantage auprès de notre communauté et ainsi pouvoir augmenté votre expérience de jeu PVP.\r\nA titre d''information: Le serveur dédié nous coûte environs 25€ par mois sans compté les frais de licence Windows.\r\n\r\nVoici les caractéristique du serveur dédié:\r\n[b]- Processeur:[/b] Intel Xeon 6 vCore - @ 3.099Ghz\r\n[b]- Mé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ée le serveur avec 150 personnes dessus sans problème ! :)\r\n\r\n[/size][right]Bon jeu à tous @Virus_Gamers[/right]', '2016-05-06 17:06:30');
  550.  
  551. -- --------------------------------------------------------
  552.  
  553. --
  554. -- Structure de la table `nf_forum_polls`
  555. --
  556.  
  557. CREATE 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.  
  570. CREATE 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.  
  580. INSERT 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.  
  621. CREATE 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.  
  636. INSERT INTO `nf_forum_topics` (`topic_id`, `forum_id`, `message_id`, `title`, `status`, `views`, `count_messages`, `last_message_id`) VALUES
  637. (2, 5, 2, 'Règlement du forum', '-2', 1, 0, NULL),
  638. (3, 7, 3, 'A propos des présentations', '-2', 1, 0, NULL),
  639. (11, 48, 11, 'Règles du serveur "RustyFrance"', '-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ébergement RustyFrance Battlefield', '0', 0, 0, NULL);
  647.  
  648. -- --------------------------------------------------------
  649.  
  650. --
  651. -- Structure de la table `nf_forum_topics_read`
  652. --
  653.  
  654. CREATE 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.  
  664. INSERT 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.  
  675. CREATE 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.  
  686. CREATE 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.  
  698. CREATE 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.  
  710. INSERT 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.  
  719. CREATE 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.  
  730. INSERT 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.  
  739. CREATE 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.  
  749. INSERT 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.  
  758. CREATE 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.  
  774. INSERT 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.  
  804. CREATE 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.  
  815. INSERT 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.  
  824. CREATE 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.  
  836. INSERT 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.  
  845. CREATE 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.  
  855. INSERT 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.  
  864. CREATE 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.  
  876. INSERT 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.  
  890. CREATE 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.  
  900. INSERT INTO `nf_groups_lang` (`group_id`, `lang`, `title`) VALUES
  901. (5, 'fr', 'Graphiste'),
  902. (6, 'fr', 'Modérateur'),
  903. (7, 'fr', 'Donateur');
  904.  
  905. -- --------------------------------------------------------
  906.  
  907. --
  908. -- Structure de la table `nf_news`
  909. --
  910.  
  911. CREATE 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.  
  926. INSERT 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.  
  936. CREATE 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.  
  947. INSERT 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.  
  957. CREATE 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.  
  967. INSERT INTO `nf_news_categories_lang` (`category_id`, `lang`, `title`) VALUES
  968. (1, 'fr', 'Actualités du site'),
  969. (2, 'fr', 'Actualités du serveur');
  970.  
  971. -- --------------------------------------------------------
  972.  
  973. --
  974. -- Structure de la table `nf_news_lang`
  975. --
  976.  
  977. CREATE 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.  
  990. INSERT INTO `nf_news_lang` (`news_id`, `lang`, `title`, `introduction`, `content`, `tags`) VALUES
  991. (1, 'fr', 'Bienvenue sur notre nouveau site RustyFrance', 'Bienvenue à tous ! \r\nNous avons ouvert se site web suite à l''ouverture du serveur Rust "RustyFrance" , ici vous pourrez trouver toute les infos et les règles du serveur Rust.\r\nCe site n''est pas réserver à la communauté des joueurs Rust ou même au serveur Rust, Ici nous pouvons parler de tout dans l''onglet "Forum".', '', '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 être pour le Samedi 7 mai 2016.[/size]\r\n[size=100]Nous sommes en cours de modification afin d''apporté un maximum de contenu pour le PVP principalement sans pour autant nuire au performance de la machine.\r\n\r\n[right]Bon jeu à vous et à bientôt in game.[/right][/size]', '', '');
  993.  
  994. -- --------------------------------------------------------
  995.  
  996. --
  997. -- Structure de la table `nf_pages`
  998. --
  999.  
  1000. CREATE 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.  
  1010. INSERT 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.  
  1021. CREATE 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.  
  1033. INSERT INTO `nf_pages_lang` (`page_id`, `lang`, `title`, `subtitle`, `content`) VALUES
  1034. (3, 'fr', 'Mentions légales', '', '[u][b][size=150]Données personnelles[/size][/b][/u]\r\n\r\n[size=100]Conformément à la loi « informatique et libertés » du 6 janvier 1978 modifiée en 2004, vous bénéficiez d’un droit d’accès et de rectification aux informations qui vous concernent, que vous pouvez exercer en vous adressant à @Virus_Gamers ou @Fouzii depuis la page de contact.\r\n\r\nVous pouvez également, pour des motifs légitimes, vous opposer au traitement des donné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’un serveur installe sur votre ordinateur et qui permettent de mémoriser des données relatives à l’internaute lorsque celui-ci se connecte au site.\r\nNous utilisons le système des cookies uniquement afin de mémoriser des informations destinées à faciliter votre navigation.\r\nIl ne s''agit en aucun cas de mémoriser des données personnelles vous concernant.\r\nIl vous est par ailleurs possible à tout moment de refuser l''installation de ces cookies voire de les supprimer.\r\nDans ce cas, nous veillons à ce que votre navigation n''en soit nullement empêchée.[/size]\r\n\r\n[u][b][size=150]Hébergement web[/size][/b][/u]\r\n\r\n[size=100]Fièrement assuré par la [url=http://www.easy-hebergement.fr/]Société Easy-Hébergement[/url]\r\nSiè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 à vous pour votre donation. Vous contribuez directement à l’évolution de notre serveur et cela nous touche beaucoup de voir que l’on peut compter sur vous pour avancer !\r\n\r\nGrâce à vous et à votre action, [url=http://rustyfrance.fr/]RustyFrance [/url]va pouvoir à la fois amortir les frais de gestion du serveur et de l''hébergement mais aussi pouvoir au fur et à mesure s’équiper de nouvelles fonctionnalités pour le site afin de toujours vous proposer le meilleur de la qualité !\r\n\r\nJe vous remercie encore une fois pour votre fidélité au fil du temps, votre soutien et le geste que vous venez de faire !\r\n\r\nLe statut "Donateur" vous sera attribuer dans les plus bref délais. \r\n\r\nJe vous dis à très bientô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é à ce point mais je pense que c''est la meilleurs solution afin d''instauré un minimum de respect auprès de la communauté.\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.  
  1044. CREATE 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.  
  1055. CREATE 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.  
  1070. INSERT 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.  
  1109. CREATE 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.  
  1124. INSERT 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.  
  1206. CREATE 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.  
  1218. INSERT 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.  
  1261. CREATE 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.  
  1271. INSERT 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.  
  1315. CREATE 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.  
  1328. INSERT 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.  
  1342. CREATE 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.  
  1354. CREATE 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.  
  1363. INSERT 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.  
  1372. CREATE 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.  
  1381. INSERT 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.  
  1391. CREATE 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.  
  1403. INSERT 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.  
  1417. CREATE 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.  
  1430. INSERT 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.  
  1439. CREATE 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.  
  1450. INSERT 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.  
  1459. CREATE 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.  
  1469. INSERT 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.  
  1479. CREATE 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.  
  1489. INSERT 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.  
  1521. CREATE 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.  
  1539. INSERT 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.  
  1572. CREATE 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.  
  1583. CREATE 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.  
  1596. CREATE 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.  
  1610. CREATE 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.  
  1622. CREATE 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.  
  1637. CREATE 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.  
  1654. INSERT 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.  
  1667. CREATE 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.  
  1680. CREATE 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.  
  1692. INSERT 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. --
  1755. ALTER 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. --
  1763. ALTER TABLE `nf_access_details`
  1764. ADD PRIMARY KEY (`access_id`,`entity`,`type`);
  1765.  
  1766. --
  1767. -- Index pour la table `nf_comments`
  1768. --
  1769. ALTER 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. --
  1778. ALTER 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. --
  1785. ALTER 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. --
  1793. ALTER 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. --
  1800. ALTER TABLE `nf_forum_categories`
  1801. ADD PRIMARY KEY (`category_id`);
  1802.  
  1803. --
  1804. -- Index pour la table `nf_forum_messages`
  1805. --
  1806. ALTER 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. --
  1814. ALTER TABLE `nf_forum_read`
  1815. ADD PRIMARY KEY (`user_id`,`forum_id`);
  1816.  
  1817. --
  1818. -- Index pour la table `nf_forum_topics`
  1819. --
  1820. ALTER 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. --
  1829. ALTER 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. --
  1836. ALTER 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. --
  1843. ALTER TABLE `nf_forum_url`
  1844. ADD PRIMARY KEY (`forum_id`);
  1845.  
  1846. --
  1847. -- Index pour la table `nf_gallery`
  1848. --
  1849. ALTER 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. --
  1857. ALTER 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. --
  1865. ALTER 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. --
  1872. ALTER 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. --
  1882. ALTER 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. --
  1889. ALTER 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. --
  1898. ALTER 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. --
  1905. ALTER TABLE `nf_groups`
  1906. ADD PRIMARY KEY (`group_id`);
  1907.  
  1908. --
  1909. -- Index pour la table `nf_groups_lang`
  1910. --
  1911. ALTER 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. --
  1918. ALTER 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. --
  1927. ALTER 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. --
  1935. ALTER 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. --
  1942. ALTER 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. --
  1949. ALTER 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. --
  1956. ALTER 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. --
  1963. ALTER TABLE `nf_search_keywords`
  1964. ADD PRIMARY KEY (`keyword`);
  1965.  
  1966. --
  1967. -- Index pour la table `nf_sessions`
  1968. --
  1969. ALTER 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. --
  1976. ALTER 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. --
  1984. ALTER TABLE `nf_settings`
  1985. ADD PRIMARY KEY (`name`,`site`,`lang`);
  1986.  
  1987. --
  1988. -- Index pour la table `nf_settings_addons`
  1989. --
  1990. ALTER TABLE `nf_settings_addons`
  1991. ADD PRIMARY KEY (`name`,`type`);
  1992.  
  1993. --
  1994. -- Index pour la table `nf_settings_languages`
  1995. --
  1996. ALTER 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. --
  2003. ALTER 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. --
  2010. ALTER TABLE `nf_statistics`
  2011. ADD PRIMARY KEY (`name`);
  2012.  
  2013. --
  2014. -- Index pour la table `nf_talks`
  2015. --
  2016. ALTER TABLE `nf_talks`
  2017. ADD PRIMARY KEY (`talk_id`);
  2018.  
  2019. --
  2020. -- Index pour la table `nf_talks_messages`
  2021. --
  2022. ALTER TABLE `nf_talks_messages`
  2023. ADD PRIMARY KEY (`message_id`);
  2024.  
  2025. --
  2026. -- Index pour la table `nf_teams`
  2027. --
  2028. ALTER 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. --
  2037. ALTER 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. --
  2044. ALTER TABLE `nf_teams_roles`
  2045. ADD PRIMARY KEY (`role_id`);
  2046.  
  2047. --
  2048. -- Index pour la table `nf_teams_users`
  2049. --
  2050. ALTER 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. --
  2058. ALTER 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. --
  2068. ALTER 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. --
  2075. ALTER 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. --
  2083. ALTER 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. --
  2090. ALTER 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. --
  2097. ALTER 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. --
  2105. ALTER 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. --
  2112. ALTER 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. --
  2120. ALTER 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. --
  2131. ALTER 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. --
  2136. ALTER 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. --
  2141. ALTER 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. --
  2146. ALTER 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. --
  2151. ALTER 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. --
  2156. ALTER 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. --
  2161. ALTER 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. --
  2166. ALTER 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. --
  2171. ALTER 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. --
  2176. ALTER 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. --
  2181. ALTER 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. --
  2186. ALTER 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. --
  2191. ALTER 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. --
  2196. ALTER 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. --
  2201. ALTER 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. --
  2206. ALTER 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. --
  2211. ALTER 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. --
  2216. ALTER 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. --
  2221. ALTER 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. --
  2226. ALTER 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. --
  2231. ALTER 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. --
  2236. ALTER 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. --
  2241. ALTER 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. --
  2246. ALTER 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. --
  2251. ALTER 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. --
  2256. ALTER 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. --
  2261. ALTER 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. --
  2270. ALTER 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. --
  2276. ALTER 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. --
  2282. ALTER 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. --
  2290. ALTER 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. --
  2296. ALTER 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. --
  2302. ALTER 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. --
  2309. ALTER 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. --
  2315. ALTER 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. --
  2323. ALTER 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. --
  2330. ALTER 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. --
  2337. ALTER 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. --
  2343. ALTER 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. --
  2350. ALTER 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. --
  2357. ALTER 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. --
  2364. ALTER 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. --
  2373. ALTER 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. --
  2380. ALTER 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. --
  2388. ALTER 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. --
  2395. ALTER 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. --
  2402. ALTER 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. --
  2410. ALTER 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. --
  2417. ALTER 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. --
  2424. ALTER 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. --
  2431. ALTER 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. --
  2438. ALTER 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. --
  2444. ALTER 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. --
  2451. ALTER 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. --
  2459. ALTER 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. --
  2466. ALTER 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. --
  2474. ALTER 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. --
  2480. ALTER 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. --
  2487. ALTER 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. --
  2494. ALTER 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. --
  2500. ALTER 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. --
  2507. ALTER 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. --
  2514. ALTER 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. --
  2521. ALTER 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. --
  2528. ALTER 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 */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!