File: ss_sql.php

package info (click to toggle)
cacti 0.8.6i-3
  • links: PTS
  • area: main
  • in suites: etch-m68k
  • size: 4,744 kB
  • ctags: 8,967
  • sloc: php: 39,760; sql: 2,306; xml: 678; sh: 487; perl: 133; makefile: 68
file content (35 lines) | stat: -rw-r--r-- 947 bytes parent folder | download | duplicates (2)
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
<?php

$no_http_headers = true;

/* display ALL errors */
error_reporting(0);

if (!isset($called_by_script_server)) {
	include_once(dirname(__FILE__) . "/../include/config.php");

	print call_user_func("ss_sql");
}

function ss_sql() {
	global $database_username;
	global $database_password;
	global $database_hostname;

	if ($database_password != "") {
		$result = `mysqladmin --host=$database_hostname --user=$database_username --password=$database_password status`;
	}else{
		$result = `mysqladmin --host=$database_hostname --user=$database_username status`;
	}

	$result = ereg_replace(": ", ":", $result);
	$result = ereg_replace("  ", " ", $result);
	$result = ereg_replace("Slow queries", "SlowQueries", $result);
	$result = ereg_replace("Open tables", "OpenTables", $result);
	$result = ereg_replace("Queries per second avg", "QPS", $result);
	$result = ereg_replace("Flush tables", "FlushTables", $result);

	return trim($result);
}

?>