Teste mal das hier aus
stock LoadHouses()
{
new data[64];
mysql_query("SELECT * FROM `houses`;");
mysql_store_result();
new rows = mysql_num_rows();
if(row > 0)
{
for(new i = 0; i < row; i ++)
{
if(mysql_retrieve_row())
{
mysql_fetch_field_row("Besitzer",data); format(HouseInfo[i][Besitzer],32,"%s",data);
mysql_fetch_field_row("Interior",data); HouseInfo[i][Interior]=strval(data);
mysql_fetch_field_row("Preis",data); HouseInfo[i][Preis]=strval(data);
mysql_fetch_field_row("PosX",data); HouseInfo[i][Pos_X]=floatstr(data);
mysql_fetch_field_row("PosY",data); HouseInfo[i][Pos_Y]=floatstr(data);
mysql_fetch_field_row("PosZ",data); HouseInfo[i][Pos_Z]=floatstr(data);
mysql_fetch_field_row("Mietbar",data); HouseInfo[i][Mietbar]=strval(data);
mysql_fetch_field_row("Miete",data); HouseInfo[i][Miete]=strval(data);
mysql_fetch_field_row("Locked",data); HouseInfo[i][Locked]=strval(data);
if(!strcmp(HouseInfo[i][Besitzer],"Niemand",true))
{
format(data,64,"Besitzer: %s\nPreis: %i$",HouseInfo[i][Besitzer],HouseInfo[i][Preis]);
CreatePickup(1273,1,HouseInfo[i][Pos_X],HouseInfo[i][Pos_Y],HouseInfo[i][Pos_Z]);
Create3DTextLabel(data,0xFF6600FF,HouseInfo[i][Pos_X],HouseInfo[i][Pos_Y],HouseInfo[i][Pos_Z]+0.2,20.0,0,0);
}
else
{
if(HouseInfo[i][Mietbar]==1)
{
format(data,64,"Besitzer: %s\nMietbar: JA\n Mietpreis: %i$\nAbgeschlossen: %s",HouseInfo[i][Besitzer],HouseInfo[i][Miete],GetLocked(i));
CreatePickup(1273,1,HouseInfo[i][Pos_X],HouseInfo[i][Pos_Y],HouseInfo[i][Pos_Z]);
Create3DTextLabel(data,0xFF6600FF,HouseInfo[i][Pos_X],HouseInfo[i][Pos_Y],HouseInfo[i][Pos_Z]+0.2,20.0,0,0);
}
else
{
format(data,64,"Besitzer: %s\nMietbar: NEIN\nAbgeschlossen: %s",HouseInfo[i][Besitzer],GetLocked(i));
CreatePickup(1273,1,HouseInfo[i][Pos_X],HouseInfo[i][Pos_Y],HouseInfo[i][Pos_Z]);
Create3DTextLabel(data,0xFF6600FF,HouseInfo[i][Pos_X],HouseInfo[i][Pos_Y],HouseInfo[i][Pos_Z]+0.2,20.0,0,0);
}
}
}
}
}
mysql_free_result();
return 1;
}
Sollte eigendlich so gehen
//edit
Sorry seh ich jetzt erst errors hab ich mal behoben 