bool IOMapSerialize::updateHouses() { Database* db = Database::getInstance(); DBQuery query; House* house = NULL; for(HouseMap::iterator it = Houses::getInstance()->getHouseBegin(); it != Houses::getInstance()->getHouseEnd(); ++it) { if(!(house = it->second)) continue; query << "SELECT `price` FROM `houses` WHERE `id` = " << house->getId() << " AND `world_id` = " << g_config.getNumber(ConfigManager::WORLD_ID) << " LIMIT 1"; if(DBResult* result = db->storeQuery(query.str())) { if((uint32_t)result->getDataInt("price") != house->getPrice()) house->setSyncFlag(House::HOUSE_SYNC_UPDATE); result->free(); query.str(""); query << "UPDATE `houses` SET "; if(house->hasSyncFlag(House::HOUSE_SYNC_NAME)) query << "`name` = " << db->escapeString(house->getName()) << ", "; if(house->hasSyncFlag(House::HOUSE_SYNC_TOWN)) query << "`town` = " << house->getTownId() << ", "; if(house->hasSyncFlag(House::HOUSE_SYNC_SIZE)) query << "`size` = " << house->getSize() << ", "; if(house->hasSyncFlag(House::HOUSE_SYNC_PRICE)) query << "`price` = " << house->getPrice() << ", "; if(house->hasSyncFlag(House::HOUSE_SYNC_RENT)) query << "`rent` = " << house->getRent() << ", "; query << "`doors` = " << house->getDoorsCount() << ", `beds` = " << house->getBedsCount() << ", `tiles` = " << house->getTilesCount(); if(house->hasSyncFlag(House::HOUSE_SYNC_GUILD)) query << ", `guild` = " << house->isGuild(); query << " WHERE `id` = " << house->getId() << " AND `world_id` = " << g_config.getNumber(ConfigManager::WORLD_ID) << db->getUpdateLimiter(); } else { query.str(""); query << "INSERT INTO `houses` (`id`, `world_id`, `owner`, `name`, `town`, `size`, `price`, `rent`, `doors`, `beds`, `tiles`, `guild`) VALUES (" << house->getId() << ", " << g_config.getNumber(ConfigManager::WORLD_ID) << ", 0, " //we need owner for compatibility reasons (field doesn't have a default value) << db->escapeString(house->getName()) << ", " << house->getTownId() << ", " << house->getSize() << ", " << house->getPrice() << ", " << house->getRent() << ", " << house->getDoorsCount() << ", " << house->getBedsCount() << ", " << house->getTilesCount() << ", " << house->isGuild() << ")"; } if(!db->query(query.str())) return false; query.str(""); } return true; }