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.

Sign up for GitHub

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

Jump to bottom

Check if giveaway is due in sqlite, not ts #24

Open

filip326 opened this issue Mar 27, 2023 · 1 comment

Assignees

Labels

Collaborator

filip326 commented Mar 27, 2023

FloBot/src/action/giveaway.ts

Line 164 in e1a4fce

    
           const giveawayArr = await db.allAsync(`SELECT message_id, prize, timestamp, status, organizer_id, channel_id FROM giveaways WHERE status = 0 and channel_id is not null`, [])

Here all open giveaways are fetched from the sqlite db and checked if due afterwards. It should be possible to fetch only the due giveaways.

filip326 added the unimportant label

filip326 self-assigned this

Collaborator

EinsKatze commented Jun 28, 2024

in sqlite you can get the current utc timestampt with unixepoch() and could therefore get the due dates with WHERE timestamp < unixepoch() ig

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment