Hi, I can’t complete this task, someone could help me?
#!/bin/bash
PSQL=“psql --username=freecodecamp --dbname=number_guess -t --no-align -c”
SECRET_NUMBER=$((RANDOM % 1000 + 1))
echo “Enter your username:”
read USERNAME
#Check if USERNAME exists
USER_ID=$($PSQL “SELECT user_id FROM users WHERE username=‘$USERNAME’”)
#If not empty
if [[ -n $USER_ID ]]
then
G_PLAYED=$($PSQL “SELECT SUM(games_played) FROM users WHERE username=‘$USERNAME’”)
BEST_GAMES=$($PSQL “SELECT MIN(best_game) FROM users WHERE username=‘$USERNAME’”)
echo -e “\nWelcome back, $USERNAME! You have played $G_PLAYED games, and your best game took $BEST_GAMES guesses.”
#If empty
else
echo -e “\nWelcome, $USERNAME! It looks like this is your first time here.”
echo “Guess the secret number between 1 and 1000:”
read GUESS
echo “resposta=$SECRET_NUMBER”
#Verification the input is a positive integer
re=‘[1]+$’
while ! [[ $GUESS =~ $re ]]
do
echo “That is not an integer, guess again:”
read GUESS
done
#Number of valid guesses
NUMBER_OF_GUESSES=1
#Loop tests until the number has been guessed
while [[ $GUESS -ne $SECRET_NUMBER ]]
do
if [[ $SECRET_NUMBER -lt GUESS ]]
then
echo “It’s lower than that, guess again:”
read GUESS
else
echo “It’s higher than that, guess again:”
read GUESS
fi
((NUMBER_OF_GUESSES++))
done
#Print results of the game
echo “You guessed it in $NUMBER_OF_GUESSES tries. The secret number was $SECRET_NUMBER. Nice job!”
fi
0-9 ↩︎