Speichern von Häusern

Guten Tag Community,

die Zeile beim speichern ist zu lang wie könnte ich sie in 2 Zeilen schreiben?

format(query,sizeof(query),"UPDATE `haus` SET `Created` = '%d',`Besitzer` = '%s',`Owned = '%d',`EnterX` = '%f',`EnterY` = '%f',`EnterZ` = '%f',`ExitX` = '%f',`ExitY` = '%f',`ExitZ` = '%f',`Preis` = '%d',`Level` = '%d',`Int` = '%d',`Mieter` = '%d',`Miete` = '%d',`Rentable` = '%d',`lock` = '%d', WHERE `id` = '%d'",Hauser[haus][pOwner],haus);
mysql_query(query);

habe es jetzt so gemacht

new query1[500];
format(query1,sizeof(query1),"UPDATE `haus` SET `Created` = '%d',`Besitzer` = '%s',`Owned = '%d',`EnterX` = '%f',`EnterY` = '%f',`EnterZ` = '%f',`ExitX` = '%f',`ExitY` = '%f',`ExitZ` = '%f',",Hauser[haus][pCreated],]Hauser[haus][pOwner],Hauser[haus][pOwned],Hauser[haus][pEnterX],Hauser[haus][pEnterY],Hauser[haus][pEnterZ],Hauser[haus][pExitX],Hauser[haus][pExitY],Hauser[haus][pExitZ]); //<-----Kriege hier alle fehler
new query2[500];
format(query2,sizeof(query2),"`Preis` = '%d',`Level` = '%d',`Int` = '%d',`Mieter` = '%d',`Miete` = '%d',`Rentable` = '%d',`lock` = '%d', WHERE `id` = '%d'",Hauser[haus][pPrice],Hauser[haus][pLevel],Hauser[haus][pInt],Hauser[haus][pMieter],Hauser[haus][pMiete],Hauser[haus][pRentable],Hauser[haus][plock]);
new mainquery[1000];
format(mainquery,sizeof(mainquery),"%s%s",query1,query2);
mysql_query(mainquery);

C:\Users\Koray Bircan\Desktop\Selfmade by Koray\gamemodes\PeG.pwn(3226) : error 029: invalid expression, assumed zero
C:\Users\Koray Bircan\Desktop\Selfmade by Koray\gamemodes\PeG.pwn(3226) : warning 215: expression has no effect
C:\Users\Koray Bircan\Desktop\Selfmade by Koray\gamemodes\PeG.pwn(3226) : warning 215: expression has no effect
C:\Users\Koray Bircan\Desktop\Selfmade by Koray\gamemodes\PeG.pwn(3226) : warning 215: expression has no effect
C:\Users\Koray Bircan\Desktop\Selfmade by Koray\gamemodes\PeG.pwn(3226) : warning 215: expression has no effect
C:\Users\Koray Bircan\Desktop\Selfmade by Koray\gamemodes\PeG.pwn(3226) : warning 215: expression has no effect
C:\Users\Koray Bircan\Desktop\Selfmade by Koray\gamemodes\PeG.pwn(3226) : warning 215: expression has no effect
C:\Users\Koray Bircan\Desktop\Selfmade by Koray\gamemodes\PeG.pwn(3226) : warning 215: expression has no effect
C:\Users\Koray Bircan\Desktop\Selfmade by Koray\gamemodes\PeG.pwn(3226) : warning 215: expression has no effect
C:\Users\Koray Bircan\Desktop\Selfmade by Koray\gamemodes\PeG.pwn(3226) : error 001: expected token: ";", but found ")"
C:\Users\Koray Bircan\Desktop\Selfmade by Koray\gamemodes\PeG.pwn(3226) : error 029: invalid expression, assumed zero
C:\Users\Koray Bircan\Desktop\Selfmade by Koray\gamemodes\PeG.pwn(3226) : fatal error 107: too many error messages on one line

Compilation aborted.Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase

4 Errors.