Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- for (const member of guild.members.values()) {
- var sql = `SELECT * FROM users WHERE discord_id=?`;
- var res = 0;
- connection.query(sql, member.id, (error, results, fields) => {
- if (error) {
- return console.error(error.message);
- }
- if (results.length == 1) {
- member.removeRole(getRoleIDByName("Novice [<1250]"));
- member.removeRole(getRoleIDByName("Intermédiaire [1250-1400]"));
- member.removeRole(getRoleIDByName("Connaisseur [1400-1550]"));
- member.removeRole(getRoleIDByName("Expérimenté [1550-1700]"));
- member.removeRole(getRoleIDByName("Adepte [1700-1850]"));
- member.removeRole(getRoleIDByName("Expert [1850-2000]"));
- member.removeRole(getRoleIDByName("Maître [>2000]"));
- console.log("using name : " + results[0].lichess_name);
- console.log("Waiting before new request...");
- setTimeout(async function() {
- await axios.get('https://lichess.org/api/user/' + args[1])
- .then(function(response) {
- if (response != null && response.status == 200) {
- var datas = response.data;
- var to_use = LichessRatingToUse(datas);
- if (to_use[1] > 0) {
- if (to_use[1] < 1250) {
- member.addRole(getRoleIDByName("Novice [<1250]"));
- } else if (to_use[1] > 1250 && to_use[1] <= 1400) {
- member.addRole(getRoleIDByName("Intermédiaire [1250-1400]"));
- } else if (to_use[1] > 1400 && to_use[1] <= 1550) {
- member.addRole(getRoleIDByName("Connaisseur [1400-1550]"));
- } else if (to_use[1] > 1550 && to_use[1] <= 1700) {
- member.addRole(getRoleIDByName("Expérimenté [1550-1700]"));
- } else if (to_use[1] > 1700 && to_use[1] <= 1850) {
- member.addRole(getRoleIDByName("Adepte [1700-1850]"));
- } else if (to_use[1] > 1850 && to_use[1] <= 2000) {
- member.addRole(getRoleIDByName("Expert [1850-2000]"));
- } else if (to_use[1] > 2000) {
- member.addRole(getRoleIDByName("Maître [>2000]"));
- }
- }
- } else {
- bot.createMessage(msg.channel.id, "Erreur: Compte introuvable...");
- }
- })
- .catch(function(error) {
- // handle error
- console.log(error);
- })
- .then(function() {
- });
- }, 3000);
- }
- });
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement