SQLCommand('UPDATE user SET team = '.$_GET['gointeam'].' WHERE ID = '.$_SESSION['UserID']);
echo('Vstoupil jsi do týmu
');
WriteLog('Uživatel vstoupil do týmu '.$_GET['gointeam'], 3);
}
}
if(array_key_exists('name', $_POST))
{
$ID = $Database->SQLCommand('INSERT INTO `team` (`name` ,`description` ) VALUES ( \''.$_POST['name'].'\', \''.$_POST['description'].'\');');
echo('Překladatelský tým vytvořen
');
WriteLog('Překladatelský tým vytvořen '.$_POST['name'], 3);
} else
{
if(array_key_exists('create', $_GET))
{
echo('');
}
if(array_key_exists('team', $_GET))
{
//zobrazení týmu
include('img_level.php');
$Columns = '';
$Joins = '';
foreach($TranslationTree as $Group)
if($Group['TablePrefix'] != '')
{
$Columns .= 'COALESCE(T'.$Group['Id'].'.Count, 0) + ';
$Joins .= ' LEFT JOIN (SELECT User, COUNT(User) as Count FROM `'.$Group['TablePrefix'].'` WHERE (Complete = 1) AND (Language <> 0) GROUP BY User) as T'.$Group['Id'].' ON user.ID=T'.$Group['Id'].'.User';
}
$Line = mysql_fetch_assoc($Database->SQLCommand('SELECT *,(SELECT count(*) FROM user WHERE team = team.ID) as numberuser, (SELECT sum('.substr($Columns, 0, -3).') FROM user '.$Joins.' WHERE team = team.ID) as NumberTranslate FROM team WHERE ID='.$_GET['team']));
echo('Překladatelský tým '.$Line['name'].' '.
$Line['description'].'
');
$ID = $Database->SQLCommand('SELECT *,(SELECT count(*) FROM user WHERE team = team.ID) as numberuser FROM team '.$_SESSION['Where'].' ORDER BY '.$_SESSION['Order'].' '.$_SESSION['Desc'].' LIMIT '.($_SESSION['Page'] - 1) * $Config['Web']['ItemsPerPage'].','.$Config['Web']['ItemsPerPage']);
while($Line = mysql_fetch_assoc($ID))
{
echo('