- 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!
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