Mercurial
comparison .cms/mod/base.mod.php @ 0:78edf6b517a0 draft
24.10
author | Coffee CMS <info@coffee-cms.ru> |
---|---|
date | Fri, 11 Oct 2024 22:40:23 +0000 |
parents | |
children |
comparison
equal
deleted
inserted
replaced
-1:000000000000 | 0:78edf6b517a0 |
---|---|
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 } |