Guten Tag,
da mein PC Schrott gegangen ist schreibe ich von Null an, leider wird kein Eintrag in meiner Datenbank erstellt.
Der print wird mir richtig ausgegeben, aber nichts in der Datenbank geschrieben.
C
stock Register(playerid, key[])
{
new query[512];
format(query, sizeof(query), "INSERT INTO `Accounts` (`Name`, `Passwort`), VALUES ('%s', '%s')", SpielerName(playerid), key);
db_query(Datenbank, query);
SetPlayerScore(playerid, 1);
GivePlayerMoney(playerid, 1500);
SetPVarInt(playerid, "Eingeloggt", 1);
return 1;
}
stock Login(playerid, key[])
{
new DBResult:Result, string[512], rows;
#pragma unused rows
format(string, sizeof(string), "SELECT * FROM `Accounts` WHERE Name = '%s' AND Passwort = '%s'", SpielerName(playerid), key);
Result = db_query(Datenbank, string);
if(db_num_rows(Result) > 0)
{
SpielerLaden(playerid);
SetPVarInt(playerid, "Eingeloggt", 1);
return 1;
}
else
{
ShowPlayerDialog(playerid, DIALOG_EINLOGGEN, DIALOG_STYLE_PASSWORD, "Login Fenster", "Das Passwort ist Falsch!", "Login", "Abbrechen");
}
return 1;
}
stock SpielerSpeichern(playerid)
{
if(GetPVarInt(playerid, "Eingeloggt") == 1)
{
new query[512];
format(query, sizeof(query), "UPDATE `Accounts` SET `Level` = '%i', `Bargeld` = '%i' WHERE `Name` = '%s'", GetPlayerScore(playerid), GetPlayerMoney(playerid), SpielerName(playerid));
printf("Speichern: %s", query);
db_query(Datenbank, query);
}
return 1;
}
stock SpielerLaden(playerid)
{
ResetPlayerMoney(playerid);
SetPVarInt(playerid, "Eingeloggt", 1);
new DBResult:Result, string[75], rows;
#pragma unused rows
format(string, sizeof(string), "SELECT * FROM `Accounts` WHERE `Name` = '%s'", SpielerName(playerid));
Result = db_query(Datenbank, string);
db_get_field_assoc(Result, "Level", string, sizeof(string));
SetPlayerScore(playerid, strval(string));
db_get_field_assoc(Result, "Bargeld", string, sizeof(string));
GivePlayerMoney(playerid, strval(string));
return 1;
}MfG. Black_Air 
