';
// State
$Filter['State'] = GetParameter('state', 0, true, true);
$Output .= ' | ';
// Translation group
if($GroupId == 0)
{
$Filter['Group'] = GetParameter('group', 0, true, true);
if($Filter['Group'] != 0)
{
if(isset($TranslationTree[$Filter['Group']]) == false) ErrorMessage('Překladová skupina dle zadaného Id neexistuje.');
$Table = $TranslationTree[$Filter['Group']]['TablePrefix'];
}
} else
{
$Filter['Group'] = $GroupId;
$Table = $TranslationTree[$Filter['Group']]['TablePrefix'];
}
$Output .= ' | ';
// Version
$Filter['Version'] = GetParameter('version', 0, true, true);
if($Filter['Version'] != 0)
{
$DbResult = $System->Database->query('SELECT `Id`, `BuildNumber`,`Version` FROM `ClientVersion` WHERE (`Imported` = 1) AND (`Id` ='.$Filter['Version'].')');
if($DbResult->num_rows > 0)
{
$DbRow = $DbResult->fetch_assoc();
$Filter['BuildNumber'] = $DbRow['BuildNumber'];
} else ErrorMessage('Zadaná verze klienta nenalezena');
}
$Output .= ' | ';
if($Filter['Version'] != 0) $VersionFilter = ' AND (`VersionStart` <= '.$Filter['BuildNumber'].') AND (`VersionEnd` >= '.$Filter['BuildNumber'].')';
else $VersionFilter = '';
//else $Filter['SQL'] .= ' AND '; DISTINCT(Entry)
// Language
$Filter['Language'] = GetParameter('lang', 0, true, true);
$Output .= ' | ';
if($Filter['Language'] != 0) $LanguageFilter = ' AND (`Language` = '.$Filter['Language'].')';
else $LanguageFilter = '';
// User
$Filter['User'] = GetParameter('user', 0, true, true);
$Output .= ' | ';
if($Filter['User'] != 0) $UserFilter = ' AND (`User` = '.$Filter['User'].')';
else $UserFilter = '';
// Words
$Filter['Text'] = GetParameter('text', '', false, true);
$Output .= ' | ';
if($Filter['Text'] != '')
{
$Items = array('(`ID` LIKE "%'.$Filter['Text'].'%")', '(`Entry` LIKE "%'.$Filter['Text'].'%")');
if($Filter['Group'] != 0)
foreach($TranslationTree[$Filter['Group']]['Items'] as $GroupItem)
if($GroupItem['Visible'] == 1)
$Items[] = '(`'.$GroupItem['Column'].'` LIKE "%'.$Filter['Text'].'%")';
$Filter['SQL'] .= ' AND ('.implode(' OR ', $Items).')';
}
// Entry
$Filter['Entry'] = GetParameter('entry', '', false, true);
$Output .= ' | ';
if($Filter['Entry'] != '')
{
$Filter['SQL'] .= ' AND (`Entry` = "'.$Filter['Entry'].'")';
}
if($Filter['Group'] != 0)
{
if($Filter['State'] == 0) $Filter['SQL'] .= $UserFilter.$VersionFilter.'';
else if($Filter['State'] == 1) $Filter['SQL'] .= $VersionFilter.' AND (`Language` = 0) AND NOT EXISTS(SELECT 1 FROM `'.$Table.'` AS `Sub` WHERE (`Sub`.`Language` <> 0)'.$LanguageFilter.$UserFilter.' AND (`Sub`.`Entry` = `T`.`Entry`) AND (`Sub`.`Complete` = 1) AND (`Sub`.`VersionStart` = `T`.`VersionStart`) AND (`Sub`.`VersionEnd` = `T`.`VersionEnd`))';
else if($Filter['State'] == 2) $Filter['SQL'] .= $UserFilter.$LanguageFilter.$VersionFilter.' AND (`Complete` = 1)';
else if($Filter['State'] == 3) $Filter['SQL'] .= $UserFilter.$LanguageFilter.$VersionFilter.' AND (`Language` != 0) AND (`Complete` = 0)';
else if($Filter['State'] == 4) $Filter['SQL'] .= $VersionFilter.' AND (`Language` = 0)';
}
/*
// Ownership
if(array_key_exists('owner', $_GET) and is_numeric($_GET['owner'])) $Filter['Owner'] = $_GET['owner'];
else $Filter['Owner'] = 0;
echo(' | ');
if(($Filter['Owner'] == 2) AND ($Filter['User'] != 0)) $Filter['SQL'] .= ' AND (`User` = '.$Filter['User'].')';
*/
$Output .= ' | ';
$Output .= '