Is something wrong in this MySQL Load ?

Is something wrong in this MySQL Load ? - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Is something wrong in this MySQL Load ? (/showthread.php?tid=596846)

Is something wrong in this MySQL Load ? - boysockpr0123 - 23.12.2015

I have turned on samp-server for 3 times but it no use , i don't know how to fix it . I have made a command to check if it loaded , like Gangzones. But when it loaded to Biz
Here is the code when it loaded Gangzones

Код:

Ket qua tai GANGZONE:
[17:30:11] Tim thay trong co so du lieu:		[124]
[17:30:11] Tai rows: [123/123]	[SAN SANG]

But when it loaded to Biz , it stopped(Stopped loading Biz).Here is the code,something is wrong ?

Код:

public LoadBiznes2()
{
	new rows, fields,idbiz = 1;
	cache_get_data(rows, fields);
	for(new i = 0; i < rows; i++)
	{
		if(rows)
		{
			Biznes2Info[idbiz][b2id] = cache_get_field_content_int(i, "id", MySQL);
			Biznes2Info[idbiz][b2Owned] = cache_get_field_content_int(i, "Owned", MySQL);
			cache_get_field_content(i, "Message", Biznes2Info[idbiz][b2Message], MySQL, 20);
			Biznes2Info[idbiz][b2Lock] = cache_get_field_content_int(i, "Lock", MySQL);
			Biznes2Info[idbiz][b2Fill_X] = cache_get_field_content_float(i, "Fill_X", MySQL);
			Biznes2Info[idbiz][b2Fill_Y] = cache_get_field_content_float(i, "Fill_Y", MySQL);
			Biznes2Info[idbiz][b2Fill_Z] = cache_get_field_content_float(i, "Fill_Z", MySQL);
			Biznes2Info[idbiz][b2Cash] = cache_get_field_content_int(i, "Cash", MySQL);
			Biznes2Info[idbiz][b2Cena] = cache_get_field_content_int(i, "Cena", MySQL);//цена Cua hang
			Biznes2Info[idbiz][b2Cena_Fuell] = cache_get_field_content_int(i, "Cena_Fuell_1", MySQL);
			Biznes2Info[idbiz][b2Colonca][0] = cache_get_field_content_int(i, "Colonca1", MySQL);
			Biznes2Info[idbiz][b2Colonca][1] = cache_get_field_content_int(i, "Colonca2", MySQL);
			Biznes2Info[idbiz][b2Colonca][2] = cache_get_field_content_int(i, "Colonca3", MySQL);
			Biznes2Info[idbiz][b2Colonca][3] = cache_get_field_content_int(i, "Colonca4", MySQL);
			Biznes2Info[idbiz][b2Colonca][4] = cache_get_field_content_int(i, "Colonca5", MySQL);
			Biznes2Info[idbiz][b2Colonca][5] = cache_get_field_content_int(i, "Colonca6", MySQL);
			Biznes2Info[idbiz][b2Colonca_X][0] = cache_get_field_content_float(i, "Colonca_X_1", MySQL);
			Biznes2Info[idbiz][b2Colonca_X][1] = cache_get_field_content_float(i, "Colonca_X_2", MySQL);
			Biznes2Info[idbiz][b2Colonca_X][2] = cache_get_field_content_float(i, "Colonca_X_3", MySQL);
			Biznes2Info[idbiz][b2Colonca_X][3] = cache_get_field_content_float(i, "Colonca_X_4", MySQL);
			Biznes2Info[idbiz][b2Colonca_X][4] = cache_get_field_content_float(i, "Colonca_X_5", MySQL);
			Biznes2Info[idbiz][b2Colonca_X][5] = cache_get_field_content_float(i, "Colonca_X_6", MySQL);
			Biznes2Info[idbiz][b2Colonca_Y][0] = cache_get_field_content_float(i, "Colonca_Y_1", MySQL);
			Biznes2Info[idbiz][b2Colonca_Y][1] = cache_get_field_content_float(i, "Colonca_Y_2", MySQL);
			Biznes2Info[idbiz][b2Colonca_Y][2] = cache_get_field_content_float(i, "Colonca_Y_3", MySQL);
			Biznes2Info[idbiz][b2Colonca_Y][3] = cache_get_field_content_float(i, "Colonca_Y_4", MySQL);
			Biznes2Info[idbiz][b2Colonca_Y][4] = cache_get_field_content_float(i, "Colonca_Y_5", MySQL);
			Biznes2Info[idbiz][b2Colonca_Y][5] = cache_get_field_content_float(i, "Colonca_Y_6", MySQL);
			Biznes2Info[idbiz][b2Colonca_Z][0] = cache_get_field_content_float(i, "Colonca_Z_1", MySQL);
			Biznes2Info[idbiz][b2Colonca_Z][1] = cache_get_field_content_float(i, "Colonca_Z_2", MySQL);
			Biznes2Info[idbiz][b2Colonca_Z][2] = cache_get_field_content_float(i, "Colonca_Z_3", MySQL);
			Biznes2Info[idbiz][b2Colonca_Z][3] = cache_get_field_content_float(i, "Colonca_Z_4", MySQL);
			Biznes2Info[idbiz][b2Colonca_Z][4] = cache_get_field_content_float(i, "Colonca_Z_5", MySQL);
			Biznes2Info[idbiz][b2Colonca_Z][5] = cache_get_field_content_float(i, "Colonca_Z_6", MySQL);
			Biznes2Info[idbiz][b2Colonca_R][0] = cache_get_field_content_float(i, "Colonca_R_1", MySQL);
			Biznes2Info[idbiz][b2Colonca_R][1] = cache_get_field_content_float(i, "Colonca_R_2", MySQL);
			Biznes2Info[idbiz][b2Colonca_R][2] = cache_get_field_content_float(i, "Colonca_R_3", MySQL);
			Biznes2Info[idbiz][b2Colonca_R][3] = cache_get_field_content_float(i, "Colonca_R_4", MySQL);
			Biznes2Info[idbiz][b2Colonca_R][4] = cache_get_field_content_float(i, "Colonca_R_5", MySQL);
			Biznes2Info[idbiz][b2Colonca_R][5] = cache_get_field_content_float(i, "Colonca_R_6", MySQL);
			Biznes2Info[idbiz][b2Cenapokupki] = cache_get_field_content_int(i, "Cenapokupki", MySQL);
			Biznes2Info[idbiz][b2Klass] = cache_get_field_content_int(i, "Klass", MySQL);
			Biznes2Info[idbiz][b2ObKolicestvo] = cache_get_field_content_int(i, "b2ObKolicestvo", MySQL);
			Biznes2Info[idbiz][b2Gorod] = cache_get_field_content_int(i, "Gorod", MySQL);

Код:

print("===============================");
	print("Ket qua tai B2Info:");
	printf("Tim thay trong co so du lieu:		[%i]",rows);
	printf("ID dau tien cua rows:		[%i]",Biznes2Info[0][b2id]);
	if(idbiz == MAX_AUTOZAP) printf("Tai rows: [%i/%i]	[SAN SANG]",idbiz,MAX_AUTOZAP);
	else printf("Tai rows: [%i/%i]	[ERROR]",idbiz,MAX_AUTOZAP);
	return 1;

P/s:Sorry for my bad English