Changeset 393 for trunk/includes/global_function.php

Timestamp:

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

Author:

maron

Message:

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

File:

• trunk/includes/global_function.php (modified) (1 diff)

trunk/includes/global_function.php

@@ -462 +462 @@
 }
 
+function GetIDbyName($Table) 
+{
+  global $TranslationTree;
+  
+  foreach($TranslationTree as $TableID => $Value) 
+  {
+    //echo $Value['TablePrefix'].'='.$Table.'<br>';
+      if ($Value['TablePrefix'] == $Table) return $TableID;
+  }
+}
+
+
+function GetTranslatNames($Text,$mode,$TablesColumn) 
+{
+  global $Database;
+  
+ /* $TablesID = array('gameobject' => 5,
+  'creature' => 6,
+  'item' => 4,
+  'transports' => 'Name',
+  'areatrigger_teleport' => 'Name',
+  'areatrigger_tavern' => 'Name',); */
+    $buff = array();
+  
+  foreach($TablesColumn as $Table => $Column) 
+  {  
+    $sql = 'SELECT `ID`,`'.$Column.'`, (SELECT `'.$Column.'` 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])-2);
+      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]) > 5)
+        $where .= '(`O`.`'.$Column.'` LIKE "%'.addslashes($ArrStr[$i]).'%") OR ';
+    }
+    $where = substr($where,0,strlen($where)-4);
+    $where .= ')';
+
+    $ID = $Database->SQLCommand($sql.$where.$groupby);
+    //echo ($sql.$where.$groupby);
+    while($Line = mysql_fetch_assoc($ID)) 
+    {
+   //   if (($mode != 0) or (($mode == 0) and (strpos(strtolower($Text), strtolower($Line[2])) > 0) ) ) 
+          $buff[] = array($Line['ID'],GetIDbyName($Table),$Line[$Column],$Line['Tran']);
+    }
+  }
+    return $buff;
+}
 ?>