This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..
Question
l2jkain
Hello, I'm trying to put the top pvp to be announced when entering however my code only announces the players that have pvp.
private static void announceTopPvp(Player activeChar)
{
String name = null;
try (Connection con = L2DatabaseFactory.getInstance().getConnection())
{
PreparedStatement statement = con.prepareStatement("SELECT char_name, pvpkills FROM characters WHERE accesslevel=0 ORDER BY pvpkills DESC LIMIT 1");
ResultSet rset = statement.executeQuery();
while (rset.next())
{
int pvpKills = rset.getInt("pvpkills");
name = rset.getString("char_name");
if (activeChar.getName().equals(name))
Broadcast.announceToOnlinePlayers(name +" Top PVP Is Now Online with " + pvpKills+ ".");
}
rset.close();
statement.close();
}
catch (Exception e)
{
_log.log(Level.WARNING,"Erro Top Player Pvp!",e);
}
}
0 answers to this question
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now