public void AddMember(WorldCharacter Character, GuildAcademyRank Rank)
{
if (Character.Character.CharLevel < 10
|| Character.Character.CharLevel > 60)
return;
if (Character.IsInGuild
|| Character.IsInGuildAcademy)
{
Handlers.Handler38.SendAcademyResponse(Character.Client, Guild.Name, GuildAcademyResponse.AlreadyInAcademy);
return;
}
lock (Guild.ThreadLocker)
{
if (Members.Count >= MaxMembers)
{
Handlers.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
Handlers.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.ZONE_AcademyMemberJoined))
{
packet.WriteInt(Guild.ID);
packet.WriteInt(Character.ID);
packet.WriteDateTime(registerDate);
ZoneManager.Instance.Broadcast(packet);
}
break;
case -1:
Handlers.Handler38.SendAcademyResponse(Character.Client, Guild.Name, GuildAcademyResponse.AlreadyInAcademy);
return;
case -2:
default:
Handlers.Handler38.SendAcademyResponse(Character.Client, Guild.Name, GuildAcademyResponse.DatabaseError);
return;
}
}
}
}
}
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.ZONE_AcademyMemberLeft))
{
packet.WriteInt(Guild.ID);
packet.WriteInt(Member.Character.ID);
ZoneManager.Instance.Broadcast(packet);
}
//clean up
Member.Dispose();
}
}
private void Load()
{
DataTable AcademyData = null;
DataTable MemberData = null;
using(DatabaseClient 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)
{
continue;
}
}
}
}
}