/
install.database.php
693 lines (633 loc) · 39.6 KB
/
install.database.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
<?PHP
/* ====================
Seditio - Website engine
Copyright Neocrome & Seditio Team
http://www.neocrome.net
https://seditio.org
[BEGIN_SED]
File=install.database.php
Version=178
Updated=2021-jun-17
Type=Core.install
Author=Neocrome
Description=Database builder
[END_SED]
==================== */
if ( !defined('SED_CODE') || !defined('SED_INSTALL') ) { die('Wrong URL.'); }
$sql = sed_sql_query("CREATE TABLE ".$cfg['mysqldb']."auth (
auth_id mediumint(8) NOT NULL auto_increment,
auth_groupid int(11) NOT NULL default '0',
auth_code varchar(255) NOT NULL default '',
auth_option varchar(255) NOT NULL default '',
auth_rights tinyint(1) unsigned NOT NULL default '0',
auth_rights_lock tinyint(1) unsigned NOT NULL default '0',
auth_setbyuserid int(11) unsigned NOT NULL default '0',
PRIMARY KEY (auth_id),
KEY auth_groupid (auth_groupid),
KEY auth_code (auth_code)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;");
$sql = sed_sql_query("CREATE TABLE ".$cfg['mysqldb']."banlist (
banlist_id int(11) NOT NULL auto_increment,
banlist_ip varchar(15) NOT NULL default '',
banlist_email varchar(64) NOT NULL default '',
banlist_reason varchar(64) NOT NULL default '',
banlist_expire int(11) default '0',
PRIMARY KEY (banlist_id),
KEY banlist_ip (banlist_ip)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;");
$sql = sed_sql_query("CREATE TABLE ".$cfg['mysqldb']."cache (
c_name varchar(16) NOT NULL default '',
c_expire int(11) NOT NULL default '0',
c_auto tinyint(1) NOT NULL default '1',
c_value text,
PRIMARY KEY (c_name)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;");
$sql = sed_sql_query("CREATE TABLE ".$cfg['mysqldb']."com (
com_id int(11) NOT NULL auto_increment,
com_code varchar(16) NOT NULL default '',
com_author varchar(24) NOT NULL default '',
com_authorid int(11) default NULL,
com_authorip varchar(15) NOT NULL default '',
com_text text NOT NULL,
com_text_ishtml tinyint(1) DEFAULT '1',
com_date int(11) NOT NULL default '0',
com_count int(11) NOT NULL default '0',
com_rating tinyint(1) DEFAULT '0',
com_isspecial tinyint(1) NOT NULL default '0',
PRIMARY KEY (com_id),
KEY com_code (com_code)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;");
$sql = sed_sql_query("CREATE TABLE ".$cfg['mysqldb']."config (
config_owner varchar(24) NOT NULL default 'core',
config_cat varchar(24) NOT NULL default '',
config_order char(2) NOT NULL default '00',
config_name varchar(32) NOT NULL default '',
config_type tinyint(2) NOT NULL default '0',
config_value text NOT NULL,
config_default varchar(255) NOT NULL default '',
config_text varchar(255) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;");
$sql = sed_sql_query("CREATE TABLE ".$cfg['mysqldb']."core (
ct_id mediumint(8) NOT NULL auto_increment,
ct_code varchar(24) NOT NULL default '',
ct_title varchar(64) NOT NULL default '',
ct_version varchar(16) NOT NULL default '',
ct_state tinyint(1) unsigned NOT NULL default '1',
ct_lock tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (ct_id),
KEY ct_code (ct_code)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;");
$sql = sed_sql_query("CREATE TABLE ".$cfg['mysqldb']."dic (
dic_id mediumint(8) NOT NULL auto_increment,
dic_title varchar(255) NOT NULL default '',
dic_code varchar(255) NOT NULL default '',
dic_type tinyint(1) default '0',
dic_values text NOT NULL,
dic_parent mediumint(8) NOT NULL default '0',
dic_mera varchar(16) NOT NULL default '',
dic_form_title varchar(255) NOT NULL default '',
dic_form_desc varchar(255) NOT NULL default '',
dic_form_size smallint(5) NOT NULL default '0',
dic_form_maxsize smallint(5) NOT NULL default '0',
dic_form_cols smallint(5) NOT NULL default '0',
dic_form_rows smallint(5) NOT NULL default '0',
dic_extra_location varchar(40) NOT NULL default '',
dic_extra_type varchar(20) NOT NULL default '',
dic_extra_size smallint(5) NOT NULL default '0',
KEY dic_code (dic_code),
KEY dic_parent (dic_parent),
PRIMARY KEY (dic_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;");
$sql = sed_sql_query("CREATE TABLE ".$cfg['mysqldb']."dic_items (
ditem_id mediumint(8) NOT NULL auto_increment,
ditem_dicid mediumint(8) NOT NULL default '0',
ditem_title varchar(255) NOT NULL default '',
ditem_code varchar(255) NOT NULL default '',
ditem_children mediumint(8) NOT NULL default '0',
ditem_defval tinyint(1) default '0',
KEY ditem_dicid (ditem_dicid),
KEY ditem_children (ditem_children),
PRIMARY KEY (ditem_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;");
$sql = sed_sql_query("CREATE TABLE ".$cfg['mysqldb']."forum_posts (
fp_id mediumint(8) unsigned NOT NULL auto_increment,
fp_topicid mediumint(8) NOT NULL default '0',
fp_sectionid smallint(5) NOT NULL default '0',
fp_posterid int(11) NOT NULL default '-1',
fp_postername varchar(24) NOT NULL default '',
fp_creation int(11) NOT NULL default '0',
fp_updated int(11) NOT NULL default '0',
fp_updater varchar(24) NOT NULL default '0',
fp_text text NOT NULL,
fp_text_ishtml tinyint(1) DEFAULT '1',
fp_posterip varchar(15) NOT NULL default '',
fp_rating tinyint(1) DEFAULT '0',
PRIMARY KEY (fp_id),
UNIQUE KEY fp_topicid (fp_topicid,fp_id),
KEY fp_updated (fp_creation)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;");
$sql = sed_sql_query("CREATE TABLE ".$cfg['mysqldb']."forum_sections (
fs_id smallint(5) unsigned NOT NULL auto_increment,
fs_state tinyint(1) unsigned NOT NULL default '0',
fs_order smallint(5) unsigned NOT NULL default '0',
fs_title varchar(128) NOT NULL default '',
fs_category varchar(64) NOT NULL default '',
fs_parentcat smallint(5) unsigned NOT NULL default '0',
fs_desc varchar(255) NOT NULL default '',
fs_icon varchar(255) NOT NULL default '',
fs_lt_id int(11) NOT NULL default '0',
fs_lt_title varchar(64) NOT NULL default '',
fs_lt_date int(11) NOT NULL default '0',
fs_lt_posterid int(11) NOT NULL default '-1',
fs_lt_postername varchar(24) NOT NULL default '',
fs_autoprune int(11) NOT NULL default '0',
fs_allowusertext tinyint(1) NOT NULL default '1',
fs_allowbbcodes tinyint(1) NOT NULL default '1',
fs_allowsmilies tinyint(1) NOT NULL default '1',
fs_allowprvtopics tinyint(1) NOT NULL default '0',
fs_countposts tinyint(1) NOT NULL default '1',
fs_topiccount mediumint(8) NOT NULL default '0',
fs_topiccount_pruned int(11) default '0',
fs_postcount mediumint(8) NOT NULL default '0',
fs_postcount_pruned int(11) default '0',
fs_viewcount mediumint(8) NOT NULL default '0',
PRIMARY KEY (fs_id),
KEY fs_order (fs_order)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;");
$sql = sed_sql_query("CREATE TABLE ".$cfg['mysqldb']."forum_structure (
fn_id mediumint(8) NOT NULL auto_increment,
fn_path varchar(16) NOT NULL default '',
fn_code varchar(16) NOT NULL default '',
fn_tpl varchar(64) NOT NULL default '',
fn_title varchar(32) NOT NULL default '',
fn_desc varchar(255) NOT NULL default '',
fn_icon varchar(128) NOT NULL default '',
fn_defstate tinyint(1) NOT NULL default '1',
PRIMARY KEY (fn_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;");
$sql = sed_sql_query("CREATE TABLE ".$cfg['mysqldb']."forum_topics (
ft_id mediumint(8) unsigned NOT NULL auto_increment,
ft_mode tinyint(1) unsigned NOT NULL default '0',
ft_state tinyint(1) unsigned NOT NULL default '0',
ft_sticky tinyint(1) unsigned NOT NULL default '0',
ft_tag varchar(16) NOT NULL default '',
ft_sectionid mediumint(8) NOT NULL default '0',
ft_title varchar(128) NOT NULL default '',
ft_desc varchar(255) NOT NULL default '',
ft_creationdate int(11) NOT NULL default '0',
ft_updated int(11) NOT NULL default '0',
ft_postcount mediumint(8) NOT NULL default '0',
ft_viewcount mediumint(8) NOT NULL default '0',
ft_lastposterid int(11) NOT NULL default '-1',
ft_lastpostername varchar(24) NOT NULL default '',
ft_firstposterid int(11) NOT NULL default '-1',
ft_firstpostername varchar(24) NOT NULL default '',
ft_poll int(11) default '0',
ft_movedto int(11) default '0',
PRIMARY KEY (ft_id),
KEY ft_updated (ft_updated),
KEY ft_mode (ft_mode),
KEY ft_state (ft_state),
KEY ft_sticky (ft_sticky),
KEY ft_sectionid (ft_sectionid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;");
$sql = sed_sql_query("CREATE TABLE ".$cfg['mysqldb']."groups (
grp_id int(11) NOT NULL auto_increment,
grp_alias varchar(24) NOT NULL default '',
grp_level tinyint(2) NOT NULL default '1',
grp_disabled tinyint(1) NOT NULL default '0',
grp_hidden tinyint(1) NOT NULL default '0',
grp_title varchar(64) NOT NULL default '',
grp_desc varchar(255) NOT NULL default '',
grp_icon varchar(128) NOT NULL default '',
grp_color varchar(24) NOT NULL default 'inherit',
grp_pfs_maxfile int(11) NOT NULL default '0',
grp_pfs_maxtotal int(11) NOT NULL default '0',
grp_ownerid int(11) NOT NULL default '0',
PRIMARY KEY (grp_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;");
$sql = sed_sql_query("CREATE TABLE ".$cfg['mysqldb']."groups_users (
gru_userid int(11) NOT NULL default '0',
gru_groupid int(11) NOT NULL default '0',
gru_state tinyint(1) NOT NULL default '0',
gru_extra1 varchar(255) NOT NULL default '',
gru_extra2 varchar(255) NOT NULL default '',
KEY gru_userid (gru_userid),
UNIQUE KEY gru_groupid (gru_groupid,gru_userid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;");
$sql = sed_sql_query("CREATE TABLE ".$cfg['mysqldb']."logger (
log_id mediumint(11) NOT NULL auto_increment,
log_date int(11) NOT NULL default '0',
log_ip varchar(15) NOT NULL default '',
log_name varchar(24) NOT NULL default '',
log_group varchar(4) NOT NULL default 'def',
log_text varchar(255) NOT NULL default '',
PRIMARY KEY (log_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;");
$sql = sed_sql_query("CREATE TABLE ".$cfg['mysqldb']."online (
online_id int(11) NOT NULL auto_increment,
online_ip varchar(15) NOT NULL default '',
online_name varchar(24) NOT NULL default '',
online_lastseen int(11) NOT NULL default '0',
online_location varchar(32) NOT NULL default '',
online_subloc varchar(255) NOT NULL default '',
online_userid int(11) NOT NULL default '0',
online_shield int(11) NOT NULL default '0',
online_action varchar(32) NOT NULL default '',
online_hammer tinyint(1) NOT NULL default '0',
PRIMARY KEY (online_id),
KEY online_lastseen (online_lastseen)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;");
$sql = sed_sql_query("CREATE TABLE ".$cfg['mysqldb']."pages (
page_id int(11) unsigned NOT NULL auto_increment,
page_state tinyint(1) unsigned NOT NULL default '0',
page_cat varchar(255) default NULL,
page_key varchar(16) default NULL,
page_title varchar(255) default NULL,
page_desc varchar(255) default NULL,
page_text text,
page_text2 text,
page_author varchar(24) default NULL,
page_ownerid int(11) NOT NULL default '0',
page_date int(11) NOT NULL default '0',
page_begin int(11) NOT NULL default '0',
page_expire int(11) NOT NULL default '0',
page_file tinyint(1) default NULL,
page_url varchar(255) default NULL,
page_size varchar(16) default NULL,
page_count mediumint(8) unsigned default '0',
page_allowcomments tinyint(1) NOT NULL default '1',
page_allowratings tinyint(1) NOT NULL default '1',
page_rating decimal(5,2) NOT NULL default '0.00',
page_comcount mediumint(8) unsigned default '0',
page_filecount mediumint(8) unsigned default '0',
page_alias varchar(255) NOT NULL default '',
page_seo_title varchar(255) default NULL,
page_seo_desc varchar(255) default NULL,
page_seo_keywords varchar(255) default NULL,
page_thumb varchar(255) NOT NULL default '',
PRIMARY KEY (page_id),
KEY page_cat (page_cat)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;");
$sql = sed_sql_query("CREATE TABLE ".$cfg['mysqldb']."pfs (
pfs_id int(11) NOT NULL auto_increment,
pfs_userid int(11) NOT NULL default '0',
pfs_date int(11) NOT NULL default '0',
pfs_file varchar(255) NOT NULL default '',
pfs_extension varchar(8) NOT NULL default '',
pfs_folderid int(11) NOT NULL default '0',
pfs_title varchar(255) NOT NULL default '',
pfs_desc text NOT NULL,
pfs_size int(11) NOT NULL default '0',
pfs_count int(11) NOT NULL default '0',
PRIMARY KEY (pfs_id),
KEY pfs_userid (pfs_userid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;");
$sql = sed_sql_query("CREATE TABLE ".$cfg['mysqldb']."pfs_folders (
pff_id int(11) NOT NULL auto_increment,
pff_userid int(11) NOT NULL default '0',
pff_date int(11) NOT NULL default '0',
pff_updated int(11) NOT NULL default '0',
pff_title varchar(255) NOT NULL default '',
pff_desc text NOT NULL,
pff_type tinyint(1) NOT NULL default '0',
pff_sample int(11) NOT NULL default '0',
pff_count int(11) NOT NULL default '0',
PRIMARY KEY (pff_id),
KEY pff_userid (pff_userid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;");
$sql = sed_sql_query("CREATE TABLE ".$cfg['mysqldb']."plugins (
pl_id mediumint(8) NOT NULL auto_increment,
pl_hook varchar(64) NOT NULL default '',
pl_code varchar(24) NOT NULL default '',
pl_part varchar(24) NOT NULL default '',
pl_title varchar(255) NOT NULL default '',
pl_file varchar(255) NOT NULL default '',
pl_order tinyint(2) unsigned NOT NULL default '10',
pl_active tinyint(1) unsigned NOT NULL default '1',
PRIMARY KEY (pl_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;");
$sql = sed_sql_query("CREATE TABLE ".$cfg['mysqldb']."pm (
pm_id int(11) unsigned NOT NULL auto_increment,
pm_state tinyint(2) NOT NULL default '0',
pm_date int(11) NOT NULL default '0',
pm_fromuserid int(11) NOT NULL default '0',
pm_fromuser varchar(24) NOT NULL default '0',
pm_touserid int(11) NOT NULL default '0',
pm_title varchar(64) NOT NULL default '0',
pm_text text NOT NULL,
PRIMARY KEY (pm_id),
KEY pm_fromuserid (pm_fromuserid),
KEY pm_touserid (pm_touserid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;");
$sql = sed_sql_query("CREATE TABLE ".$cfg['mysqldb']."polls (
poll_id mediumint(8) NOT NULL auto_increment,
poll_type tinyint(1) default '0',
poll_state tinyint(1) NOT NULL default '0',
poll_creationdate int(11) NOT NULL default '0',
poll_text varchar(255) NOT NULL default '',
PRIMARY KEY (poll_id),
KEY poll_creationdate (poll_creationdate)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;");
$sql = sed_sql_query("CREATE TABLE ".$cfg['mysqldb']."polls_options (
po_id mediumint(8) unsigned NOT NULL auto_increment,
po_pollid mediumint(8) unsigned NOT NULL default '0',
po_text varchar(128) NOT NULL default '',
po_count mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (po_id),
KEY po_pollid (po_pollid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;");
$sql = sed_sql_query("CREATE TABLE ".$cfg['mysqldb']."polls_voters (
pv_id mediumint(8) unsigned NOT NULL auto_increment,
pv_pollid mediumint(8) NOT NULL default '0',
pv_userid mediumint(8) NOT NULL default '0',
pv_userip varchar(15) NOT NULL default '',
PRIMARY KEY (pv_id),
KEY pv_pollid (pv_pollid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;");
$sql = sed_sql_query("CREATE TABLE ".$cfg['mysqldb']."rated (
rated_id int(11) unsigned NOT NULL auto_increment,
rated_code varchar(16) default NULL,
rated_userid int(11) default NULL,
rated_value tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (rated_id),
KEY rated_code (rated_code)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;");
$sql = sed_sql_query("CREATE TABLE ".$cfg['mysqldb']."ratings (
rating_id int(11) NOT NULL auto_increment,
rating_code varchar(16) NOT NULL default '',
rating_state tinyint(2) NOT NULL default '0',
rating_average decimal(5,2) NOT NULL default '0.00',
rating_creationdate int(11) NOT NULL default '0',
rating_text varchar(128) NOT NULL default '',
PRIMARY KEY (rating_id),
KEY rating_code (rating_code)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;");
$sql = sed_sql_query("CREATE TABLE ".$cfg['mysqldb']."referers (
ref_url varchar(255) NOT NULL default '',
ref_date int(11) unsigned NOT NULL default '0',
ref_count int(11) NOT NULL default '0',
PRIMARY KEY (ref_url)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;");
$sql = sed_sql_query("CREATE TABLE ".$cfg['mysqldb']."smilies (
smilie_id int(11) NOT NULL auto_increment,
smilie_code varchar(16) NOT NULL default '',
smilie_image varchar(128) NOT NULL default '',
smilie_text varchar(32) NOT NULL default '',
smilie_order smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (smilie_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;");
$sql = sed_sql_query("CREATE TABLE ".$cfg['mysqldb']."stats (
stat_name varchar(32) NOT NULL default '',
stat_value int(11) NOT NULL default '0',
PRIMARY KEY (stat_name)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;");
$sql = sed_sql_query("CREATE TABLE ".$cfg['mysqldb']."structure (
structure_id mediumint(8) NOT NULL auto_increment,
structure_code varchar(255) NOT NULL default '',
structure_path varchar(255) NOT NULL default '',
structure_tpl varchar(64) NOT NULL default '',
structure_title varchar(100) NOT NULL default '',
structure_desc varchar(255) NOT NULL default '',
structure_text text,
structure_icon varchar(128) NOT NULL default '',
structure_group tinyint(1) NOT NULL default '0',
structure_order varchar(16) NOT NULL default 'title.asc',
structure_allowcomments tinyint(1) NOT NULL default '1',
structure_allowratings tinyint(1) NOT NULL default '1',
structure_thumb varchar(255) NOT NULL default '',
PRIMARY KEY (structure_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;");
$sql = sed_sql_query("CREATE TABLE ".$cfg['mysqldb']."trash (
tr_id int(11) NOT NULL auto_increment,
tr_date int(11) unsigned NOT NULL default '0',
tr_type varchar(24) NOT NULL default '',
tr_title varchar(128) NOT NULL default '',
tr_itemid varchar(24) NOT NULL default '',
tr_trashedby int(11) NOT NULL default '0',
tr_datas mediumblob,
PRIMARY KEY (tr_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;");
$sql = sed_sql_query("CREATE TABLE ".$cfg['mysqldb']."users (
user_id int(11) unsigned NOT NULL auto_increment,
user_banexpire int(11) default '0',
user_name varchar(100) NOT NULL default '',
user_firstname varchar(100) NOT NULL default '',
user_lastname varchar(100) NOT NULL default '',
user_password varchar(32) NOT NULL default '',
user_salt varchar(16) NOT NULL default '',
user_secret varchar(32) NOT NULL default '',
user_passtype tinyint(1) DEFAULT '1',
user_maingrp int(11) unsigned NOT NULL default '4',
user_country char(2) NOT NULL default '',
user_text text NOT NULL,
user_avatar varchar(255) NOT NULL default '',
user_photo varchar(255) NOT NULL default '',
user_signature varchar(255) NOT NULL default '',
user_occupation varchar(64) NOT NULL default '',
user_location varchar(64) NOT NULL default '',
user_timezone decimal(2,0) NOT NULL default '0',
user_birthdate int(11) NOT NULL default '0',
user_gender char(1) NOT NULL default 'U',
user_skype varchar(64) NOT NULL default '',
user_website varchar(128) NOT NULL default '',
user_email varchar(64) NOT NULL default '',
user_hideemail tinyint(1) unsigned NOT NULL default '1',
user_pmnotify tinyint(1) unsigned NOT NULL default '0',
user_newpm tinyint(1) unsigned NOT NULL default '0',
user_skin varchar(16) NOT NULL default '',
user_lang varchar(16) NOT NULL default '',
user_regdate int(11) NOT NULL default '0',
user_lastlog int(11) NOT NULL default '0',
user_lastvisit int(11) NOT NULL default '0',
user_lastip varchar(16) NOT NULL default '',
user_logcount int(11) unsigned NOT NULL default '0',
user_postcount int(11) default '0',
user_sid char(32) NOT NULL default '',
user_lostpass char(32) NOT NULL default '',
user_auth text,
user_token varchar(255) NOT NULL default '',
user_oauth_provider varchar(50) NOT NULL default '',
user_oauth_uid text NOT NULL,
PRIMARY KEY (user_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;");
$sql = sed_sql_query("CREATE TABLE ".$cfg['mysqldb']."menu (
menu_id int(11) unsigned NOT NULL auto_increment,
menu_pid int(11) NOT NULL DEFAULT '0',
menu_title varchar(255) NOT NULL DEFAULT '',
menu_url varchar(255) NOT NULL DEFAULT '',
menu_position int(11) NOT NULL DEFAULT '0',
menu_visible tinyint(1) NOT NULL DEFAULT '1',
PRIMARY KEY (menu_id),
KEY menu_pid (menu_pid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."structure VALUES (1, 'articles', '1', '', 'Articles', '', '', '', 1 ,'title.asc', 1, 1, '');");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."structure VALUES (2, 'sample1', '1.1', '', 'Sample category 1', 'Description for the Sample category 1', '', '', 0 ,'title.asc', 1, 1, '');");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."structure VALUES (3, 'sample2', '1.2', '', 'Sample category 2', 'Description for the Sample category 2', '', '', 0 ,'title.asc', 1, 1, '');");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."structure VALUES (4, 'news', '2', '', 'News', '', '', '', 0 ,'date.desc', 1, 1, '');");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."forum_sections VALUES ('1', '0', '100', 'General discussion', 'pub', 0, 'General chat.', 'system/img/admin/forums.png', 0, '', 0, 0, '', 365, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."forum_sections VALUES ('2', '0', '101', 'Off-topic', 'pub', 0, 'Various and off-topic.', 'system/img/admin/forums.png', 0, '', 0, 0, '', 365, 1, 1, 1, 0, 1, 0, 0, 0, 0, 0);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."forum_structure VALUES ('1', '1', 'pub', '', 'Public', '', '', 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."smilies VALUES (1, ':D', 'system/smilies/icon_biggrin.gif', 'Mister grin', 5);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."smilies VALUES (2, ':blush', 'system/smilies/icon_blush.gif', 'Blush', 45);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."smilies VALUES (3, ':con', 'system/smilies/icon_confused.gif', 'Confused', 42);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."smilies VALUES (4, ':)', 'system/smilies/icon_smile.gif', 'Smile', 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."smilies VALUES (5, ':cry', 'system/smilies/icon_cry.gif', 'Cry', 44);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."smilies VALUES (6, ':dontgetit', 'system/smilies/icon_dontgetit.gif', 'Don\'t get it', 41);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."smilies VALUES (7, ':dozingoff', 'system/smilies/icon_dozingoff.gif', 'Dozing off', 40);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."smilies VALUES (8, ':(', 'system/smilies/icon_sad.gif', 'Sad', 50);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."smilies VALUES (9, ':((', 'system/smilies/icon_mad.gif', 'Mad', 46);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."smilies VALUES (10, ':|', 'system/smilies/icon_neutral.gif', 'Neutral', 43);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."smilies VALUES (11, ':no', 'system/smilies/icon_no.gif', 'No', 12);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."smilies VALUES (12, ':O_o', 'system/smilies/icon_o_o.gif', 'Suspicious', 7);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."smilies VALUES (13, ':p', 'system/smilies/icon_razz.gif', 'Razz', 6);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."smilies VALUES (14, ':love', 'system/smilies/icon_love.gif', 'Love', 10);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."smilies VALUES (15, ':satisfied', 'system/smilies/icon_satisfied.gif', 'Satisfied', 2);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."smilies VALUES (16, '8)', 'system/smilies/icon_cool.gif', 'Cool', 4);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."smilies VALUES (17, ':wink', 'system/smilies/icon_wink.gif', 'Wink', 3);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."smilies VALUES (18, ':yes', 'system/smilies/icon_yes.gif', 'Yes', 11);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."stats (stat_name, stat_value) VALUES ('totalpages', '0');");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."stats (stat_name, stat_value) VALUES ('totalmailsent', '0');");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."stats (stat_name, stat_value) VALUES ('totalmailpmnot', '0');");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."stats (stat_name, stat_value) VALUES ('totalpms', '0');");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."stats (stat_name, stat_value) VALUES ('totalantihammer', '0');");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."stats (stat_name, stat_value) VALUES ('textboxerprev', '0');");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."stats (stat_name, stat_value) VALUES ('version', '".$cfg['version']."');");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."core VALUES (1, 'admin', 'Administration panel', '100', 1, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."core VALUES (2, 'comments', 'Comments', '100', 1, 0);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."core VALUES (3, 'forums', 'Forums', '100', 1, 0);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."core VALUES (4, 'index', 'Home page', '100', 1, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."core VALUES (5, 'message', 'Messages', '100', 1, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."core VALUES (6, 'page', 'Pages', '100', 1, 0);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."core VALUES (7, 'pfs', 'Personal File Space', '100', 1, 0);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."core VALUES (8, 'plug', 'Plugins', '100', 1, 0);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."core VALUES (9, 'pm', 'Private messages', '100', 1, 0);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."core VALUES (10, 'polls', 'Polls', '100', 1, 0);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."core VALUES (11, 'ratings', 'Ratings', '100', 1, 0);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."core VALUES (12, 'users', 'Users', '100', 1, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."core VALUES (13, 'trash', 'Trash Can', '110', 1, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."core VALUES (14, 'gallery', 'Gallery', '150', 1, 0);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."core VALUES (15, 'dic', 'Directories', '177', 1, 0);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."core VALUES (16, 'menu', 'Menu manager', '178', 1, 0);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."groups VALUES (1, 'guests', 0, 0, 0, 'Guests', '', '', 'darkmagenta', 0, 0, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."groups VALUES (2, 'inactive', 1, 0, 0, 'Inactive', '', '', 'white', 0, 0, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."groups VALUES (3, 'banned', 1, 0, 0, 'Banned', '', '', 'gray', 0, 0, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."groups VALUES (4, 'members', 1, 0, 0, 'Members', '', '', 'black', 0, 0, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."groups VALUES (5, 'administrators', 99, 0, 0, 'Administrators', '', '', 'red', 256, 1024, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."groups VALUES (6, 'moderators', 50, 0, 0, 'Moderators', '', '', 'green', 256, 1024, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (1, 1, 'admin', 'a', 0, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (2, 2, 'admin', 'a', 0, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (3, 3, 'admin', 'a', 0, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (4, 4, 'admin', 'a', 0, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (5, 5, 'admin', 'a', 255, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (6, 1, 'comments', 'a', 1, 254, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (7, 2, 'comments', 'a', 1, 254, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (8, 3, 'comments', 'a', 0, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (9, 4, 'comments', 'a', 3, 128, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (10, 5, 'comments', 'a', 255, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (11, 1, 'index', 'a', 1, 254, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (12, 2, 'index', 'a', 1, 254, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (13, 3, 'index', 'a', 0, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (14, 4, 'index', 'a', 1, 128, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (15, 5, 'index', 'a', 255, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (16, 1, 'message', 'a', 1, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (17, 2, 'message', 'a', 1, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (18, 3, 'message', 'a', 1, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (19, 4, 'message', 'a', 1, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (20, 5, 'message', 'a', 255, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (21, 1, 'pfs', 'a', 0, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (22, 2, 'pfs', 'a', 0, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (23, 3, 'pfs', 'a', 0, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (24, 4, 'pfs', 'a', 3, 128, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (25, 5, 'pfs', 'a', 255, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (26, 1, 'pm', 'a', 0, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (27, 2, 'pm', 'a', 0, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (28, 3, 'pm', 'a', 0, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (29, 4, 'pm', 'a', 3, 128, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (30, 5, 'pm', 'a', 255, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (31, 1, 'polls', 'a', 1, 254, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (32, 2, 'polls', 'a', 1, 254, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (33, 3, 'polls', 'a', 0, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (34, 4, 'polls', 'a', 3, 128, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (35, 5, 'polls', 'a', 255, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (36, 1, 'ratings', 'a', 1, 254, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (37, 2, 'ratings', 'a', 1, 254, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (38, 3, 'ratings', 'a', 0, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (39, 4, 'ratings', 'a', 3, 128, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (40, 5, 'ratings', 'a', 255, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (41, 1, 'users', 'a', 0, 254, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (42, 2, 'users', 'a', 0, 254, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (43, 3, 'users', 'a', 0, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (44, 4, 'users', 'a', 3, 128, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (45, 5, 'users', 'a', 255, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (46, 1, 'forums', '1', 1, 254, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (47, 2, 'forums', '1', 1, 254, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (48, 3, 'forums', '1', 0, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (49, 4, 'forums', '1', 3, 128, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (50, 5, 'forums', '1', 255, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (51, 1, 'forums', '2', 1, 254, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (52, 2, 'forums', '2', 1, 254, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (53, 3, 'forums', '2', 0, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (54, 4, 'forums', '2', 3, 128, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (55, 5, 'forums', '2', 255, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (56, 1, 'page', 'articles', 1, 254, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (57, 2, 'page', 'articles', 1, 254, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (58, 3, 'page', 'articles', 0, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (59, 4, 'page', 'articles', 3, 128, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (60, 5, 'page', 'articles', 255, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (61, 1, 'page', 'sample1', 1, 254, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (62, 2, 'page', 'sample1', 1, 254, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (63, 3, 'page', 'sample1', 0, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (64, 4, 'page', 'sample1', 3, 252, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (65, 5, 'page', 'sample1', 255, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (66, 1, 'page', 'sample2', 1, 254, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (67, 2, 'page', 'sample2', 1, 254, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (68, 3, 'page', 'sample2', 0, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (69, 4, 'page', 'sample2', 3, 128, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (70, 5, 'page', 'sample2', 255, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (71, 1, 'page', 'news', 1, 254, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (72, 2, 'page', 'news', 1, 254, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (73, 3, 'page', 'news', 0, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (74, 4, 'page', 'news', 3, 252, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (75, 5, 'page', 'news', 255, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (76, 6, 'admin', 'a', 1, 0, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (77, 6, 'comments', 'a', 131, 0, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (78, 6, 'index', 'a', 131, 0, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (79, 6, 'message', 'a', 131, 0, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (80, 6, 'pfs', 'a', 131, 0, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (81, 6, 'pm', 'a', 131, 0, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (82, 6, 'polls', 'a', 131, 0, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (83, 6, 'ratings', 'a', 131, 0, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (84, 6, 'users', 'a', 3, 128, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (85, 6, 'forums', '1', 131, 0, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (86, 6, 'forums', '2', 131, 0, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (87, 1, 'gallery', 'a', 1, 254, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (88, 2, 'gallery', 'a', 1, 254, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (89, 3, 'gallery', 'a', 0, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (90, 4, 'gallery', 'a', 1, 128, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (91, 5, 'gallery', 'a', 255, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (92, 6, 'page', 'articles', 131, 0, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (93, 6, 'page', 'sample1', 131, 0, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (94, 6, 'page', 'sample2', 131, 0, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (95, 6, 'page', 'news', 131, 0, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (96, 1, 'dic', 'a', 1, 254, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (97, 2, 'dic', 'a', 1, 254, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (98, 3, 'dic', 'a', 0, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (99, 4, 'dic', 'a', 3, 128, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (100, 5, 'dic', 'a', 255, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (101, 6, 'dic', 'a', 131, 0, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (102, 1, 'menu', 'a', 1, 254, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (103, 2, 'menu', 'a', 1, 254, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (104, 3, 'menu', 'a', 0, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (105, 4, 'menu', 'a', 3, 128, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (106, 5, 'menu', 'a', 255, 255, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."auth VALUES (107, 6, 'menu', 'a', 131, 0, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."menu VALUES(1, 0, 'Menu', '', 1, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."menu VALUES(2, 1, 'Home', '/', 2, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."menu VALUES(3, 1, 'Forums', '/forums/', 3, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."menu VALUES(4, 1, 'Articles', '/articles/', 4, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."menu VALUES(5, 1, 'Galleries', '/gallery/', 5, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."menu VALUES(6, 1, 'Contact', '/plug/contact', 6, 1);");
$sql = sed_sql_query("INSERT INTO ".$cfg['mysqldb']."pages VALUES
(1, 0, 'news', '', 'Welcome !', '...', 'Congratulations, your website is up and running !<br />\r\n<br />\r\nThe next step is to go in the <a href=\"admin.php\">Administration panel</a>, tab <a href=\"admin.php?m=config\">Configuration</a>, and there tweak the settings for the system.<br />\r\nYou''ll find more instructions and tutorials in the <a href=\"https://seditio.org/list.php?c=docs\">Documentation page for Seditio at Seditio.org</a>, and technical support in our <a href=\"https://seditio.org/forums.php\">discussion forums</a>.', '', '', 1, 1263945600, 1263942000, 1861959600, 0, '', '', 38, 1, 1, 0.00, 0, 0, '', '', '', '', '');");
?>