Quick registration on non-vb page

[Franki]

Ok, I tried the php file that worked with vb2:

PHP Code:

<?php

///////////////////////////////////////////////////////////////////////////////////////////////////////////////////
// VARIABLES
// $config = relative path to your vBulletin's /admin/config.php (must be on same server)
// $groupid = user group ID for people who register using this form
// $redirect = the name of the page for redirection after submitting the form
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////

// board information
$config="/path_to_forums/includes/config.php";
$groupid="the_groupid_you_wany";
$redirect="redirect_to_this_page";

///////////////////////////////////////////////////////////////////////////
// DO NOT MODIFY ANYTHING BELOW HERE 
// UNLESS YOU KNOW WHAT YOU ARE DOING
///////////////////////////////////////////////////////////////////////////

$config=strtolower($config);
require($config);

$connect=mysql_connect($servername,$dbusername,$dbpassword);
mysql_select_db($dbname);

if ($submit) {
    $unique=mysql_query("SELECT username FROM user WHERE username='$username'");
    if (mysql_num_rows($unique) > 0) {
        print "<b>That username already exists, please choose another!</b>";
    } else {
        $user=mysql_query("INSERT INTO user (usergroupid, username, password, email, joindate, lastvisit, lastactivity) VALUES ('".$groupid."', '".htmlspecialchars(addslashes($username))."', '".addslashes(md5($password))."', '".addslashes(htmlspecialchars($email))."', '".time()."', '".time()."', '".time()."')",$connect);
        $userid=mysql_insert_id();
        $userfields=mysql_query("INSERT INTO userfield (userid) VALUES ($userid)");
        if (($user==TRUE) and ($userid==TRUE) and ($userfields==TRUE)) {
print "<meta http-equiv='refresh' content='0;URL=$redirect'>";
                    }
    mysql_close($connect);
    }
}

?>

<form action='<?php print $_SERVER['PHP_SELF']; ?>' method='post'>
Username: <input type='text' name='username'>
<br>Password: <input type='password' name='password'>
<br>Email: <input type='text' name='email'>
<br><input type='submit' name='submit' value='Submit' accesskey='s'> 
<input type='reset' name='reset' value='Reset' accesskey='r'>
</form>

The user is being registered succesfully but the password doesn't seem to work. I can't login. Could someone edit the file in order to make it work?