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!
Check your [dbo].[cabal_sp_auth] / [dbo].[cabal_sp_auth_netcafe] procedure(s) within the [Account] database.
Whatever service you consider the default one for your server can be auto extended by using something like:
IF @rExpireDate < GETDATE()
BEGIN
UPDATE cabal_charge_auth SET ServiceKind = '1', ExpireDate = DATEADD(MONTH,12,GETDATE()) WHERE UserNum = @rusernum
SET @rServiceKind = '1'
SET @rExpireDate = DATEADD(MONTH,12,GETDATE())
END
Note that ServiceKind 1 serves as mere example here as that's probably what most use as kind of a default.
The above will add 12 months to the duration of the service once the current one is expired and change the premium type to whichever one you want.