function send_clan_join_request($user_id, $clan_id)
{
DatabaseConnection::getInstance();
$clan_obj = new Clan($clan_id);
$leader = $clan_obj->getLeaderInfo();
$leader_id = $leader['player_id'];
$username = get_username($user_id);
$confirmStatement = DatabaseConnection::$pdo->prepare('SELECT verification_number FROM players WHERE player_id = :user');
$confirmStatement->bindValue(':user', $user_id);
$confirmStatement->execute();
$confirm = $confirmStatement->fetchColumn();
// These ampersands get encoded later.
$url = message_url("clan.php?joiner={$user_id}&command=review&confirmation={$confirm}", 'Confirm Request');
$join_request_message = 'CLAN JOIN REQUEST: ' . htmlentities($username) . " has sent a request to join your clan.\n\t\tIf you wish to allow this ninja into your clan click the following link:\n\t\t{$url}";
send_message($user_id, $leader_id, $join_request_message);
}
