Displays a leaderboard of users with the most money on your discord server. This snippet is a mod you can add to the Basic Discord Economy App: https://autocode.com/app/starsblaster/economy-app/
const lib = require('lib')({token: process.env.STDLIB_SECRET_TOKEN});
if (context.params.event.content.startsWith(`${process.env.prefix}leader`)) {
let database = await lib.googlesheets.query['@0.3.0'].select({
range: `A:E`,
bounds: `FIRST_EMPTY_ROW`,
});
database.rows.sort((a,b) => {
return parseInt(b.fields.money) - parseInt(a.fields.money)
});
let leaderBoardFields = []
database.rows.slice(0,10).forEach((row)=>{
let userName = row.fields.username;
let userValue = `💰 ${row.fields.money}`;
leaderBoardFields.push({ name: userName, value: userValue })
});
await lib.discord.channels['@0.1.1'].messages.create({
channel_id: context.params.event.channel_id,
content: '',
embed: {
title: '** Leader Board **',
type: 'rich',
color: 0x0000AA,
description: '',
fields: leaderBoardFields
}
})
}