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

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.
Reply
#2

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

Even on 1000 it shows the same error...
Reply
#4

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, "", "");
Reply
#5

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

BUMP
Reply
#7

PHP код:
YCMD:v_park(playeridparams[], help)
{
    if(!
IsPlayerInVehicle(playeridPlayer[playerid][PrivateVeh])) return SendClientMessage(playeridCOLOR_ERROR"[ ! ] You are not in any vehicle!");
    else if(
Player[playerid][VehiclesOwned] == 0) return SendClientMessage(playeridCOLOR_ERROR"[ ! ] You don't own any vehicle!");
    else if(
Player[playerid][PrivateVehSpawned] == false) return SendClientMessage(playeridCOLOR_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(playeridCOLOR_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(mysqlquerysizeof(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(mysqlquery);
            
DestroyVehicle(Player[playerid][PrivateVeh]);
            
Player[playerid][PrivateVehSpawned] = false;
        }
    }
    return 
1;

Try this & fix the indentation, please.

Error Reason: The lines are too long.
Reply
#8

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

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


Forum Jump:


Users browsing this thread: 1 Guest(s)