Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- register.php
- PHP Code:
- <?php
- include "functions.php";
- if(isset($_POST['submit']))
- {
- $server = "PCNAMESQLEXPRESS";
- $user = "sa";
- $pass= "PASSWORT";
- $username = strtolower(trim(htmlspecialchars(addslashes($_POST['username']))));
- $password = md5("kikugalanet".$_POST['password']);
- ################################################## ###########
- if(strlen($username) < 4 ||
- strlen($username) > 16)
- {
- die("Dein Benutzername ist zu kurz/lang .<br>Er muss zwischen <b><u>4 und 16</u></b> Zeichen lang sein .");
- }
- if(strlen($_POST['password']) < 4 ||
- strlen($_POST['password']) > 16)
- {
- die("Dein Passwort ist zu kurz/lang .<br>Es muss zwischen <b><u>4 und 16</u></b> Zeichen lang sein .");
- }
- ################################################## ###########
- $conn = mssql_connect($server,$user,$pass);
- if(!$conn)
- {
- die("Connection failed!<br>");
- }
- $select = mssql_select_db("ACCOUNT_DBF",$conn);
- if(!$select)
- {
- die("Can't select Database!<br>");
- }
- ################################################## ###########
- if(exist($username) != '0')
- {
- die ("Der Benutzername ".$username." wird schon benutzt .");
- }
- ################################################## ###########
- $bind = mssql_init("createaccount",$conn);
- if(!$bind)
- {
- die("Couldn't Bind Variables.<br>");
- }
- $acc = $username;
- $pass = $password;
- $ipadress = $ip;
- mssql_bind($bind, '@account' , $acc , SQLVARCHAR);
- mssql_bind($bind, '@password', $pass, SQLVARCHAR);
- $execute = mssql_execute($bind);
- if($execute)
- {
- echo 'Account wurde <font color="green">erfolgreich</font> erstellt !';
- }
- else
- {
- echo 'Account erstellung<font color="red">fehlgeschlagen</font> !';
- }
- mssql_close($conn);
- }
- else
- {
- ?>
- <center>
- <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
- <table>
- <tr>
- <td colspan="2" align ="center">
- <h3>Account erstellen</h3>
- </td>
- </tr>
- <tr>
- <td align ="right">
- Account :
- </td>
- <td>
- <input type="text" size="20" name="username" maxlength="15" />
- </td>
- <td> </td>
- </tr>
- <tr>
- <td align ="right">
- Passwort :
- </td>
- <td>
- <input type="password" size="20" name="password" maxlength="32" />
- </td>
- </tr>
- <tr>
- <td colspan="2" align="center">
- <input type="submit" name="submit" value="Account erstellen" />
- </td>
- </tr>
- </table>
- </form>
- </center>
- <?php
- }
- ?>
- functions.php
- PHP Code:
- <?php
- function exist($account){
- $sql = "SELECT * FROM ACCOUNT_TBL WHERE account='".$account."'";
- $result = mssql_query($sql);
- if(!$result) {
- die("MSSQL Error");
- }
- $check = mssql_num_rows($result);
- return $check;
- }
- function existip($ip){
- $sql = "SELECT * FROM ACCOUNT_TBL_DETAIL WHERE ip='".$ip."'";
- $result = mssql_query($sql);
- if(!$result) {
- die("MSSQL Error");
- }
- $check = mssql_num_rows($result);
- return $check;
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement