SA-MP Forums Archive
Business Loading [MySql] - 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: Business Loading [MySql] (/showthread.php?tid=633330)


Business Loading [MySql] - dakata994 - 29.04.2017

So, I have a problem. When the businesses start loading, only business ID 0 loads and when I try to load them manually IG one by one with a command, it says that the loading is failed.


Here's the Business loading code:



Код:
LoadBusinesses() {
	query[0] = 0;
	format(query,sizeof(query),"SELECT `business`.`id`,`name`,`owner`,`c1`.`username`,`extortion`,`c2`.`username`,`EntranceX`,`EntranceY`,`EntranceZ`,`ExitX`,`ExitY`,`ExitZ`,`business`.`interior`,`type`,`value`,`locked`,`entrancefee`,`till`,`products`,`maxproducts` FROM `business` LEFT JOIN `characters` AS `c1` ON `business`.`owner` = `c1`.`id` LEFT JOIN `characters` AS `c2` ON `business`.`extortion` = `c2`.`id`");
	mysql_function_query(g_mysql_handle, query, true, "onLoadBusiness", "");
}

Код:
public onLoadBusiness() {
	new data[1728],id_val;
	new Float:f_val;
	new rows,fields;
	cache_get_data(rows,fields);
	printf("Number of businesses: %d\n", rows);
	for(new index=0;index<rows;index++) {
		new i = findFreeBusiness();
		cache_get_row(index, 0, data); //business SQL id
		id_val = strval(data);
		Business[i][EBusinessID] = id_val;
		cache_get_row(index, 1, data); //business name
		format(Business[i][EBusinessName],64,"%s",data);
		cache_get_row(index, 2, data); //owner SQL id
		id_val = strval(data);
		Business[i][EBusinessOwner] = id_val;
		if(Business[i][EBusinessOwner] == 0) {
			format(Business[i][EBusinessOwnerName],MAX_PLAYER_NAME,"No-One");
		} else if(Business[i][EBusinessOwner] == -1) {
			format(Business[i][EBusinessOwnerName],MAX_PLAYER_NAME,"The State");
		} else {
			cache_get_row(index, 3, data); //owner username
			format(Business[i][EBusinessOwnerName],MAX_PLAYER_NAME,"%s",data);
		}
		cache_get_row(index, 4, data); //extortion
		id_val = strval(data);
		Business[i][EBusinessExtortionist] = id_val;
		if(id_val != 0) {
			cache_get_row(index, 5, data); //extortionist username
			format(Business[i][EBusinessExtortionName],MAX_PLAYER_NAME,"%s",data);
		}
		cache_get_row(index, 6, data);
		f_val = floatstr(data);
		Business[i][EBusinessEntranceX] = f_val;
		cache_get_row(index, 7, data);
		f_val = floatstr(data);
		Business[i][EBusinessEntranceY] = f_val;
		cache_get_row(index, 8, data);
		f_val = floatstr(data);
		Business[i][EBusinessEntranceZ] = f_val;
		

		cache_get_row(index, 9, data);
		f_val = floatstr(data);
		Business[i][EBusinessExitX] = f_val;
		cache_get_row(index, 10, data);
		f_val = floatstr(data);
		Business[i][EBusinessExitY] = f_val;
		cache_get_row(index, 11, data);
		f_val = floatstr(data);
		Business[i][EBusinessExitZ] = f_val;
		cache_get_row(index, 12, data);
		id_val = strval(data);
		Business[i][EBusinessInterior] = id_val;
		cache_get_row(index, 13, data);
		id_val = strval(data);
		Business[i][EBType] = EBusinessType:id_val;
		cache_get_row(index, 14, data);
		id_val = strval(data);
		Business[i][EBusinessPrice] = id_val;
		cache_get_row(index, 15, data);
		id_val = strval(data);
		Business[i][EBusinessLocked] = id_val;
		Business[i][EBusinessVW] = i+BIZ_VW_OFFSET;
		cache_get_row(index, 16, data);
		id_val = strval(data);
		Business[i][EBusinessEntranceFee] = id_val;
		cache_get_row(index, 17, data);
		id_val = strval(data);
		Business[i][EBusinessTill] = id_val;
		
		cache_get_row(index, 18, data);
		id_val = strval(data);
		Business[i][EBusinessProducts] = id_val;
		
		cache_get_row(index, 19, data);
		id_val = strval(data);
		Business[i][EBusinessMaxProducts] = id_val;
		Business[i][EBusinessPickup] = CreateDynamicPickup(Business[i][EBusinessOwner]>0?1239:1239, 16, Business[i][EBusinessEntranceX], Business[i][EBusinessEntranceY], Business[i][EBusinessEntranceZ]);
		getBiz3DLabelText(i, data, sizeof(data));
		Business[i][EBusinessText] = CreateDynamic3DTextLabel(data, 0xFFFFFFFF, Business[i][EBusinessEntranceX], Business[i][EBusinessEntranceY], Business[i][EBusinessEntranceZ]+1.5,10.0);
		if(!IsDealership(i) && !IsFishStore(i) && !IsCarRental(i))
			Business[i][EBusinessExitPickup] = CreateDynamicPickup(1318, 16, Business[i][EBusinessExitX],Business[i][EBusinessExitY],Business[i][EBusinessExitZ], Business[i][EBusinessVW], Business[i][EBusinessInterior]);
		printf("Loaded business ID %d\n",Business[i][EBusinessID]);
	}
	if(bizinit == 0) {
		sellInactiveBusinesses();
		bizinit = 1;
	}
	printf("Businesses loaded.\n");
}

If anyone could help me, I'll rep him. Thanks.

Re: Business Loading [MySql] - aoky - 29.04.2017

What error are you getting?

Re: Business Loading [MySql] - dakata994 - 29.04.2017

I don't get any error, but it just spawns business ID 0, but says there are 115 businesses. In the Database are also 115 businesses.

It only loads ID 0.

Re: Business Loading [MySql] - aoky - 29.04.2017

Quote:
Originally Posted by dakata994
Посмотреть сообщение
I don't get any error, but it just spawns business ID 0, but says there are 115 businesses. In the Database are also 115 businesses.

It only loads ID 0.
After you make a business, try restarting the server and see if it appears.

Re: Business Loading [MySql] - dakata994 - 29.04.2017

Quote:
Originally Posted by aoky
Посмотреть сообщение
After you make a business, try restarting the server and see if it appears.
Still only ID 0 business loads. I tried changing the ID in the Database, but it loads only one.

Re: Business Loading [MySql] - roun512 - 29.04.2017

Try to run that query in your PHPMyAdmin, does it show all the rows? Or only the first?

Re: Business Loading [MySql] - dakata994 - 29.04.2017

Quote:
Originally Posted by roun512
Посмотреть сообщение
Try to run that query in your PHPMyAdmin, does it show all the rows? Or only the first?
It shows all the businesses. It's working, but it doesn't load them all IG.

Re: Business Loading [MySql] - roun512 - 29.04.2017

Honestly, you should change the way you load data from the database. It's a bit hard to read.

Here is an example of the first few lines in your function. You can continue the rest.

Код:
public onLoadBusiness() {
	new rows,fields;
	cache_get_data(rows,fields);
	printf("Number of businesses: %d\n", rows);
	for(new index=0;index<rows;index++) {

		new i = findFreeBusiness();

		Business[i][EBusinessID] = cache_get_row_int(index, 0); // business SQL id
		
		cache_get_row(index, 1, Business[i][EBusinessName], 1, 64); // business name

		Business[i][EBusinessOwner] = cache_get_row_int(index, 2); // owner SQL id

		if(Business[i][EBusinessOwner] == 0)
			format(Business[i][EBusinessOwnerName],MAX_PLAYER_NAME,"No-One");
		else if(Business[i][EBusinessOwner] == -1)
			format(Business[i][EBusinessOwnerName],MAX_PLAYER_NAME,"The State");
		else
			cache_get_row(index, 3, Business[i][EBusinessOwnerName], 1, MAX_PLAYER_NAME); //owner username
	}
}
If you still want to go with your way, are you sure that findFreeBusiness() is working correctly?