Mercurial

comparison .cms/mod/base.mod.php @ 0:78edf6b517a0 draft

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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 }