premium

how to add premium into an account with the end date for sql?

here a procedure for you

Code:

---

CREATE PROCEDURE [dbo].[cabal_tool_setPremium] (@UserNum int, @Days int)
AS
begin tran
        insert into cabal_charge_auth(usernum, type, expiredate, payminutes)
        values(@UserNum, 5, DATEADD(day, @Days, getdate()), 0)
commit

---

add them to Account table
and you can easy give a user premium