radicalius / rocket-taco Goto Github PK

Need to replace all queries to the database with prepared statements

Currently have individual leader boards for each channel. Might be nice to have a leaderboard that aggregates stats over all rocket-taco channels on the server

Perhaps using Bootstrap: https://getbootstrap.com/

Want settings to persist between launches of the bot.

Maybe run as a cron job inside the container?

Explain how to install and setup the bot.

E.g.

curl \ 
-d '{"bot":false,"trigger_word":":taco:","channel_id":"TJf7cJcJjZDj3kFct","channel_name":"channel","message_id":"5xEFvg23JzH7BSPNx","timestamp":"2019-07-27T21:18:35.319Z","user_id":"F9YKW787Y4bbtYuJu","user_name":"zac","text":":taco: @user"}' \
localhost:4567/taco?channel=channel

Possible Solution:

• Server and integration script share a secret key
• Integration script sends hash(taco_giver || taco_receiver || secret_key || timestamp) in the headers for requests to /taco
• Server computes the hash and rejects the request if it doesn't match

Need a way to display the full leader board. Should be able to be sorted by time frame and channel.

Currently assuming that the bot is on the same machine as the Rocket.chat server and using localhost when setting up the integrations.

Direct message user when they hit specific thresholds for tacos given / received.
Add a !rank command to give you your total tacos given / received and level.

Possible Thresholds

Maybe Postgres?