function _upgrade_table($table, $table_key) { global $l10n_wiz_upgrade; $keys = safe_rows('*', $table, "1=1"); foreach ($keys as $key) { $index = $key[$table_key]; # Pull all gbp_l10n rows that are associated with this key... $ttable = PFX . $table; $rows = safe_rows('id,entry_value,language', 'gbp_l10n', "`entry_column` = 'title' AND `entry_id`='{$index}' AND `table` = '{$ttable}'"); if (empty($rows)) { continue; } # Build up values for each field... $set = array(); foreach ($rows as $row) { $lang = MLPLanguageHandler::find_lang($row['language'], $l10n_wiz_upgrade); $field = _l10n_make_field_name('title', $lang); $f_value = doSlash($row['entry_value']); $set[] = "`{$field}`='{$f_value}'"; if ($lang === $l10n_wiz_upgrade[0]) { $set[] = "`title`='{$f_value}'"; } } # Write the row back... $set = join(', ', $set); safe_update($table, $set, "`{$table_key}`='{$index}'"); # Delete the gbp_l10n entries used... safe_delete('gbp_l10n', "`entry_column` = 'title' AND `entry_id`='{$index}' AND `table` = '{$ttable}'"); } }