AAC how add premium time in mysql

[bpm91]

hello, I would like to know how to add in the premium time database. tfs 1.5

 

[Sarah Wesker]

-- Set 30 days
-- UPDATE accounts SET premium_ends_at = UNIX_TIMESTAMP() + 86400 * 30 WHERE id = 1;

-- Add 30 days
-- UPDATE accounts SET premium_ends_at = premium_ends_at + 86400 * 30 WHERE id = 1;

...

 

[Forkz]

-- Set 30 days
-- UPDATE accounts SET premium_ends_at = UNIX_TIMESTAMP() + 86400 * 30 WHERE id = 1;

-- Add 30 days
-- UPDATE accounts SET premium_ends_at = premium_ends_at + 86400 * 30 WHERE id = 1;

...

I used this code below, but all accounts had 7 days of premium account, how do I get accounts that already have premium to add +7 instead of all having 7?

UPDATE accounts SET premium_ends_at = UNIX_TIMESTAMP() + 86400 * 7

 

[Manigold]

UPDATE accounts
SET premium_ends_at = CASE
WHEN premium_ends_at IS NOT NULL THEN premium_ends_at + (86400 * 7)
ELSE UNIX_TIMESTAMP() + (86400 * 7)
END