0

I wanted to make a MySQL query with my Discord.js bot, however, I always get an error.

My Code:

client.on("message", async (message) => {
    if (message.content.startsWith("?userinfo")) {
        database.query("SELECT members FROM usertable WHERE username=?", [message.content], function (err, results) {
            if (err) {
                throw err;
            }
            //console.log(results[0]);

            var resultArray = Object.values(JSON.parse(JSON.stringify(results[0])));
            console.log(resultArray);
            steamid = resultArray;
        });
    }
});
Improve this question
1
  • What error are you getting? Commented Jan 24, 2021 at 15:12

1 Answer 1

Reset to default
1

you take over the complete message content and therefore the error occurs create a variable and give it the message content

var messageContent = message.content.slice(10);

(slice takes the complete string and truncates it to the length specified)

And then replace the message.content in the sql query with "messageContent".

example:

    client.on('message', async message => {
        if (message.content.startsWith('?userinfo')) {
            var messageContent = message.content.slice(10);
            database.query('SELECT members FROM usertable WHERE username=?', [messageContent], function (err,results) {
                if (err) {
                    throw err;
                }
                //console.log(results[0]);
    
                var resultArray = Object.values(JSON.parse(JSON.stringify(results[0])));
                console.log(resultArray);
                steamid = resultArray;
            })
    
      }
    }
Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.