public static bool GetGuildByID(int ID, out Guild Guild)
{
lock (ThreadLocker)
{
Guild = LoadedGuilds.Find(g => g.ID.Equals(ID));
if (Guild == null)
{
//try to load from db
using (var con = Program.DatabaseManager.GetClient().GetConnection())
{
using (var cmd = con.CreateCommand())
{
cmd.CommandText = "SELECT * FROM Guilds WHERE ID = @pID";
cmd.Parameters.Add(new MySqlParameter("@pID", ID));
using (var reader = cmd.ExecuteReader())
{
if (!reader.Read())
return false;
//create new guild
Guild = new Guild(con, reader);
//add to list
LoadedGuilds.Add(Guild);
}
}
}
}
}
return (Guild != null);
}
public GuildMember(Guild Guild, WorldCharacter Character, GuildRank Rank, ushort Corp)
{
this.Guild = Guild;
this.Character = Character;
this.Rank = Rank;
this.Corp = Corp;
ThreadLocker = new object();
}
public static void AddGuildToList(Guild pGuild)
{
LoadedGuilds.Add(pGuild);
}
public static void On_GameClient_CreateGuild(WorldClient Client, Packet Packet)
{
string name, password;
bool allowGuildWar;
if (!Packet.TryReadString(out name, 16)
|| !Packet.TryReadString(out password, 8)
|| !Packet.ReadSkip(4) // unk ?
|| !Packet.TryReadBool(out allowGuildWar))
{
return;
}
GuildCreateResponse response;
if (Client.Character.Character.CharLevel < 20)
{
response = GuildCreateResponse.LevelTooLow;
}
else if (Client.Character.Character.Money < Guild.Price)
{
response = GuildCreateResponse.MoneyTooLow;
}
else
{
//encrypt guild pw
var pwData = Encoding.UTF8.GetBytes(password);
// InterCrypto.Encrypt(ref pwData, 0, pwData.Length);
Guild guild;
//try to create guild
lock (ThreadLocker)
{
int result;
int guildID;
var createTime = Program.CurrentTime;
using (var con = Program.DatabaseManager.GetClient().GetConnection())
{
//insert guild in db
using (var cmd = con.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "Guild_Create";
cmd.Parameters.Add(new MySqlParameter("@pName", name));
cmd.Parameters.Add(new MySqlParameter("@pPassword", pwData));
cmd.Parameters.Add(new MySqlParameter("@pAllowGuildWar", allowGuildWar));
cmd.Parameters.Add(new MySqlParameter("@pCreaterID", Client.Character.ID));
cmd.Parameters.Add(new MySqlParameter("@pCreateTime", createTime));
var idParam = cmd.Parameters.Add(new MySqlParameter("@pID", SqlDbType.Int)
{
Direction = ParameterDirection.Output
});
result = Convert.ToInt32(cmd.ExecuteScalar());
guildID = (int)idParam.Value;
}
switch (result)
{
case -1:
//guild name already exists (ToDo: get response code)
SendGuildCreateResponse(Client, name, password, allowGuildWar, GuildCreateResponse.AlredyExist);
return;
case -2: //database error @ insert guild (ToDo: get response code)
SendGuildCreateResponse(Client, name, password, allowGuildWar, GuildCreateResponse.Failed);
return;
case -3: //database error @ insert guild academy (ToDo: get response code)
SendGuildCreateResponse(Client, name, password, allowGuildWar, GuildCreateResponse.Failed);
return;
case 0:
//create guild
guild = new Guild(con, guildID, name, pwData, allowGuildWar, Client.Character, createTime);
//insert guild master (character will get updated)
guild.AddMember(Client.Character, GuildRank.Master, con, false, false);
//add to loaded guilds
LoadedGuilds.Add(guild);
break;
default:
return;
}
}
}
Client.Character.
//revoke money
Client.Character.ChangeMoney(Client.Character.Character.Money - Guild.Price);
//let character broadcast guild name packet
using (var packet = new Packet(SH29Type.GuildNameResult))
{
packet.WriteInt(guild.ID);
packet.WriteString(guild.Name, 16);
BroadcastManager.Instance.BroadcastInRange(Client.Character, packet, true);
}
//let zone know that a guild has been loaded
using (var packet = new InterPacket(InterHeader.ZONE_GuildCreated))
{
packet.WriteInt(guild.ID);
packet.WriteInt(Client.Character.ID);
ZoneManager.Instance.Broadcast(packet);
}
//set response to success
response = GuildCreateResponse.Success;
}
SendGuildCreateResponse(Client, name, password, allowGuildWar, response);
}