Member script question not in FAQ.

[London]

First of all, thanks for this great great tutorial, it works, I couldn't believe it when I got the activation code, tip top stuff like we say here...

I've got a rather simple question I hope....supposing I don't want them to have a username but use their email address as a log in how would one go about doing this? I guess the database script that we started with would have to be changed?

After they log in successfully how can I direct them to a page I want? I don't want them directed to members.php or better yet, I don't want them staying there, as soon as everything it's successful I want them to be kicked back to a page I want or if it's not to complex, the page they were looking at before they decided to log in.

I luv this tutorial, it's almost like a script the way it worked like a charm, I wish I discovered it weeks ago not when I got 2 days to my php deadline project.

Thank you.

[scrowler]

First of all, thanks for this great great tutorial, it works, I couldn't believe it when I got the activation code, tip top stuff like we say here...

thanks alot glad you liked it

I've got a rather simple question I hope....supposing I don't want them to have a username but use their email address as a log in how would one go about doing this? I guess the database script that we started with would have to be changed?

yes, very simple!

http://www.biorust.com/tutorials/detail/116/us/ - login.php

PHP Code:

$query = mysql_query("SELECT * FROM Users WHERE Username = '$username' AND Password = '$password' LIMIT 1") or die(mysql_error()); 


simply change to this:

PHP Code:

$query = mysql_query("SELECT * FROM Users WHERE Email = '$username' AND Password = '$password' LIMIT 1") or die(mysql_error()); 


note: there may be some implications with this further on in the script e.g. closing your account etc, but this is a simple way to do what you want to do. if you wanted your entire script based around emails instead of usernames you would just have to strip the username instances out of everything and replace them with emails, or just remove them and leave email fields there. the database would have to be changed yes.

After they log in successfully how can I direct them to a page I want? I don't want them directed to members.php or better yet, I don't want them staying there, as soon as everything it's successful I want them to be kicked back to a page I want or if it's not to complex, the page they were looking at before they decided to log in.

simple again!

(same page, login.php):

PHP Code:

 header("Location: member.php"); 


change "member.php" to whatever you want

Thank you.

no problem

[London]

Thank you Scrowler, I sincerely appreciate this.

[scrowler]

no problem, i'll look into this a bit further at some stage and find if there are any further implications in simply doing what i said, and then put it up on the FAQ incase anyone else is wondering

[London]

Yeah, I'll go thru all the files and see since that code appears a few times... look at the database script...

PHP Code:

CREATE TABLE `Users` (
`id` int(11) NOT NULL auto_increment,
`Username` text NOT NULL,
`Password` varchar(32) NOT NULL default '',
`Name` text NOT NULL,
`Email` text NOT NULL,
`Date` text NOT NULL,
`IP` text NOT NULL,
`Actkey` varchar(40) NOT NULL default '',
`Activated` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) 


If I take out the username part, would that fix it? `Username` text NOT NULL, since I don't need that, only their email...and I know I saw one or 2 parts where it made references to "username can't be the same", I guess I'd adjust those files too...sorry to be bothering you.

[scrowler]

if you take out the username column, make sure you also take out any part of the script that uses that column otherwise you will get ALOT of errors from php!

[psychophat]

Scrowler, can your "A Complete Membership System" be integrated with the database of the forums such as SMF, gallery like coppermine and alike so that there would only be one login area for all?