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