Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- client.on('message', async function(message) {
- const cmd = (a,b,c,d) => {
- return;
- }
- if(message.author.bot) return;
- if(message.channel.type === 'dm') return;
- con.query(`SELECT * FROM top WHERE gid = '${message.guild.id}' AND id = '${message.author.id}'`, (e, rows) => {
- if(e) throw e;
- if(!rows || !rows[0] || rows.lenght < 0) {
- con.query(`INSERT INTO top (id, gid, txp) VALUES ('${message.author.id}', '${message.guild.id}', 1)`);
- } else {
- if(message.content === "confirm") return;
- con.query(`UPDATE top SET txp = ${parseInt(rows[0].txp)+1} WHERE id = '${message.author.id}' AND gid = '${message.guild.id}'`)
- }
- })
- if(message.content.toLowerCase() === prefix + "top") {
- cmd("top", "Send a leaderboard for all active members in the server", "top", "Info");
- //
- con.query(`SELECT * FROM top WHERE gid = '${message.guild.id}' ORDER BY txp DESC`, (e, rows) => {
- con.query(`SELECT * FROM top WHERE gid = '${message.guild.id}' ORDER BY vxp DESC`, (e, rowa) => {
- var text = '';
- var voice = '';
- for(var i = 0; i < 5; i++) {
- if(rows[i]) {
- let user = client.users.get(rows[i].id);
- let is = '';
- if(rows[i].id == message.author.id) {
- is = "**"
- } else {
- is = '';
- }
- text += `${is}#${parseInt(i)+1} | <@${rows[i].id}> XP: \`${rows[i].txp}\`${is}\n`
- }
- }
- for(var i = 0; i < 5; i++) {
- if(rowa[i]) {
- let user = client.users.get(rowa[i].id);
- let is = '';
- if(rowa[i].id == message.author.id) {
- is = "**"
- } else {
- is = '';
- }
- voice += `${is}#${parseInt(i)+1} | <@${rowa[i].id}> XP: \`${rowa[i].vxp}\`${is}\n`
- }
- }
- const embed2 = new Discord.RichEmbed()
- .setAuthor("📋 | Guild Score Leaderboards", message.guild.iconURL)
- .setColor(" #191919")
- .addField(`**:speech_balloon: | TOP 5 TEXT**`, `${text} \n **:thinking: | For More: \`${prefix}top text\`**`, true)
- .addField("**:microphone2: | TOP 5 VOICE**", `${voice} \n **:thinking: | For More: \`${prefix}top voice\`**`, true)
- .setFooter(message.author.tag, message.author.displayAvatarURL)
- message.channel.send(embed2)
- })
- })
- }
- if(message.content.toLowerCase() === (prefix + 'top text')) {
- cmd("top text", "Send a leaderboard for all active members in the server", "top text", "Info");
- con.query(`SELECT * FROM top WHERE gid = '${message.guild.id}' ORDER BY txp DESC`, (e, rows) => {
- var text = '';
- {
- for (var i = 0; i < 10; i++) {
- if(rows[i]) {
- let user = client.users.get(rows[i].id);
- let is = '';
- if(rows[i].id == message.author.id) {
- is = "**"
- } else {
- is = '';
- }
- text += `${is}#${parseInt(i)+1} <@${rows[i].id}> XP: \`${rows[i].txp}\`${is}\n`
- }
- }
- const embed2 = new Discord.RichEmbed()
- .setAuthor("📋 | Guild Score Leaderboards", message.guild.iconURL)
- .setColor(" #191919")
- .addField(`**:speech_balloon: | TEXT LEADERBOARD**`, `${text}`, true)
- .setFooter(message.author.tag, message.author.displayAvatarURL)
- message.channel.send(embed2)
- }
- })
- }
- if(message.content.toLowerCase() === (prefix + 'top voice')) {
- cmd("top voice", "Send a leaderboard for all active members in the server", "top voice", "Info");
- con.query(`SELECT * FROM top WHERE gid = '${message.guild.id}' ORDER BY vxp DESC`, (e, rows) => {
- var text = '';
- var voice = '';
- for(var i = 0; i < 10; i++){
- if(rows[i]) {
- let user = client.users.get(rows[i].id);
- let is = '';
- if(rows[i].id == message.author.id) {
- is = "**"
- } else {
- is = '';
- }
- text += `${is}#${parseInt(i)+1} <@${rows[i].id}> XP: \`${rows[i].vxp}\`${is}\n`
- }
- }
- const embed2 = new Discord.RichEmbed()
- .setAuthor("📋 | Guild Score Leaderboards", message.guild.iconURL)
- .setColor(" #191919")
- .addField(`**:microphone2: | VOICE LEADERBOARD**`, `${text}`, true)
- .setFooter(message.author.tag, message.author.displayAvatarURL)
- message.channel.send(embed2)
- })
- }
- con.query(`SELECT * FROM top WHERE gid='${message.guild.id}'`, (err, rows) => {
- if(message.content === prefix + "reset all") {
- if(!message.member.hasPermission("MANAGE_GUILD")) return;
- message.channel.send("**:warning: | لتأكيد عملية تصفير جميع النقاط , قم بكتابة : ```confirm```**").then(async msg => {
- try{
- let conf = await message.channel.awaitMessages(m => m.content === "confirm", { max: 1, time: 20000, errors: ["time"]}).then(c => {
- message.delete();
- msg.edit(`**${t} | تم تصفير جميع النقاط**`);
- con.query(`UPDATE top SET txp=0 WHERE gid = '${message.guild.id}'`)
- con.query(`UPDATE top SET txp=0 WHERE gid = '${message.guild.id}' AND id='${message.author.id}'`)
- con.query(`UPDATE top SET vxp=0 WHERE gid = '${message.guild.id}'`)
- con.query(`UPDATE top SET vxp=0 WHERE gid = '${message.guild.id}' AND id='${message.author.id}'`)
- })
- } catch(e) {
- message.delete();
- }
- })
- }
- if(message.content === prefix + "reset text") {
- if(!message.member.hasPermission("MANAGE_MESSAGES")) return;
- message.channel.send("**:warning: | لتأكيد عملية تصفير جميع النقاط الكتابية , قم بكتابة : ```confirm```**").then(async msg => {
- try{
- let conf = await message.channel.awaitMessages(m => m.content === "confirm", { max: 1, time: 20000, errors: ["time"]}).then(c => {
- message.delete();
- msg.edit(`**${t} | تم تصفير جميع النقاط**`);
- con.query(`UPDATE top SET txp=0 WHERE gid = '${message.guild.id}'`)
- con.query(`UPDATE top SET txp=0 WHERE gid = '${message.guild.id}' AND id='${message.author.id}'`)
- })
- } catch(e) {
- message.delete();
- }
- })
- }
- if(message.content === prefix + "reset voice") {
- if(!message.member.hasPermission("MANAGE_CHANNELS")) return;
- message.channel.send("**:warning: | لتأكيد عملية تصفير جميع النقاط الكتابية , قم بكتابة : ```confirm```**").then(async msg => {
- try{
- let conf = await message.channel.awaitMessages(m => m.content === "confirm", { max: 1, time: 20000, errors: ["time"]}).then(c => {
- message.delete();
- msg.edit(`**${t} | تم تصفير جميع النقاط**`);
- con.query(`UPDATE top SET vxp=0 WHERE gid = '${message.guild.id}'`)
- con.query(`UPDATE top SET vxp=0 WHERE gid = '${message.guild.id}' AND id='${message.author.id}'`)
- })
- } catch(e) {
- message.delete();
- }
- })
- }
- })
- })
Add Comment
Please, Sign In to add comment