← All changes | classes/Update/UpdateDB.php +24 -12 3.0 → 3.1.1 View file →

		@@ -4,16 +4,16 @@
4	4
5	5	defined( 'ABSPATH' ) || exit;
6	6
7	7	use WPCoder\Dashboard\DBManager;
8		-use WPCoder\WOW_Plugin;
	8	+use WPCoder\WPCoder;
9	9
10	10	class UpdateDB {
11	11
12	12	public static function init(): void {
13		- $current_db_version = get_option( WOW_Plugin::PREFIX . '_db_version' );
	13	+ $current_db_version = get_option( WPCoder::PREFIX . '_db_version' );
14	14
15		- if ( $current_db_version && version_compare( $current_db_version, '3.0', '>=' ) ) {
	15	+ if ( $current_db_version && version_compare( $current_db_version, '3.1', '>=' ) ) {
16	16	return;
17	17	}
18	18
19	19	self::updateDB();
		@@ -18,15 +18,14 @@
18	18
19	19	self::updateDB();
20	20	self::updateDBFields();
21	21
22		- update_option( WOW_Plugin::PREFIX . '_db_version', '3.0' );
23		-
	22	+ update_option( WPCoder::PREFIX . '_db_version', '3.1' );
24	23	}
25	24
26	25	private static function updateDB(): void {
27	26	global $wpdb;
28		- $table = $wpdb->prefix . WOW_Plugin::PREFIX;
	27	+ $table = $wpdb->prefix . WPCoder::PREFIX;
29	28
30	29	$columns = "
31	30	id mediumint(9) NOT NULL AUTO_INCREMENT,
32	31	title VARCHAR(200) NOT NULL,
		@@ -32,8 +31,9 @@
32	31	title VARCHAR(200) NOT NULL,
33	32	html_code LONGTEXT,
34	33	css_code LONGTEXT,
35	34	js_code LONGTEXT,
	35	+ php_code LONGTEXT,
36	36	param LONGTEXT,
37	37	status BOOLEAN,
38	38	mode BOOLEAN,
39	39	tag TEXT,
		@@ -49,15 +49,26 @@
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 );
	53	+ $id = $val->id;
	54	+ $title = $val->title;
	55	+ $param = maybe_unserialize( $val->param );
	56	+
56	57	$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'] : '';
	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	+ }
59	65
	66	+ $js_code = ! empty( $param['content_js'] ) ? $param['content_js'] : '';
	67	+ if ( ! empty ( $val->js_code ) ) {
	68	+ $js_code = $val->js_code;
	69	+ }
	70	+
60	71	$data = [
61	72	'title' => $title,
62	73	'html_code' => $html_code,
63	74	'css_code' => $css_code,
		@@ -64,13 +75,14 @@
64	75	'js_code' => $js_code,
65	76	'status' => 0,
66	77	'mode' => 0,
67	78	'tag' => '',
	79	+ 'param' => $val->param,
68	80	];
69	81
70	82	$where = [ 'id' => $id ];
71	83
72		- $data_formats = [ '%s', '%s', '%s', '%s', '%d', '%d', '%s' ];
	84	+ $data_formats = [ '%s', '%s', '%s', '%s', '%d', '%d', '%s', '%s' ];
73	85
74	86	DBManager::update( $data, $where, $data_formats );
75	87	}
76	88	}