Changeset 393 for trunk/dictionary.php

Timestamp:

Mar 17, 2010, 1:21:49 PM (15 years ago)

Author:

maron

Message:

Zvýrazňování názvů jmen a slov ze slovníčku u překladů

File:

• trunk/dictionary.php (modified) (3 diffs)

trunk/dictionary.php

@@ -3 +3 @@
 include('includes/global.php');
 
-function GetIDbyName($Table) 
+function WriteTranslatNames($Text,$mode) 
 {
-  global $TranslationTree;
-  
-  foreach($TranslationTree as $TableID => $Value) 
-  {
-    //echo $Value['TablePrefix'].'='.$Table.'<br>';
-      if ($Value['TablePrefix'] == $Table) return $TableID;
-  }
-}
-
-function GetTranslatNames($Text) 
-{
-  global $Database, $mode;
-  
-  if ($mode == 0) echo ('..Přesné');
+        
+  if ($mode == 0) echo ('..Nalezené názvy jmen věcí, míst, postav');
   if ($mode == 1) echo ('..Všechny přeložené');
   if ($mode == 2) echo ('..Nepřeložené');
-  echo('<div style="overflow: auto; width: 100%; height: 345px;"><table width="98%" class="BaseTable">');
-  echo('<tr><th>Originál</th>'.'<th>Překlad</th>');
+  echo('<table width="98%" class="BaseTable">');
+  echo('<tr><th>Originál</th>'.'<th>Překlad</th></tr>');
+
+
   $TablesColumn = array
   (
@@ -31 +21 @@
     'TextAreaTriggerTeleport' => 'Name',
     'TextAreaTriggerTavern' => 'Name',
+    'Dictionary' => 'Text',
   );
- /* $TablesID = array('gameobject' => 5,
-  'creature' => 6,
-  'item' => 4,
-  'transports' => 'Name',
-  'areatrigger_teleport' => 'Name',
-  'areatrigger_tavern' => 'Name',); */
+
+  $buff = GetTranslatNames($Text,$mode,$TablesColumn);
   
-  foreach($TablesColumn as $Table => $Column) 
-  {  
-    $sql = 'SELECT `ID`,`'.$Column.'`, (SELECT `Name` FROM `'.$Table.'` AS `T` WHERE `O`.`Entry` = `T`.`Entry` AND `Language` <> 0 LIMIT 1) AS `Tran` FROM `'.$Table.'` AS `O` WHERE ';
-    $groupby = ' GROUP BY `'.$Column.'`';
-  
-    $ArrStr = explode(' ', $Text);
-    $where = '`Language` = 0 ';
-    if ($mode == 1) $where .= ' AND EXISTS(SELECT 1 FROM `'.$Table.'` AS `Sub` WHERE (`Sub`.`Language` <> 0) AND (`Sub`.`Entry` = `O`.`Entry`))';
-    if ($mode == 2) $where .= ' AND NOT EXISTS(SELECT 1 FROM `'.$Table.'` AS `Sub` WHERE (`Sub`.`Language` <> 0) AND (`Sub`.`Entry` = `O`.`Entry`))';
-    $where .= ' AND ('; 
- 
-    for($i = 0; $i < count($ArrStr); $i++)
-    {
-      if (strpos($ArrStr[$i],'\'s') > 0) $ArrStr[$i] = substr($ArrStr[$i],0,strlen($ArrStr[$i])-4);
-      if (strpos($ArrStr[$i],',') > 0) $ArrStr[$i] = substr($ArrStr[$i],0,strlen($ArrStr[$i])-1);
-      if (strpos($ArrStr[$i],'.') > 0) $ArrStr[$i] = substr($ArrStr[$i],0,strlen($ArrStr[$i])-1);
-      if (strpos($ArrStr[$i],'!') > 0) $ArrStr[$i] = substr($ArrStr[$i],0,strlen($ArrStr[$i])-1);
-      if (strpos($ArrStr[$i],'?') > 0) $ArrStr[$i] = substr($ArrStr[$i],0,strlen($ArrStr[$i])-1);
-
-      if (strlen($ArrStr[$i]) > 4)
-        $where .= '(`O`.`'.$Column.'` LIKE "%'.addslashes($ArrStr[$i]).'%") OR ';
-    }
-    $where = substr($where,0,strlen($where)-4);
-    $where .= ')';
-    echo('</tr>');
-
-    $ID = $Database->SQLCommand($sql.$where.$groupby);
-    while($Line = mysql_fetch_assoc($ID)) 
-    {
+         // $buff[] = array($Line['ID'],GetIDbyName($Table),$Line[$Column],$Line['Tran']);
+  foreach($buff as $Line) {
       if ($mode == 0) 
       {
-        if (strpos(strtolower($Text), strtolower($Line[$Column])) > 0) 
-        {
-          echo('<tr><td>'.$Line[$Column].'</td>');
-          if ($Line['Tran'] <> '') echo('<td>'.$Line['Tran'].'</td></tr>');
-          else echo('<td><a target="_NEW2" href="form.php?group='.GetIDbyName($Table).'&amp;ID='.$Line['ID'].'">Překládat</a></td></tr>');
+        if (strpos(strtolower($Text), strtolower($Line[2])) > 0) 
+        {
+          echo('<tr><td>'.$Line[2].'</td>');
+          if ($Line[3] <> '') echo('<td><a target="_NEW2" href="form.php?group='.$Line[1].'&amp;ID='.$Line[0].'">'.$Line[3].'</a></td></tr>');
+          else echo('<td><a target="_NEW2" href="form.php?group='.$Line[1].'&amp;ID='.$Line[0].'">Překládat</a></td></tr>');
         }
       } else 
       {
-        echo('<tr><td>'.$Line[$Column].'</td>');
-          if ($Line['Tran'] <> '') echo('<td>'.$Line['Tran'].'</td></tr>');
-          else echo('<td><a target="_NEW2" href="form.php?group='.GetIDbyName($Table).'&amp;ID='.$Line['ID'].'">Překládat</a></td></tr>');
+        echo('<tr><td>'.$Line[2].'</td>');
+          if ($Line[3] <> '') echo('<td><a target="_NEW2" href="form.php?group='.$Line[1].'&amp;ID='.$Line[0].'">'.$Line[3].'</a></td></tr>');
+          else echo('<td><a target="_NEW2" href="form.php?group='.$Line[1].'&amp;ID='.$Line[0].'">Překládat</a></td></tr>');
       }
-    }
-  }
-  echo('</table></div>');
+  }
+
+  echo('</table>');
 }
 
@@ -119 +79 @@
     foreach($TranslationTree[$GroupId]['Items'] as $Index => $TextItem)
       $Text .= ' '.$Line[$TextItem['Column']];
-        GetTranslatNames($Text);
+        WriteTranslatNames($Text,$mode);
   }
 } else