Changeset 769

Timestamp:

Jan 31, 2014, 12:23:31 AM (11 years ago)

Author:

chronos

Message:

• Added: Log query duration to sql log file.

Location:

trunk

Files:

• Modules/User/Profile.php (modified) (1 diff)
• includes/Database.php (modified) (1 diff)
• includes/Version.php (modified) (1 diff)

trunk/Modules/User/Profile.php

@@ -129 +129 @@
                 $Output .= '</div>';
                 return($Output);
-
-        return($Output);
   }
                 

trunk/includes/Database.php

@@ -63 +63 @@
   function query($Query)
   {
-        if($this->ShowSQLQuery == true) $QueryStartTime = microtime();
+        if(($this->ShowSQLQuery == true) or ($this->LogSQLQuery == true)) $QueryStartTime = microtime();
     $this->LastQuery = $Query;
-    if($this->LogSQLQuery == true)
-      file_put_contents($this->LogFile, $Query."\n", FILE_APPEND);
     $Result = new DatabaseResult();
     $Result->PDOStatement = $this->PDO->query($Query);
+    if(($this->ShowSQLQuery == true) or ($this->LogSQLQuery == true)) 
+      $Duration = ' ; '.(microtime() - $QueryStartTime). ' s';
+    if($this->LogSQLQuery == true)
+      file_put_contents($this->LogFile, $Query.$Duration."\n", FILE_APPEND);
     if($this->ShowSQLQuery == true)
-    { 
-        $Duration = ' ; '.(microtime() - $QueryStartTime). ' s';
       echo('<div style="border-bottom-width: 1px; border-bottom-style: solid; padding-bottom: 3px; padding-top: 3px; font-size: 12px; font-family: Arial;">'.$Query.$Duration.'</div>'."\n");
-    }
     if($Result->PDOStatement)
     {

trunk/includes/Version.php

@@ -6 +6 @@
 // and system will need database update. 
 
-$Revision = 769; // Subversion revision
+$Revision = 770; // Subversion revision
 $DatabaseRevision = 748; // Database structure revision 
-$ReleaseTime = '2014-01-27';
+$ReleaseTime = '2014-01-30';