!d discord.Guild
#discord-bots
slate swan
unkempt canyonBOT
slate swan
well try updating the library
pastel solar
Also @slate swan. Do you know how to define guild in the on_ready function? I would like to use the variables guild.name and guild.id
slate swan
Also <@456226577798135808>. Do you know how to define guild in the `on_ready` fu...
!d discord.Client.get_guild
unkempt canyonBOT
slate swan
you would need atleast the ID to do this
slate swan
well try updating the library
pip install -U py-cord==2.0.0rc1
if that doesnt work, use git to install their master branch
pastel solar
`pip install -U py-cord==2.0.0rc1`
That solved it thanks!
pliant pagoda
so like?
#test
@bot.command()
async def test(message):
user = message.author
role1 = discord.Guild.get_role(993231458846122014)
await user.add_roles(role1)
I appreciate your patience with meπ
slate swan
message.guild.get_role
btw, its a Context object, not a Message, so you can call it context or ctx, not message.
this avoids confusion for both you, and the people who are trying to help you
pliant pagoda
i see, thank you and apologies if i've been 'difficult'π
scarlet aurora
in my bot, I'm trying to grab data from the cache but I do it too fast, how do I make it wait
await bot.wait_until_ready()```
iron sorrel
guys I'm asking for a friend,
did they remove the ability to selfbots finally? thank god no more abusers
maiden fable
Yea...
iron sorrel
when did they? and can i read the patch notes? my friend is really interested
not me pff never break tos
maiden fable
You can tell your friend to ask here instead of asking some other friend to ask here
paper sluice
guys __***I'm asking for a friend,***__
did they remove the ability to selfbots...
:sus:
iron sorrel
oh no thats bad tho
like eh why havent discord banned the WS API for user accs if discord for users on the web works with web requests?
pliant gulch
like eh why havent discord banned the WS API for user accs if discord for users ...
Well you have things like changing presence, which is a gateway command
Also Iβm gonna assume itβs the same ordeal for stuff like receiving messages, as a websocket saves more bandwidth than using just web requests
iron sorrel
am i sitting on a websocket connection rn then?
pliant gulch
am i sitting on a websocket connection rn then?
I think so, but to be fair I cannot see the source as Iβm just a regular user
Most chat apps now a day use websockets, thatβs pretty much the golden standard
So itβs very safe to say discord does too
Itβll be super ineffective to use web requests for receiving messages, etc
iron sorrel
discord does use it for bots, i know that but when you post messages on the web discord it sends web requests, iirc
pliant gulch
Yes, but receiving is my point
Itβll be βhardβ to know when to receive a message with just web requests
Thatβs when websockets come into play
Since they are bi-direction to discord and to the user
iron sorrel
Itβll be βhardβ to know when to receive a message with just web requests
ah cuz discord is a client
pliant gulch
Mhm
cloud beacon
def check(message):
return message.channel == ctx.channel and message.author == ctx.author
link = await self.client.wait_for(event="message",check=check)
await request(item,value,link.content)```
anyone know why link.content might be empty? all other attributes work fine, but i cant get the content for some reason
torn sail
```py
def check(message):
return message.channel == ctx.channel and message.au...
Message content intents
!d discord.Intents.message_content
unkempt canyonBOT
flat solstice
My persistent view code is this```py
class PersistentView(View):
def init(self):
super().init(timeout=None)
self.add_item(AlphaDropdown(custom_id="persistent_dropdown"))
for link in links:
self.add_item(Button(label=link.label, url=link.url))
@button(label="I still need help!", style=ButtonStyle.blurple,, custom_id="Further-Support",, emoji="π©", row=3,)
async def green(self, interaction: Interaction, button: Button):
role = await interaction.guild.get_role(self.config.further_support_role)
if role is None:
log.error( f"Could not find role for further support with id: '{self.config.further_support_role}'")
return
try:
await interaction.author.add_role(role)
except HTTPException:
log.error( f"Could not add role for further support with id: '{self.config.further_support_role}' to user: '{interaction.author}' ('{interaction.author.id}')")
return
await interaction.response.send_message(f"You have been given the {role.mention} role to gain access to the further support channel.", ephemeral=True,)
silent portal
Hi, how can I get the Moderator who banned a user in the on_member_ban event?
I tried this but it's kinda bugging when Raids happen and multiple Moderators are Banning more Users within a short period of time
@bot.event
async def on_member_ban(guild, member):
logs = await guild.audit_logs(limit=1, action=discord.AuditLogAction.ban).flatten()
logs = logs[0]
user = logs.user
if logs.target == member:
# Do some things...
south needle
Hi, how can I get the Moderator who banned a user in the `on_member_ban` event?
...
That code should work as logs.user gets the user who banned the member. Are you saying that with multiple bans it starts to bug out?
silent portal
That code should work as `logs.user` gets the user who banned the member. Are yo...
Yes. Sometimes the server gets raided with like 50+ Bot Accounts and the moderators ban them very quickly
south needle
The bot should be as fast as them banning the bots but maybe it's reading the audit log to slow? I don't see a issue with the code.
desert heart
It's just the asynchronous nature of things.
slender perch
how would i make a website for managing a discord bot?
old gate
Hey everybody I'm new around here but have a question how do i pull in real time data with my bot. I am building an anti-scam bot. That reports scammers to the proper authorities but using the api to pull and post that data's challenging. Its an amazing project to have save people from being terrorized. Sorry if my grammar sucks lol
slate swan
guys __***I'm asking for a friend,***__
did they remove the ability to selfbots...
lol. no
they still exist
ik a website people use (not gonna say obv) but they still work just not how they use to be
slate swan
when did they? and can i read the patch notes? __***my friend***__ is really int...
sounds like you are
slate swan
Not that I mean you should selfbot, but you can
didnt see this lmao. i think (may be wrong) because i dont tinker with them their might be free ones but ik of one thats paid and quite good
i mean we all had to of use a self bot once before
slate swan
can someone help me making a easy link button you can just add using await ctx.send like add the button there using rapptz or anything
ill pay
slate swan
guys __***I'm asking for a friend,***__
did they remove the ability to selfbots...
damn
slate swan
can someone help me making a easy link button you can just add using ``await ctx...
dm me
south needle
!d discord.Guild.vanity_invite
unkempt canyonBOT
silent portal
is there a way to check if a message has a discord invite?
south needle
is there a way to check if a message has a discord invite?
on_message event
silent portal
`on_message` event
Then check if the message contains "discordx. gg/"
south needle
yeah exactly
silent portal
?
ok ty
and can I check if the invite sent is the invite to the server the message has been sent to?
south needle
I don't know if you can check what server the invite link is from
silent portal
okok ty
unkempt canyonBOT
south needle
guild.vanity_invite() returns the vanity with the discord.gg is there a way to remove that and just get the vanity by itself?
fading marlin
strip it off?
slate swan
just replace/strip discord.gg from the string
south needle
ahh forgot about strip() for a second
robust fulcrum
class botclass(commands.Bot):
def __init__(self):
super().__init__(command_prefix="@",help_command=None,intents=discord.Intents.all())
async def setup_hook(self):
async with aiosqlite.connect("prefixes.db") as self.connect:
async with self.connect.cursor() as cursor:
await cursor.execute('CREATE TABLE IF NOT EXISTS prefixtable(guild_id INTEGER prefix TEXT)')
await self.connect.commit()
bot = botclass()
Guys where do I need to define the setup hook ?
slate swan
Hey everybody I'm new around here but have a question how do i pull in real time...
sounds amazing
what kind of real time data are we talking about?
robust fulcrum
```py
class botclass(commands.Bot):
def __init__(self):
super().__in...
At this
slate swan
```py
class botclass(commands.Bot):
def __init__(self):
super().__in...
you already defined it
nice cm logic
robust fulcrum
Oh k
slate swan
it will run automatically now
robust fulcrum
Is code correct?
slate swan
sql query is wrong, should have a comma in between of fields
robust fulcrum
Oh k
slate swan
I gotta continue studying bye
robust fulcrum
class botclass(commands.Bot):
def __init__(self):
super().__init__(command_prefix="@",help_command=None,intents=discord.Intents.all())
async def setup_hook(self):
async with aiosqlite.connect("prefixes.db") as self.connect:
async with self.connect.cursor() as cursor:
await cursor.execute('CREATE TABLE IF NOT EXISTS prefixtable(guild_id INTEGER ,prefix TEXT)')
await self.connect.commit()
Bye
robust fulcrum
I'll do in class
junior forum
from discord_webhook import DiscordWebhook, DiscordEmbed
webhook_enable = os.getenv("webhookVC_enabled")
webhookurl = os.getenv("webhook")
ping = os.getenv("webhook_ping")
if webhook_enable == "True":
webhook = DiscordWebhook(url=webhookurl, content=f"{ping}")
while True:
try:
scraper = cloudscraper.create_scraper()
r = scraper.get('https://rest-bf.blox.land/chat/history').json()
check = r['rain']
if check['active'] == True:
grabprize = str(check['prize'])[:-2]
prize = (format(int(grabprize),","))
host = check['host']
getduration = check['duration']
convert = (getduration/(1000*60))%60
duration = (int(convert))
waiting = (convert*60+10)
sent = time.strftime("%d/%m/%Y %H:%M:%S", time.localtime(int(time.time())))
print(f"Bloxflip Rain!\nRain amount: {prize} R$\nExpiration: {duration} minutes\nHost: {host}\nTimestamp: {sent}\n\n")
if webhook_enable == "True":
userid = requests.get(f"https://api.roblox.com/users/get-by-username?username={host}").json()['Id']
thumburl = (f"https://www.roblox.com/headshot-thumbnail/image?userId={userid}&height=50&width=50&format=png")
embed = DiscordEmbed(title=f"{host} is hosting a chat rain!", url="https://bloxflip.com", color=0xFFC800)
embed.add_embed_field(name="Rain Amount", value=f"{prize} R$")
embed.add_embed_field(name="Expiration", value=f"{duration} minutes")
embed.add_embed_field(name="Host", value=f"[{host}](https://www.roblox.com/users/{userid}/profile)")
embed.set_timestamp()
embed.set_thumbnail(url=thumburl)
webhook.add_embed(embed)
webhook.execute
webhook.remove_embed(0)
time.sleep(waiting)
elif check['active'] == False:
time.sleep(30)
except Exception as e:
print(e)
time.sleep(30)β
id = self.message.id
Is it correct?
junior forum
It doesn't post the webhook and no errors either
robust fulcrum
It doesn't post the webhook and no errors either
Can I suggest one thing to you?
junior forum
Ye
robust fulcrum
Use ```py
junior forum
I did
robust fulcrum
To make it python code block
junior forum
I'm on mobile so is tricky rn
robust fulcrum
```import cloudscraper, time, requests, os
from discord_webhook import DiscordWe...
It not looks
Me also on mobile
junior forum
import cloudscraper, time, requests, os
from discord_webhook import DiscordWebhook, DiscordEmbed
webhook_enable = os.getenv("webhook_enabled")
webhookurl = os.getenv("webhook")
ping = os.getenv("webhook_ping")
if webhook_enable == "True":
webhook = DiscordWebhook(url=webhookurl, content=f"{ping}")
while True:
try:
scraper = cloudscraper.create_scraper()
r = scraper.get('https://rest-bf.blox.land/chat/history').json()
check = r['rain']
if check['active'] == True:
grabprize = str(check['prize'])[:-2]
prize = (format(int(grabprize),","))
host = check['host']
getduration = check['duration']
convert = (getduration/(1000*60))%60
duration = (int(convert))
waiting = (convert*60+10)
sent = time.strftime("%d/%m/%Y %H:%M:%S", time.localtime(int(time.time())))
print(f"Bloxflip Rain!\nRain amount: {prize} R$\nExpiration: {duration} minutes\nHost: {host}\nTimestamp: {sent}\n\n")
if webhook_enable == "True":
userid = requests.get(f"https://api.roblox.com/users/get-by-username?username={host}").json()['Id']
thumburl = (f"https://www.roblox.com/headshot-thumbnail/image?userId={userid}&height=50&width=50&format=png")
embed = DiscordEmbed(title=f"{host} is hosting a chat rain!", url="https://bloxflip.com", color=0xFFC800)
embed.add_embed_field(name="Rain Amount", value=f"{prize} R$")
embed.add_embed_field(name="Expiration", value=f"{duration} minutes")
embed.add_embed_field(name="Host", value=f"[{host}](https://www.roblox.com/users/{userid}/profile)")
embed.set_timestamp()
embed.set_thumbnail(url=thumburl)
webhook.add_embed(embed)
requests.post(webhook.execute)
webhook.remove_embed(0)
time.sleep(waiting)
elif check['active'] == False:
time.sleep(30)
except Exception as e:
print(e)
time.sleep(30)β
Fine now ? @robust fulcrum
robust fulcrum
Me noob at python
swift pumice
@robust fulcrum From where are you if i could ask?
You dont need to answer the question if you dont want to
robust fulcrum
<@893363878728192041> From where are you if i could ask?
Place?
swift pumice
no country
robust fulcrum
India
swift pumice
Oh okay
slate swan
```py
import cloudscraper, time, requests, os
from discord_webhook import Discor...
why dont you use discord.py
also, what the issue?
slate swan
```py
id = self.message.id
```
Is it correct?
N O
slate swan
why dont you use discord.py
ew
slate swan
ew
sleep
I'd use hikari π
ew
imagine using a library just to make POST requests
use requests π
I'd just use js in that case
requests bad bad
httpx best
no
left idol
is there a limit to how many choices i have in an autofill?
slate swan
XMLHttpRequest better π
slate swan
is there a limit to how many choices i have in an autofill?
autofill as in? autocomplete or display choices?
depends on wym by autofill
slate swan
XMLHttpRequest better π
cursed
left idol
autocomplete?
slate swan
js β€οΈ
left idol
it should be autocomplete
slate swan
it should be autocomplete
you can have as many (but only 25 show up for suggestions)
left idol
yea autocomplete
slate swan
autocomplete?
there;s a limit of 25 suggestions in autocompletes
js users try to use 109 of them
left idol
so it displays 25 but i can always just input the rest?
like it shows the first 25 options
shrewd apex
yep
slate swan
it doesnt show up magically, you gotta provide a logic to your autocomplete for that.
left idol
what do you mean
shrewd apex
a list comp generally
left idol
ye i have all my options in a list
slate swan
what do you mean
what library are you using
left idol
im using pycord
slate swan
js users try to use 109 of them
imagine being so rude
left idol
async def autofill(ctx: discord.AutocompleteContext, choices):
return [auto for auto in choices]
i referred to that when i wrote the above function
it worked for something where i had 32 options but i just wanted to know if i had something like 300 it would still work
slate swan
use [:25] to get the first 25 elements in the list then...
shrewd apex
it would but u can show only 25
slate swan
imagine being so rude
ik, thanks
left idol
it would but u can show only 25
yeah im ok with that, i just wanted to know if i did have it setup that if i started typing something out of the 25 then it would still work
i just didn't know if there was a limit for that part
shrewd apex
mostly 25 is limit 25 button 25 select option 25 reactions
slate swan
use [:25] to get the first 25 elements in the list then...
;-;
left idol
are buttons 5x5 grid?
slate swan
basic python.
left idol
or can i have 2 rows of 10 or something
shrewd apex
u cant select like that it depends on button size
slate swan
you cant have more than 25 items in a view, a select menu is treated as 5items btw
shrewd apex
np
slate swan
discord is so obsessed with 25 limits
slate swan
yeah, and next day see dank memer with 1000 buttons
slate swan
ik, thanks
ruder
vale wing
Literal football field
slate swan
indeed lmao
slate swan
How do I DM a user after the did a command?
!d discord.User.send
unkempt canyonBOT
slate swan
!d discord.User.send
So I would do
await ctx.user.send("this is a dm")
dming the author of the command?
slate swan
dming the author of the command?
yes
slate swan
ctx.author.send
ok thanks
slate swan
anyone know what i did wrong? ik i def did sum wrong
you have to pass in iterable to random.choice
ah okay is that all?
should prob try it first nvm
man literally entered iterable there ;-;
thought thats what they meant π
slate swan
why
just have a random.choice on the 2 words and send the embed, theyre both the same, just pick the random word
since youre sending a file as well save it as a var
vale wing
!e
import random
def coinflip():
print("Heads" if random.randint(0, 1) else "Tails")
for i in range(5):
coinflip()```Love internet here
slate swan
!e
```py
import random
def coinflip():
print("Heads" if random.randint(0, 1)...
you can just have random.choice????
slate swan
πΏ
slate swan
what's self.message?
robust fulcrum
In a class
robust fulcrum
what's self.message?
Means how can I get guild I'd of message
slate swan
message.guild.id dude
robust fulcrum
Oh k
robust fulcrum
message.guild.id dude
You told to use same connection but it shows undefined
slate swan
You told to use same connection but it shows undefined
do you know how classes work?
robust fulcrum
do you know how classes work?
How can I make it work?
vocal snow
Learning OOP before doing this would make things easier
shrewd apex
But how to make that work
(self, message)
robust fulcrum
(self, message)
I mean that cursor is being red line
But Ashley told to use same connection
shrewd apex
u didnt even create a connection u used a context manager ;-;
slate swan
^
shrewd apex
show ur setup hook code
robust fulcrum
class botclass(commands.Bot):
def __init__(self):
super().__init__(command_prefix="@",help_command=None,intents=discord.Intents.all())
async def setup_hook(self):
async with aiosqlite.connect("prefixes.db") as self.connect:
async with self.connect.cursor() as cursor:
await cursor.execute('CREATE TABLE IF NOT EXISTS prefixtable(guild_id INTEGER ,prefix TEXT)')
await self.connect.commit()
async def get_prefix(self,message):
id = message.guild.id
await cursor.execute('')
Is there any defect in it?
shrewd apex
async def setup_hook(self):
async with aiosqlite.connect("prefixes.db") as connect:
self.db = connect # <-- connection to db here
async with connect.cursor() as cursor:
self.cursor = cursor # <-- connection to db cursor here
await self.cursor.execute('CREATE TABLE IF NOT EXISTS prefixtable(guild_id INTEGER ,prefix TEXT)') # <-- refer to cursor as self.cursor
await self.db.commit() # <-- refer to db as self.db
async def get_prefix(self,message):
id = message.guild.id
await self.cursor.execute('')
await self.db.commit()
this should give u a better idea
paper sluice
cannot import app_commands from discord.ext
its discord.app_commands
swift pumice
.
shrewd apex
u can even just use the self.db itself
self.cursor is not that necessary just makes it more convenient
paper sluice
```py
async def setup_hook(self):
async with aiosqlite.connect("prefi...
that wont work, because u r using the context-manager, the connection would close, so they can't use it else where
shrewd apex
that wont work, because u r using the context-manager, the connection would clos...
it was an example i was gonna explain slowly ;-; that wont work in setup hook but if use with bot.start it will
paper sluice
ah ok π
swift pumice
@bot.command()
async def mute(ctx, user: nextcord.Member, time : int):
role1 = ctx.guild.get_role(985475444981764106)
role2 = ctx.guild.get_role(985205310740389918)
#print(ctx.guild.me.top_role > ctx.author.top_role)
if ctx.author.guild_permissions.administrator == True:
await user.remove_roles(role2)
await user.add_roles(role1)
await ctx.send(f'{ctx.member.mention}is now muted')
await asyncio.sleep(time*60)
await user.remove_roles(role1)
await user.add_roles(role2)
else:
await ctx.send("you are not administrator noob.")``` hi guys do you guys know why this isnt working? what i mean by that that it stops working after the 2nd await, like it doesnt send the message nor removes the roleAsher if i not use context manager will Code ewirk?
shrewd apex
async def setup_hook(self):
self.db = aiosqlite.connect("prefixes.db")# <-- connection to db here
self.cursor = await self.db.cursor()# <-- connection to db cursor here
await self.cursor.execute('CREATE TABLE IF NOT EXISTS prefixtable(guild_id INTEGER ,prefix TEXT)') # <-- refer to cursor as self.cursor
await self.db.commit() # <-- refer to db as self.db
async def get_prefix(self,message):
id = message.guild.id
await self.cursor.execute('')
await self.db.commit()
this should work
just as it is if u copy paster
paper sluice
also add this:
async def close(self):
await self.db.close()
super().close()
there may be a bug in self.cursor just run and check i havent used aiosqlite
slate swan
shouldnt be using a single cursor all the time
that ends the point of having cursors in your database
cause sqlite allows you to perform operations with the connection itself
!d sqlite3.Connection.execute
unkempt canyonBOT
swift pumice
dead chat
gleaming heath
No
left vector
...
gleaming heath
replace msg with ctx
left vector
in () or not
gleaming heath
in ()
left vector
@bot.event
async def on_message(ctx):
await ctx.send('hi')
gleaming heath
Ye
left vector
alr now
how do make bot get input from user
acctualy wait i can do that
@bot.event
async def on_message(ctx):
if msg.content.startswith('+cookie'):
how can i make the bot wait for the next users message
acctualy wait
full valley
covert basin
AttributeError: module 'discord.ext.commands' has no attribute 'event
frail notch
Hi there. I found this project which allows to restore users using oauth2 in case of a raid, etc.
https://github.com/gamb2t/discord-restore-bot
I tried contacting the owner but everything is in Korean so I don't understand anything.
I translated the files and made a few modifications but I still need help making it work. Could anyone help me out?
I have put the modified version on a new GitHub repository.
I am able to run the bot.py file but whenever I press verify it doesn't do anything. I'm unsure how to get the access token+user id to add to the database.
https://github.com/vikingww2/oauth2-restore
Can anyone help me? (I'm happy to hop in vc to demonstrate the problem)
left vector
guys how do i i get input from a user
slate swan
guys how do i i get input from a user
!d discord.Client.wait_for
unkempt canyonBOT
left vector
@bot.event
async def on_message(ctx):
if msg.content.startswith('+cookie'):
msg = await client.wait_for("message", check=check)
message = msg.content
like that?
paper sluice
message = msg.content
when you do msg.content = message ( you will get an name error if message is not defined ) but also you overwrite the content attribute
left vector
`message = msg.content`
oh ok thank you
so if i run this
async def on_message(ctx):
if msg.content.startswith('+cookie'):
msg = await client.wait_for("message", check=check)
message = msg.content```and i print message will it print out the message?
robust fulcrum
@shrewd apex
class botclass(commands.Bot):
def __init__(self):
super().__init__(command_prefix="@",help_command=None,intents=discord.Intents.all())
async def setup_hook(self):
self.connect = aiosqlite.connect("prefixes.db")
self.cursor = self.connect.cursor()
await self.cursor.execute('CREATE TABLE IF NOT EXISTS prefixtable(guild_id INTEGER ,prefix TEXT)')
await self.connect.commit()
async def get_prefix(self,message):
id = message.guild.id
await self.cursor.execute('')
await self.connect.commit()
Will it work?
paper sluice
```@bot.event
async def on_message(ctx):
if msg.content.startswith('+cookie'):...
change ctx to msg
left vector
kk
nocturne topaz
how do you get the help menu fields like this?
i cant figure out how to stack it like naruto botto has theirs
robust fulcrum
How can we give bot a prefix?
class botclass(commands.Bot):
def __init__(self):
super().__init__(intents=discord.Intents.all())
async def setup_hook(self):
self.connect = aiosqlite.connect("prefixes.db")
self.cursor = self.connect.cursor()
await self.cursor.execute('CREATE TABLE IF NOT EXISTS prefixtable(guild_id INTEGER ,prefix TEXT)')
await self.connect.commit()
async def get_prefix(self,message):
id = message.guild.id
await self.cursor.execute('SELECT prefix FROM prefixtable WHERE guild_id=?',(id))
prefix = await self.cursor.fetchone()
await self.connect.commit()
return prefix or '@'
#prefix function here
How to give a prefix after define bot?
left vector
slate swan
```py
class botclass(commands.Bot):
def __init__(self):
super().__in...
super().__init__(command_prefix=self.get_prefix)
robust fulcrum
`super().__init__(command_prefix=self.get_prefix)`
I am getting one error
class botclass(commands.Bot):
def __init__(self):
super().__init__(command_prefix=self.get_prefix,intents=discord.Intents.all())
async def setup_hook(self):
self.connect = aiosqlite.connect("prefixes.db")
self.cursor = self.connect.cursor()
await self.cursor.execute('CREATE TABLE IF NOT EXISTS prefixtable(guild_id INTEGER ,prefix TEXT)')
await self.connect.commit()
async def get_prefix(self,message):
id = message.guild.id
await self.cursor.execute('SELECT prefix FROM prefixtable WHERE guild_id=?',(id))
prefix = await self.cursor.fetchone()
await self.connect.commit()
return prefix or '@'
bot = botclass()
Here is code
slate swan
```py
class botclass(commands.Bot):
def __init__(self):
super().__in...
you have to await aiosqlite.connect and self.connect.cursor
robust fulcrum
you have to `await` `aiosqlite.connect` and `self.connect.cursor`
I have to create new connection?
paper sluice
```py
class botclass(commands.Bot):
def __init__(self):
super().__in...
flat case for class names 
slate swan
I have to create new connection?
no the same
robust fulcrum
Oh understood
robust fulcrum
no the same
async def get_prefix(self,message):
id = message.guild.id
self.connect = aiosqlite.connect("prefixes.db")
self.cursor = self.connect.cursor()
await self.cursor.execute('SELECT prefix FROM prefixtable WHERE guild_id=?',(id))
prefix = await self.cursor.fetchone()
await self.connect.commit()
return prefix or '@'
Like this?
slate swan
you have to `await` `aiosqlite.connect` and `self.connect.cursor`
await @robust fulcrum
slate swan
```py
async def get_prefix(self,message):
id = message.guild.id
...
await these, kind sir
robust fulcrum
Oh k
slate swan
ashley sqlite3 classes
robust fulcrum
class botclass(commands.Bot):
def __init__(self):
super().__init__(command_prefix=self.get_prefix,intents=discord.Intents.all())
async def setup_hook(self):
self.connect = await aiosqlite.connect("prefixes.db")
self.cursor = await self.connect.cursor()
await self.cursor.execute('CREATE TABLE IF NOT EXISTS prefixtable(guild_id INTEGER ,prefix TEXT)')
await self.connect.commit()
async def get_prefix(self,message):
id = message.guild.id
self.connect = await aiosqlite.connect("prefixes.db")
self.cursor = await self.connect.cursor()
await self.cursor.execute('SELECT prefix FROM prefixtable WHERE guild_id=?',(id))
prefix = await self.cursor.fetchone()
await self.connect.commit()
return prefix or '@'
bot = botclass()
Now?
slate swan
shouldnt be using a single cursor all the time
also this
you created another connection in the get_prefix function, which you should not be doing.
and don't commit on SELECT etc, commit is meant to be called only when you write something
oh smh
I said to not connect in get_prefix smh
robust fulcrum
I said to not connect in get_prefix smh
async def get_prefix(self,message):
id = message.guild.id
self.cursor = await self.connect.cursor()
await self.cursor.execute('SELECT prefix FROM prefixtable WHERE guild_id=?',(id))
prefix = await self.cursor.fetchone()
await self.connect.commit()
return prefix or '@'
Fine now?
slate swan
nope
or maybe yes, depends on what you want
prefix there is a tuple with a single element and not a string
but that would work anyways
slate swan
```py
async def get_prefix(self,message):
id = message.guild.id
...
await self.cursor.execute('SELECT prefix FROM prefixtable WHERE guild_id=?',(id,))
the placeholder values take a tuple, not an integer
robust fulcrum
await self.cursor.execute('SELECT prefix FROM prefixtable WHERE guild_id=?',(id`...
I got this error
slate swan
show your current code.
robust fulcrum
show your current code.
class botclass(commands.Bot):
def __init__(self):
super().__init__(command_prefix=self.get_prefix,intents=discord.Intents.all())
async def setup_hook(self):
self.connect = await aiosqlite.connect("prefixes.db")
self.cursor = await self.connect.cursor()
await self.cursor.execute('CREATE TABLE IF NOT EXISTS prefixtable(guild_id INTEGER ,prefix TEXT)')
await self.connect.commit()
async def get_prefix(self,message):
id = message.guild.id
self.cursor = await self.connect.cursor()
await self.cursor.execute('SELECT prefix FROM prefixtable WHERE guild_id=?',(id,))
prefix = await self.cursor.fetchone()
await self.connect.commit()
return prefix or '@'
is that all the code you have?
robust fulcrum
is that all the code you have?
No
robust fulcrum
is that all the code you have?
import aiosqlite
import discord
from discord.ext import commands
import asyncio
class botclass(commands.Bot):
def __init__(self):
super().__init__(command_prefix=self.get_prefix,intents=discord.Intents.all())
async def setup_hook(self):
self.connect = await aiosqlite.connect("prefixes.db")
self.cursor = await self.connect.cursor()
await self.cursor.execute('CREATE TABLE IF NOT EXISTS prefixtable(guild_id INTEGER ,prefix TEXT)')
await self.connect.commit()
async def get_prefix(self,message):
id = message.guild.id
self.cursor = await self.connect.cursor()
await self.cursor.execute('SELECT prefix FROM prefixtable WHERE guild_id=?',(id,))
prefix = await self.cursor.fetchone()
await self.connect.commit()
return prefix or '@'
bot = botclass()
@bot.event
async def on_ready():
print("ready")
@bot.command()
async def test(ctx):
await ctx.send("working")
Here is all
slate swan
ight lemme see.
slate swan
```py
import aiosqlite
import discord
from discord.ext import commands
import as...
did you restart the bot?
robust fulcrum
Ye
slate swan
hm lemme try
robust fulcrum
```py
import aiosqlite
import discord
from discord.ext import commands
import as...
I am getting error in it can you help me fix
shrewd apex
self.con = await aiosqlite.connect("prefixes.db") #<-- dont await
self.cursor = await self.con.cursor(
dont await this
robust fulcrum
```py
self.con = await aiosqlite.connect("prefixes.db") #<-- dont await
...
Cursor?
lament mesa
```py
import aiosqlite
import discord
from discord.ext import commands
import as...
dont re-use the cursor
slate swan
!d discord.Client.connect
unkempt canyonBOT
dusky pine
haiiiiiiiiiiiiiiiiiii
slate swan
yeah thats the issue
dusky pine
sarth new pfp
shrewd apex
make it con
dusky pine
name it self.conn ;p
slate swan
sarth new pfp
raven is a hottie
dusky pine
everyone knows self.conn and self.cur is tradition
dusky pine
raven is a hottie
idek who that is but hot
slate swan
why use the same connection throughout the bot
shrewd apex
0-0
slate swan
π
robust fulcrum
idek who that is but hot
π
slate swan
why use the same connection throughout the bot
*cursor
slate swan
idek who that is but hot
dc comics, teen titans
lament mesa
dont re-use the cursor
reusing the same cursor can cause multiple issues
dusky pine
why use the same connection throughout the bot
to help save the environment β€οΈπ
dusky pine
dc comics, teen titans
oh damn... π³
shrewd apex
oh damn... π³
uk who starfire is?
dusky pine
oh yeah that other hottie
robust fulcrum
why use the same connection throughout the bot
shrewd apex
change connection there also
slate swan
change it to self.connection or something
me who used a dictionary for the first time
slate swan
show updated code
robust fulcrum
change connection there also
I changed
class botclass(commands.Bot):
def __init__(self):
super().__init__(command_prefix=self.get_prefix,intents=discord.Intents.all())
async def setup_hook(self):
self.connection = await aiosqlite.connect("prefixes.db")
self.cursor = await self.connection.cursor()
await self.cursor.execute('CREATE TABLE IF NOT EXISTS prefixtable(guild_id INTEGER ,prefix TEXT)')
await self.connection.commit()
async def get_prefix(self,message):
id = message.guild.id
self.cursor = await self.connection.cursor()
await self.cursor.execute('SELECT prefix FROM prefixtable WHERE guild_id=?',(id,))
prefix = await self.cursor.fetchone()
await self.connection.commit()
return prefix or '@'
bot = botclass()
then the error is lying
self.cursor = await self.connection.cursor()
await self.connection.commit()
slate swan
```py
class botclass(commands.Bot):
def __init__(self):
super().__in...
do you use bot.run or bot.start
robust fulcrum
bot.run
shrewd apex
self.connection = await aiosqlite.connect("prefixes.db")
self.cursor = await self.connection.cursor()
slate swan
yeah then your setup hook never gets triggered
robust fulcrum
What to do now
shrewd apex
yeah then your setup hook never gets triggered
it does i think
otherwise the error wont rise
slate swan
it does i think
!d discord.Client.setup_hook
unkempt canyonBOT
robust fulcrum
bot.start('token')
This?
dusky pine
bot.run
slate swan
```py
bot.start('token')
```
This?
async def main():
async with bot:
await bot.start('token')
asyncio.run(main())
the error itself is saying that there's no connection attribute yet
dusky pine
What kind of asynchronous sorcery is bot.start
slate swan
What kind of asynchronous sorcery is `bot.start`
bot.start() is basically the method called by bot.run() to start the bot
shrewd apex
class botclass(commands.Bot):
def __init__(self):
super().__init__(command_prefix=self.get_prefix,intents=discord.Intents.all())
async def setup_hook(self):
self.conn= await aiosqlite.connect("prefixes.db")
self.cursor = await self.conn.cursor()
await self.cursor.execute('CREATE TABLE IF NOT EXISTS prefixtable(guild_id INTEGER ,prefix TEXT)')
await self.conn.commit()
async def get_prefix(self,message):
id = message.guild.id
self.cursor = await self.conn.cursor()
await self.cursor.execute('SELECT prefix FROM prefixtable WHERE guild_id=?',(id,))
prefix = await self.cursor.fetchone()
await self.conn.commit()
return prefix or '@'
bot = botclass()
async def main():
async with bot:
await bot.start('token')
asyncio.run(main())
How to fix this?
dusky pine
bot.start() is basically the method called by bot.run() to start the bot
ic but why even use that when you have run
slate swan
if you installed discord.py with pip you shouldnt have done that
robust fulcrum
if you installed discord.py with pip you shouldnt have done that
I did with git link
slate swan
it still used pip, didnt it?
robust fulcrum
How to fix this?
How to fix this
slate swan
use poetry commands instead of pip.
robust fulcrum
Poetry in replit π
lament mesa
How to fix this?
remove the async with bot:
slate swan
remove the `async with bot:`
thats not the issue
robust fulcrum
sync with?
slate swan
they are on 1.7.3
lament mesa
does Bot even implement __aenter__ and __aexit__
slate swan
and bot doesnt have an aenter and aexit in 1.7.3
robust fulcrum
Ah me in 1.7
robust fulcrum
Oof i forgot that it's my test bot π€£
robust fulcrum
and bot doesnt have an aenter and aexit in 1.7.3
How to fix it?
lament mesa
they are on 1.7.3
isnt that the latest stable release
slate swan
isnt that the latest stable release
indeed. someone provided them 2.0 code.
slate swan
How to fix it?
you should not be using setup_hook that way to connect then, just do this ```py
async def main():
await bot.setup_hook()
bot.run("token")
asyncio.run(main())
setup hook is automatically called once when the bot starts no need to call again
oh rip thats run
didnt see
slate swan
setup hook is automatically called once when the bot starts no need to call agai...
they are on 1.7.3 :p
shrewd apex
my bad
slate swan
yep that works too
they told ash that they are using 2.0, so its not her fault either
shrewd apex
i was just jokingπ
robust fulcrum
you should not be using setup_hook that way to connect then, just do this ```py
...
I should download 2.9?
2.0?
slate swan
replace bot.run() with await bot.start()
you should, but if this fixes it, you dont need to
robust fulcrum
Anyone here tell me how to download 2.0 with pip?
lament mesa
you will need git to be installed
slate swan
Anyone here tell me how to download 2.0 with pip?
you cant ( in replit )
poetry add git+https://github.com/Rapptz/discord.py use this
slate swan
that works only for once. when you restart the repl, it stops working
lament mesa
you will need git to be installed
pip install git+https://github.com/Rapptz/discord.py.git should work
robust fulcrum
that works only for once. when you restart the repl, it stops working
I have solution
lament mesa
add it to the poetry.lock or something
robust fulcrum
I just need to overite the poetry
slate swan
os.system is the worst thing you should use.
slate swan
I just need to overite the poetry
thats not using pip
robust fulcrum
Bruh
slate swan
`poetry add git+https://github.com/Rapptz/discord.py` use this
this command does the same
robust fulcrum
You not able to understand what I mean
slate swan
do you know how poetry works?
hey
getting this error trying to load cogs, /home/runner/pls-donate/cogs/robux.py:26: RuntimeWarning: coroutine 'BotBase.add_cog' was never awaited client.add_cog(lookup(client)) RuntimeWarning: Enable tracemalloc to get the object allocation traceback
code =
@client.event
async def on_ready():
print("loaded.")
print(client.user)
activity = discord.Game(name="PLS DONATE ", type=3)
await client.change_presence(status=discord.Status.online, activity=activity)
for file in os.listdir("./cogs"):
if file.endswith(".py"):
try:
await client.load_extension(f"cogs.{file[:-3]}")
print(f"Loaded {file[:-3]}")
except Exception as e:
print(f"Failed to load {file[:-3]} because: {str(e)}")
you didnt await add_cog in your cog file's setup function
can you put it in code for me i dont get what ur saying
Why are u loading cogs on_ready
people from here like months back told me 2
slate swan
can you put it in code for me i dont get what ur saying
U dont await add_cog
slate swan
can you put it in code for me i dont get what ur saying
you didnt await bot.add_cog in your cog file's setup function?
oh
and stop naming Bots as client ffs
where do i put it
robust fulcrum
@slate swan i downloaded 2.0
slate swan
and stop naming `Bot`s as client ffs
why? is it bad? lol
slate swan
and stop naming `Bot`s as client ffs
lowercase b*
slate swan
<@456226577798135808> i downloaded 2.0
yes then you can now use bot.run() directly
slate swan
lowercase b*
!d discord.ext.commands.Bot ok lower it next time in your bot
unkempt canyonBOT
slate swan
uh
slate swan
why? is it bad? lol
client is discord.Client bot is commands.Bot
python naming convention
robust fulcrum
@slate swan working but i need a set_prefix command now
supple thorn
lament mesa
commands.bot is a file
supple thorn
Sparky got owned
robust fulcrum
Sarth
lament mesa
commands.bot is a file
in that case it will be commands.bot.Bot
unkempt canyonBOT
robust fulcrum
Can you help me sarth
slate swan
Weird
slate swan
Can you help me sarth
yeah
slate swan
<:b_diggie_constellation:726141314835677385>
yo wassup
iron sorrel
does anyone here have some kind of unittesting framework for discord bots setup?
supple thorn
Hi
slate swan
I used to use lower case b
supple thorn
I used to use lower case b
How'd it go
slate swan
Good
slate swan
does anyone here have some kind of unittesting framework for discord bots setup?
you mean like python tests?
Fine
iron sorrel
you mean like python tests?
yes i mean pythons unittest module
iron sorrel
class FunCommands(commands.Cog):
^^^^^^^^^^^^
...
there probably arent any test frameworks for discord bots specifically but you can use pytest with pytest-asyncio
slate swan
yes i mean pythons unittest module
!pip dpytest
unkempt canyonBOT
iron sorrel
!pip dpytest
oh thanks
slate swan
Alr I gtg π
paper sluice
π
slate swan
How should I make set_prefix command?
well. first make a command that takes a new prefix argument from the author
your next aim would be writing the new prefix into the database using INSERT INTO table/UPDATE table , and commiting to the database
robust fulcrum
Ok
dull terrace
why
lament mesa
send the full error
robust fulcrum
well. first make a command that takes a new prefix argument from the author
How can I use the same connection in it?
slate swan
How can I use the same connection in it?
bot.connection
if you have bot in your scope, else just use ctx.bot.connection
robust fulcrum
Oh k
errant coral
!d select menus
unkempt canyonBOT
slate swan
please do testing stuff in #bot-commands π
paper sluice
if you have bot in your scope, else just use `ctx.bot.connection`
try:
connection = bot.connection
except NameError:
bot = ctx.bot
connection = bot.connection
finally:
globals()['bot'] = bot
π³
lament mesa
robust fulcrum
if you have bot in your scope, else just use `ctx.bot.connection`
@bot.command()
async def set_prefix(ctx,newpre:str):
id = ctx.message.id
connection = ctx.bot.connection
cursor = connection.cursor()
Is it correct?
slate swan
```py
@bot.command()
async def set_prefix(ctx,newpre:str):
id = ctx.message....
works, but await the connection.cursor()
but why do you need ctx.message.id
lament mesa
```py
@bot.command()
async def set_prefix(ctx,newpre:str):
id = ctx.message....
run a query using connection.execute
slate swan
!d discord.ui.select
unkempt canyonBOT
robust fulcrum
but why do you need ctx.message.id
For inserting prefix into guild I'd cell
slate swan
For inserting prefix into guild I'd cell
message.id is the guild id ? huh
paper sluice
you named the class and function the same, so the function over writes the class
robust fulcrum
message.id is the guild id ? huh
Oof i forgot
slate swan
just move that class outside your cog class.
robust fulcrum
message.id is the guild id ? huh
Do i need to select the value to insert?
slate swan
#bot-commands pleasee
dusky pine
@robust fulcrum learn sql π
slate swan
Do i need to select the value to insert?
could you elaborate
robust fulcrum
Is there any guild join event?
slate swan
@slate swan check dm!
if you mean the SELECT statement, you dont need that for inserting
lament mesa
Is there any guild join event?
on_guild_join
dusky pine
Is there any guild join event?
Say that again
lament mesa
!d discord.on_guild_join
unkempt canyonBOT
robust fulcrum
!d discord.on_guild_join
The guild args is id of guild or name?
slate swan
!d discord.Guild this object
unkempt canyonBOT
robust fulcrum
I mean the guild argument is id of guild or name?
dusky pine
a guild object
not id, not name, the discord.Guild object
like the one with guild.name thing yk
afjosdifgsoudfh;gouwea4dfn0w;
lament mesa
I mean the guild argument is id of guild or name?
use guild.id for the id, guild.name for the name
pastel solar
just move that class outside your cog class.
When I do that, I get an error.
dusky pine
like this id = guild.id?
yeah
slate swan
When I do that, I get an error.
what's the error
the error says pretty much dosnt it
'cogs.tickets' raised an error: TypeError: cogs must derive from Cog
paper sluice
inherit from commands.Cog
slate swan
also what rygua said
!e ```py
class ticket: ...
def ticket():...
print(type(ticket))``` your command function is overwriting the class
unkempt canyonBOT
@slate swan :white_check_mark: Your eval job has completed with return code 0.
<class 'function'>
thats why we have naming conventions.
pastel solar
Where would I add commands.cog?
robust fulcrum
@dusky pine how can i make that when bot joins guild it inserts the '@' prefix into guild_id ?
How to make it
I have made the event but confused in inserting thing
slate swan
Where would I add commands.cog?
class ticket(commands.Cog):
def __init__(self, bot):
self.bot = bot``` you define `ticket` as a cog
```py
@discord.slash_command(description = "Create a ticket")
async def ticket(ctx):
await ctx.respond("Test",view=MyView())``` and then assign that as a function.which is not a cog .
vale wing
That's why naming conventions are cool
slate swan
thats why we have naming conventions.
π thats what i said but noone listens
paper sluice
flatcaseforeverythinggang
shrewd apex
camel case when ?π
vale wing
sussyCase
slate swan
case insensitive when :troll:
paper sluice
stupid logging module, using camelCase
robust fulcrum
@slate swan me need some help can you?
vale wing
stupid logging module, using camelCase
They basically migrated it from some other language (java or js idr) but the question is why couldn't they just rename the stuff
slate swan
sure. just post your issue here
paper sluice
<@456226577798135808> me need some help can you?
did you random.shuffle(message.split())? /s
robust fulcrum
did you `random.shuffle(message.split())`? /s
No
how can i make that when bot joins guild it inserts the '@' prefix into guild_id ?
How to make it
I have made the event but confused in inserting thing
paper sluice
They basically migrated it from some other language (java or js idr) but the que...
if they renmaed it, people would be pissed of cuz now they have to edit their code
paper sluice
No
how can i make that when bot joins guild it inserts the '@' prefix into guil...
i was kidding lol
slate swan
@slate swan check dms if u can
paper sluice
robust fulcrum
i was kidding lol
Can you help if possible
dusky pine
if they renmaed it, people would be pissed of cuz now they have to edit their co...
ctrl+shift+f ez π―π₯
vale wing
if they renmaed it, people would be pissed of cuz now they have to edit their co...
Why didn't they rename it at first tho
paper sluice
No
how can i make that when bot joins guild it inserts the '@' prefix into guil...
in the bot join event ( google it )
just write a query to insert into the table the guild id and prefix
robust fulcrum
in the bot join event ( google it )
just write a query to insert into the table ...
Ik about inserting in one value but not with 2
slate swan
No
how can i make that when bot joins guild it inserts the '@' prefix into guil...
INSERT INTO table VALUES ( 69420(server id) , "@");
paper sluice
Why didn't they rename it at first tho
i dont think such conventions came out back then, and when it did it was too late
vale wing
69420
paper sluice
ctrl+shift+f ez π―π₯
ya tell millions of people to do that
dusky pine
INSERT INTO table VALUES ( 69420(server id) , "@");
didn't sql use single quotes
robust fulcrum
INSERT INTO table VALUES ( 69420(server id) , "@");
Why (server id)
slate swan
i dont think such conventions came out back then, and when it did it was too lat...
they could provide both cases for some time with a deprecation message
vale wing
How old is pep8
paper sluice
How old is pep8
came out in 2001
vale wing
And logging module?
slate swan
Why (server id)
insert the server id instead of 69420(server id)
paper sluice
they could provide both cases for some time with a deprecation message
hmm, they could, but i dont think response to that would be positive
robust fulcrum
Oh k
robust fulcrum
INSERT INTO table VALUES ( 69420(server id) , "@");
Can I use variable in server id?
slate swan
hmm, they could, but i dont think response to that would be positive
they can atleast do that in python4 or something idk
vale wing
Ok I found that stuff https://stackoverflow.com/questions/22993667/how-come-the-pythons-logging-module-doesnt-follow-pep8-conventions
unkempt canyonBOT
slate swan
@slate swan check dmmmmmm
robust fulcrum
!sql-fstring
I mean at the guild_id
slate swan
dont ping me repeatedly for that, i'll check it when im finished here
paper sluice
they can atleast do that in python4 or something idk
oh no, they wont try stuff like that after the python2 to 3 incident, atleast thats what i sense from guido's tweet
slate swan
dont ping me repeatedly for that, i'll check it when im finished here
sorry
add_cog(tickets(bot))
paper sluice
as long as a module follows one convention, it shouldn't be a big deal
lament mesa
They basically migrated it from some other language (java or js idr) but the que...
too late now
paper sluice
rust is so organized man, everything i have used in rust follows convention
robust fulcrum
@bot.event
async def on_guild_id(guild):
id = guild.id
connection = ctx.bot.connection
cursor = connection.cursor()
await cursor.execute('INSERT INTO prefixtable VALUES ( ? , "@")',(id))
await connection.commit()
Is it correct?
paper sluice
```py
@bot.event
async def on_guild_id(guild):
id = guild.id
connection ...
run and see, rule 1 of programming
dusky pine
```py
@bot.event
async def on_guild_id(guild):
id = guild.id
connection ...
(id)
you forgot to put a comma
robust fulcrum
Ok
dusky pine
that's just a value not a tuple
slate swan
use mypy/pyright strict when
lament mesa
```py
@bot.event
async def on_guild_id(guild):
id = guild.id
connection ...
i dont think "@" will work, try '@'
slate swan
sql supports both strings
lament mesa
it would just break the string
yeah, but "" in sql is something else
dusky pine
when i used pg it only accepted single quotes
slate swan
embed=discord.Embed(color=color.color,description=f"you are missing the **permission(s)** ``" + ", ".join(error.missing_perms) + '``')
error
embed=discord.Embed(color=color.color,description=f"you are missing the **permission(s)** ``" + ", ".join(error.missing_perms) + '``')
AttributeError: 'MissingPermissions' object has no attribute 'missing_perms```The SQL standard says that strings must use 'single quotes'
idk if sqlite supports double quotes for string
weird if it does
"" is use as an identifier
for table names column names etc
slate swan
just follow the standard 
vocal snow
Pretty sure the library converts the quotations as necessary
paper sluice
<:ducky_sqlite:874451183568302087> just follow the standard <:lemon_clown:896150...
ducky sqlite bruh
slate swan
Pretty sure the library converts the quotations as necessary
i guess so, lemme try using the same in mysql command line
ignore the 3rd query, i forgot to type VALUES there
vocal snow
Interesting
robust fulcrum
i dont think `"@"` will work, try `'@'`
The set_prefix is returning none again and again even i updated the value
lament mesa
The set_prefix is returning none again and again even i updated the value
send the code
slate swan
The set_prefix is returning none again and again even i updated the value
because you're checking the message.id in that function too
message.guild.id it should be ;-;
robust fulcrum
import aiosqlite
import discord
from discord.ext import commands
import asyncio
class botclass(commands.Bot):
def __init__(self):
super().__init__(command_prefix=self.get_prefix,intents=discord.Intents.all())
async def setup_hook(self):
self.connection = await aiosqlite.connect("prefixes.db")
print("connected")
self.cursor = await self.connection.cursor()
await self.cursor.execute('CREATE TABLE IF NOT EXISTS prefixtable(guild_id INTEGER ,prefix TEXT)')
await self.connection.commit()
async def get_prefix(self,message):
id = message.guild.id
self.cursor = await self.connection.cursor()
await self.cursor.execute('SELECT prefix FROM prefixtable WHERE guild_id=?',(id,))
print("selected")
prefix = await self.cursor.fetchone()
print(prefix)
await self.connection.commit()
return prefix or '@'
bot = botclass()
@bot.event
async def on_guild_id(guild):
id = guild.id
connection = bot.connection
cursor = connection.cursor()
await cursor.execute('INSERT INTO prefixtable VALUES ( ? , "@")',(id,))
await connection.commit()
@bot.event
async def on_ready():
print("ready")
@bot.command()
async def test(ctx):
await ctx.send("working")
@bot.command()
async def set_prefix(ctx,newpre:str):
id = ctx.message.guild.id
connection = ctx.bot.connection
cursor = await connection.cursor()
await cursor.execute('UPDATE prefixtable SET prefix=? WHERE guild_id=?',(newpre,id,))
can you send the database file
robust fulcrum
Ok
slate swan
dont think you can send here, just dm me
unkempt canyonBOT
Hey @robust fulcrum!
paper sluice
dont you have to commit after UPDATE?
robust fulcrum
dont you have to commit after `UPDATE`?
I did
slate swan
@robust fulcrum there's nothing in the db
paper sluice
you didnt in set_prefix
slate swan
dont you have to commit after `UPDATE`?
^^
robust fulcrum
<@893363878728192041> there's nothing in the db
Tf man why this happening
slate swan
you can always check your sqlite files here to confirm the data
https://inloop.github.io/sqlite-viewer/
slate swan
Tf man why this happening
you didnt commit in the set_prefix
robust fulcrum
I just did now
robust fulcrum
you didnt commit in the set_prefix
But it should insert value on guild join but it not did
slate swan
But it should insert value on guild join but it not did
kick and reinvite the bot while it's online
robust fulcrum
Ok
vale wing
<@893363878728192041> there's nothing in the db
Float limit?
slate swan
async def on_guild_id(guild):
id = guild.id``` its guild_join not guild_idOr what is that
slate swan
Anyway what does it mean
the first one is the index from which i should start selecting, the second one is the number of queries which the select should proceed with
naive dew
i want make a bot on node.js
vale wing
Ok
slate swan
i want make a bot on node.js
paper sluice
Anyway what does it mean
basically rows_in_table[:30]
naive dew
thx @slate swan
slate swan
basically `rows_in_table[:30]`
exactly.
vale wing
Why not just LIMIT 30
slate swan
idk why they do that, the viewer had it by default :p
slate swan
they have paginator which moves on to 30, 60 on the next page
slate swan
you forgot to await something
robust fulcrum
Hmm
@bot.event
async def on_guild_join(guild):
id = guild.id
connection = bot.connection
cursor = connection.cursor()
await cursor.execute('INSERT INTO prefixtable VALUES ( ? , "@")',(id,))
await connection.commit()
cursor = connection.cursor()
await cursor.execute('INSERT INTO prefixtable VALUES ( ? , "@")',(id,))``` await connection.cursor whenDo we need to?
slate swan
yes
slate swan
gg, so your custom prefix system works now?
robust fulcrum
Ye
paper sluice
π
slate swan
π nice, now find a way to default a prefix if your bot was invited while the bot was offline
robust fulcrum
Head ache
robust fulcrum
π nice, now find a way to default a prefix if your bot was invited while the bo...
Ye my bot returns @ if value is none
slate swan
if its None and you try to setup a new prefix using set_prefix command, nothing will happen
since no row with that guild_id is in the database.
in your set_prefix you can fetch the prefix from the db first, if its there, then update it
if its not there , then insert it, easy
flat solstice
for some reason this get_role is returning None and I'm not sure why. ik it can see Config().further_sup... bc itlogs the value when it errorspy @button(label="I still need help!", style=ButtonStyle.blurple, custom_id="Further-Support",, emoji="π©",, row=2,) async def role_add_button(self, interaction: Interaction, button: Button): # get_role from the clients cache role = interaction.guild.get_role(Config().further_support_role)
slate swan
is that a string?
flat solstice
yes it probably will be bc it's pulling it from the.env
Just wrap it in int() and I should be good, I think
unkempt canyonBOT
slate swan
key, default and the result are str.
robust fulcrum
in your set_prefix you can fetch the prefix from the db first, if its there, the...
How can I do that? Any idea?
slate swan
How can I do that? Any idea?
yes, first try getting the prefix for that server using the code you in the get_prefix, if fetchone() returns None, then use INSERT INTO prefixtable, else use UPDATE prefixinfo
slate swan
yes, first try getting the prefix for that server using the code you in the get_...
it's fetchone() without an underscore
*without
faster I am
ty for correcting me
indeed
human you are, cant compete me
boreal ravine
I wonder why it doesn't have an underscore π€ maybe because it was ported from another language?
maiden fable
Probably
covert basin
@client.command()
async def wiki(ctx, keyword):
front = "https://en.wikipedia.org/wiki/"
await ctx.send(front + keyword)
client.run("(token)", bot=True)
status = cycle(['A', 'B'])
What can I do to solve this error?
paper sluice
I wonder why it doesn't have an underscore π€ maybe because it was ported from a...
what doesn't?
boreal ravine
```py
@client.command()
async def wiki(ctx, keyword):
front = "https://en.wiki...
Remove bot=True, that kwarg was removed in newer versions
boreal ravine
what doesn't?
The fetchone method
robust fulcrum
yes, first try getting the prefix for that server using the code you in the get_...
Ok
covert basin
Remove `bot=True`, that kwarg was removed in newer versions
Still error
paper sluice
The `fetchone` method
oh
boreal ravine
Still error
Your using an invalid token
slate swan
Yeah it's not the client secret
shrewd apex
nope
slate swan
Go to the bot page, copy the bot token
shrewd apex
token is visible only once when u create the application
slate swan
Actually regenerate to copy it
shrewd apex
after that u have to reset and copy
robust fulcrum
yes, first try getting the prefix for that server using the code you in the get_...
@bot.command()
async def set_prefix(ctx,newpre:str):
id = ctx.message.guild.id
connection = ctx.bot.connection
cursor = await connection.cursor()
await cursor.execute('SELECT prefix FROM prefixtable WHERE guild_id=?',(id,))
check = await cursor.fetchone()
if check == None:
await cursor.execute('INSERT INTO prefixtable VALUES ( ? , ?)',(id,newpre,))
await ctx.send(f"prefix updated to {newpre}")
await connection.commit()
else:
await cursor.execute('UPDATE prefixtable SET prefix=? WHERE guild_id=?',(newpre,id,))
await ctx.send(f"prefix updated to {newpre}")
await connection.commit()
Like this?
slate swan
exactly !
slate swan
mhhh
dusky pine
probably replace check == None with check is None
slate swan
Lots of redundant code
yes the await ctx.send and connection. commit can be moved out of the if/else
robust fulcrum
probably replace `check == None` with `check is None`
Both have same meaning ig?
dusky pine
Both have same meaning ig?
!d is
unkempt canyonBOT
slate swan
id = ctx.message.guild.id
connection = ctx.bot.connection
cursor = await connection.cursor()``` and these varprefer using is for comparing with singletons
slate swan
Both have same meaning ig?
Not entirely
slate swan
ofcourse.
robust fulcrum
I confused how to
slate swan
just like any other command...
robust fulcrum
Oh k
paper sluice
Both have same meaning ig?
is checks if its the same object, == checks if they contain the same value
hence why is is a little faster than == to check for singleton values
robust fulcrum
Do event name is on_guild_remove?
slate swan
yes
slate swan
Do event name is on_guild_remove?
yds
covert basin
Your using an invalid token
I tried to use the correct one, the bot can run but it don't reply me anything
robust fulcrum
i prefer not doing that
I mean that the storage will be like wasted on the non used value
slate swan
no
slate swan
I mean that the storage will be like wasted on the non used value
thats not even 0.01kb
barely seems to exist
robust fulcrum
Replit gives only 1 gb sadly
shrewd apex
1gb is more than enough
robust fulcrum
Ik
slate swan
it's not 10 records will fill up a gb
cause they will just purge your files since their file system is ephemeral
robust fulcrum
My bot is already 89 mb
slate swan
"89"
paper sluice
bruh one row with two columns takes like 64 bytes
robust fulcrum
paper sluice
probably less depending on the data type
robust fulcrum
But i would prefer deleting
slate swan
My bot is already 89 mb
i bet most of that is pycache lol
paper sluice
But i would prefer deleting
you know what takes 64 bytes? empty dict
robust fulcrum
64 byte also precious
slate swan
My bot is already 89 mb
you know even if you have more than 500 rows with max 2 cols, you will still be left with roughly 250+mb (if I calced it right sooo)
slate swan
64 byte also precious
My precious
robust fulcrum
Whats pychache
slate swan
reminds me of the goblin π
paper sluice
64 byte also precious
bro, a class is like 1000+ bytes, and you must have like 5-6 in ur whole bot, why do you care for one sql row so much?
slate swan
Whats pychache
python to bytecode
slate swan
green
robust fulcrum
Clean and python
slate swan
ew
dusky pine
haha people care about n bytes in code
my docstrings will probably take up 20%
just ask
slate swan
@robust fulcrum my db file with 10000 guild, prefix items takes 156 kb
robust fulcrum
How to delete the prefix and guild I'd from db?
dusky pine
How to delete the prefix and guild I'd from db?
DROP
paper sluice
DELETE ...;DROP table π
slate swan
make him drop the complete table
dusky pine
Me rn doing !set_prefix @'; DROP TABLE prefixtable;--
dusky pine
can't forget the classic ;--
covert basin
My bot can run but it doesn't respond
paper sluice
put the command inside the cog class
robust fulcrum
dont do that lol
Ik about deleting 1 value but not 2
slate swan
Ik about deleting 1 value but not 2
you dont delete values, you delete rows
shrewd apex
self, interaction
slate swan
self, interaction
self, ctx cuz pycord
they provide a ApplicationContext or something class as the first arg instead of interaction
robust fulcrum
you dont delete values, you delete rows
How?
robust fulcrum
```sql
DELETE FROM table_name WHERE field = ?
```
I want delete guidl_id and prefix will it delete both?
slate swan
yep
robust fulcrum
I thought only 1
slate swan
it deletes both
shrewd apex
it deletes the whole row
slate swan
uwu
robust fulcrum
@slate swan
There is one problem
Like someone kicks the bot when it's offline then the prefix would not be removed from table
Is there any way to fix?
lament mesa
you can make a separate script to delete the rows in the db which the bot is not in
slate swan
when making a ticket bot, how do you set the permissions for it?
robust fulcrum
you can make a separate script to delete the rows in the db which the bot is not...
Not possible to
dusky pine
Not possible to
it's possible lol, what are u talking about
robust fulcrum
it's possible lol, what are u talking about
Like someone kicks the bot when it's offline then the prefix would not be removed from table
dusky pine
You can make a script to check if the bot is not in that server
robust fulcrum
Hard for me
slate swan
when making a ticket bot, how do you set the permissions for it?
hushed galleon
permissions for the bot itself, or the created tickets?
open gust
how can i copy a message one channel to another channel?
paper sluice
how can i copy a message one channel to another channel?
take the message content, and send it to a different channel
paper sluice
which message do you want to send to another channel?
slate swan
permissions for the bot itself, or the created tickets?
created tickets
hushed galleon
created tickets
assuming you're using discord.py, the Guild.create_text_channel() method has an overwrites= parameter that takes a dictionary of PermissionOverwrite objects so you can specify the permissions for @Π΅veryone, whoever made the ticket, and whatever roles should be allowed to see it
slate swan
assuming you're using discord.py, the `Guild.create_text_channel()` method has a...
I use nextcord but should be similar
hushed galleon
e.g. py overwrites = { ctx.guild.default_role: discord.PermissionOverwrite(read_messages=False), ctx.author: discord.PermissionOverwrite(read_messages=True), my_mod_role: discord.PermissionOverwrite(read_messages=True) } await ctx.guild.create_text_channel(overwrites=overwrites, ...)
slate swan
Okay thank you
@hushed galleon 1 more thing, do you know how to also send a message in the created channel?
or even on the ephemeral pinging the new channel?
so upon interaction sends the new channel in the ephemeral
vale wing
create_text_channel returns channel object
slate swan
yeah ik that
quaint epoch
<@153551102443257856> 1 more thing, do you know how to also send a message in th...
you could do py channel = await ctx.guild.create_text_channel(overwrites=overwrites, ...) await channel.send('hello')
slate swan
you could do ```py
channel = await ctx.guild.create_text_channel(overwrites=over...
ah ok
vale wing
And you can't send an ephemeral without interaction if you meant that
quaint epoch
shadow vigil
it's possible lol, what are u talking about
whos nae-nae?
vocal snow
whos nae-nae?
pliant pagoda
@bot.command(pass_context=True)
async def test(ctx):
MEMBER = discord.utils.get(ctx.guild.roles, name= "Member")
embed=discord.Embed(title="Verification", description="You are now Verified!", color=0x3EF72D)
if ctx.channel.id == 993228727846719569:
await ctx.author.add_roles(MEMBER)
await ctx.message.delete()
await ctx.send(embed=embed, delete_after=5)
and
@bot.event
async def on_message(ctx):
if ctx.content != "verify": #Check if the message is not exactly "verify" (the verify message/command sent by the user).
print("Deleting because it's not $verify")
await ctx.delete()
How would i combine these two as everything i've tried makes one work but not the other?
crimson pendant
Hey
i am trying to study discord bot programming but i have error
what i have to do with it?
maybe you can hellp
will be so gratefull about it
hushed galleon
```
@bot.command(pass_context=True)
async def test(ctx):
MEMBER = discord.ut...
FAQ: https://discordpy.readthedocs.io/en/stable/faq.html#why-does-on-message-make-my-commands-stop-working
your on_message event is preventing all commands from being processed so you should use one of the solutions described in the faq, either @bot.listen() or await bot.process_commands(message)
pliant pagoda
thank youπ
vale spear
hey is there any good tutorial on discord.py library?
slate swan
https://youtu.be/vjW8wmF5VWc
!ot
unkempt canyonBOT
pliant pagoda
@bot.command(pass_context=True)
async def verify(ctx):
MEMBER = discord.utils.get(ctx.guild.roles, name= "Member")
embed=discord.Embed(title="Verification", description="You are now Verified!", color=0x3EF72D)
if ctx.channel.id == 993228727846719569:
await ctx.author.add_roles(MEMBER)
await ctx.message.delete()
await ctx.send(embed=embed, delete_after=5)
@bot.listen('on_message')
async def verify(ctx):
if ctx.content != "$verify":
print("Deleting because it's not $verify")
await ctx.delete()
Still wont workπ§
slate swan
have you been to this channel before lmaoo
Wdym I have 8952 messages in this channel π‘
swift pumice
async def ping(interaction : Interaction):
await interaction.response.send_message("pong")``` hi guys this is my first slash command so im sorry if iam dumb but did i do something wrong? if i type /ping or look at the slash commands my command will not be displayedanyone know how to delete a channel through interaction?
swift pumice
```
@bot.command(pass_context=True)
async def verify(ctx):
MEMBER = discord....
wait i thought pass_context=True isnt a thing anymore
swift pumice
```
@bot.command(pass_context=True)
async def verify(ctx):
MEMBER = discord....
what doesnt work?
vocal snow
wait i thought pass_context=True isnt a thing anymore
it still exists, just that it defaults to True now so there's no point in setting it to True yourself
swift pumice
it still exists, just that it defaults to True now so there's no point in settin...
oh ok, btw hi zeffo
could u maybe help me with my problem?
slate swan
```
@bot.command(pass_context=True)
async def verify(ctx):
MEMBER = discord....
It's ctx.message.content
vocal snow
could u maybe help me with my problem?
sure, ask away
slate swan
See
swift pumice
```@bot.slash_command(guild_ids=[testingserverID])
async def ping(interaction : ...
.
@vocal snow
vocal snow
commands.Context
vocal snow
wAHT
slate swan
Ye
swift pumice
what
pliant pagoda
It's ctx.message.content
Thank you!
swift pumice
```
@bot.command(pass_context=True)
async def verify(ctx):
MEMBER = discord....
async def on_message(message):
guild = message.guild
role = guild.get_role(985205310740389918)
if message.author == bot.user:
return
if message.channel.id == 987651665492586568 and message.content.lower() != "!verify":
await message.delete()
await message.channel.send(f'{message.author.mention}please only write !verify and not something other', delete_after=3)
if message.channel.id == 987651665492586568 and message.content.lower() == "!verify":
await message.author.add_roles(role)
await message.delete()
await bot.process_commands(message)
``` i have something similar idk if this could help youwhich wrapper is this?
swift pumice
which wrapper is this?
nextcord.
should i rather use discord?
i only use nextcord because a friend said to me nextcord is better
slate swan
i only use nextcord because a friend said to me nextcord is better
i use nextcord
Dont
pliant pagoda
```@bot.event
async def on_message(message):
guild = message.guild
role ...
Appreciate it
vocal snow
That's upto preference but I'm not familiar with nextcord. I'll need to check out their docs
swift pumice
That's upto preference but I'm not familiar with nextcord. I'll need to check ou...
oh okay
slate swan
Use disnake or discord.py nextcord is ew
swift pumice
Use disnake or discord.py nextcord is ew
why?
ivory owl
is there a delete command similar to attachments.save?
grim oar
Delete from disk or delete the attachment message
slate swan
how do i delete a channel thru an interaction? im trying to freshen up my ticket system.
grim oar
!d discord.Interaction.channel
unkempt canyonBOT
grim oar
!d discord.TextChannel.delete
unkempt canyonBOT
ivory owl
Delete from disk or delete the attachment message
the former
because it messes if I use the command again and produces two juxtaposed images
grim oar
because it messes if I use the command again and produces two juxtaposed images
no then, make your own
pliant pagoda
await message.channel.send(f"Please enter your code below. Your code: '{random.randint (10000,99999)}'")
embed=discord.Embed(title="Verification", description="You are now Verified!", color=0x3EF72D)
await message.author.add_roles(role)
await bot.process_commands(message)
await message.channel.send(embed=embed, delete_after=5)
This is a part of my verification system. How would i go about checking if the random number is correct and then that resulting into the role adding?
rare saddle
How to get a channel's webhook and send a message through it
paper sluice
```
await message.channel.send(f"Please enter your code below. Your code: '{rand...
wdym by "checking if the random number is correct"?
pliant pagoda
wdym by "checking if the random number is correct"?
I think i've figured it out. But basically {random.randint(10000,99999)} gives out a 'code', user has to enter code and if its right it will give them a role
Nevermind not figured it out
vocal snow
```
await message.channel.send(f"Please enter your code below. Your code: '{rand...
What are you verifying with this though?
paper sluice
I think i've figured it out. But basically {random.randint(10000,99999)} gives o...
store the random number somewhere, then check use it to check
rare saddle
How to get webhook by url
vocal snow
How to get webhook by url
!d discord.Webhook.from_url
unkempt canyonBOT
paper sluice
its from_url not url
rare saddle
vs code
sick birch
```
await message.channel.send(f"Please enter your code below. Your code: '{rand...
Save the random number to a variable
rare saddle
its `from_url` not `url`
Oops, I just tried another option and forgot to put it back. Error remains
paper sluice
Oops, I just tried another option and forgot to put it back. Error remains
try this
async with aiohttp.ClientSession() as session:
webhook = discord.Webhook.from_url(url, session=session)
you're passing the ClientSession class to session kwarg, not an instance
pliant pagoda
Save the random number to a variable
Full code:
@bot.event
async def on_message(message):
guild = message.guild
role = guild.get_role(993231458846122014)
code = {random.randint (10000,99999)}
if message.author == bot.user:
return
if message.channel.id == 993228727846719569 and message.content.lower() != "$verify":
await message.delete()
await message.channel.send(f' Please only write $verify and not something other {message.author.mention}', delete_after=3)
if message.channel.id == 993228727846719569 and message.content.lower() == "$verify":
message = await message.channel.send('React to recieve your code!')
await message.add_reaction('β
')
def check(reaction, user):
return reaction.emoji == 'β
' and reaction.message == message
reaction, user = await bot.wait_for('reaction_add', timeout=30.0, check=check)
await message.delete()
await message.channel.send(f"Please enter your code below. Your code: '{code}'")
embed=discord.Embed(title="Verification", description="You are now Verified!", color=0x3EF72D)
await message.author.add_roles(role)
await bot.process_commands(message)
await message.channel.send(embed=embed, delete_after=5)
Saved the random number as a variable now thanks, so how would i go about checking if its right or not now?
paper sluice
Save the random number to a variable
hi robin π
paper sluice
Full code:
```
@bot.event
async def on_message(message):
guild = message.gui...
dont do {random.randint(...)} the {} outside makes a set which is not what you want, just do random.radint(...)
pliant pagoda
thank you
sick birch
hi robin π
Hi. Nice to see you all, been a while
pliant pagoda
dont do `{random.randint(...)}` the `{}` outside makes a set which is not what y...
done that thanks, so now how do I take the input, check if its correct and then give the role?
paper sluice
Full code:
```
@bot.event
async def on_message(message):
guild = message.gui...
so you need to store it in a global space or an external file, because everytime someone types a message, it generates a new random int, which is not what you want
paper sluice
like you can either have a global dict/list where you store the random ints or you write those ints to a file and then you open the file and look for it
advantage of file is that it will keep the data even after your bot shuts down ( unless you wipe it yourself )
slate swan
π
paper sluice
im not sure how to do that sorry
from random import randint
data = {}
def store_data(name):
data[name] = randint(1, 10)
return 'stored'
store_data('ryuga')
store_data('mossy')
print(data)
something like this
vale sierra
whats is the code to have the bot avatar ? please
pliant pagoda
```py
from random import randint
data = {}
def store_data(name):
data[name...
Appreciate it
paper sluice
you didnt pass the message parameter
vale sierra
bot.avatar.url ?
paper sluice
oh, you want to use events in cogs, for that you need to decorate it with @commands.Cog.listener()
paper sluice
`bot.avatar.url` ?
bot.user.avatar.url
vale sierra
`bot.user.avatar.url`
thanks you, did you know the code to show all the servers the bot have ?
paper sluice
thanks you, did you know the code to show all the servers the bot have ?
bot.guilds
iron sorrel
@commands.user_command(name="balance", guild_ids=GUILD_IDS, description="get users balance user")
@commands.check(check_user_in_db)
@commands.check(check_target_not_bot)
async def balance(self, inter: Inter, target: disnake.Member):
await inter.response.defer()
async with inter.channel.typing():
em = await self.economy_service.balance(target)
await inter.send(embed=em)
why are the type hints not working for inter.response and inter.channel
paper sluice
because you are sending the message in message.channel not create_channel
paper sluice
```py
@commands.user_command(name="balance", guild_ids=GUILD_IDS, description="g...
wdym by "not working"
iron sorrel
paper sluice
I'm confused, are you looking for autocorrect suggestions?
iron sorrel
auto-what ππ yes yes im looking for those
slate swan
Hi
paper sluice
no, i don't think you want that check, just do create_channel.send(message)
paper sluice
auto-what ππ yes yes im looking for those
suggestions for what method? your custom methods don't show up in the tab?