SQLCommand('SELECT Id FROM `group` WHERE `Id`='.$GroupId); if(mysql_num_rows($DbResult) == 0) { echo('Neexistující id překladové skupiny.'); ShowFooter(); die(); } $Table = $TranslationTree[$GroupId]['TablePrefix']; if(array_key_exists('action', $_GET)) $Action = $_GET['action']; else $Action = ''; $ID = mysql_fetch_row($Database->SQLCommand('SELECT max(VersionEnd) FROM '.$TranslationTree[$GroupId]['TablePrefix'])); $BuildNumber_max = $ID[0]; if(array_key_exists('order', $_GET)) { $order = $_GET['order']; $desc = $_GET['desc']; $_SESSION['order'] = $_GET['order']; $_SESSION['desc'] = $_GET['desc']; } else { if (isset($_SESSION['order'])) { $order = $_SESSION['order']; $desc = $_SESSION['desc']; } else { $order = ''; $desc = 'desc'; } } if(array_key_exists('limitx', $_GET)) { $_SESSION['limitx'] = $_GET['limitx']; $_SESSION['limity'] = $_GET['limity']; } else { if(isset($_SESSION['limitx']) == false) { $_SESSION['limitx'] = '0'; $_SESSION['limity'] = $TranslationItemPerPage; } } if(($Action != 'userall') and ($Action != 'grouplist')) echo('Skupina: '.$TranslationTree[$GroupId]['Name'].'
'); function WritePages($Address, $Where) { global $Database, $TranslationItemPerPage, $Table; $Line = mysql_fetch_row($Database->SQLCommand('SELECT count(*) FROM '.$Table.' '.$Where)); $CountLists = $Line[0] / $TranslationItemPerPage; echo('Počet položek: '.$Line[0].'
Zobrazit stránku: '); $limitx = 0; for($i = 0; $i < $CountLists; ++$i) { $limity = $TranslationItemPerPage; $limitx = $i * $limity; $Page = $i + 1; if($_SESSION['limitx'] == $limitx) echo(''.$Page.' '); else echo(''.$Page.' '); } if(!array_key_exists('limitx', $_SESSION)) $_SESSION['limitx'] = 0; if($_SESSION['limitx'] > $limitx) $_SESSION['limitx'] = 0; } function WriteQuests($sql, $limit, $address) { global $Database, $order, $desc, $TranslationTree, $GroupId, $Table; // Check if order column exists $Items = $TranslationTree[$GroupId]['Items']; $I = 0; while(($I < count($Items)) and ($Items[$I]['MangosColumn'] != $order)) $I++; if($I >= count($Items)) $order = 'ID'; if($limit <> '') $limit = 'LIMIT '.$limit; if($address <> 'selection') { if($order <> '') $order = 'ORDER BY '.$order; if($desc <> 'desc') $desc = 'desc'; else $desc = ''; } else { $order = ''; $desc = ''; } echo(''); if ($address == 'selection') echo(''); else if($address <> 'notran') echo(''); echo(''); //print_r($TranslationTree[$GroupId]['Items']); $ID = $Database->SQLCommand($sql.' '.$order.' '.$desc.' '.$limit); while($Line = mysql_fetch_assoc($ID)) { //print_r($Line); echo(''); if($address == 'selection') echo(''); else if($address <> 'notran') echo(''); echo(''); } echo('
Pořadové číslo Identifikační číslo Název VerzeVýskytUživatel
'.$Line['ID'].' '.$Line['entry'].' '.htmlspecialchars($Line[$TranslationTree[$GroupId]['Items'][0]['Column']]).' '.GetVersionWOW($Line['VersionStart']).'-'.GetVersionWOW($Line['VersionEnd']).''.$Line['CountQuest'].''.$Line['User'].'
'); } if($Action == 'notran') { echo('Filtr textů -> Nepřeložené texty - > Vypsání nepřeložených textů s limitem na stránku

'); WritePages('?group='.$GroupId.'&action=notran', 'AS items WHERE items.Language = 0 AND NOT EXISTS(SELECT 1 FROM '.$Table.' AS sub WHERE sub.Language <> 0 AND sub.entry = items.entry AND VersionEnd = "'.$BuildNumber_max.'") AND VersionEnd = "'.$BuildNumber_max.'"'); WriteQuests('SELECT * FROM '.$Table.' AS items WHERE (items.Language = 0) AND NOT EXISTS(SELECT 1 FROM '.$Table.' AS sub WHERE (sub.Language <> 0) AND (sub.entry = items.entry) AND VersionEnd = "'.$BuildNumber_max.'") AND VersionEnd = "'.$BuildNumber_max.'"', $_SESSION['limitx'].','.$_SESSION['limity'], 'notran'); } else if($Action == 'nocomplete') { echo('Filtr textů -> nedokončené texty - > Vypsání nedokončených textů s limitem na stránku

'); WritePages('?group='.$GroupId.'&action=notran', 'AS items WHERE items.Language = 0 AND NOT EXISTS(SELECT 1 FROM '.$Table.' AS sub WHERE (sub.Language <> 0) AND (sub.entry = items.entry) AND (sub.Complete = 1) AND VersionEnd = "'.$BuildNumber_max.'") AND EXISTS(SELECT 1 FROM '.$Table.' AS sub WHERE sub.Language <> 0 AND sub.entry = items.entry AND (sub.Complete = 0) AND VersionEnd = "'.$BuildNumber_max.'") AND VersionEnd = "'.$BuildNumber_max.'"'); WriteQuests('SELECT * FROM '.$Table.' AS items WHERE (items.Language = 0) AND NOT EXISTS(SELECT 1 FROM '.$Table.' AS sub WHERE (sub.Language <> 0) AND (sub.entry = items.entry) AND (sub.Complete = 1) AND VersionEnd = "'.$BuildNumber_max.'") AND EXISTS(SELECT 1 FROM '.$Table.' AS sub WHERE (sub.Language <> 0) AND (sub.entry = items.entry) AND (sub.Complete = 0) AND VersionEnd = "'.$BuildNumber_max.'") AND VersionEnd = "'.$BuildNumber_max.'"', $_SESSION['limitx'].','.$_SESSION['limity'], 'nocomplete'); } else if($Action == 'Translate') { echo('Filtr překladů -> Přeložené texty

'); WritePages('?group='.$GroupId.'&action=Translate', 'WHERE '.$Table.'.Language <> 0 AND '.$Table.'.Complete = 1'); WriteQuests('SELECT *, (SELECT user.user FROM user WHERE user.id = '.$Table.'.user) as User FROM '.$Table.' WHERE '.$Table.'.Language <> 0 AND '.$Table.'.Complete = 1', $_SESSION['limitx'].','.$_SESSION['limity'], 'Translate'); } else if(($Action == 'my') and Licence(LICENCE_USER)) { echo('Filtr textů -> Moje překlady

'); WriteQuests('SELECT *, (SELECT user.user FROM user WHERE user.id = '.$Table.'.user) as User FROM '.$Table.' Where user = '.$_SESSION['UserID'], '', 'my'); } else if(($Action == 'mydevelop') and Licence(LICENCE_USER)) { echo('Filtr textů -> Rozepsané překlady

'); WriteQuests('SELECT *, (SELECT user.user FROM user WHERE user.id = '.$Table.'.user) as User FROM '.$Table.' Where user = '.$_SESSION['UserID'].' AND Complete = 0', '', 'mydevelop'); } else if($Action == 'users') { echo('Filtr textů -> Vypsání textů od určitých uživatelů

'); $users = @$_POST['users']; $WhereUsers = ''; for($i = 0; $i < Count($users); $i++) { if($WhereUsers <> '') $WhereUsers .= ' OR User = '.$users[$i]; else $WhereUsers .= ' User = '.$users[$i]; } WriteQuests('SELECT *, (SELECT user.user FROM user WHERE user.id = '.$Table.'.user) as User FROM '.$Table.' Where '.$WhereUsers, '', 'users'); } else if($Action == 'userall') { $ID = $Database->SQLCommand('SELECT user FROM user WHERE id = '.$_GET['user']); $Line = mysql_fetch_row($ID); echo('Filtr textů'. ' -> Počty překladů uživatele '.$Line[0].':

'); echo(''); $Total = 0; foreach($TranslationTree as $Group) if($Group['TablePrefix'] != '') { if(array_key_exists('not', $_GET)) { $sql = 'SELECT COUNT(*) FROM '.$Group['TablePrefix'].' WHERE Complete = 0 AND user='.$_GET['user']; $ID = $Database->SQLCommand($sql); $Line = mysql_fetch_row($ID); $GroupId = $Group['Id']; echo(''); $Total += $Line[0]; } else { $sql = 'SELECT COUNT(*) FROM '.$Group['TablePrefix'].' WHERE user='.$_GET['user']; $ID = $Database->SQLCommand($sql); $Line = mysql_fetch_row($ID); $GroupId = $Group['Id']; echo(''); $Total += $Line[0]; } } echo(''); echo('
SkupinaPřekladů
'.$Group['Name'].''.$Line[0].'
'.$Group['Name'].''.$Line[0].'
Celkem'.$Total.'
'); } else if($Action == 'grouplist') { echo('

Seznam překladových skupin

'); echo(''); $Total = 0; foreach($TranslationTree as $Group) if($Group['TablePrefix'] != '') { $Export = 'XML'; $Import = ''; if($Group['MangosTable'] != '') { $Export .= ', SQL'; $Import = 'SQL '.$Group['MangosDatabase'].'.'.$Group['MangosTable']; } if($Group['DBCFileName'] != '') { $Export .= ', DBC'; $Import = $Group['DBCFileName'].'.dbc'; } if($Group['LuaFileName'] != '') { $Export .= ', Lua'; $Import = $Group['LuaMPQFolder'].'/'.$Group['LuaFileName'].'.lua'; } foreach($Group['Items'] as $Item) if(($Item['AddonFileName'] != '') and (substr($Export, -5) != 'Addon')) { $Export .= ', Addon'; } echo(''); } echo('
JménoZdroj pro importFormáty exportu
'.$Group['Name'].''.$Import.''.$Export.'
'); } else if($Action == 'userid') { if(array_key_exists('user', $_GET)) { $ID = $Database->SQLCommand('SELECT user FROM user WHERE id = '.($_GET['user'] * 1)); if(mysql_num_rows($ID) > 0) { $Line = mysql_fetch_row($ID); echo('Filtr textů -> '. 'Vypis překladů uživatele '.$Line[0].':

'); if(array_key_exists('not', $_GET)) WriteQuests('SELECT *, (SELECT user.user FROM user WHERE user.id = '.$Table.'.user) as User FROM '.$Table.' Where Complete = 0 AND user = '.$_GET['user'], '', 'userid'); else WriteQuests('SELECT *, (SELECT user.user FROM user WHERE user.id = '.$Table.'.user) as User FROM '.$Table.' Where user = '.$_GET['user'], '', 'userid'); } else echo('Nebyl nalezen uživatel se zadaným id'); } else echo('Je nutno zadat id uživatele.'); } else if($Action == 'search') { if(array_key_exists('search', $_GET)) $Search = $_GET['search']; else $Search = $_POST['search']; $sql = 'SELECT *, (SELECT user.user FROM user WHERE user.id = '.$Table.'.user) as User FROM `'.$Table.'` WHERE `ID` LIKE "%'.$Search.'%" OR `entry` LIKE "%'.$Search.'%" OR `Language` LIKE "%'.$Search.'%" OR `User` LIKE "%'.$Search.'%" OR `Complete` LIKE "%'.$Search.'%"'; foreach($TranslationTree[$GroupId]['Items'] as $Item) { if($Item['Column'] != '') $sql .= ' OR `'.$Item['Column'].'` LIKE "%'.$Search.'%"'; } WriteQuests($sql, '', 'search='.$Search); } else if($Action == 'searchentry') { if(array_key_exists('ID', $_GET)) $Search = $_GET['ID']; else $Search = $_POST['ID']; $sql = 'SELECT *, (SELECT user.user FROM user WHERE user.id = '.$Table.'.user) as User FROM `'.$Table.'` WHERE `entry` LIKE "'.$Search.'"'; WriteQuests($sql, '', 'searchentry='.$Search); } else if($Action == 'all') { echo('Filtr textů -> Nepřeložené texty - > Výpis všech textů s limitem na stránku

'); WritePages('?group='.$GroupId.'&action=all', ' AS items WHERE (items.Language = 0)'); WriteQuests('SELECT * FROM '.$Table.' AS items WHERE (items.Language = 0)', $_SESSION['limitx'].','.$_SESSION['limity'], 'all'); } else if($Action == 'filter') { echo('Filtr textů


'. ''. ''. ''. ''. ''. ''. ''. ''. ''); if(Licence(LICENCE_USER)) { echo(''); } echo(''); echo(''); echo(''); echo('
OdkazPopis
Všechny textyZobrazit všechny dostupné texty ve skupině.
Přeložené textyZobrazit pouze již přeložené texty.
Nepřeložené textyDosud nepřeložené texty, které je potřeba přeložit.
Nedokončené textyTexty označené jako rozpracované.
Rozepsané texty Nedokončené texty přihlášeného uživatele
Moje překlady Přeložené texty přihlášeného uživatele
'. '
 Vypsat pouze od těchto uživatalů
Vybrat více uživatelů můžete pomocí CTRL+click
'. ''. ''. '
'. '		Vyhledat pomocí textu
'. ''. ''. '
'. '		Zobrazit podle ID textu v databázi MaNGOSu
'); // WriteQuests("SELECT * FROM quests Where user = ".$_SESSION['UserID']." AND Complete = '0'", '', 'mydevelop'); } ShowFooter(); ?>