Changeset 52 for trunk

Timestamp:

Feb 2, 2009, 7:14:45 PM (16 years ago)

Author:

george

Message:

• Opraveno: Zobrazení počtu překladů v tabulce uživatelů ve statistice.

Location:

trunk

Files:

• client_files/export_fo_file.php (modified) (1 diff)
• statistic.php (modified) (1 diff)

trunk/client_files/export_fo_file.php

@@ -1 +1 @@
 <?php
 
-  session_start();
-  include('../includes/config.php');
-  include('../includes/databaseconection.php');
-  include('../includes/global_function.php');
+session_start();
+include('../includes/config.php');
+include('../includes/databaseconection.php');
+include('../includes/global_function.php');
 
   //připojení do databáze
-  $Database = new Database($Config['Database']['Host'], $Config['Database']['User'], $Config['Database']['Password']); 
-  $Database->SQLCommand('SET NAMES '.$Config['Database']['Charset']);
-  $Database->SelectDatabase($Config['Database']['Database']);    
+$Database = new Database($Config['Database']['Host'], $Config['Database']['User'], $Config['Database']['Password']); 
+$Database->SQLCommand('SET NAMES '.$Config['Database']['Charset']);
+$Database->SelectDatabase($Config['Database']['Database']);    
   
-  if (Licence(2)) {  // echo 'Přístup povolen'; 
-  } else { die('Přístup zamítnut!'); }
+if(Licence(LICENCE_ADMIN)) 
+{  
+} else die('Přístup zamítnut!');
   
-  //const
-     $save_filename = '_export/LocalizationStrings.lua';
+$save_filename = '_export/LocalizationStrings.lua';
 
-  //funkce 
-    function RepairText($text)
-    { // BEGIN function RepairText
-         $text = mysql_escape_string($text);
-         return $text;
-    } // END function RepairText
+function RepairText($text)
+{
+  $text = mysql_escape_string($text);
+  return $text;
+}
 
+$Buffer = "local f=function(name, en, ru) RuWoW_interface[name]=ru; RuWoW_interface_entoname[en]=name; end; RuWoW_interface={ };RuWoW_interface_entoname={ };\n";
+$sql = "SELECT * FROM client_text WHERE Language = '0' AND File = 0";
+$ID = $Database->SQLCommand($sql);
+while($Line = mysql_fetch_array($ID)) 
+{
+  $id_text = RepairText($Line['id_text']);
+  $text = RepairText($Line['text']);            
+ 
+  $Buffer .= 'f("'.$id_text.'", "'.$text.'", "test");'."\n";
+}
 
+$file_handle = fopen($save_filename, 'w');
+$write_result = fwrite($file_handle, $Buffer);
+fclose($file_handle);
 
-      $Buffer = "local f=function(name, en, ru) RuWoW_interface[name]=ru; RuWoW_interface_entoname[en]=name; end; RuWoW_interface={ };RuWoW_interface_entoname={ };
-";
-      $sql = "SELECT * FROM client_text WHERE Language = '0' AND File = 0";
-        $ID = $Database->SQLCommand($sql);
-          while ($Line = mysql_fetch_array($ID)) {
-            
-            $id_text = RepairText($Line['id_text']);
-            $text = RepairText($Line['text']);            
-          
-            $Buffer .= 'f("'.$id_text.'", "'.$text.'", "test");
-';
-          }
-
-        $file_handle = fopen($save_filename, 'w');
-        $write_result = fwrite($file_handle, $Buffer);
-        fclose($file_handle);
-
-      echo 'Exportování LocalizationStrings.lua: <b>hotovo</b>';
-
+echo('Exportování LocalizationStrings.lua: <b>hotovo</b>');
 
 ?>

trunk/statistic.php

@@ -46 +46 @@
 
 $Query = 'SELECT ID,user, LastLogin, GM, (';
-foreach($TranslationTree as $Group);
+foreach($TranslationTree as $Group)
   if($Group['TablePrefix'] != '')
     $Query .= '(SELECT count(*) FROM `'.$Group['TablePrefix'].'` WHERE User = user.ID AND Complete = 1 AND Language <> 0) + ';