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);
}
}
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
1. Check the L2JMobius Official Forum
The forum sometimes includes links or hints in the specific version threads.
Go to: https://www.l2jmobius.org/
Search the “Live 12.1 Path of Rogue” section for client references.
Some users may post Google Drive or MEGA links with notes like “compatible client here.”
I want to add to a new zonename a orig client H5.
But its not appearing, there have to be a server side addition as well, to call the 516 ID?
Any ideas?
Thx fowardly
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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.