stoneharry

Untitled

Jun 26th, 2012
265
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.85 KB | None | 0 0
  1. $query = "REPLACE INTO `sales_orders`
  2. (`state`, `status`, `coupon_code`, `protect_code` , `shipping_description`, `is_virtual` ,
  3. `store_id`, `customer_id` , `base_discount_amount`, `base_discount_canceled` , `base_shipping_canceled`,
  4. `base_shipping_invoiced` , `base_shipping_refunded`, `base_shipping_tax_amount` , `base_shipping_tax_refunded`,
  5. `base_subtotal` , `base_subtotal_incl_tax`, `base_total_due` , `payment_authorization_amount`, `shipping_discount_amount`
  6. , `subtotal_incl_tax`, `total_due` , `weight`, `customer_dob` , `increment_id`, `applied_rule_ids` , `base_currency_code`,
  7. `customer_email` , `customer_firstname`, `customer_lastname` , `customer_middlename`, `customer_prefix` , `customer_suffix`,
  8. `customer_taxvat` , `discount_description`, `ext_customer_id` , `ext_order_id`, `global_currency_code` , `hold_before_state`,
  9. `hold_before_status` , `order_currency_code`, `original_increment_id` , `relation_child_id`, `relation_child_real_id` ,
  10. `relation_parent_id`, `relation_parent_real_id`, `remote_ip`, `shipping_method` , `store_currency_code`, `store_name`,
  11. `x_forwarded_for`, `customer_note` , `created_at`, `updated_at`, `total_item_count`, `customer_gender` , `hidden_tax_amount`,
  12. `base_hidden_tax_amount`, `shipping_hidden_tax_amount`, `base_shipping_hidden_tax_amnt` , `base_shipping_hidden_tax_amount`,
  13. `hidden_tax_invoiced`, `base_hidden_tax_invoiced`, `hidden_tax_refunded` , `base_hidden_tax_refunded`, `shipping_incl_tax`,
  14. `base_shipping_incl_tax`, `paypal_ipn_customer_notified` , `gift_message_id`, `firstname`, `lastname` ,
  15. `telephone`, `postcode`, `billing_firstname` , `billing_lastname`, `billing_name`, `shipping_name` , `order_id`)
  16. VALUES
  17. ('', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '')";
Advertisement
Add Comment
Please, Sign In to add comment