Registering problem

cheat · 02-03-2007, 08:08 PM

ok heres a script for complete.php i am making a mmorpg but i am having trouble with the registering, the register.php allows a player to regster but doesnt add to the database, i have been told that the error is somewhere in the following script.
i know that i should upload the file but it wont so ill have post it here..

PHP Code:


			
<?php
session_start();
include("conn.php");
$country = $_POST[location];
if ($country == "England") {
    $drug_prices = "8-13-21-9-106-36-32-103-159";
} elseif ($country == "France") {
    $drug_prices = "12-54-28-2-129-29-19-97-147";
} elseif ($country == "Italy") {
    $drug_prices = "10-26-54-19-97-23-25-89-153";
} elseif ($country == "Germany") {
    $drug_prices = "11-47-13-121-39-12-93-149-131";
} elseif ($country == "China") {
   $drug_prices = "7-38-17-22-152-27-14-95-144";
} elseif ($country == "Russia") {
   $drug_prices = "4-41-33-7-122-65-21-94-120";
} elseif ($country == "Mexico") {
   $drug_prices = "11-40-28-14-136-21-81-100-160";
} elseif ($country == "Japan") {
   $drug_prices = "9-45-22-63-101-30-100-87-152";
} elseif ($country == "Australia") {
   $drug_prices = "21-33-27-6-100-35-22-88-133";
}
?>
<html>
<head>
<title>Sign Up</title>
<style type="text/css">
<!--
body,td,th {
    color: #FFFFFF;
}
body {
    background-color: #000000;
}
a:link {
    color: #00FFFF;
    text-decoration: underline;
}
a:visited {
    text-decoration: underline;
    color: #00FFFF;
}
a:hover {
    text-decoration: none;
    color: #FFFFFF;
}
a:active {
    text-decoration: underline;
}
-->
</style>
</head>
<body>
<?php
$time = time();
$email = $_POST["email"];
$user = str_replace(" ", "_", $_POST[username]);
$username = strtolower($user);
$user_exist = mysql_query("SELECT * FROM users WHERE username='$username'") or die(mysql_error());
if (mysql_num_rows($user_exist) == "1") {
    echo "Username already in use";
} else {
    $sql = "INSERT INTO users VALUES ('', '$username', password('$_POST[password]'), '$_POST[full_name]', '$email', '0', '0', '500', 'none', '100', '0', '0', '0', '0', 'alive', '0', '0', '0', '$time', '0', '$country', '0','0', '0', 'no', '', '1', '$drug_prices', '0', 'none', 'middle.jpg', 'none', '$_POST[username]', '0', '0', '0', '0', '0', '1')";
    $_SESSION["name"] = $_POST["username"];
    if (mysql_query($sql, $conn)) {
        echo "Succesful signup!<br><a href='index.php'>Sign in</a>";
    } else { 
        echo "Unsucessful sign-up please try again";
    }
}
?>
</body>
</html>

guelphdad · 02-03-2007, 08:37 PM

Please don't post an entire script.

Please don't say "the error" is somewhere in the script. Run the script, report/post the error as well as the line number the error is on.

post the line the error is reported on and a few lines before and after that line.

cheat · 02-03-2007, 09:11 PM

the problem with that is i dont know where the error is i think it might be in the insert but it doesnt show any error when i run the script it allows the person to register but it wont add the details to the database.