1 |
a505dbd9
|
Andreas Kohlbecker
|
<?php
|
2 |
|
|
/**
|
3 |
|
|
* Created by PhpStorm.
|
4 |
|
|
* User: andreas
|
5 |
|
|
* Date: 11.01.18
|
6 |
|
|
* Time: 12:39
|
7 |
|
|
*
|
8 |
|
|
* Execute .e.g as
|
9 |
|
|
*
|
10 |
|
|
* php db_debug.php.inc sites/cyprus/settings.php
|
11 |
|
|
*
|
12 |
|
|
*/
|
13 |
|
|
|
14 |
|
|
$setting_file = $argv[1];
|
15 |
|
|
|
16 |
|
|
print ("Running db_debug.php with settings from " . $setting_file . "\n");
|
17 |
|
|
require($setting_file);
|
18 |
|
|
print("db configuration:\n");
|
19 |
|
|
print_r($databases);
|
20 |
|
|
print ("trying to connect to default db ...\n");
|
21 |
|
|
$db_test_settings = $databases["default"]["default"];
|
22 |
|
|
$mysqli = mysqli_connect($db_test_settings["host"], $db_test_settings["username"], $db_test_settings["password"], $db_test_settings["database"]);
|
23 |
|
|
if ($mysqli->connect_errno) {
|
24 |
|
|
echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
|
25 |
|
|
}
|
26 |
|
|
echo "Connection opened: " . $mysqli->host_info . "\n";
|
27 |
|
|
|
28 |
|
|
$res = $mysqli->query("SELECT * FROM " .$db_test_settings["prefix"]. "system");
|
29 |
|
|
|
30 |
|
|
echo "system table ...\n";
|
31 |
|
|
for ($row_no = $res->num_rows - 1; $row_no >= 0; $row_no--) {
|
32 |
|
|
$res->data_seek($row_no);
|
33 |
|
|
$row = $res->fetch_assoc();
|
34 |
|
|
echo " filename = " . $row['filename'] . "\n";
|
35 |
|
|
}
|
36 |
|
|
|