source: trunk/fill_database.php@ 89

<?php

include('includes/global.php');
include('dbc/dbc.php');

ShowPage();
  
echo('Načítání textů z databáze MaNGOSu: ');
echo('<div style="font-size: xx-small;">');
  
foreach($TranslationTree as $Group)
{
  if(($Group['MangosTable'] != '') and ($Group['TablePrefix'] != ''))
  {
        echo('<br />'.$Group['Name'].'<br />');
        $Columns = '`'.$Group['MangosDatabase'].'`.`'.$Group['MangosTable'].'`.`'.$Group['MangosTableIndex'].'`';
        foreach($Group['Items'] as $GroupItem)
          $Columns .= ', `'.$Group['MangosDatabase'].'`.`'.$Group['MangosTable'].'`.`'.$GroupItem['MangosColumn'].'` AS `'.$GroupItem['Column'].'`';
        $Query = 'SELECT '.$Columns.' FROM `'.$Group['MangosDatabase'].'`.`'.$Group['MangosTable'].'`'; 
        //echo($Query.'<br />');        
        $Count = 0;
        $NewCount = 0;
        $DbResult = $Database->SQLCommand($Query);
        while($DbRow = mysql_fetch_assoc($DbResult))
        {
          //echo('SELECT ID FROM '.$Group['TablePrefix'].' WHERE entry='.$DbRow[$Group['MangosTableIndex']].' AND Language=0'."<br>");
          $DbResult2 = $Database->SQLCommand('SELECT ID FROM '.$Group['TablePrefix'].' WHERE entry='.$DbRow[$Group['MangosTableIndex']].' 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($DbRow[$GroupItem['MangosColumn']]).'"';
                }
                $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 = $DbRow[$Group['MangosTableIndex']].', 0';
            foreach($Group['Items'] as $GroupItem)
                {
              $Columns .= ', `'.$GroupItem['Column'].'`';
                  $Values .= ', "'.addslashes($DbRow[$GroupItem['MangosColumn']]).'"';
                }
                //$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 />');
  } else
  if(($Group['DBCFileName'] != '') and ($Group['TablePrefix'] != ''))
  {
        echo('<br />'.$Group['Name'].'<br />'); 
        $DBCFile = new DBCFile();
        $DBCFile->OpenFile('dbc/'.$Group['DBCFileName'].'.dbc', $Group['DBCColumns']);
        $ItemCount = $DBCFile->RecordCount();
        $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>');
  
WriteLog('Plnění databáze', 4);
  
ShowFooter();      

?>