Changeset 64 for trunk/fill_database.php

Timestamp:

Feb 5, 2009, 10:39:11 AM (15 years ago)

Author:

george

Message:

• Přidáno: Import textů z dbc souborů. Přidány překladové skupiny gametips a spell.

File:

• trunk/fill_database.php (modified) (2 diffs)

trunk/fill_database.php

@@ -2 +2 @@
 
 include('includes/global.php');
+include('dbc/dbc.php');
   
 echo('Načítání textů z databáze MaNGOSu: ');
@@ -55 +56 @@
         }
         echo('<br />Celkem: '.$Count.'  Nových: '.$NewCount.'<br />');
-  }
+  } else
+  if(($Group['DBCFileName'] != '') and ($Group['TablePrefix'] != ''))
+  {
+        echo('<br />'.$Group['Name'].'<br />'); 
+        $DBCFile = new DBCReader();
+        $DBCFile->loadDbc('dbc/'.$Group['DBCFileName'].'.dbc', $Group['DBCColumns']);
+        $ItemCount = $DBCFile->count();
+        $NewCount = 0;
+        $Count = 0;
+        for($i = 0; $i < $ItemCount; $i++)
+    {
+      $ItemId = $DBCFile->getUint($i, 0);  
+      $DbResult2 = $Database->SQLCommand('SELECT ID FROM '.$Group['TablePrefix'].' WHERE entry='.$ItemId.' AND Language=0');
+      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']);
+          } 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++;
+          }
+          $Count++;
+        }
+        echo('<br />Celkem: '.$Count.'  Nových: '.$NewCount.'<br />');
+  }  
 }
 echo('Dokončeno.</div>');