public GuildTitlePrompt( Mobile from, Mobile target, Guild g )
     : base(from)
 {
     m_Mobile = from;
     m_Target = target;
     m_Guild = g;
 }

 //public static GuildRoster ooj = null;
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!this.IsPostBack)
     {
         if(ooj == null){
             RequestXml.basePath = MapPath("./armory/");
             RequestData.SqlConnectionString = ""; // Omitted for GitHub
             ooj = new Guild("Terenas", "Overlords of Justice");
         }
     }
     //OOJ Roster
     //http://www.wowarmory.com/guild-info.xml?r=Terenas&gn=Overlords+of+Justice&rhtml=n
     BodyText.Text = ooj.roster.ReturnRoster();
     try
     {
         //BodyText.Text = ooj.ReturnRoster();
     }catch
     {
         BodyText.Text = "Roster is currently loading...";
     }
     if (this.IsPostBack)
     {
     }
     else { }
 }

        public override void Deserialize( GenericReader reader )
        {
            base.Deserialize( reader );

            int version = reader.ReadInt();

            switch ( version )
            {
                case 1:
                    {
                        m_Guild = reader.ReadGuild() as Guild;

                        goto case 0;
                    }
                case 0:
                    {
                        break;
                    }
            }

            if ( m_Guild == null )
            {
                this.Delete();
            }
        }

 public GuildAllyPrompt( Mobile leader, Guild target, Guild g )
     : base(leader)
 {
     m_Leader = leader;
     m_Target = target;
     m_Guild = g;
 }

			Guild CreateGuild(CmdTrigger<RealmServerCmdArgs> trigger, string name, CharacterRecord record)
			{
				var guild = new Guild(record, name);

				trigger.Reply("Guild created");

				return guild;
			}

        /// <summary>
        /// Send message to a guild
        /// </summary>
        /// <param name="message">The message</param>
        /// <param name="guild">The guild</param>
        public static void SendMessageToGuild(string message, Guild guild)
        {
            if (guild == null)
                return;

            message = "[Guild] [" + message + "]";
            guild.SendMessageToGuildMembers(message, eChatType.CT_Guild, eChatLoc.CL_ChatWindow);
        }

		public GuildEventLogEntry(Guild guild, GuildEventLogEntryType type, int character1LowId, int character2LowId, int newRankId, DateTime timeStamp)
		{
			GuildId = guild.Id;
			Type = type;
			Character1LowId = character1LowId;
			Character2LowId = character2LowId;
			NewRankId = newRankId;
			TimeStamp = timeStamp;
		}

        public Guild ChangeGuild(Account acc, int guildid, int rank, int fame, bool renounce)
        {
            Guild guild;
            if (renounce)
            {
                guild = new Guild
                {
                    Name = "",
                    Id = 0,
                    Rank = 0,
                    Fame = 0
                };

                MySqlCommand cmd = CreateQuery();
                cmd.CommandText = "UPDATE accounts SET guild=0, guildRank=0, guildFame=0 WHERE [email protected]";
                cmd.Parameters.AddWithValue("@aid", acc.AccountId);
                if (cmd.ExecuteNonQuery() == 0)
                {
                    throw new Exception("Could not change player's guild in the SQL!");
                }

                UpdateGuild(guildid);

                return guild;
            }
            else
            {
                guild = new Guild
                {
                    Id = guildid,
                    Name = GetGuildName(guildid),
                    Rank = rank,
                    Fame = fame
                };
                if (guild.Name == "")
                {
                    throw new Exception("Guild not found!");
                }
                MySqlCommand cmd = CreateQuery();
                cmd.CommandText = "UPDATE accounts SET [email protected], [email protected], [email protected] WHERE [email protected]";
                cmd.Parameters.AddWithValue("@gid", guildid);
                cmd.Parameters.AddWithValue("@gr", rank);
                cmd.Parameters.AddWithValue("@gf", fame);
                cmd.Parameters.AddWithValue("@aid", acc.AccountId);
                if (cmd.ExecuteNonQuery() == 0)
                {
                    throw new Exception("Could not change player's guild in the SQL!");
                }

                UpdateGuild(guildid);

                return guild;
            }
        }

		/// <summary>
		/// Sends GuildInfoNoGuild to creature's client.
		/// </summary>
		/// <param name="creature"></param>
		/// <param name="guild"></param>
		public static void GuildInfoNoGuild(Creature creature, Guild guild)
		{
			var packet = new Packet(Op.GuildInfoNoGuild, creature.EntityId);
			packet.PutLong(guild.Id);
			packet.PutString(guild.Name);
			packet.PutString(guild.LeaderName);
			packet.PutInt(guild.MemberCount);
			packet.PutString(guild.IntroMessage);

			creature.Client.Send(packet);
		}

		/// <summary>
		/// Sends GuildInfoApplied to creature's client.
		/// </summary>
		/// <param name="creature"></param>
		/// <param name="guild"></param>
		public static void GuildInfoApplied(Creature creature, Guild guild)
		{
			// The fields of this packet were guessed, something might be missing.

			var packet = new Packet(Op.GuildInfoApplied, creature.EntityId);
			packet.PutLong(guild.Id);
			packet.PutString(guild.Server);
			packet.PutLong(creature.EntityId);
			packet.PutString(guild.Name);

			creature.Client.Send(packet);
		}

		internal GuildEventLog(Guild guild, bool isNew)
			: this(guild)
		{
			if (!isNew)
			{
				var entries = GuildEventLogEntry.FindAllByProperty("m_GuildId", (int)guild.Id);
				foreach (var entry in entries)
				{
					m_entries.Enqueue(entry);
				}
			}
		}

		/// <summary>
		/// Sends GuildPanel to creature's client.
		/// </summary>
		/// <param name="creature"></param>
		/// <param name="guild"></param>
		public static void GuildPanel(Creature creature, Guild guild)
		{
			var packet = new Packet(Op.GuildPanel, creature.EntityId);
			packet.PutLong(guild.Id);
			packet.PutByte(creature.GuildMember.IsLeader);
			if (creature.GuildMember.IsLeader)
			{
				packet.PutInt(guild.WithdrawMaxAmount);
				packet.PutLong(guild.WithdrawDeadline);
				packet.PutInt(guild.MaxMembers);
			}
			packet.PutByte(0);
			packet.PutByte(0); // 1: Go To Guild Hall,  2: Go To Guild Stone

			creature.Client.Send(packet);
		}

		public GuildMember(CharacterRecord chr, Guild guild, GuildRank rank)
			: this()
		{
			var zoneId = (int)chr.Zone;

			Guild = guild;

			CharacterLowId = (int)chr.EntityLowId;
			_rankId = rank.RankIndex;
			_name = chr.Name;
			_lastLevel = chr.Level;
			_lastLogin = DateTime.Now;
			_lastZoneId = zoneId;
			_class = (int)chr.Class;
			_publicNote = string.Empty;
			_officerNote = string.Empty;
		}

		/// <summary>
		/// Executes the given action for all members of guild that are online.
		/// </summary>
		/// <param name="guild"></param>
		/// <param name="action"></param>
		public static void ForOnlineMembers(Guild guild, Action<User> action)
		{
			var members = guild.GetMembers();
			foreach (var member in members)
			{
				// Applicants aren't full members and shouldn't receive
				// "broadcasts" yet.
				if (member.Rank > GuildMemberRank.Member)
					continue;

				var user = MsgrServer.Instance.UserManager.GetUserByCharacterId(member.CharacterId);
				if (user == null)
					continue;

				action(user);
			}
		}

 private void LoadGuilds()
 {
     MySqlCommand mysqlCmd = new MySqlCommand("SELECT * FROM Guilds", Program.DatabaseManager.GetClient().GetConnection());
     int GuildCount = 0;
     MySqlDataReader GuildReader = mysqlCmd.ExecuteReader();
     {
         for (int i = 0; i < GuildReader.FieldCount; i++)
         {
             while (GuildReader.Read())
             {
                 Guild g = new Guild(Program.DatabaseManager.GetClient().GetConnection(), GuildReader);
                 GuildManager.AddGuildToList(g);
                 GuildCount++;
             }
         }
     }
     GuildReader.Close();
     Log.WriteLine(LogLevel.Info, "Load {0} Guilds", GuildCount);
 }

		protected override void OnSyncGuildMemberAdded(Guild guild, GuildMember member)
		{
			// Only announce new members once they've become actual members,
			// no applicants.
			if (member.Rank > GuildMemberRank.Member)
				return;

			var user = MsgrServer.Instance.UserManager.GetUserByCharacterId(member.CharacterId);
			if (user == null)
			{
				user = MsgrServer.Instance.Database.GetUserByCharacterId(member.CharacterId);
				user.Status = ContactStatus.Offline;
			}

			ForOnlineMembers(guild, memberUser =>
			{
				if (memberUser != user)
					Send.GuildMemberState(memberUser.Client, guild, member, user, user.Status);
			});
		}

    protected void Page_Load(object sender, EventArgs e)
    {
        if (Request["k"] != "L0ngnubby") return;
        RequestData.SqlConnectionString = ""; // Omitted for GitHub

        Guild ooj = new Guild("Terenas", "Overlords of Justice");

        TimeSpan ts = TimeSpan.Zero;
        DateTime lastUpdate = DateTime.Now;
        foreach (ArmoryCharacter c in ooj.roster.members)
        {
            lastUpdate =RequestData.CharacterSheetLastUpdateTime(c.name, c.server);
            ts = DateTime.Now - lastUpdate;
            if (ts > new TimeSpan(2, 0, 0, 0))
            {
                RequestData.AddCharacterSheetToQueue(c.name, c.server, c.armoryUrl);
                Response.Write("*");
            }
            Response.Write(c.server + " " + c.name + " " + lastUpdate.ToShortDateString() + " " + lastUpdate.ToShortTimeString() +"\n");
        }
    }

        public DeclareWarGump( Mobile from, Guild target )
            : base(10, 10)
        {
            m_Mobile = from;

            m_Guild = m_Mobile.Guild as Guild;

            t_Guild = target as Guild;

            Intern( "0" );
            Intern( "0" );

            AddPage( 0 );

            AddBackground( 0, 0, 500, 340, 0x24AE );
            AddBackground( 65, 50, 370, 30, 0x2486 );

            AddHtmlLocalized( 75, 55, 370, 30, 1062979, 0x3C00, false, false );
            AddImage( 410, 45, 0x232C );

            AddHtmlLocalized( 65, 95, 200, 20, 1063009, 0x14AF, false, false );
            AddHtmlLocalized( 65, 120, 400, 20, 1063010, 0x0, false, false );
            AddBackground( 65, 150, 40, 30, 0x2486 );
            AddTextEntryIntern( 68, 154, 25, 20, 0x481, 175, 0 );

            AddHtmlLocalized( 65, 195, 200, 20, 1063011, 0x14AF, false, false );
            AddHtmlLocalized( 65, 220, 400, 20, 1063012, 0x0, false, false );
            AddBackground( 65, 250, 40, 30, 0x2486 );
            AddTextEntryIntern( 68, 254, 25, 20, 0x481, 176, 1 );

            AddBackground( 190, 270, 130, 26, 0x2486 );

            AddButton( 195, 275, 0x845, 0x846, 0, GumpButtonType.Reply, 0 );
            AddHtmlLocalized( 220, 273, 90, 26, 1006045, 0x0, false, false );

            AddBackground( 330, 270, 130, 26, 0x2486 );

            AddButton( 335, 275, 0x845, 0x846, 1, GumpButtonType.Reply, 0 );
            AddHtmlLocalized( 360, 273, 90, 26, 1062989, 0x5000, false, false );
        }

		/// <summary>
		/// 
		/// </summary>
		internal GuildBank(Guild guild, bool isNew)
		{
			Guild = guild;
			BankLog = new GuildBankLog(this);
			if (isNew)
			{
				bankTabs = new[] {
					new GuildBankTab(this)
					{
						BankSlot = 0,
						Icon = "",
						Name = "Slot 0",
						Text = ""
					}
				};
			}
			else
			{
				// load an existing guild bank
				bankTabs = RealmWorldDBMgr.DatabaseProvider.Query<GuildBankTab>().Where(tab => tab.Guild == guild).ToArray(); //.FindAllByProperty("_guildId", (int)guild.Id); //TODO: Check this gets all guild bank tabs as intended
				BankLog.LoadLogs();
			}
		}

		/// <summary>
		/// 
		/// </summary>
		internal GuildBank(Guild guild, bool isNew)
		{
			Guild = guild;
			BankLog = new GuildBankLog(this);
			if (isNew)
			{
				bankTabs = new [] {
					new GuildBankTab(this)
					{
						BankSlot = 0,
						Icon = "",
						Name = "Slot 0",
						Text = ""
					}
				};
			}
			else
			{
				// load an existing guild bank
				bankTabs = GuildBankTab.FindAllByProperty("_guildId", (int)guild.Id);
				BankLog.LoadLogs();
			}
		}