$sql="SELECT userid,password,isactive FROM user WHERE loginname=". $db->Quote("$loginname")." ";
$rs=$db->Execute($sql) or die($db->Errorno()." : ".$db->EorroMsg());
if(($rs->fields)!=false){
if((base64_encode($pass))==($rs->fields["password"])){
if($rs->fields["isactive"]=='Y'){
$_SESSION['loginid']=$rs->fields["user_id"];
//บันทึกการ login
$nowdate=$db->sysTimeStamp;
$sqllogin= "UPDATE user SET lastlogin=$nowdate WHERE userid=".$rs->fields["userid"];
$db->Execute($sqllogin) or die($db->Errorno()." : ".$db->EorroMsg());