Changeset 178 for trunk/export/export.php

Timestamp:

Apr 11, 2009, 12:34:37 PM (16 years ago)

Author:

maron

Message:

Export do AoWoW ke stažení

File:

• trunk/export/export.php (modified) (1 diff)

trunk/export/export.php

@@ -80 +80 @@
   return($Buffer);
 }
+  
+function ExportToAoWoWSQL($Setting) {
+  global $Database, $Config, $TranslationTree,$AoWoWconf;
+                require_once('../aowow/configs/config.php');
+        
+    $Buffer = ExportToMangosSQL($Setting);
+ 
+   $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.'))';
+
+
+        //data to aowow
+
+        $Database->SelectDatabase($AoWoWconf['mangos']['db']);    
+        $Database->SQLCommand('SET NAMES '.$Config['Database']['Charset']);
+    $AoWoWTables = array('aowow_resistances', 'aowow_spelldispeltype', 'aowow_skill');
+        foreach($AoWoWTables as $AoWoWTable) {
+        $Buffer .= $AoWoWTable.', ';
+                $Buffer .= "\n\n";  
+            $Query = 'SELECT name FROM '.$AoWoWTable;
+        $ID = $Database->SQLCommand($Query);
+                while($Line = mysql_fetch_assoc($ID)) {
+                $Tran = mysql_fetch_assoc($Database->SQLCommand('SELECT text as en,
+                (SELECT text FROM '.$Config['Database']['Database'].'.global_strings as tabletran
+                 WHERE tableen.entry = tabletran.entry AND (Complete = 1) AND '.$WhereLang.'
+                  AND '.$WhereUsers.' ORDER BY FIELD(User, '.$SelectedUsers.') LIMIT 1) as tran
+                 FROM '.$Config['Database']['Database'].'.global_strings as tableen WHERE
+                  text = "'.addslashes($Line['name']).'" LIMIT 1'));
+                        //echo ($Line['name'].'='.$Tran['tran']);
+                        if ($Tran['tran'] <> '')
+                                $Buffer .= 'UPDATE `'.$AoWoWTable.'` SET name = "'.addslashes($Tran['tran']).'" WHERE name = "'.addslashes($Line['name']).'";'."\n";
+                }
+                $Buffer .= "\n\n";  
+        }
+        return($Buffer);
+}  
+ 
   
 function ExportToXML($Setting)