CMD:createroom(playerid, params[])
{
	new price, query[128];
	if(PlayerInfo[playerid][user_admin] < 4) return SendClientMessage(playerid, COLOR_RED, "[SERVER]: {FFFFFF}You are not authorized to use that command.");
	if(sscanf(params, "d", price)) return SendClientMessage(playerid, COLOR_RED, "[USAGE]: {FFFFFF}/createroom [price]");
	if(price < 1 || price > 999999999) return SendClientMessage(playerid, COLOR_RED, "[ERROR]: {FFFFFF}From $1 to $999999999.");

	mysql_format(Database, query, sizeof(query), "INSERT IGNORE INTO `rooms` (`RoomPrice`) VALUES ('%i')", price);
	mysql_tquery(Database, query, "OnPlayerRoomCreate", "id", playerid, price);
	return 1;
}

forward OnPlayerRoomCreate(playerid, price);
public OnPlayerRoomCreate(playerid, price)
{
	new string[250], label[250], Float:PlayerPos[3], query[300];
  	GetPlayerPos(playerid, PlayerPos[0], PlayerPos[1], PlayerPos[2]);
	new roomid = RoomInfo[roomid][RoomID] = cache_insert_id();

	RoomInfo[roomid][RoomExteriorX] = PlayerPos[0];
	RoomInfo[roomid][RoomExteriorY] = PlayerPos[1];
	RoomInfo[roomid][RoomExteriorZ] = PlayerPos[2];
	RoomInfo[roomid][RoomOwned] = 0;

	format(label, sizeof(label), "This room is for sale!\nRoomID [%d]\nRoom Price: [$%d]\nRoom Owner: N/A.\nUse (/roombuy) to buy it.", roomid, price);
	Create3DTextLabel(label, 0xC09900FF, PlayerPos[0], PlayerPos[1], PlayerPos[2], 3.0, 2, 0);

	format(string, sizeof(string), "RoomID [%d] has been successfully created and is available for $%d. Players are now able to buy it.", roomid, price);
	SendClientMessage(playerid, COLOR_ORANGE, string);

	format(string, sizeof(string), "%s (ID: %d) has created RoomID [%d] for $%d.", GetName(playerid), playerid, roomid, price);
	SendAdminMessage(2, string);

	mysql_format(Database, query, sizeof(query), "UPDATE `rooms` SET `RoomExteriorX` = '%f', `RoomExteriorY` = '%f', `RoomExteriorZ` = '%f' WHERE `RoomID` = '%i'", RoomInfo[roomid][RoomExteriorX], RoomInfo[roomid][RoomExteriorY], RoomInfo[roomid][RoomExteriorY], roomid);
	mysql_query(Database, query);
	return 1;
}