public int Level() { using (var dbx = new Database()) { var id = dbx.GetGuildId(Guild); return dbx.GetGuildLevel(id); } }
public int Level() { using (var db = new Database()) { int id = db.GetGuildId(this.Guild); return db.GetGuildLevel(id); } }
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 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 void CreateGuild(RealmTime t, CreateGuildPacket pkt) { bool GuildsActive = true; if (GuildsActive == false) { psr.SendPacket(new CreateGuildResultPacket() { Success = false, ResultMessage = "Guilds currently disabled!" }); return; } else { try { string name = pkt.Name.ToString(); if (psr.Account.Stats.Fame >= 1000 || Guild != "") { if (name != "") { if (new Database().GetGuild(name) != null) { psr.SendPacket(new CreateGuildResultPacket() { Success = false, ResultMessage = "Guild already exists!" }); return; } using (Database db1 = new Database()) { try { if (Guild != "") { string oldname = psr.Account.Guild.Name; Guild g = db1.ChangeGuild(psr.Account, db1.GetGuildId(psr.Account.Guild.Name), 0, true); psr.Account.Guild.Name = g.Name; psr.Account.Guild.Rank = 0; Guild = g.Name; GuildRank = 0; UpdateCount++; psr.SendPacket(new NotificationPacket() { Text = "Left guild " + oldname, Color = new ARGB(0xFF008800), ObjectId = Id }); psr.SendPacket(new CreateGuildResultPacket() { Success = true }); foreach (var i in RealmManager.Worlds) { if (i.Key != 0) { foreach (var e in i.Value.Players) { if (e.Value.Client.Account.Guild.Name == oldname) { e.Value.Client.SendPacket(new TextPacket() { BubbleTime = 0, Stars = -1, Name = "", Recipient = "*Guild*", Text = psr.Account.Name + " has left the guild!" }); } } } } return; } else { if (pkt.Name != "") { Guild g = db1.CreateGuild(psr.Account, pkt.Name); psr.Account.Guild.Name = g.Name; psr.Account.Guild.Rank = g.Rank; Guild = g.Name; GuildRank = g.Rank; psr.SendPacket(new NotificationPacket() { Text = "Created guild " + g.Name, Color = new ARGB(0xFF008800), ObjectId = Id }); psr.SendPacket(new CreateGuildResultPacket() { Success = true, ResultMessage = "Success!" }); CurrentFame = psr.Account.Stats.Fame = psr.Database.UpdateFame(psr.Account, -1000); UpdateCount++; return; } else { psr.SendPacket(new CreateGuildResultPacket() { Success = false, ResultMessage = "Guild name cannot be blank!" }); return; } } } catch (Exception e) { psr.SendPacket(new CreateGuildResultPacket() { Success = false, ResultMessage = e.Message }); return; } } } else { psr.SendPacket(new CreateGuildResultPacket() { Success = false, ResultMessage = "Name cannot be empty!" }); } } else { psr.SendPacket(new CreateGuildResultPacket() { Success = false, ResultMessage = "Not enough fame!" }); } } catch (Exception) { Console.WriteLine("Error at line 755 of Player.cs"); psr.SendPacket(new TextPacket() { Name = "", Stars = -1, BubbleTime = 0, Text = "Error creating guild!" }); } } }
public int Level(Database db) { return db.GetGuildLevel(db.GetGuildId(Guild)); }