• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

AAC how add premium time in mysql

Solution
Sarah Wesker
LUA: 
-- Set 30 days
-- UPDATE accounts SET premium_ends_at = UNIX_TIMESTAMP() + 86400 * 30 WHERE id = 1;

LUA: 
-- Add 30 days
-- UPDATE accounts SET premium_ends_at = premium_ends_at + 86400 * 30 WHERE id = 1;
...
Sort by date Sort by votes
LUA: 
-- Set 30 days
-- UPDATE accounts SET premium_ends_at = UNIX_TIMESTAMP() + 86400 * 30 WHERE id = 1;

LUA: 
-- Add 30 days
-- UPDATE accounts SET premium_ends_at = premium_ends_at + 86400 * 30 WHERE id = 1;
...
 
Upvote 0 Downvote
Solution
Sarah Wesker said:
LUA: 
-- Set 30 days
-- UPDATE accounts SET premium_ends_at = UNIX_TIMESTAMP() + 86400 * 30 WHERE id = 1;

LUA: 
-- Add 30 days
-- UPDATE accounts SET premium_ends_at = premium_ends_at + 86400 * 30 WHERE id = 1;
...
Click to expand...
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?

PHP: 
UPDATE accounts SET premium_ends_at = UNIX_TIMESTAMP() + 86400 * 7
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
Back
Top