OK - maybe a different approach:
$form_password = $dbh->quote($FORM{'if_password'});
$form_username = $dbh->quote($FORM{'if_username'});
$db_query = "SELECT $db_field_username, $db_field_password, $db_field_email, MD5($form_password)"; #use PASSWORD($form_password) if you used mySQL to encrypt password
Sorry - I'm not sure what to do here? How do I get the password working properly in the above statement? You are not using standard MD5 encryption? How do I check password with Gossamer Threads encryption?
$db_query .= ", $db_field_firstname" if $db_field_firstname;
$db_query .= ", $db_field_lastname" if $db_field_lastname;
$db_query .= ", $db_field_group_permissions" if $db_field_group_permissions;
$db_query .= " FROM $db_table WHERE $db_field_username = $form_username";
$form_password = $dbh->quote($FORM{'if_password'});
$form_username = $dbh->quote($FORM{'if_username'});
$db_query = "SELECT $db_field_username, $db_field_password, $db_field_email, MD5($form_password)"; #use PASSWORD($form_password) if you used mySQL to encrypt password
Sorry - I'm not sure what to do here? How do I get the password working properly in the above statement? You are not using standard MD5 encryption? How do I check password with Gossamer Threads encryption?
$db_query .= ", $db_field_firstname" if $db_field_firstname;
$db_query .= ", $db_field_lastname" if $db_field_lastname;
$db_query .= ", $db_field_group_permissions" if $db_field_group_permissions;
$db_query .= " FROM $db_table WHERE $db_field_username = $form_username";