Loggin in and remembering password

[todd thompson]

Hi,
One of the most impressive features I've noticed on the site is your login and send password functions you have for the main area.

I would love to see how this works as more than any of the tutorials on the site, this one would be the most commonly used and beneficial to someone like myself.

How bout a tutorial on this one?

Great stuff by the way, I go here probaly about 4 times per week looking for something new.

[Flash-db]

This is the basic - I didn't include all of the code - but this is most of it:

$UserNameEnterNew = $HTTP_POST_VARS[UserNameEnterNew];
$PasswordEnterNew = $HTTP_POST_VARS[PasswordEnterNew];

$UserNameEnterNew = ereg_replace("[^A-Za-z0-9\-\_\ ]", "", $UserNameEnterNew);
$PasswordEnterNew = ereg_replace("[^A-Za-z0-9\-\_\ ]", "", $PasswordEnterNew);

$UserNameEnterNew = trim($UserNameEnterNew);
$PasswordEnterNew = trim($PasswordEnterNew);

$logTime = time();

mysql_connect($DBhost,$DBuser,$DBpass);
mysql_select_db($DBName);

   $request = mysql_query("SELECT passwd,realName,emailAddress,websiteTitle,websiteUrl,signature,posts,memberGroup,ICQ,AIM,YIM,gender,personalText,avatar,dateRegistered,location,birthdate,timeFormat,timeOffset,hideEmail,MSN,visits FROM members WHERE memberName='$UserNameEnterNew'");

   if (mysql_num_rows($request) == 0) {

   print "StopCheck=Stop&UserName=&Password=&displayName=Guest&Status=We where unable to locate your information please register or try Logging in Again - or Registering Error Code 1&";
   $identity = $REMOTE_ADDR;
   $request3 = mysql_query ("DELETE FROM log_online WHERE (logTime < ".($logTime - 900)." or identity='$identity')");
   $request4 = mysql_query ("INSERT INTO log_online (identity,logTime) VALUES ('$identity',$logTime)");

   } else {
      $settings = mysql_fetch_row($request);

      if ($settings[0] != $PasswordEnterNew) {
      print "StopCheck=Stop&UserName=&Password=&displayName=Guest&Status=We where unable to locate your information please register or try Logging in Again - or Registering Error Code 2&";

   $identity = $REMOTE_ADDR;
   $request3 = mysql_query ("DELETE FROM log_online WHERE (logTime < ".($logTime - 900)." or identity='$identity')");
   $request4 = mysql_query ("INSERT INTO log_online (identity,logTime) VALUES ('$identity',$logTime)");
      } else {
   setCookie ("UserNameEnter",$UserNameEnterNew, time()+30240000, "/");
   setCookie ("PasswordEnter",$PasswordEnterNew, time()+30240000, "/");
   setCookie ("expiretime",time()+(60*900),time()+30240000, "/");

         if (!$settings[21]) {
         $Visits = '1';
         } else { $Visits = $settings[21]; }
      $resultVisits = mysql_query("UPDATE members SET visits = '$Visits' + 1 WHERE (memberName = '$UserNameEnterNew')");
   
   $identity = $UserNameEnterNew;
   $request3 = mysql_query ("DELETE FROM log_online WHERE (logTime < ".($logTime - 900)." or identity='$identity')");
   $request4 = mysql_query ("INSERT INTO log_online (identity,logTime) VALUES ('$identity',$logTime)");

   $lastLog=time();
   $result =  mysql_query("UPDATE members SET lastLogin='$lastLog' WHERE memberName='$UserNameEnterNew'");

   print "Status=Welcome $UserNameEnterNew, you have successfully logged into Flash-db for the $Visits Time&UserName=$UserNameEnterNew&Password=$PasswordEnterNew&FirstName=$settings[1]&Email=$settings[2]&URLTitle=$settings[3]&URL=$settings[4]&Location=$settings[15]&displayName=$UserNameEnterNew&";