Load SqlBizz Problem
#1

Hello
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;
}
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)