Hm ne da spuckt es mir gleich bei der ersten schon ein Error raus:
error 017: undefined symbol "sqlfloat"
Hier mal die Ganze Funktion:
public LoadSBizz()
{
new result[164],query[180];
/*for(new idx=0; idx<sizeof(SBizzInfo); idx++)
{*/
new idx=0;
format(query, sizeof(query), "SELECT * FROM `sbizz`", idx);
mysql_query(query);
mysql_store_result();
while(mysql_retrieve_row())
{
mysql_get_field("sbid", result);
idx = strval(result);
mysql_get_field("sbowned", result);
SBizzInfo[idx][sbOwned] = strval(result);
mysql_get_field("sbowner", SBizzInfo[idx][sbOwner]);
mysql_get_field("sbmessage", SBizzInfo[idx][sbMessage]);
mysql_get_field("sbextortion", SBizzInfo[idx][sbExtortion]);
mysql_get_field("sbentrancex", result);
SBizzInfo[idx][sbEntranceX] = floatstr(result);
mysql_get_field("sbentrancey", result);
SBizzInfo[idx][sbEntranceY] = floatstr(result);
mysql_get_field("sbentrancez", result);
SBizzInfo[idx][sbEntranceZ] = floatstr(result);
mysql_get_field("sblevelneeded", result);
SBizzInfo[idx][sbLevelNeeded] = floatstr(result);
mysql_get_field("sbbuyprice", result);
SBizzInfo[idx][sbBuyPrice] = floatstr(result);
mysql_get_field("sbentrancecost", result);
SBizzInfo[idx][sbEntranceCost] = floatstr(result);
mysql_get_field("sbtill", result);
SBizzInfo[idx][sbTill] = floatstr(result);
mysql_get_field("sblocked", result);
SBizzInfo[idx][sbLocked] = floatstr(result);
mysql_get_field("sbinterior", result);
SBizzInfo[idx][sbInterior] = floatstr(result);
mysql_get_field("sbproducts", result);
SBizzInfo[idx][sbProducts] = floatstr(result);
mysql_get_field("sbmaxproducts", result);
SBizzInfo[idx][sbMaxProducts] = floatstr(result);
mysql_get_field("sbpriceprod", result);
SBizzInfo[idx][sbPriceProd] = floatstr(result);
mysql_get_field("sbdate", result);
SBizzInfo[idx][sbDate] = floatstr(result);
}
printf("sGeschäfte geladen %s!", SBizzInfo[idx][sbOwner]);
mysql_free_result();
//}
return 1;
}
Benutze MySQL Plugin R6, ich musste es mit jemanden zusammen so umschreiben, da es vorher so stand:
(Gab zwar keine warnings aber ok)
public LoadSBizz()
{
new val[128],query[256];
for(new idx=0; idx<sizeof(SBizzInfo); idx++)
{
format(query, sizeof(query), "SELECT * FROM `sbizz` WHERE `sid`='%i'", idx);
mysql_query(query);
mysql_store_result();
if(mysql_num_rows())
{
mysql_fetch_field_row(val,"sbowned");
SBizzInfo[idx][sbOwned] = strval(val);
mysql_fetch_field_row(SBizzInfo[idx][sbOwner],"sbowner");
mysql_fetch_field_row(SBizzInfo[idx][sbMessage],"sbmessage");
mysql_fetch_field_row(SBizzInfo[idx][sbExtortion],"sbextortion");
mysql_fetch_field_row(val,"sbentrancex");
SBizzInfo[idx][sbEntranceX] = floatstr(val);
mysql_fetch_field_row(val,"sbentrancey");
SBizzInfo[idx][sbEntranceY] = floatstr(val);
mysql_fetch_field_row(val,"sbentrancez");
SBizzInfo[idx][sbEntranceZ] = floatstr(val);
mysql_fetch_field_row(val,"sblevelneeded");
SBizzInfo[idx][sbLevelNeeded] = strval(val);
mysql_fetch_field_row(val,"sbbuyprice");
SBizzInfo[idx][sbBuyPrice] = strval(val);
mysql_fetch_field_row(val,"sbentrancecost");
SBizzInfo[idx][sbEntranceCost] = strval(val);
mysql_fetch_field_row(val,"sbtill");
SBizzInfo[idx][sbTill] = strval(val);
mysql_fetch_field_row(val,"sblocked");
SBizzInfo[idx][sbLocked] = strval(val);
mysql_fetch_field_row(val,"sbinterior");
SBizzInfo[idx][sbInterior] = strval(val);
mysql_fetch_field_row(val,"sbproducts");
SBizzInfo[idx][sbProducts] = strval(val);
mysql_fetch_field_row(val,"sbmaxproducts");
SBizzInfo[idx][sbMaxProducts] = strval(val);
mysql_fetch_field_row(val,"sbpriceprod");
SBizzInfo[idx][sbPriceProd] = strval(val);
mysql_fetch_field_row(val,"sbdate");
SBizzInfo[idx][sbDate] = strval(val);
}
mysql_free_result();
}
print("sGeschäfte geladen!");
return 1;
}
Hat aber die Biz´s nicht geladen ...
Hast vllt noch eine Idee, wie man es noch umschreiben könnte ?