function icl_plugin_upgrade()
{
global $wpdb;
$iclsettings = get_option('icl_sitepress_settings');
require_once ICL_PLUGIN_PATH . '/inc/cache.php';
icl_cache_clear('locale_cache_class');
icl_cache_clear('flags_cache_class');
icl_cache_clear('language_name_cache_class');
if (get_option('icl_sitepress_version') && version_compare(get_option('icl_sitepress_version'), '1.7.2', '<')) {
$wpdb->update($wpdb->prefix . 'icl_flags', array('flag' => 'ku.png'), array('lang_code' => 'ku'));
$wpdb->update($wpdb->prefix . 'icl_languages_translations', array('name' => 'Magyar'), array('language_code' => 'hu', 'display_language_code' => 'hu'));
$wpdb->update($wpdb->prefix . 'icl_languages_translations', array('name' => 'Hrvatski'), array('language_code' => 'hr', 'display_language_code' => 'hr'));
$wpdb->update($wpdb->prefix . 'icl_languages_translations', array('name' => 'فارسی'), array('language_code' => 'fa', 'display_language_code' => 'fa'));
}
if (get_option('icl_sitepress_version') && version_compare(get_option('icl_sitepress_version'), '1.7.3', '<')) {
$wpdb->update($wpdb->prefix . 'icl_languages_translations', array('name' => 'پارسی'), array('language_code' => 'fa', 'display_language_code' => 'fa'));
}
if (get_option('icl_sitepress_version') && version_compare(get_option('icl_sitepress_version'), '1.7.7', '<')) {
if (!isset($iclsettings['promote_wpml'])) {
$iclsettings['promote_wpml'] = 0;
update_option('icl_sitepress_settings', $iclsettings);
}
if (!isset($iclsettings['auto_adjust_ids'])) {
$iclsettings['auto_adjust_ids'] = 0;
update_option('icl_sitepress_settings', $iclsettings);
}
$wpdb->query("UPDATE {$wpdb->prefix}icl_translations SET element_type='tax_post_tag' WHERE element_type='tag'");
// @since 3.1.5 - mysql_* function deprecated in php 5.5+
$wpdb->query("UPDATE {$wpdb->prefix}icl_translations SET element_type='tax_category' WHERE element_type='category'");
}
if (get_option('icl_sitepress_version') && version_compare(get_option('icl_sitepress_version'), '1.7.8', '<')) {
$res = $wpdb->get_results("SELECT ID, post_type FROM {$wpdb->posts}");
$post_types = array();
foreach ($res as $row) {
$post_types[$row->post_type][] = $row->ID;
}
foreach ($post_types as $type => $ids) {
if (!empty($ids)) {
$q = "UPDATE {$wpdb->prefix}icl_translations SET element_type=%s WHERE element_type='post' AND element_id IN(" . join(',', $ids) . ")";
$q_prepared = $wpdb->prepare($q, 'post_' . $type);
$wpdb->query($q_prepared);
// @since 3.1.5 - mysql_* function deprecated in php 5.5+
}
}
// fix categories & tags in icl_translations
$res = $wpdb->get_results("SELECT term_taxonomy_id, taxonomy FROM {$wpdb->term_taxonomy}");
foreach ($res as $row) {
$icltr = $wpdb->get_row($wpdb->prepare("SELECT translation_id, element_type FROM {$wpdb->prefix}icl_translations WHERE element_id=%d AND element_type LIKE %s", array($row->term_taxonomy_id, wpml_like_escape('tax_') . '%')));
if ('tax_' . $row->taxonomy != $icltr->element_type) {
$wpdb->update($wpdb->prefix . 'icl_translations', array('element_type' => 'tax_' . $row->taxonomy), array('translation_id' => $icltr->translation_id));
}
}
}
if (get_option('icl_sitepress_version') && version_compare(get_option('icl_sitepress_version'), '2.0.0', '<')) {
include_once ICL_PLUGIN_PATH . '/inc/upgrade-functions/upgrade-2.0.0.php';
if (empty($iclsettings['migrated_2_0_0'])) {
define('ICL_MULTI_STEP_UPGRADE', true);
return;
// GET OUT AND DO NOT SET THE NEW VERSION
}
}
if (get_option('icl_sitepress_version') && version_compare(get_option('icl_sitepress_version'), '2.0.4', '<')) {
$sql = "ALTER TABLE {$wpdb->prefix}icl_translation_status ADD COLUMN `_prevstate` longtext";
$wpdb->query($sql);
}
$versions = array('2.0.5', '2.2.2', '2.3.0', '2.3.1', '2.3.3', '2.4.0', '2.5.0', '2.5.2', '2.6.0', '2.7', '2.9', '2.9.3', '3.1', '3.1.5', '3.1.8', '3.1.9.5', '3.2', '3.2.3', '3.3', '3.3.7');
foreach ($versions as $version) {
icl_upgrade_version($version);
}
//Forcing upgrade logic when ICL_SITEPRESS_DEV_VERSION is defined
//This allow to run the logic between different alpha/beta/RC versions
//since we are now storing only the formal version in the options
if (defined('ICL_SITEPRESS_DEV_VERSION')) {
icl_upgrade_version(ICL_SITEPRESS_DEV_VERSION, true);
}
if (version_compare(get_option('icl_sitepress_version'), ICL_SITEPRESS_VERSION, '<')) {
update_option('icl_sitepress_version', ICL_SITEPRESS_VERSION);
}
}
function icl_plugin_upgrade()
{
global $wpdb, $sitepress_settings, $sitepress;
$iclsettings = get_option('icl_sitepress_settings');
// upgrade actions
// 1. reset ajx_health_flag
$iclsettings['ajx_health_checked'] = 0;
update_option('icl_sitepress_settings', $iclsettings);
// clear any caches
require_once ICL_PLUGIN_PATH . '/inc/cache.php';
icl_cache_clear('locale_cache_class');
icl_cache_clear('flags_cache_class');
icl_cache_clear('language_name_cache_class');
if (get_option('icl_sitepress_version') && version_compare(get_option('icl_sitepress_version'), '1.7.2', '<')) {
$wpdb->update($wpdb->prefix . 'icl_flags', array('flag' => 'ku.png'), array('lang_code' => 'ku'));
$wpdb->update($wpdb->prefix . 'icl_languages_translations', array('name' => 'Magyar'), array('language_code' => 'hu', 'display_language_code' => 'hu'));
$wpdb->update($wpdb->prefix . 'icl_languages_translations', array('name' => 'Hrvatski'), array('language_code' => 'hr', 'display_language_code' => 'hr'));
$wpdb->update($wpdb->prefix . 'icl_languages_translations', array('name' => 'فارسی'), array('language_code' => 'fa', 'display_language_code' => 'fa'));
}
if (get_option('icl_sitepress_version') && version_compare(get_option('icl_sitepress_version'), '1.7.3', '<')) {
$wpdb->update($wpdb->prefix . 'icl_languages_translations', array('name' => 'پارسی'), array('language_code' => 'fa', 'display_language_code' => 'fa'));
}
if (get_option('icl_sitepress_version') && version_compare(get_option('icl_sitepress_version'), '1.7.7', '<')) {
if (!isset($iclsettings['promote_wpml'])) {
$iclsettings['promote_wpml'] = 0;
update_option('icl_sitepress_settings', $iclsettings);
}
if (!isset($iclsettings['auto_adjust_ids'])) {
$iclsettings['auto_adjust_ids'] = 0;
update_option('icl_sitepress_settings', $iclsettings);
}
mysql_query("UPDATE {$wpdb->prefix}icl_translations SET element_type='tax_post_tag' WHERE element_type='tag'");
mysql_query("UPDATE {$wpdb->prefix}icl_translations SET element_type='tax_category' WHERE element_type='category'");
}
if (get_option('icl_sitepress_version') && version_compare(get_option('icl_sitepress_version'), '1.7.8', '<')) {
$res = $wpdb->get_results("SELECT ID, post_type FROM {$wpdb->posts}");
foreach ($res as $row) {
$post_types[$row->post_type][] = $row->ID;
}
foreach ($post_types as $type => $ids) {
if (!empty($ids)) {
mysql_query("UPDATE {$wpdb->prefix}icl_translations SET element_type='post_{$type}' WHERE element_type='post' AND element_id IN(" . join(',', $ids) . ")");
}
}
// fix categories & tags in icl_translations
$res = mysql_query("SELECT term_taxonomy_id, taxonomy FROM {$wpdb->term_taxonomy}");
while ($row = mysql_fetch_object($res)) {
$icltr = $wpdb->get_row("SELECT translation_id, element_type FROM {$wpdb->prefix}icl_translations WHERE element_id='{$row->term_taxonomy_id}' AND element_type LIKE 'tax\\_%'");
if ('tax_' . $row->taxonomy != $icltr->element_type) {
$wpdb->update($wpdb->prefix . 'icl_translations', array('element_type' => 'tax_' . $row->taxonomy), array('translation_id' => $icltr->translation_id));
}
}
}
if (get_option('icl_sitepress_version') && version_compare(get_option('icl_sitepress_version'), '2.0.0', '<')) {
include_once ICL_PLUGIN_PATH . '/inc/upgrade-functions/upgrade-2.0.0.php';
if (empty($iclsettings['migrated_2_0_0'])) {
define('ICL_MULTI_STEP_UPGRADE', true);
return;
// GET OUT AND DO NOT SET THE NEW VERSION
}
}
if (get_option('icl_sitepress_version') && version_compare(get_option('icl_sitepress_version'), '2.0.4', '<')) {
$sql = "ALTER TABLE {$wpdb->prefix}icl_translation_status ADD COLUMN `_prevstate` longtext";
mysql_query($sql);
}
icl_upgrade_version('2.0.5');
icl_upgrade_version('2.2.2');
icl_upgrade_version('2.3.0');
icl_upgrade_version('2.3.1');
icl_upgrade_version('2.3.3');
icl_upgrade_version('2.4.0');
if (version_compare(get_option('icl_sitepress_version'), ICL_SITEPRESS_VERSION, '<')) {
update_option('icl_sitepress_version', ICL_SITEPRESS_VERSION);
}
}
