[Pottus]

This is just for starters, you may need multiple strcat()'s

pawn Код:

new tmpquery[512];

    format(query, sizeof(query), "INSERT INTO houses ID, Address, Owner, Owned, Price, X, Y, Z, EnterX, EnterY, EnterZ, EnterA, ExitX, ExitY, ExitZ, ExitA, Interior ");
    format(tmpquery, sizeof(tmpquery), "VALUES %s(%d, '%s', '%s', %d, %d, %f, %f, %f, %f, %f, %f, %f, %f, %f, %f, %f, %d)",
            HouseInfo[houseid][hID], HouseInfo[houseid][hAddress], HouseInfo[houseid][hOwner], HouseInfo[houseid][hOwned],
            HouseInfo[houseid][hPrice], HouseInfo[houseid][hX], HouseInfo[houseid][hY],
            HouseInfo[houseid][hZ], HouseInfo[houseid][hEnterX], HouseInfo[houseid][hEnterY], HouseInfo[houseid][hEnterZ],
            HouseInfo[houseid][hEnterA], HouseInfo[houseid][hExitX], HouseInfo[houseid][hExitY], \
            HouseInfo[houseid][hExitZ], HouseInfo[houseid][hExitA], HouseInfo[houseid][hInterior]);
            mysql_query(query);
    // Make sure you set the size of query here!
    strcat(query, tmpquery, 1024);