Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- const Discord = require("discord.js");
- let mysql = require('mysql');
- const client = new Discord.Client();
- const config = require("./config/config.json");
- const cities = require("./config/cities.json");
- const Fortnite = require("fortnite-api");
- let fortniteAPI = new Fortnite(
- [
- *secret*
- ],
- {
- debug: true
- }
- );
- client.on("ready", () => {
- console.log(`Bot has started, with ${client.users.size} users, in ${client.channels.size} channels of ${client.guilds.size} guilds.`);
- client.user.setActivity(`Serving ${client.guilds.size} servers`);
- });
- client.on("guildCreate", guild => {
- console.log(`New guild joined: ${guild.name} (id: ${guild.id}). This guild has ${guild.memberCount} members!`);
- client.user.setActivity(`Serving ${client.guilds.size} servers`);
- let con = mysql.createConnection({
- host: "localhost",
- user: "root",
- password: "",
- database: "guilds"
- });
- con.connect(function(err) {
- if (err) throw err;
- con.query(`INSERT INTO config (prefix, serverID) VALUES ('!', ${guild.id})`, (err) => {
- if (err) throw err;
- });
- });
- con.end();
- });
- client.on("guildDelete", guild => {
- console.log(`I have been removed from: ${guild.name} (id: ${guild.id})`);
- client.user.setActivity(`Serving ${client.guilds.size} servers`);
- let con = mysql.createConnection({
- host: "localhost",
- user: "root",
- password: "",
- database: "guilds",
- });
- con.connect(function(err) {
- if (err) throw err;
- con.query(`DELETE FROM config WHERE serverID = ${guild.id}`, function (err) {
- if (err) throw err;
- con.query(`DELETE FROM defis WHERE serverID = ${guild.id}`, function (err) {
- if (err) throw err;
- });
- });
- });
- con.end();
- });
- client.on("message", async message => {
- let con = mysql.createConnection({
- host: "localhost",
- user: "root",
- password: "",
- database: "guilds"
- });
- con.connect(function(err) {
- if (err) throw err;
- con.query("SELECT * FROM `config` WHERE `serverID` = '" + client.guilds.get(message.guild.id).id + "'", (err, row) => {
- if(message.author.bot) return;
- if(message.content.indexOf(row[0].prefix) !== 0) return;
- const args = message.content.slice(row[0].prefix.length).trim().split(/ +/g);
- const command = args.shift().toLowerCase();
- if(command === "info") {
- if (message.channel.id !== '468464421287624714') return
- const embed =
- {
- title: 'Fortnite Roler Statistics',
- fields: [{
- name: 'Mem Usage',
- value: `${(process.memoryUsage().heapUsed / 1024 / 1024).toFixed(2)} MB`,
- inline: true
- }, {
- name: 'Users',
- value: `${client.users.size}`,
- inline: true
- }, {
- name: 'Servers',
- value: `${client.guilds.size}`,
- inline: true
- }, {
- name: 'Channels',
- value: `${client.channels.size}`,
- inline: true
- }, {
- name: 'Discord.js',
- value: `${Discord.version}`,
- }],
- footer: {
- text: "crée par Uɳιx#3142"
- }
- }
- message.channel.send('', { embed: embed });
- }
- if(command === "stats") {
- //stats
- if (message.channel.id !== '389512905592274946') return;
- if (message.content.endsWith(row[0].prefix + "stats")) {
- let con = mysql.createConnection({
- host: "localhost",
- user: "root",
- password: "",
- database: "links",
- });
- let conStr = "SELECT * FROM `users` WHERE `userID` = '" + message.author.id+"'";
- con.query(conStr, function(error, row) {
- if (row && row.length) {
- fortniteAPI.login().then(() => {
- fortniteAPI
- .getStatsBR(row[0].username, "pc", "alltime")
- .then(stats => {
- message.channel.send({embed: {
- color: 3447003,
- title: row[0].username + "'s Stats",
- fields: [
- { name: "Solo", value: `**K/D** ${stats.group.solo["k/d"]}\n**WINS** ${stats.group.solo.wins}\n**KILLS** ${stats.group.solo.kills}\n**WIN%** ${stats.group.solo["win%"]}\n**MATCHES** ${stats.group.solo.matches}`, inline: true},
- { name: "Duo", value: `**K/D** ${stats.group.duo["k/d"]}\n**WINS** ${stats.group.duo.wins}\n**KILLS** ${stats.group.duo.kills}\n**WIN%** ${stats.group.duo["win%"]}\n**MATCHES** ${stats.group.duo.matches}`, inline: true},
- { name: "Squad", value: `**K/D** ${stats.group.squad["k/d"]}\n**WINS** ${stats.group.squad.wins}\n**KILLS** ${stats.group.squad.kills}\n**WIN%** ${stats.group.squad["win%"]}\n**MATCHES** ${stats.group.squad.matches}`, inline: true},
- { name: "Total", value: `**K/D** ${stats.lifetimeStats["k/d"]}\n**WINS** ${stats.lifetimeStats.wins}\n**KILLS** ${stats.lifetimeStats.kills}\n**WIN%** ${stats.lifetimeStats["win%"]}\n**MATCHES** ${stats.lifetimeStats.matches}`},
- ]
- }
- });
- con.end();
- })
- .catch(err => {
- console.log(err);
- });
- });
- }
- });
- }
- else {
- let username = args.join().replace(/\,/g, ' ');
- fortniteAPI.login().then(() => {
- fortniteAPI
- .getStatsBR(username, "pc", "alltime")
- .then(stats => {
- message.channel.send({embed: {
- color: 3447003,
- title: username + "'s Stats",
- fields: [
- { name: "Solo", value: `**K/D** ${stats.group.solo["k/d"]}\n**WINS** ${stats.group.solo.wins}\n**KILLS** ${stats.group.solo.kills}\n**WIN%** ${stats.group.solo["win%"]}\n**MATCHES** ${stats.group.solo.matches}`, inline: true},
- { name: "Duo", value: `**K/D** ${stats.group.duo["k/d"]}\n**WINS** ${stats.group.duo.wins}\n**KILLS** ${stats.group.duo.kills}\n**WIN%** ${stats.group.duo["win%"]}\n**MATCHES** ${stats.group.duo.matches}`, inline: true},
- { name: "Squad", value: `**K/D** ${stats.group.squad["k/d"]}\n**WINS** ${stats.group.squad.wins}\n**KILLS** ${stats.group.squad.kills}\n**WIN%** ${stats.group.squad["win%"]}\n**MATCHES** ${stats.group.squad.matches}`, inline: true},
- { name: "Total", value: `**K/D** ${stats.lifetimeStats["k/d"]}\n**WINS** ${stats.lifetimeStats.wins}\n**KILLS** ${stats.lifetimeStats.kills}\n**WIN%** ${stats.lifetimeStats["win%"]}\n**MATCHES** ${stats.lifetimeStats.matches}`},
- ]
- }
- });
- })
- .catch(err => {
- console.log(err);
- });
- });
- }
- }
- if(command === "link") {
- if (message.channel.id !== '389512905592274946') return;
- let con = mysql.createConnection({
- host: "localhost",
- user: "root",
- password: "",
- database: "links",
- });
- let conStr = "SELECT * FROM `users` WHERE `userID` = '" + message.author.id+"'";
- con.query(conStr, function(error, row) {
- if (row && row.length) {
- message.channel.send("Votre discord est déja associer à un autre compte: " + row[0].username)
- }
- else
- {
- let username = args.join().replace(/\,/g, ' ');
- let conStr = "SELECT * FROM `users` WHERE `username` = '" + username +"'";
- con.query(conStr, function(error, row) {
- if (row && row.length) {
- message.channel.send(row[0].username + " est déja associer à un autre compte discord")
- }
- else {
- let username = args.join().replace(/\,/g, ' ');
- fortniteAPI.login().then(() => {
- fortniteAPI
- .getStatsBR(username, "pc", "alltime")
- .then(stats => {
- let sql = "INSERT INTO users (userID, username) VALUES ('" + message.author.id + "', '" + username + "')";
- con.query(sql, function(error) {
- message.channel.send(username + " à bien été associer.")
- });
- })
- .catch(err => {
- message.channel.send("Ce joueur n'existe pas ou n'est pas un joueur PC");
- });
- });
- }
- });
- }
- con.end();
- });
- con.end();
- }
- if(command === "unlink") {
- if (message.channel.id !== '389512905592274946') return;
- let con = mysql.createConnection({
- host: "localhost",
- user: "root",
- password: "",
- database: "links",
- });
- let conStr = "SELECT * FROM `users` WHERE `userID` = '" + message.author.id+"'";
- con.query(conStr, function(error, row) {
- if (row && row.length) {
- let sql = "DELETE FROM users WHERE userID = '" + message.author.id + "'";
- con.query(sql, function(error) {
- message.channel.send("Vous avez bien désassocié votre compte")
- });
- }
- else
- {
- message.channel.send("Vous n'avez aucun compte d'associer, vous pouvez faire `!link nom` pour associer un compte Fortnite à votre Discord")
- }
- });
- con.end();
- }
- if(command === "drop") {
- if (message.channel.id !== '468464421287624714') return;
- message.channel.send(message.author + ", vous et votre équipe devez descendre à " + cities[Math.floor(Math.random()*cities.length)] + ".");
- }
- if(command === "roulette") {
- let con = mysql.createConnection({
- host: "localhost",
- user: "root",
- password: "",
- database: "guilds"
- });
- con.connect(function(err) {
- if (err) throw err;
- let conStr = "SELECT * from defis WHERE serverID = '" + client.guilds.get(message.guild.id).id + "' ORDER BY RAND() LIMIT 1";
- con.query(conStr, function (err, row) {
- if (row.length === 0) {
- message.channel.send("Ce serveur n'as pas encore de défi, pour en ajouter vous pouvez faire `!defi tuer un ennemi à la pioche`");
- }
- else {
- message.channel.send(message.author + ", vous et votre équipe devez descendre à " + cities[Math.floor(Math.random()*cities.length)] + ", cependant, " + row[0].defi + " (" + row[0].id + ")");
- }
- });
- });
- con.end();
- }
- if(command === "prefix") {
- if(message.member.roles.find("name", "Bot")){
- let con = mysql.createConnection({
- host: "localhost",
- user: "root",
- password: "",
- database: "guilds"
- });
- con.connect(function(err) {
- if (err) throw err;
- con.query("SELECT * from config WHERE serverID = '" + client.guilds.get(message.guild.id).id + "'", function (err, row) {
- if (err) throw err;
- let sql = "UPDATE config SET prefix = '" + args[0] +"' WHERE serverID = '" + client.guilds.get(message.guild.id).id + "'";
- con.query(sql, function (err, row) {
- message.channel.send("Votre prefix à bien été changer pour " + args[0]);
- });
- });
- });
- con.end();
- }
- else {
- }
- }
- /*if(command === "setrank") {
- let con = mysql.createConnection({
- host: "localhost",
- user: "root",
- password: "mOdT3r-dh8S(",
- database: "links"
- });
- con.connect(function(err) {
- con.query("SELECT * FROM `users` WHERE `userID` = '" + message.author.id+"'", function (err, row) {
- if (row && row.length) {
- let con = mysql.createConnection({
- host: "localhost",
- user: "root",
- password: "mOdT3r-dh8S(",
- database: "guilds"
- });
- con.connect(function(err) {
- con.query("SELECT * FROM `roles` WHERE `serverID` = '" + client.guilds.get(message.guild.id).id +"'", function (err, row) {
- if (row && row.length) {
- }
- else {
- message.channel.send("Ce serveur n'as pas encore de rôle, pour en ajouter vous pouvez faire `!arole id kd`");
- }
- });
- });
- } else {
- message.channel.send("Vous n'avez aucun compte d'associer, vous pouvez faire `!link nom` pour associer un compte Fortnite à votre Discord");
- }
- });
- });
- }*/
- if(command === "rdefi") {
- if(message.member.roles.find("name", "Bot")){
- let con = mysql.createConnection({
- host: "localhost",
- user: "root",
- password: "",
- database: "guilds"
- });
- con.connect(function(err) {
- if (err) throw err;
- con.query("SELECT * from defis WHERE id = '" + args[0] + "'", function (err, row) {
- if (row.length === 0) {
- message.channel.send("Ce serveur n'as pas encore de défi, pour en ajouter vous pouvez faire `!defi tuer un ennemi à la pioche`");
- }
- else {
- if (client.guilds.get(message.guild.id).id === row[0].serverID) {
- con.query("DELETE from defis WHERE id = '" + args[0] + "'", function (err, row) {
- message.channel.send("Vous avez bien supprimer le défi: " + args[0]);
- });
- } else {
- message.channel.send("Ce défi ne vous appartient pas, vous pouvez faire !ldefi pour voir vos défis!");
- }
- }
- });
- });
- con.end();
- } else {
- }
- }
- if(command === "ldefi") {
- let con = mysql.createConnection({
- host: "localhost",
- user: "root",
- password: "",
- database: "guilds"
- });
- con.connect(function(err) {
- if (err) throw err;
- con.query("SELECT * from defis WHERE serverID = '" + client.guilds.get(message.guild.id).id + "'", function (err, row) {
- if (row.length === 0) {
- message.channel.send("Ce serveur n'as pas encore de défi, pour en ajouter vous pouvez faire `!defi tuer un ennemi à la pioche`");
- }
- else {
- let array = '';
- row.forEach(function(row) {
- array += `${row.id}: ${row.defi}\n`
- });
- message.channel.send({embed: {
- color: 3447003,
- title: "Liste des défis pour " + client.guilds.get(message.guild.id).id ,
- description: `${array}`,
- footer: {
- text: "Vous pouvez ajouter vos propre défis avec la commande !defi tuer un ennemi à la pioche"
- }
- }
- });
- }
- con.end();
- });
- });
- }
- if(command === "cmds") {
- let con = mysql.createConnection({
- host: "localhost",
- user: "root",
- password: "",
- database: "guilds"
- });
- if (message.channel.id !== '468464421287624714') return;
- con.connect(function(err) {
- con.query("SELECT * from config WHERE serverID = '" + client.guilds.get(message.guild.id).id + "'", function (err, row) {
- message.channel.send({embed: {
- color: 3447003,
- title: "Commandes",
- fields: [
- { name: `${row[0].prefix}stats`, value: `donne les stats d'un joueur (${row[0].prefix}stats IveMemory) et ou (seulement ${row[0].prefix}stats si vous avez link votre compte.)`},
- { name: `${row[0].prefix}link`, value: `associe votre compte Fortnite à votre Discord (${row[0].prefix}link IveMemory)`},
- { name: `${row[0].prefix}unlink`, value: `désassocie votre compte (${row[0].prefix}unlink)`},
- { name: `${row[0].prefix}drop`, value: `vous donne une ville aléatoire ou vous et votre équipe devez drop.`},
- { name: `${row[0].prefix}roulette`, value: `vous donne une ville aléatoire et un défi.`},
- { name: `${row[0].prefix}ldefi`, value: `montre la liste des défis possible`},
- { name: `${row[0].prefix}info`, value: `donne des infos supplémentaire sur le bot`},
- ]
- }
- });
- });
- });
- con.end();
- }
- if(command === "adefi") {
- if(message.member.roles.find("name", "Bot")){
- let con = mysql.createConnection({
- host: "localhost",
- user: "root",
- password: "",
- database: "guilds"
- });
- con.connect(function(err) {
- if (err) throw err;
- con.query("INSERT INTO defis (defi, serverID) VALUES ('" + args.join().replace(/\,/g, ' ') + "', '" + client.guilds.get(message.guild.id).id + "')", function (err, row) {
- message.channel.send("Vous avez bien ajouter le défi!");
- });
- });
- con.end();
- }
- else {
- }
- }
- });
- });
- con.end();
- });
- client.login(config.token);
Add Comment
Please, Sign In to add comment