2015 may bug it?
#9

look at this : http://dev.mysql.com/doc/refman/5.1/...unix-timestamp
pawn Код:
format(Query, sizeof(Query), "SELECT UNIX_TIMESTAMP(LastLogin) FROM `Users` WHERE `Username` = '%s' LIMIT 0, 1", DB_Escape(hInfo[h][Owner]));
Result = db_query(Database, Query);
if(db_num_rows(Result))
{
    db_get_field_assoc(Result, "LastLogin", Date, 32);

    if(gettime() - strval(Date) >= 5259486) // 60 days = 5259486 secconds
    {
        hInfo[h][IsOwnerInactive] = 1;
        LoadedInactiveHouses++;
    }
}
db_free_result(Result);
Reply


Messages In This Thread
2015 may bug it? - by ]Rafaellos[ - 08.01.2015, 06:35
Re: 2015 may bug it? - by Spookieman - 08.01.2015, 07:46
Re: 2015 may bug it? - by ]Rafaellos[ - 08.01.2015, 07:50
Re: 2015 may bug it? - by Jessyy - 08.01.2015, 08:13
Re: 2015 may bug it? - by ]Rafaellos[ - 08.01.2015, 09:13
Re: 2015 may bug it? - by rickisme - 08.01.2015, 09:31
Re: 2015 may bug it? - by ]Rafaellos[ - 08.01.2015, 09:47
Re: 2015 may bug it? - by BroZeus - 08.01.2015, 09:56
Re: 2015 may bug it? - by rickisme - 08.01.2015, 10:04

Forum Jump:


Users browsing this thread: 2 Guest(s)