public bool AddGuildRank(Guild g, GuildMemberRank gmr) { string SQL = "INSERT INTO guild_ranks " + "(gid, rankprivileges, rankname) " + "VALUES(?gid, ?rankpriv, ?rankname);"; // Are we GM if (gmr.RankName == "GuildMaster") gmr.RankPrivileges = 7; else gmr.RankPrivileges = 0; MySqlCommand cmd = new MySqlCommand(SQL, GuildDAOConnection); cmd.Parameters.AddWithValue("?gid", g.GuildId); cmd.Parameters.AddWithValue("?rankpriv", gmr.RankPrivileges); cmd.Parameters.AddWithValue("?rankname", gmr.RankName); try { cmd.ExecuteNonQuery(); } catch (Exception e) { Log.ErrorException("DAO: Guild Rank Add Error!", e); return false; } return true; }
private void AddNewRank(Guild guild, GuildMemberRank rank) { if(guild == null) return; if (rank.RankName == "Guildmaster") rank.RankPrivileges = 7; guild.GuildRanks.Add(rank); AddHistoryEvent(guild, new HistoryEvent {Args = GuildHistoryStrings.AddNewRank(rank.RankName)}); UpdateGuild(guild); }