Changeset 576 for trunk

Timestamp:

09/02/08 16:08:00 (3 months ago)

Author:

sidtheduck

Message:

+ Adding debug information for tracking SQL queries and benchmark timing function ( define('PLOGGER_DEBUG', '1') in plog-config.php to use)

Location:

trunk

Files:

• plog-includes/plog-functions.php (modified) (3 diffs)
• plog-load-config.php (modified) (1 diff)

trunk/plog-includes/plog-functions.php

@@ -497 +497 @@
 function run_query($query) {
         global $PLOGGER_DBH;
+
+        if (defined('PLOGGER_DEBUG') && PLOGGER_DEBUG == '1') {
+                $GLOBALS['query_count']++;
+                $GLOBALS['queries'][] = $query;
+        }
 
         $result = @mysql_query($query, $PLOGGER_DBH);
@@ -1451 +1456 @@
 }
 
+function plog_timer($time = 'start') {
+        if (defined('PLOGGER_DEBUG') && PLOGGER_DEBUG == '1') {
+                global $plog_start_time;
+
+                $mtime = microtime(); 
+                $mtime = explode(' ', $mtime); 
+                $mtime = $mtime[1] + $mtime[0];
+                if ($time == 'end') {
+                        return 'Page created in ' . ($mtime-$plog_start_time) . ' seconds';
+                } else {
+                        return $mtime;
+                }
+        }
+}
+
 function plogger_init() {
         global $config;
@@ -1929 +1949 @@
                 include($config['basedir'] . 'plog-content/themes/default/footer.php');
         }
+        if (defined('PLOGGER_DEBUG') && PLOGGER_DEBUG == '1') {
+                trace('Queries: '.$GLOBALS['query_count']);
+                foreach ($GLOBALS['queries'] as $q) {
+                        trace($q);
+                }
+                trace(plog_timer('end'));
+        }
 }
 

trunk/plog-load-config.php

@@ -29 +29 @@
 }
 require_once(PLOGGER_DIR."plog-includes/plog-functions.php");
+
+if (defined('PLOGGER_DEBUG') && PLOGGER_DEBUG == '1') {
+        $GLOBALS['query_count'] = 0;
+        $GLOBALS['queries'] = array();
+        $plog_start_time = plog_timer();
+}
+
 connect_db();