UBAYA CTF Community Bot

Structure

bot_auth_role/
├── bot.py
├── cogs/
│   ├── __init__.py
│   ├── admin.py
│   ├── events.py
│   ├── ping.py
│   └── verification.py
├── config/
│   ├── __init__.py
│   └── settings.py
├── services/
│   ├── __init__.py
│   ├── crawling.py
│   └── database.py
├── utils/
│   ├── __init__.
│   ├── base_cog.py
│   ├── helpers.py
│   └── logger.py
├── Dockerfile
├── docker-compose.yml
└── requirements.txt

Structure ERD

+------------+          +------------------+
| Mahasiswa  |          |  Members         |
+------------+          +------------------+
| id (PK)    |<-------- | id (PK)          |
| nama       |          | discord_id       |
| gender     |          | discord_username |
| nrp        |          | mahasiswa_id (FK)|
| fakultas   |          +------------------+
| prodi      |
| angkatan   |
| verified_at|
+------------+

+-------------------+
| ServerChannels    |
+-------------------+
| id (PK)           |
| guild_id          |
| guild_name        |
| channel_id        |
| channel_name      |
+-------------------+

DB User Permission

GRANT CREATE, ALTER, DROP, INDEX, SELECT, INSERT, UPDATE, DELETE ON db_name.* TO 'user'@'hostname';

Run

docker-compose up -d --build

Stop

docker-compose down -v

Log

docker-compose logs -f

Version

• v2.0.0