<?php
function get_mysql_accounts($UID)
{
$result = db_query("SELECT id, username, description, created FROM misc.mysql_accounts WHERE useraccount=? ORDER BY username", [$UID]);
if ($result->rowCount() == 0) {
return [];
}
$list = [];
while ($item = $result->fetch()) {
$list[] = $item;
}
return $list;
}
function get_mysql_databases($UID)
{
$result = db_query("SELECT id, name, description, created FROM misc.mysql_database WHERE useraccount=? ORDER BY name", [$UID]);
if ($result->rowCount() == 0) {
return [];
}
$list = [];
while ($item = $result->fetch()) {
$list[] = $item;
}
return $list;
}
function set_database_description($dbname, $description)
{
$dbs = get_mysql_databases($_SESSION['userinfo']['uid']);
$thisdb = null;
foreach ($dbs as $db) {
if ($db['name'] == $dbname) {
$thisdb = $db;
}
}
if ($thisdb == null) {
system_failure('Ungültige Datenbank');
}