YCMD:asellhouse(playerid, params[], help) {
	new house, string[180], query[180];
	if(sscanf(params, "d", house)) return SCM(playerid, COLOR_GREY, "USAGE: {FFFFFF}/asellhouse <House ID>");
	if(PlayerInfo[playerid][pAdmin] < 5) return SCM(playerid, COLOR_GREY, "Nu ai nivelul necesar de admin pentru a face asta.");
	foreach(Player, i) {
		if(IsPlayerConnected(i) && PlayerInfo[i][pHouse] == house) {
			PlayerInfo[i][pHouse] = 999;
			PlayerInfo[i][pRented] = -1;
			Update(i, pHousex);
		}
	}
	HouseInfo[house][hHel] = 0;
	HouseInfo[house][hArm] = 0;
	HouseInfo[house][hLock] = 0;
	HouseInfo[house][hOwned] = 1;
	HouseInfo[house][hValue] = 0;
	format(query,sizeof(query),"UPDATE `houses` SET `Hel`='0',`Arm`='0',`Lockk`='0',`Owned`='1',`Owner`='The State',`Value`='0' WHERE `ID`='%d'",house);
	mysql_query(SQL,query);
	format(query,sizeof(query),"UPDATE users SET `House`='999' WHERE `name`='%s'",HouseInfo[house][hOwner]);
	mysql_query(SQL,query);
	strmid(HouseInfo[house][hOwner], "The State", 0, strlen("The State"), 255);
	PlayerPlaySound(playerid, 1052, 0.0, 0.0, 0.0);
	format(string, sizeof(string), "* Casa %d a fost vandut cu succes la stat!", house);
	SCM(playerid, COLOR_YELLOW, string);
	UpdateLabel(1, house);
	return 1;
}

YCMD:buyhouse(playerid, params[], help) {
	new id, szQuery[256], newmoneys, moneys, string[180];
	for(new h = 1; h < sizeof(HouseInfo); h++) {
		if(PlayerToPoint(2.0, playerid, HouseInfo[h][hEntrancex], HouseInfo[h][hEntrancey], HouseInfo[h][hEntrancez])) {
			if(HouseInfo[h][hValue] == 0) return 1;
			if(PlayerInfo[playerid][pLevel] < HouseInfo[h][hLevel]) {
				format(string, sizeof(string), "Ai nevoie de nivel %d pentru a cumpara.", HouseInfo[h][hLevel]);
				SCM(playerid, COLOR_WHITE, string);
				return 1;
			}
			if(PlayerInfo[playerid][pHouse] != 999 && strcmp(GetName(playerid), HouseInfo[PlayerInfo[playerid][pHouse]][hOwner], true) == 0) return SCM(playerid, COLOR_WHITE, "Ai deja o casa.");
			if(GetPlayerCash(playerid) < HouseInfo[h][hValue]) return SCM(playerid, COLOR_GREY, "Nu ai destui bani pentru a cumpara aceasta casa.");
			id = GetPlayerID(HouseInfo[h][hOwner]);
			if(id != INVALID_PLAYER_ID) {
				PlayerInfo[id][pHouse] = 999;
				Update(id, pHousex);
				PlayerInfo[id][pAccount] += HouseInfo[h][hValue];
				format(string, sizeof(string), "* %s ti-a cumparat casa pentru {19CF2E}$%s{239931}. Banii au fost transferati in contul tau bancar.", GetName(playerid), FormatNumber(HouseInfo[h][hValue]));
				SCM(id, 0x239931FF, string);
				format(szQuery,sizeof(szQuery),"UPDATE users SET `Bank`='%d' WHERE `ID`='%d'",PlayerInfo[id][pAccount],PlayerInfo[id][pSQLID]);
				mysql_query(SQL,szQuery);
			}
			else {
				format(szQuery, sizeof(szQuery), "SELECT * FROM `users` WHERE `name` = '%s'", HouseInfo[h][hOwner]);
				new Cache: result = mysql_query(SQL, szQuery);
				if(cache_get_row_count() != 0) {
					cache_get_field_content(0, "Bank", string); moneys = strval(string);
					newmoneys = moneys + HouseInfo[h][hValue];
				}
				cache_delete(result);
				format(szQuery, sizeof(szQuery), "UPDATE `users` SET `Bank` = '%d', `House` = '999' WHERE `name` = '%s'", newmoneys, HouseInfo[h][hOwner]);
				mysql_tquery(SQL, szQuery, "", "");
			}
			InHouse[playerid] = h;
			PlayerInfo[playerid][pHouse] = HouseInfo[h][hID];
			PlayerInfo[playerid][pRented] = -1;
			HouseInfo[h][hOwned] = 1;
			format(HouseInfo[h][hOwner], 256, GetName(playerid));
			GivePlayerCash(playerid,-HouseInfo[h][hValue]);
			SetPlayerInterior(playerid,HouseInfo[h][hInterior]);
			SetPlayerPosEx(playerid,HouseInfo[h][hExitx],HouseInfo[h][hExity],HouseInfo[h][hExitz]);
			SetPlayerVirtualWorld(playerid,HouseInfo[h][hVirtual]);
			PlayerInfo[playerid][pInt] = HouseInfo[h][hInterior];
			PlayerInfo[playerid][pLocal] = h;
			HouseInfo[h][hValue] = 0;
			SCM(playerid, COLOR_MONEY, "Felicitari! Ti-ai cumparat aceasta casa.");
			Update(playerid,pCashx);
			Update(playerid,pHousex);
			format(szQuery,sizeof(szQuery),"UPDATE `houses` SET `Owned`='1',`Owner`='%s',`Value`='0' WHERE `ID`='%d'",GetName(playerid),HouseInfo[h][hID]);
			mysql_query(SQL,szQuery);
			UpdateLabel(1,h);
			finishAchievement(playerid, 3);
		}
	}
	return 1;
}