Sign in to follow this  
Followers 0
tomassk89

VIP Status for multiserver on website FIX!

1 post in this topic

Someone might have noticed that if you are running multiservers on the same host with same website then it will not display the VIP status on the web but it will work in-game.

So easy fix is just go to your website Files   web/application/config/vip_query_config.json

And edit:

IGCN:

        "igcn":{
            "title":"IGCN Vip",
            "db":"account",  to  "db":"character",
            "check":"SELECT Date, Type FROM T_VIPList WHERE AccountID = :account",
            "update":"UPDATE T_VIPList SET Date = :until_date, Type = :type WHERE AccountID = :account",
            "insert":"INSERT INTO T_VIPList (AccountID, Date, Type) VALUES (:account, :until_date, :type)",
            "vip_codes":{
                "vip_bronze":{
                    "title":"Bronze",
                    "code": 1
                },
                "vip_silver":{
                    "title":"Silver",
                    "code": 2
                },
                "vip_gold":{
                    "title":"Gold",
                    "code": 3
                },
                "vip_platinum":{
                    "title":"Platinum",
                    "code": 4
                }
            }
        },

 

ZTEAM:

        "zteam":{
            "title":"Z-Team Vip",
            "db":"account",  to  "db":"character",
            "check":"SELECT ExpireDate AS Date, PayCode AS Type FROM PremiumData WHERE AccountID = :account",
            "update":"UPDATE PremiumData SET ExpireDate = :until_date WHERE AccountID = :account",
            "insert":"INSERT INTO PremiumData (AccountID, ExpireDate, PayCode) VALUES (:account, :until_date, :type)",
            "vip_codes":{
                "vip_bronze":{
                    "title":"Bronze",
                    "code": 1
                },
                "vip_silver":{
                    "title":"Silver",
                    "code": 2
                },
                "vip_gold":{
                    "title":"Gold",
                    "code": 3
                }
            }
        },

XTEAM:

        "xteam":{
            "title":"X-Team Vip",
            "db":"account",  to  "db":"character",
            "check":"SELECT AccountExpireDate AS Date, AccountLevel AS Type FROM MEMB_INFO WHERE memb___id = :account",
            "update":"UPDATE MEMB_INFO SET AccountExpireDate = :until_date, AccountLevel = :type WHERE memb___id = :account",
            "insert":"",
            "vip_codes":{
                "vip_bronze":{
                    "title":"Bronze",
                    "code": 1
                },
                "vip_silver":{
                    "title":"Silver",
                    "code": 2
                },
                "vip_gold":{
                    "title":"Gold",
                    "code": 3
                }
            }
        },

MUENGINE:

        "muengine":{
            "title":"MuEngine Vip",
            "db":"account",  to  "db":"character",
            "check":"SELECT vipstamp AS Date FROM MEMB_INFO WHERE memb___id = :account",
            "update":"UPDATE MEMB_INFO SET vipstamp = :until_date WHERE memb___id = :account",
            "insert":"",
            "vip_codes":{}
        }
    }
}

 

This fix is for those who Use ME_MuOnline database for their accounts.

Therefore the website reads ME_MuOnline for accounts info and MuOnline Database is used for Character Database

And in this case VIP settings are located in Character Database 

Say thanks if i helped :)

1 person likes this

Share this post


Link to post
Share on other sites
Sign in to follow this  
Followers 0