stock Guardar_Job(iJobID) { if(!(1 <= iJobID < MAX_JOBS)) return 1; new szQuery[256]; format(szQuery, sizeof szQuery, "UPDATE `jobs` SET `jobType` = %i, \ `jobPosX` = %f, \ `jobPosY` = %f, \ `jobPosZ` = %f, \ `jobPickupX` = %f, \ `jobPickupY` = %f, \ `jobPickupZ` = %f, \ `jobLevelRequirement` = %i \ WHERE `jobID` = %i", JobData[iJobID][j_iType], JobData[iJobID][j_fPosition][0], JobData[iJobID][j_fPosition][1], JobData[iJobID][j_fPosition][2], JobData[iJobID][j_fPickupPoint][0], JobData[iJobID][j_fPickupPoint][1], JobData[iJobID][j_fPickupPoint][2], JobData[iJobID][j_iLevelRequirement], iJobID ); return mysql_function_query(g_iConnectionHandle[0], szQuery, false, "OnQueryFinish", "i", THREAD_NO_RESULT); } |
El mysql_log no lanza errores de esa consulta? si no lo hace y tienes los logs activados es porque no existe el jobID.
|
Error #1064 - Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE `jobID` = 1' at line 1 | Query: INSERT INTO `jobs` SET `jobType` = 5, `jobPosX` = 1654.007690, `jobPosY` = -1655.544677, `jobPosZ` = 22.515625, `jobPickupX` = 0.000000, `jobPickupY` = 0.000000, `jobPickupZ` = 0.000000, `jobLevelRequirement` = 0 WHERE `jobID` = 1 | Callback: OnQueryFinish |
їPor quй utilizas la claъsula INSERT si estбs usando WHERE? No tiene sentido.
INSERT no puede tener la claъsula WHERE! |
format(szQuery, sizeof szQuery, "INSERT INTO `jobs` (`jobType`, `jobPosX`, `jobPosY`, \ `jobPosZ`, `jobPickupX`, `jobPickupY`, `jobPickupZ`, `jobLevelRequirement`, `jobID`) \ VALUES (%i, %f, %f, %f, %f, %f, %f, %i, %i)", JobData[iJobID][j_iType], JobData[iJobID][j_fPosition][0], JobData[iJobID][j_fPosition][1], JobData[iJobID][j_fPosition][2], JobData[iJobID][j_fPickupPoint][0], JobData[iJobID][j_fPickupPoint][1], JobData[iJobID][j_fPickupPoint][2], JobData[iJobID][j_iLevelRequirement], iJobID |