| Skupina | Výsledků |
|---|
');
foreach($TranslationTree as $Group) {
$Table = $Group['TablePrefix'];
$sql = 'SELECT count(*) FROM `'.$Table.'` WHERE `ID` LIKE "%'.$Search.'%"
OR `entry` LIKE "%'.$Search.'%"
OR `User` LIKE "%'.$Search.'%"
OR `Complete` LIKE "%'.$Search.'%"';
foreach($Group['Items'] as $Item) {
if($Item['Column'] != '') $sql .= ' OR `'.$Item['Column'].'` LIKE "%'.$Search.'%"';
}
$Line = mysql_fetch_row($Database->SQLCommand($sql));
echo('| '.$Group['Name'].' | '.$Line[0].' |
');
}
$Line = mysql_fetch_row($Database->SQLCommand('SELECT count(*) FROM `user` WHERE `user` LIKE "%'.$Search.'%"'));
echo('| Uživatelé | '.$Line[0].' |
');
$Line = mysql_fetch_row($Database->SQLCommand('SELECT count(*) FROM `team` WHERE `name` LIKE "%'.$Search.'%" OR `description` LIKE "%'.$Search.'%"'));
echo('| Týmy | '.$Line[0].' |
');
$Line = mysql_fetch_row($Database->SQLCommand('SELECT count(*) FROM `verseclient` WHERE `text` LIKE "%'.$Search.'%"'));
echo('| Čeština pro klienta | '.$Line[0].' |
');
echo('| Vyhledávací databáze AoWoW |
');
$Line = mysql_fetch_row($Database->SQLCommand('SELECT count(*) FROM `dictionary` WHERE (`Text` LIKE "%'.$Search.'%" OR `Description` LIKE "%'.$Search.'%") AND Language = 1'));
echo('| Slovníček | '.$Line[0].' |
');
echo('');
}
if(($Action == 'dbkit') and Licence(LICENCE_ADMIN))
{
echo ('
');
echo ('Opravit data v sloupci Take
');
echo ('Opravit data v sloupci ShortCut
');
if (array_key_exists('find',$_POST)) {
echo ('Začínám nahrazovat:
');
$find = $_POST['find'];
$replace = $_POST['replace'];
foreach($TranslationTree as $Group) {
$Table = $Group['TablePrefix'];
echo ($Table.' ');
$sql = 'SELECT * FROM '.$Table.' WHERE (Language <> 0) AND (';
foreach($Group['Items'] as $Item) {
if($Item['Column'] != '') $sql .= '`'.$Item['Column'].'` LIKE "%'.$find.'%" OR ';
}
$sql = substr($sql,0,strlen($sql)-4);
$sql .= ')';
$ID = $Database->SQLCommand($sql);
while ($Line = mysql_fetch_assoc($ID)) {
$sql = 'UPDATE '.$Table.' SET ';
foreach($Group['Items'] as $Item) {
$Column_text = addslashes(str_replace($find,$replace,$Line[$Item['Column']]));
$sql .= ' '.$Item['Column'].' = "'.$Column_text.'",';
}
$sql = substr($sql,0,strlen($sql)-1);
$sql .= ' WHERE ID = '.$Line['ID'];
$Database->SQLCommand($sql);
echo ('.');
}
echo (' Hotovo
');
if (mysql_num_rows($ID) > 0) {
WriteLog('Použita oprava DB ovlivněno '.mysql_num_rows($ID).' řádků z tabulky '.$Table.', "'.$find.'" nahrazeno za "'.$replace.'"', 4);
echo (' Použita oprava DB ovlivněno '.mysql_num_rows($ID).' řádků z tabulky '.$Table.', "'.$find.'" nahrazeno za "'.$replace.'"
');
}
}
}
//oprava dat v sloupci Take
if (array_key_exists('Take',$_GET)) {
echo ('Začínám opravovat Take:
');
foreach($TranslationTree as $Group) {
$Table = $Group['TablePrefix'];
echo ($Table.' ');
$sql = 'SELECT ID,entry as entry_tran, (SELECT ID FROM '.$Table.' WHERE Language = 0 AND entry = entry_tran LIMIT 1) as ID_orig FROM '.$Table.' WHERE (Language <> 0) AND (Take = 0)';
$ID = $Database->SQLCommand($sql);
while ($Line = mysql_fetch_assoc($ID)) {
$sql = 'UPDATE '.$Table.' SET Take = '.$Line['ID_orig'].' WHERE ID = '.$Line['ID'];
$Database->SQLCommand($sql);
echo ('.');
}
echo (' Hotovo
');
if (mysql_num_rows($ID) > 0) {
WriteLog('Použita oprava DB na sloupec Take '.mysql_num_rows($ID).' řádků z tabulky '.$Table, 4);
echo (' Použita oprava DB na sloupec Take '.mysql_num_rows($ID).' řádků z tabulky '.$Table.'
');
}
}
}
//oprava dat ShortCut
if (array_key_exists('ShortCut',$_GET)) {
echo ('Začínám opravovat Take:
');
$Tables = array ('global_strings','glue_strings');
foreach($Tables as $Table) {
echo ($Table.' ');
$sql = 'SELECT gs_orig.ID,
gs_tran.entry,
gs_tran.ShortCut as ShortCut_tran,
gs_orig.ShortCut as ShortCut_orig
FROM '.$Table.' as gs_tran
JOIN '.$Table.' as gs_orig ON gs_orig.entry = gs_tran.entry
WHERE gs_tran.Language <> 0 AND gs_tran.ShortCut <> gs_orig.ShortCut';
$ID = $Database->SQLCommand($sql);
while ($Line = mysql_fetch_assoc($ID)) {
$sql = 'UPDATE '.$Table.' SET ShortCut = '.$Line['ShortCut_orig'].' WHERE ID = '.$Line['ID'];
$Database->SQLCommand($sql);
echo ('.');
}
echo (' Hotovo
');
if (mysql_num_rows($ID) > 0) {
WriteLog('Použita oprava DB na sloupec ShortCut '.mysql_num_rows($ID).' řádků z tabulky '.$Table, 4);
echo (' Použita oprava DB na sloupec ShortCut '.mysql_num_rows($ID).' řádků z tabulky '.$Table.'
');
}
}
}
}
if(($Action == 'delete') and Licence(LICENCE_MODERATOR))
{
$TextID = $_GET['ID'];
$Database->SQLCommand('DELETE FROM '.$Table.' WHERE ID = '.$TextID.' AND Language <> 0');
echo('Překlad byl smazán!');
WriteLog('Překlad byl smazán! '.$TextID.'', 4);
}
if($Action == 'shoutbox')
{
if(array_key_exists('shoutbox', $_GET)) $shoutbox = $_GET['shoutbox'];
else $shoutbox = '';
if($shoutbox == '')
{
echo('');
} else
{
if(Licence(LICENCE_USER)) $user = $_SESSION['User'];
else die('Pro vkládaní musíte byt registrováni!');
$text = $_POST['text'];
$Database->SQLCommand("INSERT INTO `shoutbox` ( `user` , `text` , `date` , `IP` )
VALUES ( '$user', '$text', now(), '".$_SERVER['REMOTE_ADDR']."');");
echo('Zpráva vložena!
Budete přesměrováni...');
echo('
');
}
}
ShowFooter();
?>