enum EHouseInfo {
	Float:EHouseX,
	Float:EHouseY,
	Float:EHouseZ,
	Float:EHouseExitX,
	Float:EHouseExitY,
	Float:EHouseExitZ,
	EHouseInterior,
	EHouseName[64],
	EHouseOwnerName[MAX_PLAYER_NAME],
	EHouseOwnerSQLID,
	EHouseSQLID,
	EHouseValue,
	EHouseLevel,
	EHousePickup,
	EHouseLocked,
	EHouseLights,
	EHouseRadioIndex,
	EHouseRentPrice, //0 = not renting
	Text3D:EHouseTextLabel,
};
new hinit = 0;
#define MAX_HOUSES 2000
new Houses[MAX_HOUSES][EHouseInfo];
new Text:HouseLightsText;
forward OnLoadHouses();
forward ReloadHouse(houseid);

housesOnGameModeInit() {
	loadHouses();
	HouseLightsText = TextDrawCreate(1.0,1.0,"D");
	TextDrawAlignment(HouseLightsText,0);
	TextDrawBackgroundColor(HouseLightsText,0x00000000);
	TextDrawFont(HouseLightsText,1);
	TextDrawLetterSize(HouseLightsText,200.0,400.0);
	TextDrawColor(HouseLightsText,0x000000A9);
	TextDrawSetOutline(HouseLightsText,false);
	TextDrawSetProportional(HouseLightsText,false);
	TextDrawSetShadow(HouseLightsText,false);
	TextDrawUseBox(HouseLightsText, true);
	TextDrawBoxColor(HouseLightsText, 0x000000A9);
}
loadHouses() {
	query[0] = 0;
	format(query, sizeof(query), "SELECT `houses`.`id`,`houses`.`X`,`houses`.`Y`,`houses`.`Z`,`EX`,`EY`,`EZ`,`houses`.`interior`,`houses`.`name`,`price`,`owner`,`c1`.`username`,`locked`,`houses`.`rent`,COUNT(`hf`.`house`) FROM `houses` LEFT JOIN `characters` AS `c1` ON `houses`.`owner` = `c1`.`id` LEFT JOIN `housefurniture` `hf` ON `hf`.house = `houses`.`id` GROUP BY `hf`.`house`,`houses`.`id`");
	mysql_function_query(g_mysql_handle, query, true, "OnLoadHouses", "");
}
public OnLoadHouses() {
	new rows, fields;
	new id_string[64];
	cache_get_data(rows, fields);
	for(new i=0;i<rows;i++) {
		if(Houses[i][EHouseSQLID] != 0) continue; //because this is also used for reloading houses
		cache_get_row(i, 0, id_string);
		Houses[i][EHouseSQLID] = strval(id_string);
		
		cache_get_row(i, 1, id_string);
		Houses[i][EHouseX] = floatstr(id_string);
		
		cache_get_row(i, 2, id_string);
		Houses[i][EHouseY] = floatstr(id_string);
		
		cache_get_row(i, 3, id_string);
		Houses[i][EHouseZ] = floatstr(id_string);
		
		cache_get_row(i, 4, id_string);
		Houses[i][EHouseExitX] = floatstr(id_string);
		
		cache_get_row(i, 5, id_string);
		Houses[i][EHouseExitY] = floatstr(id_string);
		
		cache_get_row(i, 6, id_string);
		Houses[i][EHouseExitZ] = floatstr(id_string);
		
		cache_get_row(i, 7, id_string);
		Houses[i][EHouseInterior] = strval(id_string);
		
		cache_get_row(i, 8, Houses[i][EHouseName]);
		
		cache_get_row(i, 9, id_string);
		Houses[i][EHouseValue] = strval(id_string);

		cache_get_row(i, 10, id_string);
		Houses[i][EHouseOwnerSQLID] = strval(id_string);
		
		cache_get_row(i, 11, Houses[i][EHouseOwnerName]);
		
		cache_get_row(i, 12, id_string);
		Houses[i][EHouseLocked] = strval(id_string);
		if(Houses[i][EHouseOwnerSQLID] == 0) {
			Houses[i][EHouseLocked] = 1;
		}
		
		cache_get_row(i, 13, id_string);
		Houses[i][EHouseRentPrice] = strval(id_string);
		
		Houses[i][EHouseLights] = 1; //off by default
		Houses[i][EHouseRadioIndex] = -1;
		
		Houses[i][EHousePickup] = CreateDynamicPickup(Houses[i][EHouseOwnerSQLID]>0?1272:1273,16,Houses[i][EHouseX], Houses[i][EHouseY], Houses[i][EHouseZ]);
		
		new labeltext[256];
		getHouseTextLabel(i, labeltext, sizeof(labeltext));
		Houses[i][EHouseTextLabel] = CreateDynamic3DTextLabel(labeltext, 0x00FF00FF, Houses[i][EHouseX], Houses[i][EHouseY], Houses[i][EHouseZ]+1.0,15.0);
		
		cache_get_row(i, 14, id_string);
		if(strval(id_string) > 0)
			LoadHouseFurniture(i);
	}
	if(hinit == 0) {
		sellInactiveHouses();
		loadHouseSafes();
		hinit = 1;
	}
	return 1;
}
houseGetVirtualWorld(houseid) {
	return houseid+20000;
}
houseGetInterior(houseid) {
	return Houses[houseid][EHouseInterior];
}
housesTryEnterExit(playerid) {
	for(new i=0;i<sizeof(Houses);i++) {
		if(IsPlayerInRangeOfPoint(playerid, 1.5, Houses[i][EHouseX],Houses[i][EHouseY],Houses[i][EHouseZ])) {
			if(IsHouseLocked(i)) {
				GameTextForPlayer(playerid, "~r~Locked", 2000, 1);
				return 1;
			}
			if(Houses[i][EHouseLights] == 1) {
				TextDrawShowForPlayer(playerid, HouseLightsText);
			}
			if(Houses[i][EHouseRadioIndex] != -1) {
				new url[128];
				getRadioURL(Houses[i][EHouseRadioIndex], url, sizeof(url));
				PlayAudioStreamForPlayer(playerid, url);
			}
			SetPlayerPos(playerid,  Houses[i][EHouseExitX],Houses[i][EHouseExitY],Houses[i][EHouseExitZ]);
			SetPlayerInterior(playerid, Houses[i][EHouseInterior]);
			SetPlayerVirtualWorld(playerid, houseGetVirtualWorld(i));
		} else if(IsPlayerInRangeOfPoint(playerid, 5.0, Houses[i][EHouseExitX],Houses[i][EHouseExitY],Houses[i][EHouseExitZ])) {
			if(GetPlayerVirtualWorld(playerid) == houseGetVirtualWorld(i)) {
				if(Houses[i][EHouseLights] == 1) {
					TextDrawHideForPlayer(playerid, HouseLightsText);
				}
				if(Houses[i][EHouseRadioIndex] != -1) {
					StopAudioStreamForPlayer(playerid);
				}
				SetPlayerPos(playerid, Houses[i][EHouseX],Houses[i][EHouseY],Houses[i][EHouseZ]);
				SetPlayerInterior(playerid, 0);
				SetPlayerVirtualWorld(playerid, 0);
			}
		}
	}
	return 1;
}
YCMD:displayhouseinfo(playerid, params[], help) {
	if(help) {
		SendClientMessage(playerid, X11_WHITE, "Displays information on a house");
		return 1;
	}
	new houseid;
	if(sscanf(params,"d",houseid)) {
		houseid = getStandingHouse(playerid);
		if(houseid == -1) {
			SendClientMessage(playerid, X11_TOMATO_2, "You must be standing near a house");
			return 1;
		}
	}
	if(houseid < 0 || houseid > sizeof(Houses) || Houses[houseid][EHouseSQLID] == 0) {
		SendClientMessage(playerid, X11_TOMATO_2, "Invalid House");
		return 1;
	}
	format(query, sizeof(query), "******** %s[%d] ********",Houses[houseid][EHouseName],houseid);
	SendClientMessage(playerid, X11_WHITE, query);
	format(query, sizeof(query), "* House ID: %d SQLID: %d",houseid,Houses[houseid][EHouseSQLID]);
	SendClientMessage(playerid, COLOR_LIGHTBLUE, query);
	format(query, sizeof(query), "* Owner %s[%d]",Houses[houseid][EHouseOwnerName],Houses[houseid][EHouseOwnerSQLID]);
	SendClientMessage(playerid, COLOR_LIGHTBLUE, query);
	format(query, sizeof(query), "* Pos: (%f,%f,%f)",Houses[houseid][EHouseX],Houses[houseid][EHouseY],Houses[houseid][EHouseZ]);
	SendClientMessage(playerid, COLOR_LIGHTBLUE, query);
	format(query, sizeof(query), "* EPos: (%f,%f,%f,%d,%d)",Houses[houseid][EHouseExitX],Houses[houseid][EHouseExitY],Houses[houseid][EHouseExitZ],Houses[houseid][EHouseInterior],houseGetVirtualWorld(houseid));
	SendClientMessage(playerid, COLOR_LIGHTBLUE, query);
	format(query, sizeof(query), "* Rent: %d Locked: %d",Houses[houseid][EHouseRentPrice],Houses[houseid][EHouseLocked] );
	SendClientMessage(playerid, COLOR_LIGHTBLUE, query);
	SendClientMessage(playerid, X11_WHITE, "*******************");
	return 1;
}
YCMD:sethouseowner(playerid, params[], help) {
	if(help) {
		SendClientMessage(playerid, X11_WHITE, "Changes a houses owner");
		return 1;
	}
	new houseid, user;
	if(!sscanf(params, "k<playerLookup_acc>D(-1)", user, houseid)) {
		if(!IsPlayerConnectEx(user)) {
			//SendClientMessage(playerid, X11_TOMATO_2, "User not found");
			//return 1;
			user = -1;
		}
		if(houseid == -1) {
			houseid = getStandingHouse(playerid);
			if(houseid == -1) {
				SendClientMessage(playerid, X11_TOMATO_2, "You must be standing near a house");
				return 1;
			}
		}
		if(houseid < 0 || houseid > sizeof(Houses) || Houses[houseid][EHouseSQLID] == 0) {
			SendClientMessage(playerid, X11_TOMATO_2, "Invalid House");
			return 1;
		}
		setHouseOwner(houseid, user);
		SendClientMessage(playerid, COLOR_LIGHTGREEN, "* Owner updated");
	} else {
		SendClientMessage(playerid, X11_WHITE, "USAGE: /sethouseowner [user(or -1)] (house)");
	}
	return 1;
}
YCMD:gotohouse(playerid, params[], help) {
	if(help) {
		SendClientMessage(playerid, X11_WHITE, "Changes a houses owner");
		return 1;
	}
	new houseid;
	if(!sscanf(params,"d", houseid)) {
		if(houseid < 0 || houseid > sizeof(Houses) || Houses[houseid][EHouseSQLID] == 0) {
			SendClientMessage(playerid, X11_TOMATO_2, "Invalid House");
			return 1;
		}
		SetPlayerPos(playerid, Houses[houseid][EHouseX],Houses[houseid][EHouseY],Houses[houseid][EHouseZ]);
		SetPlayerInterior(playerid, 0);
		SetPlayerVirtualWorld(playerid, 0);
		SendClientMessage(playerid, X11_ORANGE, "You have been teleported");
	} else {
		SendClientMessage(playerid, X11_WHITE, "USAGE: /gotohouse [houseid]");
	}
	return 1;
}
houseOnPlayerLogin(playerid) {
	SetTimerEx("HouseSync", 1000, false, "d", playerid);
}
forward HouseSync(playerid);
public HouseSync(playerid) {
	new house = getStandingExit(playerid, 150.0);
	if(house != -1) {
		if(Houses[house][EHouseLights] == 1) {
			TextDrawShowForPlayer(playerid, HouseLightsText);
		} else {
			TextDrawHideForPlayer(playerid, HouseLightsText);
		}
		if(Houses[house][EHouseRadioIndex] != -1) {
			new url[128];
			getRadioURL(Houses[house][EHouseRadioIndex], url, sizeof(url));
			PlayAudioStreamForPlayer(playerid, url);
		}
	}
}
YCMD:houselights(playerid, params[], help) {
	if(help) {
		SendClientMessage(playerid, X11_WHITE, "Toggle house lights on/off");
	}
	new house = getStandingExit(playerid);
	if(house == -1) {
		SendClientMessage(playerid, X11_TOMATO_2, "You aren't in a house!");
		return 1;
	}
	toggleLights(playerid, house);
	return 1;
}
toggleLights(playerid, house) {
	new msg[128];
	switch(Houses[house][EHouseLights]) {
		case 1: {
			format(msg, sizeof(msg), "* %s switches the lights on.",GetPlayerNameEx(playerid, ENameType_RPName));
			setLights(house, 0);
		}
		case 0: {
			format(msg, sizeof(msg), "* %s switches the lights off.",GetPlayerNameEx(playerid, ENameType_RPName));
			setLights(house, 1);
		}
	}
	ProxMessage(15.0, playerid, msg, COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE);
}
stock setLights(house, lights) {
	foreach(Player, i) {
		if(getStandingExit(i, 150.0) == house) {
			if(lights) {
				TextDrawShowForPlayer(i, HouseLightsText);
				Houses[house][EHouseLights] = 1;
			} else {
				TextDrawHideForPlayer(i, HouseLightsText);
				Houses[house][EHouseLights] = 0;
			}
		}
	}
}
GetNumOwnedHouses(playerid) {
	new num;
	for(new i=0;i<sizeof(Houses);i++) {
		if(Houses[i][EHouseOwnerSQLID] == GetPVarInt(playerid, "CharID")) {
			num++;
		}
	}
	return num;
}
YCMD:buyhouse(playerid, params[], help) {
	new msg[128];
	if(help) {
		SendClientMessage(playerid, X11_WHITE, "Used for buying a house");
		return 1;
	}
	new num = GetNumOwnedHouses(playerid);
	if(num >= GetPVarInt(playerid, "MaxHouses")) {
		SendClientMessage(playerid, X11_TOMATO_2, "You cannot own any more houses!");
		return 1;
	}
	new house = getStandingHouse(playerid);
	if(house == -1) {
		SendClientMessage(playerid, X11_TOMATO_2, "You must be standing near a house");
		return 1;
	}
	if(Houses[house][EHouseOwnerSQLID] != 0) {
		SendClientMessage(playerid, X11_TOMATO_2, "This house is already owned by someone");
		return 1;
	}
	new confirmtext[32];
	if(!sscanf(params,"s[32]",confirmtext)) {
		if(strcmp(confirmtext,"confirm", true) != 0) {
			SendClientMessage(playerid, X11_TOMATO_2, "You must type /buyhouse confirm");
			return 1;
		}
	} else {
		format(msg, sizeof(msg), "* This house costs $%s, type /buyhouse confirm",getNumberString(Houses[house][EHouseValue]));
		SendClientMessage(playerid, COLOR_LIGHTGREEN, msg);
		return 1;
	}
	new money = GetMoneyEx(playerid);
	if(money < Houses[house][EHouseValue]) {
		format(msg, sizeof(msg), "You do not have enough money, you need $%s more to buy this house.",getNumberString(Houses[house][EHouseValue]-money));
		SendClientMessage(playerid, X11_TOMATO_2, msg);
		return 1;
	}
	GiveMoneyEx(playerid, -Houses[house][EHouseValue]);
	setHouseOwner(house, playerid);
	SendClientMessage(playerid, COLOR_LIGHTGREEN, "* Congratulations on your new house!");
	return 1;
}
YCMD:sellhouse(playerid, params[], help) {
	new msg[128];
	if(help) {
		SendClientMessage(playerid, X11_WHITE, "Used for selling your house");
		return 1;
	}
	new house = getStandingHouse(playerid);
	if(house == -1) {
		SendClientMessage(playerid, X11_TOMATO_2, "You must be standing near a house");
		return 1;
	}
	if(Houses[house][EHouseOwnerSQLID] != GetPVarInt(playerid, "CharID")) {
		SendClientMessage(playerid, X11_TOMATO_2, "This is not your house!");
		return 1;
	}
	new housevalue = Houses[house][EHouseValue];
	new deduction = floatround(Houses[house][EHouseValue]*0.20);
	housevalue -= deduction;
	new confirmtext[32];
	if(!sscanf(params,"s[32]",confirmtext)) {
		if(strcmp(confirmtext,"confirm", true) != 0) {
			SendClientMessage(playerid, X11_TOMATO_2, "You must type /sellhouse confirm");
			return 1;
		}
	} else {
		format(msg, sizeof(msg), "* You will get $%s for selling this house (( /sellhouse confirm ))",getNumberString(housevalue));
		SendClientMessage(playerid, COLOR_LIGHTGREEN, msg);
		return 1;
	}
	setHouseOwner(house, -1);
	GiveMoneyEx(playerid, housevalue);
	SendClientMessage(playerid, COLOR_LIGHTGREEN, "* You have sold your house!");
	return 1;
}
YCMD:givehouse(playerid, params[], help) {
	if(help) {
		SendClientMessage(playerid, X11_WHITE, "Used for selling your house");
		return 1;
	}
	new house = getStandingHouse(playerid);
	if(house == -1) {
		SendClientMessage(playerid, X11_TOMATO_2, "You must be standing near a house");
		return 1;
	}
	if(Houses[house][EHouseOwnerSQLID] != GetPVarInt(playerid, "CharID")) {
		SendClientMessage(playerid, X11_TOMATO_2, "This is not your house!");
		return 1;
	}
	new user;
	if(!sscanf(params, "k<playerLookup>", user)) {
		if(!IsPlayerConnectEx(user)) {
			SendClientMessage(playerid, X11_TOMATO_2, "User not found");
			return 1;
		}
		new Float:X, Float:Y, Float:Z;
		GetPlayerPos(user, X, Y, Z);
		if(!IsPlayerInRangeOfPoint(playerid, 5.0, X, Y, Z)) {
			SendClientMessage(playerid, X11_TOMATO_2, "This person is too far away!");
			return 1;
		}
		SendClientMessage(playerid, COLOR_LIGHTGREEN, "* House Given");
		SendClientMessage(user, COLOR_LIGHTGREEN, "* House Recieved");
		setHouseOwner(house, user);
	} else {
		SendClientMessage(playerid, X11_WHITE, "USAGE: /givehouse [playerid/name]");
	}
	return 1;
}
YCMD:myhouses(playerid, params[], help) {
	if(help) {
		SendClientMessage(playerid, X11_WHITE, "Lists a players houses");
		return 1;
	}
	new msg[128];
	new num;
	new charid = GetPVarInt(playerid, "CharID");
	new unlocked[] = "Unlocked";
	new locked[] = "Locked";
	for(new i=0;i<sizeof(Houses);i++) {
		if(Houses[i][EHouseOwnerSQLID] == charid) {
			format(msg, sizeof(msg), "%d. %s (ID: %d, %s)",++num,Houses[i][EHouseName],i,Houses[i][EHouseLocked]==0?unlocked:locked);
			SendClientMessage(playerid, X11_WHITE, msg);
		}
	}
	return 1;
}
YCMD:displayplayerhouses(playerid, params[], help) {
	if(help) {
		SendClientMessage(playerid, X11_WHITE, "Displays a players house");
		return 1;
	}
	new playa;
	if(!sscanf(params, "k<playerLookup_acc>", playa)) {
		if(!IsPlayerConnectEx(playa)) {
			SendClientMessage(playerid, X11_TOMATO_2, "User not found");
			return 1;
		}
		new msg[128];
		new num;
		new charid = GetPVarInt(playa, "CharID");
		new unlocked[] = "Unlocked";
		new locked[] = "Locked";
		for(new i=0;i<sizeof(Houses);i++) {
			if(Houses[i][EHouseOwnerSQLID] == charid) {
				format(msg, sizeof(msg), "%d. %s (ID: %d, %s SQL ID: %d)",++num,Houses[i][EHouseName],i,Houses[i][EHouseLocked]==0?unlocked:locked,Houses[i][EHouseSQLID]);
				SendClientMessage(playerid, X11_WHITE, msg);
			}
		}
	} else {
		SendClientMessage(playerid, X11_WHITE, "USAGE: /displayplayerhouses [playerid/name]");
	}
	return 1;
}
YCMD:door(playerid, params[], help) {
	if(help) {
		SendClientMessage(playerid, X11_WHITE, "Locks/unlocks a house door");
		return 1;
	}
	new house = getStandingHouse(playerid);
	
	if(house == -1) {
		house = getStandingExit(playerid);
		if(house == -1) {
			SendClientMessage(playerid, X11_TOMATO_2, "You must be standing near a house");
			return 1;
		}
	}
	if(!hasHouseKeys(playerid, house)) {
		SendClientMessage(playerid, X11_TOMATO_2, "This is not your house!");
		return 1;
	}
	new msg[128];
	if(Houses[house][EHouseLocked] == 1) {
		format(msg, sizeof(msg), "* %s unlocked the door.", GetPlayerNameEx(playerid, ENameType_RPName));
		ProxMessage(15.0, playerid, msg, COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE);
		GameTextForPlayer(playerid, "~w~House ~g~Unlocked", 5000, 6);
		PlayerPlaySound(playerid, 1145, 0.0, 0.0, 0.0);
		Houses[house][EHouseLocked] = 0;
	} else {
		format(msg, sizeof(msg), "* %s locked the door.",  GetPlayerNameEx(playerid, ENameType_RPName));
		ProxMessage(15.0, playerid, msg, COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE);
		GameTextForPlayer(playerid, "~w~House ~r~Locked", 5000, 6);
		PlayerPlaySound(playerid, 1145, 0.0, 0.0, 0.0);
		Houses[house][EHouseLocked] = 1;
	}
	saveHouseInfo(house);
	return 1;
}
hasHouseKeys(playerid, house) {
	new rent = GetPVarInt(playerid, "Rent");
	return Houses[house][EHouseOwnerSQLID] == GetPVarInt(playerid, "CharID") || rent == Houses[house][EHouseSQLID];
}
getHouseOwner(house) {
	return Houses[house][EHouseOwnerSQLID];
}
YCMD:toghouselock(playerid, params[], help) {
	if(help) {
		SendClientMessage(playerid, X11_WHITE, "Unlocks a players house(temporarily)");
		return 1;
	}
	new house = getStandingHouse(playerid);
	
	if(house == -1) {
		house = getStandingExit(playerid);
		if(house == -1) {
			SendClientMessage(playerid, X11_TOMATO_2, "You must be standing near a house");
			return 1;
		}
	}
	if(Houses[house][EHouseLocked] == 1) {
		GameTextForPlayer(playerid, "~w~House ~g~Unlocked", 5000, 6);
		PlayerPlaySound(playerid, 1145, 0.0, 0.0, 0.0);
		Houses[house][EHouseLocked] = 0;
	} else {
		GameTextForPlayer(playerid, "~w~House ~r~Locked", 5000, 6);
		PlayerPlaySound(playerid, 1145, 0.0, 0.0, 0.0);
		Houses[house][EHouseLocked] = 1;
	}
	saveHouseInfo(house);
	return 1;
}
YCMD:gotohouseinterior(playerid, params[], help) {
	if(help) {
		SendClientMessage(playerid, X11_WHITE, "Teleports to the interior of a house");
		return 1;
	}
	new house;
	if(!sscanf(params, "d", house)) {
		if(house < 0 || house > sizeof(Houses) || Houses[house][EHouseSQLID] == 0) {
			SendClientMessage(playerid, X11_TOMATO_2, "Invalid House ID");
			return 1;
		}
		SetPlayerPos(playerid, Houses[house][EHouseExitX],Houses[house][EHouseExitY],Houses[house][EHouseExitZ]);
		SetPlayerInterior(playerid, Houses[house][EHouseInterior]);
		SetPlayerVirtualWorld(playerid, houseGetVirtualWorld(house));
	} else {
		SendClientMessage(playerid, X11_WHITE, "USAGE: /gotohouseinterior [houseid]");
	}
	return 1;
}
YCMD:sethousename(playerid, params[], help) {
	if(help) {
		SendClientMessage(playerid, X11_WHITE, "Updates a houses description");
		return 1;
	}
	new house = getStandingHouse(playerid);
	if(house == -1) {
		SendClientMessage(playerid, X11_TOMATO_2, "You must be standing near a house");
		return 1;
	}
	new name[64],name_esc[(sizeof(name)*2)+1];
	if(!sscanf(params,"s[64]", name)) {
		query[0] = 0;
		mysql_real_escape_string(name, name_esc);
		format(Houses[house][EHouseName],64,"%s",name);
		format(query, sizeof(query), "UPDATE `houses` SET `name` = \"%s\" WHERE `id` = %d", name_esc, Houses[house][EHouseSQLID]);
		mysql_function_query(g_mysql_handle, query, true, "EmptyCallback", "");		
		new labeltext[128];
		getHouseTextLabel(house, labeltext, sizeof(labeltext));
		UpdateDynamic3DTextLabelText(Houses[house][EHouseTextLabel],0x00FF00FF, labeltext);
	} else {
		SendClientMessage(playerid, X11_WHITE, "USAGE: /sethousename [name]");
		SendClientMessage(playerid, X11_WHITE, "You must be standing at the house pickup to do this.");
	}
	return 1;
}

public ReloadHouse(houseid) {
	query[0] = 0;
	format(query, sizeof(query), "SELECT `houses`.`id`,`houses`.`X`,`houses`.`Y`,`houses`.`Z`,`EX`,`EY`,`EZ`,`houses`.`interior`,`houses`.`name`,`price`,`owner`,`c1`.`username`,`locked`,`rent` FROM `houses`  LEFT JOIN `characters` AS `c1` ON `houses`.`owner` = `c1`.`id` WHERE `houses`.`id` = %d",Houses[houseid][EHouseSQLID]);
	Houses[houseid][EHouseSQLID] = 0;
	DestroyDynamicPickup(Houses[houseid][EHousePickup]);
	DestroyDynamic3DTextLabel(Houses[houseid][EHouseTextLabel]);
	mysql_function_query(g_mysql_handle, query, true, "OnLoadHouses", "");
}
saveHouseInfo(house) {
	query[0] = 0;
	format(query, sizeof(query), "UPDATE `houses` SET `locked` = %d,`owner` = %d WHERE `id` = %d",Houses[house][EHouseLocked],Houses[house][EHouseOwnerSQLID],Houses[house][EHouseSQLID]);
	mysql_function_query(g_mysql_handle, query, true, "EmptyCallback", "");
}
getStandingHouse(playerid, Float:radi = 2.0) {
	for(new i=0;i<sizeof(Houses);i++) {
		if(IsPlayerInRangeOfPoint(playerid, radi, Houses[i][EHouseX],Houses[i][EHouseY],Houses[i][EHouseZ])) {
			return i;
		}
	}
	return -1;
}
getStandingExit(playerid, Float:radi = 5.0) {
	for(new i=0;i<sizeof(Houses);i++) {
		if(IsPlayerInRangeOfPoint(playerid, radi, Houses[i][EHouseExitX],Houses[i][EHouseExitY],Houses[i][EHouseExitZ])) {
			if(GetPlayerVirtualWorld(playerid) == houseGetVirtualWorld(i)) {
				return i;
			}
		}
	}
	return -1;
}
sendMessageToHouses(playerid, Float:radi = 30.0, msg[], color) {
	for(new i=0;i<sizeof(Houses);i++) {
		if(IsPlayerInRangeOfPoint(playerid, radi, Houses[i][EHouseX],Houses[i][EHouseY],Houses[i][EHouseZ])) {
			SendAreaMessage(radi, Houses[i][EHouseExitX],Houses[i][EHouseExitY],Houses[i][EHouseExitZ], houseGetVirtualWorld(i), msg, color);
		} else if(IsPlayerInRangeOfPoint(playerid, radi, Houses[i][EHouseExitX],Houses[i][EHouseExitY],Houses[i][EHouseExitZ])) {
			SendAreaMessage(radi, Houses[i][EHouseX],Houses[i][EHouseY],Houses[i][EHouseZ], 0, msg, color);
		}
	}
	return 1;
}
setHouseOwner(houseid, playerid) {
	query[0] = 0;
	if(playerid == -1 || playerid == INVALID_PLAYER_ID) {
		Houses[houseid][EHouseOwnerSQLID] = 0;
	} else {
		Houses[houseid][EHouseOwnerSQLID] = GetPVarInt(playerid, "CharID");
	}
	if(HouseHasSafe(houseid)) {
		DeleteHouseSafe(houseid);
	}
	Houses[houseid][EHouseLocked] = 1;
	DestroyHouseObjects(houseid);
	new labeltext[128];
	format(query, sizeof(query), "UPDATE `houses` SET `owner` = %d WHERE `id` = %d", GetPVarInt(playerid, "CharID"), Houses[houseid][EHouseSQLID]);
	mysql_function_query(g_mysql_handle, query, true, "EmptyCallback", "");
	DestroyDynamicPickup(Houses[houseid][EHousePickup]);
	format(Houses[houseid][EHouseOwnerName],MAX_PLAYER_NAME,"%s",GetPlayerNameEx(playerid, ENameType_CharName));
	getHouseTextLabel(houseid, labeltext, sizeof(labeltext));
	UpdateDynamic3DTextLabelText(Houses[houseid][EHouseTextLabel],0x00FF00FF, labeltext);
	Houses[houseid][EHousePickup] = CreateDynamicPickup(Houses[houseid][EHouseOwnerSQLID]>0?1272:1273,16,Houses[houseid][EHouseX], Houses[houseid][EHouseY], Houses[houseid][EHouseZ]);
}
getHouseTextLabel(houseid, dst[], dstlen) {
	if(Houses[houseid][EHouseOwnerSQLID] == 0) {
		format(dst, dstlen, "* %s\n{FF0000}For Sale{00FF00} *\nPrice: {00FF00}: $%s",Houses[houseid][EHouseName],getNumberString(Houses[houseid][EHouseValue]));
	} else {
		if(Houses[houseid][EHouseRentPrice] != 0)  {
			format(dst, dstlen, "* %s\nOwner: {FF0000}%s\n{00FF00}Rent: {FF0000}$%s",Houses[houseid][EHouseName],Houses[houseid][EHouseOwnerName],getNumberString(Houses[houseid][EHouseRentPrice]));
		} else {
			format(dst, dstlen, "* %s\nOwner: {FF0000}%s",Houses[houseid][EHouseName],Houses[houseid][EHouseOwnerName]);
		}
	}
}
YCMD:renters(playerid, params[], help) {
	if(help) {
		SendClientMessage(playerid, X11_WHITE, "Set the rent price for a house");
		return 1;
	}
	new house = getStandingHouse(playerid);
	if(house == -1) {
		SendClientMessage(playerid, X11_TOMATO_2, "You must be standing near a house");
		return 1;
	}
	if(Houses[house][EHouseOwnerSQLID] != GetPVarInt(playerid, "CharID")) {
		SendClientMessage(playerid, X11_TOMATO_2, "This is not your house!");
		return 1;
	}
	format(query, sizeof(query), "SELECT `username`,`id` FROM `characters` WHERE `renthouse` = %d",Houses[house][EHouseSQLID]);
	mysql_function_query(g_mysql_handle, query, true, "OnCheckRenters", "dd",playerid, house);
	return 1;
}
forward OnCheckRenters(playerid, house);
public OnCheckRenters(playerid, house) {
	new rows, fields;
	cache_get_data(rows, fields);
	new msg[128];
	new id_string[128];
	new charid;
	SendClientMessage(playerid, X11_WHITE, "*** Renters ***");
	for(new i=0;i<rows;i++) {		
	
		cache_get_row(i, 1, id_string);
		charid = strval(id_string);
		
		cache_get_row(i, 0, id_string);
		format(msg, sizeof(msg), "* %s ID: %d",id_string,charid);
		new id = findCharBySQLID(charid);
		SendClientMessage(playerid, id!=INVALID_PLAYER_ID?X11_TOMATO_2:COLOR_LIGHTBLUE, msg);
	}
	SendClientMessage(playerid, X11_WHITE, "Do /evict [id] to evict someone");
	SendClientMessage(playerid, X11_WHITE, "If the players name is red, it means they are online");
	SendClientMessage(playerid, X11_WHITE, "Do /evictall to evict everyone.");
	return 1;
}
YCMD:evict(playerid, params[], help) {
	new charid;
	if(help) {
		SendClientMessage(playerid, X11_WHITE, "Evict someone from your house");
		return 1;
	}
	new house = getStandingHouse(playerid);
	if(house == -1) {
		SendClientMessage(playerid, X11_TOMATO_2, "You must be standing near a house");
		return 1;
	}
	if(Houses[house][EHouseOwnerSQLID] != GetPVarInt(playerid, "CharID")) {
		SendClientMessage(playerid, X11_TOMATO_2, "This is not your house!");
		return 1;
	}
	if(!sscanf(params,"d",charid)) {
		if(charid < 1) {
			SendClientMessage(playerid, X11_TOMATO_2, "Invalid Character ID!");
			return 1;
		}
		new p = findCharBySQLID(charid);
		if(p == INVALID_PLAYER_ID) {
			format(query, sizeof(query), "UPDATE `characters` SET `renthouse` = -1 WHERE `renthouse` = %d AND `id` = %d",Houses[house][EHouseSQLID],charid);
			mysql_function_query(g_mysql_handle, query, true, "OnRemoveRenter", "dd",playerid, house);
		} else {
			SendClientMessage(playerid, X11_TOMATO_2, "* Player Evicted!");
			SetPVarInt(p, "Rent", 0);
			SendClientMessage(p, COLOR_LIGHTGREEN, "* You have been evicted from your house");
		}
	} else {
		SendClientMessage(playerid, X11_WHITE, "USAGE: /evict [charid]");
	}
	return 1;
}
YCMD:evictall(playerid, params[], help) {
	if(help) {
		SendClientMessage(playerid, X11_WHITE, "Evict someone from your house");
		return 1;
	}
	new house = getStandingHouse(playerid);
	if(house == -1) {
		SendClientMessage(playerid, X11_TOMATO_2, "You must be standing near a house");
		return 1;
	}
	if(Houses[house][EHouseOwnerSQLID] != GetPVarInt(playerid, "CharID")) {
		SendClientMessage(playerid, X11_TOMATO_2, "This is not your house!");
		return 1;
	}
	foreach(Player, i) {
		if(IsPlayerConnectEx(i)) {
			if(GetPVarInt(i, "Rent") == Houses[house][EHouseSQLID]) {
				SetPVarInt(i, "Rent", 0);
				SendClientMessage(i, COLOR_LIGHTGREEN, "* You have been evicted from your house");
			}
		}
	}
	format(query, sizeof(query), "UPDATE `characters` SET `renthouse` = -1 WHERE `renthouse` = %d",Houses[house][EHouseSQLID]);
	mysql_function_query(g_mysql_handle, query, true, "EmptyCallback","");
	SendClientMessage(playerid, COLOR_LIGHTGREEN, "* All players have been evicted!");
	return 1;
}
forward OnRemoveRenter(playerid, house);
public OnRemoveRenter(playerid, house) {
	new numrows = mysql_affected_rows();
	if(numrows == 0) {
		SendClientMessage(playerid, X11_TOMATO_2, "* This person is not renting your house!");
	} else {
		SendClientMessage(playerid, COLOR_LIGHTGREEN, "* Renter Removed!");
	}
}
YCMD:setrent(playerid, params[], help) {
	if(help) {
		SendClientMessage(playerid, X11_WHITE, "Set the rent price for a house");
		return 1;
	}
	new house = getStandingHouse(playerid);
	if(house == -1) {
		SendClientMessage(playerid, X11_TOMATO_2, "You must be standing near a house");
		return 1;
	}
	if(Houses[house][EHouseOwnerSQLID] != GetPVarInt(playerid, "CharID")) {
		SendClientMessage(playerid, X11_TOMATO_2, "This is not your house!");
		return 1;
	}
	new price;
	if(!sscanf(params, "d", price)) {
		if(price < 0 || price > 5000) {
			SendClientMessage(playerid, X11_TOMATO_2, "Invalid Amount!");
			return 1;
		}
		setHouseRent(house, price);
		SendClientMessage(playerid, COLOR_LIGHTGREEN, "* Rent price updated!");
	} else {
		SendClientMessage(playerid, X11_WHITE, "USAGE: /setrent [price]");
		SendClientMessage(playerid, X11_WHITE, "A rent price of 0 sets the house to be not rentable");
	}
	return 1;
}
getRentPrice(playerid) {
	new r = GetPVarInt(playerid, "Rent");
	if(r != 0) {
		new h = houseIDFromSQLID®;
		if(h != -1) {
			return Houses[h][EHouseRentPrice];
		}
	}
	return 0;
}
YCMD:rent(playerid, params[], help) {
	if(help) {
		SendClientMessage(playerid, X11_WHITE, "Rent a house");
		return 1;
	}
	new house = getStandingHouse(playerid);
	if(house == -1) {
		SendClientMessage(playerid, X11_TOMATO_2, "You must be standing near a house");
		return 1;
	}
	if(Houses[house][EHouseOwnerSQLID] == GetPVarInt(playerid, "CharID")) {
		SendClientMessage(playerid, X11_TOMATO_2, "You cannot rent your own house!");
		return 1;
	}
	if(GetPVarInt(playerid, "Rent") != 0) {
		SendClientMessage(playerid, X11_TOMATO_2, "You are already renting a house! Do /unrent!");
		return 1;
	}
	if(Houses[house][EHouseRentPrice] == 0) {
		SendClientMessage(playerid, X11_TOMATO_2, "This house is not for rent!");
		return 1;
	}
	if(GetMoneyEx(playerid) < Houses[house][EHouseRentPrice]) {
		SendClientMessage(playerid, X11_TOMATO_2, "You don't have enough money!");
		return 1;
	}
	GiveMoneyEx(playerid, -Houses[house][EHouseRentPrice]);
	SendClientMessage(playerid, COLOR_LIGHTGREEN, "* Congratulations! You are now a tennant at this house!");
	SetPVarInt(playerid, "Rent", Houses[house][EHouseSQLID]);
	return 1;
}
YCMD:unrent(playerid, params[], help) {
	if(help) {
		SendClientMessage(playerid, X11_WHITE, "Cancel your rent");
		return 1;
	}
	if(GetPVarInt(playerid, "Rent") == 0) {
		SendClientMessage(playerid, X11_TOMATO_2, "You aren't renting a house!");
		return 1;
	}
	SetPVarInt(playerid, "Rent", 0);
	SendClientMessage(playerid, COLOR_LIGHTGREEN, "* Rent cancelled");
	return 1;
}
setHouseRent(houseid, price) {
	new labeltext[128];
	format(query, sizeof(query), "UPDATE `houses` SET `rent` = %d WHERE `id` = %d", price, Houses[houseid][EHouseSQLID]);
	mysql_function_query(g_mysql_handle, query, true, "EmptyCallback", "");		
	DestroyDynamicPickup(Houses[houseid][EHousePickup]);
	Houses[houseid][EHouseRentPrice] = price;
	getHouseTextLabel(houseid, labeltext, sizeof(labeltext));
	UpdateDynamic3DTextLabelText(Houses[houseid][EHouseTextLabel],0x00FF00FF, labeltext);
	Houses[houseid][EHousePickup] = CreateDynamicPickup(Houses[houseid][EHouseOwnerSQLID]>0?1272:1273,16,Houses[houseid][EHouseX], Houses[houseid][EHouseY], Houses[houseid][EHouseZ]);
}
IsHouseLocked(house) {
	return Houses[house][EHouseLocked] == 1;
}
SetHouseStation(house, radio) {
	Houses[house][EHouseRadioIndex] = radio;
	new url[128];
	getRadioURL(Houses[house][EHouseRadioIndex], url, sizeof(url));
	foreach(Player, i) {
		if(IsPlayerConnectEx(i)) {
			if(getStandingExit(i, 150.0) == house) {
				StopAudioStreamForPlayer(i);
				if(radio != -1)
					PlayAudioStreamForPlayer(i, url);
			}
		}
	}
}
getHouseRadio(house) {
	return Houses[house][EHouseRadioIndex];
}

getHouseTax(playerid) {
	new tax;
	for(new i=0;i<sizeof(Houses);i++) {
		if(Houses[i][EHouseOwnerSQLID] == GetPVarInt(playerid, "CharID")) {
			tax += floatround(Houses[i][EHouseValue] * 0.02);
		}
	}
	return tax;
}
houseIDFromSQLID(sqlid) {
	for(new i=0;i<sizeof(Houses);i++) {
		if(Houses[i][EHouseSQLID] == sqlid) {
			return i;
		}
	}
	return -1;
}
getHouseSQLID(house) {
	return Houses[house][EHouseSQLID];
}
sellInactiveHouses() {
	mysql_function_query(g_mysql_handle, "SELECT `houses`.`id` FROM `houses` INNER JOIN `characters` ON `houses`.`owner` = `characters`.`id`  INNER JOIN `accounts` ON `characters`.`accountid` = `accounts`.`id` WHERE `houses`.`owner` != 0 AND `accounts`.`lastlogin` < DATE_SUB(CURDATE(),INTERVAL 4 WEEK)", true, "OnCheckInactiveHouses", "");	
	
	//check for houses owned by non-existant characters
	mysql_function_query(g_mysql_handle, "SELECT `h`.`id` FROM `houses`  AS `h` LEFT JOIN `characters` AS `c` ON `c`.`id` = `h`.`owner` WHERE `c`.`username` IS NULL AND `h`.`owner` != 0", true, "OnCheckInactiveHouses", "");	
}
forward OnCheckInactiveHouses();
public OnCheckInactiveHouses() {
	new rows, fields;
	new id, id_string[128];
	cache_get_data(rows, fields);
	for(new i=0;i<rows;i++) {
		cache_get_row(i, 0, id_string);
		id = strval(id_string);
		new hid = houseIDFromSQLID(id);
		if(hid != -1) {
			setHouseOwner(hid, INVALID_PLAYER_ID) ;
		}
	}
}
playerOwnsHouse(houseid, playerid) {
	new charid = GetPVarInt(playerid, "CharID");
	return Houses[houseid][EHouseOwnerSQLID] == charid;
}
getPlayerPropertiesValue(playerid) {
	new value;
	new charid = GetPVarInt(playerid, "CharID");
	for(new i=0;i<sizeof(Houses);i++) {
		if(Houses[i][EHouseOwnerSQLID] == charid) {
			value += Houses[i][EHouseValue];
		}
	}
	return value;
}