woothemes /
woocommerce
| @@ 273-283 (lines=11) @@ | ||
| 270 | add_post_meta( $this->id, '_stock', 0, true ); |
|
| 271 | ||
| 272 | // Update stock in DB directly |
|
| 273 | switch ( $mode ) { |
|
| 274 | case 'add' : |
|
| 275 | $wpdb->query( $wpdb->prepare( "UPDATE {$wpdb->postmeta} SET meta_value = meta_value + %f WHERE post_id = %d AND meta_key='_stock'", $amount, $this->id ) ); |
|
| 276 | break; |
|
| 277 | case 'subtract' : |
|
| 278 | $wpdb->query( $wpdb->prepare( "UPDATE {$wpdb->postmeta} SET meta_value = meta_value - %f WHERE post_id = %d AND meta_key='_stock'", $amount, $this->id ) ); |
|
| 279 | break; |
|
| 280 | default : |
|
| 281 | $wpdb->query( $wpdb->prepare( "UPDATE {$wpdb->postmeta} SET meta_value = %f WHERE post_id = %d AND meta_key='_stock'", $amount, $this->id ) ); |
|
| 282 | break; |
|
| 283 | } |
|
| 284 | ||
| 285 | // Clear caches |
|
| 286 | wp_cache_delete( $this->id, 'post_meta' ); |
|
| @@ 461-471 (lines=11) @@ | ||
| 458 | add_post_meta( $this->variation_id, '_stock', 0, true ); |
|
| 459 | ||
| 460 | // Update stock in DB directly |
|
| 461 | switch ( $mode ) { |
|
| 462 | case 'add' : |
|
| 463 | $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 ) ); |
|
| 464 | break; |
|
| 465 | case 'subtract' : |
|
| 466 | $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 ) ); |
|
| 467 | break; |
|
| 468 | default : |
|
| 469 | $wpdb->query( $wpdb->prepare( "UPDATE {$wpdb->postmeta} SET meta_value = %f WHERE post_id = %d AND meta_key='_stock'", $amount, $this->variation_id ) ); |
|
| 470 | break; |
|
| 471 | } |
|
| 472 | ||
| 473 | // Clear caches |
|
| 474 | wp_cache_delete( $this->variation_id, 'post_meta' ); |
|
