• Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook page for updates, we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.) When you see an Incapsula error, you know we are in the process of migration.

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

Custom Title Activated
Loyal Member
Joined
Aug 23, 2010
Messages
1,544
Reaction score
423
# 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
 
Back
Top