X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=include%2Fdba.php;h=dae14559312d00ebb1b8bf8a358ccecd40380e5f;hb=4b0e370c4c2ec606833aa326fba49922a7c470ab;hp=879d7e67e12d33c1c997faa6edcd4a57797dba20;hpb=082ad499c6bceadb2a1bc5127229bd0f86ee3895;p=friendica.git diff --git a/include/dba.php b/include/dba.php index 879d7e67e1..dae1455931 100644 --- a/include/dba.php +++ b/include/dba.php @@ -23,6 +23,9 @@ class dba { public $error = false; function __construct($server,$user,$pass,$db,$install = false) { + global $a; + + $stamp1 = microtime(true); $server = trim($server); $user = trim($user); @@ -64,6 +67,8 @@ class dba { if(! $install) system_unavailable(); } + + $a->save_timestamp($stamp1, "network"); } public function getdb() { @@ -78,18 +83,21 @@ class dba { $this->error = ''; - if ($a->config["system"]["db_log"] != "") - $stamp1 = microtime(true); + $stamp1 = microtime(true); if($this->mysqli) $result = @$this->db->query($sql); else $result = @mysql_query($sql,$this->db); - if ($a->config["system"]["db_log"] != "") { - $stamp2 = microtime(true); - $duration = round($stamp2-$stamp1, 3); - if ($duration > $a->config["system"]["db_loglimit"]) { + $stamp2 = microtime(true); + $duration = (float)($stamp2-$stamp1); + + $a->save_timestamp($stamp1, "database"); + + if(x($a->config,'system') && x($a->config['system'],'db_log')) { + if (($duration > $a->config["system"]["db_loglimit"])) { + $duration = round($duration, 3); $backtrace = debug_backtrace(DEBUG_BACKTRACE_IGNORE_ARGS); @file_put_contents($a->config["system"]["db_log"], $duration."\t". basename($backtrace[1]["file"])."\t". @@ -162,6 +170,7 @@ class dba { } } + //$a->save_timestamp($stamp1, "database"); if($this->debug) logger('dba: ' . printable(print_r($r, true))); @@ -231,9 +240,10 @@ function q($sql) { unset($args[0]); if($db && $db->connected) { - $stmt = vsprintf($sql,$args); + $stmt = @vsprintf($sql,$args); // Disabled warnings + //logger("dba: q: $stmt", LOGGER_ALL); if($stmt === false) - logger('dba: vsprintf error: ' . print_r(debug_backtrace(),true)); + logger('dba: vsprintf error: ' . print_r(debug_backtrace(),true), LOGGER_DEBUG); return $db->q($stmt); }