[HELP]Where is the src of Daily Premium Bonus?

Results 1 to 5 of 5
  1. #1
    Apprentice aummua is offline
    MemberRank
    Jun 2016 Join Date
    17Posts

    shout [HELP]Where is the src of Daily Premium Bonus?

    Where is the src of Daily Premium Bonus?
    can i change a daily bonus GC to item?


  2. #2
    Account Upgraded | Title Enabled! Oosmar02 is offline
    MemberRank
    Sep 2013 Join Date
    FranceLocation
    894Posts

    Re: [HELP]Where is the src of Daily Premium Bonus?

    In function database
    WZ_LOGIN_EXEC like this

  3. #3
    Member kukk1 is offline
    MemberRank
    Dec 2015 Join Date
    Cold NorthLocation
    67Posts

    Re: [HELP]Where is the src of Daily Premium Bonus?

    Quote Originally Posted by aummua View Post
    Where is the src of Daily Premium Bonus?
    can i change a daily bonus GC to item?
    In the function oosmar said. What you would want to change is:
    Code:
    -- give premium GC bonuses every 24hrs (actually every 23:30)    
    if @premiumExpireTime > GETDATE() and DATEDIFF(minute, @premiumLastBonus, GETDATE()) > 1410) begin        
         exec FN_AlterUserGP @CustomerID, 30, 'Daily Premium Bonus'        
         update UsersData set PremiumLastBonus=GETDATE() where CustomerID @CustomerID    
    end
    Give item function would be the one you want :p

  4. #4
    Apprentice aummua is offline
    MemberRank
    Jun 2016 Join Date
    17Posts

    Re: [HELP]Where is the src of Daily Premium Bonus?

    thank you @Oosmar02 @kukk1

    but my DB don't have
    WZ_LOGIN_EXEC function.

    how to find it?
    Last edited by aummua; 24-03-17 at 11:30 AM.

  5. #5
    Member kukk1 is offline
    MemberRank
    Dec 2015 Join Date
    Cold NorthLocation
    67Posts

    Re: [HELP]Where is the src of Daily Premium Bonus?

    Quote Originally Posted by aummua View Post
    thank you @Oosmar02 @kukk1

    but my DB don't have
    WZ_LOGIN_EXEC function.

    how to find it?
    Are you using a sql server manager? (ie Navicat). Or are you just opening ms sql manager? If so get navicat (free trial: https://www.navicat.com/download/navicat-premium)
    It is located in WarZ->dbo->functions



Advertisement