MySQL Issue

[shadow badger]

Hey, I have a server ID i need to insert, but unsure of when i would insert it? first time a command is sent? first time the bot joins a server? Its a giveaways bot

[crisp rivet]

first time the bot joins a server is the correct way to do it

Especially if you have a public growing bot

[shadow badger]

Alright, What about the bot being offline or crashing and not counting the join? (Of course this wouldnt happen often, as it is public but its good to keep in mind)

[crisp rivet]

you might need to use some of the other ways if your bot is already in a few servers

[shadow badger]

^ if i was ignoring what i just said, id use guild.join right

[shadow badger]

wym?

[crisp rivet]

yeah you wont get join events if your bot is offline when someone adds it.

[shadow badger]

So what would i use instead of join event?

[crisp rivet]

you can check that all the bot guild ids are in the db, on ready. along with the on guild join listener

[shadow badger]

And, if a guild ID is not in the DB, i insert it?

[shadow badger]

I get everything up to on ready, what do i do with guild join listener?

[crisp rivet]

yep

[crisp rivet]

what if your bot joins a server when it is online. you dont want to wait till a restart for it to get added

[shadow badger]

Oh yeah that's true, so I'd also just do this on the event

[crisp rivet]

you dont need to check if its already in the db

Just insert it

Although you might want to listen for on guild remove too
But thats upto you

[crisp rivet]

if you dont listen for guild remove, you need to check

[shadow badger]

isnt check and listen same thing

[crisp rivet]

by listen i meant listening for the on_guild_remove events

👀

[shadow badger]

Ah alr, yeah