Advertisement
Guest User

Untitled

a guest
Nov 16th, 2019
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.04 KB | None | 0 0
  1. module.exports.run = async (bot, message, args, bdd, functions, prefix) => {
  2. bdd.query(`SELECT * FROM energie WHERE discord_id = '${message.author.id}'`, (err, getEnergie) => {
  3. let gEnergie;
  4. if (getEnergie[0]) {
  5. gEnergie = getEnergie[0].value;
  6. } else {
  7. gEnergie = 10;
  8. }
  9.  
  10. // Message
  11. message.reply(`<:rocket:547024102683049984> Vous êtes désormais en train de dormir !`)
  12.  
  13. // Save
  14. bdd.query(`SELECT * FROM sleep WHERE discord_id = '${message.author.id}'`, (err, rows) => {
  15. let sql;
  16. if (rows.length < 1) {
  17. sql = `INSERT INTO sleep (discord_id, value) VALUES ('${message.author.id}', '1')`;
  18. } else {
  19. sql = `UPDATE sleep SET value = '1' WHERE discord_id = '${message.author.id}'`;
  20. }
  21. bdd.query(sql)
  22. });
  23. setTimeout(function () {
  24. // Message
  25. message.reply(`<:rocket:547024102683049984> Vous êtes réveillé !`)
  26.  
  27. // Add Energie
  28. functions.addEnergie(bdd, message.author.id, 10)
  29.  
  30. // Save
  31. bdd.query(`SELECT * FROM sleep WHERE discord_id = '${message.author.id}'`, (err, rows) => {
  32. let sql;
  33. if (rows.length < 1) {
  34. sql = `INSERT INTO sleep (discord_id, value) VALUES ('${message.author.id}', '0')`;
  35. } else {
  36. sql = `UPDATE sleep SET value = '0' WHERE discord_id = '${message.author.id}'`;
  37. }
  38. bdd.query(sql)
  39. });
  40. }, ms('30s'));
  41.  
  42. });
  43. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement