erobin27 / betbot Goto Github PK

group embeds into groups of ~8

only return 10 latest wagers

Past few days the BetBot has been offline.

button at bottom of message to switch between active and history

The bot has been offline for quite a while and I see there hasn't been any changes recently. Is there any simple way to self host this? I have a spare rpi running docker. Thanks for any help i loved the bot when it worked it would be 😭 sad for this to be the end of it.

Hello and thank you very much for this awesome project. I'm really looking forward to getting this all setup and was hoping i could get some help.

To get started clone the repo to your local machine and begin installing it's dependencies

What dependencies need to be installed?

You will need to setup your discord token and database connection info in a .env file in the project directory.

Can you give an example of how the .env file is to be setup?

I've never used MySQL before is there any further setup needed past just installing it? If so could you provide a quick tutorial on what steps to take in order to get the bot connected with mysql?

EDIT: After installing mysql i created a new database with the name UFC_BOT I added a username and password to the DB. But I'm still not sure about how the env file is supposed to be setup

EDIT2: I created a .env file using this information

APPID=MYID
TOKENTEST=MYTOKEN
user=MYUSERNAME
passwd=MYPASSWORD
database=UFC_BOT

I also installed each dependency it complained about when trying to run python BetBot.py

Now when i run python BetBot.py i get the following error.

C:\Discord_Bots\BetBot>python BetBot.py
Traceback (most recent call last):
  File "C:\Discord_Bots\BetBot\BetBot.py", line 7, in <module>
    import Database
  File "C:\Discord_Bots\BetBot\Database.py", line 5, in <module>
    db = mysql.connector.connect(
  File "C:\Users\THEKI\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.9_qbz5n2kfra8p0\LocalCache\local-packages\Python39\site-packages\mysql\connector\__init__.py", line 274, in connect
    return MySQLConnection(*args, **kwargs)
  File "C:\Users\THEKI\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.9_qbz5n2kfra8p0\LocalCache\local-packages\Python39\site-packages\mysql\connector\connection.py", line 115, in __init__
    self.connect(**kwargs)
  File "C:\Users\THEKI\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.9_qbz5n2kfra8p0\LocalCache\local-packages\Python39\site-packages\mysql\connector\abstracts.py", line 1015, in connect
    self._open_connection()
  File "C:\Users\THEKI\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.9_qbz5n2kfra8p0\LocalCache\local-packages\Python39\site-packages\mysql\connector\connection.py", line 429, in _open_connection
    self._do_auth(self._user, self._password,
  File "C:\Users\THEKI\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.9_qbz5n2kfra8p0\LocalCache\local-packages\Python39\site-packages\mysql\connector\connection.py", line 230, in _do_auth
    self._auth_switch_request(username, password)
  File "C:\Users\THEKI\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.9_qbz5n2kfra8p0\LocalCache\local-packages\Python39\site-packages\mysql\connector\connection.py", line 381, in _auth_switch_request
    raise errors.get_exception(packet)
mysql.connector.errors.ProgrammingError: 1045 (28000): Access denied for user ''@'localhost' (using password: NO)

Now i'm stuck again but feel like im getting much closer.

Hello i would like to add some feature requests if that is even a thing for this project. I'm not capable of adding these things to the project but would be willing to try and kick in a few bucks if that could help improve the betbots usefulness.

Lifetime Player Stats
/mystats display your win loss stats with the ability to choose from a drop box which ufc event you would like more info about the bets played for that event.

/discordIDstats Same as above but see other users lifetime stats and bets made.

Event Schedule Reminders

@everyone with the scheduled card/time/location for example the day before an event and then again 30m before

UFC related games/polls/dailies to earn money

Add polls and quiz for people to attempt to win/earn more spending cash for the betbot

When i try to place a bet in for UFC 268 im getting the results for UFC 267 instead.

After placing wagers the bot subtracts the proper amount form the balance but after the fights finish the balance is not updated with the winnings.

For example the UFC 268 card i spread $19 worth of wagers out across 8 fights. I picked the winning fighter in each fight but my balance says its at $481.00