[fonia5]

Am getting errors on the line of code below.

can't seem to fix the issue to sleepy.

Код:

ParkMeters[total][parkID] = cache_get_field_int(total, 0);
ParkMeters[total][parkPosX] = cache_get_field_float(total, 1);
ParkMeters[total][parkPosY] = cache_get_field_float(total, 2);
ParkMeters[total][parkPosZ] = cache_get_field_float(total, 3);
ParkMeters[total][parkPosRX] = cache_get_field_float(total, 4);
ParkMeters[total][parkPosRY] = cache_get_field_float(total, 5);
ParkMeters[total][parkPosRZ] = cache_get_field_float(total, 6);

full code.

Код:

forward LoadDynamicMeters();
public LoadDynamicMeters()
{
    new rows, fields, msg[128];
	new total = 0;
    cache_get_data(rows, fields);
    if(rows)
    {
		while(total < rows)
		{
			ParkMeters[total][parkID] = cache_get_field_int(total, 0);
			ParkMeters[total][parkPosX] = cache_get_field_float(total, 1);
			ParkMeters[total][parkPosY] = cache_get_field_float(total, 2);
			ParkMeters[total][parkPosZ] = cache_get_field_float(total, 3);
			ParkMeters[total][parkPosRX] = cache_get_field_float(total, 4);
			ParkMeters[total][parkPosRY] = cache_get_field_float(total, 5);
			ParkMeters[total][parkPosRZ] = cache_get_field_float(total, 6);
			cache_get_field(total, 7, ParkMeters[total][parkName], dbHandle, 128);
			ParkMeters[total][parkMinutes] = cache_get_field_int(total, 8);
			ParkMeters[total][parkOn] = 1;
			ParkMeters[total][parkObject] = CreateDynamicObject(1270, ParkMeters[total][parkPosX], ParkMeters[total][parkPosY], ParkMeters[total][parkPosZ], ParkMeters[total][parkPosRX], ParkMeters[total][parkPosRY], ParkMeters[total][parkPosRZ], -1, -1, -1, 200.0);
			format(msg, sizeof(msg), "minutes %d", ParkMeters[total][parkMinutes]);
			ParkMeters[total][parkArea] = CreateDynamicSphere(ParkMeters[total][parkPosX], ParkMeters[total][parkPosY], ParkMeters[total][parkPosZ], 1.5, -1, -1, -1);
			ParkMeters[total][parkLabel] = CreateDynamic3DTextLabel(msg, -1, ParkMeters[total][parkPosX], ParkMeters[total][parkPosY], ParkMeters[total][parkPosZ]+0.5, 1.5, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, -1, -1, -1, 100.0);
			total++;
		}
    }
	format(msg,sizeof(msg), "Loaded %d dynamic park meters from MySQL.", total);
	printf(msg);
    return 1;
}

[The__]

Code seems fine, but does your "ParkMeters" enum or whatever support what you're asking for?

[JeaSon]

it is becoz you are using it wrong

Wrong

pawn Код:

cache_get_field_float
cache_get_field_int

https://sampwiki.blast.hk/wiki/MySQL/R33..._content_float
https://sampwiki.blast.hk/wiki/MySQL/R33...ld_content_int

Right

pawn Код:

cache_get_field_content_float(row, const field_name[], connectionHandle = 1)
cache_get_field_content_int(row, const field_name[], connectionHandle = 1)

pawn Код:

ParkMeters[total][parkID] = cache_get_field_content_int(0, total);
ParkMeters[total][parkPosX] = cache_get_field_content_float(1, total);
ParkMeters[total][parkPosY] = cache_get_field_content_float(2, total);
ParkMeters[total][parkPosZ] = cache_get_field_content_float(3, total);
ParkMeters[total][parkPosRX] = cache_get_field_content_float(4, total);
ParkMeters[total][parkPosRY] = cache_get_field_content_float(5, total);
ParkMeters[total][parkPosRZ] = cache_get_field_content_float(6, total);

[fonia5]

Quote:

Originally Posted by The__ Code seems fine, but does your "ParkMeters" enum or whatever support what you're asking for?

Yeah it was something to do with the total but that's giving me warings now i removed it. i already tested it in game just need few bugs fixing.

Quote:

Originally Posted by Namer it is becoz you are using it wrong Wrong pawn Код: cache_get_field_float cache_get_field_int https://sampwiki.blast.hk/wiki/MySQL/R33..._content_float https://sampwiki.blast.hk/wiki/MySQL/R33...ld_content_int Right pawn Код: cache_get_field_content_float(row, const field_name[], connectionHandle = 1) cache_get_field_content_int(row, const field_name[], connectionHandle = 1) pawn Код: ParkMeters[total][parkID] = cache_get_field_content_int(0, total); ParkMeters[total][parkPosX] = cache_get_field_content_float(1, total); ParkMeters[total][parkPosY] = cache_get_field_content_float(2, total); ParkMeters[total][parkPosZ] = cache_get_field_content_float(3, total); ParkMeters[total][parkPosRX] = cache_get_field_content_float(4, total); ParkMeters[total][parkPosRY] = cache_get_field_content_float(5, total); ParkMeters[total][parkPosRZ] = cache_get_field_content_float(6, total);

Nope that's not going to work.

Код:

error 017: undefined symbol "cache_get_field_content_int"
undefined symbol "cache_get_field_content_float"