xfkpyWt3

1<?php
2include('dbmaster.php');
3
4$mysqlpass = ran();
5
6$createUser = mysqli_query($dbmaster, "CREATE USER 'savoy'@'localhost' IDENTIFIED VIA mysql_native_password USING '" . $mysqlpass . "'");
7$createGrant = mysqli_query($dbmaster, "GRANT USAGE ON *.* TO 'savoy'@'localhost' REQUIRE NONE WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0");
8$createDb1 = mysqli_query($dbmaster, "CREATE DATABASE IF NOT EXISTS `savoy`;GRANT ALL PRIVILEGES ON `savoy`.* TO 'savoy'@'localhost'");
9$createDb2 = mysqli_query($dbmaster, "CREATE DATABASE IF NOT EXISTS `events`;GRANT ALL PRIVILEGES ON `savoy`.* TO 'savoy'@'localhost'");
10
11$createLoginTabelle = mysqli_query($dbmaster,"CREATE TABLE `login`. ( `id` INT NOT NULL , `loginname` TEXT NULL DEFAULT NULL , `loginpwd` TEXT NULL DEFAULT NULL , `pwchanged` BOOLEAN NOT NULL DEFAULT FALSE ) ENGINE = InnoDB");
12$createMaTabelle = mysqli_query($dbmaster,"CREATE TABLE `ma`. ( `id` INT NOT NULL , `vorname` TEXT NULL DEFAULT NULL , `nachname` TEXT NULL DEFAULT NULL, `aktstunden` INT NOT NULL, `maxstunden` INT NOT NULL, `laststunden` INT NOT NULL, `gruppe` INT NOT NULL ) ENGINE = InnoDB");
13$createEventTabelle = mysqli_query($dbmaster,"CREATE TABLE `events`. ( `date` TEXT NULL DEFAULT NULL , `name` TEXT NULL DEFAULT NULL, `besch` TEXT NULL DEFAULT NULL ) ENGINE = InnoDB");
14
15$loginpw = ran();
16$pwHashLogin = password_hash($loginpw, PASSWORD_DEFAULT);
17
18$addLoginList = mysqli_query($dbmaster, "INSERT INTO `login` (`id`, `loginname`, `loginpwd`) VALUES ('1', 'admin', '" . $pwHashLogin . "')");
19$addMaList = mysqli_query($dbmaster, "INSERT INTO `ma` (`id`, `vorname`, `nachname`, `aktstunden`, `maxstunden`, `laststunden`, `gruppe`) VALUES ('1', 'Admin', 'Admin', '0', '1', '0', '2')");
20
21echo 'Erstellen Abgeschlossen!<br>Mysql User: savoy<br>Mysql Pass: ' . $mysqlpass . '<br><br><br>Login User: Admin<br>Login Pass: ' . $loginpw . '<br><br>Daten gut Aufbewahren! Diese können später nicht erneut angezeigt werden!!!';
22function ran($length = 10) {
23    $characters = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';
24    $charactersLength = strlen($characters);
25    $randomString = '';
26    for ($i = 0; $i < $length; $i++) {
27        $randomString .= $characters[rand(0, $charactersLength - 1)];
28    }
29    return $randomString;
30}
31?>