← All changes | classes/Update/UpdateDB.php +63 -26 4.5.1 → 3.0.4 View file →

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