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!" }); } } } }