[ApoziX]

How to fix it

Thanks for helpers +rep!

http://pastebin.ml/paste.php?id=13

Line 54937

`TColor`=%d, \

[Jaxium]

I'm on phone currently, but I'll try to help. That error means that the text is too long, between the string quotes.

You can split the entire string into two. Declare a string variable and use strcat two times. Each time use half of the text you are currently using. Then use that variable into the mysql function.

[ApoziX]

Quote:

Originally Posted by Jaxium I'm on phone currently, but I'll try to help. That error means that the text is too long, between the string quotes. You can split the entire string into two. Declare a string variable and use strcat two times. Each time use half of the text you are currently using. Then use that variable into the mysql function.

Thank you for the help bro But I am a Tiny Scripter

Could you do it for me?

[Kaliber]

You can simply do this:

PHP Code:

 mysql_format(connectionID, szMiscArray, sizeof(szMiscArray), "UPDATE `gates` SET \
                `HID`=%d, \
                `Speed`=%f, \
                `Range`=%f, \54922
                `Model`=%d, \
                `VW`=%d, \
                `Int`=%d, \
                `Pass`='%e', \
                `PosX`=%f, \
                `PosY`=%f, \
                `PosZ`=%f, \
                `RotX`=%f, \
                `RotY`=%f, \
                `RotZ`=%f, \
                `PosXM`=%f, \
                `PosYM`=%f, \
                `PosZM`=%f, \
                `RotXM`=%f, \
                `RotYM`=%f, \
                `RotZM`=%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],
                GateInfo[id][gPosXM],
                GateInfo[id][gPosYM],
                GateInfo[id][gPosZM],
                GateInfo[id][gRotXM],
                GateInfo[id][gRotYM],
                GateInfo[id][gRotZM]);
    
    mysql_format(connectionID, szMiscArray, sizeof(szMiscArray), "%s \
                `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][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(connectionID, szMiscArray);
        return 0;
}