IP using activation link

[Chotu]

Hi

I was wondering is it possible to get the client's ip when he clicks on an activation link? If yes how?

[wepnop]

Hi

I was wondering is it possible to get the client's ip when he clicks on an activation link? If yes how?

use this in the php form that responses that link:

 

$ip = $_SERVER['REMOTE_ADDR'];

[Chotu]

Could you show me one example how to response to the link ? Sorry I just learning this stuff and I'm stuck at this portion

 

[btherl]

Do you have a script already?  If you do, please post it.  If you don't have anything yet, I suggest looking for a tutorial or some sample code in google first.  Eg you can search for "php activation link code" or "php activation link tutorial"

[Chotu]

This is what me and my friend after some researching on the net wrote. Now  I have a ip column in the mysql table I dont know where to put it in this code

 

mysql_connect("localhost", DATABASE, "PASSWORD") or die(mysql_error());

mysql_select_db("USER_TABLENAME") or die(mysql_error());

if ($_POST['form_submitted'] == '1') {
##User is registering, insert data until we can activate it

$activationKey =  mt_rand() . mt_rand() . mt_rand() . mt_rand() . mt_rand();
$username = mysql_real_escape_string($_POST[username]);
$password = mysql_real_escape_string($_POST[password]);

$email = mysql_real_escape_string($_POST[email]);

$sql="INSERT INTO users (username, password, email, activationkey, status) VALUES ('$username', '$password', '$email', '$activationKey', 'verify')";

if (!mysql_query($sql))

  {

  die('Error: ' . mysql_error());

  }

echo "An email has been sent to $_POST[email] with an activation key. Please check your mail to complete registration.";

##Send activation Email

$to      = $_POST[email];

$subject = " doitright.com Registration";

$message = "Welcome to our website!\r\rYou, or someone using your email address, has completed registration . You can complete registration by clicking the following link:\rhttp://www..doitright.com/verify.php?$activationKey\r\rIf this is an error, ignore this email and you will be removed from our mailing list.\r\rRegards,\ YOURWEBSITE.com Team";

$headers = 'From: noreply@ doitright.com' . "\r\n" .

    'Reply-To: noreply@ doitright.com' . "\r\n" .

    'X-Mailer: PHP/' . phpversion();

mail($to, $subject, $message, $headers);

} else {

##User isn't registering, check verify code and change activation code to null, status to activated on success

$queryString = $_SERVER['QUERY_STRING'];

$query = "SELECT * FROM users"; 

$result = mysql_query($query) or die(mysql_error());

  while($row = mysql_fetch_array($result)){

    if ($queryString == $row["activationkey"]){

       echo "Congratulations!" . $row["username"] . " your account is activated";

       $sql="UPDATE users SET activationkey = '', status='activated' WHERE (id = $row[id])";

       if (!mysql_query($sql))

  {

        die('Error: ' . mysql_error());

  }

    }

  }

}

 

 

[btherl]

Can you try this (if the ip column is in the users table):

 

$sql="UPDATE users SET activationkey = '', status='activated', ip = '{$_SERVER['REMOTE_ADDR']}' WHERE (id = $row[id])";

 

It should replace the existing update query.

 

You may also want to replace the select with this:

 

$query = "SELECT * FROM users WHERE activationkey = '" . mysql_real_escape_string($queryString) . "'";

 

But that isn't necessary to get the script to work, it's just a sensible optimization.