Changeset 89 for trunk/export.php

Timestamp:

Feb 11, 2009, 7:49:33 PM (16 years ago)

Author:

george

Message:

• Přidáno: Funkce pro export do DBC souborů. Zatím veřejně nepovoleno v nabídce, protože doba generování 45 MB souboru Spells.dbc překračuje max. dobu vykonání PHP skriptu 30 sekund. Nutno zoptimalizovat.

File:

• trunk/export.php (modified) (1 diff)

trunk/export.php

@@ -162 +162 @@
   return($Buffer);
 }      
+
+function ExportToDBC($Setting)
+{
+  global $Database, $Config, $TranslationTree;
+  
+  $TempDir = 'tmp/'.$_SESSION['User'].'/dbc/';
+  if(!file_exists($TempDir)) mkdir($TempDir, 0777, true);
+ 
+  if($_SESSION['UserID'] != '')
+  {
+    $DbResult = $Database->SQLCommand("SELECT user FROM `user` WHERE ID=".$_SESSION['UserID']);
+    $User = mysql_fetch_assoc($DbResult);
+  } else $User = array('user' => 'Neznámý');
+
+  $WhereLang = '';
+  if($Setting['language-cz']) $WhereLang .= " OR (Language = 1)";
+  if($Setting['language-sk']) $WhereLang .= " OR (Language = 2)";
+  if($Setting['language-other']) $WhereLang .= " OR (Language = 3)";
+  if($WhereLang == '') $WhereLang = 1; 
+    else $WhereLang = '('.substr($WhereLang, 4).')';
+
+  $SelectedUsers = '';  
+  foreach($Setting['users-selection'] as $Item)
+    $SelectedUsers .= ','.$Item;
+  $SelectedUsers = substr($SelectedUsers, 1);
+
+  if($SelectedUsers == '') $Where = 0;
+    else $Where = 'ID IN ('.$SelectedUsers.')';
+  
+  $UserNames = '';
+  $DbResult = $Database->SQLCommand('SELECT user FROM `user` WHERE '.$Where);
+  while($DbRow = mysql_fetch_assoc($DbResult))
+    $UserNames .= ','.$DbRow['user'];
+  $UserNames = substr($UserNames, 1);    
+   
+  if($SelectedUsers == '') $WhereUsers = 1; 
+    else $WhereUsers = '(User IN ('.$SelectedUsers.'))';
+  
+  foreach($TranslationTree as $Group)
+  if(in_array($Group['Id'], $Setting['groups']) and ($Group['DBCFileName'] != '')) 
+  { 
+        echo($Group['Name'].'... ');
+    $DBCFile = new DBCFile();
+    $DBCFile->OpenFile('dbc/'.$Group['DBCFileName'].'.dbc', $Group['DBCColumns']);
+    $DBCFile2 = new DBCFile();
+    $DBCFile2->CreateFile($TempDir.$Group['DBCFileName'].'.dbc', $Group['DBCColumns']);
+        $Count = $DBCFile->GetRecordCount();
+        //if($Group['DBCFileName'] == 'Spell') $Count = 1000;
+        $Line = $DBCFile->GetLine(0);
+    $DBCFile2->SetRecordCount($Count);   
+    for($I = 0; $I < $Count; $I++)
+    {
+      $Line = $DBCFile->GetLine($I);
+          //print_r($Line);
+          $Query = 'SELECT * FROM (SELECT * FROM '.$Group['TablePrefix'].' WHERE (Complete = 1) AND '.$WhereLang.' AND '.$WhereUsers.' AND (entry='.$Line[0].') ORDER BY FIELD(User, '.$SelectedUsers.')) AS T GROUP BY T.entry';       
+          $DbResult = $Database->SQLCommand($Query);
+          if(mysql_num_rows($DbResult) > 0)
+          {
+            $DbRow = mysql_fetch_assoc($DbResult);
+        //  if($Setting['Diacritics'] != 1) $Buffer = utf2ascii($Buffer);
+
+        //foreach($Group['Items'] as $GroupItem)
+            //  if($GroupItem['DBCColumnIndex'] != '')
+            //    $Line[$GroupItem['DBCColumnIndex']] = $DbRow[$GroupItem['Column']];
+          }
+      $DBCFile2->SetLine($I, $Line);
+          echo('.');
+    }
+    $DBCFile2->Commit();
+    echo('Hotovo <br />');
+  }
+}
+
 ?>