Vehicle ID Problem [MYSQL] - Printable Version

Vehicle ID Problem [MYSQL] - 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: Vehicle ID Problem [MYSQL] (/showthread.php?tid=647897)

Vehicle ID Problem [MYSQL] - Bier - 12.01.2018

Hello,

i dont know how it should work that i match the Database carid with the ingame car id

https://pic-upload.pw/img/0cd for example ingame its ID:1 and in the Database its ID 4

Код:

CMD:copcarloeschen(playerid, params[])
{
	new vid;
	if(!IsNumeric(params) || !strlen(params)) return SendClientMessage(playerid, 0xFF0000FF, "Error: Nutze: /copcarloeschen [Vehicle ID]");
	vid = strval(params);
	if(vid <= 0) return SendClientMessage(playerid, 0xFF0000FF, "Error: Vehicle-ID ist kein Fraktions-Fahrzeug.");
	for(new i=0; i<MAX_cop_VEHICLES; i++)
	{
	if(copVehicle[i][e_vID] == vid)
	{
			copVehicle[i][e_modelID] = 0;
			copVehicle[i][e_x] = 0.0;
			copVehicle[i][e_y] = 0.0;
			copVehicle[i][e_z] = 0.0;
			copVehicle[i][e_a] = 0.0;
			copVehicle[i][e_color1] = 0;
			copVehicle[i][e_color2] = 0;
			new query[128];
			format(query, sizeof(query), "DELETE FROM copVehicles WHERE ID = '%i'",vid);
			mysql_tquery(handle, query);
			DestroyVehicle(copVehicle[i][e_vID]);
			return SendClientMessage(playerid, 0x00FF00FF, "Fahrzeug gelцscht.");
				}
			}
	return SendClientMessage(playerid, 0xFF0000FF, "Error: Vehicle-ID ist kein Fraktions-Fahrzeug.");
}

thats the command to delete the car but it only delete the car if the database id and the ingame id match

Re: Vehicle ID Problem [MYSQL] - denNorske - 12.01.2018

This is not a smart way to do it, you can't be sure that the database ID will be the same as the in-game id's, as in-game id's may change over time.

Re: Vehicle ID Problem [MYSQL] - Bier - 13.01.2018

Quote:

Originally Posted by denNorske

This is not a smart way to do it, you can't be sure that the database ID will be the same as the in-game id's, as in-game id's may change over time.

hmm how can i solve the problem?