不和谐机器人制造商-MySQL调平系统或Discord.js-MySQL调平系统

Question

让我来布置一下背景：

Discord Bot Maker：我有一个升级系统，它可以根据帖子添加xp，并将其存储到JSON文件中，并且可以正常工作。一旦成员达到某个xp级别，bot将在discord中为他们分配一个新角色。如果我必须重新启动bot，所有拥有xp的成员都会在1级重新启动，使用0 xp。

不一致JSI有一个xp机器人，它根据帖子添加xp，并将信息存储在在线MySQL数据库中。当角色达到某个xp级别时，此bot不会自动分配角色，但如果我需要重新启动bot，则会保存信息。

我需要帮助（给我指出正确的方向）让DBM机器人在MySQL中存储数据（我已经搜索了几个小时，找不到教程或任何东西）。这里是DBM Raw数据（减去ID和其他不相关的信息）

指挥级

{
  "name": "level",
  "permissions": "NONE",
  "restriction": "1",
  "actions": [
    {
      "member": "1",
      "varName": "",
      "dataName": "exp",
      "defaultVal": "0",
      "storage": "1",
      "varName2": "memberexp",
      "name": "Store Member Data"
    },
    {
      "member": "1",
      "varName": "",
      "dataName": "level",
      "defaultVal": "1",
      "storage": "1",
      "varName2": "myLevel",
      "name": "Store Member Data"
    },
    {
      "channel": "0",
      "varName": "",
      "message": "```You are level ${tempVars(\"myLevel\")} with ${tempVars(\"memberexp\")}!```",
      "storage": "0",
      "varName2": "",
      "name": "Send Message"
    }
  ],
  "_id": "Tucww",
  "comType": "0"
}

指挥级系统

{
  "name": "LevelingSystem",
  "temp": "msg",
  "event-type": "2",
  "actions": [
    {
      "info": "0",
      "find": "channelid goes here",
      "storage": "2",
      "varName": "channel name goes here",
      "name": "Find Channel"
    },
    {
      "storage": "2",
      "varName": "myLevel",
      "comparison": "1",
      "value": "7",
      "iftrue": "2",
      "iftrueVal": "7",
      "iffalse": "0",
      "iffalseVal": "",
      "name": "Check Variable"
    },
    {
      "storage": "2",
      "varName": "myLevel",
      "comparison": "1",
      "value": "13",
      "iftrue": "2",
      "iftrueVal": "10",
      "iffalse": "0",
      "iffalseVal": "",
      "name": "Check Variable"
    },
    {
      "storage": "2",
      "varName": "myLevel",
      "comparison": "1",
      "value": "25",
      "iftrue": "2",
      "iftrueVal": "13",
      "iffalse": "0",
      "iffalseVal": "",
      "name": "Check Variable"
    },
    {
      "storage": "2",
      "varName": "myLevel",
      "comparison": "1",
      "value": "50",
      "iftrue": "2",
      "iftrueVal": "16",
      "iffalse": "0",
      "iffalseVal": "",
      "name": "Check Variable"
    },
    {
      "storage": "2",
      "varName": "myLevel",
      "comparison": "1",
      "value": "100",
      "iftrue": "2",
      "iftrueVal": "19",
      "iffalse": "1",
      "iffalseVal": "",
      "name": "Check Variable"
    },
    {
      "info": "0",
      "find": "roleid number goes here",
      "storage": "2",
      "varName": "role name goes here",
      "name": "Find Role"
    },
    {
      "member": "3",
      "varName2": "member",
      "role": "4",
      "varName": "role name goes here",
      "reason": "",
      "name": "Add Member Role"
    },
    {
      "name": "End Action Sequence"
    },
    {
      "info": "0",
      "find": "roleid number goes here",
      "storage": "2",
      "varName": "role name goes here",
      "name": "Find Role"
    },
    {
      "member": "3",
      "varName2": "member",
      "role": "4",
      "varName": "role name goes here",
      "reason": "",
      "name": "Add Member Role"
    },
    {
      "name": "End Action Sequence"
    },
    {
      "info": "0",
      "find": "roleid number goes here",
      "storage": "2",
      "varName": "role name goes here",
      "name": "Find Role"
    },
    {
      "member": "3",
      "varName2": "member",
      "role": "4",
      "varName": "role name goes here",
      "reason": "",
      "name": "Add Member Role"
    },
    {
      "name": "End Action Sequence"
    },
    {
      "info": "0",
      "find": "roleid number goes here",
      "storage": "2",
      "varName": "role name goes here",
      "name": "Find Role"
    },
    {
      "member": "3",
      "varName2": "member",
      "role": "4",
      "varName": "role name goes here",
      "reason": "",
      "name": "Add Member Role"
    },
    {
      "name": "End Action Sequence"
    },
    {
      "info": "0",
      "find": "roleid number goes here",
      "storage": "2",
      "varName": "role name goes here",
      "name": "Find Role"
    },
    {
      "member": "3",
      "varName2": "member",
      "role": "4",
      "varName": "role name goes here",
      "reason": "",
      "name": "Add Member Role"
    },
    {
      "name": "End Action Sequence"
    }
  ],
  "_id": "gUxAU",
  "restriction": "1",
  "comType": "3",
  "permissions": "NONE"
}

事件级别系统

{
  "name": "LevelingSystem",
  "temp": "msg",
  "event-type": "2",
  "actions": [
    {
      "message": "1",
      "varName": "msg",
      "info": "3",
      "storage": "2",
      "varName2": "member",
      "name": "Store Message Info"
    },
    {
      "member": "3",
      "varName": "member",
      "dataName": "exp",
      "changeType": "1",
      "value": "1",
      "name": "Control Member Data"
    },
    {
      "member": "3",
      "varName": "member",
      "dataName": "level",
      "defaultVal": "1",
      "storage": "2",
      "varName2": "myLevel",
      "name": "Store Member Data"
    },
    {
      "member": "3",
      "varName": "member",
      "dataName": "exp",
      "comparison": "4",
      "value": "{serverVars(\"myLevel\")*48}",
      "iftrue": "0",
      "iftrueVal": "",
      "iffalse": "1",
      "iffalseVal": "",
      "name": "Check Member Data"
    },
    {
      "member": "3",
      "varName": "member",
      "dataName": "level",
      "changeType": "1",
      "value": "1",
      "name": "Control Member Data"
    }
  ],
  "_id": "Mtoid"
}

或

我需要弄清楚如何消除这种不和谐。当存储在MySQL中的xp达到某个级别时，js bot向成员添加角色。这就是不和谐。js bot代码（再次删除登录信息）：

./机器人程序。js

const Discord = require('discord.js');
const bot = new Discord.Client();
const mysql = require("mysql");
const prefix = '.';
const fs = require('fs');

bot.commands = new Discord.Collection();


fs.readdir("./cmds/", (err, files) => {
  if(err) console.error(err);

  let jsfiles = files.filter(f => f.split(".").pop() === "js");
  if(jsfiles.length <= 0) {
    console.log("No commands to load!");
    return;
  }

  console.log(`Loading ${jsfiles.length} commands!`);

  jsfiles.forEach((f, i) => {
    let props = require(`./cmds/${f}`);
    console.log(`${i + 1}: ${f} loaded!`);
    bot.commands.set(props.help.name, props);
  });
});

bot.login(process.env.BOT_TOKEN);

bot.once('ready', () => {
    console.log('Bot is online!')
});

var con =mysql.createConnection({
    host: "host name goes here",
    user: "username goes here",
    password: "password goes here",
    database: "database name goes here"
});

con.connect(err => {
  if(err) throw err;
  console.log("Connected to database.");
  
});

function generateXp() {
  let min = 1
  let max = 1
//the above numbers are both one's because I only want each message to count as 1xp
  return Math.floor(Math.random() * (max - min + 1)) + min;
};

bot.on('message', async message => {
  if(message.author.bot) return;
  if(message.channel.type === "dm") return;

  con.query(`SELECT * FROM xp WHERE id = '${message.author.id}'`, (err, rows) => {
    if (err) throw err;
    
    let sql;

    if(rows.length < 1) {
      sql = `INSERT INTO xp (id, xp) VALUES ('${message.author.id}', ${generateXp()})`
    } else {
        let xp = rows[0].xp;
        sql = `UPDATE xp SET xp = ${xp +generateXp()} WHERE id = '${message.author.id}'`;
    }

    con.query(sql);

  });

  if(/(?:https?:\/)?discord(?:app.com\/invite|.gg)/gi.test(message.content)) {
    message.delete();
    return;
  }

  let messageArray = message.content.split(/\s+/g);
  let command = messageArray[0];
  let args = messageArray.slice(1);

  if(!command.startsWith(prefix)) return;

  let cmd = bot.commands.get(command.slice(prefix.length));
  if(cmd) cmd.run(bot, message, args, con);

});

./cmds/xp。js

module.exports.run = async (bot, message, args, con) => {
    let target = message.mentions.users.first() || message.author;

    con.query(`SELECT * FROM xp WHERE id = '${target.id}'`, (err, rows) => {
        if(err) throw err;

        if(!rows[0]) return message.channel.send("This member has no XP on record.")
        let xp = rows[0].xp;
        message.channel.send(xp);
    });
};

module.exports.help = {
    name: "xp"
}

Answer 1

我对Discord Bot Maker没有太多经验，但我可以为Discord提供一个潜在的解决方案。js。它的文档可能需要一点时间来适应，但是做得很好，对于找到您需要的东西非常有用。

在主消息事件处理程序中，在运行更新其体验点的SQL查询（con.query（SQL））后，您应该检查其体验点是否超过该角色的阈值。

// inside the callback for your SELECT query
if (err) throw err;

let sql;
let originalXp;
let updatedXp;

if (rows.length < 1) {
  originalXp = 0;
  updatedXp = generateXp();
  sql = `INSERT INTO xp (id, xp) VALUES ('${message.author.id}', ${updatedXp})`;
} else {
  originalXp = rows[0].xp;
  updatedXp = originalXp + generateXp();
  sql = `UPDATE xp SET xp = ${updatedXp} WHERE id = '${message.author.id}'`;
}

con.query(sql);

// if you want different roles at certain thresholds, replace this with the snippet later in the answer
if (originalXp < SOME_XP_THRESHOLD && updatedXp >= SOME_XP_THRESHOLD) {
  // this example gets a role based on name
  // you could also get the role you want using some other criteria
  const role = message.member.guild.roles.cache.find(role => role.name === ROLE_TO_ADD);
  message.member.roles.add(role);
}

如果要包含多个角色以达到各种阈值，可以将它们设置在一个数组中：

const roles = [
  {
    name: 'foo',
    threshold: 5,
  },
  {
    name: 'bar',
    threshold: 10,
  },
];

然后在它们之间循环：

// insert this snippet instead at the point indicated above
for (const xpRole of roles) {
  if (originalXp < xpRole.threshold && updatedXp >= xpRole.threshold) {
    const role = message.member.guild.roles.cache.find(role => role.name === xpRole.name);
    // you could potentially remove the previous role here as well
    message.member.roles.add(role);
  }
}