← All changes | classes/Update/UpdateDB.php +27 -53 3.0 → 4.1 View file →

		@@ -1,80 +1,54 @@
1	1	<?php
2	2
3	3	namespace WPCoder\Update;
4	4
5		-defined( 'ABSPATH' ) || exit;
	5	+use WPCoder\WPCoder;
6	6
7		-use WPCoder\Dashboard\DBManager;
8		-use WPCoder\WOW_Plugin;
9		-
10	7	class UpdateDB {
11	8
12		- public static function init(): void {
13		- $current_db_version = get_option( WOW_Plugin::PREFIX . '_db_version' );
	9	+ const NEW_DB_VERSION = '3.6';
14	10
15		- if ( $current_db_version && version_compare( $current_db_version, '3.0', '>=' ) ) {
16		- return;
17		- }
18		-
19		- self::updateDB();
20		- self::updateDBFields();
21		-
22		- update_option( WOW_Plugin::PREFIX . '_db_version', '3.0' );
23		-
24		- }
25		-
26		- private static function updateDB(): void {
27		- global $wpdb;
28		- $table = $wpdb->prefix . WOW_Plugin::PREFIX;
29		-
30		- $columns = "
	11	+ const TABLE_COLUMNS = "
31	12	id mediumint(9) NOT NULL AUTO_INCREMENT,
32	13	title VARCHAR(200) NOT NULL,
33	14	html_code LONGTEXT,
34	15	css_code LONGTEXT,
35	16	js_code LONGTEXT,
	17	+ php_code LONGTEXT,
36	18	param LONGTEXT,
37	19	status BOOLEAN,
38	20	mode BOOLEAN,
39	21	tag TEXT,
40		- UNIQUE KEY id (id)
41		- ";
42		- require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
	22	+ php_include int(11) NOT NULL DEFAULT '0',
	23	+ UNIQUE KEY id (id),
	24	+ INDEX id_index (id)
	25	+ ";
43	26
44		- $sql = "CREATE TABLE $table ($columns) DEFAULT CHARACTER SET {$wpdb->charset} COLLATE {$wpdb->collate};";
45		- dbDelta( $sql );
	27	+ public static function init(): void {
	28	+ $current_db_version = get_option( WPCoder::PREFIX . '_db_version' );
	29	+
	30	+ if ( $current_db_version && version_compare( $current_db_version, self::NEW_DB_VERSION, '>=' ) ) {
	31	+ return;
	32	+ }
	33	+
	34	+ self::start_update();
	35	+ update_option( WPCoder::PREFIX . '_db_version', self::NEW_DB_VERSION );
46	36	}
47	37
48		- private static function updateDBFields(): void {
49		- $results = DBManager::get_all_data();
	38	+ private static function start_update(): void {
	39	+ self::update_database();
	40	+ }
50	41
51		- if ( ! empty( $results ) ) {
52		- foreach ( $results as $key => $val ) {
53		- $id = $val->id;
54		- $title = $val->title;
55		- $param = maybe_unserialize( $val->param );
56		- $html_code = ! empty( $param['content_html'] ) ? $param['content_html'] : '';
57		- $css_code = ! empty( $param['content_css'] ) ? $param['content_css'] : '';
58		- $js_code = ! empty( $param['content_js'] ) ? $param['content_js'] : '';
	42	+ private static function update_database(): void {
	43	+ global $wpdb;
59	44
60		- $data = [
61		- 'title' => $title,
62		- 'html_code' => $html_code,
63		- 'css_code' => $css_code,
64		- 'js_code' => $js_code,
65		- 'status' => 0,
66		- 'mode' => 0,
67		- 'tag' => '',
68		- ];
	45	+ $table = $wpdb->prefix . WPCoder::PREFIX;
	46	+ $charset_collate = $wpdb->get_charset_collate();
69	47
70		- $where = [ 'id' => $id ];
	48	+ require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
71	49
72		- $data_formats = [ '%s', '%s', '%s', '%s', '%d', '%d', '%s' ];
73		-
74		- DBManager::update( $data, $where, $data_formats );
75		- }
76		- }
	50	+ $sql = "CREATE TABLE $table (" . self::TABLE_COLUMNS . ") $charset_collate;";
	51	+ dbDelta( $sql );
77	52	}
78		-
79	53
80	54	}