Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Collect Daily Command #76

Open
LeoSaucedo opened this issue Jul 18, 2021 · 0 comments
Open

Collect Daily Command #76

LeoSaucedo opened this issue Jul 18, 2021 · 0 comments
Labels
enhancement New feature or request good first issue Good for newcomers

Comments

@LeoSaucedo
Copy link
Owner

Implement the ;collect daily command with the following spec:

  • When a user calls ;collect daily, the user may gain 1-5 points if they have not collected in the last 24 hours.
  • If a user calls ;collect daily more than once in the last 24 hours, the bot must notify the user they have already collected for the day.
  • The timestamp from the leaderboard table in the database must be queried to look up and update the last collected time.

For convenience, the schema for the leaderboard table is below:

CREATE TABLE leaderboard(
  server varchar(20) NOT NULL,
  user varchar(20) NOT NULL,
  score int NOT NULL,
  collectionDate date NOT NULL,
  PRIMARY KEY (server, user)
  );
@LeoSaucedo LeoSaucedo added enhancement New feature or request good first issue Good for newcomers labels Jul 18, 2021
@KueZie KueZie self-assigned this Jul 20, 2021
@KueZie KueZie removed their assignment Aug 6, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request good first issue Good for newcomers
Projects
None yet
Development

No branches or pull requests

2 participants