Context Navigation

Changeset 2325764

Timestamp:

06/17/2020 09:55:55 AM (6 years ago)

Author:

ijasonwhite

Message:

Update insert method for postmeta, for some environments previous method was not working.

Location:

jw-woo-order-prefix/trunk

Files:

-                      r2325761
+                      r2325764
 <?php
 /*
 Plugin Name: JW Order Prefix for WooCommerce
+Plugin Name: JW Woo Order Prefix
 Description: Adds a prefix to WooCommerce orders numbers
 Version: 0.1.2
+Version: 0.1.3
 Author: iJasonWhite
 Author URI: https://jasonwhite.uk
 …
                         $success = false;
+                        $query = $wpdb->prepare("
+                                INSERT INTO {$wpdb->postmeta} (post_id, meta_key, meta_value)
+                                SELECT %d, '_order_number', concat(%s,%d )
+                                FROM {$wpdb->postmeta}
+                                WHERE meta_key='_order_number'", $post_id, $prefix, $post_id);
+                        $success = $wpdb->query($query);
+                        return $success;
+                    }
+                        $sql = "INSERT INTO {$wpdb->postmeta} (post_id, meta_key, meta_value) VALUES('".$wpdb->_real_escape($post_id)."','_order_number', '".$wpdb->_real_escape($prefix.$post_id)."'  )";
+                        $success = $wpdb->query($sql);
+                        return $success;
+                    } else {
+                        return false;
+                    }
+                }
+            }
 …
 endif;

r2325761	r2325764
21	21	= 1.0 =
22	22	* First Release.
	23
	24	= 1.0.2 =
	25	* Update insert method for postmeta, for some enviroments previous method was not working.

Note: See TracChangeset for help on using the changeset viewer.