Advertisement
Guest User

Help11!!!111

a guest
Aug 29th, 2015
180
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
HTML 4.90 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html lang="en">
  3.  
  4. <head>
  5.  
  6.     <meta charset="utf-8">
  7.     <meta http-equiv="X-UA-Compatible" content="IE=edge">
  8.     <meta name="viewport" content="width=device-width, initial-scale=1">
  9.     <meta name="description" content="">
  10.     <meta name="author" content="">
  11.  
  12.     <title>ryan-service</title>
  13.  
  14.     <!-- Bootstrap Core CSS -->
  15.     <link href="bootstrap/css/bootstrap.min.css" rel="stylesheet">
  16.  
  17.     <!-- Custom CSS -->
  18.     <style>
  19.     body {
  20.         padding-top: 70px;
  21.         /* Required padding for .navbar-fixed-top. Remove if using .navbar-static-top. Change if height of navigation changes. */
  22.     }
  23.     </style>
  24. </head>
  25.  
  26. <body>
  27.  
  28.     <form class="form-horizontal" action='register.php' method='POST'>
  29.         <div class="form-group">
  30.             <label for="inputUser3" class="col-sm-2 control-label">Benutzername</label>
  31.                 <div class="col-sm-10">
  32.                     <input type="text" class="form-control" id="inputUser3" name="inputUser3" placeholder="RPG-City Benutzername">
  33.                 </div>
  34.         </div>
  35.         <div class="form-group">
  36.             <label for="inputPassword3" class="col-sm-2 control-label">Passwort</label>
  37.             <div class="col-sm-10">
  38.                 <input type="password" class="form-control" id="inputPassword3" name="inputPassword3" placeholder="Gewünschtes Passwort">
  39.             </div>
  40.         </div>
  41.         <div class="form-group">
  42.             <div class="col-sm-offset-2 col-sm-10">
  43.                 <button type="submit" name="submit" class="btn btn-default" value='Login'>Account anlegen</button>
  44.             </div>
  45.         </div>
  46.     </form>
  47.     <!-- Navigation -->
  48.     <nav class="navbar navbar-inverse navbar-fixed-top" role="navigation">
  49.         <div class="container">
  50.             <!-- Brand and toggle get grouped for better mobile display -->
  51.             <div class="navbar-header">
  52.                 <button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
  53.                     <span class="sr-only">Toggle navigation</span>
  54.                     <span class="glyphicon glyphicon-task" aria-hidden="true"></span>
  55.                     <span class="icon-bar"></span>
  56.                     <span class="icon-bar"></span>
  57.                 </button>
  58.                 <a class="navbar-brand" href="http://www.ryan-service.de/index.html">Home</a>
  59.             </div>
  60.             <!-- Collect the nav links, forms, and other content for toggling -->
  61.             <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
  62.                 <ul class="nav navbar-nav">
  63.                     <li>
  64.                         <a href="http://www.ryan-service.de/changelog.html">Updates</a>
  65.                     </li>
  66.                     <li>
  67.                         <a href="http://www.ryan-service.de/register.html">Account Beantragen</a>
  68.                     </li>
  69.                     <li>
  70.                         <a href="http://www.ryan-service.de/contact.html">Bugmelden / Kontakt</a>
  71.                     </li>
  72.                     <li>
  73.                         <a href="http://www.ryan-service.de/acp.html">Adminpanel</a>
  74.                     </li>
  75.                 </ul>
  76.             </div>
  77.             <!-- /.navbar-collapse -->
  78.         </div>
  79.         <!-- /.container -->
  80.     </nav>
  81.  
  82.     <!-- jQuery Version 1.11.1 -->
  83.     <script src="bootstrap/js/jquery.js"></script>
  84.  
  85.     <!-- Bootstrap Core JavaScript -->
  86.     <script src="bootstrap/js/bootstrap.min.js"></script>
  87.  
  88. </body>
  89.  
  90. </html>
  91. <?php
  92.     $host = "localhost";
  93.     $user = "***";
  94.     $pass = "**";
  95.     $db = "**";
  96.     mysql_connect($host, $user, $pass) or die("Die Verbindung zur MySQL Datenbank konnte nicht hergestellt werden. (1)");
  97.     mysql_select_db($db) or die("Die Verbindung zur MySQL Datenbank konnte nicht hergestellt werden. (2)");
  98.     $submit = $_POST['submit'];
  99.     $username = sanitize($_POST['inputUser3']);
  100.     $password = sanitize($_POST['inputPassword3']);
  101.     if($submit) //Wenn er auf den Submit Button klickt
  102.     {    
  103.         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)
  104.         {
  105.             $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
  106.             if(mysql_num_rows($query) == 0) //if user exists Wenn User existiert
  107.             {
  108.                 $create_user = "CREATE USER IF NOT EXISTS '".$username."'@'localhost' IDENTIFIED BY  '".$password."';";
  109.                 $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 ;";
  110.                 $user_rechte = "GRANT ALL PRIVILEGES ON  ".$db." . * TO  '".$username."'@'localhost';";
  111.                 <div class="alert alert-success" role="alert"> test </div> //Hier der Fehler?!
  112.             }
  113.             else <div class="alert alert-danger" role="alert">test </div>
  114.         }
  115.         else <div class="alert alert-danger" role="alert">test </div>
  116.     }
  117. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement