function install_woocommerce_catalog_restrictions() { global $woocommerce, $wc_catalog_restrictions; include_once $woocommerce->plugin_path() . '/admin/woocommerce-admin-install.php'; if (!get_option('woocommerce_choose_location_page_id')) { woocommerce_create_page(esc_sql(_x('choose-location', 'page_slug', 'wc_catalog_restrictions')), 'woocommerce_choose_location_page_id', __('Your Location', 'wc_catalog_restrictions'), '[location_picker /]'); } update_option("woocommerce_catalog_restrictions_db_version", $wc_catalog_restrictions->version); }
function install_woocommerce_catalog_restrictions() { global $woocommerce, $wc_catalog_restrictions, $wpdb; if (!WC_Catalog_Visibility_Compatibility::is_wc_version_gte_2_1()) { include_once $woocommerce->plugin_path() . '/admin/woocommerce-admin-install.php'; } //Clean up old rules. $wc_term_meta_table = $wpdb->prefix . 'woocommerce_termmeta'; $wpdb->query("DELETE FROM {$wc_term_meta_table} WHERE (meta_key = '_wc_restrictions' OR meta_key = '_wc_restrictions_allowed') AND (meta_value = '');"); $wpdb->query("DELETE FROM {$wc_term_meta_table} WHERE (meta_key = '_wc_restrictions_location' OR meta_key = '_wc_restrictions_locations') AND (meta_value = '');"); //Clean up the transients $wpdb->query("DELETE FROM {$wpdb->options} WHERE option_name LIKE '_transient_twccr%'"); $wpdb->query("DELETE FROM {$wpdb->options} WHERE option_name LIKE '_transient_timeout_twccr%'"); if (!get_option('woocommerce_choose_location_page_id')) { if (!WC_Catalog_Visibility_Compatibility::is_wc_version_gte_2_1()) { wc_create_page(esc_sql(_x('choose-location', 'page_slug', 'wc_catalog_restrictions')), 'woocommerce_choose_location_page_id', __('Your Location', 'wc_catalog_restrictions'), '[location_picker /]'); } else { woocommerce_create_page(esc_sql(_x('choose-location', 'page_slug', 'wc_catalog_restrictions')), 'woocommerce_choose_location_page_id', __('Your Location', 'wc_catalog_restrictions'), '[location_picker /]'); } } update_option("woocommerce_catalog_restrictions_db_version", $wc_catalog_restrictions->version); }
$wpdb->insert($wpdb->prefix . "woocommerce_tax_rates", array('tax_rate_country' => $tax_rate['country'], 'tax_rate_state' => $tax_rate['state'], 'tax_rate' => $tax_rate['rate'], 'tax_rate_name' => $tax_rate['label'], 'tax_rate_priority' => 2, 'tax_rate_compound' => $tax_rate['compound'] == 'yes' ? 1 : 0, 'tax_rate_shipping' => $tax_rate['shipping'] == 'yes' ? 1 : 0, 'tax_rate_order' => $loop, 'tax_rate_class' => $tax_rate['class'])); $tax_rate_id = $wpdb->insert_id; if ($tax_rate['locations']) { foreach ($tax_rate['locations'] as $location) { $wpdb->insert($wpdb->prefix . "woocommerce_tax_rate_locations", array('location_code' => $location, 'tax_rate_id' => $tax_rate_id, 'location_type' => $location_type)); } } $loop++; } } update_option('woocommerce_tax_rates_backup', $tax_rates); update_option('woocommerce_local_tax_rates_backup', $local_tax_rates); delete_option('woocommerce_tax_rates'); delete_option('woocommerce_local_tax_rates'); // Create lost password page woocommerce_create_page(esc_sql(_x('lost-password', 'page_slug', 'woocommerce')), 'woocommerce_lost_password_page_id', __('Lost Password', 'woocommerce'), '[woocommerce_lost_password]', woocommerce_get_page_id('myaccount')); // Now its time for the massive update to line items - move them to the new DB tables // Reverse with UPDATE `wpwc_postmeta` SET meta_key = '_order_items' WHERE meta_key = '_order_items_old' $order_item_rows = $wpdb->get_results("\r\n\tSELECT * FROM {$wpdb->postmeta}\r\n\tWHERE meta_key = '_order_items'\r\n"); foreach ($order_item_rows as $order_item_row) { $order_items = (array) maybe_unserialize($order_item_row->meta_value); foreach ($order_items as $order_item) { if (!isset($order_item['line_total']) && isset($order_item['taxrate']) && isset($order_item['cost'])) { $order_item['line_tax'] = number_format($order_item['cost'] * $order_item['qty'] * ($order_item['taxrate'] / 100), 2, '.', ''); $order_item['line_total'] = $order_item['cost'] * $order_item['qty']; $order_item['line_subtotal_tax'] = $order_item['line_tax']; $order_item['line_subtotal'] = $order_item['line_total']; } $order_item['line_tax'] = isset($order_item['line_tax']) ? $order_item['line_tax'] : 0; $order_item['line_total'] = isset($order_item['line_total']) ? $order_item['line_total'] : 0; $order_item['line_subtotal_tax'] = isset($order_item['line_subtotal_tax']) ? $order_item['line_subtotal_tax'] : 0;
/** * Create pages that the plugin relies on, storing page id's in variables. * * @access public * @return void */ function woocommerce_create_pages() { // Shop page woocommerce_create_page(esc_sql(_x('shop', 'page_slug', 'woocommerce')), 'woocommerce_shop_page_id', __('Shop', 'woocommerce'), ''); // Cart page woocommerce_create_page(esc_sql(_x('cart', 'page_slug', 'woocommerce')), 'woocommerce_cart_page_id', __('Cart', 'woocommerce'), '[woocommerce_cart]'); // Checkout page woocommerce_create_page(esc_sql(_x('checkout', 'page_slug', 'woocommerce')), 'woocommerce_checkout_page_id', __('Checkout', 'woocommerce'), '[woocommerce_checkout]'); // My Account page woocommerce_create_page(esc_sql(_x('my-account', 'page_slug', 'woocommerce')), 'woocommerce_myaccount_page_id', __('My Account', 'woocommerce'), '[woocommerce_my_account]'); // Lost password page woocommerce_create_page(esc_sql(_x('lost-password', 'page_slug', 'woocommerce')), 'woocommerce_lost_password_page_id', __('Lost Password', 'woocommerce'), '[woocommerce_lost_password]', woocommerce_get_page_id('myaccount')); // Edit address page woocommerce_create_page(esc_sql(_x('edit-address', 'page_slug', 'woocommerce')), 'woocommerce_edit_address_page_id', __('Edit My Address', 'woocommerce'), '[woocommerce_edit_address]', woocommerce_get_page_id('myaccount')); // View order page woocommerce_create_page(esc_sql(_x('view-order', 'page_slug', 'woocommerce')), 'woocommerce_view_order_page_id', __('View Order', 'woocommerce'), '[woocommerce_view_order]', woocommerce_get_page_id('myaccount')); // Change password page woocommerce_create_page(esc_sql(_x('change-password', 'page_slug', 'woocommerce')), 'woocommerce_change_password_page_id', __('Change Password', 'woocommerce'), '[woocommerce_change_password]', woocommerce_get_page_id('myaccount')); // Logout page woocommerce_create_page(esc_sql(_x('logout', 'page_slug', 'woocommerce')), 'woocommerce_logout_page_id', __('Logout', 'woocommerce'), '', woocommerce_get_page_id('myaccount')); // Pay page woocommerce_create_page(esc_sql(_x('pay', 'page_slug', 'woocommerce')), 'woocommerce_pay_page_id', __('Checkout → Pay', 'woocommerce'), '[woocommerce_pay]', woocommerce_get_page_id('checkout')); // Thanks page woocommerce_create_page(esc_sql(_x('order-received', 'page_slug', 'woocommerce')), 'woocommerce_thanks_page_id', __('Order Received', 'woocommerce'), '[woocommerce_thankyou]', woocommerce_get_page_id('checkout')); }
/** * Create pages * * Creates pages that the plugin relies on, storing page id's in variables. */ function woocommerce_create_pages() { // Shop page woocommerce_create_page(esc_sql(_x('shop', 'page_slug', 'woothemes')), 'woocommerce_shop_page_id', __('Shop', 'woothemes'), ''); // Cart page woocommerce_create_page(esc_sql(_x('cart', 'page_slug', 'woothemes')), 'woocommerce_cart_page_id', __('Cart', 'woothemes'), '[woocommerce_cart]'); // Checkout page woocommerce_create_page(esc_sql(_x('checkout', 'page_slug', 'woothemes')), 'woocommerce_checkout_page_id', __('Checkout', 'woothemes'), '[woocommerce_checkout]'); // Order tracking page woocommerce_create_page(esc_sql(_x('order-tracking', 'page_slug', 'woothemes')), 'woocommerce_order_tracking_page_id', __('Track your order', 'woothemes'), '[woocommerce_order_tracking]'); // My Account page woocommerce_create_page(esc_sql(_x('my-account', 'page_slug', 'woothemes')), 'woocommerce_myaccount_page_id', __('My Account', 'woothemes'), '[woocommerce_my_account]'); // Edit address page woocommerce_create_page(esc_sql(_x('edit-address', 'page_slug', 'woothemes')), 'woocommerce_edit_address_page_id', __('Edit My Address', 'woothemes'), '[woocommerce_edit_address]', get_option('woocommerce_myaccount_page_id')); // View order page woocommerce_create_page(esc_sql(_x('view-order', 'page_slug', 'woothemes')), 'woocommerce_view_order_page_id', __('View Order', 'woothemes'), '[woocommerce_view_order]', get_option('woocommerce_myaccount_page_id')); // Change password page woocommerce_create_page(esc_sql(_x('change-password', 'page_slug', 'woothemes')), 'woocommerce_change_password_page_id', __('Change Password', 'woothemes'), '[woocommerce_change_password]', get_option('woocommerce_myaccount_page_id')); // Pay page woocommerce_create_page(esc_sql(_x('pay', 'page_slug', 'woothemes')), 'woocommerce_pay_page_id', __('Checkout → Pay', 'woothemes'), '[woocommerce_pay]', get_option('woocommerce_checkout_page_id')); // Thanks page woocommerce_create_page(esc_sql(_x('order-received', 'page_slug', 'woothemes')), 'woocommerce_thanks_page_id', __('Order Received', 'woothemes'), '[woocommerce_thankyou]', get_option('woocommerce_checkout_page_id')); }
function swr_refer_create_pages() { woocommerce_create_page(esc_sql(_x('refer-a-friend', 'page_slug', 'rewards')), 'swr_refer_a_friend', __('Refer a friend', 'rewards'), '<p>Here you can enter some of your friends email address to earn rewards when they place their first order!</p><h2>Option 1 - Enter your friends email addresses</h2>[swr_refer_a_friend refer_option="1" refer_message="Place your first order with ' . get_bloginfo("name") . ' and earn rewards!"]<h2>Option 2 - Share via social networks</h2><p>When you share our website with your social friends, a custom link will be created to track your friend.</p> [swr_refer_a_friend refer_option="2"]<h2>Option 3 - Personal link</h2><p>Copy, paste, give, send, print, forward this link to your friends!</p>[swr_refer_a_friend refer_option="3"]<h2>Option 4 - QR code</h2>[swr_refer_a_friend refer_option="4"]', woocommerce_get_page_id('myaccount')); }