1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
|
<?php
/** Log all queries to SQL file
* @link https://www.adminer.org/plugins/#use
* @author Jakub Vrana, https://www.vrana.cz/
* @license https://www.apache.org/licenses/LICENSE-2.0 Apache License, Version 2.0
* @license https://www.gnu.org/licenses/gpl-2.0.html GNU General Public License, version 2 (one or other)
*/
class AdminerSqlLog extends Adminer\Plugin {
protected $filename;
/**
* @param string $filename defaults to "$database.sql"
*/
function __construct($filename = "") {
$this->filename = $filename;
}
function messageQuery($query, $time, $failed = false) {
$this->log($query);
}
function sqlCommandQuery($query) {
$this->log($query);
}
private function log($query) {
if ($this->filename == "") {
$this->filename = Adminer\adminer()->database() . ($_GET["ns"] != "" ? ".$_GET[ns]" : "") . ".sql"; // no database goes to ".sql" to avoid collisions
}
$fp = fopen($this->filename, "a");
flock($fp, LOCK_EX);
fwrite($fp, $query);
fwrite($fp, "\n\n");
flock($fp, LOCK_UN);
fclose($fp);
}
protected $translations = array(
'cs' => array('' => 'Zaznamenává všechny příkazy do souboru SQL'),
'de' => array('' => 'Protokollieren Sie alle Abfragen in einer SQL-Datei'),
'pl' => array('' => 'Rejestruj wszystkie zapytania do pliku SQL'),
'ro' => array('' => 'Logați toate interogările în fișierul SQL'),
'ja' => array('' => '全クエリを SQL ファイルに記録'),
);
}
|
