function qtranxf_slug_update_translations($name, &$qfields, $default_lang)
{
global $wpdb;
//$name = $qfields[$default_lang];
unset($qfields['qtranslate-original-value']);
unset($qfields[$default_lang]);
//use $post->post_name instead since it may have been adjusted by WP
if (qtranxf_slug_translate_name($default_lang, $name)) {
qtranxf_slug_del_translation($default_lang, $name);
}
foreach ($qfields as $lang => $slug) {
$slug = sanitize_title($slug);
//qtranxf_dbg_log('qtranxf_slug_update_translations: origin $slug: ', $slug);
$slug = qtranxf_slug_unique($slug, $lang, $name);
//qtranxf_dbg_log('qtranxf_slug_update_translations: unique $slug: ',$slug);
$sql = null;
if (qtranxf_slug_translate_name($lang, $name)) {
if ($name != $slug) {
$sql = 'UPDATE ' . $wpdb->prefix . 'i18n_slugs SET slug = %s WHERE lang = %s AND name = %s';
} else {
$sql = 'DELETE FROM ' . $wpdb->prefix . 'i18n_slugs WHERE slug = %s AND lang = %s AND name = %s';
}
} else {
if ($name != $slug) {
$sql = 'INSERT INTO ' . $wpdb->prefix . 'i18n_slugs (slug, lang, name) VALUES (%s, %s, %s)';
}
}
if ($sql) {
$query = $wpdb->prepare($sql, $slug, $lang, $name);
$wpdb->query($query);
}
}
}
/**
* @param (string) $name - urldecoded post name or other single slug (not a path with '/').
*/
function qtranxf_slug_update_translations($name, &$qfields, $default_lang)
{
global $q_config, $wpdb;
if (empty($name)) {
return;
}
//qtranxf_dbg_log('qtranxf_slug_update_translations: $name="'.$name.'", $qfields: ', $qfields);
if (isset($qfields['qtranslate-original-value'])) {
if ($qfields['qtranslate-original-value'] != $name) {
qtranxf_slug_del_translations(qtranxf_slug_encode($qfields['qtranslate-original-value']));
}
unset($qfields['qtranslate-original-value']);
}
unset($qfields[$default_lang]);
//use $post->post_name instead since it may have been adjusted by WP
$name = qtranxf_slug_encode($name);
//qtranxf_dbg_log('qtranxf_slug_update_translations: encoded $name: ', $name);
if (qtranxf_slug_translate_name($name, $default_lang)) {
qtranxf_slug_del_translation($default_lang, $name);
}
//$translations = qtranxf_slug_get_translations($name);
foreach ($qfields as $lang => $slug) {
$translation = qtranxf_slug_translate_name($name, $lang);
$slug = qtranxf_slug_encode($slug);
//qtranxf_dbg_log('qtranxf_slug_update_translations: origin $slug: ', $slug);
if ($name == $slug) {
if ($translation) {
qtranxf_slug_del_translation($lang, $name);
}
continue;
}
$slug = qtranxf_slug_unique($slug, $lang, $name);
//qtranxf_dbg_log('qtranxf_slug_update_translations: unique $slug: ',$slug);
if ($translation) {
$sql = 'UPDATE ' . $wpdb->prefix . 'i18n_slugs SET slug = %s WHERE lang = %s AND name = %s';
} else {
$sql = 'INSERT INTO ' . $wpdb->prefix . 'i18n_slugs (slug, lang, name) VALUES (%s, %s, %s)';
}
$query = $wpdb->prepare($sql, $slug, $lang, $name);
$wpdb->query($query);
if (!isset($q_config['slugs-cache']['names'][$name])) {
$q_config['slugs-cache']['names'][$name] = array();
}
$q_config['slugs-cache']['names'][$name][$lang] = $slug;
}
//cleanup in case a language was disabled
$slugs = qtranxf_slug_get_translations($name);
foreach ($slugs as $lang => $slug) {
if (qtranxf_isEnabled($lang)) {
continue;
}
qtranxf_slug_del_translation($lang, $name);
}
}
function qtranxf_migrate_import_qtranslate_slug()
{
global $q_config, $wpdb;
//qtranxf_dbg_log('qtranxf_migrate_import_qtranslate_slug: REQUEST_TIME_FLOAT: ', $_SERVER['REQUEST_TIME_FLOAT']);
$nm = '<a href="https://wordpress.org/plugins/qtranslate-slug/" target="_blank"><span style="color:blue"><strong>QTranslate Slug</strong></span></a>';
$wpdb->show_errors();
@set_time_limit(0);
$sql = 'SELECT post_name, meta_key, meta_value FROM ' . $wpdb->postmeta . ' as m INNER JOIN ' . $wpdb->posts . ' as p ON p.ID = m.post_id WHERE m.meta_key LIKE "_qts_slug___" AND m.meta_value IS NOT NULL';
//$sql .= ' AND NOT EXISTS (SELECT * FROM '.$wpdb->prefix.'posts_i18n WHERE ID = post_id AND lang = MID(meta_key,11))';
$sql .= ' AND NOT EXISTS (SELECT * FROM ' . $wpdb->prefix . 'i18n_slugs WHERE name = p.post_name AND lang = MID(m.meta_key,11))';
$result = $wpdb->get_results($sql);
//qtranxf_dbg_log('qtranxf_migrate_import_qtranslate_slug: $result: ', $result);
//qtranxf_dbg_log('qtranxf_migrate_import_qtranslate_slug: count($result): ', count($result));
if (is_array($result)) {
$default_language = $q_config['default_language'];
//$sql = 'INSERT INTO '.$wpdb->prefix.'posts_i18n (ID, lang, slug) VALUES (%s, %s, %s)';
$sql = 'INSERT INTO ' . $wpdb->prefix . 'i18n_slugs (slug, lang, name) VALUES (%s, %s, %s)';
foreach ($result as $row) {
$slug = $row->meta_value;
$lang = substr($row->meta_key, -2);
$name = $row->post_name;
if ($lang == $default_language) {
if ($slug != $name) {
//qtranxf_dbg_log('qtranxf_migrate_import_qtranslate_slug: $slug('.$slug.') != $name('.$name.')');
//todo
}
} else {
$slug = qtranxf_slug_unique($row->meta_value, $lang, $name);
if ($slug != $row->meta_value) {
//todo report
}
//qtranxf_dbg_log('qtranxf_migrate_import_qtranslate_slug: $lang='.$lang.'; row: ', $row);
//$query = $wpdb->prepare($sql, $row->post_id, $lang, $row->meta_value);
$query = $wpdb->prepare($sql, $slug, $lang, $row->post_name);
$wpdb->query($query);
}
}
qtranxf_add_message(sprintf(__('Applicable options and slug data from plugin %s have been imported.', 'qtranslate'), $nm) . ' ' . sprintf(__('It might be a good idea to review %smigration instructions%s, if you have not yet done so.', 'qtranslate'), '<a href="https://qtranslatexteam.wordpress.com/migration/" target="_blank">', '</a>'));
} else {
qtranxf_error_log(sprintf(__('Failed to import data from plugin %s.', 'qtranslate'), $nm) . ' ' . sprintf(__('It might be a good idea to review %smigration instructions%s, if you have not yet done so.', 'qtranslate'), '<a href="https://qtranslatexteam.wordpress.com/migration/" target="_blank">', '</a>'));
}
}
function qtranxf_migrate_import_qtranslate_slug($default_language)
{
//$q_config is not yet available
global $wpdb;
//qtranxf_dbg_log('qtranxf_migrate_import_qtranslate_slug: ');
$nm = '<a href="https://wordpress.org/plugins/qtranslate-slug/" target="_blank"><span style="color:blue"><strong>QTranslate Slug</strong></span></a>';
$wpdb->show_errors();
@set_time_limit(0);
$qts_options = get_option('qts_options');
if (!empty($qts_options)) {
//qtranxf_dbg_log('qtranxf_migrate_import_qtranslate_slug: $qts_options: ', $qts_options);
if (is_array($qts_options)) {
foreach ($qts_options as $k => $v) {
}
} else {
qtranxf_error_log(sprintf(__('Failed to import options from plugin %s.', 'qtranslate'), $nm));
}
}
$sql = 'SELECT ID, post_name, post_type, post_parent, meta_key, meta_value FROM ' . $wpdb->postmeta . ' as m INNER JOIN ' . $wpdb->posts . ' as p ON p.ID = m.post_id WHERE p.post_status = "publish" AND p.post_name != "" AND m.meta_key LIKE "_qts_slug___" AND m.meta_value IS NOT NULL';
$sql .= ' AND NOT EXISTS (SELECT * FROM ' . $wpdb->prefix . 'i18n_slugs WHERE name = p.post_name AND lang = MID(m.meta_key,11))';
$result = $wpdb->get_results($sql);
//qtranxf_dbg_log('qtranxf_migrate_import_qtranslate_slug: $result: ', $result);
//qtranxf_dbg_log('qtranxf_migrate_import_qtranslate_slug: count($result): ', count($result));
if (!is_array($result)) {
qtranxf_error_log(sprintf(__('Failed to import data from plugin %s.', 'qtranslate'), $nm) . ' ' . sprintf(__('It might be a good idea to review %smigration instructions%s, if you have not yet done so.', 'qtranslate'), '<a href="https://qtranslatexteam.wordpress.com/migration/" target="_blank">', '</a>'));
return;
}
foreach ($result as $row) {
$name = $row->post_name;
if (empty($name)) {
continue;
}
$slug = $row->meta_value;
if (empty($slug)) {
continue;
}
$lang = substr($row->meta_key, -2);
if ($lang != $default_language) {
continue;
}
if ($slug == $name) {
continue;
}
//qtranxf_dbg_log('qtranxf_migrate_import_qtranslate_slug: default language $slug('.$slug.') != $name('.$name.')');
$slug = wp_unique_post_slug($slug, $row->ID, 'publish', $row->post_type, $row->post_parent);
$wpdb->query($wpdb->prepare('UPDATE ' . $wpdb->posts . ' SET post_name = %s WHERE ID = %d', $slug, $row->ID));
$row->post_name = $row->meta_value = $slug;
}
$cnt = 0;
$cnt_renamed = 0;
$lst = '';
$sql = 'INSERT INTO ' . $wpdb->prefix . 'i18n_slugs (slug, lang, name) VALUES (%s, %s, %s)';
foreach ($result as $row) {
$lang = substr($row->meta_key, -2);
if ($lang == $default_language) {
continue;
}
$name = $row->post_name;
if (empty($name)) {
continue;
}
$slug = $row->meta_value;
if (empty($slug)) {
continue;
}
if (!qtranxf_isEnabled($lang)) {
continue;
}
$slug = qtranxf_slug_unique($row->meta_value, $lang, $name);
if ($slug != $row->meta_value) {
$lst .= $row->ID . '\\t' . $name . '\\t' . $lang . '\\t' . $row->meta_value . ' => ' . $slug . PHP_EOL;
++$cnt_renamed;
}
//qtranxf_dbg_log('qtranxf_migrate_import_qtranslate_slug: $lang='.$lang.'; row: ', $row);
$query = $wpdb->prepare($sql, $slug, $lang, $row->post_name);
$wpdb->query($query);
++$cnt;
}
$msg = '';
if ($cnt != 0) {
$msg .= sprintf(__('Applicable options and slug data from plugin %s have been imported.', 'qtranslate'), $nm);
}
//if(!empty($lst))){
$upload_dir = wp_upload_dir();
//qtranxf_dbg_log('qtranxf_migrate_import_qtranslate_slug: upload_dir: ',$upload_dir);
$fnm = '/qts-qtx-report-of-renamed.log';
$fn = $upload_dir['basedir'] . $fnm;
//[01-Nov-2015 02:21:57 UTC]
error_log(date('[d-M-Y H:i:s T]') . ': Slugs renamed during import:' . PHP_EOL . "Post_ID\tpost_name\tLANG\tQtranslate Slug => qTranslate-X Slug" . PHP_EOL . $lst . PHP_EOL, 3, $fn);
$url = $upload_dir['baseurl'] . $fnm;
$msg .= ' ' . sprintf(__('A number of post slugs have had to be renamed in order to provide uniqueness. The report of renamed slugs is saved in the file "%s".', 'qtranslate'), '<a href="' . $url . ' target="_blank">' . $url . '</a>');
//}
if (!empty($msg)) {
$msg .= ' ' . sprintf(__('It might be a good idea to review %smigration instructions%s, if you have not yet done so.', 'qtranslate'), '<a href="https://qtranslatexteam.wordpress.com/migration/" target="_blank">', '</a>');
qtranxf_add_message($msg);
}
}
