<?php if (! defined ('PmWiki')) exit;

$AuthForm      =<<<AUTHFORM
<form name='authform' action='{$_SERVER['REQUEST_URI']}' method='post'>
Name:     <input tabindex='1' type='text' name='authid' value=''><br />
Password: <input tabindex='2' type='password' name='authpw' value=''><br />
<input type='hidden' name='authaction' value='1'>
<input type='submit' value='OK'>
<script language='javascript'<!-- document.authform.authid.focus() //--></script>
</form>

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;
}