09.10.2018, 17:51
This is your query:
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:
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.
Код:
"UPDATE `backpacks` SET `PosX` = -73.955910, `PosY` = 1081.626831, `PosZ` = 19.742188, `PosRX` = 0.000000, `PosRY` = 0.000000, `PosRZ` = 0.000000 WHERE `ID` = 0"
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]);