- Joined
- Aug 23, 2010
- Messages
- 1,544
- Reaction score
- 422
# Add function Press players buy premium. The items we set.
------------------------------------------------------------------------
#Search with Navicat. Connect to SQL before start
Functions > WZ_BuyItemFN_Exec
Look for
-- premium subscription
if(@in_ItemId = 301257) begin
update UsersData set PremiumExpireTime=DATEADD(month, 1, GETDATE()) where CustomerID=@in_CustomerID
----------------------------------------------------------------------------
#Add a premium to buy premium.
exec FN_AddItemToUser @in_CustomerID, 101087, 20000 //AW Magnum
exec FN_AddItemToUser @in_CustomerID, 101336, 20000 //Katana
exec FN_AddItemToUser @in_CustomerID, 101173, 20000 //IMI TAR-21
----------------------------------------------------------------------------
------------------------------------------------------------------------
#Search with Navicat. Connect to SQL before start
Functions > WZ_BuyItemFN_Exec
Look for
-- premium subscription
if(@in_ItemId = 301257) begin
update UsersData set PremiumExpireTime=DATEADD(month, 1, GETDATE()) where CustomerID=@in_CustomerID
----------------------------------------------------------------------------
#Add a premium to buy premium.
exec FN_AddItemToUser @in_CustomerID, 101087, 20000 //AW Magnum
exec FN_AddItemToUser @in_CustomerID, 101336, 20000 //Katana
exec FN_AddItemToUser @in_CustomerID, 101173, 20000 //IMI TAR-21
----------------------------------------------------------------------------
Code:
Example.
-- premium subscription
if(@in_ItemId = 301257) begin
update UsersData set PremiumExpireTime=DATEADD(month, 1, GETDATE()) where CustomerID=@in_CustomerID
exec FN_AddItemToUser @in_CustomerID, 101087, 20000 //AW Magnum
exec FN_AddItemToUser @in_CustomerID, 101336, 20000 //Katana
exec FN_AddItemToUser @in_CustomerID, 101173, 20000 //IMI TAR-21
return
end