Changeset 425 for branches/CombinedTextTables/form.php

Timestamp:

Apr 8, 2010, 7:58:16 AM (14 years ago)

Author:

george

Message:

• Upraveno: Doplněny upravené soubory do vývojové větve CombinedTextTables.
• Nastavení ignorování obsahu složek s ikonami u AoWoW.

File:

• branches/CombinedTextTables/form.php (modified) (7 diffs)

branches/CombinedTextTables/form.php

@@ -5 +5 @@
 function ColorNames($Text, $names) 
 {
-  
-   // $buff[] = array($Line['ID'],GetIDbyName($Table),$Line[$Column],$Line['Tran']);
-  foreach($names as $Line) {
-   if ($Line[3] <> '') {
-     $Text = str_replace($Line[2],'<span Title="Byl nalezen překlad: '.$Line[3].'" class="edit">'.$Line[2].'</span>',$Text);
-     $Text = str_replace(strtolower($Line[2]),'<span Title="Byl nalezen překlad: '.$Line[3].'" class="edit">'.$Line[2].'</span>',$Text);
-   } else {
-       $Text = str_replace($Line[2],'<span Title="Jméno bylo nalezeno v názvech a můžete ho přeložit. Začnete kliknutím na: Vyhledat v názvech" class="edit">'.$Line[2].'</span>',$Text);
-       $Text = str_replace(strtolower($Line[2]),'<span Title="Jméno bylo nalezeno v názvech a můžete ho přeložit. Začnete kliknutím na: Vyhledat v názvech" class="edit">'.$Line[2].'</span>',$Text);
-     }
+  // $buff[] = array($Line['ID'],GetIDbyName($Table),$Line[$Column],$Line['Tran']);
+  foreach($names as $Line) 
+  {
+    if($Line[3] <> '') 
+    {
+      $Text = str_replace($Line[2], '<span Title="Byl nalezen překlad: '.$Line[3].'" class="edit">'.$Line[2].'</span>',$Text);
+      $Text = str_replace(strtolower($Line[2]), '<span Title="Byl nalezen překlad: '.$Line[3].'" class="edit">'.$Line[2].'</span>', $Text);
+    } else 
+    {
+      $Text = str_replace($Line[2], '<span Title="Jméno bylo nalezeno v názvech a můžete ho přeložit. Začnete kliknutím na: Vyhledat v názvech" class="edit">'.$Line[2].'</span>', $Text);
+      $Text = str_replace(strtolower($Line[2]), '<span Title="Jméno bylo nalezeno v názvech a můžete ho přeložit. Začnete kliknutím na: Vyhledat v názvech" class="edit">'.$Line[2].'</span>', $Text);
+    }
   }
   return $Text;
@@ -22 +24 @@
 
 $GroupId = LoadGroupIdParameter();
-$Table = $TranslationTree[$GroupId]['TablePrefix'];
+$Group = $TranslationTree[$GroupId];
 if(array_key_exists('action', $_GET)) $Action = $_GET['action']; 
   else $Action = '';
 
-if(array_key_exists('ID', $_GET)) 
+if(array_key_exists('ID', $_GET) and is_numeric($_GET['ID'])) 
 {
-  $TextID = $_GET['ID'] * 1;  
+  $TextID = $_GET['ID'];  
 
-  $DbResult = $Database->SQLCommand('SELECT * FROM `'.$Table.'` WHERE `ID` = '.$TextID);
+  $DbResult = $Database->SQLCommand('SELECT * FROM `Translation` WHERE `ID` = '.$TextID);
   $Line = mysql_fetch_assoc($DbResult);
   if(!$Line) ErrorMessage('Překlad nenalezen.');
     
-  $DbResult = $Database->SQLCommand('SELECT * FROM `'.$Table.'` WHERE `Language` = 0  AND `Entry` = '.$Line['Entry'].' AND `VersionEnd` = '.$Line['VersionEnd'].' LIMIT 1');
+  $DbResult = $Database->SQLCommand('SELECT * FROM `Translation` WHERE (`Language` = 0) AND (`Entry` = '.$Line['Entry'].') AND (`VersionEnd` = '.$Line['VersionEnd'].') LIMIT 1');
   $LineAJ = mysql_fetch_assoc($DbResult);
   if(!$Line) ErrorMessage('Anglický originál k překladu nenalezen.');
+  $DbResult = $System->Database->query('SELECT * FROM `TranslationItem` WHERE `Translation`='.$LineAJ['Id']);
+  while($DbRow = $DbResult->fetch_assoc())
+    $LineAJ['Item'.$DbRow['Sequence']] = $DbRow['Value'];
   
   $IDUser = $Database->SQLCommand('SELECT * FROM `User` WHERE `ID` = '.$Line['User']);
@@ -45 +50 @@
   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'])) 
+  if(($Line['Original'] <> 0) and ($Line['Original'] <> $Line['Id'])) 
   {
-    $Language = mysql_fetch_assoc($Database->SQLCommand('SELECT `Language`,`VersionStart`,`VersionEnd` FROM `'.$Table.'` WHERE `ID` = '.$Line['Take']));
+    $Language = mysql_fetch_assoc($Database->SQLCommand('SELECT `Language`,`VersionStart`,`VersionEnd` FROM `Translation` WHERE `ID` = '.$Line['Original']));
     // 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('Převzato z: <a href="form.php?group='.$GroupId.'&amp;ID='.$Line['Original'].'">'.$Line['Original'].'</a> <br />');
   }
   echo('Text: ');
@@ -63 +68 @@
   echo('<br />');
    
-  $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `'.$Table.'` WHERE `Entry` = '.$Line['Entry'].' AND `Language` <> 0');
+  $DbResult = $Database->SQLCommand('SELECT COUNT(*) FROM `Translation` WHERE (`Entry` = '.$Line['Entry'].') AND (`Language` <> 0)');
   $Version = mysql_fetch_row($DbResult);
   $Version = $Version[0];
@@ -75 +80 @@
       <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'].')');  
+    $DataID = $Database->SQLCommand('SELECT *, (SELECT `User`.`Name` AS `UserName` FROM `User` WHERE `User`.`ID` = `Translate`.`User`) AS `UserName` FROM `Translate` 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>');   
+      if ($version['Id'] == $Line['Original']) 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('<option value="'.$version['Id'].'">'.$version['Id'].' - '.$Version['UserName'].' ('.GetVersionWOW($version['VersionStart']).' - '.GetVersionWOW($version['VersionEnd']).')</option>');
       }
     }
@@ -95 +100 @@
   if($User->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>');
+    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);
+    //FollowingTran($TextID, $Table, $GroupId, true); 
+    //FollowingTran($TextID, $Table, $GroupId);
   }
 
@@ -128 +133 @@
   echo('</td></tr>');
 
-  //zvýrazňování jmen
-    $Text = '';
-    foreach($TranslationTree[$GroupId]['Items'] as $Index => $TextItem)
-      if($TextItem['Visible'] == 1)
-        $Text = $Text.' '.$LineAJ[$TextItem['Column']];
+  /*
+  // zvýrazňování jmen
+  $Text = '';
+  foreach($TranslationTree[$GroupId]['Items'] as $Index => $TextItem)
+    if($TextItem['Visible'] == 1)
+      if(array_key_exists('Item'.$TextItem['Sequence'], $LineAJ))
+        $Text = $Text.' '.$LineAJ['Item'.$TextItem['Sequence']];
 
-  if(($GroupId < 4) or ($GroupId == 10) or ($GroupId == 11)) {
-  //<span class="edit">barvou.</span>
-    $names = GetTranslatNames($Text,0,array('Dictionary' => 'Text','TextCreature' => 'name'));
-  } else {
-    $names = GetTranslatNames($Text,0,array('Dictionary' => 'Text'));
+  if(($GroupId < 4) or ($GroupId == 10) or ($GroupId == 11)) 
+  {
+    //<span class="edit">barvou.</span>
+    $names = GetTranslatNames($Text, 0, array('Dictionary' => 'Text', 'TextCreature' => 'name'));
+  } else 
+  {
+    $names = GetTranslatNames($Text, 0, array('Dictionary' => 'Text'));
   }
   //print_r($names);
-
-  foreach($TranslationTree[$GroupId]['Items'] as $Index => $TextItem)
-  if($TextItem['Visible'] == 1)
-  {          
-    if(($LineAJ[$TextItem['Column']] <> '') or ($Line[$TextItem['Column']] <> ''))  
+  */
+  $names = array();
+  
+  $DbResult = $System->Database->query('SELECT * FROM TranslationItem WHERE Translation='.$TextID);
+  while($TranslationItem = $DbResult->fetch_assoc())
+  {
+    $TextItem = $TranslationTree[$GroupId]['Items'][$TranslationItem['Sequence']];
+    if($TextItem['Visible'] == 1)
+    {          
+      if(($LineAJ['Item'.$TranslationItem['Sequence']] <> '') or ($TranslationItem['Value'] <> ''))  
+      {
+        //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/>', ColorNames(htmlspecialchars($LineAJ['Item'.$TranslationItem['Sequence']]),$names)).'</td>'.
+        '<td><textarea rows="8" cols="40" onkeydown="ResizeTextArea(this)" class="textedit" id="Item'.$TranslationItem['Sequence'].'" name="Item'.$TranslationItem['Sequence'].'">'.htmlspecialchars($TranslationItem['Value']).'</textarea></td></tr>');
+      }
+    } else
     {
-      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/>', ColorNames(htmlspecialchars($LineAJ[$TextItem['Column']]),$names)).'</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>');
+      echo('<input id="Item'.$TranslationItem['Sequence'].'" name="Item'.$TranslationItem['Sequence'].'" type="hidden" value="'.htmlspecialchars($TranslationItem['Value']).'" />');
     }
-  } else
-  {
-    echo('<input id="'.$TextItem['Column'].'" name="'.$TextItem['Column'].'" type="hidden" value="'.htmlspecialchars($Line[$TextItem['Column']]).'" />');
   }
   echo('</table></div></form>');