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);
}
