property.cfg в таблицу MySQL

[vitalik6243]

Здраствуйте как мне перевести дома в таблицу MySQL?
Я вот пробовал вот так:

stock LoadProperty()
{
    new time = GetTickCount();
	new arrCoords[25][64];
	new strFromFile2[256];
	new File: file = fopen("gamefiles/property.cfg", io_read);
	if(file)
	{
		new idx;
		while(idx < sizeof(HouseInfo))
		{
			fread(file, strFromFile2);
			split(strFromFile2, arrCoords, ',');
			HouseInfo[idx][hEntrancex] = floatstr(arrCoords[0]);
			HouseInfo[idx][hEntrancey] = floatstr(arrCoords[1]);
			HouseInfo[idx][hEntrancez] = floatstr(arrCoords[2]);
			HouseInfo[idx][hExitx] = floatstr(arrCoords[3]);
			HouseInfo[idx][hExity] = floatstr(arrCoords[4]);
			HouseInfo[idx][hExitz] = floatstr(arrCoords[5]);
			strmid(HouseInfo[idx][hOwner], arrCoords[6], 0, strlen(arrCoords[6]), 255);
			HouseInfo[idx][hValue] = strval(arrCoords[7]);
			HouseInfo[idx][hHel] = strval(arrCoords[8]);
			HouseInfo[idx][hInt] = strval(arrCoords[9]);
			HouseInfo[idx][hLock] = strval(arrCoords[10]);
			HouseInfo[idx][hOwned] = strval(arrCoords[11]);
			HouseInfo[idx][hTakings] = strval(arrCoords[12]);
			HouseInfo[idx][hClass] = strval(arrCoords[13]);
			HouseInfo[idx][hCarx] = floatstr(arrCoords[14]);
			HouseInfo[idx][hCary] = floatstr(arrCoords[15]);
			HouseInfo[idx][hCarz] = floatstr(arrCoords[16]);
			HouseInfo[idx][hCarc] = floatstr(arrCoords[17]);
			idx++;
			new addhouse1[1000];
            format(addhouse1, sizeof(addhouse1), "INSERT INTO `houses` (`ID`, `Entrancex`, `Entrancey`, `Entrancez`,\
            `Exitx`,`Exity`,`Exitz`,`Owner`,`Value`,`Hel`,`Int`,`Lock`,`Owned`,`Takings`,`Class`,`Carx`,`Cary`\
            ,`Carz`,`Carc`)\
            VALUES ('%d', '%f', '%f', '%f','%f','%f','%f', '%s', '%d', '%d','%d','%d','%d', '%d', '%f', '%f', '%f', '%f')",\
            floatstr(arrCoords[0]),
            floatstr(arrCoords[1]),
            floatstr(arrCoords[2]),
            floatstr(arrCoords[3]),
            floatstr(arrCoords[4]),
            floatstr(arrCoords[5]),
			strval(arrCoords[6]),
            strval(arrCoords[7]),
            strval(arrCoords[8]),
            strval(arrCoords[9]),
            strval(arrCoords[10]),
            strval(arrCoords[11]),
            strval(arrCoords[12]),
            strval(arrCoords[13]),
            floatstr(arrCoords[14]),
            floatstr(arrCoords[15]),
            floatstr(arrCoords[16]),
            floatstr(arrCoords[17]));
            mysql_query(addhouse1);
		}
		fclose(file);
	}
	printf("[Загрузка домов]: Было загружено %d - потрачено %d (ms)", sizeof(HouseInfo), GetTickCount() - time);
	return true;
}

Но Вылазит вот такая вот ошибка

 - An error has occured. (Error ID: 1136, Column count doesn't match value count at row 1)

---------- Post added at 22:09 ---------- Previous post was at 21:42 ----------

Разобрался! Тема закрыта!