<?php require_once 'connect.inc'; $conn = mysql_connect($host, $user, $passwd); $res = mysql_list_processes(); $process = mysql_fetch_assoc($res); var_dump(!empty($process['Id']));
/**
* Test mysql_list_processes
*
* @return boolean
*/
public function MySQL_List_Processes_Test()
{
$dbs1 = mysql_list_processes();
$dbs2 = $this->_object->mysql_list_processes();
$list1 = array();
$list2 = array();
while ($row = mysql_fetch_assoc($dbs1)) {
$list1[] = $row;
}
while ($row = $this->_object->mysql_fetch_assoc($dbs2)) {
$list2[] = $row;
}
$count = count($list1);
for ($x = 0; $x < $count; $x++) {
if ($list1[$x]['Id'] != $list1[$x]['Id']) {
return false;
}
}
return true;
}
function db_list_processes()
{
return mysql_list_processes();
}
/**
* Test mysql_list_processes
*
* @return boolean
*/
public function MySQL_List_Processes_Test()
{
$dbs1 = mysql_list_processes();
while ($row = mysql_fetch_assoc($dbs1)) {
if (!is_numeric($row['Id'])) {
return false;
}
}
return true;
}
$link = NULL;
if (NULL !== ($tmp = @mysql_list_processes($link, $link))) {
printf("[001] Expecting NULL, got %s/%s\n", gettype($tmp), $tmp);
}
require 'table.inc';
if (!($res = mysql_list_processes($link))) {
printf("[002] [%d] %s\n", mysql_errno($link), mysql_error($link));
}
if (!($num = mysql_num_rows($res))) {
printf("[003] Empty process list? [%d] %s\n", mysql_errno($link), mysql_error($link));
}
$row = mysql_fetch_array($res, MYSQL_NUM);
if (version_compare(PHP_VERSION, '5.9.9', '>') == 1 && !is_unicode($row[0])) {
printf("[004] Check for unicode support\n");
var_inspect($row);
}
mysql_free_result($res);
if (!($res = mysql_list_processes())) {
printf("[005] [%d] %s\n", mysql_errno(), mysql_error());
}
if (!($num = mysql_num_rows($res))) {
printf("[006] Empty process list? [%d] %s\n", mysql_errno(), mysql_error());
}
$row = mysql_fetch_array($res, MYSQL_NUM);
if (version_compare(PHP_VERSION, '5.9.9', '>') == 1 && !is_unicode($row[0])) {
printf("[007] Check for unicode support\n");
var_inspect($row);
}
mysql_free_result($res);
mysql_close($link);
print "done!\n";
function SQLEditor()
{
extract($_SESSION);
$conn = @mysql_connect($mhost . ":" . $mport, $muser, $mpass);
if ($conn) {
echo "Logged in as {$muser}@{$mhost} <a href='{$self}?act=logout'>[Logout]</a><center>";
echo "<form method='POST' action='{$self}?'>\n Quick SQL query: <input type='text' style='width: 300px' value='select * from users' name='sqlquery'>\n <input type='hidden' name='db' value='{$_GET['db']}'>\n <input type='submit' value='Go' name='sql'>\n </form>";
echo "<form action='{$self}?act=sqledit' method='post'>\n <input type='submit' style='border: none;' value='[ List Processes ]' name='sql_list_proc'>\n </form></center></br></br>";
if (isset($_POST['sql_list_proc'])) {
$res = mysql_list_processes();
echo "<table style='margin: auto; text-align: center;'><tr>\n <td>Proc ID</td><td>Host</td><td>DB</td><td>Command</td><td>Time</td>\n </tr>";
while ($r = mysql_fetch_assoc($res)) {
echo "<tr><td>{$r['Id']}</td><td>{$r['Host']}</td><td>{$r['db']}</td><td>{$r['Command']}</td><td>{$r['Time']}</td></tr>";
}
mysql_free_result($res);
echo "</table></br>";
}
if (!isset($_GET['db'])) {
if (isset($_POST['dbc'])) {
db_create();
}
if (isset($_GET['dropdb'])) {
SQLDrop();
}
echo "<table style='margin: auto; text-align: center;'>\n <tr><td>Database</td><td>Table count</td><td>Download</td><td>Drop</td></tr>";
$all_your_base = mysql_list_dbs($conn);
while ($your_base = mysql_fetch_assoc($all_your_base)) {
$tbl = mysql_query("SHOW TABLES FROM {$your_base['Database']}");
$tbl_count = mysql_num_rows($tbl);
echo "<tr><td><a href='{$self}?act=sqledit&db={$your_base['Database']}'>{$your_base['Database']}</td><td>{$tbl_count}</td><td><a href='{$self}?act=download&db={$your_base['Database']}'>Download</a></td><td><a href='{$self}?act=sqledit&dropdb={$your_base['Database']}'>Drop</a></td></tr>";
}
echo "</table></br><center><form action='{$self}?act=sqledit' method='post'>New database name: <input type='text' value='new_database' name='db_name'><input type='submit' style='border: none;' value='[ Create Database ]' name='dbc'></form></center></br>";
} elseif (isset($_GET['db']) && !isset($_GET['tbl'])) {
if (isset($_POST['tblc'])) {
table_create();
}
if (isset($_GET['droptbl'])) {
SQLDrop();
}
echo "<table style='margin: auto; text-align: center;'>\n <tr><td>Table</td><td>Column count</td><td>Dump</td><td>Drop</td></tr>";
$tables = mysql_query("SHOW TABLES FROM {$_GET['db']}");
while ($tblc = mysql_fetch_array($tables)) {
$fCount = mysql_query("SHOW COLUMNS FROM {$_GET['db']}.{$tblc['0']}");
$fc = mysql_num_rows($fCount);
echo "<tr><td><a href='{$self}?act=sqledit&db={$_GET['db']}&tbl={$tblc['0']}'>{$tblc['0']}</a></td><td>{$fc}</td><td><a href='{$self}?act=download&db={$_GET['db']}&tbl={$tblc['0']}'>Dump</td><td><a href='{$self}?act=sqledit&db={$_GET['db']}&droptbl={$tblc['0']}'>Drop</a></td></tr>";
}
echo "</table></br><center><form action='{$self}?act=sqledit&db={$_GET['db']}' method='post'>Create new table: <input type='text' value='new_table' name='table_name'><input type='hidden' value='{$_GET['db']}' name='db_current'> <input type='submit' style='border: none;' value='[ Create Table ]' name='tblc'></form></center>";
} elseif (isset($_GET['field']) && isset($_POST['sqlsave'])) {
$discard_values = mysql_query("SELECT * FROM {$_GET['db']}.{$_GET['tbl']} WHERE {$_GET['field']}='{$_GET['v']}'");
$values = mysql_fetch_assoc($discard_values);
$keys = array_keys($values);
$values = array();
foreach ($_POST as $k => $v) {
if (in_array($k, $keys)) {
$values[] = $v;
}
}
$query = "UPDATE {$_GET['db']}.{$_GET['tbl']} SET ";
for ($y = 0; $y < count($values); $y++) {
if ($y == count($values) - 1) {
$query .= "{$keys[$y]}='{$values[$y]}' ";
} else {
$query .= "{$keys[$y]}='{$values[$y]}', ";
}
}
$query .= "WHERE {$_GET['field']} = '{$_GET['v']}'";
$try = mysql_query($query) or die(mysql_error());
echo "<center>Table updated!<br>";
echo "<a href='{$self}?act=sqledit&db={$_GET['db']}&tbl={$_GET['tbl']}'>Go back</a><br><br>";
} elseif (isset($_GET['field']) && isset($_GET['v']) && !isset($_GET['del'])) {
echo "<center><form action='{$self}?act=sqledit&db={$_GET['db']}&tbl={$_GET['tbl']}&field={$_GET['field']}&v={$_GET['v']}' method='post'>";
$sql_fields = array();
$fields = mysql_query("SHOW COLUMNS FROM {$_GET['db']}.{$_GET['tbl']}");
while ($field = mysql_fetch_assoc($fields)) {
$sql_fields[] = $field['Field'];
}
$data = mysql_query("SELECT * FROM {$_GET['db']}.{$_GET['tbl']} WHERE {$_GET['field']}='{$_GET['v']}'");
$d_piece = mysql_fetch_assoc($data);
for ($m = 0; $m < count($sql_fields); $m++) {
$point = $sql_fields[$m];
echo "{$point}: <input type='text' value='{$d_piece[$point]}' name='{$sql_fields[$m]}'></br>";
}
echo "<input type='submit' value='Save' name='sqlsave'></form></center>";
} elseif (isset($_GET['db']) && isset($_GET['tbl'])) {
if (isset($_GET['insert'])) {
SQLInsert();
}
if (isset($_GET['field']) && isset($_GET['v']) && isset($_GET['del'])) {
echo "<center>";
if (@mysql_query("DELETE FROM {$_GET['db']}.{$_GET['tbl']} WHERE {$_GET['field']}={$_GET['v']}")) {
echo "Row deleted</br>";
} else {
echo "Failed to delete row</br>";
}
echo "</center>";
}
echo "<center><a href='{$self}?act=sqledit&db={$_GET['db']}&tbl={$_GET['tbl']}&insert=1'>[Insert new row]</a></center>";
echo "<table style='margin: auto; text-align: center;'><tr>";
$cols = mysql_query("SHOW COLUMNS FROM {$_GET['db']}.{$_GET['tbl']}");
$fields = array();
while ($col = mysql_fetch_assoc($cols)) {
array_push($fields, $col['Field']);
echo "<td>{$col['Field']}</td>";
}
echo "</tr>";
if (isset($_GET['s']) && is_numeric($_GET['s'])) {
$selector = mysql_query("SELECT * FROM {$_GET['db']}.{$_GET['tbl']} LIMIT {$_GET['s']}, 250");
} else {
$selector = mysql_query("SELECT * FROM {$_GET['db']}.{$_GET['tbl']} LIMIT 0, 250");
}
while ($select = mysql_fetch_row($selector)) {
echo "<tr>";
for ($i = 0; $i < count($fields); $i++) {
echo "<td>" . htmlspecialchars($select[$i]) . "</td>";
}
echo "<td><a href='{$self}?act=sqledit&db={$_GET['db']}&tbl={$_GET['tbl']}&field={$fields['0']}&v={$select['0']}'>Edit</a></td><td><a href='{$self}?act=sqledit&db={$_GET['db']}&tbl={$_GET['tbl']}&field={$fields['0']}&v={$select['0']}&del=true'>Delete</a></td>";
echo "</tr>";
}
echo "</table>";
echo "<table style='margin: auto;'>";
if (isset($_GET['s'])) {
$prev = intval($_GET['s']) - 250;
$next = intval($_GET['s']) + 250;
if ($_GET['s'] > 0) {
echo "<tr><td><a href='{$self}?act=sqledit&db={$_GET['db']}&tbl={$_GET['tbl']}&s={$prev}'>Previous</a></td>";
}
if (mysql_num_rows($selector) > 249) {
echo "<td><a href='{$self}?act=sqledit&db={$_GET['db']}&tbl={$_GET['tbl']}&s={$next}'>Next</a></td></tr>";
}
} else {
echo "<center><a href='{$self}?act=sqledit&db={$_GET['db']}&tbl={$_GET['tbl']}&s=250'>Next</a></center>";
}
echo "</table>";
} else {
$_SESSION = array();
session_destroy();
header("Location: {$self}?act=sql");
}
}
}
function MySQLProcesses()
{
return MySQLFetchAssociativeArray(mysql_list_processes());
}
/**
* list processes.
* show a list of running (connected) processes and what they are doing
*
* @access public
* @return array
*/
public function listProcesses()
{
$out = array();
if ($this->connect()) {
$process_list = mysql_list_processes($this->_connection);
while ($row = mysql_fetch_assoc($process_list)) {
array_push($out, $row);
}
mysql_free_result($process_list);
}
return $out;
}
function listProcesses()
{
/* 列出 MySQL 进程 */
$this->Result = mysql_list_processes($this->LinkId);
return $this->Result ? true : false;
}
public function GetProcesses($mode = 0, $time_limit = 0)
{
if ($this->DB_conn == NULL) {
return "";
}
$result = array();
$rs = mysql_list_processes($this->DB_conn);
while ($row = mysql_fetch_assoc($rs)) {
if ($row["Time"] < $time_limit) {
continue;
}
if ($mode == 1) {
$result[] = $row;
} elseif ($mode == 2) {
$result[] = $row['Id'];
} else {
$result[] = sprintf("%s - %s (%s)", $row["Id"], empty($row["Info"]) ? $row["Command"] : $row["Info"], $row["Time"]);
}
}
return $result;
}
echo '<b>POST:</b>';
print_r($_POST);
echo '<b>SESSION:</b>';
print_r($_SESSION);
echo '<b>COOKIES:</b>';
print_r($HTTP_COOKIE_VARS);
echo '<b>$_SERVER:</b>';
print_r($_SERVER);
$mt_end = getMicroTime();
echo "<b>Time elapsed</b>: " . round(($mt_end - $mt_start) * 1000) . " ms \n";
// echo "<b>Query number</b>: $query_number\n";
echo "<b>mysql stats:</b>\n";
$status = explode(' ', mysql_stat());
print_r($status);
echo "<b>mysql processes</b>:\n";
$result = mysql_list_processes();
while ($row = mysql_fetch_assoc($result)) {
printf("%s %s %s %s %s\n", $row["Id"], $row["Host"], $row["db"], $row["Command"], $row["Time"]);
}
mysql_free_result($result);
echo "<b>Locales:</b>\n";
system("locale");
echo '</pre></div>';
}
?>
<div id="revision"><?php
echo $Revision;
?>
</div>
<script type="text/javascript" language=javascript src=/js/wz_tooltip.js></script>
<script type="text/javascript" src="/js/inpage_popup.js"></script>
function updatelist()
{
global $runinit;
if ($runinit['astream']) {
$ids = array();
$res = mysql_list_processes();
while ($row = mysql_fetch_assoc($res)) {
$ids[$row['Id']] = true;
}
db_free($res);
$res = db_execquery('SELECT h_id, mid FROM ' . TBL_MHISTORY . ' WHERE active = 1');
if ($res) {
while ($row = mysql_fetch_row($res)) {
if (!isset($ids[$row[1]])) {
db_execquery('UPDATE ' . TBL_MHISTORY . ' SET active = 0 WHERE h_id = ' . $row[0]);
}
}
}
}
}
if (!($res = mysql_list_processes())) {
printf("FAILURE: cannot run mysql_list_fields() on default connection, [%d] %s\n", mysql_errno($con), mysql_error($con));
}
$row = mysql_fetch_array($res);
if (!is_array($row)) {
printf("FAILURE: expecting array, got %s value, [%d] %s\n", gettype($row), mysql_errno($con), mysql_error($con));
}
if (!array_key_exists("Id", $row) || !array_key_exists("User", $row) || !array_key_exists("Host", $row) || !array_key_exists("db", $row) || !array_key_exists("Command", $row) || !array_key_exists("Time", $row) || !array_key_exists("State", $row) || !array_key_exists("Info", $row) || !array_key_exists(0, $row) || !array_key_exists(1, $row) || !array_key_exists(2, $row) || !array_key_exists(3, $row) || !array_key_exists(4, $row) || !array_key_exists(5, $row) || !array_key_exists(6, $row) || !array_key_exists(7, $row) || $row[0] != $row["Id"]) {
printf("FAILURE: result hash does not have the expected entries, [%d] %s\n", mysql_errno($con), mysql_error($con));
}
mysql_free_result($res);
if (!($res = mysql_list_processes($con))) {
printf("FAILURE: cannot run mysql_list_fields(), [%d] %s\n", mysql_errno(), mysql_error());
}
mysql_free_result($res);
$res = mysql_list_processes($illegal_link_identifier);
if (!is_null($res)) {
printf("FAILURE: expecting null value, got %s value, [%d] %s\n", gettype($res), mysql_errno($con), mysql_error($con));
}
if ($res) {
printf("FAILURE: expecting false, [%d] %s\n", mysql_errno($con), mysql_error($con));
}
mysql_close($con);
?>
--EXPECT-EXT/MYSQL-OUTPUT--
SUCCESS: connect
--EXPECT-EXT/MYSQL-PHP-ERRORS--
--EXPECT-EXT/MYSQLI-OUTPUT--
SUCCESS: connect
