Hallo Community,
Ich habe ein Problem mit dem MySQL Plugin von StrickenKid (Sa-Mp.com).
und zwar bekomme ich immer diesen Error:
SQL
[Thu Mar 31 20:29:51 2011] Function: mysql_query executed: "INSERT INTO `user` (name, passwort, geld, bank, leader, member, admin, skin, job, drogen, payday, adminjail, jailzeit, geschlecht, levelpunkte, level) VALUES ('Verti4cal', '1F26EE2A8F542B49BB6C8A0637B4EECE', 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 1);" with result: "1".
[Thu Mar 31 20:29:51 2011] Error (0): Failed to exeute query. Column count doesn't match value count at row 1.phpMyAdmin Screen:
Das ist mein Code:
new query[512];
format(query, sizeof(query), "INSERT INTO `user` (name, passwort, geld, bank, leader, member, admin, skin, job, drogen, payday, adminjail, jailzeit, geschlecht, levelpunkte, level) VALUES ('%s', '%s', %d, %d, 0, 0, 0, %d, 1, 0, 0, 0, 0, 0, %d, 0, 1);", Spielername(playerid), passwortx, Player[playerid][geld], Player[playerid][bank], Player[playerid][Skin], Player[playerid][Geschlecht]);
mysql_query(query);
mysql_store_result();
mysql_free_result();
Mit freundlichen Grüßen,
Darkness321
