← All changes | classes/Update/UpdateDB.php +12 -24 3.2 → 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,14 +18,15 @@
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 = $wpdb->prefix . WPCoder::PREFIX;
	28	+ $table = $wpdb->prefix . WOW_Plugin::PREFIX;
28	29
29	30	$columns = "
30	31	id mediumint(9) NOT NULL AUTO_INCREMENT,
31	32	title VARCHAR(200) NOT NULL,
		@@ -31,9 +32,8 @@
31	32	title VARCHAR(200) NOT NULL,
32	33	html_code LONGTEXT,
33	34	css_code LONGTEXT,
34	35	js_code LONGTEXT,
35		- php_code LONGTEXT,
36	36	param LONGTEXT,
37	37	status BOOLEAN,
38	38	mode BOOLEAN,
39	39	tag TEXT,
		@@ -49,26 +49,15 @@
49	49	$results = DBManager::get_all_data();
50	50
51	51	if ( ! empty( $results ) ) {
52	52	foreach ( $results as $key => $val ) {
53		- $id = $val->id;
54		- $title = $val->title;
55		- $param = maybe_unserialize( $val->param );
56		-
	53	+ $id = $val->id;
	54	+ $title = $val->title;
	55	+ $param = maybe_unserialize( $val->param );
57	56	$html_code = ! empty( $param['content_html'] ) ? $param['content_html'] : '';
58		- if ( ! empty ( $val->html_code ) ) {
59		- $html_code = $val->html_code;
60		- }
61		- $css_code = ! empty( $param['content_css'] ) ? $param['content_css'] : '';
62		- if ( ! empty ( $val->css_code ) ) {
63		- $css_code = $val->css_code;
64		- }
	57	+ $css_code = ! empty( $param['content_css'] ) ? $param['content_css'] : '';
	58	+ $js_code = ! empty( $param['content_js'] ) ? $param['content_js'] : '';
65	59
66		- $js_code = ! empty( $param['content_js'] ) ? $param['content_js'] : '';
67		- if ( ! empty ( $val->js_code ) ) {
68		- $js_code = $val->js_code;
69		- }
70		-
71	60	$data = [
72	61	'title' => $title,
73	62	'html_code' => $html_code,
74	63	'css_code' => $css_code,
		@@ -75,14 +64,13 @@
75	64	'js_code' => $js_code,
76	65	'status' => 0,
77	66	'mode' => 0,
78	67	'tag' => '',
79		- 'param' => $val->param,
80	68	];
81	69
82	70	$where = [ 'id' => $id ];
83	71
84		- $data_formats = [ '%s', '%s', '%s', '%s', '%d', '%d', '%s', '%s' ];
	72	+ $data_formats = [ '%s', '%s', '%s', '%s', '%d', '%d', '%s' ];
85	73
86	74	DBManager::update( $data, $where, $data_formats );
87	75	}
88	76	}