Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- module.exports.run = async (bot, message, args, bdd, functions, prefix) => {
- bdd.query(`SELECT * FROM energie WHERE discord_id = '${message.author.id}'`, (err, getEnergie) => {
- let gEnergie;
- if (getEnergie[0]) {
- gEnergie = getEnergie[0].value;
- } else {
- gEnergie = 10;
- }
- // Message
- message.reply(`<:rocket:547024102683049984> Vous êtes désormais en train de dormir !`)
- // Save
- bdd.query(`SELECT * FROM sleep WHERE discord_id = '${message.author.id}'`, (err, rows) => {
- let sql;
- if (rows.length < 1) {
- sql = `INSERT INTO sleep (discord_id, value) VALUES ('${message.author.id}', '1')`;
- } else {
- sql = `UPDATE sleep SET value = '1' WHERE discord_id = '${message.author.id}'`;
- }
- bdd.query(sql)
- });
- setTimeout(function () {
- // Message
- message.reply(`<:rocket:547024102683049984> Vous êtes réveillé !`)
- // Add Energie
- functions.addEnergie(bdd, message.author.id, 10)
- // Save
- bdd.query(`SELECT * FROM sleep WHERE discord_id = '${message.author.id}'`, (err, rows) => {
- let sql;
- if (rows.length < 1) {
- sql = `INSERT INTO sleep (discord_id, value) VALUES ('${message.author.id}', '0')`;
- } else {
- sql = `UPDATE sleep SET value = '0' WHERE discord_id = '${message.author.id}'`;
- }
- bdd.query(sql)
- });
- }, ms('30s'));
- });
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement