/**
* Main function, returning the HTML content of the module
*
* @return string HTML
*/
function main()
{
$content = '';
$content .= '<br />Update the Static Info Tables with new language labels.';
$content .= '<br />';
if (t3lib_div::_GP('import')) {
$destEncoding = t3lib_div::_GP('dest_encoding');
$extPath = t3lib_extMgm::extPath('static_info_tables_it');
$fileContent = explode("\n", t3lib_div::getUrl($extPath . 'ext_tables_static_update.sql'));
foreach ($fileContent as $line) {
if ($line = trim($line) and preg_match('#^UPDATE#i', $line)) {
$query = $this->getUpdateEncoded($line, $destEncoding);
$res = $GLOBALS['TYPO3_DB']->admin_query($query);
}
}
$content .= '<br />';
$content .= '<p>Encoding: ' . htmlspecialchars($destEncoding) . '</p>';
$content .= '<p>Done.</p>';
} elseif (t3lib_extMgm::isLoaded('static_info_tables_it')) {
$content .= '</form>';
$content .= '<form action="' . htmlspecialchars(t3lib_div::linkThisScript()) . '" method="post">';
$content .= '<br />Destination character encoding:';
$content .= '<br />' . tx_staticinfotables_encoding::getEncodingSelect('dest_encoding', '', 'utf-8');
$content .= '<br />(The character encoding must match the encoding of the existing tables data. By default this is UTF-8.)';
$content .= '<br /><br />';
$content .= '<input type="submit" name="import" value="Import" />';
$content .= '</form>';
} else {
$content .= '<br /><strong>The extension needs to be installed first!</strong>';
}
return $content;
}
/**
* Main function, returning the HTML content of the module
*
* @return string HTML
*/
function main() {
require_once(t3lib_extMgm::extPath(STATIC_INFO_TABLES_EXTkey).'class.tx_staticinfotables_encoding.php');
$tableArray = array ('static_countries', 'static_country_zones', 'static_languages', 'static_currencies');
$content = '';
$content.= '<br />Convert character encoding of the static info tables.';
$content.= '<br />The default encoding is UTF-8.';
$destEncoding = htmlspecialchars(t3lib_div::_GP('dest_encoding'));
if(t3lib_div::_GP('convert') AND ($destEncoding != '')) {
foreach ($tableArray as $table) {
$content .= '<p>'.htmlspecialchars($table.' > '.$destEncoding).'</p>';
tx_staticinfotables_encoding::convertEncodingTable($table, 'utf-8', $destEncoding);
}
$content .= '<p>You must enter the charset \''.$destEncoding.'\' now manually in the EM for static_info_tables!</p>';
$content .= '<p>Done</p>';
} else {
$content .= '<form name="static_info_tables_form" action="'.htmlspecialchars(t3lib_div::linkThisScript()).'" method="post">';
$linkScript = t3lib_div::slashJS(t3lib_div::linkThisScript());
$content .= '<br /><br />';
$content .= 'This conversion works only once. When you converted the tables and you want to do it again to another encoding you have to reinstall the tables with the Extension Manager or select \'UPDATE!\'.';
$content .= '<br /><br />';
$content .= 'Destination character encoding:';
$content .= '<br />'.tx_staticinfotables_encoding::getEncodingSelect('dest_encoding', '', '', $TYPO3_CONF_VARS['EXTCONF'][STATIC_INFO_TABLES_EXTkey]['charset']);
$content .= '<br /><br />';
$content .= '<input type="submit" name="convert" value="Convert" onclick="this.form.action=\''.$linkScript.'\';submit();" />';
$content .= '</form>';
}
return $content;
}
/**
* Erzeugt die Selectbox für das encoding
* @return string
*/
private function getDestEncodingSelect()
{
require_once t3lib_extMgm::extPath('static_info_tables', 'class.tx_staticinfotables_encoding.php');
$content = '';
$content .= '<label>Destination character encoding:</label>';
$content .= tx_staticinfotables_encoding::getEncodingSelect('dest_encoding', '', 'utf-8');
$content .= '<p>(The character encoding must match the encoding of the existing tables data. By default this is UTF-8.)</p>';
if ($destEncoding = $this->getDestEncoding()) {
$content .= '<p>Current encoding: ' . htmlspecialchars($destEncoding) . '</p>';
}
return $content;
}