public function getAttribute($attribute, &$source = null, $func = 'PDO::getAttribute', &$last_error = null)
{
if ($source == null) {
$source =& $this->driver_options;
}
switch ($attribute) {
case EhrlichAndreas_Pdo_Abstract::ATTR_AUTOCOMMIT:
$result = mysql_unbuffered_query('SELECT @@AUTOCOMMIT', $this->link);
if (!$result) {
$this->set_driver_error(null, EhrlichAndreas_Pdo_Abstract::ERRMODE_EXCEPTION, $func);
}
$row = mysql_fetch_row($result);
mysql_free_result($result);
return intval($row[0]);
break;
case EhrlichAndreas_Pdo_Abstract::ATTR_TIMEOUT:
return intval(ini_get('mysql.connect_timeout'));
break;
case EhrlichAndreas_Pdo_Abstract::ATTR_CLIENT_VERSION:
return mysql_get_client_info();
break;
case EhrlichAndreas_Pdo_Abstract::ATTR_CONNECTION_STATUS:
return mysql_get_host_info($this->link);
break;
case EhrlichAndreas_Pdo_Abstract::ATTR_SERVER_INFO:
return mysql_stat($this->link);
break;
case EhrlichAndreas_Pdo_Abstract::ATTR_SERVER_VERSION:
return mysql_get_server_info($this->link);
break;
default:
return parent::getAttribute($attribute, $source, $func, $last_error);
break;
}
}
public function estado_enlace()
{
$stat = explode(' ', mysql_stat($this->link));
foreach ($stat as $campo => $valor) {
echo '<b>' . $campo . '</b> ' . $valor . '<br />';
}
}
function chk_db_connect($post)
{
if ($post['dbtype'] == 'mysql') {
$conn = @mysql_connect($post['host'], $post['user'], $post['pass']);
return @mysql_stat($conn);
} elseif ($post['dbtype'] == 'postgresql') {
$conn = pg_connect("host=" . $post['host'] . " port=5432 dbname=template1 user="******" password=" . $post['pass']);
return $conn;
}
}
public static function getDBStatus()
{
Piwik::checkUserIsSuperUser();
$configDb = Zend_Registry::get('config')->database->toArray();
// we decode the password. Password is html encoded because it's enclosed between " double quotes
$configDb['password'] = htmlspecialchars_decode($configDb['password']);
if (!isset($configDb['port'])) {
// before 0.2.4 there is no port specified in config file
$configDb['port'] = '3306';
}
$link = mysql_connect($configDb['host'], $configDb['username'], $configDb['password']);
$status = mysql_stat($link);
mysql_close($link);
return $status;
}
/**
* Gets general database info that is not specific to any table.
*
* @return array See http://dev.mysql.com/doc/refman/5.1/en/show-status.html .
*/
public function getDBStatus()
{
if (function_exists('mysql_connect')) {
$configDb = Piwik_Config::getInstance()->database;
$link = mysql_connect($configDb['host'], $configDb['username'], $configDb['password']);
$status = mysql_stat($link);
mysql_close($link);
$status = explode(" ", $status);
} else {
$fullStatus = Piwik_FetchAssoc('SHOW STATUS');
if (empty($fullStatus)) {
throw new Exception('Error, SHOW STATUS failed');
}
$status = array('Uptime' => $fullStatus['Uptime']['Value'], 'Threads' => $fullStatus['Threads_running']['Value'], 'Questions' => $fullStatus['Questions']['Value'], 'Slow queries' => $fullStatus['Slow_queries']['Value'], 'Flush tables' => $fullStatus['Flush_commands']['Value'], 'Open tables' => $fullStatus['Open_tables']['Value'], 'Opens' => 'unavailable', 'Queries per second avg' => 'unavailable');
}
return $status;
}
/**
* Connects to the database specified in the options.
* If autoconnect is enabled (which is is by default),
* this function will be called upon class instantiation.
*/
public function connect()
{
if (!$this->conn) {
// don't open a new connection if one already exists
$this->conn = @mysql_connect($this->host, $this->user, $this->password);
if (!$this->conn) {
throw new OsimoException(OSIMODB_CONNECT_FAIL, "Could not connect to database at {$this->host}");
}
$this->conn_db = @mysql_select_db($this->name);
if (!$this->conn_db) {
throw new OsimoException(OSIMODB_SELECT_FAIL, "Could not select the database: {$this->name}");
}
get('debug')->logMsg('OsimoDB', 'events', 'Opening database connection...');
$status = explode(' ', mysql_stat());
get('debug')->logMsg('OsimoDB', 'events', "Current database status:\n" . print_r($status, true));
}
}
public function getDBStatus()
{
Piwik::checkUserIsSuperUser();
if(function_exists('mysql_connect'))
{
$configDb = Zend_Registry::get('config')->database->toArray();
// we decode the password. Password is html encoded because it's enclosed between " double quotes
$configDb['password'] = htmlspecialchars_decode($configDb['password']);
if(!isset($configDb['port']))
{
// before 0.2.4 there is no port specified in config file
$configDb['port'] = '3306';
}
$link = mysql_connect($configDb['host'], $configDb['username'], $configDb['password']);
$status = mysql_stat($link);
mysql_close($link);
$status = explode(" ", $status);
}
else
{
$db = Zend_Registry::get('db');
$fullStatus = $db->fetchAssoc('SHOW STATUS;');
if(empty($fullStatus)) {
throw new Exception('Error, SHOW STATUS failed');
}
$status = array(
'Uptime' => $fullStatus['Uptime']['Value'],
'Threads' => $fullStatus['Threads_running']['Value'],
'Questions' => $fullStatus['Questions']['Value'],
'Slow queries' => $fullStatus['Slow_queries']['Value'],
'Flush tables' => $fullStatus['Flush_commands']['Value'],
'Open tables' => $fullStatus['Open_tables']['Value'],
// 'Opens: ', // not available via SHOW STATUS
// 'Queries per second avg' =/ // not available via SHOW STATUS
);
}
return $status;
}
/**
* Show general table stats
*
* @access public
*/
public function index()
{
// -------------------------------------
// Get basic info
// -------------------------------------
$raw_stats = explode(' ', mysql_stat());
$data = array();
$data['stats'] = array();
foreach ($raw_stats as $stat) {
$break = explode(':', $stat);
$data['stats'][trim($break[0])] = trim($break[1]);
}
// -------------------------------------
// Get Processes
// -------------------------------------
$this->load->helper('number');
$data['processes'] = $this->db->query('SHOW PROCESSLIST')->result();
// -------------------------------------
$this->template->build('admin/overview', $data);
}
public function __construct(Credentials $credentials, $workspace, $config)
{
$link = @mysql_connect($config->server, $credentials->getUserID(), $credentials->getPassword(), 1);
if (mysql_stat($link) !== null) {
if (!mysql_select_db($workspace, $link)) {
$sql = "CREATE DATABASE {$workspace}";
if (mysql_query($sql, $link)) {
mysql_select_db($workspace, $link);
$sql = "CREATE TABLE c (p text NOT NULL,\n\t\t\t\t\t\t\t\tn text NOT NULL,\n\t\t\t\t\t\t\t\tv text NOT NULL,\n\t\t\t\t\t\t\t\tKEY INDEX1 (p (1000)),\n\t\t\t\t\t\t\t\tKEY INDEX2 (p (850), n (150)),\n\t\t\t\t\t\t\t\tKEY INDEX3 (p (550), n (150), v (300)),\n\t\t\t\t\t\t\t\tKEY INDEX4 (v (1000)))\n\t\t\t\t\t\t\t\tENGINE = MyISAM DEFAULT CHARSET = latin1";
mysql_query($sql, $link);
} else {
throw new RepositoryException("in MySQL, cannot create workspace: {$workspace}");
}
}
$this->credentials = $credentials;
$this->workspace = $workspace;
$this->config = $config;
$this->link = $link;
$this->isLive = true;
}
}
function stat()
{
/* 取得当前系统状态 */
return mysql_stat($this->LinkId);
}
public function cacheTestConnection()
{
$status = '';
if ($this->cacheDbType != '' && $this->cacheDbh != false) {
if (strtolower($this->cacheDbType) == 'mysql') {
$status = mysql_stat($this->cacheDbh);
if ($status && $status != '') {
$this->cachingOn = true;
return true;
} else {
return false;
}
} else {
return false;
}
} else {
return false;
}
}
if (is_object($database->DbHandle)) {
$title = "MySQLi Info";
$server_info = mysqli_get_server_info($database->DbHandle);
$host_info = mysqli_get_host_info($database->DbHandle);
$proto_info = mysqli_get_proto_info($database->DbHandle);
$client_info = mysqli_get_client_info($database->DbHandle);
$client_encoding = mysqli_character_set_name($database->DbHandle);
$status = explode(' ', mysqli_stat($database->DbHandle));
} else {
$title = "MySQL Info";
$server_info = mysql_get_server_info();
$host_info = mysql_get_host_info();
$proto_info = mysql_get_proto_info();
$client_info = mysql_get_client_info();
$client_encoding = mysql_client_encoding();
$status = explode(' ', mysql_stat());
}
$strictMode = $database->get_one('SELECT @@sql_mode');
$strict_info = (strpos($strictMode, 'STRICT_TRANS_TABLES') !== false or strpos($strictMode, 'STRICT_ALL_TABLES') !== false) ? "MySQL strict mode active" : "MySQL strict mode not active\n";
?>
<table cellpadding="3" border="0">
<tbody>
<tr class="h">
<td><h1 class="p"><?php
echo $title;
?>
</h1></td>
</tr>
</tbody>
</table>
<br/>
sql_query("UPDATE `profiler` SET `prfCount` = `prfCount` + 1, " . "`prfTime` = `prfTime` + '" . $generationTime . "' " . "WHERE `prfPage` = '" . addslashes($page) . "'");
} else {
sql_values(array("prfPage" => $page, "prfCount" => 1, "prfTime" => $generationTime));
sql_insert("profiler");
}
}
// Show "Page generated in N seconds" if the user is at least
// a moderator.
if (atLeastSModerator() || $_auth["useid"] == 34814) {
include_once "serverload.php";
$time_start = $_stats["startTime"];
$time_end = gettimeofday();
$secdiff = $time_end["sec"] - $time_start["sec"];
$usecdiff = $time_end["usec"] - $time_start["usec"];
$generationTime = round(($secdiff * 1000000 + $usecdiff) / 1000000, 3);
$mysqlStat = mysql_stat();
$queriesPerSecond = round(preg_replace('/.*' . preg_quote("Queries per second avg: ") . '([0-9\\.]+).*/', "\\1", $mysqlStat), 2);
//if( isset( $_stats[ "startQueries" ]))
//{
// $queryCount = preg_replace( '/.*'.preg_quote( "Questions: " ).
// '([0-9]+).*/', "\\1", $mysqlStat ) - $_stats[ "startQueries" ];
//}
//else
//{
// $queryCount = 0;
//}
$mysqlUptime = round(preg_replace('/.*' . preg_quote("Uptime: ") . '([0-9\\.]+).*/', "\\1", $mysqlStat), 2);
$upDays = floor($mysqlUptime / 60 / 60 / 24);
$upHours = floor($mysqlUptime / 60 / 60) % 24;
$upMinutes = $mysqlUptime / 60 % 60;
echo " <br /> " . sprintf(_PAGE_GENERATED, $generationTime) . ", MySQL: " . $queriesPerSecond . " queries/sec, " . "uptime " . $upDays . "d " . $upHours . "h " . $upMinutes . "m. · Server load: {$loadavg}";
/**
* Get details about the current system status
* @return array details
*/
public function status()
{
return explode(' ', mysql_stat($this->link_id));
}
/**
* Return a few database statistics in an array.
*
* @return array Returns an array of statistics values on success or FALSE on error.
*/
public function GetStatistics()
{
$this->ResetError();
if (!$this->IsConnected()) {
return $this->SetError('No connection', -1);
} else {
$result = mysql_stat($this->mysql_link);
if (empty($result)) {
$this->SetError('Failed to obtain database statistics', -1);
// do NOT return to caller yet!
return array('Query Count' => $this->query_count);
}
$tot_count = preg_match_all('/([a-z ]+):\\s*([0-9.]+)/i', $result, $matches);
$info = array('Query Count' => $this->query_count);
for ($i = 0; $i < $tot_count; $i++) {
$info[$matches[1][$i]] = $matches[2][$i];
}
return $info;
}
}
/**
* Checks if current mysql connection is alive
* @return bool Returns TRUE if connection is alive, else returns FALSE
*/
public function isConnected()
{
return isset($this->dbLink) && $this->dbLink !== NULL && mysql_stat($this->dbLink) !== NULL;
}
$your_version.="<tr><td align=\"right\">Current version:</td><td align=\"left\">".implode(" ",$last_version)."</td></tr>\n";
$your_version.="<tr><td colspan=\"2\" align=\"center\">Get Last Version <a href=\"http://www.btiteam.org\" target=\"_blank\">here</a>!</td></tr>\n</table>";
}
else
{
$your_version.="You have the latest xBtit version installed.($tracker_version Rev.$tracker_revision)";
}
if (!empty($your_version))
$admin["xbtit_version"]=$your_version."<br />\n";
*/
$admin["infos"] .= "<br />\n<table border=\"0\">\n";
$admin["infos"] .= "<tr><td class=\"header\" align=\"center\">Server's OS</td></tr><tr><td align=\"left\">" . php_uname() . "</td></tr>";
$admin["infos"] .= "<tr><td class=\"header\" align=\"center\">PHP version</td></tr><tr><td align=\"left\">" . phpversion() . "</td></tr>";
$sqlver = mysql_fetch_row(do_sqlquery("SELECT VERSION()"));
$admin["infos"] .= "\n<tr><td class=\"header\" align=\"center\">MYSQL version</td></tr><tr><td align=\"left\">{$sqlver['0']}</td></tr>";
$sqlver = mysql_stat();
$sqlver = explode(' ', $sqlver);
$admin["infos"] .= "\n<tr><td valign=\"top\" class=\"header\" align=\"center\">MYSQL stats</td></tr>\n";
for ($i = 0; $i < count($sqlver); $i++) {
$admin["infos"] .= "<tr><td align=\"left\">{$sqlver[$i]}</td></tr>\n";
}
$admin["infos"] .= "\n</table><br />\n";
unset($sqlver);
// check for news on btiteam site (read rss from comunication forum)
/*
if($btit_url_rss!="")
{
include("$THIS_BASEPATH/include/class.rssreader.php");
$btit_news=get_cached_version($btit_url_rss);
$row = $mysqldb->fetchObject();
$approvedcomments = $row->commenty;
$mysqldb->query("SELECT COUNT(*) as commentn FROM articles WHERE Approved = 'N' AND ParentID>0");
$row = $mysqldb->fetchObject();
$pendingcomments = $row->commentn;
$mysqldb->query("SELECT count(*) as qy from articles WHERE Approved = 'Q'");
$row = $mysqldb->fetchObject();
$pendingquestions = $row->qy;
$mysqldb->query("SELECT count(*) as qn from articles WHERE Approved = 'A'");
$row = $mysqldb->fetchObject();
$respondedquestions = $row->qn;
$totalarticles = $pendingarticles + $approvedarticles;
$totalcomments = $approvedcomments + $pendingcomments;
$totalquestions = $respondedquestions + $pendingquestions;
// if all is good, we've got our count variables
$mysqlstat = explode(' ', mysql_stat());
$rwxcheck = permcheck();
head_page($page_title);
menu_options($title, $vnum, $viewop, $pid, $keys, $adfl);
contentinit($title);
echo <<<_EOF
<font color="red">{$rwxcheck}</font>
<br />
<table>
<tr>
<td><a href="pending.php?acq=a">Pending Articles</a></td><td><a href="a_pendinga.php">{$pendingarticles}</a></td>
</tr>
<tr>
<td>Approved Articles</td><td>{$approvedarticles}</td>
</tr>
<tr>
/**
* get server status.
* get a status string from the mysql server.
*
* - uptime
* - threads
* - questions handled
* - # slow queries
* - open connections
* - # flush tables
* - # open tables
* - # queries / second
*
* @access public
* @return string
*/
public function getStatus()
{
if ($this->connect()) {
return mysql_stat($this->_connection);
}
return null;
}
<?php
include_once "connect.inc";
$dbname = 'test';
$tmp = NULL;
$link = NULL;
if (!is_null($tmp = @mysql_stat($link))) {
printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
}
require 'table.inc';
if (!is_null($tmp = @mysql_stat($link, "foo"))) {
printf("[002] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
}
if (!is_string($stat = mysql_stat($link)) || '' === $stat) {
printf("[003] Expecting non empty string, got %s/'%s', [%d] %s\n", gettype($stat), $stat, mysql_errno($link), mysql_error($link));
}
if (version_compare(PHP_VERSION, '5.9.9', '>') == 1 && !is_unicode($stat)) {
printf("[004] Expecting Unicode error message!\n");
var_inspect($stat);
}
if (!is_string($stat_def = mysql_stat()) || '' === $stat_def) {
printf("[003] Expecting non empty string, got %s/'%s', [%d] %s\n", gettype($stat_def), $stat_def, mysql_errno(), mysql_error());
}
assert(soundex($stat) === soundex($stat_def));
mysql_close($link);
if (false !== ($tmp = mysql_stat($link))) {
printf("[005] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp);
}
print "done!";
case 'mysqlinfo':
echo window_title($database_window_title . "MySQL - Info");
echo "<div class='row'><div class='row'><label class='etiquette'>" . $msg[sql_info_notices] . "</label></div>\n\t\t\t <div class='row'>" . pmb_sql_value("select count(*) as nb from notices") . "</div>";
echo "<div class='row'><label class='etiquette'>" . $msg[sql_info_exemplaires] . "</label></div>\n\t\t\t <div class='row'>" . pmb_sql_value("select count(*) as nb from exemplaires") . "</div>";
echo "<div class='row'><label class='etiquette'>" . $msg[sql_info_bulletins] . "</label></div>\n\t\t\t <div class='row'>" . pmb_sql_value("select count(*) as nb from bulletins") . "</div>";
echo "<div class='row'><label class='etiquette'>" . $msg[sql_info_authors] . "</label></div>\n\t\t\t <div class='row'>" . pmb_sql_value("select count(*) as nb from authors") . "</div>";
echo "<div class='row'><label class='etiquette'>" . $msg[sql_info_publishers] . "</label></div>\n\t\t\t <div class='row'>" . pmb_sql_value("select count(*) as nb from publishers") . "</div>";
echo "<div class='row'><label class='etiquette'>" . $msg[sql_info_empr] . "</label></div>\n\t\t\t <div class='row'>" . pmb_sql_value("select count(*) as nb from empr") . "</div>";
echo "<div class='row'><label class='etiquette'>" . $msg[sql_info_pret] . "</label></div>\n\t\t\t <div class='row'>" . pmb_sql_value("select count(*) as nb from pret") . "</div>";
echo "<div class='row'><label class='etiquette'>" . $msg[sql_info_pret_archive] . "</label></div>\n\t\t\t <div class='row'>" . pmb_sql_value("select count(*) as nb from pret_archive") . "</div>";
echo "<hr />";
echo "<div class='row'>\n\t\t\t\t<label class='etiquette' >MySQL Database name, host and user</label>\n\t\t\t\t</div>\n\t\t\t <div class='row'>\n\t\t\t\t\t" . DATA_BASE . " on " . SQL_SERVER . ", user="******"\n\t\t\t\t\t</div>\n\t\t\t <div class='row'>\n\t\t\t\t<label class='etiquette' >MySQL Server Information</label>\n\t\t\t\t</div>\n\t\t\t <div class='row'>\n\t\t\t\t\t" . mysql_get_server_info() . "\n\t\t\t\t\t</div><hr />";
echo "<div class='row'>\n\t\t\t\t<label class='etiquette' >MySQL Client Information</label>\n\t\t\t\t</div>\n\t\t\t <div class='row'>\n\t\t\t\t\t" . mysql_get_client_info() . "\n\t\t\t\t\t</div><hr />";
echo "<div class='row'>\n\t\t\t\t<label class='etiquette' >MySQL Host Information</label>\n\t\t\t\t</div>\n\t\t\t <div class='row'>\n\t\t\t\t\t" . mysql_get_host_info() . "\n\t\t\t\t\t</div><hr />";
echo "<div class='row'>\n\t\t\t\t<label class='etiquette' >MySQL Protocol Information</label>\n\t\t\t\t</div>\n\t\t\t <div class='row'>\n\t\t\t\t\t" . mysql_get_proto_info() . "\n\t\t\t\t\t</div><hr />";
echo "<div class='row'>\n\t\t\t\t<label class='etiquette' >MySQL Stat. Information</label>\n\t\t\t\t</div>\n\t\t\t <div class='row'>\n\t\t\t\t\t" . str_replace(' ', '<br />', mysql_stat()) . "</div><hr />";
echo "<div class='row'>\n\t\t\t\t<label class='etiquette' >MySQL Variables</label>\n\t\t\t\t</div>\n\t\t\t <div class='row'><table>";
$result = mysql_query('SHOW VARIABLES', $dbh);
$parity = 0;
while ($row = mysql_fetch_assoc($result)) {
if ($parity % 2) {
$pair_impair = "even";
} else {
$pair_impair = "odd";
}
$parity += 1;
echo "<tr class='{$pair_impair}'><td>" . $row['Variable_name'] . "</td><td>" . $row['Value'] . "</td></tr>";
}
echo "</table></div>";
break;
case '':
function mysql_stat()
{
return mysql_stat($this->link);
}
public function GetStat()
{
if ($this->DB_conn == NULL) {
return "";
}
$result = array("MySQL server version" => mysql_get_server_info($this->DB_conn), "MySQL protocol version" => mysql_get_proto_info($this->DB_conn), "MySQL host info" => mysql_get_host_info($this->DB_conn), "MySQL client info" => mysql_get_client_info($this->DB_conn), "More info" => str_replace(" ", "\n", mysql_stat($this->DB_conn)), "Process list" => implode("\n", $this->GetProcesses()));
return $result;
}
function DisplayStatus() {
$urllist['System Status'] = "status.php";
NavigationBar("System", $urllist);
# connect to DB and get status
$dbconnect = true;
$devdbconnect = true;
$L = mysqli_connect($GLOBALS['cfg']['mysqlhost'],$GLOBALS['cfg']['mysqluser'],$GLOBALS['cfg']['mysqlpassword'],$GLOBALS['cfg']['mysqldatabase']) or $dbconnect = false;
$dbStatus = explode(" ", mysql_stat());
# get number of fileio operations pending
$sqlstring = "select count(*) 'numiopending' from fileio_requests where request_status in ('pending','')";
$result = MySQLQuery($sqlstring,__FILE__,__LINE__);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numiopending = $row['numiopending'];
# get number of directories in dicomincoming directory
$dirs = glob($GLOBALS['cfg']['incomingdir'].'/*', GLOB_ONLYDIR);
$numdicomdirs = count($dirs);
# get number of files in dicomincoming directory
$files = glob($GLOBALS['cfg']['incomingdir'].'/*');
$numdicomfiles = count($files);
# get number of import requests
$sqlstring = "select count(*) 'numimportpending' from import_requests where import_status in ('pending','')";
$result = MySQLQuery($sqlstring,__FILE__,__LINE__);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numimportpending = $row['numimportpending'];
# get number of directories in dicomincoming directory
$dirs = glob($GLOBALS['cfg']['uploadedpath'].'/*', GLOB_ONLYDIR);
$numimportdirs = count($dirs);
?>
<table class="entrytable">
<tr>
<td class="label">Uptime</td>
<td><pre><?php
echo trim(`uptime`);
?>
</pre></td>
</tr>
<tr>
<td class="label">Memory (GB)</td>
<td><pre><?php
echo trim(`free -g`);
?>
</pre></td>
</tr>
<tr>
<td class="label">Disk usage</td>
<td><pre><?php
echo system('df -lh');
?>
</pre></td>
</tr>
<tr>
<td class="label">Database</td>
<td><pre><?
foreach ($dbStatus as $value){
echo $value . "\n";
}
?></pre></td>
</tr>
<tr>
<td class="label">Parse DICOM module<br><span class="tiny"><?php
echo $GLOBALS['cfg']['incomingdir'];
?>
</span></td>
<td>
<?php
echo $numdicomfiles;
?>
queued files<br>
<?php
echo $numdicomdirs;
?>
queued directories<br>
</td>
</tr>
<tr>
<td class="label">Import module<br><span class="tiny"><?php
echo $GLOBALS['cfg']['uploadedpath'];
?>
</span></td>
<td>
<?php
echo $numimportpending;
?>
requests pending<br>
<?php
echo $numimportdirs;
?>
queued directories<br>
</td>
</tr>
<tr>
<td class="label">File IO module</td>
<td><?php
echo $numiopending;
?>
operations pending</td>
</tr>
<tr>
<td class="label">Pipeline module</td>
<td>
<table class="smallgraydisplaytable">
<thead>
<tr>
<th>Process ID</th>
<th>Status</th>
<th>Startdate</th>
<th>Last checkin</th>
<th>Current pipeline</th>
<th>Current study</th>
</tr>
</thead>
<tbody>
<?
$sqlstring = "select a.*, b.pipeline_name from pipeline_procs a left join pipelines b on a.pp_currentpipeline = b.pipeline_id order by a.pp_lastcheckin";
$result = MySQLQuery($sqlstring,__FILE__,__LINE__);
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$pp_processid = $row['pp_processid'];
$pp_status = $row['pp_status'];
$pp_startdate = $row['pp_startdate'];
$pp_lastcheckin = $row['pp_lastcheckin'];
$pp_currentpipeline = $row['pp_currentpipeline'];
$pipelinename = $row['pipeline_name'];
$pp_currentsubject = $row['pp_currentsubject'];
$pp_currentstudy = $row['pp_currentstudy'];
?>
<tr>
<td><?php
echo $pp_processid;
?>
</td>
<td><?php
echo $pp_status;
?>
</td>
<td><?php
echo $pp_startdate;
?>
</td>
<td><?php
echo $pp_lastcheckin;
?>
</td>
<td><?php
echo $pipelinename;
?>
</td>
<td><?php
echo $pp_currentstudy;
?>
</td>
</tr>
<?
}
?>
</tbody>
</table>
</td>
</tr>
</table>
<?
}
/**
* Test mysql_stat
*
* @return boolean
*/
public function MySQL_Stat_Test()
{
// Get stats
$stat1 = mysql_stat();
$finds = array('Uptime:', 'Threads:', 'Questions:', 'Open tables:', 'Queries per second');
foreach ($finds as $find) {
if (stripos($stat1, $find) === false) {
return false;
}
}
// Compare
return true;
}
public static function stat($stat = null)
{
if ($stat === null) {
return mysql_stat();
} else {
return mysql_stat($stat);
}
}
/**
* Test mysql_stat
*
* @return boolean
*/
public function MySQL_Stat_Test()
{
// Get stats
$stat1 = mysql_stat();
$stat2 = $this->_object->mysql_stat();
// Extract all #'s out
preg_match_all('!\\d+!', $stat1, $matches1);
preg_match_all('!\\d+!', $stat2, $matches2);
unset($stat1, $stat2);
// Go through each number
$count = count($matches1[0]);
for ($x = 0; $x < $count; $x++) {
$diff = abs($matches1[0][$x] - $matches2[0][$x]);
// Make sure that the difference is <= 10 (margin of change while queries are running)
if ($diff > 10) {
return false;
}
}
return true;
}
function stat()
{
if (!$this->curlink) {
$this->connect();
}
return mysql_stat($this->curlink);
}
function DB_GetMysqlStats()
{
// --- Abort in this case!
if (GetConfigSetting("UserDBEnabled", false) == false) {
return;
}
// ---
global $userdbconn;
$status = explode(' ', mysql_stat($userdbconn));
return $status;
}
}
}
}
}
/* validate page request */
// empty defaults to landing page set in config
if (empty($_REQUEST['page'])) {
$loadPage = $cfg['landing_page'];
} elseif (in_array($_REQUEST['page'], $pagesArray)) {
$loadPage = $_REQUEST['page'];
} else {
die('page: ' . $_REQUEST['page'] . ', does not exist');
}
// else $loadPage='404error';
/* output page */
$template->load(PATH . './pages/' . $loadPage . '.php');
$templateList = loadTemplates();
foreach ($templateList as $tpl) {
$tplName = substr($tpl, 0, strlen($tpl) - 4);
$template->replace($tplName, file_get_contents(PATH . $cfg['theme_templateDir'] . $tpl));
}
$template->publish();
/* debug stats */
@(print '<p>' . mysql_stat($cfg['mysql_linkid']) . '</p>');
$microTime = microtime();
$microTime = explode(' ', $microTime);
$microTime = $microTime[1] + $microTime[0];
$loadEnd = $microTime;
$loadTime = round($loadEnd - $loadStart, 4);
echo '<p>Page generated in ' . $loadTime . ' seconds.' . '</p>';
exit;
