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!

Help - Premium Automatic free.

Newbie Spellweaver
Joined
Jun 11, 2012
Messages
33
Reaction score
0
Hello everyone, I need help!
I am installing a premium paid system on my server, but I do not find the correct procedure where it does the verification if the user's vip has expired.

Something similar I found in Cabal_sp_Auth, but anyway it did not work.
code I created


I would like to know how can I change the type and date automatically from the user's premium expiration?

Who can help me, please, thank you from now on!

sorry for my English!
Code:
DECLARE [USER=747004]RSE[/USER]rviceKind as int        -- 0: free, 1: charged
DECLARE [USER=381074]rex[/USER]pireDate as DATETIME
			SELECT ServiceKind, ExpireDate
         FROM cabal_charge_auth WHERE UserNum = [USER=1333418107]RUser[/USER]num
			IF @@ROWCOUNT = 1
				BEGIN
				UPDATE cabal_charge_auth
				SET ServiceKind = 0, ExpireDate = GETDATE() + 1000
				WHERE UserNum = [USER=1333418107]RUser[/USER]num;
				END
 
Back
Top