Changeset 3254308

Timestamp:

03/11/2025 06:45:20 PM (10 months ago)

Author:

dan009

Message:

2025-03-11

• Added query when creating main table to handle timestamp column for older versions of mysql

Location:

raffle-play-woo/trunk

Files:

• includes/RafflePlayWoo_Plugin.php (modified) (3 diffs)
• raffle-play-woo.php (modified) (2 diffs)
• readme.txt (modified) (2 diffs)

raffle-play-woo/trunk/includes/RafflePlayWoo_Plugin.php

@@ -72 +72 @@
     }
 
+    private function createMainTableTs( $table_name, $charset_collate ){
+
+        $backup_field = "backup_name varchar(30) default '',";
+        if( $table_name !== $this->prefixTableName('main_bk') )
+            $backup_field = "";
+
+        $sql_query =  "CREATE TABLE IF NOT EXISTS {$table_name} (
+                    id mediumint(5) NOT NULL auto_increment,
+                    order_id int(10) NOT NULL default '0',                            
+                    customer_id int(5) NOT NULL default '0',
+                    product_id  int(5) NOT NULL default '0',
+                    ticket int(10) NOT NULL default '0',
+                    quantity int(5) NOT NULL default '0',                                   
+                    tickets_purchased int(5) NOT NULL default '0',
+                    catid_one int(5) NOT NULL default '0',
+                    catid_two int(5) NOT NULL default '0',
+                    catid_three int(5) NOT NUll default '0',
+                    ticket_no int(10) NOT NULL default '0',
+                    ticket_from int(10) NOT NULL default '0',
+                    ticket_to int(10) NOT NULL default '0',                            
+                    ticket_txt text NOT NULL default '',
+                    total_price float NOT NULL default '0.0', 
+                    live_order int(1) NOT NULL default '0',
+                    deleted int(1) NOT NULL default '0', 
+                    order_status varchar(30) default '',
+                    woo_session_id varchar(200) default '',
+                    extra_one text default '',
+                    reserved int(1) NOT NULL default '0',
+                    {$backup_field}                   
+                    created_at timestamp NOT NULL default CURRENT_TIMESTAMP,                                 
+                    PRIMARY KEY  (id),
+                    KEY order_id (order_id),                            
+                    KEY customer_id (customer_id),
+                    KEY product_id (product_id),
+                    KEY ticket (ticket),
+                    KEY ticket_no (ticket_no),
+                    KEY catid_one (catid_one),
+                    KEY catid_two (catid_two),
+                    KEY order_status (order_status),
+                    KEY created_at (created_at),
+                    KEY live_order (live_order),
+                    KEY woo_session_id (woo_session_id),
+                    KEY reserved (reserved)
+                ) $charset_collate;";  
+
+        return $sql_query;
+    }
+
     private function createAuditTable( $table_name, $charset_collate ){
         $sql_query =  "CREATE TABLE IF NOT EXISTS {$table_name} (
@@ -169 +217 @@
         $sql_main           = $this->createMainTables( $table_main, $charset_collate );
 
+        //create main with timestamp if datetime is not created
+        $sql_main_ts        = $this->createMainTableTs( $table_main, $charset_collate );
+
         $sql_main_b         = $this->createMainTables( $table_main_b, $charset_collate );
 
@@ -181 +232 @@
         require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
 
-        dbDelta( $sql_main );  
+        dbDelta( $sql_main ); 
+        dbDelta( $sql_main_ts ); 
         dbDelta( $sql_main_b ) ;    
         dbDelta( $sql_audit  ); 

raffle-play-woo/trunk/raffle-play-woo.php

@@ -3 +3 @@
 * Plugin Name: Raffle Play Woo
 * Plugin URI: https://tuskcode.com
-* Version: 2.4.3
+* Version: 2.4.4
 * Author: dan009
 * Description: Raffle Play Woo is the next raffle plugin for your website. It offers a complete workflow of managing raffle tickets from the admin view to the user experience.
@@ -14 +14 @@
 
 $RafflePlayWoo_MinimalRequiredPhpVersion = '5.2';
-if( ! defined('RAFFLE_PLAY_WOO_VERSION')) define('RAFFLE_PLAY_WOO_VERSION', '2.4.3');
+if( ! defined('RAFFLE_PLAY_WOO_VERSION')) define('RAFFLE_PLAY_WOO_VERSION', '2.4.4');
 if( ! defined('RAFFLE_PLAY_WOO_WP_TESTED')) define('RAFFLE_PLAY_WOO_WP_TESTED', '6.7');
 if( ! defined('RAFFLE_PLAY_WOO_URL')) define( 'RAFFLE_PLAY_WOO_URL', esc_url( plugins_url( '', __FILE__ ) ) );

raffle-play-woo/trunk/readme.txt

@@ -5 +5 @@
 Requires at least: 5.0.1
 Tested up to: 6.7
-Stable tag: 2.4.3
+Stable tag: 2.4.4
 Requires PHP: 5.2.4
 License: GPLv2 or later
@@ -35 +35 @@
 
 == Changelog ==
+
+= 2025-03-11
+* Added query when creating main table to handle timestamp column for older versions of mysql
 
 = 2024-11-22