I have a problem, if businesses want to read from the database, I have a server crash. Bizz table exists in the database and has an entry id from 1 to 15 Please help fast.
Код:
public MySql_LoadBizz()
{
new arrCoords[20][32];
new sql[80];
new row[512];
new MaxBizz;
format(sql, sizeof(sql), "SELECT COUNT(*) FROM Bizz");
samp_mysql_query(sql);
samp_mysql_store_result();
samp_mysql_fetch_row(row);
MaxBizz = strval(row);
samp_mysql_free_result();
for (new idx=0; idx<MaxBizz; idx++)
{
format(sql, sizeof(sql), "SELECT * FROM Bizz WHERE id=%d", idx+1);
samp_mysql_query(sql);
samp_mysql_store_result();
if (samp_mysql_num_rows() > 0)
{
samp_mysql_fetch_row(row);
split(row, arrCoords, '|');
samp_mysql_free_result();
BizzInfo[idx][bOwned] = strval(arrCoords[1]);
strmid(BizzInfo[idx][bOwner], arrCoords[2], 0, strlen(arrCoords[2]), 255);
strmid(BizzInfo[idx][bMessage], arrCoords[3], 0, strlen(arrCoords[3]), 255);
strmid(BizzInfo[idx][bExtortion], arrCoords[4], 0, strlen(arrCoords[4]), 255);
BizzInfo[idx][bEntranceX] = floatstr(arrCoords[5]);
BizzInfo[idx][bEntranceY] = floatstr(arrCoords[6]);
BizzInfo[idx][bEntranceZ] = floatstr(arrCoords[7]);
BizzInfo[idx][bExitX] = floatstr(arrCoords[8]);
BizzInfo[idx][bExitY] = floatstr(arrCoords[9]);
BizzInfo[idx][bExitZ] = floatstr(arrCoords[10]);
BizzInfo[idx][bLevelNeeded] = strval(arrCoords[11]);
BizzInfo[idx][bBuyPrice] = strval(arrCoords[12]);
BizzInfo[idx][bEntranceCost] = strval(arrCoords[13]);
BizzInfo[idx][bTill] = strval(arrCoords[14]);
BizzInfo[idx][bLocked] = strval(arrCoords[15]);
BizzInfo[idx][bInterior] = strval(arrCoords[16]);
BizzInfo[idx][bProducts] = strval(arrCoords[17]);
BizzInfo[idx][bMaxProducts] = strval(arrCoords[18]);
BizzInfo[idx][bPriceProd] = strval(arrCoords[19]);
}
}
//samp_mysql_free_result();
return 1;
}