Gettin ctx.author by using buttons | Pycord | Page 1

ivory phoenix Dec 22, 2022, 1:12 AM

#

Given the code

async def join(ctx, game_id):
    msg = await ctx.respond("test", view=ChoosingView())

How can I get the ctx.author inside the choosingView class?
For example, when I click the button, he says "Hello, fibertero"

wraith kiln Dec 22, 2022, 1:12 AM

#

You can pass the author as a parameter to your view class and assign it to self

ivory phoenix Dec 22, 2022, 1:13 AM

#

I tried that

proud jackal Dec 22, 2022, 1:13 AM

#

interaction.user

#

In your callback you receive a discord.Interaction

#

.rtfm Interaction

somber adderBOT Dec 22, 2022, 1:14 AM

#

124 total results

proud jackal Dec 22, 2022, 1:14 AM

#

Aw gawd

#

.rtfm discord.Interaction

somber adderBOT Dec 22, 2022, 1:14 AM

#

109 total results

kindred marlin Dec 22, 2022, 1:14 AM

#

just take his word

proud jackal Dec 22, 2022, 1:14 AM

#

Last one

kindred marlin Dec 22, 2022, 1:14 AM

#

.rtfm interaction.user

somber adderBOT Dec 22, 2022, 1:14 AM

#

2 results

discord.Interaction.user
discord.MessageInteraction.user

kindred marlin Dec 22, 2022, 1:14 AM

#

:)

ivory phoenix Dec 22, 2022, 1:14 AM

#

oh

#

thanks

#

lemme try

wraith kiln Dec 22, 2022, 1:15 AM

#

somber adder

Why doesn't the search prioritize exact matches anyways?

kindred marlin Dec 22, 2022, 1:15 AM

#

wraith kiln Why doesn't the search prioritize exact matches anyways?

because I coded it

wraith kiln Dec 22, 2022, 1:15 AM

#

I see

kindred marlin Dec 22, 2022, 1:15 AM

#

and there was a priority to just at least get it working

ivory phoenix Dec 22, 2022, 1:16 AM

#

kindred marlin Dec 22, 2022, 1:17 AM

#

what's the issue if any?

wraith kiln Dec 22, 2022, 1:17 AM

#

First of all, never manually insert values to an SQL query through f strings, that's an SQL injection waiting to happen

#

second, you're trying to set player to a user object

proud jackal Dec 22, 2022, 1:18 AM

#

The object becomes user#discrim if converted to a string

#

Which is what he's doing

ivory phoenix Dec 22, 2022, 1:18 AM

#

wraith kiln First of all, **never** manually insert values to an SQL query through f strings...

what should I do?

ivory phoenix Dec 22, 2022, 1:19 AM

#

wraith kiln second, you're trying to set `player` to a user object

player is a column

wraith kiln Dec 22, 2022, 1:19 AM

#

ivory phoenix what should I do?

Use query parameters
https://stackoverflow.com/questions/228912/sqlite-parameter-substitution-problem

wraith kiln Dec 22, 2022, 1:19 AM

#

ivory phoenix player is a column

And wouldn't it make more sense to use their ID? What if the user changes their name?

kindred marlin Dec 22, 2022, 1:19 AM

#

or their nitro expires

proud jackal Dec 22, 2022, 1:20 AM

#

Or they buy nitro

kindred marlin Dec 22, 2022, 1:20 AM

#

or like 500 more other reasons on why their name/discriminator changes

wraith kiln Dec 22, 2022, 1:20 AM

#

And currently, if their name is "; DROP TABLE game;-- your entire table is going to be deleted doggokek

ivory phoenix Dec 22, 2022, 1:21 AM

#

ok the code worked

#

the bot is for me and for my friends

wraith kiln Dec 22, 2022, 1:21 AM

#

That isn't an excuse to be doing bad practices

kindred marlin Dec 22, 2022, 1:21 AM

#

#general message

wraith kiln Dec 22, 2022, 1:21 AM

#

always use SQL parameters no matter what

ivory phoenix Dec 22, 2022, 1:21 AM

#

and i don't know how to keep my database safe so i will keep it anyway

wraith kiln Dec 22, 2022, 1:22 AM

#

bruh

#

I just told you how

ivory phoenix Dec 22, 2022, 1:22 AM

#

wraith kiln always use SQL parameters no matter what

ok

#

I'll do it

#

but I thank you right away because the bot is working

ivory phoenix Dec 22, 2022, 1:23 AM

#

wraith kiln And wouldn't it make more sense to use their ID? What if the user changes their ...

I already changed it

wraith kiln Dec 22, 2022, 1:24 AM

#

I just held a presentation about SQL injections and XSS for my colleagues last week, hopefully they learn as quickly as you do lol

tranquil kite Dec 22, 2022, 1:24 AM

#

You should use ids for anything when working with a database.

#

Like Spaxter said, they could change their name, you can’t change your ID.

ivory phoenix Dec 22, 2022, 1:25 AM

#

wraith kiln Dec 22, 2022, 1:26 AM

#

Like said, there are a million ways their name/discriminator could change, so using IDs is a lot better

kindred marlin Dec 22, 2022, 1:26 AM

#

wraith kiln Like said, there are a million ways their name/discriminator could change, so us...

~~your Discord ID can also change because Ian Deploy~~

ivory phoenix Dec 22, 2022, 1:27 AM

#

thanks for all the help

#

ans sorry for my english

#

I'm brazillian

kindred marlin Dec 22, 2022, 1:27 AM

#

your English was fluent

ivory phoenix Dec 22, 2022, 1:27 AM

#

oh

#

nice (:

kindred marlin Dec 22, 2022, 1:27 AM

#

.close

somber adderBOT Dec 22, 2022, 1:27 AM

#

Done with your help thread?

Please close your own help thread by using </close:1009144375709814897> with @vernal geyser.

#Gettin ctx.author by using buttons