Непонятки с домами

[Alex_Lenez]

Проблема очень прикольная, такого даже никогда не видел. Расскажу по подробнее

Дома на Mysql, когда я ввожу какой нить команду связанную с домами, то происходит что-то странное например

я ввел команду /setpos 140

Дом 140 пропал на место его появился дом 100 ввожу /setpos 100 перемещается 100 дом. ввожу /setpos 140 также перемещается 100 дом

140 вообще дома нету



Кто знает помогите, в коде вроде как все нормально


Команда /setpos:

CMD:setpos(playerid, params[])
{
    if(PlayerInfo[playerid][pAdmin] < 6) return true;
	new house;
	if(sscanf(params, "d", house)) return	SendClientMessage(playerid, COLOR_WHITE, "::: Введите: /setpos [ Номер дома ]");
	new Float: lwx, Float:lwy, Float:lwz;
	GetPlayerPos(playerid, lwx, lwy, lwz);
	if(house <= 0 || house > TOTALHOUSE) return SendClientMessage(playerid, COLOR_LIGHTRED, "[Ошибка]: Вы ввели недопустимый номер дома");
	HouseInfo[house][hEntrancex] = lwx;
	HouseInfo[house][hEntrancey]= lwy;
	HouseInfo[house][hEntrancez] = lwz;
	BuyHouse(house);
	SaveHouse(house);
	return 1;
}

stock BuyHouse

stock BuyHouse(house)
{
	    if(logs == 1)
	    {
		   printr("BuyHouse");
	    }
	    new h = HouseInfo[house][hID];
		if(HouseInfo[h][hOwned] == 0)
		{
			DestroyDynamicMapIcon(HouseInfo[h][hMIcon]);
			DestroyPickup(HouseInfo[h][hPickup]);
			HouseInfo[h][hPickup] = CreatePickup(1273, 23, HouseInfo[h][hEntrancex], HouseInfo[h][hEntrancey], HouseInfo[h][hEntrancez],-1);
			pickups++;
			HouseInfo[h][hMIcon] = CreateDynamicMapIcon(HouseInfo[h][hEntrancex], HouseInfo[h][hEntrancey], HouseInfo[h][hEntrancez], 31, COLOR_WHITE, 0, -1, -1, 400.0);
		}
		if(HouseInfo[h][hOwned] == 1)
		{
			DestroyDynamicMapIcon(HouseInfo[h][hMIcon]);
			DestroyPickup(HouseInfo[h][hPickup]);
	    	HouseInfo[h][hPickup] = CreatePickup(1272, 23, HouseInfo[h][hEntrancex], HouseInfo[h][hEntrancey], HouseInfo[h][hEntrancez],-1);
			pickups++;
			HouseInfo[h][hMIcon] = CreateDynamicMapIcon(HouseInfo[h][hEntrancex], HouseInfo[h][hEntrancey], HouseInfo[h][hEntrancez], 32, COLOR_WHITE, 0, -1, -1, 400.0);
		}
	    return 1;
}

stock SaveHouse

stock SaveHouse(house)
{
    new query[800];
    new string[200];
    query = "UPDATE `house` SET ";
	acc_int_strcat(query, sizeof(query), "ID",HouseInfo[house][hID]);
	acc_float_strcat(query, sizeof(query), "EnterX",HouseInfo[house][hEntrancex]);
	acc_float_strcat(query, sizeof(query), "EnterY",HouseInfo[house][hEntrancey]);
	acc_float_strcat(query, sizeof(query), "EnterZ",HouseInfo[house][hEntrancez]);
	acc_float_strcat(query, sizeof(query), "ExitX",HouseInfo[house][hExitx]);
	acc_float_strcat(query, sizeof(query), "ExitY",HouseInfo[house][hExity]);
	acc_float_strcat(query, sizeof(query), "ExitZ",HouseInfo[house][hExitz]);
	acc_str_strcat(query, sizeof(query), "Owner",HouseInfo[house][hOwner]);
	acc_int_strcat(query, sizeof(query), "Value",HouseInfo[house][hValue]);
	acc_int_strcat(query, sizeof(query), "hHel",HouseInfo[house][hHel]);
	acc_int_strcat(query, sizeof(query), "hInt",HouseInfo[house][hInt]);
	acc_int_strcat(query, sizeof(query), "hLock",HouseInfo[house][hLock]);
	acc_int_strcat(query, sizeof(query), "Number",HouseInfo[house][hOwned]);
	acc_int_strcat(query, sizeof(query), "hTakings",HouseInfo[house][hTakings]);
	acc_int_strcat(query, sizeof(query), "hVec",HouseInfo[house][hVec]);
	acc_int_strcat(query, sizeof(query), "hVcol1",HouseInfo[house][hVcol1]);
	acc_int_strcat(query, sizeof(query), "hVcol2",HouseInfo[house][hVcol2]);
	acc_int_strcat(query, sizeof(query), "hKlass",HouseInfo[house][hKlass]);
	acc_int_strcat(query, sizeof(query), "hVehSost",HouseInfo[house][hVehSost]);
	acc_float_strcat(query, sizeof(query), "hCarx",HouseInfo[house][hCarx]);
	acc_float_strcat(query, sizeof(query), "hCary",HouseInfo[house][hCary]);
	acc_float_strcat(query, sizeof(query), "hCarz",HouseInfo[house][hCarz]);
	acc_float_strcat(query, sizeof(query), "hCarc",HouseInfo[house][hCarc]);
	acc_int_strcat(query, sizeof(query), "hMats",HouseInfo[house][hMats]);
	acc_int_strcat(query, sizeof(query), "hStyle",HouseInfo[house][hStyle]);
	acc_int_strcat(query, sizeof(query), "hSost",HouseInfo[house][hSost]);
	acc_int_strcat(query, sizeof(query), "hRobhouse",HouseInfo[house][hRobhouse]);
	acc_int_strcat(query, sizeof(query), "hMember",HouseInfo[house][hMember]);
	strdel(query, strlen(query)-1, strlen(query));
	format(string,sizeof(string)," WHERE `ID` = %d", HouseInfo[house][hID]);
	strcat(query, string);
	mysql_query(query);
	return 1;
}

загрузка домов

public LoadProperty()
{
	new fetch[200];
	new time = GetTickCount();
	mysql_query("SELECT * FROM `house`");
	mysql_store_result();
	new i;
	if(mysql_num_rows()>0)
	{
		while(mysql_fetch_row_format(fetch))
		{
            i++;
  			sscanf(fetch, "p<|>dffffffs[24]dddddddddddffffddddd",
  			HouseInfo[i][hID],
	    	HouseInfo[i][hEntrancex],
	        HouseInfo[i][hEntrancey],
			HouseInfo[i][hEntrancez],
			HouseInfo[i][hExitx],
			HouseInfo[i][hExity],
			HouseInfo[i][hExitz],
			HouseInfo[i][hOwner],
			HouseInfo[i][hValue],
			HouseInfo[i][hHel],
			HouseInfo[i][hInt],
			HouseInfo[i][hLock],
			HouseInfo[i][hOwned],
			HouseInfo[i][hTakings],
			HouseInfo[i][hVec],
			HouseInfo[i][hVcol1],
			HouseInfo[i][hVcol2],
			HouseInfo[i][hKlass],
			HouseInfo[i][hVehSost],
			HouseInfo[i][hCarx],
			HouseInfo[i][hCary],
		    HouseInfo[i][hCarz],
			HouseInfo[i][hCarc],
			HouseInfo[i][hMats],
			HouseInfo[i][hStyle],
			HouseInfo[i][hSost],
			HouseInfo[i][hRobhouse],
			HouseInfo[i][hMember]);
			if(HouseInfo[i][hOwned] == 0)
			{
				 HouseInfo[i][hPickup] = CreatePickup(1273, 23, HouseInfo[i][hEntrancex], HouseInfo[i][hEntrancey], HouseInfo[i][hEntrancez],-1);
				 pickups++;
				 HouseInfo[i][hMIcon] = CreateDynamicMapIcon(HouseInfo[i][hEntrancex], HouseInfo[i][hEntrancey], HouseInfo[i][hEntrancez], 31, COLOR_WHITE, 0, -1, -1, 400.0);
			}
			if(HouseInfo[i][hOwned] == 1)
			{
				HouseInfo[i][hPickup] = CreatePickup(1272, 23, HouseInfo[i][hEntrancex], HouseInfo[i][hEntrancey], HouseInfo[i][hEntrancez],-1);
				pickups++;
				HouseInfo[i][hMIcon] = CreateDynamicMapIcon(HouseInfo[i][hEntrancex], HouseInfo[i][hEntrancey], HouseInfo[i][hEntrancez], 32, COLOR_WHITE, 0, -1, -1, 400.0);
			}

		}
	}
	TOTALHOUSE = mysql_num_rows();
	mysql_free_result();
	printf("[Asistex-Rp]: Успешная загрузка 'Домов' - загружено %d за %d м.с", TOTALHOUSE,GetTickCount() - time);
	return 1;
}

Нельзя создавать отдельную тему да и не совсем по разделу, еще один вопрос кто знает!

Возможно ли скомпилировать на простой VPS Deban 6.0 исходник плагина написанный на C++, чтобы получилось .so ?
Слышал про makefile, но как именно это сделать и можно ли на простой VPS это сделать