Hallo
Problem ist der kann die Spalte Leader nicht auslesen ka warum
if(!strcmp(cmd,"/allleader",true))
{
if(pDaten[playerid][AdminLevel] >= 1338)
{
new query[128];
format(query,sizeof(query),"SELECT `Name`,`Leader` FROM `accounts` WHERE `Leader` > '0'");
mysql_query(query);
mysql_store_result();new resultline[200];
new NAMEALLSTRING[2024];
new hCount = 0;
format(NAMEALLSTRING,2024,"");
for(new i = 0; i < SLOTS+2; i++)
{
format(LeaderName[i][playerid],2024,"");
}
while(mysql_retrieve_row())
{
new FraktionabcDigga[60],pName123[60],FraktionsIDundso;
mysql_fetch_field_row(pName123,"Name");
mysql_fetch_field_row(FraktionabcDigga,"Leader");//Server Crash
FraktionsIDundso=strval(FraktionabcDigga);
format(NAMEALLSTRING,2024,"%s%s[Fraktion:%s]\n",NAMEALLSTRING,pName123,FraktionName[FraktionsIDundso]);
format(LeaderName[hCount][playerid],2024,"%s",pName123);
hCount++;
}
ShowPlayerDialog(playerid, DIALOG_LEADERLIST, DIALOG_STYLE_LIST, "LeaderList 2.0", NAMEALLSTRING, "Auswählen", "Beenden");
mysql_free_result();
}
return 1;
}
[10:45:05] >> mysql_query( Connection handle: 1 )
[10:45:05] CMySQLHandler::Query(SELECT `Name`,`Leader` FROM `accounts` WHERE `Leader` > '0') - Successfully executed.
[10:45:05] >> mysql_store_result( Connection handle: 1 )
[10:45:05] CMySQLHandler::StoreResult() - Result was stored.
[10:45:05] >> mysql_retrieve_row( Connection handle: 1 )
[10:45:05] >> mysql_fetch_field_row( Connection handle: 1 )
[10:45:05] CMySQLHandler::FetchField("Name") - Bios
[10:45:05] >> mysql_fetch_field_row( Connection handle: 1 )
