[Loinal]

Hi, i wanted to add Last login to /stats, actually i have added it but when i try to update it every login i get weird number

Code:

PHP код:

new dayx, monthx, yearx, query[280];
    getdate(yearx, monthx, dayx);
    format(pData[playerid][RLastLogin], 12, "%d/%d/%d", dayx, monthx, yearx);
    mysql_format(mysql, query, sizeof(query), "UPDATE `players` SET `RLastLogin` = %e WHERE `ID` = %d", 
        pData[playerid][RLastLogin], pData[playerid][ID]);
    mysql_tquery(mysql, query); 


After update the query:

Код:

Last Login: 0.007433102

[iLearner]

PHP код:

mysql_format(mysql, query, sizeof(query), "UPDATE `players` SET `RLastLogin` = '%e' WHERE `ID` = %d",  
        pData[playerid][RLastLogin], pData[playerid][ID]); 
    mysql_tquery(mysql, query); 


[Loinal]

Quote:

Originally Posted by iLearner PHP код: mysql_format(mysql, query, sizeof(query), "UPDATE `players` SET `RLastLogin` = '%e' WHERE `ID` = %d",           pData[playerid][RLastLogin], pData[playerid][ID]);      mysql_tquery(mysql, query);

Thanks i didn't notice that