discord-bots

[brazen raft]

There is a library called hikari which is a strong typed development library for discord bots in Python

[small igloo]

writing a novel maybe?

[upbeat otter]

yes

[upbeat otter]

!pypi hikari

[unkempt canyon]

hikari v2.0.0.dev104

A sane Discord API for Python 3 built on asyncio and good intentions

[upbeat otter]

ohhh

[upbeat otter]

m-m-m-m-m-m-m-m-m-m-m-m--m-m-m-m-m--m-m-m-m-m-m-m-maybe

[small igloo]

why discord creator replace all API tho

[upbeat otter]

not replace, update

[small igloo]

but oppositing dpy thing, why

[small igloo]

nice, (maybe) she's not done yet

[upbeat otter]

not opposing, the updates may break dpy, thats why

[small igloo]

nah, "why"

[upbeat otter]

because of the way its written and the way the API changes

[strong shale]

!pypi nextcord

[unkempt canyon]

nextcord v2.0.0a3

A Python wrapper for the Discord API forked from discord.py

[small igloo]

then why update it lol

[small igloo]

r u advertising or what

[upbeat otter]

why not

[upbeat otter]

!pypi discord

[unkempt canyon]

discord v1.7.3

A mirror package for discord.py. Please install that instead.

[strong shale]

I'm not the owner/contributer of that package 🤷
Why would I ?

[visual island]

Once upon a time, lives a human named "Danny". He actually do work as a doctor in a hospital in Japan. He also made an API wrapper of Discord with python as a hobby. It's a big repo with 9k+ starts. But one day, he got pressured & hate so much by the community. Saying probably like "dpy is so slow on development" most of the times. But actually it's fine as all of the Devs does that as hobby and in free times. But finally the Devs decide to quit and yeah Danny also got frustated by the hate and decided to quit the development and archived the repo. Probably 99% of the community are mad at him but imo (and their opinion (the Devs)) it's not worth it. So yeah, now the library is fully undeveloped anymore and will may be unsupported in the near future. The end.

~ Based on real story

[quick gust]

disnake >

[upbeat otter]

~~
Essay~~

[quick gust]

fail

[small igloo]

if the way an update just break old system that gud, THAT'S LITTERALY WINDOWS 10 UPDATE WAY

[visual island]

More like a short story

[small igloo]

novel be like:

[small igloo]

He actually do work as a doctor in a hospital in Japan?

_sup @boreal ravine _

[boreal ravine]

how do I change the cog_check error

[visual island]

yeah

[boreal ravine]

danny is japanese? or is he just living there

[boreal ravine]

sup

[small igloo]

secret feature: import python-covid19

[visual island]

he is japanese

[boreal ravine]

o

thats gtk

[small igloo]

hmm give proof

[boreal ravine]

click the github for proof

[strong shale]

If I want to do advertising
Then I would send my own package here lol

If you want proof read about me in my profile

[cinder horizon]

any code where we can give a hyper link in an embed where the link is of an announcement channel and wen the user clicks it kinda follows the channel....if ukwim

[small igloo]

what? isn't it how ,url=... work? (in title)

[strong shale]

Ya

[small igloo]

embed=discord.Embed(title="sup announcement", url="url", description="", color=0xFF5733)

[strong shale]

I'll be the owner of my package na 😂

[cinder horizon]

like uhh...if i click it prompts me to follow it to a channel...more or less a "Bot-status" channel without askin evry single user to join the server for following

[cinder horizon]

this ik...

[small igloo]

hmm, who's saikerthaan smth then

[small igloo]

wut tha hell u want :l

[strong shale]

I'm sai keerthan bro
See who's the owner/ maintainer of nextcord

[cinder horizon]

welcoming i'd say....welp nvm m high today

[small igloo]

skrphenix? who

[small igloo]

A

[strong shale]

Me only

[small igloo]

oh u have pypi and github profile?

[strong shale]

Yes

[slate swan]

ooof

[small igloo]

ou ok ok ||noice||

[strong shale]

hm..

[small igloo]

help #2

[small igloo]

how many discord friends u hav xd

[velvet tinsel]

ok

[small igloo]

sup :3

[velvet tinsel]

show code

[strong shale]

Maybe 5 - 10 as friends and others in random servers

[velvet tinsel]

full traceback

[small igloo]

does they know that u r the developer of pycord-btns-menus

[strong shale]

Ya

So

[small igloo]

then how the hell u just have 10 friends?? (no pending friend req?)

[strong shale]

You are getting an error in database file in add() func

[strong shale]

I'll either reject or accept requests as they come

[velvet tinsel]

I think it should be commands.CommandNotFound

[strong shale]

At present I have 12 pending requests
it means nothing though

[velvet tinsel]

!ot

[unkempt canyon]

Off-topic channels

There are three off-topic channels:
• #ot2-never-nester’s-nightmare
• #ot1-perplexing-regexing
• #ot0-psvm’s-eternal-disapproval

Their names change randomly every 24 hours, but you can always find them under the OFF-TOPIC/GENERAL category in the channel list.

Please read our off-topic etiquette before participating in conversations.

[strong shale]

👍

[small igloo]

what

[velvet tinsel]

you should have a commands. before it I think

[strong shale]

See traceback carefully bro, the error is related to database file not in main.py or anything

[placid skiff]

Guys how can I assign NULL to a sqlite3 column with a query?

[lament mesa]

UPDATE TABLE_NAME SET COULMN_NAME = NULL WHERE CONDITION

[brazen raft]

As a query variable, you can use None

Probably.

[bleak sinew]

Guys, is it possible to make multiple nested commands group inside a command group in a Cog?

Like : Command Cog -> Commands Group -> Commands Group -> Commands

[boreal ravine]

how do i make my bot re-invoke a command

[boreal ravine]

yes

@commands.group()
async def do(self, ctx):
  ...
@do.group()
async def this(self, ctx):
  ...
@this.group()
async def lol(self, ctx):
  ...
``` `!do this lol`

[slate swan]

!d discord.ext.commands.Command.invoke

[unkempt canyon]

I'm sorry Dave, I'm afraid I can't do that.

No documentation found for the requested symbol.

[slate swan]

🤦 im high today ig

[visual island]

it exists

undocumented

[boreal ravine]

o

[small igloo]

then what's wrong

[slate swan]

oh , so you can basically Context.command.invoke() ;)

[boreal ravine]

https://docs.disnake.dev/en/latest/ext/commands/api.html?highlight=command invoke#disnake.ext.commands.Context.invoke why is invoke in the context class

[slate swan]

thats different

but you can use that too in your case

[boreal ravine]

o

[visual island]

Command.invoke is used for the internals

[boreal ravine]

hm

[small igloo]

nah what's wrong ;-;

helo?

[visual island]

you're inserting something that isn't supported by sqlite3

[strong shale]

Ya

[small igloo]

what is it

[visual island]

we need your code

[small igloo]

uh it's there with the error screenshot...?

[small igloo]

z

[visual island]

the code where you call the function

[small igloo]

it's there :E

[visual island]

str() it

[small igloo]

hmm

[visual island]

str(ctx.author) -> "name#0000"

[small igloo]

btw what is the code for create table if not exist?

[visual island]

CREATE TABLE IF NOT EXISTS tablename (...)

[small igloo]

ow ok, thanks

[boreal ravine]

How do I make my bot make another embed if the index was over 10? (a paginator)

[placid skiff]

!d discord-ext-menus

[strong shale]

# Use like this
conn.execute(f"INSERT INTO users_data (NAME, COIN, EXP, MAX_EXP) VALUES ('{name}', 25, 0, 125)")

[strong shale]

Try this @small igloo

[placid skiff]

https://github.com/Rapptz/discord-ext-menus

[boreal ravine]

me thought f-strings bad in sql

[boreal ravine]

hmm

[strong shale]

But it's fine if you use it with if-conditions

[upbeat otter]

~~
Same thing tho~~

[strong shale]

Maintainence is important

[placid skiff]

What happen if i pass a variable with None value into a query like that one?

[bitter perch]

Do not use f strings for sql queries.

[sage otter]

They are

[strong shale]

IK, but let's check if he's getting the same error or not

[placid skiff]

.

[wide tartan]

I'm getting this error even though I already have intents

[strong shale]

It'll not work obviously

[placid skiff]

That's not caused by intents

[visual island]

show code

[placid skiff]

so how can i add NULL value? i have to check every value I add first and if they are none give NULL to the query?

[slate swan]

i think target had a value of None, or defined

[wide tartan]

https://www.toptal.com/developers/hastebin/jikacusiwe.py

[slate swan]

most likely had a value of None

[slate swan]

send the parent where it errored

You don't need any intents for that code, just as side note.

[strong shale]

I given the code, to check whether all the code and database is working or not
It's not for full usage

[placid skiff]

past the error too

[wide tartan]

it's above

[placid skiff]

we can't see what line the error raises

It's not the entire error -.-

[slate swan]

read the error

[placid skiff]

Bro that line is the discord.py package

[cobalt jacinth]

how to give default value to arguments...lets say i want to have 3 arguments from the command

[wide tartan]

that's inside the discord.py

[slate swan]

oh my fault

yeah send the entire error

[placid skiff]

No bro, give the full error

[slate swan]

[placid skiff]

i can't check every line of your code D_D

[wide tartan]

oops wait

[strong shale]

def func(arg1, arg2,  arg3 = "default"):
    # Do something here ...

[cobalt jacinth]

abc(ctx,one=None,two = None)

[wide tartan]

that's the entire error

[slate swan]

its the last 15 lines

not the entire error

[placid skiff]

yeah i'm checking

[slate swan]

not sure how to show the full error on a vps

[visual island]

tracebacks starts with "Traceback (most recent call last)"

[cobalt jacinth]

it will default value if not specified ?

[visual island]

!tb

yea

[slate swan]

!traceback

[unkempt canyon]

Please provide the full traceback for your exception in order to help us identify your issue.

A full traceback could look like:

Traceback (most recent call last):
    File "tiny", line 3, in
        do_something()
    File "tiny", line 2, in do_something
        a = 6 / b
ZeroDivisionError: division by zero

The best way to read your traceback is bottom to top.

• Identify the exception raised (in this case ZeroDivisionError)
• Make note of the line number (in this case 2), and navigate there in your program.
• Try to understand why the error occurred (in this case because b is 0).

To read more about exceptions and errors, please refer to the PyDis Wiki or the official Python tutorial.

[strong shale]

Ya

[wide tartan]

so-

[slate swan]

show the full error

[wide tartan]

how-

[placid skiff]

we need the entire traceback

[cobalt jacinth]

ok thanks

[wide tartan]

how am i supposed to show it in a vps

[slate swan]

idk tbh , try running the code locally or find a way to show the full error

[strong shale]

Np

[slate swan]

are you using pm2 ?

[wide tartan]

yeah

[placid skiff]

WHY ARE YOU DEVELOPING INTO A VPS LOL

[wide tartan]

cause I have multiple bots running in it

what else am i supposed to use, a free server that uses shared IPs??

[slate swan]

pm2 logs -err

[placid skiff]

no, usually it is better to develop in local D_D

[slate swan]

well most likely you should develop it first on your device and when everything is working fine i upload it to the vps

[wide tartan]

it's pm2 logs actually

i did that and that's what it sent

[placid skiff]

exactly

[slate swan]

pm2 logs -err botname

or something like that

logs only show the last 15 messages wither its an error or not

[visual island]

@wide tartan seems that ctx.guild is None. Do you invoke the command on dms?

[slate swan]

https://pm2.keymetrics.io/docs/usage/log-management/ read

[wide tartan]

no

[placid skiff]

Look, i know what the error is, but without knowing the line i can't tell where it raise D_D
Essentially you are passing a nonetype value and using it like a Guild, Channel or User object

[visual island]

@wide tartan can you print role?

[small igloo]

hm ok

[visual island]

its the one that's None

[small igloo]

what did i missed

[wide tartan]

give me a sec

[visual island]

not ctx.guild apparently

[silk mauve]

Is it able that the bot gets the user banner? Same as a avatar command but just as banner

[wide tartan]

@placid skiff

[wide tartan]

alr, will do

[slate swan]

afaik if you add one as None every arg after is None

[small igloo]

sup

[visual island]

!e

def foo(a = None, b): ... 
foo()
```nah

[unkempt canyon]

@visual island :x: Your eval job has completed with return code 1.

001 |   File "<string>", line 1
002 |     def foo(a = None, b): ... 
003 |                       ^
004 | SyntaxError: non-default argument follows default argument

[slate swan]

mhmm

[placid skiff]

!d discord.Guild.create_text_channel

[unkempt canyon]

discord.Guild.create\_text\_channel

await create_text_channel(name, *, reason=None, category=None, position=..., topic=..., slowmode_delay=..., nsfw=..., overwrites=...)```
This function is a [*coroutine*](https://docs.python.org/3/library/asyncio-task.html#coroutine).

Creates a [`TextChannel`](https://discordpy.readthedocs.io/en/master/api.html#discord.TextChannel "discord.TextChannel") for the guild.

Note that you need the [`manage_channels`](https://discordpy.readthedocs.io/en/master/api.html#discord.Permissions.manage_channels "discord.Permissions.manage_channels") permission to create the channel.

The `overwrites` parameter can be used to create a ‘secret’ channel upon creation. This parameter expects a [`dict`](https://docs.python.org/3/library/stdtypes.html#dict "(in Python v3.9)") of overwrites with the target (either a [`Member`](https://discordpy.readthedocs.io/en/master/api.html#discord.Member "discord.Member") or a [`Role`](https://discordpy.readthedocs.io/en/master/api.html#discord.Role "discord.Role")) as the key and a [`PermissionOverwrite`](https://discordpy.readthedocs.io/en/master/api.html#discord.PermissionOverwrite "discord.PermissionOverwrite") as the value.

Note

Creating a channel of a specified position will not update the position of other channels to follow suit. A follow-up call to [`edit()`](https://discordpy.readthedocs.io/en/master/api.html#discord.TextChannel.edit "discord.TextChannel.edit") will be required to update the position of the channel in the channel list...

[small igloo]

idk if this is work or no, but it seems like it is, thamks

[slate swan]

their was something that made all arg after it None i dont quite remember

[slate swan]

hi

[visual island]

is there?

idk

[slate swan]

i think it was with kwargs i dont remember

[placid skiff]

Probably is something that u pass in the overwrites

[visual island]

*args?

[placid skiff]

Not probably, is it something in the overwrites

[slate swan]

nah nah that just makes arg and unknown amount of args

[wide tartan]

@visual island it returns none

[visual island]

yea

[placid skiff]

overwrites (Dict[Union[Role, Member], PermissionOverwrite]) – A dict of target (either a role or a member) to PermissionOverwrite to apply upon creation of a channel. Useful for creating secret channels.
@wide tartan

[visual island]

yeah, probably the role doesn't exists

can you try with the ID instead?

!d discord.Guild.get_role

[unkempt canyon]

discord.Guild.get\_role

get_role(role_id, /)```
Returns a role with the given ID.

[wide tartan]

oh wait

yeah, apparently i typed in the wrong role

[slate swan]

how do I add 2 buttons in a discord message

@bot.command()
async def donate(ctx):
    await ctx.send("doante below", components=[Button(style=ButtonStyle.URL, label="Steam", url="utl")])
    interaction = await bot.wait_for(
        "button_click", check=lambda inter: inter.custom_id == "button1" 
    )
    await interaction.send(content="Button Clicked")```

[visual island]

put 2 Button in the components list?

[slate swan]

yes

[wide tartan]

Alright it works, ty

[strong shale]

What's your using package ?

[visual island]

yup, nice

[visual island]

yea, just make one more Button to the list

[slate swan]

you mean library?

[strong shale]

ya, discord.py or pycord

[slate swan]

discord.py and discord_components

[strong shale]

oh ok

[small igloo]

is this will work?
def add_coin(name, amount):
conn.execute(f"UPDATE users_data set coin = coin + {amount} where NAME = {name}")

[strong shale]

It'll work bro, but don't use f-strings in sql queries

Use them for testing purposes only

[small igloo]

wait what :) u told me to use that

[small igloo]

why?

[strong shale]

For testing I told

[slate swan]

where are you hosting your discord bot?

[small igloo]

also what's the long for "f" in f-string lol

[visual island]

format

[small igloo]

pycharm E replit sucks

[small igloo]

ow ok

[slate swan]

f strings are used for injections right?

[small igloo]

then i must use what :l

[slate swan]

after it gets public? or done with testing

[small igloo]

wym?

[slate swan]

f-strings are bad with sql databases

[visual island]

f strings are vulnerable to injections

[small igloo]

then i must use waht ;-; not use f string = error code

[slate swan]

forever you will host on pycharm while your laptop/pc is on for 24x7?

[slate swan]

why is that so?

[small igloo]

ig..?

[slate swan]

ohh okay

[small igloo]

:v

[slate swan]

just asking

[small igloo]

ok

[sick birch]

There was this funny comic that explained this perfectly

[small igloo]

sup @sick birch

[small igloo]

hmm, lemme see

[slate swan]

show?

[slate swan]

i remember reading it

[sick birch]

Lmao yeah

Sanitize your inputs kids 👍

[slate swan]

lol

[visual island]

.execute(f"SELECT bla FROM bla WHERE {a}") lets say a is a param from a command. And let's say the value is "true; DROP TABLE bla" and the table will be deleted

[slate swan]

python has explanation to not use f-strings with sql databases i forgot what command it was

[visual island]

!tag injections

[small igloo]

maybe bcuz i'm a newbie i don't understand it, imma save it for later when i already mastered SQL database...

[visual island]

nah

[small igloo]

.bm

[strong shale]

https://www.w3schools.com/sql/sql_injection.asp

[slate swan]

whats ALTER?

[small igloo]

bhre typing so fast will cause that, lemme fix

[small igloo]

wait, where ALTER

[brazen raft]

Alters a table

[slate swan]

i am asking what is ALTER and what does it do?

[small igloo]

bhre i'm a newbie in SQL, u think i will know E

[slate swan]

you guys cant Find walter?

[brazen raft]

It lets you alter tables. An example would be adding an entirely new column to a table

[slate swan]

you just said "i masterd sql" and so-called

[strong shale]

The ALTER TABLE query is used to add, delete, or modify columns in an existing table

[slate swan]

correct

[small igloo]

imma save it for "later" when i already mastered it E

[silk mauve]

Is it able that the bot gets the user banner? Same as a avatar command but just as banner

[visual island]

!d discord.Member.banner

[unkempt canyon]

discord.Member.banner

property banner```
Equivalent to [`User.banner`](https://discordpy.readthedocs.io/en/master/api.html#discord.User.banner "discord.User.banner")

[silk mauve]

thanjs

[small igloo]

wow it's exist

[sinful pasture]

How can I make a change prefix command?

[silk mauve]

ty

[visual island]

in 2.0 yes

[silk mauve]

[sinful pasture]

lol

[small igloo]

:stackoverflow: oh there's no emoji

[silk mauve]

huh

[sinful pasture]

[visual island]

[small igloo]

wait :v it's exist

lol

there we go

[sinful pasture]

Very informative answer, ngl, ty

[strong shale]

# Try this 
conn.execute("INSERT INTO users_data (NAME, COIN, EXP, MAX_EXP) VALUES ('?', 25, 0, 125)", (name,))

[strong shale]

Try this @small igloo

[small igloo]

ok, back to the f-string, can give explanation why it's not recommended

[slate swan]

^

[small igloo]

also where "name" from def add(name): oh it;s there, nvm

[slate swan]

is it for a guild or overall?

[small igloo]

not understand :l

[slate swan]

[strong shale]

# Try this 
conn.execute("INSERT INTO users_data (NAME, COIN, EXP, MAX_EXP) VALUES ('?', 25, 0, 125)", (str(name),))

[small igloo]

what is yert xd

[slate swan]

YERT

anybody have command ideas

[small igloo]

pls work ;-;

[small igloo]

online 3D game in discord >:3 with ASCII characters

[slate swan]

not very suited for my bot lol

[visual island]

1 fps?

[strong shale]

working or not ?

[slate swan]

seems like enough

[small igloo]

Ignoring exception in on_command_error
Traceback (most recent call last):
File "C:\Users\thosiba\Downloads\d-bots\lib\site-packages\discord\ext\commands\core.py", line 85, in wrapped
ret = await coro(*args, **kwargs)
File "C:\Users\thosiba\PycharmProjects\main.py\main.py", line 11, in start
database.add(str(name))
File "C:\Users\thosiba\PycharmProjects\main.py\database.py", line 11, in add
conn.execute("INSERT INTO users_data (NAME, COIN, EXP, MAX_EXP) VALUES ('?', 25, 0, 125)", (str(name),))
sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 0, and there are 1 supplied.

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "C:\Users\thosiba\Downloads\d-bots\lib\site-packages\discord\client.py", line 343, in _run_event
await coro(*args, **kwargs)
File "C:\Users\thosiba\PycharmProjects\main.py\main.py", line 21, in on_command_error
raise error
File "C:\Users\thosiba\Downloads\d-bots\lib\site-packages\discord\ext\commands\bot.py", line 939, in invoke
await ctx.command.invoke(ctx)
File "C:\Users\thosiba\Downloads\d-bots\lib\site-packages\discord\ext\commands\core.py", line 863, in invoke
await injected(*ctx.args, **ctx.kwargs)
File "C:\Users\thosiba\Downloads\d-bots\lib\site-packages\discord\ext\commands\core.py", line 94, in wrapped
raise CommandInvokeError(exc) from exc
discord.ext.commands.errors.CommandInvokeError: Command raised an exception: ProgrammingError: Incorrect number of bindings supplied. The current statement uses 0, and there are 1 supplied.

[visual island]

? Shouldn't be quoted

[small igloo]

what is it about E

[small igloo]

?

[visual island]

yea ?

[slate swan]

multifunctional

[small igloo]

Ignoring exception in on_command_error
Traceback (most recent call last):
  File "C:\Users\thosiba\Downloads\d-bots\lib\site-packages\discord\ext\commands\core.py", line 85, in wrapped
    ret = await coro(*args, **kwargs)
  File "C:\Users\thosiba\PycharmProjects\main.py\main.py", line 11, in start
    database.add(str(name))
  File "C:\Users\thosiba\PycharmProjects\main.py\database.py", line 11, in add
    conn.execute("INSERT INTO users_data (NAME, COIN, EXP, MAX_EXP) VALUES ('?', 25, 0, 125)", (str(name),))
sqlite3.ProgrammingError: Incorrect number of bindings supplied. The current statement uses 0, and there are 1 supplied.

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "C:\Users\thosiba\Downloads\d-bots\lib\site-packages\discord\client.py", line 343, in _run_event
    await coro(*args, **kwargs)
  File "C:\Users\thosiba\PycharmProjects\main.py\main.py", line 21, in on_command_error
    raise error
  File "C:\Users\thosiba\Downloads\d-bots\lib\site-packages\discord\ext\commands\bot.py", line 939, in invoke
    await ctx.command.invoke(ctx)
  File "C:\Users\thosiba\Downloads\d-bots\lib\site-packages\discord\ext\commands\core.py", line 863, in invoke
    await injected(*ctx.args, **ctx.kwargs)
  File "C:\Users\thosiba\Downloads\d-bots\lib\site-packages\discord\ext\commands\core.py", line 94, in wrapped
    raise CommandInvokeError(exc) from exc
discord.ext.commands.errors.CommandInvokeError: Command raised an exception: ProgrammingError: Incorrect number of bindings supplied. The current statement uses 0, and there are 1 supplied.

[small igloo]

then use it lol, it's for game fuction

[strong shale]

Remove quotes and try

[small igloo]

:l what quote

[slate swan]

nahhhh

[visual island]

''

[slate swan]

try to understand what the actual error is

you pasted the entire tracebook usually the line which is causing error and why is in the traceback

[strong shale]

# try this
name = str(name)
conn.execute("INSERT INTO users_data (NAME, COIN, EXP, MAX_EXP) VALUES (?, 25, 0, 125)", (name,))

[slate swan]

dis " or '

[small igloo]

supply smth

[slate swan]

yes so copy that and paste that only

[small igloo]

C: it seems like work, tamks

[small igloo]

pycharm not scroll when select

[strong shale]

np

[small igloo]

funny emoji, check

[visual island]

you can just str(name) in the conn.execute()

[slate swan]

 await ctx.send("Arigato-Gozaimashita For Using This Command\nWe Currently Accept Donations Down Below", components=[Button(style=ButtonStyle.URL, label="Steam", url="url2",), Button(style=ButtonStyle.URL, label='Paypal', url='url`')])
    interaction = await bot.wait_for(
        "button_click", check=lambda inter: inter.custom_id == "button1" "button2"
    )
    await interaction.send(content="Button Clicked")```
the buttons are horizontol how do I make them vertical?

command ideas?🧍‍♂️

[slate swan]

what?

[small igloo]

badword detected!!! banned 3 days

[strong shale]

Ya, for better understanding declaring earlier is also fine

[small igloo]

teleport to another universes, can u do this C:

[slate swan]

no

[small igloo]

ok, then do that

CCCCC:

[slate swan]

okay good luck

.-.

[small igloo]

._.

[visual island]

safe public eval

[small igloo]

uhm, now can someone explain how to use select?

[slate swan]

i cant even do a private eval smh

[small igloo]

then try to do that C:

[slate swan]

to many modules for it

[visual island]

SELECT col, col2, ... FROM table the most basic use

[small igloo]

import *

[slate swan]

stole one

[small igloo]

waht

[slate swan]

pep8 is screaming rn

[visual island]

await ctx.send(eval(code)) :>

[slate swan]

wont work lmfao

[visual island]

wont it?

[slate swan]

all results go to terminal and with a exception it does but results never get shown

[small igloo]

cursor = conn.execute("SELECT name, coin, exp, max_exp from USERS_DATA")
i just know this, and how to take spesific value like from coins or exp

[slate swan]

nope

yall need the results to get redirected

[small igloo]

try to guess my gender from all of my messages

[visual island]

SELECT coin, exp FROM USERS_DATA?

[slate swan]

skeleton

[visual island]

based on your pfp: male

[small igloo]

oh, this?
coin = conn.execute("SELECT coin from USER_DATA")
exp = conn.execute("SELECT exp from USER_DATA")

[slate swan]

im just gonna learn sql bye now

[small igloo]

breh that's sans, not me

[slate swan]

lol

[small igloo]

lol ok

[small igloo]

why u still here

[slate swan]

why so many questions

[small igloo]

is this will work?

[visual island]

you'll learn it in 5 mins for sure

[small igloo]

idk, i'm a kid with so many questions in mah head

[slate swan]

pretty easy im liking it

[slate swan]

im a kid to lol

[small igloo]

then why i still struggle even i alr learn it in 1.5 hours ;-;

[visual island]

you need to fetch it

either fetchall() or fetchone()

[small igloo]

what

[small igloo]

how to use?

[visual island]

!d sqlite3.Cursor.fetchall

[unkempt canyon]

sqlite3.Cursor.fetchall

fetchall()```
Fetches all (remaining) rows of a query result, returning a list. Note that the cursor’s arraysize attribute can affect the performance of this operation. An empty list is returned when no rows are available.

[slate swan]

why does everyone assume because you know python that your old lmfao😭

[small igloo]

coin = fetchall(conn.execute("SELECT coin from USER_DATA"))

...?

[visual island]

no

[small igloo]

you're or your

[small igloo]

the what

[slate swan]

🧍‍♂️

[visual island]

conn.execute(...)
result = conn.fetchall()

[visual island]

the code

[slate swan]

bye now

[small igloo]

and come back after 1 sec

[visual island]

cya

thats okimii

[small igloo]

conn.execute("SELECT coin from USER_DATA")
coin = coin.fetchall()

[sick birch]

I’ve been doing Python for almost 2 years know and I still feel quite stupid, it just takes time

[visual island]

conn.fetchall()

[small igloo]

u off, and u suddenly on, perfect

[visual island]

not coin

[small igloo]

oh right xd

[small igloo]

conn.execute("SELECT coin from USER_DATA")
coin = conn.fetchall()

[small igloo]

do u know 'em IRL

[strong shale]

Slow and Study wins the race

[visual island]

no

[small igloo]

o ok

[strong shale]

experience plays vital role

[small igloo]

tech and smort wins the race-

[visual island]

try it

[strong shale]

😅

[small igloo]

one more check, is this right?

def check_coin(name):
name = str(name)
conn.execute("SELECT coin from USER_DATA where NAME = ?" (name,))
coin = conn.fetchall()
return coin

[visual island]

yes

coin would be a list of tuple

[small igloo]

:D ok, thanks

[full valley]

Anyone here good with asyncio tasks

[small igloo]

this code creates this error, why

def check_coin(name):
    name = str(name)
    conn.execute("SELECT coin from USER_DATA where NAME = ?" (name,))
    coin = conn.fetchall()
    return coin

[small igloo]

no no, not me

[small igloo]

but for docs, here https://docs.python.org/3/library/asyncio-task.html

[tawdry perch]

you don't have to do str(name)

[small igloo]

what? (btw sup)

[tawdry perch]

it's alrd a string afaik

[slate swan]

name is a discord.Member/User object

[small igloo]

eh.. then how to do

[slate swan]

they need to do that

[tawdry perch]

oh I did not know that

[small igloo]

xd ok

[tawdry perch]

can you show the full traceback

[small igloo]

AE then why str object not callable

[full valley]

use a different arg/var name

[slate swan]

can you show your full code and the error you get ( my internet's kinda weak so i cant slide up)

[spring flax]

@bot.command()
async def clone(ctx, role : disnake.Role):
    new_role = await ctx.guild.create_role(name="Altmute")
    for channel in ctx.guild.channels:
        overwrites = channel.overwrites_for(role)
        await channel.set_permissions(new_role, overwrites=overwrites)```
this raises `it says invalid permission given to the keyword now`

[small igloo]

hmm, ok

[small igloo]

full code here, wait

import sqlite3
conn = sqlite3.connect('database.db')
conn.execute('''CREATE TABLE IF NOT EXISTS users_data
         (
         NAME           TEXT    NOT NULL,
         COIN           INT     NOT NULL,
         EXP            INT     NOT NULL,
         MAX_EXP        INT     NOT NULL
         );''')
def add(name):
    name = str(name)
    conn.execute("INSERT INTO users_data (NAME, COIN, EXP, MAX_EXP) VALUES (?, 25, 0, 125)", (name,))

def add_coin(name, amount):
    conn.execute("UPDATE users_data set coin = coin + ? where NAME = ?", (amount, name))

def check_coin(user):
    user = str(user)
    conn.execute("SELECT coin from USER_DATA where NAME = ?" (user,))
    coin = conn.fetchall()
    return coin

and also it shows this

ooooh ok ok, ig i know it

[slate swan]

  for channel in ctx.guild.channels:
        perms = channel.permissions_for(role)
        await channel.set_permissions(new_role, perms)``` try this

[tawdry perch]

you have to pass permissionsoverwrites?

[small igloo]

ok, what is it

[tawdry perch]

!d discord.TextChannel.set_permissions

[unkempt canyon]

discord.TextChannel.set\_permissions

await set_permissions(target, *, overwrite=see - below, reason=None, **permissions)```
This function is a [*coroutine*](https://docs.python.org/3/library/asyncio-task.html#coroutine).

Sets the channel specific permission overwrites for a target in the channel.

The `target` parameter should either be a [`Member`](https://discordpy.readthedocs.io/en/master/api.html#discord.Member "discord.Member") or a [`Role`](https://discordpy.readthedocs.io/en/master/api.html#discord.Role "discord.Role") that belongs to guild.

The `overwrite` parameter, if given, must either be `None` or [`PermissionOverwrite`](https://discordpy.readthedocs.io/en/master/api.html#discord.PermissionOverwrite "discord.PermissionOverwrite"). For convenience, you can pass in keyword arguments denoting [`Permissions`](https://discordpy.readthedocs.io/en/master/api.html#discord.Permissions "discord.Permissions") attributes. If this is done, then you cannot mix the keyword arguments with the `overwrite` parameter.

If the `overwrite` parameter is `None`, then the permission overwrites are deleted.

You must have the [`manage_roles`](https://discordpy.readthedocs.io/en/master/api.html#discord.Permissions.manage_roles "discord.Permissions.manage_roles") permission to use this...

[slate swan]

anti_add = 'on'
@client.event
async def on_message(message):
    global anti_add
    if ".link" in message.content.lower():
        if anti_add == 'on':
            await message.delete()
            await message.channel.send("Απαγορεύετε να στέλνετε λίνκς!")
            await client.process_commands(message)
``` hey how can i add more links.. like .com?

[tawdry perch]

connection object has no fetchall

let me find my sql things

[small igloo]

eh... so any alternative?

[spring flax]

oops

my bad

sorry ghost ping

[visual island]

you should do cur = conn.cursor() in the top

then change to cur.fetchall()

[spring flax]

same error

[visual island]

or cause if you want to hardcore it

[slate swan]

where to put or

[slate swan]

its overwrite kwargs, not with an s

[visual island]

if statement1 or statement2

[small igloo]

def check_coin(user):
user = str(user)
conn.execute("SELECT coin from USERS_DATA where NAME = ?", (user,))
cur = conn.cursor()
coin = cur.fetchall()
return coin

[visual island]

um yea you can do that. But that's not what I meant

[spring flax]

Invalid overwrite type provided. is now raised

[small igloo]

so what u mean

[slate swan]

did you use overwrites_for or permissions_for

[slate swan]

can you show the current code and the full traceback

[tawdry perch]

!d discord.TextChannel.overwrites_for

[unkempt canyon]

discord.TextChannel.overwrites\_for

overwrites_for(obj)```
Returns the channel-specific overwrites for a member or a role.

[spring flax]

i'm supposed to be using overwrites for right?

[slate swan]

yeah

[small igloo]

.... what do u meant

[slate swan]

ok worked but now it keeps deleting the answer and pastes it again

[barren oxide]

hi

[tawdry perch]

Try this ```py
rows = await db.execute("YOUR STATEMENTS HERE")
data = await rows.fetchall()

[barren oxide]

hi

[tawdry perch]

db = connection object

[barren oxide]

hi'

hi

hi

[sly elbow]

Hello

[visual island]

define cur below the line that you define conn

[small igloo]

uh waht

[slate swan]

it must be the cursor....

[tawdry perch]

wdym?

[barren oxide]

hi how ARE you?

[small igloo]

ow ok

[tawdry perch]

I just said what that variable meant in my case

[sly elbow]

Ok

[slate swan]

he's using sqlite, it isnt async

[visual island]

await?

[tawdry perch]

ah

[barren oxide]

byeeeeeeeeeeeeeeeeeeeeeee

[small igloo]

btw it finnaly can send this, but why the coin empty, and from my observation, it's a list...?

[tawdry perch]

I used async version of SQLite, aiosqlite

[slate swan]

@visual islandcan you tell me pls

[barren oxide]

where can i spam?

[sly elbow]

BYEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEE

[tawdry perch]

no where, you don't spam

[visual island]

^ @small igloo

[barren oxide]

😦

[visual island]

seems that the result is empty so it returns an empty list

[barren oxide]

i want to spammmmmmmmmmmm

[tawdry perch]

please don't do that here

[barren oxide]

ok...k

[visual island]

#ot0-psvm’s-eternal-disapproval but still you can't spam

[small igloo]

:l what, wait, i can turn it imto a variable right, ok nvm that, but why empty

[small igloo]

ur own server...?

[boreal ravine]

is there a tutorial on discord-ext-menus

[tacit horizon]

put 30 emojis in 1 msg

[visual island]

cause there's nothing on the db maybe?

[small igloo]

btw discord hav chill mode lol

[slate swan]

no, the best you can have is examples

[visual island]

it should be cur.execute tho not conn.execute

[boreal ravine]

o thanks

[tawdry perch]

there was a tutorial I had used but I don't think I remember it, let me see my history

[barren oxide]

i cant

[visual island]

yea and get muted

[slate swan]

ok worked but now it keeps deleting the answer and pastes it again

[small igloo]

must have 25 there

[tacit horizon]

lul

[barren oxide]

u wont understand

[visual island]

"pastes it again"?

[small igloo]

i can put 100 of them...?

[visual island]

@small igloo

[barren oxide]

if i don't spam i will always get irritated

[small igloo]

about?

[slate swan]

yeah the answer when it deletes the msg

[tawdry perch]

Don't spam here, easy

[visual island]

!d sqlite3.Connection.execute

[small igloo]

ow ok, wait, wait what?

[unkempt canyon]

sqlite3.Connection.execute

execute(sql[, parameters])```
This is a nonstandard shortcut that creates a cursor object by calling the [`cursor()`](https://docs.python.org/3/library/sqlite3.html#sqlite3.Connection.cursor "sqlite3.Connection.cursor") method, calls the cursor’s [`execute()`](https://docs.python.org/3/library/sqlite3.html#sqlite3.Cursor.execute "sqlite3.Cursor.execute") method with the *parameters* given, and returns the cursor.

[barren oxide]

spamming

[tacit horizon]

try it

[visual island]

hmm, should work eitherway

[tawdry perch]

why does it matter tho?

[barren oxide]

/recources

i wanttttttttt

[small igloo]

bruh maybe i will get muted, no

[visual island]

nah, my mistake

[barren oxide]

jhmf

[tawdry perch]

!resources

[unkempt canyon]

Resources

The Resources page on our website contains a list of hand-selected learning resources that we regularly recommend to both beginners and experts.

[tacit horizon]

ya sure

[barren oxide]

thank

[visual island]

@small igloo have you commited the INSERT INTO statement?

[barren oxide]

(phew)

[slate swan]

https://stackoverflow.com/questions/6318126/why-do-you-need-to-create-a-cursor-when-querying-a-sqlite-database

[slate swan]

so ? @visual island

[small igloo]

wait wym?

[gloomy ferry]

!rtfm

[gloomy ferry]

.rtfm

[visual island]

can you show your updated code?

[visual island]

conn.commit() at the INSERT INTO statement

[small igloo]

ok, now u started spamming IN DISCORD BOT, go to #ot2-never-nester’s-nightmare breh

[barren oxide]

invis msg

[small igloo]

u said cur.commit()...?

[visual island]

huh?

[slate swan]

anti_add = 'on'
@client.event
async def on_message(message):
    global anti_add
    if ".link" or 'discord.gg' or '.com' or 'xyz' or 'www.' or 'www' in message.content.lower():
        if anti_add == 'on':
            await message.delete()
            await message.channel.send("dont spam links!")
            await client.process_commands(message)

[tawdry perch]

can you not...

[small igloo]

eh wait, cur.execute()

[visual island]

yea

[barren oxide]

??

[visual island]

below it put conn.commit()

[visual island]

!or

[unkempt canyon]

When checking if something is equal to one thing or another, you might think that this is possible:

if favorite_fruit == 'grapefruit' or 'lemon':
    print("That's a weird favorite fruit to have.")

While this makes sense in English, it may not behave the way you would expect. In Python, you should have complete instructions on both sides of the logical operator.

So, if you want to check if something is equal to one thing or another, there are two common ways:

# Like this...
if favorite_fruit == 'grapefruit' or favorite_fruit == 'lemon':
    print("That's a weird favorite fruit to have.")

# ...or like this.
if favorite_fruit in ('grapefruit', 'lemon'):
    print("That's a weird favorite fruit to have.")

[barren oxide]

~can i not what?~

[tawdry perch]

can you not spam here

[small igloo]

below what E

[barren oxide]

ok

[small igloo]

at least go to off topic ;-;

[barren oxide]

~i know html5~

[visual island]

below <cur/conn>.execute()

[barren oxide]

hi

[slate swan]

huh just put conn.commit()?

[small igloo]

no, this is PYTHON

[visual island]

@barren oxide #ot0-psvm’s-eternal-disapproval

[small igloo]

hmm, all of them?

[visual island]

no, thats for another guy

[small igloo]

for me

[visual island]

read this embed

[slate swan]

im an idiot

[barren oxide]

i know

[sullen shoal]

when i opened the channel for a sec i thought im in #databases

[barren oxide]

lol

[small igloo]

uh for me?

[visual island]

no

[slate swan]

tell me what to do please cause a lot of spam here

[visual island]

bruh this is getting confusing

[visual island]

@slate swan

[small igloo]

just ping me when reply

btw imma sleep, gn all

[visual island]

@small igloo

[barren oxide]

😥

[small igloo]

con.close() used or no

[visual island]

the one which needs to be commited (saved) such as UPDATE, INSERT INTO, ALTER TABLE ..., etc

[small igloo]

mm ok, thanks

[visual island]

you dont need it

[small igloo]

ok :3 thanks, and gn

[tawdry perch]

gn 👋

[visual island]

I'll also sleep in a sec, gn

[tawdry perch]

finally the spam is gone

[visual island]

yeah just ignore things like that and they will eventually leave

[tawdry perch]

I just press the block most of time

I made a temp mute command once and now the whole thing is broken down (database broke)

is there a method to get a cog by name?

and unload it after

[visual island]

yea get_cog exists

!d discord.ext.commands.Bot.get_cog

[unkempt canyon]

discord.ext.commands.Bot.get\_cog

get_cog(name)```
Gets the cog instance requested.

If the cog is not found, `None` is returned instead.

[slate swan]

in <string>' requires string as left operand, not tuple py anti_add = 'on' @client.event async def on_message(message): global anti_add if ('www','https','.com','link','xyz','www.','.link','.gr') in message.content.lower(): if anti_add == 'on': await message.delete() await message.channel.send("dont spam links!") await client.process_commands(message) @visual island

[slate swan]

if message content in tuple

your saying if tuple in message content

its like doing py if [python discord\'s members] in Mr.Katsaa:

[visual island]

no they want to see if a string in the content

[tawdry perch]

aha thx!

[slate swan]

yup

[slate swan]

you can either use any with comprehension or multiple or statements

if list in "str":

is what your doing

[visual island]

any() is the best

[valid barn]

what does this error mean and how can i fix it?

@client.command()
async def buy(ctx, itemm):
  await register(ctx.author)
  users = await get_bank_data()
  bal = users[str(ctx.author.id)]["balance"]

  for i in range(len(shopp)):
    if itemm.lower() in shop[i]:
      item = shop[i]
      break

[visual island]

shop is a command

[slate swan]

you have a command named users , or shop

oh users is defined , so its shop

[slate swan]

and indentation isnt correct

its correct , but too less spaces used

[visual island]

it is correct isn't it

[slate swan]

mhmm

but is it following pep8?

[slate swan]

so like this py anti_add = 'on' @client.event async def on_message(message): global anti_add if message.content.lower in ('www','https','.com','link','xyz','www.','.link','.gr')(): if anti_add == 'on': await message.delete() await message.channel.send("dont spam links!") await client.process_commands(message)

?

[valid barn]

i think its how i pasted it

[sullen shoal]

why is it itemm instead of item are you doing some global shit

[whole sparrow]

how does one add the commands of a discord bot into the / commands

[slate swan]

just do message content no need for lower

[visual island]

wait lemme take a look

[slate swan]

well slash command is not a think in og discord.py you gotta use some forks

[visual island]

!PEP 8

[unkempt canyon]

**PEP 8 - Style Guide for Python Code**

Link

Status

Active

Created

05-Jul-2001

Type

Process

[whole sparrow]

oh what really?

[sullen shoal]

it aint

[slate swan]

i dont think its following

[sullen shoal]

it is supposed to be 4 spaces

but thats 2

[slate swan]

yep

[slate swan]

yea the library is no longer maintaned

[visual island]

Use 4 spaces per indentation level.

yea

[slate swan]

has been months

yup

[whole sparrow]

bruh

[quaint epoch]

I have a question

[slate swan]

tuple' object is not callable

!pypi disnake is what i'd suggest or other forks like nextcord / pycord etc

[unkempt canyon]

disnake v2.2.2

A Python wrapper for the Discord API

[whole sparrow]

thats acc really sad i didnt know that

[slate swan]

you cant call the tuple

[slate swan]

uhh what can i do

[slate swan]

if  message.content in ('www','https','.com','link','xyz','www.','.link','.gr'):

[quaint epoch]

in a command if i use py await asyncio.sleep(10) will it wait 10 seconds but still asynchrnously run the command?

[whole sparrow]

ill take a look at it ty for telling me

[slate swan]

https://gist.github.com/Rapptz/4a2f62751b9600a31a0d3c78100287f1

[slate swan]

correct

[quaint epoch]

nice! So i could mute a user for 15 minutes, and mute another user meanwhile!

[slate swan]

not quite

as when the command is invoked the time restarts

youll need a db to store the time

[sullen shoal]

not really

[quaint epoch]

okay

[visual island]

no, it will create a different object

[quaint epoch]

wait im confused

[visual island]

a different task

[slate swan]

explain?

[visual island]

mb

[whole sparrow]

damn thats acc really painful, hes the sole reason why im good in python in the first place

[sullen shoal]

it will call the function every time someone invokes the command

[whole sparrow]

rip

[slate swan]

yah?

[sullen shoal]

the other function's session will still be running

[quaint epoch]

so i don't need to store the time i a dt base?

[sullen shoal]

that's what async is

you do not tbh

[quaint epoch]

nice so no dtbase, much easier

[slate swan]

then how?

but , if your bot restarts , it wont continue with the function's older session.

thats why you need a db

[sullen shoal]

python handles all that, it will wait 15 minutes then remove it but meanwhile the script will be running fine

[quaint epoch]

obvi, but will it create a new session for the async command if the bot doesn't restart?

[sullen shoal]

you can call the function again

[slate swan]

yes but as sarthak said it isnt a great way

[slate swan]

yea sure

[quaint epoch]

k, because this is just a small project anyway

[slate swan]

imagine the person getting muted and never unmuted xd

[sullen shoal]

yea it isn't, just tryna correct what you said

[sullen shoal]

xd

[slate swan]

i suppose hes trying to make a func that will add a role sleep with asyncio and then remove it

[quaint epoch]

how you know?

[slate swan]

because its just 15 minutes

[slate swan]

i know everything

jk

[quaint epoch]

sussy baka, anyway thnx!

[slate swan]

Your welcome lol

[whole sparrow]

is pycord one of the best maintained forks of discord.py?

[gaunt ice]

yes

[slate swan]

ig you can say that

[whole sparrow]

coolio, ty for letting me know

idk any other forks thats why

[slate swan]

wouldnt say best but it is a good fork

[slate swan]

disnake is great

[whole sparrow]

oh alrighty

[slate swan]

!pypi disnake

[unkempt canyon]

disnake v2.2.2

A Python wrapper for the Discord API

[whole sparrow]

coolio ill go have a look at both of them

ty for letting me know

[slate swan]

has buttons and slash command and same syntax

[quaint epoch]

what are the benefits of disnake/pycord vs discord.py?

[manic wing]

slash commands

[slate swan]

np

[sullen shoal]

slash commands and maybe faster implementation of new stuff if using disnake

[quaint epoch]

oh

is discord.py and disnake very similar, because i don't want to rewrite 1010 lines of code.

[sullen shoal]

change the imports, you're good to go

[quaint epoch]

nice

[slate swan]

just change discord to disnake

its pretty easy

[quaint epoch]

k

[slate swan]

and most ides have a find and replace which makes it easier

[sullen shoal]

even notepad

[slate swan]

or just import disnake as discord lol

[slate swan]

epic moment

 await ctx.send("A", components=[Button(style=ButtonStyle.URL, label="Steam", url="url1",), Button(style=ButtonStyle.URL, label='Paypal', url='url2')])
    interaction = await bot.wait_for(
        "button_click", check=lambda inter: inter.custom_id == "button1" "button2"
    )
    await interaction.send(content="Button Clicked")```
the buttons are horizontol how do I make it vertical?

[quaint epoch]

unlimited big brain

[slate swan]

afaik you cant

[sullen shoal]

not sure if you can do that without having 5 buttons on each row though

also what lib are you using

[slate swan]

just a sm0L doubt , is disnake's old method of making slash command deprecated ? or both new and old methods work

[slate swan]

discord components

[quick gust]

action rows

[sullen shoal]

idk then, use some forks (discord.py 2.0.x will have everything except slash cmds)

[slate swan]

far from it

disnake however, yes

[quaint epoch]

what's the best discord.py fork i could alternatively?

[quick gust]

disnake

[slate swan]

disnake

[whole sparrow]

yeah im looking at disnake its looking great

[quaint epoch]

nice im doing that then

[full valley]

not pycord?

[quick gust]

no

[full valley]

whys that?

[slate swan]

the only thing pycord does better than disnake is the advertising, all they got is popularity and shit code

[full valley]

lmao

[slate swan]

kraots always on the go :^)

[quick gust]

take a chill pill xD

[slate swan]

i am chill wdym 👁️

[sullen shoal]

i heard they use converters to even typehint args as int, is that true

[slate swan]

never used pycord , so cant say

[sullen shoal]

they did unnecessary shitty changes to imports thats for sure

pycord.Bot lol

[west shuttle]

Im trying to do thanks system:

thanks = await self.db.execute("SELECT thanks FROM thxcounter WHERE user_id = ?", (member.id,))
await self.db.execute("INSERT INTO thxcounter (thanks, user_id, guild_id) VALUES (?, ?, ?)", (thanks + 1, ctx.member.id, ctx.guild.id))

Its giving me this error:

discord.ext.commands.errors.CommandInvokeError: Command raised an exception: TypeError: unsupported operand type(s) for +: 'Cursor' and 'int'

[full valley]

Well one shit thing with pycord is that you cant have multiple of the same named cogs at the same time

[sullen shoal]

discord.py was an api wrapper of the entire discord api
commands is just a command handler for bots it should have remained as an extension

[quick gust]

😂

[slate swan]

thanks is your Cursor object , and you cant add 1 to it

[west shuttle]

So how i can add one?

[slate swan]

you can add ints only with ints

[pulsar moth]

Hello guy how are you ?

I'm learning to develop discord bot in python but I wonder

how Can I make the bot handle multiple servers ?

[west shuttle]

Example?

[sullen shoal]

use some api wrapper for the discord api

they handle all the sharding

[visual island]

Select statements need to be ferched

[west shuttle]

How do i ferched the statementa

[slate swan]

can anyone tell how to fix dat

[sullen shoal]

!d discord.Guild.kick

[unkempt canyon]

discord.Guild.kick

await kick(user, *, reason=None)```
This function is a [*coroutine*](https://docs.python.org/3/library/asyncio-task.html#coroutine).

Kicks a user from the guild.

The user must meet the [`abc.Snowflake`](https://discordpy.readthedocs.io/en/master/api.html#discord.abc.Snowflake "discord.abc.Snowflake") abc.

You must have the [`kick_members`](https://discordpy.readthedocs.io/en/master/api.html#discord.Permissions.kick_members "discord.Permissions.kick_members") permission to do this.

[sullen shoal]

not discord.ext.commands.Bot.kick

[slate swan]

member.kick

[proven osprey]

i want to create a text channel only for one user, like only one guy will see this channel. how to do this? will be very greatful!

[visual island]

self.cursor.fetchall() replace self.cursor with the cursor object

[pulsar moth]

hmm what do you mean ?

[visual island]

or fetchone

[slate swan]

elaborate

[slate swan]

...

[sullen shoal]

use discord.py but if you're looking for slash command implementation, use forks of it, disnake as an example

[boreal ravine]

looking at r. danny's source code, what type of object is rows?

[slate swan]

your trying to kick a member which you have a arg as a member obj so use it

[pulsar moth]

ok so it's not possible to handle multiple discord server with discord.py ?

[tawdry perch]

Pycord has advertising?

[sullen shoal]

the definition is above the marking, check what db.fetch returns

[pulsar moth]

I mean, my problem is , if an admin want to modify the prefix of the bot

[sullen shoal]

¯\_(ツ)_/¯

[slate swan]

ok-

[boreal ravine]

How would I? ok

[velvet tinsel]

Hey myxi

[pulsar moth]

I dont want it modify for ALL servers

[slate swan]

well you make a command for it

[slate swan]

yes, they did the marketing better which got them more popularity, they aren't popular because of their code, they're just popular because of that yt guy

[velvet tinsel]

Hi carrot

[pulsar moth]

wait the end haha

[velvet tinsel]

Okimii

Cyberweapon

[slate swan]

if people were to actually choose based on code, pycord would be at rock bottom

[tawdry perch]

I never seen people advertising packages

[slate swan]

[pulsar moth]

I want the bot be able to have different "setting" on different server

[velvet tinsel]

Do you use disnake 🤔

[sullen shoal]

github has some feature, hold the ctrl key then click on it, then it should pop the source code to that if its type hinted properly

[slate swan]

yes

[velvet tinsel]

Ok

[sullen shoal]

otherwise clone it locally and use your ide's features

[velvet tinsel]

Wtf is that profile

[pulsar moth]

maybe on 1 server the admin want the bot to write in a B channel , but not on another

[sullen shoal]

?

[velvet tinsel]

What’s the problem

😳

[sullen shoal]

:/

[velvet tinsel]

Or is there no problem

Meh
Ok

[sullen shoal]

there probably isnt

[velvet tinsel]

Ok

GitHub copilot

[sullen shoal]

another way would be to just replace github.com to github.dev, it will open the thing in web version of vscode

where you could like hold the ctrl key and click on the name and see what it returns

[velvet tinsel]

How does copilot work

Lmao

[sullen shoal]

it basically is trained with lots of code from stack overflow and stuff idk much about it tho

also not the right channel

[velvet tinsel]

Shit

Ok

Maybe it can code discord js for me

[quaint epoch]

So, when i try to log a message on the console it can't log dm's okay so i added a try/excepts blocks to and the except block contains a lot of errors, and the attributeerror but it still raises an attribute error because the dm guild has no id, so it raised an error instead of printing out 'log error', why?!

It doesn't log "log error" instead it raises an error, it just doesn't work

[quaint epoch]

It doesn't pose a big threat, it's just weird

[cobalt jacinth]

does printing to console slows down the bot ?

like when two people use commands same moment

[quaint epoch]

no

[cobalt jacinth]

the console can only print one command output

[quaint epoch]

there aren't enough ppl in my server lol

[sullen shoal]

or checks if the first value is None, use tuple

[boreal ravine]

printing something is like the lightest shit to do in python

[sullen shoal]

except (exc1, exc2):```

[cobalt jacinth]

two things cant print same time

imagine 7 people using same time

[quaint epoch]

no, it just raises an attribute error when the except block should be stopping it from raising an attribute error

That's the problem

[sullen shoal]

the problem is you're not supposed to use or keyword there

[west shuttle]

TypeError: can only concatenate list (not "int") to list

[cobalt jacinth]

what u think

[quaint epoch]

oh

[sullen shoal]

!e print(None or "it should print this")

[unkempt canyon]

@sullen shoal :white_check_mark: Your eval job has completed with return code 0.

it should print this

[sullen shoal]

thats the job of or

[cobalt jacinth]

if 100 people use command same time

[sullen shoal]

use tuple.

[sullen shoal]

like that.

[cobalt jacinth]

console cant print all

it must wait

i am saying because i noticed my bot pausing to print the commands ran simulatenosly

[quaint epoch]

okay got it i think

[sullen shoal]

any falsy value, not just None
my bad

False or None basically

!e print(False or None or "its gonna print this")

[unkempt canyon]

@sullen shoal :white_check_mark: Your eval job has completed with return code 0.

its gonna print this

[sullen shoal]

!e
print("a string is truthy.", bool("str"))
print("however an empty one isnt.", bool(""))

[unkempt canyon]

@sullen shoal :white_check_mark: Your eval job has completed with return code 0.

001 | a string is truthy. True
002 | however an empty one isnt. False

[west shuttle]

@sullen shoal can u help me?

[sullen shoal]

with?

[west shuttle]

New code:

thank = await self.db.execute("SELECT thanks FROM thxcounter WHERE user_id = ?", (member.id,))
thanks = await thank.fetchall()
await self.db.execute("INSERT INTO thxcounter (thanks, user_id, guild_id) VALUES (?, ?, ?)", (thanks + 1, ctx.member.id, ctx.guild.id))

Error: TypeError: can only concatenate list (not "int") to list

[sullen shoal]

which line is the error from, whats the content of it

the line number is included in the traceback

[west shuttle]

This:

await self.db.execute("INSERT INTO thxcounter (thanks, user_id, guild_id) VALUES (?, ?, ?)", (thanks + 1, ctx.member.id, ctx.guild.id))
TypeError: can only concatenate list (not "int") to list

[sullen shoal]

looks like thanks is a list?

[slate swan]

can anybody give me command ideas im kinda bored

[slate swan]

done with learning sql yet lol?

[west shuttle]

How bruh

[sullen shoal]

print the type of it

!d type

[unkempt canyon]

type

class type(object)``````py

class type(name, bases, dict, **kwds)```
With one argument, return the type of an *object*. The return value is a type object and generally the same object as returned by [`object.__class__`](https://docs.python.org/3/library/stdtypes.html#instance.__class__ "instance.__class__").

The [`isinstance()`](https://docs.python.org/3/library/functions.html#isinstance "isinstance") built-in function is recommended for testing the type of an object, because it takes subclasses into account.

Similar names: term.type, numpy.type

[west shuttle]

wdym?

[sullen shoal]

print(type(thanks))

do it in the code before the line that errors

[slate swan]

not really i just found some parts complicated so i stopped so i can take it in i just work like that

i like learning things slowly

[west shuttle]

<class 'list'>

Uh yea

[sullen shoal]

there it is, you cant basically add int with a list

[slate swan]

if you go for learning basic sql first , and then a library like sqlite or mysql , it would be lotta easier

[slate swan]

thats what im doing lmfao

[sullen shoal]

!e
[] + 1

[unkempt canyon]

@sullen shoal :x: Your eval job has completed with return code 1.

001 | Traceback (most recent call last):
002 |   File "<string>", line 1, in <module>
003 | TypeError: can only concatenate list (not "int") to list

[slate swan]

im learning sqls syntax so i can go to sqlite3 and then jump to postgresql

[upbeat otter]

Make a command that asks the user about their biodata and deploy the data on the dark web

[west shuttle]

How to fix?

[west shuttle]

lmao

[slate swan]

aha cool then!

[sullen shoal]

slice the list to the item you need

[slate swan]

yep

[west shuttle]

What i need to change in the code?

[slate swan]

excuse me?

[sullen shoal]

idk thats your project not mine, you gotta use your thinking for that

[upbeat otter]

excused

[upbeat otter]

the erroring code

[sullen shoal]

!e
l = [1,2,3,4,5]
print(l[2])

[unkempt canyon]

@sullen shoal :white_check_mark: Your eval job has completed with return code 0.

3

[sullen shoal]

2 is the index, not to be confused

[sick birch]

No way

[slate swan]

@slate swan im learning from sqlbolt and when i learn parts and find it a bit complicated i stop so i can understand it and then i start from the start and work my way more then the time before

[upbeat otter]

At Least someone here is humorous

[slate swan]

pretty good

[slate swan]

oh is that some tutorial or something?

i learned sql in my school lol

[slate swan]

yeah its a tutorial and exercises for sql

[sick birch]

🗿

[upbeat otter]

https://cdn.discordapp.com/emojis/853319051697979482.gif?size=64

[slate swan]

lol here it is -> https://sqlbolt.com/

[devout iris]

i want to make a command and it should be "when bot has logined, bot will send message to where i want"

[sullen shoal]

k

[sick birch]

on_ready?

[devout iris]

yep

how can i make

[sick birch]

uh

[slate swan]

use on_ready event ,
Bot.get_channel to get the channel and use .send

[sick birch]

It’s really simple

[slate swan]

!d discord.on_ready

[unkempt canyon]

discord.on\_ready

discord.on_ready()```
Called when the client is done preparing the data received from Discord. Usually after login is successful and the [`Client.guilds`](https://discordpy.readthedocs.io/en/master/api.html#discord.Client.guilds "discord.Client.guilds") and co. are filled up.

Warning

This function is not guaranteed to be the first event called. Likewise, this function is **not** guaranteed to only be called once. This library implements reconnection logic and thus will end up calling this event whenever a RESUME request fails.

[upbeat otter]

smh

[sick birch]

The whole thing is 3 lines of code

[slate swan]

!d discord.ext.commands.Bot.get_channel

[unkempt canyon]

discord.ext.commands.Bot.get\_channel

get_channel(id, /)```
Returns a channel or thread with the given ID.

[slate swan]

can make it less

[sick birch]

Doubt

[slate swan]

i think

[devout iris]

i know it but idk how can i set channel with id idk

[slate swan]

wait nvm

can do that in 2 lines . no less

[sullen shoal]

semicolon supremacy

[sick birch]

The decorator and function declarator is 2

[slate swan]

since 1 has to be the decorator surely

[sullen shoal]

exec

[slate swan]

@bot.event
async def on_ready():
    a = await bot.get_channel(int).send("msg")

what i would do

no even need for a var

[upbeat otter]

2

[slate swan]

    @Cog.listener('on_ready')
    async def send_message(self) : await self.bot.get_channel().send('blah')```ez

@maiden fable wont work mr

[sullen shoal]

!e
def func(f): f()

exec("@func\ndef f():print('hello')")

[unkempt canyon]

@sullen shoal :white_check_mark: Your eval job has completed with return code 0.

hello

[sullen shoal]

hehe

[slate swan]

good one

[maiden fable]

ik that is why I deleted my message (:

[slate swan]

LMFAO await was for .send because get is async

[upbeat otter]

@bot.event
async def on_ready(): return await bot.fetch_channel(int).send("msg")

[maiden fable]

yea saw it later

[slate swan]

lol

[maiden fable]

won't work tbh (or it will? probably not)

[upbeat otter]

it will

[slate swan]

it will

[valid barn]

@client.command()
async def buy(ctx, itemm):
  await register(ctx.author)
  users = await get_bank_data()
  bal = users[str(ctx.author.id)]["balance"]
  item = {}
  for i in range(len(shopp)):
    if itemm.lower() in shopp[i]:
      item = shopp[i]
      break

  name = item["name"]```
why?

[upbeat otter]

I am not dumb enough

lol