woothemes /
woocommerce
| @@ 275-285 (lines=11) @@ | ||
| 272 | add_post_meta( $this->id, '_stock', 0, true ); |
|
| 273 | ||
| 274 | // Update stock in DB directly |
|
| 275 | switch ( $mode ) { |
|
| 276 | case 'add' : |
|
| 277 | $wpdb->query( $wpdb->prepare( "UPDATE {$wpdb->postmeta} SET meta_value = meta_value + %f WHERE post_id = %d AND meta_key='_stock'", $amount, $this->id ) ); |
|
| 278 | break; |
|
| 279 | case 'subtract' : |
|
| 280 | $wpdb->query( $wpdb->prepare( "UPDATE {$wpdb->postmeta} SET meta_value = meta_value - %f WHERE post_id = %d AND meta_key='_stock'", $amount, $this->id ) ); |
|
| 281 | break; |
|
| 282 | default : |
|
| 283 | $wpdb->query( $wpdb->prepare( "UPDATE {$wpdb->postmeta} SET meta_value = %f WHERE post_id = %d AND meta_key='_stock'", $amount, $this->id ) ); |
|
| 284 | break; |
|
| 285 | } |
|
| 286 | ||
| 287 | // Clear caches |
|
| 288 | wp_cache_delete( $this->id, 'post_meta' ); |
|
| @@ 442-452 (lines=11) @@ | ||
| 439 | add_post_meta( $this->variation_id, '_stock', 0, true ); |
|
| 440 | ||
| 441 | // Update stock in DB directly |
|
| 442 | switch ( $mode ) { |
|
| 443 | case 'add' : |
|
| 444 | $wpdb->query( $wpdb->prepare( "UPDATE {$wpdb->postmeta} SET meta_value = meta_value + %f WHERE post_id = %d AND meta_key='_stock'", $amount, $this->variation_id ) ); |
|
| 445 | break; |
|
| 446 | case 'subtract' : |
|
| 447 | $wpdb->query( $wpdb->prepare( "UPDATE {$wpdb->postmeta} SET meta_value = meta_value - %f WHERE post_id = %d AND meta_key='_stock'", $amount, $this->variation_id ) ); |
|
| 448 | break; |
|
| 449 | default : |
|
| 450 | $wpdb->query( $wpdb->prepare( "UPDATE {$wpdb->postmeta} SET meta_value = %f WHERE post_id = %d AND meta_key='_stock'", $amount, $this->variation_id ) ); |
|
| 451 | break; |
|
| 452 | } |
|
| 453 | ||
| 454 | // Clear caches |
|
| 455 | wp_cache_delete( $this->variation_id, 'post_meta' ); |
|
