Understanding the Ban Table Columns in a 4s Website

[tairasan]

hey, so as some of you may already know, i am currently working on a 4s website. i want to display if an account is banned in the account settings but i dont really understand some column names in the ban table..

can someone please explain to me what these do?
- bBlockType - is this like 0 = hack, 1 = bug etc.. ??
- bEternal - is this for perma ban? but thats useless just write 99999999 at dwduration
- bBlockReason - reason should be text but the column is a tinyint
- sendBanMail - to what email? lol its a tinyint so i cant insert an email

 

[Jineman]

beternal = 1 perma 0 duration ban
bblocktype = Useless for game login (you can use it for somethink like 1 account ban 2 global ban (ip)
BlockReason = you can set something like 1 = Bug Using 2 = Hack 3 = Insult etc... there is no importance for the login / ps : you can change column to text or something like it, if you want to add reason without 1 2 3 etc...

sendbanmail = ? certainly something using by web from old owner / useless for game login.

a update will coming for the database to simplify some table / functions.
some of column of this table is useless.

 

[tairasan]

ok thanks

 

[Jineman]

a new data updates is available on 4Ever Developpement Post