Help - Premium Automatic free.

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 @RSErviceKind as int        -- 0: free, 1: charged
DECLARE @rexpireDate as DATETIME
                        SELECT ServiceKind, ExpireDate
        FROM cabal_charge_auth WHERE UserNum = @RUsernum
                        IF @@ROWCOUNT = 1
                                BEGIN
                                UPDATE cabal_charge_auth
                                SET ServiceKind = 0, ExpireDate = GETDATE() + 1000
                                WHERE UserNum = @RUsernum;
                                END

---

Please, can someone help me!

PLEASE SEE THIS GUIDE :)