[Stefand]

Well I have to split again but I already did that, and still getting errors

pawn Code:

new query[2000];

        format(query, sizeof(query), "INSERT INTO `Houses` (`hInteriorID`, `hInteriorX`, `hInteriorY`, `hInteriorZ`, `hInteriorA`, `hExteriorID`, `hExteriorX`, `hExteriorY`, `hExteriorZ`, `hExteriorA`, `hSpawnID`, ");
        format(query, sizeof(query), "%s`hSpawnX`, `hSpawnY`, `hSpawnZ`, `hSpawnA`, `hOwner`, `hAddress`, `HousePrice`, `hLockStatus`, `hType`) VALUES ", query);
        format(query, sizeof(query), "%s(%d, '%f', '%f', '%f', '%f', %d, '%f', '%f', '%f', '%f', %d, '%f', '%f', '%f', '%f', '%s', '%s', %d, %d, '%s')", query, Houses[houseid][hInteriorID], Houses[houseid][hInteriorX], Houses[houseid][hInteriorY], Houses[houseid][hInteriorZ], Houses[houseid][hInteriorA], Houses[houseid][hExteriorID], Houses[houseid][hExteriorX], Houses[houseid][hExteriorY], Houses[houseid][hExteriorZ], Houses[houseid][hExteriorA], Houses[houseid][hSpawnID], Houses[houseid][hSpawnX], Houses[houseid][hSpawnY], Houses[houseid][hSpawnZ], Houses[houseid][hSpawnA], Houses[houseid][hOwner], Houses[houseid][hAddress], -1, 1, Houses[houseid][hType],);
        mysql_function_query(connectionHandle, query, false, "DefaultCallback", "");

Code:

C:\Users\Stefan Laptop\Desktop\GTA RP Script\gamemodes\RolePlay.pwn(7176) : error 075: input line too long (after substitutions)
C:\Users\Stefan Laptop\Desktop\GTA RP Script\gamemodes\RolePlay.pwn(7177) : error 017: undefined symbol "hous"
C:\Users\Stefan Laptop\Desktop\GTA RP Script\gamemodes\RolePlay.pwn(7178) : warning 217: loose indentation
C:\Users\Stefan Laptop\Desktop\GTA RP Script\gamemodes\RolePlay.pwn(7178) : error 017: undefined symbol "eid"
C:\Users\Stefan Laptop\Desktop\GTA RP Script\gamemodes\RolePlay.pwn(7178) : error 029: invalid expression, assumed zero
C:\Users\Stefan Laptop\Desktop\GTA RP Script\gamemodes\RolePlay.pwn(7178) : error 029: invalid expression, assumed zero
C:\Users\Stefan Laptop\Desktop\GTA RP Script\gamemodes\RolePlay.pwn(7178) : fatal error 107: too many error messages on one line

Compilation aborted.Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase


6 Errors.

[mineralo]

PHP Code:

new query[2000];
        format(query, sizeof(query), "INSERT INTO `Houses` (`hInteriorID`, `hInteriorX`, `hInteriorY`, `hInteriorZ`, `hInteriorA`, `hExteriorID`, `hExteriorX`, `hExteriorY`, `hExteriorZ`, `hExteriorA`, `hSpawnID`, ");
        format(query, sizeof(query), "%s`hSpawnX`, `hSpawnY`, `hSpawnZ`, `hSpawnA`, `hOwner`, `hAddress`, `HousePrice`, `hLockStatus`, `hType`) VALUES ", query);
        format(query, sizeof(query), "%s(%d, '%f', '%f', '%f', '%f', %d, '%f', '%f', '%f', '%f', %d, '%f', '%f', '%f', '%f', '%s', '%s', %d, %d, '%s')", 
query, Houses[houseid][hInteriorID], Houses[houseid][hInteriorX], Houses[houseid][hInteriorY], Houses[houseid][hInteriorZ], Houses[houseid][hInteriorA], Houses[houseid][hExteriorID], Houses[houseid][hExteriorX], Houses[houseid][hExteriorY],
 Houses[houseid][hExteriorZ], Houses[houseid][hExteriorA], Houses[houseid][hSpawnID], Houses[houseid][hSpawnX], Houses[houseid][hSpawnY], Houses[houseid][hSpawnZ], Houses[houseid][hSpawnA], Houses[houseid][hOwner], Houses[houseid][hAddress], -1, 1, Houses[houseid][hType],);
        mysql_function_query(connectionHandle, query, false, "DefaultCallback", ""); 


[[HiC]TheKiller]

pawn Code:

format(query, sizeof(query), "INSERT INTO `Houses` (`hInteriorID`, `hInteriorX`, `hInteriorY`, `hInteriorZ`, `hInteriorA`, `hExteriorID`, `hExteriorX`, `hExteriorY`, `hExteriorZ`, `hExteriorA`, `hSpawnID`, ");
        format(query, sizeof(query), "%s`hSpawnX`, `hSpawnY`, `hSpawnZ`, `hSpawnA`, `hOwner`, `hAddress`, `HousePrice`, `hLockStatus`, `hType`) VALUES ", query);
        format(query, sizeof(query), "%s(%d, '%f', '%f', '%f', '%f', %d, '%f', '%f', '%f', '%f', %d, '%f', '%f', '%f', '%f', '%s', '%s', %d, %d, '%s')", query, Houses[houseid][hInteriorID], Houses[houseid][hInteriorX], Houses[houseid][hInteriorY], Houses[houseid][hInteriorZ], Houses[houseid][hInteriorA], Houses[houseid][hExteriorID], Houses[houseid][hExteriorX], Houses[houseid][hExteriorY], Houses[houseid][hExteriorZ], Houses[houseid][hExteriorA], Houses[houseid][hSpawnID], Houses[houseid][hSpawnX], Houses[houseid][hSpawnY], Houses[houseid][hSpawnZ], Houses[houseid][hSpawnA], Houses[houseid][hOwner], Houses[houseid][hAddress], -1, 1, Houses[houseid][hType]);
        mysql_function_query(connectionHandle, query, false, "DefaultCallback", "");

If that does not fix it, you're going to need to split it further. You had an extra comma on the end of the last format.