SA-MP Forums Archive
Car toys not saving in 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: Car toys not saving in MYSQL (/showthread.php?tid=640036)


Car toys not saving in MYSQL - Puff - 27.08.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;
	}
}
Its not saving in the mysql table..

Re: Car toys not saving in MYSQL - 10MIN - 27.08.2017

INSERT query is like:
Код:
INSERT INTO tbl_name (val1,val2) VALUES(232,15);
Source MySQL 5.7 Reference Manual: Insert

Re: Car toys not saving in MYSQL - Misiur - 27.08.2017

MySQL supports SET syntax for inserts too. OP, show us your mysql log

Re: Car toys not saving in MYSQL - Puff - 30.08.2017

Quote:
Originally Posted by Misiur
Посмотреть сообщение
MySQL supports SET syntax for inserts too. OP, show us your mysql log
Код:
[03:16:00] Passing query SELECT `X`,`Y`,`Z`,`RX`,`RY`,`RZ`,`id`,`toyidx` FROM `playercartoys` WHERE `carid` = 12 | d
[03:16:00] ProcessQueryThread(OnLoadCarToys) - Query was successful. (SELECT `X`,`Y`,`Z`,`RX`,`RY`,`RZ`,`id`,`toyidx` FROM `playercartoys` WHERE `carid` = 12)
[03:16:00] ProcessQueryThread(OnLoadCarToys) - Data caching enabled.
[03:16:00] CMySQLHandler::StoreResult() - Result was stored.
[03:16:00] CMySQLHandler::FreeResult() - Result was successfully free'd.
[03:16:00] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[03:16:00] OnLoadCarToys(d) - Threaded function called.