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'));
}