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);
}
}
Scryde banned our whole clan after they scam us with epics. They fked up abundance boxes drop, instead of 30 days epics we got real epics, then they took them away and banned us when we complained 😄
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);
}
}
Link to comment
Share on other sites
0 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.