Mysql Problem
#1

Don't update table Cars

In mysql_log is write:
ProcessQueryThread(SendQuery) - Executing query UPDATE `cars` SET `propietar` = Gireada, `model` = 415, `numar` = LA-1, `pret` = 1, `culoare1` = 1, `culoare2` = 1, `spawnx` = 1497.799560, `spawny` = -1743.912353, `spawnz` = 13.320167, `spawna` = 269.339202, `cumparata` = 1, `donata` = 0, `inchisa` = 0 WHERE `id` = '1'...
[10:11:40] ProcessQueryThread(SendQuery) - Error will be triggered to OnQueryError().


On the OnQueryError don't have error.

Код:
new query[300];
	format(query, sizeof(query), "UPDATE `cars` SET `propietar` = %s, `model` = %d, `numar` = %s, `pret` = %d, `culoare1` = %d, `culoare2` = %d, `spawnx` = %f, `spawny` = %f, `spawnz` = %f, `spawna` = %f, `cumparata` = %d, `donata` = %d, `inchisa` = %d \
	WHERE `id` = '%d'",
		VehInfo[vehicleid][Propietar],
		VehInfo[vehicleid][Model],
		VehInfo[vehicleid][Numar],
		VehInfo[vehicleid][Pret],
		VehInfo[vehicleid][Culoare1],
		VehInfo[vehicleid][Culoare2],
		VehInfo[vehicleid][Spawnx],
		VehInfo[vehicleid][Spawny],
		VehInfo[vehicleid][Spawnz],
		VehInfo[vehicleid][Spawna],
		VehInfo[vehicleid][Cumparata],
		VehInfo[vehicleid][Donata],
		VehInfo[vehicleid][Lock],
		VehInfo[vehicleid][ID]);
On login system update my table.

Executing query UPDATE `users` SET `skin` = 0, `score` = 0, `money` = 10000, `job` = 0, `faction` = 0, `rank` = 0, `admin` = 6, `mute` = 0, `muter` = 0, `lock` = 0, `car` = 0,`tir` = 0, `bike` = 0, `arma` = 0, `prison` = 0, `prisont` = 0 WHERE `name` = 'Gireada'...
ProcessQueryThread(SendQuery) - Query was successful.



Sorry for bad english
Reply


Messages In This Thread
Mysql Problem - by Gireada - 09.09.2013, 10:53
Re: Mysql Problem - by iJumbo - 09.09.2013, 10:58
Re: Mysql Problem - by Konstantinos - 09.09.2013, 11:00
Re: Mysql Problem - by Gireada - 09.09.2013, 11:45

Forum Jump:


Users browsing this thread: 1 Guest(s)