SA-MP Forums Archive
little help please, thanks.. - 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: little help please, thanks.. (/showthread.php?tid=640830)


little help please, thanks.. - Puff - 07.09.2017

Код:
SaveVehicleCarToy(carid, toyidx, update) {
	if(update) {
		format(query, sizeof(query), "UPDATE `playercartoys` SET `X` = %f, `Y` = %f, `Z` = %f, `RX` = %f, `RY` = %f, `RZ` = %f WHERE `id` = %d",VehicleCarToys[carid][toyidx][EVehCarToy_X],VehicleCarToys[carid][toyidx][EVehCarToy_Y],VehicleCarToys[carid][toyidx][EVehCarToy_Z],VehicleCarToys[carid][toyidx][EVehCarToy_RX],VehicleCarToys[carid][toyidx][EVehCarToy_RY],VehicleCarToys[carid][toyidx][EVehCarToy_RZ],VehicleCarToys[carid][toyidx][EVehCarToy_SQLID]);
	} else {
		format(query, sizeof(query), "INSERT INTO `playercartoys` SET `X` = %f, `Y` = %f, `Z` = %f, `RX` = %f, `RY` = %f, `RZ` = %f, `carid` = %d, `toyidx` = %d",VehicleCarToys[carid][toyidx][EVehCarToy_X],VehicleCarToys[carid][toyidx][EVehCarToy_Y],VehicleCarToys[carid][toyidx][EVehCarToy_Z],VehicleCarToys[carid][toyidx][EVehCarToy_RX],VehicleCarToys[carid][toyidx][EVehCarToy_RY],VehicleCarToys[carid][toyidx][EVehCarToy_RZ],GetVehicleSQLID(carid),VehicleCarToys[carid][toyidx][EVehCarToy_ToyIdx]);
	}
	mysql_function_query(g_mysql_handle, query, true, "OnSaveCarToy", "ddd", carid, toyidx, update);
}
forward OnSaveCarToy(carid, toyidx, update);
public OnSaveCarToy(carid, toyidx, update) {
	new id = mysql_insert_id();
	if(!update) {
		VehicleCarToys[carid][toyidx][EVehCarToy_SQLID] = id;
	}
}
Car Objects aren't saving its position in SQL... can anyone re-check if I am updating it right..

Do I have to debug or smth.... please help thanks.


SQL logs:
Код:
[04:16:49] Passing query INSERT INTO `playercars` (`owner`,`model`,`X`,`Y`,`Z`,`Angle`,`colour1`,`colour2`,`locktype`) VALUES (3945,411,1230.494628,-1654.971801,11.796875,278.702331,4,4,4) | ddddffffdd
[04:16:49] ProcessQueryThread(onPlayerVehicleCreate) - Query was successful. (INSERT INTO `playercars` (`owner`,`model`,`X`,`Y`,`Z`,`Angle`,`colour1`,`colour2`,`locktype`) VALUES (3945,411,1230.494628,-1654.971801,11.796875,278.702331,4,4,4))
[04:16:49] ProcessQueryThread(onPlayerVehicleCreate) - Data caching enabled.
[04:16:49] CMySQLHandler::StoreResult() - No data to store.
[04:16:49] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[04:16:49] onPlayerVehicleCreate(ddddffffdd) - Threaded function called.
[04:16:49] >> mysql_insert_id( Connection handle: 1 )


Re: little help please, thanks.. - SetPlayerNameTag - 07.09.2017

i had this bug before it might be ur coding show me more where do u using savecartoy

Re: little help please, thanks.. - Puff - 07.09.2017

Quote:
Originally Posted by SetPlayerNameTag
Посмотреть сообщение
i had this bug before it might be ur coding show me more where do u using savecartoy
Код:
YCMD:buycartoy(playerid, params[], help) {
	new carid = GetPlayerVehicleID(playerid);
	if(carid == INVALID_VEHICLE_ID || GetPlayerState(playerid) != PLAYER_STATE_DRIVER) {
		SendClientMessage(playerid, X11_TOMATO_2, "* You must be in a vehicle!");
		return 1;
	}
	new dps = IsPlayerInRangeOfPoint(playerid, 5.0, 1264.86, -1669.73, 13.54);
	new job = GetPVarInt(playerid, "Job");
	if(job != EJobType_Mechanic && !dps) {
		SendClientMessage(playerid, X11_TOMATO_2, "You must be a mechanic for this!");
		return 1;
	}
	if(VehicleInfo[carid][EVType] != EVehicleType_Owned) {
		SendClientMessage(playerid, X11_TOMATO_2, "* You can only use this on owned vehicles");
		return 1;
	}
	ShowCarToyBuyMenu(playerid, dps);
	return 1;
}
DestroyCarToy(objid, sqldelete = 1) {
	new carid;
	new obj = findCarToyByObjID(objid,carid);
	if(obj == -1) return 0;
	VehicleCarToys[carid][obj][EVehCarToy_ObjID] = 0;
	if(VehicleCarToys[carid][obj][EVehCarToy_SQLID] > 0 && sqldelete) {
		format(query, sizeof(query), "DELETE FROM `playercartoys` WHERE `id` = %d",VehicleCarToys[carid][obj][EVehCarToy_SQLID]);
		mysql_function_query(g_mysql_handle, query, true, "EmptyCallback", "");
	}
	VehicleCarToys[carid][obj][EVehCarToy_SQLID] = 0;
	DestroyDynamicObject(objid);
	return 1;
}
findCarToyByObjID(objid, &carid = 0) {
	carid = INVALID_VEHICLE_ID;
	for(new i=0;i<MAX_VEHICLES;i++) {
		for(new x=0;x<MAX_CAR_TOYS_PER_CAR;x++) {
			if(VehicleCarToys[i][x][EVehCarToy_ObjID] == objid) {
				carid = i;
				return x;
			}
		}
	}
	return -1;
}
findFreeCarToySlot(carid) {
	for(new i=0;i<MAX_CAR_TOYS_PER_CAR;i++) {
		if(VehicleCarToys[carid][i][EVehCarToy_ObjID] == 0 && VehicleCarToys[carid][i][EVehCarToy_SQLID] == 0) {
			return i;
		}
	}
	return -1;
}
SaveVehicleCarToy(carid, toyidx, update) {
	if(update) {
		format(query, sizeof(query), "UPDATE `playercartoys` SET `X` = %f, `Y` = %f, `Z` = %f, `RX` = %f, `RY` = %f, `RZ` = %f WHERE `id` = %d",VehicleCarToys[carid][toyidx][EVehCarToy_X],VehicleCarToys[carid][toyidx][EVehCarToy_Y],VehicleCarToys[carid][toyidx][EVehCarToy_Z],VehicleCarToys[carid][toyidx][EVehCarToy_RX],VehicleCarToys[carid][toyidx][EVehCarToy_RY],VehicleCarToys[carid][toyidx][EVehCarToy_RZ],VehicleCarToys[carid][toyidx][EVehCarToy_SQLID]);
	} else {
		format(query, sizeof(query), "INSERT INTO `playercartoys` SET `X` = %f, `Y` = %f, `Z` = %f, `RX` = %f, `RY` = %f, `RZ` = %f, `carid` = %d, `toyidx` = %d",VehicleCarToys[carid][toyidx][EVehCarToy_X],VehicleCarToys[carid][toyidx][EVehCarToy_Y],VehicleCarToys[carid][toyidx][EVehCarToy_Z],VehicleCarToys[carid][toyidx][EVehCarToy_RX],VehicleCarToys[carid][toyidx][EVehCarToy_RY],VehicleCarToys[carid][toyidx][EVehCarToy_RZ],GetVehicleSQLID(carid),VehicleCarToys[carid][toyidx][EVehCarToy_ToyIdx]);
	}
	mysql_function_query(g_mysql_handle, query, true, "OnSaveCarToy", "ddd", carid, toyidx, update);
}
forward OnSaveCarToy(carid, toyidx, update);
public OnSaveCarToy(carid, toyidx, update) {
	new id = mysql_insert_id();
	if(!update) {
		VehicleCarToys[carid][toyidx][EVehCarToy_SQLID] = id;
	}
}