[AntonioCroatia]

Hi, I have this code:

Код:

...
format(ELinija, sizeof(ELinija), "INSERT INTO cmds VALUES ('%i:%i/%i.%i.%i', '/givecash', '%s', '%i', '%s')", sat, minuta, dan, mjesec, godina, APlayerData[playerid][PlayerName], Money, OtherName);
mysql_query(ELinija);

I want to convert it to R7 code, coz my host is now Linux, and it have some bugs wit R5 and R7 MySQL plugin.

[IPrototypeI]

Quote:

Originally Posted by AntonioCroatia Hi, I have this code: Код: ... format(ELinija, sizeof(ELinija), "INSERT INTO cmds VALUES ('%i:%i/%i.%i.%i', '/givecash', '%s', '%i', '%s')", sat, minuta, dan, mjesec, godina, APlayerData[playerid][PlayerName], Money, OtherName); mysql_query(ELinija); I want to convert it to R7 code, coz my host is now Linux, and it have some bugs wit R5 and R7 MySQL plugin.

if you use R7 then you can upgrade to r34 or r35.
download:
https://github.com/pBlueG/SA-MP-MySQL/releases

You can use then mysql_tquery or mysql_query. In the R7 Version there is only the function mysql_function_query and there `re a lot of bugs which are fixed in the newer versions.

A little Tip you can set the attribut of your column where you save the date to the date and then you can use the sql-command NOW(). And your INSERT-command is wrong.

Syntax:

Код:

INSERT INTO table (column1,column2...) VALUES (value1,value2 ...);