[Snippet] Buy premium and get the items/weapons set

**djbadboys38** · 10-12-17

# 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
----------------------------------------------------------------------------

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