[Help] Database structure MEMB_INFO

Results 1 to 1 of 1
  1. #1
    Digital Horizon KristiansJ is offline
    MemberRank
    Jul 2012 Join Date
    203Posts

    [Help] Database structure MEMB_INFO

    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
    1. sno__numb
    2. job__code
    3. appl_days,modi_days,out__days,true_days
    4. VipStart,VipDays
    5. cspoints

    What are possible values for these columns
    1. VipType
    2. bloc_code
    3. ctl1_code


    EDIT

    Character table
    What are possible values for these columns and meanings
    1. Class
    2. PkCount - Killed player count?
    3. PkLevel
    4. PkTime
    5. MDate
    6. LDate
    7. CtlCode
    8. ChatLimitTime
    9. PenaltyMask
    10. BlockChatTime
    11. Ruud
    12. PlayGuide
    Last edited by KristiansJ; 22-06-19 at 01:07 PM.




Advertisement