[Blademaster680]

How can I load the owner's name of the vehicle as a string? So when someone gets into the car it will display the owner's name?

I have tried this way, but when I get into the vehicle it displays the name as '0'... Why?

here is the code:

Код:

Load_Vehicles()
{
	new count;
	new Query[512], savestr[50], rows, fields;
	for(new i=1; i < MAX_DVEHICLES; i++)
	{
		mysql_format(dbHandle,Query, sizeof(Query), "SELECT * FROM `Vehicles` WHERE `ID` = '%d'", i);
		mysql_query(dbHandle,Query);
	    cache_get_data(rows, fields);
		if(rows)
		{
			cache_get_field_content(0, "ID", savestr);			vInfo[i][vID] = strval(savestr);
			cache_get_field_content(0, "Owner", vInfo[i][vOwner]);
			cache_get_field_content(0, "Model", savestr);		vInfo[i][vModel] = strval(savestr);
			cache_get_field_content(0, "PosX", savestr);		vInfo[i][Pos][vX] = floatstr(savestr);
			cache_get_field_content(0, "PosY", savestr);		vInfo[i][Pos][vY] = floatstr(savestr);
			cache_get_field_content(0, "PosZ", savestr);		vInfo[i][Pos][vZ] = floatstr(savestr);
			cache_get_field_content(0, "PosA", savestr);		vInfo[i][Pos][vR] = floatstr(savestr);
			cache_get_field_content(0, "Color1", savestr);		vInfo[i][vColor1] = strval(savestr);
			cache_get_field_content(0, "Color2", savestr);		vInfo[i][vColor2] = strval(savestr);
			count++;
		}
		AddStaticVehicleEx(vInfo[i][vModel], vInfo[i][Pos][vX], vInfo[i][Pos][vY], vInfo[i][Pos][vZ], vInfo[i][Pos][vR], vInfo[i][vColor1], vInfo[i][vColor2], 60000);
	}	
	printf("Loaded %d vehicles", count);
}

[iLegendary]

Try

cache_get_field_content(0, "Owner", savestr);
format(vInfo[i][vOwner], 32,savestr);

[Blademaster680]

Nope still when I get into the car I am using this:

Код:

new str[128];
	format(str, sizeof(str), "Vehicle Owner: %d %s", vInfo[vehicleid][vOwner], vInfo[vehicleid][vOwner]);
	SendClientMessage(playerid, -1, str);

I am using %d just to test, but the %s isnt displaying anything... the %d is still displaying '0' though...

[rospar]

Код:

format(str, sizeof(str), "Vehicle Owner: %d %s", vInfo[vehicleid][vOwner], vInfo[vehicleid][vOwner]);

why the same variable ?

did you want to do it that way?

Код:

format(str, sizeof(str), "Vehicle Owner: %d %s",vehicleid, vInfo[vehicleid][vOwner]);

[Blademaster680]

Yeah same variable. just using both as a test, so I can see what its loading, and it seems to be loading as an integer I think, and need it to load as a string. .
Anyone that can help?

[rospar]

which mysql plugin version your are using ?

[Blademaster680]

R33 BlueG's I think

[Blademaster680]

Got it working thanks everyone for the help