[norton2]

Not updating the CURRENT_TIMESTAMP. (Use ORM)

Код HTML:

mysql_format(MySQLCon, query, sizeof(query), "UPDATE `safes` SET `SafeLastLog`=CURRENT_TIMESTAMP WHERE `ID`= '%d'", Safes[FactiuniSeif][ID]);
mysql_tquery(MySQLCon, query, "", "");

[Roberto80]

Mmm idk about mysql,but try to use getdate function,guide:https://sampwiki.blast.hk/wiki/Getdate

[norton2]

Also not updating "SafeLastLog" in DataBase MYSQL.

Код HTML:

new Year, Month, Day;
                    getdate(Year, Month, Day);
                    printf("%02d/%02d/%d", Day, Month, Year);
                     
                    new Days = getdate();
                    Safes[FactiuniSeif][SafeLastLog] = Days;
orm_update(Safes[FactiuniSeif][ORM_ID]);

[Sjn]

Use NOW() in your query format where you put the date. It gets the current date.

Код:

mysql_format(MySQLCon, query, sizeof(query), "UPDATE `safes` SET `SafeLastLog`=NOW() WHERE `ID`= '%d'", Safes[FactiuniSeif][ID]);

[Roberto80]

That sure it wont save/update!!!!
Use this:

Код:

new Year, Month, Day;
Safes[FactiuniSeif][SafeLastLog] = getdate(Year, Month, Day);
printf("%02d/%02d/%d", Day, Month, Year);
orm_update(Safes[FactiuniSeif][ORM_ID]);

[norton2]

Quote:

Originally Posted by Sjn Use NOW() in your query format where you put the date. It gets the current date. Код: mysql_format(MySQLCon, query, sizeof(query), "UPDATE `safes` SET `SafeLastLog`=NOW() WHERE `ID`= '%d'", Safes[FactiuniSeif][ID]);

Not Work!

Код HTML:

 mysql_format(MySQLCon, query, sizeof(query), "UPDATE `safes` SET `SafeLastLog`=NOW() WHERE `ID`= '%d'", Safes[FactiuniSeif][ID]);
mysql_tquery(MySQLCon, query, "", "");

[Vince]

Have you tried running the query manually? If that works then the problem is obviously something in your code. By the way, favor UTC_TIMESTAMP() over NOW().

[norton2]

Solved, thanks all, thank you Vince.!