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' ); |
|
| @@ 453-463 (lines=11) @@ | ||
| 450 | add_post_meta( $this->variation_id, '_stock', 0, true ); |
|
| 451 | ||
| 452 | // Update stock in DB directly |
|
| 453 | switch ( $mode ) { |
|
| 454 | case 'add' : |
|
| 455 | $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 ) ); |
|
| 456 | break; |
|
| 457 | case 'subtract' : |
|
| 458 | $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 ) ); |
|
| 459 | break; |
|
| 460 | default : |
|
| 461 | $wpdb->query( $wpdb->prepare( "UPDATE {$wpdb->postmeta} SET meta_value = %f WHERE post_id = %d AND meta_key='_stock'", $amount, $this->variation_id ) ); |
|
| 462 | break; |
|
| 463 | } |
|
| 464 | ||
| 465 | // Clear caches |
|
| 466 | wp_cache_delete( $this->variation_id, 'post_meta' ); |
|
