0
|
1 <?php
|
|
2
|
|
3 $cms["modules"]["base.mod.php"] = array(
|
|
4 "name" => "base_module_name",
|
|
5 "description" => "base_module_description",
|
|
6 "files" => array(
|
|
7 ".cms/css/base.css",
|
|
8 ".cms/mod/base.mod.php",
|
|
9 ".cms/lang/ru_RU.UTF-8/base.mod.php",
|
|
10 ".cms/lang/en_US.UTF-8/base.mod.php",
|
|
11 ".cms/lang/uk_UA.UTF-8/base.mod.php",
|
|
12 ),
|
|
13 );
|
|
14
|
|
15 // Return if module disabled
|
|
16 if ( ! empty( $cms["config"]["base.mod.php"]["disabled"] ) ) {
|
|
17
|
|
18 return;
|
|
19
|
|
20 } else {
|
|
21
|
|
22 // defautl settings
|
|
23 if ( ! isset( $cms["config"]["base.mod.php"]["host"] ) )
|
|
24 $cms["config"]["base.mod.php"]["host"] = "localhost";
|
|
25 if ( ! isset( $cms["config"]["base.mod.php"]["port"] ) )
|
|
26 $cms["config"]["base.mod.php"]["port"] = "3306";
|
|
27 if ( ! isset( $cms["config"]["base.mod.php"]["user"] ) )
|
|
28 $cms["config"]["base.mod.php"]["user"] = "";
|
|
29 if ( ! isset( $cms["config"]["base.mod.php"]["password"] ) )
|
|
30 $cms["config"]["base.mod.php"]["password"] = "";
|
|
31 if ( ! isset( $cms["config"]["base.mod.php"]["base"] ) )
|
|
32 $cms["config"]["base.mod.php"]["base"] = "";
|
|
33
|
|
34 // если админ
|
|
35 if ( is_admin() ) {
|
|
36 hook_add_fn( "admin", "cms_base_admin" );
|
|
37 hook_add_fn( "admin_header", "cms_base_admin_header" );
|
|
38 hook_add_fn( "api", "cms_base_connect", 5 );
|
|
39 }
|
|
40 hook_add_fn( "query", "cms_base_connect", 5 );
|
|
41
|
|
42 }
|
|
43
|
|
44 function cms_base_connect() {
|
|
45 global $cms;
|
|
46
|
|
47 // Это если принудительно вызывают функцию
|
|
48 if ( ! empty( $cms["config"]["base.mod.php"]["disabled"] ) ) {
|
|
49 return false;
|
|
50 }
|
|
51
|
|
52 if ( ! empty( $cms["config"]["base.mod.php"]["user"] ) ) {
|
|
53 // return false on failure
|
|
54 mysqli_report( MYSQLI_REPORT_OFF ); // PHP >= 8.1 FIX https://php.watch/versions/8.1/mysqli-error-mode
|
|
55 $cms["base"] = mysqli_connect(
|
|
56 $cms["config"]["base.mod.php"]["host"],
|
|
57 $cms["config"]["base.mod.php"]["user"],
|
|
58 $cms["config"]["base.mod.php"]["password"],
|
|
59 $cms["config"]["base.mod.php"]["base"],
|
|
60 $cms["config"]["base.mod.php"]["port"]
|
|
61 );
|
|
62 // false and null
|
|
63 if ( $cms["base"] == false ) {
|
|
64 return false;
|
|
65 } else {
|
|
66 mysqli_query( $cms["base"], "SET NAMES utf8" ); // PHP-5.2
|
|
67 mysqli_set_charset( $cms["base"], "utf8mb4" );
|
|
68 return true;
|
|
69 }
|
|
70 } else {
|
|
71 return false;
|
|
72 }
|
|
73
|
|
74 }
|
|
75
|
|
76 function cms_base_admin_header() {
|
|
77 global $cms;
|
|
78 $conf = $cms["config"]["base.mod.php"]["menu"]["base"];
|
|
79 if ( empty( $conf["hide"] ) && empty( $cms["config"]["admin_sections"][ $conf["section"] ]["hide"] ) ) {
|
|
80 echo "<link rel=stylesheet href='{$cms['base_path']}css/base.css'>";
|
|
81 }
|
|
82 }
|
|
83
|
|
84 function cms_base_admin() {
|
|
85 global $cms;
|
|
86
|
|
87 // Save settings
|
|
88 if ( ! empty( $_POST["save_base_config"] ) ) {
|
|
89 if ( $_POST["save_base_config"] === "create" ) {
|
|
90 mysqli_report( MYSQLI_REPORT_OFF ); // PHP >= 8.1 FIX https://php.watch/versions/8.1/mysqli-error-mode
|
|
91 $base = mysqli_connect( $_POST["host"], $_POST["admin_login"], $_POST["admin_password"], "mysql", $_POST["port"] );
|
|
92 if ( $base ) {
|
|
93 mysqli_query( $base, "CREATE DATABASE IF NOT EXISTS {$_POST['base']};" );
|
|
94 mysqli_query( $base, "CREATE USER IF NOT EXISTS '{$_POST['user']}'@'{$_POST['host']}' IDENTIFIED BY '{$_POST['password']}';" );
|
|
95 mysqli_query( $base, "GRANT ALL PRIVILEGES ON {$_POST['base']}.* TO '{$_POST['user']}'@'localhost';" );
|
|
96 mysqli_query( $base, "FLUSH PRIVILEGES;" );
|
|
97 }
|
|
98 }
|
|
99
|
|
100 $cms["config"]["base.mod.php"]["host"] = $_POST["host"];
|
|
101 $cms["config"]["base.mod.php"]["port"] = $_POST["port"];
|
|
102 $cms["config"]["base.mod.php"]["base"] = $_POST["base"];
|
|
103 $cms["config"]["base.mod.php"]["user"] = $_POST["user"];
|
|
104 $cms["config"]["base.mod.php"]["password"] = $_POST["password"];
|
|
105 unset( $cms["config"]["base.mod.php"]["menu"]["base"]["class"] );
|
|
106 cms_save_config();
|
|
107 if ( cms_base_connect() ) {
|
|
108 do_hook( "create_tables" );
|
|
109
|
|
110 // Выполнить запросы в БД, находящиеся в файле update.sql
|
|
111 $update_sql = "{$cms['cms_dir']}/update.sql";
|
|
112 $q = "";
|
|
113 if ( file_exists( $update_sql ) ) {
|
|
114 $q = file_get_contents( $update_sql );
|
|
115 }
|
|
116 if ( $q ) {
|
|
117 mysqli_multi_query( $cms["base"], $q );
|
|
118 }
|
|
119 }
|
|
120 $cms["status"] = "302";
|
|
121 header( "Location: {$cms['base_path']}{$cms['config']['admin.mod.php']['admin_url']}" );
|
|
122 $cms["hooks"]["admin"]["next"] = ""; // Предотвратить выдачу админки
|
|
123 return;
|
|
124 }
|
|
125
|
|
126 $conf = $cms["config"]["base.mod.php"]["menu"]["base"];
|
|
127 if ( empty( $conf["hide"] ) && empty( $cms["config"]["admin_sections"][ $conf["section"] ]["hide"] ) ) {
|
|
128
|
|
129 $e_host = htmlspecialchars( $cms['config']['base.mod.php']['host'] );
|
|
130 $e_port = htmlspecialchars( $cms['config']['base.mod.php']['port'] );
|
|
131 $e_base = htmlspecialchars( $cms['config']['base.mod.php']['base'] );
|
|
132 $e_user = htmlspecialchars( $cms['config']['base.mod.php']['user'] );
|
|
133 $e_password = htmlspecialchars( $cms['config']['base.mod.php']['password'] );
|
|
134 $page = "
|
|
135 <div class=db-settings>
|
|
136 <form method=post>
|
|
137 <div class=basic>
|
|
138 <div>
|
|
139 <div>" . __( "server_address" ) . "</div>
|
|
140 <input name=host type=text value=\"{$e_host}\" placeholder=localhost>
|
|
141 </div>
|
|
142 <div>
|
|
143 <div>" . __( "server_port" ) . "</div>
|
|
144 <input name=port type=text value=\"{$e_port}\" placeholder=3306>
|
|
145 </div>
|
|
146 <div>
|
|
147 <div>" . __( "db_name" ) . "</div>
|
|
148 <input name=base type=text value=\"{$e_base}\">
|
|
149 </div>
|
|
150 <div>
|
|
151 <div>" . __( "db_user" ) . "</div>
|
|
152 <input name=user type=text value=\"{$e_user}\">
|
|
153 </div>
|
|
154 <div>
|
|
155 <div>" . __( "db_password" ) . "</div>
|
|
156 <div class=password-widget>
|
|
157 <input name=password type=password value=\"{$e_password}\">
|
|
158 <div class=password-eye></div>
|
|
159 </div>
|
|
160 </div>
|
|
161 <button name=save_base_config value=save>" . __( "save" ) . "</button>
|
|
162 <div class=pro-btn>PRO</div>
|
|
163 </div>
|
|
164
|
|
165 <div class=pro>
|
|
166 <div class=create>" . __( "create_db" ) . "</div>
|
|
167 <div>
|
|
168 <div>" . __( "admin_login" ) . "</div>
|
|
169 <input name=admin_login type=text value>
|
|
170 </div>
|
|
171 <div>
|
|
172 <div>" . __( "admin_passwd" ) . "</div>
|
|
173 <div class=password-widget>
|
|
174 <input name=admin_password type=password value>
|
|
175 <div class=password-eye></div>
|
|
176 </div>
|
|
177 </div>
|
|
178 <button name=save_base_config value=create>" . __( "create_btn" ) . "</button>
|
|
179 </div>
|
|
180 </form>
|
|
181 </div>";
|
|
182
|
|
183 // Create menu item if not exists
|
|
184 if ( empty( $cms["config"]["base.mod.php"]["menu"]["base"] ) ) {
|
|
185 $cms["config"]["base.mod.php"]["menu"]["base"] = array(
|
|
186 "title" => "base_module_name",
|
|
187 "sort" => 20,
|
|
188 "section" => "settings",
|
|
189 );
|
|
190 cms_save_config();
|
|
191 }
|
|
192
|
|
193 if ( cms_base_connect() === false ) {
|
|
194 $cms["config"]["base.mod.php"]["menu"]["base"]["class"] = "red";
|
|
195 }
|
|
196
|
|
197 $cms["admin_pages"]["base"] = $page;
|
|
198
|
|
199 }
|
|
200 }
|