alexberryman / discordwordle Goto Github PK

Hello.
Boardle doesn't respond today on any command although it is online. Can you fix it?

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!

Users should be able to @Boardle delete 238 and remove their entry from the bot.

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?

It says the database url has to be entered

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!

• 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
• List existing quips to get a quip.id to used in delete command.
• Expose @Discordle quip delete <ID> command that removes it from the quips table for that server

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.

unable to invite the bot to the server as it has not been verified or due to an api gateway error

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;

• 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 :)

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:

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!

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.