Forum help

[zingbats]

I'm making a gateway script that only allows a forum user to enter an area if they have over 5 points.

The code I have so far, selects the username and points from the MySQL tables.

The PHPBB2 password tables are encrypted using the MD5 encyrption.

How would I encorporate the password checking in the code below. Also, I can only seem to make it print the correct message if you have 5 points only, not more than. How could I make the file print the correct message if the users' points were OVER or EQUAL to 5?

<?php


mysql_connect("localhost","zingbats","WHEVER PWL");
mysql_select_db (tycooneden_com);
$user_id = ( isset($HTTP_GET_VARS['user_id']) ) ? intval($HTTP_GET_VARS['user_id']) : 0;

$sql = "SELECT * FROM `phpbb_users` WHERE username = '$user'";
$result = mysql_query($sql);
while($r=mysql_fetch_array($result)) /*this causes the loop to be ran until the query is empty*/ 
{   

        $user_points = $r["user_points"];
        $username = $r["username"];

print "welcome ";
print $username;

if ($userpoints = 5) {
print " you do not have 5 points";
} else {
print " you do have 5 points";
}

}
?>

[mogster]

Hi!

The equal in an if-else should be double:

print "welcome ";
print $username;
if ($userpoints == 5) {
print " you do have 5 points";
} else {
print " you do not have 5 points, but more or less than 5 points";
}

And if your'e gonna check if it's equal or more:

print "welcome ";
print $username;
if ($userpoints >= 5) {
print " you do have 5 points";
} else {
print " you do not have 5 points";
}

But why not print the userpoints too?

print "welcome ";
print $username;
if ($userpoints >= 5) {
print " you do have 5 or more points. Your score: $userpoints";
} else {
print " you do not have 5 points yet. Your score: $userpoints";
}

knutm

[mogster]

You could also turn the if-else around and ask wether the score is 4 or less:

print "welcome ";
print $username;
if ($userpoints <= 4) {
print " you do not have 5 points yet, but you're getting close! Your score: $userpoints";
} else {
print " You have reached the magical 5 points! Your score: $userpoints";
}

knutm

[mogster]

Ahem...discovered an error in the value-specification:
$user_points = $r["user_points"];
should be
$userpoints = $r["user_points"];
else you need to change the other code.

knutm

[zingbats]

you know anything about the encryption thingy?