*/ include "functions.php"; loginCheck(); $conn->selectDB("mysql"); if (isset($_POST['editParts'])) { $editParts = $_POST['editParts']; $editParts = explode("; ", $editParts); $totalParts = count($editParts); $counter = 0; $firstField = true; foreach ($editParts as $part) { $part = trim($part); if ($part != "" && $part != ";") { list($user, $host) = explode("@", $part); $userSQL = $conn->query("SELECT * FROM `user` WHERE `User`='" . $user . "' AND `Host`='" . $host . "'"); $dbuserSQL = $conn->query("SELECT * FROM `db` WHERE `User`='" . $user . "' AND `Host`='" . $host . "'"); if ($conn->isResultSet($userSQL)) { $allPrivs = true; $dbShowList = array(); if ($conn->isResultSet($dbuserSQL)) { $accessLevel = "LIMITED"; while ($dbuserRow = $conn->fetchAssoc($dbuserSQL)) { $selectedPrivs = array(); $dbShowList[] = $dbuserRow['Db']; foreach ($dbuserRow as $key=>$value) { if (substr($key, -5) == "_priv" && $key != "Grant_priv" && $value == "N") { $allPrivs = false; } if ($value == "N") $selectedPrivs[$key] = $value; } if (isset($thePrivList)) { $thePrivList = array_merge($thePrivList, $selectedPrivs); } else { $thePrivList = $dbuserRow; } } } else { $accessLevel = "GLOBAL"; $userRow = $conn->fetchAssoc($userSQL); foreach ($userRow as $key=>$value) { if (substr($key, -5) == "_priv" && $key != "Grant_priv" && $value == "N") { $allPrivs = false; } } $thePrivList = $userRow; } echo '
'; echo '
'; echo ''; echo ''; ?> listDatabases(); if ($conn->isResultSet($dbList)) { ?>
:
:
:
:
>
:
" />