Changeset 66

Timestamp:

Feb 5, 2009, 11:22:27 AM (16 years ago)

Author:

george

Message:

• Upraveno: Export do SQL rozšířen i na tabulky, které nejsou importovány z databáze MaNGOSu.

Location:

trunk

Files:

• download-addon.php (deleted)
• export.php (modified) (3 diffs)
• save.php (modified) (1 diff)

trunk/export.php

@@ -24 +24 @@
   $SelectedUsers = substr($SelectedUsers, 1);
 
+  $UserNames = '';
   $DbResult = $Database->SQLCommand("SELECT user FROM `user` WHERE ID IN (".$SelectedUsers.')');
   while($DbRow = mysql_fetch_assoc($DbResult))
@@ -50 +51 @@
 
   foreach($TranslationTree as $Group)
-  if(($Group['TablePrefix'] != '') and (in_array($Group['Id'], $Setting['groups']))) 
+  if(in_array($Group['Id'], $Setting['groups'])) 
   { 
+        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);
@@ -60 +66 @@
           $Values = '';
           foreach($Group['Items'] as $GroupItem)
-            if($GroupItem['MangosColumn'] != '')
-              $Values .= ', `'.$GroupItem['MangosColumn'].'`="'.addslashes($Line[$GroupItem['Column']]).'"';
+          {
+            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"; 

trunk/save.php

@@ -35 +35 @@
         foreach($TranslationTree[$GroupId]['Items'] as $GroupItem)
         {
-          $Columns .= ', `'.$GroupItem['Column'].'`';
-          $Values .= ', "'.@$_POST[$GroupItem['Column']].'"';
+      if(array_key_exists($GroupItem['Column'], $_POST))
+          {
+                $Columns .= ', `'.$GroupItem['Column'].'`';
+            $Values .= ', "'.@$_POST[$GroupItem['Column']].'"';
+          }
         }  
         //echo('INSERT INTO `'.$Table.'` ('.$Columns.') VALUES ('.$Values.')');