[reinert]

Hey, I've one question.

I've got system that when you send SMS you get privileges for 30 days...

I would like to make such thing like extend your privileges...

So if player already has privileges then it will extend them for 30days...

Right now I've got this:

PHP Code:

$laikas = time() + 2592000;
$paring="UPDATE players SET sth=1 expire_date='".$laikas."' WHERE players.id='".$message."')"; 


So what shall I do to make that the old expire_date + 30days (unix time: 2592000)

Should I check if expire_date is 0 then just add it how it was, and else then expire_date=expire_date+2592000 ???

[minimiller]

If you're trying to do what i think you're trying to do, you need a SELECT statement to get their old 'expire_date', add 2592000 to that and then do your UPDATE

[reinert]

How about this:

Use now() instead of time() which gets time in unix it's more human-able :d

PHP Code:

$aa = mysql_query("SELECT expire_time FROM players WHERE players.id='".$message."'); 


PHP Code:

if($aa = 0)
{
   $paring="UPDATE players SET sth=1 expire_date=DATA_ADD(NOW(), INTERVAL 30 DAY) WHERE players.id='".$message."')";
}else{
   $paring="UPDATE players SET sth=1 expire_date=DATA_ADD($aa, INTERVAL 30 DAY) WHERE players.id='".$message."')";
} 


EDIT: How about this: ??

PHP Code:

$paring="
   UPDATE players
      SET sth = 1,
         expire_date = DATA_ADD(IF(expire_date = 0, NOW(), expire_date), INTERVAL 30 DAY)
   WHERE players.id = '" . $message . "'"; 


By the way, how to get expire_date correctly ???

this:

DATA_ADD(IF(expire_date = 0,'NOW()', SELECT expire_date FROM players WHERE players.id='".$message."'), INTERVAL 30 DAY)

??

[Exolent[jNr]]

You could test to see if it works instead of asking.

[reinert]

I don't have where to test...

[matsi]

Originally Posted by reinert I don't have where to test...

How about the computer you're now using?

[reinert]

Nah, it's not working because my ports cannot be forwarded...

[8088]

What about http://localhost? If you can't test it, what do you need the code for then?

[meTaLiCroSS]

XAMPP?

[matsi]

Originally Posted by reinert Nah, it's not working because my ports cannot be forwarded...

...