Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- pool.getConnection(function(err, connection){
- if (err) throw err;
- // Automatic Unban System
- setInterval (function (){
- let guildId = [];
- let userId = [];
- let punish = [];
- let date = [];
- let y = 0;
- let resultados = connection.query(
- 'SELECT * FROM actions;',
- function(error, results, fields){
- if(err) throw error;
- for(let i = 0; i < results.length; i++){
- guildId[i] = Object.values(results[i])[y];
- userId[i] = Object.values(results[i])[y+1];
- punish[i] = Object.values(results[i])[y+2];
- date[i] = Object.values(results[i])[y+3];
- }
- for(let i = 0; i < results.length; i++){
- resultados[i] = results[i];
- }
- connection.release();
- if (error) throw error;
- }
- );
- setTimeout (function (){
- for(let i = 0; i < guildId.length; i++){
- if(Date.now() >= date[i]){
- if(punish[i] == 1){
- let banId;
- connection.query(
- 'SELECT ban_role FROM guilds WHERE guild_id = "' + guildId[i] + '";',
- function(error, results, fields){
- if(err) throw error;
- banId = Object.values(results[0])[0];
- connection.release();
- if (error) throw error;
- }
- );
- connection.query(
- 'DELETE FROM actions WHERE guild_id = "' + guildId[i] + '" AND user_id = "' + userId[i] + '";',
- function(error, results, fields){
- if(err) throw error;
- console.log('\x1b[35m', 'User removed from the punishment.');
- client.guilds.cache.get(guildId[i]).members.cache.get(userId[i]).roles.remove(banId);
- connection.release();
- if (error) throw error;
- }
- );
- } else{
- let muteId;
- connection.query(
- 'SELECT mute_role FROM guilds WHERE guild_id = "' + guildId[i] + '";',
- function(error, results, fields){
- if(err) throw error;
- muteId = Object.values(results[0])[0];
- connection.release();
- if (error) throw error;
- }
- );
- connection.query(
- 'DELETE FROM actions WHERE guild_id = "' + guildId[i] + '" AND user_id = "' + userId[i] + '";',
- function(error, results, fields){
- if(err) throw error;
- console.log('\x1b[35m', 'User removed from the punishment.');
- client.guilds.cache.get(guildId[i]).members.cache.get(userId[i]).roles.remove(muteId);
- connection.release();
- if (error) throw error;
- }
- );
- }
- }
- }
- }, 500);
- }, 10000);
- // Reminders
- setInterval(function(){
- connection.query(
- 'SELECT * FROM reminders;',
- function(error, results, fields){
- if(error) console.log(error);
- if(!results) return;
- for(let i = 0; i < results; i++){
- sDate = Object.values(results[i]['saved_date']);
- date = sDate[0].slice(0).join(' ');
- time = sDate[1].slice(1).join(' ');
- let current = new Date();
- let cDate = current.getDay() + '/' + current.getMonth() + '/' + current.getFullYear();
- let cTime = current.getHours() + ':' + current.getMinutes();
- let cHours = Number(current.getHours());
- let cMin = Number(current.getMinutes());
- if(date === cDate){
- if(cHours === time.split('/')[0]){
- if(cMin === Number(time.split('1')[1]) || cMin === Number(time.split('/')[1]) + 1){
- console.log('Nicesu')
- } else if(cMin >= Number(time.split('/')[1]) + 2){
- console.log('Borrado')
- }
- }
- }
- }
- connection.release();
- if (error) throw error;
- }
- );
- }, 3000)
- })
Add Comment
Please, Sign In to add comment