MySQL saving problem
#2

This is your query:
Код:
"UPDATE `backpacks` SET `PosX` = -73.955910, `PosY` = 1081.626831, `PosZ` = 19.742188, `PosRX` = 0.000000, `PosRY` = 0.000000, `PosRZ` = 0.000000 WHERE `ID` = 0"
It attempts to update a row in which the ID is equal to 0 but it does not exist so no rows are affected.

Let's take a closer look at the columns count and arguments count:
Код:
`PosX` = %f, `PosY` = %f, `PosZ` = %f, 
`PosRX` = %f, `PosRY` = %f, `PosRZ` = %f 
WHERE `ID` = %i",
bInfo[id][Pos][0], bInfo[id][Pos][1], bInfo[id][Pos][2],
bInfo[id][Pos][3], bInfo[id][Pos][4], bInfo[id][Pos][5], 
bInfo[id][VirtualWorld], bInfo[id][Interior], bInfo[id][Type], bInfo[id][Use], bInfo[id][ID]);
It takes the value of virtual world which is 0. Remove virtual world, interior, type and use from the arguments or add the columns in the query if you want to update these as well.
Reply


Messages In This Thread
MySQL saving problem - by Ripster - 09.10.2018, 17:40
Re: MySQL saving problem - by Calisthenics - 09.10.2018, 17:51
Re: MySQL saving problem - by Ripster - 09.10.2018, 18:03

Forum Jump:


Users browsing this thread: 1 Guest(s)