| Setokaiba |
01-10-2013 05:35 PM |
NPC TOP 10 Personagens PK PVP e Level
Descrição: Esse código trata-se basicamente de um script PHP, para exibir status num NPC:
Top 10 PvP
Top 10 PK
Top 10 Level
Insira o código em net.sf.l2j.gameserver.model.actor.instance e dê o nome de L2StatManagerInstance.java
É necessário criar um NPC do tipo L2StatManager
Código:
/* This program is free software: you can redistribute it and/or modify it under
* the terms of the GNU General Public License as published by the Free Software
* Foundation, either version 3 of the License, or (at your option) any later
* version.
*
* This program is distributed in the hope that it will be useful, but WITHOUT
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
* FOR A PARTICULAR PURPOSE. See the GNU General Public License for more
* details.
*
* You should have received a copy of the GNU General Public License along with
* this program. If not, see <http://www.gnu.org/licenses/>.
*/
package net.sf.l2j.gameserver.model.actor.instance;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javolution.text.TextBuilder;
import net.sf.l2j.L2DatabaseFactory;
import net.sf.l2j.gameserver.network.serverpackets.NpcHtmlMessage;
import net.sf.l2j.gameserver.templates.chars.L2NpcTemplate;
/**
* Stat Manager
*
* @author Intrepid
*/
public class L2StatManagerInstance extends L2FolkInstance
{
public L2StatManagerInstance(int objectId, L2NpcTemplate template)
{
super(objectId, template);
}
@Override
public void onBypassFeedback(L2PcInstance player, String command)
{
if (command.startsWith("TopPvp"))
{
java.sql.Connection con = null;
try
{
con = L2DatabaseFactory.getInstance().getConnection();
PreparedStatement statement;
statement = con.prepareStatement("SELECT char_name,pvpkills FROM characters where accesslevel = 0 order by pvpkills DESC LIMIT 10;");
ResultSet rset = statement.executeQuery();
while(rset.next())
{
NpcHtmlMessage html = new NpcHtmlMessage(getObjectId());
TextBuilder sb = new TextBuilder();
sb.append ("Character: "+rset.getString("char_name")+" ("+rset.getInt("pvpkills")+" kills");
html.setHtml(sb.toString());
player.sendPacket(html);
}
rset.close();
statement.close();
con.close();
}
catch (Exception e)
{
e.printStackTrace();
}
}
if (command.startsWith("TopPk"))
{
java.sql.Connection con = null;
try
{
con = L2DatabaseFactory.getInstance().getConnection();
PreparedStatement statement;
statement = con.prepareStatement("SELECT char_name,pkkills FROM characters where accesslevel = 0 order by pkkills DESC LIMIT 10;");
ResultSet rset = statement.executeQuery();
while(rset.next())
{
NpcHtmlMessage html = new NpcHtmlMessage(getObjectId());
TextBuilder sb = new TextBuilder();
sb.append ("Character: "+rset.getString("char_name")+" ("+rset.getInt("pkkills")+" kills");
html.setHtml(sb.toString());
player.sendPacket(html);
}
rset.close();
statement.close();
con.close();
}
catch (Exception e)
{
e.printStackTrace();
}
}
if (command.startsWith("TopLvl"))
{
java.sql.Connection con = null;
try
{
con = L2DatabaseFactory.getInstance().getConnection();
PreparedStatement statement;
statement = con.prepareStatement("SELECT char_name,level FROM characters where accesslevel = 0 order by level DESC LIMIT 10;");
ResultSet rset = statement.executeQuery();
while(rset.next())
{
NpcHtmlMessage html = new NpcHtmlMessage(getObjectId());
TextBuilder sb = new TextBuilder();
sb.append ("Character: "+rset.getString("char_name")+" ("+rset.getInt("level")+" level");
html.setHtml(sb.toString());
player.sendPacket(html);
}
rset.close();
statement.close();
con.close();
}
catch (Exception e)
{
e.printStackTrace();
}
}
}
}
Coded by Intrepid |
