[MYSQL] Input line to long, help me out pls.

[MYSQL] Input line to long, help me out pls. - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: [MYSQL] Input line to long, help me out pls. (/showthread.php?tid=604398)

[MYSQL] Input line to long, help me out pls. - Scrillex - 04.04.2016

I have a problem.. So maybe some one can help me with using strcat to seperate it.. Because input line is to long!
ERRORS:

pawn Код:

error 075: input line too long (after substitutions)
error 017: undefined symbol "play"
warning 217: loose indentation
error 017: undefined symbol "erid"
error 029: invalid expression, assumed zero
error 029: invalid expression, assumed zero
fatal error 107: too many error messages on one line

pawn Код:

YCMD:v_park(playerid, params[], help)
{
    if(!IsPlayerInVehicle(playerid, Player[playerid][PrivateVeh])) return SendClientMessage(playerid, COLOR_ERROR, "[ ! ] You are not in any vehicle!");
    else if(Player[playerid][VehiclesOwned] == 0) return SendClientMessage(playerid, COLOR_ERROR, "[ ! ] You don't own any vehicle!");
    else if(Player[playerid][PrivateVehSpawned] == false) return SendClientMessage(playerid, COLOR_ERROR, "[ ! ] Your vehicle isn't spawned!");
    else
    {

        if(!IsVehicleInRangeOfPoint(Player[playerid][PrivateVeh], 10.0,Player[playerid][parkX], Player[playerid][parkY], Player[playerid][parkZ])) return SendClientMessage(playerid, COLOR_ERROR, "[ ! ] You are not near your parking spot.");
        else
        {
        
            new query[356];
            GetVehiclePos(Player[playerid][PrivateVeh], Player[playerid][parkX], Player[playerid][parkY], Player[playerid][parkZ]);
            GetVehicleZAngle(Player[playerid][PrivateVeh], Player[playerid][Angle]);
            GetVehicleHealth(Player[playerid][PrivateVeh], Player[playerid][EngineStatus]);
            GetVehicleDamageStatus(Player[playerid][PrivateVeh], Player[playerid][PanelStatus], Player[playerid][DoorStatus], Player[playerid][LightStatus], Player[playerid][TireStatus]);

            mysql_format(mysql, query, sizeof(query), "UPDATE `player` SET `parkX` = %f, `parkY` = %f,`parkZ` = %f, `Angle` = %f, `EngineStatus` = %f, `PanelStatus` = %d, `DoorStatus` = %d,\
            `LightStatus` = %d, `TireStatus` = %d WHERE `Name` = '%s'", Player[playerid][parkX], Player[playerid][parkY], Player[playerid][parkZ], Player[playerid][Angle], Player[playerid][EngineStatus], Player[playerid][PanelStatus], Player[playerid][DoorStatus], Player[playerid][LightStatus], Player[playerid][TireStatus],GetName(playerid));
            mysql_tquery(mysql, query);

            DestroyVehicle(Player[playerid][PrivateVeh]);

            Player[playerid][PrivateVehSpawned] = false;
        }
    }
    return 1;
}

With best regards Scrillex.

Re: [MYSQL] Input line to long, help me out pls. - introzen - 04.04.2016

That shouldn't be too long. Are you sure increasing the string size doesn't solve the error?

Re: [MYSQL] Input line to long, help me out pls. - Scrillex - 04.04.2016

Even on 1000 it shows the same error...

Re: [MYSQL] Input line to long, help me out pls. - Konstantinos - 04.04.2016

pawn Код:

new query[356] = "UPDATE `player` SET `parkX` = %f, `parkY` = %f,`parkZ` = %f, `Angle` = %f, `EngineStatus` = %f, `PanelStatus` = %d, `DoorStatus` = %d, `LightStatus` = %d, `TireStatus` = %d WHERE `Name` = '%s'";

...

mysql_format(mysql, query, sizeof(query), query, Player[playerid][parkX], Player[playerid][parkY], Player[playerid][parkZ], Player[playerid][Angle], Player[playerid][EngineStatus], Player[playerid][PanelStatus], Player[playerid][DoorStatus], Player[playerid][LightStatus], Player[playerid][TireStatus], GetName(playerid));
mysql_tquery(mysql, query, "", "");

Re: [MYSQL] Input line to long, help me out pls. - Scrillex - 04.04.2016

I understand that.. Even if I set query on 1000 same error.

Re: [MYSQL] Input line to long, help me out pls. - Scrillex - 04.04.2016

BUMP

Re: [MYSQL] Input line to long, help me out pls. - Karan007 - 04.04.2016

PHP код:



YCMD:v_park(playerid, params[], help)

{

    if(!IsPlayerInVehicle(playerid, Player[playerid][PrivateVeh])) return SendClientMessage(playerid, COLOR_ERROR, "[ ! ] You are not in any vehicle!");

    else if(Player[playerid][VehiclesOwned] == 0) return SendClientMessage(playerid, COLOR_ERROR, "[ ! ] You don't own any vehicle!");

    else if(Player[playerid][PrivateVehSpawned] == false) return SendClientMessage(playerid, COLOR_ERROR, "[ ! ] Your vehicle isn't spawned!");

    else

    {


        if(!IsVehicleInRangeOfPoint(Player[playerid][PrivateVeh], 10.0,Player[playerid][parkX], Player[playerid][parkY], Player[playerid][parkZ])) return SendClientMessage(playerid, COLOR_ERROR, "[ ! ] You are not near your parking spot.");

        else

        {

        

            new query[970];

            GetVehiclePos(Player[playerid][PrivateVeh], Player[playerid][parkX], Player[playerid][parkY], Player[playerid][parkZ]);

            GetVehicleZAngle(Player[playerid][PrivateVeh], Player[playerid][Angle]);

            GetVehicleHealth(Player[playerid][PrivateVeh], Player[playerid][EngineStatus]);

            GetVehicleDamageStatus(Player[playerid][PrivateVeh], Player[playerid][PanelStatus], Player[playerid][DoorStatus], Player[playerid][LightStatus], Player[playerid][TireStatus]);


            mysql_format(mysql, query, sizeof(query), "UPDATE `player` SET `parkX` = %f, `parkY` = %f,`parkZ` = %f, `Angle` = %f, `EngineStatus` = %f, `PanelStatus` = %d, `DoorStatus` = %d,\

             `LightStatus` = %d, `TireStatus` = %d WHERE `Name` = '%s'", 

                        Player[playerid][parkX],

                        Player[playerid][parkY], 

                        Player[playerid][parkZ],

                        Player[playerid][Angle], 

                        Player[playerid][EngineStatus], 

                        Player[playerid][PanelStatus], 

                        Player[playerid][DoorStatus], 

                        Player[playerid][LightStatus], 

                        Player[playerid][TireStatus],

                        GetName(playerid));

            mysql_tquery(mysql, query);


            DestroyVehicle(Player[playerid][PrivateVeh]);


            Player[playerid][PrivateVehSpawned] = false;

        }

    }

    return 1;

}

Try this & fix the indentation, please.

Error Reason: The lines are too long.

Re: [MYSQL] Input line to long, help me out pls. - Sabur - 08.04.2016

Download zeex pawn compiler and try it, i'm sure it'll work.

https://github.com/Zeex/pawn/releases