Hello i'm using IGCN - MuEMU S12 database ( http://forum.ragezone.com/f197/relea...eason-1146663/ )
I have questions about database columns and their possible values.
PHP Code:
protected $fillable = [
'memb___id', // Account name - varchar(10) - NOT NULL
'memb__pwd', // Password - varchar(20) - NOT NULL
'memb_name', // Real Name - varchar(10) - NOT NULL
'sno__numb', // Some kind of PIN? Must be 13 chars long. - char(13) - NOT NULL
'post_code', // City Post code - char(6) - NULLABLE
'addr_info', // Country - varchar(50) - NULLABLE
'addr_deta', // Address line - varchar(50) - NULLABLE
'tel__numb', // Home Phone number? - varchar(20) - NULLABLE
'phon_numb', // Mobile Phone number? - varchar(15) - NULLABLE
'mail_addr', // Email - varchar(50) - NULLABLE
'fpas_ques', // Secret Question - varchar(50) - NULLABLE
'fpas_answ', // Secret Answer - varchar(50) - NULLABLE
'job__code', // ? - char(2) - NULLABLE
'appl_days', // ? - datetime - NULLABLE
'modi_days', // ? - datetime - NULLABLE
'out__days', // ? - datetime - NULLABLE
'true_days', // ? - datetime - NULLABLE
'mail_chek', // Is Email validated - char(1) - NULLABLE
'bloc_code', // Is Account blocked? - char(1) - NOT NULL
'ctl1_code', // Game master code? - char(1) - NOT NULL
'cspoints', // PC Point shop point count? - int - NULLABLE
'VipType', // Vip Types - int - NULLABLE
'VipStart', // Starting date if VIP - datetime - NULLABLE
'VipDays', // Ending date for VIP? - datetime - NULLABLE
'JoinDate', // Date Joined - varchar(23) - NULLABLE
'created_at', // Account creation date - datetime - NULLABLE
'updated_at' // Last account change date - datetime - NULLABLE
];
My questions
What do these columns mean and what are their purpose
- sno__numb
- job__code
- appl_days,modi_days,out__days,true_days
- VipStart,VipDays
- cspoints
What are possible values for these columns
- VipType
- bloc_code
- ctl1_code
EDIT
Character table
What are possible values for these columns and meanings
- Class
- PkCount - Killed player count?
- PkLevel
- PkTime
- MDate
- LDate
- CtlCode
- ChatLimitTime
- PenaltyMask
- BlockChatTime
- Ruud
- PlayGuide