Login & Register schreibt nichts in die Datenbank!

Grapefruit · 4. Februar 2015

Guten Tag,
wie oben mein problem schon geschildert wurde, wird beim Registrieren nichts in die Datenbank geschrieben.

new query[256], pass[50];
if(dialogid == DIALOG_REGISTER)
{
if(!response) return Kick(playerid);
if(strlen(inputtext) < 4) return ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, "Registrierung", "Sie haben noch keinen Account, bitte erstellen sie sich eins!", "Register", "Abbrechen");
format(pass, sizeof(pass), "%s", inputtext);
mysql_escape_string(UserName(playerid), UserName(playerid));
mysql_escape_string(pass, pass);
format(query, sizeof(query), "INSERT INTO (Username, Password) VALUES ('%s', MD5('%s'))", UserName(playerid), pass);
mysql_tquery(handle, query);
}

H4rd_B4se · 4. Februar 2015

Du hast bei der Query auch keine Tabelle angegeben

Grapefruit · 4. Februar 2015

format(query, sizeof(query), "INSERT INTO user (Username, Password) VALUES ('%s', MD5('%s'))", UserName(playerid), pass);
Hab das jetzt so, leider hat sich nichts verändert.

Akino Kiritani · 4. Februar 2015

was sagt denn deine mysql log ?

Grapefruit · 4. Februar 2015

[21:26:49] [DEBUG] mysql_errno - connection: 1
[21:26:49] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[21:26:49] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[21:26:49] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[21:26:49] [DEBUG] CMySQLConnection::Connect - connection was successful
[21:26:49] [DEBUG] CMySQLConnection::Connect - connection was successful
[21:26:49] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[21:26:49] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[21:27:11] [DEBUG] mysql_escape_string - source: "Grapefruit", connection: 1, max_len: 24
[21:27:11] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM user WHERE Username=''", callback: "CheckUser", format: "i"
[21:27:11] [DEBUG] CMySQLQuery::Execute[CheckUser] - starting query execution
[21:27:11] [DEBUG] CMySQLQuery::Execute[CheckUser] - query was successfully executed within 0.283 milliseconds
[21:27:11] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[21:27:11] [DEBUG] Calling callback "CheckUser"..
[21:27:11] [DEBUG] cache_get_data - connection: 1
[21:27:11] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[21:27:25] [DEBUG] mysql_escape_string - source: "Grapefruit", connection: 1, max_len: 24
[21:27:25] [DEBUG] mysql_escape_string - source: "12345", connection: 1, max_len: 50
[21:27:25] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO user (Username, Password) VALUES ('Grapefruit', '123", callback: "(null)", format: "(null)"
[21:27:25] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[21:27:25] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 34.330 milliseconds
[21:27:25] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving

Jeffry · 5. Februar 2015

Auf Anfrage in PN:
Laut Log wird alles korrekt eingetragen, es gibt keinen Error und keine Warnung.
Hast du die Ansicht der Datenbank mal aktualisiert? Bist du auch an der richtigen Datenbank angemeldet?

Mellnik · 5. Februar 2015

Gib die Query doch mal in phpMyAdmin SQL dings ein...

Grapefruit · 6. Februar 2015

Mein Fehler hatte die falsche Datenbank aufgerufen. Beim registrieren wird der Spieler gespeichert, aber es wird nicht erkannt ob er schon ein Account hat.

new num_rows, num_fields;
cache_get_data(num_rows, num_fields, handle);
if(num_rows == 0)
{
ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT, "Registrierung", "Sie haben noch keinen Account, bitte erstellen sie sich eins!", "Register", "Abbrechen");
}
else
{
ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Login", "Ihr Account wurde erfolgreich in der Datenbank gefunden! Bitte logge Sie sich in ihr Account ein!", "Login", "Abbrechen");
}

Jeffry · 6. Februar 2015

Poste bitte den Code des SELECT's, das du bei OnPlayerConnect (?) stehen hast. Der SELECT eben, der dann auf den obigen Code zugreift.

Grapefruit · 6. Februar 2015

new query[100];
mysql_escape_string(UserName(playerid), UserName(playerid));
format(query, sizeof(query), "SELECT * FROM user WHERE Username='%s'", PlayerInfo[playerid][pUsername]);
mysql_pquery(handle, query, "CheckUser", "i", playerid);

Jeffry · 6. Februar 2015

mysql_escape_string(UserName(playerid), UserName(playerid));
zu:
mysql_escape_string(UserName(playerid), PlayerInfo[playerid][pUsername]);

Grapefruit · 6. Februar 2015

Er findet immer noch mein Account nicht.

Jeffry · 6. Februar 2015

Was sagt der MySQL Log, wenn du den Server betrittst?

Grapefruit · 6. Februar 2015

Bekomme diesen Error in der MySQL Log
[21:41:51] [ERROR] mysql_escape_string - destination size is too small (must be at least as big as source)

Jeffry · 6. Februar 2015

Dann schreibe es so:
new query[100], name[MAX_PLAYER_NAME];
GetPlayerName(playerid, name, MAX_PLAYER_NAME);
mysql_escape_string(name, name);
format(PlayerInfo[playerid][pUsername], MAX_PLAYER_NAME, name);
format(query, sizeof(query), "SELECT * FROM user WHERE Username='%s'", PlayerInfo[playerid][pUsername]);
mysql_pquery(handle, query, "CheckUser", "i", playerid);

Grapefruit · 6. Februar 2015

"INSERT INTO user (Username, Password) VALUES ('%s', MD5('%s'))"
Hier wird das Passwort in MD5 umgewandelt, aber wo wandel ich das beim Login um?

Jeffry · 6. Februar 2015

Du machst einfach einen SELECT auf das Passwort und den Username.

SQL

SELECT * FROM user where Username = '%s' AND Passwort = MD5('%s');

Grapefruit · 6. Februar 2015

Das hatte ich schon probiert, hat aber leider nicht funktioniert.

Jeffry · 6. Februar 2015

Was sagt der MySQL Log dazu?
Ansonsten könntest du noch das Plugin nutzen, um den inputtext zu konvertieren:
Passwörter per Md5 verschlüsseln

Grapefruit · 6. Februar 2015

[22:08:00] [DEBUG] mysql_escape_string - source: "Grapefruit", connection: 1, max_len: 24
[22:08:00] [DEBUG] mysql_escape_string - source: "12345", connection: 1, max_len: 50
[22:08:00] [DEBUG] mysql_pquery - connection: 1, query: "INSERT INTO user (Username, Password) VALUES ('Grapefruit', MD5(", callback: "(null)", format: "(null)"
[22:08:00] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[22:08:00] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 28.303 milliseconds
[22:08:00] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[22:08:25] [DEBUG] mysql_escape_string - source: "Grapefruit", connection: 1, max_len: 24
[22:08:25] [DEBUG] mysql_pquery - connection: 1, query: "SELECT * FROM user WHERE Username='Grapefruit'", callback: "CheckUser", format: "i"
[22:08:25] [DEBUG] CMySQLQuery::Execute[CheckUser] - starting query execution
[22:08:25] [DEBUG] CMySQLQuery::Execute[CheckUser] - query was successfully executed within 0.450 milliseconds
[22:08:25] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[22:08:25] [DEBUG] Calling callback "CheckUser"..
[22:08:25] [DEBUG] cache_get_data - connection: 1
[22:08:25] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[22:08:28] [DEBUG] mysql_escape_string - source: "Grapefruit", connection: 1, max_len: 24
[22:08:28] [DEBUG] mysql_escape_string - source: "12345", connection: 1, max_len: 50
[22:08:28] [DEBUG] mysql_pquery - connection: 1, query: "SELECT * FROM user WHERE Username='Grapefruit' AND Password = MD", callback: "OnPasswordResponse", format: "i"
[22:08:28] [DEBUG] CMySQLQuery::Execute[OnPasswordResponse] - starting query execution
[22:08:28] [DEBUG] CMySQLQuery::Execute[OnPasswordResponse] - query was successfully executed within 0.350 milliseconds
[22:08:28] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[22:08:28] [DEBUG] Calling callback "OnPasswordResponse"..
[22:08:28] [DEBUG] cache_get_data - connection: 1
[22:08:28] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

[22:08:28] [DEBUG] mysql_pquery - connection: 1, query: "SELECT * FROM user WHERE Username='Grapefruit' AND Password = MD", callback: "OnPasswordResponse", format: "i"