Changeset 542

Timestamp:

Jun 17, 2013, 10:42:13 AM (11 years ago)

Author:

chronos

Message:

• Přidáno: Možnost zaznamenávat všechny SQL povely do souboru.

Location:

trunk

Files:

• admin/DefaultConfig.php (modified) (1 diff)
• includes/Database.php (modified) (2 diffs)
• includes/Page.php (modified) (1 diff)
• includes/Version.php (modified) (1 diff)
• includes/system.php (modified) (1 diff)

trunk/admin/DefaultConfig.php

@@ -24 +24 @@
     'ShowSQLQuery' => false,
     'ShowSQLError' => $IsDeveloper,
-    'ShowPHPError' => $IsDeveloper,
-    'ShowRuntimeInfo' => $IsDeveloper,
+    'LogSQLQuery' => $IsDeveloper,
+        'ShowPHPError' => $IsDeveloper,
+        'ShowRuntimeInfo' => $IsDeveloper,
     'FormatOutput' => $IsDeveloper,
         'ItemsPerPage' => 40,

trunk/includes/Database.php

@@ -28 +28 @@
 class Database
 {
-  var $Prefix = '';
-  var $Functions = array('NOW()', 'CURDATE()', 'CURTIME()', 'UUID()');
-  var $Type = 'mysql';  // mysql, pgsql
+  var $Prefix;
+  var $Functions;
+  var $Type;  
   var $PDO;
-  var $Error = '';
+  var $Error;
   var $insert_id;
-  var $LastQuery = '';
-  var $ShowSQLError = false;
-  var $ShowSQLQuery = false;
+  var $LastQuery;
+  var $ShowSQLError;
+  var $ShowSQLQuery;
+  var $LogFile;
   
   function __construct()
   {    
+        $this->Functions = array('NOW()', 'CURDATE()', 'CURTIME()', 'UUID()');
+        $this->Type = 'mysql'; // mysql, pgsql
+        $this->ShowSQLError = false;
+        $this->ShowSQLQuery = false;
+        $this->LogSQLQuery = false;
+        $this->LogFile = 'Query.log';
   }
   
@@ -60 +67 @@
     if($this->ShowSQLQuery == true) 
       echo('<div style="border-bottom-width: 1px; border-bottom-style: solid; padding-bottom: 3px; padding-top: 3px; font-size: 12px; font-family: Arial;">'.$Query.'</div>'."\n");
+    if($this->LogSQLQuery == true)
+      file_put_contents($this->LogFile, $Query."\n", FILE_APPEND);
     $Result = new DatabaseResult();
     $Result->PDOStatement = $this->PDO->query($Query);

trunk/includes/Page.php

@@ -234 +234 @@
 
   $Output = '<strong>Překladové skupiny:</strong><br /><div id="TranslationMenu">';
-  $DbResult = $System->Database->select('Group', 'Id, Name', '1 ORDER BY Name');
+  $DbResult = $System->Database->select('Group', '`Id`, `Name`', '1 ORDER BY `Name`');
   while($Group = $DbResult->fetch_assoc())
   {

trunk/includes/Version.php

@@ -1 +1 @@
 <?php
 
-$Revision = 541; // Subversion revision
+$Revision = 542; // Subversion revision
 $DatabaseRevision = 539; // Database structure revision 
-$ReleaseTime = '2013-05-27';
+$ReleaseTime = '2013-06-17';
 
 ?>

trunk/includes/system.php

@@ -39 +39 @@
     $this->Database->ShowSQLQuery = $this->Config['Web']['ShowSQLQuery'];
     $this->Database->ShowSQLError = $this->Config['Web']['ShowSQLError'];
+    $this->Database->LogSQLQuery = $this->Config['Web']['LogSQLQuery'];
   }