Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

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

Custom Title Activated
Loyal Member
Joined
Aug 23, 2010
Messages
1,543
Reaction score
416
# 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