/// <summary>
/// Add a player to the guild players dictionary list
/// </summary>
/// <param name="player">Player to add</param>
public static void AddPlayerToAllGuildPlayersList(GamePlayer player)
{
if (m_guildXAllMembers.ContainsKey(player.GuildID))
{
if (!m_guildXAllMembers[player.GuildID].ContainsKey(player.InternalID))
{
Dictionary <string, GuildMemberDisplay> guildMemberList = m_guildXAllMembers[player.GuildID];
GuildMemberDisplay member = new GuildMemberDisplay(player.InternalID,
player.Name,
player.Level.ToString(),
player.CharacterClass.ID.ToString(),
player.GuildRank.RankLevel.ToString(),
player.Group != null ? player.Group.MemberCount.ToString() : "1",
player.CurrentZone.Description,
player.GuildNote);
guildMemberList.Add(player.InternalID, member);
}
}
}
/// <summary>
/// Add a player to the guild players dictionary list
/// </summary>
/// <param name="player">Player to add</param>
public static void AddPlayerToAllGuildPlayersList(GamePlayer player)
{
if (m_guildXAllMembers.ContainsKey(player.GuildID))
{
if (!m_guildXAllMembers[player.GuildID].ContainsKey(player.InternalID))
{
Dictionary<string, GuildMemberDisplay> guildMemberList = m_guildXAllMembers[player.GuildID];
GuildMemberDisplay member = new GuildMemberDisplay(player.InternalID,
player.Name,
player.Level.ToString(),
player.CharacterClass.ID.ToString(),
player.GuildRank.RankLevel.ToString(),
player.Group != null ? player.Group.MemberCount.ToString() : "1",
player.CurrentZone.Description,
player.GuildNote);
guildMemberList.Add(player.InternalID, member);
}
}
}
/// <summary>
/// Load all guilds and alliances from the database
/// </summary>
public static bool LoadAllGuilds()
{
lock (m_guilds.SyncRoot)
{
m_guilds.Clear(); //clear guild list before loading!
}
m_lastID = 0;
//load guilds
var guildObjs = GameServer.Database.SelectAllObjects <DBGuild>();
foreach (var obj in guildObjs)
{
var myguild = new Guild(obj);
if (obj.Ranks == null ||
obj.Ranks.Length < 10 ||
obj.Ranks[0] == null ||
obj.Ranks[1] == null ||
obj.Ranks[2] == null ||
obj.Ranks[3] == null ||
obj.Ranks[4] == null ||
obj.Ranks[5] == null ||
obj.Ranks[6] == null ||
obj.Ranks[7] == null ||
obj.Ranks[8] == null ||
obj.Ranks[9] == null)
{
log.ErrorFormat("GuildMgr: Ranks missing for {0}, creating new ones!", myguild.Name);
RepairRanks(myguild);
// now reload the guild to fix the relations
myguild = new Guild(DOLDB <DBGuild> .SelectObjects(DB.Column(nameof(DBGuild.GuildID)).IsEqualTo(obj.GuildID)).FirstOrDefault());
}
AddGuild(myguild);
var guildCharacters = DOLDB <DOLCharacters> .SelectObjects(DB.Column(nameof(DOLCharacters.GuildID)).IsEqualTo(myguild.GuildID));
var tempList = new Dictionary <string, GuildMemberDisplay>(guildCharacters.Count);
foreach (DOLCharacters ch in guildCharacters)
{
var member = new GuildMemberDisplay(ch.ObjectId,
ch.Name,
ch.Level.ToString(),
ch.Class.ToString(),
ch.GuildRank.ToString(),
"0",
ch.LastPlayed.ToShortDateString(),
ch.GuildNote);
tempList.Add(ch.ObjectId, member);
}
m_guildXAllMembers.Add(myguild.GuildID, tempList);
}
//load alliances
var allianceObjs = GameServer.Database.SelectAllObjects <DBAlliance>();
foreach (DBAlliance dball in allianceObjs)
{
var myalliance = new Alliance();
myalliance.LoadFromDatabase(dball);
if (dball != null && dball.DBguilds != null)
{
foreach (DBGuild mydbgui in dball.DBguilds)
{
var gui = GetGuildByName(mydbgui.GuildName);
myalliance.Guilds.Add(gui);
gui.alliance = myalliance;
}
}
}
return(true);
}
/// <summary>
/// Load all guilds and alliances from the database
/// </summary>
public static bool LoadAllGuilds()
{
lock (m_guilds.SyncRoot)
{
m_guilds.Clear(); //clear guild list before loading!
}
m_lastID = 0;
//load guilds
var guildObjs = GameServer.Database.SelectAllObjects<DBGuild>();
foreach (var obj in guildObjs)
{
var myguild = new Guild(obj);
if (obj.Ranks == null ||
obj.Ranks.Length < 10 ||
obj.Ranks[0] == null ||
obj.Ranks[1] == null ||
obj.Ranks[2] == null ||
obj.Ranks[3] == null ||
obj.Ranks[4] == null ||
obj.Ranks[5] == null ||
obj.Ranks[6] == null ||
obj.Ranks[7] == null ||
obj.Ranks[8] == null ||
obj.Ranks[9] == null)
{
log.ErrorFormat("GuildMgr: Ranks missing for {0}, creating new ones!", myguild.Name);
RepairRanks(myguild);
// now reload the guild to fix the relations
myguild = new Guild(GameServer.Database.SelectObject<DBGuild>("GuildID = '" + obj.GuildID + "'"));
}
AddGuild(myguild);
var guildCharacters = GameServer.Database.SelectObjects<DOLCharacters>(string.Format("GuildID = '" + GameServer.Database.Escape(myguild.GuildID) + "'"));
var tempList = new Dictionary<string, GuildMemberDisplay>(guildCharacters.Count);
foreach (DOLCharacters ch in guildCharacters)
{
var member = new GuildMemberDisplay(ch.ObjectId,
ch.Name,
ch.Level.ToString(),
ch.Class.ToString(),
ch.GuildRank.ToString(),
"0",
ch.LastPlayed.ToShortDateString(),
ch.GuildNote);
tempList.Add(ch.ObjectId, member);
}
m_guildXAllMembers.Add(myguild.GuildID, tempList);
}
//load alliances
var allianceObjs = GameServer.Database.SelectAllObjects<DBAlliance>();
foreach (DBAlliance dball in allianceObjs)
{
var myalliance = new Alliance();
myalliance.LoadFromDatabase(dball);
if (dball != null && dball.DBguilds != null)
{
foreach (DBGuild mydbgui in dball.DBguilds)
{
var gui = GetGuildByName(mydbgui.GuildName);
myalliance.Guilds.Add(gui);
gui.alliance = myalliance;
}
}
}
return true;
}
