Jump to content


Photo

Registration page/PHPBB help


  • Please log in to reply
No replies to this topic

#1 treilad

treilad
  • Members
  • PipPipPip
  • Advanced Member
  • 58 posts

Posted 21 July 2006 - 02:06 AM

I had just gotten my login system working and downloaded PHPBB, when I realized that when people register, I don't want them to have to register again on my forum. I'd like to have a registration code that puts the info into both tables, but I don't want them to have to register with PHPBB first. I don't know how to do that since PHPBB's register script is a lot more complicated than the one I'm running. After that, I also decided to update my registration code, which I haven't gotten working yet. So here is my new code that I copied from somewhere and edited a little bit, (hence the third-party forum):

<?php
ob_start();
include("db.php");

if($_POST['register']){
$username = $_POST['username'];
$password = $_POST['pass'];
$cpassword = $_POST['cpass'];
$email = $_POST['emai1'];

if($username==NULL|$password==NULL|$cpassword==NULL|$email==NULL){

echo "A Field was left blank.";
}else{
if($password != $cpassword){
echo "Passwords do not match";
}else{
$password = md5($password));

$checkname = mysql_query("SELECT username FROM users WHERE username='$username'");
$checkname = mysql_num_rows($checkname);
$checkemail = mysql_query("SELECT email from users WHERE email='$email'");
$checkemail = mysql_num_rows($checkemail);
if($checkemail>0){
echo "We already have a registered user with that email address. Please only register one account.";
}
if($checkname>0){
echo "This username is already in use. Please try another or <a href="./index.php">login</a>.
}
else
{
$username = htmlspecialchars($username);
$password = htmlspecialchars($password);
$email = htmlspecialchars($email);

   $valnum[1]="789542433888764";
   $valnum[2]="876954214834687";
   $valnum[3]="138732418699423";
   $valnum[4]="546311421867355";
   $valnum[5]="875632177863879";
   $valnum[6]="789876546489646";
   $valnum[7]="847515815845181";
   $valnum[8]="848584185618485";
   $valnum[9]="946181458518515";
   $valnum[10]="321312515813485";
   $random = rand(1, count($valnum)); 
$userval = "$valnum[$random]";


$query = mysql_query("INSERT INTO users (username, password, email, val_num) VALUES('$username','$password','$email', '$userval')");


mail("$email", "Please validate your account.", "Thank you for registering at YOURSITE. Please use the link below to validate your account.

Username: $username
Validation Code: $userval
To validate your account, visit: http://localhost/validate.php?username={$_POST['username']}

If your username has spaces in it, you must replace them with %20");
echo "You have successfully registered! Please check your email for your validation link!";
}
}
}
}else{
echo ("
<center>
<form method=\"POST\">
Username: <input type=\"text\" size=\"15\" maxlength=\"25\" name=\"username\"><br />
Password: <input type=\"password\" size=\"15\" maxlength=\"25\" name=\"pass\"><br />
Confirm Password: <input type=\"password\" size=\"15\" maxlength=\"25\" name=\"cpass\"><br />
Email: <input type=\"text\" size=\"15\" maxlength=\"25\" name=\"emai1\"> (Requires Validation)<br />
<input name=\"register\" type=\"submit\" value=\"Register\">
</form>
</center>
");
}
?>

Here is my login script:

<?php
ob_start();
include("db.php");

if($_POST['register']){
$username = $_POST['username'];
$password = $_POST['pass'];
$cpassword = $_POST['cpass'];
$email = $_POST['emai1'];

if($username==NULL|$password==NULL|$cpassword==NULL|$email==NULL){

echo "A Field was left blank.";
}else{
if($password != $cpassword){
echo "Passwords do not match";
}else{
$password = md5($password));

$checkname = mysql_query("SELECT username FROM users WHERE username='$username'");
$checkname = mysql_num_rows($checkname);
$checkemail = mysql_query("SELECT email from users WHERE email='$email'");
$checkemail = mysql_num_rows($checkemail);
if($checkemail>0){
echo "We already have a registered user with that email address. Please only register one account.";
}
if($checkname>0){
echo "This username is already in use. Please try another or <a href="./index.php">login</a>.
}
else
{
$username = htmlspecialchars($username);
$password = htmlspecialchars($password);
$email = htmlspecialchars($email);

   $valnum[1]="789542433888764";
   $valnum[2]="876954214834687";
   $valnum[3]="138732418699423";
   $valnum[4]="546311421867355";
   $valnum[5]="875632177863879";
   $valnum[6]="789876546489646";
   $valnum[7]="847515815845181";
   $valnum[8]="848584185618485";
   $valnum[9]="946181458518515";
   $valnum[10]="321312515813485";
   $random = rand(1, count($valnum)); 
$userval = "$valnum[$random]";


$query = mysql_query("INSERT INTO users (username, password, email, val_num) VALUES('$username','$password','$email', '$userval')");


mail("$email", "Please validate your account.", "Thank you for registering at YOURSITE. Please use the link below to validate your account.

Username: $username
Validation Code: $userval
To validate your account, visit: http://localhost/validate.php?username={$_POST['username']}

If your username has spaces in it, you must replace them with %20");
echo "You have successfully registered! Please check your email for your validation link!";
}
}
}
}else{
echo ("
<center>
<form method=\"POST\">
Username: <input type=\"text\" size=\"15\" maxlength=\"25\" name=\"username\"><br />
Password: <input type=\"password\" size=\"15\" maxlength=\"25\" name=\"pass\"><br />
Confirm Password: <input type=\"password\" size=\"15\" maxlength=\"25\" name=\"cpass\"><br />
Email: <input type=\"text\" size=\"15\" maxlength=\"25\" name=\"emai1\"> (Requires Validation)<br />
<input name=\"register\" type=\"submit\" value=\"Register\">
</form>
</center>
");
}
?>

Any tips on making these cooperate? I haven't done a whole lot to the registration code so I'm quite sure that it needs some/a lot of editing. If it's impossible or would be too much trouble to have registration on my website rather than registering on PHPBB, then I'll gladly just make the registration on PHPBB. Thanks in advance. :)

-Matt




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users