public function import($db_already_cloned)
{
Registry::set('runtime.simple_ultimate', true);
Registry::del('runtime.forced_company_id');
General::setProgressTitle(__CLASS__);
if (!$db_already_cloned) {
if (!General::cloneImportedDB($this->store_data)) {
return false;
}
} else {
General::setEmptyProgressBar(__('importing_data'));
General::setEmptyProgressBar(__('importing_data'));
}
General::connectToOriginalDB(array('table_prefix' => General::formatPrefix()));
$main_sql = Registry::get('config.dir.addons') . 'store_import/database/' . $this->main_sql_filename;
if (is_file($main_sql)) {
//Process main sql
if (!db_import_sql_file($main_sql)) {
return false;
}
}
General::setEmptyProgressBar(General::getUnavailableLangVar('updating_languages'));
General::updateAltLanguages('language_values', 'name');
General::updateAltLanguages('shipping_service_descriptions', 'service_id');
General::setEmptyProgressBar();
General::setEmptyProgressBar();
return true;
}
public function import($db_already_cloned)
{
General::setProgressTitle(__CLASS__);
if (!$db_already_cloned) {
if (!General::cloneImportedDB($this->store_data)) {
return false;
}
} else {
General::setEmptyProgressBar(__('importing_data'));
General::setEmptyProgressBar(__('importing_data'));
}
General::connectToOriginalDB(array('table_prefix' => General::formatPrefix()));
$main_sql = Registry::get('config.dir.addons') . 'store_import/database/' . $this->main_sql_filename;
if (is_file($main_sql)) {
//Process main sql
if (!db_import_sql_file($main_sql)) {
return false;
}
}
General::addEsStates();
General::restoreSettings();
General::setEmptyProgressBar(General::getUnavailableLangVar('updating_languages'));
General::updateAltLanguages('language_values', 'name');
General::updateAltLanguages('settings_descriptions', array('object_id', 'object_type'));
General::updateAltLanguages('state_descriptions', 'state_id');
General::setEmptyProgressBar();
General::setEmptyProgressBar();
return true;
}
public function import($db_already_cloned)
{
General::setProgressTitle(__CLASS__);
if (!$db_already_cloned) {
if (!General::cloneImportedDB($this->store_data)) {
return false;
}
} else {
General::setEmptyProgressBar(__('importing_data'));
General::setEmptyProgressBar(__('importing_data'));
}
General::connectToOriginalDB(array('table_prefix' => General::formatPrefix()));
$main_sql = Registry::get('config.dir.addons') . 'store_import/database/' . $this->main_sql_filename;
if (is_file($main_sql)) {
//Process main sql
if (!db_import_sql_file($main_sql)) {
return false;
}
}
General::restoreSettings();
db_query("\n DELETE FROM ?:settings_objects\n WHERE name IN (\n 'product_notify_vendor',\n 'order_notify_vendor',\n 'page_notify_vendor',\n 'company_discussion_type',\n 'company_only_buyers',\n 'company_posts_per_page',\n 'company_post_approval',\n 'company_post_ip_check',\n 'company_notification_email',\n 'company_notify_vendor',\n 'companies_setting',\n 'include_companies',\n 'companies_change',\n 'companies_priority',\n 'product_share_discussion',\n 'news_share_discussion',\n 'page_share_discussion',\n 'testimonials_from_all_stores'\n )\n AND section_id IN (\n SELECT section_id FROM ?:settings_sections\n WHERE name IN (\n 'discussion',\n 'google_sitemap'\n )\n )\n ");
General::setEmptyProgressBar(General::getUnavailableLangVar('updating_languages'));
General::updateAltLanguages('language_values', 'name');
General::updateAltLanguages('settings_descriptions', array('object_id', 'object_type'));
General::updateAltLanguages('state_descriptions', 'state_id');
db_query('DROP TABLE IF EXISTS ?:se_queue');
General::setEmptyProgressBar();
General::setEmptyProgressBar();
return true;
}
public function import($db_already_cloned)
{
General::setProgressTitle(__CLASS__);
if (!$db_already_cloned) {
if (!General::cloneImportedDB($this->store_data)) {
return false;
}
} else {
General::setEmptyProgressBar(__('importing_data'));
General::setEmptyProgressBar(__('importing_data'));
}
General::connectToOriginalDB(array('table_prefix' => General::formatPrefix()));
$main_sql = Registry::get('config.dir.addons') . 'store_import/database/' . $this->main_sql_filename;
if (is_file($main_sql)) {
//Process main sql
if (!db_import_sql_file($main_sql)) {
return false;
}
}
General::processAddons($this->store_data, __CLASS__);
General::setEmptyProgressBar(General::getUnavailableLangVar('updating_languages'));
General::updateAltLanguages('language_values', 'name');
General::updateAltLanguages('settings_descriptions', array('object_id', 'object_type'));
General::updateAltLanguages('shipping_service_descriptions', 'service_id');
General::updateAltLanguages('privilege_descriptions', 'privilege');
General::updateAltLanguages('privilege_section_descriptions', 'section_id');
General::updateAltLanguages('state_descriptions', 'state_id');
General::updateAltLanguages('country_descriptions', 'code');
General::processBlocks();
General::setEmptyProgressBar();
if (db_get_field("SHOW TABLES LIKE '?:mailing_lists'")) {
db_query("ALTER TABLE ?:mailing_lists DROP `show_on_sidebar`");
}
return true;
}
public function import($db_already_cloned)
{
General::setProgressTitle(__CLASS__);
if (!$db_already_cloned) {
if (!General::cloneImportedDB($this->store_data)) {
return false;
}
} else {
General::setEmptyProgressBar(__('importing_data'));
General::setEmptyProgressBar(__('importing_data'));
}
General::connectToOriginalDB(array('table_prefix' => General::formatPrefix()));
General::processAddons($this->store_data, __CLASS__);
$main_sql = Registry::get('config.dir.addons') . 'store_import/database/' . $this->main_sql_filename;
if (is_file($main_sql)) {
//Process main sql
if (!db_import_sql_file($main_sql)) {
return false;
}
}
General::setEmptyProgressBar(General::getUnavailableLangVar('updating_languages'));
General::updateAltLanguages('language_values', 'name');
General::updateAltLanguages('settings_descriptions', array('object_id', 'object_type'));
General::convertPresets403To411();
General::convertScrollerBlocks();
db_query("UPDATE ?:sales_reports_tables SET type = 'P' WHERE type = 'C'");
General::setEmptyProgressBar();
return true;
}
public function import($db_already_cloned)
{
General::setProgressTitle(__CLASS__);
if (!$db_already_cloned) {
if (!General::cloneImportedDB($this->store_data)) {
return false;
}
} else {
General::setEmptyProgressBar(__('importing_data'));
General::setEmptyProgressBar(__('importing_data'));
}
General::connectToOriginalDB(array('table_prefix' => General::formatPrefix()));
General::processAddons($this->store_data, __CLASS__);
$main_sql = Registry::get('config.dir.addons') . 'store_import/database/' . $this->main_sql_filename;
if (is_file($main_sql)) {
//Process main sql
if (!db_import_sql_file($main_sql)) {
return false;
}
}
// General::restoreSettings();
if (db_get_field("SELECT status FROM ?:addons WHERE addon = 'searchanise'") != 'D') {
db_query("UPDATE ?:addons SET status = 'D' WHERE addon = 'searchanise'");
fn_set_notification('W', __('warning'), General::getUnavailableLangVar('uc_searchanise_disabled'));
}
General::setActualLangValues();
General::updateAltLanguages('language_values', 'name');
General::updateAltLanguages('ult_language_values', array('name', 'company_id'));
General::updateAltLanguages('settings_descriptions', array('object_id', 'object_type'));
General::setEmptyProgressBar();
General::setEmptyProgressBar();
General::setEmptyProgressBar();
General::setEmptyProgressBar();
return true;
}
public function import($db_already_cloned)
{
General::setProgressTitle(__CLASS__);
if (!$db_already_cloned) {
if (!General::cloneImportedDB($this->store_data)) {
return false;
}
} else {
General::setEmptyProgressBar(__('importing_data'));
General::setEmptyProgressBar(__('importing_data'));
}
General::connectToOriginalDB(array('table_prefix' => General::formatPrefix()));
$main_sql = Registry::get('config.dir.addons') . 'store_import/database/' . $this->main_sql_filename;
if (is_file($main_sql)) {
//Process main sql
if (!db_import_sql_file($main_sql)) {
return false;
}
}
General::setEmptyProgressBar();
General::restoreSettings();
db_query("\n DELETE FROM ?:settings_objects\n WHERE name IN (\n 'product_share_discussion',\n 'news_share_discussion',\n 'page_share_discussion',\n 'testimonials_from_all_stores'\n )\n AND section_id IN (\n SELECT section_id FROM ?:settings_sections\n WHERE name = 'discussion'\n )\n ");
General::setEmptyProgressBar(General::getUnavailableLangVar('updating_languages'));
General::updateAltLanguages('language_values', 'name');
General::updateAltLanguages('settings_descriptions', array('object_id', 'object_type'));
General::updateAltLanguages('shipping_service_descriptions', 'service_id');
General::updateAltLanguages('state_descriptions', 'state_id');
General::setEmptyProgressBar();
return true;
}
public function import($db_already_cloned)
{
General::setProgressTitle(__CLASS__);
if (!$db_already_cloned) {
if (!General::cloneImportedDB($this->store_data)) {
return false;
}
} else {
General::setEmptyProgressBar(__('importing_data'));
General::setEmptyProgressBar(__('importing_data'));
}
General::connectToOriginalDB(array('table_prefix' => General::formatPrefix()));
$main_sql = Registry::get('config.dir.addons') . 'store_import/database/' . $this->main_sql_filename;
if (is_file($main_sql)) {
//Process main sql
if (!db_import_sql_file($main_sql)) {
return false;
}
}
General::setEmptyProgressBar(General::getUnavailableLangVar('updating_languages'));
General::updateAltLanguages('language_values', 'name');
General::updateAltLanguages('settings_descriptions', array('object_id', 'object_type'));
General::updateAltLanguages('privilege_descriptions', 'privilege');
General::updateAltLanguages('state_descriptions', 'state_id');
General::updateAltLanguages('shipping_service_descriptions', 'service_id');
General::setEmptyProgressBar();
$fields = array('profile_show', 'checkout_show', 'partner_show');
$billing = db_get_row("SELECT " . implode(', ', $fields) . " FROM ?:profile_fields WHERE field_name = 'email' AND section = 'B'");
$shipping = array();
foreach ($fields as $field) {
$shipping[$field] = $billing[$field] == 'Y' ? 'N' : 'Y';
}
db_query("UPDATE ?:profile_fields SET ?u WHERE field_name = 'email' AND section = 'S'", $shipping);
General::setEmptyProgressBar();
return true;
}
protected function _convertOrders($default_company_id)
{
$limit = 50;
General::connectToOriginalDB(array('table_prefix' => General::formatPrefix()));
db_query("UPDATE ?:order_data SET type='A' WHERE type='G'");
//change marker for addon Reward points
$orders_count = db_get_field("SELECT COUNT(*) FROM ?:orders");
$crypt = new Crypt_Blowfish($this->store_data['crypt_key']);
$crypt_new = new Crypt_Blowfish(Registry::get('config.crypt_key'));
$location_fields = array('s_firstname as firstname', 's_lastname as lastname', 's_address as address', 's_address_2 as address_2', 's_city as city', 's_state as state', 's_country as country', 's_zipcode as zipcode', 's_phone as phone', 's_address_type as address_type');
fn_set_progress('step_scale', ceil($orders_count / $limit));
for ($i = 0; $i <= floor($orders_count / $limit); $i++) {
$order_ids = db_get_fields("SELECT order_id FROM ?:orders LIMIT ?i, ?i", $i * $limit, $limit);
$data = array();
$shipment_items = array();
fn_set_progress('echo', '<br />' . General::getUnavailableLangVar('converting_orders'), true);
foreach ($order_ids as $order_id) {
$order_info = array();
$order_info['shipping'] = unserialize(db_get_field("SELECT data FROM ?:order_data WHERE type='L' AND order_id = ?i", $order_id));
$order_info['products'] = db_get_hash_array("SELECT * FROM ?:order_details WHERE order_id = ?i", 'item_id', $order_id);
$location = db_get_row("SELECT ?p FROM ?:orders WHERE order_id = ?i", implode(',', $location_fields), $order_id);
if ($order_info['products']) {
foreach ($order_info['products'] as $cart_id => $product) {
if ($product['extra']) {
$order_info['products'][$cart_id]['extra'] = unserialize($product['extra']);
}
}
}
$products = array();
foreach ($order_info['products'] as $cart_id => $product) {
$products[$cart_id] = $product['extra'];
$products[$cart_id]['amount'] = $product['amount'];
$products[$cart_id]['product_id'] = $product['product_id'];
}
$product_groups = $this->_groupProductsListOrder($products);
$shippings = array();
foreach ($product_groups as $key_group => $group) {
if (!empty($order_info['shipping'])) {
foreach ($order_info['shipping'] as $shipping_id => $shipping) {
$_shipping = $shipping;
$_shipping['shipping_id'] = $shipping_id;
unset($_shipping['rates']);
if (isset($_shipping['tracking_number'])) {
$shipment = array('shipping_id' => $shipping_id, 'tracking_number' => $_shipping['tracking_number'], 'carrier' => strtolower($_shipping['carrier']));
$shipment_id = db_query("INSERT INTO ?:shipments ?e", $shipment);
foreach ($group['products'] as $cart_id => $product) {
$shipment_items[] = array('item_id' => $cart_id, 'shipment_id' => $shipment_id, 'order_id' => $order_id, 'product_id' => $product['product_id'], 'amount' => $product['amount']);
}
unset($_shipping['tracking_number']);
unset($_shipping['carrier']);
}
if (!empty($shipping_id)) {
foreach ($shipping['rates'] as $company_id => $rate) {
if ($company_id == $group['company_id'] || $company_id == 0 && $group['company_id'] == $default_company_id) {
$_shipping['rate'] = $rate;
$_shipping['group_key'] = $key_group;
$product_groups[$key_group]['shippings'][$shipping_id] = $_shipping;
$product_groups[$key_group]['chosen_shippings'][] = $_shipping;
$product_groups[$key_group]['package_info'] = !empty($_shipping['packages_info']) ? $_shipping['packages_info'] : array();
$product_groups[$key_group]['package_info']['location'] = $location;
$shippings[$shipping_id] = !empty($shippings[$shipping_id]) ? $shippings[$shipping_id] : $_shipping;
$shippings[$shipping_id]['rates'][$key_group] = $shipping_id;
}
}
}
}
}
}
$payment_info = db_get_field("SELECT data FROM ?:order_data WHERE type='P' AND order_id = ?i", $order_id);
if (!empty($payment_info)) {
$payment_info = $crypt->decrypt(base64_decode($payment_info));
$payment_info = base64_encode($crypt_new->encrypt($payment_info));
$data[] = array('order_id' => $order_id, 'type' => 'P', 'data' => $payment_info);
}
$data[] = array('order_id' => $order_id, 'type' => 'G', 'data' => serialize($product_groups));
$data[] = array('order_id' => $order_id, 'type' => 'L', 'data' => serialize(array_values($shippings)));
fn_echo(' .');
}
if (!empty($data)) {
db_query("REPLACE INTO ?:order_data ?m", $data);
}
if (!empty($shipment_items)) {
db_query("REPLACE INTO ?:shipment_items ?m", $shipment_items);
}
}
db_query("UPDATE ?:shipments SET carrier = LOWER(carrier);");
db_query("UPDATE ?:shipments SET carrier = 'usps' WHERE carrier = 'usp';");
db_query("UPDATE ?:shipments SET carrier = 'fedex' WHERE carrier = 'fdx';");
db_query("UPDATE ?:shipments SET carrier = 'swisspost' WHERE carrier = 'chp';");
}
public function import($db_already_cloned)
{
General::setProgressTitle(__CLASS__);
if (!$db_already_cloned) {
if (!General::cloneImportedDB($this->store_data)) {
return false;
}
} else {
General::setEmptyProgressBar(__('importing_data'));
General::setEmptyProgressBar(__('importing_data'));
}
General::connectToOriginalDB(array('table_prefix' => General::formatPrefix()));
General::processAddons($this->store_data, __CLASS__);
$main_sql = Registry::get('config.dir.addons') . 'store_import/database/' . $this->main_sql_filename;
if (is_file($main_sql)) {
//Process main sql
if (!db_import_sql_file($main_sql)) {
return false;
}
}
$this->_edpProducts();
$this->_bmNewLinkField();
$this->_addNewLocation();
$this->_removeShippingSettings();
$this->_convertImageVerification();
$this->_mveConvertImageVerification();
// $this->_addNewSettingTimeframe();
$this->_newFieldInProcessor();
$this->_renameCategoryTableFields();
$this->_updatePayPalPayments();
$this->_addNewFieldToMenu();
General::setCustomCssClassForResponsive();
General::addCheckoutSection();
General::coreCheckoutSettings();
General::removeNullTextFields();
General::filtersRefactoring();
$this->_mveFiltersRefactoring();
General::removeNewsLogger();
General::convertNewsToBlog();
General::pagesRemoveShowInPopup();
General::removeTplDebugSetting();
$this->_removeCheckoutStyleSetting();
General::revertSearchFieldBlock();
General::addFullHttps();
General::removeUseEmailAsLoginSetting();
General::removeUserLoginEximField();
$this->coreLogosLinkedToStyles();
db_query("ALTER TABLE ?:vendor_payouts CHANGE `comments` `comments` text");
db_query("UPDATE ?:usergroup_privileges SET privilege = 'backup_restore' WHERE privilege = 'database_maintenance'");
db_query("UPDATE ?:privileges SET privilege = 'backup_restore' WHERE privilege = 'database_maintenance'");
// General::restoreSettings();
if (db_get_field("SELECT status FROM ?:addons WHERE addon = 'searchanise'") != 'D') {
db_query("UPDATE ?:addons SET status = 'D' WHERE addon = 'searchanise'");
fn_set_notification('W', __('warning'), General::getUnavailableLangVar('uc_searchanise_disabled'));
}
General::setActualLangValues();
General::updateAltLanguages('language_values', 'name');
General::updateAltLanguages('settings_descriptions', array('object_id', 'object_type'));
General::setEmptyProgressBar();
General::setEmptyProgressBar();
General::setEmptyProgressBar();
General::setEmptyProgressBar();
return true;
}
