Changeset 68 for trunk/export.php

Timestamp:

Feb 6, 2009, 8:41:20 AM (16 years ago)

Author:

george

Message:

• Přidáno: Možnost výstupu překladů v XML formátu ke zobrazení nebo v ZIP souboru.

File:

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

trunk/export.php

@@ -1 +1 @@
 <?php
 
-function Export($Setting)
+function ExportToMangosSQL($Setting)
 {
   global $Database, $Config, $TranslationTree;
@@ -24 +24 @@
   $SelectedUsers = substr($SelectedUsers, 1);
 
+  if($SelectedUsers == '') $Where = 0;
+    else $Where = 'ID IN ('.$SelectedUsers.')';
+  
   $UserNames = '';
-  $DbResult = $Database->SQLCommand("SELECT user FROM `user` WHERE ID IN (".$SelectedUsers.')');
+  $DbResult = $Database->SQLCommand('SELECT user FROM `user` WHERE '.$Where);
   while($DbRow = mysql_fetch_assoc($DbResult))
     $UserNames .= ','.$DbRow['user'];
@@ -78 +81 @@
 }
   
-      
+function ExportToXML($Setting)
+{
+  global $Database, $Config, $TranslationTree;
+  
+  $AnoNe = array('Ne', 'Ano');
+  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.'))';
+
+  $Buffer = '<?xml version="1.0" encoding="utf-8"?>'."\n".
+  "<document>\n".
+  "  <meta>\n".
+  "    <projecturl>".$Config['Web']['BaseURL']."</projecturl>\n".
+  "    <time>".date('r')."</time>\n".
+  "    <diacritics mode=".'"'.$Setting['Diacritics'].'"'." />\n".
+  "    <author>".$User['user']."</author>\n".
+  "    <contributors>\n";
+  foreach(explode(',', $UserNames) as $UserName)
+    $Buffer .= "      <user>".$UserName."</user>\n";
+  $Buffer .= 
+  "    </contributors>\n".
+  "  </meta>\n".
+  "  <translation>\n";
+
+  foreach($TranslationTree as $Group)
+  if(in_array($Group['Id'], $Setting['groups'])) 
+  { 
+        if($Group['MangosTable'] == '')
+        {
+          $Group['MangosTable'] = $Group['TablePrefix'];
+          $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';     
+    //echo($Query);
+    $Buffer .= '    <group id="'.$Group['Id'].'" name="'.$Group['TablePrefix'].'">'."\n";
+    $ID = $Database->SQLCommand($Query);
+    while($Line = mysql_fetch_array($ID)) 
+    {
+      $Buffer .= '      <item id="'.$Line['entry'].'" user="'.$Line['UserName'].'">'."\n";
+          $Values = '';
+          foreach($Group['Items'] as $GroupItem)
+          {
+            if($GroupItem['MangosColumn'] == '') $GroupItem['MangosColumn'] = $GroupItem['Column'];
+                if($Line[$GroupItem['Column']] != '')
+                  $Buffer .= '        <text index="'.$GroupItem['Id'].'" name="'.$GroupItem['Column'].'">'.addslashes($Line[$GroupItem['Column']]).'</text>'."\n";
+          }
+          $Buffer .= "      </item>\n";
+    }    
+        $Buffer .= "    </group>\n";
+  }
+  if($Setting['Diacritics'] != 1) $Buffer = utf2ascii($Buffer);
+  $Buffer .= "  </translation>\n".
+  "</document>";
+  return($Buffer);
+}      
 ?>