[HELP] MySQL data loading - Printable Version

[HELP] MySQL data loading - 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: [HELP] MySQL data loading (/showthread.php?tid=529463)

[HELP] MySQL data loading - E_Meec - 02.08.2014

Hi guys, I've got a problem with MySQL data loading:

Код:

stock LoadPointData()
{
	new PointCount;
	for(new j=0; j<MAX_POINTS; j++)
	{
		format(Query, sizeof(Query), "SELECT * FROM Points WHERE ID = '%d'", j);
		mysql_query(Query);
		printf("Query: %s", Query);
		mysql_store_result();
		if(mysql_num_rows())
		if(mysql_fetch_row_format(Query,"|"))
		{
			sscanf(Query, "p<|>e<ds[32]fff>", PointInfo[j]);
			PointCount++;
		}
		printf("ID: %d - Name: %s - X: %f - Y: %f - Z: %f", PointInfo[j][pointID], PointInfo[j][pointName], PointInfo[j][pointX], PointInfo[j][pointY], PointInfo[j][pointZ]);
		
		CreatePickup(1314, 1, PointInfo[j][pointX], PointInfo[j][pointY], PointInfo[j][pointZ], 0);
	}
	printf("Loaded %d points", PointCount);
	return 1;
}

Enum:

Код:

enum E_POINT_INFO
{
	pointID,
	pointName[32],
	Float:pointX,
	Float:pointY,
	Float:pointZ,
}
new PointInfo[MAX_POINTS][E_POINT_INFO];

And these are the logs:

Код:

[15:44:46] Query: SELECT * FROM Points WHERE ID = '0'
[15:44:46] ID: 0 - Name:  - X: 0.000000 - Y: 0.000000 - Z: 0.000000
[15:44:46] Query: SELECT * FROM Points WHERE ID = '1'
[15:44:46] ID: 0 - Name:  - X: 0.000000 - Y: 0.000000 - Z: 0.000000
[15:44:46] Query: SELECT * FROM Points WHERE ID = '2'
[15:44:46] ID: 0 - Name:  - X: 0.000000 - Y: 0.000000 - Z: 0.000000
[15:44:46] Query: SELECT * FROM Points WHERE ID = '3'
[15:44:46] ID: 0 - Name:  - X: 0.000000 - Y: 0.000000 - Z: 0.000000
[15:44:46] Query: SELECT * FROM Points WHERE ID = '4'
[15:44:46] ID: 0 - Name:  - X: 0.000000 - Y: 0.000000 - Z: 0.000000
[15:44:46] Query: SELECT * FROM Points WHERE ID = '5'
[15:44:46] ID: 0 - Name:  - X: 0.000000 - Y: 0.000000 - Z: 0.000000
[15:44:46] Query: SELECT * FROM Points WHERE ID = '6'
[15:44:46] ID: 0 - Name:  - X: 0.000000 - Y: 0.000000 - Z: 0.000000
[15:44:46] Query: SELECT * FROM Points WHERE ID = '7'
[15:44:46] ID: 0 - Name:  - X: 0.000000 - Y: 0.000000 - Z: 0.000000
[15:44:46] Query: SELECT * FROM Points WHERE ID = '8'
[15:44:46] ID: 0 - Name:  - X: 0.000000 - Y: 0.000000 - Z: 0.000000
[15:44:46] Query: SELECT * FROM Points WHERE ID = '9'
[15:44:46] ID: 0 - Name:  - X: 0.000000 - Y: 0.000000 - Z: 0.000000
[15:44:46] Loaded 0 points.

I've used this to create a Point (IN MYSQL TABLE ON PHPMYADMIN):

Код:

INSERT INTO Points (ID, Name, X, Y, Z) VALUES ('0','Rodeo','490.5896','-1516.3459','20.3971')