[Score]

Hello, i have made a kick system and if you kick the player it should display on the database, but there's a problem.

Here is the code:

PHP код:

mysql_format(Database, DB_Query, sizeof(DB_Query), "INSERT INTO `kicks` (`Name`, `KickedBy`, `Reason`, `IpAddress`)\
     VALUES (`%s`, `%s`, `%s`, `%s`)", GetPlayerNameEx(giveplayerid), GetPlayerNameEx(playerid), reason, playerip);
    mysql_tquery(Database, DB_Query); 


There was no errors when i compiled it, but it just doesn't insert the data into the "kicks" table.

[Kane]

Don't use backticks for values. It's suppose to be an apostrophe.

Also, use '%e' to escape strings.

[Score]

Quote:

Originally Posted by Arthur Kane Don't use backticks for values. It's suppose to be an apostrophe. Also, use '%e' to escape strings.

PHP код:

mysql_format(Database, DB_Query, sizeof(DB_Query), "INSERT INTO `kicks` (`Name`, `KickedBy`, `Reason`, `IpAddress`)\
     VALUES (%e, %e, %e, %e)", GetPlayerNameEx(giveplayerid), GetPlayerNameEx(playerid), reason, playerip);
    mysql_tquery(Database, DB_Query); 


So this should work?

[Dayrion]

'%e' instead of %e and it should work, yes.

[Score]

It works, thanks