public static void CreateGuildRequest(World.Network.WorldClient client, string packet)
{
string[] data = packet.Substring(2).Split('|');
//Guild creator request pattern : gC8|16777215|8|8796216|Nightteam
int backArtID = int.Parse(data[0]);
int backColor = int.Parse(data[1]);
int frontArtID = int.Parse(data[2]);
int frontColor = int.Parse(data[3]);
Game.Guilds.GuildEmblem emblem = new Game.Guilds.GuildEmblem(backArtID, backColor, frontArtID, frontColor);
string guildName = data[4];
if (!Helper.GuildHelper.ExistGuild(guildName.ToLower()))
{
Game.Guilds.Guild guild = new Game.Guilds.Guild(1, guildName, emblem);
guild.AddMember(client);
client.Action.GuildMember.Rank = Game.Guilds.GuildRank.Leader;
client.Action.GuildMember.AllowFullRight();
}
else // Guild already exist
{
client.Action.SystemMessage("Ce nom de guilde existe deja !");
client.Send("gV");
}
client.Send("gV");
}
public static void CreateGuildRequest(World.Network.WorldClient client, string packet)
{
string[] data = packet.Substring(2).Split('|');
//Guild creator request pattern : gC8|16777215|8|8796216|Nightteam
int backArtID = int.Parse(data[0]);
int backColor = int.Parse(data[1]);
int frontArtID = int.Parse(data[2]);
int frontColor = int.Parse(data[3]);
Game.Guilds.GuildEmblem emblem = new Game.Guilds.GuildEmblem(backArtID, backColor, frontArtID, frontColor);
string guildName = data[4];
if (!Helper.GuildHelper.ExistGuild(guildName.ToLower()))
{
Game.Guilds.Guild guild = new Game.Guilds.Guild(1, guildName, emblem);
guild.AddMember(client);
client.Action.GuildMember.Rank = Game.Guilds.GuildRank.Leader;
client.Action.GuildMember.AllowFullRight();
}
else // Guild already exist
{
client.Action.SystemMessage("Ce nom de guilde existe deja !");
client.Send("gV");
}
client.Send("gV");
}
public static void LoadGuilds()
{
lock (DatabaseProvider.Locker)
{
var sqlText = "SELECT * FROM guilds";
var sqlCommand = new MySqlCommand(sqlText, DatabaseProvider.Connection);
var sqlResult = sqlCommand.ExecuteReader();
while (sqlResult.Read())
{
var guild = new Game.Guilds.Guild
{
ID = sqlResult.GetInt32("ID"),
Name = sqlResult.GetString("Name"),
Level = sqlResult.GetInt32("Level"),
Exp = sqlResult.GetInt64("Exp"),
IsNewGuild = false,
};
guild.ParseEmblem(sqlResult.GetString("Emblem"));
guild.ParseSqlMembers(sqlResult.GetString("Members"));
guild.ParseSqlStats(sqlResult.GetString("Stats"));
GuildsList.Add(guild);
}
sqlResult.Close();
}
Utilities.Loggers.Status.Write(string.Format("Loaded '{0}' guilds from the database !", GuildsList.Count));
}
