It seems if someone posts their Wordle score incorrectly, resulting in the bot not registering the results, if they then repost it correctly, the bot doesn’t pick them up. Attached the most recent example of this:

The users on my server wished to disable the quips. I was able to find the command through this Github issue, but less technical users might not find this, so it would be good to add the quip enable and quip disable to the help message.

The Wordle site doesn't have a way for you to go back in time, so the Discord bot should mirror that functionality.

Prevent updates or submissions for Wordles completed before today.

btw: Great bot, thanks for this community add!

Firstly, thank you very much for creating this bot, it's fantastic and adds that extra competitive element to our daily wordle results, major kudos!

Secondly, apologies, I didn't really want to raise this as an "issue", but can't see another way to ask the question and have worked through everything (even tried amending the quips to blank text). We have a large number of people on our server, and would like the option to disable or delete specific quips if possible, is this feature available or something that could be added down the line, please?

Many thanks in advance!

Right now the scoreboard looks something like this when people miss entries:

Player1      [4, 5, 2]   38      
Player2      [6, 2, 4]   35      
Player3      [3, 3, 6]   33         
Player4      [4, 3]      25      
Player5      [5, 3]      20   

It would be useful if it could be updated to show something like this:

Player1      [4, 5, 2]   38      
Player2      [6, 2, 4]   35      
Player3      [3, 3, 6]   33         
Player4      [-, 4, 3]   25      
Player5      [5, -, 3]   20   

Having a quick look at the queries, perhaps something like this would do it (I haven't actually looked up the table structure...)?

-- name: GetScoresByServerId :many
with max_game_week as (select max(game_id / 7) game_week
                       from wordle_scores
                                inner join nicknames n2 on wordle_scores.discord_id = n2.discord_id
                       where n2.server_id = $1
)
select n.nickname,
       coalesce(json_agg(guesses order by s.game_id), "-")             guesses_per_game,
       json_agg((7 - s.guesses) ^ 2 order by s.game_id) points_per_game,
       count(distinct game_id)                          games_count,
       sum((7 - s.guesses) ^ 2)                         total
from wordle_scores s
         inner join nicknames n on s.discord_id = n.discord_id
         inner join max_game_week g on g.game_week = s.game_id / 7
where n.server_id = $1
group by n.nickname
order by sum((7 - s.guesses) ^ 2) desc;

Uses a pretty specific regex that checks all messages for the Wordle…\d+ \d/6\n share block that has to have a new line at the end which is expected if it was pasted from the Wordle Share button.

Exact regex:

var dataExp = regexp.MustCompile(fmt.Sprintf(`Wordle (?P<game_id>\d+)\s(?P<guesses>\d+|%s)/6\n`, noSolutionResult))

This will match bad @mentions followed by the share block:

@randomName Wordle 200 X/6

⬛⬛⬛⬛⬛
⬛⬛⬛⬛🟩
⬛⬛⬛⬛🟩
⬛⬛⬛⬛🟩
⬛⬛⬛⬛🟩
⬛⬛⬛⬛🟩

This will not match the phrase Wordle 200 X/6 in casual conversation since there is no trailing newline, and the bot isn't mentioned.

He Tom, I got Wordle 200 X/6 today. Really tough puzzle

The bot was dying due to issues when user input failed to match the defined regex for quips and Wordle scores. Some conditional logic will resolve the root issue, and better logging will make it easier to debug future issues.

Current solution uses Postgres order by random() limit 1 which does give different results when repeating the query multiple times. However it seems that the same seed is being used/restarted based on a high number of repeats in the Discord servers.

Find a round robin load balancer approach to increase the variety in quip replies.

Implementation for #22

Before:

Name   Guesses              Total   
1      [1, 1, 1, 1, 1, 1]   216     
2      [2, 2, 2, 2, 2]      125     
3      [3, 3, 3, 3]         64      
4      [4, 4, 4]            27      
5      [5, 5]               8       
6      [6]                  1 

After:

Name   Guesses         Total   
1      [1 1 1 1 1 1]   216     
2      [2 2 2 2 2 -]   125     
3      [3 3 - - 3 3]   64      
4      [4 - - - 4 4]   27      
5      [- - - - 5 5]   8       
6      [- - - - - 6]   1 

Code explanation: I tried a SQL-only solution, but the left wasn't returning null rows/values like I needed for the coalesce() operator needed to work. Instead, I had to pull the list of possible games into the app and iterate through each one and choose to display the number if it's defined, otherwise using - placeholder.

Not as pretty as I wanted since I had to add two new layer of loops, and even the return format from the database [{"217" : 5}, {"218" : 5}, {"219" : 6}] isn't the ideal shape of a flat dictionary {"271": 5, "218": 5, "219": 6} so I had to repack that data in the new dashDisplayForMissingScores method.

• [ ] Refactor the inside_joke = false starter quips to be cloned over to inside_joke = true, server_id = m.GuildId so they can be deleted server by server
• [x] List existing quips to get a quip.id to used in delete command.
• [x] Expose @Discordle quip delete <ID> command that removes it from the quips table for that server

@Discordle quip disable - Turn off quip responses, the bot will continue to add emojis to the request if it understood the input
@Discordle quip enable - Turn quip responses back on if previously disabled

Add two new commands to insert/delete rows in disable_quips.server_id table that gets checked before trying to find a hilarious quip to respond with.

Hi, I am trying to tweak this bot to work for a different wordle like game, it uses different colo emojis and has a different name

Is there a way to make that happen somehow? I'm a huge newbie when it comes to coding but I use python

Thank you!

• many of us are adding this bot to our server after already having played Wordle for a while we have a ton of old results that aren't in the bot
• since the results are all stored locally: might there be a way to view them, copy them, paste them to the bot, and have it parse them into our results history somehow?

thanks :)

Great bot, thanks for creating it. Would it be possible for the bot to listen for wordle scores without requiring users to remember to @ mention the bot, or is this a limitation of the way bots work in discord?