Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[Help] Database structure MEMB_INFO

Experienced Elementalist
Joined
Jul 23, 2012
Messages
201
Reaction score
128
Hello i'm using IGCN - MuEMU S12 database ( http://forum.ragezone.com/f197/release-igcn-muemu-server-season-1146663/ )

I have questions about database columns and their possible values.

PHP:
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:
Back
Top