Changeset 230

Timestamp:

Jul 2, 2009, 7:24:10 PM (15 years ago)

Author:

maron

Message:

export lua a dbc podle verze

File:

• trunk/export/export.php (modified) (4 diffs)

trunk/export/export.php

@@ -284 +284 @@
         echo($Group['Name'].'... ');
     $DBCFile = new DBCFile();
-    $DBCFile->OpenFile('../source/'.$Config['Web']['GameVersion'].'/dbc/'.$Group['DBCFileName'].'.dbc', $Group['DBCColumns']);
+    $DBCFile->OpenFile('../source/'.$Setting['Version'].'/dbc/'.$Group['DBCFileName'].'.dbc', GetDBCColumns($Setting['Version'],$Group['DBCFileName']));
     $DBCFile2 = new DBCFile();
-    $DBCFile2->CreateFile($TempDir.$Group['DBCFileName'].'.dbc', $Group['DBCColumns']);
+    $DBCFile2->CreateFile($TempDir.$Group['DBCFileName'].'.dbc', GetDBCColumns($Setting['Version'],$Group['DBCFileName']));
         $Count = $DBCFile->GetRecordCount();
         //if($Group['DBCFileName'] == 'Spell') $Count = 1000;
@@ -294 +294 @@
     {
       $Line = $DBCFile->GetLine($I);
-          $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';       
+          $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);
           if(mysql_num_rows($DbResult) > 0)
@@ -356 +356 @@
         echo($Group['Name'].'... ');
     $File = new FileStream();
-    $File->OpenFile('../source/'.$Config['Web']['GameVersion'].'/lua/'.$Group['LuaFileName'].'.lua');
+    $File->OpenFile('../source/'.$Setting['Version'].'/lua/'.$Group['LuaFileName'].'.lua');
     $File2 = new FileStream();
-    $File2->CreateFile($TempDir.$Group['LuaMPQFolder'].'/'.$Group['LuaFileName'].'.lua');
+    $File2->CreateFile($TempDir.''.$Group['LuaFileName'].'.lua');
 
     while(!$File->EOF())
@@ -371 +371 @@
                 $Value['Comment'] = addslashes(substr(trim($LineParts[1]), 3));
 
-            $Query = 'SELECT * FROM (SELECT * FROM '.$Group['TablePrefix'].' WHERE (Complete = 1) AND '.$WhereLang.' AND '.$WhereUsers.' AND (ShortCut="'.$Value['ShortCut'].'") ORDER BY FIELD(User, '.$SelectedUsers.')) AS T GROUP BY T.entry';
+            $Query = 'SELECT * FROM (SELECT * FROM '.$Group['TablePrefix'].' WHERE (Complete = 1) AND '.$WhereLang.' AND '.$WhereUsers.' AND (ShortCut="'.$Value['ShortCut'].'") AND VersionStart <= '.GetBuildNumber($Setting['Version']).' AND VersionEnd >= '.GetBuildNumber($Setting['Version']).' ORDER BY FIELD(User, '.$SelectedUsers.')) AS T GROUP BY T.entry';
                 //echo($Query);
             $DbResult = $Database->SQLCommand($Query);