Register page ep3

[redfryone]

you could link me or send me a pm registration page last chaos ep2 / 3?
thanks in advance

there is some guidance on how to modify?
Sorry for google translate

[guiguipsp]

In db_auth, on bg_user table add fields : email (varchar 200) and passwd (varchar 60)

After register work (for LC CMS in ep3 db)

[primax123]

PHP

 Spoiler

PHP Code:


$verbindung= mysql_connect("ip/domain", "username" , "password") 
or die("Cannot connect to db"); 

mysql_select_db("newproject_db_auth") or die ("Cannot connect to newproject_db_auth"); 


$username = $_POST["username"];
$passwort = $_POST["passwort"]; 
$passwort2 = $_POST["passwort2"];
$email = $_POST["email"];  


if($passwort != $passwort2 OR $username == "" OR $passwort == "") 
    { 
    echo '';
    exit; 
    } 
$passwort = md5($passwort); 
$result = mysql_query("SELECT user_id FROM bg_user WHERE user_id LIKE '$username'"); 
$menge = mysql_num_rows($result); 

if($menge == 0) 
    { 
    $eintrag = "INSERT INTO bg_user (user_id, passwd, email) VALUES ('$username', '$passwort', '$email')"; 
    $eintragen = mysql_query($eintrag); 

    if($eintragen == true) 
        { 
echo "acc successfully created <p>
Username: $username<p>
Password: .... ";

    } 
    else 
        { 
    echo 'something went wrong';
        } 


    } 

else 
    { 
    echo 'acc id in use';
    } 
?> 


html (just example important is "name" and "form action")

 Spoiler

<form action=" register page or php self.. ">
  <table border="0" cellpadding="5" cellspacing="0" bgcolor="#E0E0E0">
    <tr>
      <td align="right">Username:</td>
      <td><input name="username" type="text" size="30" maxlength="30"></td>
    </tr>
    <tr>
      <td align="right">Password:</td>
      <td><input name="passwort" type="text" size="30" maxlength="40"></td>
    </tr>
    <tr>
      <td align="right">Confirm Password:</td>
      <td><input name="passwort2" type="text" size="30" maxlength="40"></td>
    </tr>
    <tr>
      <td align="right" valign="top">Email:</td>
      <td><textarea name="email" rows="10" cols="50"></textarea></td>
    </tr>
    <tr>
      <td>
        <input type="submit" value=" Register">
      </td>
    </tr>
  </table>
</form>

very simple you can add some features like save ip, register time and more..