Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- setInterval(function(){
- connection.query(
- 'SELECT * FROM reminders;',
- function(error, results, fields){
- if(error) console.log(error);
- for(let i = 0; i < results.length; i++){
- var userId = Object.values(results[i])[0];
- var guildId = Object.values(results[i])[1];
- var chId = Object.values(results[i])[2];
- var rmb = Object.values(results[i])[4];
- var sDate = Object.values(results[i])[3].toLocaleString();
- let date = sDate.split(' ')[0];
- let time = sDate.split(' ')[1];
- let day = Number(date.split('/')[0]);
- let month = Number(date.split('/')[1]);
- let year = Number(date.split('/')[2]);
- let hour = Number(time.split(':')[0]);
- let min = Number(time.split(':')[1]);
- let sec = Number(time.split(':')[2]);
- let current = new Date();
- let cDate = current.getDay() + '/' + current.getMonth() + '/' + current.getFullYear();
- let cYear = Number(current.getFullYear());
- let cMonth = Number(current.getMonth()) + 1;
- let cDay = Number(current.getDate());
- let cTime = current.getHours() + ':' + current.getMinutes();
- let cHour = Number(current.getHours());
- let cMin = Number(current.getMinutes());
- let cSec = Number(current.getSeconds());
- let cSaved = cYear + '-' + cMonth + '-' + cDay + ' ' + cHour + ':' + cMin + ':' + cSec;
- if(cYear == year && cMonth == month && cDay == day){
- if(cHour == hour && cMin == min){
- connection.query(
- 'DELETE FROM reminders WHERE user_id = "' + userId + '" AND remember = "' + rmb + '";',
- function(error, results, fields){
- if(err) throw error;
- let guild = client.guilds.cache.get(guildId);
- let channel = guild.channels.cache.get(chId);
- channel.send('<@' + guild.members.cache.get(userId) + '> **Reminder:** _' + rmb + '_');
- }
- );
- } else if(cHour > hour){
- connection.query(
- 'DELETE FROM reminders WHERE user_id = "' + userId + '" AND remember = "' + rmb + '";',
- function(error, results, fields){
- if(err) throw error;
- }
- );
- } else if(cHour == hour && cMin > min + 1){
- connection.query(
- 'DELETE FROM reminders WHERE user_id = "' + userId + '" AND remember = "' + rmb + '";',
- function(error, results, fields){
- if(err) throw error;
- }
- );
- }
- } else if(cYear > year){
- connection.query(
- 'DELETE FROM reminders WHERE user_id = "' + userId + '" AND remember = "' + rmb + '";',
- function(error, results, fields){
- if(err) throw error;
- }
- );
- } else if(cMonth > month){
- connection.query(
- 'DELETE FROM reminders WHERE user_id = "' + userId + '" AND remember = "' + rmb + '";',
- function(error, results, fields){
- if(err) throw error;
- }
- );
- } else if (cMonth == month && cDay > day){
- connection.query(
- 'DELETE FROM reminders WHERE user_id = "' + userId + '" AND remember = "' + rmb + '";',
- function(error, results, fields){
- if(err) throw error;
- }
- );
- }
- }
- }
- );
- }, 3000)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement