[NEW] Discord Economic Bot | Opening Account, Work, Balance | Part 1 | Python

[NEW] Discord Economic Bot | Opening Account, Work, Balance | Part 1 | Python
sqlite3 is built into python but if its not their try this.
Install sqlite3: | pip install pysqlite3 | or | pip install sqlite |
DB browser: sqlitebrowser.org/dl/
Join my server for help or if you want to talk to peps: / discord

[@Nurgalinchik]

You're my hero!!!
Thank you so much for the video

[@mujtabanaveed3583]

Please continue this series :D It was great help to create a small bot for my friends and I.
I have a recommendation for the next part: Make a shop command and an inventory system.

[@CivoCode]

Glad it helped and yes I shall do a shop and inventory system next

[@timothybritcliffe]

Hey Civo! I did everything exactly how the video describes/shows. Do you have any idea why the eco.sqlite file wouldn't generate?

[@zaynosplay3433]

I love to learn coding😊
But i have a question ❓
Is there any option for verification system in discord server by Gmail or by mobile number ?
Example: when new members join the server bot send them message for Varified his self option 1- ( by Gmail) option 2- (by mobile number)
I really want that for my discord server

[@nishiths5107]

nice bro

[@kream_8127]

Please help, what does this error mean.
Traceback (most recent call last):
File "c:\Kream\Sunflowar Bot\Sunflowar.py", line 2, in
from economy import Event
File "c:\Kream\Sunflowar Bot\economy.py", line 10, in
class Event(Commands.Cog):
AttributeError: 'dict' object has no attribute 'Cog'
Sunflowar is my main folder, Economy is like his event folder.
help :)

[@Lynztx]

can you show the code?
I think i can maybe fix it for you

[@Lynztx]

you have to replace the class Event(Commands.Cog): with class Event(commands.Cog):
You just got the cap wrong

[@maniccFN]

I get this error
Ignoring exception in on_ready
Traceback (most recent call last):
File "C:\Python314\lib\site-packages
extcord\client.py", line 445, in _run_event
await coro(*args, **kwargs)
File "C:\Users\Alexander\Desktop\econemyBot\event.py", line 19, in on_ready
cursor.execute('''CREATE TABLE IF NOT EXISTS main (
sqlite3.OperationalError: near ".": syntax error

[@lackjaw]

Did you solve the problem? I am getting same error.

[@Lynztx]

cursor.execute('''CREATE TABLE IF NOT EXISTS eco (
user_id INTERGER, wallet INTERGER, bank INTERGER
)''')
Maybe u did smth wrong and idk what u did wrong so here

[@maniccFN]

@@lackjaw no sorry

[@set1227]

It won‘t create a SQL file. Please help 🙏

[@caycuockiemtien]

Can you help me? my sqlite file cannot be created

[@mr.pasdenom107]

Did it work since? Bc someone helped me and i found the solution if needed

[@rafy267]

Damn cutie

[@user-mb5lq5po7h]

can't use.... it didn't generate sqlite file

[@mr.pasdenom107]

Did it work since? Bc someone helped me and i found the solution if needed

[@gregremer]

Civo, Is your discord down fella? can you message me the new one. I could really use some help with the SQLite3 discord commands, which happy to discuss $

[@amirulhakimi6705]

Hi,can i make bot using my phone? im curious

[@CivoCode]

I'm not sure maybe if you use replit, not recommended tho

[@amirulhakimi6705]

@@CivoCode Mhmm ig i need to get a laptop then😂

[@CivoCode]

Yes indeed lol

[@J.S_YE]

@@CivoCode i do use replit it's quite good but the env system in it is pretty trash xD

[@CivoCode]

I meant as using it on a phone

[@Lynztx]

Hey great video!
But im keep getting this error whenever i try using hide!balance or hide!earn
hide! is my prefix
And this is the error:
Traceback (most recent call last):
File "C:\Users\Tony\AppData\Local\Programs\Python\Python310\lib\site-packages\discord\client.py", line 409, in _run_event
await coro(*args, **kwargs)
File "c:\Users\Tony\Downloads\My Awsome Discord Bot\test.py", line 33, in on_message
cursor.execute(f"SELECT user_id FROM eco WHERE user_id = {author.id}")
sqlite3.OperationalError: no such table: eco

[@user-vy8nc3hu2u]

Remove the on_ready event after the event where you create the table/delete the event where you created the table but copy the code and paste it in another event on_ready

[@user-bq2xe3jp4c]

discord invite is not working ser

[@joeyy9705]

how do i get python

[@adriansfx]

did you try searching for it instead of asking in a comment? searching is way easier than leaving a comment on youtube 😂

[@omaralkouli1852]

I've followed everything and my discord bot runs and goes online but i cant find my 'main.sqlite' it doesnt appear. This is my cog
async def setup(bot):
await bot.add_cog(Event(bot))
changed a bit..

[@timothybritcliffe]

did you end up figuring this out?
I cannot for the life of me figure out why the .sqlite file wont generate

[@mr.pasdenom107]

Did it work since? Bc someone helped me and i found the solution if needed

[@loyi6324]

@@mr.pasdenom107 what did u do