void GuildFinderMgr::SetGuildSettings(uint32 guildGuid, LFGuildSettings const& settings) { _guildSettings[guildGuid] = settings; SQLTransaction trans = CharacterDatabase.BeginTransaction(); PreparedStatement* stmt = CharacterDatabase.GetPreparedStatement(CHAR_REP_GUILD_FINDER_GUILD_SETTINGS); stmt->setUInt32(0, settings.GetGUID()); stmt->setUInt8(1, settings.GetAvailability()); stmt->setUInt8(2, settings.GetClassRoles()); stmt->setUInt8(3, settings.GetInterests()); stmt->setUInt8(4, settings.GetLevel()); stmt->setUInt8(5, settings.IsListed()); stmt->setString(6, settings.GetComment()); trans->Append(stmt); CharacterDatabase.CommitTransaction(trans); }
void GuildFinderMgr::SetGuildSettings(uint32 guildGuid, LFGuildSettings const& settings) { _guildSettings[guildGuid] = settings; std::string comment = settings.GetComment(); CharacterDatabase.escape_string(comment); CharacterDatabase.PExecute("REPLACE INTO guild_finder_guild_settings (guildId, availability, classRoles, interests, level, listed, comment) VALUES('%u', '%u', '%u', '%u', '%u', '%u', '%s')", settings.GetGUID(), settings.GetAvailability(), settings.GetClassRoles(), settings.GetInterests(), settings.GetLevel(), settings.IsListed(), comment.c_str()); }