Changeset 231 for trunk/export/export.php

Timestamp:

Jul 2, 2009, 8:19:35 PM (15 years ago)

Author:

maron

Message:

úprava exportu sql podle verze, u exportu mangosu exportuje pouze tabulky mangosu

File:

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

trunk/export/export.php

@@ -56 +56 @@
   if(in_array($Group['Id'], $Setting['groups'])) 
   { 
-        if($Group['MangosTable'] == '')
+        if($Group['MangosTable'] != '')
         {
-          $Group['MangosTable'] = $Group['TablePrefix'];
-          $Group['MangosTableIndex'] = 'entry';
-        }
-    $Query = 'SELECT * FROM (SELECT * FROM '.$Group['TablePrefix'].' WHERE (Complete = 1) AND '.$WhereLang.' AND '.$WhereUsers.' ORDER BY FIELD(User, '.$SelectedUsers.')) AS T GROUP BY T.entry';
-    //echo($Query);
-    $Buffer .= "\n\n-- ".$Group['Name']."\n\n";
-    $ID = $Database->SQLCommand($Query);
-    while($Line = mysql_fetch_array($ID)) 
-    {
-          $Values = '';
-          foreach($Group['Items'] as $GroupItem)
-          {
-            if($GroupItem['MangosColumn'] == '') $GroupItem['MangosColumn'] = $GroupItem['Column'];
-            $Values .= ', `'.$GroupItem['MangosColumn'].'`="'.addslashes($Line[$GroupItem['Column']]).'"';
-          }
-      $Values = substr($Values, 2);
-      $Buffer .= 'UPDATE `'.$Group['MangosTable'].'` SET '.$Values.' WHERE `'.$Group['MangosTableIndex'].'` = '.$Line['entry'].';'."\n"; 
+      $Query = 'SELECT * FROM (SELECT * FROM '.$Group['TablePrefix'].' WHERE (Complete = 1) AND VersionStart <= '.GetBuildNumber($Setting['Version']).' AND VersionEnd >= '.GetBuildNumber($Setting['Version']).' AND '.$WhereLang.' AND '.$WhereUsers.' ORDER BY FIELD(User, '.$SelectedUsers.')) AS T GROUP BY T.entry';      
+      //echo($Query);
+      $Buffer .= "\n\n-- ".$Group['Name']."\n\n";
+      $ID = $Database->SQLCommand($Query);
+      while($Line = mysql_fetch_array($ID)) 
+      {
+            $Values = '';
+            foreach($Group['Items'] as $GroupItem)
+            {
+              if($GroupItem['MangosColumn'] == '') $GroupItem['MangosColumn'] = $GroupItem['Column'];
+              $Values .= ', `'.$GroupItem['MangosColumn'].'`="'.addslashes($Line[$GroupItem['Column']]).'"';
+            }
+        $Values = substr($Values, 2);
+        $Buffer .= 'UPDATE `'.$Group['MangosTable'].'` SET '.$Values.' WHERE `'.$Group['MangosTableIndex'].'` = '.$Line['entry'].';'."\n"; 
+      }
     }    
   }
@@ -218 +216 @@
           $Group['MangosTableIndex'] = 'entry';
         }
-    $Query = 'SELECT *,(SELECT user FROM user WHERE user.ID=T.User) as UserName FROM (SELECT * FROM '.$Group['TablePrefix'].' WHERE (Complete = 1) AND '.$WhereLang.' AND '.$WhereUsers.' ORDER BY FIELD(User, '.$SelectedUsers.')) AS T GROUP BY T.entry';     
+    $Query = 'SELECT *,(SELECT user FROM user WHERE user.ID=T.User) as UserName FROM (SELECT * FROM '.$Group['TablePrefix'].' WHERE (Complete = 1) AND VersionStart <= '.GetBuildNumber($Setting['Version']).' AND VersionEnd >= '.GetBuildNumber($Setting['Version']).' AND '.$WhereLang.' AND '.$WhereUsers.' ORDER BY FIELD(User, '.$SelectedUsers.')) AS T GROUP BY T.entry';       
     //echo($Query);
     $Buffer .= '    <group id="'.$Group['Id'].'" name="'.$Group['TablePrefix'].'">'."\n";