public override void Buy(Player player)
{
if (!player.Guild.IsDefault)
{
if (player.Guild[player.AccountId].Rank >= 30)
{
using (var db = new Database())
{
if (db.GetGuild(db.GetGuildId(player.Guild[player.AccountId].Name)).GuildFame >= Price)
{
var cmd = db.CreateQuery();
cmd.CommandText = "UPDATE guilds SET level=level+1, guildFame=guildFame-@price WHERE name=@guildName";
cmd.Parameters.AddWithValue("@guildName", player.Guild.Name);
cmd.Parameters.AddWithValue("@price", Price);
if (cmd.ExecuteNonQuery() == 1)
{
player.Client.SendPacket(new BuyResultPacket
{
Message = "{\"key\":\"server.sale_succeeds\"}",
Result = -1
});
player.SendInfo("Please leave the Guild Hall, we need some minutes to update the Guild Hall.");
player.Guild.UpdateGuildHall();
}
}
else
{
player.SendHelp("F**K");
player.Client.SendPacket(new BuyResultPacket
{
Message = "{\"key\":\"server.not_enough_fame\"}",
Result = 9
});
}
}
}
else
{
player.Client.SendPacket(new BuyResultPacket
{
Message = "Founder or Leader rank required.",
Result = 0
});
}
}
}
public override void Buy(Player player)
{
using (var dbx = new Database())
{
if (dbx.GetGuild(dbx.GetGuildId(player.Guild)).GuildFame >= Price)
{
dbx.DetractGuildFame(dbx.GetGuildId(player.Guild), Price);
dbx.ChangeGuildLevel(dbx.GetGuildId(player.Guild), nextLevel);
player.Client.SendPacket(new BuyResultPacket
{
Message = "Upgrade successful! Please leave the Guild Hall to have it upgraded",
Result = 0
});
}
else
player.Client.SendPacket(new BuyResultPacket
{
Message = "Not enough Guild Fame!",
Result = 9
});
}
}
public void JoinGuild(RealmTime t, JoinGuildPacket pkt)
{
var db = new Database();
var gStruct = db.GetGuild(pkt.GuildName);
if (psr.Player.Invited == false)
{
SendInfo("You need to be invited to join a guild!");
}
if (gStruct != null)
{
var g = db.ChangeGuild(psr.Account, gStruct.Id, 0, 0, false);
if (g != null)
{
psr.Account.Guild = g;
Guild = g.Name;
GuildRank = g.Rank;
UpdateCount++;
foreach (var p in RealmManager.GuildMembersOf(g.Name))
{
p.Client.SendPacket(new TextPacket()
{
BubbleTime = 0,
Stars = -1,
//Name = "@" + psr.Account.Name + " has joined the guild!"
Name = "",
Recipient = "*Guild*",
Text = psr.Account.Name + " has joined the guild!"
});
}
}
}
}
