<?php

include('includes/global.php');    

ShowPage();

$GroupId = LoadGroupIdParameter();
$Table = $TranslationTree[$GroupId]['TablePrefix'];
if(array_key_exists('action', $_GET)) $Action = $_GET['action']; else $Action = '';

if(array_key_exists('ID', $_GET)) 
{
  $TextID = $_GET['ID'] * 1;  

  $DbResult = $Database->SQLCommand('SELECT * FROM `'.$Table.'` WHERE `ID` = '.$TextID);
  $Line = mysql_fetch_assoc($DbResult);
  if(!$Line) die('Překlad nenalezen.');
    
  $DbResult = $Database->SQLCommand('SELECT * FROM `'.$Table.'` WHERE `Language` = 0  AND `Entry` = '.$Line['Entry'].' AND `VersionEnd` = '.$Line['VersionEnd'].' LIMIT 1');
  $LineAJ = mysql_fetch_assoc($DbResult);
  if(!$Line) die('Anglický originál k překladu nenalezen.');
  
  $User = @$_SESSION['User'];
  $IDUser = $Database->SQLCommand('SELECT * FROM `User` WHERE `ID` = '.$Line['User']);
  $LineUser = mysql_fetch_array($IDUser);
  
  echo('Skupina: <strong>'.$TranslationTree[$GroupId]['Name'].'</strong><br />');
      
  if(($Line['Language'] <> 0) and ($LineUser['Name'] <> '')) 
    echo('Přeložil: <strong>'.$LineUser['Name'].'</strong> <br />');
  if(($Line['Take'] <> 0) and ($Line['Take'] <> $Line['ID'])) 
  {
    $Language = mysql_fetch_assoc($Database->SQLCommand('SELECT `Language`,`VersionStart`,`VersionEnd` FROM `'.$Table.'` WHERE `ID` = '.$Line['Take']));
    // echo $Language['Language'].'  '.$Line['Take'];
    if($Language['Language'] <> 0)
      echo('Převzato z: <a href="form.php?group='.$GroupId.'&amp;ID='.$Line['Take'].'">'.$Line['Take'].'</a> <br />');
  }
  echo('Text: ');
  if($Line['Language'] <> 0) 
  {
    if($Line['Complete'] == 1) echo(' <b>Hotov</b>');
      else echo(' <b> Uložen v rozepsaných</b> ');
  } else echo(' <b>Anglická, původní verze</b> ');

  echo('<br />');
  echo('Verze: <b>'.GetVersionWOW($Line['VersionStart']).' - '.GetVersionWOW($Line['VersionEnd'].'</b>'));
  echo('<br />');
   
  $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `'.$Table.'` WHERE `Entry` = '.$Line['Entry'].' AND `Language` <> 0');
  $Version = mysql_fetch_row($DbResult);
  $Version = $Version[0];
  if($Version > 0)
  {
    echo('<form action="comparison.php" method="get"><a href="TranslationList.php?group='.$GroupId.'&amp;action=searchentry&amp;ID='.$Line['Entry'].'">Počet verzí: <strong>'.$Version.'</strong></a>  
      <input type="hidden" name="group" value="'.$GroupId.'" />
      <input type="hidden" name="entry" value="'.$Line['Entry'].'" />
      <input type="hidden" name="ID2" value="'.$TextID.'" />
      <select onchange="this.form.submit();" name="ID1">
      <option value="-1">Vyberte text k porovnání</option>
      <option value="-1">Zobrazit/porovnat všechny</option>'); 
    $DataID = $Database->SQLCommand('SELECT *, (SELECT `User`.`Name` AS `UserName` FROM `User` WHERE `User`.`ID` = `'.$Table.'`.`User`) AS `UserName` FROM `'.$Table.'` WHERE (`Entry` = '.$Line['Entry'].') AND (`ID` <> '.$Line['ID'].')');  
    while($version = mysql_fetch_array($DataID))
    {     
      if ($version['ID'] == $Line['Take']) echo('<option value="'.$version['ID'].'">'.$version['ID'].' - '.$version['User'].' (převzato)</option>');   
      else 
      {
        if($version['Language'] == 0) $version['UserName'] = 'Předloha';
        echo('<option value="'.$version['ID'].'">'.$version['ID'].' - '.$Version['UserName'].' ('.GetVersionWOW($version['VersionStart']).' - '.GetVersionWOW($version['VersionEnd']).')</option>');
      }
    }
    echo('</select></form>');    
  } else
  {
    echo('<a href="TranslationList.php?group='.$GroupId.'&amp;action=searchentry&amp;ID='.$Line['Entry'].'">Počet verzí: <strong>'.$Version.'</strong></a>'); 
  }

//    Speciální znaky: $B - Odřádkování, $N - Jméno, $C - povolání
  echo('<form action="save.php?group='.$GroupId.'" method="post"><div>');
  if(Licence(LICENCE_USER)) 
  {
    if(($GroupId < 4) or ($GroupId == 10) or ($GroupId == 11)) echo('<a href="dictionary.php?group='.$GroupId.'&amp;ID='.$LineAJ['ID'].'" target="_blank"  title="Zobrazit přeložené názvy věci, postav, a herních objektů k tomuto překladu">Vyhledat v názvech</a>');
    echo(' <input type="submit" value="Uložit do rozepsaných" name="save" title="Klikněte na uložit pro pozdější dokončení překladu" />
    <input type="submit" value="Dokončeno" name="End" title="Klikněte na Dokončeno jesli jsou všechny texty hotové a chcete již publikovat" /> ');
    FollowingTran($TextID, $Table, $GroupId, true); 
    FollowingTran($TextID, $Table, $GroupId);
  }

  if($TranslationTree[$GroupId]['WowheadName'] != '')
    $WowheadLink = '<a href="http://www.wowhead.com/?'.$TranslationTree[$GroupId]['WowheadName'].'='.$LineAJ['Entry'].'">'.$LineAJ['Entry'].'</a>';
    else $WowheadLink = $LineAJ['Entry'];
  
  echo('<input type="hidden" name="entry" value="'.$LineAJ['Entry'].'" />
    <input type="hidden" name="user" value="'.$User.'" />
    <input type="hidden" name="ID" value="'.$TextID.'" />
    <table class="BaseTable">
      <tr>
        <th>Číslo textu: '.$WowheadLink.'</th>
        <th>Nepřeložené</th>
        <th>Přeložené</th>
      </tr>
      <tr>
        <th>Jazyk</th>
        <td>Anglický</td>
        <td>
          Přeloženo do:'); 
  if($Line['Language'] <> 0) $Language = $Line['Language']; 
  else if($_SESSION['UserID'] != '')
  {
    $IDUser = $Database->SQLCommand('SELECT * FROM `User` WHERE `ID` = '.$_SESSION['UserID']);
    $LineUser = mysql_fetch_array($IDUser);
    $Language = $LineUser['Language'];  // jiný user vyčítám
  } else $Language = 0;
  WriteLanguages($Language);
  echo('</td></tr>');
  foreach($TranslationTree[$GroupId]['Items'] as $Index => $TextItem)
  if($TextItem['Visible'] == 1)
  {          
    if(($LineAJ[$TextItem['Column']] <> '') or ($Line[$TextItem['Column']] <> ''))  
    {
      if ($TextItem['Name'] == 'Text' AND (($Table == 'global_strings') OR ($Table == 'glue_strings'))) echo('<tr><th>'.$LineAJ['ShortCut'].'</th>');
        else echo('<tr><th>'.$TextItem['Name'].'</th>');
      echo('<td>'.str_replace("\n", '<br/>', htmlspecialchars($LineAJ[$TextItem['Column']])).'</td>
      <td><textarea rows="8" cols="40" onkeydown="ResizeTextArea(this)" class="textedit" id="'.$TextItem['Column'].'" name="'.$TextItem['Column'].'">'.htmlspecialchars($Line[$TextItem['Column']]).'</textarea></td></tr>');
    }
  } else
  {
    echo('<input id="'.$TextItem['Column'].'" name="'.$TextItem['Column'].'" type="hidden" value="'.htmlspecialchars($Line[$TextItem['Column']]).'" />');
  }
  echo('</table></div></form>');
} else 
{
  // include 'ListQuests.php';   
  echo('Nebylo zadáno ID <a href="index.php">zpět</a>');
}

ShowFooter();

?>   

