[MySQL] Numberplate Not appearing in Dialog

[MySQL] Numberplate Not appearing in Dialog - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: [MySQL] Numberplate Not appearing in Dialog (/showthread.php?tid=554821)

[MySQL] Numberplate Not appearing in Dialog - JonathanW - 05.01.2015

I fixed the problem of Loading vehicles, but now another appeared. The Numberplate is 'LOADED', it even sets to the Correct vehicle. But doesn't appear in a Dialog. Here's the related code.

The Command /mycars. (I showed the code for only the first vehicle.)

pawn Код:

if(OwnedVehicle[playerid][0][loaded])
{
format(string, sizeof(string), "%s (ID: %d) Plate: %s\n", GetVehicleName(OwnedVehicle[playerid][0][ID]), OwnedVehicle[playerid][0][vID], VehicleInfo[OwnedVehicle[playerid][0][ID]][vPlate]);
}

Here is the Loading.

pawn Код:

cache_get_field_content(i, "vPlate", temp), format(VehicleInfo[playerid][vPlate], 12, "%s", temp);

It loads the vehicle numberplates, sets them, respawns the vehicles. It works fine. But in this command, they aren't appearing in the Dialog.
Here is the Result:

You can see, for all the vehicles, the Plate is empty. It set them, so they load fine. Something wrong with the Command, probably. Any Help?

AW: [MySQL] Numberplate Not appearing in Dialog - Sascha - 05.01.2015

You're using "playerid" here

pawn Код:

cache_get_field_content(i, "vPlate", temp), format(VehicleInfo[playerid][vPlate], 12, "%s", temp);

and when calling it you are using the (mysql?) id of the vehicle

pawn Код:

format(string, sizeof(string), "%s (ID: %d) Plate: %s\n", GetVehicleName(OwnedVehicle[playerid][0][ID]), OwnedVehicle[playerid][0][vID], VehicleInfo[OwnedVehicle[playerid][0][ID]][vPlate]);

Re: AW: [MySQL] Numberplate Not appearing in Dialog - JonathanW - 05.01.2015

Quote:

Originally Posted by Sascha

You're using "playerid" here

pawn Код:

cache_get_field_content(i, "vPlate", temp), format(VehicleInfo[playerid][vPlate], 12, "%s", temp);

and when calling it you are using the (mysql?) id of the vehicle

pawn Код:

format(string, sizeof(string), "%s (ID: %d) Plate: %s\n", GetVehicleName(OwnedVehicle[playerid][0][ID]), OwnedVehicle[playerid][0][vID], VehicleInfo[OwnedVehicle[playerid][0][ID]][vPlate]);

I'm confused about the First Objection. All the other Variables load fine. The Color, the Position, the Model. Why not the Plate then?

And the Second objection, Well No, I'm not using the MySQL ID. Look at it again, orderwise.
%s = Vehicle Name Of Ownedvehicle[playerid][0][ID] (ID = The variable used to create vehicle. NOT MYSQL ID)
%d = Actual MySQL ID of the vehicle.
%s = The Number Plate of Ownedvehicle[playerid][0][ID] Same as above.

Re: [MySQL] Numberplate Not appearing in Dialog - JonathanW - 05.01.2015

UPDATE: There's a problem in Loading 'STRINGS'. I tried debugging it, using the Plate and Owner Name. It returned Blank. i.e 'This vehicle is owned by ." (Something is supposed to be before the full stop)

Re: [MySQL] Numberplate Not appearing in Dialog - Sawalha - 05.01.2015

a question, why doing this:

pawn Код:

cache_get_field_content(i, "vPlate", temp), format(VehicleInfo[playerid][vPlate], 12, "%s", temp);

while you can simply do this:

pawn Код:

cache_get_field_content(i, "vPlate", VehicleInfo[playerid[vPlate], mysql, 12);

and yea, Sascha noticed a something, you used in loading vehicle, for vehicleinfo enum "playerid", while you are using in the formatting line, a vehicle id.

Re: [MySQL] Numberplate Not appearing in Dialog - JonathanW - 05.01.2015

Well, I Fixed the error. Thanks Sascha, that worked.
But erm, another appeared. The vehicle numberplates roll back by one.
Let me explain
1st vehicle is supposed to have = MG 01
2nd vehicle -------------------- = UV 46
3rd Vehicle -------------------- = DE 3933

1st Vehicle has the plate of 2nd, 2nd has the plate of 3rd, 3rd has empty. So, do I need to do some sort of -1 here? Since MySQL starts with 0, eh?

pawn Код:

for(new i = 0; i < rows; i++)
        {
     cache_get_field_content(i, "vPlate", VehicleInfo[i][vPlate], handle, 12);

So, where do I -1, erm?

Re: [MySQL] Numberplate Not appearing in Dialog - Sawalha - 05.01.2015

try

pawn Код:

for(new i; i<rows;)

Re: [MySQL] Numberplate Not appearing in Dialog - JonathanW - 05.01.2015

@ Sawalha
That;

pawn Код:

for(new i; i<rows;)

Crashes the server. When I change it to this;

pawn Код:

for(new i; i < rows; i++)

It's fine. But then, the Plates Conflict with each other?

Re: [MySQL] Numberplate Not appearing in Dialog - Smally - 06.01.2015

This:

pawn Код:

for(new i; i < rows; i++)

Should be:

pawn Код:

for(new i = 0; i < rows; i++) The reason being in your array 0 is the first vehicle by default I believe I would be 1.

Re: [MySQL] Numberplate Not appearing in Dialog - JonathanW - 06.01.2015

Quote:

Originally Posted by Smally

This:

pawn Код:

for(new i; i < rows; i++)

Should be:

pawn Код:

for(new i = 0; i < rows; i++) The reason being in your array 0 is the first vehicle by default I believe I would be 1.

So then. The plates roll back by one. i.e The first vehicle has the second vehicle's plate, second has third's, third has blank.
EDIT: Please refer to this thread, it's the same.
https://sampforum.blast.hk/showthread.php?tid=554867