Changeset 216 for trunk/includes/global_function.php

Timestamp:

Jun 24, 2009, 10:30:42 PM (15 years ago)

Author:

maron

Message:

Import textů z dbc souborů, úprava importu: # změněn text + přidán text , nezměněn text ovlivněn sloupec VersionEnd . neovlivněn text
Přidání sloupců pro indexování dbc souborů u tabulky verzí hry
Možnos vypráznění logu

File:

• trunk/includes/global_function.php (modified) (2 diffs)

trunk/includes/global_function.php

@@ -233 +233 @@
 }
 
+
+function HaveSameText($Group, $DbRow2, $Value)
+{
+  $result = true;
+  foreach($Group['Items'] as $GroupItem) 
+  {
+    $old = $DbRow2[$GroupItem['Column']];
+    $old = str_replace(chr(10), '', $old);
+    $old = str_replace(chr(13), '', $old);
+    $old = str_replace('\n', '', $old);
+    $old = str_replace('\r', '', $old);
+    $old = str_replace('\"', '"', $old);
+    $old = str_replace('\\\\', '\\', $old);
+    $old = str_replace('\32', '32', $old);
+    $old = str_replace('\124', '124', $old);
+    $old = str_replace("\'", "'", $old);
+  
+    $new = $Value[$GroupItem['Column']];
+    $new = str_replace(chr(10), '', $new);
+    $new = str_replace(chr(13), '', $new);
+    $new = str_replace('\n', '', $new);
+    $new = str_replace('\r', '', $new);
+    $new = str_replace('\"', '"', $new);
+    $new = str_replace('\\\\', '\\', $new);
+    $new = str_replace('\32', '32', $new);
+    $new = str_replace('\124', '124', $new);
+    $new = str_replace("\'", "'", $new);
+
+    if(($old <> $new) and ($GroupItem['Column'] <> 'Comment')) 
+    {
+     //   echo $old.'-'.$new;
+      $result = false;
+    }
+  }
+  return($result);
+}
+
+
 function GetBuildNumber($Version)
 {
@@ -251 +289 @@
 }
 
+function GetDBCColumns($Version,$DBCFileName)
+{
+  global $Database;
+        
+  $sql = 'SELECT DBCColumns_'.$DBCFileName.' as DBCColumns FROM `wow_client_version` WHERE Version = "'.$Version.'"';
+  $DbRow = mysql_fetch_assoc($Database->SQLCommand($sql));
+  return($DbRow['DBCColumns']);
+}
+
+function GetDBCColumnIndex($Version,$DBCFileName,$Column)
+{
+  global $Database;
+        
+  $sql = 'SELECT '.$DBCFileName.'_'.$Column.' as DBCColumns FROM `wow_client_version` WHERE Version = "'.$Version.'"';
+  $DbRow = mysql_fetch_assoc($Database->SQLCommand($sql));
+  return($DbRow['DBCColumns']);
+}
+
 ?>