function dologin($username, $password)
{
$enc = new Encryption();
$password = $enc->oneway_encode($password);
$db = new dbconnection();
$db->dbconnect();
$db->query = "select * from " . TABLE_USERS . " where username='******' and password='******'";
$db->execute();
if ($db->rowcount() > 0) {
$row = $db->fetchrow(0);
$userid = $row['userid'];
$ipaddr = $_SERVER['REMOTE_ADDR'];
$lastlogin = Date("Y-m-d H:i:s");
$db->query = "update " . TABLE_USERS . " set lastlogin='******' where userid={$userid}";
$db->execute();
$db->query = "insert into " . TABLE_USERLOGS . " (userid,ipaddress,logdate,action)\n values ({$userid},'{$ipaddr}','{$lastlogin}','LOGIN')\n ";
$db->execute();
return $row;
} else {
$db->dbclose();
return false;
}
}
