[ecca]

Well, im trying to compare a date in my database against the current date. But when i do that it only said to run code even if it isnt same date as in database, so when the current date is past the date in database i want to run this but it only runs whole time xD?

PHP Code:

decl String:expire[255];
            
SQL_FetchString(hndl, 3, expire, sizeof(expire));
            
new tima = StringToInt(expire);
decl String:idag[100];
FormatTime(idag, sizeof(idag), "%d/%m/%Y", GetTime());
new time = StringToInt(idag);
            
if (tima <= time)
{
    //do something
} 


any suggestions?

[McFlurry]

An example of what FormatTime would give you today, "04/01/2012"
You see that? StringToInt doesn't recognize division, and I'm pretty sure you don't want that to be divided. StringToInt would error and give you 0 for time. It's probably safe to store times as timestamps instead.

Edit: Why are you supplying FormatTime with the current timestamp? It already gives you the current date if the stamp parameter is left empty.

[ecca]

Can you give me an example how i can check instead with timestamps

The date today is 04/01/2012 and in the db its 04/03/2012

[McFlurry]

Generate a timestamp for that date here. Then simply retrieve the timestamp from the database as an int and compare it to GetTime()'s return value.

[ecca]

But its diffrent dates, in database, some players got 04/06/2012 and so on

[McFlurry]

The timestamp is just a number of seconds that have passed since the UNIX epoch. You can do 60*60*24 and it to a timestamp to add a full day, and vice versa with subtraction. You'll have to modify the expiration dates for your players from now on.

[ecca]

Isnt there any other way, im pretty sure it can work with formattime

[thetwistedpanda]

Use timestamps, they're universal.

http://www.unixtimestamp.com/index.php

[ecca]

I dont get the timestamp, i really want to use realdate

[McFlurry]

What isn't there to get, the timestamp is just the number of seconds that have passed since the UNIX epoch (January 1, 1970 00:00:00 UTC).