Changeset 3059614

Timestamp:

03/27/2024 09:22:42 AM (22 months ago)

Author:

xtoool

Message:

fix bug

Location:

xtoool-ads-box/trunk

Files:

• readme.txt (modified) (1 diff)
• xtoool-ads-box.php (modified) (4 diffs)

xtoool-ads-box/trunk/readme.txt

@@ -6 +6 @@
 Requires at least: 5.3
 Tested up to: 6.4.3
-Stable tag: 1.0.2
+Stable tag: 1.0.3
 Requires PHP: 5.4
 License: GPLv3

xtoool-ads-box/trunk/xtoool-ads-box.php

@@ -4 +4 @@
 Plugin URI: https://www.xtoool.com/wordpress/
 Description: Xtoool Ads Box helps you create High-converting product bars to engage customers and grow sales.
-Version: 1.0.2
+Version: 1.0.3
 Author: xtoool.com
 Author URI: https://www.xtoool.com
@@ -35 +35 @@
 define('XTPLB_URL', plugins_url('', __FILE__));
 define('XTPLB_BASE', plugin_basename(XTPLB_PATH));
-
-
+define('ADSBX_PLUGIN_NAME', basename(XTPLB_DIR) . '/xtoool-ads-box.php');
 
 class plbProductListForBlog{
     private static $instance = null;
     public $db;
-    const XTPLB_VERSION = '1.0.2';
+    const XTPLB_VERSION = '1.0.3';
     public $AdsbxAdmin_obj = null;
 
@@ -59 +58 @@
 
         register_activation_hook(XTPLB_PATH, [$this, 'activate']);
+        add_action( 'upgrader_process_complete', [$this, 'my_upgrate_function'], 10, 2);
+
         $this->_initScript();
 
@@ -65 +66 @@
         $this->AdsbxAdmin_obj = new AdsbxAdmin($this);
         new Shortcode($this);
+    }
+
+    public function my_upgrate_function( $upgrader_object, $options ) {
+
+        if ($options['action'] !== 'update' || $options['type'] !== 'plugin') {
+            return;
+        }
+
+        if (! in_array(ADSBX_PLUGIN_NAME, $options['plugins'] ?? [])) {
+            return;
+        }
+
+        if(self::XTPLB_VERSION == '1.0.3'){
+            $this->_update_1_0_3();
+        }
+
+    }
+
+    private function _update_1_0_3(){
+        global $wpdb;
+        $sql4 = 'CREATE TABLE if not exists `' . $wpdb->prefix . 'products_banner_blog` (
+            `id` int(11) NOT NULL AUTO_INCREMENT,
+  `name` varchar(255) NOT NULL default "",
+  `image_url` varchar(255) NOT NULL default "",
+  `regular_price` varchar(25) NOT NULL default "",
+  `price` varchar(25) NOT NULL default "",
+  `title` varchar(255) NOT NULL default "",
+  `desc` text default null,
+  `shop_btn_text` varchar(255) NOT NULL default "",
+  `shop_btn_link` varchar(1000) NOT NULL default "",
+  `sub_btn_text` varchar(255) NOT NULL default "",
+  `sub_btn_link` varchar(1000) NOT NULL default "",
+  `added_by` int(11) not null default 0,
+  `added_date` datetime default null,
+  `updated_by` int(11) not null default 0,
+  `updated_date` datetime default null,
+  
+  PRIMARY KEY (`id`)
+) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4;';
+        $wpdb->query($sql4);
     }