messages = array(); $this->explain_messages = array(); } /** * * @param type $sql * @param type $time * @param type $errorLevel * @param type $errorDescription */ public function addMessage($sql, $time, $errorLevel, $errorDescription) { $this->messages[] = array( 'query' => $sql, 'query_time' => $time, 'errno' => $errorLevel, 'error' => $errorDescription ); } /** * * @param type $sql * @param type $time * @param type $errorLevel * @param type $errorDescription */ public function addExplainMessage($sql, $results) { $this->explain_messages[] = array( 'query' => $sql, 'explain' => $results ); } /** * */ public function printMessages() { echo '

' . PHP_EOL; echo '

  Database queries (Total queries: ' . $this->getTotalNumberQueries() .' - Total queries time: ' . $this->getTotalQueriesTime() . ')  

' . PHP_EOL; echo '' . PHP_EOL; if( count($this->messages) == 0 ) { echo '' . PHP_EOL; } else { foreach($this->messages as $msg) { $row_style = ''; if( $msg['errno'] != 0 ) { $row_style = 'style="background-color: #FFC2C2;"'; } echo '' . PHP_EOL; echo '' . PHP_EOL; echo '' . PHP_EOL; echo '' . PHP_EOL; } } echo '

No queries
' . $msg['query_time'] . '	'; if( $msg['errno'] != 0 ) { echo 'Error number: ' . $msg['errno'] . ' '; echo 'Error description: ' . $msg['error'] . ' '; } echo nl2br($msg['query']); echo '

' . PHP_EOL; echo '

' . PHP_EOL; } function writeMessages() { $filename = CONTENT_PATH . 'queries.log'; if( !file_exists($filename) || !is_writable($filename) ) { return false; } $fp = fopen($filename, 'a'); if( $fp == false ) { return false; } fwrite($fp, '==================================================' . PHP_EOL); if(MULTISITE) { fwrite($fp, '=' . str_pad('Date: ' . date('Y-m-d').' '.date('H:i:s'), 48, " ", STR_PAD_BOTH) . '=' . PHP_EOL); } else { fwrite($fp, '=' . str_pad('Date: ' . date(osc_date_format()!=''?osc_date_format():'Y-m-d').' '.date(osc_time_format()!=''?osc_date_format():'H:i:s'), 48, " ", STR_PAD_BOTH) . '=' . PHP_EOL); } fwrite($fp, '=' . str_pad('Total queries: ' . $this->getTotalNumberQueries(), 48, " ", STR_PAD_BOTH) . '=' . PHP_EOL); fwrite($fp, '=' . str_pad('Total queries time: ' . $this->getTotalQueriesTime(), 48, " ", STR_PAD_BOTH) . '=' . PHP_EOL); fwrite($fp, '==================================================' . PHP_EOL . PHP_EOL); foreach($this->messages as $msg) { fwrite($fp, 'QUERY TIME' . ' ' . $msg['query_time'] . PHP_EOL); if( $msg['errno'] != 0 ) { fwrite($fp, 'Error number: ' . $msg['errno'] . PHP_EOL); fwrite($fp, 'Error description: ' . $msg['error'] . PHP_EOL); } fwrite($fp, '**************************************************' . PHP_EOL); fwrite($fp, $msg['query'] . PHP_EOL); fwrite($fp, '--------------------------------------------------' . PHP_EOL); } fwrite($fp, PHP_EOL . PHP_EOL. PHP_EOL); fclose($fp); return true; } function writeExplainMessages() { $filename = CONTENT_PATH . 'explain_queries.log'; if( !file_exists($filename) || !is_writable($filename) ) { return false; } $fp = fopen($filename, 'a'); if( $fp == false ) { return false; } fwrite($fp, '==================================================' . PHP_EOL); if(MULTISITE) { fwrite($fp, '=' . str_pad('Date: ' . date('Y-m-d').' '.date('H:i:s'), 48, " ", STR_PAD_BOTH) . '=' . PHP_EOL); } else { fwrite($fp, '=' . str_pad('Date: ' . date(osc_date_format()?osc_date_format():'Y-m-d').' '.date(osc_time_format()?osc_time_format():'H:i:s'), 48, " ", STR_PAD_BOTH) . '=' . PHP_EOL); } fwrite($fp, '==================================================' . PHP_EOL . PHP_EOL); $title = '|' . str_pad('id', 3, " ", STR_PAD_BOTH) . '|'; $title .= str_pad('select_type', 20, " ", STR_PAD_BOTH) . '|'; $title .= str_pad('table', 20, " ", STR_PAD_BOTH) . '|'; $title .= str_pad('type', 8, " ", STR_PAD_BOTH) . '|'; $title .= str_pad('possible_keys', 28, " ", STR_PAD_BOTH) . '|'; $title .= str_pad('key', 18, " ", STR_PAD_BOTH) . '|'; $title .= str_pad('key_len', 9, " ", STR_PAD_BOTH) . '|'; $title .= str_pad('ref', 48, " ", STR_PAD_BOTH) . '|'; $title .= str_pad('rows', 8, " ", STR_PAD_BOTH) . '|'; $title .= str_pad('Extra', 38, " ", STR_PAD_BOTH) . '|'; for($i = 0; $i < count($this->explain_messages); $i++) { fwrite($fp, $this->explain_messages[$i]['query'] . PHP_EOL); fwrite($fp, str_pad('', 211, "-", STR_PAD_BOTH) . PHP_EOL); fwrite($fp, $title . PHP_EOL); fwrite($fp, str_pad('', 211, "-", STR_PAD_BOTH) . PHP_EOL); foreach($this->explain_messages[$i]['explain'] as $explain) { $row = '|' . str_pad($explain['id'], 3, " ", STR_PAD_BOTH) . '|'; $row .= str_pad($explain['select_type'], 20, " ", STR_PAD_BOTH) . '|'; $row .= str_pad($explain['table'], 20, " ", STR_PAD_BOTH) . '|'; $row .= str_pad($explain['type'], 8, " ", STR_PAD_BOTH) . '|'; $row .= str_pad($explain['possible_keys'], 28, " ", STR_PAD_BOTH) . '|'; $row .= str_pad($explain['key'], 18, " ", STR_PAD_BOTH) . '|'; $row .= str_pad($explain['key_len'], 9, " ", STR_PAD_BOTH) . '|'; $row .= str_pad($explain['ref'], 48, " ", STR_PAD_BOTH) . '|'; $row .= str_pad($explain['rows'], 8, " ", STR_PAD_BOTH) . '|'; $row .= str_pad($explain['Extra'], 38, " ", STR_PAD_BOTH) . '|'; fwrite($fp, $row . PHP_EOL); fwrite($fp, str_pad('', 211, "-", STR_PAD_BOTH) . PHP_EOL); } if( $i != ( count($this->explain_messages) - 1 ) ) { fwrite($fp, PHP_EOL . PHP_EOL); } } fwrite($fp, PHP_EOL . PHP_EOL); fclose($fp); return true; } public function getTotalQueriesTime() { $time = 0; foreach($this->messages as $m) { $time = $time + $m['query_time']; } return $time; } public function getTotalNumberQueries() { return count($this->messages); } } /* file end: ./oc-includes/osclass/Logger/LogDatabase.php */ ?>