[User Vip] - Description of SQL Table

Discussion in 'FAQ / Guides / Мануалы' started by Fr3DBr, Aug 13, 2011.

Thread Status:
Not open for further replies.
  1. Fr3DBr

    Fr3DBr Guest

    Hello,

    Here we have a brief explanation of how the user_vip table works :

    We have the following fields :

    char_id - character id which have the vip privilege
    exprate - default 1 (1x) - multiplier type (accept decimal)
    sprate - default 1 (1x) - multiplier type (accept decimal)
    spoilrate - default 1 (1x) - multiplier type (accept decimal)
    droprate - default 1 (1x) - multiplier type (accept decimal)
    vitrate - default 1 (1x) - multiplier type (accept decimal)
    namecolor - default 0 (disabled) or BGR (l2 color standard)
    titlecolor - default 0 (disabled) or BGR (l2 color standard)
    expirein - date format (windows date) [vip privilege expire date]
    offlineshop - 0 off / 1 on
    autopickup - 0 off / 1 on
    buffer - not used
    locksystem - 0 off / 1 on
    adenarate - default 1 (1x) - multiplier type (accept decimal)

    PS : After modifying this table the character just need to relogin to apply the new settings !

    Small considerations :

    - In a party, only the character which have the VIP exp / sp / vit rates as privilege will get the benefit, that means other players will remain with the normal rates, unless they are 'also' VIP.
    - The same said above, apply to the traditional premium account system. (l2server.ini -> [PremiumUser])
    - Drop Rate (do not affect amount, this is chance based only).
    - Spoil Rate (do not affect amount, this is chance based only).

    This will only work, after you enable that system in 'GeneralSettings.ini'
     
Thread Status:
Not open for further replies.