XCL Web Application Platform 2.5.0
The XoopsCube Legacy Project
Loading...
Searching...
No Matches
install_updateConfig_go.inc.php
1<?php
10
11include_once '../mainfile.php';
12
13echo '<h2>wizard/install_updateConfig_go.inc</h2>';
14
15$language = check_language( $language );
16if ( file_exists( './language/' . $language . '/install2.php' ) ) {
17 include_once './language/' . $language . '/install2.php';
18} elseif ( file_exists( './language/english/install2.php' ) ) {
19 include_once './language/english/install2.php';
20 $language = 'english';
21} else {
22 echo 'no language file (install2.php).';
23 exit();
24}
25
26include_once './class/dbmanager.php';
27
28$dbm = new db_manager();
29
30// default settings
31$xoopsConfig['sitename'] = 'Web Application Platform';
32$xoopsConfig['slogan'] = 'Just use it!';
33$xoopsConfig['adminmail'] = '';
34$xoopsConfig['language'] = 'english';
35$xoopsConfig['anonymous'] = 'Anonymous';
36$xoopsConfig['minpass'] = 5;
37$xoopsConfig['anonpost'] = 0;
38$xoopsConfig['new_user_notify'] = 0;
39$xoopsConfig['new_user_notify_group'] = 1;
40$xoopsConfig['self_delete'] = 0;
41$xoopsConfig['gzip_compression'] = 0;
42$xoopsConfig['uname_test_level'] = 0;
43$xoopsConfig['usercookie'] = 'wap_user';
44$xoopsConfig['sessioncookie'] = 'wap_session';
45$xoopsConfig['sessionexpire'] = 4500;
46$xoopsConfig['server_TZ'] = 0;
47$xoopsConfig['default_TZ'] = 0;
48$xoopsConfig['banners'] = 1;
49$xoopsConfig['com_mode'] = 'nest';
50$xoopsConfig['com_order'] = 1;
51$xoopsConfig['my_ip'] = '127.0.0.1';
52$xoopsConfig['avatar_allow_upload'] = 0;
53$xoopsConfig['avatar_width'] = 128;
54$xoopsConfig['avatar_height'] = 128;
55$xoopsConfig['avatar_maxsize'] = 25000;
56
57$dbm->insert( 'config', " VALUES (1, 0, 1, 'sitename', '_MD_AM_SITENAME', '" . addslashes( $xoopsConfig['sitename'] ) . "', '_MD_AM_SITENAMEDSC', 'textbox', 'text', 0)" );
58$dbm->insert( 'config', " VALUES (2, 0, 1, 'slogan', '_MD_AM_SLOGAN', '" . addslashes( $xoopsConfig['slogan'] ) . "', '_MD_AM_SLOGANDSC', 'textbox', 'text', 2)" );
59$dbm->insert( 'config', " VALUES (3, 0, 1, 'language', '_MD_AM_LANGUAGE', '" . $xoopsConfig['language'] . "', '_MD_AM_LANGUAGEDSC', 'language', 'other', 4)" );
60$dbm->insert( 'config', " VALUES (4, 0, 1, 'startpage', '_MD_AM_STARTPAGE', '--', '_MD_AM_STARTPAGEDSC', 'startpage', 'other', 6)" );
61$dbm->insert( 'config', " VALUES (5, 0, 1, 'server_TZ', '_MD_AM_SERVERTZ', '" . addslashes( $xoopsConfig['server_TZ'] ) . "', '_MD_AM_SERVERTZDSC', 'timezone', 'float', 8)" );
62$dbm->insert( 'config', " VALUES (6, 0, 1, 'default_TZ', '_MD_AM_DEFAULTTZ', '" . addslashes( $xoopsConfig['default_TZ'] ) . "', '_MD_AM_DEFAULTTZDSC', 'timezone', 'float', 10)" );
63$dbm->insert( 'config', " VALUES (7, 0, 1, 'theme_set', '_MD_AM_DTHEME', 'default', '_MD_AM_DTHEMEDSC', 'theme', 'other', 12)" );
64$dbm->insert( 'config', " VALUES (8, 0, 1, 'anonymous', '_MD_AM_ANONNAME', '" . addslashes( $xoopsConfig['anonymous'] ) . "', '_MD_AM_ANONNAMEDSC', 'textbox', 'text', 15)" );
65$dbm->insert( 'config', " VALUES (9, 0, 1, 'gzip_compression', '_MD_AM_USEGZIP', '" . (int) $xoopsConfig['gzip_compression'] . "', '_MD_AM_USEGZIPDSC', 'yesno', 'int', 16)" );
66$dbm->insert( 'config', " VALUES (11, 0, 1, 'session_expire', '_MD_AM_SESSEXPIRE', '15', '_MD_AM_SESSEXPIREDSC', 'textbox', 'int', 22)" );
67$dbm->insert( 'config', " VALUES (13, 0, 1, 'debug_mode', '_MD_AM_DEBUGMODE', '1', '_MD_AM_DEBUGMODEDSC', 'select', 'int', 24)" );
68$dbm->insert( 'config', " VALUES (14, 0, 1, 'my_ip', '_MD_AM_MYIP', '" . addslashes( $xoopsConfig['my_ip'] ) . "', '_MD_AM_MYIPDSC', 'textbox', 'text', 29)" );
69$dbm->insert( 'config', " VALUES (15, 0, 1, 'use_ssl', '_MD_AM_USESSL', '0', '_MD_AM_USESSLDSC', 'yesno', 'int', 30)" );
70$dbm->insert( 'config', " VALUES (16, 0, 1, 'session_name', '_MD_AM_SESSNAME', 'xcl_wap_session', '_MD_AM_SESSNAMEDSC', 'textbox', 'text', 20)" );
71$dbm->insert( 'config', " VALUES (32, 0, 1, 'com_mode', '_MD_AM_COMMODE', '" . addslashes( $xoopsConfig['com_mode'] ) . "', '_MD_AM_COMMODEDSC', 'select', 'text', 34)" );
72$dbm->insert( 'config', " VALUES (33, 0, 1, 'com_order', '_MD_AM_COMORDER', '" . (int) $xoopsConfig['com_order'] . "', '_MD_AM_COMORDERDSC', 'select', 'int', 36)" );
73$dbm->insert( 'config', " VALUES (37, 0, 1, 'bad_ips', '_MD_AM_BADIPS', '" . addslashes( serialize( [ '127.0.0.1' ] ) ) . "', '_MD_AM_BADIPSDSC', 'textarea', 'array', 42)" );
74$dbm->insert( 'config', " VALUES (40, 0, 4, 'censor_enable', '_MD_AM_DOCENSOR', '0', '_MD_AM_DOCENSORDSC', 'yesno', 'int', 0)" );
75$dbm->insert( 'config', " VALUES (41, 0, 4, 'censor_words', '_MD_AM_CENSORWRD', '" . addslashes( serialize( [
76 'fuck',
77 'shit'
78 ] ) ) . "', '_MD_AM_CENSORWRDDSC', 'textarea', 'array', 1)" );
79$dbm->insert( 'config', " VALUES (42, 0, 4, 'censor_replace', '_MD_AM_CENSORRPLC', '#OOPS#', '_MD_AM_CENSORRPLCDSC', 'textbox', 'text', 2)" );
80$dbm->insert( 'config', " VALUES (44, 0, 5, 'enable_search', '_MD_AM_DOSEARCH', '1', '_MD_AM_DOSEARCHDSC', 'yesno', 'int', 0)" );
81$dbm->insert( 'config', " VALUES (45, 0, 5, 'keyword_min', '_MD_AM_MINSEARCH', '5', '_MD_AM_MINSEARCHDSC', 'textbox', 'int', 1)" );
82$dbm->insert( 'config', " VALUES (47, 0, 1, 'enable_badips', '_MD_AM_DOBADIPS', '0', '_MD_AM_DOBADIPSDSC', 'yesno', 'int', 40)" );
83$dbm->insert( 'config', " VALUES (53, 0, 1, 'use_mysession', '_MD_AM_USEMYSESS', '0', '_MD_AM_USEMYSESSDSC', 'yesno', 'int', 19)" );
84$dbm->insert( 'config', " VALUES (57, 0, 1, 'theme_fromfile', '_MD_AM_THEMEFILE', '1', '_MD_AM_THEMEFILEDSC', 'yesno', 'int', 13)" );
85$dbm->insert( 'config', " VALUES (58, 0, 1, 'closesite', '_MD_AM_CLOSESITE', '1', '_MD_AM_CLOSESITEDSC', 'yesno', 'int', 26)" );
86$dbm->insert( 'config', " VALUES (59, 0, 1, 'closesite_okgrp', '_MD_AM_CLOSESITEOK', '" . addslashes( serialize( [ '1' ] ) ) . "', '_MD_AM_CLOSESITEOKDSC', 'group_multi', 'array', 27)" );
87$dbm->insert( 'config', " VALUES (60, 0, 1, 'closesite_text', '_MD_AM_CLOSESITETXT', '" . _INSTALL_L165 . "', '_MD_AM_CLOSESITETXTDSC', 'textarea', 'text', 28)" );
88$dbm->insert( 'config', " VALUES (61, 0, 1, 'sslpost_name', '_MD_AM_SSLPOST', 'xcl_wap_ssl', '_MD_AM_SSLPOSTDSC', 'textbox', 'text', 31)" );
89$dbm->insert( 'config', " VALUES (62, 0, 1, 'module_cache', '_MD_AM_MODCACHE', '', '_MD_AM_MODCACHEDSC', 'module_cache', 'array', 50)" );
90$dbm->insert( 'config', " VALUES (63, 0, 1, 'template_set', '_MD_AM_DTPLSET', 'default', '_MD_AM_DTPLSETDSC', 'tplset', 'other', 14)" );
91$dbm->insert( 'config', " VALUES (64,0,6,'mailmethod','_MD_AM_MAILERMETHOD','mail','_MD_AM_MAILERMETHODDESC','select','text',4)" );
92$dbm->insert( 'config', " VALUES (65,0,6,'smtphost','_MD_AM_SMTPHOST','a:1:{i:0;s:0:\"\";}', '_MD_AM_SMTPHOSTDESC','textarea','array',6)" );
93$dbm->insert( 'config', " VALUES (66,0,6,'smtpuser','_MD_AM_SMTPUSER','','_MD_AM_SMTPUSERDESC','textbox','text',7)" );
94$dbm->insert( 'config', " VALUES (67,0,6,'smtppass','_MD_AM_SMTPPASS','','_MD_AM_SMTPPASSDESC','password','text',8)" );
95$dbm->insert( 'config', " VALUES (68,0,6,'sendmailpath','_MD_AM_SENDMAILPATH','/usr/sbin/sendmail','_MD_AM_SENDMAILPATHDESC','textbox','text',5)" );
96$dbm->insert( 'config', " VALUES (69,0,6,'from','_MD_AM_MAILFROM','','_MD_AM_MAILFROMDESC','textbox','text',1)" );
97$dbm->insert( 'config', " VALUES (70,0,6,'fromname','_MD_AM_MAILFROMNAME','','_MD_AM_MAILFROMNAMEDESC','textbox','text',2)" );
98$dbm->insert( 'config', " VALUES (71,0,1, 'sslloginlink', '_MD_AM_SSLLINK', 'https://', '_MD_AM_SSLLINKDSC', 'textbox', 'text', 33)" );
99$dbm->insert( 'config', " VALUES (72,0,1, 'theme_set_allowed', '_MD_AM_THEMEOK', '" . serialize( [ 'xcl_default', 'bs5-starter' ] ) . "', '_MD_AM_THEMEOKDSC', 'theme_multi', 'array', 13)" );
100$dbm->insert( 'config', " VALUES (73,0,6,'fromuid','_MD_AM_MAILFROMUID','1','_MD_AM_MAILFROMUIDDESC','user','int',3)" );
101
102
103// default the default theme
104
105$time = time();
106$dbm->insert( 'tplset', " VALUES (1, 'xcl_default', 'Default Theme', '', " . $time . ')' ); //TODO check install tplset
107
108
109
110$dbm->query( 'INSERT INTO ' . $dbm->prefix( 'group_permission' ) . ' (gperm_groupid, gperm_itemid) SELECT groupid, block_id FROM ' . $dbm->prefix( 'groups_blocks_link' ) );
111$dbm->query( 'UPDATE ' . $dbm->prefix( 'group_permission' ) . " SET gperm_name = 'block_read'" );
112$dbm->query( 'INSERT INTO ' . $dbm->prefix( 'group_permission' ) . ' (gperm_groupid, gperm_itemid) SELECT groupid, mid FROM ' . $dbm->prefix( 'groups_modules_link' ) . " WHERE type='A'" );
113$dbm->query( 'UPDATE ' . $dbm->prefix( 'group_permission' ) . " SET gperm_name = 'module_admin' WHERE gperm_name = ''" );
114$dbm->query( 'INSERT INTO ' . $dbm->prefix( 'group_permission' ) . ' (gperm_groupid, gperm_itemid) SELECT groupid, mid FROM ' . $dbm->prefix( 'groups_modules_link' ) . " WHERE type='R'" );
115$dbm->query( 'UPDATE ' . $dbm->prefix( 'group_permission' ) . " SET gperm_name = 'module_read' WHERE gperm_name = ''" );
116$dbm->query( 'UPDATE ' . $dbm->prefix( 'group_permission' ) . ' SET gperm_modid = 1' );
117$dbm->query( 'DROP TABLE ' . $dbm->prefix( 'groups_blocks_link' ) );
118$dbm->query( 'DROP TABLE ' . $dbm->prefix( 'groups_modules_link' ) );
119
120// insert some more data
121$result = $dbm->queryFromFile( './sql/' . ( ( XOOPS_DB_TYPE === 'mysqli' ) ? 'mysql' : XOOPS_DB_TYPE ) . '.data.sql' );
122
123$content = $dbm->report();
124//$content .= $cm->report();
125$b_next = [ 'updateModules', _INSTALL_L14 ];
126
127include './install_tpl.php';
db_manager
Definition dbmanager.php:19