Hi,
Ich baue grade das Bizzsystem um, nur lädt er ein einziges Bizz aus der Datenbank..
public LoadBizz()
{
print("start");
for(new idx; idx < MAX_Bizz; idx++)
{
print("start2");
new string[128], bedienung[40],data[128];
format(bedienung,sizeof(bedienung),"bID = '%i'",idx);
format(string,sizeof(string),"SELECT * FROM bizz WHERE %s", bedienung);
mysql_query(string);
mysql_store_result();
if(mysql_num_rows() != 0) //this will be running until all rows are processed
{
print("start3");
mysql_fetch_field("bOwned", data);
strins(BizzInfo[idx][bOwned],data,0);
strdel(data,0,100);
mysql_fetch_field("bEntranceX", data);
BizzInfo[idx][bEntranceX] = floatstr(data);
strdel(data,0,100);
mysql_fetch_field("bEntranceY", data);
BizzInfo[idx][bEntranceY] = floatstr(data);
strdel(data,0,100);
mysql_fetch_field("bEntranceZ", data);
BizzInfo[idx][bEntranceZ] = floatstr(data);
strdel(data,0,100);
mysql_fetch_field("bExitX", data);
BizzInfo[idx][bExitX] = floatstr(data);
strdel(data,0,100);
mysql_fetch_field("bExitY", data);
BizzInfo[idx][bExitY] = floatstr(data);
strdel(data,0,100);
mysql_fetch_field("bExitZ", data);
BizzInfo[idx][bExitZ] = floatstr(data);
strdel(data,0,100);
mysql_fetch_field("bLevelNeeded",data);
BizzInfo[idx][bLevelNeeded] =strval(data);
strdel(data,0,100);
mysql_fetch_field("bBuyPrice",data);
BizzInfo[idx][bBuyPrice] =strval(data);
strdel(data,0,100);
mysql_fetch_field("bEntranceCost",data);
BizzInfo[idx][bEntranceCost] =strval(data);
strdel(data,0,100);
mysql_fetch_field("bTill",data);
BizzInfo[idx][bTill] =strval(data);
strdel(data,0,100);
mysql_fetch_field("bLocked",data);
BizzInfo[idx][bLocked] =strval(data);
strdel(data,0,100);
mysql_fetch_field("bInterior",data);
BizzInfo[idx][bInterior] =strval(data);
strdel(data,0,100);
mysql_fetch_field("bProducts",data);
BizzInfo[idx][bProducts] =strval(data);
strdel(data,0,100);
mysql_fetch_field("bMaxProducts",data);
BizzInfo[idx][bMaxProducts] =strval(data);
strdel(data,0,100);
mysql_fetch_field("bPriceProd",data);
BizzInfo[idx][bPriceProd] =strval(data);
strdel(data,0,100);
print("stop");
}
mysql_free_result();
printf("BizzInfo:%d Owner:%s Message:%s Entfee:%d Till:%d Products:%d/%d Interior:%d.",idx,BizzInfo[idx][bOwner],BizzInfo[idx][bMessage],BizzInfo[idx][bEntranceCost],BizzInfo[idx][bTill],BizzInfo[idx][bProducts],BizzInfo[idx][bMaxProducts],BizzInfo[idx][bInterior]);
}
print("string");
}
MFG GamerXIOS ♥
