[User Vip] - Description of SQL Table

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'