← All changes | classes/Update/UpdateDB.php +26 -37 3.4 → 3.0 View file →

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