Snippet: Level LeaderBoard extension for All-in-one Levelling System

Level LeaderBoard extension for All-in-one Levelling System

KSK — KSK1

Get a list of the top 10 user's!, This leaderboard extension requires the same google sheet used in the All-in-one Levelling System that was made by Hakiki. https://docs.google.com/spreadsheets/d/1MtxpE5nogVypBQy79iPQ2Y45Q_7thvvGP08dYeDUrYQ/template/preview

const lib = require('lib')({token: process.env.STDLIB_SECRET_TOKEN});

let database = await lib.googlesheets.query['@0.3.0'].select({
  range: `A:D`,
  bounds: `FIRST_EMPTY_ROW`,
});

database.rows.sort((a, b) => {
  return parseInt(b.fields.Level) - parseInt(a.fields.Level);
});
database.rows.sort((a, b) => {
  return parseInt(b.fields.Points) - parseInt(a.fields.Points);
});

let LBFields = [];
database.rows.slice(0, 10).forEach((row) => {
  let Username = row.fields.Username;
  let userValue = `\`🏆\` **Level:** \`${row.fields.Level}\` | \`👾\` **Points:** \`${row.fields.Points}\``;
  LBFields.push({name: Username, value: userValue});
});

await lib.discord.channels['@0.3.1'].messages.create({
  channel_id: context.params.event.channel_id,
  content: '',
  embed: {
    title: '**Level Leader Board **',
    type: 'rich',
    color: 0x9c00ff,
    description: '',
    fields: LBFields,
  },
});