[legho]

Hello ive created this house system and it works perfectly i create the houses IG with a command. it works perfectly for the first house i create. but then i try to create another and it doesent do anything to the DB but it prints...

Код:

stock CreateHouse(Float:EnterPosX,Float:EnterPosY,Float:EnterPosZ,Float:ExitPosX,Float:ExitPosY,Float:ExitPosZ,Int,Price)
{
	new query[128*4];
	houseid ++;
	HouseInfo[houseid][hEnterPos][0] = EnterPosX;
	HouseInfo[houseid][hEnterPos][1] = EnterPosY;
	HouseInfo[houseid][hEnterPos][2] = EnterPosZ;
	HouseInfo[houseid][hExitPos][0] = ExitPosX;
	HouseInfo[houseid][hExitPos][1] = ExitPosY;
	HouseInfo[houseid][hExitPos][2] = ExitPosZ;
	HouseInfo[houseid][hInt] = Int;
	HouseInfo[houseid][hPrice] = Price;

	format(query, sizeof(query), "INSERT INTO `houseinfo` (`HouseID`, `HouseOwner`, `EnterPosX`, `EnterPosY`, `EnterPosZ`, `ExitPosX`, `ExitPosY`, `ExitPosZ`, `World`, `Interior`, `Price` ) VALUES ('%d', 'For Sale', '%f', '%f', '%f', '%f', '%f', '%f', '%d', '%d', '%d')",houseid,HouseInfo[houseid][hEnterPos][0],HouseInfo[houseid][hEnterPos][1],HouseInfo[houseid][hEnterPos][2],HouseInfo[houseid][hExitPos][0],HouseInfo[houseid][hExitPos][1],HouseInfo[houseid][hExitPos][2],
	HouseInfo[houseid][hID],HouseInfo[houseid][hInt],HouseInfo[houseid][hPrice]);
	mysql_function_query(mCon, query, false, "", "","");
	printf("House ID: %d. has been created.",houseid);
	return 1;
}

Heres the num

Код:

enum hInfo
{
	hID,
    hOwner[MAX_PLAYER_NAME],
    Float:hEnterPos[3],
    Float:hExitPos[3],
    hInt,
    hPrice,
    Text3D:hText,
    Text3D:hExitText
};

new HouseInfo[MAX_HOUSES][hInfo], houseid;

I lack knowledge in MySQL and its syntax i would much appreciate it if someone could help.
Regards.