· 6 years ago · Jan 24, 2020, 09:02 AM
1#------------------------------------------
2# Database Backup Class nuked-klan
3# Database: mineart
4# Date: Sat, 22 Feb 2014 20:20:56 GMT
5#------------------------------------------
6
7#------------------------------------------
8# Table definition for nuked_action
9#------------------------------------------
10DROP TABLE IF EXISTS nuked_action;
11
12CREATE TABLE nuked_action (
13 id int(11) NOT NULL auto_increment,
14 date varchar(30) DEFAULT '0' NOT NULL,
15 pseudo text NOT NULL,
16 action text NOT NULL,
17 PRIMARY KEY (id)
18);
19#------------------------------------------
20# Data inserts for nuked_action
21#------------------------------------------
22INSERT INTO nuked_action VALUES ('321','1392231032','pwmfyl1w1U0rCh5lrrzU','s\'est connecté à l\'administration');
23INSERT INTO nuked_action VALUES ('322','1392231106','pwmfyl1w1U0rCh5lrrzU','a modifié les préférences générales.');
24INSERT INTO nuked_action VALUES ('323','1392389047','pwmfyl1w1U0rCh5lrrzU','s\'est connecté à l\'administration');
25INSERT INTO nuked_action VALUES ('324','1392389193','pwmfyl1w1U0rCh5lrrzU','a modifié les préférences générales.');
26INSERT INTO nuked_action VALUES ('325','1392450189','pwmfyl1w1U0rCh5lrrzU','s\'est connecté à l\'administration');
27INSERT INTO nuked_action VALUES ('326','1392450224','pwmfyl1w1U0rCh5lrrzU','a modifié les préférences générales.');
28INSERT INTO nuked_action VALUES ('327','1392457586','pwmfyl1w1U0rCh5lrrzU','s\'est connecté à l\'administration');
29INSERT INTO nuked_action VALUES ('328','1392457612','pwmfyl1w1U0rCh5lrrzU','a modifié les préférences générales.');
30INSERT INTO nuked_action VALUES ('329','1392499543','pwmfyl1w1U0rCh5lrrzU','s\'est connecté à l\'administration');
31INSERT INTO nuked_action VALUES ('330','1392499563','pwmfyl1w1U0rCh5lrrzU','a modifié les préférences générales.');
32INSERT INTO nuked_action VALUES ('331','1392499887','pwmfyl1w1U0rCh5lrrzU','a modifié les préférences générales.');
33INSERT INTO nuked_action VALUES ('332','1392552746','pwmfyl1w1U0rCh5lrrzU','s\'est connecté à l\'administration');
34INSERT INTO nuked_action VALUES ('333','1392552769','pwmfyl1w1U0rCh5lrrzU','a modifié les préférences générales.');
35INSERT INTO nuked_action VALUES ('334','1392553003','pwmfyl1w1U0rCh5lrrzU','a modifié les préférences générales.');
36INSERT INTO nuked_action VALUES ('335','1393100317','pwmfyl1w1U0rCh5lrrzU','s\'est connecté à l\'administration');
37INSERT INTO nuked_action VALUES ('336','1393100449','pwmfyl1w1U0rCh5lrrzU','a modifié les préférences générales.');
38
39
40#------------------------------------------
41# Table definition for nuked_banned
42#------------------------------------------
43DROP TABLE IF EXISTS nuked_banned;
44
45CREATE TABLE nuked_banned (
46 id int(11) NOT NULL auto_increment,
47 ip varchar(50) NOT NULL,
48 pseudo varchar(50) NOT NULL,
49 email varchar(80) NOT NULL,
50 date varchar(20),
51 dure varchar(20),
52 texte text NOT NULL,
53 PRIMARY KEY (id)
54);
55#------------------------------------------
56# Data inserts for nuked_banned
57#------------------------------------------
58INSERT INTO nuked_banned VALUES ('1','220.161.127.59','489uknz5','','1386601740','0','');
59
60
61#------------------------------------------
62# Table definition for nuked_block
63#------------------------------------------
64DROP TABLE IF EXISTS nuked_block;
65
66CREATE TABLE nuked_block (
67 bid int(10) NOT NULL auto_increment,
68 active int(1) DEFAULT '0' NOT NULL,
69 position int(2) DEFAULT '0' NOT NULL,
70 module varchar(100) NOT NULL,
71 titre text NOT NULL,
72 content text NOT NULL,
73 type varchar(30) DEFAULT '0' NOT NULL,
74 nivo int(1) DEFAULT '0' NOT NULL,
75 page text NOT NULL,
76 PRIMARY KEY (bid)
77);
78#------------------------------------------
79# Data inserts for nuked_block
80#------------------------------------------
81INSERT INTO nuked_block VALUES ('1','2','1','','Login','','login','0','Tous');
82INSERT INTO nuked_block VALUES ('2','1','1','','Menu','[News]|News||0|NEWLINE[Archives]|Archives||0|NEWLINE[Forum]|Forum||0|NEWLINE[Recruit]|<img src=\"images/puces/none.gif\" style=\"border: 0;\" alt=\"\" />Devenir villageois|Devenez villageois !!!!!|0||NEWLINE[Sections]|Articles||0|NEWLINE[Links]|Liens Web||0|NEWLINE[Calendar]|Calendrier||0|NEWLINE[Gallery]|<img src=\"images/puces/none.gif\" style=\"border: 0;\" alt=\"\" />Galerie Photos||1||NEWLINE[Guestbook]|Livre d\'Or||0|NEWLINE|<b>Membre</b>||1|NEWLINE[User]|Compte||1|NEWLINE|<b>Admin</b>||2|NEWLINE[Admin]|Administration||2|NEWLINE[Contact]|<img src=\"images/puces/none.gif\" style=\"border: 0;\" alt=\"\" />Nous contacter|écrivez nous!!!!|0||','menu','0','Tous');
83INSERT INTO nuked_block VALUES ('13','0','2','','Pub','Votre pub ici','html','0','Tous');
84INSERT INTO nuked_block VALUES ('14','1','2','Video','Vidéos','','module','0','Tous');
85INSERT INTO nuked_block VALUES ('4','1','2','','Sondage','1','survey','0','Tous');
86INSERT INTO nuked_block VALUES ('5','0','3','Wars','Matchs','','module','0','Tous');
87INSERT INTO nuked_block VALUES ('6','1','3','Stats','Stats','','module','0','Tous');
88INSERT INTO nuked_block VALUES ('7','0','0','Irc','Irc Awards','','module','0','Tous');
89INSERT INTO nuked_block VALUES ('8','0','0','Server','Serveur monitor','','module','0','Tous');
90INSERT INTO nuked_block VALUES ('9','0','0','','Suggestion','','suggest','1','Tous');
91INSERT INTO nuked_block VALUES ('10','2','2','Textbox','Tribune libre','','module','0','Tous');
92INSERT INTO nuked_block VALUES ('12','0','4','','Calendrier','','event','0','Tous');
93
94
95#------------------------------------------
96# Table definition for nuked_calendar
97#------------------------------------------
98DROP TABLE IF EXISTS nuked_calendar;
99
100CREATE TABLE nuked_calendar (
101 id int(11) NOT NULL auto_increment,
102 titre text NOT NULL,
103 description text NOT NULL,
104 date_jour int(2),
105 date_mois int(2),
106 date_an int(4),
107 heure varchar(5) NOT NULL,
108 auteur text NOT NULL,
109 PRIMARY KEY (id)
110);
111
112
113#------------------------------------------
114# Table definition for nuked_comment
115#------------------------------------------
116DROP TABLE IF EXISTS nuked_comment;
117
118CREATE TABLE nuked_comment (
119 id int(10) NOT NULL auto_increment,
120 module varchar(30) DEFAULT '0' NOT NULL,
121 im_id int(100),
122 autor text,
123 autor_id varchar(20) NOT NULL,
124 titre text NOT NULL,
125 comment text,
126 date varchar(12),
127 autor_ip varchar(20),
128 PRIMARY KEY (id),
129 KEY im_id (im_id)
130);
131#------------------------------------------
132# Data inserts for nuked_comment
133#------------------------------------------
134INSERT INTO nuked_comment VALUES ('8','Download','3','Yann80240','pwmfyl1w1U0rCh5lrrzU','','Ce mod n'est plus a jours dsl','1370701675','83.198.198.2');
135INSERT INTO nuked_comment VALUES ('7','Survey','1','Yann80240','pwmfyl1w1U0rCh5lrrzU','','merci a toi mon amis ','1369994141','88.169.59.128');
136INSERT INTO nuked_comment VALUES ('6','Survey','1','sebastien','','','ton serveur pour le meilleur au monde ton cher amis sebastien','1367955096','86.204.247.247');
137INSERT INTO nuked_comment VALUES ('9','Survey','1','Red_Rex_','f40fe4a1d21320221631','','se serveur est juste génial car il ya peut de personne et c'est calme et j'adore sa moi <br />
138c'est pour ça que j'aimerait être animateur pour animer et aider les personne qui en on besoin<br />
139votre cher amis Red_Rex_ ','1385291336','92.163.105.178');
140INSERT INTO nuked_comment VALUES ('10','news','1','hdsff','','','Le code HTML est mal formaté','1389860254','213.199.248.199');
141
142
143#------------------------------------------
144# Table definition for nuked_comment_mod
145#------------------------------------------
146DROP TABLE IF EXISTS nuked_comment_mod;
147
148CREATE TABLE nuked_comment_mod (
149 id int(11) NOT NULL auto_increment,
150 module text NOT NULL,
151 active int(1) NOT NULL,
152 PRIMARY KEY (id)
153);
154#------------------------------------------
155# Data inserts for nuked_comment_mod
156#------------------------------------------
157INSERT INTO nuked_comment_mod VALUES ('1','news','1');
158INSERT INTO nuked_comment_mod VALUES ('2','download','1');
159INSERT INTO nuked_comment_mod VALUES ('3','links','1');
160INSERT INTO nuked_comment_mod VALUES ('4','survey','1');
161INSERT INTO nuked_comment_mod VALUES ('5','wars','1');
162INSERT INTO nuked_comment_mod VALUES ('6','gallery','1');
163INSERT INTO nuked_comment_mod VALUES ('7','sections','1');
164INSERT INTO nuked_comment_mod VALUES ('8','video','1');
165
166
167#------------------------------------------
168# Table definition for nuked_config
169#------------------------------------------
170DROP TABLE IF EXISTS nuked_config;
171
172CREATE TABLE nuked_config (
173 name varchar(255) NOT NULL,
174 value text NOT NULL,
175 PRIMARY KEY (name)
176);
177#------------------------------------------
178# Data inserts for nuked_config
179#------------------------------------------
180INSERT INTO nuked_config VALUES ('time_generate','off');
181INSERT INTO nuked_config VALUES ('dateformat','%d/%m/%Y');
182INSERT INTO nuked_config VALUES ('datezone','+0100');
183INSERT INTO nuked_config VALUES ('version','1.7.9');
184INSERT INTO nuked_config VALUES ('date_install','1365240118');
185INSERT INTO nuked_config VALUES ('langue','french');
186INSERT INTO nuked_config VALUES ('stats_share','0');
187INSERT INTO nuked_config VALUES ('stats_timestamp','37238400');
188INSERT INTO nuked_config VALUES ('name','MineArt');
189INSERT INTO nuked_config VALUES ('slogan','Par Yann Martin');
190INSERT INTO nuked_config VALUES ('tag_pre','');
191INSERT INTO nuked_config VALUES ('tag_suf','');
192INSERT INTO nuked_config VALUES ('url','http://mineart.free.fr');
193INSERT INTO nuked_config VALUES ('mail','yannmartin@live.fr');
194INSERT INTO nuked_config VALUES ('footmessage','coded by YannMartin80');
195INSERT INTO nuked_config VALUES ('nk_status','open');
196INSERT INTO nuked_config VALUES ('index_site','News');
197INSERT INTO nuked_config VALUES ('theme','Absolut');
198INSERT INTO nuked_config VALUES ('keyword','');
199INSERT INTO nuked_config VALUES ('description','');
200INSERT INTO nuked_config VALUES ('inscription','on');
201INSERT INTO nuked_config VALUES ('inscription_mail','Bonjours vous venez de valider votre compte vous pouvez vous y<br />
202connecter !<br />
203 Cordialement , l'equipe MineArt !');
204INSERT INTO nuked_config VALUES ('inscription_avert','on');
205INSERT INTO nuked_config VALUES ('inscription_charte','<div style=\"text-align: center;\">
206 <em><strong>Bienvenue sur notre site pour rejoindre la communauté "Mineart"<br />
207 Regle n°1 /Ne pas ce créer plus de deux compte MineArt.<br />
208 Regle n°2/Il est maintenant possible de créer un forum sur ce site le forum ne doit<br />
209 pas parler de vos chose personnel sinon votre compte sera supprimer !<br />
210 Chaine Youtube du createur de MineArt: www.YouTube.com/YannMartin80<br />
211 Ip du serveur MineArt: mineart.location-minecraft.fr</strong></em></div>
212');
213INSERT INTO nuked_config VALUES ('validation','mail');
214INSERT INTO nuked_config VALUES ('user_delete','on');
215INSERT INTO nuked_config VALUES ('video_editeur','on');
216INSERT INTO nuked_config VALUES ('scayt_editeur','on');
217INSERT INTO nuked_config VALUES ('suggest_avert','');
218INSERT INTO nuked_config VALUES ('irc_chan','mineart');
219INSERT INTO nuked_config VALUES ('irc_serv','mineart.no-ip.org');
220INSERT INTO nuked_config VALUES ('server_ip','');
221INSERT INTO nuked_config VALUES ('server_port','');
222INSERT INTO nuked_config VALUES ('server_pass','');
223INSERT INTO nuked_config VALUES ('server_game','');
224INSERT INTO nuked_config VALUES ('forum_title','');
225INSERT INTO nuked_config VALUES ('forum_desc','');
226INSERT INTO nuked_config VALUES ('forum_rank_team','off');
227INSERT INTO nuked_config VALUES ('forum_field_max','10');
228INSERT INTO nuked_config VALUES ('forum_file','on');
229INSERT INTO nuked_config VALUES ('forum_file_level','1');
230INSERT INTO nuked_config VALUES ('forum_file_maxsize','1000');
231INSERT INTO nuked_config VALUES ('thread_forum_page','20');
232INSERT INTO nuked_config VALUES ('mess_forum_page','10');
233INSERT INTO nuked_config VALUES ('hot_topic','20');
234INSERT INTO nuked_config VALUES ('post_flood','10');
235INSERT INTO nuked_config VALUES ('gallery_title','');
236INSERT INTO nuked_config VALUES ('max_img_line','2');
237INSERT INTO nuked_config VALUES ('max_img','6');
238INSERT INTO nuked_config VALUES ('max_news','5');
239INSERT INTO nuked_config VALUES ('max_download','10');
240INSERT INTO nuked_config VALUES ('hide_download','on');
241INSERT INTO nuked_config VALUES ('max_liens','10');
242INSERT INTO nuked_config VALUES ('max_sections','10');
243INSERT INTO nuked_config VALUES ('max_wars','30');
244INSERT INTO nuked_config VALUES ('max_archives','30');
245INSERT INTO nuked_config VALUES ('max_members','30');
246INSERT INTO nuked_config VALUES ('max_shout','20');
247INSERT INTO nuked_config VALUES ('mess_guest_page','10');
248INSERT INTO nuked_config VALUES ('sond_delay','24');
249INSERT INTO nuked_config VALUES ('level_analys','0');
250INSERT INTO nuked_config VALUES ('visit_delay','30');
251INSERT INTO nuked_config VALUES ('recrute','1');
252INSERT INTO nuked_config VALUES ('recrute_charte','');
253INSERT INTO nuked_config VALUES ('recrute_mail','');
254INSERT INTO nuked_config VALUES ('recrute_inbox','pwmfyl1w1U0rCh5lrrzU');
255INSERT INTO nuked_config VALUES ('defie_charte','');
256INSERT INTO nuked_config VALUES ('defie_mail','');
257INSERT INTO nuked_config VALUES ('defie_inbox','');
258INSERT INTO nuked_config VALUES ('birthday','all');
259INSERT INTO nuked_config VALUES ('avatar_upload','on');
260INSERT INTO nuked_config VALUES ('avatar_url','on');
261INSERT INTO nuked_config VALUES ('cookiename','nuked');
262INSERT INTO nuked_config VALUES ('sess_inactivemins','5');
263INSERT INTO nuked_config VALUES ('sess_days_limit','365');
264INSERT INTO nuked_config VALUES ('nbc_timeout','300');
265INSERT INTO nuked_config VALUES ('screen','on');
266INSERT INTO nuked_config VALUES ('contact_mail','yannmartin@live.fr');
267INSERT INTO nuked_config VALUES ('contact_flood','60');
268INSERT INTO nuked_config VALUES ('max_video','10');
269INSERT INTO nuked_config VALUES ('cat_idem','1');
270
271
272#------------------------------------------
273# Table definition for nuked_contact
274#------------------------------------------
275DROP TABLE IF EXISTS nuked_contact;
276
277CREATE TABLE nuked_contact (
278 id int(11) NOT NULL auto_increment,
279 titre varchar(200) NOT NULL,
280 message text NOT NULL,
281 email varchar(80) NOT NULL,
282 nom varchar(200) NOT NULL,
283 ip varchar(50) NOT NULL,
284 date varchar(30) NOT NULL,
285 PRIMARY KEY (id),
286 KEY titre (titre)
287);
288
289
290#------------------------------------------
291# Table definition for nuked_defie
292#------------------------------------------
293DROP TABLE IF EXISTS nuked_defie;
294
295CREATE TABLE nuked_defie (
296 id int(11) NOT NULL auto_increment,
297 send varchar(12) NOT NULL,
298 pseudo text NOT NULL,
299 clan text NOT NULL,
300 mail varchar(80) NOT NULL,
301 icq varchar(50) NOT NULL,
302 irc varchar(50) NOT NULL,
303 url varchar(200) NOT NULL,
304 pays text NOT NULL,
305 date varchar(20) NOT NULL,
306 heure varchar(10) NOT NULL,
307 serveur text NOT NULL,
308 game int(11) DEFAULT '0' NOT NULL,
309 type text NOT NULL,
310 map text NOT NULL,
311 comment text NOT NULL,
312 PRIMARY KEY (id)
313);
314
315
316#------------------------------------------
317# Table definition for nuked_discussion
318#------------------------------------------
319DROP TABLE IF EXISTS nuked_discussion;
320
321CREATE TABLE nuked_discussion (
322 id int(11) NOT NULL auto_increment,
323 date varchar(30) DEFAULT '0' NOT NULL,
324 pseudo text NOT NULL,
325 texte text NOT NULL,
326 PRIMARY KEY (id)
327);
328
329
330#------------------------------------------
331# Table definition for nuked_downloads
332#------------------------------------------
333DROP TABLE IF EXISTS nuked_downloads;
334
335CREATE TABLE nuked_downloads (
336 id int(11) NOT NULL auto_increment,
337 date varchar(12) NOT NULL,
338 taille varchar(6) DEFAULT '0' NOT NULL,
339 titre text NOT NULL,
340 description text NOT NULL,
341 type int(11) DEFAULT '0' NOT NULL,
342 count int(10) DEFAULT '0' NOT NULL,
343 url varchar(200) NOT NULL,
344 url2 varchar(200) NOT NULL,
345 broke int(11) DEFAULT '0' NOT NULL,
346 url3 varchar(200) NOT NULL,
347 level int(1) DEFAULT '0' NOT NULL,
348 hit int(11) DEFAULT '0' NOT NULL,
349 edit varchar(12) NOT NULL,
350 screen varchar(200) NOT NULL,
351 autor text NOT NULL,
352 url_autor varchar(200) NOT NULL,
353 comp text NOT NULL,
354 PRIMARY KEY (id),
355 KEY type (type)
356);
357#------------------------------------------
358# Data inserts for nuked_downloads
359#------------------------------------------
360INSERT INTO nuked_downloads VALUES ('3','1365348166','59,7','mode world','Mode qui permet de telecharger les map d'un serveur minecraft.','2','3','upload/Download/22e2faf381.zip','','0','','0','8','','','Yann80240','','');
361INSERT INTO nuked_downloads VALUES ('4','1370701798','','Force Op','Ce plugin vous permais de vous op sur tout les serveur !','2','0','upload/Suggest/1370701895.rar','','0','','0','4','','','Yann80240','http://mineart.free.fr','1.5.2');
362INSERT INTO nuked_downloads VALUES ('5','1370702265','','GroupManager','Se plugin permais de mettre des grade mais pour sa il faut essentials !','3','6','upload/Suggest/1370702368.rar','','0','','0','13','','','Yann80240','http://mineart.free.fr','1.5.2');
363INSERT INTO nuked_downloads VALUES ('6','1370702409','','Essentials','Se plugin est essentiel pour votre serveur il ajoute plus de 100 command ex: /nick , /gm ,/god ...','3','8','upload/Suggest/1370702514.zip','','0','','0','13','','','Yann80240','http://mineart.free.fr','1.5.2');
364INSERT INTO nuked_downloads VALUES ('7','1387382267','0,05','RUN','RUN pour craftbukkit','0','2','upload/Download/24c95c3fef.bat','','0','','0','2','','','Yann80240','http://mineart.free.fr/','');
365
366
367#------------------------------------------
368# Table definition for nuked_downloads_cat
369#------------------------------------------
370DROP TABLE IF EXISTS nuked_downloads_cat;
371
372CREATE TABLE nuked_downloads_cat (
373 cid int(11) NOT NULL auto_increment,
374 parentid int(11) DEFAULT '0' NOT NULL,
375 titre varchar(50) NOT NULL,
376 description text NOT NULL,
377 level int(1) DEFAULT '0' NOT NULL,
378 position int(2) unsigned DEFAULT '0' NOT NULL,
379 PRIMARY KEY (cid),
380 KEY parentid (parentid)
381);
382#------------------------------------------
383# Data inserts for nuked_downloads_cat
384#------------------------------------------
385INSERT INTO nuked_downloads_cat VALUES ('1','0','Fonds d\'écran','Partageons nos fond d'écran.','1','1');
386INSERT INTO nuked_downloads_cat VALUES ('2','0','mode minecraft','','3','2');
387INSERT INTO nuked_downloads_cat VALUES ('3','0','Plugins bukkit','','0','0');
388
389
390#------------------------------------------
391# Table definition for nuked_erreursql
392#------------------------------------------
393DROP TABLE IF EXISTS nuked_erreursql;
394
395CREATE TABLE nuked_erreursql (
396 id int(11) NOT NULL auto_increment,
397 date varchar(30) DEFAULT '0' NOT NULL,
398 lien text NOT NULL,
399 texte text NOT NULL,
400 PRIMARY KEY (id)
401);
402
403
404#------------------------------------------
405# Table definition for nuked_forums
406#------------------------------------------
407DROP TABLE IF EXISTS nuked_forums;
408
409CREATE TABLE nuked_forums (
410 id int(5) NOT NULL auto_increment,
411 cat int(11) DEFAULT '0' NOT NULL,
412 nom text NOT NULL,
413 comment text NOT NULL,
414 moderateurs text NOT NULL,
415 niveau int(1) DEFAULT '0' NOT NULL,
416 level int(1) DEFAULT '0' NOT NULL,
417 ordre int(5) DEFAULT '0' NOT NULL,
418 level_poll int(1) DEFAULT '0' NOT NULL,
419 level_vote int(1) DEFAULT '0' NOT NULL,
420 PRIMARY KEY (id),
421 KEY cat (cat)
422);
423#------------------------------------------
424# Data inserts for nuked_forums
425#------------------------------------------
426INSERT INTO nuked_forums VALUES ('1','1','Forum','Test Forum','','0','0','0','1','1');
427
428
429#------------------------------------------
430# Table definition for nuked_forums_cat
431#------------------------------------------
432DROP TABLE IF EXISTS nuked_forums_cat;
433
434CREATE TABLE nuked_forums_cat (
435 id int(11) NOT NULL auto_increment,
436 nom varchar(100),
437 ordre int(5) DEFAULT '0' NOT NULL,
438 niveau int(1) DEFAULT '0' NOT NULL,
439 PRIMARY KEY (id)
440);
441#------------------------------------------
442# Data inserts for nuked_forums_cat
443#------------------------------------------
444INSERT INTO nuked_forums_cat VALUES ('1','Categorie 1','0','0');
445
446
447#------------------------------------------
448# Table definition for nuked_forums_messages
449#------------------------------------------
450DROP TABLE IF EXISTS nuked_forums_messages;
451
452CREATE TABLE nuked_forums_messages (
453 id int(5) NOT NULL auto_increment,
454 titre text NOT NULL,
455 txt text NOT NULL,
456 date varchar(12) NOT NULL,
457 edition text NOT NULL,
458 auteur text NOT NULL,
459 auteur_id varchar(20) NOT NULL,
460 auteur_ip varchar(20) NOT NULL,
461 bbcodeoff int(1) DEFAULT '0' NOT NULL,
462 smileyoff int(1) DEFAULT '0' NOT NULL,
463 cssoff int(1) DEFAULT '0' NOT NULL,
464 usersig int(1) DEFAULT '0' NOT NULL,
465 emailnotify int(1) DEFAULT '0' NOT NULL,
466 thread_id int(5) DEFAULT '0' NOT NULL,
467 forum_id mediumint(10) DEFAULT '0' NOT NULL,
468 file varchar(200) NOT NULL,
469 PRIMARY KEY (id),
470 KEY auteur_id (auteur_id),
471 KEY thread_id (thread_id),
472 KEY forum_id (forum_id)
473);
474#------------------------------------------
475# Data inserts for nuked_forums_messages
476#------------------------------------------
477INSERT INTO nuked_forums_messages VALUES ('2','Information sur le Serveur','Mineart est maintenant hébergé sur mon propre serveur.<br />
478Il sera donc ouvert quasiment 7jrs/7.<br />
479Venez donc nous y retrouver pour jouer ensemble.<br />
480 merci & à très vite....<br />
481 ','1365357569','Edité par Herve80240 le 08/04/2013','Yann80240','pwmfyl1w1U0rCh5lrrzU','83.192.166.12','0','0','0','1','1','2','1','');
482INSERT INTO nuked_forums_messages VALUES ('5','Passer Vip','Bonjours a tous<br />
483Pour passer au grade Vip il faut vous inscrire puis vous poster un message dans se forum et puis si votre nom sur le site n'est pas le méme que sur minecraft dite moi votre nom minecraft.<br />
484 merci a plus sur le serveur.','1367518909','Edité par Yann80240 le 06/05/2013','Yann80240','pwmfyl1w1U0rCh5lrrzU','83.192.43.131','0','0','0','0','1','5','1','');
485
486
487#------------------------------------------
488# Table definition for nuked_forums_options
489#------------------------------------------
490DROP TABLE IF EXISTS nuked_forums_options;
491
492CREATE TABLE nuked_forums_options (
493 id int(11) DEFAULT '0' NOT NULL,
494 poll_id int(11) DEFAULT '0' NOT NULL,
495 option_text varchar(255) NOT NULL,
496 option_vote int(11) DEFAULT '0' NOT NULL,
497 KEY poll_id (poll_id)
498);
499
500
501#------------------------------------------
502# Table definition for nuked_forums_poll
503#------------------------------------------
504DROP TABLE IF EXISTS nuked_forums_poll;
505
506CREATE TABLE nuked_forums_poll (
507 id int(11) NOT NULL auto_increment,
508 thread_id int(11) DEFAULT '0' NOT NULL,
509 titre varchar(255) NOT NULL,
510 PRIMARY KEY (id),
511 KEY thread_id (thread_id)
512);
513
514
515#------------------------------------------
516# Table definition for nuked_forums_rank
517#------------------------------------------
518DROP TABLE IF EXISTS nuked_forums_rank;
519
520CREATE TABLE nuked_forums_rank (
521 id int(10) NOT NULL auto_increment,
522 nom varchar(100) NOT NULL,
523 type int(1) DEFAULT '0' NOT NULL,
524 post int(4) DEFAULT '0' NOT NULL,
525 image varchar(200) NOT NULL,
526 PRIMARY KEY (id)
527);
528#------------------------------------------
529# Data inserts for nuked_forums_rank
530#------------------------------------------
531INSERT INTO nuked_forums_rank VALUES ('1','Noob','0','0','modules/Forum/images/rank/star1.gif');
532INSERT INTO nuked_forums_rank VALUES ('2','Jeune membre','0','10','modules/Forum/images/rank/star2.gif');
533INSERT INTO nuked_forums_rank VALUES ('3','Membre','0','100','modules/Forum/images/rank/star3.gif');
534INSERT INTO nuked_forums_rank VALUES ('4','Membre averti','0','500','modules/Forum/images/rank/star4.gif');
535INSERT INTO nuked_forums_rank VALUES ('5','Posteur Fou','0','1000','modules/Forum/images/rank/star5.gif');
536INSERT INTO nuked_forums_rank VALUES ('6','Modérateur','1','0','modules/Forum/images/rank/mod.gif');
537INSERT INTO nuked_forums_rank VALUES ('7','Administrateur','2','0','modules/Forum/images/rank/mod.gif');
538
539
540#------------------------------------------
541# Table definition for nuked_forums_read
542#------------------------------------------
543DROP TABLE IF EXISTS nuked_forums_read;
544
545CREATE TABLE nuked_forums_read (
546 user_id varchar(20) NOT NULL,
547 thread_id text NOT NULL,
548 forum_id text NOT NULL,
549 PRIMARY KEY (user_id)
550);
551#------------------------------------------
552# Data inserts for nuked_forums_read
553#------------------------------------------
554INSERT INTO nuked_forums_read VALUES ('pwmfyl1w1U0rCh5lrrzU',',1,2,5,',',1,');
555INSERT INTO nuked_forums_read VALUES ('07f263efab2915dbadbf',',1,2,3,4,',',');
556INSERT INTO nuked_forums_read VALUES ('4039e108a07882afbefb',',3,',',');
557INSERT INTO nuked_forums_read VALUES ('4035d736cb3dd124179b',',4,',',');
558
559
560#------------------------------------------
561# Table definition for nuked_forums_threads
562#------------------------------------------
563DROP TABLE IF EXISTS nuked_forums_threads;
564
565CREATE TABLE nuked_forums_threads (
566 id int(5) NOT NULL auto_increment,
567 titre text NOT NULL,
568 date varchar(10),
569 closed int(1) DEFAULT '0' NOT NULL,
570 auteur text NOT NULL,
571 auteur_id varchar(20) NOT NULL,
572 forum_id int(5) DEFAULT '0' NOT NULL,
573 last_post varchar(20) NOT NULL,
574 view int(10) DEFAULT '0' NOT NULL,
575 annonce int(1) DEFAULT '0' NOT NULL,
576 sondage int(1) DEFAULT '0' NOT NULL,
577 PRIMARY KEY (id),
578 KEY auteur_id (auteur_id),
579 KEY forum_id (forum_id)
580);
581#------------------------------------------
582# Data inserts for nuked_forums_threads
583#------------------------------------------
584INSERT INTO nuked_forums_threads VALUES ('2','Information sur le Serveur','1365357569','0','Yann80240','pwmfyl1w1U0rCh5lrrzU','1','1365357569','29','0','0');
585INSERT INTO nuked_forums_threads VALUES ('5','Passer Vip','1367518909','0','Yann80240','pwmfyl1w1U0rCh5lrrzU','1','1367518909','23','0','0');
586
587
588#------------------------------------------
589# Table definition for nuked_forums_vote
590#------------------------------------------
591DROP TABLE IF EXISTS nuked_forums_vote;
592
593CREATE TABLE nuked_forums_vote (
594 poll_id int(11) DEFAULT '0' NOT NULL,
595 auteur_id varchar(20) NOT NULL,
596 auteur_ip varchar(20) NOT NULL,
597 KEY poll_id (poll_id)
598);
599
600
601#------------------------------------------
602# Table definition for nuked_gallery
603#------------------------------------------
604DROP TABLE IF EXISTS nuked_gallery;
605
606CREATE TABLE nuked_gallery (
607 sid int(11) NOT NULL auto_increment,
608 titre text NOT NULL,
609 description text NOT NULL,
610 url varchar(200) NOT NULL,
611 url2 varchar(200) NOT NULL,
612 url_file varchar(200) NOT NULL,
613 cat int(11) DEFAULT '0' NOT NULL,
614 date varchar(12) NOT NULL,
615 count int(10) DEFAULT '0' NOT NULL,
616 autor text NOT NULL,
617 PRIMARY KEY (sid),
618 KEY cat (cat)
619);
620
621
622#------------------------------------------
623# Table definition for nuked_gallery_cat
624#------------------------------------------
625DROP TABLE IF EXISTS nuked_gallery_cat;
626
627CREATE TABLE nuked_gallery_cat (
628 cid int(11) NOT NULL auto_increment,
629 parentid int(11) DEFAULT '0' NOT NULL,
630 titre varchar(50) NOT NULL,
631 description text NOT NULL,
632 position int(2) unsigned DEFAULT '0' NOT NULL,
633 PRIMARY KEY (cid),
634 KEY parentid (parentid)
635);
636
637
638#------------------------------------------
639# Table definition for nuked_games
640#------------------------------------------
641DROP TABLE IF EXISTS nuked_games;
642
643CREATE TABLE nuked_games (
644 id int(11) NOT NULL auto_increment,
645 name varchar(50) NOT NULL,
646 titre varchar(50) NOT NULL,
647 icon varchar(150) NOT NULL,
648 pref_1 varchar(50) NOT NULL,
649 pref_2 varchar(50) NOT NULL,
650 pref_3 varchar(50) NOT NULL,
651 pref_4 varchar(50) NOT NULL,
652 pref_5 varchar(50) NOT NULL,
653 map text NOT NULL,
654 PRIMARY KEY (id)
655);
656#------------------------------------------
657# Data inserts for nuked_games
658#------------------------------------------
659INSERT INTO nuked_games VALUES ('1','mineart','Préférences CS','images/games/cs.gif','Autre pseudo','Map favorite','Arme favorite','Skin Terro','Skin CT','de_dust2|de_inferno');
660
661
662#------------------------------------------
663# Table definition for nuked_games_prefs
664#------------------------------------------
665DROP TABLE IF EXISTS nuked_games_prefs;
666
667CREATE TABLE nuked_games_prefs (
668 id int(11) NOT NULL auto_increment,
669 game int(11) DEFAULT '0' NOT NULL,
670 user_id varchar(20) NOT NULL,
671 pref_1 text NOT NULL,
672 pref_2 text NOT NULL,
673 pref_3 text NOT NULL,
674 pref_4 text NOT NULL,
675 pref_5 text NOT NULL,
676 PRIMARY KEY (id)
677);
678
679>: Code Ghost Decrypted: http://mineart.free.fr/mineart.sql