JSON数据库的排行榜命令

Question

我有一个水平系统，代码如下，它使用JSON数据库对数据进行排序，如{"626916199783071750":{"xp":94,"level":12}。我想制作一个命令，按照级别顺序显示所有成员的领导委员会。代码

nst Discord = require('discord.js');
const client = new Discord.Client();
const config = require('./config.json');
const fs = require("fs");
let db = JSON.parse(fs.readFileSync("./database.json", "utf8"));
client.on("message", message => {
if (message.author.bot) return; // ignore bots
// if the user is not on db add the user and change his values to 0
if (!db[message.author.id]) db[message.author.id] = {
xp: 0,
level: 0
};
db[message.author.id].xp++;
let userInfo = db[message.author.id];
if(userInfo.xp > 100) {
userInfo.level++
userInfo.xp = 0
message.reply("Congratulations, you level up")
}
const args = message.content.slice(config.prefix.length).trim().split(/ +/g);
const cmd = args.shift().toLowerCase();
if(cmd === "rank") {
let userInfo = db[message.author.id];
let member = message.mentions.members.first();
let embed = new Discord.RichEmbed()
.setColor(0x4286f4)
.addField("Level", userInfo.level)
.addField("XP", userInfo.xp+"/100");
if(!member) return message.channel.sendEmbed(embed)
let memberInfo = db[member.id]
let embed2 = new Discord.RichEmbed()
.setColor(0x4286f4)
.addField("Level", memberInfo.level)
.addField("XP", memberInfo.xp+"/100")
message.channel.sendEmbed(embed2)
}
fs.writeFile("./database.json", JSON.stringify(db), (x) => {
if (x) console.error(x)
});
})
client.login(config.token)

BTW im使用discord.js v12+

Answer 1

如果您需要按照您提供的方式对JSON数据进行排序，这里是解决方案

// Your database
const members = [
{"626916199783071750":{"xp":94,"level":7}},
{"626916199783071750":{"xp":94,"level":22}},
{"626916199783071750":{"xp":94,"level":12}}
];
// Sort function
members.sort(function(a, b) {
const keyA = a[Object.keys(a)[0]].level,
keyB = b[Object.keys(a)[0]].level;
// Compare
// (swap -1 and 1 to change sort order)
if(keyA < keyB) return -1;
if(keyA > keyB) return 1;
return 0;
});
// Result
console.log(members);