Activation Link Readout

[team_lh_Max]

I am having a problem with my account activation link readout section of my code and seriously do not know what I am doing wrong. I hope you guys can see the error, i tried to circle it as close as possible, first the code:

		//Check if activation link is entered
		if (isset($_GET['userid'])) {

		if(isset($_GET['email'])) {

			if(isset($_GET['activationcode'])) {


					$userid = $_GET['userid'];
					$email = $_GET['email'];
					$activcode = $_GET['activationcode'];

					$request = mysql_query("SELECT * FROM login_table WHERE user_name = '" . $userid . "' AND user_email = '" . $email . "';");
					$row = mysql_fetch_object($request) or die( mysql_error() );
					$lname = $row->user_lname;
					$elname = md5('ajanxistubiar56892'. $lname);  						
					$id = $row->userid;
						/*
						if($activcode == $elname) {

							$activquery = "UPDATE `login_table` SET `user_level` = '1' WHERE `userid` = " . $id . " LIMIT 1;";
							mysql_query($cactivquery) or die( mysql_error() );
							echo "<center><font color=\"green\">Your Activation is now complete, you may login now!</font></center>";

						} else {

							echo "<center><font color=\"red\">The Activationcode is invalid!</font></center>";
						}*/

					echo "<br><br><br>";
					include("" . $absolute_path . "/elements/footer.php");
					exit();
			}

		} else {
			echo "<font color=\"red\"><u>Error:</u> Invalid Activation Link</p>";
			include("" . $absolute_path . "/elements/footer.php");
			exit();
		}
	}

But the line

						$row = mysql_fetch_object($request) or die( mysql_error() );

still makes the code underneath the line not be executed (i know since the footer is not displayed anymore).

When I outcomment that line the footer is there again.

Do you still see any error, i can't figure it out.

Thanks for help
greetz
max

[iNFERiON]

Try replacing:

$request = mysql_query("SELECT * FROM login_table WHERE user_name = '" . $userid . "' AND user_email = '" . $email . "';");
						$row = mysql_fetch_object($request) or die( mysql_error() );
						$lname = $row->user_lname;
						$elname = md5('ajanxistubiar56892'. $lname);  						
						$id = $row->userid;

with this:

$request = mysql_query("SELECT * FROM login_table WHERE user_name = '" . $userid . "' AND user_email = '" . $email . "';");
						while($row = mysql_fetch_assoc($request)){
							$lname = $row['user_lname'];
							$elname = md5('ajanxistubiar56892'. $lname);  

							$id = $row['userid'];
						}

[team_lh_Max]

Ok i did what you told me to, the footer is actually being displayed now but i can not get the variables $elname and $id to work which means something still must be wrong

What i tried

.
.
.
						//Re-Generate Activation code to check if it matches with the link
						$request = mysql_query("SELECT * FROM login_table WHERE user_name = '" . $userid . "' AND user_email = '" . $email . "';");
						 while($row = mysql_fetch_assoc($request)){ 
                            $lname = $row['user_lname']; 
                            $elname = md5('ajanxistubiar56892'. $lname);   

                            $id = $row['userid']; 
                        }
						echo "Activcode:  ";
						echo $activcode;
						echo "<br><br>";
						echo "ELname:  ";
						echo $elname;
						echo "<br><br>";
						echo "ID:  ";
						echo $id;
.
.
.

But what is being echo 'ed is:

Activcode: e6e75accf951d0d4e18fb3b0298e069e

ELname:

ID:

As you can see only the $activcode works.

Y is this happening, any ideas?

Best regards
max

[iNFERiON]

Must be in the field names. The field names in your database are probably different then I put in my example code.

A code like $row['test'] would get the content of the "test" field. But you might not have a field with that name, so if you edit the $row[] things to contain the field names you want fetched, it should work.

Example

I have a database containing the table users. I want to get the username and email fields associated with the user that has userid 18.

I would use this code:

$select = mysql_query('SELECT `username`, `email`,  FROM `users` WHERE userid=18 LIMIT 1');

while($row = mysql_fetch_assoc($select)) {
echo "Username: " . $row['username'] . "<br>\n";
echo "E-Mail Address: " . $row['email'] . "<br>\n";
}

[team_lh_Max]

No my fields names are correct.

I modified the code again a bit, here the newest version and the output in webbrowser:

		//Check if activation link is entered
		if (isset($_GET['userid'])) {

		if(isset($_GET['email'])) {

			if(isset($_GET['activationcode'])) {


					$userid = $_GET['userid'];
					$email = $_GET['email'];
					$activcode = $_GET['activationcode'];

					//Re-Generate Activation code to check if it matches with the link
					$request = mysql_query("SELECT * FROM login_table WHERE user_name = '$userid' AND user_email = '$email'");  
					 while($row = mysql_fetch_object($request)){ 
                        $lname = $row->user_lname; 
                        $elname = md5('ajanxistubiar56892'. $lname);   
                        $id = $row->user_id;
                    }

					echo "Activcode: $activcode <br>";
					echo "lname:  $lname <br>";
					echo "elname: $elname <br>";
					echo "id:  $id <br>";

						if($activcode == $elname) {

							$activquery = "UPDATE `login_table` SET `user_level` = '1' WHERE `userid` = " . $id . " LIMIT 1;";
							mysql_query($cactivquery) or die( mysql_error() );
							echo "<center><font color=\"green\">Your Activation is now complete, you may login now!</font></center>";

						} else {

							echo "<center><font color=\"red\">The Activationcode is invalid!</font></center>";
						}

					echo "<br><br><br>";
					include("" . $absolute_path . "/elements/footer.php");
					exit();
			}

		} else {
			echo "<font color=\"red\"><u>Error:</u> Invalid Activation Link</p>";
			include("" . $absolute_path . "/elements/footer.php");
			exit();
		}
	}

OUTPUT:

Activcode: e6e75accf951d0d4e18fb3b0298e069e
lname:
elname:
id:

The Activationcode is invalid!

[iNFERiON]

Don't use $row->, but $row[]. So you would get this:

$lname = $row['user_lname'];
$elname = md5('ajanxistubiar56892'. $lname);   

$id = $row['user_id'];

[team_lh_Max]

that does not help