Name:
Password:
AUTHFORM;
$AuthPromptFmt = array(&$PageStartFmt, $AuthForm, &$PageEndFmt);
if ($_POST['authaction']) {
$dbauth = array(
'host' => 'localhost',
'db' => 'db',
'user' => 'user',
'password' => 'pass',
'table' => 'table',
'userfield' => 'username',
'pwfield' => 'password'
);
getForumUserPassword($dbauth);
}
function getForumUserPassword($dbauth) {
global $AuthUser;
$link = mysql_connect($dbauth['host'],$dbauth['user'],$dbauth['password']);
if (!$link) { die('Could not connect: '.mysql_error()); }
@mysql_select_db($dbauth['db'])
or die("Unable to select database $dbauth[db]: ".mysql_error());
$user = $dbauth['userfield'];
$pass = $dbauth['pwfield'];
$query = "SELECT $user, $pass FROM $dbauth[table]";
$result = mysql_query($query);
if (!$result) {
die("Could not successfully run query ($query) from DB: ".mysql_error());
}
if (mysql_num_rows($result) > 0) {
while ($r = mysql_fetch_assoc($result)) {
$AuthUser[$r[$user]] = $r[$pass];
}
}
mysql_close;
}