47 lines
1.5 KiB
PHP
Executable File
47 lines
1.5 KiB
PHP
Executable File
<?php
|
|
namespace HermannTelser\Gutachten\Settings;
|
|
|
|
use HermannTelser\Gutachten\DB\DbFunction;
|
|
use HermannTelser\Gutachten\DB\Select;
|
|
use TYPO3\CMS\Core\Utility\GeneralUtility;
|
|
|
|
set_time_limit(0);
|
|
|
|
class Sonderzeichen
|
|
{
|
|
/***************************************************
|
|
* print sql querries
|
|
***************************************************/
|
|
public static function run()
|
|
{
|
|
// DbFunction::$debug = 1;
|
|
|
|
$from = array("Ÿ", "Š", "š", "§");
|
|
$to = array("ü", "ä", "ö", "ß");
|
|
|
|
$_arr = DbFunction::select('tx_gutachten_allgemein', ['id', 'typ']);
|
|
foreach ($_arr as $key => $value) {
|
|
$value_array['typ'] = str_replace($from, $to, $value['typ']);
|
|
|
|
DbFunction::secureUpdate('tx_gutachten_allgemein', $value_array, ['id' => $value['id']]);
|
|
}
|
|
|
|
$_arr = DbFunction::select('tx_gutachten_raume_all', ['id', 'raum']);
|
|
foreach ($_arr as $key => $value) {
|
|
$value_array['raum'] = str_replace($from, $to, $value['raum']);
|
|
|
|
DbFunction::secureUpdate('tx_gutachten_raume_all', $value_array, ['id' => $value['id']]);
|
|
}
|
|
|
|
$_arr = DbFunction::select('tx_gutachten_raume_generell', ['id', 'raum']);
|
|
foreach ($_arr as $key => $value) {
|
|
$value_array['raum'] = str_replace($from, $to, $value['raum']);
|
|
|
|
DbFunction::secureUpdate('tx_gutachten_raume_generell', $value_array, ['id' => $value['id']]);
|
|
}
|
|
|
|
echo 1;
|
|
exit;
|
|
}
|
|
}
|