README.md

This is currenly a python based server/client chatroom

using a SQL database to store information

Functionalitys currently include:

-diffrent roooms
-login with email and password
-username not email
-sql database
-history table
-client/room info
-login
-userinfo
-bannedips
-ability to create accounts
-ability to bann ips
-ip logging

Looking to add:

-improved server resiliency (login/create account breaks server if client sends just enter key)
-account banning
-spam protection

Non server related things that i want to add

-execualtable client side (proabably in rust)

Setup

To run server first create a config.secret file. inside this file use the following format. (NOTHING in quotations)

[server]

db_ip = YOUR_DB_IP
db_user = DB_USER
db_password = DB_PASSWORD
db_db = SCHEMA_NAME

SQL Server Setup

A script now exists to do this for you called "SQL_DB_CREATOR.sql"

create a schemea
banned_ips
-banned_id [INT] (PK,NN,UQ,AI)
-ipaddress [VARCHAR(45)]
client_room
-client_room_id [INT] (PK,NN,UQ,AI)
-client_id [INT]
-room_id [INT]
clients
client_id [INT] (PK,NN,UQ,AI)
nickname [VARCHAR(45)]
active [INT]
history
-history_id [INT] (PK,NN,UQ,AI)
-room_id [INT]
-client_id [INT]
-message1 [LONGTEXT]
-time_data [VARCHAR(45)]
login_data
-login_id [INT] (PK,NN,UQ,AI)
-client_id [INT] (UQ)
-email [VARCHAR(45)]
-password [VARCHAR(200)]
rooms
-room_id [INT] (PK,NN,UQ,AI)
-room_name [VARCHAR(45)]
ip_logs
-ipLogs_id [INT] (PK,NN,UQ,AI)
-client_id [INT]
-ip_add [VARCHAR(100)]
-time_date [VARCHAR(45)]