public function registerCaptain($username, $password, $firstName, $lastName, $zip, $street, $city, $state, $email, $phone, $mobile)
{
$formatted_firstName = ucwords(strtolower($firstName));
$formatted_lastName = ucwords(strtolower($lastName));
$captain = new Captain();
$salt = $captain->generate_salt();
$hash = $captain->hash_password($salt, $password);
$db = DatabaseBook::getInstance();
$mysqli = $db->getConnection();
$query = "INSERT INTO ea_users(`first_name`, `last_name`, `zip_code`,`address`,`city`,`state`,`email`,`captain_pic`,`phone_number`,`mobile_number`,`id_roles`) VALUES ('{$formatted_firstName}', '{$formatted_lastName}', '{$zip}','{$street}','{$city}','{$state}','{$email}','assets/images/default/profile-default.png','{$phone}','{$mobile}',2)";
if (!$mysqli->query($query)) {
return false;
} else {
$query = "INSERT INTO ea_user_settings(`id_users`,`username`,`password`,`salt`) VALUES (LAST_INSERT_ID(),'{$username}','{$hash}','{$salt}')";
if (!$mysqli->query($query)) {
return false;
} else {
return true;
}
}
return false;
}
