← All changes | classes/Update/UpdateDB.php +12 -23 3.1 → 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.0.5', '>=' ) ) {
	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.0.5' );
	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,
		@@ -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	}