Changeset 216 for trunk/import/import_dbc.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/import/import_dbc.php (modified) (3 diffs)

trunk/import/import_dbc.php

@@ -1 +1 @@
 <?php
+/*
+DELETE FROM `gametips` WHERE ID > 266;
+DELETE FROM `spell` WHERE ID > 43672;
+UPDATE `gametips` SET VersionStart = 8606,VersionEnd = 8606;
+UPDATE `spell` SET VersionStart = 8606,VersionEnd = 8606;
+DELETE FROM `log` WHERE Type = 11;
+*/  
+ 
 
-function ImportDBC()
+
+function ImportDBC($import_version)
 {
   global $Database, $TranslationTree, $Config;
+  $BuildNumber = GetBuildNumber($import_version);
 
   echo('Načítání textů z DBC souborů...');
@@ -12 +22 @@
       echo('<br />'.$Group['Name'].'<br />');   
           $DBCFile = new DBCFile();
-          $DBCFile->OpenFile('../source/'.$Config['Web']['GameVersion'].'/dbc/'.$Group['DBCFileName'].'.dbc', $Group['DBCColumns']);
+          $DBCFile->OpenFile('../source/'.$import_version.'/dbc/'.$Group['DBCFileName'].'.dbc', GetDBCColumns($import_version,$Group['DBCFileName']));
           $ItemCount = $DBCFile->GetRecordCount();
           $NewCount = 0;
@@ -18 +28 @@
           for($i = 0; $i < $ItemCount; $i++)
       {
+        foreach($Group['Items'] as $GroupItem)
+        {
+          $Value[$GroupItem['Column']] = addslashes($DBCFile->GetString($i, GetDBCColumnIndex($import_version,$Group['DBCFileName'],$GroupItem['Column'])));
+        }
+                
+        $Columns = '';
+        foreach($Group['Items'] as $GroupItem)
+        {
+          $Columns .= ', '.$GroupItem['Column'].' ';
+        }
+          $Columns = substr($Columns, 1);
+                
         $ItemId = $DBCFile->GetUint($i, 0);  
-        $DbResult2 = $Database->SQLCommand('SELECT ID FROM '.$Group['TablePrefix'].' WHERE entry='.$ItemId.' AND Language=0');
+        $DbResult2 = $Database->SQLCommand('SELECT VersionEnd, ID, entry, '.$Columns.' FROM '.$Group['TablePrefix'].' WHERE entry='.$ItemId.' AND Language=0 ORDER BY VersionStart DESC LIMIT 1');
         if(isset($DbResult2) and (mysql_num_rows($DbResult2) > 0))
             {
-                  $DbRow2 = mysql_fetch_assoc($DbResult2);
-                  //echo($DbRow2['ID']);
-                  $ColumnsValues = '';
-              foreach($Group['Items'] as $GroupItem)
-                  {
-                $ColumnsValues .= ', `'.$GroupItem['Column'].'`="'.addslashes($DBCFile->GetString($i, $GroupItem['DBCColumnIndex'])).'"';
-                  }
-                  $ColumnsValues = substr($ColumnsValues, 2);
-                  echo('. '); //'UPDATE `'.$Group['TablePrefix'].'` SET '.$ColumnsValues.' WHERE ID='.$DbRow2['ID']."<br>");
-                  //print_r($DbRow2);
-                  $Database->SQLCommand('UPDATE `'.$Group['TablePrefix'].'` SET '.$ColumnsValues.' WHERE ID='.$DbRow2['ID']);
+            // Update existed text
+            $DbRow2 = mysql_fetch_assoc($DbResult2);
+            if(HaveSameText($Group, $DbRow2, $Value)) 
+            { 
+                          if ($DbRow2['VersionEnd'] <> $BuildNumber) {
+                $Database->SQLCommand('UPDATE `'.$Group['TablePrefix'].'` SET VersionEnd = "'.$BuildNumber.'" WHERE ID='.$DbRow2['ID']);
+                            echo(', '); 
+                          } else
+                            echo('. '); 
+            } else 
+            {       
+              $Columns = 'entry, language, VersionStart, VersionEnd';
+              $Values = $DbRow2['entry'].', 0, '.$BuildNumber.', '.$BuildNumber;
+              foreach($Group['Items'] as $GroupItem) 
+              { 
+                $Columns .= ', `'.$GroupItem['Column'].'`';
+                $Values .= ', "'.$Value[$GroupItem['Column']].'"';
+              }
+              $Database->SQLCommand('INSERT `'.$Group['TablePrefix'].'` ('.$Columns.') VALUES ('.$Values.')');
+              echo('# ');
+              $NewCount++;
+              WriteLog('Text <a href="form.php?group='.$Group['Id'].'&amp;ID='.$DbRow2['ID'].'">'.$DbRow2['ID'].'</a> ('.$DbRow2['entry'].') ze skupiny '.$Group['Name'].' byl v nové verzi '.$import_version.' změněn.', 11);
+            }       
+                        
             } else 
-            {
-                  $Columns = 'entry, language';
-                  $Values = $ItemId.', 0';
-              foreach($Group['Items'] as $GroupItem)
-                  { 
-                $Columns .= ', `'.$GroupItem['Column'].'`';
-                    $Values .= ', "'.addslashes($DBCFile->GetString($i, $GroupItem['DBCColumnIndex'])).'"';
-                  }
-                  //$Columns = substr($Columns, 2);
-                  //$Values = substr($Values, 2);
-                  $Database->SQLCommand('INSERT `'.$Group['TablePrefix'].'` ('.$Columns.') VALUES ('.$Values.')');
-                  echo('# ');
-                  //echo('INSERT `'.$Group['TablePrefix'].'` ('.$Columns.') VALUES ('.$Values.')'."<br>");
-              $NewCount++;
+            {           
+            // Insert new text
+            $Columns = 'entry, language, VersionStart, VersionEnd';
+            $Values = $ItemId.', 0, '.$BuildNumber.', '.$BuildNumber;
+            foreach($Group['Items'] as $GroupItem)
+            { 
+              $Columns .= ', `'.$GroupItem['Column'].'`';
+              $Values .= ', "'.$Value[$GroupItem['Column']].'"';
+            }
+            $Database->SQLCommand('INSERT `'.$Group['TablePrefix'].'` ('.$Columns.') VALUES ('.$Values.')');
+            echo('+ ');
+            $NewCount++;
+            WriteLog('Text <a href="form.php?group='.$Group['Id'].'&amp;ID='.mysql_insert_id().'">'.$DbRow2['ID'].'</a> ('.$ItemId.') ze skupiny '.$Group['Name'].' byl v nové verzi '.$import_version.' přidán.', 11);
+                
             }
             $Count++;