[Aceman]

A friend of mine who's a PHP GOD.. helped me figure this one out. Daneel.. you da man!

You can use the following code to accept a username and password from a form and then compare it to what's stored in the VB3 Database. NOTE This takes into account the md5 and salt encryption. It works perfectly for me.

// hostname or ip of server
	$servername='localhost';

	// username and password to log onto db server
	$dbusername='?????????';
	$dbpassword='?????????';

	// name of database ($dbname2 is my VB3 database)
	$dbname='MY_contest';
	$dbname2='MY_forum';

	/* Connecting, selecting database */
	$link = mysql_connect($servername, $dbusername, $dbpassword)
		or die("Could not connect");
	print "Connected successfully<br><br>";
	mysql_select_db($dbname2) or die("Could not select database");

	/* Necessary fields filled? */
	if (!$username || !$password || !$name || !$country || !$email || !$picture || !$stats)
		die("Fill in all necessary fields.");


	/* password correct? */
	$query = "SELECT salt, password FROM user WHERE username='$username'"; 
	$result = mysql_query($query) or die("The information you entered does not match our records.");
	$row=mysql_fetch_array($result);

	$dbpassword = $row['password'];
	$salt = $row['salt'];	

	if ($dbpassword == md5(md5($password). $salt)) {
		print "Password correct<br><br>";
	}
	else {
		die("password not correct!");
	}

Then just place the rest of whatever you need your page to do after the password comparison.

I honestly have yet to find this code posted anywhere on VB.org and VB.com so I hope this helps someone!

Aceman