Changeset 2309570

Timestamp:

05/21/2020 03:21:50 PM (6 years ago)

Author:

teoleonard

Message:

update in query

File:

• raffle-ticket-generator/trunk/raffle-ticket-generator.php (modified) (2 diffs)

raffle-ticket-generator/trunk/raffle-ticket-generator.php

@@ -4 +4 @@
 Plugin URI: http://wpraffle.com
 Description: Raffle Ticket Generator.  Generate numbered raffle tickets and email virtual tickets via WooCommerce order system
-Version: 3.6
+Version: 3.6.1
 Author: The Web Design Ninja
 Author URI: http://TheWebDesignNinja.com 
@@ -580 +580 @@
     $last_order_id = get_orders_from($order_id);
 
-    $start_query = $wpdb->get_results('SELECT `ticket_number` FROM `'.$wpdb->prefix.'wooraffle_tickets_customer_to_tickets` ORDER BY CAST(`ticket_number` AS UNSIGNED)=0, CAST(`ticket_number` AS UNSIGNED), LEFT(`ticket_number`,1), CAST(MID(`ticket_number`,2) AS UNSIGNED) LIMIT 0,1 ');
-    
+    //$start_query = $wpdb->get_results('SELECT `ticket_number` FROM `'.$wpdb->prefix.'wooraffle_tickets_customer_to_tickets` ORDER BY CAST(`ticket_number` AS UNSIGNED)=0, CAST(`ticket_number` AS UNSIGNED), LEFT(`ticket_number`,1), CAST(MID(`ticket_number`,2) AS UNSIGNED) LIMIT 0,1 ');
+    $start_query = $wpdb->get_results('SELECT `ticket_number` FROM `'.$wpdb->prefix.'wooraffle_tickets_customer_to_tickets` ORDER BY order_id desc LIMIT 1 ');
 if (empty($start_query)) {
 $start = 1;