Nabend
Ich habe ein problem, mit der Funktion mysql_fetch_row
Wenn ein 2. Spieler connectet, dann geht er wegen der while schleife in die Knie
Ich frage mich zwar wiso aber mir fällt keine lösung ein.
Ich arbeite mit den Strickenkid plugin und nein ich nehme nicht das Blue G.
stock LoadPlayer(playerid,Key[])
{
new Data[1024],query[256];
format(query, 256, "SELECT `Passwort` FROM `player` WHERE `Name` = '%s'", PlayerInfo[playerid][Name]);
mysql_query(query, (-1), (0), SQL);
mysql_store_result(SQL);
while(mysql_fetch_row(Data, "|", SQL))sscanf(Data, "p<|>s[128]",PlayerInfo[playerid][Passwort]);// an der while schleife chrasht er
if(!strcmp(MD5_Hash(Key), PlayerInfo[playerid][Passwort], true))
{
mysql_free_result(SQL);
format(query, sizeof(query),"SELECT * FROM `player` WHERE `Name` = '%s'",PlayerInfo[playerid][Name]);
mysql_query(query, (-1), (0), SQL);
mysql_store_result(SQL);
while(mysql_fetch_row(Data, "|", SQL))
{
sscanf(Data, "p<|>ds[64]s[128]dddddddddddds[128]s[128]s[16]dd",
PlayerInfo[playerid][Userid],PlayerInfo[playerid][Name],PlayerInfo[playerid][Passwort],PlayerInfo[playerid][Admin],PlayerInfo[playerid][Job],PlayerInfo[playerid][Team],PlayerInfo[playerid][Geld],PlayerInfo[playerid][Skin],
PlayerInfo[playerid][Level],PlayerInfo[playerid][Respekt],PlayerInfo[playerid][PayDay],PlayerInfo[playerid][PayDayTog],PlayerInfo[playerid][Rank],PlayerInfo[playerid][Leader],PlayerInfo[playerid][Banned],PlayerInfo[playerid][BanGrund],
PlayerInfo[playerid][BanAdmin],PlayerInfo[playerid][IP],PlayerInfo[playerid][Nummer],PlayerInfo[playerid][Safeban]);
}
GivePlayerMoney(playerid,PlayerInfo[playerid][Geld]);
SetPlayerScore(playerid,PlayerInfo[playerid][Userid]);
format(query, 128, "{006100}[Join] %s hat den Server betreten.", PlayerInfo[playerid][Name]);
SendClientMessageToAll(cGreen, query);
SetPVarInt(playerid,"loggedin",1);
SetPVarInt(playerid,"played",1);
SpawnPlayer(playerid);
mysql_free_result(SQL);
return 1;
}
else
{
format(query, 128, "{FFFFFF}Fehler{FF6E00} %s {FFFFFF}Das Passwort war Falsch", PlayerInfo[playerid][Name]);
ShowPlayerDialog(playerid,diaLogin,DIALOG_STYLE_PASSWORD,"GTA "Servername"",query,"Login","");
mysql_free_result(SQL);
return 1;
}
}
Ich hoffe mal, das einer von euch eine idee dazu hat
