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

