12.11.2009, 07:41
Hello ![Wink](images/smilies/wink.png)
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.
![Wink](images/smilies/wink.png)
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; }