02.08.2014, 13:52
Hi guys, I've got a problem with MySQL data loading:
Enum:
And these are the logs:
I've used this to create a Point (IN MYSQL TABLE ON PHPMYADMIN):
Код:
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 E_POINT_INFO { pointID, pointName[32], Float:pointX, Float:pointY, Float:pointZ, } new PointInfo[MAX_POINTS][E_POINT_INFO];
Код:
[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.
Код:
INSERT INTO Points (ID, Name, X, Y, Z) VALUES ('0','Rodeo','490.5896','-1516.3459','20.3971')