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

[aummua]

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

 

[Oosmar02]

In function database
WZ_LOGIN_EXEC like this

 

[kukk1]

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:

-- give premium GC bonuses every 24hrs (actually every 23:30)    
if @[I][B][URL="http://forum.ragezone.com/members/43741.html"]prem[/URL][/B][/I]iumExpireTime > GETDATE() and DATEDIFF(minute, @[I][B][URL="http://forum.ragezone.com/members/43741.html"]prem[/URL][/B][/I]iumLastBonus, GETDATE()) > 1410) begin        
     exec [COLOR=#ff0000][B]FN_AlterUserGP[/B][/COLOR] @[I][B][URL="http://forum.ragezone.com/members/25895.html"]Custom[/URL][/B][/I]erID, 30, 'Daily Premium Bonus'        
     update UsersData set PremiumLastBonus=GETDATE() where CustomerID @[I][B][URL="http://forum.ragezone.com/members/25895.html"]Custom[/URL][/B][/I]erID    
end

Give item function would be the one you want

 

[aummua]

thank you @Oosmar02 @kukk1

but my DB don't have WZ_LOGIN_EXEC function.

how to find it?

 

[kukk1]

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:

You must be registered to see links

)
It is located in WarZ->dbo->functions