Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html lang="en">
- <head>
- <meta charset="utf-8">
- <meta http-equiv="X-UA-Compatible" content="IE=edge">
- <meta name="viewport" content="width=device-width, initial-scale=1">
- <meta name="description" content="">
- <meta name="author" content="">
- <title>ryan-service</title>
- <!-- Bootstrap Core CSS -->
- <link href="bootstrap/css/bootstrap.min.css" rel="stylesheet">
- <!-- Custom CSS -->
- <style>
- body {
- padding-top: 70px;
- /* Required padding for .navbar-fixed-top. Remove if using .navbar-static-top. Change if height of navigation changes. */
- }
- </style>
- </head>
- <body>
- <form class="form-horizontal" action='register.php' method='POST'>
- <div class="form-group">
- <label for="inputUser3" class="col-sm-2 control-label">Benutzername</label>
- <div class="col-sm-10">
- <input type="text" class="form-control" id="inputUser3" name="inputUser3" placeholder="RPG-City Benutzername">
- </div>
- </div>
- <div class="form-group">
- <label for="inputPassword3" class="col-sm-2 control-label">Passwort</label>
- <div class="col-sm-10">
- <input type="password" class="form-control" id="inputPassword3" name="inputPassword3" placeholder="Gewünschtes Passwort">
- </div>
- </div>
- <div class="form-group">
- <div class="col-sm-offset-2 col-sm-10">
- <button type="submit" name="submit" class="btn btn-default" value='Login'>Account anlegen</button>
- </div>
- </div>
- </form>
- <!-- Navigation -->
- <nav class="navbar navbar-inverse navbar-fixed-top" role="navigation">
- <div class="container">
- <!-- Brand and toggle get grouped for better mobile display -->
- <div class="navbar-header">
- <button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
- <span class="sr-only">Toggle navigation</span>
- <span class="glyphicon glyphicon-task" aria-hidden="true"></span>
- <span class="icon-bar"></span>
- <span class="icon-bar"></span>
- </button>
- <a class="navbar-brand" href="http://www.ryan-service.de/index.html">Home</a>
- </div>
- <!-- Collect the nav links, forms, and other content for toggling -->
- <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
- <ul class="nav navbar-nav">
- <li>
- <a href="http://www.ryan-service.de/changelog.html">Updates</a>
- </li>
- <li>
- <a href="http://www.ryan-service.de/register.html">Account Beantragen</a>
- </li>
- <li>
- <a href="http://www.ryan-service.de/contact.html">Bugmelden / Kontakt</a>
- </li>
- <li>
- <a href="http://www.ryan-service.de/acp.html">Adminpanel</a>
- </li>
- </ul>
- </div>
- <!-- /.navbar-collapse -->
- </div>
- <!-- /.container -->
- </nav>
- <!-- jQuery Version 1.11.1 -->
- <script src="bootstrap/js/jquery.js"></script>
- <!-- Bootstrap Core JavaScript -->
- <script src="bootstrap/js/bootstrap.min.js"></script>
- </body>
- </html>
- <?php
- $host = "localhost";
- $user = "***";
- $pass = "**";
- $db = "**";
- mysql_connect($host, $user, $pass) or die("Die Verbindung zur MySQL Datenbank konnte nicht hergestellt werden. (1)");
- mysql_select_db($db) or die("Die Verbindung zur MySQL Datenbank konnte nicht hergestellt werden. (2)");
- $submit = $_POST['submit'];
- $username = sanitize($_POST['inputUser3']);
- $password = sanitize($_POST['inputPassword3']);
- if($submit) //Wenn er auf den Submit Button klickt
- {
- if($username && $password) //Wenn er sowohl von Username und Passwort tippt und nicht eine von dem (Stand so dort hab also keine Fehler gemacht :D)
- {
- $query = mysql_query("SELECT Name, Passwort FROM accounts WHERE Name = '$username'"); //Auswählen von Username und Passwort ,ändert es in euere Field names , ändert Users in eurer Tabellen Namen ,$username bedeutet username wenn er dass tippt
- if(mysql_num_rows($query) == 0) //if user exists Wenn User existiert
- {
- $create_user = "CREATE USER IF NOT EXISTS '".$username."'@'localhost' IDENTIFIED BY '".$password."';";
- $user_zuweisen = "GRANT USAGE ON * . * TO '".$username."'@'localhost' IDENTIFIED BY '".$password."' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;";
- $user_rechte = "GRANT ALL PRIVILEGES ON ".$db." . * TO '".$username."'@'localhost';";
- <div class="alert alert-success" role="alert"> test </div> //Hier der Fehler?!
- }
- else <div class="alert alert-danger" role="alert">test </div>
- }
- else <div class="alert alert-danger" role="alert">test </div>
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement