private void Load()
{
DataTable AcademyData = null;
DataTable MemberData = null;
using (var DBClient = Program.DatabaseManager.GetClient())
{
AcademyData = DBClient.ReadDataTable("SELECT * FROM GuildAcademy WHERE GuildID = " + Guild.ID + "");
MemberData =
DBClient.ReadDataTable("SELECT * FROM GuildAcademyMembers WHERE GuildID = " + Guild.ID + "");
}
foreach (DataRow row in AcademyData.Rows)
{
//load academy info
Message = row["Message"].ToString();
Points = GetDataTypes.GetUshort(row["Points"]);
}
//members
foreach (DataRow MemberRow in MemberData.Rows)
{
WorldCharacter character;
if (!CharacterManager.Instance.GetCharacterByID(Convert.ToInt32(MemberRow["CharID"]), out character))
{
continue; // maybe deleted
}
var member = new GuildAcademyMember(this, character, MemberRow);
Members.Add(member);
}
}
public void Broadcast(Packet Packet, GuildAcademyMember Exclude = null)
{
lock (Guild.ThreadLocker)
{
foreach (var member in Members)
{
if (Exclude != null &&
member == Exclude)
{
continue;
}
if (member.Character.IsOnline)
{
try
{
member.Character.Client.SendPacket(Packet);
}
catch (Exception)
{
}
}
}
}
}
public void RemoveMember(GuildAcademyMember Member)
{
lock (Guild.ThreadLocker)
{
//remove from db
using (var con = Program.DatabaseManager.GetClient().GetConnection())
{
using (var cmd = con.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GuildAcademyMember_Remove";
cmd.Parameters.Add(new MySqlParameter("@pGuildID", Guild.ID));
cmd.Parameters.Add(new MySqlParameter("@pCharacterID", Member.Character.ID));
cmd.ExecuteNonQuery();
}
}
//remove from list
Members.Remove(Member);
//clean character
Member.Character.Guild = null;
Member.Character.GuildAcademy = null;
Member.Character.GuildAcademyMember = null;
//send packets
using (var packet = new Packet(SH38Type.LeaveAcademyResponse))
{
packet.WriteUShort((ushort)GuildAcademyResponse.LeaveSuccess);
Member.Character.Client.SendPacket(packet);
}
using (var packet = new Packet(SH38Type.AcademyMemberLeft))
{
packet.WriteString(Member.Character.Character.Name, 16);
Broadcast(packet);
Guild.Broadcast(packet);
}
//send packet to zones
using (var packet = new InterPacket(InterHeader.ZoneAcademyMemberLeft))
{
packet.WriteInt(Guild.ID);
packet.WriteInt(Member.Character.ID);
ZoneManager.Broadcast(packet);
}
//clean up
Member.Dispose();
}
}
public void AddMember(WorldCharacter Character, GuildAcademyRank Rank)
{
if (Character.Character.CharLevel < 10 ||
Character.Character.CharLevel > 60)
{
return;
}
if (Character.IsInGuild ||
Character.IsInGuildAcademy)
{
Handler38.SendAcademyResponse(Character.Client, Guild.Name, GuildAcademyResponse.AlreadyInAcademy);
return;
}
lock (Guild.ThreadLocker)
{
if (Members.Count >= MaxMembers)
{
Handler38.SendAcademyResponse(Character.Client, Guild.Name, GuildAcademyResponse.AcademyFull);
return;
}
var registerDate = Program.CurrentTime;
//add to sql
using (var con = Program.DatabaseManager.GetClient().GetConnection())
{
using (var cmd = con.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GuildAcademyMember_Create";
cmd.Parameters.Add(new MySqlParameter("@pGuildID", Guild.ID));
cmd.Parameters.Add(new MySqlParameter("@pCharacterID", Character.ID));
cmd.Parameters.Add(new MySqlParameter("@pRegisterDate", registerDate));
cmd.Parameters.Add(new MySqlParameter("@pRank", (byte)Rank));
switch (Convert.ToInt32(cmd.ExecuteScalar()))
{
case 0:
var member = new GuildAcademyMember(this, Character, registerDate, Rank);
//Add to list
Members.Add(member);
//Update character
Character.Guild = Guild;
Character.GuildAcademy = this;
Character.GuildAcademyMember = member;
//send packets to client
Handler38.SendAcademyResponse(Character.Client, Guild.Name,
GuildAcademyResponse.JoinSuccess);
using (var packet = new Packet(SH4Type.CharacterGuildacademyinfo))
{
WriteInfo(packet);
Character.Client.SendPacket(packet);
}
member.BroadcastGuildName();
using (var packet = new Packet(SH38Type.AcademyMemberJoined))
{
member.WriteInfo(packet);
Broadcast(packet);
Guild.Broadcast(packet);
}
//send packet to zones
using (var packet = new InterPacket(InterHeader.ZoneAcademyMemberJoined))
{
packet.WriteInt(Guild.ID);
packet.WriteInt(Character.ID);
packet.WriteDateTime(registerDate);
ZoneManager.Broadcast(packet);
}
break;
case -1:
Handler38.SendAcademyResponse(Character.Client, Guild.Name,
GuildAcademyResponse.AlreadyInAcademy);
return;
case -2:
default:
Handler38.SendAcademyResponse(Character.Client, Guild.Name,
GuildAcademyResponse.DatabaseError);
return;
}
}
}
}
}
