23.06.2018, 20:25
Quote:
You can split and join them with strcat before the query.
Or just split the mysql_format (as long you have enough string buffer size) like this: Код:
mysql_format(MainPipeline, szMiscArray, sizeof(szMiscArray), "UPDATE `gates` SET \ `HID`=%d, \ `Speed`=%f, \ `Range`=%f, \ `Model`=%d, \ `VW`=%d, \ `Int`=%d, \ `Pass`='%e', \ `PosX`=%f, \ `PosY`=%f, \ `PosZ`=%f, \ `RotX`=%f, \ `RotY`=%f, \ `RotZ`=%f, ", GateInfo[id][gHID], GateInfo[id][gSpeed], GateInfo[id][gRange], GateInfo[id][gModel], GateInfo[id][gVW], GateInfo[id][gInt], GateInfo[id][gPass], GateInfo[id][gPosX], GateInfo[id][gPosY], GateInfo[id][gPosZ], GateInfo[id][gRotX], GateInfo[id][gRotY], GateInfo[id][gRotZ] ); mysql_format(MainPipeline, szMiscArray, sizeof(szMiscArray), "%s\ `PosXM`=%f, \ `PosYM`=%f, \ `PosZM`=%f, \ `RotXM`=%f, \ `RotYM`=%f, \ `RotZM`=%f, \ `Allegiance`=%d, \ `GroupType`=%d, \ `GroupID`=%d, \ `RenderHQ`=%d, \ `Timer`=%d, \ `Automate`=%d, \ `Locked`=%d, \ `TIndex`=%d, \ `TModel`=%d, \ `TTXD`='%e', \ `TTexture`='%e', \ `TColor`=%d, \ `Facility`=%d \ WHERE `ID`=%d", szMiscArray, GateInfo[id][gPosXM], GateInfo[id][gPosYM], GateInfo[id][gPosZM], GateInfo[id][gRotXM], GateInfo[id][gRotYM], GateInfo[id][gRotZM], GateInfo[id][gAllegiance], GateInfo[id][gGroupType], GateInfo[id][gGroupID], GateInfo[id][gRenderHQ], GateInfo[id][gTimer], GateInfo[id][gAutomate], GateInfo[id][gLocked], GateInfo[id][gTIndex], GateInfo[id][gTModel], GateInfo[id][gTTXD], GateInfo[id][gTTexture], GateInfo[id][gTColor], GateInfo[id][gFacility], id+1 ); mysql_tquery(MainPipeline, szMiscArray, "OnQueryFinish", "i", SENDDATA_THREAD); |