[HELP] MySQL data loading
#1

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')
Reply


Messages In This Thread
[HELP] MySQL data loading - by E_Meec - 02.08.2014, 13:52

Forum Jump:


Users browsing this thread: 1 Guest(s)