int[] daysOfWeek = { 0, 1, 2, 3, 4, 5, 6, 7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30 }; //дни
double[] probably_day_change = new double[31];
chart1.ChartAreas["ChartArea1"].AxisX.Minimum = 0;
for (int i = 0; i < daysOfWeek.Length; i++)
{
probably_day_change[i] = 1-Math.Exp(-sum_change*(i-1+1));
chart1.Series[0].Points.AddXY(i, probably_day_change[i]);
}pool.query(`SELECT date_added FROM moneys WHERE UserID = ${interaction.user.id} AND GuildID = ${interaction.guild.id}`, async function (err, result, fields) {
if (err) throw err;
if (result.length > 0) {
if (result[0]['date_added'] === null) {
pool.query(`UPDATE moneys SET Moneyscol = Moneyscol + 500, date_added = NOW(), date_next = (NOW() + INTERVAL 1 DAY) WHERE UserID = ${interaction.user.id} AND GuildID = ${interaction.guild.id}`, async function (err, result, fields) {
if (err) throw err;
return interaction.reply({ content: "Успешно" })
});
} else {
pool.query(`UPDATE moneys SET date_added = NOW() WHERE UserID = ${interaction.user.id} AND GuildID = ${interaction.guild.id}`, async function (err, result, fields) {
if (err) throw err;
pool.query(`SELECT date_added, date_next FROM moneys WHERE UserID = ${interaction.user.id} AND GuildID = ${interaction.guild.id}`, async function (err, result, fields) {
if (err) throw err;
if (result[0]['date_added'] >= result[0]['date_next']) {
pool.query(`UPDATE moneys SET Moneyscol = Moneyscol + 500, date_added = NOW(), date_next = (NOW() + INTERVAL 1 DAY) WHERE UserID = ${interaction.user.id} AND GuildID = ${interaction.guild.id}`, async function (err, result, fields) {
if (err) throw err;
return interaction.reply({ content: "Успешно" })
});
} else {
pool.query(`SELECT TIME_FORMAT(TIMEDIFF(date_next, date_added), '%H ч, %i мин, %s сек') as time from moneys WHERE UserID = ${interaction.user.id} AND GuildID = ${interaction.guild.id}`, async function (err, result, fields) {
if (err) throw err;
const data = {
time: result[0]["time"]
}
let embed = new MessageEmbed()
.setColor("#FF0000")
.setTitle(`${interaction.member.displayName}`)
.setDescription(`Вы уже использовали эту команду. Попробуйте снова через \`${data.time}\``)
.setThumbnail(interaction.user.displayAvatarURL())
.setTimestamp(new Date())
return interaction.reply({ embeds: [embed] })
});
}
});
});
}
} else {
pool.query(`INSERT INTO moneys (GuildID, UserID, Moneyscol, date_added, date_next) VALUES (${interaction.guild.id}, ${interaction.user.id}, 500, NOW(), (NOW() + INTERVAL 1 DAY))`, async function (err, result, fields) {
if (err) throw err;
let embed = new MessageEmbed()
.setColor("#FFCC4D")
.setTitle(`${interaction.member.displayName}`)
.setDescription(`Вы получили ежедневный бонус в размере \`500\` :coin:`)
.setThumbnail(interaction.user.displayAvatarURL())
.setTimestamp(new Date())
return interaction.reply({ embeds: [embed] })
});
}
});pool.query(`SELECT TIME_FORMAT(TIMEDIFF(date_next, date_added), '%H ч, %i мин, %s сек') as time from moneys WHERE UserID = ${interaction.user.id} AND GuildID = ${interaction.guild.id}`, async function (err, result, fields) {
if (err) throw err;
const data = {
time: result[0]["time"]
}
return interaction.reply({ content: Попробуйте снова через \`${data.time}\``)
});