<?php
require_once('session/start.php');
require_once('inc/icons.php');
require_role([ROLE_SYSTEMUSER]);
global $prefix;
require_once('mysql.php');
$dbs = get_mysql_databases($_SESSION['userinfo']['uid']);
$users = get_mysql_accounts($_SESSION['userinfo']['uid']);
$username = $_SESSION['userinfo']['username'];
$section = 'mysql_overview';
title('Neue MySQL-Datenbank');
$dbnames = [];
foreach ($dbs as $db) {
$dbnames[] = $db['name'];
}
$suggestion = $username . '_1';
$count = 2;
while (in_array($suggestion, $dbnames)) {
$suggestion = $username . '_' . $count;
$count++;
}
$hint = 'Der Datenbankname muss mit <strong>' . $username . '_</strong> beginnen.';
$form = '<h4>Name der neuen Datenbank</h4>
<input type="text" name="newdb" value="' . $suggestion . '" />
<p>Bitte nur Kleinbuchstaben, Zahlen und Unterstrich verwenden. ' . $hint . '</p>
<p><label for="description">Optionale Beschreibung dieser Datenbank:</label> <input type="text" name="description" id="description" /></p>
';
if (count(additional_servers()) > 0) {
$form .= '<h4>Server</h4>';
$form .= '<p>Auf welchem Server soll diese Datenbank eingerichtet werden?</p>';
$available_servers = additional_servers();