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 = ''; } $TableColumns = array( array('Name' => 'ID', 'Title' => 'Pořadové číslo'), array('Name' => 'entry', 'Title' => 'Identifikační číslo'), array('Name' => $TranslationTree[$GroupId]['Items'][0]['Column'], 'Title' => 'Název'), array('Name' => 'VersionStart', 'Title' => 'Verze'), ); if($address == 'selection') $TableColumns[] = array('Name' => 'CountQuests', 'Title' => 'Výskyt'); else if($address == 'connexion') $TableColumns[] = array('Name' => '', 'Title' => 'Již přeložil'); else if($address <> 'notran') $TableColumns[] = array('Name' => 'User', 'Title' => 'Překladatel'); $Order = GetOrderTableHeader($TableColumns, 'ID'); echo(''); echo($Order['Output']); //print_r($TranslationTree[$GroupId]['Items']); $ID = $Database->SQLCommand($sql.' '.$Order['SQL'].' '.$limit); while($Line = mysql_fetch_assoc($ID)) { //print_r($Line); echo(''); if($address == 'selection') echo(''); else if($address <> 'notran') echo(''); echo(''); } echo('
'.$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 == 'connexion') { //SELECT * FROM spell WHERE entry IN(SELECT entry FROM connexion_item WHERE connexion = 1) $Line = mysql_fetch_assoc($Database->SQLCommand('SELECT Name FROM connexion WHERE `Id` = '.$_SESSION['connexion_id'])); echo('Filtr textů -> Souvislosti - > Vypsání souvislostí ze skupiny '.$Line['Name'].'

'); WritePages('?group='.$GroupId.'&action=connexion', ' WHERE Language = 0 AND entry IN(SELECT entry FROM connexion_item WHERE connexion = '.$_SESSION['connexion_id'].') AND VersionEnd = "'.$BuildNumber_max.'" AND VersionEnd = "'.$BuildNumber_max.'"'); WriteQuests('SELECT *, (SELECT sub.User FROM '.$Table.' as sub WHERE sub.entry = '.$Table.'.entry AND Language <> 0 LIMIT 1) as UserID, (SELECT user.user FROM user WHERE user.id = UserID) as User FROM '.$Table.' WHERE Language = 0 AND entry IN(SELECT entry FROM connexion_item WHERE connexion = '.$_SESSION['connexion_id'].') AND VersionEnd = "'.$BuildNumber_max.'" AND VersionEnd = "'.$BuildNumber_max.'"', $_SESSION['limitx'].','.$_SESSION['limity'], 'connexion'); } else if($Action == 'connexion_list') { //SELECT * FROM spell WHERE entry IN(SELECT entry FROM connexion_item WHERE connexion = 1) echo('Filtr textů -> Souvislosti - > Vypsání souvislostí

'); echo(''); echo(''); $ID = $Database->SQLCommand('SELECT * FROM connexion WHERE `Group` = '.$GroupId); while($Line = mysql_fetch_assoc($ID)) { echo(''); } echo ('
Pořadové čísloNázev
'.$Line['Id'].' '.$Line['Name'].'
'); } 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ů

'); if(array_key_exists('users', $_POST)) $users = $_POST['users']; else $users = array(); $WhereUsers = ''; foreach($users as $Index => $User) { if($WhereUsers <> '') $WhereUsers .= ' OR `User` = '.$User; else $WhereUsers .= ' `User` = '.$User; } if($WhereUsers == '') $WhereUsers = '0'; 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 exportuDatum posledního importuVerze posledního importu
'.$Group['Name'].''.$Import.''.$Export.''.HumanDate($Group['LastImport']).''.GetVersionWOW($Group['LastVersion']).'
'); echo('
Záznam změn v textech při importu'); } 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 if(array_key_exists('ID', $_POST)) $Search = $_POST['ID']; else $Search = ''; $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(); ?>