[MySQL R4] INSERT fail
#1

Here is the Code:

public CreatePlayerAccount(playerid, password[])
{
new sql_abfrage[212];
format(sql_abfrage, sizeof(sql_abfrage), "INSERT INTO `spieler` (id, name, password, money) VALUES (NULL, '%s', MD5(\"%s\"), '%d');", Name(playerid), password, GetMoneyFromPlayer(playerid));
mysql_real_escape_string(sql_abfrage, sql_abfrage, Id(playerid));
mysql_query(sql_abfrage, -1, Id(playerid));
return 1;
}

Result: e.g.
Quote:

INSERT INTO `spieler` (id, name, password, money) VALUES (NULL, 'Seibay', MD5("Test"), '1500');

In phpmyadmin it works, but here not.
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)