loud quail
const userdb = await client.userdb.findOne({
userID: interaction.user.id
})
let cupcake = Math.floor(Math.random() * 2000) + 200
await client.userdb.updateOne({
userID: interaction.user.id
}, { $set: {
"economia.cupcake": userdb.economia.cupcake + cupcake }
})```
steep roverBOT
loud quail
This is the schema folder
const { Schema, model } = require("mongoose");
const userset = new Schema({
userID: { type: String },
economia: {
banco: { type: Number, default: 0 },
cupcake: { type: Number, default: 0 },
},
});
module.exports = model("Usuários", userset);```
earnest hinge
Show your code please
loud quail
index
client.userdb = require("./schema/user.js")
mg.connect(process.env.mongodb, {
}).then(() => console.log(`Database logada com sucesso.`));```Code
const Discord = require("discord.js");
module.exports = {
name: "trabalhar",
description: "「Economia」trabalhe para receber uma recompensa.",
type: Discord.ApplicationCommandType.ChatInput,
run: async (client, interaction) => {
const userdb = await client.userdb.findOne({
userID: interaction.user.id
})
const emprego = [
"Pedreiro",
"Pintor",
"Bombeiro",
"Policial",
"Animador de Restaurante",
"Feirante",
"Traficante",
"Ladrão de carros",
"Presidente",
"Vendedor De Carros"
]
let cupcake = Math.floor(Math.random() * 2000) + 200
await client.userdb.updateOne({
userID: interaction.user.id
}, { $set: {
"economia.cupcake": userdb.economia.cupcake + cupcake }
})
const emprego1 = emprego[Math.floor(Math.random() * emprego.length)]
const embed = new Discord.EmbedBuilder()
.setTitle(`( ✅ ) Trabalho realizado`)
.setColor("#8D7866")
.setDescription(`** ✅ - **<@${interaction.user.id}> você trabalhou de **${emprego1}** e faturou **${dinheiro} Cupcakes**.`)
interaction.reply({embeds: [embed]})
}
}```Correct me if I'm wrong, I haven't used mongodb in a long time. But where you have userdb.economia.cupcake + cupcake, userdb.economie.cupcake isn't the location of the #? Wouldn't it be within the findOne's ID?
I am going to bed, good luck
daring stirrup
```js
const userdb = await client.userdb.findOne({
userID: interaction.user.id
}...
findOne (line 1) is returning undefined
so you're setting userdb = undefined and then trying to read (undefined).economia, which doesn't exist
either the query is incorrect or there's no db entry for that user
loud quail
that's what i want to know
I've been asking for help for days to store in the database and no one helps me
loud quail
index
```js
client.userdb = require("./schema/user.js")
mg.connect(p...
I was told to put this in index.js and I put
@daring stirrup can you help me?
daring stirrup
ok so basically, findOne will return undefined if the user is not already in the database
so your code should check if the result is undefined, and substitute in a default value
loud quail
so your code should check if the result is undefined, and substitute in a defaul...
But is he right? why doesn't anyone explain to me the right way to do it then I don't know how it is
loud quail
@daring stirrup help me to solve this problem
daring stirrup
But is he right? why doesn't anyone explain to me the right way to do it then I ...
I have no clue what eX meant in their message
I haven't used mongodb before, but logically findOne should return whatever object matches the query (or undefined if no such object)
lucid idol
findOne() returns null specifically if there is no data. You can use some sorta tenary operator for example
userdb ? userdb.economia.cupcake + cupcake : cupcake
@loud quail this is for you
loud quail
findOne() returns null specifically if there is no data. You can use some sorta ...
Can you help me with mongodb, I've been asking for help for days but nobody helps me, I need help saving information and setting money, reputation etc
But no one helps me
lucid idol
Sure just specify what you need help with
loud quail
This is the schema folder
```js
const { Schema, model } = require("mongoose");
...
first is this right?
loud quail
index
```js
client.userdb = require("./schema/user.js")
mg.connect(p...
Is this correct?
lucid idol
This is the schema folder
```js
const { Schema, model } = require("mongoose");
...
This is right depending on what your desired outcome is
But to me from what I can gather
Yes
lucid idol
index
```js
client.userdb = require("./schema/user.js")
mg.connect(p...
Yes I think so
loud quail
Okay, as I am making a command work, it needs to save the user information in the money case.
When I go to use the wallet, the bot will find his information in the case of money and money in the bank.
lucid idol
What you’re doing is correct
Just if the db doesn’t find any document witg that userId it’ll return null
So you’ll either wanna make a document where you findOne() add the money to the user
Or you’ll want to use what I said and then also add upsert: true into the third part of the options in updateOne()