Changeset 255

Timestamp:

Jul 24, 2009, 11:39:21 AM (15 years ago)

Author:

maron

Message:

Plánované úkoly stahování dbc zatím pouze admin

Location:

trunk

Files:

• download.php (modified) (1 diff)
• export/cmd.php (added)
• export/export.php (modified) (1 diff)
• export/index.php (modified) (2 diffs)
• includes/global_function.php (modified) (1 diff)
• sql/updates/255.sql (added)

trunk/download.php

@@ -76 +76 @@
 } else
 {
+        
+        
+if (Licence(LICENCE_USER)) {    
+  $ID = $Database->SQLCommand('SELECT * FROM tasks WHERE User = '.$_SESSION['UserID']);
+  if (mysql_num_rows($ID) > 0) 
+  {
+    echo ('<table  class="BaseTable"><tr><th>Datum</th><th>Vygenerováno</th><th>Staženo</th><th>Soubor</th></tr>');
+    while($Line = mysql_fetch_assoc($ID)) 
+    {
+          if ($Line['Active'] == 0)
+          {
+            $Active = 'Hotovo';
+                $Download = '<a href="'.$Config['Web']['TempFolder'].$_SESSION['User'].'/dbc/CzWoW_DBC.zip">Stáhnout - CzWoW_DBC.zip</a>';
+          } else {
+                $Active = 'Čeká na zpracování'; 
+                $Download = 'CzWoW_DBC.zip';
+          }
+          if ($Line['Downloaded'] == 1) $Downloaded = 'Staženo'; else $Downloaded = 'Nestaženo'; 
+        echo('<tr>'.
+        '<td><strong>'.$Line['Date'].'</strong></td>'.
+        '<td>'.$Active.'</td>'.
+        '<td>'.$Downloaded.'</td>'.
+        '<td>'.$Download.'</td>');
+            echo('</tr>');
+    }
+    echo('</table>');           
+  }
+}
+
   echo('
   <br />

trunk/export/export.php

@@ -281 +281 @@
   { 
         echo($Group['Name'].'... ');
-    $DBCFile = new DBCFile();
-    $DBCFile->OpenFile('../source/'.$Setting['Version'].'/dbc/'.$Group['DBCFileName'].'.dbc', GetDBCColumns($Setting['Version'],$Group['DBCFileName']));
+  //  $DBCFile = new DBCFile();
+  //  $DBCFile->OpenFile('../source/'.$Setting['Version'].'/dbc/'.$Group['DBCFileName'].'.dbc', GetDBCColumns($Setting['Version'],$Group['DBCFileName']));
+    if (copy('../source/'.$Setting['Version'].'/dbc/'.$Group['DBCFileName'].'.dbc',$TempDir.$Group['DBCFileName'].'.dbc') == false)
+          die('Nepodařilo se zkopírovat');
     $DBCFile2 = new DBCFile();
-    $DBCFile2->CreateFile($TempDir.$Group['DBCFileName'].'.dbc', GetDBCColumns($Setting['Version'],$Group['DBCFileName']));
-        $Count = $DBCFile->GetRecordCount();
+    $DBCFile2->OpenFile($TempDir.$Group['DBCFileName'].'.dbc', GetDBCColumns($Setting['Version'],$Group['DBCFileName']));
+        $Count = $DBCFile2->GetRecordCount();
         //if($Group['DBCFileName'] == 'Spell') $Count = 1000;
-        $Line = $DBCFile->GetLine(0);
+        $Line = $DBCFile2->GetLine(0);
     $DBCFile2->SetRecordCount($Count);   
     for($I = 0; $I < $Count; $I++)
     {
-      $Line = $DBCFile->GetLine($I);
+      $Line = $DBCFile2->GetLine($I);
           $Query = 'SELECT * FROM (SELECT * FROM '.$Group['TablePrefix'].' WHERE (Complete = 1) AND '.$WhereLang.' AND '.$WhereUsers.' AND (entry='.$Line[0].')  AND VersionStart <= '.GetBuildNumber($Setting['Version']).' AND VersionEnd >= '.GetBuildNumber($Setting['Version']).' ORDER BY FIELD(User, '.$SelectedUsers.')) AS T GROUP BY T.entry';        
           $DbResult = $Database->SQLCommand($Query);

trunk/export/index.php

@@ -404 +404 @@
             break;
           case 'DBC':
+          
+            echo('<br /><br /><br />U dbc souborů export textů funguje jinak, protože generování je náročné na výpočet provádí se přes noc kdy je server nejmíň vytížen. Nyní jste zadali úlohu, která se provede v noci. Zítra si můžete stáhnout vygenerovaný soubor.<br /><br />Dbc soubory je nutné zabalit do souboru data-5.MPQ uvnitř složky ... a hru spouštět přes wowme.exe');
+          
+        $Database->SQLCommand('INSERT INTO `wowpreklad`.`tasks` (`User` ,`ExportSetting` ,`Date` ) VALUES ("'.$_SESSION['User'].'", "'.addslashes(serialize($ExportSetting)).'", NOW( ))');
+                
+                
+                WriteLog('Zadání úlohy pro vygenerování dbc souboru', 2);
+            
+          
+          /*
         if(function_exists('gzcompress')) 
         {
@@ -424 +434 @@
           'Pokud se vám zdá, že filtr na export nefunguje, vymažte si vyrovnávací paměť prohlížeče a zkuste stáhnout soubor znovu.');
                 echo('<br /><br /><strong>Použití ve hře</strong><br />Ze souborů vytvořte MPQ archív a nahrajte ho do hry do podsložky Data/enUS jako patch-enUS-5.MPQ. Hru spusťte pomocí programu WoWMe.exe (WoW Model Editor Fix).');
+                */
+         
             break;
           case 'Lua':

trunk/includes/global_function.php

@@ -323 +323 @@
 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']);
+  global $Database,$DBCColumns;
+  if (isset($DBCColumns[$Version][$DBCFileName]) == false) 
+  {
+    $sql = 'SELECT DBCColumns_'.$DBCFileName.' as DBCColumns FROM `wow_client_version` WHERE Version = "'.$Version.'"';
+    $DbRow = mysql_fetch_assoc($Database->SQLCommand($sql));
+    $DBCColumns[$Version][$DBCFileName] = $DbRow['DBCColumns'];
+  }
+    return($DBCColumns[$Version][$DBCFileName]);
 }
 
 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']);
+  global $Database,$DBCColumnIndex;
+  if (isset($DBCColumnIndex[$Version][$DBCFileName][$Column]) == false) 
+  {
+    $sql = 'SELECT '.$DBCFileName.'_'.$Column.' as DBCColumns FROM `wow_client_version` WHERE Version = "'.$Version.'"';
+    $DbRow = mysql_fetch_assoc($Database->SQLCommand($sql));
+    $DBCColumnIndex[$Version][$DBCFileName][$Column] = $DbRow['DBCColumns'];
+  }
+    return($DBCColumnIndex[$Version][$DBCFileName][$Column]);
 }