alexberryman / discordwordle Goto Github PK
View Code? Open in Web Editor NEWDiscord bot to track Wordle scores
License: MIT License
Discord bot to track Wordle scores
License: MIT License
thanks :)
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;
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
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.
inside_joke = false
starter quips to be cloned over to inside_joke = true, server_id = m.GuildId
so they can be deleted server by serverquip.id
to used in delete command.@Discordle quip delete <ID>
command that removes it from the quips
table for that serverUsers should be able to @Boardle delete 238
and remove their entry from the bot.
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!
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!
Hello.
Boardle doesn't respond today on any command although it is online. Can you fix it?
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!
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
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.